Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.11.2020 16: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 17452608 kB
MemAvailable 31501288 kB
Buffers 0 kB
Cached 14276440 kB
SwapCached 3628 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-17 16:27:01
DTS_END                         2020-11-17 16:27:01.7130
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/39852
TRN_ID                          230352
ATT_ID                          652
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: 9099.77 28054 1091972
customer order: creation 158.25 387 18990
customer order: refuse 14.16 315 1699
order to supplier: creation 41.94 1335 5033
order to supplier: removal 3.34 110976 401
invoice (draft): creation 42.97 4040 5156
invoice (draft): removal 53.88 905 6466
invoice accept: apply 39.42 18522 4730
invoice accept: cancel 48.23 811 5788
customer reserve: creation 3683.97 180 442076
customer reserve: removal 4733.43 60 568012
realization accept: apply 76.78 209 9213
realization accept: cancel 81.32 107 9758
payment from customer: creation 55.33 142 6639
payment from customer: removal 5.50 86 660
payment to supplier: creation 45.99 166 5519
payment to supplier: removal 3.49 76 419
service: total inventory turnovers 4.60 978 552
service: total monetary turnovers 6.32 36 758
service: aggregate perf. data 0.83 18425 99
service: refresh index statistics 0.03 403330 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-11-2020 16:28:37 to 17-11-2020 16:28:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5015
TEST_TIME 2 5130
TEST_TIME 3 5734
TEST_TIME 4 5339
TEST_TIME 5 5131
TEST_TIME 6 5438
TEST_TIME 7 5090
TEST_TIME 8 5588
TEST_TIME 9 5585
TEST_TIME 10 5810
TEST_TIME 11 6076
TEST_TIME 12 6158
TEST_TIME 13 6789
TEST_TIME 14 6822
TEST_TIME 15 7244
TEST_TIME 16 7346
TEST_TIME 17 7617
TEST_TIME 18 8289
TEST_TIME 19 8934
TEST_TIME 20 9075
TEST_TIME 21 9147
TEST_TIME 22 9453
TEST_TIME 23 9308
TEST_TIME 24 9360
TEST_TIME 25 9417
TEST_TIME 26 9942
TEST_TIME 27 10577
TEST_TIME 28 11308
TEST_TIME 29 11011
TEST_TIME 30 10787
TEST_TIME 31 10597
TEST_TIME 32 10367
TEST_TIME 33 10538
TEST_TIME 34 10500
TEST_TIME 35 10446
TEST_TIME 36 10266
TEST_TIME 37 10126
TEST_TIME 38 10002
TEST_TIME 39 9959
TEST_TIME 40 9858
TEST_TIME 41 9720
TEST_TIME 42 9597
TEST_TIME 43 9445
TEST_TIME 44 9665
TEST_TIME 45 9546
TEST_TIME 46 9573
TEST_TIME 47 9563
TEST_TIME 48 9436
TEST_TIME 49 9386
TEST_TIME 50 9299
TEST_TIME 51 9234
TEST_TIME 52 9406
TEST_TIME 53 9358
TEST_TIME 54 9332
TEST_TIME 55 9390
TEST_TIME 56 9370
TEST_TIME 57 9416
TEST_TIME 58 9409
TEST_TIME 59 9495
TEST_TIME 60 9507
TEST_TIME 61 9558
TEST_TIME 62 9692
TEST_TIME 63 9686
TEST_TIME 64 9754
TEST_TIME 65 9679
TEST_TIME 66 9543
TEST_TIME 67 9489
TEST_TIME 68 9496
TEST_TIME 69 9422
TEST_TIME 70 9383
TEST_TIME 71 9310
TEST_TIME 72 9336
TEST_TIME 73 9409
TEST_TIME 74 9393
TEST_TIME 75 9414
TEST_TIME 76 9484
TEST_TIME 77 9408
TEST_TIME 78 9385
TEST_TIME 79 9430
TEST_TIME 80 9396
TEST_TIME 81 9449
TEST_TIME 82 9510
TEST_TIME 83 9513
TEST_TIME 84 9539
TEST_TIME 85 9452
TEST_TIME 86 9389
TEST_TIME 87 9339
TEST_TIME 88 9303
TEST_TIME 89 9350
TEST_TIME 90 9307
TEST_TIME 91 9266
TEST_TIME 92 9284
TEST_TIME 93 9214
TEST_TIME 94 9178
TEST_TIME 95 9200
TEST_TIME 96 9236
TEST_TIME 97 9216
TEST_TIME 98 9261
TEST_TIME 99 9285
TEST_TIME 100 9310
TEST_TIME 101 9268
TEST_TIME 102 9315
TEST_TIME 103 9405
TEST_TIME 104 9345
TEST_TIME 105 9405
TEST_TIME 106 9408
TEST_TIME 107 9435
TEST_TIME 108 9381
TEST_TIME 109 9319
TEST_TIME 110 9354
TEST_TIME 111 9315
TEST_TIME 112 9326
TEST_TIME 113 9285
TEST_TIME 114 9255
TEST_TIME 115 9251
TEST_TIME 116 9215
TEST_TIME 117 9151
TEST_TIME 118 9150
TEST_TIME 119 9167
TEST_TIME 120 9104

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-11-2020 16:28:41 to 17-11-2020 16:28:44.

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 1500256 1500256 0 0.00 0 33590 6 0 0
doc_list_biud 1500255 1500255 0 0.00 0 63202 29 0 0
sp_add_invoice_to_stock 4875 4730 145 2.97 19 214781 18523 0 145
sp_cancel_adding_invoice 5788 5788 0 0.00 3 80717 811 0 0
sp_cancel_client_order 1699 1699 0 0.00 4 9834 315 0 0
sp_cancel_customer_reserve 568012 568012 0 0.00 1 63204 60 0 0
sp_cancel_pay_from_customer 660 660 0 0.00 2 5985 87 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 3339 77 0 0
sp_cancel_supplier_invoice 6473 6466 7 0.10 1 36244 905 0 7
sp_cancel_supplier_order 401 401 0 0.00 7 1016949 110976 0 0
sp_cancel_write_off 9758 9758 0 0.00 1 7814 107 0 0
sp_client_order 18990 18990 0 0.00 4 31306 387 0 0
sp_customer_reserve 442076 442076 0 0.00 0 83218 180 0 0
sp_fill_shopping_cart 29172 29172 0 0.00 1 11264 47 0 0
sp_fill_shopping_cart_clo_res 442067 442067 0 0.00 0 15876 15 0 0
sp_get_clo_for_invoice 4721 4721 0 0.00 0 26842 379 0 0
sp_kill_cost_storno 16625 16625 0 0.00 0 8399 60 0 0
sp_kill_qstorno_ret_qs2qd 1152649 1152649 0 0.00 0 63200 33 0 0
sp_kill_qty_storno 606058 606058 0 0.00 0 63202 71 0 0
sp_lock_selected_doc 19510 19510 0 0.00 0 5886 4 0 0
sp_make_cost_storno 26092 26092 0 0.00 0 18552 68 0 0
sp_multiply_rows_for_pdistr 26092 26092 0 0.00 0 10064 39 0 0
sp_multiply_rows_for_qdistr 18990 18990 0 0.00 0 9905 178 0 0
sp_pay_from_customer 6639 6639 0 0.00 4 13536 142 0 0
sp_pay_to_supplier 5519 5519 0 0.00 5 18894 167 0 0
sp_payment_common 12158 12158 0 0.00 2 12951 42 0 0
sp_qd_handle_on_cancel_clo 1699 1699 0 0.00 0 9828 289 0 0
sp_qd_handle_on_invoice_upd_sts 10509 10509 0 0.00 0 29518 358 0 0
sp_qd_handle_on_reserve_upd_sts 9213 9213 0 0.00 0 16332 62 0 0
sp_reserve_write_off 9213 9213 0 0.00 6 16347 209 0 0
sp_supplier_invoice 5156 5156 0 0.00 6 104520 4040 0 0
sp_supplier_order 5033 5033 0 0.00 6 56079 1336 0 0
srv_aggregate_perf_data 99 99 0 0.00 2460 233844 18426 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1124 167086 33601 0 0
srv_find_qd_qs_mism 1046543 1046543 0 0.00 0 33590 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 20 30482 979 0 0
srv_make_money_saldo 758 758 0 0.00 1 11106 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 219669 538363 403331 0 0
t$perf-abend:sp_add_invoice_to_stock 145 145 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4730 4730 0 0.00 0 11704 169 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 1 3640 94 0 0
t$perf-norm:sp_cancel_client_order 1699 1699 0 0.00 0 3942 14 0 0
t$perf-norm:sp_cancel_customer_reserve 647 647 0 0.00 0 603 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 660 660 0 0.00 0 481 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 5077 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 419 419 0 0.00 0 764 11 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 22387 1832 0 0
t$perf-norm:sp_cancel_write_off 949 949 0 0.00 0 1921 14 0 0
t$perf-norm:sp_client_order 18990 18990 0 0.00 0 9350 17 0 0
t$perf-norm:sp_customer_reserve 947 947 0 0.00 0 1585 4 0 0
t$perf-norm:sp_pay_from_customer 6639 6639 0 0.00 0 6801 10 0 0
t$perf-norm:sp_pay_to_supplier 5519 5519 0 0.00 0 4823 9 0 0
t$perf-norm:sp_reserve_write_off 9213 9213 0 0.00 0 7318 11 0 0
t$perf-norm:sp_supplier_invoice 5156 5156 0 0.00 0 4509 17 0 0
t$perf-norm:sp_supplier_order 5033 5033 0 0.00 0 5373 16 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 702 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 513 5 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 1087 20 0 0
t$perf-norm:srv_make_money_saldo 758 758 0 0.00 0 1857 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9732 9442 290 2.97 0 8413 20 0 290
v_all_customers 34832 34832 0 0.00 0 22 1 0 0
v_all_suppliers 28294 28294 0 0.00 0 20 1 0 0
v_all_wares 37980 37980 0 0.00 0 107 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 2006 9 0 0
v_cancel_client_order 3398 3398 0 0.00 0 2978 6 0 0
v_cancel_customer_prepayment 1320 1320 0 0.00 0 931 4 0 0
v_cancel_customer_reserve 1294 1294 0 0.00 0 2473 7 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 835 3 0 0
v_cancel_supplier_invoice 852 838 14 1.64 0 253 13 0 14
v_cancel_supplier_order 802 802 0 0.00 0 1730 6 0 0
v_cancel_write_off 1898 1898 0 0.00 0 2840 16 0 0
v_max_id_clo_ord 5030 5030 0 0.00 0 2416 2 0 0
v_max_id_clo_res 947 947 0 0.00 0 3371 21 0 0
v_max_id_ord_sup 5150 5150 0 0.00 0 4601 4 0 0
v_max_non_paid_invoice 1552 1552 0 0.00 0 322 2 0 0
v_max_non_paid_realizn 3481 3481 0 0.00 0 3339 4 0 0
v_min_id_clo_ord 5030 5030 0 0.00 0 6637 12 0 0
v_min_id_clo_res 947 947 0 0.00 0 16185 36 0 0
v_min_id_ord_sup 5150 5150 0 0.00 0 5804 7 0 0
v_min_non_paid_invoice 5519 5519 0 0.00 0 10109 28 0 0
v_min_non_paid_realizn 6639 6639 0 0.00 0 10113 30 0 0
v_our_firm 9464 9464 0 0.00 0 18 1 0 0
v_reserve_write_off 18426 18426 0 0.00 0 5098 6 0 0
x_lock_depdocs_on_canc_invoice 11835 11835 0 0.00 0 39064 125 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 30951 464 0 0
x_make_qstorno_1000_1200 5033 5033 0 0.00 2 56066 1246 0 0
x_make_qstorno_1200_2000 5156 5156 0 0.00 3 104058 3867 0 0
x_make_qstorno_2100_3300 442076 442076 0 0.00 0 83216 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-11-2020 16:28:45 to 17-11-2020 16:28:49.

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
13:57:05 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:11 10669 8192000000 10212640928 10512330752 905331184 9.951 73 56 117 0 927148160 2398304 19418672
13:57:33 15682 8192000000 10306575872 10617954304 1356519504 14.206 100 87 173 1 1389835728 4238976 29077248
13:58:07 35336 8192000000 10378785760 10698293248 1409023120 14.675 100 83 164 2 1442528544 6053088 27452336
13:58:54 22197 8192000000 10403872000 10730434560 1458980416 15.117 100 90 180 0 1495903232 7451440 29471376
13:59:27 12486 8192000000 10424138272 10750275584 1473163152 15.241 100 92 184 0 1511018896 8077408 29778336
13:59:54 23346 8192000000 10440483120 10770157568 1488111680 15.372 100 88 176 1 1525244528 8852352 28280496
14:00:24 5134 8192000000 10440492256 10772520960 1497358896 15.453 100 91 182 0 1535544512 9309632 28875984
14:00:41 15092 8192000000 10453301360 10787336192 1502064272 15.494 100 91 182 1 1541261056 9759520 29437264
14:01:06 20545 8192000000 10481172048 10824728576 1525599504 15.699 100 81 162 0 1560728432 10096912 25032016
14:01:38 7815 8192000000 10516775152 10862190592 1571676176 16.097 100 86 172 0 1608789120 10968000 26144944
14:01:56 11170 8192000000 10523045888 10876665856 1586137056 16.221 100 82 164 1 1622151728 11083024 24931648
14:02:18 11890 8192000000 10559869792 10915659776 1616836336 16.483 100 84 167 0 1653074848 11172880 25065632
14:02:38 11990 8192000000 10576911856 10934919168 1632982192 16.620 100 79 158 2 1668075104 11702480 23390432
14:02:59 10355 8192000000 10587895808 10952421376 1649246608 16.758 100 82 164 3 1685782304 12087600 24448096
14:03:18 8227 8192000000 10620478640 10984833024 1676282224 16.986 100 81 160 2 1712083152 12428608 23372320
14:03:38 12221 8192000000 10640968224 11009003520 1694780176 17.141 100 87 174 1 1733641072 13323104 25537792
14:03:58 7025 8192000000 10651367504 11022970880 1712913904 17.293 100 82 164 0 1749881696 13167968 23799824
14:04:12 5222 8192000000 10668678432 11041091584 1727477104 17.415 100 84 167 2 1763490144 12217280 23795760
14:04:24 5301 8192000000 10670403408 11047727104 1738042736 17.502 100 81 162 1 1774332016 12927088 23362192
14:04:36 6786 8192000000 10690469040 11065593856 1750947664 17.609 100 91 180 1 1790792416 14133712 25711040
14:04:51 4586 8192000000 10688757696 11066208256 1755789936 17.650 100 85 170 4 1794297776 14218672 24289168
14:05:03 6244 8192000000 10709537424 11087523840 1764566944 17.722 100 77 153 0 1799958464 14059232 21332288
14:05:16 3866 8192000000 10711747872 11093225472 1775239888 17.810 100 85 170 1 1813509168 14275520 23993760
14:05:27 3157 8192000000 10733695552 11109527552 1786227696 17.901 100 86 173 0 1822942704 12847792 23867216
14:05:36 3298 8192000000 10724660352 11105689600 1791393760 17.943 100 82 159 1 1827292432 13726816 22171856
14:05:46 4737 8192000000 10733694240 11121881088 1799904288 18.013 100 81 162 1 1835227488 13083136 22240064
14:05:57 2266 8192000000 10749641040 11131244544 1806637088 18.068 100 88 172 1 1843759616 12848352 24274176
14:06:06 2942 8192000000 10745008272 11131621376 1811463408 18.108 100 84 164 1 1847904976 13456656 22984912
14:06:15 5206 8192000000 10752952976 11136348160 1816283744 18.147 100 82 162 1 1851761648 12727504 22750400
14:06:27 3723 8192000000 10760366416 11145568256 1815855488 18.144 100 75 150 0 1850526352 13644000 21026864
14:06:37 2022 8192000000 10782370256 11162808320 1837091712 18.317 100 93 187 0 1875802496 12880688 25830096
14:06:46 2027 8192000000 10779128832 11166494720 1835535216 18.304 100 86 172 2 1873679648 14299904 23844528
14:06:54 1526 8192000000 10786559488 11172405248 1844668928 18.379 100 95 189 0 1886066272 14079568 27317776
14:07:02 1421 8192000000 10792588560 11178692608 1847782048 18.404 100 92 181 3 1886336240 12808784 25745408
14:07:10 1558 8192000000 10794378480 11177439232 1850974736 18.430 100 94 188 0 1891620048 13334352 27310960
14:07:18 1671 8192000000 10801867744 11185643520 1857075600 18.480 100 94 189 2 1896043536 12989840 25978096
14:07:26 1850 8192000000 10798545968 11185864704 1857899232 18.486 100 84 168 3 1893818720 11847792 24071696
14:07:34 1773 8192000000 10811980208 11197149184 1865848704 18.551 100 93 186 0 1904830480 12467472 26514304
14:07:42 2012 8192000000 10804859952 11201626112 1863111648 18.529 100 82 161 1 1902403440 16885968 22405824
14:07:51 9162 8192000000 10799598144 11196809216 1861429408 18.515 100 72 146 1 1892833456 11825264 19578784
14:08:06 5999 8192000000 10786830160 11196354560 1861023456 18.512 100 49 98 1 1885777440 10998832 13755152
14:08:19 3592 8192000000 10784924016 11197788160 1867514096 18.564 100 47 95 3 1890353120 9446448 13392576
14:08:29 3313 8192000000 10787772224 11201585152 1870913568 18.592 100 47 94 2 1893402432 9049072 13439792
14:08:39 4072 8192000000 10786744432 11206455296 1870630720 18.589 100 41 81 0 1891920480 10064640 11225120
14:08:52 6741 8192000000 10768453056 11198144512 1867763824 18.566 100 31 60 3 1883187408 6663344 8760240
14:09:04 10163 8192000000 10790212096 11199819776 1871149184 18.594 100 33 63 5 1885803120 6026848 8627088
14:09:27 4942 8192000000 10777970768 11206205440 1873579648 18.613 100 28 57 0 1888135040 6697312 7858080
14:09:40 3517 8192000000 10787620672 11208630272 1876687920 18.638 100 34 68 0 1893517664 7613968 9215776
14:09:50 3150 8192000000 10783526464 11211812864 1875867648 18.632 100 29 58 0 1890887120 7091504 7927968
14:10:03 7850 8192000000 10777276432 11210289152 1880281552 18.667 100 23 46 1 1893997408 6146096 7569760
14:10:17 18595 8192000000 10803314480 11225976832 1881768720 18.679 100 24 47 1 1894840528 6643344 6428464
14:10:42 84998 8192000000 10793406880 11232690176 1884903808 18.705 100 23 44 1 1896656384 5450672 6301904
14:12:14 7077 8192000000 10808030160 11237085184 1890558976 18.750 100 29 58 2 1905846928 7086192 8201760
14:12:27 2127 8192000000 10806587056 11238051840 1893468400 18.774 100 33 65 2 1910054048 6965936 9619712
14:12:36 3802 8192000000 10808752240 11238916096 1892914064 18.769 100 26 52 0 1907215920 6443600 7858256
14:12:46 4413 8192000000 10812151376 11244867584 1899745232 18.824 100 44 89 0 1919963440 7138832 13079376
14:12:59 8315 8192000000 10816022864 11242184704 1892821184 18.769 100 19 38 0 1903549008 5560832 5166992
14:13:16 8474 8192000000 10806708720 11242037248 1892829728 18.769 100 16 32 2 1903483488 5653776 4999984
14:13:32 5370 8192000000 10833056224 11247521792 1897580848 18.807 100 33 64 0 1913225856 6294704 9350304
14:13:43 8416 8192000000 10814707280 11248795648 1895267856 18.788 100 24 48 2 1912307680 10567024 6472800
14:14:03 4855 8192000000 10833009360 11250200576 1900498208 18.830 100 25 50 0 1913965376 6157440 7309728
14:14:15 10724 8192000000 10806085344 11249643520 1900066592 18.827 100 18 36 0 1911524448 5618384 5839472
14:14:33 7412 8192000000 10821544944 11253239808 1901494512 18.838 100 14 28 0 1910344784 5017120 3833152
14:14:51 8649 8192000000 10815181904 11254341632 1904483296 18.862 100 16 32 0 1915092816 6319360 4290160
14:15:09 9893 8192000000 10811859808 11250454528 1903639472 18.856 100 21 42 1 1915826224 5951888 6234864
14:15:29 71784 8192000000 10819910272 11256418304 1907439536 18.886 100 32 65 1 1923339472 5781552 10118384
14:16:47 12204 8192000000 10814752288 11246993408 1867270608 18.562 98 14 28 4 1876481504 5075936 4134960
14:17:05 5227 8192000000 10789241328 11215147008 1844685808 18.379 97 45 90 1 1865480288 7527808 13266672
14:17:17 6112 8192000000 10792543264 11219668992 1863983232 18.536 99 31 61 1 1878952352 6505808 8463312
14:17:30 9016 8192000000 10757389696 11179782144 1765692016 17.731 95 27 54 1 1779510480 5801408 8017056
14:17:46 5700 8192000000 10776527984 11197632512 1838548816 18.329 99 27 54 0 1852532256 6085328 7898112
14:17:59 4058 8192000000 10758088080 11173642240 1803377296 18.042 97 33 66 0 1819552000 6782288 9392416
14:18:12 7121 8192000000 10735743328 11158396928 1766977232 17.742 95 18 36 0 1777395904 5343072 5075600
14:18:27 6744 8192000000 10717158592 11136507904 1768024704 17.751 97 13 26 1 1776844912 5104480 3715728
14:18:40 8128 8192000000 10741101664 11161128960 1779646064 17.847 97 23 46 0 1792150608 5940944 6563600
14:18:55 9742 8192000000 10745427936 11159281664 1728223440 17.421 94 23 45 2 1740374480 4544640 7606400
14:19:11 4844 8192000000 10726435008 11146162176 1787896864 17.914 98 28 56 0 1801819168 5995616 7926688
14:19:24 8769 8192000000 10697410992 11115425792 1739576336 17.515 96 30 59 2 1758701200 10433360 8691504
14:19:40 6980 8192000000 10719875936 11138560000 1761584608 17.697 98 18 36 1 1772101856 5659344 4857904
14:19:58 63883 8192000000 10723870832 11115782144 1701560176 17.198 94 39 78 0 1717936064 5080448 11295440
14:21:08 23118 8192000000 10702590192 11124224000 1680672688 17.023 93 21 42 1 1692633792 6185376 5775728
14:21:37 5176 8192000000 10719538432 11135135744 1788030848 17.916 99 36 72 1 1806388848 8425680 9932320
14:21:50 6141 8192000000 10741251712 11162361856 1824132528 18.211 100 35 70 0 1841426640 6166592 11127520
14:22:05 7229 8192000000 10703648080 11119857664 1774956560 17.808 97 28 56 0 1788342720 5573152 7813008
14:22:20 9211 8192000000 10729962128 11150659584 1796463984 17.985 99 19 38 0 1807669360 5382704 5822672
14:22:37 8514 8192000000 10741987920 11162066944 1819789136 18.176 100 17 34 0 1830249392 5315392 5144864
14:22:58 11090 8192000000 10754439648 11179929600 1840191808 18.342 100 18 36 0 1851359920 5788656 5379456
14:23:15 12348 8192000000 10762047904 11186999296 1843402672 18.368 100 18 36 0 1853963504 5029936 5530896
14:23:34 6080 8192000000 10756922592 11183165440 1845138496 18.383 100 29 57 1 1859483648 6557888 7787264
14:23:47 9264 8192000000 10762887168 11190689792 1846560000 18.394 100 14 28 3 1856159152 4979088 4620064
14:24:02 6779 8192000000 10770993552 11194990592 1853267760 18.449 100 19 38 0 1864534224 5823600 5442864
14:24:17 17153 8192000000 10771415040 11199913984 1858496864 18.491 100 16 32 2 1868534224 5539616 4497744
14:24:41 69106 8192000000 10766907872 11203624960 1862209680 18.521 100 39 79 1 1879140512 5696464 11234368
14:25:56 9366 8192000000 10780997808 11204997120 1864067696 18.536 100 29 59 0 1878755536 5434608 9253232
14:26:12 6605 8192000000 10797276048 11214348288 1867857568 18.567 100 39 79 1 1885052624 6953824 10241232
14:26:28 8767 8192000000 10787740944 11213647872 1868951680 18.576 100 27 54 1 1882435056 6282976 7200400
14:26:43 6787 8192000000 10798297136 11219140608 1873333056 18.611 100 41 81 4 1891737824 6853488 11551280
14:26:57 8276 8192000000 10787580128 11223126016 1875716720 18.631 100 17 34 1 1885044368 4968432 4359216
14:27:26 9048 8192000000 10828751920 11244507136 1901437872 18.838 100 45 92 1 1919381312 5441264 12502176
14:28:03 39134 8192000000 10850512672 11271331840 1911337568 18.917 100 44 88 2 1933869440 10151472 12380400
14:28:49 18315 8192000000 10853812992 11274047488 1917519296 18.967 100 41 78 2 1940677168 11905232 11252640
14:29:16 65088 8192000000 10849807776 11296690176 1924892320 19.026 100 32 64 0 1947177248 12693648 9591280
14:30:44 16938 8192000000 10882649920 11308056576 1944060816 19.179 100 37 74 3 1966988096 12071136 10856144
14:31:11 12551 8192000000 10891080160 11316838400 1951421232 19.238 100 45 90 0 1979502704 15454320 12627152
14:31:37 4234 8192000000 10900699472 11325079552 1957118688 19.283 100 66 132 0 1992503536 15593360 19791488
14:31:50 26049 8192000000 10898212272 11331563520 1955860416 19.273 100 42 80 2 1983079696 15719648 11499632
14:32:27 50158 8192000000 10907177536 11339485184 1962646848 19.327 100 38 77 1 1990461392 16596960 11217584
14:33:42 13160 8192000000 10902202960 11337646080 1965648352 19.351 100 38 77 1 1994843584 17909792 11285440
14:34:04 18860 8192000000 10910441072 11349659648 1972001264 19.401 100 38 74 2 2001595696 17837504 11756928
14:34:50 36215 8192000000 10920956528 11361095680 1983834384 19.495 100 39 78 3 2019412336 23718368 11859584
14:35:43 2404 8192000000 10936533488 11359752192 1987418064 19.523 100 78 155 1 2029119296 19517600 22183632
14:35:54 10192 8192000000 10939701168 11369975808 1985948720 19.512 100 60 118 0 2026966016 23439008 17578288
14:36:11 6396 8192000000 10952756768 11373592576 1990803888 19.550 100 60 120 1 2032863328 23643248 18416192
14:36:25 3285 8192000000 10933247392 11356815360 1975918768 19.432 99 75 145 4 2019924976 21335568 22670640
14:36:36 12887 8192000000 10944224608 11375276032 1992564416 19.564 100 63 126 0 2034136368 22551376 19020576
14:36:59 8360 8192000000 10953809696 11385163776 2001051648 19.631 100 59 118 2 2044807280 25590464 18165168
14:37:16 3061 8192000000 10960695680 11393462272 2004496256 19.658 100 51 102 0 2043332112 23374832 15461024
14:37:27 10852 8192000000 10961381120 11393576960 2010062208 19.702 100 62 122 3 2053629968 25232960 18334800
14:37:46 7514 8192000000 10968179584 11402096640 2011752560 19.715 100 70 140 1 2059390352 26395120 21242672
14:38:01 6267 8192000000 10960709440 11393101824 2003125904 19.647 100 59 116 0 2048965952 27411360 18428688
14:38:18 6643 8192000000 10974747552 11403825152 2011077312 19.710 100 73 146 0 2067004832 34076704 21850816
14:38:32 3963 8192000000 10977388192 11406041088 2014060704 19.733 100 71 142 1 2065483120 29773296 21649120
14:38:47 4113 8192000000 10982269920 11410087936 2015852704 19.748 100 67 134 1 2065665088 29704400 20107984
14:38:58 2335 8192000000 10995561488 11409756160 2018798528 19.771 100 81 160 3 2073266720 30558784 23909408
14:39:07 3628 8192000000 10981876080 11405176832 2013016832 19.725 100 80 161 0 2067857184 30890464 23949888
14:39:20 3322 8192000000 10989491968 11407921152 2008758192 19.692 100 83 164 2 2069507712 35807456 24942064
14:39:33 4322 8192000000 10989966784 11415363584 2013692624 19.731 100 69 138 1 2071118480 36535760 20890096
14:39:45 2002 8192000000 10995469296 11413635072 2015872144 19.748 100 80 157 0 2076444240 36172976 24399120
14:39:55 1219 8192000000 11001238768 11419369472 2021449904 19.792 100 84 167 1 2088438992 40888176 26100912
14:40:03 3793 8192000000 10993574256 11420524544 2020891632 19.787 100 72 143 0 2079786768 36676896 22218240
14:40:15 2316 8192000000 11002435968 11421675520 2019619024 19.777 100 91 182 0 2085760608 38362224 27779360
14:40:24 4373 8192000000 10996464128 11420532736 2024893232 19.819 100 86 168 4 2082487264 32056128 25537904
14:40:37 2181 8192000000 10993778016 11414298624 2020283568 19.782 100 82 164 0 2077452832 32181744 24987520
14:40:47 2008 8192000000 10970045248 11386236928 1980069664 19.465 98 78 153 0 2034849216 31350064 23429488
14:40:57 4291 8192000000 10977015280 11398848512 1997259760 19.601 99 85 170 3 2054532880 32038352 25234768
14:41:10 4407 8192000000 10992247168 11414278144 2015944400 19.748 100 81 162 2 2074028128 33253968 24829760
14:41:24 6701 8192000000 10956292976 11376922624 1950730000 19.232 97 77 154 1 2009356304 34361872 24264432
14:41:40 6667 8192000000 10975988528 11391135744 1979890240 19.464 99 83 166 1 2043678848 38248096 25540512
14:41:55 3295 8192000000 10977681712 11399036928 1997336256 19.602 100 81 163 4 2061870336 39555744 24978336
14:42:06 1123 8192000000 11002455072 11415171072 2008417776 19.689 100 94 188 0 2078616912 41029840 29169296
14:42:14 1749 8192000000 10997289104 11417776128 2011163984 19.711 100 84 170 0 2080214352 42000592 27049776
14:42:27 4476 8192000000 11003852272 11415887872 2007921072 19.685 100 88 176 1 2077940320 42083680 27935568
14:42:37 1390 8192000000 10999886304 11417001984 2008322560 19.688 100 90 178 2 2079048224 41909488 28816176
14:42:46 1449 8192000000 10994760592 11414515712 2010128752 19.703 100 82 163 1 2076587680 40071840 26387088
14:42:56 8114 8192000000 10973320224 11397525504 1972485056 19.405 99 71 142 1 2034723168 39700960 22537152
14:43:15 2102 8192000000 10969587280 11380015104 1974939504 19.425 99 85 171 1 2044715056 41491296 28284256
14:43:25 5069 8192000000 10981494864 11403841536 1997135408 19.600 100 76 152 1 2063866752 42095456 24635888
14:43:37 7862 8192000000 10965765152 11387748352 1979873408 19.464 99 67 134 1 2044587616 43096112 21618096
14:43:52 3425 8192000000 10964875024 11379748864 1977898000 19.448 99 80 162 0 2046047760 43024496 25125264
14:44:05 2821 8192000000 10982661552 11397947392 1990395840 19.547 100 86 172 2 2061805008 43471392 27937776
14:44:16 2399 8192000000 10978728640 11390722048 1986550912 19.517 100 84 168 1 2058755808 46081824 26123072
14:44:25 4028 8192000000 10982996560 11409735680 1997843728 19.606 100 82 163 0 2070846272 46435712 26566832
14:44:37 6488 8192000000 10974098160 11393839104 1985902304 19.511 99 81 161 2 2055992384 45307760 24782320
14:44:54 2600 8192000000 10985325648 11409743872 1993627440 19.572 100 81 160 0 2071126336 51720576 25778320
14:45:03 3280 8192000000 10952894688 11371315200 1960594752 19.311 99 86 172 0 2036982656 49033040 27354864
14:45:17 2781 8192000000 10958195728 11377909760 1973573136 19.414 100 87 173 0 2044162224 42772384 27816704
14:45:27 1887 8192000000 10967615344 11380715520 1977169360 19.442 100 84 167 3 2046279776 42191824 26918592
14:45:38 1212 8192000000 10975591392 11391557632 1982349856 19.483 100 78 155 0 2050290192 43086624 24853712
14:45:46 3399 8192000000 10963784704 11387580416 1981853984 19.479 100 82 163 2 2052481168 44732432 25894752
14:45:59 1750 8192000000 10973098336 11388211200 1983989200 19.496 100 90 180 3 2054283920 42615872 27678848
14:46:08 5149 8192000000 10949818960 11371245568 1955811840 19.273 99 83 167 2 2025913984 43771680 26330464
14:46:20 4968 8192000000 10951335568 11372797952 1964577936 19.342 100 70 140 0 2028730560 42262640 21889984
14:46:37 9967 8192000000 10922842208 11368968192 1963897312 19.337 100 45 90 4 2014421360 35659344 14864704
14:46:54 13203 8192000000 10939487328 11376041984 1972193728 19.403 100 42 81 2 2020133520 34924832 13014960
14:47:14 10579 8192000000 10928206384 11375497216 1957557920 19.287 99 39 78 1 2007466528 36458960 13449648
14:47:32 23104 8192000000 10930930592 11377541120 1949830464 19.225 99 31 61 3 1994484128 33850880 10802784
14:48:01 7099 8192000000 10921894576 11359002624 1925517984 19.031 98 35 70 2 1973799808 36306784 11975040
14:48:17 8156 8192000000 10917439184 11352363008 1944163696 19.180 99 49 98 2 1998168128 37737936 16266496
14:48:32 4578 8192000000 10928853168 11355787264 1946080592 19.195 99 50 95 1 2000322640 38714208 15527840
14:48:43 3530 8192000000 10944424800 11370881024 1959772816 19.304 100 74 148 1 2028259856 44808304 23678736
14:49:05 10581 8192000000 10921706992 11368488960 1936270960 19.117 99 28 56 1 1986235360 40267504 9696896
14:49:23 27300 8192000000 10905948992 11357515776 1901888896 18.841 97 29 58 0 1950406048 38856096 9661056
14:49:59 20910 8192000000 10913047520 11359096832 1927939872 19.050 99 30 58 1 1976547232 38570432 10036928
14:50:28 6853 8192000000 10918589744 11354009600 1944662640 19.184 100 36 72 1 1998145104 41747616 11734848
14:50:41 6988 8192000000 10928511520 11364143104 1951330064 19.237 100 40 81 1 2008131120 43127184 13673872
14:51:03 18551 8192000000 10921226272 11370463232 1937530112 19.127 99 35 69 2 1996267136 46473520 12263504
14:51:27 15247 8192000000 10919749072 11361902592 1943707456 19.176 100 36 72 1 2007169296 50918352 12543488
14:51:50 23562 8192000000 10936554688 11379757056 1946590800 19.199 100 35 68 3 2013999216 54962304 12446112
14:52:27 9715 8192000000 10942512912 11386142720 1936582064 19.119 99 35 70 1 2010152096 60774016 12796016
14:52:43 12664 8192000000 10920457520 11371372544 1924093904 19.020 99 25 50 2 1995252320 61375376 9783040
14:53:04 7921 8192000000 10902203200 11349372928 1909740880 18.905 99 26 52 0 1977792352 58221600 9829872
14:53:18 16866 8192000000 10907255632 11364749312 1928287024 19.053 100 26 52 1 2002337472 64268192 9782256
14:53:43 26464 8192000000 10907870224 11379118080 1925750128 19.033 100 25 49 2 1995778320 61323168 8705024
14:54:56 49243 8192000000 10870758656 11319750656 1894850320 18.785 98 15 29 0 1914298752 15307760 4140672
14:55:53 129604 8192000000 10884084064 11342512128 1937057152 19.123 99 54 108 1 1967329360 14218448 16053760
14:58:28 42016 8192000000 10885623696 11349831680 1944602592 19.183 99 14 28 0 1962962992 14513552 3846848
14:59:18 30863 8192000000 10903733376 11363983360 1972129584 19.402 100 34 66 2 1997668352 15898688 9640080
15:00:01 70661 8192000000 10875775136 11354894336 1915650048 18.952 98 10 20 1 1939128816 20660976 2817792
15:01:18 42684 8192000000 10903925312 11354873856 1960026272 19.306 100 12 24 0 1970608272 7279824 3302176
15:02:08 94632 8192000000 10890488240 11360063488 1955529904 19.270 99 13 26 0 1968218384 9095776 3592704
15:03:54 47124 8192000000 10867815328 11331686400 1917460688 18.966 97 15 28 1 1929202592 8243888 3498016
15:04:48 167056 8192000000 10898938128 11361431552 1918353504 18.974 97 21 40 1 1937357664 13232576 5771584
15:08:22 71213 8192000000 10893921008 11362336768 1939708384 19.144 98 15 30 0 1960913600 16760688 4444528
15:09:39 36818 8192000000 10900875728 11360522240 1946681344 19.200 99 16 31 1 1969328016 17337968 5308704
15:10:23 14479 8192000000 10919250576 11374321664 1974728768 19.423 100 30 59 0 2007017184 22844816 9443600
15:10:49 47045 8192000000 10948545296 11403087872 1988271984 19.530 100 44 88 1 2027678192 25635680 13770528
15:11:54 71292 8192000000 10913498032 11387965440 1985807584 19.511 100 21 42 1 2011390784 19233504 6349696
15:13:16 76299 8192000000 10883727584 11352903680 1936247984 19.117 98 15 30 1 1950046304 9743136 4055184
15:14:38 42325 8192000000 10902112976 11356794880 1951775776 19.241 99 20 40 1 1965156400 7559584 5821040
15:15:31 68634 8192000000 10873146000 11350884352 1938306496 19.133 98 13 26 0 1955566160 13634304 3625360
15:16:47 54540 8192000000 10877429392 11358314496 1960495440 19.310 100 12 24 0 1977099344 12672416 3931488
15:17:48 29134 8192000000 10895542160 11375292416 1966165936 19.355 100 5 10 0 1980329616 12694352 1469328
15:18:23 64735 8192000000 10911362736 11397468160 1982999920 19.488 100 13 26 0 2009959680 23197456 3762304
15:19:34 92604 8192000000 10932900208 11395584000 1997489856 19.603 100 14 28 2 2013256960 11996896 3770208
15:21:13 58170 8192000000 10928531840 11390107648 1983223824 19.490 99 28 56 0 2000994208 10255744 7514640
15:22:20 14611 8192000000 10936656800 11400781824 2006557696 19.674 100 51 102 2 2032852688 11907392 14387600
15:22:43 31269 8192000000 10943586816 11405688832 2007897120 19.685 100 27 55 1 2025967824 10575264 7495440
15:23:30 57117 8192000000 10924055344 11399843840 1979903296 19.464 99 21 42 1 1998743888 13420352 5420240
15:24:33 74301 8192000000 10950105312 11405393920 2008216880 19.687 100 23 46 0 2023471728 9327840 5927008
15:25:57 34845 8192000000 10957295424 11417415680 2004974576 19.662 99 47 94 0 2030396960 12149216 13273168
15:26:53 69679 8192000000 10927650368 11396268032 1953112640 19.251 97 18 36 0 1970807024 13178080 4516304
15:28:09 47225 8192000000 10920100624 11396206592 1973339888 19.412 99 15 30 1 1994251504 16665280 4246336
15:29:02 112449 8192000000 10910811488 11393265664 1925590704 19.032 97 11 22 0 1945101264 16816384 2694176
15:31:01 83263 8192000000 10880795216 11356864512 1855081152 18.463 94 6 12 0 1872021760 15958592 982016
15:32:35 114550 8192000000 10900148624 11354894336 1911782448 18.921 97 35 70 2 1929600960 7902832 9915680
15:34:37 12818 8192000000 10898332080 11356835840 1948124976 19.212 99 49 98 2 1975959376 13761760 14072640
15:34:56 44489 8192000000 10880508896 11365765120 1963239088 19.332 100 11 22 0 1977701232 11377472 3084672
15:35:48 33941 8192000000 10867342656 11349934080 1919981008 18.987 98 10 20 0 1935712432 13108976 2622448
15:36:34 37380 8192000000 10876551600 11348692992 1928558880 19.055 98 14 28 1 1941563792 8938544 4066368
15:37:21 85186 8192000000 10878223424 11342143488 1879946816 18.665 96 15 30 2 1897147712 12883968 4316928
15:38:54 55966 8192000000 10877200336 11351113728 1894936112 18.786 97 19 38 2 1919644752 17776304 6932336
15:39:59 62349 8192000000 10856139088 11328294912 1870895504 18.592 96 15 30 1 1889082800 13958688 4228608
15:41:08 68996 8192000000 10823898736 11277443072 1822928704 18.202 94 19 39 1 1845532592 16012352 6591536
15:42:32 86978 8192000000 10819149552 11281297408 1798243232 17.999 94 17 34 0 1818515088 15222880 5048976
15:44:05 47231 8192000000 10836885984 11287830528 1836528432 18.313 96 32 64 2 1853976224 8885600 8562192
15:44:59 70418 8192000000 10840535200 11306807296 1876486608 18.637 98 25 50 0 1895879440 12341424 7051408
15:46:23 76565 8192000000 10876330912 11316371456 1865346368 18.547 97 22 44 0 1880881536 9853552 5681616
15:47:48 11231 8192000000 10885546528 11321679872 1922758160 19.009 99 57 113 0 1948207840 9325264 16124416
15:48:09 13976 8192000000 10873028608 11322224640 1922969552 19.011 99 41 80 1 1948225920 13667808 11588560
15:48:31 108081 8192000000 10854560992 11328798720 1855478096 18.467 96 14 28 1 1877307344 17901232 3928016
15:50:31 22591 8192000000 10868217136 11325927424 1914108736 18.940 99 25 50 1 1937677648 16762112 6806800
15:51:04 83745 8192000000 10846503920 11303583744 1836968032 18.316 95 19 38 0 1852698400 10509952 5220416
15:52:37 148919 8192000000 10882811248 11336015872 1915447792 18.950 99 29 57 1 1933580832 9809648 8323392
15:55:21 19245 8192000000 10874978784 11331076096 1943245472 19.173 100 36 72 0 1969250784 16308880 9696432
15:55:46 39728 8192000000 10857267664 11342311424 1944523360 19.183 100 16 33 2 1966474400 17355120 4595920
15:56:44 63733 8192000000 10885328032 11357499392 1966637728 19.359 100 15 30 1 1977193280 6808160 3747392
15:57:54 63953 8192000000 10878103440 11345133568 1910908784 18.914 97 7 14 1 1920821536 8389072 1523680
15:59:04 49070 8192000000 10882727168 11355344896 1966878160 19.361 100 11 22 0 1975827200 6164752 2784288
16:01:40 82235 8192000000 10880083152 11360763904 1947507072 19.207 99 17 34 2 1967778016 15854640 4416304
16:03:08 88814 8192000000 10898953520 11361726464 1897474464 18.806 96 19 36 1 1912335856 9873728 4987664
16:04:43 59872 8192000000 10909798944 11380580352 1963361376 19.333 99 29 58 1 1983839696 12324112 8154208
16:05:49 53720 8192000000 10906077072 11383414784 1981342848 19.475 100 15 30 1 1999971728 14757136 3871744
16:06:49 35952 8192000000 10899553584 11365076992 1947476848 19.206 98 18 36 1 1965515088 12429168 5609072
16:07:31 45899 8192000000 10918543248 11380510720 1959890608 19.305 99 23 46 1 1976708800 9996928 6821264
16:08:24 41566 8192000000 10918567584 11382239232 1964541184 19.342 99 23 45 1 1984582912 13465056 6576672
16:09:52 82748 8192000000 10903389376 11386400768 1954657280 19.264 99 6 12 0 1976706304 19865312 2183712
16:11:46 23501 8192000000 10958988096 11397378048 1990335920 19.546 100 49 98 0 2019160352 15429184 13395248
16:12:19 39489 8192000000 10900876112 11368927232 1893913296 18.777 95 40 81 2 1924432400 19647840 10871264
16:13:06 64441 8192000000 10886227248 11347877888 1911932944 18.922 97 17 34 1 1931006576 13153840 5919792
16:14:29 42825 8192000000 10932826144 11380559872 1972206752 19.403 100 31 59 1 1994558688 13930432 8421504
16:15:18 87576 8192000000 10940409312 11381764096 1980671472 19.470 100 34 67 2 2006138416 15678192 9788752
16:17:23 90177 8192000000 10920032912 11381075968 1968214576 19.371 99 30 60 0 1986132160 9611472 8306112
16:19:00 37635 8192000000 10905173360 11386011648 1988088192 19.529 100 17 34 1 2002888016 9616464 5183360
16:19:46 70625 8192000000 10896680384 11377954816 1962142368 19.323 99 16 32 1 1981312656 14624192 4546096
16:21:03 85421 8192000000 10886078400 11362271232 1921136320 18.996 97 10 20 1 1932874080 9077664 2660096
16:22:37 75130 8192000000 10880881280 11352358912 1930774176 19.073 98 15 30 0 1943047456 7799344 4473936
16:24:48 43321 8192000000 10876351008 11363274752 1959420576 19.301 100 26 52 1 1977287584 9326160 8540848
16:25:42 87115 8192000000 9838643600 10207469568 971040112 10.597 50 5 10 0 976668288 4725344 902832

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-11-2020 16:28:51 to 17-11-2020 16:29:22.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 145 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-11-2020 16:29:23 to 17-11-2020 16:29:25.

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          230456
MON$OLDEST_ACTIVE               230692
MON$OLDEST_SNAPSHOT             230692
MON$NEXT_TRANSACTION            230692
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                       2028448
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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 ---
:230: 
:231: mscs-test-161.budzdorov.ru    Tue Nov 17 16:27:17 2020
:232:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:233: 
--- end of diff output ---

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

17.11.20 16:29:26. 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-17 16:29:28 No severe PSQL-related problems occured
17.11.20 16:29:29. End of report.