Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.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 17316096 kB
MemAvailable 31242712 kB
Buffers 0 kB
Cached 14410936 kB
SwapCached 4876 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-07 01:27:18
DTS_END                         2021-02-07 01:27:18.0680
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/42848
TRN_ID                          232831
ATT_ID                          685
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: 9025.51 23970 1083061
customer order: creation 163.98 374 19677
customer order: refuse 14.46 342 1735
order to supplier: creation 44.20 1341 5304
order to supplier: removal 3.15 114942 378
invoice (draft): creation 43.53 3608 5224
invoice (draft): removal 51.54 803 6185
invoice accept: apply 40.65 19777 4878
invoice accept: cancel 46.15 822 5538
customer reserve: creation 3765.44 195 451853
customer reserve: removal 4563.12 62 547574
realization accept: apply 82.26 200 9871
realization accept: cancel 82.68 107 9922
payment from customer: creation 57.78 130 6933
payment from customer: removal 5.10 79 612
payment to supplier: creation 46.74 154 5609
payment to supplier: removal 3.04 85 365
service: total inventory turnovers 4.49 1238 539
service: total monetary turnovers 6.28 36 754
service: aggregate perf. data 0.88 15167 106
service: refresh index statistics 0.03 319934 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-02-2021 01:29:08 to 07-02-2021 01:29:10.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4625
TEST_TIME 2 4606
TEST_TIME 3 5351
TEST_TIME 4 5469
TEST_TIME 5 6103
TEST_TIME 6 6337
TEST_TIME 7 6300
TEST_TIME 8 6458
TEST_TIME 9 6531
TEST_TIME 10 6655
TEST_TIME 11 6679
TEST_TIME 12 6645
TEST_TIME 13 6648
TEST_TIME 14 7277
TEST_TIME 15 7187
TEST_TIME 16 7285
TEST_TIME 17 7335
TEST_TIME 18 7397
TEST_TIME 19 7585
TEST_TIME 20 8048
TEST_TIME 21 8009
TEST_TIME 22 7956
TEST_TIME 23 8629
TEST_TIME 24 8756
TEST_TIME 25 8824
TEST_TIME 26 9253
TEST_TIME 27 10021
TEST_TIME 28 10317
TEST_TIME 29 10669
TEST_TIME 30 10420
TEST_TIME 31 10465
TEST_TIME 32 10219
TEST_TIME 33 10138
TEST_TIME 34 10101
TEST_TIME 35 10039
TEST_TIME 36 10121
TEST_TIME 37 9859
TEST_TIME 38 9854
TEST_TIME 39 9736
TEST_TIME 40 9535
TEST_TIME 41 9487
TEST_TIME 42 9481
TEST_TIME 43 9377
TEST_TIME 44 9409
TEST_TIME 45 9472
TEST_TIME 46 9359
TEST_TIME 47 9300
TEST_TIME 48 9332
TEST_TIME 49 9311
TEST_TIME 50 9261
TEST_TIME 51 9230
TEST_TIME 52 9171
TEST_TIME 53 9166
TEST_TIME 54 9211
TEST_TIME 55 9226
TEST_TIME 56 9163
TEST_TIME 57 9173
TEST_TIME 58 9289
TEST_TIME 59 9295
TEST_TIME 60 9357
TEST_TIME 61 9401
TEST_TIME 62 9457
TEST_TIME 63 9524
TEST_TIME 64 9429
TEST_TIME 65 9310
TEST_TIME 66 9326
TEST_TIME 67 9220
TEST_TIME 68 9258
TEST_TIME 69 9177
TEST_TIME 70 9100
TEST_TIME 71 9150
TEST_TIME 72 9108
TEST_TIME 73 9043
TEST_TIME 74 9034
TEST_TIME 75 9022
TEST_TIME 76 9093
TEST_TIME 77 9076
TEST_TIME 78 9093
TEST_TIME 79 9132
TEST_TIME 80 9158
TEST_TIME 81 9146
TEST_TIME 82 9138
TEST_TIME 83 9191
TEST_TIME 84 9212
TEST_TIME 85 9232
TEST_TIME 86 9233
TEST_TIME 87 9332
TEST_TIME 88 9319
TEST_TIME 89 9231
TEST_TIME 90 9187
TEST_TIME 91 9139
TEST_TIME 92 9081
TEST_TIME 93 9070
TEST_TIME 94 9086
TEST_TIME 95 9074
TEST_TIME 96 9055
TEST_TIME 97 9039
TEST_TIME 98 9171
TEST_TIME 99 9125
TEST_TIME 100 9190
TEST_TIME 101 9176
TEST_TIME 102 9169
TEST_TIME 103 9175
TEST_TIME 104 9175
TEST_TIME 105 9209
TEST_TIME 106 9169
TEST_TIME 107 9266
TEST_TIME 108 9258
TEST_TIME 109 9271
TEST_TIME 110 9195
TEST_TIME 111 9250
TEST_TIME 112 9201
TEST_TIME 113 9208
TEST_TIME 114 9166
TEST_TIME 115 9143
TEST_TIME 116 9139
TEST_TIME 117 9116
TEST_TIME 118 9058
TEST_TIME 119 9068
TEST_TIME 120 9036

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-02-2021 01:29:12 to 07-02-2021 01:29:15.

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 1499803 1499803 0 0.00 0 24776 6 0 0
doc_list_biud 1499795 1499795 0 0.00 0 50146 29 0 0
sp_add_invoice_to_stock 4983 4878 105 2.10 42 221531 19777 0 105
sp_cancel_adding_invoice 5538 5538 0 0.00 4 81079 823 0 0
sp_cancel_client_order 1735 1735 0 0.00 4 7063 342 0 0
sp_cancel_customer_reserve 547574 547574 0 0.00 1 50147 63 0 0
sp_cancel_pay_from_customer 612 612 0 0.00 3 4460 80 0 0
sp_cancel_pay_to_supplier 365 365 0 0.00 3 3128 85 0 0
sp_cancel_supplier_invoice 6193 6185 8 0.12 2 15724 803 0 8
sp_cancel_supplier_order 378 378 0 0.00 9 1210351 114943 0 0
sp_cancel_write_off 9922 9922 0 0.00 1 9006 107 0 0
sp_client_order 19677 19677 0 0.00 4 24545 375 0 0
sp_customer_reserve 451853 451853 0 0.00 0 47161 195 0 0
sp_fill_shopping_cart 30201 30201 0 0.00 1 28963 41 0 0
sp_fill_shopping_cart_clo_res 451841 451841 0 0.00 0 15524 15 0 0
sp_get_clo_for_invoice 4864 4864 0 0.00 0 25570 352 0 0
sp_kill_cost_storno 16437 16437 0 0.00 0 15658 59 0 0
sp_kill_qstorno_ret_qs2qd 1111633 1111633 0 0.00 0 50144 34 0 0
sp_kill_qty_storno 586067 586067 0 0.00 0 50145 72 0 0
sp_lock_selected_doc 20259 20259 0 0.00 0 9145 6 0 0
sp_make_cost_storno 27277 27277 0 0.00 0 13864 58 0 0
sp_multiply_rows_for_pdistr 27277 27277 0 0.00 0 7289 33 0 0
sp_multiply_rows_for_qdistr 19677 19677 0 0.00 0 10954 166 0 0
sp_pay_from_customer 6933 6933 0 0.00 4 12870 130 0 0
sp_pay_to_supplier 5609 5609 0 0.00 4 14003 155 0 0
sp_payment_common 12542 12542 0 0.00 1 13983 35 0 0
sp_qd_handle_on_cancel_clo 1735 1735 0 0.00 0 7053 303 0 0
sp_qd_handle_on_invoice_upd_sts 10402 10402 0 0.00 0 18814 325 0 0
sp_qd_handle_on_reserve_upd_sts 9871 9871 0 0.00 0 15524 66 0 0
sp_reserve_write_off 9871 9871 0 0.00 6 15535 201 0 0
sp_supplier_invoice 5224 5224 0 0.00 7 86075 3609 0 0
sp_supplier_order 5304 5304 0 0.00 5 39932 1341 0 0
srv_aggregate_perf_data 106 106 0 0.00 2686 136022 15167 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1559 132693 31682 0 0
srv_find_qd_qs_mism 1036178 1036178 0 0.00 0 24775 5 0 0
srv_make_invnt_saldo 539 539 0 0.00 31 113728 1239 0 0
srv_make_money_saldo 754 754 0 0.00 1 7665 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 160715 473856 319934 0 0
t$perf-abend:sp_add_invoice_to_stock 105 105 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4880 4880 0 0.00 0 27950 207 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 2790 106 0 0
t$perf-norm:sp_cancel_client_order 1735 1735 0 0.00 0 3740 13 0 0
t$perf-norm:sp_cancel_customer_reserve 648 648 0 0.00 0 6045 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 612 612 0 0.00 0 6623 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 365 365 0 0.00 0 963 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 1020 18 0 0
t$perf-norm:sp_cancel_supplier_order 378 378 0 0.00 0 21176 1611 0 0
t$perf-norm:sp_cancel_write_off 975 975 0 0.00 0 1802 6 0 0
t$perf-norm:sp_client_order 19678 19678 0 0.00 0 24223 22 0 0
t$perf-norm:sp_customer_reserve 944 944 0 0.00 0 6330 13 0 0
t$perf-norm:sp_pay_from_customer 6934 6934 0 0.00 0 8087 14 0 0
t$perf-norm:sp_pay_to_supplier 5609 5609 0 0.00 0 6046 11 0 0
t$perf-norm:sp_reserve_write_off 9871 9871 0 0.00 0 8595 16 0 0
t$perf-norm:sp_supplier_invoice 5224 5224 0 0.00 0 7716 20 0 0
t$perf-norm:sp_supplier_order 5304 5304 0 0.00 0 5938 17 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 294 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 3338 32 0 0
t$perf-norm:srv_make_invnt_saldo 539 539 0 0.00 0 2210 37 0 0
t$perf-norm:srv_make_money_saldo 754 754 0 0.00 0 2131 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9936 9726 210 2.11 0 4503 24 0 210
v_all_customers 36086 36086 0 0.00 0 17 1 0 0
v_all_suppliers 29198 29198 0 0.00 0 29 1 0 0
v_all_wares 39352 39352 0 0.00 0 30 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 3579 17 0 0
v_cancel_client_order 3470 3470 0 0.00 0 3414 8 0 0
v_cancel_customer_prepayment 1224 1224 0 0.00 0 3584 9 0 0
v_cancel_customer_reserve 1296 1296 0 0.00 0 3507 9 0 0
v_cancel_payment_to_supplier 730 730 0 0.00 0 3100 11 0 0
v_cancel_supplier_invoice 848 832 16 1.88 0 2983 21 0 16
v_cancel_supplier_order 756 756 0 0.00 0 5373 14 0 0
v_cancel_write_off 1950 1950 0 0.00 0 1712 12 0 0
v_max_id_clo_ord 5304 5304 0 0.00 0 842 1 0 0
v_max_id_clo_res 944 944 0 0.00 0 2742 14 0 0
v_max_id_ord_sup 5221 5221 0 0.00 0 4775 6 0 0
v_max_non_paid_invoice 1535 1535 0 0.00 0 349 2 0 0
v_max_non_paid_realizn 3670 3670 0 0.00 0 2023 5 0 0
v_min_id_clo_ord 5304 5304 0 0.00 0 5538 7 0 0
v_min_id_clo_res 944 944 0 0.00 0 713 4 0 0
v_min_id_ord_sup 5221 5221 0 0.00 0 4489 6 0 0
v_min_non_paid_invoice 5609 5609 0 0.00 0 13979 20 0 0
v_min_non_paid_realizn 6933 6933 0 0.00 0 8187 26 0 0
v_our_firm 9792 9792 0 0.00 0 19 1 0 0
v_reserve_write_off 19742 19742 0 0.00 0 10199 8 0 0
x_lock_depdocs_on_canc_invoice 11307 11307 0 0.00 0 28151 144 0 0
x_lock_depdocs_on_canc_sup_ord 378 378 0 0.00 0 9739 466 0 0
x_make_qstorno_1000_1200 5304 5304 0 0.00 2 39920 1253 0 0
x_make_qstorno_1200_2000 5224 5224 0 0.00 2 86054 3464 0 0
x_make_qstorno_2100_3300 451853 451853 0 0.00 0 47159 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-02-2021 01:29:16 to 07-02-2021 01:29:20.

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:21 14 8192000000 8803602768 8815611904 8738032 0.106 3 1 2 0 8858736 58144 62560
22:57:28 11608 8192000000 10203487808 10504626176 887522928 9.774 71 55 114 0 908027984 2353712 18151344
22:57:49 33024 8192000000 10331217264 10646200320 1354514192 14.188 100 82 164 0 1385955360 4460112 26981056
22:58:32 27228 8192000000 10386233760 10706898944 1429056064 14.853 100 88 176 0 1464752864 6563728 29133072
22:59:09 16381 8192000000 10406411504 10731884544 1461370160 15.138 100 90 180 0 1502357696 11491920 29495616
22:59:40 28442 8192000000 10440754720 10769158144 1491105136 15.399 100 91 182 1 1528521680 8118400 29298144
23:00:22 28255 8192000000 10466984304 10802974720 1512659360 15.586 100 83 166 2 1548280656 9237392 26383904
23:01:01 19432 8192000000 10485382960 10826141696 1539257808 15.817 100 88 176 0 1576947168 9927888 27761472
23:01:36 18750 8192000000 10509605808 10852724736 1554635632 15.950 100 80 159 1 1589847344 10149920 25061792
23:02:03 12374 8192000000 10527595152 10881470464 1583439696 16.198 100 77 154 0 1617598704 10332128 23826880
23:02:28 12617 8192000000 10556163264 10910371840 1610839424 16.432 100 77 154 0 1644949648 10548864 23561360
23:02:49 18925 8192000000 10580052528 10938142720 1626216368 16.563 100 74 148 0 1659440944 10770240 22454336
23:03:20 15004 8192000000 10608916048 10972258304 1667202128 16.910 100 79 156 3 1701449552 11270064 22977360
23:03:46 11356 8192000000 10629104784 10994966528 1686908544 17.075 100 78 157 1 1722104368 12226544 22969280
23:04:04 10664 8192000000 10641305184 11009544192 1704486336 17.223 100 76 150 1 1738504448 12461760 21556352
23:04:23 7749 8192000000 10661588768 11037589504 1724043296 17.386 100 72 144 1 1757225376 12075632 21106448
23:04:41 7817 8192000000 10684354496 11059036160 1742614912 17.540 100 80 158 2 1778087552 12787792 22684848
23:04:57 5259 8192000000 10692543088 11073216512 1758149056 17.669 100 73 147 1 1791225744 12597088 20479600
23:05:09 5582 8192000000 10710568288 11090522112 1773987680 17.800 100 78 157 0 1807973328 11897824 22087824
23:05:24 8128 8192000000 10720209920 11102625792 1781102848 17.859 100 73 143 2 1813189744 11611072 20475824
23:05:39 5106 8192000000 10724789552 11109781504 1790572080 17.936 100 76 152 1 1824916208 12741408 21602720
23:05:56 7225 8192000000 10737639664 11118845952 1799626112 18.011 100 77 155 1 1832909328 11729920 21553296
23:06:10 3506 8192000000 10757725616 11141382144 1813226096 18.122 100 83 166 0 1849662992 13111392 23325504
23:06:21 4278 8192000000 10753246576 11140448256 1819784352 18.176 100 89 176 1 1858484560 14050000 24650208
23:06:32 3227 8192000000 10768004464 11151519744 1823944704 18.210 100 89 176 3 1863045808 14777536 24323568
23:06:42 2943 8192000000 10769170096 11157078016 1828151392 18.244 100 79 159 1 1864183216 12471568 23560256
23:06:51 2556 8192000000 10783505856 11169492992 1837886416 18.324 100 81 162 1 1872544384 12529360 22128608
23:07:01 2426 8192000000 10787162032 11174707200 1844556768 18.378 100 85 172 2 1882138624 13756112 23825744
23:07:10 1886 8192000000 10786097440 11176173568 1851718880 18.436 100 90 179 2 1890727872 13941712 25067280
23:07:19 2108 8192000000 10794941312 11185381376 1856058544 18.471 100 85 171 0 1894725632 14321408 24345680
23:07:27 1074 8192000000 10809820752 11196452864 1865575904 18.548 100 95 189 0 1905711568 13362384 26773280
23:07:35 2227 8192000000 10805767600 11196928000 1870698592 18.590 100 92 185 2 1910511744 13841072 25972080
23:07:44 2019 8192000000 10820003088 11208228864 1874724544 18.622 100 93 187 1 1915044448 14336576 25983328
23:07:52 2130 8192000000 10816225600 11204231168 1874028336 18.617 100 93 186 1 1915163552 14652064 26483152
23:08:00 1337 8192000000 10820485360 11212959744 1879962464 18.665 100 86 172 1 1917386272 13252752 24171056
23:08:08 1945 8192000000 10833036880 11221278720 1885845568 18.712 100 94 188 1 1925284144 13548288 25890288
23:08:16 1648 8192000000 10834981376 11224236032 1887918016 18.729 100 94 188 1 1928280592 14769840 25592736
23:08:24 2308 8192000000 10820651040 11225939968 1888821632 18.736 100 81 163 2 1927066592 15957072 22287888
23:08:33 14228 8192000000 10810572704 11222425600 1887710304 18.727 100 57 115 1 1915136752 10937936 16488512
23:08:54 1332 8192000000 10837749312 11236941824 1897775840 18.808 100 86 172 0 1934728336 11473984 25478512
23:09:03 4001 8192000000 10830826592 11230429184 1893302000 18.772 100 61 121 1 1922532864 11711984 17518880
23:09:15 5386 8192000000 10800594416 11220623360 1887961232 18.729 100 33 66 1 1905726224 8846016 8918976
23:09:27 5927 8192000000 10809960256 11231096832 1889189296 18.739 100 28 56 1 1904834672 7888048 7757328
23:09:39 7661 8192000000 10794668128 11225382912 1890256112 18.748 100 17 34 2 1902317824 7100832 4960880
23:09:53 8024 8192000000 10802137472 11230404608 1892761696 18.768 100 22 43 2 1905839984 6780752 6297536
23:10:12 5830 8192000000 10804183024 11231469568 1895036992 18.786 100 27 54 0 1910223504 7228288 7958224
23:10:24 12735 8192000000 10808839648 11234893824 1896908480 18.801 100 25 48 1 1909328304 5625152 6794672
23:11:00 42280 8192000000 10848608096 11250266112 1907435056 18.886 100 68 139 3 1933814528 6143408 20236064
23:11:49 7089 8192000000 10811848848 11246120960 1900609856 18.831 100 29 58 1 1917235024 8807168 7818000
23:12:03 6152 8192000000 10817232144 11251298304 1902313728 18.845 100 37 74 1 1918906464 6954320 9638416
23:12:16 7769 8192000000 10818258848 11249639424 1903069408 18.851 100 26 52 1 1916505680 6708368 6727904
23:12:32 19705 8192000000 10812634048 11250245632 1904333440 18.861 100 15 29 1 1914286288 5823824 4129024
23:12:58 9345 8192000000 10831060736 11257692160 1909114304 18.900 100 31 62 0 1925229680 6634960 9480416
23:13:14 11924 8192000000 10808408848 11252072448 1908798688 18.897 100 31 62 1 1923651600 5630160 9222752
23:13:33 4598 8192000000 10824917280 11259985920 1909137408 18.900 100 28 56 3 1928935632 10257904 9540320
23:13:46 10338 8192000000 10824586624 11257262080 1908545536 18.895 100 28 56 0 1923219296 6589072 8084688
23:14:02 8563 8192000000 10816440032 11257741312 1908154496 18.892 100 16 31 0 1922557008 10189440 4213072
23:14:17 9305 8192000000 10811590544 11255828480 1888525312 18.734 99 19 38 2 1903525056 9955728 5044016
23:14:33 11718 8192000000 10817402016 11254665216 1907608976 18.887 100 23 46 2 1919497968 5252656 6636336
23:14:51 8699 8192000000 10821494720 11259195392 1911066416 18.915 100 23 46 3 1924485904 7002176 6417312
23:15:08 51132 8192000000 10833089856 11260813312 1914710016 18.944 100 29 58 1 1928339248 5566384 8062848
23:16:07 26001 8192000000 10820855408 11259289600 1896727488 18.800 99 37 73 4 1913210944 6828224 9655232
23:16:41 7547 8192000000 10831617632 11264905216 1915065312 18.947 100 33 66 1 1931050176 6902336 9082528
23:16:55 5693 8192000000 10801337040 11226681344 1853628416 18.452 97 22 44 0 1866129968 6237488 6264064
23:17:07 4335 8192000000 10807288928 11237113856 1887457552 18.725 100 37 73 1 1905005328 6979664 10568112
23:17:20 5768 8192000000 10794442208 11226660864 1871248080 18.594 99 25 49 2 1884531360 5693280 7590000
23:17:34 4684 8192000000 10785459680 11206270976 1861736064 18.517 99 25 50 1 1874863856 5958896 7168896
23:17:47 4765 8192000000 10778594256 11202682880 1819207888 18.171 97 32 63 4 1834214816 5960720 9046208
23:18:01 5473 8192000000 10769933056 11198140416 1826705824 18.232 98 22 44 0 1838945264 5862528 6376912
23:18:13 5185 8192000000 10779701104 11208278016 1852755568 18.445 99 23 46 1 1865716480 6353392 6607520
23:18:29 8192 8192000000 10753130352 11175784448 1796933072 17.989 97 23 46 0 1809186688 5823616 6430000
23:18:47 8546 8192000000 10758951664 11184779264 1831343952 18.270 99 25 50 0 1844468864 5555856 7569056
23:19:03 10396 8192000000 10740660896 11157921792 1753653552 17.632 95 17 34 1 1763851392 5379296 4818544
23:19:24 14616 8192000000 10714116032 11145003008 1710360176 17.272 93 11 22 1 1719253488 5038160 3855152
23:19:51 7242 8192000000 10662087344 11060994048 1665354592 16.894 93 13 26 1 1677922496 9375328 3192576
23:20:04 55548 8192000000 10680220336 11089358848 1709778560 17.267 96 47 94 1 1729711664 5808288 14124816
23:21:07 19561 8192000000 10667804464 11080151040 1681892896 17.033 94 19 38 1 1692258208 5179776 5185536
23:21:36 7257 8192000000 10694793424 11106996224 1770912432 17.775 100 28 56 1 1786060048 7238928 7908688
23:21:52 4941 8192000000 10715313488 11129450496 1792040656 17.949 100 34 68 2 1809474672 7901456 9532560
23:22:05 5126 8192000000 10704497264 11115847680 1771207696 17.777 99 34 68 0 1787458304 5488976 10761632
23:22:16 7567 8192000000 10698651888 11111641088 1767447808 17.746 99 25 50 1 1780985040 5656752 7880480
23:22:31 11428 8192000000 10717212144 11133399040 1802040256 18.031 100 29 58 1 1816413520 5224512 9148752
23:22:49 11838 8192000000 10731106736 11148451840 1799397392 18.009 99 25 50 1 1812595072 5475136 7722544
23:23:07 11255 8192000000 10744217696 11162759168 1819054912 18.170 100 24 48 1 1835573216 9656448 6861856
23:23:25 7827 8192000000 10755306240 11173965824 1830265248 18.261 100 30 60 1 1844774544 5304016 9205280
23:23:41 6394 8192000000 10757011856 11178508288 1840970864 18.349 100 36 71 1 1857969696 6214224 10784608
23:23:54 10812 8192000000 10754888528 11172040704 1834626752 18.297 100 19 37 1 1845299040 5117440 5554848
23:24:14 9468 8192000000 10746650688 11178512384 1841972960 18.357 100 24 48 2 1855106544 6008640 7124944
23:24:30 7934 8192000000 10752999904 11182481408 1842281168 18.359 100 20 40 3 1853734832 5522224 5931440
23:24:48 17784 8192000000 10754553616 11182026752 1843430688 18.369 100 13 26 0 1852775760 5206352 4138720
23:25:15 50454 8192000000 10800133584 11194437632 1852761568 18.445 100 61 123 1 1877442400 6148128 18532704
23:26:11 12906 8192000000 10753613680 11187580928 1848511696 18.410 100 25 49 3 1862757136 6610320 7635120
23:26:31 9030 8192000000 10775196416 11193307136 1850654576 18.427 100 22 44 1 1862983312 5686224 6642512
23:26:47 8269 8192000000 10767191264 11194007552 1853281104 18.449 100 19 37 3 1864247600 5909536 5056960
23:27:02 5021 8192000000 10772908432 11204067328 1864900368 18.543 100 26 53 0 1878666080 5796768 7968944
23:27:13 29285 8192000000 10809465712 11229986816 1880284512 18.667 100 27 52 5 1893447760 6139408 7023840
23:27:53 10780 8192000000 10827099168 11246149632 1898231696 18.812 100 46 90 3 1918521888 7793024 12497168
23:28:16 2818 8192000000 10843132544 11256283136 1908049248 18.891 100 56 112 1 1932256096 8821968 15384880
23:28:36 15793 8192000000 10853187392 11269152768 1916374384 18.958 100 61 122 1 1943691792 10295648 17021760
23:29:11 23522 8192000000 10858958224 11278790656 1926437456 19.038 100 52 100 2 1953927520 13519952 13970112
23:29:46 13397 8192000000 10867438928 11293528064 1930564112 19.071 100 59 118 1 1960562416 13748480 16249824
23:30:06 6776 8192000000 10869524528 11288551424 1933174960 19.092 100 50 99 2 1962183472 13655568 15352944
23:30:23 12920 8192000000 10877317600 11296088064 1935858480 19.114 100 49 98 0 1963513312 13252112 14402720
23:30:48 15233 8192000000 10874989520 11301859328 1941828048 19.161 100 56 111 0 1972677904 14646928 16202928
23:31:16 34887 8192000000 10857674048 11303260160 1940230400 19.149 100 43 86 1 1967675008 14562896 12881712
23:32:25 21463 8192000000 10870795792 11304132608 1937400448 19.126 100 30 60 1 1957757568 11648736 8708384
23:32:55 27900 8192000000 10882647664 11314126848 1925612192 19.032 99 43 85 1 1955709136 17820992 12275952
23:33:32 6457 8192000000 10899834752 11322421248 1955901776 19.273 100 60 120 0 1988931888 15279296 17750816
23:33:49 10876 8192000000 10896694720 11325976576 1957738336 19.288 100 67 133 2 1993480688 16017232 19725120
23:34:09 5019 8192000000 10906478192 11326287872 1958695824 19.296 100 61 122 1 1991221568 15702400 16823344
23:34:21 1776 8192000000 10917490640 11332517888 1965110608 19.347 100 85 165 1 2004974784 15718496 24145680
23:34:36 13626 8192000000 10908732032 11331579904 1947689216 19.208 99 63 126 1 1982756944 16978144 18089584
23:34:59 9779 8192000000 10920488704 11347460096 1972465072 19.405 100 66 132 1 2010395360 19120752 18809536
23:35:15 8713 8192000000 10910354288 11338309632 1970521376 19.390 100 69 138 1 2010087728 19235040 20331312
23:35:32 5878 8192000000 10923185664 11353178112 1974369632 19.420 100 63 126 1 2010784608 17928976 18486000
23:35:54 17785 8192000000 10927922960 11365449728 1980207552 19.466 100 45 89 1 2014536432 21049344 13279536
23:36:20 9959 8192000000 10937154688 11371880448 1988655344 19.533 100 59 117 1 2029334864 22446000 18233520
23:36:41 8996 8192000000 10942181584 11375673344 1990265584 19.546 100 48 96 0 2028888816 23164976 15458256
23:36:58 8979 8192000000 10940216624 11372896256 1978789568 19.455 99 60 121 2 2021420720 23929200 18701952
23:37:15 2830 8192000000 10954225696 11379605504 1993466224 19.571 100 68 134 0 2043020800 29396768 20157808
23:37:26 5800 8192000000 10956843600 11381800960 1995736192 19.589 100 66 132 1 2043565552 28287248 19542112
23:37:45 2808 8192000000 10965468704 11391598592 2006306640 19.672 100 75 147 2 2052876080 25012976 21556464
23:37:54 3531 8192000000 10964820144 11383791616 1983173408 19.490 99 84 168 3 2037357504 29338272 24845824
23:38:07 7338 8192000000 10956274896 11380633600 1977873344 19.448 99 71 142 1 2024823552 25890240 21059968
23:38:22 3290 8192000000 10955421248 11375816704 1988772944 19.534 100 82 162 3 2042614384 29060144 24781296
23:38:34 1554 8192000000 10970026240 11381878784 1996287520 19.593 100 86 168 0 2051212464 29164960 25759984
23:38:44 3557 8192000000 10970399152 11384852480 2000144784 19.624 100 71 139 0 2050376368 29351728 20879856
23:38:55 5938 8192000000 10955332208 11381657600 1982305216 19.483 99 69 138 1 2032359792 29683568 20371008
23:39:16 5189 8192000000 10965264800 11384025088 1992996176 19.567 100 78 156 0 2048591600 32389408 23206016
23:39:30 3544 8192000000 10966899200 11387965440 1997153840 19.600 100 78 154 2 2055651104 35023360 23473904
23:39:42 3645 8192000000 10968769104 11397038080 2001770176 19.637 100 68 135 1 2058956096 35677840 21508080
23:39:53 9945 8192000000 10969820880 11399782400 2003561840 19.651 100 58 115 0 2056779984 35273376 17944768
23:40:10 8397 8192000000 10959840848 11387416576 1988010736 19.528 99 59 118 0 2043514000 36259184 19244080
23:40:26 4164 8192000000 10979416048 11404189696 2005010208 19.662 100 67 134 1 2062598848 36535856 21052784
23:40:37 3365 8192000000 10974934976 11388993536 1965107872 19.347 98 82 162 0 2027809360 37892432 24809056
23:40:51 6766 8192000000 10954096112 11384283136 1974242064 19.419 99 70 138 3 2035853760 40277904 21333792
23:41:05 5739 8192000000 10952677008 11381366784 1973796800 19.416 99 66 132 2 2027909616 33938784 20174032
23:41:18 3956 8192000000 10969676320 11390234624 1980065168 19.465 99 79 159 1 2034657824 30020384 24572272
23:41:29 2676 8192000000 10959204672 11376926720 1984709312 19.502 100 84 166 1 2041468672 31249360 25510000
23:41:40 7234 8192000000 10954020512 11377053696 1984548336 19.501 100 71 142 1 2039158688 32317120 22293232
23:41:56 12002 8192000000 10958705728 11381837824 1987181216 19.522 100 73 144 2 2042827184 32934528 22711440
23:42:18 6086 8192000000 10946938752 11364519936 1956930256 19.282 98 71 141 0 2012264400 33393040 21941104
23:42:32 8077 8192000000 10954516400 11381624832 1979839872 19.463 100 57 114 0 2030886016 33109488 17936656
23:42:51 6052 8192000000 10955918496 11382837248 1972246000 19.403 99 64 128 0 2029363872 36155408 20962464
23:43:06 8421 8192000000 10939023344 11363119104 1963861168 19.337 99 61 121 1 2021448672 38430432 19157072
23:43:23 1926 8192000000 10959009392 11374841856 1978225584 19.451 100 81 161 2 2041421696 38325328 24870784
23:43:32 2267 8192000000 10960977696 11378073600 1979395408 19.460 100 82 164 0 2044931136 39821920 25713808
23:43:42 8787 8192000000 10945154976 11372597248 1970113232 19.386 100 56 112 1 2026076528 37789456 18173840
23:43:58 1808 8192000000 10953978384 11367481344 1970614192 19.390 100 70 139 2 2030813824 38060192 22139440
23:44:08 14614 8192000000 10953550336 11374403584 1973711968 19.415 100 67 134 1 2032047200 37128576 21206656
23:44:29 5484 8192000000 10955653072 11379011584 1979514272 19.461 100 64 128 1 2038373600 38396016 20463312
23:44:43 3363 8192000000 10968099488 11387473920 1987559760 19.525 100 66 131 0 2047822320 39873936 20388624
23:44:53 2824 8192000000 10976694208 11394891776 1993169952 19.569 100 82 164 0 2058686176 39317200 26199024
23:45:07 4516 8192000000 10961758240 11381432320 1966310432 19.356 99 67 134 0 2027867152 40182752 21373968
23:45:19 2369 8192000000 10959854144 11376857088 1965962960 19.353 99 78 156 0 2030756032 40557024 24236048
23:45:31 4172 8192000000 10954042960 11368546304 1963653376 19.335 99 76 152 2 2030324016 42376384 24294256
23:45:47 3307 8192000000 10956881968 11371081728 1966692096 19.359 99 84 168 2 2037016400 43516240 26808064
23:45:57 3690 8192000000 10971937104 11388325888 1982184944 19.482 100 90 180 1 2058979440 47413408 29381088
23:46:08 4007 8192000000 10974345008 11383037952 1978622576 19.454 100 86 172 1 2053712304 48325552 26764176
23:46:22 3186 8192000000 10966684240 11384221696 1982676544 19.486 100 75 149 1 2055346736 49148736 23521456
23:46:33 2636 8192000000 10968328848 11386552320 1980422336 19.468 100 69 139 0 2051611504 48040432 23148736
23:46:44 4113 8192000000 10935287776 11352899584 1938710464 19.136 99 77 154 0 2011865136 48102640 25052032
23:46:55 5637 8192000000 10947806320 11363983360 1957765840 19.288 100 70 138 1 2029703488 49109552 22828096
23:47:08 9309 8192000000 10954385808 11378438144 1966592864 19.358 100 65 130 0 2038980592 51026288 21361440
23:47:25 6663 8192000000 10955562784 11377627136 1962709584 19.328 100 71 143 1 2038615504 52569552 23336368
23:47:40 6489 8192000000 10962177440 11395178496 1981505152 19.477 100 51 101 2 2049367856 51185824 16676880
23:47:55 8609 8192000000 10961236928 11396128768 1983474176 19.492 100 47 94 0 2043341312 44904208 14962928
23:48:13 14076 8192000000 10958051968 11393937408 1967536288 19.366 99 41 82 1 2025411392 44656272 13218832
23:48:38 11652 8192000000 10938858928 11373920256 1941500672 19.159 98 42 84 0 2004570496 48478960 14590864
23:49:04 9475 8192000000 10934826944 11370053632 1958451264 19.294 100 42 84 0 2023491744 50809632 14230848
23:49:26 7641 8192000000 10928957280 11365527552 1934662880 19.104 99 49 96 0 2002846160 52071536 16111744
23:49:47 11863 8192000000 10902689312 11335065600 1902134080 18.843 98 42 84 2 1972736512 56016752 14585680
23:50:09 5563 8192000000 10916486000 11345698816 1929781232 19.065 100 51 102 0 2001287296 54092864 17413200
23:50:22 5977 8192000000 10932069568 11361087488 1937876928 19.130 100 50 99 0 2010646928 56308368 16461632
23:50:38 17063 8192000000 10911516688 11359363072 1937551968 19.127 100 36 72 2 2003774064 54104784 12117312
23:51:11 18013 8192000000 10920054944 11363287040 1944631056 19.184 100 29 58 0 2001392176 46962752 9798368
23:51:36 8100 8192000000 10917845680 11366301696 1946645424 19.200 100 29 58 1 2004902400 48328800 9928176
23:52:10 10847 8192000000 10921781600 11358973952 1924968096 19.027 99 42 84 1 1993439104 53760352 14710656
23:52:38 20136 8192000000 10909263920 11355430912 1915513792 18.951 99 29 58 0 1983956464 58038512 10404160
23:53:09 12401 8192000000 10927661536 11372740608 1931485376 19.079 100 36 71 2 2005271008 61639984 12145648
23:53:35 41711 8192000000 10904620976 11355795456 1894543152 18.782 98 24 48 2 1959273168 56800000 7930016
23:54:23 39414 8192000000 10868724400 11330314240 1896363232 18.797 99 14 28 1 1944062384 41845936 5853216
23:55:10 65077 8192000000 10854945984 11315961856 1891638032 18.759 99 28 53 3 1935028592 34411888 8978672
23:56:32 8002 8192000000 10871836224 11311808512 1923446912 19.014 100 39 76 1 1949814976 14894768 11473296
23:56:46 13942 8192000000 10836242064 11282829312 1893006896 18.770 99 27 54 2 1909029744 8366608 7656240
23:57:10 47497 8192000000 10864959280 11309461504 1932237232 19.085 100 32 63 4 1952202912 10406656 9559024
23:58:11 22349 8192000000 10850605584 11315470336 1913799264 18.937 99 17 34 1 1930708624 12036304 4873056
23:58:49 92142 8192000000 10847078416 11302203392 1893410192 18.773 98 11 22 0 1911104512 14782912 2911408
00:00:27 71009 8192000000 10861387728 11319590912 1928337824 19.054 100 10 20 1 1947379296 16628816 2412656
00:01:44 85030 8192000000 10856583728 11315851264 1868936880 18.576 96 16 32 1 1885154864 11939968 4278016
00:03:21 116406 8192000000 10883002336 11325730816 1921106560 18.996 99 29 58 1 1940680704 11011248 8562896
00:05:24 73052 8192000000 10875706448 11353751552 1950567008 19.231 100 22 44 3 1969218144 12491552 6159584
00:07:09 39762 8192000000 10879462240 11337363456 1939855776 19.146 99 26 53 1 1958234736 10965984 7412976
00:07:56 9506 8192000000 10891559536 11343593472 1962417632 19.325 100 50 100 2 1987240944 11051120 13772192
00:08:12 46631 8192000000 10900489024 11360047104 1963939056 19.337 100 12 24 1 1983556352 15547632 4069664
00:09:14 38869 8192000000 10874790048 11329986560 1922062336 19.003 98 30 60 3 1941052496 9721072 9269088
00:10:02 30173 8192000000 10888779440 11346849792 1956808880 19.281 100 39 78 3 1979509536 11030560 11670096
00:10:55 43108 8192000000 10893895952 11360407552 1957334816 19.285 100 24 48 2 1980616848 15677424 7604608
00:11:44 52292 8192000000 10894346816 11365994496 1963099296 19.331 100 18 35 0 1985594944 16766464 5729184
00:13:01 36217 8192000000 10894362752 11363639296 1967944192 19.369 100 8 16 0 1985654928 15241776 2468960
00:14:13 52987 8192000000 10901725280 11360870400 1950991392 19.234 99 18 34 2 1967608800 11651776 4965632
00:16:03 88118 8192000000 10900899040 11381067776 1959307248 19.301 99 39 78 1 1990627392 19785424 11534720
00:17:45 80140 8192000000 10890747792 11366711296 1969500432 19.381 100 2 4 0 1989638784 19739616 398736
00:19:38 29625 8192000000 10907688048 11381141504 1974661024 19.422 99 39 78 0 1996836752 10651632 11524096
00:20:14 34901 8192000000 10902412656 11370008576 1965746688 19.352 99 11 22 0 1975246928 6627904 2872336
00:20:55 54627 8192000000 10899133920 11365822464 1932491872 19.087 97 35 70 1 1952740112 10456144 9792096
00:21:56 61404 8192000000 10929078096 11378753536 1976804976 19.439 100 20 40 1 1996186208 14029344 5351888
00:23:07 44783 8192000000 10927455952 11389128704 1986474512 19.516 100 24 49 0 2002277744 9347520 6455712
00:23:59 56929 8192000000 10907387376 11383046144 1914930960 18.946 96 33 66 0 1943633984 18796512 9906512
00:25:28 103273 8192000000 10914714848 11384025088 1962236320 19.324 99 12 24 1 1987051072 21377728 3437024
00:27:23 72582 8192000000 10935109168 11388272640 1967089424 19.362 99 18 34 3 1984884912 13250128 4545360
00:28:42 132669 8192000000 10879911184 11346837504 1793047232 17.957 90 10 20 0 1810136176 14145792 2943152
00:31:02 106109 8192000000 10856170304 11301371904 1863063168 18.528 95 31 62 1 1879936512 8572160 8301184
00:33:12 74202 8192000000 10864587936 11318743040 1897611232 18.807 97 48 96 1 1921628144 10065616 13951296
00:34:33 10113 8192000000 10897943744 11347918848 1962433712 19.325 100 54 108 1 1988235952 10751504 15050736
00:35:08 56154 8192000000 10842265552 11321556992 1918349408 18.974 98 21 42 3 1937567520 13457616 5760496
00:36:15 35299 8192000000 10857527888 11339255808 1941021232 19.155 100 6 12 0 1955548912 12827216 1700464
00:36:58 33298 8192000000 10846524720 11327512576 1916825376 18.961 99 11 22 0 1932670272 12330800 3514096
00:37:37 36005 8192000000 10867863040 11345129472 1930999360 19.075 100 5 10 0 1946607424 13917312 1690752
00:38:19 25205 8192000000 10859968656 11336286208 1928575216 19.055 99 16 32 1 1942821280 9261600 4984464
00:39:07 77813 8192000000 10831800592 11307544576 1842557840 18.362 95 17 34 0 1855374592 8200272 4616480
00:40:42 88579 8192000000 10834130208 11311386624 1865152144 18.545 97 14 28 0 1880945024 11539552 4253328
00:42:37 54712 8192000000 10821651392 11300745216 1885417792 18.709 98 25 50 1 1906605776 14478672 6709312
00:43:38 42014 8192000000 10842029168 11298979840 1897394784 18.805 99 22 42 2 1913716288 10466960 5854544
00:44:42 64621 8192000000 10837823456 11298865152 1879526624 18.661 98 21 42 1 1898277088 12352080 6398384
00:46:13 104001 8192000000 10846416160 11317587968 1870898912 18.592 97 29 58 0 1901278624 21786304 8593408
00:48:08 33667 8192000000 10842065472 11298197504 1882627856 18.686 98 27 53 1 1897517296 7329056 7560384
00:48:50 20546 8192000000 10850312496 11300073472 1897772864 18.808 99 38 76 0 1919440208 10970864 10696480
00:49:18 76619 8192000000 10843445264 11318509568 1882817568 18.688 98 29 58 0 1908347680 17083392 8446720
00:51:12 76363 8192000000 10845288240 11299217408 1807249248 18.073 94 20 40 1 1827403840 14785952 5368640
00:52:38 54242 8192000000 10836768448 11306356736 1879574144 18.662 98 17 34 1 1897337824 13246640 4517040
00:53:43 46303 8192000000 10888681616 11335561216 1912952896 18.930 99 44 88 4 1940836944 15893920 11990128
00:54:42 86251 8192000000 10853946720 11339329536 1928825456 19.057 100 21 42 1 1957186624 22766256 5594912
00:56:30 70375 8192000000 10861332416 11326119936 1916721376 18.961 99 24 49 0 1930669344 8212848 5735120
00:57:47 38310 8192000000 10842229248 11315077120 1903050608 18.851 98 12 24 1 1912857232 6872464 2934160
00:58:37 76019 8192000000 10853678432 11327049728 1921769056 19.001 99 12 24 1 1933634912 8431168 3434688
01:00:00 45522 8192000000 10858691616 11341172736 1940921168 19.154 100 6 12 0 1952190496 9904928 1364400
01:00:51 18437 8192000000 10853340272 11340492800 1923100048 19.012 99 6 12 1 1939048720 14577728 1370944
01:01:16 44759 8192000000 10846678400 11311476736 1893576960 18.775 97 16 32 1 1905855360 8108464 4169936
01:02:51 56704 8192000000 10895477568 11361964032 1958468352 19.294 100 16 32 1 1973545024 10706720 4369952
01:04:02 75230 8192000000 10917789040 11396808704 1981673088 19.478 100 21 42 2 2003514224 15348896 6492240
01:05:40 47403 8192000000 10890375600 11331301376 1901663024 18.840 96 25 50 0 1916980000 7795360 7521616
01:06:34 24731 8192000000 10921120656 11374710784 1980579936 19.469 100 55 110 2 2006589040 10223376 15785728
01:07:08 65099 8192000000 10888312304 11357827072 1937436832 19.126 98 24 48 0 1956430960 12529968 6464160
01:08:19 81395 8192000000 10892589248 11361796096 1944867936 19.186 99 19 38 0 1961440960 11152880 5420144
01:09:47 48037 8192000000 10922106928 11377856512 1975540144 19.429 100 27 54 1 1992806736 10014112 7252480
01:10:54 59804 8192000000 10904430768 11374407680 1961553296 19.318 99 17 30 2 1977358416 11473456 4331664
01:11:59 67967 8192000000 10925048816 11383431168 1971104080 19.394 99 22 43 1 1985810256 8666320 6039856
01:13:16 46041 8192000000 10928197200 11379077120 1928371728 19.054 97 37 74 2 1949298000 10897072 10029200
01:14:09 31801 8192000000 10891332224 11369963520 1936747728 19.121 98 28 56 0 1960293600 15822480 7723392
01:14:57 78516 8192000000 10922908560 11388035072 1983576752 19.493 100 25 50 3 2005083488 14758688 6748048
01:16:22 101156 8192000000 10923680592 11386814464 1969014032 19.378 99 24 48 0 1989003936 13763904 6226000
01:18:34 57732 8192000000 10915944192 11402747904 1963922384 19.337 99 20 40 0 1987543296 18639504 4981408
01:19:41 28389 8192000000 10909160544 11395006464 1981788432 19.479 100 10 20 0 2003010416 18966000 2255984
01:20:26 55185 8192000000 10875931488 11353411584 1903806736 18.857 96 22 44 1 1920437792 10870640 5760416
01:21:27 55579 8192000000 10880823856 11363606528 1964718080 19.344 100 5 10 0 1976658896 10106240 1834576
01:22:29 30241 8192000000 10866898272 11349561344 1909369104 18.902 97 12 24 0 1922658064 9891232 3397728
01:23:10 59612 8192000000 10890481728 11360677888 1942098944 19.164 99 17 34 0 1954054064 7246368 4708752
01:24:33 88835 8192000000 10871198512 11349716992 1879457744 18.661 95 15 30 0 1896979120 13431280 4090096
01:26:35 60963 8192000000 10013104416 10399076352 1140149360 12.217 58 4 8 0 1155301248 13907216 1244672

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 07-02-2021 01:29:22 to 07-02-2021 01:29:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 105 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-02-2021 01:29:54 to 07-02-2021 01:29:56.

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          233382
MON$OLDEST_ACTIVE               233383
MON$OLDEST_SNAPSHOT             233383
MON$NEXT_TRANSACTION            233383
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                       2006848
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:57: 
:58: mscs-test-161.budzdorov.ru    Sun Feb  7 01:27:38 2021
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
--- end of diff output ---

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

07.02.21 01:29:57. 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-07 01:30:00 No severe PSQL-related problems occured
07.02.21 01:30:01. End of report.