Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.06.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 58e1ddde69c44dad93d327777e5becec
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-05-09 08:45
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 4793.92
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 16970364 kB
MemAvailable 31371832 kB
Buffers 0 kB
Cached 14653460 kB
SwapCached 32 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-06-14 19:27:41
DTS_END                         2021-06-14 19:27:41.8360
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/46368
TRN_ID                          245410
ATT_ID                          699
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: 9767.16 19078 1172059
customer order: creation 174.95 336 20994
customer order: refuse 14.83 326 1780
order to supplier: creation 46.22 1264 5546
order to supplier: removal 3.45 98098 414
invoice (draft): creation 46.93 3487 5631
invoice (draft): removal 55.43 774 6651
invoice accept: apply 42.08 17820 5049
invoice accept: cancel 50.59 741 6071
customer reserve: creation 4009.13 172 481096
customer reserve: removal 5023.09 52 602771
realization accept: apply 84.13 171 10096
realization accept: cancel 82.95 92 9954
payment from customer: creation 60.78 100 7293
payment from customer: removal 5.82 72 698
payment to supplier: creation 50.77 135 6092
payment to supplier: removal 3.48 85 418
service: total inventory turnovers 4.97 1068 596
service: total monetary turnovers 6.60 28 792
service: aggregate perf. data 0.94 17413 113
service: refresh index statistics 0.03 239333 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 14-06-2021 19:28:22 to 14-06-2021 19:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3017
TEST_TIME 2 2058
TEST_TIME 3 3113
TEST_TIME 4 4020
TEST_TIME 5 3676
TEST_TIME 6 3844
TEST_TIME 7 4080
TEST_TIME 8 4428
TEST_TIME 9 4638
TEST_TIME 10 4751
TEST_TIME 11 5142
TEST_TIME 12 5485
TEST_TIME 13 5561
TEST_TIME 14 5819
TEST_TIME 15 6114
TEST_TIME 16 6552
TEST_TIME 17 6955
TEST_TIME 18 7035
TEST_TIME 19 7109
TEST_TIME 20 7193
TEST_TIME 21 7467
TEST_TIME 22 7709
TEST_TIME 23 8657
TEST_TIME 24 8695
TEST_TIME 25 9148
TEST_TIME 26 9039
TEST_TIME 27 9143
TEST_TIME 28 9789
TEST_TIME 29 9746
TEST_TIME 30 10336
TEST_TIME 31 10472
TEST_TIME 32 10732
TEST_TIME 33 10724
TEST_TIME 34 10685
TEST_TIME 35 10605
TEST_TIME 36 10737
TEST_TIME 37 10549
TEST_TIME 38 10711
TEST_TIME 39 10575
TEST_TIME 40 10407
TEST_TIME 41 10264
TEST_TIME 42 10261
TEST_TIME 43 10200
TEST_TIME 44 10320
TEST_TIME 45 10164
TEST_TIME 46 10106
TEST_TIME 47 10049
TEST_TIME 48 10111
TEST_TIME 49 10178
TEST_TIME 50 10182
TEST_TIME 51 10123
TEST_TIME 52 9998
TEST_TIME 53 10050
TEST_TIME 54 10010
TEST_TIME 55 9970
TEST_TIME 56 9926
TEST_TIME 57 9896
TEST_TIME 58 9938
TEST_TIME 59 9898
TEST_TIME 60 10012
TEST_TIME 61 9999
TEST_TIME 62 10026
TEST_TIME 63 9980
TEST_TIME 64 10139
TEST_TIME 65 10062
TEST_TIME 66 10129
TEST_TIME 67 10091
TEST_TIME 68 10179
TEST_TIME 69 10164
TEST_TIME 70 10131
TEST_TIME 71 10134
TEST_TIME 72 10273
TEST_TIME 73 10142
TEST_TIME 74 10117
TEST_TIME 75 10068
TEST_TIME 76 9997
TEST_TIME 77 10016
TEST_TIME 78 9995
TEST_TIME 79 9952
TEST_TIME 80 9905
TEST_TIME 81 9865
TEST_TIME 82 9794
TEST_TIME 83 9717
TEST_TIME 84 9766
TEST_TIME 85 9737
TEST_TIME 86 9736
TEST_TIME 87 9723
TEST_TIME 88 9739
TEST_TIME 89 9732
TEST_TIME 90 9815
TEST_TIME 91 9825
TEST_TIME 92 9842
TEST_TIME 93 9865
TEST_TIME 94 9854
TEST_TIME 95 9853
TEST_TIME 96 9972
TEST_TIME 97 10016
TEST_TIME 98 9963
TEST_TIME 99 9985
TEST_TIME 100 9956
TEST_TIME 101 9873
TEST_TIME 102 9860
TEST_TIME 103 9828
TEST_TIME 104 9798
TEST_TIME 105 9786
TEST_TIME 106 9748
TEST_TIME 107 9712
TEST_TIME 108 9638
TEST_TIME 109 9664
TEST_TIME 110 9676
TEST_TIME 111 9677
TEST_TIME 112 9664
TEST_TIME 113 9743
TEST_TIME 114 9740
TEST_TIME 115 9726
TEST_TIME 116 9724
TEST_TIME 117 9742
TEST_TIME 118 9759
TEST_TIME 119 9777
TEST_TIME 120 9768

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-06-2021 19:28:26 to 14-06-2021 19:28:29.

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 1617342 1617342 0 0.00 0 17999 6 0 0
doc_list_biud 1617342 1617342 0 0.00 0 40538 25 0 0
sp_add_invoice_to_stock 5172 5049 123 2.37 46 169941 17821 0 123
sp_cancel_adding_invoice 6071 6071 0 0.00 5 57993 742 0 0
sp_cancel_client_order 1780 1780 0 0.00 4 11753 327 0 0
sp_cancel_customer_reserve 602771 602771 0 0.00 1 40552 53 0 0
sp_cancel_pay_from_customer 698 698 0 0.00 2 5661 72 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 3 4539 85 0 0
sp_cancel_supplier_invoice 6665 6651 14 0.21 2 41845 775 0 14
sp_cancel_supplier_order 414 414 0 0.00 9 1150649 98098 0 0
sp_cancel_write_off 9954 9954 0 0.00 1 8586 92 0 0
sp_client_order 20994 20994 0 0.00 3 30065 336 0 0
sp_customer_reserve 481096 481096 0 0.00 0 60711 172 0 0
sp_fill_shopping_cart 32163 32163 0 0.00 1 19080 39 0 0
sp_fill_shopping_cart_clo_res 481095 481095 0 0.00 0 24538 13 0 0
sp_get_clo_for_invoice 5048 5048 0 0.00 0 33679 267 0 0
sp_kill_cost_storno 17141 17141 0 0.00 0 12715 52 0 0
sp_kill_qstorno_ret_qs2qd 1222561 1222561 0 0.00 0 40531 29 0 0
sp_kill_qty_storno 642785 642785 0 0.00 0 40537 62 0 0
sp_lock_selected_doc 20998 20998 0 0.00 0 7409 5 0 0
sp_make_cost_storno 28529 28529 0 0.00 0 15543 50 0 0
sp_multiply_rows_for_pdistr 28529 28529 0 0.00 0 11302 29 0 0
sp_multiply_rows_for_qdistr 20994 20994 0 0.00 0 25909 159 0 0
sp_pay_from_customer 7293 7293 0 0.00 4 28264 101 0 0
sp_pay_to_supplier 6092 6092 0 0.00 4 34382 136 0 0
sp_payment_common 13385 13385 0 0.00 1 34371 30 0 0
sp_qd_handle_on_cancel_clo 1780 1780 0 0.00 0 11747 295 0 0
sp_qd_handle_on_invoice_upd_sts 11119 11119 0 0.00 0 32304 307 0 0
sp_qd_handle_on_reserve_upd_sts 10096 10096 0 0.00 0 16834 60 0 0
sp_reserve_write_off 10096 10096 0 0.00 7 16865 171 0 0
sp_supplier_invoice 5631 5631 0 0.00 7 120736 3487 0 0
sp_supplier_order 5546 5546 0 0.00 4 70957 1264 0 0
srv_aggregate_perf_data 113 113 0 0.00 2412 406635 17414 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1329 137227 31143 0 0
srv_find_qd_qs_mism 1122817 1122817 0 0.00 0 17998 5 0 0
srv_make_invnt_saldo 596 596 0 0.00 26 36894 1069 0 0
srv_make_money_saldo 792 792 0 0.00 1 5254 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 83703 464662 239334 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 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 5049 5049 0 0.00 0 32361 220 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 17695 215 0 0
t$perf-norm:sp_cancel_client_order 1780 1780 0 0.00 0 13788 34 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 1377 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 698 698 0 0.00 0 618 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 1192 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 389 389 0 0.00 0 1017 15 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 31572 2003 0 0
t$perf-norm:sp_cancel_write_off 1040 1040 0 0.00 0 5550 16 0 0
t$perf-norm:sp_client_order 20994 20994 0 0.00 0 14000 19 0 0
t$perf-norm:sp_customer_reserve 958 958 0 0.00 0 4639 18 0 0
t$perf-norm:sp_pay_from_customer 7293 7293 0 0.00 0 8438 11 0 0
t$perf-norm:sp_pay_to_supplier 6092 6092 0 0.00 0 10437 11 0 0
t$perf-norm:sp_reserve_write_off 10096 10096 0 0.00 0 5100 12 0 0
t$perf-norm:sp_supplier_invoice 5631 5631 0 0.00 0 17547 26 0 0
t$perf-norm:sp_supplier_order 5546 5546 0 0.00 0 6511 19 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 120 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 2395 16 0 0
t$perf-norm:srv_make_invnt_saldo 596 596 0 0.00 0 4670 30 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 3385 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10342 10096 246 2.37 0 3942 17 0 246
v_all_customers 38500 38500 0 0.00 0 83 1 0 0
v_all_suppliers 31374 31374 0 0.00 0 61 1 0 0
v_all_wares 41988 41988 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 2683 8 0 0
v_cancel_client_order 3560 3560 0 0.00 0 2647 6 0 0
v_cancel_customer_prepayment 1396 1396 0 0.00 0 3003 5 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 1056 4 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 783 3 0 0
v_cancel_supplier_invoice 806 778 28 3.47 0 1735 16 0 28
v_cancel_supplier_order 828 828 0 0.00 0 4765 12 0 0
v_cancel_write_off 2080 2080 0 0.00 0 7196 19 0 0
v_max_id_clo_ord 5544 5544 0 0.00 0 1243 1 0 0
v_max_id_clo_res 958 958 0 0.00 0 4805 18 0 0
v_max_id_ord_sup 5625 5625 0 0.00 0 9402 5 0 0
v_max_non_paid_invoice 1574 1574 0 0.00 0 835 4 0 0
v_max_non_paid_realizn 3796 3796 0 0.00 0 2084 4 0 0
v_min_id_clo_ord 5544 5544 0 0.00 0 16764 10 0 0
v_min_id_clo_res 958 958 0 0.00 0 779 3 0 0
v_min_id_ord_sup 5625 5625 0 0.00 0 6124 11 0 0
v_min_non_paid_invoice 6092 6092 0 0.00 0 34366 23 0 0
v_min_non_paid_realizn 7293 7293 0 0.00 0 5490 15 0 0
v_our_firm 10482 10482 0 0.00 0 20 1 0 0
v_reserve_write_off 20190 20190 0 0.00 0 3884 5 0 0
x_lock_depdocs_on_canc_invoice 12333 12333 0 0.00 0 20183 106 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 8537 358 0 0
x_make_qstorno_1000_1200 5546 5546 0 0.00 1 70945 1187 0 0
x_make_qstorno_1200_2000 5631 5631 0 0.00 4 117964 3339 0 0
x_make_qstorno_2100_3300 481096 481096 0 0.00 0 60709 156 0 0

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

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:45 12 8192000000 8803023744 8814886912 6918192 0.084 2 1 2 0 7037568 56816 62560
16:57:52 18910 8192000000 10225853280 10538213376 1052585888 11.385 83 65 130 0 1078686272 3012176 23088208
16:58:20 28109 8192000000 10332873616 10647465984 1372279936 14.347 100 87 174 0 1406176720 4579376 29317408
16:58:58 22431 8192000000 10360495152 10681106432 1411506208 14.697 100 86 172 1 1446106976 5852912 28747856
16:59:30 29361 8192000000 10405441568 10726932480 1452478784 15.060 100 95 190 0 1490636320 6924624 31232912
17:00:10 26938 8192000000 10425208288 10753974272 1473184768 15.242 100 88 176 0 1509301856 7621664 28495424
17:00:47 9683 8192000000 10435599152 10767003648 1494424896 15.428 100 89 178 0 1531464192 8370336 28668960
17:01:07 20847 8192000000 10450955696 10788569088 1504799344 15.518 100 83 166 1 1540207552 8601520 26806688
17:01:38 12844 8192000000 10474849328 10816155648 1533841024 15.770 100 80 160 0 1568092512 8888720 25362768
17:02:00 13342 8192000000 10496844176 10844975104 1551757104 15.925 100 75 150 1 1584088176 8975536 23355536
17:02:23 17230 8192000000 10530343216 10886586368 1586454112 16.223 100 77 154 1 1619451136 9633472 23363552
17:02:50 11556 8192000000 10567870160 10926919680 1622371488 16.530 100 75 150 0 1654580544 10262160 21946896
17:03:12 10151 8192000000 10590696176 10948804608 1646710928 16.737 100 88 176 2 1684513280 11599616 26202736
17:03:33 15167 8192000000 10602809216 10969776128 1661900080 16.865 100 75 150 0 1696131008 11860800 22370128
17:03:58 10578 8192000000 10620601184 10986815488 1681820144 17.033 100 79 158 2 1716659440 12109568 22729728
17:04:19 8720 8192000000 10653623664 11020947456 1701792992 17.200 100 87 174 0 1740202368 13098960 25310416
17:04:35 5474 8192000000 10647943696 11015659520 1706530928 17.240 100 80 159 1 1742854816 13379616 22944272
17:04:48 6460 8192000000 10665674560 11038310400 1724631632 17.391 100 84 169 3 1762534208 13644912 24257664
17:05:03 7721 8192000000 10668338800 11043901440 1731873648 17.451 100 83 166 0 1769605168 14243328 23488192
17:05:18 5810 8192000000 10686169520 11061006336 1751442224 17.614 100 90 178 1 1791022432 14029536 25550672
17:05:33 5344 8192000000 10693939152 11071401984 1758151104 17.669 100 80 160 1 1794421024 13744256 22525664
17:05:45 4319 8192000000 10705336416 11083202560 1771792368 17.782 100 85 168 0 1808007008 12409888 23804752
17:05:57 5365 8192000000 10717697408 11097985024 1780936368 17.857 100 84 168 1 1817697344 13247616 23513360
17:06:09 2993 8192000000 10726499568 11105591296 1788537312 17.920 100 87 174 1 1826576576 13822912 24216352
17:06:20 3916 8192000000 10731736080 11110535168 1791504080 17.944 100 91 180 1 1831151888 14848464 24799344
17:06:33 2847 8192000000 10746237984 11125067776 1801128368 18.023 100 90 178 1 1840787024 14937936 24720720
17:06:43 2053 8192000000 10743446864 11126280192 1807808288 18.078 100 85 170 1 1846088288 14959040 23320960
17:06:52 2995 8192000000 10756456368 11139551232 1814898288 18.136 100 89 179 0 1854928320 15176976 24853056
17:07:01 6586 8192000000 10755060912 11139313664 1814479392 18.133 100 81 162 1 1852440176 15642752 22318032
17:07:14 2783 8192000000 10766117216 11147452416 1818663968 18.167 100 83 161 1 1855421616 14301664 22455984
17:07:23 1714 8192000000 10772589264 11160289280 1837393968 18.320 100 87 174 0 1875597744 14025392 24178384
17:07:31 1419 8192000000 10784823728 11169697792 1842866400 18.364 100 91 182 0 1881743344 13090400 25786544
17:07:39 1372 8192000000 10787679120 11174014976 1848304176 18.408 100 88 175 1 1886943312 13870704 24768432
17:07:47 2008 8192000000 10795391856 11179761664 1851896944 18.438 100 94 186 1 1891173520 13803984 25472592
17:07:56 1855 8192000000 10800225808 11186491392 1852082880 18.439 100 88 177 0 1890505648 13405936 25016832
17:08:04 1531 8192000000 10808256624 11193262080 1859267200 18.497 100 93 185 1 1898308144 13893488 25147456
17:08:12 1561 8192000000 10811266640 11197243392 1865567120 18.548 100 92 184 1 1904771648 12978528 26226000
17:08:19 1541 8192000000 10820210448 11205537792 1869956992 18.584 100 95 189 3 1910016912 13369424 26690496
17:08:27 1410 8192000000 10813505936 11204542464 1871482016 18.596 100 91 182 1 1912310720 14430096 26398608
17:08:35 2008 8192000000 10803493120 11204509696 1872807872 18.607 100 72 143 1 1906178560 12742800 20627888
17:08:44 3051 8192000000 10803914256 11207032832 1872099312 18.601 100 67 133 2 1900718176 10275968 18342896
17:08:54 8204 8192000000 10792913408 11206606848 1871874400 18.599 100 41 80 1 1889491424 6227136 11389888
17:09:08 53345 8192000000 10788701344 11212271616 1874299488 18.619 100 38 76 0 1892777408 7535376 10942544
17:10:14 4466 8192000000 10788746640 11217661952 1881785824 18.680 100 39 78 1 1901606304 8766576 11053904
17:10:26 12141 8192000000 10789438848 11214897152 1878052608 18.649 100 28 55 5 1892596848 6922752 7621488
17:10:47 5699 8192000000 10798097024 11223224320 1880784800 18.671 100 30 61 0 1896669696 7249456 8635440
17:10:59 5429 8192000000 10793889376 11222818816 1884427728 18.701 100 32 64 2 1901469248 8209376 8832144
17:11:11 9428 8192000000 10798990912 11227136000 1884081040 18.698 100 24 48 0 1896882464 5787696 7013728
17:11:26 7212 8192000000 10791204832 11225751552 1886540016 18.718 100 29 58 0 1901750304 7318000 7892288
17:11:40 7666 8192000000 10797734400 11227725824 1885357984 18.708 100 21 43 3 1896861328 5447648 6055696
17:11:58 9443 8192000000 10797169488 11233087488 1892561568 18.766 100 21 42 3 1905138272 6727488 5849216
17:12:16 9444 8192000000 10801087072 11233136640 1892435104 18.765 100 14 27 4 1902397168 6146608 3815456
17:12:32 6400 8192000000 10795044400 11235110912 1893539536 18.774 100 12 24 1 1902821488 5776160 3505792
17:12:45 2913 8192000000 10808129552 11241721856 1897171296 18.804 100 30 60 1 1912968560 7468720 8328544
17:12:55 6148 8192000000 10816943056 11246600192 1899740176 18.824 100 23 46 0 1912200592 6264688 6195728
17:13:12 8449 8192000000 10816102576 11245330432 1900781584 18.833 100 18 36 3 1916138784 10347648 5009552
17:13:29 9558 8192000000 10818742240 11247046656 1900293200 18.829 100 24 48 1 1913893344 6921408 6678736
17:13:45 67444 8192000000 10835761408 11254267904 1904882448 18.866 100 33 64 1 1919799552 5741168 9175936
17:14:59 19653 8192000000 10811388400 11249692672 1902861552 18.849 100 23 46 0 1915172560 5687664 6623344
17:15:27 4782 8192000000 10829077344 11255459840 1907586672 18.887 100 32 64 0 1923615936 6359904 9669360
17:15:41 9776 8192000000 10817701664 11256561664 1908869792 18.898 100 31 63 1 1924964352 7393264 8701296
17:16:00 6735 8192000000 10830172800 11259084800 1907335520 18.885 100 23 44 3 1919773744 5527504 6910720
17:16:13 5485 8192000000 10833561968 11269709824 1912025504 18.923 100 32 64 3 1928940224 7266240 9648480
17:16:24 6825 8192000000 10835765120 11267661824 1913206464 18.932 100 37 74 4 1934896608 10820304 10869840
17:16:39 4796 8192000000 10822273328 11246264320 1871901168 18.600 98 24 47 1 1884311072 5496832 6913072
17:16:50 8210 8192000000 10805586736 11241775104 1876707808 18.639 99 18 36 4 1891405952 9445168 5252976
17:17:08 8216 8192000000 10797635504 11234295808 1870386480 18.587 99 15 30 1 1880380048 5606640 4386928
17:17:23 6719 8192000000 10808960800 11240038400 1894041008 18.778 100 29 58 0 1908553360 5761376 8750976
17:17:40 12011 8192000000 10806605024 11245670400 1897653408 18.807 100 21 42 2 1910001088 6253920 6093760
17:17:59 10382 8192000000 10782895856 11223425024 1863551360 18.532 99 25 50 3 1877612048 7003344 7057344
17:18:17 8882 8192000000 10764859712 11200077824 1802669216 18.036 96 14 28 1 1812796272 5140352 4986704
17:18:34 46290 8192000000 10725523536 11153526784 1725257440 17.396 93 24 45 3 1738386000 5547568 7580992
17:19:38 19792 8192000000 10737135216 11173076992 1835423696 18.304 100 17 34 1 1845744160 5266144 5054320
17:20:04 6197 8192000000 10740586336 11158974464 1801268048 18.024 98 27 53 1 1814524064 5842304 7413712
17:20:17 7664 8192000000 10734732336 11148070912 1772917728 17.791 97 33 66 1 1789124880 5748064 10459088
17:20:35 4156 8192000000 10701900704 11106291712 1760407408 17.688 97 39 77 1 1781433072 10872432 10153232
17:20:45 3954 8192000000 10725460976 11138150400 1790325600 17.934 99 38 77 3 1808062528 6814848 10922080
17:20:55 5042 8192000000 10696988032 11101843456 1709600160 17.265 95 29 58 1 1727242480 8895632 8746688
17:21:08 6096 8192000000 10667260256 11074105344 1714497936 17.306 96 27 54 1 1727593312 4764816 8330560
17:21:22 7073 8192000000 10687268112 11094376448 1711926928 17.285 96 23 46 2 1724601120 5930800 6743392
17:21:36 5397 8192000000 10710667936 11119398912 1769851664 17.766 99 41 82 0 1792102048 10584288 11666096
17:21:50 6052 8192000000 10704424688 11108143104 1742756672 17.542 97 37 74 2 1759783280 6419360 10607248
17:22:04 6279 8192000000 10718043712 11126996992 1777214480 17.827 99 27 54 4 1790336432 4808000 8313952
17:22:19 10405 8192000000 10698290448 11116769280 1774539760 17.804 99 36 72 1 1791077056 5355952 11181344
17:22:35 5766 8192000000 10704648512 11123941376 1779247248 17.843 99 29 59 0 1793990656 6107600 8635808
17:22:51 6598 8192000000 10719298160 11128897536 1764362256 17.720 98 19 38 1 1775835488 5069664 6403568
17:23:05 6310 8192000000 10716268992 11137581056 1806252048 18.065 100 21 41 2 1817500944 5575120 5673776
17:23:19 21160 8192000000 10743359904 11153965056 1815805008 18.143 100 26 52 0 1829719632 5970720 7943904
17:23:48 59719 8192000000 10761790656 11164184576 1825143120 18.220 100 33 66 0 1840202736 5038000 10021616
17:24:54 7514 8192000000 10738376976 11165192192 1828645488 18.248 100 17 34 0 1839930720 6446912 4838320
17:25:08 7631 8192000000 10743066112 11169722368 1832286944 18.278 100 23 46 0 1844848304 6125536 6435824
17:25:24 7849 8192000000 10750554592 11178504192 1836849136 18.315 100 25 49 2 1853369408 10228880 6291392
17:25:40 8221 8192000000 10754750528 11176935424 1844338528 18.376 100 31 60 1 1859588320 6711328 8538464
17:25:55 6325 8192000000 10755279632 11177791488 1842786192 18.363 100 23 44 1 1854946976 5759088 6401696
17:26:08 7475 8192000000 10759845488 11183919104 1847726560 18.404 100 23 44 1 1859750000 5461152 6562288
17:26:22 8521 8192000000 10782731968 11198885888 1855703200 18.468 100 35 68 3 1870920176 6279808 8937168
17:26:37 8033 8192000000 10760620384 11191967744 1853353936 18.449 100 24 48 2 1866248816 6032432 6862448
17:26:53 9047 8192000000 10776848080 11199885312 1860228960 18.505 100 20 41 0 1871475024 4708272 6537792
17:27:09 13261 8192000000 10785902272 11213422592 1876638960 18.638 100 19 38 0 1887022000 4812240 5570800
17:27:28 5255 8192000000 10799107680 11222773760 1886036656 18.714 100 33 65 0 1900867008 4737408 10092944
17:27:41 22693 8192000000 10821915984 11235385344 1890733984 18.752 100 28 56 0 1905161824 5365424 9062416
17:28:15 4383 8192000000 10835449168 11250499584 1903876656 18.857 100 50 100 1 1925613488 7265840 14470992
17:28:29 124638 8192000000 10863297392 11287035904 1918063568 18.971 100 50 100 1 1941850224 9519856 14266800
17:31:06 16604 8192000000 10859809168 11289382912 1930353840 19.070 100 34 68 3 1956875792 17226736 9295216
17:31:32 15842 8192000000 10859277344 11291566080 1931853792 19.082 100 33 64 2 1954935680 13065440 10016448
17:32:04 19531 8192000000 10865053056 11298217984 1940731008 19.153 100 38 75 0 1963537120 10819616 11986496
17:32:35 21221 8192000000 10876471712 11310624768 1945370608 19.190 100 31 62 0 1969231280 14134192 9726480
17:33:04 16720 8192000000 10878492160 11313459200 1947851216 19.209 100 34 66 0 1972405280 14696224 9857840
17:33:28 29090 8192000000 10885754784 11321479168 1951856800 19.241 100 41 79 0 1979824544 16109472 11858272
17:34:06 25288 8192000000 10886613952 11324256256 1937636736 19.128 99 46 91 2 1969908640 18491456 13780448
17:34:42 28178 8192000000 10908474192 11341549568 1957760640 19.288 100 38 75 2 1987424272 19135824 10527808
17:35:19 23425 8192000000 10906146480 11339198464 1948617216 19.215 99 40 80 0 1978341728 18193568 11530944
17:35:50 5690 8192000000 10902851440 11333173248 1959916368 19.305 100 51 101 0 1994976288 19630656 15429264
17:36:03 3530 8192000000 10925576032 11346968576 1970636576 19.390 100 71 137 2 2011215392 20402800 20176016
17:36:24 17006 8192000000 10929550176 11358068736 1971386064 19.396 100 67 134 1 2015102560 23877616 19838880
17:36:49 10072 8192000000 10925597200 11360444416 1974964784 19.425 100 56 110 2 2016753408 25382976 16405648
17:37:13 7536 8192000000 10906515120 11331772416 1941363456 19.158 99 54 106 1 1981561472 25148384 15049632
17:37:30 12446 8192000000 10910451952 11345182720 1965257232 19.348 100 54 108 1 2008071680 26667776 16146672
17:37:49 2074 8192000000 10920701472 11345076224 1965394816 19.349 100 50 100 0 2007283216 26643856 15244544
17:37:59 4664 8192000000 10931531600 11350913024 1968758176 19.376 100 68 135 0 2016299200 27799632 19741392
17:38:12 2724 8192000000 10944353120 11365089280 1978230672 19.451 100 78 156 2 2029235184 27698976 23305536
17:38:23 7111 8192000000 10941520240 11366162432 1982622256 19.485 100 67 132 2 2029497616 27913296 18962064
17:38:40 9173 8192000000 10948373584 11377328128 1990793008 19.550 100 67 135 0 2039847440 29354336 19700096
17:38:58 2275 8192000000 10966829744 11385540608 1998719904 19.613 100 86 170 1 2053815872 30197120 24898848
17:39:10 1664 8192000000 10964452272 11386642432 1997143936 19.600 100 74 147 0 2050647440 31761312 21742192
17:39:19 4445 8192000000 10962460064 11385978880 1998566960 19.611 100 76 150 0 2052450096 32220128 21663008
17:39:31 3831 8192000000 10965877728 11386806272 1982932448 19.488 99 73 142 3 2038309840 34663792 20713600
17:39:43 3359 8192000000 10959523760 11380617216 1990958832 19.551 100 73 145 1 2043178000 30630816 21588352
17:39:55 3193 8192000000 10976960304 11392102400 2000127792 19.624 100 87 168 4 2056711712 31357312 25226608
17:40:06 8965 8192000000 10958646720 11380445184 1991036768 19.552 100 72 144 2 2046311216 33837824 21436624
17:40:25 4515 8192000000 10938888464 11349917696 1948029632 19.211 98 80 157 1 2005400896 34379312 22991952
17:40:39 6651 8192000000 10956224160 11373756416 1969786176 19.384 99 87 170 1 2030924160 35594704 25543280
17:40:52 12574 8192000000 10952230128 11377614848 1983106160 19.489 100 67 132 3 2040447392 37908720 19432512
17:41:17 2835 8192000000 10927650064 11340689408 1931790080 19.081 98 73 145 1 1992465648 38924656 21750912
17:41:26 4086 8192000000 10950890448 11356372992 1959386784 19.301 100 77 152 0 2021208336 38679536 23142016
17:41:38 4579 8192000000 10940711472 11361259520 1966302784 19.356 100 73 144 2 2029000544 39375296 23322464
17:41:59 6619 8192000000 10956085840 11374391296 1952418928 19.246 99 75 150 1 2018245408 43032720 22793760
17:42:13 5616 8192000000 10952375456 11366166528 1964672480 19.343 100 74 146 0 2032048464 44984400 22391584
17:42:26 6193 8192000000 10957202624 11378880512 1971108528 19.394 100 72 144 1 2038536288 45680800 21746960
17:42:39 3508 8192000000 10962072128 11370704896 1981092240 19.473 100 83 164 2 2048854048 43272448 24489360
17:42:49 2067 8192000000 10971909184 11386597376 1985914736 19.512 100 96 192 1 2056384432 41806832 28662864
17:43:00 2702 8192000000 10976453744 11386384384 1985956928 19.512 100 91 183 0 2056307504 42822288 27528288
17:43:13 3316 8192000000 10962942944 11383455744 1983791760 19.495 100 74 146 1 2047252224 40659376 22801088
17:43:26 10270 8192000000 10950553728 11379810304 1981872192 19.480 100 66 132 1 2042803936 41061168 19870576
17:43:44 3030 8192000000 10955027216 11379937280 1968672576 19.375 99 72 144 0 2030323264 39754688 21896000
17:43:53 1710 8192000000 10951154928 11366338560 1967453824 19.365 100 66 132 1 2027472960 39102272 20916864
17:44:03 4068 8192000000 10939854944 11360808960 1966898496 19.361 100 79 155 2 2029111136 39003280 23209360
17:44:14 1717 8192000000 10954205744 11370323968 1970170944 19.387 100 84 169 2 2035371536 39451728 25748864
17:44:22 5106 8192000000 10954381024 11374997504 1976259968 19.435 100 81 162 0 2039601056 38843872 24497216
17:44:35 1765 8192000000 10954350208 11369594880 1966541328 19.358 99 83 165 0 2028233984 36521296 25171360
17:44:43 2289 8192000000 10962294512 11379417088 1967920352 19.369 99 79 158 0 2028926064 37624368 23381344
17:44:53 3106 8192000000 10968372016 11381051392 1968112832 19.370 99 84 168 1 2033795440 40495936 25186672
17:45:03 11119 8192000000 10933286224 11380224000 1975209600 19.427 100 43 86 1 2026874624 38482496 13182528
17:45:29 7860 8192000000 10922719184 11348934656 1930544304 19.071 98 59 118 2 1987832752 38119648 19168800
17:45:44 1684 8192000000 10958001936 11378352128 1980564992 19.469 100 77 154 0 2040702704 36496912 23640800
17:45:53 2404 8192000000 10949799456 11375312896 1976633120 19.438 100 69 138 0 2036540880 37341952 22565808
17:46:04 2634 8192000000 10924493600 11343196160 1933241232 19.093 98 87 173 2 1999024336 38955232 26827872
17:46:15 3538 8192000000 10922067632 11343396864 1945629296 19.192 100 67 132 1 2007558864 39849472 22080096
17:46:26 1379 8192000000 10925245520 11342028800 1917750256 18.969 98 80 160 1 1982987328 40293360 24943712
17:46:37 10522 8192000000 10914240944 11341828096 1940798032 19.153 100 54 106 0 2001009856 42490560 17721264
17:46:57 4364 8192000000 10941966128 11359965184 1943294800 19.173 99 84 164 4 2011263408 42489696 25478912
17:47:08 1370 8192000000 10950779392 11363082240 1949194352 19.220 100 93 184 3 2023649680 44897568 29557760
17:47:17 2229 8192000000 10949488112 11361529856 1957548816 19.287 100 81 162 2 2028497408 44661360 26287232
17:47:26 3511 8192000000 10950138144 11361480704 1959928448 19.305 100 79 158 0 2030901648 45918592 25054608
17:47:37 3701 8192000000 10961757872 11374071808 1967515344 19.366 100 85 170 1 2040727552 46814192 26398016
17:47:52 1328 8192000000 10959077264 11374657536 1966665248 19.359 100 72 142 2 2037369696 48078336 22626112
17:48:00 4042 8192000000 10958143504 11376644096 1964429568 19.341 100 75 150 1 2038788624 51328288 23030768
17:48:11 4055 8192000000 10945856832 11366227968 1956461712 19.278 100 67 134 0 2027788816 50109696 21217408
17:48:29 2762 8192000000 10930116944 11354087424 1928099232 19.052 99 54 108 0 1997979904 51853728 18026944
17:48:43 8482 8192000000 10931258928 11367477248 1949143648 19.220 100 51 102 0 2020250032 53874736 17231648
17:49:01 7723 8192000000 10927171696 11346354176 1932632080 19.088 99 68 135 2 2005271280 50243712 22395488
17:49:16 11691 8192000000 10926011248 11360821248 1935388528 19.110 99 45 90 0 2001712768 51265632 15058608
17:49:41 11580 8192000000 10917180128 11342757888 1915549408 18.951 99 53 106 1 1987321552 54108848 17663296
17:50:03 4642 8192000000 10921659696 11345825792 1927644912 19.048 100 60 120 1 2007536880 59715280 20176688
17:50:16 4067 8192000000 10940828224 11359338496 1942964384 19.170 100 75 146 2 2023590224 56946816 23679024
17:50:26 6210 8192000000 10927648800 11363250176 1940843984 19.153 100 57 114 2 2019342896 59549952 18948960
17:50:56 10993 8192000000 10888958976 11325210624 1904394640 18.862 99 28 56 0 1957910784 43586336 9929808
17:51:15 8862 8192000000 10901425280 11336892416 1925708560 19.033 100 36 72 0 1981670144 43323328 12638256
17:51:30 16776 8192000000 10875629280 11313594368 1889508192 18.742 98 31 63 0 1945529184 45169248 10851744
17:52:02 29184 8192000000 10894104016 11348824064 1927908400 19.050 100 28 56 1 1987919200 50685808 9324992
17:52:37 36069 8192000000 10879869744 11324477440 1917375728 18.966 99 26 52 0 1962996800 37693472 7927600
17:53:22 15861 8192000000 10900404944 11348525056 1923699904 19.016 100 31 61 1 1977966288 43670720 10595664
17:53:56 17173 8192000000 10906893776 11347648512 1921352592 18.998 100 25 50 1 1983369856 52998656 9018608
17:54:43 26879 8192000000 10903724880 11365289984 1930776240 19.073 100 28 56 3 1996913968 56483520 9654208
17:55:46 21847 8192000000 10895344720 11347247104 1928869008 19.058 100 20 40 0 1979551536 43646656 7035872
17:56:30 21625 8192000000 10895524624 11347181568 1911394320 18.918 99 26 52 1 1971753648 52060080 8299248
17:57:03 29659 8192000000 10903217328 11361193984 1939565712 19.143 100 19 38 0 1985128800 39480496 6082592
17:58:27 56412 8192000000 10874090832 11338293248 1909401056 18.902 98 9 18 1 1940839392 28909840 2528496
17:59:29 23953 8192000000 10893768800 11341688832 1936744512 19.121 99 40 80 2 1958113936 9955760 11413664
18:00:00 43255 8192000000 10886994192 11357990912 1954514960 19.262 100 8 16 1 1971034976 14489520 2030496
18:00:52 77653 8192000000 10903828112 11355537408 1943365984 19.174 99 12 24 1 1959165488 12959440 2840064
18:02:17 52830 8192000000 10907892832 11370987520 1965144864 19.347 100 10 20 1 1979952048 12292784 2514400
18:03:18 95051 8192000000 10933373920 11398856704 1980380608 19.468 100 7 14 0 2004101904 21381056 2340240
18:04:59 121041 8192000000 10931048848 11390177280 1971051568 19.394 99 20 39 2 1988236672 11063680 6121424
18:07:08 137226 8192000000 10926571952 11392577536 1986183424 19.514 99 46 92 0 2008657952 9140160 13334368
18:09:52 70842 8192000000 10930928480 11396866048 1961724944 19.320 98 28 56 1 1983705616 14624448 7356224
18:11:12 57530 8192000000 10936106208 11418255360 2000001376 19.623 100 19 38 3 2026681456 20967376 5712704
18:12:33 21288 8192000000 10954413936 11412881408 2008399936 19.689 100 28 55 2 2030879456 14777952 7701568
18:13:02 30912 8192000000 10946810624 11409100800 1994646032 19.580 99 35 70 2 2016956880 12565968 9744880
18:14:04 41911 8192000000 10945001136 11399847936 1971046720 19.394 98 16 32 0 1990377760 14419216 4911824
18:14:55 19324 8192000000 10959965664 11418013696 2007077200 19.679 100 48 95 4 2036333120 14363920 14892000
18:15:24 29562 8192000000 10952270624 11421315072 2009637088 19.699 100 40 78 2 2040183360 19016224 11530048
18:16:09 27700 8192000000 10948367584 11417260032 1997304512 19.601 99 41 82 2 2023882544 14914208 11663824
18:16:47 33528 8192000000 10916977824 11397353472 1965989840 19.354 98 11 22 0 1984041248 14734000 3317408
18:17:27 20160 8192000000 10925702256 11409047552 1997844160 19.606 100 19 38 3 2022482128 19554192 5083776
18:17:54 42642 8192000000 10927546272 11403874304 2004382912 19.657 100 16 33 2 2019708480 11018576 4306992
18:18:43 51636 8192000000 10926243728 11406721024 1969881744 19.385 98 12 25 4 1988452656 15004176 3566736
18:19:41 20876 8192000000 10923451440 11411496960 2000047616 19.623 100 10 20 1 2022336592 19246608 3042368
18:20:13 3008 8192000000 10917028832 11405402112 1996164752 19.592 100 12 24 3 2012799040 12763824 3870464
18:20:22 20224 8192000000 10909634032 11413254144 1993968544 19.575 100 5 10 0 2006443488 11182928 1292016
18:20:48 3635 8192000000 10909501440 11412393984 1991706960 19.557 100 2 4 0 2004772096 12537664 527472
18:21:08 34477 8192000000 10935509520 11417235456 2000967696 19.630 100 25 49 2 2020749168 12931664 6849808
18:21:49 50097 8192000000 10924924208 11407462400 2001910624 19.638 100 9 18 1 2018739568 14308352 2520592
18:22:47 67331 8192000000 10903009856 11395756032 1982768256 19.487 99 12 24 0 1999775728 14063200 2944272
18:24:01 67813 8192000000 10891139536 11375415296 1899402048 18.821 95 10 20 0 1910154592 8120880 2631664
18:25:20 50714 8192000000 10897334720 11384930304 1946812704 19.201 98 15 31 3 1964266288 12879488 4574096
18:26:19 54484 8192000000 10888599152 11361939456 1901640144 18.839 96 16 32 2 1918562416 12500272 4422000
18:27:37 61237 8192000000 10922780080 11384463360 1946900784 19.202 98 17 33 2 1959300624 7968880 4430960
18:28:45 46718 8192000000 10912737504 11393187840 1974938128 19.425 99 13 26 1 1987222320 8915312 3368880
18:29:38 24028 8192000000 10909371104 11382800384 1934385888 19.102 97 11 22 0 1945653152 8331904 2935360
18:30:09 65271 8192000000 10890492416 11370930176 1866724368 18.558 94 16 32 2 1888561424 17395376 4441680
18:31:23 58384 8192000000 10894511248 11370659840 1932003968 19.083 99 11 22 1 1953900016 18906752 2989296
18:32:34 82836 8192000000 10859832512 11326603264 1792365344 17.951 92 29 58 1 1815702784 15188400 8149040
18:34:38 112996 8192000000 10849059136 11308695552 1766082000 17.735 91 10 20 0 1788047824 18955664 3010160
18:36:38 37228 8192000000 10832378688 11294785536 1818593600 18.166 95 37 74 3 1839308112 10195232 10519280
18:37:21 59227 8192000000 10850494768 11306303488 1801790704 18.029 94 30 60 2 1822264384 12169888 8303792
18:39:38 105089 8192000000 10842000288 11293605888 1887530896 18.726 99 20 40 1 1903520048 9963568 6025584
18:41:30 73018 8192000000 10840646608 11308339200 1905863616 18.873 100 22 43 2 1922187440 10856512 5467312
18:42:49 28937 8192000000 10849516576 11306594304 1900795504 18.833 99 32 64 0 1918937664 8719760 9422400
18:43:24 25404 8192000000 10857521568 11304656896 1877637808 18.646 98 21 42 2 1891935568 8595600 5702160
18:44:03 88841 8192000000 10846485120 11324432384 1888877152 18.737 98 21 42 0 1906345568 11681328 5787088
18:45:41 65376 8192000000 10852372480 11341885440 1929899488 19.066 100 6 12 1 1946707440 14825552 1982400
18:47:36 46352 8192000000 10848965040 11305590784 1888130496 18.731 98 21 42 1 1905445312 11407808 5907008
18:48:34 58466 8192000000 10858192896 11326058496 1932602992 19.088 100 13 26 1 1943606448 7224912 3778544
18:49:38 87585 8192000000 10852003648 11320614912 1919594208 18.984 99 23 46 0 1935602672 8928080 7080384
18:51:17 59593 8192000000 10858843664 11350728704 1917501568 18.967 99 5 11 0 1933486176 14326512 1658096
18:52:24 59107 8192000000 10862611632 11348013056 1927467280 19.047 99 4 8 0 1940143184 11525488 1150416
18:53:33 43349 8192000000 10860528624 11336921088 1909916480 18.906 98 12 24 0 1923927504 10640224 3370800
18:54:30 39154 8192000000 10880858000 11357880320 1955544896 19.271 100 27 54 0 1976187504 12659008 7983600
18:55:57 46364 8192000000 10890433200 11358408704 1958021600 19.290 100 21 42 1 1976722256 12393536 6307120
18:56:56 54464 8192000000 10893904368 11379671040 1968987792 19.377 100 20 40 3 1985703936 11357424 5358720
18:57:57 66248 8192000000 10908901296 11384217600 1947747840 19.209 98 27 54 0 1964522624 9733408 7041376
18:59:17 90105 8192000000 10927521616 11395325952 1988753472 19.534 100 23 46 1 2003721936 9208224 5760240
19:00:58 41558 8192000000 10926860288 11404472320 1998755728 19.613 100 10 20 1 2013467392 11725712 2985952
19:01:46 55364 8192000000 10934525008 11408003072 1989314096 19.538 99 20 40 2 2011077712 16014672 5748944
19:02:47 87862 8192000000 10937323952 11436281856 2002352240 19.641 100 11 22 0 2026858016 21366720 3139056
19:04:27 104788 8192000000 10957802416 11410149376 1953742832 19.256 97 32 63 3 1975648528 12753184 9152512
19:06:19 10688 8192000000 10970749056 11424395264 2014839344 19.740 100 68 136 3 2044079344 10335824 18904176
19:06:45 31124 8192000000 10937357472 11411984384 1985883968 19.511 99 30 61 2 2008147744 13566576 8697200
19:07:23 68172 8192000000 10919193584 11403710464 1977430544 19.444 99 18 36 0 1995408080 13274208 4703328
19:08:52 70363 8192000000 10947462352 11420450816 2005899280 19.669 100 34 66 2 2023036864 8257408 8880176
19:10:13 15249 8192000000 10929382256 11411587072 1991757264 19.558 99 32 64 2 2013841088 12501696 9582128
19:10:47 34107 8192000000 10866473312 11335843840 1865875680 18.551 94 18 36 2 1881186560 9544880 5766000
19:11:30 77311 8192000000 10887718592 11376402432 1926814176 19.041 98 8 16 0 1945901808 17086016 2001616
19:12:56 16818 8192000000 10881269200 11378634752 1962797840 19.328 100 4 8 0 1980110016 16265568 1046608
19:13:19 14497 8192000000 10879297040 11373125632 1947475408 19.206 99 11 21 1 1964750224 14185744 3089072
19:13:41 53537 8192000000 10907971200 11378597888 1936720208 19.121 98 20 39 2 1956312176 14484624 5107344
19:14:41 50687 8192000000 10897323632 11382206464 1971971488 19.401 100 9 18 0 1989519840 14750016 2798336
19:16:21 64128 8192000000 10894479488 11380547584 1939418160 19.142 98 14 28 1 1952553248 8997664 4137424
19:17:31 56723 8192000000 10892899440 11372888064 1922327200 19.005 97 18 36 1 1935586384 8423200 4835984
19:18:42 58274 8192000000 10883082944 11358343168 1877321552 18.643 95 13 26 0 1890972048 9863552 3786944
19:19:53 94994 8192000000 10876609200 11360296960 1899479312 18.822 97 12 24 1 1913491328 10661936 3350080
19:21:34 53208 8192000000 10855620768 11331600384 1817609056 18.158 93 13 26 0 1829228720 8162112 3457552
19:23:01 41001 8192000000 10845089632 11314024448 1856222096 18.473 97 34 66 0 1879005264 13603008 9180160
19:23:51 46724 8192000000 10862062288 11325673472 1898838880 18.817 99 38 76 1 1926054992 16741536 10474576
19:24:45 46802 8192000000 10872959872 11336294400 1894944464 18.786 98 35 70 1 1918738688 14255744 9538480
19:25:39 47307 8192000000 10854320112 11324682240 1854651248 18.460 96 21 42 1 1871558608 11292352 5615008
19:26:32 64333 8192000000 10837802240 11296911360 1745633648 17.565 91 20 40 1 1763181728 12044720 5503360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 14-06-2021 19:28:36 to 14-06-2021 19:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 123 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 14-06-2021 19:29:10 to 14-06-2021 19:29:12.

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          244310
MON$OLDEST_ACTIVE               245517
MON$OLDEST_SNAPSHOT             245517
MON$NEXT_TRANSACTION            245517
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                       2060128
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:139: 
:140: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:44 2021
:141:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:142: 
:143: 
:144: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:50 2021
:145:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:146: 
:147: 
:148: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:50 2021
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
:151: 
:152: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:50 2021
:153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:154: 
:155: 
:156: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:50 2021
:157:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:158: 
:159: 
:160: mscs-test-161.budzdorov.ru    Mon Jun 14 19:27:50 2021
:161:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:162: 
--- end of diff output ---

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

14.06.21 19:29:13. 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-06-14 19:29:15 No severe PSQL-related problems occured
14.06.21 19:29:16. End of report.