Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.06.2021 01:28
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 17003204 kB
MemAvailable 31357204 kB
Buffers 0 kB
Cached 14630744 kB
SwapCached 2440 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-19 01:27:42
DTS_END                         2021-06-19 01:27:42.4920
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56466
TRN_ID                          253882
ATT_ID                          655
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: 9659.83 17137 1159180
customer order: creation 187.07 328 22448
customer order: refuse 15.87 312 1904
order to supplier: creation 50.06 1244 6007
order to supplier: removal 3.43 106246 412
invoice (draft): creation 48.90 3630 5868
invoice (draft): removal 53.09 829 6371
invoice accept: apply 44.94 17633 5393
invoice accept: cancel 48.35 857 5802
customer reserve: creation 4156.02 175 498723
customer reserve: removal 4733.33 61 568000
realization accept: apply 90.50 160 10860
realization accept: cancel 86.94 111 10433
payment from customer: creation 64.85 112 7782
payment from customer: removal 6.32 82 758
payment to supplier: creation 53.13 118 6376
payment to supplier: removal 3.86 79 463
service: total inventory turnovers 5.43 969 651
service: total monetary turnovers 6.87 37 824
service: aggregate perf. data 0.84 22182 101
service: refresh index statistics 0.03 187574 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-06-2021 01:28:27 to 19-06-2021 01:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2871
TEST_TIME 2 3151
TEST_TIME 3 4051
TEST_TIME 4 4141
TEST_TIME 5 3906
TEST_TIME 6 4406
TEST_TIME 7 4557
TEST_TIME 8 4775
TEST_TIME 9 4846
TEST_TIME 10 5459
TEST_TIME 11 6236
TEST_TIME 12 6327
TEST_TIME 13 6296
TEST_TIME 14 6496
TEST_TIME 15 6617
TEST_TIME 16 6868
TEST_TIME 17 7108
TEST_TIME 18 7053
TEST_TIME 19 7394
TEST_TIME 20 7804
TEST_TIME 21 7847
TEST_TIME 22 8394
TEST_TIME 23 8445
TEST_TIME 24 8897
TEST_TIME 25 8976
TEST_TIME 26 8816
TEST_TIME 27 9147
TEST_TIME 28 9801
TEST_TIME 29 10831
TEST_TIME 30 11302
TEST_TIME 31 11218
TEST_TIME 32 11065
TEST_TIME 33 10864
TEST_TIME 34 10679
TEST_TIME 35 10548
TEST_TIME 36 10548
TEST_TIME 37 10498
TEST_TIME 38 10523
TEST_TIME 39 10646
TEST_TIME 40 10488
TEST_TIME 41 10345
TEST_TIME 42 10291
TEST_TIME 43 10239
TEST_TIME 44 10423
TEST_TIME 45 10368
TEST_TIME 46 10315
TEST_TIME 47 10304
TEST_TIME 48 10281
TEST_TIME 49 10220
TEST_TIME 50 10097
TEST_TIME 51 9987
TEST_TIME 52 10129
TEST_TIME 53 9997
TEST_TIME 54 10017
TEST_TIME 55 9931
TEST_TIME 56 9923
TEST_TIME 57 9861
TEST_TIME 58 9790
TEST_TIME 59 9869
TEST_TIME 60 9974
TEST_TIME 61 10011
TEST_TIME 62 10003
TEST_TIME 63 9999
TEST_TIME 64 10021
TEST_TIME 65 10052
TEST_TIME 66 9996
TEST_TIME 67 10084
TEST_TIME 68 10074
TEST_TIME 69 10146
TEST_TIME 70 10217
TEST_TIME 71 10174
TEST_TIME 72 10042
TEST_TIME 73 10019
TEST_TIME 74 10083
TEST_TIME 75 10001
TEST_TIME 76 9954
TEST_TIME 77 9899
TEST_TIME 78 9871
TEST_TIME 79 9913
TEST_TIME 80 9831
TEST_TIME 81 9761
TEST_TIME 82 9845
TEST_TIME 83 9803
TEST_TIME 84 9815
TEST_TIME 85 9784
TEST_TIME 86 9787
TEST_TIME 87 9760
TEST_TIME 88 9740
TEST_TIME 89 9776
TEST_TIME 90 9769
TEST_TIME 91 9796
TEST_TIME 92 9799
TEST_TIME 93 9824
TEST_TIME 94 9871
TEST_TIME 95 9838
TEST_TIME 96 9850
TEST_TIME 97 9938
TEST_TIME 98 9985
TEST_TIME 99 9968
TEST_TIME 100 9910
TEST_TIME 101 9826
TEST_TIME 102 9829
TEST_TIME 103 9833
TEST_TIME 104 9803
TEST_TIME 105 9738
TEST_TIME 106 9755
TEST_TIME 107 9717
TEST_TIME 108 9733
TEST_TIME 109 9671
TEST_TIME 110 9660
TEST_TIME 111 9631
TEST_TIME 112 9683
TEST_TIME 113 9670
TEST_TIME 114 9687
TEST_TIME 115 9686
TEST_TIME 116 9661
TEST_TIME 117 9712
TEST_TIME 118 9681
TEST_TIME 119 9722
TEST_TIME 120 9663

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-06-2021 01:28:31 to 19-06-2021 01:28:34.

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 1621277 1621277 0 0.00 0 18903 7 0 0
doc_list_biud 1621277 1621277 0 0.00 0 50688 27 0 0
sp_add_invoice_to_stock 5596 5393 203 3.62 36 192717 17633 0 203
sp_cancel_adding_invoice 5802 5802 0 0.00 4 73200 857 0 0
sp_cancel_client_order 1904 1904 0 0.00 4 12829 313 0 0
sp_cancel_customer_reserve 568000 568000 0 0.00 1 27317 61 0 0
sp_cancel_pay_from_customer 758 758 0 0.00 3 5280 82 0 0
sp_cancel_pay_to_supplier 463 463 0 0.00 3 5171 79 0 0
sp_cancel_supplier_invoice 6389 6371 18 0.28 2 50757 829 0 18
sp_cancel_supplier_order 412 412 0 0.00 7 1077480 106246 0 0
sp_cancel_write_off 10433 10433 0 0.00 1 9576 112 0 0
sp_client_order 22448 22448 0 0.00 3 26267 328 0 0
sp_customer_reserve 498723 498723 0 0.00 0 58865 175 0 0
sp_fill_shopping_cart 34309 34309 0 0.00 1 21581 35 0 0
sp_fill_shopping_cart_clo_res 498719 498719 0 0.00 0 14696 12 0 0
sp_get_clo_for_invoice 5389 5389 0 0.00 0 11314 240 0 0
sp_kill_cost_storno 17456 17456 0 0.00 0 15383 58 0 0
sp_kill_qstorno_ret_qs2qd 1153216 1153216 0 0.00 0 50686 33 0 0
sp_kill_qty_storno 609171 609171 0 0.00 0 50687 71 0 0
sp_lock_selected_doc 22554 22554 0 0.00 0 8430 6 0 0
sp_make_cost_storno 30407 30407 0 0.00 0 14332 50 0 0
sp_multiply_rows_for_pdistr 30407 30407 0 0.00 0 11893 28 0 0
sp_multiply_rows_for_qdistr 22448 22448 0 0.00 0 9727 137 0 0
sp_pay_from_customer 7782 7782 0 0.00 4 16453 112 0 0
sp_pay_to_supplier 6376 6376 0 0.00 4 14527 118 0 0
sp_payment_common 14158 14158 0 0.00 1 16406 35 0 0
sp_qd_handle_on_cancel_clo 1904 1904 0 0.00 0 12819 288 0 0
sp_qd_handle_on_invoice_upd_sts 11191 11191 0 0.00 0 15808 330 0 0
sp_qd_handle_on_reserve_upd_sts 10860 10860 0 0.00 0 16832 51 0 0
sp_reserve_write_off 10860 10860 0 0.00 5 16882 161 0 0
sp_supplier_invoice 5868 5868 0 0.00 7 96362 3631 0 0
sp_supplier_order 6007 6007 0 0.00 5 40452 1244 0 0
srv_aggregate_perf_data 101 101 0 0.00 2232 347184 22183 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1452 135828 29647 0 0
srv_find_qd_qs_mism 1107543 1107543 0 0.00 0 10271 6 0 0
srv_make_invnt_saldo 651 651 0 0.00 46 73945 969 0 0
srv_make_money_saldo 824 824 0 0.00 1 9178 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 131870 295695 187574 0 0
t$perf-abend:sp_add_invoice_to_stock 203 203 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5394 5394 0 0.00 0 12129 164 0 0
t$perf-norm:sp_cancel_adding_invoice 456 456 0 0.00 0 10891 111 0 0
t$perf-norm:sp_cancel_client_order 1904 1904 0 0.00 0 2157 9 0 0
t$perf-norm:sp_cancel_customer_reserve 786 786 0 0.00 0 490 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 758 758 0 0.00 0 4701 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 463 463 0 0.00 0 4694 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 437 437 0 0.00 0 913 18 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 24873 1620 0 0
t$perf-norm:sp_cancel_write_off 1089 1089 0 0.00 0 1149 4 0 0
t$perf-norm:sp_client_order 22448 22448 0 0.00 0 6600 15 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 365 3 0 0
t$perf-norm:sp_pay_from_customer 7782 7782 0 0.00 0 3870 8 0 0
t$perf-norm:sp_pay_to_supplier 6376 6376 0 0.00 0 4910 9 0 0
t$perf-norm:sp_reserve_write_off 10860 10860 0 0.00 0 7728 12 0 0
t$perf-norm:sp_supplier_invoice 5868 5868 0 0.00 0 4842 15 0 0
t$perf-norm:sp_supplier_order 6007 6007 0 0.00 0 10299 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 296 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 907 7 0 0
t$perf-norm:srv_make_invnt_saldo 651 651 0 0.00 0 944 20 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 1141 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 11184 10778 406 3.63 0 2631 17 0 406
v_all_customers 41264 41264 0 0.00 0 153 1 0 0
v_all_suppliers 32814 32814 0 0.00 0 30 1 0 0
v_all_wares 44896 44896 0 0.00 0 86 1 0 0
v_cancel_adding_invoice 912 912 0 0.00 0 2545 9 0 0
v_cancel_client_order 3808 3808 0 0.00 0 2749 4 0 0
v_cancel_customer_prepayment 1516 1516 0 0.00 0 736 3 0 0
v_cancel_customer_reserve 1572 1572 0 0.00 0 845 4 0 0
v_cancel_payment_to_supplier 926 926 0 0.00 0 941 4 0 0
v_cancel_supplier_invoice 910 874 36 3.95 0 1345 19 0 36
v_cancel_supplier_order 824 824 0 0.00 0 422 4 0 0
v_cancel_write_off 2178 2178 0 0.00 0 2340 14 0 0
v_max_id_clo_ord 6007 6007 0 0.00 0 814 1 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 2023 13 0 0
v_max_id_ord_sup 5854 5854 0 0.00 0 4164 4 0 0
v_max_non_paid_invoice 1830 1830 0 0.00 0 216 2 0 0
v_max_non_paid_realizn 3979 3979 0 0.00 0 5216 6 0 0
v_min_id_clo_ord 6007 6007 0 0.00 0 6036 8 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 6422 11 0 0
v_min_id_ord_sup 5854 5854 0 0.00 0 4546 6 0 0
v_min_non_paid_invoice 6376 6376 0 0.00 0 14438 24 0 0
v_min_non_paid_realizn 7782 7782 0 0.00 0 16400 27 0 0
v_our_firm 11238 11238 0 0.00 0 15 1 0 0
v_reserve_write_off 21720 21720 0 0.00 0 4844 4 0 0
x_lock_depdocs_on_canc_invoice 11736 11736 0 0.00 0 27807 118 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 5413 363 0 0
x_make_qstorno_1000_1200 6007 6007 0 0.00 2 40441 1166 0 0
x_make_qstorno_1200_2000 5868 5868 0 0.00 3 95666 3505 0 0
x_make_qstorno_2100_3300 498723 498723 0 0.00 0 58864 161 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:46 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
22:57:53 20919 8192000000 10279273888 10582810624 1008975040 10.965 79 63 127 1 1033572128 2739200 21857888
22:58:22 44518 8192000000 10362712928 10679439360 1392519744 14.528 100 88 177 0 1426504016 5332624 28651648
22:59:13 31386 8192000000 10387007440 10711310336 1437818512 14.930 100 90 180 0 1474725328 7143680 29763136
22:59:56 18613 8192000000 10418982656 10743816192 1466552256 15.183 100 89 177 0 1503021936 8104368 28365312
23:00:30 20105 8192000000 10437617760 10767806464 1485276736 15.348 100 89 178 0 1522828080 9026704 28524640
23:01:11 22562 8192000000 10465385472 10805821440 1516571088 15.620 100 90 180 0 1554745344 9605472 28568784
23:01:50 13259 8192000000 10498088160 10841858048 1549244256 15.903 100 83 166 1 1584789872 9899344 25646272
23:02:10 21322 8192000000 10516982368 10865827840 1571896944 16.099 100 85 170 0 1608029824 10230704 25902176
23:02:41 16303 8192000000 10538311040 10889695232 1590135968 16.255 100 79 158 0 1625237840 10813008 24288864
23:03:08 18921 8192000000 10553175056 10911567872 1619569200 16.506 100 90 180 1 1658165264 11457744 27138320
23:03:35 12411 8192000000 10570995728 10931347456 1629679136 16.592 100 76 152 0 1664208480 11518288 23011056
23:03:55 7976 8192000000 10599801968 10961309696 1661148672 16.859 100 80 160 0 1696406640 12306656 22951312
23:04:10 9320 8192000000 10610495680 10976264192 1674499184 16.971 100 80 160 1 1710994928 13216080 23279664
23:04:28 9835 8192000000 10635242736 11001659392 1694527120 17.139 100 80 160 0 1730589408 13168192 22894096
23:04:46 5822 8192000000 10638582080 11011805184 1704148800 17.220 100 80 160 1 1740489680 13156624 23184256
23:04:59 6110 8192000000 10654930528 11032342528 1723389808 17.380 100 75 150 1 1757662320 12983136 21289376
23:05:15 6324 8192000000 10675163136 11051020288 1732296736 17.455 100 73 144 2 1765350272 11873488 21180048
23:05:29 4148 8192000000 10685336432 11063091200 1747980080 17.585 100 78 155 1 1782210384 11716224 22514080
23:05:41 6388 8192000000 10687312912 11067187200 1755060816 17.644 100 76 152 1 1788408288 11683136 21664336
23:05:54 3962 8192000000 10706603936 11083251712 1769722400 17.765 100 77 153 0 1802045024 11133328 21189296
23:06:05 3651 8192000000 10723148128 11109105664 1788725968 17.921 100 69 136 0 1819465248 11831296 18907984
23:06:17 3349 8192000000 10734370288 11121139712 1797916560 17.997 100 76 150 1 1831565296 12092784 21555952
23:06:27 2822 8192000000 10748919456 11134218240 1810917408 18.103 100 85 170 0 1848087888 13471136 23699344
23:06:37 2449 8192000000 10760280080 11144454144 1820483216 18.182 100 87 172 2 1857934208 13386400 24064592
23:06:46 8672 8192000000 10751897408 11144642560 1821149056 18.187 100 70 140 2 1853475072 12877344 19448672
23:07:02 3762 8192000000 10780013808 11163459584 1827134704 18.236 100 79 158 1 1860771968 11635200 22002064
23:07:13 2812 8192000000 10784284160 11174670336 1843696288 18.371 100 90 179 0 1882483600 12505536 26281776
23:07:22 2688 8192000000 10786900592 11172732928 1849757600 18.420 100 91 182 3 1889721312 14525456 25438256
23:07:31 1945 8192000000 10795497744 11183411200 1853109984 18.447 100 91 182 1 1891806368 13536832 25159552
23:07:40 1858 8192000000 10801313792 11190243328 1861156912 18.513 100 94 187 0 1901673456 13822016 26694528
23:07:48 2413 8192000000 10799167264 11186335744 1861409328 18.515 100 90 178 3 1900549200 14495296 24644576
23:07:56 1657 8192000000 10808344544 11198222336 1864480224 18.540 100 89 178 2 1904651824 14812224 25359376
23:08:05 1892 8192000000 10811068608 11197825024 1863343776 18.530 100 86 171 0 1900837824 13630048 23864000
23:08:13 1527 8192000000 10806826384 11198156800 1869450512 18.580 100 85 170 1 1905564560 12936096 23177952
23:08:21 1933 8192000000 10811894368 11201572864 1869364048 18.579 100 93 185 0 1909241088 13390256 26486784
23:08:29 2295 8192000000 10808528464 11205521408 1871435280 18.596 100 83 167 2 1908034304 13655104 22943920
23:08:37 15523 8192000000 10813957712 11207241728 1874672736 18.622 100 82 164 0 1909587856 12322256 22592864
23:08:59 4038 8192000000 10811743360 11209216000 1873767536 18.615 100 68 135 2 1903242848 10797856 18677456
23:09:10 3823 8192000000 10780100064 11199791104 1869278000 18.578 100 49 98 3 1893080288 9870624 13931664
23:09:20 3557 8192000000 10787610672 11205500928 1874767264 18.623 100 40 80 0 1895636432 9260880 11608288
23:09:31 4101 8192000000 10787838096 11206905856 1872239920 18.602 100 31 62 1 1889078144 8097904 8740320
23:09:45 5616 8192000000 10793071104 11210125312 1877718624 18.647 100 27 54 1 1892041984 6352800 7970560
23:09:58 5068 8192000000 10790276880 11214696448 1882292272 18.684 100 43 88 0 1901246608 6988640 11965696
23:10:09 8111 8192000000 10791507536 11217989632 1879400400 18.660 100 22 44 0 1892884032 7427120 6056512
23:10:28 7649 8192000000 10789179664 11220107264 1885853152 18.712 100 29 58 1 1902190048 7661872 8675024
23:10:47 13139 8192000000 10789657824 11222528000 1887620192 18.727 100 22 44 1 1900583472 6660960 6302320
23:11:10 10927 8192000000 10797352880 11227619328 1888968128 18.737 100 15 30 0 1899893616 6110688 4814800
23:11:27 8722 8192000000 10796438480 11229614080 1890382048 18.749 100 23 46 2 1903439472 6842896 6214528
23:11:42 68547 8192000000 10826566368 11243679744 1898164832 18.812 100 39 78 2 1918883360 9230928 11487600
23:12:57 6528 8192000000 10826138384 11253678080 1902970704 18.850 100 42 84 0 1924782784 10190624 11621456
23:13:10 3986 8192000000 10812481792 11245633536 1899532656 18.823 100 25 49 2 1913719088 5942352 8244080
23:13:20 5561 8192000000 10820694352 11248062464 1901558016 18.839 100 29 58 0 1916747008 6978832 8210160
23:13:32 3255 8192000000 10822057024 11247624192 1902775536 18.849 100 35 70 1 1920097472 7766064 9555872
23:13:42 4801 8192000000 10827618176 11255582720 1906185776 18.876 100 45 90 0 1928167904 9208592 12773536
23:13:54 5574 8192000000 10821894656 11253493760 1903887824 18.858 100 35 68 1 1920618496 6806272 9924400
23:14:07 6200 8192000000 10821562560 11253075968 1906591584 18.879 100 30 61 1 1921185296 6186336 8407376
23:14:20 4493 8192000000 10821013408 11254194176 1905798448 18.873 100 34 69 1 1922266912 6387344 10081120
23:14:33 4404 8192000000 10828931696 11256913920 1907127568 18.884 100 34 69 1 1923732944 7169584 9435792
23:14:46 13492 8192000000 10824778048 11259523072 1907376608 18.886 100 22 44 2 1919411984 5138480 6896896
23:15:06 6727 8192000000 10820263024 11258281984 1906982512 18.882 100 19 38 2 1918289376 5607152 5699712
23:15:19 12452 8192000000 10832798128 11267563520 1912144864 18.924 100 29 59 3 1926507360 5666864 8695632
23:15:42 53283 8192000000 10814705936 11257171968 1893605120 18.775 99 31 62 3 1908186608 5854496 8726992
23:16:41 12230 8192000000 10824778176 11262586880 1909413872 18.902 100 29 58 4 1925013424 7018976 8580576
23:17:01 6922 8192000000 10801165376 11234664448 1882465680 18.685 99 24 48 0 1895148144 6255568 6426896
23:17:15 5100 8192000000 10826584592 11256729600 1903131536 18.851 100 37 73 2 1926145760 12545472 10468752
23:17:29 4961 8192000000 10787527120 11221979136 1837890000 18.324 97 23 46 0 1849713808 4927696 6896112
23:17:42 8510 8192000000 10802538560 11232980992 1873344416 18.611 99 28 54 4 1887139456 5962432 7832608
23:17:59 5014 8192000000 10773398256 11204947968 1845209200 18.383 98 22 44 1 1858010288 6275792 6525296
23:18:10 5993 8192000000 10783118976 11204956160 1822107744 18.195 97 29 57 2 1836966688 5895280 8963664
23:18:24 8882 8192000000 10774798128 11203776512 1830212976 18.261 98 25 50 2 1843367200 5743632 7410592
23:18:41 5748 8192000000 10765623648 11200438272 1845311552 18.384 99 33 66 2 1862022336 7245280 9465504
23:18:54 7839 8192000000 10723568960 11155787776 1768293056 17.753 96 16 32 3 1778719696 5788512 4638128
23:19:08 9108 8192000000 10744665104 11167944704 1803705328 18.044 98 23 47 1 1815686224 5309600 6671296
23:19:23 11425 8192000000 10728779808 11152171008 1732552016 17.457 94 25 50 4 1745407296 5419504 7435776
23:19:41 10810 8192000000 10681717792 11084402688 1685896464 17.067 93 14 28 1 1695082240 5280736 3905040
23:19:59 55692 8192000000 10660205056 11078799360 1653622240 16.795 93 31 59 0 1668017456 5130304 9264912
23:21:01 10751 8192000000 10671130432 11077664768 1679296192 17.011 96 12 24 1 1687326464 4916224 3114048
23:21:17 5085 8192000000 10686906288 11108122624 1764661776 17.723 99 35 70 0 1782235568 6993952 10579840
23:21:32 9618 8192000000 10697851376 11106390016 1734146464 17.470 97 37 74 1 1754808960 9862976 10799520
23:21:48 5902 8192000000 10691538480 11105988608 1762445920 17.705 99 24 48 2 1775107936 6104048 6557968
23:22:01 6357 8192000000 10717412576 11136524288 1799594496 18.011 100 25 50 0 1812328896 5728352 7006048
23:22:14 8658 8192000000 10716655248 11138859008 1805614576 18.060 100 27 52 0 1819101984 5626896 7860512
23:22:31 4698 8192000000 10735973440 11154309120 1816589040 18.150 100 36 72 2 1834275264 7984240 9701984
23:22:44 13464 8192000000 10714417072 11138985984 1760879424 17.692 97 28 56 3 1774572624 4580112 9113088
23:23:09 8893 8192000000 10730340656 11153244160 1818162208 18.163 100 31 62 1 1833635856 6482496 8991152
23:23:24 5313 8192000000 10741693584 11163168768 1821409776 18.189 100 27 54 2 1834830496 5367760 8052960
23:23:40 10421 8192000000 10738120848 11167272960 1824869008 18.217 100 17 34 0 1836174000 6089200 5215792
23:23:58 9158 8192000000 10750431424 11175084032 1834713280 18.298 100 22 44 0 1846745920 5236416 6796224
23:24:14 10095 8192000000 10757903568 11187154944 1841042096 18.349 100 11 22 1 1853418016 9446144 2929776
23:24:30 59300 8192000000 10784516240 11192950784 1849976608 18.422 100 23 44 2 1861720032 5455472 6287952
23:25:36 23987 8192000000 10759630400 11190288384 1848966416 18.414 100 17 35 1 1858967184 4963856 5036912
23:26:08 9801 8192000000 10776324912 11202367488 1859600224 18.500 100 27 53 2 1874136096 6401520 8134352
23:26:27 5553 8192000000 10780013344 11205918720 1863678448 18.533 100 34 68 1 1879636288 6549472 9408368
23:26:40 6422 8192000000 10787122144 11209699328 1868064016 18.569 100 34 69 1 1883850688 5940720 9845952
23:26:53 7330 8192000000 10781374720 11210600448 1870351728 18.587 100 43 87 1 1889336896 6161264 12823904
23:27:09 7480 8192000000 10795085264 11222773760 1882606400 18.686 100 29 58 0 1896546416 6226752 7713264
23:27:24 7849 8192000000 10795930832 11230965760 1887790784 18.728 100 19 36 1 1898040496 5301040 4948672
23:27:40 37615 8192000000 10821613328 11241725952 1897393456 18.805 100 39 76 2 1913795040 5094480 11307104
23:28:26 18502 8192000000 10836527472 11260096512 1907886016 18.890 100 43 86 0 1928115088 6624704 13604368
23:28:52 16600 8192000000 10855532992 11276632064 1920302112 18.989 100 54 106 0 1946137952 9998256 15837584
23:29:18 16962 8192000000 10861820336 11284234240 1929557536 19.063 100 58 114 3 1958561056 11535760 17467760
23:29:52 17222 8192000000 10871876768 11294392320 1933470400 19.095 100 50 100 0 1962750592 14228320 15051872
23:30:24 17950 8192000000 10881991296 11303120896 1940591184 19.151 100 57 114 2 1974514448 17146400 16776864
23:31:15 55912 8192000000 10870176224 11304853504 1939544080 19.143 100 44 87 0 1965968608 13425024 12999504
23:32:20 23705 8192000000 10878919168 11310972928 1943335664 19.173 100 41 82 0 1969980912 15000608 11644640
23:32:57 6574 8192000000 10877130784 11312947200 1945863008 19.194 100 41 82 1 1974609888 17067648 11679232
23:33:18 3275 8192000000 10897959904 11324456960 1954670944 19.264 100 59 116 1 1988206224 15999856 17535424
23:33:32 14225 8192000000 10903159264 11331530752 1961809984 19.320 100 56 112 1 1993454144 15870832 15773328
23:34:01 27594 8192000000 10914281776 11341692928 1967121968 19.363 100 64 126 2 2006410720 21001472 18287280
23:34:42 6279 8192000000 10924949472 11349708800 1973350304 19.412 100 65 130 1 2015836640 22940032 19546304
23:34:56 2729 8192000000 10923319136 11352240128 1977506032 19.445 100 59 117 1 2015479168 20871600 17101536
23:35:07 6342 8192000000 10928300496 11356921856 1978556032 19.453 100 57 112 3 2017307344 21590240 17161072
23:35:24 7225 8192000000 10936296480 11363266560 1983834368 19.495 100 57 114 2 2028136176 27546912 16754896
23:35:48 10420 8192000000 10928087280 11363880960 1977273312 19.443 100 44 86 1 2018449456 27573520 13602624
23:36:09 7866 8192000000 10940003344 11371266048 1983237424 19.490 100 55 110 2 2027605968 26937856 17430688
23:36:24 2662 8192000000 10968735488 11389906944 1996193744 19.593 100 87 168 1 2055482960 33446384 25842832
23:36:36 1949 8192000000 10971477728 11388637184 2001640016 19.636 100 89 175 2 2059263936 31399456 26224464
23:36:53 19612 8192000000 10959448192 11388833792 1968747760 19.376 99 58 116 1 2024131296 38016400 17367136
23:37:21 3732 8192000000 10959092096 11380539392 1986585824 19.517 100 67 131 1 2042072960 35176448 20310688
23:37:38 4728 8192000000 10952831984 11382603776 1990165856 19.545 100 64 126 1 2044093296 35224784 18702656
23:37:53 5366 8192000000 10971047040 11389116416 1992716816 19.565 100 77 152 2 2053027552 37775552 22535184
23:38:07 2872 8192000000 10949350208 11374276608 1980269280 19.467 100 68 136 1 2036384192 35644816 20470096
23:38:17 6181 8192000000 10950166032 11380895744 1983251856 19.490 100 63 126 1 2038101264 36606928 18242480
23:38:30 13300 8192000000 10946290272 11370819584 1953054736 19.251 98 70 140 1 2011253840 38198384 20000720
23:38:51 2119 8192000000 10939131456 11364777984 1973480528 19.413 100 63 126 5 2026313344 33585952 19246864
23:39:02 18180 8192000000 10945200368 11379400704 1978368784 19.452 100 51 102 1 2028272240 34000512 15902944
23:39:29 7483 8192000000 10923959552 11362975744 1955534752 19.271 99 40 78 0 1999351552 31328896 12487904
23:39:46 7798 8192000000 10949301088 11384913920 1985889088 19.511 100 54 107 3 2035060752 33293616 15878048
23:40:02 6654 8192000000 10973636560 11400876032 1993495424 19.571 100 68 135 1 2053655296 39644800 20515072
23:40:17 8053 8192000000 10984645856 11408150528 2000365376 19.626 100 66 129 3 2059190032 39725664 19098992
23:40:33 9374 8192000000 10971078736 11409522688 2003399280 19.650 100 55 110 0 2058581488 38696064 16486144
23:40:51 6994 8192000000 10948527184 11378405376 1978690336 19.454 100 62 124 1 2037705200 39564448 19450416
23:41:13 2494 8192000000 10959019744 11387863040 1994290144 19.578 100 63 123 2 2044870448 32473648 18106656
23:41:24 6808 8192000000 10932823280 11358932992 1960414352 19.309 99 62 124 3 2013957504 33952112 19591040
23:41:41 2519 8192000000 10926480768 11339755520 1934162864 19.100 98 69 135 0 1992490128 37016832 21310432
23:41:50 4163 8192000000 10933329680 11355557888 1959995584 19.306 100 76 151 2 2021826736 38430416 23400736
23:42:09 3354 8192000000 10922566432 11349401600 1952505920 19.246 100 62 124 0 2009909744 38132608 19271216
23:42:19 1926 8192000000 10944283520 11359162368 1953666704 19.256 99 82 163 0 2016756400 38408528 24681168
23:42:27 2689 8192000000 10945236544 11360239616 1969527280 19.382 100 88 176 1 2035648496 39564192 26557024
23:42:37 3033 8192000000 10948373472 11362238464 1963940352 19.337 100 79 159 1 2028948176 41197440 23810384
23:42:47 4027 8192000000 10945044016 11355656192 1958707024 19.296 100 85 170 1 2027219440 41725264 26787152
23:42:58 2651 8192000000 10908530320 11316953088 1923128720 19.012 99 84 166 1 1991769808 43800128 24840960
23:43:13 1749 8192000000 10939133040 11347345408 1951349456 19.237 100 92 184 2 2024986880 46322928 27314496
23:43:21 1750 8192000000 10939693504 11352645632 1953434912 19.254 100 88 176 0 2025977136 46520000 26022224
23:43:34 3160 8192000000 10947434800 11352621056 1959445152 19.302 100 81 162 1 2026164400 42014544 24704704
23:43:46 2730 8192000000 10950581168 11353600000 1953426528 19.254 100 79 155 0 2019708960 42590208 23692224
23:43:55 2888 8192000000 10936408928 11338104832 1938118448 19.132 100 85 170 1 2010404976 45684704 26601824
23:44:05 1953 8192000000 10928027680 11331969024 1934687808 19.104 100 96 192 4 2009765824 46048080 29029936
23:44:15 2378 8192000000 10938407840 11337338880 1937445504 19.126 100 89 178 1 2011811440 46991312 27374624
23:44:25 2352 8192000000 10936404400 11343519744 1947136304 19.204 100 87 176 0 2018522000 45137616 26248080
23:44:35 4736 8192000000 10936577456 11339698176 1928578416 19.056 99 87 174 0 2002371600 46841104 26952080
23:44:47 1819 8192000000 10940080208 11338682368 1941377504 19.158 100 86 167 3 2015269984 47230736 26661744
23:44:55 3594 8192000000 10923309328 11326189568 1927294256 19.045 99 86 171 0 2002184704 48348304 26542144
23:45:06 2576 8192000000 10932704832 11345113088 1942420512 19.166 100 83 166 1 2016626592 47857584 26348496
23:45:17 6294 8192000000 10930185600 11345592320 1932643104 19.088 99 74 148 0 2005802896 49267952 23891840
23:45:37 6512 8192000000 10949909920 11362299904 1951605792 19.239 100 64 128 2 2022622464 49827872 21188800
23:45:50 5873 8192000000 10951981888 11366449152 1938094688 19.132 99 72 142 0 2012786464 50899456 23792320
23:46:04 7774 8192000000 10944264816 11361480704 1936637264 19.120 99 73 146 0 2014090192 53567168 23885760
23:46:19 4792 8192000000 10949898192 11362701312 1952885888 19.249 100 79 159 1 2034951072 56702896 25362288
23:46:33 3300 8192000000 10974404352 11380006912 1967815600 19.368 100 88 175 1 2052328048 56411200 28101248
23:46:44 3041 8192000000 10991074416 11395690496 1977837728 19.448 100 85 163 4 2062086400 57479392 26769280
23:46:53 3009 8192000000 10973179456 11396423680 1977069664 19.441 100 74 148 2 2058220016 57443344 23707008
23:47:04 1450 8192000000 10971807984 11391967232 1974054176 19.418 100 78 156 1 2055271824 57100368 24117280
23:47:15 11771 8192000000 10957343664 11397877760 1977135120 19.442 100 47 94 0 2046016880 53459680 15422080
23:47:33 9984 8192000000 10960678064 11395190784 1975749168 19.431 100 48 94 1 2041171440 49225488 16196784
23:47:51 11538 8192000000 10939722816 11375972352 1934918704 19.106 98 41 81 2 1999742112 50763072 14060336
23:48:17 1579 8192000000 10975621888 11395469312 1976339744 19.436 100 74 149 2 2051642080 51962656 23339680
23:48:26 2492 8192000000 10988084432 11395534848 1983010096 19.489 100 83 164 1 2062033184 53648880 25374208
23:48:37 2430 8192000000 10982528016 11406389248 1980890208 19.472 100 75 151 2 2062659168 58005680 23763280
23:48:47 4794 8192000000 10977524928 11408986112 1979929760 19.464 100 52 104 1 2056873808 59832000 17112048
23:48:59 9623 8192000000 10963304464 11400183808 1974892736 19.424 100 52 104 1 2053319568 60763488 17663344
23:49:18 10963 8192000000 10966294256 11395907584 1971803840 19.400 100 45 90 2 2044740240 57570768 15365632
23:49:38 7192 8192000000 10965227872 11403247616 1980162768 19.466 100 51 102 0 2052007968 54361664 17483536
23:49:54 8838 8192000000 10964483296 11406430208 1980968272 19.472 100 39 76 0 2049433584 55349104 13116208
23:50:14 10458 8192000000 10969771568 11413323776 1988765872 19.534 100 41 82 4 2056910928 53990144 14154912
23:50:36 5738 8192000000 10970059920 11416285184 1990985776 19.552 100 45 90 0 2061382048 55640960 14755312
23:51:00 6242 8192000000 10966592128 11391639552 1957242768 19.284 99 57 114 1 2031509120 54924304 19342048
23:51:18 24948 8192000000 10941481264 11391938560 1954317328 19.261 99 41 80 1 2025902640 57968880 13616432
23:52:08 12780 8192000000 10944221984 11385118720 1949917248 19.226 99 40 80 2 2013848080 50742336 13188496
23:52:53 15096 8192000000 10938504512 11394224128 1965479072 19.350 100 32 64 1 2026420784 49787504 11154208
23:53:16 9069 8192000000 10941753840 11388452864 1941121904 19.156 99 31 62 2 2005600528 53580048 10898576
23:53:37 4795 8192000000 10956270368 11398787072 1959183088 19.300 100 45 89 4 2033537152 58630224 15723840
23:53:48 8645 8192000000 10951035200 11398184960 1954539952 19.263 100 30 60 1 2028705504 62746848 11418704
23:54:05 14987 8192000000 10964407664 11405991936 1959003168 19.298 100 40 80 0 2042174176 68112256 15058752
23:54:29 18349 8192000000 10954386000 11402981376 1941415904 19.158 99 34 68 1 2023780992 69311760 13053328
23:55:15 17594 8192000000 10942376208 11401019392 1956750464 19.280 100 27 54 2 2026884736 59998672 10135600
23:55:39 22062 8192000000 10923534496 11395342336 1933023264 19.091 99 24 48 1 2006469840 64090320 9356256
23:57:30 48061 8192000000 10911091488 11361624064 1952323776 19.245 100 19 37 0 1970463248 13013760 5125712
23:58:24 43713 8192000000 10879517632 11340169216 1919637888 18.984 98 14 28 1 1936495904 13483472 3374544
23:59:14 87918 8192000000 10879357728 11321544704 1903644592 18.856 97 27 55 1 1922026528 11159968 7221968
00:00:49 61949 8192000000 10886961360 11340341248 1940530640 19.151 99 47 95 2 1966767312 12868240 13368432
00:02:32 87208 8192000000 10892069728 11342462976 1914158016 18.940 98 37 75 2 1935313664 11282416 9873232
00:04:06 93733 8192000000 10905553216 11344080896 1919806480 18.985 98 25 50 2 1939758496 13018656 6933360
00:05:51 42761 8192000000 10897031664 11339194368 1917005408 18.963 98 33 66 0 1940108896 14071152 9032336
00:06:43 46184 8192000000 10873569936 11330940928 1915410752 18.950 98 9 18 3 1927455488 8828048 3216688
00:07:35 63104 8192000000 10860184624 11312750592 1924063920 19.019 99 15 30 0 1937417280 9074496 4278864
00:08:45 5793 8192000000 10886033072 11333697536 1948173200 19.212 100 30 58 0 1967394496 10710576 8510720
00:08:58 19143 8192000000 10905935392 11359707136 1964519328 19.342 100 41 82 1 1988545936 12034592 11992016
00:09:27 29342 8192000000 10907608400 11365507072 1970082256 19.386 100 14 28 0 1986115200 11830256 4202688
00:10:11 29906 8192000000 10919477360 11371851776 1980182320 19.466 100 29 57 1 2001139536 12459536 8497680
00:10:53 58443 8192000000 10908986832 11370237952 1956731904 19.280 99 31 60 2 1983634608 17432288 9470416
00:11:58 50927 8192000000 10898726432 11371061248 1963517408 19.334 99 22 44 0 1983745840 13968352 6260080
00:12:55 34010 8192000000 10872261264 11347709952 1955938960 19.274 99 14 28 0 1969731792 9815312 3977520
00:13:36 8502 8192000000 10886869232 11365257216 1971853328 19.400 100 6 12 0 1982667584 9549504 1264752
00:13:50 5657 8192000000 10897634960 11371683840 1974426928 19.421 100 10 21 0 1991035216 13484672 3123616
00:14:02 30538 8192000000 10912029440 11382259712 1969455456 19.381 100 16 32 1 1994416096 20237728 4722912
00:14:48 27361 8192000000 10901761904 11383066624 1981584496 19.477 100 19 38 0 2001190352 14532352 5073504
00:15:28 51625 8192000000 10876410464 11348185088 1885524352 18.710 95 11 22 1 1896951632 8553920 2873360
00:16:27 42060 8192000000 10884943344 11355992064 1948132768 19.212 99 21 41 0 1967407232 13411520 5862944
00:17:50 38443 8192000000 10884380176 11354701824 1928677984 19.056 98 19 38 0 1941090624 7503584 4909056
00:18:36 74558 8192000000 10867326400 11355537408 1927730112 19.049 98 23 46 0 1945382416 10771216 6881088
00:20:02 44587 8192000000 10856809728 11325132800 1914603744 18.944 98 13 26 1 1927518928 9169648 3745536
00:20:53 56002 8192000000 10860195680 11342520320 1933282368 19.093 99 26 52 1 1949661584 8813568 7565648
00:21:55 78854 8192000000 10875062688 11348733952 1924698176 19.024 99 13 26 0 1935014032 6912976 3402880
00:23:20 62093 8192000000 10853405680 11335417856 1871482240 18.596 96 8 16 0 1887581840 13797376 2302224
00:24:29 77449 8192000000 10861697504 11322011648 1869275552 18.578 96 10 20 0 1888705024 16735296 2694176
00:26:28 47591 8192000000 10860152560 11331584000 1893593584 18.775 98 14 28 0 1918182080 20059952 4528544
00:27:24 55090 8192000000 10862983568 11327684608 1888339408 18.732 97 12 23 1 1899748672 8963376 2445888
00:28:25 60413 8192000000 10875342320 11357085696 1934992400 19.107 99 10 20 0 1947839760 10175808 2671552
00:29:33 62451 8192000000 10892718048 11346698240 1888782624 18.736 96 21 42 1 1903528704 9197664 5548416
00:30:43 28616 8192000000 10891179088 11352641536 1918383072 18.974 98 41 82 0 1940116848 10215264 11518512
00:31:24 20067 8192000000 10895331792 11338252288 1917061136 18.963 98 41 82 1 1938579776 10059360 11459280
00:31:54 20549 8192000000 10900727616 11359784960 1959398704 19.301 100 43 86 0 1984495040 12392208 12704128
00:32:25 40037 8192000000 10888839824 11361435648 1945927280 19.194 99 25 50 1 1967799568 15099664 6772624
00:33:12 39680 8192000000 10911676752 11366957056 1946371504 19.198 99 37 73 1 1969761600 13177424 10212672
00:34:02 37124 8192000000 10894219760 11351678976 1920542944 18.991 98 18 36 0 1933977104 8758800 4675360
00:34:47 19526 8192000000 10907982000 11364249600 1968500304 19.374 100 36 71 0 1987632736 9181088 9951344
00:35:14 92179 8192000000 10885861712 11361435648 1889202672 18.739 96 24 48 0 1909639424 13676928 6759824
00:36:55 124416 8192000000 10895184368 11368386560 1945418736 19.190 99 8 16 0 1962031664 14279536 2333392
00:39:05 72839 8192000000 10899258976 11369562112 1958131232 19.291 99 34 66 1 1975335648 7454608 9749808
00:40:47 49889 8192000000 10877380528 11364208640 1955141728 19.267 100 29 58 3 1977516288 14413504 7961056
00:41:46 50304 8192000000 10875884208 11361415168 1938391536 19.134 99 7 14 0 1953930720 13532256 2006928
00:42:43 59571 8192000000 10875699328 11350941696 1930732800 19.073 98 21 42 1 1955427360 18617568 6076992
00:45:07 58930 8192000000 10886976944 11377315840 1926977616 19.043 98 20 40 0 1957269616 24095152 6196848
00:46:22 69603 8192000000 10904416896 11385864192 1975450944 19.429 100 19 39 2 1998803488 18179408 5173136
00:48:30 52845 8192000000 10890265232 11368239104 1949727552 19.224 99 23 46 1 1974102192 17193616 7181024
00:49:29 84161 8192000000 10915465632 11376189440 1966292128 19.356 100 21 42 1 1994774416 22014352 6467936
00:51:01 15675 8192000000 10880002496 11352576000 1959059456 19.299 99 41 83 2 1982260448 11574832 11626160
00:51:23 49814 8192000000 10891869792 11369037824 1950294800 19.229 99 19 37 1 1968361728 12843360 5223568
00:52:20 81472 8192000000 10877365552 11360280576 1913286880 18.933 97 13 26 2 1929256656 12869808 3099968
00:53:47 64543 8192000000 10914464032 11355066368 1914661872 18.944 97 46 91 3 1937477920 10521760 12294288
00:54:58 19269 8192000000 10887326720 11348213760 1937788448 19.129 99 40 79 1 1956905984 7923552 11193984
00:55:27 20964 8192000000 10882992816 11346821120 1920375168 18.990 98 34 68 0 1942498688 12925504 9198016
00:55:55 24788 8192000000 10885356704 11344138240 1942256592 19.165 99 48 96 2 1966220368 10465808 13497968
00:56:26 31025 8192000000 10871459296 11348037632 1915238016 18.949 98 31 62 1 1934862176 11223184 8400976
00:57:13 87023 8192000000 10863800768 11338817536 1836490176 18.312 94 19 39 2 1851714640 9842064 5382400
00:58:47 36171 8192000000 10892658864 11357855744 1941645232 19.160 99 24 48 4 1956851840 8444800 6761808
00:59:34 43105 8192000000 10901696560 11359805440 1934094608 19.100 98 27 54 1 1951266000 10410240 6761152
01:00:23 46417 8192000000 10886423280 11366744064 1924754496 19.025 98 20 40 1 1944583216 14659120 5169600
01:01:16 65767 8192000000 10883994704 11367333888 1922137680 19.004 98 15 30 1 1938602160 12374640 4089840
01:02:40 30452 8192000000 10921854880 11380527104 1959516528 19.302 99 32 65 2 1981197488 12397600 9283360
01:03:22 48189 8192000000 10882017392 11370176512 1919060848 18.979 97 25 50 1 1942295872 16538464 6696560
01:04:18 135827 8192000000 10908608304 11377180672 1907014528 18.883 97 10 20 1 1925772208 16286864 2470816
01:06:40 105181 8192000000 10871437008 11340500992 1854301152 18.457 94 16 32 0 1865897680 6645456 4951072
01:08:57 80754 8192000000 10874101536 11347369984 1881617968 18.678 96 25 50 0 1899338720 9864368 7856384
01:10:26 39546 8192000000 10876078976 11361669120 1948290768 19.213 100 14 28 0 1967726624 15240304 4195552
01:11:12 22451 8192000000 10899655088 11366678528 1956437920 19.278 100 24 48 2 1981454800 17218224 7798656
01:11:41 46765 8192000000 10851731408 11328364544 1893906800 18.777 97 13 26 2 1909255504 11703008 3645696
01:12:34 45061 8192000000 10880239152 11354099712 1945360144 19.190 100 12 24 1 1962863296 13945888 3557264
01:14:05 55966 8192000000 10851599456 11326013440 1880283232 18.667 96 19 36 1 1894698576 8852704 5562640
01:15:30 71526 8192000000 10859495872 11343978496 1941350928 19.158 100 14 28 1 1954460912 9061744 4048240
01:17:03 77601 8192000000 10884000208 11369762816 1931184304 19.076 99 10 19 1 1941189696 7789232 2216160
01:18:28 62085 8192000000 10886293840 11355754496 1927101760 19.044 98 19 38 1 1946235216 13150560 5982896
01:19:36 59770 8192000000 10867350592 11342159872 1912142688 18.924 98 14 28 1 1922782384 7152192 3487504
01:20:53 22926 8192000000 10893346976 11346685952 1914731072 18.945 98 53 104 3 1942710352 12193040 15786240
01:21:28 73061 8192000000 10865368256 11338678272 1892971984 18.770 97 19 38 0 1909607824 11624912 5010928
01:22:54 88991 8192000000 10863558128 11347111936 1861224048 18.513 96 16 32 2 1886636464 20810304 4602112
01:24:31 51413 8192000000 10866206144 11320856576 1878033088 18.649 97 14 28 0 1893260912 11758640 3469184
01:25:30 59250 8192000000 10885124992 11345670144 1886011488 18.714 97 37 75 0 1913204512 17498176 9694848
01:26:37 35063 8192000000 10894245296 11357507584 1950245312 19.228 100 25 50 0 1966602944 9542736 6814896
01:27:21 31193 8192000000 9304698144 9579778048 459587440 5.312 24 8 12 2 465060400 3181184 2291776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 203 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 19-06-2021 01:29:15 to 19-06-2021 01:29:16.

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          254693
MON$OLDEST_ACTIVE               254694
MON$OLDEST_SNAPSHOT             254694
MON$NEXT_TRANSACTION            254694
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                       2049824
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:57: 
:58: mscs-test-161.budzdorov.ru    Sat Jun 19 01:27:54 2021
:59:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:60: 
:61: 
:62: mscs-test-161.budzdorov.ru    Sat Jun 19 01:27:55 2021
:63:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:64: 
--- end of diff output ---

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

19.06.21 01:29:17. 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-19 01:29:20 No severe PSQL-related problems occured
19.06.21 01:29:21. End of report.