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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-07 22:27:07
DTS_END                         2020-12-07 22:27:07.8170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54460
TRN_ID                          251786
ATT_ID                          672
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9521.93 18793 1142632
customer order: creation 181.81 343 21817
customer order: refuse 15.92 290 1910
order to supplier: creation 47.63 1188 5716
order to supplier: removal 3.53 72471 424
invoice (draft): creation 48.25 2962 5790
invoice (draft): removal 55.73 553 6687
invoice accept: apply 43.39 15828 5207
invoice accept: cancel 49.71 616 5965
customer reserve: creation 3920.19 161 470423
customer reserve: removal 4850.54 42 582065
realization accept: apply 87.63 156 10515
realization accept: cancel 81.78 98 9813
payment from customer: creation 61.20 98 7344
payment from customer: removal 6.05 57 726
payment to supplier: creation 52.61 108 6313
payment to supplier: removal 3.42 54 410
service: total inventory turnovers 4.64 1041 557
service: total monetary turnovers 7.06 19 847
service: aggregate perf. data 0.83 22192 99
service: refresh index statistics 0.03 257581 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-12-2020 22:28:32 to 07-12-2020 22:28:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4729
TEST_TIME 2 5303
TEST_TIME 3 4215
TEST_TIME 4 4135
TEST_TIME 5 5094
TEST_TIME 6 5819
TEST_TIME 7 6666
TEST_TIME 8 6846
TEST_TIME 9 7027
TEST_TIME 10 7725
TEST_TIME 11 8042
TEST_TIME 12 8664
TEST_TIME 13 9472
TEST_TIME 14 9619
TEST_TIME 15 9561
TEST_TIME 16 10280
TEST_TIME 17 10955
TEST_TIME 18 10928
TEST_TIME 19 11089
TEST_TIME 20 11399
TEST_TIME 21 11311
TEST_TIME 22 11885
TEST_TIME 23 12089
TEST_TIME 24 11744
TEST_TIME 25 11620
TEST_TIME 26 11576
TEST_TIME 27 11295
TEST_TIME 28 11203
TEST_TIME 29 10978
TEST_TIME 30 11045
TEST_TIME 31 11163
TEST_TIME 32 10932
TEST_TIME 33 10856
TEST_TIME 34 10742
TEST_TIME 35 10527
TEST_TIME 36 10400
TEST_TIME 37 10296
TEST_TIME 38 10168
TEST_TIME 39 10161
TEST_TIME 40 10162
TEST_TIME 41 10132
TEST_TIME 42 10115
TEST_TIME 43 10147
TEST_TIME 44 10111
TEST_TIME 45 10145
TEST_TIME 46 10142
TEST_TIME 47 10184
TEST_TIME 48 10147
TEST_TIME 49 10221
TEST_TIME 50 10235
TEST_TIME 51 10207
TEST_TIME 52 10258
TEST_TIME 53 10118
TEST_TIME 54 10016
TEST_TIME 55 10026
TEST_TIME 56 10145
TEST_TIME 57 10042
TEST_TIME 58 9923
TEST_TIME 59 9910
TEST_TIME 60 9912
TEST_TIME 61 9815
TEST_TIME 62 9888
TEST_TIME 63 9875
TEST_TIME 64 9836
TEST_TIME 65 9993
TEST_TIME 66 9953
TEST_TIME 67 10009
TEST_TIME 68 9982
TEST_TIME 69 10022
TEST_TIME 70 10021
TEST_TIME 71 9985
TEST_TIME 72 10023
TEST_TIME 73 10073
TEST_TIME 74 10227
TEST_TIME 75 10145
TEST_TIME 76 10027
TEST_TIME 77 9940
TEST_TIME 78 10019
TEST_TIME 79 9951
TEST_TIME 80 9866
TEST_TIME 81 9800
TEST_TIME 82 9789
TEST_TIME 83 9769
TEST_TIME 84 9832
TEST_TIME 85 9809
TEST_TIME 86 9785
TEST_TIME 87 9819
TEST_TIME 88 9912
TEST_TIME 89 9871
TEST_TIME 90 9880
TEST_TIME 91 9927
TEST_TIME 92 9953
TEST_TIME 93 9969
TEST_TIME 94 9958
TEST_TIME 95 9949
TEST_TIME 96 9992
TEST_TIME 97 9944
TEST_TIME 98 9880
TEST_TIME 99 9840
TEST_TIME 100 9813
TEST_TIME 101 9777
TEST_TIME 102 9721
TEST_TIME 103 9687
TEST_TIME 104 9686
TEST_TIME 105 9688
TEST_TIME 106 9643
TEST_TIME 107 9634
TEST_TIME 108 9606
TEST_TIME 109 9646
TEST_TIME 110 9661
TEST_TIME 111 9654
TEST_TIME 112 9653
TEST_TIME 113 9637
TEST_TIME 114 9606
TEST_TIME 115 9623
TEST_TIME 116 9664
TEST_TIME 117 9623
TEST_TIME 118 9675
TEST_TIME 119 9607
TEST_TIME 120 9527

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 07-12-2020 22:28:35 to 07-12-2020 22:28:39.

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 1581120 1581120 0 0.00 0 26494 5 0 0
doc_list_biud 1581116 1581116 0 0.00 0 37741 20 0 0
sp_add_invoice_to_stock 5349 5207 142 2.65 45 190021 15829 0 142
sp_cancel_adding_invoice 5965 5965 0 0.00 3 46099 616 0 0
sp_cancel_client_order 1910 1910 0 0.00 4 23852 290 0 0
sp_cancel_customer_reserve 582065 582065 0 0.00 1 37744 42 0 0
sp_cancel_pay_from_customer 726 726 0 0.00 2 4481 57 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 3 2879 54 0 0
sp_cancel_supplier_invoice 6697 6687 10 0.14 1 26941 553 0 10
sp_cancel_supplier_order 424 424 0 0.00 12 723833 72472 0 0
sp_cancel_write_off 9813 9813 0 0.00 1 12975 99 0 0
sp_client_order 21817 21817 0 0.00 3 29651 343 0 0
sp_customer_reserve 470423 470423 0 0.00 0 73620 162 0 0
sp_fill_shopping_cart 33319 33319 0 0.00 1 17857 38 0 0
sp_fill_shopping_cart_clo_res 470414 470414 0 0.00 0 16792 13 0 0
sp_get_clo_for_invoice 5197 5197 0 0.00 0 39086 265 0 0
sp_kill_cost_storno 16914 16914 0 0.00 0 10024 40 0 0
sp_kill_qstorno_ret_qs2qd 1181054 1181054 0 0.00 0 37737 23 0 0
sp_kill_qty_storno 622571 622571 0 0.00 0 37740 50 0 0
sp_lock_selected_doc 21806 21806 0 0.00 0 7883 7 0 0
sp_make_cost_storno 29368 29368 0 0.00 0 11302 45 0 0
sp_multiply_rows_for_pdistr 29364 29364 0 0.00 0 6519 22 0 0
sp_multiply_rows_for_qdistr 21817 21817 0 0.00 0 18009 172 0 0
sp_pay_from_customer 7344 7344 0 0.00 4 9236 99 0 0
sp_pay_to_supplier 6313 6313 0 0.00 5 13428 109 0 0
sp_payment_common 13657 13657 0 0.00 1 9232 29 0 0
sp_qd_handle_on_cancel_clo 1910 1910 0 0.00 0 23846 260 0 0
sp_qd_handle_on_invoice_upd_sts 11159 11159 0 0.00 0 29993 241 0 0
sp_qd_handle_on_reserve_upd_sts 10513 10513 0 0.00 0 24669 52 0 0
sp_reserve_write_off 10515 10515 0 0.00 5 24694 156 0 0
sp_supplier_invoice 5790 5790 0 0.00 7 133341 2963 0 0
sp_supplier_order 5716 5716 0 0.00 5 67441 1188 0 0
srv_aggregate_perf_data 99 99 0 0.00 3001 289028 22193 0 0
srv_fill_mon_cache_memory 136 136 0 0.00 1443 135562 39849 0 0
srv_find_qd_qs_mism 1094450 1094450 0 0.00 0 26492 5 0 0
srv_make_invnt_saldo 557 557 0 0.00 38 59752 1042 0 0
srv_make_money_saldo 847 847 0 0.00 1 762 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 169615 301476 257581 0 0
t$perf-abend:sp_add_invoice_to_stock 142 142 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5207 5207 0 0.00 0 14175 151 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 5206 85 0 0
t$perf-norm:sp_cancel_client_order 1910 1910 0 0.00 0 4118 14 0 0
t$perf-norm:sp_cancel_customer_reserve 719 719 0 0.00 0 11055 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 726 726 0 0.00 0 2543 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 5890 29 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 3915 19 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 28538 1435 0 0
t$perf-norm:sp_cancel_write_off 1059 1059 0 0.00 0 1775 5 0 0
t$perf-norm:sp_client_order 21817 21817 0 0.00 0 19308 18 0 0
t$perf-norm:sp_customer_reserve 1064 1064 0 0.00 0 10910 14 0 0
t$perf-norm:sp_pay_from_customer 7344 7344 0 0.00 0 4461 9 0 0
t$perf-norm:sp_pay_to_supplier 6313 6313 0 0.00 0 4450 11 0 0
t$perf-norm:sp_reserve_write_off 10515 10515 0 0.00 0 12711 15 0 0
t$perf-norm:sp_supplier_invoice 5790 5790 0 0.00 0 10844 19 0 0
t$perf-norm:sp_supplier_order 5716 5716 0 0.00 0 10073 15 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 275 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 136 136 0 0.00 0 22 1 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 11277 31 0 0
t$perf-norm:srv_make_money_saldo 847 847 0 0.00 0 519 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10670 10386 284 2.66 0 5450 20 0 284
v_all_customers 39438 39438 0 0.00 0 181 0 0 0
v_all_suppliers 32480 32480 0 0.00 0 35 1 0 0
v_all_wares 43628 43628 0 0.00 0 104 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 976 7 0 0
v_cancel_client_order 3820 3820 0 0.00 0 3311 5 0 0
v_cancel_customer_prepayment 1452 1452 0 0.00 0 2647 9 0 0
v_cancel_customer_reserve 1438 1438 0 0.00 0 1290 3 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 2761 9 0 0
v_cancel_supplier_invoice 844 824 20 2.36 0 3864 22 0 20
v_cancel_supplier_order 848 848 0 0.00 0 2424 7 0 0
v_cancel_write_off 2118 2118 0 0.00 0 4154 14 0 0
v_max_id_clo_ord 5714 5714 0 0.00 0 6425 3 0 0
v_max_id_clo_res 1064 1064 0 0.00 0 3124 15 0 0
v_max_id_ord_sup 5790 5790 0 0.00 0 4338 5 0 0
v_max_non_paid_invoice 1576 1576 0 0.00 0 646 3 0 0
v_max_non_paid_realizn 3982 3982 0 0.00 0 3399 5 0 0
v_min_id_clo_ord 5714 5714 0 0.00 0 17814 17 0 0
v_min_id_clo_res 1064 1064 0 0.00 0 2831 6 0 0
v_min_id_ord_sup 5790 5790 0 0.00 0 6767 10 0 0
v_min_non_paid_invoice 6313 6313 0 0.00 0 6380 17 0 0
v_min_non_paid_realizn 7344 7344 0 0.00 0 9229 19 0 0
v_our_firm 10914 10914 0 0.00 0 14 1 0 0
v_reserve_write_off 21026 21026 0 0.00 0 4642 6 0 0
x_lock_depdocs_on_canc_invoice 12240 12240 0 0.00 0 11465 92 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 11918 305 0 0
x_make_qstorno_1000_1200 5716 5716 0 0.00 2 67394 1108 0 0
x_make_qstorno_1200_2000 5790 5790 0 0.00 3 124854 2831 0 0
x_make_qstorno_2100_3300 470423 470423 0 0.00 0 73617 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-12-2020 22:28:40 to 07-12-2020 22:28:44.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:17 11000 8192000000 10195407696 10499411968 978916368 10.674 77 60 122 0 1001505408 2809584 19779456
19:57:36 19443 8192000000 10323361280 10633945088 1355922608 14.201 100 82 164 0 1387124496 4307808 26894080
19:58:08 17196 8192000000 10355864736 10677301248 1414644448 14.725 100 84 169 0 1448088112 5761744 27681920
19:58:35 22013 8192000000 10386446048 10711404544 1441565904 14.963 100 90 180 0 1477648528 6538976 29543648
19:59:07 28319 8192000000 10414173120 10747842560 1470273520 15.216 100 87 174 0 1505926944 7376288 28277136
19:59:52 14108 8192000000 10450644352 10783027200 1501565712 15.490 100 90 180 1 1538222224 7833472 28823040
20:00:17 23246 8192000000 10474040464 10812039168 1522564912 15.673 100 83 166 0 1557667312 8603056 26499344
20:00:50 17903 8192000000 10499055168 10839916544 1544619952 15.864 100 85 170 0 1580798560 9208112 26970496
20:01:16 12333 8192000000 10500496336 10849255424 1561411232 16.008 100 79 158 0 1595539280 9541248 24586800
20:01:37 19089 8192000000 10536540432 10888474624 1582656320 16.191 100 85 171 0 1618822496 10162608 26003568
20:02:05 9637 8192000000 10554140576 10906279936 1609986592 16.425 100 83 166 0 1645333776 10381552 24965632
20:02:23 10542 8192000000 10568852448 10924916736 1624215744 16.546 100 76 153 1 1657568416 10729440 22623232
20:02:41 11361 8192000000 10585318336 10949779456 1647958912 16.747 100 88 177 1 1685438576 10963408 26516256
20:03:00 10211 8192000000 10617857200 10983456768 1675436160 16.979 100 79 158 0 1709404160 10376480 23591520
20:03:18 6934 8192000000 10634369424 11000020992 1693461472 17.130 100 77 154 0 1726293840 10566432 22265936
20:03:35 9905 8192000000 10656049328 11024560128 1709113136 17.261 100 80 159 2 1744321936 11945120 23263680
20:03:51 5738 8192000000 10671008080 11043241984 1732391840 17.455 100 87 174 0 1771107568 13886224 24829504
20:04:06 5227 8192000000 10682322560 11057258496 1745243280 17.562 100 89 178 3 1784696256 13951728 25501248
20:04:18 7063 8192000000 10692216320 11065712640 1748510288 17.589 100 80 160 1 1785566016 14735968 22319760
20:04:32 4743 8192000000 10696989600 11074342912 1757789568 17.666 100 84 168 1 1796023552 14814448 23419536
20:04:44 3223 8192000000 10705801120 11084046336 1770975728 17.775 100 83 167 0 1807232944 13504608 22752608
20:04:54 5015 8192000000 10717714976 11096141824 1775980080 17.816 100 86 172 1 1814783072 13898496 24904496
20:05:06 3312 8192000000 10728810880 11107622912 1786847888 17.906 100 82 164 1 1824029808 14636752 22545168
20:05:16 2979 8192000000 10731263680 11110887424 1793305344 17.959 100 86 170 2 1831327856 13829200 24193312
20:05:26 6354 8192000000 10737967856 11125215232 1800741840 18.020 100 85 170 0 1838534464 14099728 23692896
20:05:41 7633 8192000000 10749221328 11135922176 1810779408 18.102 100 79 158 1 1846005984 13342416 21884160
20:05:55 2879 8192000000 10765586992 11150213120 1827742512 18.241 100 86 169 1 1866042688 14528256 23771920
20:06:04 2531 8192000000 10782286928 11166654464 1838239200 18.326 100 94 189 3 1878784160 14802144 25742816
20:06:13 1899 8192000000 10769874736 11156885504 1836515584 18.312 100 90 180 3 1875656704 13918016 25223104
20:06:22 1717 8192000000 10786226560 11171377152 1838688208 18.330 100 90 178 3 1877347616 13703104 24956304
20:06:31 1670 8192000000 10787727312 11173883904 1843322192 18.368 100 92 185 0 1883354656 14745264 25287200
20:06:39 1732 8192000000 10791906624 11176939520 1848880208 18.413 100 97 195 2 1891550832 15839264 26831360
20:06:48 1666 8192000000 10797558352 11182534656 1850740864 18.428 100 93 188 2 1891730336 15490128 25499344
20:06:56 1620 8192000000 10794211008 11185004544 1853487872 18.450 100 87 174 2 1891042672 11927792 25627008
20:07:03 1245 8192000000 10797414864 11183771648 1853214352 18.448 100 93 184 3 1892433936 13072800 26146784
20:07:11 1358 8192000000 10805769888 11192762368 1857178672 18.480 100 88 175 0 1895320192 13179264 24962256
20:07:19 3765 8192000000 10800206624 11190706176 1860729424 18.509 100 92 182 0 1899421776 13089520 25602832
20:07:29 1052 8192000000 10808748448 11199926272 1866291968 18.554 100 89 178 2 1904338896 12584672 25462256
20:07:37 2653 8192000000 10793319280 11196817408 1864345152 18.538 100 75 151 1 1898154016 12602048 21206816
20:07:48 2921 8192000000 10778102272 11192549376 1861196496 18.513 100 52 104 0 1886174688 10284384 14693808
20:07:57 9479 8192000000 10778860336 11200512000 1864689664 18.541 100 41 82 0 1884389744 7672224 12027856
20:08:28 13937 8192000000 10800618640 11210313728 1871434080 18.596 100 54 106 0 1893220544 5867072 15919392
20:08:48 24428 8192000000 10787768720 11201990656 1869843376 18.583 100 41 82 3 1889094448 7446464 11804608
20:09:19 1280 8192000000 10827754608 11219570688 1882350288 18.684 100 94 193 2 1918775632 9966784 26458560
20:09:26 23153 8192000000 10783526032 11210985472 1873036128 18.609 100 33 64 5 1889242320 7086560 9119632
20:09:57 7514 8192000000 10785065808 11214704640 1877338256 18.644 100 30 60 3 1892849504 6083744 9427504
20:10:17 5799 8192000000 10796004688 11217178624 1877190160 18.642 100 29 57 1 1892888976 7234880 8463936
20:10:31 8008 8192000000 10786065792 11219873792 1882996512 18.689 100 24 48 3 1895892512 6297824 6598176
20:10:51 7805 8192000000 10794681184 11222941696 1883860848 18.696 100 30 59 1 1899001856 6827392 8313616
20:11:05 6146 8192000000 10797650208 11227226112 1888099200 18.730 100 20 40 1 1899734784 5978800 5656784
20:11:18 11421 8192000000 10787813984 11229413376 1885918816 18.713 100 13 26 0 1895210272 5528320 3763136
20:11:36 8653 8192000000 10808543856 11236478976 1892550656 18.766 100 18 36 0 1903544688 5919808 5074224
20:11:52 9275 8192000000 10801399536 11237576704 1896848832 18.801 100 30 61 0 1915676576 10120336 8707408
20:12:07 8513 8192000000 10808822768 11245801472 1894951264 18.786 100 15 30 2 1904959936 5697584 4311088
20:12:25 14963 8192000000 10803311808 11239993344 1895280512 18.788 100 9 18 0 1903100656 5401248 2418896
20:12:48 10250 8192000000 10817204304 11240800256 1899309408 18.821 100 16 32 1 1909391600 5665072 4417120
20:13:05 50714 8192000000 10847663568 11261906944 1907830176 18.889 100 53 106 1 1929801440 6466448 15504816
20:14:02 5414 8192000000 10828059552 11261947904 1908701792 18.896 100 40 80 3 1929667872 10100432 10865648
20:14:15 5985 8192000000 10818385200 11253649408 1905742416 18.872 100 16 32 1 1915345584 5266224 4336944
20:14:30 6125 8192000000 10819753840 11251126272 1890907440 18.753 99 30 60 3 1906468592 6906832 8654320
20:14:45 7156 8192000000 10820775024 11255492608 1903340800 18.853 100 25 50 2 1916910640 6297616 7272224
20:15:00 5875 8192000000 10821839840 11254145024 1903760640 18.857 100 27 54 1 1918417408 7042640 7614128
20:15:16 7486 8192000000 10825935232 11257851904 1912915968 18.930 100 28 56 0 1928756544 5734672 10105904
20:15:32 7308 8192000000 10823464752 11257638912 1911301088 18.917 100 21 41 0 1922735040 5831760 5602192
20:15:47 6970 8192000000 10792463408 11218894848 1833839392 18.291 96 23 46 2 1847382864 6613232 6930240
20:16:03 5032 8192000000 10811256208 11240230912 1882620384 18.686 99 27 54 1 1896051200 5370848 8059968
20:16:17 14372 8192000000 10805157136 11230490624 1870098960 18.585 98 16 33 1 1880131152 5303952 4728240
20:16:38 7283 8192000000 10795878896 11220951040 1815927568 18.144 96 22 44 0 1831973472 9293440 6752464
20:16:52 8991 8192000000 10795559120 11231547392 1872714800 18.606 99 23 46 1 1885093008 5494784 6883424
20:17:07 14561 8192000000 10781356928 11196489728 1806875936 18.070 96 29 58 3 1820979840 5037424 9066480
20:17:27 65094 8192000000 10697849136 11118927872 1587277120 16.231 86 21 40 1 1598353456 4998464 6077872
20:18:39 11526 8192000000 10719500464 11134590976 1736799328 17.492 95 33 66 1 1752162512 6419360 8943824
20:18:58 9389 8192000000 10716575264 11124563968 1724520912 17.390 96 30 60 1 1739337216 6426416 8389888
20:19:15 4631 8192000000 10699077504 11105964032 1740087376 17.519 97 31 58 1 1754339408 6010912 8241120
20:19:27 4725 8192000000 10676336304 11084308480 1702443872 17.206 95 22 44 0 1714272256 5321632 6506752
20:19:39 4335 8192000000 10706858544 11120697344 1790542656 17.936 100 35 71 1 1806379072 5264400 10572016
20:19:51 5292 8192000000 10719534752 11136675840 1805842160 18.062 100 27 52 1 1819182448 5942000 7398288
20:20:03 8299 8192000000 10713882768 11126059008 1792395648 17.951 99 21 41 1 1803698112 5443296 5859168
20:20:19 9179 8192000000 10709068416 11121561600 1707868144 17.251 94 26 51 1 1720332704 5065152 7399408
20:20:35 8930 8192000000 10700086432 11124883456 1763744768 17.715 98 25 50 1 1777033392 5746544 7542080
20:20:54 9647 8192000000 10705734688 11123728384 1788453696 17.919 99 22 44 0 1800023248 4996416 6573136
20:21:11 7492 8192000000 10716035840 11134803968 1789688032 17.929 99 24 48 1 1802400192 5167760 7544400
20:21:25 14677 8192000000 10734704112 11161903104 1821572000 18.191 100 14 28 1 1831196560 5694688 3929872
20:21:50 10458 8192000000 10759032688 11176669184 1836546816 18.313 100 25 50 0 1850062224 5853280 7662128
20:22:06 51696 8192000000 10769281856 11177271296 1838390960 18.328 100 23 47 0 1851746160 5177952 8177248
20:23:12 10325 8192000000 10755006352 11180392448 1842243472 18.359 100 30 60 1 1857447056 6533168 8670416
20:23:37 6319 8192000000 10756678528 11179753472 1842366336 18.360 100 32 64 2 1858439648 7036368 9036944
20:23:54 6202 8192000000 10775677200 11186397184 1845396800 18.385 100 43 86 1 1864587872 7106112 12084960
20:24:11 8697 8192000000 10756537456 11185405952 1845697136 18.387 100 27 54 1 1858214432 5474256 7043040
20:24:28 6770 8192000000 10765262432 11196563456 1853808048 18.453 100 42 84 2 1877199648 11366016 12025584
20:24:41 10392 8192000000 10773468448 11196219392 1853514560 18.451 100 22 44 2 1865687200 6013616 6159024
20:25:00 13331 8192000000 10767529248 11196850176 1853693280 18.452 100 15 30 1 1863366640 5393552 4279808
20:25:20 11526 8192000000 10777655376 11203977216 1858467808 18.491 100 17 34 0 1868747312 5282896 4996608
20:25:40 7257 8192000000 10769605920 11203321856 1863369248 18.531 100 25 50 0 1876429760 5808688 7251824
20:25:53 10186 8192000000 10775201648 11204403200 1861706704 18.517 100 14 28 1 1871430944 5358672 4365568
20:26:10 10210 8192000000 10788753184 11211468800 1863926128 18.535 100 20 40 2 1875417392 5516640 5974624
20:26:28 10760 8192000000 10786384464 11213316096 1868634624 18.573 100 21 40 0 1881181056 5454400 7092032
20:26:45 7691 8192000000 10780380768 11214077952 1869482320 18.580 100 12 24 1 1882988384 10010688 3495376
20:26:59 13854 8192000000 10814363776 11229655040 1883146768 18.691 100 33 65 1 1898813536 5231616 10435152
20:27:30 25924 8192000000 10827457664 11252490240 1904725744 18.864 100 46 95 3 1925967360 8552176 12689440
20:28:03 104542 8192000000 10829940272 11264663552 1872082784 18.601 98 28 56 0 1892912112 13320864 7508464
20:29:54 34905 8192000000 10849330496 11284381696 1923689856 19.016 100 39 78 1 1946601376 11111120 11800400
20:30:47 14564 8192000000 10862455024 11292471296 1934604192 19.104 100 25 50 1 1955418208 13069168 7744848
20:31:13 32414 8192000000 10879037968 11307966464 1926526384 19.039 99 42 84 2 1953713040 15074384 12112272
20:31:56 12978 8192000000 10891137536 11315757056 1932628608 19.088 99 45 88 4 1962275456 16484032 13162816
20:32:16 2883 8192000000 10896820384 11318657024 1956541328 19.279 100 78 154 5 1994622720 15160416 22920976
20:32:29 4345 8192000000 10908802032 11323351040 1942272352 19.165 99 66 132 0 1979423936 18219104 18932480
20:32:41 9774 8192000000 10897822128 11323686912 1953239840 19.252 100 66 132 0 1993080448 20085856 19754752
20:33:02 14089 8192000000 10897972336 11328466944 1955482800 19.270 100 50 100 0 1990764864 19959632 15322432
20:33:23 3881 8192000000 10916736768 11341156352 1965895648 19.353 100 56 111 0 2002456688 20126368 16434672
20:33:34 11567 8192000000 10913239680 11326066688 1914335776 18.941 97 65 126 1 1955166880 21744848 19086256
20:33:53 18562 8192000000 10907001008 11341594624 1960036160 19.306 100 46 92 1 1996211168 22709936 13465072
20:34:20 6027 8192000000 10893052880 11323068416 1945773040 19.193 99 46 90 0 1976623280 17852736 12997504
20:34:33 1704 8192000000 10911062656 11332939776 1964575296 19.342 100 59 116 1 2000552032 20628160 15348576
20:34:43 3289 8192000000 10933172288 11348873216 1973251328 19.411 100 69 135 1 2012907936 20673520 18983088
20:34:53 5376 8192000000 10926737888 11353710592 1977695312 19.446 100 71 142 0 2021478864 22987888 20795664
20:35:07 14116 8192000000 10914698960 11344564224 1941631344 19.160 98 64 128 3 1981496992 22013184 17852464
20:35:29 3319 8192000000 10918745280 11336241152 1958547552 19.294 99 62 125 1 2001758208 25122240 18088416
20:35:40 6918 8192000000 10923614832 11353219072 1972891856 19.408 100 52 102 2 2013306896 25462336 14952704
20:35:55 12705 8192000000 10931314880 11354533888 1970281824 19.388 100 62 124 1 2020089520 30887568 18920128
20:36:15 7412 8192000000 10935647760 11362299904 1976306368 19.435 100 66 130 3 2024990816 28643392 20041056
20:36:36 2397 8192000000 10906797520 11324952576 1933752064 19.097 98 71 143 2 1984230432 29193520 21284848
20:36:46 3724 8192000000 10932156576 11353264128 1973362720 19.412 100 74 148 2 2025639664 30293088 21983856
20:37:03 4067 8192000000 10953745904 11372691456 1975250464 19.427 100 80 156 2 2034205792 36022336 22932992
20:37:15 6290 8192000000 10924499728 11349032960 1964544656 19.342 100 63 125 1 2015593744 32608240 18440848
20:37:28 1880 8192000000 10940298992 11350634496 1966366992 19.357 100 83 164 1 2022352896 31637456 24348448
20:37:38 2520 8192000000 10920649232 11336331264 1947551328 19.207 99 72 141 1 2002175408 33421152 21202928
20:37:47 2058 8192000000 10914994960 11330371584 1942925024 19.170 99 78 156 2 2000011152 32629728 24456400
20:37:57 7349 8192000000 10918730320 11339833344 1956870656 19.281 100 71 138 0 2008286128 30997360 20418112
20:38:12 4716 8192000000 10942076688 11358662656 1968309824 19.372 100 71 142 1 2026321408 36913120 21098464
20:38:24 5621 8192000000 10938136000 11359510528 1973352752 19.412 100 65 130 0 2024288160 31311216 19624192
20:38:38 4497 8192000000 10933267696 11362926592 1974245920 19.419 100 64 127 2 2025523456 31748544 19528992
20:38:51 4253 8192000000 10942757024 11366776832 1955367056 19.269 99 74 145 3 2010549168 32037664 23144448
20:39:04 1441 8192000000 10949898864 11370516480 1975544768 19.429 100 88 174 2 2038241264 35537920 27158576
20:39:14 2575 8192000000 10934352576 11358916608 1955538416 19.271 99 80 156 6 2014407968 35525376 23344176
20:39:27 2237 8192000000 10906239632 11321184256 1920498096 18.991 98 73 143 2 1974218208 32063200 21656912
20:39:36 2542 8192000000 10881472496 11293876224 1883867040 18.696 97 83 164 2 1942633376 33309968 25456368
20:39:45 4077 8192000000 10900550272 11313577984 1926855984 19.042 100 66 130 0 1980897504 33972784 20068736
20:39:56 8678 8192000000 10883092320 11322318848 1933857552 19.098 100 62 122 4 1988298192 36113104 18327536
20:40:14 8398 8192000000 10839854832 11286245376 1851233440 18.432 96 38 74 1 1894916480 31352400 12330640
20:40:41 13547 8192000000 10842628000 11281502208 1869094880 18.577 98 28 56 3 1905280384 27222432 8963072
20:41:01 22959 8192000000 10834998288 11272200192 1849452992 18.418 97 31 62 1 1890157072 30118096 10585984
20:41:30 18475 8192000000 10836043120 11268067328 1876554816 18.637 99 24 47 0 1913932656 29080752 8297088
20:41:56 14096 8192000000 10852409216 11288440832 1896409936 18.797 100 23 46 0 1932628000 28817552 7400512
20:42:21 10540 8192000000 10861926800 11287326720 1849712640 18.420 97 29 56 1 1893892144 35157584 9021920
20:42:37 2162 8192000000 10889700944 11304800256 1914199056 18.940 100 77 152 4 1973559488 35882288 23478144
20:42:46 6541 8192000000 10897066000 11311595520 1916980448 18.963 100 64 128 2 1974175888 37224384 19971056
20:42:59 5221 8192000000 10892987056 11313119232 1922478464 19.007 100 59 115 1 1977573888 37370416 17725008
20:43:11 9454 8192000000 10867777584 11304673280 1882014640 18.681 98 28 56 4 1926818624 35109440 9694544
20:43:35 12789 8192000000 10867815392 11297366016 1905736448 18.872 100 32 64 3 1946200976 30172688 10291840
20:43:59 15707 8192000000 10852603696 11296260096 1895209360 18.788 99 36 72 2 1939204832 32476368 11519104
20:44:32 22320 8192000000 10840180208 11299999744 1876349328 18.636 98 20 40 1 1905876304 22905872 6621104
20:45:02 18099 8192000000 10837871376 11278221312 1869225120 18.578 98 17 34 1 1895911328 21232528 5453680
20:45:26 15655 8192000000 10844372192 11286753280 1877785856 18.647 98 23 46 2 1904975488 20099280 7090352
20:45:50 14558 8192000000 10840442032 11278106624 1892427280 18.765 99 24 50 2 1925487248 25477920 7582048
20:46:12 13845 8192000000 10864266480 11304812544 1913669056 18.936 100 21 42 2 1951650768 30953984 7027728
20:46:42 18024 8192000000 10861430496 11298168832 1894538384 18.782 99 18 36 1 1926391552 25425648 6427520
20:47:07 11697 8192000000 10873822624 11313283072 1921418720 18.998 100 27 54 1 1957128464 26891408 8818336
20:47:26 34583 8192000000 10879486176 11324796928 1930831936 19.074 100 22 44 0 1960948656 22738368 7378352
20:48:20 31994 8192000000 10871385792 11312644096 1906720384 18.880 99 17 34 0 1935263600 22842128 5701088
20:49:15 64333 8192000000 10866102944 11325857792 1890368272 18.749 98 10 20 2 1924309264 30236816 3704176
20:50:28 38046 8192000000 10873139504 11334053888 1934413008 19.102 100 23 46 1 1954760912 13736112 6611792
20:51:29 64885 8192000000 10881304480 11328507904 1925673840 19.032 99 29 58 1 1946377088 12785440 7917808
20:52:47 93899 8192000000 10891670448 11351396352 1951951168 19.242 100 12 24 0 1972204080 17125328 3127584
20:54:46 66186 8192000000 10877556048 11350786048 1934299280 19.101 99 22 44 1 1961893280 21384048 6209952
20:56:05 49961 8192000000 10899553648 11350847488 1946013856 19.195 100 10 20 0 1969349504 20133744 3201904
20:57:03 49123 8192000000 10887685824 11349741568 1945885216 19.194 99 12 24 1 1964987392 15866448 3235728
20:57:58 31609 8192000000 10867247632 11337637888 1923502368 19.015 98 18 34 1 1946258560 17591920 5164272
20:59:18 60997 8192000000 10867349232 11320991744 1933122304 19.092 99 9 18 0 1946203008 10753936 2326768
21:00:28 78250 8192000000 10889986464 11337953280 1959901152 19.305 100 26 50 1 1977366800 10232576 7233072
21:02:24 36861 8192000000 10902093024 11348008960 1967834624 19.368 100 36 73 1 1984722800 6748256 10139920
21:03:10 45718 8192000000 10882266304 11353104384 1973552272 19.414 100 24 48 1 1987762032 7437632 6772128
21:04:33 69093 8192000000 10877356880 11353554944 1952518576 19.247 99 8 16 0 1961441952 6952512 1970864
21:05:55 58630 8192000000 10891073104 11366801408 1969948832 19.385 100 6 12 0 1984690064 12961440 1779792
21:07:06 70597 8192000000 10902774560 11367452672 1963792832 19.336 99 16 32 2 1977134112 9048208 4293072
21:08:27 19522 8192000000 10908669520 11373527040 1971957168 19.401 99 39 77 3 1991803712 7934624 11911920
21:08:58 58352 8192000000 10900166768 11370434560 1970901440 19.393 99 22 44 0 1987681632 10496192 6284000
21:10:21 50221 8192000000 10909280768 11383918592 1975126048 19.426 99 21 42 1 1996468656 14978336 6364272
21:11:23 66569 8192000000 10918680912 11383332864 1972382880 19.404 99 20 40 0 1988470560 9792320 6295360
21:12:39 64942 8192000000 10914245984 11390025728 1971207216 19.395 99 16 32 1 1986867872 10432384 5228272
21:13:51 44012 8192000000 10911041648 11385339904 1951527280 19.239 98 22 45 0 1971405296 13326496 6551520
21:14:53 47085 8192000000 10928760288 11401805824 1999294352 19.617 100 22 44 2 2020155024 14359360 6501312
21:15:47 84574 8192000000 10914992064 11379965952 1964085952 19.339 98 30 60 0 1983641680 11491072 8064656
21:17:18 48788 8192000000 10878843056 11349749760 1837304832 18.319 92 25 50 1 1855516688 11428992 6782864
21:18:18 86014 8192000000 10905434880 11365437440 1910147120 18.908 97 17 34 0 1934971808 19157344 5667344
21:19:52 106984 8192000000 10941443968 11384348672 1977893424 19.448 100 49 98 2 2005068672 12084656 15090592
21:21:52 91842 8192000000 10906387472 11390164992 1959297952 19.300 99 24 48 0 1995575248 28240432 8036864
21:23:30 57200 8192000000 10897985216 11376824320 1979472400 19.461 100 14 28 0 1993454784 10114128 3868256
21:24:58 52857 8192000000 10917350304 11384479744 1985842528 19.511 100 7 14 0 2001743520 13798384 2102608
21:25:59 84079 8192000000 10886420704 11358650368 1873577200 18.613 94 14 28 1 1888122816 10445776 4099840
21:27:45 71703 8192000000 10876316656 11341123584 1877049760 18.641 95 11 22 0 1887513520 7806880 2656880
21:29:04 50180 8192000000 10817771680 11295449088 1838927856 18.332 94 14 28 1 1851868784 8751616 4189312
21:30:05 68936 8192000000 10861457968 11324350464 1858945232 18.495 95 15 30 2 1871062896 7468832 4648832
21:31:21 48636 8192000000 10865325344 11314683904 1817115120 18.154 93 27 53 1 1833188736 8638160 7435456
21:32:17 41534 8192000000 10855751856 11336925184 1918053472 18.971 99 36 72 1 1942660960 14526368 10081120
21:33:19 43083 8192000000 10871135904 11322998784 1878387632 18.652 97 21 42 1 1896368688 12688352 5292704
21:34:10 135562 8192000000 10844807840 11308584960 1718814864 17.342 89 30 60 0 1745745600 17453152 9477584
21:36:32 78696 8192000000 10854390608 11305828352 1855305680 18.465 96 30 60 0 1873204704 9612992 8286032
21:38:03 49087 8192000000 10869040816 11313717248 1867540352 18.564 97 25 50 2 1886852592 12490832 6821408
21:39:03 39908 8192000000 10889959920 11344457728 1921562672 18.999 99 44 88 1 1959059600 24240496 13256432
21:39:49 19960 8192000000 10879568176 11345981440 1938965680 19.139 100 27 54 0 1967220624 20797248 7457696
21:40:35 74272 8192000000 10868382304 11357147136 1931102688 19.076 100 6 12 1 1955470832 22826928 1541216
21:41:55 117794 8192000000 10879886736 11325747200 1851815232 18.437 95 27 54 0 1869548928 9496192 8237504
21:44:20 73627 8192000000 10865531696 11327987712 1934118320 19.100 100 20 40 1 1951998768 11390400 6490048
21:45:54 50438 8192000000 10866789296 11345580032 1936948064 19.122 100 3 6 0 1945479744 7569936 961744
21:47:27 82717 8192000000 10896146608 11368624128 1965118608 19.347 100 17 34 1 1985095968 15121680 4855680
21:49:30 80662 8192000000 10887941440 11362185216 1935282624 19.109 98 20 40 0 1969639360 28108608 6248128
21:51:03 93417 8192000000 10886731328 11358560256 1905632960 18.872 97 13 26 0 1921747456 12391888 3722608
21:52:43 81925 8192000000 10893420992 11369664512 1967211904 19.363 100 18 36 2 1987599536 14850688 5536944
21:54:34 66735 8192000000 10891283552 11362852864 1943357584 19.174 99 17 33 2 1965621088 16662368 5601136
21:56:03 53099 8192000000 10900195520 11361968128 1962011072 19.322 100 34 68 1 1984975536 13774432 9190032
21:57:08 70847 8192000000 10902420640 11369705472 1953275456 19.253 99 19 38 1 1975940400 17171424 5493520
21:59:28 61358 8192000000 10897995520 11362627584 1949729616 19.224 99 20 40 1 1966705872 11604304 5371952
22:00:43 75376 8192000000 10907057392 11357638656 1893785744 18.776 96 19 38 2 1909221008 9711664 5723600
22:02:17 27227 8192000000 10908085472 11357888512 1951811632 19.241 99 35 70 0 1970503808 9267152 9425024
22:02:54 32886 8192000000 10911246384 11356442624 1932142976 19.084 98 47 94 2 1956587072 11320608 13123488
22:03:36 99015 8192000000 10872163568 11345797120 1919774912 18.985 98 27 54 3 1939975232 12830592 7369728
22:05:41 90941 8192000000 10859242128 11316187136 1893830320 18.777 97 23 46 1 1908308928 7550400 6928208
22:07:19 45893 8192000000 10865452752 11344035840 1948243328 19.212 100 18 36 0 1961275200 7796608 5235264
22:09:28 64233 8192000000 10874230032 11343798272 1937959024 19.130 99 14 29 0 1949286144 7327440 3999680
22:10:38 80984 8192000000 10873801456 11355086848 1939671808 19.144 99 5 10 0 1950949744 9757552 1520384
22:12:27 58651 8192000000 10873439136 11337732096 1903596112 18.855 97 13 27 0 1915773856 8518784 3658960
22:13:36 69377 8192000000 10854344592 11329331200 1855796192 18.469 95 20 40 0 1872638496 10837840 6004464
22:14:52 77409 8192000000 10852578624 11329544192 1883572544 18.694 97 27 55 2 1906256400 14538464 8145392
22:16:31 63069 8192000000 10870267392 11338551296 1896594144 18.799 97 29 58 0 1914966688 9343072 9029472
22:17:44 49797 8192000000 10830276848 11297517568 1802494064 18.034 93 13 26 0 1814680720 8688800 3497856
22:18:51 38327 8192000000 10831475408 11295100928 1845272208 18.384 96 20 40 0 1858530176 7518000 5739968
22:19:40 65460 8192000000 10855359376 11312738304 1867558320 18.565 97 33 66 1 1885745872 9134608 9052944
22:20:51 62265 8192000000 10854347760 11310133248 1833943712 18.291 95 41 78 0 1853785792 8442944 11399136
22:22:05 48978 8192000000 10850910592 11303964672 1870110000 18.585 97 27 54 0 1888073536 10505152 7458384
22:23:02 30015 8192000000 10867694144 11322888192 1926305456 19.037 100 35 71 2 1946910176 11059360 9545360
22:23:43 52484 8192000000 10874539264 11331444736 1920531520 18.991 99 23 47 1 1938350128 11974000 5844608
22:24:45 74765 8192000000 10853861104 11332734976 1876052976 18.633 97 26 52 1 1899731472 16493184 7185312
22:26:28 59989 8192000000 9269343744 9534418944 432434112 5.014 23 6 12 0 435482592 1391424 1657056

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 142 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

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

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          252091
MON$OLDEST_ACTIVE               252092
MON$OLDEST_SNAPSHOT             252092
MON$NEXT_TRANSACTION            252092
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                       2022080
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

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

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

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