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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17475824 kB
MemAvailable 31462524 kB
Buffers 0 kB
Cached 14198708 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-22 22:27:06
DTS_END                         2020-12-22 22:27:06.8450
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36584
TRN_ID                          245688
ATT_ID                          672
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: 9340.25 24372 1120830
customer order: creation 171.89 375 20627
customer order: refuse 14.49 283 1739
order to supplier: creation 46.45 1212 5574
order to supplier: removal 3.43 81688 412
invoice (draft): creation 46.94 3218 5633
invoice (draft): removal 53.57 664 6428
invoice accept: apply 42.28 16920 5074
invoice accept: cancel 48.04 727 5765
customer reserve: creation 3862.31 170 463477
customer reserve: removal 4747.94 46 569753
realization accept: apply 83.65 188 10038
realization accept: cancel 86.73 90 10408
payment from customer: creation 61.03 137 7323
payment from customer: removal 5.81 116 697
payment to supplier: creation 49.78 165 5973
payment to supplier: removal 3.61 84 433
service: total inventory turnovers 4.83 873 580
service: total monetary turnovers 6.53 19 783
service: aggregate perf. data 0.91 17083 109
service: refresh index statistics 0.03 363375 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 22-12-2020 22:28:26 to 22-12-2020 22:28:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5015
TEST_TIME 2 5101
TEST_TIME 3 6820
TEST_TIME 4 8142
TEST_TIME 5 7029
TEST_TIME 6 6927
TEST_TIME 7 7378
TEST_TIME 8 7479
TEST_TIME 9 7391
TEST_TIME 10 7401
TEST_TIME 11 7808
TEST_TIME 12 8370
TEST_TIME 13 8763
TEST_TIME 14 9188
TEST_TIME 15 9247
TEST_TIME 16 9323
TEST_TIME 17 9418
TEST_TIME 18 9528
TEST_TIME 19 9879
TEST_TIME 20 9868
TEST_TIME 21 9700
TEST_TIME 22 10799
TEST_TIME 23 11567
TEST_TIME 24 11391
TEST_TIME 25 10951
TEST_TIME 26 10761
TEST_TIME 27 10940
TEST_TIME 28 10644
TEST_TIME 29 10480
TEST_TIME 30 10228
TEST_TIME 31 10450
TEST_TIME 32 10254
TEST_TIME 33 10192
TEST_TIME 34 10186
TEST_TIME 35 10409
TEST_TIME 36 10266
TEST_TIME 37 10157
TEST_TIME 38 10180
TEST_TIME 39 10034
TEST_TIME 40 9885
TEST_TIME 41 9889
TEST_TIME 42 9728
TEST_TIME 43 9711
TEST_TIME 44 9645
TEST_TIME 45 9680
TEST_TIME 46 9566
TEST_TIME 47 9606
TEST_TIME 48 9593
TEST_TIME 49 9598
TEST_TIME 50 9601
TEST_TIME 51 9578
TEST_TIME 52 9583
TEST_TIME 53 9676
TEST_TIME 54 9735
TEST_TIME 55 9671
TEST_TIME 56 9688
TEST_TIME 57 9732
TEST_TIME 58 9780
TEST_TIME 59 9853
TEST_TIME 60 9771
TEST_TIME 61 9623
TEST_TIME 62 9558
TEST_TIME 63 9671
TEST_TIME 64 9568
TEST_TIME 65 9549
TEST_TIME 66 9564
TEST_TIME 67 9484
TEST_TIME 68 9537
TEST_TIME 69 9562
TEST_TIME 70 9623
TEST_TIME 71 9641
TEST_TIME 72 9613
TEST_TIME 73 9606
TEST_TIME 74 9683
TEST_TIME 75 9646
TEST_TIME 76 9725
TEST_TIME 77 9698
TEST_TIME 78 9696
TEST_TIME 79 9717
TEST_TIME 80 9614
TEST_TIME 81 9591
TEST_TIME 82 9519
TEST_TIME 83 9572
TEST_TIME 84 9508
TEST_TIME 85 9446
TEST_TIME 86 9389
TEST_TIME 87 9331
TEST_TIME 88 9311
TEST_TIME 89 9293
TEST_TIME 90 9281
TEST_TIME 91 9293
TEST_TIME 92 9262
TEST_TIME 93 9356
TEST_TIME 94 9354
TEST_TIME 95 9365
TEST_TIME 96 9349
TEST_TIME 97 9390
TEST_TIME 98 9442
TEST_TIME 99 9416
TEST_TIME 100 9437
TEST_TIME 101 9481
TEST_TIME 102 9559
TEST_TIME 103 9568
TEST_TIME 104 9578
TEST_TIME 105 9514
TEST_TIME 106 9471
TEST_TIME 107 9462
TEST_TIME 108 9467
TEST_TIME 109 9484
TEST_TIME 110 9425
TEST_TIME 111 9383
TEST_TIME 112 9385
TEST_TIME 113 9353
TEST_TIME 114 9341
TEST_TIME 115 9389
TEST_TIME 116 9365
TEST_TIME 117 9365
TEST_TIME 118 9399
TEST_TIME 119 9386
TEST_TIME 120 9344

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-12-2020 22:28:30 to 22-12-2020 22:28:34.

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 1551334 1551334 0 0.00 0 22523 6 0 0
doc_list_biud 1551334 1551334 0 0.00 0 34507 22 0 0
sp_add_invoice_to_stock 5161 5074 87 1.68 24 181708 16920 0 87
sp_cancel_adding_invoice 5765 5765 0 0.00 5 103460 727 0 0
sp_cancel_client_order 1739 1739 0 0.00 4 11699 284 0 0
sp_cancel_customer_reserve 569753 569753 0 0.00 1 34509 47 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 3 10079 117 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 5986 84 0 0
sp_cancel_supplier_invoice 6436 6428 8 0.12 2 17135 665 0 8
sp_cancel_supplier_order 412 412 0 0.00 5 813399 81688 0 0
sp_cancel_write_off 10408 10408 0 0.00 1 10165 90 0 0
sp_client_order 20627 20627 0 0.00 3 32366 376 0 0
sp_customer_reserve 463477 463477 0 0.00 0 57506 170 0 0
sp_fill_shopping_cart 31834 31834 0 0.00 1 19716 39 0 0
sp_fill_shopping_cart_clo_res 463471 463471 0 0.00 0 18006 14 0 0
sp_get_clo_for_invoice 5068 5068 0 0.00 0 18380 317 0 0
sp_kill_cost_storno 17303 17303 0 0.00 0 22499 50 0 0
sp_kill_qstorno_ret_qs2qd 1156754 1156754 0 0.00 0 34504 25 0 0
sp_kill_qty_storno 609611 609611 0 0.00 0 34506 55 0 0
sp_lock_selected_doc 20913 20913 0 0.00 0 7217 6 0 0
sp_make_cost_storno 28402 28402 0 0.00 0 19945 57 0 0
sp_multiply_rows_for_pdistr 28402 28402 0 0.00 0 7877 32 0 0
sp_multiply_rows_for_qdistr 20627 20627 0 0.00 0 14971 167 0 0
sp_pay_from_customer 7323 7323 0 0.00 4 31533 137 0 0
sp_pay_to_supplier 5973 5973 0 0.00 5 21361 166 0 0
sp_payment_common 13296 13296 0 0.00 2 19144 33 0 0
sp_qd_handle_on_cancel_clo 1739 1739 0 0.00 0 11691 253 0 0
sp_qd_handle_on_invoice_upd_sts 10833 10833 0 0.00 0 28076 272 0 0
sp_qd_handle_on_reserve_upd_sts 10038 10038 0 0.00 0 32575 62 0 0
sp_reserve_write_off 10038 10038 0 0.00 6 32719 188 0 0
sp_supplier_invoice 5633 5633 0 0.00 7 84927 3218 0 0
sp_supplier_order 5574 5574 0 0.00 5 57998 1213 0 0
srv_aggregate_perf_data 109 109 0 0.00 2675 421702 17084 0 0
srv_fill_mon_cache_memory 142 142 0 0.00 867 165491 37048 0 0
srv_find_qd_qs_mism 1073262 1073262 0 0.00 0 9135 5 0 0
srv_make_invnt_saldo 580 580 0 0.00 32 30598 873 0 0
srv_make_money_saldo 783 783 0 0.00 1 266 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 224299 544652 363375 0 0
t$perf-abend:sp_add_invoice_to_stock 87 87 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5075 5075 0 0.00 0 17267 163 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 0 8290 129 0 0
t$perf-norm:sp_cancel_client_order 1739 1739 0 0.00 0 2176 11 0 0
t$perf-norm:sp_cancel_customer_reserve 652 652 0 0.00 0 8625 38 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 2121 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 435 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 428 428 0 0.00 0 3462 30 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 18753 1285 0 0
t$perf-norm:sp_cancel_write_off 1018 1018 0 0.00 0 1608 4 0 0
t$perf-norm:sp_client_order 20627 20627 0 0.00 0 6770 15 0 0
t$perf-norm:sp_customer_reserve 970 970 0 0.00 0 4095 10 0 0
t$perf-norm:sp_pay_from_customer 7323 7323 0 0.00 0 6408 8 0 0
t$perf-norm:sp_pay_to_supplier 5973 5973 0 0.00 0 6837 9 0 0
t$perf-norm:sp_reserve_write_off 10038 10038 0 0.00 0 6505 12 0 0
t$perf-norm:sp_supplier_invoice 5633 5633 0 0.00 0 5041 16 0 0
t$perf-norm:sp_supplier_order 5574 5574 0 0.00 0 4868 15 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 300 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 142 142 0 0.00 0 426 6 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 700 16 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 1437 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 18 5 0 0
v_add_invoice_to_stock 10310 10136 174 1.68 0 15042 21 0 174
v_all_customers 37710 37710 0 0.00 0 170 1 0 0
v_all_suppliers 30826 30826 0 0.00 0 18 1 0 0
v_all_wares 41254 41254 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 9912 23 0 0
v_cancel_client_order 3478 3478 0 0.00 0 5694 9 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 10022 23 0 0
v_cancel_customer_reserve 1304 1304 0 0.00 0 156 3 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 2423 9 0 0
v_cancel_supplier_invoice 872 856 16 1.83 0 16934 33 0 16
v_cancel_supplier_order 824 824 0 0.00 0 24776 44 0 0
v_cancel_write_off 2036 2036 0 0.00 0 576 11 0 0
v_max_id_clo_ord 5574 5574 0 0.00 0 716 1 0 0
v_max_id_clo_res 970 970 0 0.00 0 2192 6 0 0
v_max_id_ord_sup 5633 5633 0 0.00 0 3474 5 0 0
v_max_non_paid_invoice 1767 1767 0 0.00 0 1037 2 0 0
v_max_non_paid_realizn 3969 3969 0 0.00 0 8608 5 0 0
v_min_id_clo_ord 5574 5574 0 0.00 0 1175 4 0 0
v_min_id_clo_res 970 970 0 0.00 0 5003 13 0 0
v_min_id_ord_sup 5633 5633 0 0.00 0 4570 6 0 0
v_min_non_paid_invoice 5973 5973 0 0.00 0 6145 24 0 0
v_min_non_paid_realizn 7323 7323 0 0.00 0 6703 19 0 0
v_our_firm 10252 10252 0 0.00 0 10 1 0 0
v_reserve_write_off 20076 20076 0 0.00 0 20932 11 0 0
x_lock_depdocs_on_canc_invoice 11765 11765 0 0.00 0 13926 104 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 14547 300 0 0
x_make_qstorno_1000_1200 5574 5574 0 0.00 2 57960 1141 0 0
x_make_qstorno_1200_2000 5633 5633 0 0.00 4 84915 3077 0 0
x_make_qstorno_2100_3300 463477 463477 0 0.00 0 57495 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-12-2020 22:28:35 to 22-12-2020 22:28:39.

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:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:16 24192 8192000000 10246412704 10558001152 946694784 10.359 73 52 105 1 966359072 2526192 17138096
19:57:51 35555 8192000000 10357432080 10674143232 1406630048 14.654 100 90 180 1 1440981568 5092640 29258880
19:58:37 25648 8192000000 10377899040 10701324288 1429471744 14.857 100 90 180 0 1465888016 6683232 29733040
19:59:13 37708 8192000000 10411726752 10746130432 1459598224 15.122 100 89 178 1 1496457760 7820704 29038832
20:00:06 18359 8192000000 10431305504 10767929344 1489563344 15.385 100 82 164 0 1524931264 8538512 26829408
20:00:45 18464 8192000000 10459738272 10800926720 1516012176 15.616 100 86 172 0 1552597952 8956960 27628816
20:01:14 17425 8192000000 10490855488 10834034688 1550492752 15.914 100 82 164 1 1586186112 9844208 25849152
20:01:41 24049 8192000000 10538848912 10890969088 1580204736 16.170 100 76 151 1 1613260368 10485536 22570096
20:02:17 13573 8192000000 10556892752 10914205696 1613891296 16.458 100 79 158 1 1648860352 10998400 23970656
20:02:39 10779 8192000000 10577548800 10939576320 1630244192 16.597 100 79 156 0 1665687872 10985744 24457936
20:03:00 8295 8192000000 10601593584 10963214336 1663925728 16.882 100 80 160 1 1699151648 11482416 23743504
20:03:16 10864 8192000000 10622020976 10993651712 1686450992 17.072 100 77 152 4 1720182384 11546528 22184864
20:03:38 8883 8192000000 10648617440 11020128256 1705856848 17.234 100 78 154 1 1739700576 11631872 22211856
20:03:53 7783 8192000000 10660593136 11034300416 1719971760 17.352 100 81 162 0 1756287376 12845008 23470608
20:04:08 8201 8192000000 10665667408 11042394112 1728884256 17.426 100 72 144 0 1761898256 12711136 20302864
20:04:25 4746 8192000000 10692306528 11072512000 1756588928 17.656 100 77 154 2 1791407808 12450672 22368208
20:04:36 6575 8192000000 10707434064 11091476480 1767869680 17.749 100 78 156 0 1802870288 13041056 21959552
20:04:49 5057 8192000000 10709069696 11090227200 1774430080 17.804 100 82 162 3 1811331648 14103200 22798368
20:05:01 2732 8192000000 10723376336 11101872128 1781910800 17.865 100 83 166 0 1818703488 13752800 23039888
20:05:10 9281 8192000000 10725185088 11111608320 1787342960 17.910 100 75 150 0 1820814864 12299728 21172176
20:05:28 3970 8192000000 10743023344 11129249792 1794627536 17.970 100 84 168 1 1832020800 13601344 23791920
20:05:39 2687 8192000000 10744028400 11134046208 1808594064 18.084 100 78 155 0 1842361296 11925216 21842016
20:05:48 2839 8192000000 10754022432 11139416064 1812723552 18.118 100 79 156 2 1847413088 11875200 22814336
20:05:58 2486 8192000000 10752932032 11150692352 1827210240 18.237 100 69 138 0 1858223728 11772208 19241280
20:06:07 1901 8192000000 10771218352 11157532672 1829574384 18.256 100 80 160 0 1864177184 11653968 22948832
20:06:16 2016 8192000000 10785698480 11169632256 1840002144 18.341 100 87 174 3 1876860512 12724800 24133568
20:06:24 1953 8192000000 10782797088 11167748096 1843302960 18.368 100 91 182 2 1881506960 13359424 24844576
20:06:33 1442 8192000000 10787263376 11179343872 1845696816 18.387 100 88 177 2 1885315248 14769376 24849056
20:06:41 1542 8192000000 10785584160 11177930752 1851012768 18.430 100 81 160 4 1887003344 13720976 22269600
20:06:49 5197 8192000000 10793849600 11188088832 1853035504 18.447 100 85 169 0 1890092656 12601984 24455168
20:07:00 1587 8192000000 10807119824 11195719680 1859047920 18.496 100 90 181 1 1897909728 13577968 25283840
20:07:08 14545 8192000000 10780077712 11188273152 1854992432 18.463 100 59 118 2 1883324288 12206000 16125856
20:07:30 2259 8192000000 10785153152 11196473344 1860255488 18.505 100 55 110 0 1885915616 9619104 16041024
20:07:38 1998 8192000000 10777277680 11185823744 1857609200 18.484 100 52 104 3 1881777008 9520976 14646832
20:07:50 6261 8192000000 10773237104 11185127424 1858753552 18.493 100 37 75 0 1876730960 6501648 11475760
20:08:02 5644 8192000000 10764509440 11187990528 1863059376 18.528 100 36 72 1 1880874576 8123616 9691584
20:08:14 6347 8192000000 10773107968 11194187776 1862221520 18.521 100 45 90 1 1883180320 8299728 12659072
20:08:29 9069 8192000000 10770242896 11195813888 1864988784 18.544 100 29 58 0 1880160448 6956736 8214928
20:08:44 6994 8192000000 10769287552 11198058496 1868939408 18.576 100 36 72 0 1886724640 7162656 10622576
20:08:58 15995 8192000000 10769135488 11204640768 1869846208 18.583 100 26 52 0 1883391120 6557024 6987888
20:09:26 50437 8192000000 10809602432 11218968576 1875269680 18.627 100 27 54 1 1889356544 6074912 8011952
20:10:28 22555 8192000000 10781091552 11218841600 1876702960 18.638 100 23 45 3 1889017472 6093344 6221168
20:10:57 5764 8192000000 10810072080 11227209728 1879983152 18.665 100 26 51 2 1893416672 6225424 7208096
20:11:10 5918 8192000000 10806064864 11228246016 1882294512 18.684 100 26 50 0 1896043872 6026688 7722672
20:11:23 3297 8192000000 10819481296 11239940096 1883798608 18.696 100 36 73 0 1908884848 14905472 10180768
20:11:32 7740 8192000000 10801894496 11233300480 1887967104 18.729 100 35 71 2 1909658976 12062656 9629216
20:11:50 8004 8192000000 10804686944 11236040704 1887944096 18.729 100 21 42 1 1898994688 4905632 6144960
20:12:06 9087 8192000000 10812054848 11240644608 1889110320 18.739 100 20 40 1 1904237888 9850320 5277248
20:12:23 10785 8192000000 10810023760 11241390080 1892743680 18.768 100 18 34 1 1903526160 5995136 4787344
20:12:44 11582 8192000000 10820260304 11247697920 1897281632 18.804 100 20 38 3 1909165424 6254752 5629040
20:13:04 7223 8192000000 10808558000 11245006848 1898206624 18.812 100 18 36 1 1909011408 5264768 5540016
20:13:19 16444 8192000000 10805796912 11247403008 1900678016 18.832 100 15 30 0 1910920688 5481248 4761424
20:13:46 8617 8192000000 10825814176 11257319424 1905653968 18.872 100 26 52 1 1920510592 7099248 7757376
20:14:03 13496 8192000000 10808418112 11248001024 1898464944 18.814 100 16 32 2 1908566880 6128528 3973408
20:14:22 15592 8192000000 10809968704 11248922624 1901773056 18.841 100 40 80 0 1920246416 6297264 12176096
20:14:47 59469 8192000000 10820531120 11260211200 1906584704 18.879 100 23 47 1 1918090144 5710800 5794640
20:15:55 5048 8192000000 10818113376 11253866496 1902554832 18.847 100 20 40 2 1914726640 6250000 5921808
20:16:06 3657 8192000000 10826299408 11254775808 1902714192 18.848 100 33 64 1 1918893552 7077632 9101728
20:16:19 9573 8192000000 10813859408 11245588480 1879545392 18.661 99 22 44 2 1892177312 6560688 6071232
20:16:36 7410 8192000000 10808664016 11241226240 1887742704 18.728 100 22 44 0 1899549376 5433216 6373456
20:16:52 5560 8192000000 10793892480 11228803072 1876111360 18.634 99 33 66 1 1896251488 10298224 9841904
20:17:04 8871 8192000000 10779920304 11199967232 1784615440 17.887 95 31 63 0 1799185168 5266480 9303248
20:17:23 10617 8192000000 10745422448 11171921920 1771958320 17.783 95 20 40 0 1782610496 4801968 5850208
20:17:40 6121 8192000000 10736532448 11163750400 1774252320 17.802 96 28 54 1 1788370784 6346688 7771776
20:17:53 7967 8192000000 10694382272 11106570240 1664029808 16.883 91 21 42 0 1675611904 4858768 6723328
20:18:11 10835 8192000000 10689192560 11103731712 1725831600 17.401 96 15 30 1 1735424016 5068224 4524192
20:18:30 8234 8192000000 10676894432 11087994880 1683410256 17.046 94 21 42 1 1694487296 4946000 6131040
20:18:48 15294 8192000000 10672783792 11090927616 1651834224 16.780 93 30 61 0 1666390928 5346464 9210240
20:19:09 53531 8192000000 10673217360 11071799296 1656711360 16.821 93 30 60 1 1671041296 5396672 8933264
20:20:11 14136 8192000000 10666461760 11078455296 1706069696 17.236 97 17 33 1 1715739664 4851328 4818640
20:20:32 12534 8192000000 10701681120 11114082304 1758541008 17.672 99 21 41 1 1770070000 5894528 5634464
20:20:53 6346 8192000000 10712940240 11127042048 1779956688 17.849 99 25 50 1 1793027872 6069200 7001984
20:21:07 11372 8192000000 10729262064 11146706944 1811885744 18.111 100 36 73 1 1828533216 5990320 10657152
20:21:29 11675 8192000000 10723036176 11146063872 1771957968 17.783 98 20 41 2 1786746672 9794160 4994544
20:21:49 5750 8192000000 10727427728 11152662528 1816416256 18.148 100 21 42 2 1828646048 6299696 5930096
20:22:06 5887 8192000000 10746008208 11167096832 1832758832 18.282 100 27 53 1 1846176832 5500448 7917552
20:22:19 8234 8192000000 10742313968 11170701312 1834388240 18.295 100 31 62 1 1850739776 7382752 8968784
20:22:33 9962 8192000000 10753614336 11175874560 1835091888 18.301 100 19 38 1 1845123136 4877696 5153552
20:22:50 10928 8192000000 10743421216 11171708928 1838355328 18.327 100 17 33 0 1848238496 5044384 4838784
20:23:11 7259 8192000000 10755385872 11178897408 1840670336 18.346 100 23 46 0 1853716000 5827888 7217776
20:23:25 8615 8192000000 10761293696 11186315264 1846502864 18.394 100 25 51 1 1859225312 6122128 6600320
20:23:42 7096 8192000000 10761690688 11188133888 1850913920 18.430 100 21 42 0 1862890624 5129184 6847520
20:23:56 7976 8192000000 10763790176 11193831424 1852042960 18.439 100 17 32 0 1861751536 5175472 4533104
20:24:11 75047 8192000000 10771719968 11210866688 1864356112 18.539 100 31 62 1 1879328800 5350016 9622672
20:25:32 17712 8192000000 10788616464 11213365248 1869608736 18.581 100 26 52 1 1882814496 5631856 7573904
20:25:58 5913 8192000000 10787873712 11218436096 1877909376 18.648 100 42 84 0 1897191424 7191376 12090672
20:26:10 5396 8192000000 10801657472 11222925312 1878974736 18.657 100 41 81 2 1897695248 7736704 10983808
20:26:23 11127 8192000000 10798853728 11222990848 1874694352 18.622 100 25 50 2 1888508416 6768976 7045088
20:26:44 5936 8192000000 10787782672 11221651456 1876305456 18.635 100 20 38 2 1886535280 4797408 5432416
20:26:58 7660 8192000000 10796860640 11228303360 1883693536 18.695 100 19 38 1 1893977648 5271440 5012672
20:27:21 28184 8192000000 10845881328 11266363392 1911712656 18.920 100 43 87 2 1930178832 6253552 12212624
20:28:00 18963 8192000000 10846995760 11274960896 1924808704 19.025 100 49 97 3 1945421984 7472976 13140304
20:28:38 43481 8192000000 10859865040 11290058752 1933860016 19.098 100 39 78 0 1954495856 9407904 11227936
20:29:36 41970 8192000000 10880930112 11305107456 1941378304 19.158 100 33 66 0 1963192512 12439168 9375040
20:30:28 38294 8192000000 10879983856 11316514816 1949996240 19.226 100 43 87 2 1977224464 14540768 12687456
20:31:13 52494 8192000000 10881873968 11327676416 1954653168 19.264 100 28 56 3 1972321920 9788976 7879776
20:32:17 35741 8192000000 10894577952 11335196672 1962278128 19.324 100 39 78 1 1985104016 12148448 10677440
20:33:02 9819 8192000000 10879233680 11323469824 1947102032 19.203 99 31 61 2 1967069952 11577552 8390368
20:33:24 3523 8192000000 10892060080 11321077760 1951228784 19.236 99 67 130 3 1981599712 11384256 18986672
20:33:37 3273 8192000000 10909434208 11336974336 1970693552 19.391 100 70 140 1 2005332784 14697040 19942192
20:33:48 6535 8192000000 10909561632 11332530176 1966106400 19.355 100 65 130 1 1999894928 15451920 18336608
20:34:02 4809 8192000000 10921123184 11343843328 1968961424 19.377 100 56 111 1 2004161936 19741344 15459168
20:34:13 3279 8192000000 10915041568 11344961536 1973154832 19.410 100 59 119 1 2006628144 16075536 17397776
20:34:24 2901 8192000000 10927387792 11343986688 1974579664 19.422 100 67 134 3 2009873040 15759392 19533984
20:34:34 3012 8192000000 10936821040 11359469568 1989862288 19.543 100 87 169 0 2031962912 16840960 25259664
20:34:44 4174 8192000000 10939407424 11361955840 1992870144 19.566 100 75 146 3 2029900160 16295728 20734288
20:34:55 10551 8192000000 10925559760 11353579520 1966797184 19.360 99 61 122 1 2001487968 16756272 17934512
20:35:14 2319 8192000000 10937563600 11357192192 1985306816 19.507 100 82 164 0 2024756624 14725872 24723936
20:35:23 12175 8192000000 10926112960 11360108544 1988579808 19.533 100 57 112 2 2019533776 14634128 16319840
20:35:52 9797 8192000000 10946537040 11375243264 1996059296 19.592 100 62 124 1 2032235088 17472752 18703040
20:36:09 7128 8192000000 10939206752 11372716032 1980188864 19.466 99 51 102 2 2012568624 17217904 15161856
20:36:23 11951 8192000000 10932431248 11355484160 1968224432 19.371 99 62 124 1 2003842528 17498064 18120032
20:36:43 4640 8192000000 10940983792 11368173568 1971317408 19.396 99 60 120 1 2011788752 23044000 17427344
20:36:55 6235 8192000000 10920146096 11341352960 1955952144 19.274 99 68 136 3 1996655664 20013776 20689744
20:37:10 4617 8192000000 10934326752 11349516288 1971797888 19.400 100 80 159 1 2017642432 22534208 23310336
20:37:21 5567 8192000000 10922105456 11337445376 1962234336 19.324 99 74 148 0 2007879840 23919792 21725712
20:37:35 4877 8192000000 10932260928 11347578880 1971700144 19.399 100 79 156 2 2021127760 25187056 24240560
20:37:48 3237 8192000000 10930734944 11337707520 1943505008 19.175 98 88 170 4 1994866032 25460368 25900656
20:37:59 7027 8192000000 10930874384 11354976256 1969713568 19.383 100 69 137 2 2019232352 28445840 21072944
20:38:14 6866 8192000000 10938911520 11366285312 1981412688 19.476 100 63 124 3 2029146480 28386944 19346848
20:38:29 2765 8192000000 10925837344 11348434944 1967070240 19.362 100 61 121 2 2012991920 27128864 18792816
20:38:41 2805 8192000000 10936505600 11345739776 1950256384 19.229 99 82 164 1 2003176064 28743056 24176624
20:38:51 5173 8192000000 10898099424 11315167232 1913951344 18.938 98 70 140 2 1964456624 28899312 21605968
20:39:04 5041 8192000000 10909682864 11323973632 1934378112 19.102 99 77 153 0 1983277680 24653472 24246096
20:39:22 1743 8192000000 10907401136 11317305344 1932444176 19.086 99 84 162 0 1980551728 23458480 24649072
20:39:31 3188 8192000000 10905374640 11315204096 1926152512 19.036 99 79 158 4 1974099520 24629360 23317648
20:39:42 3032 8192000000 10881022912 11283034112 1909741808 18.905 99 85 169 2 1961434400 25730368 25962224
20:39:54 2186 8192000000 10885857824 11285663744 1914448144 18.942 99 78 153 1 1964145776 26315120 23382512
20:40:03 4842 8192000000 10893516224 11309314048 1933489104 19.095 100 76 152 1 1983056976 26452832 23115040
20:40:15 4513 8192000000 10879003856 11295674368 1911095280 18.915 99 60 120 2 1958336992 27823200 19418512
20:40:31 10109 8192000000 10892241056 11313876992 1931118400 19.076 100 53 105 2 1976388384 28863808 16406176
20:40:50 4183 8192000000 10874146672 11289071616 1884676304 18.703 98 70 139 1 1934600640 28357440 21566896
20:41:01 3060 8192000000 10874607504 11282882560 1901366320 18.837 99 75 148 2 1952616704 28721504 22528880
20:41:11 5936 8192000000 10893712640 11305824256 1924474160 19.023 100 76 152 4 1980600464 32270688 23855616
20:41:25 2165 8192000000 10898037888 11307474944 1929079168 19.060 100 72 141 0 1983339680 31094224 23166288
20:41:43 4462 8192000000 10880184400 11299643392 1920368464 18.990 100 65 130 1 1969339408 28130944 20840000
20:41:57 19345 8192000000 10881880720 11306332160 1923009776 19.011 100 56 110 0 1967448240 27784464 16654000
20:42:24 2192 8192000000 10886997344 11297206272 1908263728 18.893 99 63 126 2 1955508736 28039872 19205136
20:42:34 5210 8192000000 10885935936 11299651584 1917913776 18.970 99 67 132 1 1967736384 29692992 20129616
20:42:46 4290 8192000000 10900588656 11315916800 1920602096 18.992 99 67 134 1 1971640784 30808544 20230144
20:42:58 867 8192000000 10899300848 11307536384 1921837488 19.002 99 83 167 2 1979602112 32770400 24994224
20:43:12 3938 8192000000 10898238656 11328389120 1942002752 19.163 100 50 100 2 1991914256 34789104 15122400
20:43:49 12700 8192000000 10849211504 11274915840 1880601712 18.670 98 37 74 1 1923646512 30908496 12136304
20:44:16 8257 8192000000 10862201072 11291242496 1893680896 18.775 99 30 60 2 1932611296 28834320 10096080
20:44:33 6569 8192000000 10872994000 11302289408 1916266736 18.957 100 45 90 1 1962897472 31845264 14785472
20:44:47 9801 8192000000 10844680560 11279409152 1879586624 18.662 99 29 58 2 1919133104 29620832 9925648
20:45:04 18132 8192000000 10860533696 11286192128 1882225632 18.683 99 33 65 1 1925476096 31866656 11383808
20:45:33 7271 8192000000 10869040960 11285794816 1887845792 18.728 99 52 104 1 1938184592 33738288 16600512
20:45:47 6915 8192000000 10863276368 11295682560 1906912256 18.882 100 34 68 1 1953761312 35468240 11380816
20:46:00 11656 8192000000 10857491600 11298754560 1894425456 18.781 99 31 60 2 1934954304 31051488 9477360
20:46:20 2620 8192000000 10875367328 11304091648 1913521696 18.935 100 38 75 1 1954540768 29481472 11537600
20:46:32 21877 8192000000 10870811392 11314925568 1924821504 19.025 100 22 44 2 1962496128 29979136 7695488
20:47:13 26897 8192000000 10887145616 11321212928 1922004960 19.003 100 29 57 1 1963885728 32608256 9272512
20:47:51 22345 8192000000 10863493680 11295027200 1881384384 18.676 98 24 48 1 1924173040 34292240 8496416
20:48:20 10091 8192000000 10873001280 11307245568 1894600896 18.783 99 32 64 1 1943830288 38160256 11069136
20:48:46 13468 8192000000 10877379952 11316785152 1893351840 18.773 99 25 50 0 1946176560 43737344 9087376
20:49:09 37549 8192000000 10863416192 11320315904 1906537840 18.879 100 15 30 0 1950041856 37780112 5723904
20:49:53 52235 8192000000 10848797056 11311673344 1877296656 18.643 98 11 22 0 1900690960 19726368 3667936
20:51:03 16668 8192000000 10858447280 11302543360 1925008816 19.027 100 40 80 0 1950936368 13524288 12403264
20:51:26 81590 8192000000 10871257184 11314470912 1928425152 19.054 100 26 51 2 1949022656 13569696 7027808
20:53:16 29420 8192000000 10850020496 11298291712 1911851904 18.922 99 36 73 0 1937141840 14443280 10846656
20:53:53 27358 8192000000 10859134096 11317714944 1926408592 19.038 100 17 34 0 1952192816 20683360 5100864
20:54:31 36051 8192000000 10858366512 11328569344 1910021712 18.907 99 13 26 1 1936101536 22218720 3861104
20:55:32 61141 8192000000 10877006192 11312304128 1915642768 18.952 99 24 47 1 1934421728 11592400 7186560
20:56:40 49186 8192000000 10884492992 11327115264 1938624176 19.136 100 22 44 1 1966534032 20452592 7457264
20:57:40 34143 8192000000 10881608960 11324964864 1909559584 18.903 98 35 68 2 1944370880 23719808 11091488
20:58:30 71100 8192000000 10891510976 11339042816 1950123616 19.227 100 22 43 3 1968944400 13071344 5749440
21:00:07 106901 8192000000 10873632656 11320668160 1915769376 18.953 98 28 56 0 1941266688 18076464 7420848
21:02:19 66359 8192000000 10883371696 11343429632 1961596240 19.319 100 12 24 0 1973047824 8227184 3224400
21:03:36 14656 8192000000 10895483104 11348533248 1973017456 19.409 100 41 82 0 1992456080 7731968 11706656
21:03:58 23462 8192000000 10907254288 11358760960 1975464832 19.429 100 17 33 0 1987921696 8043376 4413488
21:04:35 45781 8192000000 10890789504 11361505280 1973151728 19.410 100 17 34 0 1986420448 8312544 4956176
21:05:33 56303 8192000000 10906018096 11367931904 1979036240 19.457 100 24 48 1 1996412336 9281328 8094768
21:07:20 61367 8192000000 10915707584 11384037376 1995253360 19.585 100 11 22 1 2009155984 11230928 2671696
21:10:25 33175 8192000000 10902232400 11374673920 1989814800 19.542 100 14 28 0 2000795232 6917712 4062720
21:11:05 24841 8192000000 10931298256 11379965952 1984597968 19.501 99 43 87 3 2006104816 8975440 12531408
21:11:38 72582 8192000000 10893462048 11384217600 1971609008 19.398 99 14 28 2 1987433856 11355664 4469184
21:13:51 64228 8192000000 10917981696 11400613888 1993565904 19.572 100 12 24 1 2009696272 12902528 3227840
21:15:01 61134 8192000000 10923167840 11385188352 1981740384 19.478 99 14 28 1 1997349952 11798032 3811536
21:16:20 90281 8192000000 10917369696 11383353344 1952628080 19.247 98 16 32 1 1964904992 7884848 4392064
21:17:59 16610 8192000000 10908427504 11353178112 1916793424 18.961 96 42 83 1 1935836752 7434192 11609136
21:18:27 45348 8192000000 10897560576 11354533888 1900217056 18.828 96 32 64 0 1919125344 9924544 8983744
21:19:21 45160 8192000000 10911354720 11374837760 1953482960 19.254 99 27 54 2 1977624112 16253472 7887680
21:20:21 77488 8192000000 10887078432 11359711232 1920260816 18.989 97 13 26 1 1941714256 18058288 3395152
21:21:48 24188 8192000000 10890639568 11347537920 1911915808 18.922 97 27 53 1 1927226128 7819968 7490352
21:22:20 62925 8192000000 10857853504 11310026752 1819121584 18.171 93 45 90 0 1845696000 13396384 13178032
21:23:31 40526 8192000000 10874621664 11332149248 1936501632 19.119 100 40 78 0 1960104848 12552752 11050464
21:24:23 58145 8192000000 10860089264 11329347584 1856901872 18.478 95 20 40 3 1879048432 16513872 5632688
21:25:27 126330 8192000000 10858645552 11310882816 1703661056 17.216 88 19 38 0 1728547120 19678736 5207328
21:27:40 107677 8192000000 10873953952 11326664704 1931138896 19.076 100 31 61 2 1957656720 17323072 9194752
21:29:45 50946 8192000000 10836192176 11301896192 1854452720 18.458 96 30 60 0 1882779024 20103376 8222928
21:30:42 60740 8192000000 10832554384 11305574400 1896239088 18.796 99 6 12 0 1913588480 16159136 1190256
21:31:49 59785 8192000000 10842203936 11312435200 1870651136 18.590 97 7 14 0 1884327200 11784256 1891808
21:32:58 78771 8192000000 10847722064 11307819008 1811546992 18.109 94 10 20 0 1829823488 15288688 2987808
21:34:26 70955 8192000000 10839772832 11301601280 1851678992 18.436 96 17 34 2 1873377200 16254016 5444192
21:35:44 76942 8192000000 10867414016 11332366336 1913922336 18.938 100 18 36 3 1940488176 20653936 5911904
21:37:25 39304 8192000000 10861345120 11317891072 1891636464 18.759 98 21 43 0 1911824208 13875216 6312528
21:38:29 23027 8192000000 10855047664 11299467264 1872474208 18.604 97 29 56 1 1888795552 8246432 8074912
21:39:02 65555 8192000000 10869392016 11326849024 1912278656 18.925 99 30 60 3 1935521136 14075504 9166976
21:40:47 56677 8192000000 10868423952 11329015808 1882385360 18.684 97 29 58 1 1908221552 17622528 8213664
21:41:55 34026 8192000000 10858574256 11315847168 1913758656 18.937 99 22 44 1 1932612048 13113440 5739952
21:42:36 36514 8192000000 10884560928 11340447744 1946342736 19.197 100 43 86 2 1969012128 9763840 12905552
21:43:24 165491 8192000000 10914184480 11370512384 1906351904 18.877 97 10 20 0 1924756608 15650560 2754144
21:47:53 74773 8192000000 10914939104 11373678592 1974137408 19.418 100 19 37 3 1988293088 8769072 5386608
21:49:33 33891 8192000000 10900647568 11348533248 1929130736 19.060 97 43 84 2 1954824784 13709728 11984320
21:50:29 82668 8192000000 10880054256 11367477248 1966003472 19.354 100 15 29 1 1988578592 17702144 4872976
21:51:58 35820 8192000000 10870229248 11344392192 1928145536 19.052 98 9 16 0 1943622224 13651792 1824896
21:53:29 39430 8192000000 10887545440 11367297024 1977302816 19.443 100 18 36 1 1990906160 7937472 5665872
21:54:14 105845 8192000000 10890736192 11374919680 1962554000 19.326 99 10 20 0 1975333024 10081536 2697488
21:56:14 63580 8192000000 10919986688 11381534720 1984317664 19.499 100 24 47 3 2006955328 16315024 6322640
21:57:28 38689 8192000000 10920305920 11393540096 1989701840 19.541 100 12 24 1 2004992288 11813088 3477360
21:58:18 73305 8192000000 10921795072 11388465152 1960710576 19.312 98 20 40 1 1976951840 11104592 5136672
21:59:46 79165 8192000000 10906470928 11377135616 1954337824 19.261 98 14 28 0 1970957168 12962576 3656768
22:01:15 63649 8192000000 10919038048 11398860800 1993992848 19.575 100 18 36 0 2008582656 9704144 4885664
22:02:25 68052 8192000000 10894622784 11363729408 1903008832 18.850 95 13 26 0 1915146192 8638464 3498896
22:03:47 26668 8192000000 10919277200 11375968256 1981847952 19.479 100 42 84 3 2004175232 11034832 11292448
22:04:45 75167 8192000000 10922550592 11401965568 1976126560 19.434 99 17 34 1 1995195408 14526256 4542592
22:06:06 68129 8192000000 10928124208 11384852480 1948513936 19.215 97 29 56 0 1966752272 10039760 8198576
22:07:28 30224 8192000000 10921127216 11385290752 1973375632 19.412 99 42 84 1 2000126256 14510368 12240256
22:08:11 78481 8192000000 10908267056 11401576448 1923093616 19.012 97 13 26 0 1948118688 21351456 3673616
22:09:55 114749 8192000000 10890595184 11359703040 1857194336 18.481 94 10 20 0 1876794720 17422064 2178320
22:11:57 75441 8192000000 10896344272 11360989184 1928024560 19.051 98 24 48 2 1948465488 13373760 7067168
22:13:26 112587 8192000000 10887551264 11355987968 1913680176 18.936 97 14 28 0 1935194400 16870432 4643792
22:15:48 38452 8192000000 10873093424 11352264704 1912473072 18.926 98 12 24 0 1935982288 19918688 3590528
22:16:42 68505 8192000000 10859341904 11334479872 1868582464 18.573 96 7 13 0 1883816848 13594800 1639584
22:17:57 73396 8192000000 10858957456 11325300736 1876645120 18.638 96 26 52 0 1896420032 11911408 7863504
22:19:21 90301 8192000000 10852882128 11309449216 1903463184 18.854 99 22 44 1 1922657760 12607984 6586592
22:21:01 69592 8192000000 10831048624 11306643456 1873744304 18.615 97 12 24 0 1889765904 12530656 3490944
22:22:35 82640 8192000000 10852850544 11316576256 1838196944 18.326 95 16 32 0 1852875520 10613472 4065104
22:24:06 40913 8192000000 10853545296 11319250944 1904960096 18.866 99 24 48 0 1927064080 14855568 7248416
22:24:59 78523 8192000000 10832658144 11308548096 1848511056 18.410 96 17 34 0 1866192400 12861536 4819808
22:26:26 60120 8192000000 9246185872 9511473152 376863520 4.398 20 5 10 1 382120096 3783808 1472768

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 22-12-2020 22:28:40 to 22-12-2020 22:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 87 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          246354
MON$OLDEST_ACTIVE               246355
MON$OLDEST_SNAPSHOT             246355
MON$NEXT_TRANSACTION            246355
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                       2021248
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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