Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.03.2021 22: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 df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17465008 kB
MemAvailable 31476704 kB
Buffers 0 kB
Cached 14176172 kB
SwapCached 0 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-03-24 22:27:24
DTS_END                         2021-03-24 22:27:24.5210
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/36426
TRN_ID                          247320
ATT_ID                          711
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: 9270.86 20495 1112503
customer order: creation 181.67 351 21800
customer order: refuse 15.16 333 1819
order to supplier: creation 48.05 1283 5766
order to supplier: removal 3.53 88235 424
invoice (draft): creation 49.22 3439 5906
invoice (draft): removal 52.58 785 6309
invoice accept: apply 43.62 18318 5234
invoice accept: cancel 47.02 712 5642
customer reserve: creation 3942.62 185 473114
customer reserve: removal 4588.02 52 550562
realization accept: apply 87.93 168 10551
realization accept: cancel 78.12 104 9374
payment from customer: creation 61.97 106 7436
payment from customer: removal 5.54 102 665
payment to supplier: creation 50.01 130 6001
payment to supplier: removal 3.19 72 383
service: total inventory turnovers 4.97 974 597
service: total monetary turnovers 6.69 30 803
service: aggregate perf. data 0.94 16747 113
service: refresh index statistics 0.03 277778 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2021 22:28:21 to 24-03-2021 22:28:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2121
TEST_TIME 2 4548
TEST_TIME 3 4786
TEST_TIME 4 4901
TEST_TIME 5 5994
TEST_TIME 6 6185
TEST_TIME 7 6394
TEST_TIME 8 7141
TEST_TIME 9 7007
TEST_TIME 10 7450
TEST_TIME 11 7215
TEST_TIME 12 7131
TEST_TIME 13 7262
TEST_TIME 14 7437
TEST_TIME 15 7614
TEST_TIME 16 8227
TEST_TIME 17 8377
TEST_TIME 18 8789
TEST_TIME 19 9573
TEST_TIME 20 9344
TEST_TIME 21 9333
TEST_TIME 22 9328
TEST_TIME 23 9756
TEST_TIME 24 10301
TEST_TIME 25 10982
TEST_TIME 26 10876
TEST_TIME 27 10650
TEST_TIME 28 10549
TEST_TIME 29 10436
TEST_TIME 30 10469
TEST_TIME 31 10513
TEST_TIME 32 10360
TEST_TIME 33 10120
TEST_TIME 34 10097
TEST_TIME 35 9959
TEST_TIME 36 10153
TEST_TIME 37 10173
TEST_TIME 38 10163
TEST_TIME 39 10090
TEST_TIME 40 9965
TEST_TIME 41 9795
TEST_TIME 42 9820
TEST_TIME 43 9690
TEST_TIME 44 9587
TEST_TIME 45 9666
TEST_TIME 46 9559
TEST_TIME 47 9550
TEST_TIME 48 9525
TEST_TIME 49 9462
TEST_TIME 50 9457
TEST_TIME 51 9645
TEST_TIME 52 9637
TEST_TIME 53 9633
TEST_TIME 54 9631
TEST_TIME 55 9641
TEST_TIME 56 9618
TEST_TIME 57 9797
TEST_TIME 58 9770
TEST_TIME 59 9793
TEST_TIME 60 9656
TEST_TIME 61 9652
TEST_TIME 62 9554
TEST_TIME 63 9526
TEST_TIME 64 9510
TEST_TIME 65 9438
TEST_TIME 66 9436
TEST_TIME 67 9484
TEST_TIME 68 9432
TEST_TIME 69 9486
TEST_TIME 70 9477
TEST_TIME 71 9533
TEST_TIME 72 9496
TEST_TIME 73 9554
TEST_TIME 74 9610
TEST_TIME 75 9617
TEST_TIME 76 9626
TEST_TIME 77 9640
TEST_TIME 78 9653
TEST_TIME 79 9567
TEST_TIME 80 9473
TEST_TIME 81 9474
TEST_TIME 82 9409
TEST_TIME 83 9440
TEST_TIME 84 9388
TEST_TIME 85 9365
TEST_TIME 86 9370
TEST_TIME 87 9365
TEST_TIME 88 9325
TEST_TIME 89 9270
TEST_TIME 90 9353
TEST_TIME 91 9419
TEST_TIME 92 9384
TEST_TIME 93 9404
TEST_TIME 94 9439
TEST_TIME 95 9410
TEST_TIME 96 9435
TEST_TIME 97 9443
TEST_TIME 98 9462
TEST_TIME 99 9458
TEST_TIME 100 9462
TEST_TIME 101 9496
TEST_TIME 102 9480
TEST_TIME 103 9395
TEST_TIME 104 9382
TEST_TIME 105 9352
TEST_TIME 106 9329
TEST_TIME 107 9307
TEST_TIME 108 9334
TEST_TIME 109 9299
TEST_TIME 110 9253
TEST_TIME 111 9217
TEST_TIME 112 9205
TEST_TIME 113 9238
TEST_TIME 114 9266
TEST_TIME 115 9240
TEST_TIME 116 9295
TEST_TIME 117 9295
TEST_TIME 118 9280
TEST_TIME 119 9294
TEST_TIME 120 9281

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-03-2021 22:28:25 to 24-03-2021 22:28:28.

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 1550641 1550641 0 0.00 0 16858 7 0 0
doc_list_biud 1550641 1550641 0 0.00 0 59106 24 0 0
sp_add_invoice_to_stock 5362 5234 128 2.38 42 172597 18319 0 128
sp_cancel_adding_invoice 5642 5642 0 0.00 4 54242 712 0 0
sp_cancel_client_order 1819 1819 0 0.00 4 10072 333 0 0
sp_cancel_customer_reserve 550562 550562 0 0.00 1 27792 53 0 0
sp_cancel_pay_from_customer 665 665 0 0.00 3 8392 102 0 0
sp_cancel_pay_to_supplier 383 383 0 0.00 3 2939 73 0 0
sp_cancel_supplier_invoice 6322 6309 13 0.20 2 59119 786 0 13
sp_cancel_supplier_order 424 424 0 0.00 11 1131053 88236 0 0
sp_cancel_write_off 9374 9374 0 0.00 1 13660 105 0 0
sp_client_order 21800 21800 0 0.00 3 25899 351 0 0
sp_customer_reserve 473114 473114 0 0.00 0 86606 185 0 0
sp_fill_shopping_cart 33472 33472 0 0.00 1 15380 38 0 0
sp_fill_shopping_cart_clo_res 473101 473101 0 0.00 0 20279 15 0 0
sp_get_clo_for_invoice 5213 5213 0 0.00 0 27060 274 0 0
sp_kill_cost_storno 16064 16064 0 0.00 0 8456 50 0 0
sp_kill_qstorno_ret_qs2qd 1117231 1117231 0 0.00 0 59092 29 0 0
sp_kill_qty_storno 589893 589893 0 0.00 0 59100 63 0 0
sp_lock_selected_doc 21673 21673 0 0.00 0 9804 7 0 0
sp_make_cost_storno 29200 29200 0 0.00 0 16853 51 0 0
sp_multiply_rows_for_pdistr 29200 29200 0 0.00 0 6508 27 0 0
sp_multiply_rows_for_qdistr 21800 21800 0 0.00 0 25816 172 0 0
sp_pay_from_customer 7436 7436 0 0.00 4 13948 107 0 0
sp_pay_to_supplier 6001 6001 0 0.00 4 13523 131 0 0
sp_payment_common 13437 13437 0 0.00 1 12209 30 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 7912 287 0 0
sp_qd_handle_on_invoice_upd_sts 10854 10854 0 0.00 0 16287 315 0 0
sp_qd_handle_on_reserve_upd_sts 10551 10551 0 0.00 0 13897 53 0 0
sp_reserve_write_off 10551 10551 0 0.00 6 16932 168 0 0
sp_supplier_invoice 5906 5906 0 0.00 7 118641 3440 0 0
sp_supplier_order 5766 5766 0 0.00 5 56313 1283 0 0
srv_aggregate_perf_data 113 113 0 0.00 3278 169820 16747 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1103 153387 32694 0 0
srv_find_qd_qs_mism 1063028 1063028 0 0.00 0 14320 6 0 0
srv_make_invnt_saldo 597 597 0 0.00 42 45262 974 0 0
srv_make_money_saldo 803 803 0 0.00 1 2143 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 165924 472305 277778 0 0
t$perf-abend:sp_add_invoice_to_stock 128 128 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5234 5234 0 0.00 0 15001 160 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 4567 97 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 4676 16 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 1015 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 665 665 0 0.00 0 6295 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 383 383 0 0.00 0 2865 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 438 438 0 0.00 0 1060 15 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 17185 1411 0 0
t$perf-norm:sp_cancel_write_off 1109 1109 0 0.00 0 1084 3 0 0
t$perf-norm:sp_client_order 21800 21800 0 0.00 0 9886 18 0 0
t$perf-norm:sp_customer_reserve 1071 1071 0 0.00 0 4611 9 0 0
t$perf-norm:sp_pay_from_customer 7436 7436 0 0.00 0 4918 9 0 0
t$perf-norm:sp_pay_to_supplier 6001 6001 0 0.00 0 5445 13 0 0
t$perf-norm:sp_reserve_write_off 10551 10551 0 0.00 0 10016 13 0 0
t$perf-norm:sp_supplier_invoice 5906 5906 0 0.00 0 5521 15 0 0
t$perf-norm:sp_supplier_order 5766 5766 0 0.00 0 5729 17 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 340 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 207 3 0 0
t$perf-norm:srv_make_invnt_saldo 597 597 0 0.00 0 2073 20 0 0
t$perf-norm:srv_make_money_saldo 803 803 0 0.00 0 1233 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 4 5 4 0 0
v_add_invoice_to_stock 10680 10424 256 2.39 0 9444 19 0 256
v_all_customers 38942 38942 0 0.00 0 17 1 0 0
v_all_suppliers 31732 31732 0 0.00 0 157 1 0 0
v_all_wares 43600 43600 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 135 5 0 0
v_cancel_client_order 3638 3638 0 0.00 0 2007 4 0 0
v_cancel_customer_prepayment 1330 1330 0 0.00 0 4690 11 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 985 5 0 0
v_cancel_payment_to_supplier 766 766 0 0.00 0 2019 8 0 0
v_cancel_supplier_invoice 902 876 26 2.88 0 4439 19 0 26
v_cancel_supplier_order 848 848 0 0.00 0 1243 8 0 0
v_cancel_write_off 2218 2218 0 0.00 0 2694 14 0 0
v_max_id_clo_ord 5766 5766 0 0.00 0 302 1 0 0
v_max_id_clo_res 1071 1071 0 0.00 0 4829 18 0 0
v_max_id_ord_sup 5906 5906 0 0.00 0 1609 2 0 0
v_max_non_paid_invoice 1807 1807 0 0.00 0 2554 7 0 0
v_max_non_paid_realizn 4319 4319 0 0.00 0 5418 6 0 0
v_min_id_clo_ord 5766 5766 0 0.00 0 3196 8 0 0
v_min_id_clo_res 1071 1071 0 0.00 0 5807 25 0 0
v_min_id_ord_sup 5906 5906 0 0.00 0 4549 5 0 0
v_min_non_paid_invoice 6001 6001 0 0.00 0 8245 19 0 0
v_min_non_paid_realizn 7436 7436 0 0.00 0 4827 15 0 0
v_our_firm 10892 10892 0 0.00 0 16 1 0 0
v_reserve_write_off 21102 21102 0 0.00 0 2811 5 0 0
x_lock_depdocs_on_canc_invoice 11513 11513 0 0.00 0 10776 105 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 17377 373 0 0
x_make_qstorno_1000_1200 5766 5766 0 0.00 2 56304 1199 0 0
x_make_qstorno_1200_2000 5906 5906 0 0.00 3 115090 3312 0 0
x_make_qstorno_2100_3300 473114 473114 0 0.00 0 86593 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2021 22:28:29 to 24-03-2021 22:28:33.

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
19:57:28 5 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:34 21274 8192000000 10212457600 10523545600 887402880 9.773 71 50 101 0 906382128 2589488 16389760
19:58:04 18162 8192000000 10318486736 10631462912 1368099808 14.310 100 86 172 0 1399771344 4277952 27393584
19:58:33 24619 8192000000 10368694288 10688376832 1416244640 14.739 100 85 170 0 1449952944 5965904 27742400
19:59:08 28517 8192000000 10397088928 10721243136 1447201232 15.013 100 87 174 1 1482352304 6871536 28279536
19:59:48 10161 8192000000 10414544752 10741915648 1472051904 15.232 100 91 181 0 1509309424 7865280 29392240
20:00:12 19184 8192000000 10436377744 10766749696 1491300320 15.400 100 87 174 0 1527673776 8656992 27716464
20:00:45 13500 8192000000 10447398368 10780241920 1499119808 15.469 100 82 164 0 1534323056 9069344 26133904
20:01:17 15339 8192000000 10470628240 10809184256 1521862864 15.666 100 85 170 0 1558395776 9733808 26799104
20:01:50 20209 8192000000 10506686496 10851610624 1554989296 15.953 100 78 156 1 1589052992 9876320 24187376
20:02:23 16751 8192000000 10530779680 10883858432 1584626768 16.208 100 72 145 0 1616284240 9810800 21846672
20:02:47 12798 8192000000 10573941040 10928197632 1622629408 16.532 100 84 168 1 1659650160 11095568 25925184
20:03:09 12670 8192000000 10581761488 10940932096 1638544384 16.667 100 80 160 2 1674630384 12121936 23964064
20:03:29 11386 8192000000 10599214048 10965377024 1653147712 16.791 100 73 146 3 1686981664 11973232 21860720
20:03:48 9380 8192000000 10617465344 10986835968 1680801712 17.024 100 72 144 0 1713536384 11825008 20909664
20:04:05 8198 8192000000 10652489936 11018895360 1707091568 17.244 100 85 170 1 1744511168 11956528 25463072
20:04:20 8070 8192000000 10664692640 11036717056 1720552000 17.357 100 85 170 2 1758096880 12667392 24877488
20:04:35 8355 8192000000 10679653520 11057512448 1744784176 17.558 100 77 153 0 1778815120 12526224 21504720
20:04:51 6328 8192000000 10687897968 11067146240 1752133616 17.619 100 77 155 0 1786076144 12134720 21807808
20:05:04 5926 8192000000 10695802512 11079798784 1764805296 17.724 100 77 151 1 1797814896 11231168 21778432
20:05:18 4706 8192000000 10717852272 11098193920 1779771648 17.848 100 85 170 0 1816828064 12395360 24661056
20:05:30 3812 8192000000 10717294864 11098816512 1782594672 17.871 100 78 156 1 1817157664 13399488 21163504
20:05:40 2884 8192000000 10725156784 11108761600 1788818624 17.922 100 82 164 1 1825275584 13346176 23110784
20:05:50 2561 8192000000 10739530272 11120791552 1795103648 17.974 100 84 160 2 1830349712 12157760 23088304
20:05:59 3475 8192000000 10743320256 11124203520 1806559088 18.068 100 79 157 2 1840320320 12160720 21600512
20:06:10 3347 8192000000 10740093216 11129544704 1810306656 18.098 100 77 154 0 1844557536 12458736 21792144
20:06:20 2469 8192000000 10754978784 11135860736 1815332048 18.140 100 87 174 2 1853397616 13974432 24091136
20:06:29 3173 8192000000 10759277888 11140415488 1819007680 18.170 100 89 179 1 1858834176 14518080 25308416
20:06:39 5152 8192000000 10753047760 11138691072 1819360752 18.172 100 78 156 3 1855353536 13976112 22016672
20:06:51 4467 8192000000 10783056560 11167866880 1829841648 18.258 100 85 167 3 1864940576 12366608 22732320
20:07:02 2320 8192000000 10786667120 11173093376 1844367392 18.376 100 92 184 0 1884654256 14200032 26086832
20:07:11 2074 8192000000 10795376128 11182198784 1848017984 18.406 100 84 168 0 1886150320 13960256 24172080
20:07:19 2430 8192000000 10790628144 11180294144 1852679824 18.444 100 89 176 1 1890619536 13256224 24683488
20:07:28 1693 8192000000 10799360224 11187945472 1857886960 18.486 100 93 184 0 1897538992 12877584 26774448
20:07:36 2597 8192000000 10808297904 11194171392 1859295248 18.498 100 90 181 0 1897771024 13474208 25001568
20:07:45 1939 8192000000 10797944416 11185156096 1862225328 18.521 100 91 183 2 1901797776 13711072 25861376
20:07:53 1736 8192000000 10815626416 11206070272 1869710400 18.582 100 95 191 0 1910998896 13932592 27355904
20:08:01 2098 8192000000 10818530544 11208781824 1876483104 18.637 100 90 180 0 1914309744 11775440 26051200
20:08:13 20900 8192000000 10784795520 11205300224 1869433648 18.580 100 46 92 0 1890122640 7957904 12731088
20:08:41 6778 8192000000 10789688160 11208335360 1875623728 18.630 100 51 100 0 1899571888 10561136 13387024
20:08:57 2877 8192000000 10797238864 11209277440 1877997168 18.649 100 51 102 0 1902017728 10206160 13814400
20:09:08 4470 8192000000 10790708608 11206926336 1875102640 18.626 100 39 78 2 1894258704 8585792 10570272
20:09:18 3889 8192000000 10780385408 11207290880 1871679104 18.598 100 20 40 3 1884452864 7316416 5457344
20:09:31 6637 8192000000 10793929328 11213770752 1877401344 18.644 100 21 42 2 1889492736 6333840 5757552
20:09:44 6685 8192000000 10797084208 11214598144 1878999296 18.657 100 38 77 1 1898060096 8881456 10179344
20:10:01 10776 8192000000 10781419568 11216404480 1881409104 18.676 100 21 42 0 1893762880 6595840 5757936
20:10:18 7896 8192000000 10792108416 11220725760 1884732080 18.703 100 35 69 1 1902486192 7149088 10605024
20:10:34 5818 8192000000 10786659440 11221303296 1886470576 18.717 100 23 46 0 1901441504 7854432 7116496
20:10:46 6765 8192000000 10798460528 11222712320 1885843280 18.712 100 24 42 4 1897308992 5489088 5976624
20:11:01 59706 8192000000 10815095168 11237941248 1891764736 18.760 100 29 57 2 1905147776 4876432 8506608
20:12:14 9109 8192000000 10806109504 11240685568 1892084064 18.763 100 31 62 1 1908884704 7097616 9703024
20:12:29 5261 8192000000 10812293136 11244167168 1895342464 18.789 100 27 50 3 1909192272 6038992 7810816
20:12:41 3236 8192000000 10825113792 11250757632 1898182272 18.812 100 29 58 1 1912591312 5955216 8453824
20:12:53 5293 8192000000 10815495936 11248328704 1902644560 18.848 100 28 56 1 1916522048 5931008 7946480
20:13:04 2991 8192000000 10824257840 11256496128 1906628720 18.880 100 39 78 2 1924125360 7258752 10237888
20:13:14 8934 8192000000 10815024048 11251814400 1904617920 18.863 100 19 38 1 1916331840 5881680 5832240
20:13:29 4976 8192000000 10825796848 11258204160 1907665840 18.888 100 27 52 2 1920327408 5749728 6911840
20:13:41 5462 8192000000 10828683696 11259863040 1907836080 18.889 100 29 58 2 1926949856 9970496 9143280
20:13:57 9487 8192000000 10827180112 11261018112 1908280272 18.893 100 18 35 1 1918443936 5433728 4729936
20:14:15 8105 8192000000 10823080384 11259469824 1907509760 18.887 100 29 58 0 1922219040 7091728 7617552
20:14:32 4739 8192000000 10844715600 11271315456 1914972784 18.947 100 33 66 4 1934340128 9900080 9467264
20:14:43 3812 8192000000 10835193280 11266789376 1915401440 18.950 100 42 77 2 1932957424 6027936 11528048
20:14:54 12539 8192000000 10828275184 11266297856 1911385888 18.918 100 17 34 1 1922513888 6672736 4455264
20:15:13 10370 8192000000 10826332976 11266514944 1914756096 18.945 100 26 52 1 1929640576 6966912 7917568
20:15:30 40154 8192000000 10824219776 11257868288 1898750368 18.816 99 25 49 4 1912093632 6105456 7237808
20:16:25 27563 8192000000 10800812944 11237834752 1856343328 18.474 97 28 54 1 1869691488 5075808 8272352
20:16:58 12085 8192000000 10817657824 11248463872 1881049088 18.674 99 23 46 2 1893672016 5819696 6803232
20:17:20 4618 8192000000 10816855136 11245613056 1894181056 18.779 100 25 50 3 1907516032 6604912 6730064
20:17:34 7063 8192000000 10793012256 11219599360 1844723152 18.379 98 21 42 2 1855971472 5527520 5720800
20:17:47 5770 8192000000 10787678880 11210190848 1854371904 18.458 99 36 72 0 1870912352 5791568 10748880
20:18:00 6727 8192000000 10777856304 11193782272 1777942976 17.833 95 32 63 1 1792335872 5652128 8740768
20:18:14 4986 8192000000 10765248512 11193671680 1825440288 18.222 98 41 82 1 1845710192 9069744 11200160
20:18:26 4557 8192000000 10742786032 11167612928 1815342464 18.140 99 27 54 3 1828958384 5531232 8084688
20:18:39 8030 8192000000 10727415696 11150118912 1752293328 17.621 95 19 38 1 1763710704 5437088 5980288
20:18:54 4898 8192000000 10676845328 11090014208 1716778688 17.325 95 34 68 3 1731962752 5377808 9806256
20:19:06 11844 8192000000 10694161264 11113189376 1725311040 17.396 96 19 38 0 1736593504 5411472 5870992
20:19:24 5817 8192000000 10696347872 11107409920 1751810304 17.617 98 25 50 0 1765177456 5935856 7431296
20:19:36 5972 8192000000 10634704848 11045785600 1661246688 16.859 94 14 27 2 1670211200 4965520 3998992
20:19:48 8795 8192000000 10692273824 11099459584 1746954976 17.576 99 30 60 1 1760999952 4981040 9063936
20:20:09 9062 8192000000 10713047616 11125493760 1764433792 17.721 99 23 46 1 1777235984 5442976 7359216
20:20:26 17364 8192000000 10717601808 11132407808 1756150608 17.653 97 22 44 0 1768718704 5699088 6869008
20:20:54 64993 8192000000 10695927424 11116982272 1749811168 17.600 97 26 54 1 1762724304 4849952 8063184
20:22:05 11546 8192000000 10719135328 11135942656 1787622640 17.912 99 11 22 1 1796934448 5067472 4244336
20:22:25 9120 8192000000 10735441088 11141103616 1788982032 17.923 99 28 54 2 1803552992 6685408 7885552
20:22:42 6086 8192000000 10736043872 11155005440 1818673392 18.167 100 32 64 2 1834185456 6535392 8976672
20:22:55 9088 8192000000 10735726064 11152158720 1803952592 18.046 99 35 70 0 1820578384 6668896 9956896
20:23:12 3905 8192000000 10732262608 11152629760 1815158656 18.138 100 27 54 2 1829386320 6929680 7297984
20:23:25 7652 8192000000 10737417840 11161538560 1825963744 18.226 100 24 48 2 1838716304 5365456 7387104
20:23:40 8141 8192000000 10746146064 11168010240 1831979088 18.275 100 27 54 0 1845304896 5591392 7734416
20:23:57 13870 8192000000 10742367008 11171549184 1833849280 18.291 100 20 40 3 1845574896 5342192 6383424
20:24:17 6168 8192000000 10753702320 11178020864 1839558208 18.337 100 25 50 2 1852896592 6188288 7150096
20:24:32 11154 8192000000 10754992992 11180064768 1839599936 18.338 100 15 30 0 1849270000 5032896 4637168
20:24:49 7375 8192000000 10757361968 11182624768 1845337120 18.384 100 25 49 3 1858818064 5599696 7881248
20:25:03 7478 8192000000 10767922832 11190730752 1847459360 18.401 100 24 48 3 1861423808 7034016 6930432
20:25:18 11305 8192000000 10760444160 11192926208 1850105376 18.423 100 21 39 3 1861472368 5972304 5394688
20:25:36 25561 8192000000 10768377536 11196502016 1851878880 18.437 100 15 31 0 1861527040 5101168 4546992
20:26:42 25093 8192000000 10785270304 11212812288 1862526400 18.524 100 24 48 2 1879049600 10185584 6337616
20:27:14 7930 8192000000 10807051312 11230552064 1884451728 18.701 100 34 69 2 1899183296 5701072 9030496
20:27:40 46714 8192000000 10826377968 11242008576 1894521024 18.782 100 48 90 2 1915106640 8107600 12478016
20:28:52 20604 8192000000 10848954240 11269263360 1918072224 18.971 100 55 110 2 1947215680 13466368 15677088
20:29:20 2128 8192000000 10874235168 11284590592 1928637408 19.056 100 80 159 0 1964629856 13387024 22605424
20:29:31 17072 8192000000 10865029552 11283906560 1927835408 19.050 100 47 93 0 1953598272 13028208 12734656
20:30:00 8514 8192000000 10867009744 11290222592 1933199680 19.092 100 55 110 0 1962625152 13491792 15933680
20:30:17 11596 8192000000 10862914944 11291136000 1933915072 19.098 100 50 100 1 1961929776 13329056 14685648
20:30:38 16827 8192000000 10876757808 11298635776 1937439248 19.126 100 50 100 4 1965259184 13058800 14761136
20:31:04 2946 8192000000 10880048656 11302338560 1942518960 19.167 100 52 103 0 1971105776 13595712 14991104
20:31:21 2369 8192000000 10890970752 11303845888 1945860272 19.193 100 64 128 0 1978848224 14494880 18493072
20:31:32 11952 8192000000 10890539408 11313442816 1948909712 19.218 100 60 120 0 1985129200 18036128 18183360
20:31:55 22599 8192000000 10874437536 11310776320 1945561008 19.191 100 53 103 3 1977438832 17062112 14815712
20:32:27 20093 8192000000 10879645424 11316887552 1946641488 19.200 100 36 72 3 1976268848 18083952 11543408
20:32:54 10040 8192000000 10871031712 11305103360 1931033504 19.075 99 39 78 1 1963143408 19890496 12219408
20:33:12 12776 8192000000 10884842112 11313500160 1945440944 19.190 100 52 102 3 1977015632 15934864 15639824
20:33:35 25708 8192000000 10894198800 11325984768 1950267248 19.229 100 40 77 3 1977772432 15514240 11990944
20:34:09 4155 8192000000 10885820240 11310116864 1937062544 19.123 99 61 122 0 1971467280 15692480 18712256
20:34:23 31532 8192000000 10893092432 11330584576 1955389552 19.269 100 43 85 0 1984032016 15350160 13292304
20:35:13 5157 8192000000 10912181136 11344457728 1972977568 19.409 100 62 123 0 2007226128 15558800 18689760
20:35:25 1945 8192000000 10942668112 11352363008 1981519728 19.477 100 87 174 0 2022776208 15830272 25426208
20:35:34 2388 8192000000 10946076880 11357442048 1985283792 19.507 100 88 171 1 2026980896 17986768 23710336
20:35:43 1754 8192000000 10948120048 11363639296 1988860688 19.535 100 86 172 3 2031512256 18009504 24642064
20:35:54 6013 8192000000 10929119984 11352526848 1964012880 19.338 99 67 133 1 2002565376 19155056 19397440
20:36:07 4550 8192000000 10922675744 11342364672 1957063280 19.283 99 69 136 0 1994743440 18352304 19327856
20:36:18 3697 8192000000 10928877056 11341770752 1967425072 19.365 100 77 152 2 2009875264 19540896 22909296
20:36:29 2440 8192000000 10928195440 11346370560 1970609920 19.390 100 72 140 2 2010186912 19180816 20396176
20:36:39 9152 8192000000 10900028640 11321229312 1946643552 19.200 99 67 135 1 1984384912 18570720 19170640
20:36:56 2642 8192000000 10916031232 11336327168 1962336768 19.325 100 69 136 3 2001588928 19748848 19503312
20:37:09 5003 8192000000 10916654992 11335421952 1961596784 19.319 100 69 138 2 2001855792 20008528 20250480
20:37:21 4150 8192000000 10919889584 11337588736 1949847616 19.225 99 74 149 1 1994800096 22164272 22788208
20:37:32 3052 8192000000 10925163328 11335561216 1949784544 19.225 99 88 174 2 1997878080 22225440 25868096
20:37:43 3154 8192000000 10930823936 11345068032 1966123008 19.355 100 88 176 1 2016454672 23660528 26671136
20:37:55 11359 8192000000 10904222368 11328258048 1951636160 19.240 100 62 124 2 1992269184 22281456 18351568
20:38:13 6398 8192000000 10903546608 11323011072 1935920400 19.114 99 67 132 1 1975011360 19729024 19361936
20:38:29 3903 8192000000 10899673328 11325087744 1949501120 19.223 100 66 129 3 1990762864 21875792 19385952
20:38:42 8612 8192000000 10909172992 11339161600 1957955536 19.290 100 55 109 0 1996235408 22131536 16148336
20:39:05 4490 8192000000 10921846496 11339165696 1958563376 19.295 100 70 139 0 2001769168 22838992 20366800
20:39:16 2752 8192000000 10920342128 11344601088 1966209792 19.355 100 61 123 2 2007845856 23613744 18022320
20:39:28 4533 8192000000 10922188816 11341377536 1959731328 19.304 100 70 139 0 2005396128 25027936 20636864
20:39:44 8116 8192000000 10911641744 11334672384 1941687824 19.160 99 56 112 0 1983311408 24768320 16855264
20:40:00 2191 8192000000 10914454864 11327655936 1940506512 19.151 99 84 166 1 1990648064 24933776 25207776
20:40:12 1618 8192000000 10929024128 11342376960 1958699440 19.296 100 73 146 1 2007628032 26940160 21988432
20:40:21 1979 8192000000 10930592560 11341164544 1966587968 19.358 100 85 171 0 2019726480 27432640 25705872
20:40:30 1514 8192000000 10950534352 11355566080 1974614464 19.422 100 81 158 2 2025640192 27452384 23573344
20:40:38 3667 8192000000 10940020032 11351805952 1971260384 19.395 100 80 159 1 2023075664 28380640 23434640
20:40:50 1371 8192000000 10948930208 11355500544 1970588384 19.390 100 91 183 2 2028377152 29555264 28233504
20:40:58 2579 8192000000 10928541200 11338260480 1956355264 19.277 100 84 166 1 2011034336 29499008 25180064
20:41:07 1102 8192000000 10926108400 11328065536 1952131968 19.243 100 94 185 1 2010035552 29326128 28577456
20:41:15 1976 8192000000 10899267248 11303116800 1901439536 18.838 97 81 160 1 1954307616 28185104 24682976
20:41:26 4396 8192000000 10904253024 11320369152 1939217856 19.141 100 72 140 1 1989512816 29135136 21159824
20:41:37 3452 8192000000 10908256336 11312107520 1930421136 19.070 100 90 180 1 1987097872 29596560 27080176
20:41:47 4435 8192000000 10922031200 11323650048 1926891232 19.042 99 89 173 1 1984815792 32010256 25914304
20:41:59 4172 8192000000 10928777360 11331874816 1945653248 19.192 100 91 183 1 2007850096 34248896 27947952
20:42:10 4002 8192000000 10900813840 11309129728 1915100720 18.948 99 85 168 1 1975265904 34274352 25890832
20:42:25 2409 8192000000 10913277232 11317313536 1931407488 19.078 100 81 159 1 1991729312 35302064 25019760
20:42:34 3480 8192000000 10900002256 11319779328 1931282784 19.077 100 62 124 1 1985856640 34816336 19757520
20:42:46 13993 8192000000 10914397472 11318497280 1930652592 19.072 100 80 160 0 1990237280 34522240 25062448
20:43:06 2586 8192000000 10931012896 11333840896 1945200304 19.188 100 85 170 2 2007196672 35857488 26138880
20:43:16 6447 8192000000 10902817904 11318538240 1915461952 18.950 99 70 140 0 1974715040 36979872 22273216
20:43:33 3329 8192000000 10901030832 11317211136 1901645664 18.840 98 74 145 1 1960730480 36238400 22846416
20:43:48 2408 8192000000 10905952176 11316133888 1917154288 18.964 99 74 146 0 1974740368 34495744 23090336
20:43:59 1594 8192000000 10916830752 11317133312 1916854848 18.962 99 83 166 1 1977808992 35154544 25799600
20:44:07 5187 8192000000 10900776000 11301847040 1912103440 18.924 99 77 154 2 1974181024 37837232 24240352
20:44:19 2214 8192000000 10918185600 11320082432 1927226320 19.045 100 82 165 0 1990980912 37819696 25934896
20:44:29 3183 8192000000 10907256672 11314171904 1921509344 18.999 100 75 150 1 1982456336 38230736 22716256
20:44:39 1978 8192000000 10886544832 11292659712 1907088096 18.883 99 71 142 2 1967026064 36981920 22956048
20:44:49 5417 8192000000 10920219504 11328258048 1934476752 19.103 100 82 162 1 1998434000 39227968 24729280
20:45:01 3212 8192000000 10921843984 11327717376 1929797120 19.065 100 81 162 1 1997173152 41408128 25967904
20:45:11 1849 8192000000 10903551248 11302055936 1897832160 18.809 98 87 175 0 1967872608 42530448 27510000
20:45:21 4237 8192000000 10897119616 11309862912 1905725952 18.872 99 81 155 0 1972755216 43033360 23995904
20:45:34 4955 8192000000 10907201040 11319173120 1922672128 19.008 100 75 151 2 1989316112 41109056 25534928
20:45:49 1573 8192000000 10902053728 11309625344 1915692432 18.952 100 75 148 2 1978919600 38776320 24450848
20:45:58 5451 8192000000 10886792640 11307020288 1914853024 18.946 100 56 111 0 1969685040 37039888 17792128
20:46:12 8099 8192000000 10896397152 11314016256 1923446672 19.014 100 71 142 0 1984537312 38305520 22785120
20:46:28 3369 8192000000 10903707776 11302789120 1910316448 18.909 99 82 164 1 1973112560 36480384 26315728
20:46:45 6001 8192000000 10885521696 11327184896 1929717552 19.065 100 41 82 0 1980294896 37118704 13458640
20:47:08 14715 8192000000 10880559760 11314044928 1927833392 19.050 100 38 76 3 1966801456 26666240 12301824
20:47:42 3091 8192000000 10900120208 11318870016 1931335456 19.078 100 56 110 2 1976424624 28106624 16982544
20:47:53 5292 8192000000 10898424160 11326287872 1933784224 19.097 100 48 96 3 1979534160 30726768 15023168
20:48:39 14446 8192000000 10901218192 11338141696 1940277488 19.149 100 30 60 1 1980682096 30359280 10045328
20:49:07 21283 8192000000 10886673536 11330822144 1917640192 18.968 99 30 60 0 1962274544 34022880 10611472
20:49:49 9689 8192000000 10888183040 11328135168 1924905504 19.026 100 32 62 3 1972088928 36349296 10834128
20:50:06 8145 8192000000 10895102864 11331829760 1936553936 19.119 100 46 91 2 1988335232 36563232 15218064
20:50:27 14739 8192000000 10892630832 11342856192 1915991952 18.955 99 24 48 1 1962271568 37934416 8345200
20:50:53 31400 8192000000 10887935696 11348537344 1940296960 19.149 100 22 45 2 1982824544 34888176 7639408
20:52:01 41462 8192000000 10877797968 11335311360 1892368048 18.765 98 19 38 2 1926674272 27715664 6590560
20:53:00 39148 8192000000 10863223840 11315544064 1936681024 19.120 100 44 89 1 1956980864 8097056 12202784
20:53:45 38997 8192000000 10876640368 11325739008 1929357088 19.062 99 38 76 2 1948804720 9023824 10423808
20:54:30 135179 8192000000 10888888848 11356835840 1931410144 19.078 99 18 36 0 1953253712 16578672 5264896
20:57:43 12637 8192000000 10889542480 11336675328 1961674912 19.319 100 42 83 0 1979418592 6098144 11645536
20:58:07 62479 8192000000 10913552144 11345743872 1934636112 19.104 98 29 58 2 1950320656 7497488 8187056
20:59:17 124073 8192000000 10947124576 11383574528 1970023248 19.386 99 37 74 1 1992286432 11829680 10433504
21:01:27 23676 8192000000 10933465760 11389906944 2000281328 19.625 100 39 78 2 2026434720 14956240 11197152
21:02:06 9498 8192000000 10948365392 11398250496 2005992928 19.670 100 36 72 0 2031465872 14371696 11101248
21:02:37 61232 8192000000 10911730720 11383099392 1952052240 19.243 98 26 52 1 1981164624 20922800 8189584
21:03:45 45502 8192000000 10905339424 11375210496 1942026832 19.163 98 14 28 1 1962589312 16341760 4220720
21:04:37 88676 8192000000 10904858256 11382849536 1965144400 19.347 99 22 44 1 1982467440 10913360 6409680
21:07:34 106830 8192000000 10886335840 11359707136 1946957600 19.202 98 24 47 3 1964744480 10470448 7316432
21:09:46 57629 8192000000 10897478576 11374059520 1960996016 19.314 99 9 18 1 1971189008 7735536 2457456
21:10:53 37369 8192000000 10881898944 11349630976 1924779936 19.025 97 15 30 0 1936769232 7488416 4500880
21:11:42 46000 8192000000 10887043024 11369746432 1973026176 19.409 100 19 38 0 1987946368 9306608 5613584
21:12:40 41351 8192000000 10880364336 11358556160 1938026224 19.131 98 16 30 2 1949784912 7225552 4533136
21:13:35 67885 8192000000 10897497040 11363913728 1955441840 19.270 99 4 8 0 1964709456 8197008 1070608
21:14:49 39905 8192000000 10896480080 11374514176 1943472000 19.174 98 18 35 1 1961010736 12436080 5102656
21:15:36 26738 8192000000 10893777136 11354378240 1957113920 19.283 99 32 64 0 1977889984 10245296 10530768
21:16:12 23891 8192000000 10922069936 11388710912 1986052672 19.513 100 22 44 1 2004020832 11006080 6962080
21:16:48 28006 8192000000 10919195088 11377012736 1984356112 19.499 100 28 56 0 2005555024 13039472 8159440
21:17:25 60296 8192000000 10896732496 11362185216 1934940096 19.106 98 25 50 0 1957449536 14995664 7513776
21:18:45 59427 8192000000 10898801920 11373703168 1959504320 19.302 99 17 34 0 1976643456 12187600 4951536
21:19:57 73634 8192000000 10917681760 11388452864 1965779696 19.352 99 11 22 0 1985947040 17014096 3153248
21:21:18 41319 8192000000 10935380064 11395493888 1979140368 19.458 99 33 67 0 2006189552 17572080 9477104
21:22:12 50891 8192000000 10931740976 11406303232 1995990496 19.591 100 23 46 0 2024710960 22088496 6631968
21:23:12 51358 8192000000 10924356800 11401551872 1969612704 19.382 99 16 32 0 2005928208 31141168 5174336
21:24:15 73596 8192000000 10910660320 11347804160 1867105792 18.561 94 32 64 0 1886363584 10014224 9243568
21:25:36 23932 8192000000 10897637872 11347615744 1917207616 18.964 98 32 64 2 1934876752 9048208 8620928
21:26:07 56056 8192000000 10858500576 11317727232 1827260976 18.237 94 32 64 3 1849196768 12579072 9356720
21:27:31 87908 8192000000 10878217104 11332460544 1907341856 18.885 98 35 71 0 1925359920 8331424 9686640
21:29:06 45688 8192000000 10861444560 11324313600 1911371232 18.918 98 23 46 1 1925463744 7572048 6520464
21:29:58 51551 8192000000 10881652288 11357016064 1956582320 19.279 100 33 66 1 1976326880 10714784 9029776
21:31:11 49501 8192000000 10870354224 11353546752 1945591392 19.191 99 13 26 0 1968267968 19654352 3022224
21:32:07 25841 8192000000 10875480496 11361153024 1940979056 19.155 99 8 16 0 1957037008 14303504 1754448
21:32:46 25373 8192000000 10871470816 11353542656 1954202000 19.260 100 6 12 0 1966078368 10439056 1437312
21:33:21 46134 8192000000 10862644176 11339345920 1891053984 18.754 97 12 24 0 1903125824 9243328 2828512
21:34:23 61662 8192000000 10849712032 11312160768 1838644992 18.330 95 21 42 0 1858399344 13613728 6140624
21:35:31 61250 8192000000 10882548928 11353034752 1950953136 19.234 100 29 58 4 1971049280 11345248 8750896
21:36:38 70301 8192000000 10874845728 11346554880 1854543200 18.459 95 6 12 0 1868632272 11927360 2161712
21:38:09 65275 8192000000 10854714160 11334905856 1869958176 18.584 96 15 30 0 1889877936 15515632 4404128
21:39:29 153387 8192000000 10899019568 11380396032 1931533056 19.079 99 17 34 0 1957386976 20921376 4932544
21:43:26 41997 8192000000 10883684976 11351003136 1935637040 19.112 99 27 54 0 1954395392 11004384 7753968
21:44:14 90604 8192000000 10887641744 11358003200 1907339184 18.885 97 14 28 2 1925574848 14170208 4065456
21:45:51 30980 8192000000 10897357184 11356413952 1931983440 19.083 98 20 40 0 1950070176 12564432 5522304
21:46:33 48120 8192000000 10910017152 11365675008 1954515216 19.262 99 49 98 3 1980478432 12170800 13792416
21:47:28 121474 8192000000 10902996752 11376185344 1972306912 19.404 100 28 56 2 1995644128 15691328 7645888
21:49:36 43496 8192000000 10914756144 11386544128 1980883920 19.472 100 24 48 0 2006631168 18350096 7397152
21:50:38 75807 8192000000 10887607968 11372171264 1919423280 18.982 97 16 32 1 1939220000 15307616 4489104
21:52:01 41541 8192000000 10863772816 11345551360 1903811584 18.857 97 3 6 0 1918097856 13488528 797744
21:53:34 65133 8192000000 10875624192 11365441536 1934941760 19.106 99 10 18 2 1952042528 13125248 3975520
21:55:10 56882 8192000000 10915232160 11382939648 1977136144 19.442 100 14 28 0 1993256352 12604544 3515664
21:56:13 31150 8192000000 10914051040 11380060160 1966364160 19.357 99 34 67 2 1989186864 12760400 10062304
21:57:03 91010 8192000000 10900828560 11390382080 1942548144 19.167 98 9 18 0 1964822736 19882992 2391600
21:58:50 55192 8192000000 10914474368 11366174720 1923157584 19.012 97 15 28 0 1934125840 7256912 3711344
21:59:54 46060 8192000000 10927360384 11392937984 1987206992 19.522 100 32 64 2 2007055600 11299408 8549200
22:00:48 87595 8192000000 10936335408 11389218816 1970364880 19.388 99 20 40 1 1987361792 11605616 5391296
22:02:22 49865 8192000000 10919947136 11376877568 1959894592 19.305 99 38 75 2 1979872448 9494464 10483392
22:03:21 45933 8192000000 10891034416 11363274752 1914851216 18.946 97 23 46 1 1933362752 11937088 6574448
22:04:13 45206 8192000000 10906390384 11370500096 1952951072 19.250 99 13 25 1 1965857760 9229040 3677648
22:05:14 59267 8192000000 10918518400 11385864192 1960352656 19.309 99 28 56 1 1983991856 15651120 7988080
22:06:21 73994 8192000000 10912358272 11377229824 1949332608 19.221 98 27 54 3 1969039200 12736768 6969824
22:07:41 103759 8192000000 10908014384 11393765376 1928652288 19.056 97 18 36 0 1945974288 12394720 4927280
22:09:31 114686 8192000000 10907290240 11385118720 1979847040 19.463 100 22 44 1 1995499568 8889696 6762832
22:11:33 83278 8192000000 10897971712 11371966464 1905744128 18.872 96 24 48 1 1923855248 11126736 6984384
22:13:03 41371 8192000000 10883010528 11347906560 1929781712 19.065 98 15 30 2 1946386000 12360960 4243328
22:13:57 64686 8192000000 10865464800 11349889024 1934088272 19.100 99 7 14 0 1947494656 11484928 1921456
22:15:08 54607 8192000000 10852458000 11339694080 1897789040 18.809 97 8 16 0 1910368096 10248576 2330480
22:16:10 64618 8192000000 10843228144 11312500736 1806755584 18.069 93 16 33 2 1817419856 6297840 4366432
22:17:39 82797 8192000000 10853282032 11321700352 1842970832 18.365 95 16 32 1 1862184816 14405520 4808464
22:19:08 59720 8192000000 10846573616 11311423488 1869430896 18.580 97 17 35 1 1886155136 11865344 4858896
22:20:17 39066 8192000000 10842107344 11310522368 1874958464 18.624 97 20 40 0 1888833232 7900560 5974208
22:21:35 97053 8192000000 10871295440 11331260416 1882858880 18.688 97 24 48 1 1904662096 14954752 6848464
22:23:24 48776 8192000000 10837414848 11305242624 1816671136 18.150 94 31 61 1 1836108480 10945440 8491904
22:24:23 64329 8192000000 10821722288 11289194496 1795718112 17.979 94 25 50 1 1813465968 9818816 7929040
22:25:34 123751 8192000000 9390556688 9687928832 534992672 6.130 28 6 12 0 546660032 9908432 1758928

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-03-2021 22:28:35 to 24-03-2021 22:29:06.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2021 22:29:07 to 24-03-2021 22:29:09.

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          247017
MON$OLDEST_ACTIVE               247696
MON$OLDEST_SNAPSHOT             247696
MON$NEXT_TRANSACTION            247696
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                       2017344
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:248: 
:249: mscs-test-161.budzdorov.ru    Wed Mar 24 22:27:42 2021
:250:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:251: 
:252: 
:253: mscs-test-161.budzdorov.ru    Wed Mar 24 22:27:42 2021
:254:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:255: 
--- end of diff output ---

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

24.03.21 22:29:10. 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-03-24 22:29:12 No severe PSQL-related problems occured
24.03.21 22:29:14. End of report.