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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-14 19:27:16
DTS_END                         2021-02-14 19:27:16.9410
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/49474
TRN_ID                          234804
ATT_ID                          643
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: 9355.01 21210 1122601
customer order: creation 168.73 357 20247
customer order: refuse 14.48 372 1738
order to supplier: creation 44.83 1391 5380
order to supplier: removal 3.48 113154 418
invoice (draft): creation 46.12 3583 5534
invoice (draft): removal 54.33 900 6520
invoice accept: apply 41.51 18459 4981
invoice accept: cancel 49.21 846 5905
customer reserve: creation 3871.50 180 464580
customer reserve: removal 4762.26 64 571471
realization accept: apply 83.05 179 9966
realization accept: cancel 87.79 119 10535
payment from customer: creation 58.11 114 6973
payment from customer: removal 6.08 72 730
payment to supplier: creation 47.19 126 5663
payment to supplier: removal 3.43 134 412
service: total inventory turnovers 4.85 1128 582
service: total monetary turnovers 7.03 30 843
service: aggregate perf. data 0.99 17380 119
service: refresh index statistics 0.03 265606 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-02-2021 19:27:58 to 14-02-2021 19:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4019
TEST_TIME 2 4931
TEST_TIME 3 5625
TEST_TIME 4 5582
TEST_TIME 5 5491
TEST_TIME 6 5335
TEST_TIME 7 5698
TEST_TIME 8 5738
TEST_TIME 9 5986
TEST_TIME 10 6148
TEST_TIME 11 6678
TEST_TIME 12 6866
TEST_TIME 13 7478
TEST_TIME 14 7777
TEST_TIME 15 8020
TEST_TIME 16 8077
TEST_TIME 17 8026
TEST_TIME 18 7963
TEST_TIME 19 8168
TEST_TIME 20 8620
TEST_TIME 21 8816
TEST_TIME 22 8890
TEST_TIME 23 9320
TEST_TIME 24 9484
TEST_TIME 25 9546
TEST_TIME 26 9725
TEST_TIME 27 9884
TEST_TIME 28 10834
TEST_TIME 29 11785
TEST_TIME 30 11482
TEST_TIME 31 11459
TEST_TIME 32 11334
TEST_TIME 33 11232
TEST_TIME 34 11004
TEST_TIME 35 10827
TEST_TIME 36 10619
TEST_TIME 37 10537
TEST_TIME 38 10701
TEST_TIME 39 10590
TEST_TIME 40 10399
TEST_TIME 41 10330
TEST_TIME 42 10269
TEST_TIME 43 10216
TEST_TIME 44 10230
TEST_TIME 45 10155
TEST_TIME 46 9991
TEST_TIME 47 9937
TEST_TIME 48 9966
TEST_TIME 49 9916
TEST_TIME 50 10085
TEST_TIME 51 10010
TEST_TIME 52 9896
TEST_TIME 53 9809
TEST_TIME 54 9719
TEST_TIME 55 9621
TEST_TIME 56 9620
TEST_TIME 57 9733
TEST_TIME 58 9671
TEST_TIME 59 9662
TEST_TIME 60 9628
TEST_TIME 61 9772
TEST_TIME 62 9736
TEST_TIME 63 9678
TEST_TIME 64 9749
TEST_TIME 65 9849
TEST_TIME 66 9784
TEST_TIME 67 9905
TEST_TIME 68 9897
TEST_TIME 69 10045
TEST_TIME 70 9979
TEST_TIME 71 9850
TEST_TIME 72 9814
TEST_TIME 73 9845
TEST_TIME 74 9743
TEST_TIME 75 9744
TEST_TIME 76 9696
TEST_TIME 77 9656
TEST_TIME 78 9643
TEST_TIME 79 9572
TEST_TIME 80 9542
TEST_TIME 81 9487
TEST_TIME 82 9492
TEST_TIME 83 9476
TEST_TIME 84 9422
TEST_TIME 85 9499
TEST_TIME 86 9470
TEST_TIME 87 9470
TEST_TIME 88 9463
TEST_TIME 89 9466
TEST_TIME 90 9497
TEST_TIME 91 9563
TEST_TIME 92 9581
TEST_TIME 93 9574
TEST_TIME 94 9564
TEST_TIME 95 9637
TEST_TIME 96 9598
TEST_TIME 97 9674
TEST_TIME 98 9707
TEST_TIME 99 9660
TEST_TIME 100 9596
TEST_TIME 101 9578
TEST_TIME 102 9529
TEST_TIME 103 9510
TEST_TIME 104 9476
TEST_TIME 105 9451
TEST_TIME 106 9420
TEST_TIME 107 9412
TEST_TIME 108 9367
TEST_TIME 109 9316
TEST_TIME 110 9298
TEST_TIME 111 9341
TEST_TIME 112 9401
TEST_TIME 113 9383
TEST_TIME 114 9377
TEST_TIME 115 9406
TEST_TIME 116 9389
TEST_TIME 117 9384
TEST_TIME 118 9421
TEST_TIME 119 9410
TEST_TIME 120 9362

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-02-2021 19:28:02 to 14-02-2021 19:28:05.

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 1551395 1551395 0 0.00 0 34244 7 0 0
doc_list_biud 1551381 1551381 0 0.00 0 83644 30 0 0
sp_add_invoice_to_stock 5089 4981 108 2.12 32 184599 18460 0 108
sp_cancel_adding_invoice 5905 5905 0 0.00 4 75907 846 0 0
sp_cancel_client_order 1738 1738 0 0.00 5 17049 372 0 0
sp_cancel_customer_reserve 571471 571471 0 0.00 1 83647 65 0 0
sp_cancel_pay_from_customer 730 730 0 0.00 3 2368 72 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 5567 134 0 0
sp_cancel_supplier_invoice 6529 6520 9 0.13 1 15918 901 0 9
sp_cancel_supplier_order 418 418 0 0.00 9 1136164 113154 0 0
sp_cancel_write_off 10535 10535 0 0.00 1 11661 119 0 0
sp_client_order 20247 20247 0 0.00 4 37977 358 0 0
sp_customer_reserve 464580 464580 0 0.00 0 40982 181 0 0
sp_fill_shopping_cart 31151 31151 0 0.00 1 24180 49 0 0
sp_fill_shopping_cart_clo_res 464566 464566 0 0.00 0 13078 14 0 0
sp_get_clo_for_invoice 4967 4967 0 0.00 0 30438 308 0 0
sp_kill_cost_storno 17582 17582 0 0.00 0 13880 63 0 0
sp_kill_qstorno_ret_qs2qd 1160415 1160415 0 0.00 0 83641 35 0 0
sp_kill_qty_storno 611520 611520 0 0.00 0 83644 76 0 0
sp_lock_selected_doc 20668 20668 0 0.00 0 5778 4 0 0
sp_make_cost_storno 27569 27569 0 0.00 0 12767 53 0 0
sp_multiply_rows_for_pdistr 27569 27569 0 0.00 0 34036 29 0 0
sp_multiply_rows_for_qdistr 20247 20247 0 0.00 0 13188 151 0 0
sp_pay_from_customer 6973 6973 0 0.00 4 13116 114 0 0
sp_pay_to_supplier 5663 5663 0 0.00 5 16792 126 0 0
sp_payment_common 12635 12635 0 0.00 1 11674 30 0 0
sp_qd_handle_on_cancel_clo 1738 1738 0 0.00 0 17043 338 0 0
sp_qd_handle_on_invoice_upd_sts 10872 10872 0 0.00 0 40938 345 0 0
sp_qd_handle_on_reserve_upd_sts 9966 9966 0 0.00 0 13071 61 0 0
sp_reserve_write_off 9966 9966 0 0.00 7 13167 179 0 0
sp_supplier_invoice 5534 5534 0 0.00 6 75043 3584 0 0
sp_supplier_order 5380 5380 0 0.00 5 92540 1392 0 0
srv_aggregate_perf_data 119 119 0 0.00 2455 117557 17381 0 0
srv_fill_mon_cache_memory 176 176 0 0.00 755 188346 28949 0 0
srv_find_qd_qs_mism 1074571 1074571 0 0.00 0 15607 6 0 0
srv_make_invnt_saldo 582 582 0 0.00 21 56012 1129 0 0
srv_make_money_saldo 843 843 0 0.00 0 1184 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 116557 335115 265606 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4983 4983 0 0.00 0 9585 180 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 7882 105 0 0
t$perf-norm:sp_cancel_client_order 1738 1738 0 0.00 0 2890 15 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 851 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 730 730 0 0.00 0 6199 24 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 548 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 5193 30 0 0
t$perf-norm:sp_cancel_supplier_order 418 418 0 0.00 0 24543 1582 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 3735 20 0 0
t$perf-norm:sp_client_order 20247 20247 0 0.00 0 18714 23 0 0
t$perf-norm:sp_customer_reserve 978 978 0 0.00 0 3501 9 0 0
t$perf-norm:sp_pay_from_customer 6973 6973 0 0.00 0 11903 12 0 0
t$perf-norm:sp_pay_to_supplier 5663 5663 0 0.00 0 5036 10 0 0
t$perf-norm:sp_reserve_write_off 9966 9966 0 0.00 0 9804 12 0 0
t$perf-norm:sp_supplier_invoice 5534 5534 0 0.00 0 11943 24 0 0
t$perf-norm:sp_supplier_order 5380 5380 0 0.00 0 6336 17 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 6509 60 0 0
t$perf-norm:srv_fill_mon_cache_memory 176 176 0 0.00 0 3825 33 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 5724 35 0 0
t$perf-norm:srv_make_money_saldo 843 843 0 0.00 0 1485 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10150 9934 216 2.12 0 6379 22 0 216
v_all_customers 36988 36988 0 0.00 0 18 1 0 0
v_all_suppliers 29998 29998 0 0.00 0 18 1 0 0
v_all_wares 40494 40494 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 823 8 0 0
v_cancel_client_order 3476 3476 0 0.00 0 4457 8 0 0
v_cancel_customer_prepayment 1460 1460 0 0.00 0 1605 6 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 2703 6 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 4461 17 0 0
v_cancel_supplier_invoice 824 806 18 2.18 0 5176 34 0 18
v_cancel_supplier_order 836 836 0 0.00 0 2842 14 0 0
v_cancel_write_off 1926 1926 0 0.00 0 5196 20 0 0
v_max_id_clo_ord 5374 5374 0 0.00 0 9168 4 0 0
v_max_id_clo_res 978 978 0 0.00 0 2155 11 0 0
v_max_id_ord_sup 5527 5527 0 0.00 0 7639 7 0 0
v_max_non_paid_invoice 1565 1565 0 0.00 0 457 3 0 0
v_max_non_paid_realizn 3782 3782 0 0.00 0 2097 4 0 0
v_min_id_clo_ord 5374 5374 0 0.00 0 9159 12 0 0
v_min_id_clo_res 978 978 0 0.00 0 4150 15 0 0
v_min_id_ord_sup 5527 5527 0 0.00 0 5437 3 0 0
v_min_non_paid_invoice 5663 5663 0 0.00 0 10738 19 0 0
v_min_non_paid_realizn 6972 6972 0 0.00 0 11670 20 0 0
v_our_firm 9886 9886 0 0.00 0 20 1 0 0
v_reserve_write_off 19932 19932 0 0.00 0 4951 6 0 0
x_lock_depdocs_on_canc_invoice 12022 12022 0 0.00 0 15517 128 0 0
x_lock_depdocs_on_canc_sup_ord 418 418 0 0.00 0 4388 352 0 0
x_make_qstorno_1000_1200 5380 5380 0 0.00 2 89070 1293 0 0
x_make_qstorno_1200_2000 5534 5534 0 0.00 3 75016 3410 0 0
x_make_qstorno_2100_3300 464580 464580 0 0.00 0 40981 164 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-02-2021 19:28:06 to 14-02-2021 19:28:10.

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
16:57:20 2 8192000000 8799211712 8810037248 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:27 14868 8192000000 10235095760 10540605440 963103584 10.519 75 58 116 2 984637232 2622448 18911200
16:57:50 35709 8192000000 10354496320 10667597824 1378276640 14.401 100 86 172 1 1411519168 4947040 28295488
16:58:38 37748 8192000000 10394748224 10718216192 1439740528 14.947 100 89 178 1 1476505040 7056976 29707536
16:59:26 23084 8192000000 10422893648 10751201280 1468858976 15.204 100 83 167 0 1504046896 7780800 27407120
17:00:03 23307 8192000000 10447376064 10779869184 1500641328 15.482 100 90 180 0 1538822144 9188112 28992704
17:00:36 19614 8192000000 10458745376 10793246720 1512116320 15.582 100 91 182 2 1550600336 9495056 28988960
17:01:16 23962 8192000000 10480530096 10823835648 1534845712 15.779 100 83 166 1 1571073168 10010128 26217328
17:01:48 17275 8192000000 10503045488 10848448512 1562397120 16.017 100 81 160 3 1597762896 10690240 24675536
17:02:15 19454 8192000000 10528041744 10880532480 1584093104 16.203 100 81 162 2 1619390752 10999712 24297936
17:02:44 13561 8192000000 10553673184 10910793728 1612070752 16.442 100 83 166 1 1648080944 11335936 24674256
17:03:07 12069 8192000000 10577269008 10936340480 1634048720 16.629 100 80 160 1 1669917280 12025552 23843008
17:03:27 16530 8192000000 10589753520 10956128256 1650891168 16.772 100 77 154 0 1684932048 11909792 22131088
17:03:53 12230 8192000000 10618215376 10986799104 1676053200 16.984 100 80 160 1 1711651104 12207440 23390464
17:04:18 11901 8192000000 10650926336 11021045760 1705728992 17.233 100 84 168 0 1743490272 13226640 24534640
17:04:38 8474 8192000000 10665931968 11038609408 1727043568 17.411 100 81 162 1 1763804896 13359632 23401696
17:04:53 7574 8192000000 10680305552 11053207552 1738675024 17.508 100 89 177 1 1777605968 13885840 25045104
17:05:09 3803 8192000000 10685366240 11063099392 1744564624 17.557 100 78 158 0 1779829888 13285488 21979776
17:05:20 5643 8192000000 10691909216 11070521344 1752048032 17.619 100 77 152 1 1786195728 12763312 21384384
17:05:33 6874 8192000000 10704743056 11082121216 1767427712 17.746 100 84 168 1 1804621168 13409136 23784320
17:05:48 4837 8192000000 10715177936 11092004864 1773819136 17.799 100 85 170 0 1811594432 14065632 23709664
17:06:01 2903 8192000000 10718252272 11097088000 1777720672 17.831 100 86 171 3 1815093792 14195152 23177968
17:06:10 3353 8192000000 10723910224 11103559680 1783546816 17.879 100 81 161 1 1820148576 14502160 22099600
17:06:21 2818 8192000000 10730207216 11110666240 1791737824 17.946 100 90 181 0 1830561952 13447088 25377040
17:06:31 3945 8192000000 10734648816 11116359680 1797816464 17.996 100 83 164 3 1833177472 13122032 22238976
17:06:41 3289 8192000000 10742090528 11123200000 1804124208 18.048 100 86 171 0 1839897280 12805088 22967984
17:06:51 6885 8192000000 10736398688 11122401280 1803212256 18.040 100 87 176 2 1840821312 13506624 24102432
17:07:05 2830 8192000000 10759569968 11145244672 1815476864 18.141 100 88 174 3 1854431840 13864448 25090528
17:07:14 2326 8192000000 10765476976 11147911168 1826544016 18.231 100 84 169 0 1864363072 12942208 24876848
17:07:23 3093 8192000000 10768137984 11152506880 1834520192 18.296 100 89 179 2 1872031440 12656544 24854704
17:07:32 2071 8192000000 10767606400 11151888384 1835113632 18.301 100 86 172 0 1871930768 12219088 24598048
17:07:41 2397 8192000000 10778810512 11166482432 1836024912 18.308 100 82 165 0 1873000224 13098224 23877088
17:07:50 2445 8192000000 10790264800 11174461440 1844329536 18.376 100 87 173 0 1882001024 13521488 24150000
17:08:00 1548 8192000000 10796583680 11182522368 1850569936 18.427 100 98 199 1 1890899744 12475824 27853984
17:08:08 2726 8192000000 10797186320 11182002176 1851420848 18.434 100 88 175 0 1888779904 11945776 25413280
17:08:17 1595 8192000000 10797524528 11187339264 1855236992 18.465 100 85 172 2 1891734032 12098464 24398576
17:08:25 1849 8192000000 10807821168 11194646528 1864905856 18.543 100 93 187 0 1904147360 13080720 26160784
17:08:33 1518 8192000000 10809475472 11195351040 1861548896 18.516 100 93 186 0 1901213264 13307936 26356432
17:08:41 1643 8192000000 10804554368 11195412480 1863923296 18.535 100 90 181 0 1902282608 12467792 25891520
17:08:48 2801 8192000000 10799052384 11201351680 1870463712 18.588 100 85 170 1 1907920048 13555824 23900512
17:08:58 22322 8192000000 10790771200 11190083584 1860269152 18.505 100 63 131 0 1892936176 14872896 17794128
17:09:26 3005 8192000000 10798214048 11196268544 1864067552 18.536 100 70 141 3 1894801344 10074288 20659504
17:09:36 2295 8192000000 10806771136 11200974848 1864195792 18.537 100 70 138 1 1893747440 9903360 19648288
17:09:44 3241 8192000000 10801553520 11203702784 1870775440 18.591 100 77 154 1 1903770736 11219120 21776176
17:09:54 4879 8192000000 10781187312 11197820928 1864658880 18.541 100 51 102 2 1888974704 10412544 13903280
17:10:07 6223 8192000000 10784648400 11203698688 1863930832 18.535 100 40 80 0 1883802512 9126448 10745232
17:10:20 10699 8192000000 10778770336 11195932672 1861677392 18.517 100 25 50 1 1876262528 7008736 7576400
17:10:38 5782 8192000000 10787807440 11203424256 1866666704 18.557 100 35 69 3 1884681984 8304160 9711120
17:10:54 9171 8192000000 10787923424 11204968448 1866484912 18.556 100 33 67 0 1882175760 6581728 9109120
17:11:10 8642 8192000000 10777381104 11195797504 1867518416 18.564 100 35 69 4 1884678064 6567600 10592048
17:11:26 7005 8192000000 10773345072 11201298432 1867448704 18.564 100 34 68 1 1884011744 7200016 9363024
17:11:40 72200 8192000000 10792662864 11217231872 1874621744 18.622 100 30 60 1 1888771360 5605344 8544272
17:12:59 5263 8192000000 10786914240 11218960384 1876966528 18.641 100 30 60 1 1893459328 8221184 8271616
17:13:14 5063 8192000000 10788737424 11222908928 1881664368 18.679 100 37 73 1 1899782608 7854912 10263328
17:13:26 5847 8192000000 10816328096 11225567232 1882746896 18.687 100 40 81 0 1900515264 6637872 11130496
17:13:40 4197 8192000000 10796460256 11224276992 1883478192 18.693 100 41 81 2 1902692320 7287920 11926208
17:13:50 2454 8192000000 10809123920 11227123712 1884382048 18.700 100 46 94 0 1904550336 7695440 12472848
17:14:00 3705 8192000000 10801074928 11227852800 1883711776 18.695 100 42 84 0 1903097424 7600208 11785440
17:14:10 6856 8192000000 10785037312 11221790720 1881522432 18.677 100 23 47 0 1894886304 7095712 6268160
17:14:23 10655 8192000000 10786016000 11224739840 1885323328 18.708 100 26 53 1 1898451344 5493984 7634032
17:14:39 10193 8192000000 10793886400 11225448448 1880855072 18.672 100 13 25 2 1890065536 5854576 3355888
17:14:58 8356 8192000000 10816756016 11236438016 1887102288 18.722 100 30 60 1 1902530352 6688640 8739424
17:15:15 14046 8192000000 10797494320 11230953472 1887846448 18.728 100 21 41 1 1899394640 5529920 6018272
17:15:37 9018 8192000000 10785310960 11220500480 1866370784 18.555 99 24 48 0 1879871824 6772624 6728416
17:15:52 6784 8192000000 10804078672 11228585984 1886292368 18.716 100 48 95 1 1906034448 6042752 13699328
17:16:06 71106 8192000000 10789233200 11224264704 1828632112 18.248 97 24 48 1 1840563792 4858288 7073392
17:17:27 11877 8192000000 10794349056 11229483008 1886644912 18.719 100 18 36 1 1897722624 5847216 5230496
17:17:45 8965 8192000000 10796918416 11224985600 1868396624 18.571 99 31 63 0 1883735456 6539968 8798864
17:18:00 6049 8192000000 10791298880 11216261120 1855498896 18.467 99 30 58 5 1870021024 6033696 8488432
17:18:13 5385 8192000000 10801616096 11226767360 1884134720 18.698 100 38 74 0 1901388080 7218144 10035216
17:18:27 6109 8192000000 10775953600 11198173184 1832296624 18.278 98 36 72 4 1848599936 6338080 9965232
17:18:39 7459 8192000000 10772526368 11200204800 1825399328 18.222 98 30 58 0 1839360128 5293584 8667216
17:18:53 6042 8192000000 10760547632 11174604800 1802178224 18.032 98 30 60 1 1820804448 9934240 8691984
17:19:10 7519 8192000000 10748209648 11169415168 1792160576 17.950 97 24 48 0 1804427424 5404720 6862128
17:19:24 9390 8192000000 10725867168 11145891840 1728961712 17.427 94 19 38 0 1739628032 5061840 5604480
17:19:40 3877 8192000000 10740433808 11156557824 1817368624 18.156 100 31 62 0 1832948128 5554640 10024864
17:19:54 14840 8192000000 10698969888 11105382400 1704819600 17.225 94 27 54 0 1719195952 5834384 8541968
17:20:15 8720 8192000000 10675884432 11094355968 1717914096 17.335 96 19 38 1 1728989968 5269296 5806576
17:20:34 6813 8192000000 10695400816 11115941888 1753942784 17.634 98 24 48 0 1767545536 7010176 6592576
17:20:54 60403 8192000000 10704690112 11121758208 1737094576 17.494 97 31 62 0 1751490176 4719344 9676256
17:22:03 12716 8192000000 10694206736 11108470784 1707996400 17.252 95 22 44 2 1719225200 5111504 6117296
17:22:23 7850 8192000000 10706029264 11114700800 1729562896 17.432 96 29 58 2 1745124640 6609072 8952672
17:22:38 6558 8192000000 10726813136 11133792256 1780517296 17.854 99 26 52 0 1794122800 5929152 7676352
17:22:51 7219 8192000000 10741550352 11158138880 1813105648 18.121 100 25 50 1 1826330304 5493728 7730928
17:23:06 6638 8192000000 10732556912 11156602880 1819469984 18.173 100 27 54 1 1838428288 11482576 7475728
17:23:20 7624 8192000000 10753655440 11171045376 1832199840 18.277 100 26 52 0 1845686304 5274672 8211792
17:23:36 8675 8192000000 10743576160 11158114304 1810544592 18.100 99 35 70 1 1827062464 5900880 10616992
17:23:52 6767 8192000000 10741606528 11162251264 1824474576 18.214 100 28 56 0 1838083152 5130768 8477808
17:24:05 7274 8192000000 10745870448 11171442688 1834197104 18.294 100 20 40 3 1845464592 5451920 5815568
17:24:20 7967 8192000000 10770393680 11189538816 1841012032 18.349 100 29 58 0 1855588800 6073776 8502992
17:24:39 9251 8192000000 10758782544 11190501376 1842866288 18.364 100 18 36 1 1853645680 5659440 5119952
17:24:54 11835 8192000000 10760029504 11189358592 1851438144 18.434 100 23 45 0 1864202544 6222288 6542112
17:25:15 12483 8192000000 10768552592 11198275584 1857949824 18.487 100 24 48 4 1870756688 5479440 7327424
17:25:34 71937 8192000000 10782006960 11207495680 1861617120 18.516 100 29 58 1 1876350096 6394496 8338480
17:26:52 6192 8192000000 10787065056 11207766016 1865269136 18.546 100 32 64 0 1880873120 6155600 9448384
17:27:04 8480 8192000000 10791770496 11221262336 1879133280 18.658 100 30 60 0 1893350128 5907072 8309776
17:27:21 10218 8192000000 10823384784 11237036032 1893779056 18.776 100 45 90 1 1913024688 5943904 13301728
17:27:39 32290 8192000000 10833407456 11252961280 1905965472 18.874 100 48 94 0 1927246704 7088688 14192544
17:28:26 12212 8192000000 10850007456 11263598592 1913240720 18.933 100 56 112 0 1937625648 8897248 15487680
17:28:46 9719 8192000000 10860862432 11275919360 1921239200 18.997 100 67 134 1 1951193440 10739776 19214464
17:29:08 11830 8192000000 10866380512 11285786624 1928621616 19.056 100 64 126 2 1958036240 12295856 17118768
17:29:34 22295 8192000000 10863104048 11288924160 1930113376 19.068 100 52 104 3 1957432240 11799152 15519712
17:30:24 7143 8192000000 10876967728 11299360768 1937885024 19.130 100 42 84 2 1961708208 10341040 13482144
17:30:38 33063 8192000000 10869985328 11302912000 1943012192 19.171 100 38 74 2 1963321760 9312928 10996640
17:31:21 7706 8192000000 10880283856 11311640576 1949701888 19.224 100 45 90 1 1974487072 10399808 14385376
17:31:37 12606 8192000000 10892395744 11320377344 1958415312 19.293 100 54 107 0 1985582848 11181168 15986368
17:32:16 15011 8192000000 10896399360 11334463488 1962682176 19.327 100 38 76 3 1987922336 13966064 11274096
17:32:41 28076 8192000000 10908548336 11350867968 1977359072 19.444 100 46 92 0 2007590672 16067488 14164112
17:33:17 8280 8192000000 10909191072 11350556672 1976929344 19.440 100 34 69 2 2007426496 19889936 10607216
17:33:38 12104 8192000000 10920805120 11356897280 1978900672 19.456 100 32 65 0 2005175680 16458208 9816800
17:33:57 4884 8192000000 10936467232 11359883264 1986064416 19.513 100 55 110 1 2020513184 17096144 17352624
17:34:08 9621 8192000000 10949484736 11368357888 1991187456 19.553 100 71 137 3 2030631248 19809664 19634128
17:34:25 3607 8192000000 10954647072 11378671616 2001066272 19.631 100 76 152 0 2045180768 21402048 22712448
17:34:39 4760 8192000000 10947292192 11378606080 1997699312 19.605 100 63 126 2 2038782384 22627680 18455392
17:34:53 2192 8192000000 10950613008 11381088256 2004837792 19.661 100 77 151 3 2047487840 20574928 22075120
17:35:02 5816 8192000000 10952291168 11383300096 2007739136 19.684 100 71 143 3 2048611072 19624592 21247344
17:35:19 4471 8192000000 10960914432 11389845504 2004947680 19.662 100 60 117 4 2048857728 26585888 17324160
17:35:31 9195 8192000000 10972897392 11397787648 2012034256 19.718 100 69 136 2 2056193744 24287888 19871600
17:35:50 4661 8192000000 10971770352 11397722112 1996118080 19.592 99 79 158 0 2044733648 25581056 23034512
17:36:07 9583 8192000000 10965381312 11396530176 2010835552 19.708 100 67 134 1 2058419152 27133760 20449840
17:36:34 6038 8192000000 10967951696 11406327808 2017573888 19.761 100 55 105 5 2061403824 27781584 16048352
17:36:48 5051 8192000000 10979977328 11413442560 2021462192 19.792 100 65 130 1 2074154480 33147632 19544656
17:37:01 6710 8192000000 10970292768 11409264640 2016109424 19.750 100 55 108 3 2062496928 30108448 16279056
17:37:33 9288 8192000000 10982206112 11425718272 2024322480 19.814 100 55 106 2 2075039296 33662352 17054464
17:37:51 13175 8192000000 10983654928 11431079936 2030825808 19.865 100 54 101 4 2081037360 34036832 16174720
17:38:15 2957 8192000000 10979532688 11413348352 2016799040 19.755 100 53 105 1 2064550224 31804352 15946832
17:38:26 4723 8192000000 10982352032 11411079168 2010763136 19.708 100 77 150 1 2067871904 33876928 23231840
17:38:40 4472 8192000000 10994900608 11418693632 2020371056 19.783 100 75 148 2 2080132912 36590272 23171584
17:38:52 2015 8192000000 11004127952 11428257792 2028889792 19.850 100 84 168 0 2089618976 35022112 25707072
17:39:02 12589 8192000000 10990909472 11425009664 2020296448 19.782 100 59 118 3 2072452512 33706160 18449904
17:39:21 7906 8192000000 10994232352 11426938880 2023763184 19.810 100 64 128 0 2078845456 34962528 20119744
17:39:36 5673 8192000000 10975118224 11419914240 2014598656 19.738 100 45 90 0 2063247232 34265824 14382752
17:39:51 2327 8192000000 10988824672 11424120832 2020783104 19.786 100 61 122 0 2075663712 35186704 19693904
17:40:00 2195 8192000000 10982593184 11412840448 2011337376 19.712 100 68 136 0 2067790864 35907552 20545936
17:40:10 1285 8192000000 10981146752 11400552448 2001887712 19.638 100 77 148 3 2058949344 34549280 22512352
17:40:20 9421 8192000000 10985540160 11414982656 2010462464 19.705 100 71 140 0 2070812880 38806432 21543984
17:40:36 2176 8192000000 10992772880 11417468928 2015620096 19.746 100 88 176 1 2080123088 37597328 26905664
17:40:46 2036 8192000000 10997828064 11414794240 2009077808 19.694 100 87 174 2 2073715568 38402000 26235760
17:40:55 6871 8192000000 10963174544 11412967424 2005685728 19.668 100 52 104 1 2059526784 37995008 15846048
17:41:09 9089 8192000000 10955028640 11398823936 1965402768 19.349 98 40 77 1 2008240176 30794816 12042592
17:41:27 5787 8192000000 10979302320 11413626880 2009824240 19.700 100 63 125 5 2061923360 32702976 19396144
17:41:41 4459 8192000000 10979097024 11416055808 2010425776 19.705 100 57 111 0 2061091248 33530624 17134848
17:41:52 4640 8192000000 10987439920 11422191616 2013353664 19.728 100 64 127 1 2069150080 36594448 19201968
17:42:04 4045 8192000000 10991623648 11422355456 2014693728 19.738 100 73 146 1 2076360336 39563616 22102992
17:42:17 8583 8192000000 10976359488 11405115392 1991258848 19.554 100 70 138 1 2058667008 46446432 20961728
17:42:36 8841 8192000000 10981058160 11413463040 1997332992 19.602 100 61 121 0 2061604416 46086976 18184448
17:42:56 4873 8192000000 10996796064 11420823552 2005024800 19.662 100 86 171 2 2082051216 51190128 25836288
17:43:11 2048 8192000000 10976804896 11393118208 1980801776 19.471 100 87 174 2 2054233136 46990304 26441056
17:43:20 2442 8192000000 10972206928 11392618496 1983381744 19.491 100 92 178 1 2057980464 47341152 27257568
17:43:29 1893 8192000000 10984588848 11396026368 1979250080 19.459 100 87 172 1 2053665728 47815120 26600528
17:43:38 2169 8192000000 10973817760 11391717376 1978597632 19.454 100 82 163 3 2052949072 49589072 24762368
17:43:47 2681 8192000000 10978400976 11400966144 1987860416 19.527 100 81 160 2 2062332240 50219936 24251888
17:43:57 2126 8192000000 10985113056 11401158656 1985996384 19.512 100 84 164 0 2061453184 50315008 25141792
17:44:06 3656 8192000000 10973747040 11390201856 1977342592 19.444 100 80 160 1 2055207648 53186560 24678496
17:44:16 3316 8192000000 10980483456 11398643712 1981549856 19.477 100 86 173 1 2062117696 54130816 26437024
17:44:26 3200 8192000000 10975025664 11393277952 1965979760 19.354 99 81 159 0 2042898016 52985296 23932960
17:44:39 9257 8192000000 10956776864 11374157824 1940016000 19.147 98 70 140 0 2016942208 54206800 22719408
17:44:57 3861 8192000000 10993283456 11409334272 1991298096 19.554 100 97 194 3 2077488656 55246816 30943744
17:45:09 3567 8192000000 10991670128 11403575296 1971612096 19.398 99 87 174 2 2055259568 56037056 27610416
17:45:20 3757 8192000000 10963361120 11378040832 1924342128 19.022 97 90 181 2 2010499264 57867520 28289616
17:45:34 5380 8192000000 10960840912 11384242176 1962325008 19.325 100 69 138 2 2044272480 59345712 22601760
17:45:47 1349 8192000000 10978074432 11389362176 1968823120 19.376 100 84 166 2 2054398032 58803248 26771664
17:45:57 4484 8192000000 10968816688 11379376128 1956788736 19.281 99 89 179 3 2046134432 60093120 29252576
17:46:08 834 8192000000 10980985232 11390029824 1968202544 19.371 99 94 188 2 2057374976 60456352 28716080
17:46:16 804 8192000000 10988699232 11400310784 1984191280 19.498 100 94 186 1 2070045808 56056608 29797920
17:46:24 2908 8192000000 10982985280 11402317824 1981789088 19.479 100 77 154 0 2063189856 56336448 25064320
17:46:36 3595 8192000000 10968531568 11388383232 1966079552 19.354 99 77 154 1 2048469616 57592752 24797312
17:46:47 1629 8192000000 10988684992 11401519104 1976809456 19.439 100 90 180 0 2065633120 60526800 28296864
17:46:58 754 8192000000 10968593600 11379150848 1960030528 19.306 99 82 160 1 2045049680 59773328 25245824
17:47:10 3123 8192000000 10966722400 11383218176 1964099216 19.339 100 81 163 1 2049702416 59776192 25827008
17:47:20 4446 8192000000 10963500800 11389911040 1964995456 19.346 100 63 126 0 2047836912 62274000 20567456
17:47:31 8590 8192000000 10948037744 11379773440 1941667296 19.160 99 55 110 1 2021297248 61173120 18456832
17:47:46 5161 8192000000 10959623968 11385466880 1964922048 19.345 100 64 129 0 2043335632 57492160 20921424
17:47:58 10341 8192000000 10968031760 11401121792 1971252256 19.395 100 65 130 1 2053836288 61425440 21158592
17:48:24 15819 8192000000 10958262384 11399335936 1971128416 19.394 100 40 80 0 2044154512 58657248 14368848
17:48:47 6854 8192000000 10944572656 11383672832 1943100720 19.171 99 41 82 1 2019497408 62099840 14296848
17:49:00 8332 8192000000 10934648048 11375345664 1947775488 19.209 100 40 80 1 2020805408 59072928 13956992
17:49:21 1895 8192000000 10975362144 11384672256 1962921680 19.329 100 78 153 1 2046181360 58331936 24927744
17:49:32 3502 8192000000 10942783504 11356590080 1933277024 19.093 99 73 144 2 2018557808 61611616 23669168
17:49:44 3960 8192000000 10990604544 11402276864 1972338992 19.404 100 90 179 3 2064553520 64737280 27477248
17:49:55 5521 8192000000 10981470768 11403907072 1979427680 19.460 100 75 151 3 2068244864 64865312 23951872
17:50:11 17457 8192000000 10956258880 11398926336 1947235520 19.204 99 38 76 3 2027510704 66708960 13566224
17:50:45 16806 8192000000 10943355440 11404562432 1945225680 19.188 99 36 72 2 2028367296 70248560 12893056
17:51:09 8857 8192000000 10942752720 11394883584 1942701232 19.168 99 31 62 0 2014250976 60777904 10771840
17:51:24 11096 8192000000 10946522608 11391467520 1964491120 19.342 100 33 66 1 2032036640 56573904 10971616
17:51:52 26249 8192000000 10949426864 11394412544 1947184736 19.204 99 32 64 2 2017374256 59373152 10816368
17:52:26 19873 8192000000 10949691488 11403198464 1962025152 19.322 100 31 62 1 2035963808 62603408 11335248
17:52:57 11687 8192000000 10957502432 11405664256 1964991200 19.346 100 27 54 3 2036071536 61283904 9796432
17:53:17 29435 8192000000 10915156160 11377610752 1915006320 18.947 99 28 56 4 1996573408 70234208 11332880
17:54:28 33259 8192000000 10937277088 11391197184 1934242432 19.101 100 24 48 0 2012884112 69665648 8976032
17:55:14 31740 8192000000 10919700368 11372843008 1930816048 19.073 99 17 34 0 1998117296 61066640 6234608
17:55:52 26036 8192000000 10880937568 11358703616 1902666752 18.848 98 15 31 1 1946253168 38586592 4999824
17:56:36 56874 8192000000 10879973168 11315675136 1920060320 18.987 99 35 69 0 1939599056 10259696 9279040
17:57:41 1506 8192000000 10922208496 11345727488 1963656784 19.335 100 82 165 1 1996974720 9297280 24020656
17:57:49 11181 8192000000 10897410720 11339272192 1955050672 19.267 100 37 75 1 1978227456 12290928 10885856
17:58:10 13254 8192000000 10892983216 11353440256 1957867136 19.289 100 25 50 1 1974878816 10105568 6906112
17:58:38 36907 8192000000 10906220464 11360911360 1966329088 19.356 100 20 41 0 1984060176 12031312 5699776
18:00:05 60438 8192000000 10885886768 11358810112 1942641696 19.168 99 14 28 0 1960459072 13602032 4215344
18:01:17 48041 8192000000 10890307200 11347660800 1955819328 19.273 100 25 51 0 1973733056 10446976 7466752
18:02:14 66673 8192000000 10904956192 11372343296 1968168912 19.371 100 11 21 0 1979622352 8350496 3102944
18:03:59 52908 8192000000 10891673776 11350585344 1933643024 19.096 98 19 38 0 1952628992 12671200 6314768
18:05:53 103385 8192000000 10894586560 11354529792 1948758416 19.217 99 28 56 2 1970673664 14355856 7559392
18:07:59 82065 8192000000 10892328448 11357364224 1925982704 19.035 98 14 28 2 1942318256 12119488 4216064
18:09:41 139270 8192000000 10906406784 11376074752 1933642496 19.096 98 19 38 0 1955140080 16189632 5307952
18:12:31 40518 8192000000 10895456176 11362238464 1945135520 19.188 98 27 53 1 1962475232 9996272 7343440
18:13:40 15795 8192000000 10923960416 11370254336 1970366304 19.388 99 43 86 0 1993286720 10444208 12476208
18:14:02 3847 8192000000 10917929104 11361767424 1971481840 19.397 99 53 106 0 1998465824 11686368 15297616
18:14:13 7556 8192000000 10926418384 11376607232 1982851360 19.487 100 41 83 0 2007693952 12864976 11977616
18:14:30 11869 8192000000 10924846528 11384492032 1991058752 19.552 100 52 104 2 2019652656 12911168 15682736
18:14:51 50987 8192000000 10923334944 11389218816 1990840528 19.550 100 33 66 1 2016601952 15891664 9869760
18:15:55 37403 8192000000 10922246688 11389292544 1990852176 19.551 100 39 77 2 2015212800 12066240 12294384
18:16:48 55585 8192000000 10902328464 11399155712 1986138912 19.513 100 23 46 1 2010449840 16699808 7611120
18:17:50 47416 8192000000 10899807344 11386048512 1983185296 19.490 100 6 11 2 1994399792 9475808 1738688
18:19:03 85554 8192000000 10895619680 11379470336 1948151120 19.212 98 18 36 1 1961889232 8758016 4980096
18:20:44 26232 8192000000 10900341664 11386523648 1984089712 19.497 100 10 20 1 1994299424 7342560 2867152
18:21:16 21507 8192000000 10910494000 11390365696 1986301808 19.515 100 3 6 0 1994376384 6960720 1113856
18:21:44 35394 8192000000 10933580608 11389870080 1979634192 19.462 99 35 67 2 1996838528 7355792 9848544
18:22:26 41516 8192000000 10940534416 11401609216 1989018512 19.536 99 36 72 1 2009168192 10264256 9885424
18:23:20 62756 8192000000 10908264544 11388026880 1933691200 19.096 97 18 36 1 1950258528 11238880 5328448
18:24:29 68609 8192000000 10896528352 11371073536 1956174016 19.276 99 16 32 0 1968598352 7960768 4463568
18:25:45 40171 8192000000 10859937792 11326349312 1852976208 18.446 94 31 61 0 1869030256 7254592 8799456
18:26:43 54385 8192000000 10887721072 11355328512 1948545040 19.215 100 18 36 0 1964549696 11405536 4599120
18:28:48 76959 8192000000 10898832848 11359133696 1913236688 18.933 97 15 30 0 1936793936 19038288 4518960
18:30:13 22444 8192000000 10915727712 11367153664 1940276032 19.149 98 53 104 1 1964719056 9454880 14988144
18:30:49 43687 8192000000 10887456672 11327008768 1872277072 18.603 95 34 68 1 1898733056 16912160 9543824
18:31:40 94315 8192000000 10883609808 11355500544 1913782576 18.937 98 16 32 1 1935637984 17287584 4567824
18:33:29 31976 8192000000 10896551920 11345936384 1905800832 18.873 97 42 82 1 1928906464 11589968 11515664
18:34:15 52875 8192000000 10906723408 11386982400 1959218128 19.300 100 23 46 0 1982692848 17314608 6160112
18:35:18 81215 8192000000 10874025680 11361275904 1869728400 18.582 95 8 16 0 1891594592 19794272 2071920
18:36:51 136708 8192000000 10881011760 11342639104 1896937744 18.802 97 13 26 0 1918627408 17456576 4233088
18:39:20 108639 8192000000 10858653920 11342397440 1890182976 18.747 97 11 22 0 1905578912 12896624 2499312
18:41:25 7474 8192000000 10853942960 11322040320 1918029152 18.971 99 26 52 1 1938084880 12506608 7549120
18:41:39 18456 8192000000 10864410096 11328905216 1917617968 18.968 99 30 59 4 1940645360 14815552 8211840
18:42:05 56824 8192000000 10862359424 11337658368 1925450240 19.030 99 24 48 0 1940879296 8774368 6654688
18:43:08 46043 8192000000 10849961280 11321327616 1893053216 18.770 97 9 18 0 1901626576 6204352 2369008
18:44:00 28602 8192000000 10894336432 11350978560 1956631952 19.279 100 42 84 2 1977200880 8787680 11781248
18:44:35 50145 8192000000 10891114832 11353853952 1943974976 19.178 99 32 64 1 1962078976 9056768 9047232
18:45:34 59583 8192000000 10867136368 11349274624 1916998592 18.963 98 11 22 0 1932140112 12181728 2959792
18:46:39 23324 8192000000 10876242864 11350511616 1951141536 19.236 100 8 16 1 1964674608 11392688 2140384
18:47:29 89946 8192000000 10860117184 11334610944 1874822896 18.623 96 16 31 2 1890778048 11399264 4555888
18:49:16 97230 8192000000 10865398720 11352170496 1934459888 19.103 99 23 45 0 1951881776 10702272 6719616
18:51:37 66099 8192000000 10869833088 11345444864 1898483488 18.814 97 24 48 2 1916662240 11238544 6940208
18:53:14 23933 8192000000 10862980400 11310379008 1849890864 18.421 95 27 52 0 1863682480 5844432 7947184
18:53:50 80462 8192000000 10864042128 11330998272 1893962048 18.778 98 20 40 0 1912969712 12696144 6311520
18:55:16 63318 8192000000 10891432512 11351773184 1934371824 19.102 99 29 58 1 1953118512 10129296 8617392
18:56:31 78345 8192000000 10868985488 11346583552 1895272592 18.788 97 24 48 3 1916615216 14277792 7064832
18:57:56 110321 8192000000 10879219328 11352334336 1893615808 18.775 97 9 18 0 1910003280 13811440 2576032
18:59:53 72689 8192000000 10882252544 11347337216 1871899712 18.600 95 18 34 1 1889519696 12912480 4707504
19:01:12 43586 8192000000 10916599536 11372064768 1966611344 19.359 100 22 43 1 1987743024 14921152 6210528
19:02:06 48025 8192000000 10919340368 11398750208 1979917536 19.464 100 23 46 1 2001656720 15231712 6507472
19:03:00 71683 8192000000 10926800080 11385868288 1951539392 19.239 98 26 53 1 1974148000 14708320 7900288
19:04:18 61923 8192000000 10922096832 11412164608 1988772976 19.534 100 14 28 1 2011849200 19303520 3772704
19:05:33 188346 8192000000 10889002368 11367337984 1900984192 18.834 96 22 44 0 1923706992 16790256 5932544
19:08:56 44403 8192000000 10883883584 11358416896 1926880784 19.042 98 18 36 0 1940567696 8600704 5086208
19:09:46 45801 8192000000 10884230336 11369099264 1968034880 19.370 100 15 30 1 1982726192 9680272 5011040
19:10:52 95432 8192000000 10889116912 11370627072 1938936208 19.138 98 11 22 0 1949646384 7699392 3010784
19:12:34 54044 8192000000 10880071376 11357474816 1878244288 18.651 95 13 26 0 1892146576 10285776 3616512
19:13:38 60213 8192000000 10869695024 11337883648 1883054480 18.690 96 16 33 2 1900842160 12296288 5491392
19:15:42 75662 8192000000 10878485904 11357184000 1921509824 18.999 98 11 22 0 1941728784 16817008 3401952
19:17:04 65908 8192000000 10895478944 11359072256 1938820800 19.137 99 26 51 1 1969145232 22309264 8015168
19:18:16 74160 8192000000 10891785792 11379613696 1951702352 19.240 100 12 24 0 1977178688 21582960 3893376
19:19:37 42655 8192000000 10867274784 11346411520 1900242704 18.828 97 8 16 0 1910026304 7573328 2210272
19:20:57 65520 8192000000 10899238912 11374129152 1947880144 19.210 99 23 46 2 1963957984 9941888 6135952
19:22:14 32313 8192000000 10916760640 11375988736 1956794736 19.281 99 31 61 0 1973935824 9091888 8049200
19:22:59 19279 8192000000 10907696128 11363864576 1931665936 19.080 98 26 52 0 1945751312 7392496 6692880
19:23:31 13972 8192000000 10902450832 11365130240 1963185088 19.331 100 31 62 1 1980343040 8619584 8538368
19:23:52 10542 8192000000 10910083968 11365634048 1968174624 19.371 100 50 100 0 1992091792 10200832 13716336
19:24:08 38558 8192000000 10917042960 11379281920 1954740928 19.264 99 39 78 0 1981513712 16012096 10760688
19:24:53 40581 8192000000 10922656032 11388006400 1976545888 19.437 100 35 70 1 2000462352 14292048 9624416
19:25:40 27651 8192000000 10915795984 11381510144 1941211296 19.156 98 29 58 1 1964060624 15101568 7747760
19:26:14 24864 8192000000 10917290752 11377803264 1972963072 19.409 100 33 66 0 1991953792 9981232 9009488
19:26:46 34227 8192000000 9632859856 9964654592 742917120 8.314 38 9 18 1 750061024 4700672 2443232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-02-2021 19:28:12 to 14-02-2021 19:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-02-2021 19:28:45 to 14-02-2021 19:28:47.

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          235165
MON$OLDEST_ACTIVE               235166
MON$OLDEST_SNAPSHOT             235166
MON$NEXT_TRANSACTION            235166
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                       2028256
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:383: 
:384: mscs-test-161.budzdorov.ru    Sun Feb 14 19:27:29 2021
:385:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:386: 
--- end of diff output ---

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

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