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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17407644 kB
MemAvailable 31557668 kB
Buffers 0 kB
Cached 14259144 kB
SwapCached 1988 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-08 01:27:07
DTS_END                         2020-12-08 01:27:07.4320
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/56432
TRN_ID                          253036
ATT_ID                          648
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: 9803.22 17217 1176386
customer order: creation 186.22 329 22346
customer order: refuse 16.08 272 1929
order to supplier: creation 50.17 1188 6020
order to supplier: removal 3.68 78833 442
invoice (draft): creation 49.84 2823 5981
invoice (draft): removal 54.78 623 6573
invoice accept: apply 45.68 16275 5481
invoice accept: cancel 49.43 618 5932
customer reserve: creation 4193.23 164 503188
customer reserve: removal 4841.34 47 580961
realization accept: apply 89.99 140 10799
realization accept: cancel 83.59 97 10031
payment from customer: creation 64.13 87 7695
payment from customer: removal 6.26 81 751
payment to supplier: creation 51.98 97 6237
payment to supplier: removal 3.44 92 413
service: total inventory turnovers 5.11 1108 613
service: total monetary turnovers 7.30 49 876
service: aggregate perf. data 0.95 15434 114
service: refresh index statistics 0.03 225986 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 08-12-2020 01:28:15 to 08-12-2020 01:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11952
TEST_TIME 2 9148
TEST_TIME 3 8688
TEST_TIME 4 8490
TEST_TIME 5 7953
TEST_TIME 6 7325
TEST_TIME 7 7217
TEST_TIME 8 8262
TEST_TIME 9 8985
TEST_TIME 10 9269
TEST_TIME 11 9676
TEST_TIME 12 9605
TEST_TIME 13 9586
TEST_TIME 14 10111
TEST_TIME 15 9958
TEST_TIME 16 10102
TEST_TIME 17 9989
TEST_TIME 18 9907
TEST_TIME 19 10293
TEST_TIME 20 10816
TEST_TIME 21 11038
TEST_TIME 22 10899
TEST_TIME 23 11090
TEST_TIME 24 11217
TEST_TIME 25 11995
TEST_TIME 26 12615
TEST_TIME 27 12345
TEST_TIME 28 12237
TEST_TIME 29 11932
TEST_TIME 30 11929
TEST_TIME 31 11768
TEST_TIME 32 11609
TEST_TIME 33 11661
TEST_TIME 34 11584
TEST_TIME 35 11429
TEST_TIME 36 11303
TEST_TIME 37 11239
TEST_TIME 38 11151
TEST_TIME 39 11134
TEST_TIME 40 10982
TEST_TIME 41 10969
TEST_TIME 42 10748
TEST_TIME 43 10886
TEST_TIME 44 10779
TEST_TIME 45 10674
TEST_TIME 46 10682
TEST_TIME 47 10667
TEST_TIME 48 10669
TEST_TIME 49 10582
TEST_TIME 50 10485
TEST_TIME 51 10635
TEST_TIME 52 10559
TEST_TIME 53 10770
TEST_TIME 54 10779
TEST_TIME 55 10772
TEST_TIME 56 10779
TEST_TIME 57 10799
TEST_TIME 58 10799
TEST_TIME 59 10771
TEST_TIME 60 10659
TEST_TIME 61 10559
TEST_TIME 62 10502
TEST_TIME 63 10479
TEST_TIME 64 10413
TEST_TIME 65 10311
TEST_TIME 66 10343
TEST_TIME 67 10313
TEST_TIME 68 10363
TEST_TIME 69 10317
TEST_TIME 70 10379
TEST_TIME 71 10396
TEST_TIME 72 10338
TEST_TIME 73 10367
TEST_TIME 74 10348
TEST_TIME 75 10459
TEST_TIME 76 10450
TEST_TIME 77 10517
TEST_TIME 78 10517
TEST_TIME 79 10419
TEST_TIME 80 10338
TEST_TIME 81 10333
TEST_TIME 82 10268
TEST_TIME 83 10204
TEST_TIME 84 10136
TEST_TIME 85 10144
TEST_TIME 86 10116
TEST_TIME 87 10113
TEST_TIME 88 10070
TEST_TIME 89 10046
TEST_TIME 90 10085
TEST_TIME 91 10115
TEST_TIME 92 10114
TEST_TIME 93 10139
TEST_TIME 94 10147
TEST_TIME 95 10168
TEST_TIME 96 10200
TEST_TIME 97 10161
TEST_TIME 98 10199
TEST_TIME 99 10186
TEST_TIME 100 10236
TEST_TIME 101 10167
TEST_TIME 102 10107
TEST_TIME 103 10061
TEST_TIME 104 10072
TEST_TIME 105 10009
TEST_TIME 106 9965
TEST_TIME 107 9951
TEST_TIME 108 9910
TEST_TIME 109 9882
TEST_TIME 110 9885
TEST_TIME 111 9876
TEST_TIME 112 9859
TEST_TIME 113 9868
TEST_TIME 114 9925
TEST_TIME 115 9872
TEST_TIME 116 9895
TEST_TIME 117 9871
TEST_TIME 118 9863
TEST_TIME 119 9887
TEST_TIME 120 9811

