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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17703128 kB
MemAvailable 31616140 kB
Buffers 0 kB
Cached 13968072 kB
SwapCached 2080 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-11-26 19:26:55
DTS_END                         2020-11-26 19:26:55.7270
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/34032
TRN_ID                          239218
ATT_ID                          693
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: 9399.19 17782 1127903
customer order: creation 173.89 344 20867
customer order: refuse 15.12 316 1814
order to supplier: creation 46.13 1203 5535
order to supplier: removal 3.38 107543 405
invoice (draft): creation 46.42 3529 5570
invoice (draft): removal 53.38 810 6405
invoice accept: apply 42.76 17639 5131
invoice accept: cancel 48.12 715 5774
customer reserve: creation 3959.03 174 475084
customer reserve: removal 4703.40 61 564408
realization accept: apply 85.40 165 10248
realization accept: cancel 89.46 115 10735
payment from customer: creation 61.68 92 7402
payment from customer: removal 5.66 72 679
payment to supplier: creation 49.49 100 5939
payment to supplier: removal 3.41 63 409
service: total inventory turnovers 4.90 1025 588
service: total monetary turnovers 6.72 40 806
service: aggregate perf. data 0.83 18326 100
service: refresh index statistics 0.03 203299 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-11-2020 19:27:46 to 26-11-2020 19:27:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4652
TEST_TIME 2 6467
TEST_TIME 3 5943
TEST_TIME 4 5473
TEST_TIME 5 5613
TEST_TIME 6 5538
TEST_TIME 7 5827
TEST_TIME 8 5630
TEST_TIME 9 5690
TEST_TIME 10 5689
TEST_TIME 11 5929
TEST_TIME 12 6009
TEST_TIME 13 6403
TEST_TIME 14 6523
TEST_TIME 15 6581
TEST_TIME 16 6749
TEST_TIME 17 7220
TEST_TIME 18 7782
TEST_TIME 19 7729
TEST_TIME 20 7850
TEST_TIME 21 8045
TEST_TIME 22 8239
TEST_TIME 23 8599
TEST_TIME 24 8763
TEST_TIME 25 9842
TEST_TIME 26 10945
TEST_TIME 27 10781
TEST_TIME 28 10599
TEST_TIME 29 10399
TEST_TIME 30 10243
TEST_TIME 31 10329
TEST_TIME 32 10336
TEST_TIME 33 10379
TEST_TIME 34 10219
TEST_TIME 35 10017
TEST_TIME 36 9935
TEST_TIME 37 9809
TEST_TIME 38 9731
TEST_TIME 39 9763
TEST_TIME 40 10068
TEST_TIME 41 10307
TEST_TIME 42 10236
TEST_TIME 43 10149
TEST_TIME 44 10015
TEST_TIME 45 9881
TEST_TIME 46 9804
TEST_TIME 47 9714
TEST_TIME 48 9660
TEST_TIME 49 9573
TEST_TIME 50 9568
TEST_TIME 51 9490
TEST_TIME 52 9446
TEST_TIME 53 9428
TEST_TIME 54 9451
TEST_TIME 55 9532
TEST_TIME 56 9516
TEST_TIME 57 9478
TEST_TIME 58 9459
TEST_TIME 59 9634
TEST_TIME 60 9673
TEST_TIME 61 9672
TEST_TIME 62 9749
TEST_TIME 63 9796
TEST_TIME 64 9805
TEST_TIME 65 9805
TEST_TIME 66 9686
TEST_TIME 67 9647
TEST_TIME 68 9579
TEST_TIME 69 9537
TEST_TIME 70 9525
TEST_TIME 71 9436
TEST_TIME 72 9428
TEST_TIME 73 9508
TEST_TIME 74 9517
TEST_TIME 75 9470
TEST_TIME 76 9454
TEST_TIME 77 9586
TEST_TIME 78 9577
TEST_TIME 79 9525
TEST_TIME 80 9597
TEST_TIME 81 9560
TEST_TIME 82 9624
TEST_TIME 83 9630
TEST_TIME 84 9636
TEST_TIME 85 9638
TEST_TIME 86 9567
TEST_TIME 87 9518
TEST_TIME 88 9486
TEST_TIME 89 9526
TEST_TIME 90 9454
TEST_TIME 91 9367
TEST_TIME 92 9361
TEST_TIME 93 9392
TEST_TIME 94 9413
TEST_TIME 95 9428
TEST_TIME 96 9472
TEST_TIME 97 9468
TEST_TIME 98 9600
TEST_TIME 99 9560
TEST_TIME 100 9574
TEST_TIME 101 9562
TEST_TIME 102 9583
TEST_TIME 103 9590
TEST_TIME 104 9571
TEST_TIME 105 9647
TEST_TIME 106 9596
TEST_TIME 107 9523
TEST_TIME 108 9475
TEST_TIME 109 9454
TEST_TIME 110 9385
TEST_TIME 111 9338
TEST_TIME 112 9374
TEST_TIME 113 9396
TEST_TIME 114 9378
TEST_TIME 115 9390
TEST_TIME 116 9367
TEST_TIME 117 9365
TEST_TIME 118 9331
TEST_TIME 119 9415
TEST_TIME 120 9410

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-11-2020 19:27:49 to 26-11-2020 19:27:53.

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 1565869 1565869 0 0.00 0 17498 6 0 0
doc_list_biud 1565869 1565869 0 0.00 0 33864 28 0 0
sp_add_invoice_to_stock 5243 5131 112 2.13 46 191141 17639 0 112
sp_cancel_adding_invoice 5774 5774 0 0.00 4 73667 716 0 0
sp_cancel_client_order 1814 1814 0 0.00 4 9071 316 0 0
sp_cancel_customer_reserve 564408 564408 0 0.00 1 26039 61 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 2 5886 72 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 1859 63 0 0
sp_cancel_supplier_invoice 6411 6405 6 0.09 2 16461 810 0 6
sp_cancel_supplier_order 405 405 0 0.00 5 1188073 107544 0 0
sp_cancel_write_off 10735 10735 0 0.00 1 12867 116 0 0
sp_client_order 20867 20867 0 0.00 3 17406 345 0 0
sp_customer_reserve 475084 475084 0 0.00 0 75978 175 0 0
sp_fill_shopping_cart 31966 31966 0 0.00 1 21095 38 0 0
sp_fill_shopping_cart_clo_res 475073 475073 0 0.00 0 12724 15 0 0
sp_get_clo_for_invoice 5114 5114 0 0.00 0 21014 272 0 0
sp_kill_cost_storno 17597 17597 0 0.00 0 6320 56 0 0
sp_kill_qstorno_ret_qs2qd 1146361 1146361 0 0.00 0 26007 33 0 0
sp_kill_qty_storno 604902 604902 0 0.00 0 33863 71 0 0
sp_lock_selected_doc 21259 21259 0 0.00 0 8327 5 0 0
sp_make_cost_storno 28702 28702 0 0.00 0 14231 47 0 0
sp_multiply_rows_for_pdistr 28702 28702 0 0.00 0 5593 25 0 0
sp_multiply_rows_for_qdistr 20867 20867 0 0.00 0 11499 154 0 0
sp_pay_from_customer 7402 7402 0 0.00 4 10782 92 0 0
sp_pay_to_supplier 5939 5939 0 0.00 4 14238 101 0 0
sp_payment_common 13341 13341 0 0.00 1 7650 23 0 0
sp_qd_handle_on_cancel_clo 1814 1814 0 0.00 0 9063 290 0 0
sp_qd_handle_on_invoice_upd_sts 10887 10887 0 0.00 0 33860 300 0 0
sp_qd_handle_on_reserve_upd_sts 10248 10248 0 0.00 0 19130 58 0 0
sp_reserve_write_off 10248 10248 0 0.00 6 19146 165 0 0
sp_supplier_invoice 5570 5570 0 0.00 6 103432 3529 0 0
sp_supplier_order 5535 5535 0 0.00 5 42934 1204 0 0
srv_aggregate_perf_data 100 100 0 0.00 2678 204034 18327 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 886 156220 33876 0 0
srv_find_qd_qs_mism 1078176 1078176 0 0.00 0 17498 6 0 0
srv_make_invnt_saldo 588 588 0 0.00 46 89483 1025 0 0
srv_make_money_saldo 806 806 0 0.00 1 11143 40 0 0
srv_recalc_idx_stat 4 4 0 0.00 75891 362083 203299 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5131 5131 0 0.00 0 16479 198 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 4021 83 0 0
t$perf-norm:sp_cancel_client_order 1814 1814 0 0.00 0 9069 18 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 1796 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 2053 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 2296 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 578 10 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 25589 1517 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 3475 10 0 0
t$perf-norm:sp_client_order 20868 20868 0 0.00 0 11104 18 0 0
t$perf-norm:sp_customer_reserve 1060 1060 0 0.00 0 692 3 0 0
t$perf-norm:sp_pay_from_customer 7402 7402 0 0.00 0 7225 12 0 0
t$perf-norm:sp_pay_to_supplier 5939 5939 0 0.00 0 7010 13 0 0
t$perf-norm:sp_reserve_write_off 10248 10248 0 0.00 0 10826 15 0 0
t$perf-norm:sp_supplier_invoice 5570 5570 0 0.00 0 6219 18 0 0
t$perf-norm:sp_supplier_order 5535 5535 0 0.00 0 11041 19 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 222 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 26 1 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 2582 29 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 670 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10450 10226 224 2.14 0 4215 18 0 224
v_all_customers 38492 38492 0 0.00 0 15 1 0 0
v_all_suppliers 30787 30787 0 0.00 0 23 1 0 0
v_all_wares 41734 41734 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 603 7 0 0
v_cancel_client_order 3628 3628 0 0.00 0 4472 5 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 5879 8 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 4016 7 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 1408 7 0 0
v_cancel_supplier_invoice 840 828 12 1.42 0 356 13 0 12
v_cancel_supplier_order 810 810 0 0.00 0 370 3 0 0
v_cancel_write_off 2118 2118 0 0.00 0 8481 19 0 0
v_max_id_clo_ord 5532 5532 0 0.00 0 1764 1 0 0
v_max_id_clo_res 1060 1060 0 0.00 0 2596 19 0 0
v_max_id_ord_sup 5567 5567 0 0.00 0 3972 3 0 0
v_max_non_paid_invoice 1644 1644 0 0.00 0 457 3 0 0
v_max_non_paid_realizn 3920 3920 0 0.00 0 2227 4 0 0
v_min_id_clo_ord 5532 5532 0 0.00 0 3887 5 0 0
v_min_id_clo_res 1060 1060 0 0.00 0 5128 10 0 0
v_min_id_ord_sup 5567 5567 0 0.00 0 5497 9 0 0
v_min_non_paid_invoice 5939 5939 0 0.00 0 3961 13 0 0
v_min_non_paid_realizn 7402 7402 0 0.00 0 7647 17 0 0
v_our_firm 10206 10206 0 0.00 0 16 1 0 0
v_reserve_write_off 20496 20496 0 0.00 0 4258 6 0 0
x_lock_depdocs_on_canc_invoice 11765 11765 0 0.00 0 19209 105 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 7639 331 0 0
x_make_qstorno_1000_1200 5535 5535 0 0.00 1 42670 1129 0 0
x_make_qstorno_1200_2000 5570 5570 0 0.00 3 103423 3388 0 0
x_make_qstorno_2100_3300 475084 475084 0 0.00 0 75977 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-11-2020 19:27:54 to 26-11-2020 19:27:58.

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
16:56:59 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:05 21862 8192000000 10269803472 10578022400 927660400 10.172 73 58 117 1 950229696 2771152 19798144
16:57:34 29944 8192000000 10346836080 10661761024 1389972432 14.506 100 86 172 0 1422711712 4759456 27979824
16:58:14 33176 8192000000 10378659888 10701803520 1431976400 14.879 100 88 176 1 1467215024 6444544 28794080
16:59:04 21097 8192000000 10406312144 10733457408 1463251760 15.154 100 92 185 0 1500682736 7388912 30042064
16:59:35 19082 8192000000 10422572592 10751266816 1476216800 15.268 100 89 178 1 1512438928 7838416 28383712
17:00:04 27719 8192000000 10441100096 10772262912 1489579312 15.385 100 88 176 1 1526493568 8645088 28269168
17:00:41 13573 8192000000 10444110848 10781876224 1506874160 15.536 100 91 183 1 1544925456 9101616 28949680
17:01:06 16000 8192000000 10460555696 10800963584 1518700592 15.639 100 78 156 1 1552056992 9049568 24306832
17:01:38 19577 8192000000 10504242864 10855985152 1564014256 16.031 100 73 146 2 1595556064 9306304 22235504
17:02:07 17177 8192000000 10532213136 10882822144 1588439504 16.240 100 85 171 1 1623879360 10173552 25266304
17:02:33 12540 8192000000 10557558464 10912542720 1617756336 16.491 100 86 171 3 1654344416 11266048 25322032
17:03:00 12204 8192000000 10585787008 10948071424 1640684224 16.686 100 77 154 1 1675324768 12196288 22444256
17:03:22 9630 8192000000 10602222720 10964582400 1658633536 16.837 100 75 150 1 1692558592 12120736 21804320
17:03:39 12170 8192000000 10619107776 10982322176 1676438752 16.987 100 83 166 0 1712694288 12389024 23866512
17:04:00 14424 8192000000 10649652272 11016691712 1707255104 17.246 100 79 156 0 1741308576 12272560 21780912
17:04:24 7580 8192000000 10658738720 11029143552 1719482096 17.348 100 87 174 3 1758069440 14092176 24495168
17:04:40 9049 8192000000 10668335648 11039490048 1728912272 17.426 100 81 162 1 1764754192 13198784 22643136
17:04:56 5411 8192000000 10677904272 11051577344 1738293840 17.504 100 77 152 3 1772841184 12917984 21629360
17:05:08 5795 8192000000 10685913344 11062812672 1748417248 17.588 100 84 169 0 1785443152 12937680 24088224
17:05:21 6690 8192000000 10695772000 11073896448 1755420000 17.646 100 86 171 2 1794063216 13707776 24935440
17:05:34 5994 8192000000 10703863712 11076976640 1766726208 17.740 100 79 155 2 1801989664 13559248 21704208
17:05:47 4315 8192000000 10717342176 11093377024 1772931296 17.791 100 81 160 1 1808594192 13595232 22067664
17:05:59 4347 8192000000 10729147152 11108380672 1780632720 17.855 100 83 161 0 1816345200 13546176 22166304
17:06:10 2764 8192000000 10731222288 11112828928 1791932320 17.948 100 85 169 1 1828958864 13724368 23302176
17:06:19 3908 8192000000 10739070400 11123933184 1797323712 17.992 100 81 162 1 1834237712 14028320 22885680
17:06:30 3660 8192000000 10748919424 11131047936 1806793296 18.070 100 91 181 1 1846212704 13783824 25635584
17:06:40 10028 8192000000 10749953392 11137486848 1810616960 18.101 100 84 166 0 1847381792 13934352 22830480
17:06:57 5390 8192000000 10755066576 11144228864 1816078480 18.146 100 76 151 2 1850711024 13715328 20917216
17:07:09 2511 8192000000 10771258592 11157114880 1830215120 18.261 100 86 171 2 1867615488 12719792 24680576
17:07:18 3380 8192000000 10779352112 11161812992 1836853200 18.315 100 91 182 3 1875557904 13109392 25595312
17:07:29 1442 8192000000 10774119920 11157835776 1837040784 18.317 100 87 177 1 1874014080 11978160 24995136
17:07:37 2384 8192000000 10782023184 11167588352 1842935872 18.365 100 87 175 1 1879776688 11947216 24893600
17:07:46 2352 8192000000 10785699616 11171647488 1844584032 18.378 100 90 180 2 1882672640 12998560 25090048
17:07:55 1896 8192000000 10791258960 11177545728 1845494096 18.386 100 94 188 0 1885409520 13459824 26455600
17:08:03 1170 8192000000 10794510992 11179446272 1850047824 18.423 100 92 185 3 1888763216 13155840 25559552
17:08:11 2372 8192000000 10796782496 11181322240 1854478880 18.458 100 95 190 3 1894414848 13934512 26001456
17:08:19 3178 8192000000 10798397664 11183067136 1855138752 18.464 100 88 175 0 1892724640 12923632 24662256
17:08:29 2800 8192000000 10800893968 11191300096 1857535968 18.483 100 91 182 0 1895614912 13265440 24813504
17:08:38 1562 8192000000 10807116704 11192807424 1860754144 18.509 100 94 189 1 1902006672 14941456 26311072
17:08:46 1244 8192000000 10812727424 11197808640 1860783280 18.510 100 90 180 0 1901685312 15072400 25829632
17:08:54 1894 8192000000 10811644912 11198885888 1864104400 18.537 100 95 186 1 1903519488 13374032 26041056
17:09:02 1678 8192000000 10803117344 11194417152 1867995088 18.568 100 93 186 1 1908512096 13583360 26933648
17:09:10 3012 8192000000 10808904688 11200401408 1868835104 18.575 100 81 162 1 1905492480 13272496 23384880
17:09:20 2032 8192000000 10817838416 11207708672 1872129072 18.601 100 87 172 1 1909780960 13308448 24343440
17:09:28 1191 8192000000 10809060912 11201150976 1870987920 18.592 100 88 175 2 1908875424 13778368 24109136
17:09:36 18108 8192000000 10823730128 11213737984 1874165184 18.618 100 86 171 2 1912837920 14028880 24643856
17:10:01 2072 8192000000 10824319424 11217563648 1879487600 18.661 100 89 178 1 1917871232 13475264 24908368
17:10:10 17739 8192000000 10782895088 11202691072 1871486064 18.596 100 47 93 2 1893713472 9875424 12351984
17:10:42 8309 8192000000 10770166912 11200442368 1868594464 18.573 100 33 66 1 1885893488 7940272 9358752
17:11:00 9015 8192000000 10775318000 11199967232 1874866144 18.624 100 30 60 2 1889862032 5080496 9915392
17:11:18 7058 8192000000 10780615280 11207364608 1872827664 18.607 100 24 48 3 1885733072 6353456 6551952
17:11:36 6363 8192000000 10788185264 11207524352 1870789776 18.591 100 22 44 0 1883435472 6512208 6133488
17:11:51 6528 8192000000 10777241776 11208867840 1875171392 18.626 100 21 42 0 1886725232 5286080 6267760
17:12:05 8305 8192000000 10796211600 11221221376 1878992240 18.657 100 34 67 0 1899584912 11294096 9298576
17:12:22 6244 8192000000 10783607536 11216945152 1878915216 18.656 100 19 38 0 1894160624 10375376 4870032
17:12:35 8984 8192000000 10777540272 11213762560 1879856352 18.664 100 25 49 4 1892142960 5668720 6617888
17:12:50 11831 8192000000 10794865680 11224051712 1884721248 18.703 100 24 48 3 1897429792 6296720 6411824
17:13:09 10462 8192000000 10784768288 11221925888 1883756320 18.695 100 20 40 2 1895756128 6290928 5708880
17:13:25 13765 8192000000 10787893056 11221659648 1883001952 18.689 100 16 31 0 1893228752 5671152 4555648
17:13:51 6784 8192000000 10792759792 11226079232 1885188640 18.707 100 18 35 1 1896531904 6437504 4905760
17:14:04 14522 8192000000 10781036048 11224104960 1886155392 18.715 100 16 32 3 1896688928 6309728 4223808
17:14:29 17782 8192000000 10807502416 11223154688 1872242384 18.602 99 27 55 3 1884842688 5567024 7033280
17:14:54 63115 8192000000 10794080368 11238498304 1893382864 18.773 100 43 88 0 1911932704 5168800 13381040
17:16:03 5875 8192000000 10812596800 11245031424 1895335376 18.789 100 30 61 1 1909356128 5513232 8507520
17:16:19 7670 8192000000 10811555872 11243298816 1895719216 18.792 100 26 50 6 1908069168 5647712 6702240
17:16:34 5755 8192000000 10808509792 11229892608 1879689712 18.663 99 31 62 3 1894802368 6694560 8418096
17:16:46 3768 8192000000 10785532672 11205287936 1840301040 18.343 98 37 74 1 1858578768 7393632 10884096
17:16:56 7050 8192000000 10795230624 11224563712 1881660272 18.679 100 20 39 2 1892299488 5348720 5290496
17:17:10 4590 8192000000 10801333968 11237707776 1888345536 18.732 100 24 48 1 1901763248 6808592 6609120
17:17:21 8905 8192000000 10815869168 11247403008 1900607360 18.831 100 21 42 3 1912256976 5519648 6129968
17:17:36 6657 8192000000 10782457632 11201855488 1806815728 18.070 95 26 52 1 1818772512 4728352 7228432
17:17:51 3494 8192000000 10788096320 11211198464 1853026816 18.447 99 28 56 4 1867336848 6302016 8008016
17:18:04 10471 8192000000 10779279952 11200856064 1851862320 18.437 99 20 40 1 1863058752 5697312 5499120
17:18:24 6361 8192000000 10784189968 11209035776 1832787824 18.282 98 20 40 0 1844787104 6408512 5590768
17:18:37 7975 8192000000 10747948544 11169812480 1764887552 17.725 95 21 39 1 1779963424 9596320 5479552
17:18:53 4950 8192000000 10705474656 11123204096 1749862224 17.600 96 21 42 0 1762187664 5523248 6802192
17:19:05 13430 8192000000 10724242368 11150417920 1785221632 17.892 98 16 32 1 1795379648 6023168 4134848
17:19:30 56506 8192000000 10683521440 11097714688 1701390832 17.197 94 33 66 0 1716312064 5746992 9174240
17:20:34 19005 8192000000 10683035152 11095695360 1654591216 16.803 92 15 29 2 1663754544 5197328 3966000
17:20:59 6678 8192000000 10657839136 11068178432 1711734288 17.283 97 37 73 2 1729600288 7296384 10569616
17:21:12 4888 8192000000 10688792144 11086958592 1731098816 17.445 98 30 60 3 1746497424 5868784 9529824
17:21:25 6748 8192000000 10672683088 11081822208 1729846096 17.434 98 28 56 3 1745048928 6836032 8366800
17:21:38 10279 8192000000 10695935776 11113664512 1731776000 17.450 97 17 31 1 1741476352 4887632 4812720
17:21:54 6294 8192000000 10706616688 11128868864 1798303152 18.000 100 32 65 0 1813396864 5186448 9907264
17:22:09 7057 8192000000 10710748816 11124789248 1764468192 17.721 98 25 49 0 1777811344 5708992 7634160
17:22:25 9187 8192000000 10700592096 11122089984 1767148288 17.743 98 25 50 2 1780968848 5587904 8232656
17:22:40 7807 8192000000 10718603728 11139022848 1801955568 18.030 100 31 62 0 1816956384 5913184 9087632
17:22:54 6892 8192000000 10722528528 11144904704 1812955376 18.120 100 19 38 1 1823766160 5224832 5585952
17:23:08 5912 8192000000 10742120352 11162640384 1823318096 18.205 100 24 49 1 1835662544 5318544 7025904
17:23:22 11774 8192000000 10750202576 11167875072 1813133312 18.122 99 28 56 1 1826249328 4896016 8220000
17:23:40 12785 8192000000 10739991088 11168567296 1829488992 18.255 100 23 46 1 1842082608 5424368 7169248
17:24:01 12024 8192000000 10752676256 11170873344 1838475088 18.328 100 33 66 1 1853918848 5974544 9469216
17:24:20 68911 8192000000 10751025344 11174371328 1818489872 18.165 99 26 53 0 1831371520 5396336 7485312
17:25:35 8815 8192000000 10764569584 11184287744 1838421760 18.328 100 28 56 0 1852612432 6438912 7751760
17:25:52 4772 8192000000 10772294352 11185033216 1843624864 18.370 100 42 85 1 1861999456 6719184 11655408
17:26:04 10378 8192000000 10778394064 11204046848 1856835120 18.478 100 33 66 2 1872061456 5579168 9647168
17:26:21 4050 8192000000 10787375232 11209924608 1869234816 18.578 100 36 73 2 1886056528 6608640 10213072
17:26:32 9066 8192000000 10797385216 11215806464 1872383840 18.604 100 25 51 1 1884787872 5301520 7102512
17:26:48 6438 8192000000 10792102896 11217252352 1877223152 18.643 100 28 56 0 1890921584 5880160 7818272
17:27:03 9598 8192000000 10810185024 11230105600 1885077776 18.706 100 29 56 0 1899244128 6396064 7770288
17:27:22 2785 8192000000 10849990256 11253641216 1905222880 18.868 100 72 143 2 1936129424 8764288 22142256
17:27:32 25489 8192000000 10848601712 11262369792 1906231952 18.876 100 53 106 0 1932685168 11550864 14902352
17:28:06 28773 8192000000 10845727856 11271507968 1918375520 18.974 100 74 148 3 1953833552 13889296 21568736
17:28:51 3700 8192000000 10856606656 11273715712 1918351040 18.974 100 50 100 1 1945803600 12339024 15113536
17:29:02 10127 8192000000 10852832016 11279032320 1923681264 19.016 100 52 104 0 1949418208 11321520 14415424
17:29:28 27245 8192000000 10860695536 11288743936 1928946608 19.058 100 45 90 0 1954307728 12018848 13342272
17:30:03 11720 8192000000 10865122400 11289583616 1927445504 19.046 100 42 84 1 1954168848 13934400 12788944
17:30:27 32399 8192000000 10874734368 11304427520 1936957712 19.122 100 45 90 4 1968742832 17892912 13892208
17:31:10 19926 8192000000 10882068112 11305484288 1936433680 19.118 100 31 62 1 1959910320 14427824 9048816
17:31:39 12522 8192000000 10891861696 11313598464 1931548576 19.079 99 47 93 1 1961693984 17124032 13021376
17:32:04 17278 8192000000 10900842848 11326939136 1952141312 19.244 100 50 100 2 1987253472 20446624 14665536
17:32:32 5693 8192000000 10909098544 11337334784 1958745120 19.296 100 51 100 5 1999046912 25970016 14331776
17:32:45 9381 8192000000 10907347392 11336826880 1959800960 19.304 100 47 94 2 2000497312 27030976 13665376
17:33:10 19095 8192000000 10912954160 11350081536 1971140176 19.394 100 44 87 1 2010935952 26123472 13672304
17:33:37 11295 8192000000 10927412816 11357519872 1976964656 19.441 100 51 102 1 2016773648 24176160 15632832
17:33:56 7744 8192000000 10937362016 11365978112 1987296720 19.522 100 51 102 3 2028675264 25668960 15709584
17:34:22 18755 8192000000 10940105952 11372118016 1986810752 19.519 100 49 98 0 2031453904 29815056 14828096
17:34:52 10122 8192000000 10951187984 11378634752 1988999264 19.536 100 49 98 2 2034373552 30453616 14920672
17:35:11 6027 8192000000 10946126640 11379494912 1996554112 19.596 100 59 114 0 2042873776 29257264 17062400
17:35:27 7679 8192000000 10955385056 11385626624 1993842208 19.574 100 48 96 0 2039516752 31352320 14322224
17:35:46 14533 8192000000 10950259984 11379703808 1984860576 19.503 99 67 134 1 2035414400 30910480 19643344
17:36:12 20482 8192000000 10954151664 11386269696 1995231728 19.585 100 55 109 2 2047048960 34805232 17012000
17:36:45 9904 8192000000 10962917680 11396988928 1995618944 19.588 100 56 112 0 2046791088 33358784 17813360
17:37:03 7748 8192000000 10956119984 11394224128 1996912832 19.598 100 47 94 0 2048181696 36701520 14567344
17:37:19 6003 8192000000 10958090512 11391766528 1995463344 19.587 100 61 119 2 2051044720 36488112 19093264
17:37:31 12031 8192000000 10960995936 11397951488 1998685808 19.612 100 53 104 1 2050825168 35273216 16866144
17:37:52 13940 8192000000 10959148544 11383681024 1989708800 19.541 100 60 120 2 2040572672 31277472 19586400
17:38:16 3667 8192000000 10952427104 11391037440 2000351952 19.626 100 51 102 1 2046095296 30636592 15106752
17:38:27 9108 8192000000 10953902032 11387039744 1983086528 19.489 99 67 134 3 2036014832 32240784 20687520
17:38:44 7778 8192000000 10968667440 11394945024 2001504320 19.635 100 67 134 0 2056869872 34793296 20572256
17:38:59 8239 8192000000 10969561120 11402809344 2001871392 19.637 100 64 125 2 2057093168 35592128 19629648
17:39:15 9980 8192000000 10966768144 11392143360 1983601472 19.493 99 59 118 1 2034687968 32749408 18337088
17:39:35 4796 8192000000 10978824688 11403898880 2004913104 19.661 100 65 128 0 2059458048 34746240 19798704
17:39:47 6318 8192000000 10946860704 11373588480 1968411600 19.373 98 69 138 0 2025648560 35811872 21425088
17:40:05 4156 8192000000 10958316464 11389009920 1994945728 19.583 100 60 120 2 2046418752 32716080 18756944
17:40:28 7276 8192000000 10969021536 11398647808 2006876016 19.677 100 66 129 1 2061168912 33116192 21176704
17:40:46 7853 8192000000 10966703536 11400560640 1985501728 19.508 99 66 132 1 2047627152 41280016 20845408
17:41:07 6477 8192000000 10985754304 11412062208 2005004976 19.662 100 63 126 0 2062152528 36978144 20169408
17:41:23 3786 8192000000 10989855200 11419238400 2013815792 19.732 100 62 124 0 2071448960 37890576 19742592
17:41:36 11008 8192000000 10988618048 11423723520 2014831312 19.740 100 61 122 0 2072921136 39408896 18680928
17:41:56 5593 8192000000 10985777232 11414392832 1994660944 19.581 99 68 136 0 2057111216 41187328 21262944
17:42:09 2371 8192000000 10991237968 11415662592 2009263152 19.696 100 88 174 1 2078598672 42818976 26516544
17:42:18 2098 8192000000 11002024960 11420340224 2014757040 19.739 100 89 182 1 2083522368 42516080 26249248
17:42:31 11298 8192000000 10982434160 11409043456 1998860944 19.614 100 80 160 0 2067745856 44258672 24626240
17:42:49 6219 8192000000 10971436752 11399270400 1973719824 19.415 99 62 124 0 2038532496 45531856 19280816
17:43:04 6451 8192000000 10953765888 11377569792 1974016544 19.417 99 68 136 0 2039798272 44697984 21083744
17:43:19 1945 8192000000 10966424000 11386228736 1983791456 19.495 100 81 159 1 2054478000 45365712 25320832
17:43:29 3075 8192000000 10986844928 11402747904 1991614864 19.557 100 81 162 0 2062239328 46089536 24534928
17:43:38 1882 8192000000 10983625024 11394572288 1970255248 19.387 99 88 175 1 2045741664 47880704 27605712
17:43:48 1965 8192000000 10991422896 11401224192 1993983568 19.575 100 92 185 1 2071442640 48975104 28483968
17:43:57 2171 8192000000 10979244976 11394293760 1977071952 19.442 99 84 168 0 2047532064 44136160 26323952
17:44:06 2126 8192000000 10978599376 11399311360 1988995696 19.536 100 67 133 1 2054751856 45138224 20617936
17:44:22 7842 8192000000 10987638944 11411095552 2001500064 19.635 100 62 124 0 2067427600 46403680 19523856
17:44:37 9638 8192000000 10973540640 11417931776 2005655968 19.667 100 44 88 1 2067120384 46403024 15061392
17:44:54 4050 8192000000 10985876320 11423084544 2015455488 19.744 100 44 88 2 2068585536 38841168 14288880
17:45:09 2785 8192000000 10998143280 11419856896 1999011504 19.615 99 65 128 1 2059790176 40322448 20456224
17:45:19 3969 8192000000 11007569504 11428810752 2020360800 19.783 100 78 155 2 2086181040 42480432 23339808
17:45:37 2921 8192000000 10981407584 11397337088 1974839088 19.424 98 79 157 1 2044140736 45014096 24287552
17:45:46 1937 8192000000 10996015008 11416281088 2004048976 19.655 100 80 158 1 2074086880 45601456 24436448
17:45:58 1712 8192000000 10989674736 11398201344 1989526080 19.540 100 88 171 1 2061396944 45099872 26770992
17:46:09 3299 8192000000 10966909136 11378741248 1966415184 19.357 100 82 164 0 2043109232 50849600 25844448
17:46:19 11579 8192000000 10909433888 11343327232 1914579248 18.943 98 60 119 1 1981136176 47079264 19477664
17:46:48 4966 8192000000 10896054608 11327283200 1917931392 18.970 99 37 74 2 1978085296 47062720 13091184
17:47:11 12872 8192000000 10917525424 11350503424 1923400800 19.014 99 37 74 1 1983124720 47150960 12572960
17:47:32 3450 8192000000 10940413216 11355111424 1937702336 19.128 99 73 146 2 2007424512 46509696 23212480
17:47:42 3790 8192000000 10946764736 11364716544 1938935488 19.138 99 76 149 4 2011983168 49753632 23294048
17:48:05 5504 8192000000 10926161776 11358920704 1944244816 19.181 100 48 96 2 2011161008 51537376 15378816
17:48:20 16630 8192000000 10910863472 11344437248 1924414224 19.022 99 35 69 0 1986872016 50452992 12004800
17:48:44 18220 8192000000 10899685376 11336736768 1896027280 18.794 98 39 78 1 1963345216 54608560 12709376
17:49:19 15390 8192000000 10905320816 11346104320 1930444704 19.070 100 29 58 0 1986041152 45247632 10348816
17:49:45 14267 8192000000 10890520032 11331026944 1917485344 18.967 100 32 61 2 1980078224 50536928 12055952
17:50:11 25467 8192000000 10892530560 11333877760 1906272416 18.877 99 26 52 0 1966173120 49864848 10035856
17:51:11 29424 8192000000 10899275744 11354312704 1899039776 18.819 99 25 49 1 1964806304 55886736 9879792
17:51:47 29955 8192000000 10858454992 11324518400 1889597056 18.743 99 18 36 0 1943748160 47040784 7110320
17:52:23 24245 8192000000 10858667856 11312496640 1917122720 18.964 100 26 52 3 1944538176 19678912 7736544
17:53:02 37738 8192000000 10868008752 11308011520 1869412640 18.580 97 20 40 1 1883718720 8087200 6218880
17:53:47 109463 8192000000 10869521280 11315298304 1914677200 18.944 99 41 82 5 1935090752 9060528 11353024
17:56:01 87053 8192000000 10855363424 11309703168 1857649136 18.484 96 17 34 1 1871811120 9743104 4418880
17:57:35 49313 8192000000 10883225168 11315769344 1889366800 18.741 97 41 80 3 1912701568 11358320 11976448
17:58:36 58587 8192000000 10854186240 11319304192 1900724192 18.832 98 20 40 2 1927694976 20914576 6056208
17:59:59 72646 8192000000 10886593648 11346051072 1934642496 19.104 99 25 50 1 1962033200 19289024 8101680
18:01:21 28497 8192000000 10890393648 11338559488 1919213488 18.981 98 19 40 3 1943084304 18251856 5618960
18:01:56 882 8192000000 10934093744 11352047616 1963355952 19.333 100 89 176 1 2008677424 19940144 25381328
18:02:03 50009 8192000000 10902672720 11355107328 1942260640 19.165 99 44 88 1 1979745776 24510736 12974400
18:03:00 26800 8192000000 10892057088 11342520320 1946865600 19.202 99 31 60 1 1976747728 21438240 8443888
18:03:44 31019 8192000000 10939012448 11377692672 1981708320 19.478 100 48 96 2 2019365872 23292000 14365552
18:04:25 44286 8192000000 10934628160 11391504384 1981795840 19.479 100 34 68 0 2020620672 28306224 10518608
18:05:38 49145 8192000000 10913073936 11408367616 1972442368 19.405 100 17 34 2 2012302512 33742400 6117744
18:07:15 30531 8192000000 10898341568 11384303616 1967160832 19.363 100 22 44 2 1996876880 22202272 7513776
18:07:52 53747 8192000000 10876762400 11357102080 1944412608 19.182 99 5 10 0 1954554336 8677120 1464608
18:08:54 70754 8192000000 10883676240 11362164736 1961874064 19.321 100 9 18 0 1973464848 8919264 2671520
18:10:11 13955 8192000000 10883134704 11363737600 1965951664 19.353 100 5 10 1 1974681632 7481488 1248480
18:10:32 46331 8192000000 10899471312 11356864512 1937330272 19.125 98 34 67 0 1954775520 7509952 9935296
18:11:31 88330 8192000000 10888486624 11364323328 1968798240 19.376 100 12 24 0 1981452416 9523872 3130304
18:13:14 34090 8192000000 10896374784 11373674496 1976961104 19.441 100 13 26 1 1994622992 14063456 3598432
18:14:01 71284 8192000000 10889598400 11348877312 1934746208 19.105 98 30 61 2 1954772720 11212384 8814128
18:15:21 38842 8192000000 10883447776 11354177536 1962465440 19.326 100 18 36 1 1978756720 11128912 5162368
18:16:13 53028 8192000000 10887607600 11360997376 1947409904 19.206 99 10 20 0 1959262976 9206544 2646528
18:17:12 72586 8192000000 10890610512 11373490176 1973848720 19.416 100 9 18 0 1985717360 9301168 2567472
18:18:31 35146 8192000000 10910927424 11386789888 1984084128 19.497 100 14 28 2 1995832032 7410336 4337568
18:19:13 50111 8192000000 10916902944 11389882368 1988020064 19.528 100 15 30 2 2002349792 9506080 4823648
18:20:27 49061 8192000000 10912941408 11385004032 1958821792 19.297 98 29 58 1 1979570400 12107920 8640688
18:21:33 76881 8192000000 10869691600 11342725120 1851549920 18.435 94 11 22 0 1864399920 10247568 2602432
18:22:56 36367 8192000000 10910459008 11376259072 1950504896 19.230 99 21 42 2 1964335472 8023760 5806816
18:23:39 23176 8192000000 10877293664 11338723328 1858288048 18.489 94 26 52 0 1873467056 7723232 7455776
18:24:08 54904 8192000000 10866285808 11339173888 1887575920 18.726 97 15 30 0 1904422992 12538496 4308576
18:25:12 84368 8192000000 10840222944 11309441024 1766406704 17.737 91 6 12 0 1780912368 13078048 1427616
18:26:43 51742 8192000000 10869070368 11325726720 1917866144 18.970 99 21 42 1 1931766848 8287488 5613216
18:27:45 34353 8192000000 10889489184 11340910592 1910332640 18.909 98 35 70 0 1928953584 9339936 9281008
18:28:26 81794 8192000000 10878268656 11360391168 1908487376 18.895 98 16 32 1 1931109904 18410768 4211760
18:29:54 46519 8192000000 10881420912 11340804096 1907976384 18.890 98 17 34 2 1929334432 16372192 4985856
18:31:26 29648 8192000000 10869784960 11321004032 1926533200 19.039 100 52 104 0 1951652816 11048448 14071168
18:32:25 98939 8192000000 10878741776 11342057472 1925596640 19.032 99 45 89 1 1954623824 16429536 12597648
18:34:29 33570 8192000000 10851786672 11321782272 1901998512 18.842 98 16 32 1 1921927344 14552784 5376048
18:35:09 16170 8192000000 10853140192 11322798080 1924604880 19.024 100 9 17 1 1941718064 14458032 2655152
18:35:40 65173 8192000000 10853791376 11334787072 1904849904 18.865 98 19 38 1 1932534752 22424928 5259920
18:36:55 47884 8192000000 10854872800 11329859584 1912300000 18.925 99 10 19 3 1932688096 17464032 2924064
18:37:49 40354 8192000000 10848989168 11312504832 1886439152 18.717 98 8 16 1 1908194912 19440480 2315280
18:38:35 61426 8192000000 10840849888 11298095104 1856494128 18.475 97 22 43 1 1877189808 13716592 6979088
18:39:49 26526 8192000000 10841665008 11299098624 1874474768 18.620 98 10 20 0 1884196592 7097296 2624528
18:40:24 69827 8192000000 10868203360 11329171456 1910053552 18.907 99 15 29 1 1922526960 8104672 4368736
18:41:41 25110 8192000000 10905252544 11350953984 1951904336 19.242 100 44 88 3 1974813760 10218368 12691056
18:42:14 34524 8192000000 10887670384 11341262848 1929505424 19.063 98 51 103 0 1957818480 13854480 14458576
18:42:58 84902 8192000000 10877333520 11358871552 1920068736 18.987 99 15 30 1 1939661456 15456272 4136448
18:44:30 56599 8192000000 10863696928 11325554688 1844821584 18.380 95 8 16 0 1856142944 9310112 2011248
18:45:32 69741 8192000000 10883708224 11341860864 1921647856 19.000 99 19 36 0 1939593632 12634576 5311200
18:46:50 65047 8192000000 10888284960 11334713344 1899350752 18.821 97 41 82 0 1920883152 9943104 11589296
18:48:13 39784 8192000000 10857722768 11332583424 1904262208 18.861 98 18 36 1 1919198736 10060272 4876256
18:49:01 98022 8192000000 10872957600 11348664320 1912398000 18.926 98 20 40 1 1930576896 12972912 5205984
18:50:50 132736 8192000000 10856102416 11321602048 1908197840 18.892 98 15 30 0 1928852752 16666560 3988352
18:53:13 64154 8192000000 10875242160 11331604480 1927548992 19.047 99 33 66 0 1946120608 8799952 9771664
18:54:24 4004 8192000000 10883581280 11339210752 1951026816 19.235 100 32 63 0 1967931824 7562576 9342432
18:54:35 62638 8192000000 10880883248 11367829504 1962797360 19.328 100 25 46 0 1977585200 7907312 6880528
18:55:51 68901 8192000000 10882300288 11365158912 1949711408 19.224 99 7 14 0 1966362944 14921760 1729776
18:57:06 37388 8192000000 10904202256 11382984704 1979713088 19.462 100 15 30 0 1999995712 16269600 4013024
18:58:04 77326 8192000000 10911937296 11395002368 1984489264 19.500 100 16 32 1 2007308368 18710880 4108224
18:59:28 60227 8192000000 10907671392 11397365760 1959654576 19.303 99 12 24 1 1978010656 15028096 3327984
19:00:34 86096 8192000000 10921638112 11402342400 1992987504 19.567 100 16 32 0 2007325280 10029920 4307856
19:02:11 115480 8192000000 10935892048 11404873728 1900879024 18.833 95 19 36 0 1925408112 19094160 5434928
19:04:33 61711 8192000000 10930949248 11373092864 1949503200 19.223 98 41 82 1 1974826240 12847984 12475056
19:05:40 17575 8192000000 10935583792 11382067200 1981066624 19.473 100 57 116 1 2005275472 8439504 15769344
19:06:04 16651 8192000000 10932694224 11382751232 1989317440 19.538 100 52 105 0 2013585440 9223952 15044048
19:06:27 21651 8192000000 10921460656 11385065472 1970065664 19.386 99 36 72 2 1990915424 10640880 10208880
19:06:56 65137 8192000000 10911655632 11366297600 1894156656 18.779 95 26 52 2 1910021584 9012944 6851984
19:08:10 59251 8192000000 10928899680 11384184832 1958588592 19.295 99 24 48 0 1975144272 10247136 6308544
19:09:16 15362 8192000000 10940860656 11379040256 1970353440 19.388 99 55 110 1 1995568976 10057920 15157616
19:09:40 27682 8192000000 10917679488 11380133888 1962151776 19.323 99 38 76 0 1984978480 12641888 10184816
19:10:15 59194 8192000000 10928247920 11393396736 1939444832 19.142 98 24 48 0 1966562576 20595088 6522656
19:11:28 156220 8192000000 10838630480 11285860352 1837213856 18.318 93 14 28 1 1858007056 16703296 4089904
19:14:23 38381 8192000000 10853388880 11316105216 1897053392 18.803 97 38 76 1 1917118080 9925408 10139280
19:15:13 55520 8192000000 10855660144 11330547712 1889793616 18.744 97 11 22 1 1905219920 12167072 3259232
19:16:35 69724 8192000000 10843670736 11314356224 1879261920 18.659 97 9 18 0 1893872128 11947584 2662624
19:17:51 71585 8192000000 10839819552 11322855424 1906158976 18.876 99 19 37 2 1932562928 20417344 5986608
19:19:48 68338 8192000000 10855396032 11328507904 1908905440 18.898 99 22 44 0 1926450640 10629104 6916096
19:21:03 75644 8192000000 10855805920 11329581056 1893728992 18.776 98 12 22 1 1912414208 15260944 3424272
19:22:47 32453 8192000000 10871390528 11344670720 1925147376 19.028 99 29 58 0 1941113344 7630800 8335168
19:23:31 60037 8192000000 10896387648 11352469504 1920051696 18.987 98 30 60 0 1938320880 10079632 8189552
19:24:52 125000 8192000000 10622959344 11075096576 1640855136 16.687 84 17 34 3 1658742560 12856592 5030832

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-11-2020 19:27:59 to 26-11-2020 19:28:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-11-2020 19:28:32 to 26-11-2020 19:28:34.

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

26.11.20 19:28:35. 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-11-26 19:28:37 No severe PSQL-related problems occured
26.11.20 19:28:38. End of report.