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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-29 01:27:06
DTS_END                         2020-12-29 01:27:06.4230
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/49094
TRN_ID                          247136
ATT_ID                          694
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: 9616.42 20121 1153970
customer order: creation 182.29 351 21875
customer order: refuse 15.62 337 1874
order to supplier: creation 49.84 1272 5981
order to supplier: removal 3.53 98161 423
invoice (draft): creation 49.50 3238 5940
invoice (draft): removal 52.52 765 6302
invoice accept: apply 44.72 16511 5366
invoice accept: cancel 47.21 799 5665
customer reserve: creation 4165.19 160 499823
customer reserve: removal 4697.82 58 563738
realization accept: apply 89.40 173 10728
realization accept: cancel 81.80 107 9816
payment from customer: creation 62.31 108 7477
payment from customer: removal 6.05 84 726
payment to supplier: creation 52.32 124 6278
payment to supplier: removal 3.65 99 438
service: total inventory turnovers 4.82 1176 578
service: total monetary turnovers 6.92 26 830
service: aggregate perf. data 0.90 19615 108
service: refresh index statistics 0.03 259256 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 29-12-2020 01:28:01 to 29-12-2020 01:28:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1729
TEST_TIME 2 3724
TEST_TIME 3 3922
TEST_TIME 4 4563
TEST_TIME 5 5162
TEST_TIME 6 5299
TEST_TIME 7 5804
TEST_TIME 8 5710
TEST_TIME 9 6289
TEST_TIME 10 6968
TEST_TIME 11 6919
TEST_TIME 12 7268
TEST_TIME 13 7491
TEST_TIME 14 7544
TEST_TIME 15 7874
TEST_TIME 16 8204
TEST_TIME 17 8859
TEST_TIME 18 9231
TEST_TIME 19 9592
TEST_TIME 20 9676
TEST_TIME 21 9683
TEST_TIME 22 9616
TEST_TIME 23 9518
TEST_TIME 24 9851
TEST_TIME 25 9906
TEST_TIME 26 10360
TEST_TIME 27 10495
TEST_TIME 28 10997
TEST_TIME 29 11236
TEST_TIME 30 11184
TEST_TIME 31 11130
TEST_TIME 32 10987
TEST_TIME 33 10881
TEST_TIME 34 10809
TEST_TIME 35 10966
TEST_TIME 36 10833
TEST_TIME 37 10696
TEST_TIME 38 10775
TEST_TIME 39 10614
TEST_TIME 40 10524
TEST_TIME 41 10328
TEST_TIME 42 10279
TEST_TIME 43 10325
TEST_TIME 44 10165
TEST_TIME 45 10146
TEST_TIME 46 10098
TEST_TIME 47 10092
TEST_TIME 48 10252
TEST_TIME 49 10342
TEST_TIME 50 10222
TEST_TIME 51 10146
TEST_TIME 52 10128
TEST_TIME 53 9969
TEST_TIME 54 9918
TEST_TIME 55 9906
TEST_TIME 56 9832
TEST_TIME 57 9742
TEST_TIME 58 9644
TEST_TIME 59 9744
TEST_TIME 60 9832
TEST_TIME 61 9792
TEST_TIME 62 9868
TEST_TIME 63 9956
TEST_TIME 64 9972
TEST_TIME 65 9980
TEST_TIME 66 10046
TEST_TIME 67 9965
TEST_TIME 68 9950
TEST_TIME 69 10130
TEST_TIME 70 10078
TEST_TIME 71 10099
TEST_TIME 72 10160
TEST_TIME 73 10173
TEST_TIME 74 10048
TEST_TIME 75 10000
TEST_TIME 76 9935
TEST_TIME 77 9920
TEST_TIME 78 9892
TEST_TIME 79 9836
TEST_TIME 80 9780
TEST_TIME 81 9725
TEST_TIME 82 9739
TEST_TIME 83 9694
TEST_TIME 84 9673
TEST_TIME 85 9678
TEST_TIME 86 9636
TEST_TIME 87 9625
TEST_TIME 88 9727
TEST_TIME 89 9685
TEST_TIME 90 9708
TEST_TIME 91 9695
TEST_TIME 92 9702
TEST_TIME 93 9712
TEST_TIME 94 9743
TEST_TIME 95 9762
TEST_TIME 96 9736
TEST_TIME 97 9754
TEST_TIME 98 9749
TEST_TIME 99 9820
TEST_TIME 100 9802
TEST_TIME 101 9735
TEST_TIME 102 9684
TEST_TIME 103 9678
TEST_TIME 104 9665
TEST_TIME 105 9634
TEST_TIME 106 9597
TEST_TIME 107 9590
TEST_TIME 108 9540
TEST_TIME 109 9568
TEST_TIME 110 9539
TEST_TIME 111 9544
TEST_TIME 112 9552
TEST_TIME 113 9537
TEST_TIME 114 9617
TEST_TIME 115 9646
TEST_TIME 116 9633
TEST_TIME 117 9629
TEST_TIME 118 9596
TEST_TIME 119 9695
TEST_TIME 120 9617

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-12-2020 01:28:05 to 29-12-2020 01: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 1615396 1615396 0 0.00 0 23942 6 0 0
doc_list_biud 1615393 1615393 0 0.00 0 50482 26 0 0
sp_add_invoice_to_stock 5472 5366 106 1.93 51 170793 16511 0 106
sp_cancel_adding_invoice 5665 5665 0 0.00 4 73019 800 0 0
sp_cancel_client_order 1874 1874 0 0.00 4 13700 337 0 0
sp_cancel_customer_reserve 563738 563738 0 0.00 1 50486 58 0 0
sp_cancel_pay_from_customer 726 726 0 0.00 2 6177 85 0 0
sp_cancel_pay_to_supplier 438 438 0 0.00 3 4544 99 0 0
sp_cancel_supplier_invoice 6316 6302 14 0.22 1 17498 765 0 14
sp_cancel_supplier_order 423 423 0 0.00 6 968891 98161 0 0
sp_cancel_write_off 9816 9816 0 0.00 1 12220 108 0 0
sp_client_order 21875 21875 0 0.00 3 31062 352 0 0
sp_customer_reserve 499823 499823 0 0.00 0 32448 161 0 0
sp_fill_shopping_cart 33784 33784 0 0.00 1 11062 38 0 0
sp_fill_shopping_cart_clo_res 499816 499816 0 0.00 0 23010 12 0 0
sp_get_clo_for_invoice 5358 5358 0 0.00 0 33132 277 0 0
sp_kill_cost_storno 16645 16645 0 0.00 0 23081 52 0 0
sp_kill_qstorno_ret_qs2qd 1144017 1144017 0 0.00 0 50478 31 0 0
sp_kill_qty_storno 603904 603904 0 0.00 0 50482 68 0 0
sp_lock_selected_doc 22241 22241 0 0.00 0 9289 6 0 0
sp_make_cost_storno 29841 29841 0 0.00 0 16182 53 0 0
sp_multiply_rows_for_pdistr 29841 29841 0 0.00 0 10213 29 0 0
sp_multiply_rows_for_qdistr 21872 21872 0 0.00 0 14669 150 0 0
sp_pay_from_customer 7477 7477 0 0.00 4 10858 108 0 0
sp_pay_to_supplier 6278 6278 0 0.00 5 16212 124 0 0
sp_payment_common 13755 13755 0 0.00 1 7262 25 0 0
sp_qd_handle_on_cancel_clo 1874 1874 0 0.00 0 13693 299 0 0
sp_qd_handle_on_invoice_upd_sts 11023 11023 0 0.00 0 31351 335 0 0
sp_qd_handle_on_reserve_upd_sts 10728 10728 0 0.00 0 14156 54 0 0
sp_reserve_write_off 10728 10728 0 0.00 6 14192 173 0 0
sp_supplier_invoice 5940 5940 0 0.00 6 82107 3239 0 0
sp_supplier_order 5981 5981 0 0.00 5 46157 1272 0 0
srv_aggregate_perf_data 108 108 0 0.00 2415 442634 19616 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1055 118219 29437 0 0
srv_find_qd_qs_mism 1102200 1102200 0 0.00 0 23941 5 0 0
srv_make_invnt_saldo 578 578 0 0.00 34 32551 1177 0 0
srv_make_money_saldo 830 830 0 0.00 0 1178 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 151787 355773 259256 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5366 5366 0 0.00 0 9312 167 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 1 3231 76 0 0
t$perf-norm:sp_cancel_client_order 1874 1874 0 0.00 0 704 9 0 0
t$perf-norm:sp_cancel_customer_reserve 770 770 0 0.00 0 1555 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 726 726 0 0.00 0 1809 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 438 438 0 0.00 0 1187 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 2038 17 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 23581 1703 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 3432 13 0 0
t$perf-norm:sp_client_order 21875 21875 0 0.00 0 8951 19 0 0
t$perf-norm:sp_customer_reserve 1091 1091 0 0.00 0 2450 11 0 0
t$perf-norm:sp_pay_from_customer 7477 7477 0 0.00 0 4985 9 0 0
t$perf-norm:sp_pay_to_supplier 6278 6278 0 0.00 0 3327 10 0 0
t$perf-norm:sp_reserve_write_off 10728 10728 0 0.00 0 13098 14 0 0
t$perf-norm:sp_supplier_invoice 5940 5940 0 0.00 0 8102 16 0 0
t$perf-norm:sp_supplier_order 5981 5981 0 0.00 0 10556 18 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 489 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 2066 27 0 0
t$perf-norm:srv_make_invnt_saldo 578 578 0 0.00 0 958 18 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 711 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10928 10716 212 1.93 0 4991 16 0 212
v_all_customers 39472 39472 0 0.00 0 112 1 0 0
v_all_suppliers 33080 33080 0 0.00 0 112 1 0 0
v_all_wares 43736 43736 0 0.00 0 85 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 1491 7 0 0
v_cancel_client_order 3748 3748 0 0.00 0 3328 6 0 0
v_cancel_customer_prepayment 1452 1452 0 0.00 0 6151 10 0 0
v_cancel_customer_reserve 1540 1540 0 0.00 0 2051 6 0 0
v_cancel_payment_to_supplier 876 876 0 0.00 0 1277 5 0 0
v_cancel_supplier_invoice 890 862 28 3.14 0 1358 17 0 28
v_cancel_supplier_order 846 846 0 0.00 0 3740 8 0 0
v_cancel_write_off 2130 2130 0 0.00 0 5013 21 0 0
v_max_id_clo_ord 5979 5979 0 0.00 0 1974 2 0 0
v_max_id_clo_res 1091 1091 0 0.00 0 6834 28 0 0
v_max_id_ord_sup 5937 5937 0 0.00 0 6185 4 0 0
v_max_non_paid_invoice 1654 1654 0 0.00 0 50 2 0 0
v_max_non_paid_realizn 4142 4142 0 0.00 0 3159 4 0 0
v_min_id_clo_ord 5979 5979 0 0.00 0 3827 6 0 0
v_min_id_clo_res 1091 1091 0 0.00 0 3234 9 0 0
v_min_id_ord_sup 5937 5937 0 0.00 0 11049 16 0 0
v_min_non_paid_invoice 6278 6278 0 0.00 0 7229 19 0 0
v_min_non_paid_realizn 7477 7477 0 0.00 0 6031 13 0 0
v_our_firm 10934 10934 0 0.00 0 22 1 0 0
v_reserve_write_off 21456 21456 0 0.00 0 7126 8 0 0
x_lock_depdocs_on_canc_invoice 11536 11536 0 0.00 0 17019 123 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 10799 315 0 0
x_make_qstorno_1000_1200 5981 5981 0 0.00 1 46144 1188 0 0
x_make_qstorno_1200_2000 5940 5940 0 0.00 3 82098 3110 0 0
x_make_qstorno_2100_3300 499823 499823 0 0.00 0 32447 145 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 29-12-2020 01:28:09 to 29-12-2020 01: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
22:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:16 13197 8192000000 10214298240 10510761984 909268192 9.990 74 57 115 0 931629968 2444160 19917616
22:57:38 17476 8192000000 10305394096 10613800960 1351942304 14.165 100 86 172 0 1384111584 4098144 28071136
22:58:06 22125 8192000000 10339754128 10655834112 1392484112 14.528 100 87 174 0 1426986592 5726688 28775792
22:58:40 30047 8192000000 10378831008 10696622080 1417161312 14.748 100 84 168 1 1451404064 6430752 27812000
22:59:21 20996 8192000000 10387919744 10712416256 1444465776 14.989 100 89 178 0 1480844880 7458672 28920432
22:59:51 26613 8192000000 10411550256 10739048448 1461841632 15.142 100 88 176 2 1498015360 7594208 28579520
23:00:30 13842 8192000000 10419622960 10750824448 1480976720 15.310 100 88 177 1 1517416000 8121552 28317728
23:00:54 18259 8192000000 10441778336 10781782016 1499431760 15.471 100 80 159 1 1533614816 8460016 25723040
23:01:20 7169 8192000000 10466935728 10807463936 1531191040 15.747 100 76 152 0 1562972080 8103456 23677584
23:01:49 16275 8192000000 10528533152 10880729088 1584890560 16.210 100 72 144 1 1615419664 8762544 21766560
23:02:15 11778 8192000000 10555876000 10914447360 1617125856 16.485 100 77 153 1 1650078848 9767104 23185888
23:02:34 14042 8192000000 10581569040 10941415424 1634242576 16.631 100 83 166 0 1669531472 10307456 24981440
23:02:57 16760 8192000000 10595950352 10960457728 1653767296 16.796 100 71 141 1 1685583696 11261008 20555392
23:03:22 13446 8192000000 10605874752 10971574272 1667897216 16.915 100 80 160 0 1703035936 11308864 23829856
23:03:44 9656 8192000000 10630798000 10998824960 1686636672 17.073 100 76 150 0 1719852688 11699984 21516032
23:04:06 6454 8192000000 10639164224 11015495680 1700566768 17.190 100 76 151 0 1734966160 12406816 21992576
23:04:19 8871 8192000000 10670764272 11042582528 1725152016 17.395 100 86 172 0 1762419632 12664352 24603264
23:04:39 6375 8192000000 10677610720 11052679168 1740450912 17.522 100 82 162 0 1777213616 13757712 23004992
23:04:53 8332 8192000000 10693047872 11069005824 1752162128 17.620 100 84 168 2 1790188688 13851456 24175104
23:05:08 3382 8192000000 10701205584 11080646656 1759133664 17.677 100 76 151 0 1793229808 12926704 21169440
23:05:18 4377 8192000000 10710524544 11089657856 1768696544 17.756 100 79 158 0 1803814688 13287280 21830864
23:05:29 4963 8192000000 10720286736 11098931200 1781466400 17.862 100 86 166 2 1817733360 12592384 23674576
23:05:41 3389 8192000000 10724496768 11107672064 1788963520 17.923 100 86 173 1 1825558736 12684304 23910912
23:05:50 3709 8192000000 10737431408 11118465024 1795045184 17.973 100 86 170 1 1832870304 13378848 24446272
23:06:01 3598 8192000000 10741021184 11123351552 1802390336 18.034 100 88 175 0 1839175248 12061824 24723088
23:06:11 8356 8192000000 10742718576 11130208256 1809338432 18.090 100 84 167 2 1844593856 12270112 22985312
23:06:28 4746 8192000000 10763854912 11146280960 1814880816 18.136 100 79 156 2 1849588624 12363024 22344784
23:06:39 3435 8192000000 10771165232 11164033024 1831805888 18.274 100 89 177 4 1869713248 13346096 24561264
23:06:49 2537 8192000000 10777355808 11163934720 1839739344 18.339 100 84 166 1 1875536992 13181520 22616128
23:06:58 2821 8192000000 10783162016 11169890304 1842669600 18.363 100 81 162 1 1877564384 12107024 22787760
23:07:09 2286 8192000000 10793627552 11181142016 1847612384 18.403 100 88 175 0 1886136944 13769504 24755056
23:07:17 2757 8192000000 10792124624 11183497216 1848538704 18.410 100 84 169 1 1885765456 13598272 23628480
23:07:26 1917 8192000000 10800621856 11187707904 1853405472 18.450 100 95 189 0 1894175120 13582064 27187584
23:07:34 1740 8192000000 10804783360 11189669888 1855865968 18.470 100 90 181 0 1893426512 12780880 24779664
23:07:43 1870 8192000000 10803455920 11193491456 1858247744 18.489 100 83 166 0 1894317008 12517280 23551984
23:07:51 2054 8192000000 10801018560 11192406016 1862369120 18.522 100 86 172 3 1899016032 12828528 23818384
23:08:00 1942 8192000000 10807709968 11200745472 1866924080 18.559 100 87 175 0 1904540352 13386784 24229488
23:08:08 2203 8192000000 10813294672 11203706880 1872743280 18.606 100 94 185 0 1912042960 13759600 25540080
23:08:17 2504 8192000000 10817465376 11207557120 1870321760 18.587 100 89 178 3 1911054592 15323776 25409056
23:08:26 1495 8192000000 10819699744 11208237056 1871126016 18.593 100 94 190 1 1913212656 14850592 27236048
23:08:34 2786 8192000000 10803361376 11207536640 1871995408 18.600 100 78 157 0 1907588208 13038992 22553808
23:08:44 3257 8192000000 10807490432 11207544832 1879889440 18.664 100 80 159 2 1913281424 10289776 23102208
23:08:55 16715 8192000000 10797121792 11198484480 1868870192 18.575 100 46 92 2 1889682912 7657248 13155472
23:09:30 1339 8192000000 10824846240 11218014208 1879346640 18.660 100 88 176 1 1914307200 9805392 25155168
23:09:39 4540 8192000000 10793477056 11211243520 1873602720 18.613 100 41 82 3 1894408480 9396640 11409120
23:09:50 8880 8192000000 10782882304 11208339456 1873945008 18.616 100 31 60 1 1889938992 7206912 8787072
23:10:06 6616 8192000000 10806307248 11209080832 1877585088 18.646 100 34 69 1 1892966112 5245024 10136000
23:10:19 5207 8192000000 10794846880 11215745024 1876380656 18.636 100 32 64 2 1892881008 7265072 9235280
23:10:31 11137 8192000000 10777815808 11213832192 1873954096 18.616 100 19 39 2 1886201616 6858096 5389424
23:10:50 7071 8192000000 10787497216 11214348288 1874353472 18.619 100 17 34 1 1885529056 6120640 5054944
23:11:05 7771 8192000000 10785870672 11213672448 1875995408 18.633 100 15 30 2 1886609600 6055632 4558560
23:11:20 55542 8192000000 10809526976 11224764416 1882379696 18.684 100 35 70 1 1898282752 5288992 10614064
23:12:25 8469 8192000000 10793355328 11226083328 1881583376 18.678 100 29 59 1 1895529600 5679504 8266720
23:12:42 14266 8192000000 10791867520 11227099136 1882602496 18.686 100 14 25 3 1891425888 5585696 3237696
23:13:03 8933 8192000000 10795296256 11231870976 1886428304 18.717 100 17 34 1 1897372880 6103024 4841552
23:13:18 8174 8192000000 10800503536 11237961728 1890663040 18.751 100 27 54 3 1904425536 6318160 7444336
23:13:33 5511 8192000000 10798624112 11233382400 1891317728 18.756 100 29 58 2 1906316160 6277712 8720720
23:13:49 10064 8192000000 10804624784 11238735872 1890618768 18.751 100 16 32 1 1902360944 6410912 5331264
23:14:05 4948 8192000000 10808428032 11241517056 1895133712 18.787 100 24 48 1 1908013328 6204480 6675136
23:14:19 12551 8192000000 10807042992 11242020864 1894295904 18.780 100 17 34 1 1905103632 5594352 5213376
23:14:41 13332 8192000000 10814295216 11248156672 1898172752 18.812 100 20 40 1 1913536160 10416832 4946576
23:15:08 7563 8192000000 10809023520 11242876928 1895698544 18.792 100 17 34 1 1906518272 5270912 5548816
23:15:24 8488 8192000000 10804423664 11235667968 1873812112 18.615 99 17 32 1 1884573824 5470800 5290912
23:15:42 9353 8192000000 10810818720 11244679168 1894372480 18.781 100 27 54 0 1908539280 6332976 7833824
23:16:00 51564 8192000000 10810639120 11239256064 1878112000 18.650 99 28 56 1 1891119424 5121296 7886128
23:17:07 16596 8192000000 10805948480 11226771456 1858990048 18.495 98 58 114 4 1881409616 5359328 17060240
23:17:37 8803 8192000000 10793581824 11220619264 1864037552 18.536 99 20 40 1 1875477200 5445200 5994448
23:17:57 6991 8192000000 10792429888 11215269888 1859901616 18.502 99 26 52 0 1872486928 5799440 6785872
23:18:11 5246 8192000000 10767681136 11196907520 1833696080 18.289 98 37 75 4 1851441088 6995760 10749248
23:18:23 3933 8192000000 10764915104 11184386048 1816851808 18.152 98 41 82 2 1835284960 6791216 11641936
23:18:36 7456 8192000000 10718737584 11136851968 1787415664 17.911 97 27 55 5 1800273408 5216912 7640832
23:18:54 8928 8192000000 10728051312 11145699328 1748553200 17.590 96 23 46 0 1761928576 7092848 6282528
23:19:10 5116 8192000000 10735213424 11159445504 1810913424 18.103 99 30 60 4 1826550384 6665888 8971072
23:19:25 12712 8192000000 10725539296 11147206656 1810217776 18.098 99 26 52 1 1823523248 5793968 7511504
23:19:44 9326 8192000000 10709366560 11142922240 1769075808 17.759 97 24 48 1 1783208304 6116928 8015568
23:20:01 4439 8192000000 10700462368 11121876992 1757423232 17.663 97 16 32 3 1767767232 5980928 4363072
23:20:15 14164 8192000000 10695364448 11120271360 1749026560 17.594 97 20 40 2 1759834336 5166208 5641568
23:20:40 8423 8192000000 10702153984 11116806144 1756678784 17.657 98 22 42 4 1768284480 5690160 5915536
23:20:59 9167 8192000000 10702200752 11118424064 1762352720 17.704 98 24 48 2 1774625328 5733632 6538976
23:21:14 19782 8192000000 10710064992 11108737024 1772068256 17.784 98 35 70 3 1787684256 5597376 10018624
23:21:40 75888 8192000000 10697859488 11122704384 1719688384 17.350 95 34 67 1 1734184848 4797744 9698720
23:23:05 4331 8192000000 10701821456 11117875200 1753377696 17.630 98 20 40 0 1769635264 10566304 5691264
23:23:16 9503 8192000000 10722187008 11131121664 1781428688 17.861 99 37 74 1 1798156432 6556016 10171728
23:23:35 5895 8192000000 10706979952 11114086400 1771797616 17.782 98 31 62 0 1786360816 5641392 8921808
23:23:51 6746 8192000000 10722223056 11144859648 1812964912 18.120 100 36 72 0 1834880864 10067072 11848880
23:24:04 6978 8192000000 10739101152 11153272832 1814771792 18.135 100 28 56 2 1827972768 5287728 7913248
23:24:19 7494 8192000000 10751169776 11161280512 1820422096 18.181 100 29 57 2 1834841888 5940576 8479216
23:24:32 6297 8192000000 10738607696 11164000256 1821757040 18.192 100 17 34 1 1832882112 6381200 4743872
23:24:45 6015 8192000000 10731902576 11138301952 1806673008 18.069 99 30 61 2 1820555040 5271984 8610048
23:24:57 8627 8192000000 10743396688 11164590080 1830003584 18.259 100 32 64 3 1845284320 5464912 9815824
23:25:12 9138 8192000000 10747424256 11176251392 1831340848 18.270 100 25 48 3 1848218224 10161200 6716176
23:25:30 10334 8192000000 10771257120 11181117440 1839208352 18.334 100 38 77 1 1856434624 5109888 12116384
23:25:47 8609 8192000000 10753147520 11178983424 1842124272 18.358 100 35 68 1 1858148112 5424896 10598944
23:26:03 13585 8192000000 10769757584 11185020928 1844180576 18.375 100 19 38 3 1855615440 5019776 6415088
23:26:30 48674 8192000000 10778501568 11191795712 1851794912 18.437 100 23 46 1 1863952608 5351712 6805984
23:27:30 99305 8192000000 10817299440 11234111488 1875934448 18.632 100 35 70 4 1892790720 7148592 9707680
23:29:21 24615 8192000000 10831398448 11251834880 1901073104 18.835 100 40 78 0 1919658864 7488400 11097360
23:29:59 16205 8192000000 10857425648 11270934528 1914385616 18.942 100 49 98 0 1938833648 9845840 14602192
23:30:29 27419 8192000000 10855182128 11281481728 1922899600 19.010 100 55 110 0 1952141472 12991072 16250800
23:31:08 19842 8192000000 10845977024 11280883712 1924822512 19.025 100 38 76 1 1948325376 12124848 11378016
23:31:37 24195 8192000000 10866676032 11295444992 1933954208 19.098 100 45 90 2 1959969248 12616032 13399008
23:32:10 14294 8192000000 10871288416 11299008512 1935504320 19.111 100 41 82 2 1959806064 12186096 12115648
23:32:31 4316 8192000000 10883790384 11304054784 1923416928 19.014 99 51 102 1 1954164480 15745904 15001648
23:32:51 34638 8192000000 10891306400 11315253248 1945175648 19.188 100 50 98 0 1974631760 15166336 14289776
23:33:49 9420 8192000000 10903619712 11327373312 1955698976 19.272 100 60 118 1 1991161760 17099952 18362832
23:34:06 3575 8192000000 10909903104 11328512000 1962882576 19.329 100 68 134 0 2000057344 17694480 19480288
23:34:18 22304 8192000000 10905949168 11328544768 1957100256 19.283 100 52 104 2 1989658704 16922928 15635520
23:34:47 6958 8192000000 10901838624 11326435328 1960352128 19.309 100 52 103 5 1991830176 15883872 15594176
23:35:01 17519 8192000000 10908455168 11337195520 1963956176 19.337 100 46 92 3 1994395584 16970000 13469408
23:35:29 7465 8192000000 10918784064 11341283328 1968919216 19.377 100 56 108 2 2003050720 18268320 15863184
23:35:44 4485 8192000000 10916826768 11329839104 1959743856 19.304 99 67 134 0 2000912192 22085840 19082496
23:35:56 3088 8192000000 10935644288 11355697152 1977368112 19.444 100 72 143 3 2022415504 22820096 22227296
23:36:07 12624 8192000000 10928369760 11352903680 1980142304 19.466 100 69 138 2 2024015088 22945968 20926816
23:36:28 9929 8192000000 10934029952 11362148352 1977874576 19.448 100 59 118 3 2020246432 24570656 17801200
23:36:59 14561 8192000000 10937953136 11372068864 1985954192 19.512 100 48 95 3 2023466464 23143888 14368384
23:37:24 3249 8192000000 10933336192 11359662080 1971855248 19.400 99 64 128 1 2013329792 21334736 20139808
23:37:37 4054 8192000000 10951128848 11367448576 1984753344 19.502 100 60 120 1 2025625584 23100560 17771680
23:37:48 4719 8192000000 10940504960 11365257216 1987339872 19.523 100 72 144 2 2031890496 23303920 21246704
23:38:00 6461 8192000000 10954423168 11373830144 1995254576 19.585 100 78 156 0 2039876480 21486192 23135712
23:38:18 2126 8192000000 10948442880 11368423424 1980786096 19.471 99 73 144 3 2024218560 22497136 20935328
23:38:28 1982 8192000000 10944328608 11365208064 1989087824 19.537 100 77 153 1 2034523952 22888400 22547728
23:38:37 5487 8192000000 10948704688 11362807808 1986974368 19.520 100 77 152 3 2031138208 22378064 21785776
23:38:49 3807 8192000000 10944632320 11354664960 1975250608 19.427 99 79 158 3 2022376448 23185568 23940272
23:38:59 2538 8192000000 10952554848 11371954176 1991548128 19.556 100 79 158 0 2039796224 24172176 24075920
23:39:09 1927 8192000000 10959030016 11371753472 1995597008 19.588 100 88 176 0 2046318864 24349904 26371952
23:39:20 5871 8192000000 10936363264 11357102080 1973586848 19.414 99 68 135 1 2017514592 23987232 19940512
23:39:32 2212 8192000000 10954671280 11372564480 1991461200 19.555 100 72 144 3 2037231424 23684416 22085808
23:39:42 1944 8192000000 10955499904 11375042560 1997355728 19.602 100 69 139 0 2041279328 23126048 20797552
23:39:54 2085 8192000000 10973723584 11384934400 2002239456 19.640 100 82 165 1 2050412544 23469616 24703472
23:40:02 5257 8192000000 10959785360 11383218176 2000770032 19.629 100 75 150 0 2047256928 23371984 23114912
23:40:17 1143 8192000000 10977300032 11390513152 2011217328 19.711 100 87 173 1 2060920064 23495440 26207296
23:40:25 2956 8192000000 10971197360 11389788160 2006876768 19.677 100 78 155 4 2053947312 24777472 22293072
23:40:35 1880 8192000000 10966640416 11381035008 1984709024 19.502 99 88 174 4 2036126016 25623216 25793776
23:40:44 2760 8192000000 10955213664 11368591360 1988299232 19.530 100 90 176 1 2042244656 27104576 26840848
23:40:54 2123 8192000000 10967510080 11381583872 1998066880 19.607 100 85 170 0 2051049856 27592368 25390608
23:41:03 6035 8192000000 10948180288 11370840064 1972199248 19.403 99 77 154 1 2024174368 28734784 23240336
23:41:16 3720 8192000000 10966330096 11380400128 1992221552 19.561 100 77 152 0 2039778704 24547216 23009936
23:41:29 2060 8192000000 10971068752 11378417664 1981743648 19.479 99 90 178 1 2035704208 26771856 27188704
23:41:38 1286 8192000000 10961975408 11367759872 1982438192 19.484 99 95 190 1 2038852848 27146896 29267760
23:41:45 2198 8192000000 10927558144 11337564160 1960476064 19.310 99 87 172 0 2014941472 28210272 26255136
23:41:55 5056 8192000000 10940415024 11356561408 1972343824 19.404 100 84 169 1 2028843072 30195904 26303344
23:42:08 5859 8192000000 10936914176 11351572480 1966837200 19.360 100 89 176 2 2024273424 30339824 27096400
23:42:21 1054 8192000000 10939023648 11347181568 1962514592 19.326 100 91 184 0 2021400128 31571552 27313984
23:42:29 1853 8192000000 10941082800 11346411520 1955113408 19.267 100 87 173 2 2015669888 33642624 26913856
23:42:38 5568 8192000000 10933593392 11352530944 1963430160 19.333 100 78 154 0 2020716944 33391216 23895568
23:42:50 3833 8192000000 10917455712 11332603904 1951882480 19.241 99 83 164 1 2011529552 34273360 25373712
23:43:02 5730 8192000000 10936549744 11359027200 1965635664 19.351 100 62 122 1 2019872688 35189712 19047312
23:43:15 1792 8192000000 10934289856 11338629120 1945345520 19.189 99 87 172 1 2007192736 35234976 26612240
23:43:26 4846 8192000000 10950709472 11359162368 1962302624 19.324 100 79 158 0 2024189744 37199312 24687808
23:43:38 4404 8192000000 10940976240 11357683712 1966932768 19.361 100 76 152 0 2027217408 36251360 24033280
23:43:53 1302 8192000000 10941611616 11352436736 1959768144 19.304 100 86 169 0 2023114256 37398048 25948064
23:44:01 2358 8192000000 10951258384 11362652160 1966650800 19.359 100 83 166 0 2030533712 37606992 26275920
23:44:10 4892 8192000000 10936824272 11356196864 1960257456 19.308 100 73 144 1 2017147696 34488512 22401728
23:44:22 8004 8192000000 10933489808 11357134848 1967275104 19.364 100 62 123 1 2016770304 30018832 19476368
23:44:37 7899 8192000000 10942429616 11360591872 1969022896 19.378 100 69 138 0 2024224400 33464176 21737328
23:44:54 3255 8192000000 10964314016 11378524160 1985120368 19.505 100 82 163 0 2046365504 35877200 25367936
23:45:04 2649 8192000000 10962916144 11377106944 1982110208 19.481 100 81 163 0 2042488784 35194000 25184576
23:45:15 4032 8192000000 10958408896 11377254400 1981448144 19.476 100 70 140 1 2037421520 33869712 22103664
23:45:26 3347 8192000000 10965903440 11377930240 1980523040 19.469 100 92 183 0 2044383072 35466240 28393792
23:45:36 3354 8192000000 10955472384 11369189376 1971602288 19.398 100 81 162 0 2032049936 35628592 24819056
23:45:52 4661 8192000000 10927033744 11352068096 1955438048 19.270 100 65 130 1 2015988880 40292352 20258480
23:46:04 1491 8192000000 10923969632 11341598720 1949409392 19.222 100 67 133 2 2006346400 36493728 20443280
23:46:13 9472 8192000000 10887506496 11308855296 1899953696 18.826 98 51 102 0 1950345008 34208128 16183184
23:46:32 4654 8192000000 10912627136 11327045632 1941329616 19.157 100 44 87 6 1984044384 29332944 13381824
23:46:45 5350 8192000000 10922131120 11339161600 1949391600 19.222 100 57 114 0 1997879936 30976896 17511440
23:46:58 6337 8192000000 10906651200 11339288576 1950208896 19.228 100 49 99 0 1996254176 30921328 15123952
23:47:15 1809 8192000000 10929588336 11343753216 1958738592 19.296 100 78 152 2 2018219584 34902256 24578736
23:47:23 5051 8192000000 10918658560 11346464768 1956417536 19.278 100 50 100 1 2005616624 33590176 15608912
23:47:35 7630 8192000000 10917366192 11353157632 1959305456 19.301 100 50 100 2 2009307040 34288480 15713104
23:48:01 4873 8192000000 10912648736 11336081408 1949520160 19.223 100 44 87 0 1995401216 31866896 14014160
23:48:14 6046 8192000000 10934011264 11345612800 1954431920 19.262 100 73 143 1 2009940176 33386032 22122224
23:48:27 1513 8192000000 10926508672 11332526080 1942249056 19.165 99 79 158 2 2002003136 35049824 24704256
23:48:36 4159 8192000000 10933377792 11354763264 1959200352 19.300 100 63 125 1 2017780992 39320816 19259824
23:49:01 18093 8192000000 10908663376 11345113088 1945859648 19.193 100 34 68 1 1994945456 37910608 11175200
23:49:26 7060 8192000000 10919012848 11351404544 1951008336 19.235 100 37 71 2 2002537504 39447344 12081824
23:49:41 10174 8192000000 10923205056 11362226176 1960150528 19.307 100 38 76 2 2015894064 42548944 13194592
23:50:17 18940 8192000000 10931299840 11367862272 1952777056 19.249 100 31 62 0 2012247888 48580736 10890096
23:50:46 21701 8192000000 10935093856 11377213440 1958488080 19.294 100 46 90 1 2027426432 53848192 15090160
23:51:17 14639 8192000000 10934934448 11380559872 1954274176 19.261 100 34 68 2 2018123680 51024928 12824576
23:51:46 16021 8192000000 10932853120 11363815424 1950669600 19.232 100 45 90 3 2011509488 46129040 14710848
23:52:09 35818 8192000000 10876617216 11319816192 1905502448 18.871 98 36 72 2 1964214880 46044512 12667920
23:52:51 31438 8192000000 10910689616 11358621696 1933165488 19.092 100 31 62 0 1992396448 49212672 10018288
23:53:35 18963 8192000000 10892988688 11348209664 1915037216 18.947 99 29 58 2 1972502960 47492944 9972800
23:54:32 31335 8192000000 10855286832 11318468608 1874964144 18.624 98 13 26 0 1916270624 36733216 4573264
23:55:10 30897 8192000000 10863348704 11336220672 1908300608 18.893 100 15 30 1 1958053664 44566400 5186656
23:55:56 69007 8192000000 10846843120 11310370816 1897185536 18.804 99 14 28 0 1915750672 14258944 4306192
23:57:12 97595 8192000000 10871873776 11330498560 1904510640 18.863 98 10 21 1 1921315232 14172480 2632112
23:58:55 82359 8192000000 10877777552 11330887680 1922850112 19.010 99 11 22 1 1937560272 11681648 3028512
00:00:38 67070 8192000000 10897330288 11341262848 1916901744 18.962 98 22 43 2 1933933760 10795536 6236480
00:01:56 47391 8192000000 10898485376 11360133120 1954649616 19.263 100 12 24 1 1975305760 17133120 3523024
00:03:28 83052 8192000000 10917434208 11353808896 1900699504 18.832 96 31 61 0 1918747792 9478240 8570048
00:04:59 25458 8192000000 10895615568 11353960448 1945853456 19.193 99 18 36 1 1961307232 10504576 4949200
00:06:18 81345 8192000000 10887192224 11345031168 1916958784 18.962 97 35 70 2 1934203328 7689376 9555168
00:08:40 70192 8192000000 10924167616 11370024960 1951481696 19.238 99 29 57 3 1972254704 12960480 7812528
00:09:58 42727 8192000000 10930926512 11378364416 1957072128 19.283 99 29 58 0 1985521616 19439232 9010256
00:10:56 61465 8192000000 10903779440 11365199872 1955492240 19.270 99 21 41 1 1980221136 18328864 6400032
00:12:33 19318 8192000000 10928498656 11374370816 1978958592 19.456 100 32 64 0 2005766768 17313568 9494608
00:13:00 34617 8192000000 10908313696 11372036096 1967478032 19.365 100 22 44 1 1988825856 14784368 6563456
00:13:41 42333 8192000000 10927971728 11395391488 1986879632 19.519 100 22 44 2 2014651456 20701232 7070592
00:14:56 12064 8192000000 10948229248 11402018816 2002979200 19.646 100 51 100 6 2037404080 18758992 15665888
00:15:28 71380 8192000000 10906320800 11403399168 1971039888 19.394 99 19 38 0 1995656128 18150656 6465584
00:16:46 18152 8192000000 10895271568 11377340416 1954402096 19.262 99 6 12 0 1969993632 13892048 1699488
00:17:11 65552 8192000000 10910294016 11386286080 1986610560 19.517 100 29 58 1 2000413664 6202304 7600800
00:19:21 27587 8192000000 10905772496 11390988288 1981692432 19.478 100 4 8 0 1994251040 11310256 1248352
00:20:07 51362 8192000000 10912263152 11394854912 1989921888 19.543 100 15 30 1 2003923456 9822256 4179312
00:21:10 94656 8192000000 10894089536 11379560448 1896138192 18.795 95 16 32 0 1911827120 11850176 3838752
00:22:51 29738 8192000000 10899292992 11381157888 1974686112 19.423 100 12 24 1 1992212224 14380912 3145200
00:23:27 18523 8192000000 10911462336 11394686976 1989041840 19.536 100 19 37 1 2007629648 12742000 5845808
00:23:51 29515 8192000000 10904122352 11372802048 1970440928 19.389 99 12 24 0 1985870736 11849376 3580432
00:25:08 64486 8192000000 10885418464 11365240832 1947410448 19.206 98 14 28 0 1965695200 13643968 4640784
00:26:42 36829 8192000000 10870361632 11335802880 1876933808 18.640 95 13 26 1 1894456736 13670848 3852080
00:27:28 42547 8192000000 10864612656 11321110528 1867565888 18.565 95 23 46 1 1886354784 11957664 6831232
00:28:16 64118 8192000000 10887899360 11358101504 1897303840 18.805 97 27 54 1 1917484192 13272912 6907440
00:29:36 46692 8192000000 10897426304 11373080576 1962272768 19.324 100 14 28 1 1989201072 23043040 3885264
00:30:29 29974 8192000000 10878162992 11334123520 1884607312 18.702 96 15 29 0 1896958944 8874272 3477360
00:31:05 23785 8192000000 10876920560 11324772352 1884629152 18.702 96 33 66 1 1905696320 11769472 9297696
00:31:37 42645 8192000000 10868573104 11318075392 1904858832 18.865 98 31 62 0 1927880432 14222976 8798624
00:32:27 65098 8192000000 10865243120 11345309696 1893549520 18.774 97 23 46 1 1914870272 14834080 6486672
00:33:38 76234 8192000000 10884550672 11329462272 1820915216 18.185 93 22 44 1 1842936352 15911280 6109856
00:35:03 45892 8192000000 10892010976 11354025984 1918613424 18.976 98 41 83 0 1949129424 18105200 12410800
00:36:01 65105 8192000000 10880454400 11346894848 1871433952 18.596 96 13 25 2 1893131136 17107584 4589600
00:37:13 45518 8192000000 10904783344 11367268352 1955167840 19.268 100 24 48 0 1978140624 16537104 6435680
00:38:04 57077 8192000000 10891919808 11355742208 1865401280 18.547 95 19 38 1 1886435520 15622208 5412032
00:39:08 58246 8192000000 10897137808 11361693696 1906169856 18.876 98 12 24 0 1931446368 22264480 3012032
00:40:13 118219 8192000000 10881485920 11340079104 1926103728 19.036 99 18 36 2 1943077376 11652560 5321088
00:42:17 65105 8192000000 10876068016 11340759040 1898853520 18.817 97 28 54 2 1916908496 10569824 7485152
00:43:33 5451 8192000000 10885207136 11345776640 1954544640 19.263 100 28 56 0 1973301088 10581472 8174976
00:43:45 9281 8192000000 10870901104 11343663104 1950640400 19.232 100 13 26 0 1964486576 10252192 3593984
00:44:05 41154 8192000000 10887640512 11359207424 1956730256 19.280 100 26 53 0 1976162896 12497328 6935312
00:45:00 64159 8192000000 10874628960 11362570240 1943549984 19.175 99 12 24 0 1961874720 15017040 3307696
00:46:17 44517 8192000000 10871657280 11343077376 1930229360 19.069 99 11 20 1 1941975152 9063712 2682080
00:47:18 106400 8192000000 10877653696 11347398656 1900601760 18.831 97 13 26 1 1918817376 14382016 3833600
00:49:12 64438 8192000000 10859021456 11338178560 1930404368 19.070 99 17 33 0 1950327152 14890704 5032080
00:50:26 33682 8192000000 10894115616 11350519808 1950868080 19.233 100 36 72 0 1971824032 10529312 10426640
00:51:06 30846 8192000000 10864831232 11338579968 1936384768 19.118 99 15 29 1 1948296656 8365344 3546544
00:51:49 52253 8192000000 10874839472 11355635712 1954348416 19.261 100 18 36 2 1967623472 8246160 5028896
00:52:49 66314 8192000000 10883586944 11358982144 1935781616 19.113 99 5 10 0 1946443152 9457712 1203824
00:54:52 69491 8192000000 10888513584 11371270144 1945891392 19.194 99 12 24 1 1964048816 14831168 3326256
00:56:08 30677 8192000000 10893511536 11356168192 1949046464 19.219 99 28 57 1 1965494160 9059520 7388176
00:56:45 18658 8192000000 10895418208 11360227328 1965086976 19.346 100 27 54 2 1981440496 8805632 7547888
00:57:13 57858 8192000000 10845239840 11313786880 1855413168 18.466 95 24 48 0 1871780528 9631264 6736096
00:58:23 37800 8192000000 10892993408 11353870336 1947712736 19.208 100 23 46 1 1962420224 8440112 6267376
00:59:15 83945 8192000000 10871548064 11346145280 1919256256 18.981 98 30 59 2 1937955376 10730000 7969120
01:00:48 86817 8192000000 10891215088 11360751616 1930262224 19.069 98 25 51 0 1951546912 14102976 7181712
01:02:21 87255 8192000000 10908663392 11376046080 1933820336 19.097 98 14 28 1 1947449216 10558960 3069920
01:03:54 17904 8192000000 10907950896 11368038400 1954647344 19.263 99 24 48 0 1968905408 7837104 6420960
01:04:20 22096 8192000000 10928748144 11380076544 1964259920 19.340 99 36 72 1 1987792496 13545536 9987040
01:04:51 69519 8192000000 10906399056 11381067776 1938571776 19.135 98 23 44 1 1960092064 15401248 6119040
01:06:09 34149 8192000000 10893468640 11367669760 1911961232 18.922 97 14 28 2 1932685328 17043472 3680624
01:07:37 42274 8192000000 10879415952 11338833920 1931591008 19.080 99 14 28 0 1943702080 7629936 4481136
01:09:57 56255 8192000000 10843463424 11325706240 1901671024 18.840 97 8 16 1 1913717680 9145744 2900912
01:10:59 26764 8192000000 10853770000 11327954944 1911019632 18.915 98 18 36 2 1923501664 7718416 4763616
01:11:32 17781 8192000000 10868129280 11332550656 1927377984 19.046 99 26 53 2 1942912448 7331120 8203344
01:12:09 43200 8192000000 10872919856 11353919488 1948589936 19.215 100 5 10 0 1961067776 11338112 1139728
01:12:58 27361 8192000000 10877298240 11356508160 1956698896 19.280 100 12 24 0 1975102752 15215616 3188240
01:13:32 62541 8192000000 10868809216 11340005376 1920875360 18.994 98 14 28 1 1938146064 13219968 4050736
01:14:41 76909 8192000000 10875792912 11351044096 1939653712 19.144 99 17 34 0 1954786592 10269664 4863216
01:16:05 64774 8192000000 10850952096 11327631360 1856207072 18.473 95 9 18 2 1869477712 10648800 2621840
01:17:16 20155 8192000000 10856397504 11314798592 1894822160 18.785 98 36 74 0 1913106256 7500560 10783536
01:17:49 60109 8192000000 10861391456 11334504448 1871379552 18.595 96 28 57 3 1889419008 10063296 7976160
01:18:58 35835 8192000000 10872817216 11350663168 1947391792 19.206 100 25 50 1 1963792576 8579552 7821232
01:19:42 35413 8192000000 10861472560 11331522560 1891353056 18.757 97 21 42 1 1910345120 12647360 6344704
01:20:27 52125 8192000000 10867249536 11334488064 1887003184 18.722 97 21 42 1 1908812464 15162032 6647248
01:21:39 37890 8192000000 10843877584 11305639936 1862953888 18.527 97 19 38 1 1879522992 11567952 5001152
01:22:27 51124 8192000000 10859408320 11318050816 1888035008 18.730 98 28 56 2 1915295088 18633984 8626096
01:23:25 79391 8192000000 10852599984 11322957824 1849742416 18.420 96 20 40 2 1874495952 18795728 5957808
01:24:57 73252 8192000000 10885157552 11338080256 1910347888 18.909 99 14 28 1 1931639088 17421424 3869776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 29-12-2020 01:28:15 to 29-12-2020 01:28:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 29-12-2020 01:28:48 to 29-12-2020 01:28:50.

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          246447
MON$OLDEST_ACTIVE               247406
MON$OLDEST_SNAPSHOT             247406
MON$NEXT_TRANSACTION            247406
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                       2038240
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:33: 
:34: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:16 2020
:35:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:36: 
:37: 
:38: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:17 2020
:39:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:40: 
:41: 
:42: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:30 2020
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:44: 
:45: 
:46: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:31 2020
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
:49: 
:50: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:31 2020
:51:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:52: 
:53: 
:54: mscs-test-161.budzdorov.ru    Tue Dec 29 01:27:31 2020
:55:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:56: 
--- end of diff output ---

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

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