Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.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 17228740 kB
MemAvailable 31506912 kB
Buffers 0 kB
Cached 14489668 kB
SwapCached 3700 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-23 16:27:05
DTS_END                         2020-12-23 16:27:05.8630
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/48846
TRN_ID                          249998
ATT_ID                          727
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: 9816.66 21292 1177999
customer order: creation 181.25 345 21750
customer order: refuse 15.48 308 1858
order to supplier: creation 49.18 1115 5902
order to supplier: removal 3.75 74265 450
invoice (draft): creation 47.24 2830 5669
invoice (draft): removal 57.83 597 6940
invoice accept: apply 43.18 15906 5181
invoice accept: cancel 52.35 620 6282
customer reserve: creation 3953.76 159 474451
customer reserve: removal 5105.37 43 612644
realization accept: apply 87.21 152 10465
realization accept: cancel 85.88 91 10306
payment from customer: creation 60.06 124 7207
payment from customer: removal 6.03 88 723
payment to supplier: creation 51.66 137 6199
payment to supplier: removal 3.69 67 443
service: total inventory turnovers 5.01 1101 601
service: total monetary turnovers 6.86 19 823
service: aggregate perf. data 0.84 21295 101
service: refresh index statistics 0.03 306580 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-12-2020 16:29:03 to 23-12-2020 16:29:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6447
TEST_TIME 2 7365
TEST_TIME 3 6574
TEST_TIME 4 6361
TEST_TIME 5 6364
TEST_TIME 6 7059
TEST_TIME 7 7700
TEST_TIME 8 7539
TEST_TIME 9 8207
TEST_TIME 10 8146
TEST_TIME 11 8178
TEST_TIME 12 8440
TEST_TIME 13 8689
TEST_TIME 14 8872
TEST_TIME 15 9344
TEST_TIME 16 9817
TEST_TIME 17 10002
TEST_TIME 18 10156
TEST_TIME 19 11055
TEST_TIME 20 11027
TEST_TIME 21 11825
TEST_TIME 22 11538
TEST_TIME 23 11678
TEST_TIME 24 11733
TEST_TIME 25 12101
TEST_TIME 26 11785
TEST_TIME 27 12126
TEST_TIME 28 11854
TEST_TIME 29 11726
TEST_TIME 30 11610
TEST_TIME 31 11775
TEST_TIME 32 11711
TEST_TIME 33 11591
TEST_TIME 34 11556
TEST_TIME 35 11548
TEST_TIME 36 11696
TEST_TIME 37 11451
TEST_TIME 38 11191
TEST_TIME 39 11031
TEST_TIME 40 10902
TEST_TIME 41 10877
TEST_TIME 42 10824
TEST_TIME 43 10747
TEST_TIME 44 10709
TEST_TIME 45 10625
TEST_TIME 46 10536
TEST_TIME 47 10417
TEST_TIME 48 10428
TEST_TIME 49 10298
TEST_TIME 50 10220
TEST_TIME 51 10296
TEST_TIME 52 10272
TEST_TIME 53 10211
TEST_TIME 54 10192
TEST_TIME 55 10080
TEST_TIME 56 9994
TEST_TIME 57 9896
TEST_TIME 58 9934
TEST_TIME 59 9986
TEST_TIME 60 10038
TEST_TIME 61 10031
TEST_TIME 62 10166
TEST_TIME 63 10120
TEST_TIME 64 10228
TEST_TIME 65 10216
TEST_TIME 66 10170
TEST_TIME 67 10250
TEST_TIME 68 10260
TEST_TIME 69 10307
TEST_TIME 70 10332
TEST_TIME 71 10288
TEST_TIME 72 10183
TEST_TIME 73 10132
TEST_TIME 74 10128
TEST_TIME 75 10100
TEST_TIME 76 10067
TEST_TIME 77 10064
TEST_TIME 78 10033
TEST_TIME 79 9974
TEST_TIME 80 10001
TEST_TIME 81 10037
TEST_TIME 82 10064
TEST_TIME 83 10005
TEST_TIME 84 10046
TEST_TIME 85 10027
TEST_TIME 86 10048
TEST_TIME 87 10181
TEST_TIME 88 10151
TEST_TIME 89 10103
TEST_TIME 90 10260
TEST_TIME 91 10256
TEST_TIME 92 10238
TEST_TIME 93 10250
TEST_TIME 94 10156
TEST_TIME 95 10121
TEST_TIME 96 10075
TEST_TIME 97 10080
TEST_TIME 98 10064
TEST_TIME 99 10052
TEST_TIME 100 10001
TEST_TIME 101 9996
TEST_TIME 102 9983
TEST_TIME 103 10000
TEST_TIME 104 9986
TEST_TIME 105 10003
TEST_TIME 106 10032
TEST_TIME 107 10015
TEST_TIME 108 10022
TEST_TIME 109 10031
TEST_TIME 110 10035
TEST_TIME 111 10074
TEST_TIME 112 10074
TEST_TIME 113 10115
TEST_TIME 114 10061
TEST_TIME 115 9994
TEST_TIME 116 9994
TEST_TIME 117 9948
TEST_TIME 118 9928
TEST_TIME 119 9900
TEST_TIME 120 9819

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-12-2020 16:29:07 to 23-12-2020 16:29:10.

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 1618445 1618445 0 0.00 0 22948 5 0 0
doc_list_biud 1618445 1618445 0 0.00 0 73177 21 0 0
sp_add_invoice_to_stock 5313 5181 132 2.48 43 159003 15907 0 132
sp_cancel_adding_invoice 6282 6282 0 0.00 4 49939 621 0 0
sp_cancel_client_order 1858 1858 0 0.00 4 12971 309 0 0
sp_cancel_customer_reserve 612644 612644 0 0.00 1 36608 43 0 0
sp_cancel_pay_from_customer 723 723 0 0.00 2 7573 88 0 0
sp_cancel_pay_to_supplier 443 443 0 0.00 2 6192 67 0 0
sp_cancel_supplier_invoice 6953 6940 13 0.18 2 73246 598 0 13
sp_cancel_supplier_order 450 450 0 0.00 5 819400 74266 0 0
sp_cancel_write_off 10306 10306 0 0.00 1 22733 91 0 0
sp_client_order 21750 21750 0 0.00 3 30439 345 0 0
sp_customer_reserve 474451 474451 0 0.00 0 115030 160 0 0
sp_fill_shopping_cart 33320 33320 0 0.00 1 8465 33 0 0
sp_fill_shopping_cart_clo_res 474449 474449 0 0.00 0 14945 12 0 0
sp_get_clo_for_invoice 5179 5179 0 0.00 0 16746 236 0 0
sp_kill_cost_storno 17754 17754 0 0.00 0 6964 43 0 0
sp_kill_qstorno_ret_qs2qd 1242984 1242984 0 0.00 0 73176 23 0 0
sp_kill_qty_storno 654124 654124 0 0.00 0 73177 51 0 0
sp_lock_selected_doc 21707 21707 0 0.00 0 7925 5 0 0
sp_make_cost_storno 29050 29050 0 0.00 0 14229 43 0 0
sp_multiply_rows_for_pdistr 29050 29050 0 0.00 0 11174 30 0 0
sp_multiply_rows_for_qdistr 21750 21750 0 0.00 0 9377 131 0 0
sp_pay_from_customer 7207 7207 0 0.00 4 28817 125 0 0
sp_pay_to_supplier 6199 6199 0 0.00 5 28332 138 0 0
sp_payment_common 13406 13406 0 0.00 1 10574 27 0 0
sp_qd_handle_on_cancel_clo 1858 1858 0 0.00 0 12963 276 0 0
sp_qd_handle_on_invoice_upd_sts 11461 11461 0 0.00 0 26528 257 0 0
sp_qd_handle_on_reserve_upd_sts 10465 10465 0 0.00 0 17115 49 0 0
sp_reserve_write_off 10465 10465 0 0.00 6 17542 153 0 0
sp_supplier_invoice 5669 5669 0 0.00 6 80267 2830 0 0
sp_supplier_order 5902 5902 0 0.00 5 29982 1116 0 0
srv_aggregate_perf_data 101 101 0 0.00 2333 412390 21296 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1420 194708 35995 0 0
srv_find_qd_qs_mism 1129000 1129000 0 0.00 0 22948 5 0 0
srv_make_invnt_saldo 601 601 0 0.00 29 73722 1102 0 0
srv_make_money_saldo 823 823 0 0.00 1 280 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 188418 537626 306581 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5181 5181 0 0.00 0 10445 156 0 0
t$perf-norm:sp_cancel_adding_invoice 433 433 0 0.00 0 4124 75 0 0
t$perf-norm:sp_cancel_client_order 1858 1858 0 0.00 0 7256 13 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 507 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 723 723 0 0.00 0 3621 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 443 443 0 0.00 0 1076 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 1138 14 0 0
t$perf-norm:sp_cancel_supplier_order 450 450 0 0.00 0 33542 1380 0 0
t$perf-norm:sp_cancel_write_off 1042 1042 0 0.00 0 5359 16 0 0
t$perf-norm:sp_client_order 21750 21750 0 0.00 0 8576 16 0 0
t$perf-norm:sp_customer_reserve 1027 1027 0 0.00 0 1028 4 0 0
t$perf-norm:sp_pay_from_customer 7207 7207 0 0.00 0 7759 11 0 0
t$perf-norm:sp_pay_to_supplier 6199 6199 0 0.00 0 5170 10 0 0
t$perf-norm:sp_reserve_write_off 10465 10465 0 0.00 0 8124 11 0 0
t$perf-norm:sp_supplier_invoice 5669 5669 0 0.00 0 6475 18 0 0
t$perf-norm:sp_supplier_order 5902 5902 0 0.00 0 4664 15 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 310 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 383 5 0 0
t$perf-norm:srv_make_invnt_saldo 601 601 0 0.00 0 775 15 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 7436 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10616 10352 264 2.48 0 7335 17 0 264
v_all_customers 38984 38984 0 0.00 0 25 1 0 0
v_all_suppliers 32220 32220 0 0.00 0 15 1 0 0
v_all_wares 43500 43500 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 866 866 0 0.00 0 2368 11 0 0
v_cancel_client_order 3716 3716 0 0.00 0 4280 8 0 0
v_cancel_customer_prepayment 1446 1446 0 0.00 0 3110 9 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 1203 4 0 0
v_cancel_payment_to_supplier 886 886 0 0.00 0 6186 10 0 0
v_cancel_supplier_invoice 880 854 26 2.95 0 1033 14 0 26
v_cancel_supplier_order 900 900 0 0.00 0 3301 10 0 0
v_cancel_write_off 2084 2084 0 0.00 0 4593 17 0 0
v_max_id_clo_ord 5902 5902 0 0.00 0 462 1 0 0
v_max_id_clo_res 1027 1027 0 0.00 0 3619 14 0 0
v_max_id_ord_sup 5668 5668 0 0.00 0 3288 3 0 0
v_max_non_paid_invoice 1659 1659 0 0.00 0 67 2 0 0
v_max_non_paid_realizn 3935 3935 0 0.00 0 2600 5 0 0
v_min_id_clo_ord 5902 5902 0 0.00 0 2571 5 0 0
v_min_id_clo_res 1027 1027 0 0.00 0 3182 8 0 0
v_min_id_ord_sup 5668 5668 0 0.00 0 5057 7 0 0
v_min_non_paid_invoice 6199 6199 0 0.00 0 10568 19 0 0
v_min_non_paid_realizn 7207 7207 0 0.00 0 6220 19 0 0
v_our_firm 11060 11060 0 0.00 0 23 1 0 0
v_reserve_write_off 20930 20930 0 0.00 0 4354 6 0 0
x_lock_depdocs_on_canc_invoice 12795 12795 0 0.00 0 21645 105 0 0
x_lock_depdocs_on_canc_sup_ord 450 450 0 0.00 0 2955 219 0 0
x_make_qstorno_1000_1200 5902 5902 0 0.00 2 29978 1048 0 0
x_make_qstorno_1200_2000 5669 5669 0 0.00 3 80240 2712 0 0
x_make_qstorno_2100_3300 474451 474451 0 0.00 0 114949 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-12-2020 16:29:11 to 23-12-2020 16:29:15.

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:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:16 17439 8192000000 10261497824 10574417920 979796432 10.682 76 54 109 0 1000306320 2546064 17963824
13:57:43 38065 8192000000 10380882176 10703183872 1417289344 14.749 100 80 159 0 1447347840 4892400 25166096
13:58:34 27463 8192000000 10422981552 10751627264 1469178864 15.207 100 89 178 0 1504953312 7158176 28616272
13:59:10 10590 8192000000 10433588048 10764398592 1490395216 15.392 100 92 184 1 1528670288 8266832 30008240
13:59:34 23606 8192000000 10448277744 10782887936 1504443808 15.515 100 87 174 1 1541345888 8894992 28007088
14:00:10 23458 8192000000 10459660496 10798751744 1515525312 15.611 100 91 182 0 1554276992 9607808 29143872
14:00:41 19737 8192000000 10472950816 10816507904 1529657040 15.734 100 89 178 1 1567715744 10053792 28004912
14:01:11 11316 8192000000 10499774832 10844127232 1543741760 15.856 100 81 162 0 1579693312 10373568 25577984
14:01:32 17831 8192000000 10519462544 10870808576 1577922016 16.150 100 78 156 2 1612632496 10837504 23872976
14:01:57 18468 8192000000 10539875952 10895167488 1600762400 16.346 100 83 166 0 1637403104 11292544 25348160
14:02:25 17846 8192000000 10577331888 10935734272 1619832384 16.508 100 80 160 2 1655892144 11940736 24119024
14:02:54 14377 8192000000 10591179152 10957455360 1652777216 16.788 100 78 154 1 1688258640 12531088 22950336
14:03:16 10210 8192000000 10608177776 10973343744 1667488336 16.912 100 81 162 0 1704153312 12940416 23724560
14:03:41 7017 8192000000 10613775072 10986110976 1685021248 17.060 100 80 160 1 1721812784 13682544 23108992
14:03:58 8320 8192000000 10628790672 11003006976 1689200400 17.095 100 71 141 0 1723211088 13652992 20357696
14:04:14 6778 8192000000 10640186240 11020361728 1704639296 17.224 100 69 136 3 1736795424 12628832 19527296
14:04:34 6073 8192000000 10656802960 11034427392 1717892064 17.335 100 74 148 2 1751102448 12518960 20691424
14:04:48 5198 8192000000 10668871248 11051597824 1739876320 17.518 100 71 142 0 1771408016 10936848 20594848
14:05:01 4338 8192000000 10689041088 11069800448 1752296464 17.621 100 78 156 2 1786772576 11761584 22714528
14:05:13 2956 8192000000 10698125568 11082276864 1763068320 17.710 100 78 153 1 1800791456 16621488 21101648
14:05:23 3203 8192000000 10705107552 11086508032 1772622752 17.789 100 75 150 0 1805208000 11316048 21269200
14:05:33 3373 8192000000 10710247408 11095126016 1780295168 17.852 100 76 150 0 1813593520 11989568 21308784
14:05:43 4180 8192000000 10712964608 11099947008 1784055264 17.883 100 67 132 1 1814094880 11919680 18119936
14:05:54 4336 8192000000 10725921840 11116064768 1795676848 17.978 100 74 148 2 1828266208 12240912 20348448
14:06:05 2949 8192000000 10746879984 11137712128 1808470368 18.083 100 79 157 1 1843507952 12518096 22519488
14:06:16 2201 8192000000 10763194768 11147325440 1818653472 18.167 100 86 170 2 1856141760 13545488 23942800
14:06:25 2794 8192000000 10764586224 11151949824 1822111824 18.195 100 91 182 2 1861493408 14132880 25248704
14:06:34 2529 8192000000 10775787424 11160907776 1834248896 18.294 100 90 178 0 1874412016 15249648 24913472
14:06:43 2107 8192000000 10784726576 11169472512 1837134960 18.317 100 92 184 0 1882365616 19920720 25309936
14:06:52 2020 8192000000 10787027184 11171487744 1844495168 18.377 100 93 188 1 1884743376 14865056 25383152
14:07:00 1505 8192000000 10793778368 11180855296 1852853520 18.445 100 94 188 0 1893469248 13580608 27035120
14:07:08 1930 8192000000 10795292816 11180331008 1852367728 18.441 100 87 174 0 1888980432 12282080 24330624
14:07:16 1370 8192000000 10801941456 11186831360 1855363600 18.466 100 94 188 2 1894981280 12702480 26915200
14:07:24 1629 8192000000 10808044064 11195289600 1861530016 18.516 100 88 179 2 1899102704 12671776 24900912
14:07:32 1417 8192000000 10808011040 11196162048 1863073744 18.528 100 90 181 0 1902354320 13154912 26125664
14:07:40 2395 8192000000 10787327328 11192643584 1857516832 18.483 100 63 125 2 1886559584 11422912 17619840
14:07:48 16171 8192000000 10788479648 11198210048 1859522928 18.499 100 60 119 1 1889717584 12641808 17552848
14:08:11 9060 8192000000 10802527568 11200102400 1867716144 18.566 100 82 164 2 1900180672 9002800 23461728
14:08:26 16826 8192000000 10786062560 11203784704 1867464880 18.564 100 47 94 1 1890334144 9793824 13075440
14:08:55 7468 8192000000 10782066608 11208957952 1873088704 18.609 100 37 74 2 1890605568 7304144 10212720
14:09:09 3500 8192000000 10779568976 11206901760 1874817728 18.623 100 31 62 0 1891425888 7856560 8751600
14:09:20 5318 8192000000 10786625072 11212562432 1879013152 18.657 100 34 68 1 1895056320 7133264 8909904
14:09:32 4893 8192000000 10791126752 11219644416 1876024976 18.633 100 28 56 1 1895415808 11851936 7538896
14:09:43 7309 8192000000 10786387200 11215855616 1875665808 18.630 100 18 36 0 1886751344 6367184 4718352
14:09:58 4581 8192000000 10787901744 11215331328 1879040848 18.657 100 17 34 0 1890056864 6337104 4678912
14:10:08 11195 8192000000 10797812896 11223363584 1883365680 18.692 100 31 62 1 1898703792 6404528 8933584
14:10:27 9450 8192000000 10790620160 11224178688 1885235728 18.707 100 24 48 3 1897826800 6108016 6483056
14:10:46 4426 8192000000 10802976528 11232014336 1892517040 18.766 100 27 55 0 1906824528 5978944 8328544
14:11:04 7544 8192000000 10796590000 11230531584 1894768448 18.784 100 25 49 1 1907956320 5834128 7353744
14:11:19 11594 8192000000 10802631184 11236085760 1895396112 18.789 100 11 20 1 1903803472 6017248 2390112
14:11:37 7750 8192000000 10798801104 11236601856 1899266864 18.820 100 26 52 1 1913272112 6272752 7732496
14:11:57 55604 8192000000 10815933920 11248230400 1902000512 18.842 100 29 58 3 1916281136 5973344 8307280
14:12:59 4612 8192000000 10841930064 11262054400 1910374640 18.910 100 69 138 2 1937795920 7051968 20369312
14:13:15 8195 8192000000 10826552480 11254091776 1903149840 18.852 100 15 28 1 1913328400 5643728 4534832
14:13:34 9412 8192000000 10821722576 11258953728 1904694992 18.864 100 17 34 4 1914961552 6037408 4229152
14:13:50 8441 8192000000 10829614496 11264888832 1909154512 18.900 100 18 36 1 1920629264 6584048 4890704
14:14:06 5305 8192000000 10828617744 11265142784 1912717312 18.928 100 37 75 2 1930043248 6960272 10365664
14:14:17 5959 8192000000 10825841264 11260649472 1909330016 18.901 100 18 36 2 1923683392 9269424 5083952
14:14:30 9990 8192000000 10828151824 11260383232 1911432976 18.918 100 16 32 0 1921193936 4855920 4905040
14:14:46 7763 8192000000 10820893632 11260878848 1910231328 18.909 100 21 42 2 1921975952 5664048 6080576
14:15:04 6137 8192000000 10818752128 11256246272 1903752512 18.856 100 19 38 1 1914930624 6047200 5130912
14:15:20 4893 8192000000 10822521808 11259453440 1908867312 18.898 100 21 42 1 1920824864 5892896 6064656
14:15:31 8769 8192000000 10817964384 11244617728 1853680912 18.452 97 21 42 0 1865296800 5582272 6033616
14:15:47 8982 8192000000 10809043952 11249451008 1899503248 18.822 100 22 43 2 1911328448 5763856 6061344
14:16:02 7288 8192000000 10813069664 11231801344 1839237616 18.335 97 24 47 2 1852499440 5694800 7567024
14:16:16 11612 8192000000 10782889920 11215618048 1810189696 18.097 96 15 30 1 1819637232 5388384 4059152
14:16:34 62314 8192000000 10773299696 11207233536 1788654864 17.921 95 35 70 1 1803605136 4907520 10042752
14:17:46 9537 8192000000 10776042800 11204222976 1827593888 18.240 98 22 44 0 1839374720 5722880 6057952
14:18:02 10277 8192000000 10757842272 11180351488 1770290256 17.769 95 23 46 2 1782806704 6255728 6260720
14:18:21 4341 8192000000 10761355440 11180081152 1824142784 18.212 99 33 66 1 1844220928 10220640 9857504
14:18:31 5160 8192000000 10728061968 11150155776 1747969488 17.585 95 32 62 2 1762616512 5114464 9532560
14:18:43 7542 8192000000 10716458448 11137036288 1735752592 17.483 95 15 30 1 1745256224 5420672 4082960
14:18:57 6786 8192000000 10709954800 11123748864 1722113872 17.370 95 19 38 1 1732516512 5199920 5202720
14:19:13 5577 8192000000 10685938000 11107528704 1741884176 17.534 96 34 65 3 1761749232 10158560 9706496
14:19:25 8501 8192000000 10689351776 11095306240 1707030864 17.244 96 23 47 3 1718735232 5235376 6468992
14:19:39 8396 8192000000 10684564416 11097501696 1713706368 17.300 96 28 56 0 1727401552 5297040 8398144
14:19:55 7787 8192000000 10669934240 11078836224 1730944128 17.443 97 19 38 1 1741549952 5133936 5471888
14:20:09 15939 8192000000 10701485184 11111636992 1719708128 17.350 96 23 46 0 1731910784 5509104 6693552
14:20:34 13269 8192000000 10715936320 11133353984 1778601872 17.838 99 32 63 3 1794017792 5536016 9879904
14:20:56 14117 8192000000 10729673392 11152965632 1778779760 17.839 98 11 23 0 1787152352 5431168 2941424
14:21:18 63169 8192000000 10725346000 11156750336 1814258896 18.131 99 37 74 1 1830658480 5330208 11069376
14:22:27 11440 8192000000 10738511328 11161862144 1807813552 18.078 99 25 48 0 1821134208 6566928 6753728
14:22:47 8373 8192000000 10751819040 11170435072 1829053888 18.252 100 28 54 1 1843474752 6250848 8170016
14:23:03 5626 8192000000 10750572512 11176742912 1841564480 18.354 100 38 72 3 1857985264 5554752 10866032
14:23:17 8566 8192000000 10758446704 11185418240 1843555472 18.370 100 22 43 3 1855959536 6054336 6349728
14:23:31 6404 8192000000 10763382464 11189243904 1847035472 18.398 100 27 49 4 1859684624 5586928 7062224
14:23:46 6928 8192000000 10770411456 11200532480 1856109648 18.472 100 36 73 1 1873167184 6543024 10514512
14:23:59 6751 8192000000 10767941792 11198693376 1857103616 18.480 100 27 55 0 1870946288 6107552 7735120
14:24:13 11865 8192000000 10775441760 11202412544 1859269408 18.497 100 25 50 0 1871699104 5133712 7295984
14:24:34 6121 8192000000 10777014560 11208482816 1865103232 18.545 100 33 62 0 1881159664 6809312 9247120
14:24:49 9932 8192000000 10785529488 11208241152 1869023984 18.576 100 39 78 1 1885364400 4832112 11508304
14:25:06 8561 8192000000 10777138480 11209875456 1866746320 18.558 100 21 42 2 1877690400 5065552 5878528
14:25:20 11559 8192000000 10788588384 11214077952 1868057920 18.569 100 16 32 1 1878139056 5771008 4310128
14:25:39 6712 8192000000 10785962688 11218096128 1872603248 18.605 100 11 22 2 1880892320 5250688 3038384
14:25:52 63808 8192000000 10802685872 11225686016 1876889104 18.640 100 34 68 2 1892023088 4821616 10312368
14:27:02 39086 8192000000 10819289584 11240296448 1890388640 18.749 100 24 48 0 1903223792 6273248 6561904
14:27:49 7226 8192000000 10839971536 11256901632 1912749216 18.929 100 51 102 4 1934970384 7979136 14242032
14:28:03 4612 8192000000 10856578864 11270512640 1921859328 19.002 100 62 124 3 1947682528 8678112 17145088
14:28:20 7664 8192000000 10869178192 11280654336 1925161440 19.028 100 61 123 0 1952848896 10166832 17520624
14:28:42 22995 8192000000 10855612560 11282006016 1929353584 19.062 100 45 89 0 1951051184 9897152 11800448
14:29:11 13396 8192000000 10870182912 11293159424 1937534912 19.127 100 54 107 3 1962427424 9632896 15259616
14:29:38 6645 8192000000 10874903504 11302957056 1942575120 19.167 100 47 94 1 1966150400 9463792 14111488
14:29:57 17524 8192000000 10888266896 11314081792 1948416432 19.214 100 52 104 0 1972758800 9186256 15156112
14:30:22 25578 8192000000 10888659840 11322126336 1959479504 19.302 100 38 76 0 1980267136 9835872 10951760
14:31:07 23827 8192000000 10908841632 11340201984 1968549920 19.374 100 63 126 1 2003636960 17091920 17995120
14:31:40 7262 8192000000 10910383360 11339419648 1971907360 19.401 100 53 106 0 2002112880 15584560 14620960
14:32:01 6882 8192000000 10919375488 11350282240 1976471984 19.437 100 53 106 1 2007158240 15518336 15167920
14:32:24 20361 8192000000 10914681616 11349258240 1979005888 19.457 100 54 108 0 2010417696 15533392 15878416
14:32:53 23856 8192000000 10933417200 11365961728 1982332784 19.483 100 54 104 2 2015030448 17778256 14919408
14:33:31 2913 8192000000 10923068560 11352780800 1965860336 19.353 99 54 108 0 2001162768 19824720 15477712
14:33:41 3004 8192000000 10924569568 11356942336 1980430896 19.468 100 55 108 2 2016575840 20191104 15953840
14:33:53 9349 8192000000 10937469312 11366207488 1986804880 19.519 100 61 121 1 2025909520 21719264 17385376
14:34:17 17755 8192000000 10937478928 11367464960 1991942176 19.559 100 58 116 0 2029769600 21444960 16382464
14:34:43 3377 8192000000 10954886848 11377393664 1997192736 19.601 100 68 135 0 2038782672 21006688 20583248
14:34:55 9017 8192000000 10948466672 11378081792 2000242432 19.625 100 67 132 3 2039812864 20179552 19390880
14:35:14 5821 8192000000 10954673504 11377168384 1993262640 19.570 100 61 118 1 2034523792 23797552 17463600
14:35:28 12815 8192000000 10947294048 11380998144 1994631648 19.580 100 58 116 2 2038663056 26681376 17350032
14:35:48 2541 8192000000 10935257488 11356778496 1975082640 19.426 99 68 135 2 2023669488 28299200 20287648
14:35:59 4471 8192000000 10946828736 11369037824 1982017632 19.481 100 71 143 2 2037237360 34103584 21116144
14:36:15 2803 8192000000 10950395504 11370995712 1985401584 19.507 100 75 151 0 2037129296 29203904 22523808
14:36:25 5379 8192000000 10944410304 11369533440 1972944304 19.409 99 67 134 1 2019221040 27018640 19258096
14:36:37 5318 8192000000 10952055536 11376320512 1993325680 19.570 100 70 138 0 2040853888 27181536 20346672
14:36:48 3034 8192000000 10937784064 11359477760 1969610336 19.382 99 72 140 2 2016760560 26875456 20274768
14:36:59 2808 8192000000 10911682288 11318849536 1925004240 19.027 97 70 141 0 1973763808 27473184 21286384
14:37:13 3087 8192000000 10913680096 11340414976 1958689184 19.296 100 58 115 1 2002908976 27613472 16606320
14:37:25 4375 8192000000 10907811696 11323772928 1938977152 19.139 99 54 108 0 1980920096 26716992 15225952
14:37:36 7924 8192000000 10913860240 11336323072 1951411472 19.238 100 66 129 1 1997798192 27269664 19117056
14:37:57 5405 8192000000 10929572336 11350183936 1968569120 19.374 100 66 130 1 2016906624 28685328 19652176
14:38:10 1420 8192000000 10901398224 11305627648 1921231728 18.997 98 75 148 6 1971710912 28307952 22171232
14:38:18 2396 8192000000 10932239648 11342827520 1961850560 19.321 100 89 175 0 2018485408 30216160 26418688
14:38:27 3553 8192000000 10916352096 11336658944 1947132768 19.204 99 66 132 1 1998202576 30864896 20204912
14:38:40 10081 8192000000 10931362256 11356831744 1968893856 19.377 100 67 134 1 2020999424 31178992 20926576
14:38:57 4226 8192000000 10944204288 11370401792 1976762272 19.439 100 62 123 1 2029134000 33267856 19103872
14:39:09 2251 8192000000 10965811568 11376345088 1985976544 19.512 100 80 157 4 2044004064 33930320 24097200
14:39:18 6655 8192000000 10955362560 11375394816 1982480640 19.484 100 78 155 1 2040559408 34479792 23598976
14:39:37 1483 8192000000 10957434896 11369762816 1979341440 19.459 100 83 165 1 2040346096 35711008 25293648
14:39:47 2134 8192000000 10923127776 11330416640 1941117200 19.156 99 80 158 1 2000907888 35789072 24001616
14:39:57 3185 8192000000 10932218960 11349585920 1960114176 19.307 100 77 152 3 2020802576 37189456 23498944
14:40:07 3163 8192000000 10959022352 11365617664 1971817264 19.400 100 89 178 0 2038243280 38626992 27799024
14:40:16 2404 8192000000 10952197952 11359805440 1967114528 19.363 100 88 175 0 2032759984 39288928 26356528
14:40:25 2224 8192000000 10916428000 11323600896 1924772848 19.025 98 85 168 2 1990287584 40364992 25149744
14:40:35 3202 8192000000 10939577888 11349385216 1958342192 19.293 100 74 145 2 2021237856 40594080 22301584
14:40:45 6837 8192000000 10928217968 11345149952 1937654784 19.128 99 72 144 1 2000305008 40803536 21846688
14:40:59 2513 8192000000 10950585792 11356119040 1958334736 19.293 100 89 177 0 2026750704 41739152 26676816
14:41:11 2221 8192000000 10929940528 11339829248 1933364272 19.094 99 85 170 0 2000930144 41900944 25664928
14:41:21 1958 8192000000 10950653328 11361386496 1960748672 19.312 100 82 162 2 2031650640 45468000 25433968
14:41:30 2831 8192000000 10952254688 11360038912 1959630240 19.303 100 90 177 2 2034139808 46943536 27566032
14:41:39 3956 8192000000 10954710912 11368591360 1964187952 19.339 100 79 158 0 2036499088 47458896 24852240
14:41:51 3284 8192000000 10951616672 11369271296 1967217344 19.363 100 72 142 0 2034944240 45369056 22357840
14:42:01 3559 8192000000 10955532192 11370090496 1954633552 19.263 99 80 158 1 2025706608 46347280 24725776
14:42:12 5979 8192000000 10950366304 11364126720 1960798048 19.312 100 75 149 0 2032412224 47959984 23654192
14:42:24 2975 8192000000 10957456832 11373670400 1963591920 19.335 100 80 160 0 2039032848 50549232 24891696
14:42:37 4426 8192000000 10928267680 11360837632 1942949984 19.170 99 58 117 1 2009598048 47392384 19255680
14:42:49 13708 8192000000 10925049952 11371192320 1961637664 19.319 100 37 74 1 2022347920 48275008 12435248
14:43:14 17289 8192000000 10910759600 11347660800 1913491744 18.935 98 32 64 1 1965059072 40301056 11266272
14:43:40 10732 8192000000 10937649808 11365920768 1939910880 19.146 99 40 74 2 1990396496 38112592 12373024
14:43:57 8760 8192000000 10926412000 11357851648 1937600224 19.128 99 39 78 1 1989516432 39714192 12202016
14:44:13 11114 8192000000 10891897488 11324637184 1896037792 18.794 97 35 69 1 1945741024 38115040 11588192
14:44:30 11231 8192000000 10878188000 11315183616 1907872640 18.890 99 31 62 0 1962627360 44361408 10393312
14:44:48 12308 8192000000 10889844704 11333545984 1927959920 19.051 100 29 59 0 1982619568 44389120 10270528
14:45:13 26085 8192000000 10882518992 11322064896 1896390576 18.797 98 24 48 2 1948010160 43331216 8288368
14:45:53 11844 8192000000 10914880016 11341860864 1912054448 18.923 99 48 94 1 1976838432 49123840 15660144
14:46:12 5075 8192000000 10908895136 11327246336 1917153344 18.964 100 51 102 2 1983739616 50024768 16561504
14:46:24 9524 8192000000 10882819056 11316903936 1906284512 18.877 100 41 82 0 1970518272 50508240 13725520
14:46:47 40788 8192000000 10885163840 11326971904 1907055024 18.883 100 25 49 1 1953914000 38532784 8326192
14:47:41 22670 8192000000 10892901728 11333894144 1929395152 19.062 100 40 81 2 1981502656 39084864 13022640
14:48:23 25932 8192000000 10886714720 11337687040 1910618624 18.912 99 35 71 0 1956040320 33944224 11477472
14:49:06 35133 8192000000 10876928832 11325403136 1927948016 19.050 100 18 34 3 1959850080 26053584 5848480
14:50:09 30226 8192000000 10878844464 11344146432 1930385152 19.070 100 17 34 2 1970374736 34714400 5275184
14:51:54 89381 8192000000 10868594768 11330854912 1890269232 18.748 98 2 4 0 1910184352 19488752 426368
14:53:29 110753 8192000000 10856115216 11315154944 1915642272 18.952 99 13 27 1 1939265616 19704368 3918976
14:55:26 23399 8192000000 10913468976 11338330112 1950855040 19.233 100 55 108 2 1978446192 10647520 16943632
14:55:57 45540 8192000000 10900649904 11344326656 1951812848 19.241 100 46 92 1 1982137360 16773472 13551040
14:57:23 101181 8192000000 10898094560 11356909568 1935360112 19.110 99 7 14 0 1952533200 15544352 1628736
15:00:48 33031 8192000000 10880620192 11331211264 1950718224 19.232 100 10 20 1 1961833184 8819536 2295424
15:01:44 144903 8192000000 10896197952 11367809024 1888356960 18.733 96 13 24 1 1911403296 19894128 3152208
15:04:15 85514 8192000000 10888340704 11338584064 1939259072 19.141 99 7 14 0 1965383632 24708624 1415936
15:05:49 42463 8192000000 10910443952 11360509952 1970793280 19.392 100 42 84 1 1991892032 8898912 12199840
15:06:38 52697 8192000000 10899049136 11356766208 1956674352 19.280 99 22 44 2 1973163632 9680272 6809008
15:08:12 43729 8192000000 10901045056 11355189248 1972013760 19.401 100 18 35 1 1984777920 6995216 5768944
15:09:04 56644 8192000000 10921024128 11377991680 1982610592 19.485 100 32 63 2 2003342704 11392208 9339904
15:10:08 81340 8192000000 10903038864 11372371968 1965956880 19.353 99 10 19 0 1976467104 7964992 2545232
15:11:44 42365 8192000000 10898274832 11372871680 1939802656 19.145 98 14 28 1 1953634544 9088464 4743424
15:12:35 45927 8192000000 10888489904 11354042368 1938447536 19.134 98 15 29 1 1949644096 6847792 4348768
15:13:29 116805 8192000000 10906475888 11377852416 1980279408 19.467 100 12 23 3 1992836400 9180240 3376752
15:15:32 102894 8192000000 10901630816 11375947776 1958348960 19.293 99 11 21 1 1971365792 9743776 3273056
15:18:07 95684 8192000000 10892598448 11369058304 1963993920 19.338 99 12 24 1 1981016848 13651168 3371760
15:19:49 14192 8192000000 10904085040 11378851840 1988886464 19.535 100 17 33 1 2001710816 7659856 5164496
15:20:17 2198 8192000000 10902534832 11372339200 1969664944 19.383 99 23 47 1 1982836448 6934640 6236864
15:20:26 67135 8192000000 10879540208 11357892608 1937541328 19.127 98 18 36 0 1950404992 8054880 4808784
15:21:59 71175 8192000000 10865034736 11338764288 1909403472 18.902 97 16 32 0 1923791888 9744112 4644304
15:23:40 64131 8192000000 10875440640 11354595328 1927745264 19.049 98 14 28 2 1943123728 11354288 4024176
15:24:52 69584 8192000000 10866418144 11339767808 1885324288 18.708 97 11 22 2 1908390896 19652560 3414048
15:26:40 41139 8192000000 10880843392 11349716992 1935289872 19.109 99 17 34 1 1953168656 13027648 4851136
15:27:28 46023 8192000000 10879754112 11346161664 1899169664 18.820 97 23 45 1 1922030864 16059552 6801648
15:28:20 40165 8192000000 10877413760 11345907712 1931006224 19.075 99 20 40 1 1953057168 16305088 5745856
15:29:11 33995 8192000000 10875235168 11336994816 1937845824 19.130 99 15 29 2 1957256640 15542976 3867840
15:29:54 24424 8192000000 10892059744 11349889024 1912187440 18.924 97 26 51 1 1926394752 7313056 6894256
15:30:39 58064 8192000000 10889924192 11360489472 1939159360 19.140 99 15 30 1 1954868480 12082000 3627120
15:31:50 104656 8192000000 10867030944 11328061440 1715410480 17.314 87 21 42 1 1736048736 14850784 5787472
15:33:42 36464 8192000000 10864832096 11313496064 1836906672 18.316 95 24 48 1 1858635920 15023680 6705568
15:34:28 18855 8192000000 10861656816 11318554624 1897258096 18.804 98 38 76 0 1916872096 9134576 10479424
15:34:55 35486 8192000000 10881090832 11349426176 1919938976 18.986 99 24 48 0 1941720384 15218608 6562800
15:35:37 67087 8192000000 10832916608 11290251264 1741317696 17.530 90 20 40 0 1755540800 8872896 5350208
15:36:50 42961 8192000000 10865272736 11321778176 1896448064 18.798 99 23 46 3 1915922688 13045024 6429600
15:37:44 94163 8192000000 10865150960 11334565888 1926189584 19.036 99 20 40 0 1943116560 10909504 6017472
15:40:05 62763 8192000000 10899567600 11351670784 1934957040 19.106 99 43 86 2 1963389968 15809136 12623792
15:41:15 40057 8192000000 10875447712 11343396864 1938473632 19.135 100 28 56 0 1965183552 18511664 8198256
15:42:28 53387 8192000000 10862273056 11348000768 1931413840 19.078 99 11 22 1 1951400032 16632976 3353216
15:44:02 54499 8192000000 10871743968 11344871424 1931788944 19.081 99 16 31 1 1949840480 13537376 4514160
15:45:07 63122 8192000000 10879081072 11347095552 1954624576 19.263 100 12 24 1 1967941888 9796608 3520704
15:46:17 85925 8192000000 10886022992 11377594368 1937213168 19.125 99 7 14 0 1950569376 11568048 1788160
15:47:49 70668 8192000000 10859005632 11329818624 1895110512 18.787 97 11 22 0 1914366656 16173472 3082672
15:49:39 40209 8192000000 10881089808 11335843840 1912751376 18.929 98 17 32 1 1925452224 7720112 4980736
15:50:27 21785 8192000000 10899924384 11351662592 1958534896 19.294 100 40 80 1 1978497520 8784848 11177776
15:50:59 58901 8192000000 10891631536 11362672640 1925012112 19.027 98 24 48 1 1942175968 10605952 6557904
15:52:21 48253 8192000000 10920236704 11385212928 1980034064 19.465 100 31 60 4 2002471344 13805664 8631616
15:53:26 100827 8192000000 10888660304 11380113408 1894288528 18.780 96 10 20 0 1915645984 18479728 2877728
15:55:14 86524 8192000000 10888614656 11365687296 1904522944 18.863 97 12 24 1 1928125952 20387296 3215712
15:57:00 23081 8192000000 10899493184 11373944832 1954863344 19.265 100 20 40 0 1980897392 20372432 5661616
15:57:39 60547 8192000000 10894266000 11346522112 1907541248 18.887 97 13 24 0 1921730944 10900240 3289456
15:58:49 58698 8192000000 10898175120 11358052352 1950571920 19.231 99 30 60 1 1974454224 15752144 8130160
15:59:54 111387 8192000000 10899437344 11365134336 1956681600 19.280 99 29 58 3 1978949424 14047632 8220192
16:01:56 74525 8192000000 10899440592 11364028416 1965185776 19.347 99 12 24 0 1978833552 10440960 3206816
16:03:16 37672 8192000000 10919949392 11379912704 1986613440 19.517 100 16 32 2 2004569728 12769520 5186768
16:04:12 49841 8192000000 10902182576 11386101760 1966000768 19.354 99 18 36 1 1989233728 17769920 5463040
16:05:22 61180 8192000000 10897763888 11390689280 1960901568 19.313 99 15 30 1 1980146704 15173776 4071360
16:06:35 51901 8192000000 10900874368 11367522304 1917950608 18.970 97 13 26 0 1931195872 9674576 3570688
16:07:33 92432 8192000000 10868546848 11348684800 1900130160 18.827 96 13 26 0 1915252224 11076304 4045760
16:09:25 51584 8192000000 10875698000 11356233728 1920089088 18.988 98 10 20 0 1940269248 16608832 3571328
16:10:28 45876 8192000000 10902634656 11363487744 1929798112 19.065 98 21 41 2 1949551424 13370064 6383248
16:11:52 65898 8192000000 10867952448 11338686464 1863204752 18.529 95 25 50 1 1882815072 12491312 7119008
16:13:04 68291 8192000000 10885622112 11365052416 1948146896 19.212 100 14 28 2 1963012736 11060016 3805824
16:14:26 42635 8192000000 10882057504 11354107904 1923282864 19.013 98 16 32 0 1939828096 12301296 4243936
16:15:20 52337 8192000000 10887878000 11344379904 1893241040 18.772 97 20 39 1 1912482128 14056960 5184128
16:16:22 194708 8192000000 10893740848 11366735872 1818436240 18.165 93 21 42 1 1839302480 14661904 6204336
16:19:43 54700 8192000000 10834908544 11312246784 1784672688 17.888 92 6 12 0 1800671392 14350176 1648528
16:20:44 56246 8192000000 10866653120 11316428800 1889941456 18.745 99 10 20 0 1906620528 13967792 2711280
16:21:59 110129 8192000000 10841842288 11308466176 1861584368 18.516 96 29 58 1 1879034944 9533664 7916912
16:24:06 57250 8192000000 10847662208 11303604224 1899626848 18.823 98 24 48 0 1913253232 7272352 6354032
16:25:09 52770 8192000000 10857743344 11321479168 1875343152 18.627 96 32 64 1 1894960416 10746288 8870976
16:26:11 64887 8192000000 9809591584 10172723200 944494944 10.337 49 7 14 0 954670544 8214688 1960912

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 23-12-2020 16:29:17 to 23-12-2020 16:29:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 132 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-12-2020 16:29:48 to 23-12-2020 16:29:50.

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          250362
MON$OLDEST_ACTIVE               250363
MON$OLDEST_SNAPSHOT             250363
MON$NEXT_TRANSACTION            250363
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                       2045472
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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'

23.12.20 16:29:51. 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-23 16:29:53 No severe PSQL-related problems occured
23.12.20 16:29:54. End of report.