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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17235260 kB
MemAvailable 31565296 kB
Buffers 0 kB
Cached 14393272 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-09 16:27:19
DTS_END                         2021-03-09 16:27:19.4690
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52314
TRN_ID                          235798
ATT_ID                          625
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: 9914.17 17263 1189701
customer order: creation 171.10 344 20532
customer order: refuse 14.59 326 1751
order to supplier: creation 45.62 1237 5474
order to supplier: removal 3.57 107553 428
invoice (draft): creation 45.08 3310 5409
invoice (draft): removal 59.55 796 7146
invoice accept: apply 41.31 17528 4957
invoice accept: cancel 53.94 716 6473
customer reserve: creation 3884.15 171 466098
customer reserve: removal 5298.37 56 635804
realization accept: apply 81.99 175 9839
realization accept: cancel 86.33 114 10359
payment from customer: creation 59.16 113 7099
payment from customer: removal 5.35 91 642
payment to supplier: creation 48.25 129 5790
payment to supplier: removal 3.68 64 442
service: total inventory turnovers 4.72 1207 567
service: total monetary turnovers 6.53 21 784
service: aggregate perf. data 0.86 17035 103
service: refresh index statistics 0.03 194281 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4407
TEST_TIME 2 3360
TEST_TIME 3 3270
TEST_TIME 4 3181
TEST_TIME 5 3512
TEST_TIME 6 3339
TEST_TIME 7 3597
TEST_TIME 8 4497
TEST_TIME 9 4689
TEST_TIME 10 5320
TEST_TIME 11 5445
TEST_TIME 12 5772
TEST_TIME 13 6199
TEST_TIME 14 6284
TEST_TIME 15 6438
TEST_TIME 16 7004
TEST_TIME 17 7130
TEST_TIME 18 7422
TEST_TIME 19 8022
TEST_TIME 20 8310
TEST_TIME 21 8140
TEST_TIME 22 8223
TEST_TIME 23 8213
TEST_TIME 24 8449
TEST_TIME 25 8725
TEST_TIME 26 8982
TEST_TIME 27 10068
TEST_TIME 28 10503
TEST_TIME 29 11116
TEST_TIME 30 11221
TEST_TIME 31 11078
TEST_TIME 32 10992
TEST_TIME 33 11047
TEST_TIME 34 11092
TEST_TIME 35 11030
TEST_TIME 36 10910
TEST_TIME 37 11193
TEST_TIME 38 10983
TEST_TIME 39 10781
TEST_TIME 40 10700
TEST_TIME 41 10494
TEST_TIME 42 10591
TEST_TIME 43 10678
TEST_TIME 44 10550
TEST_TIME 45 10531
TEST_TIME 46 10478
TEST_TIME 47 10476
TEST_TIME 48 10565
TEST_TIME 49 10425
TEST_TIME 50 10411
TEST_TIME 51 10375
TEST_TIME 52 10259
TEST_TIME 53 10248
TEST_TIME 54 10101
TEST_TIME 55 10137
TEST_TIME 56 10120
TEST_TIME 57 10190
TEST_TIME 58 10258
TEST_TIME 59 10229
TEST_TIME 60 10185
TEST_TIME 61 10225
TEST_TIME 62 10232
TEST_TIME 63 10300
TEST_TIME 64 10327
TEST_TIME 65 10345
TEST_TIME 66 10363
TEST_TIME 67 10379
TEST_TIME 68 10353
TEST_TIME 69 10472
TEST_TIME 70 10453
TEST_TIME 71 10380
TEST_TIME 72 10306
TEST_TIME 73 10244
TEST_TIME 74 10249
TEST_TIME 75 10205
TEST_TIME 76 10182
TEST_TIME 77 10109
TEST_TIME 78 10094
TEST_TIME 79 10119
TEST_TIME 80 10108
TEST_TIME 81 10020
TEST_TIME 82 10028
TEST_TIME 83 10004
TEST_TIME 84 9952
TEST_TIME 85 10016
TEST_TIME 86 9995
TEST_TIME 87 10001
TEST_TIME 88 9978
TEST_TIME 89 10064
TEST_TIME 90 10063
TEST_TIME 91 10079
TEST_TIME 92 10084
TEST_TIME 93 10073
TEST_TIME 94 10137
TEST_TIME 95 10093
TEST_TIME 96 10178
TEST_TIME 97 10236
TEST_TIME 98 10228
TEST_TIME 99 10195
TEST_TIME 100 10147
TEST_TIME 101 10118
TEST_TIME 102 10089
TEST_TIME 103 10091
TEST_TIME 104 10027
TEST_TIME 105 10021
TEST_TIME 106 9969
TEST_TIME 107 9956
TEST_TIME 108 9905
TEST_TIME 109 9969
TEST_TIME 110 9927
TEST_TIME 111 9915
TEST_TIME 112 9950
TEST_TIME 113 9935
TEST_TIME 114 9927
TEST_TIME 115 9922
TEST_TIME 116 9930
TEST_TIME 117 10001
TEST_TIME 118 10012
TEST_TIME 119 9982
TEST_TIME 120 9917

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 09-03-2021 16:28:04 to 09-03-2021 16:28:08.

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 1622514 1622514 0 0.00 0 23644 5 0 0
doc_list_biud 1622512 1622512 0 0.00 0 66724 28 0 0
sp_add_invoice_to_stock 5122 4957 165 3.22 33 188647 17529 0 165
sp_cancel_adding_invoice 6473 6473 0 0.00 5 55344 717 0 0
sp_cancel_client_order 1751 1751 0 0.00 4 14122 327 0 0
sp_cancel_customer_reserve 635804 635804 0 0.00 1 26921 56 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 5724 91 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 3 1678 64 0 0
sp_cancel_supplier_invoice 7161 7146 15 0.20 1 21890 797 0 15
sp_cancel_supplier_order 428 428 0 0.00 11 1244075 107554 0 0
sp_cancel_write_off 10359 10359 0 0.00 1 20148 115 0 0
sp_client_order 20532 20532 0 0.00 3 16836 344 0 0
sp_customer_reserve 466098 466098 0 0.00 0 131555 172 0 0
sp_fill_shopping_cart 31401 31401 0 0.00 1 11866 32 0 0
sp_fill_shopping_cart_clo_res 466093 466093 0 0.00 0 36340 12 0 0
sp_get_clo_for_invoice 4952 4952 0 0.00 0 25105 228 0 0
sp_kill_cost_storno 17916 17916 0 0.00 0 18331 57 0 0
sp_kill_qstorno_ret_qs2qd 1289541 1289541 0 0.00 0 26899 31 0 0
sp_kill_qty_storno 676751 676751 0 0.00 0 66724 66 0 0
sp_lock_selected_doc 20523 20523 0 0.00 0 10422 5 0 0
sp_make_cost_storno 27679 27679 0 0.00 0 10811 47 0 0
sp_multiply_rows_for_pdistr 27679 27679 0 0.00 0 7103 27 0 0
sp_multiply_rows_for_qdistr 20532 20532 0 0.00 0 16824 162 0 0
sp_pay_from_customer 7099 7099 0 0.00 4 30052 113 0 0
sp_pay_to_supplier 5790 5790 0 0.00 5 13284 129 0 0
sp_payment_common 12889 12889 0 0.00 1 30033 27 0 0
sp_qd_handle_on_cancel_clo 1751 1751 0 0.00 0 14117 296 0 0
sp_qd_handle_on_invoice_upd_sts 11424 11424 0 0.00 0 66723 336 0 0
sp_qd_handle_on_reserve_upd_sts 9839 9839 0 0.00 0 17128 58 0 0
sp_reserve_write_off 9839 9839 0 0.00 7 19849 176 0 0
sp_supplier_invoice 5409 5409 0 0.00 7 105308 3310 0 0
sp_supplier_order 5474 5474 0 0.00 5 38082 1237 0 0
srv_aggregate_perf_data 104 103 1 0.96 2631 136234 17036 0 1
srv_fill_mon_cache_memory 160 160 0 0.00 1110 119532 33205 0 0
srv_find_qd_qs_mism 1142655 1142655 0 0.00 0 23204 5 0 0
srv_make_invnt_saldo 567 567 0 0.00 40 101470 1208 0 0
srv_make_money_saldo 784 784 0 0.00 1 385 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 95012 408341 194281 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4957 4957 0 0.00 0 12200 159 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 4181 81 0 0
t$perf-norm:sp_cancel_client_order 1751 1751 0 0.00 0 5293 15 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 1011 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 2667 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 1404 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 796 16 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 21175 1549 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 5516 9 0 0
t$perf-norm:sp_client_order 20532 20532 0 0.00 0 13397 17 0 0
t$perf-norm:sp_customer_reserve 984 984 0 0.00 0 2961 9 0 0
t$perf-norm:sp_pay_from_customer 7099 7099 0 0.00 0 7946 9 0 0
t$perf-norm:sp_pay_to_supplier 5790 5790 0 0.00 0 5103 7 0 0
t$perf-norm:sp_reserve_write_off 9839 9839 0 0.00 0 9456 9 0 0
t$perf-norm:sp_supplier_invoice 5409 5409 0 0.00 0 13299 17 0 0
t$perf-norm:sp_supplier_order 5474 5474 0 0.00 0 7859 19 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 993 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 1864 21 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 5008 34 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 3282 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10230 9900 330 3.22 0 10142 28 0 330
v_all_customers 37718 37718 0 0.00 0 34 1 0 0
v_all_suppliers 30108 30108 0 0.00 0 21 1 0 0
v_all_wares 41064 41064 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 4378 19 0 0
v_cancel_client_order 3502 3502 0 0.00 0 7592 6 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 5713 19 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 2145 7 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 610 3 0 0
v_cancel_supplier_invoice 858 828 30 3.49 0 6059 24 0 30
v_cancel_supplier_order 856 856 0 0.00 0 4249 18 0 0
v_cancel_write_off 1938 1938 0 0.00 0 10776 26 0 0
v_max_id_clo_ord 5473 5473 0 0.00 0 1046 1 0 0
v_max_id_clo_res 984 984 0 0.00 0 2926 14 0 0
v_max_id_ord_sup 5396 5396 0 0.00 0 7705 5 0 0
v_max_non_paid_invoice 1605 1605 0 0.00 0 6564 10 0 0
v_max_non_paid_realizn 3645 3645 0 0.00 0 980 3 0 0
v_min_id_clo_ord 5473 5473 0 0.00 0 4872 8 0 0
v_min_id_clo_res 984 984 0 0.00 0 9853 13 0 0
v_min_id_ord_sup 5396 5396 0 0.00 0 7730 6 0 0
v_min_non_paid_invoice 5790 5790 0 0.00 0 8045 13 0 0
v_min_non_paid_realizn 7099 7099 0 0.00 0 4771 13 0 0
v_our_firm 10254 10254 0 0.00 0 13 1 0 0
v_reserve_write_off 19678 19678 0 0.00 0 16638 11 0 0
x_lock_depdocs_on_canc_invoice 13205 13205 0 0.00 0 14309 96 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 3930 301 0 0
x_make_qstorno_1000_1200 5474 5474 0 0.00 2 38075 1162 0 0
x_make_qstorno_1200_2000 5409 5409 0 0.00 2 105005 3204 0 0
x_make_qstorno_2100_3300 466098 466098 0 0.00 0 131554 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2021 16:28:09 to 09-03-2021 16:28:13.

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
13:57:23 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 13181 8192000000 10199729456 10502205440 811437728 9.012 66 56 113 0 833876096 2584304 19854064
13:57:52 30632 8192000000 10336488976 10648571904 1369799696 14.325 100 86 172 0 1402975344 4687312 28488336
13:58:32 26780 8192000000 10372448560 10699751424 1427367888 14.838 100 84 168 0 1461349328 6389264 27592176
13:59:09 25971 8192000000 10420325264 10750226432 1467882896 15.195 100 85 170 0 1502765504 7513904 27368704
13:59:47 22761 8192000000 10442063504 10773102592 1492261568 15.409 100 90 180 0 1529794464 8747088 28785808
14:00:24 15310 8192000000 10454047088 10785665024 1506082336 15.529 100 91 182 1 1545069808 9434592 29552880
14:00:52 16580 8192000000 10462772304 10799759360 1520446096 15.654 100 88 176 0 1557950368 9808192 27696080
14:01:17 13836 8192000000 10483373888 10822823936 1529460656 15.732 100 91 182 0 1568103184 10342224 28300304
14:01:41 18650 8192000000 10507971808 10854588416 1566424560 16.052 100 85 170 0 1603653840 10612224 26617056
14:02:11 12857 8192000000 10529928672 10882662400 1581046912 16.177 100 75 150 1 1615119280 11062208 23010160
14:02:36 13594 8192000000 10557177184 10911051776 1603096224 16.366 100 79 156 1 1637445296 10610512 23738560
14:02:57 13654 8192000000 10565548448 10925498368 1625153856 16.554 100 73 146 1 1657444272 10550464 21739952
14:03:18 15265 8192000000 10586687632 10951876608 1656027088 16.815 100 74 148 1 1689244720 11650176 21567456
14:03:40 6745 8192000000 10601335152 10971930624 1668362944 16.919 100 73 146 1 1700950592 11427456 21160192
14:03:55 9156 8192000000 10629493424 10994733056 1689614080 17.098 100 85 171 0 1727160256 12328352 25217824
14:04:14 12808 8192000000 10646506400 11018072064 1704920096 17.226 100 75 150 1 1739803104 13278000 21605008
14:04:34 7615 8192000000 10650520912 11028062208 1718221424 17.337 100 78 156 1 1753871520 13138000 22512096
14:04:50 8707 8192000000 10675612432 11049930752 1737430112 17.497 100 83 164 1 1773569648 13144944 22994592
14:05:05 5164 8192000000 10687542208 11062071296 1742166048 17.537 100 78 155 1 1777632016 13524640 21941328
14:05:17 5837 8192000000 10689885248 11070812160 1752844416 17.625 100 76 151 1 1788013264 13952592 21216256
14:05:30 4620 8192000000 10701673184 11080065024 1761956096 17.701 100 83 166 0 1799327040 14377008 22993936
14:05:42 6962 8192000000 10697200608 11079938048 1765338448 17.729 100 76 153 2 1800884832 13610896 21935488
14:05:56 6089 8192000000 10705738832 11087532032 1772040400 17.784 100 74 148 2 1806939536 13584144 21314992
14:06:10 3892 8192000000 10724776704 11114627072 1792578112 17.953 100 75 147 1 1825519456 11166896 21774448
14:06:22 3916 8192000000 10745250416 11127234560 1806312640 18.066 100 83 166 1 1843458768 13492768 23653360
14:06:33 3011 8192000000 10758339408 11143741440 1814851200 18.136 100 82 164 1 1855298704 17224064 23223440
14:06:43 3609 8192000000 10761750928 11147173888 1821145904 18.187 100 79 159 1 1855325408 11948048 22231456
14:06:53 3241 8192000000 10769327664 11156439040 1830365088 18.262 100 74 145 3 1863163872 12033040 20765744
14:07:03 2917 8192000000 10773576288 11158663168 1833525600 18.288 100 85 168 3 1869864928 12331232 24008096
14:07:12 2603 8192000000 10787363280 11169263616 1840523104 18.345 100 95 190 0 1881370912 14294080 26553728
14:07:22 2823 8192000000 10782370304 11168722944 1837946368 18.324 100 88 176 1 1877269232 14106320 25216544
14:07:31 2513 8192000000 10784780080 11174842368 1847717856 18.404 100 87 174 0 1886331472 12859152 25754464
14:07:41 2356 8192000000 10789834592 11179900928 1847367072 18.401 100 87 170 2 1884951872 12776768 24808032
14:07:50 1790 8192000000 10799099232 11188178944 1854294576 18.457 100 94 188 0 1895850816 14905008 26651232
14:07:59 2003 8192000000 10799022256 11187798016 1858360336 18.490 100 92 185 0 1897440832 12821168 26259328
14:08:07 2323 8192000000 10804582864 11190779904 1856785840 18.477 100 92 182 2 1895403776 12737104 25880832
14:08:16 2226 8192000000 10807703952 11194318848 1861357072 18.514 100 96 193 0 1900577296 11989872 27230352
14:08:25 4978 8192000000 10805688576 11196944384 1864834656 18.542 100 93 187 1 1905339008 13827472 26676880
14:08:37 1667 8192000000 10813949760 11202936832 1869003440 18.576 100 90 179 0 1907329328 13523536 24802352
14:08:45 2126 8192000000 10821424896 11207069696 1870168960 18.586 100 95 188 1 1911110528 13542272 27399296
14:08:53 1383 8192000000 10824506048 11210608640 1877302784 18.643 100 93 185 0 1916746128 13328720 26114624
14:09:01 2005 8192000000 10832212096 11220766720 1882836512 18.688 100 97 194 2 1924206400 14016560 27353328
14:09:09 2661 8192000000 10816082800 11211227136 1878038016 18.649 100 78 156 0 1914920784 15167376 21715392
14:09:18 21760 8192000000 10787302000 11204804608 1869736992 18.582 100 45 90 1 1893921840 10816512 13368336
14:09:49 12189 8192000000 10821768624 11214311424 1882718656 18.687 100 79 161 0 1912599040 6276880 23603504
14:10:07 14207 8192000000 10807581920 11215396864 1879387872 18.660 100 64 128 6 1907300240 8767280 19145088
14:10:31 5737 8192000000 10780785040 11208335360 1875517200 18.629 100 42 82 4 1895508608 7949376 12042032
14:10:47 6029 8192000000 10789321728 11210170368 1877205872 18.643 100 37 74 1 1898916432 11706368 10004192
14:11:00 3478 8192000000 10798344144 11216416768 1878224032 18.651 100 41 80 2 1897652880 7641728 11787120
14:11:11 4642 8192000000 10790595104 11217723392 1880444064 18.669 100 33 66 0 1897346160 8004912 8897184
14:11:28 8361 8192000000 10799467264 11213795328 1883516208 18.693 100 43 88 1 1901857536 6298336 12042992
14:11:43 5824 8192000000 10802144144 11219226624 1879312304 18.660 100 22 44 1 1892237152 6659632 6265216
14:11:57 10236 8192000000 10787767792 11218165760 1880178416 18.667 100 17 34 0 1890609424 5296800 5134208
14:12:13 9054 8192000000 10795335744 11222593536 1880694176 18.671 100 17 33 0 1891387280 5594912 5098192
14:12:33 7101 8192000000 10796556400 11226238976 1886730016 18.719 100 22 44 2 1899593040 6888448 5974576
14:12:47 13503 8192000000 10781822160 11219800064 1884634928 18.703 100 19 38 0 1895950768 6034528 5281312
14:13:06 9370 8192000000 10796384544 11227201536 1887371312 18.725 100 15 30 0 1897623072 6045136 4206624
14:13:25 7382 8192000000 10784627168 11225485312 1887545264 18.726 100 18 36 1 1899434448 6081648 5807536
14:13:39 5385 8192000000 10798850656 11229384704 1887383040 18.725 100 17 34 0 1898516576 6178336 4955200
14:13:51 14413 8192000000 10799813472 11227660288 1888162512 18.731 100 16 31 3 1897852976 5639952 4050512
14:14:12 66514 8192000000 10824964496 11246272512 1895388288 18.789 100 34 65 2 1909848512 4812432 9647792
14:15:25 2035 8192000000 10835176864 11254915072 1905686912 18.872 100 69 139 2 1936262928 10747696 19828320
14:15:36 3823 8192000000 10822729504 11253678080 1899880224 18.825 100 41 83 2 1919116048 7910336 11325488
14:15:53 4224 8192000000 10814425712 11246104576 1899765040 18.824 100 33 65 0 1916629264 6252720 10611504
14:16:05 4989 8192000000 10803855424 11241381888 1895569056 18.791 100 31 62 0 1910842384 6548992 8724336
14:16:17 6468 8192000000 10825226304 11253018624 1898203328 18.812 100 36 72 1 1920318720 12648304 9467088
14:16:32 5963 8192000000 10811976448 11245993984 1900646544 18.831 100 38 76 1 1918524320 7279584 10598192
14:16:46 6611 8192000000 10813227104 11245039616 1899037904 18.819 100 17 34 1 1909764720 5521200 5205616
14:16:59 8003 8192000000 10820142816 11247546368 1897296928 18.805 100 30 61 1 1916531808 10522816 8712064
14:17:16 6698 8192000000 10802364560 11242303488 1893913232 18.777 100 19 38 0 1904704848 5502672 5288944
14:17:30 9576 8192000000 10801056256 11230412800 1870595296 18.589 99 27 54 0 1883990960 5864960 7530704
14:17:48 8931 8192000000 10803991600 11238707200 1886105168 18.714 100 20 39 0 1901663632 10360528 5197936
14:18:03 8743 8192000000 10778377408 11215441920 1842313616 18.360 98 17 34 0 1852594000 5246032 5034352
14:18:21 18478 8192000000 10754883168 11166425088 1741166752 17.528 93 24 48 0 1754798912 5211504 8420656
14:18:46 59908 8192000000 10750680736 11164749824 1741019408 17.527 94 38 76 2 1758284752 6364320 10901024
14:19:55 8761 8192000000 10717191664 11131592704 1700407232 17.189 93 31 63 0 1716753216 6218064 10127920
14:20:12 8731 8192000000 10701203824 11120582656 1716605312 17.324 95 26 52 1 1730363920 5939264 7819344
14:20:29 3953 8192000000 10703830640 11108257792 1744818304 17.559 98 31 61 1 1759816064 6499824 8497936
14:20:42 5563 8192000000 10722024576 11137638400 1803647200 18.044 100 42 84 0 1824928144 9012592 12268352
14:20:57 9146 8192000000 10701697104 11116154880 1758922864 17.675 98 29 60 0 1773751280 5725248 9103168
14:21:13 6617 8192000000 10695252992 11103645696 1703728496 17.216 95 32 64 3 1717938032 5045232 9164304
14:21:25 7147 8192000000 10702248512 11118534656 1771253520 17.777 99 25 51 1 1784534448 5845376 7435552
14:21:39 6520 8192000000 10710569264 11119362048 1770058592 17.768 99 30 60 4 1785227024 6026448 9141984
14:21:53 9879 8192000000 10713831856 11126390784 1746667200 17.574 97 26 52 1 1760038752 5852224 7519328
14:22:09 7836 8192000000 10713606064 11125637120 1764671840 17.723 98 24 48 1 1777268480 5410832 7185808
14:22:23 7608 8192000000 10713776704 11124969472 1793186432 17.958 100 30 60 0 1808151504 5178720 9786352
14:22:40 11334 8192000000 10723897488 11138514944 1771830464 17.782 98 22 44 1 1783284736 4905920 6548352
14:23:00 6237 8192000000 10732033264 11151790080 1803065440 18.039 99 26 52 2 1816350880 5427632 7857808
14:23:14 81328 8192000000 10717504000 11136909312 1676140032 16.985 92 19 37 1 1685690176 4645024 4905120
14:24:41 13186 8192000000 10734490256 11151249408 1813202384 18.122 100 31 62 3 1827970960 6232160 8536416
14:25:02 5914 8192000000 10752305376 11158740992 1822812816 18.201 100 32 64 0 1837133888 5540992 8780080
14:25:14 6857 8192000000 10748737952 11166720000 1831290704 18.270 100 39 79 2 1849669712 7763088 10615920
14:25:30 6237 8192000000 10756629904 11180285952 1840206896 18.342 100 26 52 0 1853118656 6307520 6604240
14:25:43 9076 8192000000 10760893072 11181719552 1843179936 18.367 100 30 61 2 1858303408 5969568 9153904
14:25:58 3283 8192000000 10772430928 11186147328 1844117744 18.374 100 19 38 0 1855749152 5276544 6354864
14:26:08 9182 8192000000 10755510832 11180994560 1847155680 18.399 100 22 45 0 1858286592 4675856 6455056
14:26:23 7645 8192000000 10758005328 11191750656 1852130128 18.439 100 14 28 2 1862356624 6066880 4159616
14:26:37 10820 8192000000 10767125488 11193200640 1854634176 18.460 100 18 36 1 1864881744 5050256 5197312
14:26:57 7530 8192000000 10791898784 11205783552 1862316464 18.522 100 27 53 3 1874938400 5641808 6980128
14:27:12 8438 8192000000 10793704944 11213176832 1876632704 18.638 100 26 48 3 1888299360 4293488 7373168
14:27:31 41572 8192000000 10813768512 11230560256 1886728960 18.719 100 39 79 2 1903572816 5537040 11306816
14:28:20 7014 8192000000 10835579744 11248250880 1897525024 18.806 100 53 105 1 1921883664 9526848 14831792
14:28:35 10305 8192000000 10829781088 11248316416 1900207744 18.828 100 52 99 3 1925233328 10388576 14637008
14:28:57 114531 8192000000 10826539328 11263377408 1908033584 18.891 100 36 72 1 1928531984 10093616 10404784
14:31:10 29451 8192000000 10866026912 11286269952 1924504896 19.023 100 42 84 3 1951324528 14029440 12790192
14:31:56 16911 8192000000 10862852480 11295723520 1932905568 19.090 100 45 90 0 1961543872 15271296 13367008
14:32:26 33995 8192000000 10878187728 11307524096 1938345392 19.134 100 40 80 1 1965761712 15065168 12351152
14:33:08 21301 8192000000 10890524832 11317870592 1950461936 19.230 100 49 96 2 1982294928 16909232 14923760
14:33:36 21450 8192000000 10890955904 11319021568 1952701072 19.248 100 55 109 1 1988631408 19151376 16778960
14:34:16 4200 8192000000 10925135056 11333402624 1961467968 19.318 100 69 137 1 2004359920 22369648 20522304
14:34:31 18703 8192000000 10900922512 11324399616 1940695984 19.152 99 55 110 0 1981151408 23981280 16474144
14:35:04 9327 8192000000 10898321600 11334443008 1958085632 19.291 100 43 87 1 1995374832 23908272 13380928
14:35:26 5751 8192000000 10914844816 11346059264 1965482624 19.350 100 50 100 1 2005654064 25053984 15117456
14:35:42 15938 8192000000 10918675552 11350790144 1968938768 19.377 100 58 117 2 2006486048 20365120 17182160
14:36:06 10227 8192000000 10929338352 11357462528 1976212560 19.435 100 49 98 2 2012180384 21369664 14598160
14:36:23 6167 8192000000 10933742032 11357179904 1979666096 19.462 100 59 117 0 2018888928 21923520 17299312
14:36:36 5728 8192000000 10937427280 11361398784 1982762848 19.487 100 58 116 2 2022749616 22820032 17166736
14:36:49 7304 8192000000 10941197568 11366162432 1987162624 19.521 100 66 132 0 2030785568 23820368 19802576
14:37:06 3244 8192000000 10959217248 11374256128 1991951056 19.559 100 77 153 0 2039138416 23451232 23736128
14:37:16 5149 8192000000 10950025680 11374292992 1989208656 19.538 100 62 124 1 2031321168 23380976 18731536
14:37:28 7249 8192000000 10951844272 11377782784 1995870768 19.590 100 64 124 1 2039581552 24883600 18827184
14:37:42 4507 8192000000 10963497568 11391365120 2004214352 19.656 100 72 143 0 2055392096 29360336 21817408
14:37:57 2286 8192000000 10965352480 11388608512 2005619792 19.667 100 71 143 2 2051764704 25265104 20879808
14:38:06 7214 8192000000 10970231152 11392655360 2007694960 19.683 100 69 138 1 2053773504 25541456 20537088
14:38:20 5380 8192000000 10974565888 11400781824 2008942384 19.693 100 72 142 0 2060214640 30757216 20515040
14:38:33 1862 8192000000 10962722992 11381350400 2007453424 19.681 100 83 166 0 2059771744 27559216 24759104
14:38:48 7868 8192000000 10963881792 11391217664 2000052224 19.623 100 64 128 3 2049327616 30020880 19254512
14:39:04 6102 8192000000 10957660768 11382763520 1990917568 19.551 100 66 130 0 2041045648 30655856 19472224
14:39:16 3040 8192000000 10955799248 11375517696 1982485936 19.484 99 80 160 3 2037488832 30782288 24220608
14:39:28 7670 8192000000 10944108448 11372580864 1972744304 19.407 99 67 130 2 2024584128 31769280 20070544
14:39:46 5400 8192000000 10934851696 11351359488 1966012272 19.354 99 82 163 0 2021592512 30769648 24810592
14:39:59 5980 8192000000 10963420624 11379822592 1986632464 19.517 100 84 163 2 2044093392 32450880 25010048
14:40:16 4829 8192000000 10967856848 11381563392 1991105360 19.553 100 83 161 2 2048045600 31813792 25126448
14:40:29 3545 8192000000 10957373824 11379105792 1984134352 19.497 100 77 154 0 2042611968 34375216 24102400
14:40:41 5687 8192000000 10952242560 11373817856 1982416240 19.484 100 69 138 3 2037602576 34175024 21011312
14:40:54 11363 8192000000 10952170944 11374358528 1979637632 19.462 100 69 136 2 2032248400 31997680 20613088
14:41:13 2705 8192000000 10945993792 11363168256 1972837824 19.408 100 72 142 1 2027076848 32765808 21473216
14:41:23 2120 8192000000 10958973568 11372236800 1981056160 19.473 100 76 152 1 2038041424 34468352 22516912
14:41:32 1988 8192000000 10957781472 11368005632 1981060032 19.473 100 90 179 0 2043225680 34968624 27197024
14:41:49 8155 8192000000 10951908272 11366576128 1963044608 19.330 99 70 139 1 2021342016 36859376 21438032
14:42:05 2884 8192000000 10955763264 11368382464 1974174272 19.419 100 76 149 3 2036638816 39530416 22934128
14:42:19 6776 8192000000 10943270336 11357376512 1953403584 19.254 99 64 127 1 2014348160 40801280 20143296
14:42:35 2295 8192000000 10914713504 11325517824 1923349808 19.014 99 81 160 3 1988745152 40482080 24913264
14:42:46 2820 8192000000 10954121984 11362062336 1963832368 19.336 100 83 166 1 2033190064 43601488 25756208
14:42:56 3113 8192000000 10961322320 11375828992 1969434400 19.381 100 69 137 0 2036168256 45143056 21590800
14:43:08 1581 8192000000 10979232192 11389788160 1988094080 19.529 100 84 166 2 2057441584 44045920 25301584
14:43:18 10023 8192000000 10960300592 11387891712 1984240176 19.498 100 69 137 1 2051607424 45712560 21654688
14:43:36 5015 8192000000 10971409584 11398729728 1984485296 19.500 100 65 128 3 2056606096 51482944 20637856
14:43:51 2639 8192000000 10976322560 11397197824 1984533488 19.501 100 73 145 2 2060361792 52530528 23297776
14:44:00 2947 8192000000 10968507760 11386253312 1972258224 19.403 99 86 167 7 2042431200 43676128 26496848
14:44:10 1791 8192000000 10972871632 11385597952 1981918048 19.480 100 77 154 1 2048047312 42218448 23910816
14:44:21 1109 8192000000 10981370688 11392081920 1993697616 19.573 100 88 171 0 2063648192 43782000 26168576
14:44:32 4160 8192000000 10971817184 11392290816 1985823360 19.511 100 68 136 1 2051989664 44801136 21365168
14:44:46 3183 8192000000 10976578704 11402977280 1996384944 19.594 100 74 145 0 2068104064 48553984 23165136
14:44:58 3261 8192000000 10982958592 11401986048 1994401152 19.579 100 77 154 1 2067730432 49359504 23969776
14:45:11 4008 8192000000 10977142240 11404017664 1997813056 19.605 100 66 132 0 2062410688 43552640 21044992
14:45:22 1963 8192000000 11000388848 11412672512 2000078512 19.623 100 81 160 2 2070641520 45504928 25058080
14:45:37 7236 8192000000 10984637232 11410214912 1982239600 19.482 99 68 134 1 2050421008 47052352 21129056
14:45:53 4513 8192000000 10989554640 11406839808 1993527904 19.572 100 77 154 0 2066369152 48127328 24713920
14:46:04 2738 8192000000 10990104944 11411443712 1995977328 19.591 100 73 146 0 2069456336 50434800 23044208
14:46:17 2487 8192000000 11002104336 11425779712 2010173984 19.703 100 85 169 1 2088899888 52007168 26718736
14:46:28 5341 8192000000 11011652176 11433558016 2014885200 19.740 100 75 150 1 2093340000 53948528 24506272
14:46:43 4728 8192000000 11000245088 11437740032 2010378624 19.704 100 61 121 0 2080513136 50646720 19487792
14:46:57 10689 8192000000 10975569248 11425341440 1999631584 19.620 100 41 82 0 2060282656 46979008 13672064
14:47:26 10655 8192000000 10964889280 11411877888 1989974272 19.544 100 40 79 2 2051174096 47764544 13435280
14:47:45 8388 8192000000 10982951488 11420266496 1998596384 19.612 100 47 94 1 2062315392 48106304 15612704
14:48:07 11839 8192000000 10969507232 11417460736 1985436752 19.508 99 39 76 2 2048295056 50424384 12433920
14:48:40 9619 8192000000 10970930720 11407253504 1978371504 19.452 99 41 82 0 2040559728 48355904 13832320
14:48:57 7691 8192000000 10999732992 11434635264 2008130016 19.687 100 59 117 0 2078009584 51346928 18532640
14:49:18 17945 8192000000 10986794704 11439140864 2010428496 19.705 100 37 73 0 2072308336 49807200 12072640
14:49:51 11281 8192000000 10977330080 11422339072 1985529312 19.508 99 42 84 0 2052621872 52958976 14133584
14:50:13 8886 8192000000 10988962848 11424870400 1996171936 19.593 100 46 93 3 2067233232 55019232 16042064
14:50:34 5142 8192000000 11006810000 11434561536 2004061024 19.655 100 60 119 0 2079267984 55089232 20117728
14:50:45 6553 8192000000 11007263680 11444273152 2004665840 19.660 100 58 115 1 2086405024 62680576 19058608
14:51:03 23095 8192000000 10986564448 11449606144 2000598336 19.627 100 31 62 0 2077086128 65060944 11426848
14:51:32 14461 8192000000 10971407104 11422019584 1964373744 19.341 99 38 76 3 2044611888 66398608 13839536
14:52:16 22839 8192000000 10952826928 11417100288 1953749344 19.256 99 26 52 0 2029530848 65956192 9825312
14:53:04 22639 8192000000 10954480752 11409010688 1950845264 19.233 100 24 48 2 2029752480 69438304 9468912
14:53:33 19258 8192000000 10945062928 11399700480 1933550192 19.095 99 30 60 0 2022356560 77501952 11304416
14:53:59 15728 8192000000 10942382336 11403321344 1943937632 19.178 100 22 44 0 2027518368 74965120 8615616
14:54:25 23593 8192000000 10911120720 11374063616 1907566512 18.887 98 16 32 0 1964705968 51466064 5673392
14:55:16 20874 8192000000 10902551168 11379273728 1929264560 19.061 99 19 38 0 1977105856 42015600 5825696
14:55:50 30492 8192000000 10891118560 11372904448 1930349392 19.070 99 16 32 0 1968233984 32389200 5495392
14:56:30 57023 8192000000 10876312928 11352801280 1924666448 19.024 99 4 8 0 1948739280 22876192 1196640
14:57:34 42257 8192000000 10870477472 11331313664 1880703104 18.671 96 14 26 0 1897419440 12943232 3773104
14:59:02 72613 8192000000 10906278704 11370278912 1967343552 19.364 100 26 52 1 1987993840 12425616 8224672
15:00:23 67550 8192000000 10898535424 11358748672 1905578464 18.871 97 11 22 1 1920071360 11646528 2846368
15:01:37 113158 8192000000 10891953776 11350204416 1829787728 18.258 93 10 20 0 1846068928 13672576 2608624
15:04:14 54792 8192000000 10890400320 11367301120 1929203504 19.061 99 8 16 1 1954193568 22448064 2542000
15:05:15 33998 8192000000 10927050304 11367739392 1945950560 19.194 99 36 73 3 1969986800 12234016 11802224
15:06:00 38610 8192000000 10912548480 11370266624 1971509568 19.397 100 25 50 1 1995772032 17062448 7200016
15:06:50 119531 8192000000 10941473520 11389435904 1980118272 19.466 100 44 88 0 2016848400 23652832 13077296
15:09:09 51323 8192000000 10917583136 11382677504 1959510240 19.302 99 36 71 1 1986104752 16528464 10066048
15:10:12 95029 8192000000 10922858336 11365986304 1911711808 18.920 96 49 99 3 1934383072 8462320 14208944
15:12:00 70485 8192000000 10919227632 11387326464 1978775952 19.455 100 18 36 0 1994675584 10672448 5227184
15:13:17 44406 8192000000 10943718000 11395076096 1989609472 19.541 100 18 36 1 2005466848 9140880 6716496
15:14:09 54266 8192000000 10907104928 11375632384 1970713440 19.391 99 52 102 0 1998793824 12877136 15203248
15:15:19 45583 8192000000 10905232032 11390005248 1978381248 19.452 100 14 28 0 1998665104 16421376 3862480
15:17:16 89020 8192000000 10894364096 11375779840 1946330560 19.197 98 7 14 0 1955234736 7205600 1698576
15:18:51 10290 8192000000 10909059488 11380686848 1980663904 19.470 100 12 24 2 1992009424 7914624 3430896
15:19:08 73207 8192000000 10912393312 11393818624 1985529536 19.508 100 11 22 0 2002423712 14290176 2604000
15:20:42 83904 8192000000 10928292672 11412934656 1990013040 19.544 100 14 28 0 2010615504 16717664 3884800
15:23:46 64139 8192000000 10912093696 11401834496 1957662528 19.287 98 19 37 3 1973814016 10112640 6038848
15:25:04 40496 8192000000 10930004624 11405062144 1995023200 19.583 100 21 42 1 2012420640 11128848 6268592
15:25:54 63157 8192000000 10911874960 11392258048 1911845056 18.921 96 17 34 1 1933801584 17504992 4451536
15:27:03 53212 8192000000 10914611776 11387035648 1932736224 19.089 97 22 43 0 1947048080 8522656 5789200
15:28:13 66683 8192000000 10904656064 11374649344 1857930960 18.487 93 15 30 1 1877764464 16704368 3129136
15:29:27 99155 8192000000 10901397888 11363860480 1831303296 18.270 93 8 16 0 1850007824 16873168 1831360
15:31:13 41890 8192000000 10917069152 11391025152 1974208960 19.419 100 30 60 1 1999824112 16961456 8653696
15:32:02 48375 8192000000 10908091296 11388530688 1959510400 19.302 99 23 45 0 1976700944 10929392 6261152
15:33:02 47083 8192000000 10886153472 11359514624 1880006480 18.665 95 12 23 3 1892704528 9643184 3054864
15:33:55 104166 8192000000 10894163216 11358101504 1870196192 18.586 95 14 28 0 1887289440 12870672 4222576
15:35:51 71144 8192000000 10867254480 11343085568 1874533488 18.621 96 25 50 2 1893356160 11283712 7538960
15:37:40 51655 8192000000 10898513120 11359916032 1939316464 19.141 99 22 44 0 1957230736 11688576 6225696
15:38:38 108031 8192000000 10867471488 11337707520 1902345408 18.845 97 29 58 2 1921095808 10385984 8364416
15:40:32 53746 8192000000 10865833600 11322417152 1867161568 18.561 96 19 38 1 1881305776 9721744 4422464
15:41:32 64781 8192000000 10857853552 11323723776 1879922416 18.664 97 35 67 0 1907345776 18557648 8865712
15:42:44 42405 8192000000 10857732048 11346087936 1931504656 19.079 100 20 40 0 1954665792 17287072 5874064
15:43:45 31870 8192000000 10871020064 11343384576 1919282192 18.981 99 18 35 0 1938946992 15001376 4663424
15:44:23 51748 8192000000 10864702576 11345600512 1924043920 19.019 99 12 24 1 1948052304 21050560 2957824
15:45:22 54118 8192000000 10856076672 11341197312 1888209152 18.731 97 12 26 1 1905466512 13894608 3362752
15:46:23 78069 8192000000 10843792512 11324416000 1860805616 18.510 96 18 36 1 1878324048 12225952 5292480
15:48:01 84603 8192000000 10863742992 11339464704 1931967120 19.083 100 21 42 0 1951012608 12799344 6246144
15:49:33 57826 8192000000 10863332400 11352911872 1939929808 19.146 100 11 22 2 1958453040 15168752 3354480
15:51:14 36899 8192000000 10859644800 11331891200 1902559600 18.847 98 32 64 1 1920931216 8660880 9710736
15:51:58 49961 8192000000 10848411424 11333373952 1900964352 18.834 98 14 28 0 1915331664 10105040 4262272
15:52:54 21019 8192000000 10893093888 11332722688 1939856640 19.146 100 40 80 0 1963748096 11364432 12527024
15:53:23 20318 8192000000 10875450560 11339546624 1921386528 18.998 99 54 107 0 1946573776 9894944 15292304
15:53:49 24223 8192000000 10887685472 11346776064 1945593408 19.191 100 26 52 1 1962085392 9595808 6896176
15:54:24 26619 8192000000 10902335904 11365179392 1957975232 19.290 100 36 71 2 1980345632 12451584 9918816
15:54:57 35754 8192000000 10893859984 11366776832 1942253056 19.165 99 20 40 1 1959638480 11868112 5517312
15:55:41 81618 8192000000 10889696992 11375026176 1959307024 19.301 100 21 43 0 1978068976 12455712 6306240
15:57:09 51042 8192000000 10890486432 11350450176 1857134096 18.480 94 27 53 0 1873591760 9239520 7218144
15:58:06 83427 8192000000 10879858592 11360219136 1876038240 18.633 96 16 32 2 1892202048 11800800 4363008
15:59:35 66479 8192000000 10898985744 11352625152 1876404528 18.636 96 25 50 0 1896544816 12839136 7301152
16:00:50 70524 8192000000 10903268336 11384238080 1953248816 19.252 100 22 44 3 1971694160 12309440 6135904
16:02:09 93512 8192000000 10903393472 11384057856 1931573344 19.079 98 12 24 0 1953786368 18631840 3581184
16:03:52 74722 8192000000 10886226368 11361902592 1907945120 18.890 97 10 20 0 1926356848 15739920 2671808
16:05:13 43043 8192000000 10926990880 11390996480 1975342560 19.428 100 33 66 0 1997568288 12300400 9925328
16:06:08 74510 8192000000 10898353664 11393753088 1973688464 19.415 100 9 18 1 1989844752 13719424 2436864
16:07:38 47849 8192000000 10876666672 11348135936 1909754768 18.905 97 21 42 0 1924042864 7885616 6402480
16:08:35 63126 8192000000 10898686464 11360514048 1945347488 19.189 99 33 66 0 1964091952 9496720 9247744
16:09:45 40895 8192000000 10884806480 11364433920 1945131616 19.188 99 19 37 2 1965164832 14057792 5975424
16:10:47 60228 8192000000 10894821456 11373613056 1950062240 19.227 99 16 32 2 1970584176 15800048 4721888
16:11:54 82759 8192000000 10899165552 11385315328 1973101056 19.410 100 15 30 1 1990623328 13160624 4361648
16:13:23 81063 8192000000 10889773520 11365756928 1923326592 19.013 97 23 46 1 1942832544 12186816 7319136
16:15:11 63174 8192000000 10899319600 11390287872 1967323248 19.364 100 11 22 1 1987015968 15789520 3903200
16:16:27 47127 8192000000 10880768960 11363725312 1925370192 19.030 98 12 24 0 1936830128 8729168 2730768
16:17:21 22744 8192000000 10897236592 11357569024 1923554640 19.015 98 18 35 1 1934765184 6161872 5048672
16:17:53 28026 8192000000 10896745504 11363094528 1947593952 19.207 99 47 92 2 1969644896 8928832 13122112
16:18:31 36722 8192000000 10847217904 11323154432 1876657984 18.638 96 26 52 1 1893952288 9659936 7634368
16:19:14 50349 8192000000 10863207376 11319459840 1898205504 18.812 98 20 40 3 1913238176 8927360 6105312
16:20:14 66392 8192000000 10867772192 11335053312 1854128848 18.456 95 19 38 0 1878277168 18923712 5224608
16:21:28 37877 8192000000 10895906352 11367628800 1950455344 19.230 100 37 73 1 1981725392 20873536 10396512
16:22:57 60617 8192000000 10872172496 11349389312 1897368032 18.805 98 14 28 1 1920307280 18765360 4173888
16:24:04 97090 8192000000 10867697104 11342409728 1888661184 18.735 97 12 24 1 1911026640 19144608 3220848
16:25:47 43896 8192000000 10900838064 11364851712 1945982720 19.194 100 29 58 1 1964547808 10683392 7881696
16:26:37 20803 8192000000 10903430320 11359449088 1944732032 19.184 99 49 100 0 1968154928 9704736 13718160
16:27:08 22487 8192000000 9463657088 9767768064 600867872 6.833 32 9 18 0 611398832 8549824 1981136

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-03-2021 16:28:15 to 09-03-2021 16:28:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 165 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-03-2021 16:28:47 to 09-03-2021 16:28:49.

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          236090
MON$OLDEST_ACTIVE               236091
MON$OLDEST_SNAPSHOT             236091
MON$NEXT_TRANSACTION            236091
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                       2051744
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:205: 
:206: mscs-test-161.budzdorov.ru    Tue Mar  9 16:27:33 2021
:207:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:208: 
:209: 
:210: mscs-test-161.budzdorov.ru    Tue Mar  9 16:27:33 2021
:211:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:212: 
:213: 
:214: mscs-test-161.budzdorov.ru    Tue Mar  9 16:27:37 2021
:215:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:216: 
--- end of diff output ---

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

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