Performance per minute, chart


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

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 1640492 1640492 0 0.00 0 30530 5 0 0
doc_list_biud 1640491 1640491 0 0.00 0 44560 21 0 0
sp_add_invoice_to_stock 5637 5481 156 2.76 26 177294 16275 0 156
sp_cancel_adding_invoice 5932 5932 0 0.00 5 72505 618 0 0
sp_cancel_client_order 1929 1929 0 0.00 4 10253 273 0 0
sp_cancel_customer_reserve 580961 580961 0 0.00 1 44561 47 0 0
sp_cancel_pay_from_customer 751 751 0 0.00 2 11645 82 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 2 5698 92 0 0
sp_cancel_supplier_invoice 6585 6573 12 0.18 2 20130 623 0 12
sp_cancel_supplier_order 442 442 0 0.00 6 789830 78833 0 0
sp_cancel_write_off 10031 10031 0 0.00 1 7415 98 0 0
sp_client_order 22346 22346 0 0.00 4 39825 329 0 0
sp_customer_reserve 503188 503188 0 0.00 0 133562 164 0 0
sp_fill_shopping_cart 34347 34347 0 0.00 1 10284 34 0 0
sp_fill_shopping_cart_clo_res 503170 503170 0 0.00 0 14054 13 0 0
sp_get_clo_for_invoice 5463 5463 0 0.00 0 20922 260 0 0
sp_kill_cost_storno 17127 17127 0 0.00 0 7800 43 0 0
sp_kill_qstorno_ret_qs2qd 1178968 1178968 0 0.00 0 44508 26 0 0
sp_kill_qty_storno 622129 622129 0 0.00 0 44560 55 0 0
sp_lock_selected_doc 22430 22430 0 0.00 0 11635 7 0 0
sp_make_cost_storno 30194 30194 0 0.00 0 9978 42 0 0
sp_multiply_rows_for_pdistr 30193 30193 0 0.00 0 5407 20 0 0
sp_multiply_rows_for_qdistr 22346 22346 0 0.00 0 39749 171 0 0
sp_pay_from_customer 7695 7695 0 0.00 4 12089 88 0 0
sp_pay_to_supplier 6237 6237 0 0.00 4 10878 98 0 0
sp_payment_common 13932 13932 0 0.00 1 8828 23 0 0
sp_qd_handle_on_cancel_clo 1929 1929 0 0.00 0 10246 252 0 0
sp_qd_handle_on_invoice_upd_sts 11395 11395 0 0.00 0 30706 250 0 0
sp_qd_handle_on_reserve_upd_sts 10798 10798 0 0.00 0 13457 48 0 0
sp_reserve_write_off 10799 10799 0 0.00 6 14860 141 0 0
sp_supplier_invoice 5981 5981 0 0.00 5 89596 2824 0 0
sp_supplier_order 6020 6020 0 0.00 4 42231 1188 0 0
srv_aggregate_perf_data 114 114 0 0.00 2917 247258 15435 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1448 158758 32409 0 0
srv_find_qd_qs_mism 1123766 1123766 0 0.00 0 30519 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 46 120182 1109 0 0
srv_make_money_saldo 876 876 0 0.00 1 28244 50 0 0
srv_recalc_idx_stat 4 4 0 0.00 149742 309730 225987 0 0
t$perf-abend:sp_add_invoice_to_stock 156 156 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5481 5481 0 0.00 0 26892 136 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 1 3350 60 0 0
t$perf-norm:sp_cancel_client_order 1929 1929 0 0.00 0 4515 10 0 0
t$perf-norm:sp_cancel_customer_reserve 751 751 0 0.00 0 3209 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 751 751 0 0.00 0 2789 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 1785 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 633 8 0 0
t$perf-norm:sp_cancel_supplier_order 442 442 0 0.00 0 23242 1266 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 590 4 0 0
t$perf-norm:sp_client_order 22346 22346 0 0.00 0 5345 12 0 0
t$perf-norm:sp_customer_reserve 1107 1107 0 0.00 0 2617 6 0 0
t$perf-norm:sp_pay_from_customer 7695 7695 0 0.00 0 5160 8 0 0
t$perf-norm:sp_pay_to_supplier 6237 6237 0 0.00 0 4469 11 0 0
t$perf-norm:sp_reserve_write_off 10799 10799 0 0.00 0 8609 8 0 0
t$perf-norm:sp_supplier_invoice 5981 5981 0 0.00 0 5491 15 0 0
t$perf-norm:sp_supplier_order 6020 6020 0 0.00 0 7739 13 0 0
t$perf-norm:srv_aggregate_perf_data 114 114 0 0.00 0 501 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 711 7 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 1412 14 0 0
t$perf-norm:srv_make_money_saldo 876 876 0 0.00 0 1329 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 11234 10922 312 2.77 0 5164 17 0 312
v_all_customers 40292 40292 0 0.00 0 88 1 0 0
v_all_suppliers 32828 32828 0 0.00 0 88 1 0 0
v_all_wares 44692 44692 0 0.00 0 26 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 1528 8 0 0
v_cancel_client_order 3858 3858 0 0.00 0 2103 3 0 0
v_cancel_customer_prepayment 1502 1502 0 0.00 0 2229 6 0 0
v_cancel_customer_reserve 1502 1502 0 0.00 0 431 4 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 3853 13 0 0
v_cancel_supplier_invoice 850 826 24 2.82 0 3455 18 0 24
v_cancel_supplier_order 884 884 0 0.00 0 4114 6 0 0
v_cancel_write_off 2076 2076 0 0.00 0 1146 11 0 0
v_max_id_clo_ord 6020 6020 0 0.00 0 315 1 0 0
v_max_id_clo_res 1107 1107 0 0.00 0 3492 19 0 0
v_max_id_ord_sup 5981 5981 0 0.00 0 5034 4 0 0
v_max_non_paid_invoice 1824 1824 0 0.00 0 358 2 0 0
v_max_non_paid_realizn 4210 4210 0 0.00 0 2459 4 0 0
v_min_id_clo_ord 6020 6020 0 0.00 0 4642 7 0 0
v_min_id_clo_res 1107 1107 0 0.00 0 8715 20 0 0
v_min_id_ord_sup 5981 5981 0 0.00 0 3792 4 0 0
v_min_non_paid_invoice 6237 6237 0 0.00 0 7203 13 0 0
v_min_non_paid_realizn 7695 7695 0 0.00 0 7203 13 0 0
v_our_firm 11370 11370 0 0.00 0 12 1 0 0
v_reserve_write_off 21594 21594 0 0.00 0 3862 5 0 0
x_lock_depdocs_on_canc_invoice 12092 12092 0 0.00 0 17227 87 0 0
x_lock_depdocs_on_canc_sup_ord 442 442 0 0.00 0 19430 346 0 0
x_make_qstorno_1000_1200 6020 6020 0 0.00 2 42223 1109 0 0
x_make_qstorno_1200_2000 5981 5981 0 0.00 2 80901 2710 0 0
x_make_qstorno_2100_3300 503188 503188 0 0.00 0 133556 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-12-2020 01:28:23 to 08-12-2020 01:28:27.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:16 7524 8192000000 10155198944 10447106048 778568432 8.679 62 54 113 1 798789040 2060912 18159696
22:57:33 21404 8192000000 10304170064 10617831424 1344353424 14.097 100 87 174 0 1377791920 4437776 29000720
22:58:04 27512 8192000000 10362203648 10684755968 1400492592 14.599 100 80 160 0 1432339408 5399808 26447008
22:58:40 24039 8192000000 10403728816 10731495424 1453058448 15.065 100 87 174 0 1488360624 6943024 28359152
22:59:13 16966 8192000000 10429272096 10760019968 1479837040 15.300 100 89 178 1 1520156736 12188016 28131680
22:59:39 20179 8192000000 10438730368 10774192128 1500501616 15.481 100 87 174 0 1537159328 8501552 28156160
23:00:14 17513 8192000000 10470673744 10806226944 1521167936 15.660 100 85 170 2 1557297504 9289840 26839728
23:00:40 13043 8192000000 10478529376 10819493888 1533638208 15.769 100 85 170 1 1569911312 9875840 26397264
23:01:05 16185 8192000000 10489111200 10835615744 1552892128 15.935 100 87 174 0 1589972640 10426288 26654224
23:01:32 15041 8192000000 10515772528 10871758848 1573589552 16.113 100 72 143 2 1605408048 10011968 21806528
23:01:57 11921 8192000000 10544407792 10903683072 1606411488 16.394 100 78 154 4 1640119808 9922080 23786240
23:02:23 11609 8192000000 10575503104 10940964864 1634731136 16.635 100 75 150 1 1667126464 9896400 22498928
23:02:43 9681 8192000000 10605732336 10966827008 1659124512 16.841 100 83 166 0 1699138448 15304624 24709312
23:03:02 7491 8192000000 10611885600 10977861632 1674530928 16.971 100 87 174 3 1711753920 11345424 25877568
23:03:18 10082 8192000000 10645200064 11013910528 1690430528 17.105 100 76 151 4 1723504048 11259984 21813536
23:03:37 5257 8192000000 10649241840 11021987840 1716149040 17.320 100 80 160 1 1750741952 11749376 22843536
23:03:49 6041 8192000000 10670367232 11043454976 1731810128 17.451 100 82 162 2 1767609632 13046592 22752912
23:04:02 6160 8192000000 10685202768 11057750016 1739511696 17.515 100 89 178 2 1778112896 13046272 25554928
23:04:17 6387 8192000000 10686817216 11068518400 1750458320 17.605 100 77 151 3 1786002304 13945296 21598688
23:04:30 3877 8192000000 10708416640 11086360576 1758410272 17.671 100 79 156 2 1793998448 13458528 22129648
23:04:41 5154 8192000000 10707478064 11089268736 1771074704 17.776 100 85 170 0 1809394448 14362944 23956800
23:04:54 4184 8192000000 10721098464 11101724672 1781649600 17.863 100 76 152 0 1815244992 12682272 20913120
23:05:05 3678 8192000000 10724903120 11108188160 1786700624 17.905 100 71 142 0 1820176176 12956592 20518960
23:05:17 4920 8192000000 10741151552 11125342208 1802892800 18.038 100 82 164 1 1839283904 13564688 22826416
23:05:28 10015 8192000000 10742667744 11131805696 1802650048 18.036 100 74 148 1 1837362496 14078064 20634384
23:05:45 3136 8192000000 10761419152 11146412032 1815668160 18.142 100 89 175 1 1854573472 14536976 24368336
23:05:55 2576 8192000000 10777976912 11162382336 1826373056 18.230 100 77 154 1 1862104544 13296288 22435200
23:06:04 2930 8192000000 10777667008 11162796032 1837455552 18.320 100 88 175 0 1875450000 13365152 24629296
23:06:14 2642 8192000000 10783873280 11170492416 1845214240 18.383 100 92 184 1 1884501872 13838208 25449424
23:06:23 2514 8192000000 10798721904 11183960064 1848967152 18.414 100 91 184 1 1890230640 15286624 25976864
23:06:32 1874 8192000000 10802006864 11186896896 1851818944 18.437 100 94 187 1 1895831584 16853456 27159184
23:06:41 1434 8192000000 10792651824 11186335744 1853465856 18.450 100 92 181 4 1893939392 14961072 25512464
23:06:48 2099 8192000000 10797805264 11190804480 1859237872 18.497 100 84 169 0 1896299616 13283376 23778368
23:06:58 3021 8192000000 10811011920 11196956672 1865335472 18.547 100 82 165 1 1899935744 11213856 23386416
23:07:07 1822 8192000000 10813776240 11201650688 1869391488 18.579 100 92 183 0 1908704992 13407264 25906240
23:07:15 1207 8192000000 10819273360 11211034624 1876888016 18.640 100 96 191 0 1917621920 13428912 27304992
23:07:23 1304 8192000000 10818362640 11214663680 1878190176 18.650 100 89 177 0 1916826512 13753072 24883264
23:07:30 33957 8192000000 10814753408 11212374016 1875125136 18.626 100 67 133 0 1905261408 11844704 18291568
23:08:10 1340 8192000000 10828098192 11222089728 1882606976 18.686 100 93 186 2 1921782816 11067968 28107872
23:08:19 2738 8192000000 10798205952 11215806464 1876228176 18.635 100 56 111 1 1902939712 10940240 15771296
23:08:28 6096 8192000000 10796815152 11216502784 1875487264 18.629 100 42 84 0 1896051856 9156000 11408592
23:08:42 2760 8192000000 10795345616 11218046976 1880434864 18.669 100 30 60 0 1896963984 8323328 8205792
23:08:51 2611 8192000000 10797265536 11220180992 1883950272 18.697 100 40 80 1 1903578304 8448512 11179520
23:09:02 3917 8192000000 10802658848 11227664384 1883482544 18.693 100 30 59 1 1899608336 7907152 8218640
23:09:15 7975 8192000000 10797768576 11227435008 1887614656 18.727 100 32 64 0 1904883424 7609504 9659264
23:09:33 5905 8192000000 10802292400 11228196864 1887389872 18.725 100 16 32 0 1898245872 6088480 4767520
23:09:46 4302 8192000000 10800425296 11229978624 1893003328 18.770 100 33 67 0 1909931312 7284976 9643008
23:09:58 10761 8192000000 10795475120 11230646272 1892885728 18.769 100 22 44 1 1904910880 5523248 6501904
23:10:15 9063 8192000000 10799323728 11233669120 1893239168 18.772 100 22 44 3 1905480528 6125824 6115536
23:10:32 15479 8192000000 10807879552 11241127936 1896393664 18.797 100 27 54 1 1918901552 14455808 8052080
23:10:54 46739 8192000000 10846835264 11261874176 1905684688 18.872 100 52 105 0 1927355536 5843648 15827200
23:11:49 12523 8192000000 10803683504 11245744128 1900019984 18.826 100 15 30 0 1909866496 5923344 3923168
23:12:10 5244 8192000000 10821954896 11251703808 1905423232 18.870 100 32 62 3 1920582992 6949104 8210656
23:12:24 4495 8192000000 10812007552 11253366784 1903863232 18.857 100 26 52 2 1919180928 8377552 6940144
23:12:36 9215 8192000000 10814602384 11251425280 1904241376 18.860 100 22 44 2 1916819216 6092656 6485184
23:12:53 5141 8192000000 10816869376 11251625984 1908613136 18.896 100 37 75 1 1926483856 6955952 10914768
23:13:05 6855 8192000000 10828178400 11259031552 1910645264 18.912 100 42 84 0 1929036448 5680080 12711104
23:13:20 9877 8192000000 10824085440 11258707968 1908190848 18.892 100 22 44 2 1924580560 9903872 6485840
23:13:36 8955 8192000000 10817210480 11255201792 1908201888 18.892 100 19 38 0 1919468272 5743152 5523232
23:13:53 16541 8192000000 10814178064 11257159680 1907205568 18.884 100 13 26 2 1916585520 5704176 3675776
23:14:17 12626 8192000000 10816859280 11253714944 1890051904 18.746 99 12 24 0 1898672800 5260624 3360272
23:14:36 12432 8192000000 10824746304 11256922112 1906950192 18.882 100 22 45 0 1919273648 5982736 6340720
23:14:56 9739 8192000000 10806730016 11246723072 1884525024 18.702 99 16 32 0 1895011456 5467632 5018800
23:15:12 31248 8192000000 10812148752 11246755840 1868576384 18.573 98 19 36 2 1879953344 5594096 5782864
23:15:49 58300 8192000000 10802333232 11241848832 1845485264 18.385 97 33 66 3 1859810496 5001936 9323296
23:16:53 7766 8192000000 10784031744 11221241856 1862708752 18.525 99 24 48 1 1875179232 5419424 7051056
23:17:09 6387 8192000000 10765536464 11185655808 1789440128 17.927 95 42 84 1 1808439248 7415104 11584016
23:17:23 5574 8192000000 10773590512 11202838528 1842339408 18.360 99 34 67 1 1858537840 7253504 8944928
23:17:35 4423 8192000000 10758281280 11193552896 1855263664 18.465 100 23 46 2 1868398336 6530448 6604224
23:17:47 6276 8192000000 10759177696 11185496064 1820287232 18.180 98 28 56 1 1834213312 5987776 7938304
23:18:02 12724 8192000000 10737705632 11149410304 1746558944 17.573 95 32 64 2 1761800320 5448704 9792672
23:18:20 4769 8192000000 10706166144 11130990592 1759311936 17.679 97 20 40 1 1771263936 6348864 5603136
23:18:35 8626 8192000000 10703469104 11124809728 1774068912 17.801 98 14 28 2 1783062704 5356624 3637168
23:18:49 8817 8192000000 10726612704 11144876032 1781239296 17.860 98 22 43 1 1793539760 6322912 5977552
23:19:06 10329 8192000000 10712023008 11125252096 1705665408 17.233 94 17 34 2 1715380896 5217664 4497824
23:19:24 7796 8192000000 10657884800 11071254528 1724341168 17.388 97 21 42 1 1740110480 9990880 5778432
23:19:38 10437 8192000000 10652784448 11066527744 1687081760 17.077 95 18 36 0 1698461008 5281696 6097552
23:19:57 11176 8192000000 10663366272 11078995968 1684006272 17.051 95 13 26 1 1693827728 5814368 4007088
23:20:15 51222 8192000000 10675298512 11078037504 1735417696 17.481 98 28 54 2 1748929936 4930608 8581632
23:21:13 39609 8192000000 10695586256 11112218624 1705833824 17.234 95 10 20 0 1713904672 4917616 3153232
23:22:02 6241 8192000000 10720766992 11140308992 1808290224 18.082 100 25 50 2 1822536416 6888016 7358176
23:22:14 7270 8192000000 10725627056 11149987840 1817934336 18.161 100 35 68 1 1835167008 6864176 10368496
23:22:28 6275 8192000000 10729297472 11156987904 1821978064 18.194 100 28 56 0 1835519520 5563856 7977600
23:22:40 6258 8192000000 10752171888 11168948224 1834206336 18.294 100 39 78 3 1851931248 6379488 11345424
23:22:53 5674 8192000000 10746331280 11167281152 1832591904 18.280 100 19 38 1 1844244208 5846672 5805632
23:23:06 5467 8192000000 10760307360 11178270720 1843984896 18.373 100 37 73 1 1860018304 5312160 10721248
23:23:20 7440 8192000000 10768570272 11184476160 1846510832 18.394 100 24 48 0 1859795808 5570016 7714960
23:23:39 6633 8192000000 10757592576 11189346304 1846261136 18.392 100 20 39 2 1862281296 10699232 5320928
23:23:54 11194 8192000000 10768177760 11192172544 1848963088 18.414 100 17 34 1 1864004464 9527632 5513744
23:24:13 11203 8192000000 10767107744 11198476288 1851569424 18.435 100 21 42 2 1868121520 10173264 6378832
23:24:32 9339 8192000000 10771802512 11195109376 1854816544 18.461 100 28 54 3 1868682880 5518688 8347648
23:24:49 8744 8192000000 10773140272 11201732608 1858020640 18.487 100 22 44 1 1869596688 5700080 5875968
23:25:04 13285 8192000000 10771500656 11203784704 1859129744 18.496 100 17 33 0 1869949488 5677936 5141808
23:25:31 66139 8192000000 10779324624 11211644928 1869344640 18.579 100 35 71 2 1885580928 6002080 10234208
23:26:44 10284 8192000000 10787561712 11216330752 1871230432 18.594 100 24 46 3 1883658816 6230448 6197936
23:27:01 6120 8192000000 10800946528 11221045248 1880170128 18.666 100 27 54 0 1894299024 6677648 7451248
23:27:16 5453 8192000000 10840742448 11252277248 1904807344 18.865 100 66 133 0 1932862688 8390672 19664672
23:27:32 12163 8192000000 10836111536 11257798656 1908764864 18.897 100 52 103 1 1931564176 8814144 13985168
23:27:51 11255 8192000000 10851513632 11271774208 1915035792 18.947 100 56 112 0 1939993088 9694640 15262656
23:28:10 11475 8192000000 10851734048 11272261632 1920323520 18.989 100 57 114 0 1946503040 10503536 15675984
23:28:29 11513 8192000000 10863958848 11284504576 1926243952 19.037 100 59 119 0 1953529360 10818240 16467168
23:29:15 19995 8192000000 10864141344 11292975104 1935279312 19.109 100 50 100 1 1959779632 10327040 14173280
23:29:45 6032 8192000000 10872524256 11292471296 1939533456 19.143 100 57 112 1 1966839888 11589024 15717408
23:30:03 13352 8192000000 10883865792 11310030848 1944940784 19.186 100 42 84 1 1973064992 16458096 11666112
23:30:24 11180 8192000000 10876632288 11314700288 1954784160 19.265 100 46 92 1 1980659904 11799664 14076080
23:30:45 27140 8192000000 10880880336 11320147968 1938296144 19.133 99 36 72 0 1962281296 13202880 10782272
23:31:25 10185 8192000000 10894719984 11325108224 1958701008 19.296 100 45 90 1 1984710640 12983808 13025824
23:31:48 12830 8192000000 10882616016 11319521280 1954514752 19.262 100 44 88 4 1980520048 12848480 13156816
23:32:14 25920 8192000000 10889916976 11328450560 1963444304 19.333 100 38 76 1 1987585568 12632112 11509152
23:32:48 3745 8192000000 10913554464 11339436032 1969560320 19.382 100 52 104 0 1999214688 14985264 14669104
23:32:59 8120 8192000000 10915307264 11343618048 1971969280 19.401 100 52 104 0 2001462016 14585456 14907280
23:33:26 25478 8192000000 10915217936 11348434944 1972737552 19.407 100 58 116 1 2006280448 16924448 16618448
23:34:04 8988 8192000000 10909261952 11340365824 1965915168 19.353 100 53 106 2 1999743552 18485904 15342480
23:34:20 1447 8192000000 10923927264 11349360640 1970582112 19.390 100 64 128 3 2007550912 18490912 18477888
23:34:30 5669 8192000000 10925846672 11346866176 1960004832 19.306 99 71 140 1 2000688848 19625360 21058656
23:34:52 7605 8192000000 10913162464 11336077312 1950953616 19.234 99 57 113 1 1989250464 21932144 16364704
23:35:07 2661 8192000000 10931756800 11356291072 1977614192 19.446 100 75 147 2 2024103168 23440656 23048320
23:35:20 7872 8192000000 10935608000 11357044736 1958848800 19.297 99 71 142 1 2005775120 25801344 21124976
23:35:40 2210 8192000000 10929181072 11354267648 1954875952 19.265 99 66 130 0 1998698992 24690304 19132736
23:35:49 2408 8192000000 10947997296 11364286464 1980335008 19.467 100 82 161 2 2031678800 26857408 24486384
23:35:58 7362 8192000000 10940218352 11363385344 1975135600 19.426 100 69 138 0 2026252496 30753536 20363360
23:36:12 1505 8192000000 10957947248 11372486656 1985705888 19.510 100 82 163 0 2040137600 29452752 24978960
23:36:23 2952 8192000000 10930850816 11341418496 1956266112 19.276 99 75 149 2 2006158832 27268400 22624320
23:36:32 2349 8192000000 10941547552 11358109696 1973127728 19.410 100 74 147 2 2023427360 28564720 21734912
23:36:41 2190 8192000000 10948503584 11369254912 1979392128 19.460 100 79 157 0 2033075968 30832672 22851168
23:36:51 1899 8192000000 10902832336 11309551616 1923357232 19.014 97 81 163 3 1975740256 28664976 23718048
23:37:00 2421 8192000000 10926589952 11346116608 1964866176 19.345 100 72 145 1 2015411392 29608112 20937104
23:37:10 9376 8192000000 10926537952 11347959808 1946190240 19.196 99 70 140 0 2003012784 35393408 21429136
23:37:28 6160 8192000000 10916443696 11350093824 1963750800 19.336 100 56 112 1 2011944896 30764464 17429632
23:37:49 7591 8192000000 10889195840 11328077824 1946968016 19.202 100 42 84 2 1984857056 24976096 12912944
23:38:06 7587 8192000000 10901872880 11339026432 1955121776 19.267 100 38 76 1 1993291472 26381312 11788384
23:38:21 1998 8192000000 10917307776 11346620416 1950412656 19.230 99 67 132 1 1999507424 27468144 21626624
23:38:29 2161 8192000000 10932147568 11358474240 1973905568 19.416 100 75 150 0 2022369728 27066768 21397392
23:38:39 7184 8192000000 10926003440 11360452608 1969131904 19.379 100 44 88 3 2009074240 26656320 13286016
23:38:53 3036 8192000000 10918841696 11360243712 1973251024 19.411 100 50 100 1 2013231536 25781200 14199312
23:39:07 4297 8192000000 10907852864 11335553024 1945647136 19.192 99 41 82 1 1988453280 30168608 12637536
23:39:17 9039 8192000000 10852773856 11288121344 1895488208 18.790 98 45 91 2 1935071088 24467360 15115520
23:39:34 4195 8192000000 10879870640 11308437504 1926567408 19.039 100 57 109 2 1968523072 24873296 17082368
23:39:45 4537 8192000000 10864846128 11286061056 1903713136 18.856 99 71 142 0 1953695136 27592512 22389488
23:40:03 5105 8192000000 10855848960 11275755520 1868497760 18.572 97 49 98 3 1912491088 28303216 15690112
23:40:15 6053 8192000000 10882364720 11305910272 1916586368 18.959 100 59 117 1 1970526032 35964096 17975568
23:40:36 8555 8192000000 10894019632 11315912704 1925641568 19.032 100 56 112 1 1976145968 33263200 17241200
23:40:53 5319 8192000000 10900119216 11321163776 1922045152 19.003 99 60 120 1 1977366160 36681488 18639520
23:41:05 2182 8192000000 10925617968 11336683520 1945665680 19.192 100 85 165 0 2007524288 36793616 25064992
23:41:14 4708 8192000000 10905695952 11331481600 1938973280 19.139 100 60 120 0 1995523968 37861728 18688960
23:41:27 8266 8192000000 10881537360 11319648256 1917689904 18.968 99 45 90 0 1964149008 32138880 14320224
23:41:46 9437 8192000000 10881611264 11302772736 1895397952 18.789 98 36 71 3 1939288624 33114464 10776208
23:42:04 7384 8192000000 10883890816 11319656448 1926361568 19.038 100 34 67 0 1971134096 33567616 11204912
23:42:27 5182 8192000000 10902576784 11330805760 1945190144 19.188 100 45 90 1 1989965728 29845280 14930304
23:42:40 5721 8192000000 10899764016 11328385024 1943109440 19.172 100 48 94 1 1990164960 29867328 17188192
23:42:57 2836 8192000000 10918465840 11337891840 1952856400 19.249 100 61 123 3 2003920400 31651136 19412864
23:43:07 8642 8192000000 10903231968 11337244672 1946987136 19.202 100 44 88 0 1994267664 32868304 14412224
23:43:24 4843 8192000000 10917414592 11337482240 1952978448 19.250 100 64 127 3 2006406592 32316480 21111664
23:43:46 4456 8192000000 10898339504 11323637760 1923759040 19.017 99 42 84 0 1975109776 37663600 13687136
23:43:57 10795 8192000000 10910631968 11337084928 1946160128 19.196 100 39 78 2 1998378800 39635552 12583120
23:44:14 10505 8192000000 10910794736 11342278656 1929380624 19.062 99 36 72 3 1977338656 35829232 12128800
23:44:37 4648 8192000000 10926188848 11356442624 1961991408 19.322 100 57 114 0 2018356480 37233840 19131232
23:44:50 5214 8192000000 10938015616 11367182336 1967186336 19.363 100 50 100 2 2026857296 43376000 16294960
23:45:04 3169 8192000000 10936692352 11348701184 1955971040 19.274 100 63 122 2 2014189040 38357136 19860864
23:45:14 5392 8192000000 10943859824 11362611200 1964990112 19.346 100 61 122 2 2024075840 39494016 19591712
23:45:26 9425 8192000000 10935364208 11372347392 1967677456 19.367 100 46 92 1 2025407152 42435888 15293808
23:45:49 4362 8192000000 10930585392 11355389952 1935451952 19.110 98 55 108 0 2000803872 47177552 18174368
23:46:04 5335 8192000000 10953912048 11378851840 1969941248 19.385 100 63 122 1 2036206976 46152720 20113008
23:46:17 2186 8192000000 10953610016 11367641088 1950290896 19.229 99 72 137 1 2022042096 50018960 21732240
23:46:26 2888 8192000000 10962432416 11373191168 1959981552 19.306 100 88 175 0 2040888144 53728816 27177776
23:46:37 4122 8192000000 10953114656 11371536384 1957172304 19.284 100 58 115 2 2028412928 52621328 18619296
23:46:58 13030 8192000000 10933498272 11366281216 1949586192 19.223 100 37 74 0 2012267888 50251984 12429712
23:47:22 17613 8192000000 10931118752 11369304064 1953894912 19.257 100 35 70 1 2013765568 48145392 11725264
23:48:02 21885 8192000000 10919109632 11364282368 1954557488 19.263 100 29 58 2 2006551760 42286384 9707888
23:48:32 12221 8192000000 10915779760 11369627648 1956730752 19.280 100 30 60 1 2009534784 42856128 9947904
23:49:02 20579 8192000000 10913191776 11368013824 1952446880 19.246 100 22 44 1 1999440208 39815056 7178272
23:49:32 18769 8192000000 10897810432 11348160512 1902580256 18.847 98 27 54 1 1959379728 47683520 9115952
23:50:22 43277 8192000000 10907614000 11374632960 1941156928 19.156 100 23 46 1 2002609728 52863712 8589088
23:51:25 46842 8192000000 10881758096 11341185024 1894090752 18.779 98 19 38 1 1944687264 44003104 6593408
23:52:31 48314 8192000000 10879878384 11358703616 1910109216 18.908 99 13 24 1 1956317696 41722160 4486320
23:53:25 60145 8192000000 10884737488 11318296576 1901079584 18.835 98 20 39 0 1921056160 13991280 5985296
23:54:33 14457 8192000000 10884243968 11316715520 1927258544 19.045 99 74 150 2 1958087136 8496368 22332224
23:54:59 22694 8192000000 10866976080 11328864256 1929116272 19.060 100 16 32 1 1943673296 9772800 4784224
23:56:33 107419 8192000000 10882187376 11335249920 1909776960 18.905 98 25 50 2 1927239760 10845056 6617744
23:58:30 33088 8192000000 10891476944 11347562496 1942495760 19.167 99 18 35 0 1953363904 6656736 4211408
23:59:16 55230 8192000000 10903202080 11361333248 1960782880 19.312 99 38 76 1 1981332672 10493696 10056096
00:00:21 57856 8192000000 10918486032 11367137280 1940080432 19.147 98 38 74 0 1961843360 12195248 9567680
00:01:25 51004 8192000000 10892139936 11364421632 1966952768 19.361 100 17 34 1 1983758400 11823056 4982576
00:02:23 17630 8192000000 10892188704 11358793728 1949058592 19.219 99 11 20 1 1963044192 10893120 3092480
00:02:47 30187 8192000000 10924851712 11374817280 1973747472 19.415 100 24 48 1 1992085104 11508384 6829248
00:03:25 18933 8192000000 10900497888 11352973312 1945867776 19.194 98 59 115 0 1973457056 11899952 15689328
00:03:53 22120 8192000000 10935472688 11378262016 1973443504 19.413 100 56 113 0 2004668896 15508096 15717296
00:04:27 19691 8192000000 10915345552 11370389504 1979609904 19.462 100 44 88 2 2004813568 12624480 12579184
00:04:54 158741 8192000000 10868029712 11329470464 1882676368 18.687 95 22 44 2 1905726016 16488960 6560688
00:07:45 42082 8192000000 10885831904 11360583680 1949113568 19.219 99 18 36 0 1966604608 12717424 4773616
00:08:33 6939 8192000000 10882873888 11361505280 1959980240 19.306 100 9 18 0 1976095472 13441488 2673744
00:09:47 71424 8192000000 10882897184 11370418176 1958449600 19.294 100 23 44 3 1980169648 15187280 6532768
00:11:05 31012 8192000000 10901618224 11367960576 1968858912 19.376 100 19 37 1 1985474112 11005808 5609392
00:11:44 69158 8192000000 10888066352 11361849344 1932842800 19.090 98 17 34 0 1946145760 8592976 4709984
00:12:59 55204 8192000000 10883243792 11367284736 1927944656 19.050 98 12 24 1 1941864336 10237392 3682288
00:14:00 47653 8192000000 10898121136 11368030208 1965855248 19.353 100 15 30 2 1982991648 12440528 4695872
00:14:56 86694 8192000000 10887371808 11355111424 1874092880 18.617 95 17 34 1 1886592640 7624896 4874864
00:16:29 43779 8192000000 10912604368 11376291840 1968466864 19.373 100 20 40 0 1988226592 14324944 5434784
00:17:19 73371 8192000000 10912446576 11376635904 1920600912 18.992 97 27 54 0 1947534592 18745408 8188272
00:18:39 52705 8192000000 10902744624 11365748736 1945422752 19.190 99 15 30 1 1966487808 16645936 4419120
00:19:46 73224 8192000000 10891496432 11354734592 1911245312 18.917 97 12 24 1 1937178032 22887984 3044736
00:21:10 67257 8192000000 10866697264 11341123584 1860484208 18.507 95 16 32 3 1873805392 8384528 4936656
00:22:23 70480 8192000000 10893562272 11342954496 1860443472 18.507 95 28 55 3 1876237200 8469504 7324224
00:23:42 61695 8192000000 10886383936 11343630336 1874027280 18.617 96 20 38 1 1900700160 20952640 5720240
00:24:50 52093 8192000000 10901238624 11341127680 1905475600 18.870 98 24 48 0 1924133600 11765072 6892928
00:25:48 20375 8192000000 10898622000 11340193792 1906597824 18.879 98 38 76 1 1927820272 10753328 10469120
00:27:25 72735 8192000000 10826386384 11283533824 1856161584 18.472 96 38 77 0 1876051344 9162448 10727312
00:28:49 21668 8192000000 10859097712 11314790400 1929176576 19.060 100 30 60 1 1946072896 8680928 8215392
00:29:16 17663 8192000000 10852097104 11311685632 1895511840 18.790 98 21 42 0 1910579424 8696864 6370720
00:29:42 51155 8192000000 10843829296 11309748224 1882415440 18.685 98 14 28 0 1895267968 9107696 3744832
00:30:40 65108 8192000000 10845271712 11326107648 1928262160 19.053 100 9 18 2 1940548912 9980496 2306256
00:31:53 36173 8192000000 10861749984 11337146368 1920841472 18.994 99 11 21 1 1934012128 10205008 2965648
00:33:21 69637 8192000000 10844576192 11317633024 1855385936 18.466 96 12 24 0 1871656752 12559856 3710960
00:34:40 63364 8192000000 10831278848 11297955840 1863174464 18.529 97 13 26 0 1875536192 8639600 3722128
00:35:50 28093 8192000000 10815337872 11265867776 1856916544 18.478 97 25 49 3 1873667376 9868448 6882384
00:36:29 73666 8192000000 10858931472 11332087808 1894228064 18.780 98 22 44 4 1917284944 16711824 6345056
00:37:50 46954 8192000000 10878567328 11329253376 1919128320 18.980 99 23 48 0 1933698560 7762432 6807808
00:39:05 82880 8192000000 10892620992 11351257088 1919068192 18.979 98 16 32 1 1935611712 11920560 4622960
00:40:46 67954 8192000000 10900980816 11375591424 1941207888 19.156 99 20 40 0 1964245904 17570912 5467104
00:43:15 92402 8192000000 10902750448 11375923200 1942926784 19.170 99 18 36 2 1963560864 15652032 4982048
00:44:59 136020 8192000000 10895474192 11365265408 1911385184 18.918 97 29 58 1 1934279872 14689952 8204736
00:48:01 52808 8192000000 10893931696 11373277184 1977361760 19.444 100 23 46 0 1990319136 6919776 6037600
00:49:00 43772 8192000000 10866780576 11350421504 1933688592 19.096 98 8 16 0 1947101968 10567392 2845984
00:49:51 50350 8192000000 10877040576 11352014848 1950678976 19.232 99 12 24 0 1967124368 13395680 3049712
00:50:47 84272 8192000000 10875559424 11355271168 1924645248 19.024 98 13 26 1 1940248640 11604992 3998400
00:52:30 59594 8192000000 10866122064 11341660160 1915131232 18.948 98 14 28 1 1929329792 9928128 4270432
00:53:36 51895 8192000000 10847230048 11324964864 1911169184 18.916 98 16 32 0 1925338832 9580768 4588880
00:54:56 60588 8192000000 10874903008 11340181504 1904726832 18.864 98 16 33 0 1918265792 9323488 4215472
00:56:06 34952 8192000000 10887703232 11349831680 1920428960 18.990 98 27 54 2 1939645248 11413536 7802752
00:56:58 89093 8192000000 10882978144 11360391168 1904608928 18.863 97 14 28 2 1926014624 17175904 4229792
00:58:34 85794 8192000000 10892614640 11368869888 1926767472 19.041 98 7 14 0 1942085152 13580432 1737248
01:00:06 102029 8192000000 10877446960 11340402688 1813218000 18.122 92 7 14 0 1823931296 8518608 2194688
01:02:15 76638 8192000000 10893288400 11385229312 1951572400 19.239 99 19 38 0 1975723760 18393248 5758112
01:03:38 60782 8192000000 10867770864 11327258624 1886414624 18.717 96 10 20 0 1910023136 20661872 2946640
01:04:51 13177 8192000000 10915246784 11356635136 1945785024 19.193 99 57 114 0 1977021744 13532960 17703760
01:05:12 11202 8192000000 10903358576 11357040640 1958800336 19.297 100 41 82 0 1980464064 10047504 11616224
01:05:31 62833 8192000000 10920900896 11360989184 1945062144 19.187 99 38 76 3 1966577712 10435504 11080064
01:06:40 16432 8192000000 10922933024 11380580352 1980997296 19.473 100 41 82 1 2003696256 10574960 12124000
01:07:07 76620 8192000000 10890045984 11362582528 1902551648 18.847 96 15 30 2 1918420688 11797648 4071392
01:09:01 91305 8192000000 10863057552 11329794048 1857446128 18.483 95 24 48 0 1876019008 11596736 6976144
01:10:39 35274 8192000000 10843305056 11312300032 1900376384 18.829 98 10 20 1 1913741456 10717808 2647264
01:11:23 44689 8192000000 10848837728 11337355264 1919129744 18.980 99 7 14 0 1932005808 10401600 2474464
01:12:25 49537 8192000000 10853093888 11334230016 1902412112 18.846 98 9 20 1 1913693888 8521568 2760208
01:13:29 61029 8192000000 10843811216 11320549376 1887983440 18.730 97 6 12 0 1897108704 7462832 1662432
01:14:40 80849 8192000000 10824465632 11297075200 1833131216 18.285 95 13 26 1 1843268912 6710112 3427584
01:16:08 97669 8192000000 10843740080 11325505536 1878054416 18.649 98 8 16 1 1889202992 9311776 1836800
01:17:52 83869 8192000000 10870169360 11336843264 1881274384 18.675 97 19 38 1 1896198896 9928208 4996304
01:19:24 40716 8192000000 10861117712 11324657664 1885961216 18.713 97 25 50 0 1903804768 10782432 7061120
01:20:15 65704 8192000000 10861136272 11339825152 1921092512 18.996 99 18 35 1 1940220240 14096512 5031216
01:22:11 22760 8192000000 10865794192 11318566912 1899612560 18.823 98 18 36 1 1912574064 7875072 5086432
01:22:41 24278 8192000000 10889506304 11334324224 1937405616 19.126 100 39 78 1 1962614880 14538672 10670592
01:23:11 47980 8192000000 10866042624 11331944448 1901054336 18.835 98 34 68 1 1923545696 13124432 9366928
01:24:09 54605 8192000000 10893095872 11344715776 1926088816 19.036 99 34 68 1 1945501360 9263328 10149216
01:25:10 20114 8192000000 10900523264 11347562496 1937089040 19.124 99 47 94 2 1966706848 16352256 13265552
01:25:47 42743 8192000000 10893055792 11359997952 1928632800 19.056 99 30 60 0 1955448960 18433280 8382880
01:26:37 53922 8192000000 9439232448 9738571776 573710736 6.544 30 4 8 0 592943024 18262272 970016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 156 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-12-2020 01:29:01 to 08-12-2020 01:29:03.

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          253687
MON$OLDEST_ACTIVE               253688
MON$OLDEST_SNAPSHOT             253688
MON$NEXT_TRANSACTION            253688
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                       2033760
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:169: 
:170: mscs-test-161.budzdorov.ru    Tue Dec  8 01:27:41 2020
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:172: 
--- end of diff output ---

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

08.12.20 01:29:04. 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-08 01:29:07 No severe PSQL-related problems occured
08.12.20 01:29:08. End of report.