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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-02 19:27:01
DTS_END                         2020-12-02 19:27:01.5310
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/58592
TRN_ID                          243980
ATT_ID                          675
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: 9121.93 24177 1094632
customer order: creation 173.15 380 20778
customer order: refuse 15.16 345 1819
order to supplier: creation 45.78 1394 5494
order to supplier: removal 3.10 110785 372
invoice (draft): creation 47.00 3525 5640
invoice (draft): removal 51.79 758 6215
invoice accept: apply 41.98 18499 5037
invoice accept: cancel 47.18 747 5662
customer reserve: creation 3796.45 187 455574
customer reserve: removal 4606.21 58 552745
realization accept: apply 84.68 179 10161
realization accept: cancel 79.25 106 9510
payment from customer: creation 59.41 135 7129
payment from customer: removal 5.66 103 679
payment to supplier: creation 49.25 149 5910
payment to supplier: removal 3.39 86 407
service: total inventory turnovers 4.93 954 592
service: total monetary turnovers 6.77 33 812
service: aggregate perf. data 0.77 26286 92
service: refresh index statistics 0.03 318836 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-12-2020 19:27:56 to 02-12-2020 19:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1606
TEST_TIME 2 3000
TEST_TIME 3 4316
TEST_TIME 4 4794
TEST_TIME 5 5351
TEST_TIME 6 6262
TEST_TIME 7 5917
TEST_TIME 8 5803
TEST_TIME 9 6239
TEST_TIME 10 6433
TEST_TIME 11 6785
TEST_TIME 12 6673
TEST_TIME 13 6777
TEST_TIME 14 6856
TEST_TIME 15 7226
TEST_TIME 16 7191
TEST_TIME 17 7170
TEST_TIME 18 7181
TEST_TIME 19 7882
TEST_TIME 20 8290
TEST_TIME 21 8263
TEST_TIME 22 8252
TEST_TIME 23 8670
TEST_TIME 24 8689
TEST_TIME 25 9302
TEST_TIME 26 9621
TEST_TIME 27 9805
TEST_TIME 28 10688
TEST_TIME 29 10564
TEST_TIME 30 10249
TEST_TIME 31 10365
TEST_TIME 32 10205
TEST_TIME 33 9955
TEST_TIME 34 9933
TEST_TIME 35 10100
TEST_TIME 36 9968
TEST_TIME 37 9922
TEST_TIME 38 9918
TEST_TIME 39 9771
TEST_TIME 40 9794
TEST_TIME 41 9772
TEST_TIME 42 9586
TEST_TIME 43 9407
TEST_TIME 44 9506
TEST_TIME 45 9362
TEST_TIME 46 9295
TEST_TIME 47 9330
TEST_TIME 48 9237
TEST_TIME 49 9145
TEST_TIME 50 9123
TEST_TIME 51 9222
TEST_TIME 52 9312
TEST_TIME 53 9316
TEST_TIME 54 9348
TEST_TIME 55 9412
TEST_TIME 56 9391
TEST_TIME 57 9401
TEST_TIME 58 9379
TEST_TIME 59 9430
TEST_TIME 60 9404
TEST_TIME 61 9406
TEST_TIME 62 9548
TEST_TIME 63 9424
TEST_TIME 64 9319
TEST_TIME 65 9248
TEST_TIME 66 9229
TEST_TIME 67 9202
TEST_TIME 68 9138
TEST_TIME 69 9051
TEST_TIME 70 9092
TEST_TIME 71 9030
TEST_TIME 72 8958
TEST_TIME 73 8988
TEST_TIME 74 8963
TEST_TIME 75 8919
TEST_TIME 76 8950
TEST_TIME 77 9014
TEST_TIME 78 9004
TEST_TIME 79 8968
TEST_TIME 80 9025
TEST_TIME 81 9080
TEST_TIME 82 9038
TEST_TIME 83 9075
TEST_TIME 84 9049
TEST_TIME 85 9272
TEST_TIME 86 9229
TEST_TIME 87 9294
TEST_TIME 88 9229
TEST_TIME 89 9165
TEST_TIME 90 9165
TEST_TIME 91 9122
TEST_TIME 92 9108
TEST_TIME 93 9041
TEST_TIME 94 9042
TEST_TIME 95 9048
TEST_TIME 96 9112
TEST_TIME 97 9097
TEST_TIME 98 9063
TEST_TIME 99 9090
TEST_TIME 100 9210
TEST_TIME 101 9166
TEST_TIME 102 9227
TEST_TIME 103 9222
TEST_TIME 104 9210
TEST_TIME 105 9176
TEST_TIME 106 9310
TEST_TIME 107 9288
TEST_TIME 108 9228
TEST_TIME 109 9181
TEST_TIME 110 9192
TEST_TIME 111 9166
TEST_TIME 112 9121
TEST_TIME 113 9118
TEST_TIME 114 9136
TEST_TIME 115 9136
TEST_TIME 116 9159
TEST_TIME 117 9151
TEST_TIME 118 9147
TEST_TIME 119 9199
TEST_TIME 120 9123

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-12-2020 19:28:00 to 02-12-2020 19:28:03.

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 1516882 1516882 0 0.00 0 21826 7 0 0
doc_list_biud 1516851 1516851 0 0.00 0 25806 27 0 0
sp_add_invoice_to_stock 5100 5037 63 1.23 40 211172 18499 0 63
sp_cancel_adding_invoice 5662 5662 0 0.00 5 64131 747 0 0
sp_cancel_client_order 1819 1819 0 0.00 4 10467 346 0 0
sp_cancel_customer_reserve 552745 552745 0 0.00 1 25809 59 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 2 9537 104 0 0
sp_cancel_pay_to_supplier 407 407 0 0.00 3 3116 87 0 0
sp_cancel_supplier_invoice 6220 6215 5 0.08 1 12456 759 0 5
sp_cancel_supplier_order 372 372 0 0.00 19 955376 110785 0 0
sp_cancel_write_off 9510 9510 0 0.00 1 10572 106 0 0
sp_client_order 20778 20778 0 0.00 3 28561 380 0 0
sp_customer_reserve 455574 455574 0 0.00 0 80591 187 0 0
sp_fill_shopping_cart 31912 31912 0 0.00 1 18109 46 0 0
sp_fill_shopping_cart_clo_res 455573 455573 0 0.00 0 16463 16 0 0
sp_get_clo_for_invoice 5036 5036 0 0.00 0 26342 321 0 0
sp_kill_cost_storno 16258 16258 0 0.00 0 10658 58 0 0
sp_kill_qstorno_ret_qs2qd 1121587 1121587 0 0.00 0 25778 32 0 0
sp_kill_qty_storno 591500 591500 0 0.00 0 25805 68 0 0
sp_lock_selected_doc 20929 20929 0 0.00 0 6188 5 0 0
sp_make_cost_storno 28236 28236 0 0.00 0 21810 60 0 0
sp_multiply_rows_for_pdistr 28205 28205 0 0.00 0 12330 34 0 0
sp_multiply_rows_for_qdistr 20778 20778 0 0.00 0 17883 162 0 0
sp_pay_from_customer 7129 7129 0 0.00 4 16186 135 0 0
sp_pay_to_supplier 5910 5910 0 0.00 5 21180 149 0 0
sp_payment_common 13028 13028 0 0.00 1 16050 41 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 10459 300 0 0
sp_qd_handle_on_invoice_upd_sts 10691 10691 0 0.00 0 16239 324 0 0
sp_qd_handle_on_reserve_upd_sts 10148 10148 0 0.00 0 9450 52 0 0
sp_reserve_write_off 10161 10161 0 0.00 6 14245 179 0 0
sp_supplier_invoice 5640 5640 0 0.00 7 107322 3525 0 0
sp_supplier_order 5494 5494 0 0.00 5 53255 1395 0 0
srv_aggregate_perf_data 92 92 0 0.00 2261 458541 26286 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1271 127798 31585 0 0
srv_find_qd_qs_mism 1047119 1047119 0 0.00 0 17549 6 0 0
srv_make_invnt_saldo 592 592 0 0.00 31 39206 954 0 0
srv_make_money_saldo 812 812 0 0.00 1 5198 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 269303 364526 318836 0 0
t$perf-abend:sp_add_invoice_to_stock 63 63 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5037 5037 0 0.00 0 14788 170 0 0
t$perf-norm:sp_cancel_adding_invoice 443 443 0 0.00 0 7977 138 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 12299 23 0 0
t$perf-norm:sp_cancel_customer_reserve 632 632 0 0.00 0 3610 19 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 1000 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 407 407 0 0.00 0 3189 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 2825 33 0 0
t$perf-norm:sp_cancel_supplier_order 372 372 0 0.00 0 26509 1755 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 9721 18 0 0
t$perf-norm:sp_client_order 20778 20778 0 0.00 0 12872 19 0 0
t$perf-norm:sp_customer_reserve 1053 1053 0 0.00 0 12228 25 0 0
t$perf-norm:sp_pay_from_customer 7129 7129 0 0.00 0 12320 11 0 0
t$perf-norm:sp_pay_to_supplier 5910 5910 0 0.00 0 15485 17 0 0
t$perf-norm:sp_reserve_write_off 10161 10161 0 0.00 0 23340 12 0 0
t$perf-norm:sp_supplier_invoice 5640 5640 0 0.00 0 7499 20 0 0
t$perf-norm:sp_supplier_order 5494 5494 0 0.00 0 6446 18 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 359 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 597 9 0 0
t$perf-norm:srv_make_invnt_saldo 592 592 0 0.00 0 1439 21 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 757 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10184 10058 126 1.23 0 6299 18 0 126
v_all_customers 37802 37802 0 0.00 0 61 1 0 0
v_all_suppliers 30596 30596 0 0.00 0 92 1 0 0
v_all_wares 41556 41556 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 886 886 0 0.00 0 857 6 0 0
v_cancel_client_order 3638 3638 0 0.00 0 5525 8 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 3398 7 0 0
v_cancel_customer_reserve 1264 1264 0 0.00 0 436 3 0 0
v_cancel_payment_to_supplier 814 814 0 0.00 0 2416 11 0 0
v_cancel_supplier_invoice 772 762 10 1.29 0 2806 24 0 10
v_cancel_supplier_order 744 744 0 0.00 0 857 8 0 0
v_cancel_write_off 2040 2040 0 0.00 0 2305 16 0 0
v_max_id_clo_ord 5494 5494 0 0.00 0 2264 2 0 0
v_max_id_clo_res 1053 1053 0 0.00 0 4886 16 0 0
v_max_id_ord_sup 5640 5640 0 0.00 0 6867 6 0 0
v_max_non_paid_invoice 1738 1738 0 0.00 0 1541 3 0 0
v_max_non_paid_realizn 3846 3846 0 0.00 0 5530 7 0 0
v_min_id_clo_ord 5494 5494 0 0.00 0 14851 14 0 0
v_min_id_clo_res 1053 1053 0 0.00 0 2427 5 0 0
v_min_id_ord_sup 5640 5640 0 0.00 0 8564 11 0 0
v_min_non_paid_invoice 5902 5902 0 0.00 0 10800 23 0 0
v_min_non_paid_realizn 7124 7124 0 0.00 0 10531 26 0 0
v_our_firm 10310 10310 0 0.00 0 18 1 0 0
v_reserve_write_off 20294 20294 0 0.00 0 6080 6 0 0
x_lock_depdocs_on_canc_invoice 11496 11496 0 0.00 0 15172 109 0 0
x_lock_depdocs_on_canc_sup_ord 372 372 0 0.00 0 12774 416 0 0
x_make_qstorno_1000_1200 5494 5494 0 0.00 1 42177 1305 0 0
x_make_qstorno_1200_2000 5640 5640 0 0.00 3 107031 3354 0 0
x_make_qstorno_2100_3300 455574 455574 0 0.00 0 80590 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-12-2020 19:28:04 to 02-12-2020 19:28:08.

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:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:11 14798 8192000000 10218818816 10521300992 837709632 9.277 67 49 100 0 856083520 2313824 16060064
16:57:33 23177 8192000000 10315372464 10630602752 1368053120 14.310 100 87 174 0 1402103952 4735696 29315136
16:58:07 27035 8192000000 10349794880 10670034944 1404374624 14.634 100 86 173 0 1439140288 6131584 28634080
16:58:43 19480 8192000000 10383342576 10702508032 1425096688 14.818 100 87 174 0 1460876768 6987568 28792512
16:59:14 21883 8192000000 10401100208 10727485440 1451505968 15.051 100 84 168 1 1486836352 7914432 27415952
16:59:56 17122 8192000000 10415128848 10741424128 1468055088 15.197 100 91 182 0 1505993584 8611616 29326880
17:00:28 8993 8192000000 10420466576 10750943232 1485545168 15.350 100 88 177 0 1522475888 8864912 28065808
17:00:46 21882 8192000000 10444431504 10782445568 1499124624 15.469 100 81 162 0 1533263216 9012640 25125952
17:01:17 10352 8192000000 10474620640 10813730816 1533407536 15.767 100 84 168 0 1568601856 9510688 25683632
17:01:38 12526 8192000000 10498646992 10847891456 1555232480 15.955 100 79 158 1 1588994464 9572720 24189264
17:01:59 6310 8192000000 10518527728 10867748864 1577739024 16.149 100 82 164 1 1612283904 9901184 24643696
17:02:16 10885 8192000000 10534474544 10890080256 1594433040 16.292 100 76 152 1 1627427824 10133104 22861680
17:02:35 13374 8192000000 10566667344 10925088768 1625453552 16.556 100 77 149 1 1658577904 10334784 22789568
17:02:57 11562 8192000000 10597202224 10959110144 1649673008 16.762 100 81 164 0 1684576608 11171712 23731888
17:03:16 9504 8192000000 10608847008 10973532160 1667343712 16.911 100 77 153 2 1702075952 12058496 22673744
17:03:34 6533 8192000000 10630426416 11000893440 1684597856 17.056 100 73 146 0 1717004960 11031216 21375888
17:03:48 6728 8192000000 10653014464 11026579456 1715046432 17.311 100 75 150 1 1748988736 12063904 21878400
17:04:02 6634 8192000000 10664232528 11040153600 1724699712 17.391 100 76 152 1 1758006064 11932352 21374000
17:04:16 5762 8192000000 10676167328 11052773376 1740444096 17.522 100 75 150 0 1774279872 12717376 21118400
17:04:29 5434 8192000000 10693863840 11068993536 1754885936 17.642 100 82 164 0 1790796944 12915648 22995360
17:04:41 4293 8192000000 10700867072 11081035776 1762689744 17.707 100 78 156 1 1797731264 13100640 21940880
17:04:52 5597 8192000000 10706493696 11087134720 1767757632 17.749 100 82 164 1 1804893584 13638752 23497200
17:05:05 3992 8192000000 10723745936 11101249536 1782665200 17.871 100 86 172 5 1819251936 13004224 23582512
17:05:16 4211 8192000000 10725387200 11107700736 1784691968 17.888 100 82 163 1 1820678800 13349824 22637008
17:05:28 3807 8192000000 10733625936 11114766336 1794472288 17.969 100 85 171 1 1831294144 13012208 23809648
17:05:38 3022 8192000000 10743086928 11124592640 1800217040 18.016 100 80 159 2 1835643136 13071120 22354976
17:05:48 1699 8192000000 10750198144 11134074880 1813667632 18.126 100 84 168 0 1850315104 13699120 22948352
17:05:57 6695 8192000000 10756854144 11143843840 1814180464 18.130 100 83 166 0 1851883680 15016608 22686608
17:06:11 2859 8192000000 10774495424 11156389888 1821631872 18.191 100 86 173 2 1858557376 13533136 23392368
17:06:20 2276 8192000000 10770562368 11159457792 1833813424 18.290 100 86 172 2 1871786112 13844256 24128432
17:06:29 2037 8192000000 10782740080 11167240192 1840035648 18.341 100 87 174 3 1879094720 14649568 24409504
17:06:37 1715 8192000000 10783687920 11169566720 1844176240 18.375 100 88 176 0 1881920576 13144272 24600064
17:06:45 1875 8192000000 10790537808 11176914944 1845785200 18.388 100 88 175 0 1884155712 13477120 24893392
17:06:54 1823 8192000000 10805793472 11190988800 1858039376 18.487 100 86 172 1 1895825984 13450592 24336016
17:07:02 2368 8192000000 10802574688 11189968896 1861299696 18.514 100 88 170 0 1898887664 13268224 24319744
17:07:11 1914 8192000000 10809762464 11198070784 1869511488 18.580 100 97 195 0 1910679520 14463120 26704912
17:07:19 1574 8192000000 10812652384 11202174976 1868277552 18.570 100 90 180 0 1907556160 14011312 25267296
17:07:27 1316 8192000000 10811632128 11198283776 1867431088 18.563 100 85 169 2 1904134048 13119440 23583520
17:07:35 15601 8192000000 10785601712 11193262080 1864251104 18.538 100 60 119 1 1892434048 12141872 16041072
17:08:09 2053 8192000000 10805745840 11202195456 1870912960 18.592 100 79 160 1 1903588256 10643776 22031520
17:08:23 32849 8192000000 10790833216 11199483904 1865794560 18.550 100 32 63 1 1881425968 6412464 9218944
17:09:02 17547 8192000000 10784570704 11205558272 1871642720 18.598 100 39 77 2 1889489136 6427312 11419104
17:09:28 3455 8192000000 10785955952 11208200192 1874353008 18.619 100 34 68 0 1891761184 7777744 9630432
17:09:38 8858 8192000000 10774970912 11205009408 1873832016 18.615 100 24 48 0 1887572032 7291456 6448560
17:09:55 5560 8192000000 10792811904 11212771328 1875697376 18.630 100 32 62 3 1891621792 7509520 8414896
17:10:07 2602 8192000000 10796182992 11214286848 1877488272 18.645 100 40 80 1 1896979408 7910736 11580400
17:10:18 6152 8192000000 10787701456 11212505088 1879775856 18.663 100 31 62 0 1895248864 6683504 8789504
17:10:31 7225 8192000000 10786243856 11217784832 1878602688 18.654 100 24 48 0 1895738944 10547184 6589072
17:10:47 8847 8192000000 10787973744 11217387520 1880190000 18.667 100 22 44 0 1892242304 5875664 6176640
17:11:04 9208 8192000000 10786997344 11221938176 1887586192 18.726 100 33 66 1 1903640512 6898080 9156240
17:11:20 7594 8192000000 10806623136 11230351360 1891040784 18.754 100 29 58 1 1906485488 7209632 8235072
17:11:34 5434 8192000000 10805837936 11231563776 1892100848 18.763 100 26 52 2 1907133040 7300240 7731952
17:11:47 10913 8192000000 10802591472 11235213312 1891423392 18.757 100 17 34 0 1902270368 6438448 4408528
17:12:04 9216 8192000000 10801044976 11233988608 1892752880 18.768 100 20 41 1 1905414208 7280848 5380480
17:12:24 4553 8192000000 10803110176 11234516992 1894286448 18.780 100 21 42 2 1906215984 6145872 5783664
17:12:35 8554 8192000000 10810026496 11238187008 1895020992 18.786 100 18 35 3 1905868096 5288128 5558976
17:12:50 18948 8192000000 10805975728 11234418688 1900407232 18.830 100 27 52 1 1914377664 5771104 8199328
17:13:17 63247 8192000000 10836876048 11252695040 1901762992 18.840 100 40 81 1 1918932560 4903200 12266368
17:14:27 5818 8192000000 10807442016 11246661632 1898805040 18.817 100 40 80 1 1919286800 9337040 11144720
17:14:40 11400 8192000000 10814557344 11245559808 1898065584 18.811 100 20 38 0 1908964016 5461952 5436480
17:14:58 4416 8192000000 10806944064 11242467328 1898137456 18.811 100 28 56 1 1912589264 6214176 8237632
17:15:10 7435 8192000000 10821130400 11255115776 1902292896 18.845 100 25 50 1 1915996032 7084656 6618480
17:15:25 4890 8192000000 10824278864 11254738944 1889188160 18.739 99 27 54 0 1903715280 7175664 7351456
17:15:37 6657 8192000000 10816014864 11254984704 1903724144 18.856 100 28 56 3 1917821664 6006592 8090928
17:15:50 7279 8192000000 10808996384 11249508352 1902776768 18.849 100 33 66 2 1918746720 6214848 9755104
17:16:05 7099 8192000000 10770896032 11198238720 1841934624 18.357 97 32 63 1 1857884944 6731424 9218896
17:16:26 5101 8192000000 10804640592 11239051264 1894006608 18.778 100 28 56 3 1907910160 5543936 8359616
17:16:37 9045 8192000000 10810413440 11240112128 1870995488 18.592 99 18 36 0 1881457216 5402448 5059280
17:16:59 10899 8192000000 10780540272 11207118848 1807982688 18.079 96 25 50 0 1820867808 5516400 7368720
17:17:16 71455 8192000000 10744742080 11173666816 1684908400 17.059 90 21 40 0 1695704512 4541264 6254848
17:18:34 12106 8192000000 10746913200 11160731648 1760388880 17.688 96 17 29 2 1768382256 4443200 3550176
17:18:52 6331 8192000000 10708748144 11124912128 1734102432 17.470 95 20 41 2 1746607456 6117504 6387520
17:19:05 7836 8192000000 10692455520 11109355520 1714169616 17.304 95 27 53 1 1728931600 6496816 8265168
17:19:19 6046 8192000000 10719857120 11133919232 1785795440 17.897 99 19 37 2 1796789456 5972320 5021696
17:19:31 7090 8192000000 10717729152 11134873600 1753314000 17.629 97 16 32 0 1763079824 5216496 4549328
17:19:47 7168 8192000000 10718338928 11135365120 1773335312 17.795 98 22 44 2 1785065856 5214896 6515648
17:20:03 11567 8192000000 10723123056 11140329472 1761367504 17.696 97 26 51 1 1775142960 6423968 7351488
17:20:22 9365 8192000000 10714241776 11128250368 1764292208 17.720 98 20 40 2 1775620944 5725968 5602768
17:20:37 8115 8192000000 10736083840 11146526720 1753043360 17.627 97 24 48 2 1766382144 5735536 7603248
17:20:56 11922 8192000000 10713379072 11128991744 1740526880 17.523 96 27 54 0 1754014048 5449488 8037680
17:21:15 8838 8192000000 10728697584 11139784704 1775857696 17.815 98 24 47 2 1788487888 5646704 6983488
17:21:31 8999 8192000000 10729242480 11147902976 1795769056 17.979 99 30 60 2 1810277424 5381936 9126432
17:21:48 30450 8192000000 10721161184 11151302656 1773022272 17.792 97 30 58 3 1788228160 5812912 9392976
17:22:49 29711 8192000000 10743878512 11171934208 1827877952 18.242 100 15 30 2 1837304224 5328976 4097296
17:23:25 11766 8192000000 10767064992 11187957760 1843742800 18.371 100 27 55 1 1857470064 5838032 7889232
17:23:43 5095 8192000000 10760274336 11186163712 1848970208 18.414 100 31 62 1 1864962928 7051616 8941104
17:23:57 5724 8192000000 10763448560 11195482112 1852924624 18.446 100 20 40 1 1864244352 5148720 6171008
17:24:09 7491 8192000000 10776491936 11200237568 1858895760 18.494 100 18 35 1 1868592240 5402640 4293840
17:24:23 5411 8192000000 10783156400 11209641984 1864834912 18.542 100 27 54 0 1878726048 6218224 7672912
17:24:35 6909 8192000000 10798076752 11220070400 1871709696 18.598 100 35 70 1 1891873536 10008944 10154896
17:24:51 10028 8192000000 10788198544 11219329024 1874781456 18.623 100 20 38 2 1885368480 5028208 5558816
17:25:07 12161 8192000000 10792661536 11227435008 1879970864 18.665 100 21 40 4 1891581472 5536400 6074208
17:25:25 8426 8192000000 10794047568 11224387584 1886931248 18.721 100 31 62 3 1902483456 6101776 9450432
17:25:40 6079 8192000000 10816907344 11230552064 1885424448 18.709 100 20 38 1 1896478992 4811840 6242704
17:25:53 8194 8192000000 10804713520 11233427456 1885647952 18.711 100 24 48 0 1898777376 5875840 7253584
17:26:08 10156 8192000000 10794880624 11230629888 1888495824 18.734 100 18 36 0 1899971744 5809696 5666224
17:26:27 10104 8192000000 10818070912 11242643456 1891950704 18.761 100 21 41 1 1904018400 5956544 6111152
17:26:44 35632 8192000000 10845352320 11259469824 1898287152 18.813 100 31 61 3 1915338208 9631440 7419616
17:27:34 107685 8192000000 10847078224 11278274560 1924359104 19.022 100 45 89 3 1944150032 7151344 12639584
17:29:37 28216 8192000000 10872960608 11299500032 1939392880 19.142 100 42 84 2 1964497120 13701568 11402672
17:30:14 10366 8192000000 10887500144 11312640000 1948175408 19.212 100 51 100 3 1973676336 10687056 14813872
17:30:50 9285 8192000000 10884911040 11314053120 1953571696 19.255 100 44 83 1 1976230816 11159712 11499408
17:31:13 5889 8192000000 10903509712 11321831424 1942755648 19.169 99 65 130 1 1974368144 13091824 18520672
17:31:26 13220 8192000000 10899735904 11326181376 1961505664 19.318 100 61 122 0 1993294464 14447904 17340896
17:31:52 7433 8192000000 10910353584 11336724480 1968654288 19.375 100 65 125 0 1999371376 13069600 17647488
17:32:06 5843 8192000000 10904357008 11333541888 1970246464 19.387 100 54 106 4 1998471632 12684480 15540688
17:32:22 4108 8192000000 10928851792 11347623936 1978871952 19.456 100 58 115 3 2009192720 13239040 17081728
17:32:34 19236 8192000000 10916678544 11348987904 1979485360 19.461 100 65 128 1 2013698528 15531376 18681792
17:33:00 16536 8192000000 10917365184 11350970368 1978538400 19.453 100 52 103 1 2010323440 17000736 14784304
17:33:24 9684 8192000000 10927522592 11363090432 1969669360 19.383 99 54 108 0 2000192576 14340560 16182656
17:33:41 14714 8192000000 10915150864 11349434368 1966291024 19.356 99 63 122 1 1997833648 13226736 18315888
17:34:05 20049 8192000000 10905437712 11339091968 1957199072 19.284 99 45 89 2 1984144752 13522592 13423088
17:34:43 14131 8192000000 10895505344 11334860800 1956572320 19.279 99 41 82 0 1981630208 13580080 11477808
17:35:07 6618 8192000000 10912428912 11341885440 1962109120 19.323 99 51 103 0 1992474112 15652048 14712944
17:35:24 3577 8192000000 10926691056 11351097344 1980079376 19.465 100 53 103 1 2011453696 16359024 15015296
17:35:34 2559 8192000000 10935345632 11358490624 1986610288 19.517 100 69 138 1 2025395920 18451840 20333792
17:35:44 4557 8192000000 10925819232 11342675968 1962855920 19.329 99 72 141 1 2003133280 19693056 20584304
17:35:57 7615 8192000000 10919696416 11351814144 1975333344 19.428 100 58 116 0 2013409632 20456320 17619968
17:36:28 15787 8192000000 10931742816 11353141248 1964726144 19.344 99 62 121 4 2001783920 19126128 17931648
17:36:55 1996 8192000000 10943458704 11360579584 1985892832 19.511 100 63 126 3 2023209872 18724976 18592064
17:37:05 3651 8192000000 10945848944 11372756992 1995817344 19.590 100 64 125 1 2037246080 23202368 18226368
17:37:18 4636 8192000000 10926776240 11352039424 1951252112 19.236 98 61 122 0 1988720640 19586448 17882080
17:37:30 5529 8192000000 10920902784 11343884288 1957172800 19.284 99 65 128 0 1997314480 19527376 20614304
17:37:42 3614 8192000000 10908614560 11331682304 1956015248 19.274 99 72 144 0 1997711088 20558048 21137792
17:37:54 2768 8192000000 10910794784 11327340544 1954833632 19.265 99 75 148 2 1997163616 20751488 21578496
17:38:04 8766 8192000000 10912744944 11335872512 1949592640 19.223 99 63 123 1 1988590016 21087760 17909616
17:38:20 3898 8192000000 10926008384 11332435968 1948418752 19.214 99 70 139 0 1990690784 21295008 20977024
17:38:32 9513 8192000000 10907677408 11330920448 1946692704 19.200 99 61 122 0 1987528304 22329600 18506000
17:38:49 5509 8192000000 10912402528 11336179712 1961474096 19.318 100 58 114 2 1999373392 20328832 17570464
17:39:02 6981 8192000000 10907362864 11325480960 1919846928 18.986 97 70 139 2 1960165888 19815360 20503600
17:39:18 10847 8192000000 10908588704 11331145728 1955386960 19.269 100 67 132 2 1996338432 20886352 20065120
17:39:38 6967 8192000000 10901172784 11321106432 1947771984 19.209 100 62 122 1 1987985664 21554016 18659664
17:39:53 9104 8192000000 10885632512 11306123264 1919211584 18.981 99 59 118 1 1960459760 22917120 18331056
17:40:16 7181 8192000000 10892024080 11306536960 1906709216 18.880 98 64 128 1 1949076192 23536624 18830352
17:40:32 7575 8192000000 10900006256 11315052544 1921651248 19.000 99 56 111 0 1963888064 25465440 16771376
17:40:47 5735 8192000000 10901427568 11318874112 1930961984 19.075 99 68 135 2 1980290448 27840976 21487488
17:41:01 3426 8192000000 10923409520 11342569472 1958810256 19.297 100 70 140 2 2007016112 26183328 22022528
17:41:12 5424 8192000000 10905383168 11332911104 1936821504 19.121 99 65 131 1 1984650160 27941952 19886704
17:41:30 4460 8192000000 10909682496 11322216448 1935925056 19.114 99 67 134 2 1986882768 29793056 21164656
17:41:47 2715 8192000000 10912206288 11326427136 1944184144 19.180 99 74 145 0 1997116560 31015440 21916976
17:41:57 1584 8192000000 10933261248 11339108352 1955816720 19.273 100 89 178 0 2015284288 31752448 27715120
17:42:06 1270 8192000000 10941487632 11351805952 1963386560 19.333 100 82 163 0 2020897120 32639824 24870736
17:42:14 4311 8192000000 10943766768 11356692480 1955782448 19.273 99 80 159 0 2013478448 33800672 23895328
17:42:28 3335 8192000000 10921142176 11323506688 1912846384 18.929 97 74 145 1 1966579456 30498000 23235072
17:42:38 11344 8192000000 10915556784 11340558336 1938821728 19.137 99 65 128 2 1990662752 31863360 19977664
17:43:02 7224 8192000000 10922356768 11343122432 1957766688 19.288 100 69 138 0 2008968864 29962320 21239856
17:43:16 4313 8192000000 10901302240 11314749440 1918161776 18.972 98 73 146 1 1972401440 30945600 23294064
17:43:27 6016 8192000000 10930820032 11344920576 1961138192 19.315 100 69 136 0 2013320912 30721984 21460736
17:43:40 7871 8192000000 10920270416 11339309056 1954123968 19.259 100 68 136 0 2007218304 31156800 21937536
17:43:58 4189 8192000000 10937276592 11353731072 1961264256 19.316 100 68 136 1 2015372896 32679520 21429120
17:44:09 2563 8192000000 10942970592 11352346624 1961641104 19.319 100 84 169 0 2027228640 39365184 26222352
17:44:18 3761 8192000000 10945116416 11359182848 1970774848 19.392 100 80 160 2 2033405808 37298784 25332176
17:44:30 4449 8192000000 10958798592 11366141952 1971079008 19.394 100 83 162 1 2034493952 37929904 25485040
17:44:44 4743 8192000000 10951713744 11371393024 1975849296 19.432 100 79 158 2 2038453760 38154896 24449568
17:44:55 2829 8192000000 10958543056 11364433920 1959385536 19.301 99 88 176 4 2026976320 38486464 29104320
17:45:05 3166 8192000000 10963109696 11374845952 1977074896 19.442 100 80 161 1 2043374720 40397072 25902752
17:45:15 3234 8192000000 10937898240 11353542656 1936972336 19.123 98 76 149 2 2002274752 40866304 24436112
17:45:26 4333 8192000000 10948871696 11359879168 1962041360 19.322 100 82 162 0 2029822448 41357888 26423200
17:45:38 9266 8192000000 10938994784 11357380608 1957390928 19.285 100 74 146 1 2022946272 42160912 23394432
17:45:54 3917 8192000000 10951948368 11371425792 1968138976 19.371 100 68 136 1 2036636048 46668080 21828992
17:46:09 6715 8192000000 10968242544 11391696896 1983595136 19.493 100 67 133 3 2050414576 45629936 21189504
17:46:26 2775 8192000000 10985348368 11396894720 1972682432 19.407 99 87 174 0 2053399760 51878528 28838800
17:46:36 2394 8192000000 10973534336 11393032192 1986697936 19.518 100 77 152 0 2057160208 45165904 25296368
17:46:47 1420 8192000000 10959994320 11376791552 1967607024 19.366 99 78 156 0 2040917744 47508240 25802480
17:46:55 2114 8192000000 10969468624 11381088256 1979930784 19.464 100 75 149 1 2047184496 44037152 23216560
17:47:06 2729 8192000000 10965906512 11382112256 1979056864 19.457 100 77 155 1 2046587376 43143168 24387344
17:47:18 1350 8192000000 10983851840 11392593920 1987518992 19.524 100 83 162 4 2056255984 42842304 25894688
17:47:27 2902 8192000000 10986899408 11402813440 1998221248 19.609 100 79 158 0 2065495488 42290384 24983856
17:47:43 3667 8192000000 10971728576 11400196096 1994967552 19.583 100 59 118 3 2056549504 42559408 19022544
17:48:05 10824 8192000000 10956323280 11396665344 1991086496 19.552 100 42 83 1 2044957760 40038400 13832864
17:48:25 8345 8192000000 10960655056 11392753664 1989411328 19.539 100 54 107 2 2046741216 39767984 17561904
17:48:43 8188 8192000000 10962050992 11393921024 1974986896 19.425 99 63 124 1 2036460448 42529664 18943888
17:49:03 12679 8192000000 10954919152 11387596800 1976765200 19.439 100 41 81 3 2032359344 42198912 13395232
17:49:29 8908 8192000000 10954909712 11391897600 1981781584 19.479 100 48 95 0 2042529120 44293504 16454032
17:50:06 11458 8192000000 10944733376 11387445248 1969491744 19.381 100 36 73 0 2029327456 47865344 11970368
17:50:49 25048 8192000000 10910964032 11356176384 1946016384 19.195 99 26 52 1 1997422576 42293824 9112368
17:51:39 15418 8192000000 10936612864 11381469184 1961242016 19.316 100 35 70 0 2018665008 45103616 12319376
17:52:01 23874 8192000000 10934575344 11394043904 1968431712 19.373 100 28 56 0 2025433952 47215792 9786448
17:52:42 26723 8192000000 10919098720 11379015680 1963960224 19.338 100 22 44 0 2004060528 32333200 7767104
17:53:21 43104 8192000000 10916496368 11368058880 1933075456 19.091 99 24 48 1 1984260032 42907200 8277376
17:54:11 52171 8192000000 10905091568 11366649856 1911168944 18.916 98 19 38 0 1958006176 40431312 6405920
17:55:55 12208 8192000000 10897249792 11341172736 1963533040 19.334 100 47 92 2 1982514592 5996128 12985424
17:56:14 115194 8192000000 10894846912 11346808832 1926874016 19.042 98 33 66 0 1947015616 10025632 10115968
17:58:24 85807 8192000000 10901808256 11377188864 1947740432 19.208 99 12 25 0 1964007536 12877760 3389344
18:00:45 5060 8192000000 10922142176 11369013248 1984046640 19.497 100 35 69 0 2005316352 11426640 9843072
18:00:56 30489 8192000000 10903520464 11359846400 1946859424 19.201 98 28 55 1 1965420208 10671440 7889344
18:01:34 36829 8192000000 10933725808 11363811328 1956513120 19.278 99 34 67 0 1980657008 14137536 10006352
18:02:24 26711 8192000000 10911398720 11365789696 1981445216 19.476 100 27 50 0 1999222672 10463104 7314352
18:03:07 57699 8192000000 10912573712 11374460928 1969987248 19.385 99 15 29 1 1985626512 11053280 4585984
18:04:11 57425 8192000000 10915831616 11383214080 1966467712 19.357 99 7 14 1 1980108080 11956464 1683904
18:05:51 67015 8192000000 10918393872 11377455104 1953692256 19.256 98 10 21 0 1968495808 12097824 2705728
18:07:19 51894 8192000000 10909617408 11381911552 1986333072 19.515 100 8 16 0 2001891920 13148080 2410768
18:09:52 87326 8192000000 10921156384 11388616704 1974080944 19.418 99 16 32 0 1989360224 10094208 5185072
18:11:34 46751 8192000000 10941767312 11394834432 1995030656 19.584 100 28 52 3 2011407536 8420480 7956400
18:12:28 52034 8192000000 10924032016 11389640704 1986520352 19.516 99 28 56 1 2005165632 10883200 7762080
18:14:08 55821 8192000000 10898626960 11385892864 1974285280 19.419 99 11 22 0 1990843136 12648288 3909568
18:15:19 45055 8192000000 10915045952 11398451200 1999233840 19.617 100 10 20 1 2014855344 12384160 3237344
18:16:20 59843 8192000000 10943543328 11414523904 1991521520 19.556 99 20 40 0 2016360672 18613472 6225680
18:17:43 47948 8192000000 10952315552 11422388224 2021446288 19.792 100 34 69 2 2047697280 16146080 10104912
18:18:37 75234 8192000000 10919400592 11410141184 1970703856 19.391 98 11 22 1 1991894432 17405264 3785312
18:20:05 123501 8192000000 10915500880 11398840320 1918674560 18.976 96 11 22 0 1932783632 11090096 3018976
18:22:15 89737 8192000000 10905838656 11359494144 1851954272 18.438 93 16 32 0 1871383584 14807456 4621856
18:24:05 28767 8192000000 10896906736 11344121856 1939382384 19.142 99 40 79 1 1960361232 9813200 11165648
18:24:43 54926 8192000000 10861358256 11316981760 1887619664 18.727 97 25 50 1 1906080784 11746416 6714704
18:25:45 30569 8192000000 10884662896 11330113536 1930561840 19.071 99 31 62 1 1950030400 9847600 9620960
18:26:22 36747 8192000000 10855758608 11323346944 1891796800 18.760 97 17 34 4 1908343536 11941872 4604864
18:27:05 56870 8192000000 10889291200 11346579456 1896553248 18.799 97 16 32 0 1913051520 11975808 4522464
18:28:09 51549 8192000000 10889137664 11356884992 1923012544 19.011 98 23 46 1 1948288640 19320480 5955616
18:29:09 98253 8192000000 10834677792 11304935424 1812532176 18.117 93 15 30 1 1830531568 13878960 4120432
18:30:55 83701 8192000000 10850526064 11297972224 1892647600 18.767 98 34 68 1 1909419696 6820608 9951488
18:32:39 36196 8192000000 10808051248 11276611584 1871866832 18.599 97 25 50 1 1887785888 8888720 7030336
18:33:22 62934 8192000000 10808770688 11285360640 1844235616 18.375 96 14 28 2 1859714736 11261040 4218080
18:35:14 56695 8192000000 10793087120 11254435840 1824809856 18.217 96 11 23 0 1836056544 8038400 3208288
18:36:29 27514 8192000000 10800388976 11249803264 1859418752 18.499 98 20 40 0 1876052992 10860592 5773648
18:37:04 55247 8192000000 10811150576 11278733312 1841188848 18.350 97 11 22 1 1851528896 6887840 3452208
18:38:06 47683 8192000000 10817796752 11277230080 1856116800 18.472 97 18 36 0 1868199952 6361856 5721296
18:39:02 76804 8192000000 10819854304 11289075712 1880978624 18.673 98 23 46 1 1901007488 12836624 7192240
18:41:19 36720 8192000000 10821315680 11292217344 1895894656 18.793 99 14 28 0 1908943792 8981792 4067344
18:42:02 36448 8192000000 10853714608 11314565120 1922276032 19.005 100 20 40 1 1935596912 7855072 5465808
18:43:16 60819 8192000000 10859818976 11323920384 1898014624 18.810 98 16 32 0 1916556080 13733008 4808448
18:44:23 54248 8192000000 10839621392 11310985216 1893202016 18.772 98 11 21 0 1910133040 13478864 3452160
18:45:24 35133 8192000000 10876539728 11332743168 1940499280 19.151 100 22 44 1 1954438480 8131168 5808032
18:46:05 23913 8192000000 10889027232 11335507968 1916745072 18.961 98 54 104 4 1942719312 11157968 14816272
18:46:41 50734 8192000000 10876684624 11350433792 1945308112 19.189 100 18 36 0 1965739312 15553136 4878064
18:47:38 62346 8192000000 10873970048 11350790144 1954921984 19.266 100 22 44 0 1973560208 12634048 6004176
18:48:50 30312 8192000000 10887957120 11343945728 1953659408 19.256 100 30 60 1 1973910560 11726560 8524592
18:49:41 34601 8192000000 10918128032 11364130816 1961520352 19.318 100 44 88 1 1991701552 17681984 12499216
18:50:27 49882 8192000000 10889165808 11345989632 1900094816 18.827 97 37 75 3 1932220416 21595728 10529872
18:51:23 75236 8192000000 10870350080 11360632832 1939123664 19.140 100 16 32 1 1967537648 23160496 5253488
18:52:55 54408 8192000000 10888586496 11347148800 1950317856 19.229 100 15 30 2 1972739696 18458128 3963712
18:54:00 43105 8192000000 10897582192 11370164224 1948924176 19.218 99 29 58 2 1972500416 15886928 7689312
18:54:57 89250 8192000000 10907361344 11359215616 1969746000 19.383 100 17 32 1 1983251024 9471824 4033200
18:56:32 71994 8192000000 10881499376 11344543744 1858423920 18.491 94 25 48 3 1873319104 8095552 6799632
18:57:52 16159 8192000000 10898782720 11352047616 1956143120 19.275 99 55 109 1 1979733936 8093664 15497152
18:58:17 31622 8192000000 10877964288 11321188352 1937058048 19.123 98 50 101 0 1959719168 9348240 13312880
18:58:54 40646 8192000000 10887362592 11357364224 1968472960 19.373 100 33 66 1 1989466128 12050208 8942960
18:59:46 50961 8192000000 10864928352 11335467008 1928838272 19.058 98 8 16 0 1941922448 10941888 2142288
19:00:58 40492 8192000000 10886005440 11365355520 1961015664 19.314 100 11 22 1 1976847216 12452640 3378912
19:01:49 52134 8192000000 10899738432 11378921472 1965985328 19.354 100 12 25 1 1986620208 17188720 3446160
19:02:48 78584 8192000000 10892574544 11370086400 1931340384 19.078 98 11 22 1 1948702336 14113120 3248832
19:04:15 26582 8192000000 10905834336 11363086336 1973694928 19.415 100 27 51 2 1989312384 8552224 7065232
19:04:49 24908 8192000000 10898757472 11359449088 1939953664 19.146 98 26 52 2 1957692672 10218416 7520592
19:05:37 28936 8192000000 10896141968 11352846336 1946798656 19.201 99 52 103 0 1979469552 18080256 14590640
19:06:12 70375 8192000000 10870006976 11357548544 1890782736 18.752 97 10 20 1 1918732192 24595328 3354128
19:08:03 70351 8192000000 10893388864 11360276480 1954288624 19.261 100 15 30 1 1972892976 14529552 4074800
19:09:20 127793 8192000000 10896325072 11345829888 1832154272 18.277 93 6 12 0 1848818512 14403792 2260448
19:11:36 33891 8192000000 10882542368 11336982528 1889406928 18.741 96 37 74 1 1914227744 14328656 10492160
19:12:17 68997 8192000000 10880843648 11365404672 1928534576 19.055 99 23 46 1 1953220832 18299184 6387072
19:13:37 71400 8192000000 10929719920 11367182336 1946083328 19.195 99 32 64 2 1972236432 16859488 9293616
19:14:55 89149 8192000000 10897972320 11359866880 1935184640 19.108 98 27 54 1 1957176576 14581408 7410528
19:16:59 63223 8192000000 10877286640 11355320320 1923615344 19.016 98 18 35 3 1942488112 13647008 5225760
19:18:35 46555 8192000000 10862974656 11335938048 1899212368 18.820 97 7 14 0 1915029232 13966752 1850112
19:20:08 93884 8192000000 10859792608 11326869504 1846164112 18.391 95 13 26 0 1865857360 15426208 4267040
19:21:54 65849 8192000000 10855572992 11320029184 1915903632 18.954 99 18 34 1 1933575520 12278912 5392976
19:23:06 67421 8192000000 10849940960 11302064128 1814348288 18.131 94 15 30 1 1825926192 7269840 4308064
19:24:28 32459 8192000000 10869596048 11323777024 1924638592 19.024 100 36 72 0 1944049408 9195952 10214864
19:25:16 42096 8192000000 10858478544 11309797376 1881707232 18.679 97 20 40 1 1898438528 10586064 6145232
19:26:12 57537 8192000000 9264933872 9527844864 415292608 4.824 22 8 16 0 420443664 3057264 2093792

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 02-12-2020 19:28:10 to 02-12-2020 19:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 63 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 02-12-2020 19:28:42 to 02-12-2020 19:28:44.

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          243979
MON$OLDEST_ACTIVE               244311
MON$OLDEST_SNAPSHOT             244311
MON$NEXT_TRANSACTION            244311
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                       2022784
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:253: 
:254: mscs-test-161.budzdorov.ru    Wed Dec  2 19:27:12 2020
:255:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:256: 
:257: 
:258: mscs-test-161.budzdorov.ru    Wed Dec  2 19:27:12 2020
:259:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:260: 
--- end of diff output ---

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

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