Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.12.2020 16: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 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 17043816 kB
MemAvailable 31516264 kB
Buffers 0 kB
Cached 14620808 kB
SwapCached 3724 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-14 16:27:07
DTS_END                         2020-12-14 16:27:07.0640
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/45458
TRN_ID                          257605
ATT_ID                          686
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: 10008.98 20691 1201078
customer order: creation 185.86 304 22303
customer order: refuse 16.27 271 1952
order to supplier: creation 49.43 1056 5932
order to supplier: removal 3.78 79847 454
invoice (draft): creation 49.66 2857 5959
invoice (draft): removal 58.56 589 7027
invoice accept: apply 45.48 15379 5457
invoice accept: cancel 52.02 653 6242
customer reserve: creation 4109.24 156 493109
customer reserve: removal 5118.08 46 614169
realization accept: apply 90.26 171 10831
realization accept: cancel 90.20 94 10824
payment from customer: creation 63.96 114 7675
payment from customer: removal 6.31 70 757
payment to supplier: creation 52.99 144 6359
payment to supplier: removal 3.99 84 479
service: total inventory turnovers 5.51 905 661
service: total monetary turnovers 6.58 31 789
service: aggregate perf. data 0.79 25221 95
service: refresh index statistics 0.03 285832 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-12-2020 16:28:27 to 14-12-2020 16:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4435
TEST_TIME 2 5458
TEST_TIME 3 5268
TEST_TIME 4 5995
TEST_TIME 5 6703
TEST_TIME 6 7194
TEST_TIME 7 7958
TEST_TIME 8 8020
TEST_TIME 9 8366
TEST_TIME 10 8608
TEST_TIME 11 8511
TEST_TIME 12 8311
TEST_TIME 13 8375
TEST_TIME 14 8536
TEST_TIME 15 8713
TEST_TIME 16 9034
TEST_TIME 17 9134
TEST_TIME 18 9840
TEST_TIME 19 10371
TEST_TIME 20 10250
TEST_TIME 21 11223
TEST_TIME 22 11713
TEST_TIME 23 12042
TEST_TIME 24 12140
TEST_TIME 25 12102
TEST_TIME 26 11903
TEST_TIME 27 11724
TEST_TIME 28 11789
TEST_TIME 29 11806
TEST_TIME 30 11717
TEST_TIME 31 11575
TEST_TIME 32 11582
TEST_TIME 33 11685
TEST_TIME 34 11639
TEST_TIME 35 11493
TEST_TIME 36 11656
TEST_TIME 37 11575
TEST_TIME 38 11428
TEST_TIME 39 11232
TEST_TIME 40 11156
TEST_TIME 41 11183
TEST_TIME 42 11061
TEST_TIME 43 11053
TEST_TIME 44 10999
TEST_TIME 45 11008
TEST_TIME 46 10909
TEST_TIME 47 10774
TEST_TIME 48 10674
TEST_TIME 49 10601
TEST_TIME 50 10515
TEST_TIME 51 10535
TEST_TIME 52 10550
TEST_TIME 53 10524
TEST_TIME 54 10426
TEST_TIME 55 10371
TEST_TIME 56 10364
TEST_TIME 57 10689
TEST_TIME 58 10644
TEST_TIME 59 10529
TEST_TIME 60 10538
TEST_TIME 61 10638
TEST_TIME 62 10896
TEST_TIME 63 10848
TEST_TIME 64 10963
TEST_TIME 65 10895
TEST_TIME 66 10778
TEST_TIME 67 10646
TEST_TIME 68 10748
TEST_TIME 69 10675
TEST_TIME 70 10695
TEST_TIME 71 10633
TEST_TIME 72 10593
TEST_TIME 73 10525
TEST_TIME 74 10465
TEST_TIME 75 10386
TEST_TIME 76 10379
TEST_TIME 77 10386
TEST_TIME 78 10359
TEST_TIME 79 10330
TEST_TIME 80 10316
TEST_TIME 81 10277
TEST_TIME 82 10349
TEST_TIME 83 10349
TEST_TIME 84 10325
TEST_TIME 85 10308
TEST_TIME 86 10339
TEST_TIME 87 10410
TEST_TIME 88 10469
TEST_TIME 89 10556
TEST_TIME 90 10544
TEST_TIME 91 10516
TEST_TIME 92 10505
TEST_TIME 93 10435
TEST_TIME 94 10401
TEST_TIME 95 10335
TEST_TIME 96 10315
TEST_TIME 97 10298
TEST_TIME 98 10293
TEST_TIME 99 10245
TEST_TIME 100 10222
TEST_TIME 101 10196
TEST_TIME 102 10142
TEST_TIME 103 10154
TEST_TIME 104 10087
TEST_TIME 105 10072
TEST_TIME 106 10031
TEST_TIME 107 10053
TEST_TIME 108 10061
TEST_TIME 109 10061
TEST_TIME 110 10049
TEST_TIME 111 10087
TEST_TIME 112 10205
TEST_TIME 113 10193
TEST_TIME 114 10186
TEST_TIME 115 10161
TEST_TIME 116 10175
TEST_TIME 117 10208
TEST_TIME 118 10149
TEST_TIME 119 10080
TEST_TIME 120 10013

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-12-2020 16:28:31 to 14-12-2020 16: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 1659717 1659717 0 0.00 0 33551 6 0 0
doc_list_biud 1659717 1659717 0 0.00 0 52260 22 0 0
sp_add_invoice_to_stock 5563 5457 106 1.90 34 145700 15379 0 106
sp_cancel_adding_invoice 6242 6242 0 0.00 4 75105 654 0 0
sp_cancel_client_order 1952 1952 0 0.00 4 13043 271 0 0
sp_cancel_customer_reserve 614169 614169 0 0.00 1 52263 47 0 0
sp_cancel_pay_from_customer 757 757 0 0.00 3 4386 70 0 0
sp_cancel_pay_to_supplier 479 479 0 0.00 3 6559 84 0 0
sp_cancel_supplier_invoice 7030 7027 3 0.04 1 14255 590 0 3
sp_cancel_supplier_order 454 454 0 0.00 5 1006495 79847 0 0
sp_cancel_write_off 10824 10824 0 0.00 1 14462 94 0 0
sp_client_order 22303 22303 0 0.00 3 20659 305 0 0
sp_customer_reserve 493109 493109 0 0.00 0 43599 156 0 0
sp_fill_shopping_cart 34194 34194 0 0.00 1 14594 38 0 0
sp_fill_shopping_cart_clo_res 493093 493093 0 0.00 0 18526 13 0 0
sp_get_clo_for_invoice 5441 5441 0 0.00 0 14636 258 0 0
sp_kill_cost_storno 18302 18302 0 0.00 0 24210 45 0 0
sp_kill_qstorno_ret_qs2qd 1246643 1246643 0 0.00 0 52257 25 0 0
sp_kill_qty_storno 656939 656939 0 0.00 0 52260 55 0 0
sp_lock_selected_doc 22601 22601 0 0.00 0 7451 6 0 0
sp_make_cost_storno 30305 30305 0 0.00 0 25023 60 0 0
sp_multiply_rows_for_pdistr 30305 30305 0 0.00 0 15073 25 0 0
sp_multiply_rows_for_qdistr 22303 22303 0 0.00 0 10834 143 0 0
sp_pay_from_customer 7675 7675 0 0.00 4 19830 114 0 0
sp_pay_to_supplier 6359 6359 0 0.00 5 32980 145 0 0
sp_payment_common 14034 14034 0 0.00 1 19245 39 0 0
sp_qd_handle_on_cancel_clo 1952 1952 0 0.00 0 13035 243 0 0
sp_qd_handle_on_invoice_upd_sts 11682 11682 0 0.00 0 34262 267 0 0
sp_qd_handle_on_reserve_upd_sts 10831 10831 0 0.00 0 37073 54 0 0
sp_reserve_write_off 10831 10831 0 0.00 6 37083 172 0 0
sp_supplier_invoice 5959 5959 0 0.00 6 106277 2858 0 0
sp_supplier_order 5932 5932 0 0.00 5 50219 1056 0 0
srv_aggregate_perf_data 95 95 0 0.00 3058 293322 25222 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 804 220912 36701 0 0
srv_find_qd_qs_mism 1150696 1150696 0 0.00 0 11401 5 0 0
srv_make_invnt_saldo 661 661 0 0.00 35 62751 905 0 0
srv_make_money_saldo 789 789 0 0.00 1 7916 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 227703 311517 285832 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5457 5457 0 0.00 0 42200 174 0 0
t$perf-norm:sp_cancel_adding_invoice 451 451 0 0.00 0 2637 47 0 0
t$perf-norm:sp_cancel_client_order 1952 1952 0 0.00 0 1764 9 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 4204 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 757 757 0 0.00 0 5662 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 479 479 0 0.00 0 619 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 476 476 0 0.00 0 1879 12 0 0
t$perf-norm:sp_cancel_supplier_order 454 454 0 0.00 0 22702 1349 0 0
t$perf-norm:sp_cancel_write_off 1039 1039 0 0.00 0 5973 15 0 0
t$perf-norm:sp_client_order 22303 22303 0 0.00 0 41088 18 0 0
t$perf-norm:sp_customer_reserve 1103 1103 0 0.00 0 3561 9 0 0
t$perf-norm:sp_pay_from_customer 7675 7675 0 0.00 0 5572 9 0 0
t$perf-norm:sp_pay_to_supplier 6359 6359 0 0.00 0 3774 10 0 0
t$perf-norm:sp_reserve_write_off 10831 10831 0 0.00 0 19491 11 0 0
t$perf-norm:sp_supplier_invoice 5960 5960 0 0.00 0 10120 19 0 0
t$perf-norm:sp_supplier_order 5932 5932 0 0.00 0 36624 23 0 0
t$perf-norm:srv_aggregate_perf_data 95 95 0 0.00 0 87 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 68 2 0 0
t$perf-norm:srv_make_invnt_saldo 661 661 0 0.00 0 2527 17 0 0
t$perf-norm:srv_make_money_saldo 789 789 0 0.00 0 1109 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 11092 10880 212 1.91 0 4884 19 0 212
v_all_customers 40684 40684 0 0.00 0 68 1 0 0
v_all_suppliers 33064 33064 0 0.00 0 68 1 0 0
v_all_wares 44606 44606 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 902 902 0 0.00 0 1404 6 0 0
v_cancel_client_order 3904 3904 0 0.00 0 3504 6 0 0
v_cancel_customer_prepayment 1514 1514 0 0.00 0 4337 9 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 2871 6 0 0
v_cancel_payment_to_supplier 958 958 0 0.00 0 4222 10 0 0
v_cancel_supplier_invoice 958 952 6 0.62 0 2979 17 0 6
v_cancel_supplier_order 908 908 0 0.00 0 2760 11 0 0
v_cancel_write_off 2078 2078 0 0.00 0 4514 23 0 0
v_max_id_clo_ord 5932 5932 0 0.00 0 294 1 0 0
v_max_id_clo_res 1103 1103 0 0.00 0 2492 14 0 0
v_max_id_ord_sup 5959 5959 0 0.00 0 6954 5 0 0
v_max_non_paid_invoice 1718 1718 0 0.00 0 2210 4 0 0
v_max_non_paid_realizn 4042 4042 0 0.00 0 3351 5 0 0
v_min_id_clo_ord 5932 5932 0 0.00 0 8068 20 0 0
v_min_id_clo_res 1103 1103 0 0.00 0 1512 7 0 0
v_min_id_ord_sup 5959 5959 0 0.00 0 9314 12 0 0
v_min_non_paid_invoice 6359 6359 0 0.00 0 12716 26 0 0
v_min_non_paid_realizn 7675 7675 0 0.00 0 11223 26 0 0
v_our_firm 11188 11188 0 0.00 0 18 1 0 0
v_reserve_write_off 21662 21662 0 0.00 0 5964 8 0 0
x_lock_depdocs_on_canc_invoice 12793 12793 0 0.00 0 25597 104 0 0
x_lock_depdocs_on_canc_sup_ord 454 454 0 0.00 0 11395 272 0 0
x_make_qstorno_1000_1200 5932 5932 0 0.00 2 50208 973 0 0
x_make_qstorno_1200_2000 5959 5959 0 0.00 2 91678 2731 0 0
x_make_qstorno_2100_3300 493109 493109 0 0.00 0 42054 142 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-12-2020 16:28:35 to 14-12-2020 16: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
13:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:17 8587 8192000000 10192539312 10492035072 871428864 9.614 71 56 115 0 893903936 2394224 20080848
13:57:36 19092 8192000000 10294521872 10611900416 1345234064 14.105 100 80 160 0 1375111776 4085232 25792480
13:58:06 35797 8192000000 10363957072 10681176064 1412009792 14.702 100 89 179 0 1447363808 6285648 29068368
13:58:55 22958 8192000000 10382845808 10707808256 1435953008 14.914 100 85 170 0 1471210192 7382848 27874336
13:59:34 23489 8192000000 10412157408 10737176576 1461824592 15.142 100 90 180 0 1499041920 8517152 28700176
14:00:11 13441 8192000000 10417758016 10746691584 1469447616 15.209 100 87 174 0 1506662608 9035744 28179248
14:00:36 12079 8192000000 10434571488 10766831616 1488949872 15.380 100 89 179 0 1527144896 9912048 28282976
14:00:56 4525 8192000000 10442957680 10779668480 1503913760 15.510 100 87 174 0 1540999408 10106384 26979264
14:01:13 15518 8192000000 10465778896 10809757696 1528750768 15.726 100 79 158 2 1563400272 10314208 24335296
14:01:39 13756 8192000000 10496527296 10849382400 1555914576 15.961 100 71 142 0 1587923104 10496560 21511968
14:02:03 11226 8192000000 10542529328 10890444800 1588521600 16.241 100 83 166 1 1624696160 11051504 25123056
14:02:22 8115 8192000000 10558213600 10916192256 1617139312 16.486 100 76 152 1 1652192192 11456960 23595920
14:02:38 12207 8192000000 10574520880 10937286656 1635394272 16.641 100 77 155 0 1669818848 11493888 22930688
14:02:57 12237 8192000000 10596757760 10964455424 1657860880 16.831 100 82 164 0 1694597088 12225376 24510832
14:03:16 10694 8192000000 10620416752 10991251456 1681349472 17.029 100 78 156 0 1715717696 11992624 22375600
14:03:34 5882 8192000000 10639576592 11011313664 1697654944 17.165 100 78 156 1 1732562848 12626240 22281664
14:03:47 6677 8192000000 10656197168 11029991424 1717527488 17.332 100 84 167 2 1754686944 13226736 23932720
14:04:00 6613 8192000000 10681824768 11053842432 1735740896 17.483 100 85 170 1 1773912576 13797568 24374112
14:04:14 3719 8192000000 10680247008 11056959488 1743024896 17.544 100 85 170 0 1781490720 14196976 24268848
14:04:25 4544 8192000000 10690477408 11065368576 1748265968 17.587 100 80 160 1 1784841600 14263888 22311744
14:04:36 4795 8192000000 10700413152 11076218880 1760079184 17.685 100 85 171 0 1797800640 13949264 23772192
14:04:47 3578 8192000000 10704704432 11082911744 1767311888 17.745 100 85 169 1 1806066752 14631568 24123296
14:04:58 3790 8192000000 10722875248 11098984448 1778389088 17.836 100 90 181 0 1818866960 15189680 25288192
14:05:09 2455 8192000000 10731532992 11109085184 1785545456 17.895 100 83 166 1 1823830464 14717968 23567040
14:05:17 2222 8192000000 10733590176 11113213952 1792948544 17.956 100 87 175 0 1830386976 13760976 23677456
14:05:26 3725 8192000000 10737403552 11117400064 1797425376 17.993 100 86 173 2 1835530880 13793248 24312256
14:05:37 2231 8192000000 10741204192 11128066048 1807242080 18.073 100 79 153 2 1840628256 12342688 21043488
14:05:46 2409 8192000000 10747721152 11136319488 1813433104 18.124 100 74 146 0 1845093728 11401424 20259200
14:05:55 2075 8192000000 10764145632 11146780672 1818948592 18.169 100 90 180 0 1856985728 12883760 25153376
14:06:03 5161 8192000000 10755740640 11144634368 1819789728 18.176 100 80 158 2 1855705792 14260112 21655952
14:06:15 2338 8192000000 10777101072 11163230208 1823985904 18.210 100 85 171 1 1862220672 14133584 24101184
14:06:23 1561 8192000000 10788380400 11175849984 1839960016 18.340 100 97 194 3 1882152688 13751936 28440736
14:06:31 1856 8192000000 10784524432 11171119104 1843778304 18.372 100 85 167 0 1879825104 12162160 23884640
14:06:39 1929 8192000000 10797221312 11183558656 1852924480 18.446 100 92 185 2 1891796240 12452672 26419088
14:06:48 2087 8192000000 10798618816 11191713792 1859317952 18.498 100 90 181 3 1897478720 12989104 25171664
14:06:56 1279 8192000000 10806976032 11197861888 1869888992 18.583 100 93 185 1 1909269408 13508912 25871504
14:07:04 1190 8192000000 10813658080 11199954944 1866483744 18.556 100 92 183 0 1905976288 13654848 25837696
14:07:12 1487 8192000000 10813782848 11202289664 1869180464 18.578 100 90 181 0 1906841184 11819280 25841440
14:07:19 6445 8192000000 10796088176 11205648384 1869632480 18.581 100 63 124 3 1895389968 8998928 16758560
14:07:33 48515 8192000000 10805154592 11209854976 1870581536 18.589 100 42 82 1 1889555888 7397584 11576768
14:08:28 28331 8192000000 10783158320 11208597504 1875874608 18.632 100 46 90 2 1897161648 7194016 14093024
14:09:03 12018 8192000000 10778346128 11210424320 1872294736 18.603 100 18 36 0 1883527440 6614160 4618544
14:09:25 7041 8192000000 10787975792 11217965056 1879601168 18.662 100 33 66 1 1896191296 7065168 9524960
14:09:38 6943 8192000000 10779145216 11218771968 1879745984 18.663 100 19 38 3 1890979424 5871232 5362208
14:09:54 4595 8192000000 10810458496 11230838784 1887107008 18.722 100 22 41 1 1898955488 6036016 5812464
14:10:09 10346 8192000000 10793701024 11231780864 1891142800 18.755 100 21 42 0 1904195152 6833440 6218912
14:10:28 9797 8192000000 10809511424 11238752256 1890426784 18.749 100 19 38 0 1905462464 9827216 5208464
14:10:44 11158 8192000000 10809032272 11240013824 1898605280 18.815 100 28 56 0 1912643264 6253056 7784928
14:11:01 8101 8192000000 10806121744 11238244352 1894848624 18.785 100 19 38 2 1905693552 5459392 5385536
14:11:21 5690 8192000000 10810051008 11240542208 1901315424 18.837 100 27 54 2 1914849168 5711056 7822688
14:11:33 17416 8192000000 10805635232 11246399488 1901319632 18.837 100 16 32 0 1912328896 5936032 5073232
14:11:57 17304 8192000000 10804663040 11246637056 1902902176 18.850 100 15 29 3 1912857440 5224480 4730784
14:12:25 12700 8192000000 10810329040 11249930240 1905875744 18.874 100 11 22 1 1914489664 5642048 2971872
14:12:43 53905 8192000000 10847501120 11268919296 1917033360 18.963 100 46 93 3 1936729504 6527984 13168160
14:13:43 13968 8192000000 10824465904 11262251008 1912225424 18.925 100 12 24 2 1920332384 5317616 2789344
14:14:06 6260 8192000000 10836666528 11270242304 1920827872 18.993 100 42 82 2 1939960352 7947904 11184576
14:14:20 4979 8192000000 10842155104 11272921088 1920235248 18.989 100 42 84 2 1939790752 7368704 12186800
14:14:32 5971 8192000000 10836019200 11269881856 1920528304 18.991 100 25 50 3 1933709472 6461840 6719328
14:14:44 11724 8192000000 10824077584 11269574656 1918537872 18.975 100 12 24 1 1927711760 5916656 3257232
14:15:02 5779 8192000000 10840394624 11275247616 1905910944 18.874 99 23 46 2 1918087520 5833200 6343376
14:15:16 4348 8192000000 10830453888 11273175040 1920201024 18.988 100 28 56 2 1935799216 7882528 7715664
14:15:26 7890 8192000000 10830346896 11270836224 1918431280 18.974 100 24 46 2 1931766432 6217616 7117536
14:15:41 9368 8192000000 10824433568 11249147904 1872356640 18.603 98 20 40 1 1883436816 4829920 6250256
14:15:56 6682 8192000000 10813062864 11251802112 1902024384 18.843 100 25 50 3 1916322576 7283312 7014880
14:16:10 7789 8192000000 10812944176 11247996928 1883273520 18.692 99 30 60 0 1898556016 7160144 8122352
14:16:24 7855 8192000000 10782169280 11215421440 1806333120 18.066 95 21 41 2 1817695776 4905200 6457456
14:16:40 5338 8192000000 10780031024 11216465920 1845978640 18.389 98 20 41 2 1857167040 5364112 5824288
14:16:54 13881 8192000000 10753738832 11183112192 1798308320 18.000 96 10 20 0 1806128640 4907328 2912992
14:17:16 11354 8192000000 10732355136 11150405632 1772727760 17.790 96 20 40 1 1783652160 4804320 6120080
14:17:34 42712 8192000000 10701265216 11128733696 1743518848 17.548 96 23 46 1 1755742176 4310256 7913072
14:18:26 10685 8192000000 10727464896 11154989056 1792936352 17.956 99 40 73 5 1809550224 4912016 11701856
14:18:47 5842 8192000000 10703797680 11113041920 1732375072 17.455 96 35 70 2 1748325584 5858816 10091696
14:19:01 3280 8192000000 10700430864 11110694912 1774385456 17.803 99 39 78 1 1794453984 9353696 10714832
14:19:10 6471 8192000000 10689462352 11099758592 1687053056 17.077 94 27 52 5 1700316928 5802304 7461568
14:19:23 9467 8192000000 10735920864 11146539008 1786434656 17.902 99 33 65 1 1805755936 10661536 8659744
14:19:40 8265 8192000000 10722341392 11132252160 1762737264 17.707 97 26 52 0 1776704432 6632016 7335152
14:19:57 4140 8192000000 10712120880 11128098816 1774060224 17.801 98 30 59 2 1789063344 5253168 9749952
14:20:09 7868 8192000000 10724552880 11144118272 1811200896 18.106 100 29 58 1 1826175088 6620016 8354176
14:20:23 6866 8192000000 10721248496 11139706880 1793295760 17.959 99 35 70 4 1810855328 6951760 10607808
14:20:37 7321 8192000000 10727001536 11151826944 1794415888 17.968 99 21 42 1 1805936048 5464656 6055504
14:20:51 4653 8192000000 10714783296 11134697472 1800832464 18.021 100 26 53 2 1815982288 6372816 8777008
14:21:07 6467 8192000000 10731089136 11152752640 1815517056 18.141 100 25 47 4 1827420816 4927168 6976592
14:21:19 8620 8192000000 10730007728 11146723328 1789111552 17.924 98 15 30 1 1798893616 5418032 4364032
14:21:34 6695 8192000000 10732622560 11152297984 1804198720 18.048 99 16 33 1 1814497584 5778672 4520192
14:21:50 11891 8192000000 10735739664 11164839936 1833593120 18.289 100 32 64 1 1849799776 6556512 9650144
14:22:12 19621 8192000000 10737640720 11170926592 1838936288 18.332 100 22 45 1 1850772208 5337584 6498336
14:22:39 54688 8192000000 10756980784 11188572160 1847171408 18.399 100 25 50 1 1863836592 9232048 7433136
14:23:42 7737 8192000000 10764061168 11195232256 1859353056 18.498 100 29 58 2 1873557648 6139712 8064880
14:23:57 8337 8192000000 10770560288 11194945536 1855265584 18.465 100 23 45 0 1867263040 5743952 6253504
14:24:14 4733 8192000000 10769800736 11197583360 1861042480 18.512 100 36 73 4 1882437344 11333904 10060960
14:24:28 4242 8192000000 10789990080 11207086080 1865803248 18.550 100 40 80 3 1888837152 11620368 11413536
14:24:39 6547 8192000000 10781792400 11201974272 1861508704 18.516 100 23 44 1 1873276688 5711184 6056800
14:24:51 8566 8192000000 10773522672 11204063232 1864545600 18.540 100 24 47 2 1878427680 6317728 7564352
14:25:06 7051 8192000000 10787968928 11206340608 1862181392 18.521 100 20 38 1 1872964112 5233680 5549040
14:25:19 13707 8192000000 10776106256 11208708096 1864111792 18.537 100 16 32 1 1873829824 5205600 4512432
14:25:41 7188 8192000000 10775683776 11208937472 1868020016 18.568 100 14 28 1 1877291040 5268720 4002304
14:25:55 12054 8192000000 10778962048 11216723968 1871895824 18.600 100 19 36 0 1882924432 5697648 5330960
14:26:17 11695 8192000000 10786587760 11216592896 1872172432 18.602 100 12 24 0 1881161440 5756192 3232816
14:26:35 8550 8192000000 10790993184 11219943424 1875522688 18.629 100 11 22 1 1884222080 5232192 3467200
14:26:50 5767 8192000000 10788640944 11220500480 1876307568 18.635 100 26 52 3 1889965936 6080624 7577744
14:27:02 18492 8192000000 10795609984 11213746176 1871788176 18.599 99 30 60 1 1885358624 5362544 8207904
14:27:36 23102 8192000000 10826095008 11242995712 1900650704 18.832 100 41 80 2 1919071120 7161152 11259264
14:28:14 112376 8192000000 10817242656 11256713216 1898384768 18.813 99 32 64 1 1919092480 11195552 9512160
14:30:15 78873 8192000000 10856604128 11297411072 1922559904 19.007 100 29 57 1 1946159488 15758992 7840592
14:31:49 18126 8192000000 10886338112 11307032576 1929965376 19.067 99 41 82 1 1954751184 12831152 11954656
14:32:15 6200 8192000000 10895402752 11319255040 1958660512 19.295 100 62 123 1 1992835776 15600752 18574512
14:32:30 22456 8192000000 10890549856 11321769984 1937659280 19.128 99 48 93 2 1968167920 17164720 13343920
14:33:00 7009 8192000000 10902703680 11325857792 1956006816 19.274 100 57 112 1 1988690368 15967584 16715968
14:33:16 3369 8192000000 10910029024 11334893568 1963355344 19.333 100 67 133 3 2001082736 17745248 19982144
14:33:27 6751 8192000000 10916534880 11342778368 1969070240 19.378 100 52 104 1 2001959744 18121024 14768480
14:33:41 3676 8192000000 10911547120 11333308416 1951494128 19.238 99 71 141 3 1989813840 18705184 19614528
14:33:55 2591 8192000000 10910789856 11328475136 1953802688 19.257 100 68 136 1 1995048736 21301840 19944208
14:34:05 1988 8192000000 10924477744 11332362240 1961955488 19.322 100 66 132 0 1996933328 16454304 18523536
14:34:13 7256 8192000000 10919686928 11341746176 1970082592 19.386 100 64 125 1 2006136128 18576240 17477296
14:34:28 10034 8192000000 10918181776 11345653760 1976172080 19.434 100 54 107 0 2011736688 20785888 14778720
14:34:48 23938 8192000000 10915092176 11346833408 1963882784 19.337 99 56 112 0 1995984464 16013136 16088544
14:35:20 4585 8192000000 10916194816 11342553088 1960079424 19.307 99 65 128 0 1996687360 17632672 18975264
14:35:33 1413 8192000000 10947693280 11357261824 1983323008 19.491 100 91 183 2 2027930320 17535072 27072240
14:35:41 1920 8192000000 10931324288 11341856768 1946991264 19.203 98 85 170 4 1991564784 20541728 24031792
14:35:54 12662 8192000000 10934072832 11354251264 1976204752 19.435 100 73 146 0 2019659392 21793904 21660736
14:36:17 8878 8192000000 10886753504 11310170112 1930163328 19.068 98 57 113 1 1968540576 22198800 16178448
14:36:33 3207 8192000000 10933546976 11355676672 1974075104 19.418 100 69 136 1 2017821200 22660112 21085984
14:36:44 4925 8192000000 10893085856 11317645312 1932773616 19.089 98 73 146 1 1978960768 24354576 21832576
14:36:57 4293 8192000000 10910002416 11336179712 1954153488 19.260 100 55 106 1 1995241584 24997056 16091040
14:37:10 3561 8192000000 10925926992 11348557824 1965533632 19.350 100 68 136 1 2012266352 25647408 21085312
14:37:20 3579 8192000000 10907109424 11324026880 1948759184 19.217 100 69 136 0 1995464208 26496272 20208752
14:37:31 5020 8192000000 10911160688 11333271552 1952858048 19.249 100 68 135 1 2000631328 27670848 20102432
14:37:47 7429 8192000000 10894726288 11313020928 1923753696 19.017 99 63 122 2 1968855024 27061616 18039712
14:38:03 4691 8192000000 10883841216 11301523456 1918568352 18.975 99 60 120 0 1964244240 28203392 17472496
14:38:15 19397 8192000000 10888417840 11310182400 1906662336 18.880 98 57 114 0 1954118768 30102352 17354080
14:38:42 6543 8192000000 10890353488 11327037440 1943397488 19.174 100 40 80 0 1985817408 29252240 13167680
14:38:58 6034 8192000000 10888236160 11322667008 1925881680 19.034 99 39 78 2 1966413840 28019232 12512928
14:39:12 7658 8192000000 10899075792 11323846656 1928023040 19.051 99 55 109 4 1973299264 28558960 16717264
14:39:26 3874 8192000000 10877444976 11305185280 1910247312 18.909 99 50 100 1 1955054448 29023680 15783456
14:39:39 3188 8192000000 10898415792 11319521280 1938745968 19.137 100 62 125 0 1992645776 34873424 19026384
14:39:51 4250 8192000000 10902925072 11313217536 1929254240 19.061 100 73 147 0 1983041552 31843776 21943536
14:40:01 2143 8192000000 10909567920 11319443456 1936476480 19.119 100 72 144 3 1991033792 32570288 21987024
14:40:11 2502 8192000000 10919183184 11327913984 1948289200 19.213 100 72 143 1 2002658960 32703920 21665840
14:40:21 4373 8192000000 10907225936 11322048512 1916718640 18.961 98 73 146 2 1973254448 32946096 23589712
14:40:33 5502 8192000000 10919983584 11329306624 1947856112 19.209 100 75 148 0 2004388400 33786352 22745936
14:40:47 9214 8192000000 10918654864 11336613888 1936811808 19.121 99 70 141 0 1994173376 35907072 21454496
14:41:05 2943 8192000000 10923142832 11342544896 1939038048 19.139 99 59 116 1 1993583296 35756592 18788656
14:41:15 801 8192000000 10937767552 11340763136 1953655520 19.256 100 82 162 0 2015811600 36729024 25427056
14:41:23 6524 8192000000 10913925536 11323891712 1913027264 18.931 98 78 156 3 1976481600 38745856 24708480
14:41:37 5183 8192000000 10906939456 11315884032 1929208272 19.061 99 70 140 0 1988869616 37911424 21749920
14:41:49 2077 8192000000 10929361568 11341889536 1946221744 19.196 100 84 168 2 2013197760 39787072 27188944
14:41:59 1789 8192000000 10922900704 11328909312 1935884752 19.114 100 88 171 0 2003577120 40541248 27151120
14:42:08 4824 8192000000 10908970912 11314278400 1920384464 18.990 100 81 160 5 1987360096 41714608 25261024
14:42:20 2145 8192000000 10928412688 11328008192 1936196192 19.116 100 86 174 0 2006681136 43597056 26887888
14:42:29 2498 8192000000 10925850672 11336577024 1941228432 19.157 100 74 147 0 2007076528 43076880 22771216
14:42:40 4234 8192000000 10925882512 11346141184 1942972560 19.170 100 56 112 2 2002987392 42274352 17740480
14:42:51 3931 8192000000 10928860144 11347648512 1937368752 19.126 99 70 138 1 2003636016 43550144 22717120
14:43:05 6541 8192000000 10911259424 11344125952 1930734448 19.073 99 53 106 0 1991570256 43538512 17297296
14:43:28 10576 8192000000 10931074992 11358683136 1939962640 19.146 99 51 102 1 2001926480 44807568 17156272
14:43:47 9992 8192000000 10910724768 11343876096 1910197744 18.908 98 45 90 1 1973206112 47640272 15368096
14:44:04 6442 8192000000 10912496368 11339186176 1927715632 19.049 99 56 111 4 1989963248 44866000 17381616
14:44:31 9371 8192000000 10920329952 11346731008 1936167056 19.116 100 49 96 1 2005550864 52594496 16789312
14:44:47 13519 8192000000 10902542592 11332096000 1916174672 18.956 99 41 82 1 1981381184 51113328 14093184
14:45:13 27512 8192000000 10907120240 11354218496 1920950592 18.994 99 33 66 2 1983606496 50959952 11695952
14:45:47 15359 8192000000 10883213120 11325747200 1891308080 18.756 98 29 58 2 1946998528 44750624 10939824
14:46:09 29848 8192000000 10871139568 11313905664 1900188736 18.828 99 27 54 0 1951788048 42043200 9556112
14:46:46 15181 8192000000 10880329728 11330531328 1921186240 18.996 100 23 46 1 1971655904 42536512 7933152
14:47:07 22434 8192000000 10888293280 11339198464 1922423904 19.006 100 25 50 2 1974060384 42946992 8689488
14:47:37 10431 8192000000 10921831216 11357392896 1930626928 19.072 100 44 88 1 1994991104 48631392 15732784
14:47:55 14428 8192000000 10905824928 11356860416 1931103152 19.076 100 32 64 2 1996333696 53637520 11593024
14:48:18 31178 8192000000 10882629008 11348299776 1932324224 19.085 100 19 38 0 1983489696 44298912 6866560
14:49:01 35604 8192000000 10864385200 11338240000 1887745712 18.728 98 17 34 1 1933794432 39868112 6180608
14:49:42 28488 8192000000 10865688352 11328126976 1902990192 18.850 99 20 40 3 1940391056 31070176 6330688
14:50:27 48695 8192000000 10857439456 11318763520 1926066768 19.035 100 19 38 2 1953700144 21559952 6073424
14:51:22 74301 8192000000 10860069120 11323064320 1908894688 18.898 99 10 21 0 1928783904 17109168 2780048
14:52:43 45235 8192000000 10874317040 11324522496 1921860272 19.002 99 15 30 1 1937014400 11113840 4040288
14:53:35 37970 8192000000 10893617504 11328851968 1924441600 19.022 99 33 66 2 1941611328 8207664 8962064
14:54:23 31074 8192000000 10873933920 11335725056 1943067472 19.171 100 34 68 1 1964139760 11919152 9153136
14:55:27 220912 8192000000 10911572864 11373539328 1939711392 19.144 99 12 25 0 1958872672 16021664 3139616
14:59:15 76971 8192000000 10901757376 11371286528 1942132880 19.164 98 11 22 0 1962868160 18005824 2729456
15:00:39 142001 8192000000 10927754704 11392307200 1958095312 19.291 98 21 42 2 1974407744 10550576 5761856
15:03:09 89044 8192000000 10932914240 11402129408 1998170912 19.608 100 16 32 0 2015262976 12266544 4825520
15:05:01 133415 8192000000 10952674704 11410042880 2013046672 19.725 100 39 78 0 2037814928 13125280 11642976
15:07:21 25414 8192000000 10977010800 11430735872 2020348000 19.783 100 48 96 2 2044726752 10566880 13811872
15:07:59 55807 8192000000 10949043216 11419299840 1963975616 19.338 97 44 88 1 1991331200 14858304 12497280
15:09:01 25331 8192000000 10943368064 11419131904 2007884672 19.685 100 25 49 3 2030080992 14706336 7489984
15:09:36 14122 8192000000 10940394720 11423608832 2011846816 19.716 100 18 36 1 2034280672 17671088 4762768
15:09:58 8841 8192000000 10944995520 11414769664 2015391088 19.744 100 24 48 0 2032939520 9932384 7616048
15:10:13 9106 8192000000 10945401616 11412893696 2016517056 19.753 100 35 70 1 2036941728 10952640 9472032
15:10:29 30441 8192000000 10937400160 11412193280 2012878656 19.724 100 11 23 2 2022813008 6880272 3054080
15:11:08 28940 8192000000 10967840544 11418169344 2011946400 19.717 100 28 56 1 2026893776 7023680 7923696
15:11:43 60980 8192000000 10890105440 11371970560 1860117664 18.504 92 29 59 1 1878931216 9951472 8862080
15:12:51 42427 8192000000 10907447760 11378724864 1960107872 19.307 99 7 14 0 1971418288 9469712 1840704
15:13:39 21705 8192000000 10907388816 11380424704 1978396784 19.452 100 8 16 0 1990582128 10232960 1952384
15:14:07 55741 8192000000 10873410432 11344023552 1881943216 18.681 95 9 18 0 1890874480 6482288 2448976
15:15:09 39240 8192000000 10869169632 11334078464 1907548080 18.887 97 14 28 1 1924074576 11763856 4762640
15:16:00 60094 8192000000 10891668832 11359854592 1905940512 18.874 97 21 41 2 1924567408 12089456 6537440
15:17:21 99519 8192000000 10886471280 11369263104 1950099392 19.227 99 22 44 0 1969049216 12155408 6794416
15:19:22 81075 8192000000 10858916800 11340926976 1906932992 18.882 97 12 24 1 1925231632 15068368 3230272
15:20:50 31216 8192000000 10882403504 11353612288 1922844624 19.010 98 22 44 3 1937098832 7226528 7027680
15:21:40 41234 8192000000 10870937408 11340070912 1896753440 18.800 97 19 38 1 1919932672 17408752 5770480
15:22:29 44065 8192000000 10871472816 11338399744 1859499440 18.499 95 21 42 2 1886310000 20234208 6576352
15:23:36 58836 8192000000 10837838704 11321061376 1806046272 18.063 93 19 38 2 1838424128 26265200 6112656
15:24:44 45284 8192000000 10845526016 11295924224 1860333456 18.506 97 15 30 1 1884114352 19516976 4263920
15:25:36 46258 8192000000 10866131744 11307270144 1839559472 18.337 96 31 62 2 1860376512 11969312 8847728
15:26:32 30230 8192000000 10872790064 11313590272 1886319488 18.716 98 51 102 1 1917898480 17270448 14308544
15:27:20 64472 8192000000 10905542896 11368660992 1917760320 18.969 99 18 36 0 1949517424 26015584 5741520
15:28:30 56782 8192000000 10862866640 11333140480 1887991440 18.730 97 14 28 2 1921298336 28926432 4380464
15:29:53 49262 8192000000 10880631424 11344826368 1910306528 18.909 98 14 27 1 1925191088 10899984 3984576
15:31:06 79817 8192000000 10889131312 11358703616 1919262640 18.981 98 14 28 1 1936570352 13694016 3613696
15:32:43 47149 8192000000 10866752528 11317260288 1869761824 18.582 96 42 84 3 1892467552 10632368 12073360
15:33:36 89712 8192000000 10865889328 11331256320 1924474384 19.023 100 40 80 3 1950290048 14292736 11522928
15:35:27 75597 8192000000 10871884224 11335090176 1915596048 18.952 98 34 68 2 1938520880 13387680 9537152
15:36:49 29221 8192000000 10880798032 11339104256 1914396640 18.942 98 41 82 1 1938918528 12730848 11791040
15:37:25 22878 8192000000 10878941760 11344830464 1949465264 19.222 100 56 112 1 1976541376 10669312 16406800
15:38:05 55372 8192000000 10876023040 11351097344 1937133344 19.124 99 11 22 0 1949341328 9340480 2867504
15:39:07 22787 8192000000 10878653072 11343974400 1915349328 18.950 98 22 44 0 1932133216 10806080 5977808
15:39:42 42435 8192000000 10875919040 11347468288 1936196528 19.116 99 23 46 0 1953668016 11216320 6255168
15:40:47 56283 8192000000 10855360464 11332284416 1916319616 18.957 98 20 40 2 1932199568 10317616 5562336
15:41:49 57197 8192000000 10881943072 11356876800 1953107120 19.251 100 14 28 1 1970627872 12935616 4585136
15:42:53 30198 8192000000 10877727792 11365957632 1957325616 19.285 100 10 20 1 1970977184 10813664 2837904
15:43:50 62678 8192000000 10888548768 11360890880 1944225536 19.180 99 17 34 1 1959979808 11217968 4536304
15:44:59 56120 8192000000 10879526528 11357732864 1945685584 19.192 99 18 36 0 1958612576 8103264 4823728
15:46:05 66776 8192000000 10885065232 11362230272 1943125904 19.172 99 6 12 0 1954017424 9380032 1511488
15:47:25 42237 8192000000 10889899728 11375681536 1968767584 19.376 100 17 34 0 1986993312 13935504 4290224
15:48:24 62805 8192000000 10912438880 11387473920 1962319296 19.324 99 18 36 1 1979422992 11747392 5356304
15:50:41 35945 8192000000 10912655696 11382427648 1952545648 19.247 98 25 50 1 1968005088 7671328 7788112
15:51:25 31214 8192000000 10911614432 11387584512 1984434976 19.500 100 30 60 1 2005227424 11819968 8972480
15:52:11 28980 8192000000 10931914000 11399639040 1996179440 19.593 100 34 68 2 2017033920 11197104 9657376
15:52:51 38242 8192000000 10942413472 11401338880 1977455856 19.445 99 23 45 2 1997206976 13105872 6645248
15:54:19 111448 8192000000 10927663472 11405918208 1949804960 19.225 98 15 30 0 1976329824 21789360 4735504
15:56:20 83586 8192000000 10933450048 11408605184 1971575728 19.398 99 6 12 1 1990234416 17210768 1447920
15:58:19 33171 8192000000 10904547536 11362713600 1891375648 18.757 95 14 28 2 1901065616 6022144 3667824
15:58:59 75755 8192000000 10890490160 11371155456 1916368848 18.958 97 21 42 2 1933280048 11383648 5527552
16:00:37 87487 8192000000 10887834032 11367383040 1904140880 18.860 96 9 17 0 1913767344 7403968 2222496
16:02:17 31751 8192000000 10901737824 11361959936 1943100992 19.171 99 21 43 2 1959490912 9916608 6473312
16:03:03 79640 8192000000 10888892496 11374305280 1968980320 19.377 100 20 40 2 1987544752 12824816 5739616
16:04:29 61480 8192000000 10872210816 11355283456 1910340000 18.909 97 14 28 0 1927344176 12939088 4065088
16:05:39 85049 8192000000 10895907488 11378204672 1952134736 19.243 99 19 37 1 1966731024 9722528 4873760
16:07:18 51150 8192000000 10902339936 11387682816 1977813536 19.447 100 14 28 0 1996787216 14384208 4589472
16:08:16 75171 8192000000 10870172112 11339403264 1877539936 18.645 95 16 32 0 1888433808 6189136 4704736
16:09:45 77942 8192000000 10874813408 11363475456 1942643968 19.168 99 11 21 1 1960292128 14336144 3312016
16:11:15 66130 8192000000 10851074720 11343433728 1897028272 18.802 97 15 30 0 1911936000 10738800 4168928
16:12:36 51029 8192000000 10859544656 11330150400 1892402128 18.765 97 18 36 0 1905400016 8413824 4584064
16:13:43 35246 8192000000 10827436128 11296595968 1852242560 18.440 96 40 78 1 1873759696 10650544 10866592
16:14:25 60301 8192000000 10840432368 11301511168 1840156528 18.342 95 35 70 1 1861808560 12095984 9556048
16:15:38 54026 8192000000 10875097744 11344388096 1935635360 19.112 100 34 68 2 1960347056 15039872 9671824
16:16:44 33200 8192000000 10884864224 11348074496 1902977648 18.850 98 30 60 0 1927166768 15273744 8915376
16:17:24 60475 8192000000 10881045376 11353870336 1933838400 19.098 99 29 58 2 1963855440 21466512 8550528
16:18:45 75669 8192000000 10839901952 11311951872 1859858192 18.502 96 7 14 0 1885716832 24124064 1734576
16:20:10 59598 8192000000 10858854640 11321970688 1878149264 18.650 97 22 44 1 1897956992 13682640 6125088
16:21:21 67181 8192000000 10842735008 11302645760 1852836432 18.445 96 28 56 0 1871196544 10317568 8042544
16:22:36 16877 8192000000 10863602112 11310755840 1891160240 18.755 98 48 95 1 1912807200 8892784 12754176
16:22:59 64226 8192000000 10836279248 11313385472 1861271344 18.514 97 27 54 0 1882007344 13406320 7329680
16:24:12 82589 8192000000 10843724704 11312009216 1888516912 18.734 98 7 14 2 1901505312 11398832 1589568
16:25:47 90709 8192000000 9139727200 9374695424 302682784 3.563 16 5 10 0 307815392 3878384 1254224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-12-2020 16:28:41 to 14-12-2020 16:29:12.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-12-2020 16:29:13 to 14-12-2020 16:29:15.

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          258587
MON$OLDEST_ACTIVE               258984
MON$OLDEST_SNAPSHOT             258984
MON$NEXT_TRANSACTION            258984
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                       2072160
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.33400 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33400 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33400 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33400 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 ---
--- end of diff output ---

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

14.12.20 16:29:16. 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-14 16:29:18 No severe PSQL-related problems occured
14.12.20 16:29:19. End of report.