Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.01.2021 22:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17321116 kB
MemAvailable 31236296 kB
Buffers 0 kB
Cached 14367748 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-01-31 22:27:16
DTS_END                         2021-01-31 22:27:16.7010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60098
TRN_ID                          245280
ATT_ID                          687
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: 9008.13 17395 1080976
customer order: creation 181.36 351 21763
customer order: refuse 15.83 333 1899
order to supplier: creation 48.98 1229 5878
order to supplier: removal 3.26 95113 391
invoice (draft): creation 47.63 3439 5715
invoice (draft): removal 49.19 739 5903
invoice accept: apply 43.29 16475 5195
invoice accept: cancel 44.48 838 5338
customer reserve: creation 3891.91 166 467029
customer reserve: removal 4382.09 57 525851
realization accept: apply 88.28 184 10593
realization accept: cancel 74.79 110 8975
payment from customer: creation 62.93 126 7551
payment from customer: removal 5.98 98 718
payment to supplier: creation 51.23 154 6148
payment to supplier: removal 3.68 81 441
service: total inventory turnovers 4.94 1108 593
service: total monetary turnovers 7.41 22 889
service: aggregate perf. data 0.85 16635 102
service: refresh index statistics 0.03 210645 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-01-2021 22:28:23 to 31-01-2021 22:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6593
TEST_TIME 2 5304
TEST_TIME 3 5443
TEST_TIME 4 5337
TEST_TIME 5 5438
TEST_TIME 6 5848
TEST_TIME 7 5774
TEST_TIME 8 5730
TEST_TIME 9 5996
TEST_TIME 10 5933
TEST_TIME 11 6252
TEST_TIME 12 6311
TEST_TIME 13 7100
TEST_TIME 14 7087
TEST_TIME 15 7540
TEST_TIME 16 8254
TEST_TIME 17 8448
TEST_TIME 18 8524
TEST_TIME 19 8560
TEST_TIME 20 8912
TEST_TIME 21 8956
TEST_TIME 22 9308
TEST_TIME 23 9592
TEST_TIME 24 9856
TEST_TIME 25 10003
TEST_TIME 26 10509
TEST_TIME 27 10535
TEST_TIME 28 10516
TEST_TIME 29 10842
TEST_TIME 30 10626
TEST_TIME 31 10478
TEST_TIME 32 10244
TEST_TIME 33 10258
TEST_TIME 34 10119
TEST_TIME 35 10201
TEST_TIME 36 10092
TEST_TIME 37 10085
TEST_TIME 38 10010
TEST_TIME 39 9942
TEST_TIME 40 9908
TEST_TIME 41 9831
TEST_TIME 42 9668
TEST_TIME 43 9560
TEST_TIME 44 9512
TEST_TIME 45 9530
TEST_TIME 46 9720
TEST_TIME 47 9714
TEST_TIME 48 9614
TEST_TIME 49 9529
TEST_TIME 50 9496
TEST_TIME 51 9364
TEST_TIME 52 9246
TEST_TIME 53 9284
TEST_TIME 54 9232
TEST_TIME 55 9234
TEST_TIME 56 9181
TEST_TIME 57 9091
TEST_TIME 58 9056
TEST_TIME 59 9095
TEST_TIME 60 9020
TEST_TIME 61 9091
TEST_TIME 62 9086
TEST_TIME 63 9121
TEST_TIME 64 9123
TEST_TIME 65 9269
TEST_TIME 66 9241
TEST_TIME 67 9229
TEST_TIME 68 9266
TEST_TIME 69 9310
TEST_TIME 70 9335
TEST_TIME 71 9368
TEST_TIME 72 9392
TEST_TIME 73 9363
TEST_TIME 74 9408
TEST_TIME 75 9378
TEST_TIME 76 9275
TEST_TIME 77 9263
TEST_TIME 78 9209
TEST_TIME 79 9166
TEST_TIME 80 9277
TEST_TIME 81 9263
TEST_TIME 82 9214
TEST_TIME 83 9162
TEST_TIME 84 9124
TEST_TIME 85 9056
TEST_TIME 86 9000
TEST_TIME 87 9006
TEST_TIME 88 9005
TEST_TIME 89 9060
TEST_TIME 90 9088
TEST_TIME 91 9077
TEST_TIME 92 9106
TEST_TIME 93 9137
TEST_TIME 94 9146
TEST_TIME 95 9127
TEST_TIME 96 9192
TEST_TIME 97 9225
TEST_TIME 98 9216
TEST_TIME 99 9187
TEST_TIME 100 9240
TEST_TIME 101 9282
TEST_TIME 102 9261
TEST_TIME 103 9273
TEST_TIME 104 9190
TEST_TIME 105 9178
TEST_TIME 106 9156
TEST_TIME 107 9131
TEST_TIME 108 9084
TEST_TIME 109 9076
TEST_TIME 110 9064
TEST_TIME 111 9023
TEST_TIME 112 9017
TEST_TIME 113 8996
TEST_TIME 114 8997
TEST_TIME 115 9021
TEST_TIME 116 8988
TEST_TIME 117 9034
TEST_TIME 118 9080
TEST_TIME 119 9057
TEST_TIME 120 9012

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-01-2021 22:28:27 to 31-01-2021 22:28:30.

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 1514362 1514362 0 0.00 0 32017 6 0 0
doc_list_biud 1514361 1514361 0 0.00 0 44888 25 0 0
sp_add_invoice_to_stock 5329 5195 134 2.51 34 175069 16476 0 134
sp_cancel_adding_invoice 5338 5338 0 0.00 3 52633 838 0 0
sp_cancel_client_order 1899 1899 0 0.00 4 9335 333 0 0
sp_cancel_customer_reserve 525851 525851 0 0.00 1 44890 57 0 0
sp_cancel_pay_from_customer 718 718 0 0.00 3 4685 98 0 0
sp_cancel_pay_to_supplier 441 441 0 0.00 3 4486 81 0 0
sp_cancel_supplier_invoice 5910 5903 7 0.11 2 25220 740 0 7
sp_cancel_supplier_order 391 391 0 0.00 5 911759 95113 0 0
sp_cancel_write_off 8975 8975 0 0.00 1 10881 111 0 0
sp_client_order 21763 21763 0 0.00 3 20002 351 0 0
sp_customer_reserve 467029 467029 0 0.00 0 36192 167 0 0
sp_fill_shopping_cart 33349 33349 0 0.00 1 44873 43 0 0
sp_fill_shopping_cart_clo_res 467012 467012 0 0.00 0 16145 14 0 0
sp_get_clo_for_invoice 5178 5178 0 0.00 0 25087 311 0 0
sp_kill_cost_storno 15472 15472 0 0.00 0 7483 53 0 0
sp_kill_qstorno_ret_qs2qd 1066971 1066971 0 0.00 0 44885 31 0 0
sp_kill_qty_storno 564128 564128 0 0.00 0 44888 67 0 0
sp_lock_selected_doc 21818 21818 0 0.00 0 10552 4 0 0
sp_make_cost_storno 29470 29470 0 0.00 0 31379 54 0 0
sp_multiply_rows_for_pdistr 29470 29470 0 0.00 0 6891 27 0 0
sp_multiply_rows_for_qdistr 21763 21763 0 0.00 0 15840 156 0 0
sp_pay_from_customer 7551 7551 0 0.00 4 15637 127 0 0
sp_pay_to_supplier 6148 6148 0 0.00 5 17092 155 0 0
sp_payment_common 13699 13699 0 0.00 1 13323 36 0 0
sp_qd_handle_on_cancel_clo 1899 1899 0 0.00 0 9328 296 0 0
sp_qd_handle_on_invoice_upd_sts 10516 10516 0 0.00 0 19352 323 0 0
sp_qd_handle_on_reserve_upd_sts 10593 10593 0 0.00 0 22677 61 0 0
sp_reserve_write_off 10593 10593 0 0.00 6 22817 185 0 0
sp_supplier_invoice 5715 5715 0 0.00 5 106541 3439 0 0
sp_supplier_order 5878 5878 0 0.00 4 32248 1229 0 0
srv_aggregate_perf_data 102 102 0 0.00 2554 165279 16636 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1537 152205 34265 0 0
srv_find_qd_qs_mism 1031821 1031821 0 0.00 0 14920 5 0 0
srv_make_invnt_saldo 593 593 0 0.00 26 77496 1108 0 0
srv_make_money_saldo 889 889 0 0.00 1 765 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 128182 359736 210645 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5195 5195 0 0.00 0 8843 136 0 0
t$perf-norm:sp_cancel_adding_invoice 465 465 0 0.00 0 3600 104 0 0
t$perf-norm:sp_cancel_client_order 1899 1899 0 0.00 0 2353 13 0 0
t$perf-norm:sp_cancel_customer_reserve 740 740 0 0.00 0 3304 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 718 718 0 0.00 0 2970 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 441 441 0 0.00 0 2339 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 5573 32 0 0
t$perf-norm:sp_cancel_supplier_order 391 391 0 0.00 0 22284 1481 0 0
t$perf-norm:sp_cancel_write_off 1008 1008 0 0.00 0 2514 8 0 0
t$perf-norm:sp_client_order 21763 21763 0 0.00 0 12830 16 0 0
t$perf-norm:sp_customer_reserve 1068 1068 0 0.00 0 970 6 0 0
t$perf-norm:sp_pay_from_customer 7551 7551 0 0.00 0 11078 15 0 0
t$perf-norm:sp_pay_to_supplier 6148 6148 0 0.00 0 4420 9 0 0
t$perf-norm:sp_reserve_write_off 10593 10593 0 0.00 0 8659 10 0 0
t$perf-norm:sp_supplier_invoice 5715 5715 0 0.00 0 3385 15 0 0
t$perf-norm:sp_supplier_order 5878 5878 0 0.00 0 4835 17 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 488 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 146 4 0 0
t$perf-norm:srv_make_invnt_saldo 593 593 0 0.00 0 1942 19 0 0
t$perf-norm:srv_make_money_saldo 889 889 0 0.00 0 2547 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 10622 10354 268 2.52 0 6052 23 0 268
v_all_customers 39948 39948 0 0.00 0 21 1 0 0
v_all_suppliers 32062 32062 0 0.00 0 23 1 0 0
v_all_wares 43526 43526 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 930 930 0 0.00 0 2822 12 0 0
v_cancel_client_order 3798 3798 0 0.00 0 5424 8 0 0
v_cancel_customer_prepayment 1436 1436 0 0.00 0 4090 20 0 0
v_cancel_customer_reserve 1480 1480 0 0.00 0 1840 8 0 0
v_cancel_payment_to_supplier 882 882 0 0.00 0 3347 13 0 0
v_cancel_supplier_invoice 786 772 14 1.78 0 1485 19 0 14
v_cancel_supplier_order 782 782 0 0.00 0 2273 10 0 0
v_cancel_write_off 2016 2016 0 0.00 0 3793 21 0 0
v_max_id_clo_ord 5877 5877 0 0.00 0 959 1 0 0
v_max_id_clo_res 1068 1068 0 0.00 0 2110 16 0 0
v_max_id_ord_sup 5708 5708 0 0.00 0 10312 8 0 0
v_max_non_paid_invoice 1702 1702 0 0.00 0 6789 7 0 0
v_max_non_paid_realizn 4004 4004 0 0.00 0 5186 8 0 0
v_min_id_clo_ord 5877 5877 0 0.00 0 3254 7 0 0
v_min_id_clo_res 1068 1068 0 0.00 0 7020 19 0 0
v_min_id_ord_sup 5708 5708 0 0.00 0 10048 11 0 0
v_min_non_paid_invoice 6148 6148 0 0.00 0 10386 26 0 0
v_min_non_paid_realizn 7551 7551 0 0.00 0 13319 22 0 0
v_our_firm 10672 10672 0 0.00 0 19 1 0 0
v_reserve_write_off 21186 21186 0 0.00 0 5399 9 0 0
x_lock_depdocs_on_canc_invoice 10855 10855 0 0.00 0 10959 110 0 0
x_lock_depdocs_on_canc_sup_ord 391 391 0 0.00 0 17203 404 0 0
x_make_qstorno_1000_1200 5878 5878 0 0.00 2 31917 1150 0 0
x_make_qstorno_1200_2000 5715 5715 0 0.00 3 106368 3272 0 0
x_make_qstorno_2100_3300 467029 467029 0 0.00 0 36190 151 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 31-01-2021 22:28:31 to 31-01-2021 22:28:36.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:20 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:26 19961 8192000000 10258302144 10568953856 909112352 9.989 72 55 109 0 930140176 2695600 18332224
19:57:55 24413 8192000000 10347682592 10664902656 1395296640 14.553 100 84 168 0 1432431536 9023600 28111296
19:58:29 23769 8192000000 10382246208 10704130048 1427894768 14.843 100 85 170 0 1462588752 6697744 27996240
19:59:07 23572 8192000000 10418996256 10746953728 1471362448 15.226 100 89 179 0 1507881680 7622928 28896304
19:59:40 23225 8192000000 10443163456 10775027712 1493948656 15.423 100 89 178 1 1530616336 8350208 28317472
20:00:12 26487 8192000000 10462048048 10798440448 1513034992 15.590 100 85 170 0 1548924464 8742544 27146928
20:00:46 9946 8192000000 10476979488 10813612032 1531365984 15.749 100 88 176 0 1568297248 9171696 27759568
20:01:07 20817 8192000000 10488021264 10832150528 1546186640 15.877 100 88 176 0 1583737408 9724160 27826608
20:01:35 12188 8192000000 10510420288 10854719488 1561592800 16.010 100 79 158 0 1595677968 9624304 24460864
20:01:54 17583 8192000000 10539079696 10891104256 1590189264 16.255 100 83 167 0 1625740832 9940112 25611456
20:02:20 14961 8192000000 10564347536 10921005056 1618738080 16.499 100 78 154 1 1652074848 10188432 23148336
20:02:48 14850 8192000000 10592910128 10953125888 1648165536 16.749 100 77 154 3 1681607344 10403744 23038064
20:03:09 10477 8192000000 10600949920 10966327296 1662681760 16.871 100 73 146 1 1695058832 10818928 21558144
20:03:32 11168 8192000000 10622347088 10989285376 1686687600 17.074 100 81 163 1 1721815776 11876096 23252080
20:03:52 10535 8192000000 10644802640 11015979008 1705523328 17.231 100 72 144 0 1737415808 11374320 20518160
20:04:10 9061 8192000000 10664467296 11036364800 1723471664 17.381 100 80 158 2 1759381728 12448432 23461632
20:04:29 9110 8192000000 10672123648 11046924288 1732568672 17.457 100 78 156 1 1768071392 12750464 22752256
20:04:46 8155 8192000000 10674691888 11053465600 1741912768 17.535 100 74 147 3 1775216880 12711408 20592704
20:05:01 5987 8192000000 10681393632 11059994624 1745545968 17.565 100 80 161 0 1780486160 13314928 21625264
20:05:15 8343 8192000000 10703524016 11083177984 1761500112 17.697 100 83 165 3 1798495280 13382528 23612640
20:05:30 4428 8192000000 10713681632 11093184512 1773338608 17.795 100 84 163 3 1809868496 13292224 23237664
20:05:41 4411 8192000000 10717067632 11098468352 1783546864 17.879 100 83 166 0 1820804016 13714256 23542896
20:05:54 6508 8192000000 10715233168 11103494144 1784017808 17.883 100 76 153 3 1819990096 14578272 21394016
20:06:08 2687 8192000000 10736459360 11120222208 1794390512 17.968 100 81 161 1 1831895616 14613536 22891568
20:06:18 3230 8192000000 10748586784 11135320064 1805569856 18.060 100 77 154 1 1839451184 12343168 21538160
20:06:28 3050 8192000000 10756727840 11141128192 1812672592 18.118 100 82 165 2 1847586800 11836048 23078160
20:06:38 3213 8192000000 10765459760 11148722176 1819664912 18.175 100 74 147 0 1851586816 11389344 20532560
20:06:48 2051 8192000000 10763971424 11151872000 1826900304 18.234 100 84 167 1 1863462992 12936832 23625856
20:06:57 2897 8192000000 10779797728 11165667328 1835751664 18.306 100 88 174 1 1875240128 14205888 25282576
20:07:06 2359 8192000000 10766850160 11156045824 1839521904 18.337 100 85 167 3 1875501904 13015936 22964064
20:07:15 2451 8192000000 10786401936 11171192832 1842519936 18.361 100 84 166 2 1880366416 13339856 24506624
20:07:24 1942 8192000000 10793706656 11176308736 1846145824 18.391 100 93 185 0 1886063680 13698480 26219376
20:07:32 2375 8192000000 10794280400 11178729472 1850170160 18.424 100 85 168 1 1887026496 12969808 23886528
20:07:41 1930 8192000000 10791159488 11182919680 1854907184 18.462 100 87 176 1 1892509040 12719536 24882320
20:07:49 1886 8192000000 10798243248 11188248576 1860050848 18.504 100 94 188 1 1899514832 11648736 27815248
20:07:57 2047 8192000000 10804070624 11192807424 1863993888 18.536 100 93 181 2 1901992384 11819216 26179280
20:08:06 3964 8192000000 10810438064 11197972480 1866028288 18.552 100 88 180 4 1903685424 12353968 25303168
20:08:16 1674 8192000000 10818531168 11206111232 1868762944 18.574 100 93 187 1 1909460560 13697824 26999792
20:08:25 2728 8192000000 10799144720 11200901120 1865820688 18.550 100 66 132 2 1897805136 13239664 18744784
20:08:35 7123 8192000000 10792210112 11193368576 1866862192 18.559 100 46 92 2 1888325536 8784624 12678720
20:08:49 3332 8192000000 10793278928 11200147456 1869688176 18.582 100 60 120 0 1897766160 11248320 16829664
20:08:59 4071 8192000000 10793679648 11204136960 1870373872 18.587 100 55 108 2 1895878240 10260832 15243536
20:09:10 3488 8192000000 10784910576 11204321280 1871967600 18.600 100 48 97 0 1894283312 8450672 13865040
20:09:20 9528 8192000000 10780743936 11200626688 1868530368 18.572 100 22 44 0 1881802384 6400384 6871632
20:09:36 8559 8192000000 10799891216 11212308480 1877028528 18.641 100 39 79 0 1895045936 7599424 10417984
20:09:52 5702 8192000000 10783739152 11211128832 1876830208 18.640 100 35 71 0 1894671392 8853280 8987904
20:10:06 59919 8192000000 10797252624 11221032960 1882321616 18.684 100 41 82 1 1899546752 4757616 12467520
20:11:12 11872 8192000000 10794324128 11228090368 1882741296 18.687 100 31 62 1 1900027392 7727696 9558400
20:11:32 5944 8192000000 10803456784 11228508160 1880126912 18.666 100 20 40 0 1891469696 5522608 5820176
20:11:45 7541 8192000000 10796498544 11227627520 1883890784 18.697 100 24 48 2 1897702864 7102160 6709920
20:11:58 6040 8192000000 10805364624 11231129600 1887067216 18.722 100 30 59 1 1902600192 6951872 8581104
20:12:10 8477 8192000000 10797281952 11230900224 1889522544 18.742 100 22 43 1 1902274576 5786112 6965920
20:12:25 11900 8192000000 10800936944 11236634624 1890459568 18.749 100 19 38 1 1901353136 5574384 5319184
20:12:46 10249 8192000000 10799640816 11239583744 1892498880 18.766 100 21 42 1 1905207088 7005296 5702912
20:13:02 9184 8192000000 10806404016 11241115648 1896496160 18.798 100 21 42 0 1908429184 5342896 6590128
20:13:25 9893 8192000000 10814938224 11248553984 1901967344 18.842 100 21 40 3 1914002384 6068928 5966112
20:13:43 10577 8192000000 10823951168 11255050240 1902671616 18.848 100 17 34 1 1913012736 5706912 4634208
20:14:03 9157 8192000000 10815826384 11251625984 1904104560 18.859 100 14 28 3 1913793472 5202992 4485920
20:14:19 5793 8192000000 10818439184 11253805056 1904216368 18.860 100 17 32 3 1914522592 5670992 4635232
20:14:38 13172 8192000000 10818635664 11257380864 1905418560 18.870 100 14 28 0 1915200768 5356352 4425856
20:15:01 25652 8192000000 10815820544 11253956608 1910490384 18.911 100 25 50 1 1923991984 5172704 8328896
20:15:42 42763 8192000000 10813477872 11250520064 1890574688 18.750 99 33 66 1 1905858864 5573600 9710576
20:16:31 10279 8192000000 10814874352 11249225728 1885629200 18.711 99 13 24 2 1894366512 5140112 3597200
20:16:48 6336 8192000000 10803361568 11241918464 1882209728 18.683 99 25 50 1 1896686000 6219872 8256400
20:17:01 5231 8192000000 10820076208 11238883328 1876612080 18.638 99 37 71 1 1893080688 6707328 9761280
20:17:13 4770 8192000000 10797695200 11233501184 1889423360 18.741 100 27 54 0 1902911328 5774640 7713328
20:17:24 9571 8192000000 10770740320 11202609152 1848618784 18.411 99 29 59 0 1867145936 10244816 8282336
20:17:43 5947 8192000000 10792064832 11213189120 1867934896 18.568 100 34 68 1 1885310656 7215360 10160400
20:17:57 10980 8192000000 10742118800 11168079872 1799972720 18.014 98 28 56 2 1813796720 5197792 8626208
20:18:16 10294 8192000000 10732795152 11155951616 1779389936 17.844 97 18 35 1 1789692896 5006144 5296816
20:18:37 6524 8192000000 10748298160 11175620608 1830014480 18.259 100 27 54 0 1844864832 5664320 9186032
20:18:53 6574 8192000000 10738239584 11151552512 1738578528 17.507 94 30 60 0 1752503808 5052944 8872336
20:19:08 7078 8192000000 10707668352 11127033856 1723875200 17.385 95 15 30 1 1733766304 5767072 4124032
20:19:28 19528 8192000000 10666573344 11082260480 1664086768 16.883 93 21 43 1 1675734752 5311728 6336256
20:19:54 13505 8192000000 10686416720 11101564928 1711881056 17.284 96 25 51 1 1728863232 9839184 7142992
20:20:13 47018 8192000000 10701316784 11107155968 1735087008 17.478 97 43 86 1 1753697520 5875328 12735184
20:21:14 16302 8192000000 10715290800 11094536192 1746360592 17.571 97 66 134 2 1772642288 5954176 20327520
20:21:36 11511 8192000000 10708431552 11122892800 1774809648 17.807 99 22 44 1 1787760896 6688976 6262272
20:21:57 12315 8192000000 10706572880 11120525312 1757594560 17.664 98 29 59 0 1771629600 6183792 7851248
20:22:17 8007 8192000000 10725186032 11137196032 1761734912 17.699 97 33 66 0 1781479680 10191264 9553504
20:22:36 4402 8192000000 10734532416 11151441920 1815405712 18.140 100 38 74 0 1832300720 6578512 10316496
20:22:48 8759 8192000000 10719722384 11144781824 1789109408 17.924 98 33 66 2 1805680000 7392656 9177936
20:23:05 11602 8192000000 10726187728 11154411520 1805910304 18.062 99 24 48 4 1818053840 5440592 6702944
20:23:23 9840 8192000000 10741585744 11168018432 1829365264 18.254 100 25 49 3 1842207152 5805488 7036400
20:23:39 10231 8192000000 10754229872 11184263168 1842242704 18.359 100 22 44 1 1854191088 5486976 6461408
20:24:04 9581 8192000000 10764670176 11189538816 1831692640 18.273 99 24 47 0 1843833840 5432640 6708560
20:24:22 11293 8192000000 10763368560 11194281984 1849878112 18.421 100 18 35 2 1861212064 5515408 5818544
20:24:42 7350 8192000000 10755700432 11190415360 1851752064 18.436 100 18 36 0 1862944416 6072544 5119808
20:24:55 10961 8192000000 10773999632 11201654784 1855852992 18.470 100 20 40 2 1867123632 5581872 5688768
20:25:13 21862 8192000000 10788119408 11209859072 1863065104 18.528 100 22 42 1 1875642320 5565040 7012176
20:25:41 50230 8192000000 10806944992 11221368832 1873823808 18.615 100 53 106 3 1895606416 6168640 15613968
20:26:41 12792 8192000000 10774780720 11210383360 1868485360 18.572 100 20 39 2 1879984576 5382480 6116736
20:27:02 6568 8192000000 10791656576 11222196224 1884554224 18.702 100 25 51 1 1896039184 4798144 6686816
20:27:15 10038 8192000000 10829581280 11241795584 1896829856 18.801 100 43 86 2 1914896016 5949392 12116768
20:27:31 9865 8192000000 10835513488 11255148544 1909030160 18.899 100 49 97 0 1930670528 7780224 13860144
20:27:54 40580 8192000000 10842705216 11268222976 1913898000 18.938 100 38 76 1 1933390176 8770272 10721904
20:28:46 8938 8192000000 10852740096 11277045760 1924491680 19.023 100 43 86 2 1946638640 10490576 11656384
20:29:03 9872 8192000000 10852584720 11281883136 1930638240 19.072 100 46 90 2 1954033280 10682464 12712576
20:29:22 39045 8192000000 10871087888 11302662144 1938091776 19.132 100 43 85 1 1961259424 11497712 11669936
20:30:20 19053 8192000000 10884587376 11314683904 1947968416 19.210 100 46 92 3 1974129936 12758768 13402752
20:30:50 14645 8192000000 10884791184 11312975872 1953921408 19.258 100 38 76 1 1977585344 13167136 10496800
20:31:12 13019 8192000000 10887234912 11319926784 1958608448 19.295 100 51 102 0 1986807200 13396128 14802624
20:31:39 8524 8192000000 10902130192 11332702208 1966186032 19.355 100 50 98 1 1994623280 14346768 14090480
20:31:56 12575 8192000000 10901927520 11336368128 1969616656 19.382 100 55 110 2 2000346496 14386384 16343456
20:32:19 15497 8192000000 10906087792 11340320768 1973467808 19.413 100 51 102 1 2001750080 13263968 15018304
20:32:56 38117 8192000000 10902815280 11348357120 1975524048 19.429 100 29 58 1 2000925760 16006592 9395120
20:33:44 21094 8192000000 10911871296 11352555520 1980855696 19.471 100 40 80 0 2006437424 13706768 11874960
20:34:13 33881 8192000000 10931147248 11367964672 1990491104 19.548 100 48 95 0 2023086240 18077760 14517376
20:34:54 3382 8192000000 10937704064 11370860544 1996717840 19.597 100 76 153 0 2035036112 16103328 22214944
20:35:05 13772 8192000000 10938790240 11373498368 1996972768 19.599 100 60 120 1 2031503120 16909360 17620992
20:35:26 13349 8192000000 10950676144 11383803904 2000302384 19.625 100 63 126 1 2039709856 21150192 18257280
20:35:48 6893 8192000000 10946397248 11380191232 2002510384 19.643 100 63 126 1 2039503136 18268336 18724416
20:36:25 6897 8192000000 10963492336 11393867776 2012644896 19.722 100 69 140 3 2052095776 18700000 20750880
20:36:48 1535 8192000000 10972929104 11400331264 2018306512 19.767 100 75 151 2 2060700960 19713040 22681408
20:36:56 4197 8192000000 10973281808 11400503296 2020813264 19.787 100 73 146 0 2064918720 22807280 21298176
20:37:12 5312 8192000000 10973658736 11407605760 2020206048 19.782 100 64 128 0 2063711824 24438416 19067360
20:37:26 11248 8192000000 10960359440 11396423680 2004789648 19.660 99 58 116 0 2045643840 23948176 16906016
20:37:47 6851 8192000000 10980422624 11411066880 2021300720 19.790 100 71 142 1 2067927040 24657360 21968960
20:38:00 2202 8192000000 10955031648 11372556288 1975746352 19.431 98 72 144 4 2023820176 25668320 22405504
20:38:13 2265 8192000000 10960053824 11390615552 2006711360 19.676 100 57 109 1 2048194896 25077888 16405648
20:38:22 4177 8192000000 10939744064 11369816064 1985159520 19.506 99 57 114 1 2028196624 25561712 17475392
20:38:34 4439 8192000000 10965054464 11396059136 2006480912 19.674 100 68 135 3 2053310176 26833824 19995440
20:38:47 2687 8192000000 10953300512 11386249216 1987211984 19.522 99 58 115 2 2032401056 27436768 17752304
20:38:57 3935 8192000000 10973801344 11399561216 2005798880 19.668 100 75 150 0 2056950736 28619008 22532848
20:39:09 6458 8192000000 10976217392 11404697600 2012367296 19.720 100 68 135 3 2061437360 28186928 20883136
20:39:23 1892 8192000000 10977482944 11404726272 2012072656 19.718 100 64 128 4 2061543760 29347168 20123936
20:39:32 1905 8192000000 10950782288 11366330368 1973304720 19.412 98 76 152 0 2027256768 30182288 23769760
20:39:44 2549 8192000000 10979738880 11400306688 2007012240 19.678 100 77 152 2 2062096768 31718352 23366176
20:39:54 1787 8192000000 10979594752 11401981952 2007731600 19.684 100 81 161 2 2065879200 33532944 24614656
20:40:04 7581 8192000000 10972935440 11405996032 2007167360 19.679 100 75 149 2 2065960352 35662096 23130896
20:40:21 5317 8192000000 10992399648 11417288704 2014016896 19.733 100 85 169 0 2077471072 36152432 27301744
20:40:35 9555 8192000000 10970192000 11407462400 2005799392 19.668 100 69 137 0 2063482976 36497216 21186368
20:40:53 3450 8192000000 10933161152 11355262976 1958901104 19.297 99 77 154 1 2016618224 33696048 24021072
20:41:11 6679 8192000000 10933758096 11345997824 1956164864 19.276 100 67 132 5 2004872544 29080896 19626784
20:41:27 2789 8192000000 10941336000 11359895552 1965487472 19.350 100 81 163 0 2023405152 33432544 24485136
20:41:37 4885 8192000000 10936117744 11362746368 1967972896 19.369 100 73 147 0 2025457456 34972288 22512272
20:41:48 1922 8192000000 10943321936 11365937152 1975224944 19.427 100 83 166 0 2035874944 35331392 25318608
20:41:57 8731 8192000000 10965927216 11388133376 1987635680 19.525 100 82 162 2 2051000128 38073216 25291232
20:42:14 2246 8192000000 10973097408 11386859520 1991004032 19.552 100 90 180 3 2051773392 33972720 26796640
20:42:24 3456 8192000000 10974741920 11386888192 1986558304 19.517 100 80 161 1 2049927792 39189760 24179728
20:42:35 1551 8192000000 10971848352 11381641216 1984617168 19.501 100 90 180 1 2052277440 39690544 27969728
20:42:43 3375 8192000000 10955032064 11370975232 1956208848 19.276 99 77 154 1 2020157232 40550544 23397840
20:42:55 5928 8192000000 10961300768 11387236352 1982163600 19.482 100 67 134 2 2042959648 40248096 20547952
20:43:07 3531 8192000000 10965368384 11383533568 1966886288 19.361 99 84 167 0 2034562112 41373504 26302320
20:43:18 1648 8192000000 10970126464 11376472064 1978705872 19.454 100 93 182 0 2043561328 36714752 28140704
20:43:26 6062 8192000000 10959453840 11373502464 1975262864 19.427 100 80 160 1 2038748576 39090048 24395664
20:43:41 4932 8192000000 10962842640 11386499072 1984968656 19.504 100 77 154 0 2049529280 40583760 23976864
20:43:53 15342 8192000000 10949738384 11384459264 1982967584 19.488 100 44 89 0 2031366848 34143216 14256048
20:44:17 16546 8192000000 10900653136 11347365888 1905180480 18.868 97 33 66 1 1952681552 35700560 11800512
20:44:40 13186 8192000000 10914854720 11337773056 1914423808 18.942 98 41 82 3 1957724208 29647568 13652832
20:45:02 4420 8192000000 10927015184 11353460736 1958477728 19.294 100 70 139 2 2012154560 32249072 21427760
20:45:13 2672 8192000000 10942746688 11358306304 1965588400 19.350 100 74 149 1 2018511744 30658064 22265280
20:45:23 8203 8192000000 10917741856 11367297024 1967038352 19.362 100 35 70 0 2009938416 31413456 11486608
20:45:41 8668 8192000000 10900778112 11342106624 1931245104 19.077 98 35 69 2 1972941280 30422384 11273792
20:46:02 9403 8192000000 10907570912 11342954496 1945742784 19.193 100 42 85 0 1993528704 33866288 13919632
20:46:21 2993 8192000000 10915214896 11330424832 1925344000 19.030 99 86 172 2 1987482272 35608240 26530032
20:46:34 5007 8192000000 10918857648 11338616832 1939069680 19.139 100 67 132 0 1994849328 35553248 20226400
20:46:47 7100 8192000000 10899387216 11343351808 1942452528 19.166 100 48 96 2 1994254448 36858192 14943728
20:47:15 6654 8192000000 10899746528 11328860160 1908784784 18.897 98 42 84 3 1958583680 35776304 14022592
20:47:33 15618 8192000000 10884427776 11325685760 1904630992 18.864 98 29 58 1 1949202896 34881904 9690000
20:47:55 16587 8192000000 10909844080 11337752576 1924827536 19.025 99 41 82 5 1972418848 34696928 12894384
20:48:35 18909 8192000000 10898563296 11332665344 1928969232 19.059 100 31 62 2 1975672176 35461584 11241360
20:49:01 3014 8192000000 10938386096 11346190336 1931003376 19.075 99 74 142 0 1992076480 38502544 22570560
20:49:12 2458 8192000000 10931492896 11340664832 1945972352 19.194 100 80 159 1 2009764432 39926752 23865328
20:49:21 7111 8192000000 10930265520 11362152448 1960672896 19.311 100 68 134 2 2026986864 44941408 21372560
20:49:37 17574 8192000000 10918561104 11362803712 1953477232 19.254 100 27 54 0 2005685408 43233616 8974560
20:50:02 14925 8192000000 10907578320 11348226048 1913869504 18.938 98 34 68 1 1966051728 40409616 11772608
20:50:26 23443 8192000000 10913478032 11353718784 1926023312 19.035 99 35 70 0 1981136608 43271456 11841840
20:50:58 7881 8192000000 10899264240 11342508032 1925286352 19.029 99 36 71 5 1976795824 39395520 12113952
20:51:18 19851 8192000000 10905046672 11356196864 1942743232 19.169 100 30 60 2 1992063888 39078192 10242464
20:51:46 22813 8192000000 10889257904 11344723968 1917399200 18.966 99 31 62 1 1963417120 36174336 9843584
20:52:36 31981 8192000000 10864390656 11317014528 1901839008 18.841 99 19 38 2 1946038352 37223072 6976272
20:53:26 35604 8192000000 10869831808 11326259200 1911187856 18.916 99 29 58 0 1956189584 34991952 10009776
20:54:31 57156 8192000000 10847282816 11309019136 1902415408 18.846 99 22 45 0 1932242432 22620752 7206272
20:55:38 11120 8192000000 10877617008 11319476224 1925720640 19.033 100 40 81 1 1956553712 18133280 12699792
20:56:00 38116 8192000000 10868205856 11327602688 1931950928 19.082 100 26 52 2 1961111568 20758896 8401744
20:56:53 40773 8192000000 10851467488 11312406528 1905759328 18.873 98 26 52 0 1925920000 13015536 7145136
20:57:44 41299 8192000000 10852022480 11310116864 1915782704 18.953 99 13 28 0 1930269968 10295792 4191472
20:58:31 38081 8192000000 10829498256 11287511040 1875965280 18.633 97 16 32 0 1896921488 16151776 4804432
20:59:34 54966 8192000000 10837181184 11291455488 1850167712 18.423 96 26 48 0 1872327152 15192960 6966480
21:01:11 79799 8192000000 10860631024 11323121664 1891706224 18.760 98 21 43 0 1919067664 21322496 6038944
21:02:37 77636 8192000000 10858424160 11307831296 1926988048 19.043 100 35 69 1 1950708512 12635616 11084848
21:04:06 51434 8192000000 10884655120 11318849536 1932634016 19.088 100 38 75 2 1952794064 10309168 9850880
21:05:08 70252 8192000000 10875347792 11323707392 1911490000 18.919 98 29 59 1 1928006112 8029104 8487008
21:06:25 37653 8192000000 10879385904 11323473920 1908270672 18.893 98 26 53 1 1926949296 11081520 7597104
21:07:14 31095 8192000000 10884681040 11341541376 1952796432 19.249 100 41 77 1 1974358112 9799040 11762640
21:08:03 64013 8192000000 10903227264 11360354304 1966428416 19.357 100 34 69 2 1994881632 18494416 9958800
21:09:13 52870 8192000000 10913638832 11369992192 1980708224 19.470 100 23 46 1 2001776048 14017648 7050176
21:10:15 20771 8192000000 10925842016 11374927872 1989730048 19.542 100 25 51 0 2010396672 12751088 7915536
21:10:42 16933 8192000000 10921868016 11378565120 1997570432 19.604 100 37 74 0 2024146528 15139056 11437040
21:11:10 26956 8192000000 10927021408 11387781120 1995383872 19.586 100 26 52 1 2020061136 16354000 8323264
21:11:46 49086 8192000000 10920631008 11384467456 1975941632 19.433 99 25 50 0 2002814576 19013664 7859280
21:12:49 60337 8192000000 10897395408 11385356288 1979926480 19.464 100 21 42 2 2008832912 22119584 6786848
21:14:04 43017 8192000000 10890036656 11377602560 1972321072 19.404 100 8 16 0 1987074912 13093072 1660768
21:14:57 36483 8192000000 10892220048 11372871680 1979660912 19.462 100 15 31 1 1996930544 13908960 3360672
21:15:40 79721 8192000000 10904966608 11378651136 1966356048 19.357 99 15 31 0 1978699088 8090720 4252320
21:17:10 68561 8192000000 10901062112 11372797952 1967658448 19.367 99 16 32 0 1983852352 11041104 5152800
21:18:27 119516 8192000000 10904191200 11372716032 1912051216 18.923 96 22 44 1 1933603568 15412272 6140080
21:20:55 31366 8192000000 10884663376 11351584768 1941269904 19.157 98 29 56 0 1962980864 12709760 9001200
21:21:38 39640 8192000000 10873503616 11344080896 1928912000 19.058 98 16 32 1 1941953184 8801424 4239760
21:22:30 76040 8192000000 10891814064 11375022080 1975824016 19.432 100 12 24 0 1988667808 9201120 3642672
21:23:53 86319 8192000000 10889951664 11368583168 1944185088 19.180 98 14 28 0 1956641472 8654320 3802064
21:25:29 70409 8192000000 10899979536 11395420160 1989071536 19.536 100 13 26 0 2004399344 11575504 3752304
21:26:52 25064 8192000000 10925965552 11381325824 1949433200 19.222 98 17 34 0 1966105680 11714176 4958304
21:27:23 29475 8192000000 10906390512 11369054208 1929818288 19.065 97 34 68 1 1947222240 8012608 9391344
21:28:02 58693 8192000000 10882556528 11362791424 1898097904 18.811 96 18 36 1 1914625024 11605776 4921344
21:29:31 89738 8192000000 10900932048 11367428096 1892900608 18.769 96 8 16 0 1910077040 14970240 2206192
21:31:10 59048 8192000000 10896772576 11361398784 1914627888 18.944 97 17 34 0 1930940096 11798960 4513248
21:33:07 84522 8192000000 10857932816 11315892224 1821199776 18.187 93 22 44 1 1837994832 10839664 5955392
21:34:37 22719 8192000000 10879710624 11338776576 1932848592 19.090 100 24 48 2 1949356640 9997408 6510640
21:35:07 35454 8192000000 10896169840 11360141312 1956948192 19.282 100 20 40 1 1975465664 12984624 5532848
21:35:50 90882 8192000000 10871763456 11332050944 1835871104 18.307 94 14 28 1 1850886768 11402576 3613088
21:37:28 59783 8192000000 10855883744 11336507392 1900094832 18.827 98 16 31 2 1918993696 13701232 5197632
21:38:43 152205 8192000000 10834930464 11314700288 1720919408 17.360 89 13 24 1 1743755936 18798944 4037584
21:41:22 117033 8192000000 10854315872 11323379712 1900723680 18.832 98 8 16 0 1913694048 10742576 2227792
21:43:25 90584 8192000000 10847994224 11313913856 1855008592 18.463 96 24 48 1 1870128880 8673792 6446496
21:45:07 105754 8192000000 10867101232 11330506752 1905721856 18.872 98 26 52 1 1929948304 16560064 7666384
21:47:30 78406 8192000000 10810941088 11293106176 1829893296 18.258 95 14 29 0 1841786592 7787200 4106096
21:48:55 48688 8192000000 10823186816 11299905536 1892924416 18.769 99 8 14 1 1903972272 8696464 2351392
21:49:50 35593 8192000000 10858848768 11314352128 1901977456 18.842 99 14 28 0 1913347040 7280832 4088752
21:50:34 64605 8192000000 10858265248 11329998848 1923147024 19.012 99 12 24 1 1934180112 7743200 3289888
21:51:44 89274 8192000000 10875934528 11344244736 1946321888 19.197 100 17 34 2 1961342224 9837200 5183136
21:54:21 40911 8192000000 10861806784 11341942784 1946511088 19.199 100 10 20 3 1960001952 10195776 3295088
21:55:08 57165 8192000000 10857239008 11341950976 1909821104 18.905 98 16 33 0 1926757072 12249472 4686496
21:56:18 42267 8192000000 10864503200 11336024064 1927896608 19.050 99 23 46 0 1944194768 9592384 6705776
21:57:09 54972 8192000000 10862242240 11296272384 1879262960 18.659 96 32 65 3 1895763328 7925840 8574528
21:58:13 13724 8192000000 10902809440 11353182208 1961792880 19.320 100 46 92 2 1982670400 6969088 13908432
21:58:33 39213 8192000000 10886660512 11360952320 1964731360 19.344 100 23 46 1 1982762480 11879472 6151648
21:59:18 50378 8192000000 10901100896 11374575616 1951718336 19.240 99 18 36 1 1968779232 12125728 4935168
22:00:31 79816 8192000000 10894559696 11357638656 1923887072 19.018 97 29 58 0 1943017856 11107520 8023264
22:02:03 29216 8192000000 10912240448 11370676224 1951141184 19.236 99 29 58 0 1968792512 10082912 7568416
22:02:40 29277 8192000000 10918403200 11375562752 1977918160 19.448 100 38 76 1 2002355168 13830080 10606928
22:03:16 98878 8192000000 10889759840 11372322816 1936873024 19.122 98 22 44 3 1960795984 18086128 5836832
22:05:02 85960 8192000000 10922247664 11368181760 1900677680 18.832 96 35 71 0 1920440528 10121792 9641056
22:06:34 26093 8192000000 10910223152 11372113920 1974725600 19.423 100 39 78 3 1997655728 11418496 11511632
22:07:07 128076 8192000000 10902098784 11371663360 1886836208 18.720 96 15 30 0 1905447424 14882016 3729200
22:09:26 86868 8192000000 10888754624 11366875136 1931520704 19.079 98 19 37 2 1951700304 15073408 5106192
22:12:07 82166 8192000000 10887778032 11363975168 1938516416 19.135 98 17 34 0 1959714320 16113936 5083968
22:13:39 40753 8192000000 10887358048 11371298816 1962793040 19.328 100 6 11 1 1979029376 14548576 1687760
22:14:26 92472 8192000000 10866215120 11340001280 1909853664 18.905 97 9 18 0 1922637152 9791472 2992016
22:16:05 41533 8192000000 10847772080 11313340416 1855099808 18.464 95 7 14 1 1866136528 9308272 1728448
22:17:38 78103 8192000000 10845583344 11305304064 1846983552 18.398 95 16 32 1 1860041712 7922368 5135792
22:19:02 55991 8192000000 10840230000 11307974656 1885310672 18.708 98 10 20 0 1895489088 7458752 2719664
22:20:06 39515 8192000000 10863707776 11332034560 1900781232 18.833 98 21 39 1 1915299168 9007200 5510736
22:20:55 51334 8192000000 10881730176 11345264640 1920217936 18.989 99 11 22 1 1935739216 12379984 3141296
22:21:53 79315 8192000000 10884142656 11353206784 1894082032 18.779 97 7 14 0 1907814064 11801152 1930880
22:23:18 82177 8192000000 10882076000 11349082112 1908102112 18.891 98 21 42 0 1930562384 16242400 6217872
22:24:50 60872 8192000000 10844461168 11317788672 1865665584 18.549 96 27 54 1 1882598896 9680352 7252960
22:26:00 56563 8192000000 10873760320 11335311360 1902913360 18.850 98 25 50 2 1925370320 13810224 8646736
22:27:03 22637 8192000000 9262134000 9532768256 402105120 4.678 21 5 8 1 409076880 5055552 1916208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-01-2021 22:28:37 to 31-01-2021 22:29:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-01-2021 22:29:09 to 31-01-2021 22:29:11.

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          244145
MON$OLDEST_ACTIVE               245565
MON$OLDEST_SNAPSHOT             245565
MON$NEXT_TRANSACTION            245565
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                       2007488
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.33409 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33409 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33409 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33409 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 ---
:48: 
:49: mscs-test-161.budzdorov.ru    Sun Jan 31 22:27:33 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Sun Jan 31 22:27:34 2021
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
--- end of diff output ---

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

31.01.21 22:29:12. 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-01-31 22:29:15 No severe PSQL-related problems occured
31.01.21 22:29:16. End of report.