Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.03.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 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 17481644 kB
MemAvailable 31550168 kB
Buffers 0 kB
Cached 14174540 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-15 01:27:25
DTS_END                         2021-03-15 01:27:25.3910
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/51614
TRN_ID                          250023
ATT_ID                          677
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: 9221.95 22163 1106634
customer order: creation 184.83 336 22179
customer order: refuse 16.09 328 1931
order to supplier: creation 48.53 1293 5824
order to supplier: removal 3.54 95354 425
invoice (draft): creation 49.93 3460 5992
invoice (draft): removal 49.58 870 5950
invoice accept: apply 44.65 17336 5358
invoice accept: cancel 44.61 853 5353
customer reserve: creation 4070.02 173 488402
customer reserve: removal 4401.19 59 528143
realization accept: apply 90.27 182 10832
realization accept: cancel 77.14 113 9257
payment from customer: creation 63.97 112 7676
payment from customer: removal 6.33 64 760
payment to supplier: creation 53.40 119 6408
payment to supplier: removal 3.82 86 458
service: total inventory turnovers 5.53 1055 664
service: total monetary turnovers 7.46 35 895
service: aggregate perf. data 1.03 14144 123
service: refresh index statistics 0.03 307288 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-03-2021 01:28:13 to 15-03-2021 01:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2671
TEST_TIME 2 4147
TEST_TIME 3 4430
TEST_TIME 4 4604
TEST_TIME 5 5088
TEST_TIME 6 5730
TEST_TIME 7 5592
TEST_TIME 8 5943
TEST_TIME 9 6411
TEST_TIME 10 6470
TEST_TIME 11 6628
TEST_TIME 12 6709
TEST_TIME 13 7073
TEST_TIME 14 7227
TEST_TIME 15 7487
TEST_TIME 16 7701
TEST_TIME 17 7954
TEST_TIME 18 8379
TEST_TIME 19 8606
TEST_TIME 20 8526
TEST_TIME 21 8473
TEST_TIME 22 8917
TEST_TIME 23 8899
TEST_TIME 24 9527
TEST_TIME 25 9780
TEST_TIME 26 9594
TEST_TIME 27 9835
TEST_TIME 28 9752
TEST_TIME 29 9948
TEST_TIME 30 10022
TEST_TIME 31 10541
TEST_TIME 32 10746
TEST_TIME 33 10575
TEST_TIME 34 10618
TEST_TIME 35 10602
TEST_TIME 36 10612
TEST_TIME 37 10616
TEST_TIME 38 10506
TEST_TIME 39 10377
TEST_TIME 40 10185
TEST_TIME 41 10107
TEST_TIME 42 10140
TEST_TIME 43 10068
TEST_TIME 44 9972
TEST_TIME 45 9979
TEST_TIME 46 9931
TEST_TIME 47 9798
TEST_TIME 48 10080
TEST_TIME 49 9971
TEST_TIME 50 9858
TEST_TIME 51 9759
TEST_TIME 52 9627
TEST_TIME 53 9637
TEST_TIME 54 9595
TEST_TIME 55 9527
TEST_TIME 56 9467
TEST_TIME 57 9460
TEST_TIME 58 9471
TEST_TIME 59 9495
TEST_TIME 60 9465
TEST_TIME 61 9547
TEST_TIME 62 9516
TEST_TIME 63 9589
TEST_TIME 64 9549
TEST_TIME 65 9534
TEST_TIME 66 9600
TEST_TIME 67 9637
TEST_TIME 68 9593
TEST_TIME 69 9682
TEST_TIME 70 9667
TEST_TIME 71 9634
TEST_TIME 72 9618
TEST_TIME 73 9651
TEST_TIME 74 9581
TEST_TIME 75 9518
TEST_TIME 76 9539
TEST_TIME 77 9477
TEST_TIME 78 9528
TEST_TIME 79 9441
TEST_TIME 80 9450
TEST_TIME 81 9456
TEST_TIME 82 9434
TEST_TIME 83 9356
TEST_TIME 84 9329
TEST_TIME 85 9266
TEST_TIME 86 9260
TEST_TIME 87 9248
TEST_TIME 88 9219
TEST_TIME 89 9220
TEST_TIME 90 9247
TEST_TIME 91 9273
TEST_TIME 92 9294
TEST_TIME 93 9313
TEST_TIME 94 9335
TEST_TIME 95 9344
TEST_TIME 96 9339
TEST_TIME 97 9315
TEST_TIME 98 9342
TEST_TIME 99 9363
TEST_TIME 100 9409
TEST_TIME 101 9429
TEST_TIME 102 9421
TEST_TIME 103 9350
TEST_TIME 104 9343
TEST_TIME 105 9314
TEST_TIME 106 9342
TEST_TIME 107 9320
TEST_TIME 108 9289
TEST_TIME 109 9262
TEST_TIME 110 9231
TEST_TIME 111 9180
TEST_TIME 112 9177
TEST_TIME 113 9200
TEST_TIME 114 9206
TEST_TIME 115 9229
TEST_TIME 116 9203
TEST_TIME 117 9226
TEST_TIME 118 9260
TEST_TIME 119 9261
TEST_TIME 120 9223

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-03-2021 01:28:17 to 15-03-2021 01:28:20.

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 1558516 1558516 0 0.00 0 15243 6 0 0
doc_list_biud 1558516 1558516 0 0.00 0 40183 26 0 0
sp_add_invoice_to_stock 5578 5358 220 3.94 60 165726 17336 0 220
sp_cancel_adding_invoice 5353 5353 0 0.00 3 62543 854 0 0
sp_cancel_client_order 1931 1931 0 0.00 4 18405 328 0 0
sp_cancel_customer_reserve 528143 528143 0 0.00 1 25683 59 0 0
sp_cancel_pay_from_customer 760 760 0 0.00 2 2066 64 0 0
sp_cancel_pay_to_supplier 458 458 0 0.00 2 6186 87 0 0
sp_cancel_supplier_invoice 5968 5950 18 0.30 2 19344 870 0 18
sp_cancel_supplier_order 425 425 0 0.00 5 999785 95354 0 0
sp_cancel_write_off 9257 9257 0 0.00 1 33792 114 0 0
sp_client_order 22179 22179 0 0.00 4 19623 337 0 0
sp_customer_reserve 488402 488402 0 0.00 0 153004 173 0 0
sp_fill_shopping_cart 33986 33986 0 0.00 1 28271 39 0 0
sp_fill_shopping_cart_clo_res 488400 488400 0 0.00 0 24383 13 0 0
sp_get_clo_for_invoice 5352 5352 0 0.00 0 35225 314 0 0
sp_kill_cost_storno 15828 15828 0 0.00 0 7514 55 0 0
sp_kill_qstorno_ret_qs2qd 1071918 1071918 0 0.00 0 33786 33 0 0
sp_kill_qty_storno 567243 567243 0 0.00 0 40180 72 0 0
sp_lock_selected_doc 22322 22322 0 0.00 0 10597 7 0 0
sp_make_cost_storno 30268 30268 0 0.00 0 15212 50 0 0
sp_multiply_rows_for_pdistr 30268 30268 0 0.00 0 7947 27 0 0
sp_multiply_rows_for_qdistr 22179 22179 0 0.00 0 19616 146 0 0
sp_pay_from_customer 7676 7676 0 0.00 4 10914 112 0 0
sp_pay_to_supplier 6408 6408 0 0.00 4 15756 120 0 0
sp_payment_common 14084 14084 0 0.00 1 10906 26 0 0
sp_qd_handle_on_cancel_clo 1931 1931 0 0.00 0 18396 294 0 0
sp_qd_handle_on_invoice_upd_sts 10705 10705 0 0.00 0 40175 381 0 0
sp_qd_handle_on_reserve_upd_sts 10832 10832 0 0.00 0 20110 57 0 0
sp_reserve_write_off 10832 10832 0 0.00 6 20145 183 0 0
sp_supplier_invoice 5992 5992 0 0.00 6 96586 3460 0 0
sp_supplier_order 5824 5824 0 0.00 5 20833 1293 0 0
srv_aggregate_perf_data 123 123 0 0.00 2527 193995 14145 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1679 211674 34436 0 0
srv_find_qd_qs_mism 1055233 1055233 0 0.00 0 13810 5 0 0
srv_make_invnt_saldo 664 664 0 0.00 33 47728 1055 0 0
srv_make_money_saldo 895 895 0 0.00 0 7153 36 0 0
srv_recalc_idx_stat 4 4 0 0.00 233364 445645 307289 0 0
t$perf-abend:sp_add_invoice_to_stock 220 220 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5358 5358 0 0.00 0 12770 150 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 1 2389 79 0 0
t$perf-norm:sp_cancel_client_order 1931 1931 0 0.00 0 3265 15 0 0
t$perf-norm:sp_cancel_customer_reserve 718 718 0 0.00 0 690 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 760 760 0 0.00 0 1514 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 458 458 0 0.00 0 681 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 2456 17 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 25775 1701 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 3642 12 0 0
t$perf-norm:sp_client_order 22179 22179 0 0.00 0 4075 15 0 0
t$perf-norm:sp_customer_reserve 1105 1105 0 0.00 0 3962 8 0 0
t$perf-norm:sp_pay_from_customer 7676 7676 0 0.00 0 7420 10 0 0
t$perf-norm:sp_pay_to_supplier 6408 6408 0 0.00 0 10862 10 0 0
t$perf-norm:sp_reserve_write_off 10832 10832 0 0.00 0 15181 14 0 0
t$perf-norm:sp_supplier_invoice 5992 5992 0 0.00 0 5975 19 0 0
t$perf-norm:sp_supplier_order 5824 5824 0 0.00 0 8723 17 0 0
t$perf-norm:srv_aggregate_perf_data 123 123 0 0.00 0 304 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 1597 17 0 0
t$perf-norm:srv_make_invnt_saldo 664 664 0 0.00 0 854 14 0 0
t$perf-norm:srv_make_money_saldo 895 895 0 0.00 0 1110 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 79 22 0 0
v_add_invoice_to_stock 11128 10688 440 3.95 0 6158 21 0 440
v_all_customers 40128 40128 0 0.00 0 16 1 0 0
v_all_suppliers 32714 32714 0 0.00 0 17 1 0 0
v_all_wares 44358 44358 0 0.00 0 60 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 3337 9 0 0
v_cancel_client_order 3862 3862 0 0.00 0 3884 7 0 0
v_cancel_customer_prepayment 1520 1520 0 0.00 0 577 4 0 0
v_cancel_customer_reserve 1436 1436 0 0.00 0 4980 12 0 0
v_cancel_payment_to_supplier 916 916 0 0.00 0 6164 12 0 0
v_cancel_supplier_invoice 890 854 36 4.04 0 6476 37 0 36
v_cancel_supplier_order 850 850 0 0.00 0 660 4 0 0
v_cancel_write_off 2032 2032 0 0.00 0 5774 18 0 0
v_max_id_clo_ord 5822 5822 0 0.00 0 1263 1 0 0
v_max_id_clo_res 1105 1105 0 0.00 0 2205 18 0 0
v_max_id_ord_sup 5983 5983 0 0.00 0 7507 6 0 0
v_max_non_paid_invoice 1856 1856 0 0.00 0 6622 7 0 0
v_max_non_paid_realizn 4243 4243 0 0.00 0 5163 6 0 0
v_min_id_clo_ord 5822 5822 0 0.00 0 1802 5 0 0
v_min_id_clo_res 1105 1105 0 0.00 0 10583 12 0 0
v_min_id_ord_sup 5983 5983 0 0.00 0 5434 7 0 0
v_min_non_paid_invoice 6408 6408 0 0.00 0 4120 11 0 0
v_min_non_paid_realizn 7676 7676 0 0.00 0 7875 16 0 0
v_our_firm 11096 11096 0 0.00 0 21 1 0 0
v_reserve_write_off 21664 21664 0 0.00 0 7036 9 0 0
x_lock_depdocs_on_canc_invoice 10876 10876 0 0.00 0 18937 113 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 7191 311 0 0
x_make_qstorno_1000_1200 5824 5824 0 0.00 1 20780 1222 0 0
x_make_qstorno_1200_2000 5992 5992 0 0.00 3 85999 3302 0 0
x_make_qstorno_2100_3300 488402 488402 0 0.00 0 153003 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-03-2021 01:28:21 to 15-03-2021 01:28:25.

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:28 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:34 14861 8192000000 10239852448 10540953600 784395696 8.738 62 45 92 0 801789456 1931376 15462384
22:57:58 34684 8192000000 10358393200 10675511296 1386285456 14.473 100 83 167 0 1418093312 4512144 27295712
22:58:45 27377 8192000000 10395464624 10718593024 1453165792 15.066 100 85 170 0 1487265264 6267264 27832208
22:59:27 20005 8192000000 10430780288 10761039872 1485998464 15.354 100 89 178 0 1522178304 7672880 28506960
22:59:58 8511 8192000000 10437470304 10772787200 1500631232 15.482 100 86 172 0 1535861840 7912432 27318176
23:00:16 24899 8192000000 10459155904 10794512384 1515408432 15.610 100 86 172 0 1550677184 7839536 27429216
23:00:52 12194 8192000000 10479469200 10815840256 1527790480 15.718 100 89 178 0 1564624304 8675648 28158176
23:01:15 12707 8192000000 10483744256 10827231232 1545201440 15.869 100 86 172 0 1581264448 9434304 26628704
23:01:36 15818 8192000000 10505859824 10849861632 1560841216 16.003 100 85 170 0 1596987904 9793280 26353408
23:02:01 11402 8192000000 10524308000 10876383232 1584223296 16.204 100 85 170 0 1620135728 10496576 25415856
23:02:22 10289 8192000000 10551812544 10906337280 1605041168 16.382 100 76 153 0 1639022976 10830560 23151248
23:02:42 15391 8192000000 10570820464 10927337472 1630348144 16.598 100 85 170 1 1666644704 11037504 25259056
23:03:08 15143 8192000000 10581992080 10947715072 1648638560 16.753 100 73 144 2 1681485056 11769856 21076640
23:03:34 9185 8192000000 10606690544 10971504640 1665997552 16.899 100 76 153 0 1699648464 11569552 22081360
23:03:51 12458 8192000000 10635956432 11002159104 1690685776 17.107 100 82 164 2 1727281840 12752800 23843264
23:04:12 6726 8192000000 10642070496 11012083712 1706191520 17.237 100 80 160 1 1742415360 13574848 22648992
23:04:25 9173 8192000000 10649389616 11024850944 1718168192 17.337 100 78 156 4 1753528320 13104480 22255648
23:04:42 7093 8192000000 10668315376 11041046528 1730937136 17.443 100 82 164 1 1767888240 13434048 23517056
23:04:56 6800 8192000000 10683622048 11058782208 1740090336 17.519 100 78 156 2 1775428688 13612448 21725904
23:05:14 7659 8192000000 10698445776 11076284416 1756730688 17.657 100 80 160 0 1791499488 12376608 22392192
23:05:30 4608 8192000000 10698715488 11080200192 1766534896 17.738 100 74 145 2 1798327360 11470896 20321568
23:05:42 4827 8192000000 10706544128 11085479936 1774054432 17.800 100 70 139 0 1805444992 11986960 19403600
23:05:53 13545 8192000000 10708378288 11099164672 1779584448 17.846 100 67 134 0 1810006528 12185488 18236592
23:06:16 4349 8192000000 10737816816 11124211712 1798732736 18.004 100 71 142 1 1830771952 12515712 19523504
23:06:28 2748 8192000000 10745703920 11132272640 1810149392 18.097 100 84 165 0 1846387072 12272496 23965184
23:06:37 3926 8192000000 10763180784 11144396800 1819186928 18.171 100 86 172 0 1859959232 16327984 24444320
23:06:48 3969 8192000000 10764806832 11150217216 1829374720 18.254 100 78 157 1 1864823472 13447840 22000912
23:07:00 3846 8192000000 10776574672 11169038336 1834061232 18.292 100 81 162 0 1875053680 18224544 22767904
23:07:10 2828 8192000000 10784356448 11175059456 1840863056 18.348 100 83 164 0 1877752928 13195088 23694784
23:07:21 3346 8192000000 10788955760 11179499520 1847044896 18.398 100 83 167 1 1886202816 15470032 23687888
23:07:31 2172 8192000000 10792613360 11179704320 1850402416 18.425 100 83 166 2 1887222816 13334160 23486240
23:07:39 3138 8192000000 10791077264 11180834816 1856886288 18.478 100 88 175 6 1894207504 12692976 24628240
23:07:49 2813 8192000000 10799295968 11188228096 1860825664 18.510 100 94 188 2 1901043888 12910528 27307696
23:07:58 1820 8192000000 10808586448 11195531264 1863366976 18.531 100 87 174 0 1901449008 14302400 23779632
23:08:06 1852 8192000000 10807547616 11198767104 1864419376 18.539 100 89 179 2 1903247744 14251504 24576864
23:08:15 1986 8192000000 10799672032 11194900480 1863700720 18.533 100 85 170 1 1900904752 14081024 23123008
23:08:23 4800 8192000000 10800983744 11198140416 1865437920 18.547 100 82 165 2 1902001504 13758080 22805504
23:08:35 2014 8192000000 10823209632 11208126464 1870901648 18.592 100 94 188 0 1910733072 12619296 27212128
23:08:43 1724 8192000000 10819232928 11208232960 1873030544 18.609 100 90 181 1 1911717824 13865520 24821760
23:08:51 1651 8192000000 10820250928 11210055680 1876941808 18.640 100 91 182 1 1917113600 14709696 25462096
23:08:59 16235 8192000000 10806420208 11203395584 1871083856 18.593 100 71 142 0 1903552400 12548528 19920016
23:09:23 1160 8192000000 10815536816 11213213696 1878485216 18.653 100 91 183 2 1916974144 12744288 25744640
23:09:30 8833 8192000000 10817611584 11207696384 1876866512 18.640 100 72 140 1 1907605568 10949984 19789072
23:09:46 10871 8192000000 10808266112 11218358272 1878145824 18.650 100 62 124 2 1907402128 12196752 17059552
23:10:05 2481 8192000000 10795069424 11212255232 1877328928 18.644 100 48 96 2 1900843008 10449632 13064448
23:10:15 5706 8192000000 10798261312 11211390976 1881366080 18.676 100 48 96 0 1904561472 8144832 15050560
23:10:27 3196 8192000000 10793984656 11215507456 1884780512 18.704 100 42 85 2 1905816864 8965280 12071072
23:10:37 11032 8192000000 10804094368 11218112512 1884773152 18.704 100 28 56 0 1899782704 7033200 7976352
23:10:55 8742 8192000000 10798050992 11226091520 1888067280 18.730 100 33 66 3 1904941952 7896576 8978096
23:11:11 6534 8192000000 10800605136 11226718208 1890262896 18.748 100 35 70 0 1908921136 8848128 9810112
23:11:29 6235 8192000000 10806866416 11227615232 1891221136 18.756 100 33 66 1 1908871600 7942704 9707760
23:11:43 8355 8192000000 10790660400 11225571328 1890084128 18.746 100 20 39 1 1901656016 6165248 5406640
23:12:01 9968 8192000000 10810181376 11234054144 1893223712 18.772 100 23 46 1 1905201280 5940512 6037056
23:12:18 11184 8192000000 10799151088 11233755136 1894959968 18.786 100 17 34 1 1905535520 5705488 4870064
23:12:42 32035 8192000000 10803469856 11245678592 1898954384 18.818 100 25 50 2 1912540016 6331792 7253840
23:13:46 17118 8192000000 10821437952 11254804480 1904021104 18.859 100 28 56 1 1919304928 7497696 7786128
23:14:09 5354 8192000000 10817288704 11252883456 1902996096 18.850 100 25 46 3 1915705072 6706016 6002960
23:14:24 6336 8192000000 10823678816 11254833152 1906156624 18.876 100 29 58 1 1920527824 5960848 8410352
23:14:39 3643 8192000000 10828824384 11256913920 1909879808 18.906 100 46 92 3 1930378736 6468240 14030688
23:14:50 5957 8192000000 10817915840 11255721984 1907493968 18.887 100 31 62 1 1923470944 7443792 8533184
23:15:03 4427 8192000000 10829589456 11260354560 1908524160 18.895 100 29 58 6 1922769536 6858752 7386624
23:15:15 5805 8192000000 10816279392 11257782272 1911448640 18.918 100 29 58 3 1926479312 6247392 8783280
23:15:27 3915 8192000000 10837786000 11264684032 1917111168 18.964 100 40 80 1 1936301232 6386336 12803728
23:15:39 8188 8192000000 10827193280 11263094784 1914987456 18.947 100 25 50 1 1929426384 6719632 7719296
23:15:55 11038 8192000000 10798220304 11231203328 1858503712 18.491 97 17 34 2 1869732896 5451104 5778080
23:16:13 12169 8192000000 10816071600 11258552320 1907129616 18.884 100 14 28 0 1916716960 5586512 4000832
23:16:31 8223 8192000000 10826083424 11262382080 1912209824 18.924 100 18 35 2 1922738736 5561824 4967088
23:16:48 8471 8192000000 10832207296 11268169728 1915418320 18.950 100 21 42 2 1926897488 5403648 6075520
23:17:02 10296 8192000000 10819732416 11255259136 1910322208 18.909 100 21 42 2 1922129040 5969024 5837808
23:17:21 69238 8192000000 10791752416 11232931840 1800107216 18.015 94 21 42 1 1811000672 4822256 6071200
23:18:38 10161 8192000000 10788145536 11219861504 1858620736 18.492 98 20 40 2 1869384288 5141904 5621648
23:18:55 5599 8192000000 10796950608 11222249472 1846124096 18.391 98 26 52 2 1860446192 6850640 7471456
23:19:09 7234 8192000000 10788027936 11222638592 1879205840 18.659 100 27 54 3 1893728384 6326912 8195632
23:19:25 5749 8192000000 10792869232 11229175808 1877699216 18.647 100 29 56 1 1896341008 11149664 7492128
23:19:38 10461 8192000000 10724806368 11142590464 1692447040 17.122 91 15 30 2 1701349472 4977200 3925232
23:19:55 4245 8192000000 10720073712 11140132864 1792080768 17.949 99 36 72 2 1814795040 12299696 10414576
23:20:06 5974 8192000000 10741417888 11159572480 1812400928 18.116 99 23 46 2 1824768752 5690832 6676992
23:20:22 6161 8192000000 10724784864 11146878976 1793886512 17.964 98 30 59 2 1808378128 6196592 8295024
23:20:34 9359 8192000000 10713789472 11132035072 1756960928 17.659 97 19 38 1 1767772928 5063440 5748560
23:20:49 7663 8192000000 10683921392 11092877312 1692729104 17.124 94 18 36 1 1703396528 5458768 5208656
23:21:07 7478 8192000000 10683837136 11100864512 1717968848 17.335 96 29 57 2 1732009408 4829840 9210720
23:21:20 9761 8192000000 10691429872 11100479488 1714920304 17.310 96 20 40 1 1725978000 5014240 6043456
23:21:36 7727 8192000000 10700803904 11114573824 1775153984 17.810 100 24 48 1 1788261024 6317232 6789808
23:21:55 44152 8192000000 10723047408 11141275648 1797021632 17.989 99 29 58 2 1811696608 5408272 9266704
23:22:54 28438 8192000000 10715996016 11140935680 1787318720 17.910 98 17 34 0 1797426400 5323664 4784016
23:23:32 7250 8192000000 10740881056 11150753792 1814597200 18.134 100 28 55 1 1828158768 5734704 7826864
23:23:50 6472 8192000000 10730404272 11153031168 1802354416 18.033 99 20 38 3 1813022400 5595808 5072176
23:24:03 3863 8192000000 10747564656 11157737472 1822587136 18.199 100 34 66 1 1838192944 6703920 8901888
23:24:16 6815 8192000000 10753070576 11168555008 1819184304 18.171 99 36 72 2 1836180400 6317824 10678272
23:24:29 7927 8192000000 10762220672 11178106880 1835251728 18.302 100 23 46 1 1847303152 5725344 6326080
23:24:46 9893 8192000000 10756454288 11183812608 1842788976 18.364 100 21 41 2 1854020432 5498224 5733232
23:25:02 7519 8192000000 10759811536 11189051392 1848444208 18.409 100 28 55 2 1862268592 5809776 8014608
23:25:17 9862 8192000000 10761059280 11188822016 1847943472 18.405 100 16 32 1 1858005600 5609104 4453024
23:25:34 9829 8192000000 10775599328 11195748352 1850518400 18.426 100 20 40 1 1861384656 5553152 5313104
23:25:52 7874 8192000000 10775852448 11197030400 1855709168 18.468 100 26 49 1 1868670000 4770048 8190784
23:26:08 5104 8192000000 10773264192 11196112896 1856638544 18.476 100 25 50 0 1870340896 6346000 7356352
23:26:19 8887 8192000000 10766042304 11195744256 1856806848 18.477 100 16 31 1 1866909664 5296176 4806640
23:26:34 9365 8192000000 10775449264 11196305408 1856547328 18.475 100 17 34 0 1867071248 6022064 4501856
23:26:50 127752 8192000000 10815420288 11237126144 1874483312 18.621 100 27 53 0 1887266048 5147312 7635424
23:29:10 19412 8192000000 10829596160 11251744768 1903357024 18.853 100 41 81 2 1922491200 8094224 11039952
23:29:40 2907 8192000000 10854803424 11265880064 1914145472 18.940 100 64 128 0 1942123888 9014304 18964112
23:29:50 6964 8192000000 10846906336 11268276224 1917888432 18.970 100 53 107 3 1942068752 9864080 14316240
23:30:07 19430 8192000000 10862913552 11282731008 1929644048 19.064 100 53 106 1 1955573584 11123488 14806048
23:30:35 6449 8192000000 10867431296 11285340160 1932509280 19.087 100 54 107 0 1958561600 10786848 15265472
23:30:48 13041 8192000000 10871582448 11288961024 1936005744 19.115 100 55 111 0 1963043312 10501280 16536288
23:31:11 6772 8192000000 10881501856 11298373632 1942840256 19.169 100 65 130 1 1973974304 11774736 19359312
23:31:26 19281 8192000000 10882046880 11309748224 1944137456 19.180 100 52 104 1 1975420480 16420192 14862832
23:31:56 14203 8192000000 10877293936 11309547520 1948236592 19.212 100 43 86 2 1973571600 12952400 12382608
23:32:19 18069 8192000000 10878961632 11309506560 1947755664 19.209 100 41 82 1 1972965184 12775776 12433744
23:32:45 18675 8192000000 10883983440 11319664640 1952979712 19.250 100 35 70 3 1977608272 13567856 11060704
23:33:13 7642 8192000000 10893151664 11318607872 1956063936 19.275 100 39 79 1 1980155168 12201024 11890208
23:33:29 11396 8192000000 10905655312 11330822144 1964421488 19.341 100 64 128 1 1997441040 13397216 19622336
23:33:54 2898 8192000000 10901116464 11316006912 1949070064 19.219 99 60 118 3 1980157472 13429488 17657920
23:34:07 2346 8192000000 10911539200 11329323008 1967779744 19.368 100 59 116 3 2002069168 18137088 16152336
23:34:17 34861 8192000000 10919949376 11346980864 1971167232 19.395 100 64 128 0 2008066704 18363952 18535520
23:35:03 8989 8192000000 10920190816 11347890176 1972307680 19.404 100 55 106 2 2008238448 19635888 16294880
23:35:22 12742 8192000000 10922112880 11357409280 1980567856 19.469 100 59 118 1 2020922000 22216016 18138128
23:35:42 7358 8192000000 10930794704 11363737600 1985084592 19.505 100 59 115 0 2024282576 21006992 18190992
23:35:57 20527 8192000000 10930600512 11368316928 1968201776 19.371 99 45 89 1 2005825904 21859520 15764608
23:36:35 6898 8192000000 10915724224 11348234240 1970723040 19.391 99 35 70 1 2002982480 20894016 11365424
23:36:49 4238 8192000000 10943581424 11369136128 1992876304 19.567 100 54 105 2 2029698656 20546256 16276096
23:37:03 3491 8192000000 10946463440 11374415872 1994534960 19.580 100 59 116 1 2033900272 22270128 17095184
23:37:15 4396 8192000000 10943560352 11374657536 1996862432 19.598 100 68 134 2 2038928976 20678112 21388432
23:37:28 6144 8192000000 10948022816 11381530624 2000733088 19.629 100 67 133 2 2042127312 21314608 20079616
23:37:41 2829 8192000000 10967054384 11389272064 2008730640 19.692 100 81 162 3 2055051920 22744080 23577200
23:37:53 5175 8192000000 10958527088 11377192960 1993003376 19.568 99 78 156 2 2039797056 24668080 22125600
23:38:06 2193 8192000000 10961715328 11382562816 1991162480 19.553 99 81 162 0 2039527664 25204848 23160336
23:38:16 6818 8192000000 10966991296 11391410176 2009936384 19.701 100 72 141 1 2056004000 24849440 21218176
23:38:30 3273 8192000000 10964964400 11384647680 1994391600 19.578 99 76 149 1 2040896912 24716560 21788752
23:38:40 3569 8192000000 10958592816 11383468032 1988071152 19.529 99 76 151 1 2036056720 25644592 22340976
23:38:53 12169 8192000000 10962428672 11392356352 2006541360 19.674 100 68 136 2 2055738240 29114784 20082096
23:39:15 9387 8192000000 10961271376 11393998848 2005697264 19.668 100 62 122 0 2054703664 29520880 19485520
23:39:32 5484 8192000000 10965764704 11399065600 2009604192 19.698 100 66 132 0 2058630576 28654016 20372368
23:39:48 14953 8192000000 10971729968 11409854464 2016406000 19.752 100 66 129 1 2066795968 30554400 19835568
23:40:15 10387 8192000000 10965101616 11398008832 1991997360 19.560 99 66 131 1 2043314592 31290448 20026784
23:40:37 4461 8192000000 10971763920 11400306688 2006085296 19.671 100 70 140 2 2057048896 29652960 21310640
23:40:50 8396 8192000000 10967495168 11394834432 2001987392 19.638 100 70 140 0 2054143360 30697424 21458544
23:41:06 3426 8192000000 10977238896 11397005312 2002925888 19.646 100 82 164 0 2058110672 29556320 25628464
23:41:17 2248 8192000000 10978070544 11402526720 2009300304 19.696 100 81 163 0 2064964592 30859168 24805120
23:41:25 3254 8192000000 10977246912 11399249920 2004973472 19.662 100 85 168 0 2060559216 30237248 25348496
23:41:37 2447 8192000000 10978386448 11398565888 2005168144 19.663 100 84 169 1 2060744096 31485120 24090832
23:41:48 3147 8192000000 10958382672 11368898560 1978112832 19.450 100 90 179 1 2039109104 32404992 28591280
23:41:59 2349 8192000000 10958173408 11380023296 1985468272 19.508 100 83 164 0 2043518816 32367600 25682944
23:42:08 2185 8192000000 10963836384 11381518336 1986426944 19.516 100 87 176 0 2045239744 32175536 26637264
23:42:18 6112 8192000000 10967855456 11392159744 1996310640 19.594 100 77 154 1 2052562048 33062320 23189088
23:42:33 5087 8192000000 10959642368 11378581504 1987416384 19.523 100 67 134 2 2040056992 32080352 20560256
23:42:50 2150 8192000000 10937307472 11358375936 1967277952 19.364 99 78 156 1 2024178720 33439088 23461680
23:43:01 2422 8192000000 10967571616 11382112256 1990101744 19.545 100 80 158 0 2047760928 33667056 23992128
23:43:11 5305 8192000000 10953449152 11382018048 1981796688 19.479 100 69 137 1 2037656912 34324896 21535328
23:43:23 2063 8192000000 10953048624 11372462080 1977339856 19.444 100 70 139 1 2032520288 34152928 21027504
23:43:31 2375 8192000000 10934998912 11358162944 1965900256 19.353 100 85 170 1 2026688256 35314848 25473152
23:43:42 9822 8192000000 10926406128 11352563712 1957198304 19.284 100 65 130 0 2016271296 38378960 20694032
23:43:58 12460 8192000000 10916045776 11348463616 1937736240 19.129 99 61 122 1 1994442864 36559712 20146912
23:44:22 19736 8192000000 10924211792 11364392960 1953184080 19.252 100 54 107 2 2010565120 39992736 17388304
23:44:56 8024 8192000000 10932744304 11361435648 1960970192 19.314 100 64 128 2 2019683552 37985584 20727776
23:45:11 6615 8192000000 10916256416 11332866048 1930971600 19.075 99 62 124 5 1989168208 38165648 20030960
23:45:25 5209 8192000000 10932490784 11355975680 1958166352 19.291 100 64 128 3 2015558496 36802000 20590144
23:45:39 4929 8192000000 10950767920 11364483072 1964984096 19.346 100 78 152 3 2026739584 38579456 23176032
23:45:50 11863 8192000000 10916389280 11362283520 1947066944 19.203 99 49 98 1 2004294288 41969152 15258192
23:46:17 13126 8192000000 10916236112 11363516416 1948135296 19.212 99 33 66 1 1993367520 34181056 11051168
23:46:38 4141 8192000000 10936455856 11374895104 1968600000 19.374 100 42 82 0 2017578416 35081312 13897104
23:46:48 5373 8192000000 10921525456 11352735744 1940503040 19.151 99 43 86 1 1989126416 35134288 13489088
23:47:01 11405 8192000000 10932004832 11375366144 1970742944 19.391 100 35 70 3 2018833936 36680560 11410432
23:47:20 10417 8192000000 10915795008 11354501120 1947800880 19.209 99 31 62 1 1994087280 36201120 10085280
23:47:39 11871 8192000000 10936532976 11376648192 1967793792 19.368 100 42 84 1 2023506736 42224176 13488768
23:47:59 3990 8192000000 10951010640 11372118016 1953409632 19.254 99 74 145 4 2015360384 39657376 22293376
23:48:10 16851 8192000000 10904903088 11347161088 1914556304 18.943 98 51 100 1 1972960432 41497248 16906880
23:48:36 6795 8192000000 10922830320 11358334976 1917781200 18.969 98 51 100 2 1976717664 42106064 16830400
23:48:55 3054 8192000000 10940390320 11370893312 1955980768 19.274 100 69 134 1 2022988288 45911728 21095792
23:49:05 2066 8192000000 10937631392 11355992064 1933193504 19.092 99 83 166 0 2008877520 50043184 25640832
23:49:14 1678 8192000000 10939527696 11348889600 1946107952 19.195 100 89 178 0 2021784240 47739904 27936384
23:49:23 3505 8192000000 10949835696 11359764480 1948762944 19.217 100 86 172 2 2023013776 47029712 27221120
23:49:35 3989 8192000000 10925613840 11356110848 1928036080 19.051 99 54 108 2 1992108816 46352816 17719920
23:49:47 11931 8192000000 10896914784 11339206656 1902047152 18.843 98 43 86 2 1966034864 49701552 14286160
23:50:07 9192 8192000000 10915916704 11350589440 1936717648 19.121 100 34 68 1 1996114352 47101824 12294880
23:50:24 4254 8192000000 10936753568 11362959360 1934457552 19.103 99 75 145 4 2005347504 46724256 24165696
23:50:38 2237 8192000000 10938674992 11356200960 1943257344 19.173 100 82 164 1 2018595904 49294880 26043680
23:50:49 7783 8192000000 10942433856 11374166016 1951594048 19.239 100 62 125 0 2030929952 58946016 20389888
23:51:11 18479 8192000000 10929544160 11368620032 1948912656 19.218 100 32 64 3 2009399776 49132144 11354976
23:51:42 23017 8192000000 10924927744 11372302336 1940715664 19.152 99 35 70 2 2000072336 47738144 11618528
23:52:24 42497 8192000000 10917651872 11358289920 1942902144 19.170 99 38 76 0 1987956592 33170256 11884192
23:53:40 12398 8192000000 10916100288 11368517632 1952590944 19.247 100 26 52 2 2000826096 39509456 8725696
23:54:06 29667 8192000000 10890161968 11350163456 1919608448 18.984 99 23 46 1 1965174720 37766368 7799904
23:54:43 13000 8192000000 10896783808 11342131200 1923724784 19.017 99 39 78 1 1968936496 32697344 12514368
23:55:03 18729 8192000000 10894960064 11343413248 1942217040 19.164 100 26 52 1 1983468848 32353088 8898720
23:55:31 11478 8192000000 10884478448 11342077952 1922259520 19.005 99 21 41 0 1960975808 31815056 6901232
23:55:49 8525 8192000000 10905391824 11350196224 1942308848 19.165 100 28 56 1 1983224512 31258704 9656960
23:56:05 11303 8192000000 10890297008 11342323712 1920836832 18.994 99 26 52 1 1961554128 32584976 8132320
23:56:42 35935 8192000000 10892549472 11352756224 1929238816 19.061 100 14 28 1 1970200848 36034304 4927728
23:57:45 77622 8192000000 10873681216 11335917568 1907830768 18.889 98 16 31 1 1942820016 29955024 5034224
23:59:10 63493 8192000000 10899544848 11343736832 1955368768 19.269 100 19 37 0 1975131936 14923776 4839392
00:00:20 77928 8192000000 10904670528 11363672064 1953798992 19.257 99 23 47 1 1972779600 12900816 6079792
00:01:44 113926 8192000000 10876977248 11345756160 1851760432 18.436 94 9 18 1 1867935088 14147888 2026768
00:03:45 62506 8192000000 10886920160 11347841024 1896733088 18.800 97 4 8 0 1908947760 10497904 1716768
00:04:56 52943 8192000000 10920390160 11358289920 1961501680 19.318 100 38 75 0 1984548816 11812736 11234400
00:05:55 30856 8192000000 10909906528 11349082112 1951108640 19.235 99 51 105 4 1985681072 20209456 14362976
00:06:35 134252 8192000000 10895618192 11352801280 1950460464 19.230 99 34 68 1 1973157392 13011424 9685504
00:08:57 33666 8192000000 10917247856 11355111424 1947133008 19.204 99 45 88 5 1971724480 12577952 12013520
00:09:46 8030 8192000000 10891864752 11327430656 1942059024 19.163 99 45 88 2 1963821440 8891728 12870688
00:10:03 10946 8192000000 10907253104 11356483584 1964481872 19.342 100 40 79 4 1986434368 10467248 11485248
00:10:21 171246 8192000000 10939441296 11407347712 1943299328 19.173 98 34 68 1 1963899968 11384784 9215856
00:13:27 76082 8192000000 10939057408 11379597312 1921588752 19.000 96 29 58 1 1944756816 14759120 8408944
00:14:49 82466 8192000000 10893472416 11380473856 1934840016 19.106 98 25 50 1 1960164176 17981904 7342256
00:16:23 211674 8192000000 10916451968 11391188992 1978223520 19.451 100 6 12 0 1989094368 9473824 1397024
00:20:11 75738 8192000000 10912950384 11392712704 1989766480 19.542 100 9 19 0 2003212816 10951760 2494576
00:21:36 66093 8192000000 10903617984 11378225152 1973004576 19.409 99 18 36 1 1985857408 7342592 5510240
00:22:56 57143 8192000000 10893434848 11376193536 1951879408 19.241 98 10 20 0 1965484944 10739536 2866000
00:24:02 52450 8192000000 10899536528 11367985152 1944355200 19.181 98 21 42 1 1959992880 8624512 7013168
00:25:04 55866 8192000000 10886288304 11354890240 1923699232 19.016 97 22 42 0 1937412976 7890032 5823712
00:26:09 79944 8192000000 10898176304 11372879872 1924763712 19.025 97 15 29 2 1937159296 8619552 3776032
00:27:37 55722 8192000000 10877321280 11348451328 1882458400 18.685 95 17 34 0 1897834640 10584912 4791328
00:28:40 76178 8192000000 10869314304 11339055104 1837340704 18.319 93 12 24 1 1849849552 9376672 3132176
00:30:05 52175 8192000000 10851167792 11320709120 1852711184 18.444 95 10 20 0 1867852128 12204704 2936240
00:31:04 51969 8192000000 10892807184 11341623296 1897554960 18.807 97 25 50 1 1914198304 9582592 7060752
00:32:02 21166 8192000000 10877069184 11320897536 1902180560 18.844 98 42 81 1 1923364624 9961248 11222816
00:32:29 30328 8192000000 10881503648 11332608000 1915052928 18.947 99 44 88 1 1939030624 12107152 11870544
00:33:12 127500 8192000000 10896074064 11353231360 1883657440 18.695 96 26 52 0 1909238112 18426256 7154416
00:35:26 42806 8192000000 10895933920 11351089152 1932068288 19.083 99 24 48 3 1958657424 19763424 6825712
00:36:19 116244 8192000000 10883805344 11338403840 1840317920 18.343 95 13 26 0 1858882752 14819184 3745648
00:38:26 55431 8192000000 10872866352 11319664640 1868799648 18.575 96 32 64 1 1888538624 10895472 8843504
00:39:43 130044 8192000000 10867452032 11328159744 1862920160 18.527 96 14 27 2 1884545648 17899152 3726336
00:42:00 71148 8192000000 10887161888 11343732736 1908141520 18.892 98 33 66 0 1925508512 8231888 9135104
00:43:44 43119 8192000000 10876980640 11325419520 1926470544 19.039 99 47 94 4 1949918448 10045376 13402528
00:44:37 7787 8192000000 10888317696 11337838592 1946882592 19.202 100 50 101 0 1972958224 11916800 14158832
00:44:51 26273 8192000000 10903576080 11346460672 1934999200 19.107 99 58 116 3 1964249600 12703760 16546640
00:45:26 67543 8192000000 10852944704 11330408448 1924278800 19.021 99 11 22 0 1940824928 13744592 2801536
00:46:40 60242 8192000000 10880953760 11362414592 1954400688 19.262 100 21 41 1 1969955200 9751392 5803120
00:47:49 60264 8192000000 10863562048 11328077824 1903043104 18.851 97 22 44 0 1919421472 10029072 6349296
00:48:56 60480 8192000000 10852524576 11338428416 1903379104 18.853 98 14 28 0 1920026576 12824096 3823376
00:50:02 49738 8192000000 10860948624 11338039296 1936045696 19.115 100 11 22 0 1947591200 8247680 3297824
00:51:04 68057 8192000000 10841186304 11319967744 1886201280 18.715 97 12 24 1 1896866976 6894368 3771328
00:52:23 68967 8192000000 10855034976 11336384512 1915796448 18.953 99 26 51 2 1934766496 11715760 7254288
00:53:39 74852 8192000000 10855183072 11339415552 1918488544 18.975 99 9 18 0 1928402880 7613808 2300528
00:55:03 70675 8192000000 10882563824 11359617024 1934456784 19.102 99 12 23 2 1948390976 10161824 3772368
00:56:26 77991 8192000000 10870558096 11335467008 1855941744 18.470 95 16 32 1 1877827504 17312624 4573136
00:57:58 52626 8192000000 10883507936 11350773760 1927113424 19.044 98 25 50 2 1943826400 9691840 7021136
00:58:57 63523 8192000000 10900431280 11374690304 1960640016 19.311 100 24 46 1 1975804032 9113760 6050256
01:00:07 70895 8192000000 10907233152 11376910336 1926951152 19.042 97 11 22 0 1938451424 8741696 2758576
01:01:25 48649 8192000000 10920735360 11377864704 1948047888 19.211 98 29 58 0 1962723360 7025520 7649952
01:02:27 59838 8192000000 10908538688 11390664704 1971370048 19.396 100 14 28 1 1983076544 8147520 3558976
01:03:33 44683 8192000000 10918904800 11377790976 1949114000 19.219 98 34 68 1 1969981520 10565088 10302432
01:04:28 17026 8192000000 10929546480 11391971328 1985005504 19.504 100 46 92 1 2008930432 11022432 12902496
01:04:55 62701 8192000000 10904009248 11377426432 1926886288 19.042 97 29 58 1 1947151840 12362400 7903152
01:06:42 85260 8192000000 10869366416 11331297280 1882237312 18.683 96 7 14 1 1900770112 16653024 1879776
01:08:17 81112 8192000000 10876341648 11339788288 1869408608 18.579 95 15 29 0 1882316976 8844864 4063504
01:09:49 101382 8192000000 10879148000 11339227136 1890178784 18.747 97 38 76 3 1910547584 9021536 11347264
01:11:39 80022 8192000000 10860322496 11345903616 1906183856 18.876 98 12 24 0 1926616864 17568672 2864336
01:13:06 51717 8192000000 10852270944 11339022336 1898394592 18.813 98 10 20 0 1914058208 12611456 3052160
01:14:08 36910 8192000000 10833054144 11317960704 1891158128 18.755 98 6 12 0 1907631568 14935104 1538336
01:14:53 27419 8192000000 10839252176 11313352704 1905027344 18.867 99 7 14 0 1916918512 10553664 1337504
01:15:35 49794 8192000000 10818530224 11289489408 1855759216 18.469 97 14 28 0 1865843664 6445136 3639312
01:16:33 64116 8192000000 10856145072 11322904576 1909614368 18.904 99 15 29 2 1921599312 6986112 4998832
01:18:28 70525 8192000000 10845279184 11335577600 1921454960 18.998 99 12 24 0 1933958768 9224688 3279120
01:20:31 49417 8192000000 10832512224 11293650944 1816364800 18.148 94 18 36 0 1829105680 7645392 5095488
01:21:28 54860 8192000000 10820855536 11278254080 1818795712 18.168 95 14 29 1 1830020800 7453440 3771648
01:22:29 52256 8192000000 10838566880 11311398912 1907008048 18.883 100 26 52 0 1924084048 9740752 7335248
01:23:34 40295 8192000000 10843934080 11309957120 1882653920 18.687 98 37 74 4 1904330144 10829312 10846912
01:24:22 36457 8192000000 10835621472 11299033088 1845037328 18.382 96 27 54 2 1861403008 8927520 7438160
01:25:05 43351 8192000000 10829953296 11308625920 1889445216 18.741 99 24 48 1 1910302688 14491120 6366352
01:25:57 94158 8192000000 9273352864 9539829760 427989376 4.965 23 6 12 0 433826624 4145680 1691568

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-03-2021 01:28:27 to 15-03-2021 01:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 220 v_add_invoice_to_stock 335544517
except 18 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 15-03-2021 01:29:00 to 15-03-2021 01:29:01.

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

15.03.21 01:29:02. 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-15 01:29:05 No severe PSQL-related problems occured
15.03.21 01:29:06. End of report.