Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.11.2020 01: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 17574660 kB
MemAvailable 31532764 kB
Buffers 0 kB
Cached 14160948 kB
SwapCached 3124 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-24 01:27:03
DTS_END                         2020-11-24 01:27:03.0960
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56634
TRN_ID                          242392
ATT_ID                          668
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: 9346.94 20178 1121633
customer order: creation 176.86 367 21223
customer order: refuse 15.03 330 1803
order to supplier: creation 46.75 1158 5610
order to supplier: removal 3.19 100872 383
invoice (draft): creation 47.43 3288 5691
invoice (draft): removal 52.75 886 6330
invoice accept: apply 42.49 18896 5099
invoice accept: cancel 47.70 752 5724
customer reserve: creation 3961.01 188 475321
customer reserve: removal 4647.57 52 557708
realization accept: apply 84.83 182 10180
realization accept: cancel 88.36 109 10603
payment from customer: creation 60.15 107 7218
payment from customer: removal 5.76 94 691
payment to supplier: creation 50.75 118 6090
payment to supplier: removal 3.70 94 444
service: total inventory turnovers 5.14 858 617
service: total monetary turnovers 6.53 22 784
service: aggregate perf. data 0.92 14810 110
service: refresh index statistics 0.03 260383 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-11-2020 01:28:55 to 24-11-2020 01:28:57.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2603
TEST_TIME 2 4196
TEST_TIME 3 5258
TEST_TIME 4 5183
TEST_TIME 5 5192
TEST_TIME 6 5391
TEST_TIME 7 5301
TEST_TIME 8 5543
TEST_TIME 9 5570
TEST_TIME 10 5582
TEST_TIME 11 5535
TEST_TIME 12 5883
TEST_TIME 13 6044
TEST_TIME 14 6545
TEST_TIME 15 7187
TEST_TIME 16 7586
TEST_TIME 17 8188
TEST_TIME 18 8216
TEST_TIME 19 8615
TEST_TIME 20 8625
TEST_TIME 21 9342
TEST_TIME 22 10195
TEST_TIME 23 10846
TEST_TIME 24 11370
TEST_TIME 25 11317
TEST_TIME 26 11099
TEST_TIME 27 11001
TEST_TIME 28 10683
TEST_TIME 29 10518
TEST_TIME 30 10726
TEST_TIME 31 10631
TEST_TIME 32 10556
TEST_TIME 33 10459
TEST_TIME 34 10635
TEST_TIME 35 10473
TEST_TIME 36 10355
TEST_TIME 37 10286
TEST_TIME 38 10168
TEST_TIME 39 10205
TEST_TIME 40 10009
TEST_TIME 41 9961
TEST_TIME 42 9956
TEST_TIME 43 9987
TEST_TIME 44 9937
TEST_TIME 45 9924
TEST_TIME 46 10016
TEST_TIME 47 10083
TEST_TIME 48 10122
TEST_TIME 49 10080
TEST_TIME 50 10037
TEST_TIME 51 10130
TEST_TIME 52 10092
TEST_TIME 53 10184
TEST_TIME 54 10187
TEST_TIME 55 10199
TEST_TIME 56 10184
TEST_TIME 57 10035
TEST_TIME 58 10053
TEST_TIME 59 9943
TEST_TIME 60 9952
TEST_TIME 61 9903
TEST_TIME 62 9803
TEST_TIME 63 9723
TEST_TIME 64 9686
TEST_TIME 65 9691
TEST_TIME 66 9668
TEST_TIME 67 9762
TEST_TIME 68 9751
TEST_TIME 69 9739
TEST_TIME 70 9716
TEST_TIME 71 9815
TEST_TIME 72 9778
TEST_TIME 73 9770
TEST_TIME 74 9742
TEST_TIME 75 9753
TEST_TIME 76 9748
TEST_TIME 77 9830
TEST_TIME 78 9808
TEST_TIME 79 9725
TEST_TIME 80 9664
TEST_TIME 81 9593
TEST_TIME 82 9520
TEST_TIME 83 9532
TEST_TIME 84 9516
TEST_TIME 85 9515
TEST_TIME 86 9535
TEST_TIME 87 9518
TEST_TIME 88 9523
TEST_TIME 89 9549
TEST_TIME 90 9551
TEST_TIME 91 9554
TEST_TIME 92 9592
TEST_TIME 93 9558
TEST_TIME 94 9546
TEST_TIME 95 9633
TEST_TIME 96 9581
TEST_TIME 97 9603
TEST_TIME 98 9594
TEST_TIME 99 9513
TEST_TIME 100 9517
TEST_TIME 101 9456
TEST_TIME 102 9523
TEST_TIME 103 9488
TEST_TIME 104 9432
TEST_TIME 105 9382
TEST_TIME 106 9402
TEST_TIME 107 9415
TEST_TIME 108 9476
TEST_TIME 109 9496
TEST_TIME 110 9478
TEST_TIME 111 9431
TEST_TIME 112 9488
TEST_TIME 113 9481
TEST_TIME 114 9475
TEST_TIME 115 9496
TEST_TIME 116 9485
TEST_TIME 117 9487
TEST_TIME 118 9459
TEST_TIME 119 9425
TEST_TIME 120 9347

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-11-2020 01:28:58 to 24-11-2020 01:29:02.

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 1560951 1560951 0 0.00 0 20293 6 0 0
doc_list_biud 1560951 1560951 0 0.00 0 53615 25 0 0
sp_add_invoice_to_stock 5197 5099 98 1.88 35 178543 18896 0 98
sp_cancel_adding_invoice 5724 5724 0 0.00 4 52234 753 0 0
sp_cancel_client_order 1803 1803 0 0.00 4 14676 330 0 0
sp_cancel_customer_reserve 557708 557708 0 0.00 1 24929 53 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 11104 94 0 0
sp_cancel_pay_to_supplier 444 444 0 0.00 2 6887 94 0 0
sp_cancel_supplier_invoice 6335 6330 5 0.07 2 38385 886 0 5
sp_cancel_supplier_order 383 383 0 0.00 8 1211838 100873 0 0
sp_cancel_write_off 10603 10603 0 0.00 1 15493 110 0 0
sp_client_order 21223 21223 0 0.00 3 70786 367 0 0
sp_customer_reserve 475321 475321 0 0.00 0 80145 188 0 0
sp_fill_shopping_cart 32510 32510 0 0.00 1 11819 35 0 0
sp_fill_shopping_cart_clo_res 475321 475321 0 0.00 0 11630 13 0 0
sp_get_clo_for_invoice 5099 5099 0 0.00 0 41048 304 0 0
sp_kill_cost_storno 17462 17462 0 0.00 0 8390 52 0 0
sp_kill_qstorno_ret_qs2qd 1132732 1132732 0 0.00 0 38371 30 0 0
sp_kill_qty_storno 597830 597830 0 0.00 0 53614 64 0 0
sp_lock_selected_doc 21224 21224 0 0.00 0 8785 6 0 0
sp_make_cost_storno 28587 28587 0 0.00 0 20258 46 0 0
sp_multiply_rows_for_pdistr 28587 28587 0 0.00 0 9622 26 0 0
sp_multiply_rows_for_qdistr 21223 21223 0 0.00 0 70775 174 0 0
sp_pay_from_customer 7218 7218 0 0.00 4 14577 108 0 0
sp_pay_to_supplier 6090 6090 0 0.00 5 17483 119 0 0
sp_payment_common 13308 13308 0 0.00 1 14551 30 0 0
sp_qd_handle_on_cancel_clo 1803 1803 0 0.00 0 10852 294 0 0
sp_qd_handle_on_invoice_upd_sts 10823 10823 0 0.00 0 53613 304 0 0
sp_qd_handle_on_reserve_upd_sts 10180 10180 0 0.00 0 23315 70 0 0
sp_reserve_write_off 10180 10180 0 0.00 6 23421 182 0 0
sp_supplier_invoice 5691 5691 0 0.00 7 96185 3289 0 0
sp_supplier_order 5610 5610 0 0.00 5 59732 1158 0 0
srv_aggregate_perf_data 110 110 0 0.00 2632 159139 14811 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1208 162282 34480 0 0
srv_find_qd_qs_mism 1072176 1072176 0 0.00 0 12112 6 0 0
srv_make_invnt_saldo 617 617 0 0.00 44 41489 858 0 0
srv_make_money_saldo 784 784 0 0.00 1 2034 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 211851 326206 260384 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5099 5099 0 0.00 0 12379 152 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 3787 98 0 0
t$perf-norm:sp_cancel_client_order 1803 1803 0 0.00 0 4068 19 0 0
t$perf-norm:sp_cancel_customer_reserve 683 683 0 0.00 0 1952 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 5828 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 444 444 0 0.00 0 855 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 416 416 0 0.00 0 3344 15 0 0
t$perf-norm:sp_cancel_supplier_order 383 383 0 0.00 0 25744 1674 0 0
t$perf-norm:sp_cancel_write_off 1093 1093 0 0.00 0 749 4 0 0
t$perf-norm:sp_client_order 21223 21223 0 0.00 0 8538 16 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 2672 4 0 0
t$perf-norm:sp_pay_from_customer 7218 7218 0 0.00 0 4936 7 0 0
t$perf-norm:sp_pay_to_supplier 6090 6090 0 0.00 0 16196 11 0 0
t$perf-norm:sp_reserve_write_off 10180 10180 0 0.00 0 5327 10 0 0
t$perf-norm:sp_supplier_invoice 5691 5691 0 0.00 0 6403 17 0 0
t$perf-norm:sp_supplier_order 5610 5610 0 0.00 0 3828 15 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 412 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 167 3 0 0
t$perf-norm:srv_make_invnt_saldo 617 617 0 0.00 0 695 17 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 1032 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 109 33 0 0
v_add_invoice_to_stock 10394 10198 196 1.88 0 12594 19 0 196
v_all_customers 38662 38662 0 0.00 0 94 1 0 0
v_all_suppliers 31332 31332 0 0.00 0 35 1 0 0
v_all_wares 42446 42446 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 1246 9 0 0
v_cancel_client_order 3606 3606 0 0.00 0 14530 12 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 1881 6 0 0
v_cancel_customer_reserve 1366 1366 0 0.00 0 3225 8 0 0
v_cancel_payment_to_supplier 888 888 0 0.00 0 2944 8 0 0
v_cancel_supplier_invoice 842 832 10 1.18 0 1898 19 0 10
v_cancel_supplier_order 766 766 0 0.00 0 218 3 0 0
v_cancel_write_off 2186 2186 0 0.00 0 15381 23 0 0
v_max_id_clo_ord 5610 5610 0 0.00 0 880 1 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 1770 9 0 0
v_max_id_ord_sup 5677 5677 0 0.00 0 6664 4 0 0
v_max_non_paid_invoice 1711 1711 0 0.00 0 2479 4 0 0
v_max_non_paid_realizn 3742 3742 0 0.00 0 5702 6 0 0
v_min_id_clo_ord 5610 5610 0 0.00 0 4419 8 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 3289 9 0 0
v_min_id_ord_sup 5677 5677 0 0.00 0 8508 9 0 0
v_min_non_paid_invoice 6090 6090 0 0.00 0 8515 17 0 0
v_min_non_paid_realizn 7218 7218 0 0.00 0 9623 20 0 0
v_our_firm 10736 10736 0 0.00 0 14 1 0 0
v_reserve_write_off 20360 20360 0 0.00 0 17552 9 0 0
x_lock_depdocs_on_canc_invoice 11638 11638 0 0.00 0 15689 103 0 0
x_lock_depdocs_on_canc_sup_ord 383 383 0 0.00 0 8654 312 0 0
x_make_qstorno_1000_1200 5610 5610 0 0.00 2 59700 1079 0 0
x_make_qstorno_1200_2000 5691 5691 0 0.00 4 92352 3167 0 0
x_make_qstorno_2100_3300 475321 475321 0 0.00 0 80140 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-11-2020 01:29:03 to 24-11-2020 01:29:07.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:12 11568 8192000000 10237354016 10541346816 950917424 10.400 75 61 123 0 973873968 2537360 20419184
22:57:32 26813 8192000000 10339793856 10656190464 1363961648 14.273 100 78 154 0 1394444560 4385008 26097904
22:58:14 20295 8192000000 10375603040 10704535552 1435157824 14.907 100 85 171 2 1469046848 6173600 27715424
22:58:43 19575 8192000000 10420161664 10747518976 1457031744 15.100 100 83 166 0 1490966000 6841504 27092752
22:59:15 22852 8192000000 10433703904 10767077376 1485768320 15.352 100 89 178 0 1523158048 8028736 29360992
22:59:46 21469 8192000000 10445036512 10782408704 1500733296 15.483 100 87 173 0 1537353168 8783504 27836368
23:00:16 9760 8192000000 10457853744 10796830720 1519142032 15.643 100 86 172 0 1556172384 9247744 27782608
23:00:41 14453 8192000000 10478001600 10818830336 1536128544 15.790 100 90 180 0 1574353728 9654064 28571120
23:01:02 15880 8192000000 10503643712 10847465472 1557806000 15.977 100 90 180 0 1595891184 10366416 27718768
23:01:28 17560 8192000000 10524100000 10876739584 1578608320 16.156 100 86 170 2 1615767472 10740880 26418272
23:01:55 16883 8192000000 10548263584 10906722304 1604961376 16.382 100 79 158 0 1640582144 11448384 24172384
23:02:22 11404 8192000000 10562519584 10925383680 1622931488 16.535 100 78 156 1 1657949056 11598304 23419264
23:02:42 11126 8192000000 10589123136 10950426624 1644054672 16.714 100 82 164 0 1681207584 12558368 24594544
23:03:02 12994 8192000000 10611957136 10978406400 1669198192 16.926 100 80 160 1 1706287760 13118928 23970640
23:03:23 7902 8192000000 10627153504 10998890496 1683742544 17.049 100 76 152 3 1719021632 12749248 22529840
23:03:44 8332 8192000000 10641757776 11012538368 1699023024 17.177 100 85 171 2 1738243408 13392032 25828352
23:04:00 7792 8192000000 10644329536 11021295616 1705773456 17.233 100 73 145 0 1740278048 13885488 20619104
23:04:15 6526 8192000000 10664895312 11043336192 1721757120 17.367 100 76 152 0 1756495344 12701920 22036304
23:04:29 6633 8192000000 10667675952 11050639360 1734968336 17.477 100 73 146 0 1768367376 13261904 20137136
23:04:43 6443 8192000000 10681846912 11066916864 1747490592 17.581 100 69 138 0 1779233696 11792368 19950736
23:04:57 4105 8192000000 10703625776 11079520256 1762325424 17.704 100 74 147 2 1793725008 11161584 20238000
23:05:09 4068 8192000000 10694447264 11083943936 1765664752 17.731 100 63 126 0 1795893728 12030160 18198816
23:05:20 4094 8192000000 10723555904 11104419840 1781933552 17.865 100 88 174 0 1818212272 11591520 24687200
23:05:31 12857 8192000000 10717244448 11103555584 1780870080 17.857 100 66 132 0 1811320928 12070128 18380720
23:05:51 5839 8192000000 10722608160 11114475520 1793342928 17.959 100 76 152 0 1830692688 15784416 21565344
23:06:03 3328 8192000000 10741534784 11130900480 1806793984 18.070 100 69 138 0 1837556912 11276512 19486416
23:06:13 3558 8192000000 10752341616 11143602176 1819789488 18.176 100 86 172 0 1857033120 12528784 24714848
23:06:24 2951 8192000000 10761404736 11148795904 1820943456 18.185 100 85 168 1 1857372640 12486624 23942560
23:06:34 1335 8192000000 10764222576 11153338368 1828337344 18.246 100 80 161 5 1862087920 12064800 21685776
23:06:43 3146 8192000000 10774264896 11161448448 1832618320 18.281 100 82 163 3 1867456784 11953888 22884576
23:06:53 3080 8192000000 10777773296 11165290496 1836101136 18.309 100 87 174 2 1872994464 12743504 24149824
23:07:03 2908 8192000000 10779891088 11172397056 1844882208 18.381 100 86 172 2 1881278848 11885984 24510656
23:07:13 2010 8192000000 10788799344 11176701952 1848094672 18.407 100 85 168 2 1886060512 13782288 24183552
23:07:21 1642 8192000000 10802585200 11189358592 1854234704 18.457 100 89 178 1 1892093728 12591808 25267216
23:07:29 2316 8192000000 10797225328 11191652352 1861658576 18.517 100 89 179 1 1900839888 12942208 26239104
23:07:38 3648 8192000000 10802516576 11195092992 1864781440 18.542 100 86 167 0 1900020416 12164352 23074624
23:07:48 2480 8192000000 10807296960 11196928000 1869125456 18.577 100 86 172 1 1906855136 13026832 24702848
23:07:57 1937 8192000000 10814916080 11205140480 1867206944 18.562 100 92 182 1 1906506624 14225680 25074000
23:08:05 2251 8192000000 10816121216 11203215360 1868375984 18.571 100 89 177 1 1908207520 13597440 26234096
23:08:13 2369 8192000000 10815662288 11209785344 1870350512 18.587 100 89 176 1 1908250800 12438496 25461792
23:08:22 29676 8192000000 10797286448 11201761280 1866794224 18.558 100 73 145 0 1898889936 11737840 20357872
23:08:58 1768 8192000000 10814935008 11209469952 1872358208 18.603 100 81 162 0 1907327360 12069120 22900032
23:09:07 2401 8192000000 10809740112 11209744384 1873014544 18.609 100 76 153 0 1907645664 12197312 22433808
23:09:15 2221 8192000000 10810820864 11212247040 1875432784 18.628 100 76 153 3 1907555488 10717328 21405376
23:09:24 2723 8192000000 10802010496 11206852608 1874837008 18.623 100 63 126 1 1903865856 11378720 17650128
23:09:34 2100 8192000000 10800857632 11208224768 1873319264 18.611 100 67 134 0 1903477504 11020096 19138144
23:09:59 11276 8192000000 10775352544 11200610304 1867577664 18.565 100 29 58 0 1882311280 6615088 8118528
23:10:17 9016 8192000000 10777781840 11204050944 1870373776 18.587 100 26 52 1 1883880736 5683360 7823600
23:10:32 8494 8192000000 10778383264 11204820992 1869519232 18.580 100 22 43 0 1881194272 5742512 5932528
23:10:48 6301 8192000000 10775804384 11204784128 1869840752 18.583 100 21 42 0 1880954064 5656720 5456592
23:11:07 4354 8192000000 10782784320 11212386304 1875665168 18.630 100 33 66 2 1891600368 6996480 8938720
23:11:17 7015 8192000000 10794040256 11218223104 1877059712 18.641 100 26 52 0 1890869072 6420880 7388480
23:11:34 5036 8192000000 10793886208 11219427328 1880191712 18.667 100 28 56 2 1894438608 6255456 7991440
23:11:46 6642 8192000000 10799687440 11223269376 1881094896 18.674 100 32 64 1 1897178432 7276448 8807088
23:12:00 6075 8192000000 10801220480 11223060480 1886202384 18.715 100 25 50 0 1900767696 6706064 7859248
23:12:15 6942 8192000000 10804651392 11225956352 1886416448 18.717 100 27 54 2 1901708560 7402992 7889120
23:12:29 10484 8192000000 10810283696 11225985024 1885764128 18.712 100 26 52 0 1899187024 5761776 7661120
23:12:49 61177 8192000000 10791788160 11233222656 1886612928 18.718 100 24 48 4 1899420720 5739040 7068752
23:13:58 10526 8192000000 10796081920 11233828864 1889800432 18.744 100 24 48 0 1903237712 6019664 7417616
23:14:15 7807 8192000000 10805062720 11243794432 1890940320 18.753 100 24 48 0 1904040240 6130912 6969008
23:14:34 6780 8192000000 10808468352 11244806144 1899506000 18.822 100 29 58 1 1914688256 6301568 8880688
23:14:48 8390 8192000000 10808544960 11245780992 1899951152 18.826 100 27 54 3 1914772496 6680464 8140880
23:15:03 5288 8192000000 10825432288 11250794496 1902431808 18.846 100 41 83 0 1921810416 6474432 12904176
23:15:16 5877 8192000000 10818246752 11248607232 1902167232 18.844 100 31 62 3 1920227536 10225744 7834560
23:15:28 10482 8192000000 10802085568 11241156608 1894774000 18.784 100 26 52 2 1908253296 5394864 8084432
23:15:46 8172 8192000000 10802365504 11239063552 1892577888 18.767 100 23 46 0 1904766080 5648352 6539840
23:16:00 8177 8192000000 10806516336 11240988672 1895246736 18.788 100 18 36 1 1905752096 5437776 5067584
23:16:16 7959 8192000000 10814152576 11248750592 1899299712 18.821 100 27 54 6 1912490240 6254704 6935824
23:16:30 7884 8192000000 10798427440 11233210368 1872509488 18.605 99 14 28 0 1881104448 4923520 3671440
23:16:44 6515 8192000000 10795119632 11228827648 1870560336 18.589 99 22 44 1 1882968512 6176400 6231776
23:16:59 9235 8192000000 10778091696 11205455872 1824125664 18.211 97 20 40 0 1836708736 5915056 6668016
23:17:14 7235 8192000000 10779586992 11206819840 1847954912 18.406 99 20 40 1 1859071808 5377920 5738976
23:17:28 13758 8192000000 10732732896 11157975040 1773846320 17.799 95 31 59 2 1788898432 6056560 8995552
23:17:50 67488 8192000000 10707382848 11136827392 1664686464 16.888 90 26 52 4 1676375744 4424672 7264608
23:19:07 8623 8192000000 10708588384 11123195904 1736072400 17.486 95 33 66 1 1751147536 5054464 10020672
23:19:23 5392 8192000000 10750974624 11165437952 1809084000 18.088 99 38 75 3 1827241552 7755056 10402496
23:19:39 6012 8192000000 10728655904 11144466432 1783342160 17.877 98 34 68 0 1800137744 6962960 9832624
23:19:52 9070 8192000000 10713962768 11131789312 1782118976 17.867 99 19 38 0 1792970976 4833168 6018832
23:20:09 9914 8192000000 10654746000 11069706240 1633714800 16.626 91 22 44 1 1645080288 4828144 6537344
23:20:25 7222 8192000000 10666093152 11078230016 1701314768 17.196 96 25 50 4 1713869008 5688000 6866240
23:20:38 5190 8192000000 10698612960 11102142464 1732679904 17.458 97 35 69 1 1748775520 6803968 9291648
23:20:50 6240 8192000000 10695442144 11099926528 1760674080 17.690 99 31 63 1 1776550160 5584800 10291280
23:21:04 6629 8192000000 10690058160 11100426240 1734612432 17.474 97 22 43 3 1746011600 5660240 5738928
23:21:17 7513 8192000000 10694716320 11108139008 1765055712 17.726 99 25 50 1 1778720000 5924160 7740128
23:21:31 7311 8192000000 10684429424 11087986688 1743506464 17.548 98 33 66 0 1759083120 5431744 10144912
23:21:48 9873 8192000000 10720718656 11130281984 1783003408 17.874 99 32 64 3 1797783680 5490000 9290272
23:22:07 14656 8192000000 10715269696 11130232832 1769719040 17.765 98 15 29 3 1779248048 5128848 4400160
23:22:27 19197 8192000000 10740560784 11152568320 1802109552 18.031 99 33 65 0 1818222640 6352368 9760720
23:22:53 62105 8192000000 10752903696 11163017216 1828237072 18.245 100 42 85 0 1846129280 5691408 12200800
23:24:01 4448 8192000000 10748281040 11173670912 1835269792 18.302 100 39 78 0 1855528368 9984368 10274208
23:24:14 6906 8192000000 10763545056 11177537536 1839744528 18.339 100 34 69 1 1855702320 6104720 9853072
23:24:28 4868 8192000000 10769585776 11180535808 1844493856 18.377 100 41 80 1 1862050848 6158736 11398256
23:24:42 6831 8192000000 10760056496 11183738880 1849263024 18.416 100 30 57 3 1863631984 5783664 8585296
23:24:57 6558 8192000000 10762611536 11187642368 1854461680 18.458 100 46 92 1 1879318480 11090976 13765824
23:25:12 3845 8192000000 10766620848 11192500224 1851228544 18.432 100 25 50 0 1864576864 6736192 6612128
23:25:27 6744 8192000000 10770158592 11193839616 1853850240 18.453 100 29 57 2 1868177344 5383472 8943632
23:25:42 8323 8192000000 10768050192 11200053248 1854869136 18.462 100 19 35 3 1865431056 5203072 5358848
23:25:57 11515 8192000000 10766150656 11194445824 1853792544 18.453 100 24 48 1 1866705232 6113184 6799504
23:26:19 6698 8192000000 10776376944 11196780544 1856963472 18.479 100 32 62 0 1872290576 6416992 8910112
23:26:32 10889 8192000000 10784992848 11209183232 1861842000 18.518 100 38 77 2 1878663792 5198544 11623248
23:27:41 68204 8192000000 10819388816 11243831296 1894906624 18.785 100 36 72 0 1913699184 8992576 9799984
23:29:01 18630 8192000000 10837850112 11262947328 1911525696 18.919 100 38 76 2 1931825568 9576912 10722960
23:29:26 40267 8192000000 10863916816 11284701184 1925063824 19.027 100 47 94 0 1952659616 13454096 14141696
23:30:16 18878 8192000000 10865548624 11298762752 1934051536 19.099 100 41 81 2 1962956544 17159072 11745936
23:30:41 21442 8192000000 10891956176 11313844224 1944837824 19.185 100 58 116 1 1979170912 16597344 17735744
23:31:10 4835 8192000000 10893968208 11316957184 1950247344 19.228 100 58 114 1 1986415840 19634688 16533808
23:31:36 12938 8192000000 10904844400 11330560000 1957479248 19.286 100 50 100 2 1996300784 24332992 14488544
23:32:06 4776 8192000000 10914632304 11341389824 1965055552 19.346 100 54 108 3 2006104976 24833296 16216128
23:32:20 11548 8192000000 10917231904 11344482304 1968152000 19.371 100 53 105 1 2009136960 25078096 15906864
23:32:42 12231 8192000000 10927785984 11353186304 1975000096 19.425 100 55 110 2 2018496752 26896768 16599888
23:33:04 8919 8192000000 10925045680 11354226688 1974819664 19.424 100 46 91 1 2015150288 26191936 14138688
23:33:23 14131 8192000000 10932595440 11362426880 1979787424 19.463 100 47 94 1 2019603904 25575024 14241456
23:33:49 31577 8192000000 10941120560 11378925568 1987267424 19.522 100 42 83 0 2028829296 28317808 13244064
23:34:35 7942 8192000000 10957623968 11387273216 1995605536 19.588 100 49 98 0 2044136176 32746128 15784512
23:34:53 17842 8192000000 10955073312 11387551744 1996289520 19.593 100 45 90 1 2044511376 34121696 14100160
23:35:22 13137 8192000000 10942307568 11376316416 1977333456 19.444 99 47 93 2 2022269760 30898320 14037984
23:35:46 7260 8192000000 10950286640 11379257344 1978680288 19.454 99 56 110 1 2027607968 32037952 16889728
23:36:03 5547 8192000000 10936318640 11365367808 1967314960 19.364 99 58 116 0 2018226416 33634032 17277424
23:36:15 5693 8192000000 10960433968 11383558144 1991641632 19.557 100 64 128 1 2044910416 34223680 19045104
23:36:30 6251 8192000000 10958043328 11387465728 1997143216 19.600 100 64 128 2 2051555712 34619536 19792960
23:36:49 7765 8192000000 10963666448 11388112896 1997247616 19.601 100 67 134 1 2051881120 34688256 19945248
23:37:11 18806 8192000000 10975845280 11398397952 2002886096 19.645 100 74 147 1 2061514848 37403968 21224784
23:37:36 11882 8192000000 10985659408 11411816448 2009982848 19.701 100 63 126 1 2071926304 42565632 19377824
23:37:56 2343 8192000000 10996373648 11418865664 2014076784 19.734 100 68 136 0 2075646368 41189120 20380464
23:38:09 11803 8192000000 10979129184 11406069760 1992084528 19.560 99 65 128 0 2053452128 42572240 18795360
23:38:28 4621 8192000000 10993934736 11416326144 2016602784 19.753 100 81 160 0 2084477072 43336176 24538112
23:38:40 8410 8192000000 11005750256 11426037760 2018129040 19.765 100 69 136 1 2083002352 44724288 20149024
23:38:55 4971 8192000000 11001857248 11416178688 2000271392 19.625 99 83 165 1 2070574992 45988192 24315408
23:39:09 1205 8192000000 11008439360 11423453184 2019785088 19.778 100 90 182 0 2093370816 46736336 26849392
23:39:19 5477 8192000000 10973008272 11400232960 1993596672 19.572 99 65 130 0 2058519136 45238352 19684112
23:39:32 3226 8192000000 10962957392 11377496064 1972673280 19.407 98 81 159 2 2041885648 45048480 24163888
23:39:42 2518 8192000000 10994194448 11414634496 2007418320 19.681 100 78 156 0 2079256416 47283568 24554528
23:39:51 5936 8192000000 10983020416 11410632704 2001956144 19.638 100 76 150 0 2071645520 45893920 23795456
23:40:07 5860 8192000000 10999219600 11420676096 2007186544 19.679 100 76 152 1 2082987360 52449248 23351568
23:40:20 1237 8192000000 10993065616 11406700544 1994189840 19.577 100 93 188 0 2073560576 51043456 28327280
23:40:28 2125 8192000000 10987256960 11402588160 1996797504 19.597 100 85 170 1 2074311664 52069856 25444304
23:40:38 1428 8192000000 10992910688 11403341824 1997409616 19.602 100 86 172 1 2076010480 52526032 26074832
23:40:48 3466 8192000000 11005981008 11418550272 2005917184 19.669 100 83 166 0 2085121888 53805408 25399296
23:41:01 9449 8192000000 10976720752 11403124736 1989249840 19.538 100 68 136 1 2066203872 54940000 22014032
23:41:17 9379 8192000000 10983386144 11405660160 1971950432 19.401 99 68 137 1 2051642016 57861088 21830496
23:41:35 5249 8192000000 10986487392 11401666560 1967071408 19.362 99 77 153 2 2051613024 60046848 24494768
23:41:49 1697 8192000000 10976657856 11393839104 1961629248 19.319 99 82 161 1 2045563712 58558336 25376128
23:41:57 4717 8192000000 10980714432 11400773632 1970020976 19.386 99 81 160 1 2054563600 59201376 25341248
23:42:10 4373 8192000000 10965125488 11383631872 1954382608 19.261 99 80 160 1 2037397504 57841344 25173552
23:42:21 3303 8192000000 10960818192 11376005120 1959111168 19.299 100 77 153 1 2039731792 56313584 24307040
23:42:31 5827 8192000000 10947695424 11371040768 1954671952 19.264 100 70 140 3 2033961120 57373536 21915632
23:42:46 9403 8192000000 10944588528 11383836672 1962982768 19.330 100 35 70 0 2031660928 56202384 12475776
23:43:04 5971 8192000000 10958387056 11394068480 1971985840 19.401 100 45 89 0 2044878336 58123520 14768976
23:43:17 1794 8192000000 10971914592 11384471552 1964767840 19.344 99 82 162 2 2046446448 56714768 24963840
23:43:26 14450 8192000000 10948994560 11397963776 1956291248 19.277 99 38 76 0 2030269296 60982624 12995424
23:43:48 14802 8192000000 10958755472 11394781184 1972260640 19.403 100 36 70 1 2040884208 57091408 11532160
23:44:14 1376 8192000000 10985615584 11396841472 1971208272 19.395 100 81 164 2 2058211888 60047632 26955984
23:44:23 2613 8192000000 10953204368 11370569728 1945130224 19.188 99 71 142 0 2029248240 61729424 22388592
23:44:33 2685 8192000000 10972031120 11391737856 1965737984 19.352 100 78 154 1 2053834672 63838512 24258176
23:44:42 4030 8192000000 10960214272 11377774592 1966760160 19.360 100 78 156 0 2043674496 52622080 24292256
23:44:54 9422 8192000000 10916105072 11351801856 1940160288 19.148 99 57 111 0 2009153056 50865072 18127696
23:45:15 10462 8192000000 10948127904 11373465600 1941522640 19.159 99 48 95 1 2009971440 52740272 15708528
23:45:35 9051 8192000000 10963948480 11388035072 1970162640 19.387 100 65 130 1 2049057248 56097552 22797056
23:45:53 3273 8192000000 10971239152 11394838528 1972299440 19.404 100 71 142 1 2051768256 56572640 22896176
23:46:04 2874 8192000000 10961395616 11397386240 1970594944 19.390 100 58 116 0 2048789920 58645232 19549744
23:46:14 15668 8192000000 10938359520 11382050816 1924364176 19.022 98 42 84 2 1999903120 60765136 14773808
23:46:46 12632 8192000000 10943474800 11385663488 1955652256 19.271 100 37 74 0 2027069392 58136400 13280736
23:47:08 18535 8192000000 10919190528 11369172992 1941269072 19.157 100 25 50 0 2006176032 55434528 9472432
23:47:40 7798 8192000000 10933582848 11377455104 1947598128 19.207 100 43 86 1 2020552240 57752544 15201568
23:47:57 2875 8192000000 10946124240 11385577472 1950854880 19.233 100 41 82 0 2026141552 60869648 14417024
23:48:06 17693 8192000000 10938808192 11386855424 1954455728 19.262 100 31 62 2 2021186304 55284368 11446208
23:48:38 22480 8192000000 10916329312 11376762880 1920006272 18.987 98 32 64 2 1991305808 58975504 12324032
23:49:13 19781 8192000000 10886996672 11336302592 1879831632 18.664 97 21 41 2 1934798288 47100896 7865760
23:49:44 13175 8192000000 10870261328 11318239232 1894481360 18.782 98 20 40 0 1942522352 40837840 7203152
23:50:03 18985 8192000000 10862450800 11314434048 1877292880 18.643 98 18 35 2 1912297616 29131232 5873504
23:50:29 20625 8192000000 10858052336 11324194816 1909257696 18.901 100 16 32 0 1944089232 29410736 5420800
23:51:31 55864 8192000000 10840773456 11306221568 1885385072 18.709 98 7 14 0 1902608192 14880576 2342544
23:52:59 62810 8192000000 10868571760 11314692096 1910681136 18.912 99 30 60 0 1926747120 7941824 8124160
23:54:09 94208 8192000000 10845973280 11299606528 1863189264 18.529 96 20 40 0 1884392112 15830512 5372336
23:56:23 107970 8192000000 10868985808 11347267584 1915708336 18.952 99 28 56 0 1944470864 20288480 8474048
23:58:17 53290 8192000000 10857605232 11320438784 1927225232 19.045 99 10 20 2 1940511456 10492816 2793408
23:59:18 22513 8192000000 10893128160 11339268096 1943068896 19.171 99 38 76 1 1961326176 7803792 10453488
23:59:48 6063 8192000000 10877338512 11322081280 1935821888 19.113 99 35 70 0 1953735632 8465984 9447760
00:00:01 4849 8192000000 10876055456 11328843776 1948062224 19.211 100 29 58 1 1962991248 7306336 7622688
00:00:16 7955 8192000000 10879621296 11330682880 1948245152 19.212 100 34 68 0 1966240864 7820480 10175232
00:00:33 22783 8192000000 10906827552 11342032896 1926396048 19.038 98 65 128 2 1952962944 8606608 17960288
00:01:14 80690 8192000000 10867694048 11341877248 1945021008 19.187 100 19 40 0 1960939056 10986944 4931104
00:02:42 8888 8192000000 10871462640 11341922304 1950484880 19.230 100 10 20 1 1964436800 10415008 3536912
00:02:59 35608 8192000000 10858360288 11323006976 1895929552 18.794 97 26 52 1 1911053312 7227056 7896704
00:04:01 75090 8192000000 10886520896 11345387520 1931099888 19.076 99 18 36 4 1950601648 14539776 4961984
00:05:29 50579 8192000000 10891553872 11359354880 1962119520 19.323 100 26 52 0 1983627200 13856880 7650800
00:07:18 74751 8192000000 10904450800 11366817792 1970568960 19.390 100 30 56 1 1995422464 15780320 9073184
00:08:42 67743 8192000000 10892983072 11378315264 1956463408 19.278 99 17 34 0 1976017088 14797792 4755888
00:09:56 48658 8192000000 10921338560 11398381568 1983332128 19.491 100 17 34 1 2010638128 22562112 4743888
00:10:50 53324 8192000000 10911269024 11379265536 1965496032 19.350 99 12 24 1 1982222336 13268928 3457376
00:11:53 37224 8192000000 10935699936 11396087808 1994175024 19.577 100 35 67 2 2013883104 11101888 8606192
00:12:37 54170 8192000000 10918670080 11389202432 1958608224 19.295 98 14 28 0 1979446720 16472848 4365648
00:13:38 52059 8192000000 10898682992 11360399360 1906836768 18.881 96 10 20 1 1924692912 14686448 3169696
00:14:37 88079 8192000000 10905143408 11370962944 1936269696 19.117 98 11 22 0 1955489104 16224544 2994864
00:16:15 75474 8192000000 10928519888 11379994624 1954159936 19.260 99 20 40 2 1972412400 12535136 5717328
00:18:09 42458 8192000000 10910316112 11363659776 1936948608 19.122 98 16 32 0 1953078000 11731808 4397584
00:19:00 29031 8192000000 10926515472 11382943744 1982045968 19.481 100 32 64 0 2004943456 13602448 9295040
00:19:37 35715 8192000000 10902347792 11360509952 1947720928 19.208 98 47 95 1 1978742192 18055072 12966192
00:20:21 84496 8192000000 10902404112 11376259072 1905539520 18.871 97 20 39 2 1927459248 16091296 5828432
00:21:52 62194 8192000000 10906376944 11379838976 1959628624 19.303 99 22 44 0 1980555136 15033776 5892736
00:23:01 97791 8192000000 10913490784 11361599488 1934574016 19.103 98 8 16 0 1952587760 15455120 2558624
00:24:52 81947 8192000000 10924914608 11378274304 1976557840 19.437 100 34 68 1 1999187280 13486288 9143152
00:26:22 19155 8192000000 10929393024 11375472640 1979626752 19.462 100 46 90 2 2003506208 10986896 12892560
00:26:48 13616 8192000000 10917175968 11380019200 1983387568 19.492 100 34 68 1 2004454784 11727056 9340160
00:27:11 21715 8192000000 10891444320 11359215616 1948747904 19.217 98 26 52 0 1963979856 7172064 8059888
00:27:41 52605 8192000000 10859302288 11340296192 1921547296 18.999 98 8 16 0 1932723664 9118784 2057584
00:28:59 45128 8192000000 10844887600 11314520064 1920003904 18.987 99 15 30 0 1932265952 8054384 4207664
00:29:51 34296 8192000000 10834377424 11300487168 1896904608 18.801 98 10 18 2 1906843488 7427408 2511472
00:30:34 71847 8192000000 10829565072 11300655104 1794355728 17.968 92 10 20 0 1806857312 9792272 2709312
00:31:52 46348 8192000000 10841956768 11308457984 1861676896 18.517 97 16 32 1 1883107968 17079168 4351904
00:32:45 28870 8192000000 10859140544 11309371392 1921241296 18.997 100 34 68 1 1939785392 8678096 9866000
00:33:31 71907 8192000000 10845721600 11324665856 1876051472 18.633 97 17 34 1 1893637088 12471376 5114240
00:34:56 72627 8192000000 10871113936 11331268608 1877545968 18.645 97 8 16 0 1897710672 18023824 2140880
00:36:20 26411 8192000000 10861839504 11321397248 1915164256 18.948 99 32 63 2 1936829040 12688672 8976112
00:36:55 86960 8192000000 10879940544 11346276352 1907424832 18.886 98 18 36 0 1930729616 18342944 4961840
00:38:28 44147 8192000000 10906758576 11333783552 1941811936 19.161 99 35 67 1 1964012912 12382992 9817984
00:39:21 34671 8192000000 10898908064 11349295104 1942314880 19.165 99 42 84 1 1963741920 10248144 11178896
00:40:07 39949 8192000000 10854050784 11318394880 1875717392 18.631 96 30 60 1 1893970304 9845584 8407328
00:40:53 20311 8192000000 10881625072 11332067328 1938661472 19.136 100 41 82 1 1959316912 8698048 11957392
00:41:19 48467 8192000000 10894566192 11331293184 1913386016 18.934 98 40 78 0 1935891488 11685600 10819872
00:42:16 52585 8192000000 10878866352 11350437888 1927662960 19.048 99 39 77 3 1949422144 11502928 10256256
00:43:15 78713 8192000000 10865145696 11336232960 1881211760 18.675 96 9 18 1 1895378960 11505440 2661760
00:44:40 162281 8192000000 10880604448 11349319680 1928148416 19.052 99 9 18 0 1946839008 16090144 2600448
00:47:48 53261 8192000000 10879500304 11346939904 1954402096 19.262 100 25 50 1 1972939568 11317760 7219712
00:48:53 61906 8192000000 10844030528 11309309952 1910096864 18.907 98 21 42 1 1926613488 10656608 5860016
00:50:01 75724 8192000000 10850680016 11331768320 1923624432 19.016 99 10 20 1 1937943296 11307280 3011584
00:51:23 28533 8192000000 10838880080 11311370240 1877084720 18.642 97 12 24 0 1892456944 11497664 3874560
00:52:11 73960 8192000000 10860013200 11332657152 1923345840 19.014 100 11 22 1 1939695696 13267296 3082560
00:54:00 51016 8192000000 10865305408 11330076672 1921382288 18.998 99 15 31 0 1940224096 14140256 4701552
00:55:03 60286 8192000000 10888857312 11349372928 1910044496 18.907 98 19 38 0 1931385072 15598400 5742176
00:56:09 69441 8192000000 10884085456 11360927744 1957327056 19.285 100 20 39 1 1980493264 17142176 6024032
00:57:51 99193 8192000000 10902274992 11372634112 1939281584 19.141 98 21 42 2 1955037312 10325824 5429904
00:59:36 56106 8192000000 10895730128 11355586560 1933306080 19.093 98 10 20 0 1944542352 9001456 2234816
01:00:44 42465 8192000000 10901104448 11358789632 1915260512 18.949 97 31 62 1 1933119728 9392464 8466752
01:01:33 42663 8192000000 10907533696 11375505408 1968404688 19.373 100 23 44 1 1987271280 12496912 6369680
01:02:27 68015 8192000000 10914481168 11359465472 1915394528 18.950 97 20 40 1 1930504032 9545136 5564368
01:03:41 16453 8192000000 10938069136 11374194688 1976126272 19.434 100 60 119 1 2005568608 12791488 16650848
01:04:05 23220 8192000000 10928993632 11383037952 1973592016 19.414 100 42 84 0 2000716080 14912096 12211968
01:05:41 122710 8192000000 10918287728 11390689280 1964739008 19.344 99 21 42 1 1983109056 11002800 7367248
01:08:06 88772 8192000000 10899644608 11398701056 1961600656 19.319 99 15 30 0 1987785840 21178960 5006224
01:09:57 27241 8192000000 10902093376 11392675840 1960011840 19.306 99 6 12 1 1981343392 19331136 2000416
01:10:35 32858 8192000000 10907574560 11387011072 1982010656 19.481 100 14 28 0 2001516720 15401744 4104320
01:11:17 63019 8192000000 10902091072 11373756416 1924065120 19.019 97 11 22 2 1939797248 12681744 3050384
01:12:29 72340 8192000000 10888181472 11369254912 1915463984 18.950 97 17 34 0 1939089088 18015584 5609520
01:14:14 60144 8192000000 10895239984 11370811392 1952267696 19.245 99 13 26 0 1973164768 16502816 4394256
01:15:38 111170 8192000000 10903699040 11380322304 1937737328 19.129 98 8 16 1 1958629264 18651776 2240160
01:17:37 17730 8192000000 10920402464 11371147264 1960952976 19.314 99 47 90 1 1980852768 7613312 12286480
01:18:01 43969 8192000000 10900279296 11356491776 1937112816 19.124 99 28 55 0 1954181264 9370064 7698384
01:18:51 36223 8192000000 10890261536 11352231936 1939982560 19.147 99 27 54 3 1962049024 14083056 7983408
01:19:44 58194 8192000000 10857939952 11307347968 1826554320 18.231 94 25 48 0 1845839040 12416896 6867824
01:20:50 13995 8192000000 10867190656 11315646464 1930274592 19.069 100 46 93 1 1952005648 8654960 13076096
01:21:25 46321 8192000000 10872163424 11334434816 1919416000 18.982 99 49 97 3 1944259456 11451632 13391824
01:22:25 52983 8192000000 10854158608 11307704320 1871591888 18.597 97 28 57 0 1891477360 11230512 8654960
01:23:28 87421 8192000000 10859938608 11316998144 1863965408 18.535 97 27 54 3 1881162096 9558720 7637968
01:25:02 45511 8192000000 10863274544 11296346112 1838691808 18.330 95 44 88 1 1862679344 11896256 12091280
01:26:01 87392 8192000000 9297679248 9566961664 458097600 5.295 24 10 17 1 463197696 2432016 2668080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-11-2020 01:29:09 to 24-11-2020 01:29:40.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-11-2020 01:29:41 to 24-11-2020 01:29:43.

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          242678
MON$OLDEST_ACTIVE               242679
MON$OLDEST_SNAPSHOT             242679
MON$NEXT_TRANSACTION            242679
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                       2018944
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 ---
:173: 
:174: mscs-test-161.budzdorov.ru    Tue Nov 24 01:27:30 2020
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:176: 
--- end of diff output ---

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

24.11.20 01:29:44. 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-24 01:29:46 No severe PSQL-related problems occured
24.11.20 01:29:47. End of report.