Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.02.2021 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 17106260 kB
MemAvailable 31199824 kB
Buffers 0 kB
Cached 14573308 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-08 01:27:18
DTS_END                         2021-02-08 01:27:18.1220
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/58342
TRN_ID                          238054
ATT_ID                          700
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: 9152.81 18714 1098337
customer order: creation 174.31 366 20917
customer order: refuse 14.43 359 1732
order to supplier: creation 46.51 1403 5581
order to supplier: removal 3.28 108332 394
invoice (draft): creation 46.04 3218 5525
invoice (draft): removal 52.18 822 6262
invoice accept: apply 41.11 18337 4933
invoice accept: cancel 47.57 830 5708
customer reserve: creation 3791.51 182 454981
customer reserve: removal 4639.24 60 556709
realization accept: apply 83.61 168 10033
realization accept: cancel 83.11 105 9973
payment from customer: creation 59.98 115 7198
payment from customer: removal 5.46 61 655
payment to supplier: creation 48.98 123 5877
payment to supplier: removal 3.62 58 434
service: total inventory turnovers 4.85 1070 582
service: total monetary turnovers 6.15 40 738
service: aggregate perf. data 0.84 21041 101
service: refresh index statistics 0.03 217592 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-02-2021 01:27:58 to 08-02-2021 01:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3752
TEST_TIME 2 5353
TEST_TIME 3 5270
TEST_TIME 4 5237
TEST_TIME 5 5335
TEST_TIME 6 5639
TEST_TIME 7 5875
TEST_TIME 8 5753
TEST_TIME 9 5680
TEST_TIME 10 5785
TEST_TIME 11 5905
TEST_TIME 12 5899
TEST_TIME 13 6281
TEST_TIME 14 6588
TEST_TIME 15 6860
TEST_TIME 16 7021
TEST_TIME 17 7439
TEST_TIME 18 7872
TEST_TIME 19 8231
TEST_TIME 20 8092
TEST_TIME 21 8180
TEST_TIME 22 9257
TEST_TIME 23 9055
TEST_TIME 24 8884
TEST_TIME 25 9106
TEST_TIME 26 9067
TEST_TIME 27 9555
TEST_TIME 28 9852
TEST_TIME 29 10741
TEST_TIME 30 10809
TEST_TIME 31 11037
TEST_TIME 32 10896
TEST_TIME 33 10614
TEST_TIME 34 10536
TEST_TIME 35 10504
TEST_TIME 36 10299
TEST_TIME 37 10259
TEST_TIME 38 10045
TEST_TIME 39 10077
TEST_TIME 40 9945
TEST_TIME 41 10124
TEST_TIME 42 9950
TEST_TIME 43 9873
TEST_TIME 44 9930
TEST_TIME 45 9776
TEST_TIME 46 9719
TEST_TIME 47 9641
TEST_TIME 48 9553
TEST_TIME 49 9593
TEST_TIME 50 9475
TEST_TIME 51 9459
TEST_TIME 52 9408
TEST_TIME 53 9449
TEST_TIME 54 9397
TEST_TIME 55 9436
TEST_TIME 56 9324
TEST_TIME 57 9364
TEST_TIME 58 9370
TEST_TIME 59 9429
TEST_TIME 60 9360
TEST_TIME 61 9362
TEST_TIME 62 9408
TEST_TIME 63 9393
TEST_TIME 64 9439
TEST_TIME 65 9380
TEST_TIME 66 9357
TEST_TIME 67 9445
TEST_TIME 68 9493
TEST_TIME 69 9463
TEST_TIME 70 9498
TEST_TIME 71 9483
TEST_TIME 72 9566
TEST_TIME 73 9549
TEST_TIME 74 9429
TEST_TIME 75 9374
TEST_TIME 76 9379
TEST_TIME 77 9324
TEST_TIME 78 9306
TEST_TIME 79 9318
TEST_TIME 80 9243
TEST_TIME 81 9206
TEST_TIME 82 9182
TEST_TIME 83 9225
TEST_TIME 84 9267
TEST_TIME 85 9237
TEST_TIME 86 9278
TEST_TIME 87 9318
TEST_TIME 88 9329
TEST_TIME 89 9282
TEST_TIME 90 9304
TEST_TIME 91 9359
TEST_TIME 92 9338
TEST_TIME 93 9318
TEST_TIME 94 9341
TEST_TIME 95 9359
TEST_TIME 96 9349
TEST_TIME 97 9406
TEST_TIME 98 9363
TEST_TIME 99 9352
TEST_TIME 100 9287
TEST_TIME 101 9284
TEST_TIME 102 9284
TEST_TIME 103 9257
TEST_TIME 104 9208
TEST_TIME 105 9156
TEST_TIME 106 9092
TEST_TIME 107 9033
TEST_TIME 108 9103
TEST_TIME 109 9103
TEST_TIME 110 9152
TEST_TIME 111 9137
TEST_TIME 112 9114
TEST_TIME 113 9121
TEST_TIME 114 9181
TEST_TIME 115 9200
TEST_TIME 116 9201
TEST_TIME 117 9163
TEST_TIME 118 9177
TEST_TIME 119 9211
TEST_TIME 120 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-02-2021 01:28:01 to 08-02-2021 01:28:05.

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 1520731 1520731 0 0.00 0 20386 6 0 0
doc_list_biud 1520731 1520731 0 0.00 0 29800 28 0 0
sp_add_invoice_to_stock 5047 4933 114 2.25 42 171384 18337 0 114
sp_cancel_adding_invoice 5708 5708 0 0.00 5 44999 830 0 0
sp_cancel_client_order 1732 1732 0 0.00 4 15312 359 0 0
sp_cancel_customer_reserve 556709 556709 0 0.00 1 29801 61 0 0
sp_cancel_pay_from_customer 655 655 0 0.00 3 1545 61 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 2111 59 0 0
sp_cancel_supplier_invoice 6276 6262 14 0.22 2 16459 822 0 14
sp_cancel_supplier_order 394 394 0 0.00 6 1187616 108333 0 0
sp_cancel_write_off 9973 9973 0 0.00 1 14965 106 0 0
sp_client_order 20917 20917 0 0.00 4 20568 367 0 0
sp_customer_reserve 454981 454981 0 0.00 0 63832 183 0 0
sp_fill_shopping_cart 32014 32014 0 0.00 1 21754 35 0 0
sp_fill_shopping_cart_clo_res 454973 454973 0 0.00 0 14414 12 0 0
sp_get_clo_for_invoice 4925 4925 0 0.00 0 31391 309 0 0
sp_kill_cost_storno 16770 16770 0 0.00 0 4889 55 0 0
sp_kill_qstorno_ret_qs2qd 1130047 1130047 0 0.00 0 29798 33 0 0
sp_kill_qty_storno 595736 595736 0 0.00 0 29800 71 0 0
sp_lock_selected_doc 20718 20718 0 0.00 0 7039 2 0 0
sp_make_cost_storno 28033 28033 0 0.00 0 19738 52 0 0
sp_multiply_rows_for_pdistr 28033 28033 0 0.00 0 10752 28 0 0
sp_multiply_rows_for_qdistr 20917 20917 0 0.00 0 18295 151 0 0
sp_pay_from_customer 7198 7198 0 0.00 4 14388 116 0 0
sp_pay_to_supplier 5877 5877 0 0.00 4 13985 123 0 0
sp_payment_common 13075 13075 0 0.00 1 13245 26 0 0
sp_qd_handle_on_cancel_clo 1732 1732 0 0.00 0 10692 314 0 0
sp_qd_handle_on_invoice_upd_sts 10633 10633 0 0.00 0 25131 338 0 0
sp_qd_handle_on_reserve_upd_sts 10033 10033 0 0.00 0 10641 54 0 0
sp_reserve_write_off 10033 10033 0 0.00 6 17895 169 0 0
sp_supplier_invoice 5525 5525 0 0.00 6 92144 3218 0 0
sp_supplier_order 5581 5581 0 0.00 5 31849 1403 0 0
srv_aggregate_perf_data 101 101 0 0.00 2645 398382 21041 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 992 137859 32368 0 0
srv_find_qd_qs_mism 1051158 1051158 0 0.00 0 20384 5 0 0
srv_make_invnt_saldo 582 582 0 0.00 27 30943 1070 0 0
srv_make_money_saldo 738 738 0 0.00 1 8877 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 133185 360026 217593 0 0
t$perf-abend:sp_add_invoice_to_stock 114 114 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4933 4933 0 0.00 0 11121 152 0 0
t$perf-norm:sp_cancel_adding_invoice 421 421 0 0.00 0 5970 133 0 0
t$perf-norm:sp_cancel_client_order 1732 1732 0 0.00 0 1083 10 0 0
t$perf-norm:sp_cancel_customer_reserve 705 705 0 0.00 0 2000 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 655 655 0 0.00 0 11398 26 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 2169 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 564 13 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 26914 1647 0 0
t$perf-norm:sp_cancel_write_off 981 981 0 0.00 0 1810 10 0 0
t$perf-norm:sp_client_order 20917 20917 0 0.00 0 11176 18 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 2997 12 0 0
t$perf-norm:sp_pay_from_customer 7198 7198 0 0.00 0 7660 10 0 0
t$perf-norm:sp_pay_to_supplier 5877 5877 0 0.00 0 7969 10 0 0
t$perf-norm:sp_reserve_write_off 10033 10033 0 0.00 0 8459 14 0 0
t$perf-norm:sp_supplier_invoice 5525 5525 0 0.00 0 7404 24 0 0
t$perf-norm:sp_supplier_order 5581 5581 0 0.00 0 2267 16 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 159 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 1189 10 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 1370 25 0 0
t$perf-norm:srv_make_money_saldo 738 738 0 0.00 0 920 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10074 9846 228 2.26 0 14683 22 0 228
v_all_customers 38280 38280 0 0.00 0 37 1 0 0
v_all_suppliers 30836 30836 0 0.00 0 86 1 0 0
v_all_wares 41832 41832 0 0.00 0 84 1 0 0
v_cancel_adding_invoice 842 842 0 0.00 0 1588 9 0 0
v_cancel_client_order 3464 3464 0 0.00 0 15000 16 0 0
v_cancel_customer_prepayment 1310 1310 0 0.00 0 1527 5 0 0
v_cancel_customer_reserve 1410 1410 0 0.00 0 4162 7 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 180 2 0 0
v_cancel_supplier_invoice 908 880 28 3.08 0 4284 21 0 28
v_cancel_supplier_order 788 788 0 0.00 0 260 3 0 0
v_cancel_write_off 1962 1962 0 0.00 0 14298 19 0 0
v_max_id_clo_ord 5580 5580 0 0.00 0 9141 3 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 2029 11 0 0
v_max_id_ord_sup 5518 5518 0 0.00 0 2547 4 0 0
v_max_non_paid_invoice 1557 1557 0 0.00 0 4726 6 0 0
v_max_non_paid_realizn 3819 3819 0 0.00 0 4719 7 0 0
v_min_id_clo_ord 5580 5580 0 0.00 0 1812 5 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 8256 21 0 0
v_min_id_ord_sup 5518 5518 0 0.00 0 4859 5 0 0
v_min_non_paid_invoice 5877 5877 0 0.00 0 13242 16 0 0
v_min_non_paid_realizn 7198 7198 0 0.00 0 6374 14 0 0
v_our_firm 10310 10310 0 0.00 0 15 1 0 0
v_reserve_write_off 20066 20066 0 0.00 0 14403 9 0 0
x_lock_depdocs_on_canc_invoice 11530 11530 0 0.00 0 17960 128 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 7190 368 0 0
x_make_qstorno_1000_1200 5581 5581 0 0.00 2 31822 1321 0 0
x_make_qstorno_1200_2000 5525 5525 0 0.00 2 78430 3100 0 0
x_make_qstorno_2100_3300 454981 454981 0 0.00 0 63831 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-02-2021 01:28:06 to 08-02-2021 01:28:10.

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:21 124 8192000000 8842977760 8865226752 23786928 0.289 4 4 6 0 24109264 97792 224544
22:57:28 13996 8192000000 10204013456 10501353472 870072544 9.601 72 58 117 1 893576784 2664192 20840048
22:57:50 12707 8192000000 10291496944 10603048960 1334662544 14.009 100 83 166 0 1366934192 4176128 28095520
22:58:11 34774 8192000000 10359881392 10678812672 1402963488 14.621 100 78 156 0 1433638016 5689008 24985520
22:58:55 28651 8192000000 10392163424 10714288128 1440267904 14.952 100 90 180 1 1476792704 7184288 29340512
22:59:34 27603 8192000000 10413638912 10741993472 1467844816 15.195 100 86 172 0 1503806800 8228032 27733952
23:00:14 4680 8192000000 10433655360 10762997760 1490217936 15.391 100 92 184 0 1528894192 9153248 29523008
23:00:29 13168 8192000000 10446482960 10779045888 1496281232 15.444 100 89 178 0 1534021360 9442720 28297408
23:01:09 22146 8192000000 10479192144 10818232320 1531991280 15.754 100 87 174 0 1569316960 10112624 27213056
23:01:41 18666 8192000000 10488820288 10832248832 1545008576 15.867 100 86 172 1 1582494576 10664912 26821088
23:02:09 17558 8192000000 10514269840 10861486080 1573098176 16.109 100 87 174 1 1610260560 10392176 26770208
23:02:34 12277 8192000000 10524970224 10879627264 1586351984 16.223 100 78 156 0 1621466224 10596896 24517344
23:02:54 14031 8192000000 10560533808 10919260160 1625574848 16.557 100 78 156 0 1659545648 10852768 23118032
23:03:18 7699 8192000000 10580594032 10938908672 1641148912 16.689 100 79 157 2 1676376880 11846976 23380992
23:03:35 10405 8192000000 10593311520 10956304384 1655075360 16.807 100 75 150 3 1689119584 12314224 21730000
23:03:54 9198 8192000000 10612385216 10978553856 1668417216 16.920 100 79 156 2 1703060448 11994464 22648768
23:04:19 8110 8192000000 10635855216 11006230528 1696266368 17.154 100 82 164 2 1733329760 13203520 23859872
23:04:34 6399 8192000000 10648948336 11023392768 1713977792 17.302 100 68 137 3 1745475712 11919552 19578368
23:04:48 7457 8192000000 10666949936 11046334464 1733087056 17.461 100 76 152 1 1766876368 11720544 22068768
23:05:03 5214 8192000000 10683255664 11065249792 1747535568 17.581 100 76 152 1 1780906528 11972656 21398304
23:05:15 6283 8192000000 10686984672 11066208256 1753903056 17.634 100 75 150 3 1787268096 11948400 21416640
23:05:28 6116 8192000000 10700270688 11084984320 1770990448 17.775 100 80 158 2 1806090416 12903152 22196816
23:05:42 10734 8192000000 10710572160 11090239488 1773802720 17.798 100 72 144 0 1807306304 12924608 20578976
23:06:01 4024 8192000000 10736144544 11120541696 1797002320 17.989 100 80 160 1 1832646736 13101200 22543216
23:06:11 3146 8192000000 10749320832 11133288448 1809712368 18.094 100 84 168 1 1847119264 13841920 23564976
23:06:21 3901 8192000000 10749304864 11134582784 1813279504 18.123 100 81 162 0 1850057792 13977856 22800432
23:06:32 2914 8192000000 10763338240 11144601600 1819676576 18.175 100 91 182 2 1861243840 14703104 26864160
23:06:42 2683 8192000000 10762943008 11148271616 1825129824 18.220 100 93 187 2 1864466592 13148608 26188160
23:06:51 3074 8192000000 10771274224 11157291008 1829252080 18.253 100 92 184 1 1868518176 13125024 26141072
23:07:01 2648 8192000000 10770677808 11160256512 1833518768 18.288 100 81 162 2 1869163120 13143216 22501136
23:07:11 2031 8192000000 10781049568 11167428608 1840966624 18.349 100 90 178 1 1879822816 13478592 25377600
23:07:20 2321 8192000000 10774742080 11167350784 1843954480 18.373 100 85 172 2 1879624784 12264736 23405568
23:07:28 2489 8192000000 10794098208 11178655744 1846043552 18.390 100 89 176 2 1885427280 13496672 25887056
23:07:37 2230 8192000000 10796588688 11185139712 1853259408 18.449 100 91 182 1 1892104288 13108528 25736352
23:07:46 2004 8192000000 10799209168 11189637120 1858956352 18.495 100 90 180 2 1897827920 13791728 25079840
23:07:55 2144 8192000000 10804334480 11192115200 1860123440 18.504 100 93 187 2 1899308624 12913920 26271264
23:08:03 2970 8192000000 10811360304 11196305408 1864104960 18.537 100 96 193 3 1904718992 13574064 27039968
23:08:13 1944 8192000000 10813389280 11199045632 1866401360 18.555 100 93 185 3 1906542112 14622528 25518224
23:08:22 3156 8192000000 10807857936 11198730240 1867286992 18.562 100 89 178 0 1905810912 13907600 24616320
23:08:33 2829 8192000000 10818779888 11205496832 1867427168 18.563 100 84 169 1 1904911072 14212432 23271472
23:08:42 2052 8192000000 10808189728 11199819776 1870940416 18.592 100 93 188 0 1909829552 12779616 26109520
23:08:50 2301 8192000000 10814365840 11207970816 1875495648 18.629 100 88 175 0 1913201328 13225136 24480544
23:08:59 11169 8192000000 10778497888 11197464576 1866499520 18.556 100 61 122 0 1896294896 12849472 16945904
23:09:35 2740 8192000000 10807408944 11208994816 1873233888 18.610 100 77 154 2 1905683328 9734064 22715376
23:09:45 2463 8192000000 10806654800 11206230016 1872146944 18.602 100 69 136 1 1900818848 9963904 18708000
23:09:54 3622 8192000000 10788758352 11206692864 1871272800 18.595 100 48 96 1 1895560752 10687392 13600560
23:10:06 7343 8192000000 10787720688 11208957952 1872514048 18.605 100 44 87 2 1894646240 9859888 12272304
23:10:24 6141 8192000000 10801032704 11211689984 1874011584 18.617 100 39 78 1 1892597648 8045744 10540320
23:10:37 3272 8192000000 10808575072 11214028800 1880638656 18.670 100 42 85 1 1899507536 8113856 10755024
23:10:47 6320 8192000000 10795367408 11216478208 1878546720 18.653 100 35 70 2 1897601632 8593008 10461904
23:11:02 5390 8192000000 10793006224 11219816448 1880683888 18.671 100 28 56 1 1895694176 6993456 8016832
23:11:14 10003 8192000000 10809588400 11221745664 1885108496 18.706 100 26 51 2 1898974384 6468480 7397408
23:11:31 14987 8192000000 10807173472 11229941760 1891225600 18.756 100 31 62 0 1906122016 6546880 8349536
23:11:54 56678 8192000000 10842105680 11247861760 1899798864 18.825 100 49 97 2 1923935248 9592448 14543936
23:12:57 11430 8192000000 10807318896 11242082304 1899383920 18.821 100 35 70 1 1916957344 7904464 9668960
23:13:15 5672 8192000000 10820231344 11245305856 1898411360 18.814 100 23 46 1 1911357280 6914944 6030976
23:13:30 6290 8192000000 10818081392 11246125056 1900884768 18.833 100 34 68 0 1918563616 7977168 9701680
23:13:45 5731 8192000000 10827950880 11250454528 1906306736 18.877 100 41 82 0 1926021344 8087104 11627504
23:13:57 9378 8192000000 10820262864 11245383680 1904930752 18.866 100 25 50 0 1917811488 5921232 6959504
23:14:13 6860 8192000000 10819358848 11253481472 1912791456 18.929 100 47 94 2 1932653248 6050656 13811136
23:14:27 8823 8192000000 10828167280 11256696832 1909586640 18.903 100 28 56 1 1923999072 6835312 7577120
23:14:44 8894 8192000000 10833950336 11261878272 1913193680 18.932 100 27 54 0 1928163888 7633232 7336976
23:14:59 10590 8192000000 10831535440 11262083072 1912533152 18.927 100 30 58 2 1926663200 6041664 8088384
23:15:16 7328 8192000000 10831720736 11264212992 1915681712 18.952 100 20 40 1 1927718736 5922464 6114560
23:15:30 8312 8192000000 10831217296 11260801024 1914435328 18.942 100 13 26 1 1923586960 4893312 4258320
23:15:46 8957 8192000000 10829978576 11258990592 1902184304 18.844 99 34 68 2 1917249104 5947952 9116848
23:16:01 61977 8192000000 10819992544 11252924416 1877716256 18.647 98 25 50 1 1891028208 6230048 7081904
23:17:10 9714 8192000000 10824812384 11252801536 1891647120 18.759 99 37 74 0 1913540240 11572288 10320832
23:17:26 5168 8192000000 10829050768 11255947264 1907144992 18.884 100 35 70 1 1924658432 7584784 9928656
23:17:38 4176 8192000000 10797425168 11220881408 1877002208 18.641 99 36 73 0 1894951040 7146304 10802528
23:17:49 5216 8192000000 10804955840 11229593600 1857059216 18.479 98 27 54 3 1870761632 5990336 7712080
23:18:02 6029 8192000000 10800688272 11240472576 1876560576 18.637 99 28 56 2 1895748688 11486976 7701136
23:18:16 6867 8192000000 10783621728 11208151040 1865852464 18.551 99 33 65 1 1880759424 5673552 9233408
23:18:31 8077 8192000000 10792600992 11220471808 1878723504 18.655 100 26 53 2 1892334096 6398096 7212496
23:18:46 6375 8192000000 10741948704 11158937600 1793587952 17.961 97 34 69 1 1810665904 6766752 10311200
23:19:01 4058 8192000000 10722165216 11136204800 1771162928 17.777 97 37 74 2 1787720880 5930976 10626976
23:19:14 6393 8192000000 10721671552 11130269696 1773194160 17.793 97 30 60 1 1786881280 5576288 8110832
23:19:28 6857 8192000000 10705593344 11126288384 1765399840 17.729 97 21 42 0 1777109856 5810656 5899360
23:19:44 8890 8192000000 10705033424 11119325184 1730627440 17.441 95 18 36 0 1740434752 4794800 5012512
23:20:01 8709 8192000000 10670555856 11084713984 1625656736 16.558 90 15 30 0 1635115984 5321600 4137648
23:20:16 14549 8192000000 10706746176 11120025600 1759012800 17.676 98 31 62 0 1773731664 5864592 8854272
23:20:37 72330 8192000000 10680857840 11099992064 1626800464 16.568 91 18 35 1 1636833552 4202128 5830960
23:21:57 5271 8192000000 10697268480 11112980480 1786164000 17.900 100 26 52 0 1799807888 6632528 7011360
23:22:09 4832 8192000000 10703191248 11119386624 1777455792 17.829 99 40 80 2 1795965264 6420544 12088928
23:22:22 6666 8192000000 10704637520 11110236160 1727599360 17.416 96 39 79 2 1745990336 6794544 11596432
23:22:36 4537 8192000000 10698966928 11107008512 1778406352 17.836 100 36 73 0 1794926544 6168848 10351344
23:22:48 8848 8192000000 10717969168 11131744256 1798750480 18.004 100 33 66 2 1814131904 5181088 10200336
23:23:03 7101 8192000000 10726498528 11138961408 1804514112 18.051 100 32 63 1 1819602912 6430048 8658752
23:23:16 5614 8192000000 10741848288 11160555520 1819150160 18.171 100 34 68 3 1839664800 10352032 10162608
23:23:30 6132 8192000000 10743301424 11157630976 1809897264 18.095 99 30 60 0 1825112496 5943648 9271584
23:23:44 9290 8192000000 10734902928 11156762624 1824536608 18.215 100 31 62 1 1844551872 10399472 9615792
23:24:03 13878 8192000000 10757025472 11166162944 1830895488 18.267 100 36 70 2 1851278080 9414656 10967936
23:24:24 12621 8192000000 10739687664 11164581888 1830184560 18.261 100 20 40 0 1841611200 5169744 6256896
23:24:43 6069 8192000000 10751789008 11172986880 1835377952 18.303 100 28 56 1 1850158800 6839136 7941712
23:25:00 12527 8192000000 10754110384 11173748736 1838458368 18.328 100 17 34 2 1849166528 5471072 5237088
23:25:19 61871 8192000000 10761182144 11184713728 1851919328 18.438 100 62 126 5 1876129136 5366256 18843552
23:26:32 10585 8192000000 10771968832 11191508992 1851701488 18.436 100 23 46 1 1864069360 5997184 6370688
23:26:48 8896 8192000000 10770699232 11190464512 1852508080 18.442 100 31 61 1 1866664832 6172384 7984368
23:27:05 5740 8192000000 10784809456 11202555904 1863891824 18.535 100 37 72 1 1880640672 7176960 9571888
23:27:23 50264 8192000000 10805666912 11226791936 1883353680 18.692 100 30 60 2 1897070960 5201472 8515808
23:28:21 5509 8192000000 10840512656 11251974144 1898594176 18.815 100 52 105 1 1925542192 12032592 14915424
23:28:39 22054 8192000000 10848569488 11258269696 1910049392 18.907 100 57 114 1 1936490128 10383712 16057024
23:29:11 8007 8192000000 10844250960 11260489728 1915544528 18.951 100 62 124 1 1944362208 11844752 16972928
23:29:26 16669 8192000000 10836552976 11265249280 1917149952 18.964 100 62 124 1 1945091808 10891968 17049888
23:30:00 29008 8192000000 10852326432 11274670080 1918767408 18.977 100 42 83 1 1942037728 11645216 11625104
23:30:36 9403 8192000000 10865202960 11283283968 1924439504 19.022 100 45 89 1 1948027536 10661664 12926368
23:30:52 4104 8192000000 10866401776 11283529728 1926830432 19.042 100 45 90 0 1952143744 12000192 13313120
23:31:10 20830 8192000000 10870952688 11288268800 1933575792 19.095 100 52 104 0 1962253520 13632272 15045456
23:31:39 66027 8192000000 10869014848 11302428672 1932898784 19.090 100 38 75 1 1958138528 14321296 10918448
23:33:01 24027 8192000000 10872169712 11306262528 1941489952 19.159 100 43 86 0 1972298368 18654304 12154112
23:33:44 14608 8192000000 10874796880 11308810240 1945233440 19.188 100 36 72 1 1968501808 12679536 10588832
23:34:07 33968 8192000000 10884817296 11330359296 1957189568 19.284 100 39 78 0 1987926352 18571040 12165744
23:34:51 20162 8192000000 10906697728 11335491584 1947198688 19.204 99 45 89 0 1976600848 16226352 13175808
23:35:20 6341 8192000000 10908305520 11339939840 1971307728 19.396 100 55 110 0 2008029120 19809568 16911824
23:35:37 2755 8192000000 10918855584 11344498688 1973848832 19.416 100 59 116 1 2011177056 20327008 17001216
23:35:50 9395 8192000000 10919437680 11350970368 1977190864 19.442 100 55 108 2 2015125648 21705136 16229648
23:36:07 2582 8192000000 10947643296 11356614656 1985093776 19.505 100 72 143 1 2027830624 22002864 20733984
23:36:16 3244 8192000000 10948872896 11365928960 1987123184 19.521 100 66 131 0 2029457376 23108112 19226080
23:36:29 6867 8192000000 10935444144 11356450816 1979325280 19.459 100 61 122 1 2020753536 23975888 17452368
23:36:46 11195 8192000000 10937063152 11362033664 1985147344 19.505 100 63 126 2 2028668048 24506768 19013936
23:37:09 13726 8192000000 10934290480 11367415808 1987265952 19.522 100 50 98 2 2025040240 23714656 14059632
23:37:33 6382 8192000000 10943891536 11373215744 1991475488 19.555 100 55 110 2 2031252080 23806336 15970256
23:37:46 3874 8192000000 10946172192 11374428160 1995248512 19.585 100 55 107 0 2035231072 23301840 16680720
23:37:58 7889 8192000000 10960279056 11382304768 2001253088 19.633 100 66 133 2 2045978288 25285280 19439920
23:38:19 3965 8192000000 10957621216 11387928576 2002820592 19.645 100 55 110 0 2044405600 25586992 15998016
23:38:30 5589 8192000000 10964068464 11386327040 2007609488 19.683 100 74 146 0 2055604480 26125696 21869296
23:38:49 7415 8192000000 10951967600 11383660544 1988019328 19.528 99 56 111 2 2032080688 27002736 17058624
23:39:06 3838 8192000000 10930354528 11355389952 1973589392 19.414 99 52 103 1 2013871808 25344832 14937584
23:39:19 7766 8192000000 10952127232 11377827840 1977907200 19.448 99 65 129 1 2025355808 27787696 19660912
23:39:35 4312 8192000000 10946517184 11370496000 1987399872 19.523 100 71 138 2 2037501248 29211936 20889440
23:39:47 3826 8192000000 10959939664 11379437568 1995380656 19.586 100 74 146 1 2047421168 29516992 22523520
23:39:59 1365 8192000000 10965641952 11381374976 1997243840 19.601 100 73 142 1 2048266352 29330240 21692272
23:40:07 2707 8192000000 10969269792 11387461632 2004266336 19.656 100 80 158 1 2059003072 29979040 24757696
23:40:17 4547 8192000000 10941377600 11362115584 1980697680 19.470 100 82 162 0 2036278848 30477872 25103296
23:40:30 3211 8192000000 10951928496 11367911424 1983603872 19.493 100 72 144 2 2035193216 29614544 21974800
23:40:41 2814 8192000000 10954469408 11374149632 1986330336 19.515 100 84 166 2 2042186704 30191856 25664512
23:40:50 3905 8192000000 10930566256 11344871424 1936092160 19.116 98 76 152 0 1990568064 31653920 22821984
23:41:02 1764 8192000000 10930441392 11346632704 1956479424 19.278 99 80 158 3 2011813824 30785312 24549088
23:41:11 4779 8192000000 10935759856 11355557888 1967446880 19.365 100 72 140 2 2020503264 32443776 20612608
23:41:28 3348 8192000000 10951565456 11369758720 1980612464 19.470 100 86 170 3 2038915616 32123824 26179328
23:41:37 2774 8192000000 10945176336 11373768704 1983264592 19.491 100 79 153 0 2037870704 31024912 23581200
23:41:48 7982 8192000000 10912364416 11343732736 1937414896 19.126 98 63 126 2 1986662016 29750544 19496576
23:42:06 2662 8192000000 10935987248 11362234368 1970881840 19.392 100 64 128 0 2021693408 30997824 19813744
23:42:16 2575 8192000000 10949017232 11373498368 1983136832 19.490 100 68 136 0 2036089456 32119072 20833552
23:42:26 2628 8192000000 10950450384 11367710720 1975503328 19.429 100 74 148 0 2031604864 33084672 23016864
23:42:36 7242 8192000000 10942694032 11365289984 1974428432 19.421 100 72 144 0 2030199472 33691248 22079792
23:42:52 1913 8192000000 10963808000 11386417152 1990087408 19.544 100 77 154 1 2046537152 33043952 23405792
23:43:02 3196 8192000000 10967936000 11384049664 1988074528 19.529 100 85 170 2 2051656192 37560752 26020912
23:43:15 3375 8192000000 10966320128 11384492032 1971572896 19.398 99 83 165 2 2035003712 38776368 24654448
23:43:26 1242 8192000000 10974032176 11385110528 1987293296 19.522 100 88 174 0 2053305104 39990512 26021296
23:43:34 3232 8192000000 10965341840 11378470912 1980336512 19.467 100 90 179 0 2048703344 40650816 27716016
23:43:44 3792 8192000000 10959554720 11381723136 1980587616 19.469 100 73 145 1 2044300160 41503680 22208864
23:43:55 7779 8192000000 10964200592 11385380864 1983701328 19.494 100 72 144 0 2046442112 40471552 22269232
23:44:12 8552 8192000000 10947260144 11380715520 1966006976 19.354 99 57 114 0 2025949792 41865600 18077216
23:44:31 3441 8192000000 10939220592 11365990400 1962232960 19.324 100 62 123 1 2025536768 43939792 19364016
23:44:42 2897 8192000000 10949936784 11367911424 1965189888 19.347 100 81 163 2 2036528128 44995920 26342320
23:44:52 1942 8192000000 10947248576 11365351424 1963509136 19.334 100 81 162 1 2033166592 43719760 25937696
23:45:01 3373 8192000000 10945728384 11370635264 1970664640 19.391 100 80 158 1 2038451120 43625088 24161392
23:45:15 9769 8192000000 10915180992 11352731648 1932419920 19.086 99 43 86 1 1992379488 45787696 14171872
23:45:36 7602 8192000000 10937710544 11358429184 1951601312 19.239 100 66 130 1 2013367504 41248896 20517296
23:45:54 3097 8192000000 10955234864 11370352640 1965000400 19.346 100 67 133 0 2030076528 44428640 20647488
23:46:04 2642 8192000000 10976829136 11387547648 1982250992 19.483 100 88 173 0 2053230240 44216416 26762832
23:46:14 1741 8192000000 10974782784 11388137472 1980966176 19.472 100 83 163 2 2052201760 45611680 25623904
23:46:23 4033 8192000000 10951679216 11372773376 1966723360 19.359 100 76 152 1 2037407472 46510912 24173200
23:46:35 2570 8192000000 10951537328 11377848320 1963554976 19.334 100 72 144 1 2031924192 46594272 21774944
23:46:47 13968 8192000000 10919471312 11353186304 1933468720 19.095 99 41 80 1 1995741840 48445024 13828096
23:47:20 6349 8192000000 10935686336 11367272448 1955698448 19.272 100 49 98 1 2020998800 49584016 15716336
23:48:08 2623 8192000000 10924626720 11333136384 1908042176 18.891 97 77 152 1 1986726736 54171408 24513152
23:48:19 1564 8192000000 10939078592 11351855104 1944005680 19.179 100 79 158 0 2023744240 55004624 24733936
23:48:32 2815 8192000000 10950763120 11360735232 1933068608 19.091 99 78 158 1 2014200464 56162240 24969616
23:48:42 991 8192000000 10968102784 11375808512 1955471392 19.270 100 93 188 0 2045712880 60353776 29887712
23:48:52 2385 8192000000 10939537296 11360333824 1926143840 19.036 99 65 130 1 2009014480 62046688 20823952
23:49:07 7855 8192000000 10924327280 11356573696 1908061424 18.891 98 46 92 0 1979746304 55955536 15729344
23:49:23 8678 8192000000 10920802400 11359584256 1928271648 19.053 99 42 85 1 1997896208 54650544 14974016
23:49:39 9618 8192000000 10928794736 11360980992 1946209472 19.196 100 43 86 2 2011020672 49762752 15048448
23:49:55 8441 8192000000 10920737088 11353792512 1953443280 19.254 100 45 86 0 2002360400 35562784 13354336
23:50:11 22299 8192000000 10925144576 11351343104 1940536656 19.151 99 44 85 2 1989443424 35621216 13285552
23:50:42 7163 8192000000 10926983616 11356930048 1956329136 19.277 100 57 112 2 2012062640 37480704 18252800
23:51:02 18366 8192000000 10928999056 11369463808 1962254288 19.324 100 35 70 1 2015787504 41622784 11910432
23:51:45 8963 8192000000 10929834224 11368591360 1959637136 19.303 100 35 71 0 2014553376 43136256 11779984
23:52:02 17846 8192000000 10930685264 11375845376 1962610304 19.327 100 33 66 1 2020752256 46863456 11278496
23:52:39 26989 8192000000 10920114144 11370618880 1948347840 19.213 100 28 56 0 2006609280 48253792 10007648
23:53:13 14150 8192000000 10923746576 11369324544 1946542448 19.199 100 28 56 1 2008016480 51151584 10322448
23:53:58 16559 8192000000 10914610064 11368046592 1939746592 19.145 100 26 52 1 2002618544 53018512 9853440
23:54:22 17628 8192000000 10869916000 11325513728 1894063424 18.779 98 22 41 1 1951651664 49965808 7622432
23:54:47 21148 8192000000 10897471072 11351764992 1919124800 18.980 100 18 36 2 1976910176 50984720 6800656
23:55:16 22956 8192000000 10894864736 11353128960 1904825712 18.865 99 28 55 2 1967999696 54189936 8984048
23:57:05 78384 8192000000 10862850480 11335831552 1910938448 18.914 99 12 24 0 1944300048 29723248 3638352
23:58:36 87248 8192000000 10876001424 11333849088 1911715616 18.920 98 8 16 0 1926266368 12403392 2147360
00:00:41 128679 8192000000 10897576592 11381960704 1961497856 19.318 100 12 24 0 1983665696 18740544 3427296
00:02:57 4349 8192000000 10924089184 11389304832 1977848656 19.448 100 34 68 1 2008659184 20485936 10324592
00:03:08 30807 8192000000 10911158032 11376603136 1978293440 19.451 100 19 38 1 2006181264 22284000 5603824
00:03:55 53359 8192000000 10915951168 11379695616 1964438080 19.341 99 40 79 3 1998580256 21966256 12175920
00:04:59 63356 8192000000 10927298576 11381010432 1979783232 19.463 100 29 58 0 2009683072 20298368 9601472
00:06:16 57028 8192000000 10907825712 11390234624 1975535168 19.429 100 9 18 0 2000882976 22764656 2583152
00:07:21 23302 8192000000 10902179808 11392155648 1974752832 19.423 100 7 14 0 2000644912 23865552 2026528
00:08:05 15331 8192000000 10906690960 11391373312 1969593632 19.382 100 5 10 0 1999829104 28636000 1599472
00:08:34 44120 8192000000 10886447392 11375325184 1952109024 19.243 99 13 25 1 1970728192 15170960 3448208
00:10:01 63085 8192000000 10896359424 11362897920 1968119360 19.371 100 17 34 0 1982095248 9140960 4834928
00:11:11 78566 8192000000 10894986752 11379183616 1961752064 19.320 99 10 20 0 1977679184 13134640 2792480
00:12:38 60545 8192000000 10906607104 11382874112 1980143920 19.466 100 17 35 1 1994385312 9188864 5052528
00:13:49 101067 8192000000 10895147792 11362516992 1927348416 19.046 97 34 69 1 1949741296 12249056 10143824
00:15:38 60199 8192000000 10914021344 11378397184 1974431568 19.421 100 21 42 0 1989922016 9837440 5653008
00:16:53 35714 8192000000 10918694048 11383828480 1991705952 19.557 100 35 70 1 2013953552 11591440 10656160
00:17:38 6288 8192000000 10922825008 11385995264 1993186592 19.569 100 32 64 0 2015172224 12947520 9038112
00:17:55 8825 8192000000 10925046064 11393851392 1995897728 19.590 100 28 57 3 2019879104 15784560 8196816
00:18:12 14212 8192000000 10910636096 11388604416 1987465616 19.524 100 21 42 0 2010654656 16569152 6619888
00:18:41 26869 8192000000 10914860400 11387793408 1989329840 19.538 100 16 33 1 2008629424 14327568 4972016
00:19:25 59399 8192000000 10921154560 11406905344 1994389072 19.578 100 14 28 1 2012527008 14233344 3904592
00:20:37 45762 8192000000 10920679056 11408887808 1997445760 19.603 100 8 16 0 2021343392 21568112 2329520
00:21:37 65352 8192000000 10918638160 11398283264 1964167792 19.339 98 22 44 1 1986093472 15866048 6059632
00:22:54 80270 8192000000 10914727872 11404795904 1993085488 19.568 100 13 24 2 2011361776 14933600 3342688
00:24:34 66568 8192000000 10911803312 11388641280 1936640368 19.120 97 12 24 0 1951194896 10989136 3565392
00:25:47 73623 8192000000 10898204096 11373137920 1946956192 19.202 98 9 18 0 1961698688 11793184 2949312
00:27:11 18437 8192000000 10923924720 11381776384 1979062944 19.457 99 48 90 1 2000573056 8003072 13507040
00:27:38 48960 8192000000 10913714880 11387129856 1954796848 19.265 98 39 79 0 1975064896 9558272 10709776
00:28:38 104178 8192000000 10901275792 11370754048 1915784640 18.953 96 11 22 0 1927426944 9077216 2565088
00:30:31 117418 8192000000 10912387904 11359014912 1838009472 18.325 92 14 28 1 1851562176 9590224 3962480
00:32:35 25161 8192000000 10881081648 11338235904 1891176992 18.755 96 30 60 1 1908382880 8362848 8843040
00:33:11 31661 8192000000 10907552320 11360280576 1945121792 19.188 99 44 88 1 1973478784 16508896 11848096
00:33:51 54720 8192000000 10864889056 11331866624 1847533696 18.402 94 30 60 1 1872506480 16745600 8227184
00:34:57 75979 8192000000 10889779440 11347918848 1889027744 18.738 97 21 42 1 1905266080 10709792 5528544
00:36:20 56720 8192000000 10876868944 11344588800 1921002800 18.995 98 18 36 1 1937855312 12154560 4697952
00:37:24 104004 8192000000 10879551696 11346669568 1863756336 18.534 95 17 34 0 1880251792 11888960 4606496
00:39:15 107435 8192000000 10834429248 11308630016 1819462992 18.173 94 6 12 0 1840694704 19714368 1517344
00:41:24 57254 8192000000 10856404192 11298148352 1897713744 18.808 99 34 68 1 1917150528 9557248 9879536
00:42:30 54049 8192000000 10846743776 11302363136 1862930880 18.527 97 25 50 2 1879071200 8413440 7726880
00:43:33 40177 8192000000 10868785184 11316158464 1929112400 19.060 100 44 88 1 1952084304 10190352 12781552
00:44:23 16816 8192000000 10813920624 11263655936 1863392400 18.531 97 32 64 0 1881466048 9452192 8621456
00:44:47 28283 8192000000 10840881968 11289632768 1895309440 18.789 99 34 68 1 1917269824 12363056 9597328
00:45:31 60783 8192000000 10814832912 11279806464 1859394368 18.498 97 20 40 0 1876186544 11264240 5527936
00:46:38 85236 8192000000 10860026368 11326382080 1901121424 18.835 99 13 26 0 1921250256 15831088 4297744
00:48:09 38517 8192000000 10866758192 11336347648 1933497008 19.095 100 22 44 2 1957345152 17285680 6562464
00:49:04 60496 8192000000 10868206048 11346104320 1938579280 19.135 100 9 18 0 1959333888 17945008 2809600
00:50:38 69433 8192000000 10861679152 11342069760 1902074560 18.843 98 21 42 3 1927207552 18920640 6212352
00:51:53 127616 8192000000 10872661824 11345920000 1881826848 18.680 97 9 18 2 1899129744 14644480 2658416
00:54:12 112274 8192000000 10869138032 11321749504 1881311376 18.676 97 15 30 1 1900083440 14481872 4290192
00:56:14 18329 8192000000 10901126912 11339112448 1948084192 19.211 100 49 98 0 1970258832 8704208 13470432
00:56:41 22137 8192000000 10897931712 11353337856 1956203520 19.276 100 57 114 3 1986319424 14024656 16091248
00:57:11 96810 8192000000 10848308912 11315691520 1841383232 18.352 94 20 41 0 1860945616 14264224 5298160
00:58:54 41551 8192000000 10880691008 11332075520 1916204688 18.956 98 34 64 1 1934538112 8496688 9836736
00:59:42 40750 8192000000 10902434176 11344281600 1910185232 18.908 98 31 59 2 1926202720 7978368 8039120
01:00:32 37978 8192000000 10901772080 11354918912 1958340656 19.293 100 37 74 3 1979949888 11437792 10171440
01:01:20 63526 8192000000 10892014160 11363274752 1922675728 19.008 98 20 40 2 1941355456 12979056 5700672
01:02:29 89782 8192000000 10894226832 11351187456 1908315472 18.893 97 23 46 0 1928040560 13881248 5843840
01:04:05 66626 8192000000 10897346128 11376857088 1942667872 19.168 99 24 47 0 1964835840 16013952 6154016
01:05:18 137859 8192000000 10883618800 11357069312 1910600880 18.911 97 14 29 0 1930474144 16143984 3729280
01:07:42 63831 8192000000 10903685968 11366834176 1951017024 19.235 99 27 54 1 1970556176 12314832 7224320
01:10:20 22042 8192000000 10888534000 11352895488 1945643856 19.192 99 27 54 3 1958895504 5389920 7861728
01:11:19 97192 8192000000 10896197216 11369406464 1956149088 19.275 99 10 20 1 1969997200 10605952 3242160
01:13:03 103506 8192000000 10912774656 11387400192 1967266656 19.364 99 20 40 0 1987352672 14005184 6080832
01:14:55 100878 8192000000 10896916752 11387453440 1954532896 19.263 99 13 26 0 1972124224 13977072 3614256
01:16:43 54332 8192000000 10879736112 11362746368 1914508240 18.943 97 12 24 0 1929883792 11972592 3402960
01:17:43 28067 8192000000 10873501424 11347898368 1925898368 19.034 98 23 46 0 1939476880 6992400 6586112
01:18:22 40870 8192000000 10873743872 11336691712 1919603664 18.984 98 26 52 2 1936250304 8852032 7794608
01:19:15 40988 8192000000 10881494000 11352571904 1941505488 19.159 99 30 60 2 1960993680 11190080 8298112
01:20:04 37268 8192000000 10898385120 11347251200 1921960128 19.003 98 34 67 3 1944099024 12489680 9649216
01:20:50 15139 8192000000 10902466544 11346202624 1935635776 19.112 99 52 104 0 1962455824 11599632 15220416
01:21:24 61956 8192000000 10850706752 11327975424 1896537312 18.798 98 18 36 1 1915710272 13658880 5514080
01:22:32 117373 8192000000 10879869568 11340337152 1869728368 18.582 96 19 38 0 1887054816 11600736 5725712
01:24:46 64182 8192000000 10880736080 11349676032 1930717776 19.073 99 36 71 2 1953119408 11741856 10659776
01:26:30 59514 8192000000 9297929536 9565057024 439265216 5.089 23 2 4 0 442153760 2763920 124624

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-02-2021 01:28:12 to 08-02-2021 01:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 114 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-02-2021 01:28:44 to 08-02-2021 01:28:46.

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

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