Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 22.12.2020 19:29
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 17464720 kB
MemAvailable 31515388 kB
Buffers 0 kB
Cached 14259388 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-22 19:27:07
DTS_END                         2020-12-22 19:27:07.4500
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34436
TRN_ID                          245697
ATT_ID                          648
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: 9680.90 19796 1161708
customer order: creation 176.22 338 21146
customer order: refuse 15.04 259 1805
order to supplier: creation 47.90 1115 5748
order to supplier: removal 3.68 78247 441
invoice (draft): creation 47.49 3306 5699
invoice (draft): removal 56.86 655 6823
invoice accept: apply 42.88 17137 5146
invoice accept: cancel 51.09 640 6131
customer reserve: creation 3957.55 170 474906
customer reserve: removal 4969.19 45 596303
realization accept: apply 85.89 165 10307
realization accept: cancel 95.16 92 11419
payment from customer: creation 61.56 116 7387
payment from customer: removal 6.10 61 732
payment to supplier: creation 48.63 109 5835
payment to supplier: removal 3.66 94 439
service: total inventory turnovers 4.78 953 574
service: total monetary turnovers 6.36 19 763
service: aggregate perf. data 0.83 19755 100
service: refresh index statistics 0.03 272638 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-12-2020 19:29:46 to 22-12-2020 19:29:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9717
TEST_TIME 2 8153
TEST_TIME 3 8151
TEST_TIME 4 7652
TEST_TIME 5 7312
TEST_TIME 6 6981
TEST_TIME 7 6919
TEST_TIME 8 6824
TEST_TIME 9 7955
TEST_TIME 10 8091
TEST_TIME 11 8716
TEST_TIME 12 9302
TEST_TIME 13 9766
TEST_TIME 14 9900
TEST_TIME 15 10337
TEST_TIME 16 10297
TEST_TIME 17 10169
TEST_TIME 18 10448
TEST_TIME 19 10738
TEST_TIME 20 11681
TEST_TIME 21 12288
TEST_TIME 22 12845
TEST_TIME 23 12561
TEST_TIME 24 12391
TEST_TIME 25 12143
TEST_TIME 26 11881
TEST_TIME 27 11723
TEST_TIME 28 11854
TEST_TIME 29 11625
TEST_TIME 30 11429
TEST_TIME 31 11558
TEST_TIME 32 11369
TEST_TIME 33 11192
TEST_TIME 34 11155
TEST_TIME 35 10984
TEST_TIME 36 10825
TEST_TIME 37 10815
TEST_TIME 38 10806
TEST_TIME 39 10647
TEST_TIME 40 10524
TEST_TIME 41 10361
TEST_TIME 42 10271
TEST_TIME 43 10331
TEST_TIME 44 10181
TEST_TIME 45 10209
TEST_TIME 46 10344
TEST_TIME 47 10270
TEST_TIME 48 10249
TEST_TIME 49 10281
TEST_TIME 50 10164
TEST_TIME 51 10177
TEST_TIME 52 10316
TEST_TIME 53 10505
TEST_TIME 54 10544
TEST_TIME 55 10566
TEST_TIME 56 10493
TEST_TIME 57 10494
TEST_TIME 58 10670
TEST_TIME 59 10532
TEST_TIME 60 10423
TEST_TIME 61 10322
TEST_TIME 62 10242
TEST_TIME 63 10233
TEST_TIME 64 10186
TEST_TIME 65 10161
TEST_TIME 66 10201
TEST_TIME 67 10126
TEST_TIME 68 10131
TEST_TIME 69 10109
TEST_TIME 70 10262
TEST_TIME 71 10222
TEST_TIME 72 10178
TEST_TIME 73 10217
TEST_TIME 74 10246
TEST_TIME 75 10250
TEST_TIME 76 10197
TEST_TIME 77 10199
TEST_TIME 78 10134
TEST_TIME 79 10069
TEST_TIME 80 10024
TEST_TIME 81 10002
TEST_TIME 82 9953
TEST_TIME 83 9887
TEST_TIME 84 9820
TEST_TIME 85 9822
TEST_TIME 86 9874
TEST_TIME 87 9891
TEST_TIME 88 9835
TEST_TIME 89 9791
TEST_TIME 90 9800
TEST_TIME 91 9872
TEST_TIME 92 9912
TEST_TIME 93 9916
TEST_TIME 94 9913
TEST_TIME 95 9902
TEST_TIME 96 9929
TEST_TIME 97 9910
TEST_TIME 98 9939
TEST_TIME 99 9999
TEST_TIME 100 9902
TEST_TIME 101 9832
TEST_TIME 102 9801
TEST_TIME 103 9769
TEST_TIME 104 9758
TEST_TIME 105 9750
TEST_TIME 106 9736
TEST_TIME 107 9737
TEST_TIME 108 9707
TEST_TIME 109 9742
TEST_TIME 110 9716
TEST_TIME 111 9792
TEST_TIME 112 9758
TEST_TIME 113 9740
TEST_TIME 114 9828
TEST_TIME 115 9867
TEST_TIME 116 9857
TEST_TIME 117 9844
TEST_TIME 118 9819
TEST_TIME 119 9768
TEST_TIME 120 9687

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-12-2020 19:29:49 to 22-12-2020 19:29:53.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1600851 1600851 0 0.00 0 18287 6 0 0
doc_list_biud 1600851 1600851 0 0.00 0 26453 22 0 0
sp_add_invoice_to_stock 5232 5146 86 1.64 46 160843 17137 0 86
sp_cancel_adding_invoice 6131 6131 0 0.00 4 51442 640 0 0
sp_cancel_client_order 1805 1805 0 0.00 4 9178 259 0 0
sp_cancel_customer_reserve 596303 596303 0 0.00 1 20038 45 0 0
sp_cancel_pay_from_customer 732 732 0 0.00 2 3663 62 0 0
sp_cancel_pay_to_supplier 439 439 0 0.00 3 4982 95 0 0
sp_cancel_supplier_invoice 6836 6823 13 0.19 1 26460 655 0 13
sp_cancel_supplier_order 441 441 0 0.00 6 804143 78247 0 0
sp_cancel_write_off 11419 11419 0 0.00 1 10324 93 0 0
sp_client_order 21146 21146 0 0.00 3 27057 339 0 0
sp_customer_reserve 474906 474906 0 0.00 0 86020 171 0 0
sp_fill_shopping_cart 32570 32570 0 0.00 1 21187 39 0 0
sp_fill_shopping_cart_clo_res 474899 474899 0 0.00 0 13673 13 0 0
sp_get_clo_for_invoice 5128 5128 0 0.00 0 38135 346 0 0
sp_kill_cost_storno 18721 18721 0 0.00 0 9959 43 0 0
sp_kill_qstorno_ret_qs2qd 1211289 1211289 0 0.00 0 26446 25 0 0
sp_kill_qty_storno 638355 638355 0 0.00 0 26451 54 0 0
sp_lock_selected_doc 21485 21485 0 0.00 0 9148 7 0 0
sp_make_cost_storno 28655 28655 0 0.00 0 18286 47 0 0
sp_multiply_rows_for_pdistr 28655 28655 0 0.00 0 9177 24 0 0
sp_multiply_rows_for_qdistr 21146 21146 0 0.00 0 21294 154 0 0
sp_pay_from_customer 7387 7387 0 0.00 4 20648 117 0 0
sp_pay_to_supplier 5835 5835 0 0.00 5 18290 110 0 0
sp_payment_common 13222 13222 0 0.00 1 20621 28 0 0
sp_qd_handle_on_cancel_clo 1805 1805 0 0.00 0 9168 236 0 0
sp_qd_handle_on_invoice_upd_sts 11257 11257 0 0.00 0 14030 253 0 0
sp_qd_handle_on_reserve_upd_sts 10307 10307 0 0.00 0 16096 61 0 0
sp_reserve_write_off 10307 10307 0 0.00 6 20072 166 0 0
sp_supplier_invoice 5699 5699 0 0.00 6 99433 3307 0 0
sp_supplier_order 5748 5748 0 0.00 5 35591 1115 0 0
srv_aggregate_perf_data 100 100 0 0.00 2541 414312 19756 0 0
srv_fill_mon_cache_memory 146 146 0 0.00 1369 119600 37823 0 0
srv_find_qd_qs_mism 1112420 1112420 0 0.00 0 14058 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 45 89068 954 0 0
srv_make_money_saldo 763 763 0 0.00 1 424 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 178910 432293 272639 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5146 5146 0 0.00 0 18622 139 0 0
t$perf-norm:sp_cancel_adding_invoice 432 432 0 0.00 0 6594 102 0 0
t$perf-norm:sp_cancel_client_order 1805 1805 0 0.00 0 3600 11 0 0
t$perf-norm:sp_cancel_customer_reserve 768 768 0 0.00 0 827 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 732 732 0 0.00 0 2869 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 439 439 0 0.00 0 4619 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 7262 25 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 14667 1139 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 6044 14 0 0
t$perf-norm:sp_client_order 21146 21146 0 0.00 0 12372 16 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 5817 14 0 0
t$perf-norm:sp_pay_from_customer 7387 7387 0 0.00 0 8030 10 0 0
t$perf-norm:sp_pay_to_supplier 5835 5835 0 0.00 0 4457 12 0 0
t$perf-norm:sp_reserve_write_off 10307 10307 0 0.00 0 7261 9 0 0
t$perf-norm:sp_supplier_invoice 5699 5699 0 0.00 0 8116 20 0 0
t$perf-norm:sp_supplier_order 5748 5748 0 0.00 0 5499 12 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 3 0 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 4194 33 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 2537 18 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 403 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 16 6 0 0
v_add_invoice_to_stock 10424 10252 172 1.65 0 4195 17 0 172
v_all_customers 38896 38896 0 0.00 0 49 0 0 0
v_all_suppliers 31376 31376 0 0.00 0 21 1 0 0
v_all_wares 42292 42292 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 864 864 0 0.00 0 1682 7 0 0
v_cancel_client_order 3610 3610 0 0.00 0 3435 5 0 0
v_cancel_customer_prepayment 1464 1464 0 0.00 0 3266 8 0 0
v_cancel_customer_reserve 1536 1536 0 0.00 0 4385 8 0 0
v_cancel_payment_to_supplier 878 878 0 0.00 0 2418 9 0 0
v_cancel_supplier_invoice 884 858 26 2.94 0 4447 24 0 26
v_cancel_supplier_order 882 882 0 0.00 0 1748 6 0 0
v_cancel_write_off 2012 2012 0 0.00 0 1951 12 0 0
v_max_id_clo_ord 5748 5748 0 0.00 0 2095 1 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 2379 11 0 0
v_max_id_ord_sup 5676 5676 0 0.00 0 9241 5 0 0
v_max_non_paid_invoice 1571 1571 0 0.00 0 1912 4 0 0
v_max_non_paid_realizn 3745 3745 0 0.00 0 5381 7 0 0
v_min_id_clo_ord 5748 5748 0 0.00 0 8807 7 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 1570 5 0 0
v_min_id_ord_sup 5676 5676 0 0.00 0 7966 5 0 0
v_min_non_paid_invoice 5835 5835 0 0.00 0 8507 16 0 0
v_min_non_paid_realizn 7387 7387 0 0.00 0 20613 22 0 0
v_our_firm 10680 10680 0 0.00 0 18 1 0 0
v_reserve_write_off 20614 20614 0 0.00 0 5179 5 0 0
x_lock_depdocs_on_canc_invoice 12525 12525 0 0.00 0 21775 93 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 11598 278 0 0
x_make_qstorno_1000_1200 5748 5748 0 0.00 2 35572 1045 0 0
x_make_qstorno_1200_2000 5699 5699 0 0.00 2 94176 3157 0 0
x_make_qstorno_2100_3300 474906 474906 0 0.00 0 86019 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-12-2020 19:29:54 to 22-12-2020 19:29:58.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:09 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 10841 8192000000 10191125136 10493411328 809873872 8.996 65 56 116 0 831273808 2293696 19106240
16:57:34 16657 8192000000 10296108608 10613313536 1355423280 14.196 100 81 162 2 1386337872 4402752 26511840
16:57:59 31414 8192000000 10352905904 10670338048 1399798384 14.593 100 86 172 2 1434378688 5729360 28850944
16:58:39 26503 8192000000 10383194192 10707111936 1434614800 14.902 100 86 172 1 1469279360 6657600 28006960
16:59:17 16531 8192000000 10404920960 10733506560 1463721040 15.159 100 85 170 0 1498530784 7640400 27169344
16:59:44 24176 8192000000 10424982352 10757328896 1479656256 15.298 100 87 174 0 1515731056 8094560 27980240
17:00:20 13474 8192000000 10434527936 10771329024 1496877152 15.449 100 82 164 2 1531512784 8244784 26390848
17:00:47 24306 8192000000 10473814992 10810822656 1516313552 15.618 100 85 170 1 1551781728 8933008 26535168
17:01:20 15806 8192000000 10508100704 10850066432 1547714144 15.890 100 84 167 3 1583260208 9564880 25981184
17:01:45 14391 8192000000 10529579008 10878005248 1581932336 16.185 100 80 160 1 1616527344 10134432 24460576
17:02:10 15119 8192000000 10567858192 10925568000 1626542064 16.566 100 86 172 1 1662538464 10459472 25536928
17:02:32 8545 8192000000 10585126528 10942824448 1637858864 16.662 100 81 162 0 1677206128 15394032 23953232
17:02:52 10830 8192000000 10615167664 10974785536 1668529664 16.921 100 86 173 0 1706104400 12393632 25181104
17:03:09 7730 8192000000 10625708800 10987577344 1673503216 16.963 100 84 168 0 1711653504 13786352 24363936
17:03:26 8447 8192000000 10634468048 10999939072 1689920784 17.101 100 90 181 0 1730427232 14212160 26294288
17:03:41 6473 8192000000 10649682768 11015397376 1703182416 17.212 100 87 174 2 1743746304 15387600 25176288
17:03:54 5437 8192000000 10664910576 11033915392 1715110080 17.311 100 85 169 2 1754206048 15285168 23810800
17:04:06 6138 8192000000 10675472176 11045384192 1728485232 17.423 100 89 178 3 1769027712 15398112 25144368
17:04:20 3767 8192000000 10687957824 11056058368 1738559872 17.507 100 86 172 0 1777963248 14975984 24427392
17:04:30 4015 8192000000 10682055408 11057168384 1741617136 17.532 100 75 150 0 1777018464 14643696 20757632
17:04:41 4446 8192000000 10692331184 11070771200 1754208784 17.636 100 82 164 2 1791090176 13631824 23249568
17:04:52 3889 8192000000 10700906416 11082821632 1768273136 17.753 100 81 161 0 1803136576 12744592 22118848
17:05:03 3129 8192000000 10708999712 11088171008 1775311552 17.811 100 83 166 0 1811925280 13216880 23396848
17:05:13 2688 8192000000 10724064144 11106217984 1789314976 17.926 100 83 167 1 1825675104 13231968 23128160
17:05:22 2486 8192000000 10732501664 11114020864 1792999200 17.956 100 95 189 0 1834173680 14824240 26350240
17:05:32 2534 8192000000 10738981136 11117395968 1798580208 18.002 100 90 178 0 1836743376 13483936 24679232
17:05:41 6072 8192000000 10736885408 11121647616 1797573312 17.994 100 78 155 0 1832595488 13275648 21746528
17:05:54 4193 8192000000 10739685424 11130535936 1808818096 18.086 100 82 160 3 1844382208 13431072 22133040
17:06:05 2394 8192000000 10750627760 11133632512 1823313680 18.205 100 88 173 3 1859094720 11765216 24015824
17:06:13 2137 8192000000 10762337776 11147243520 1820890496 18.185 100 86 172 1 1857549376 12982656 23676224
17:06:22 2377 8192000000 10776395328 11161497600 1833688144 18.289 100 89 177 2 1872869680 14370736 24810800
17:06:31 1994 8192000000 10779986032 11168202752 1839755776 18.339 100 94 187 1 1879684464 13420944 26507744
17:06:40 1803 8192000000 10786196336 11171237888 1844320080 18.376 100 87 175 1 1882031568 13128128 24583360
17:06:48 1742 8192000000 10788299568 11179053056 1855659536 18.468 100 92 185 2 1895351120 13231776 26459808
17:06:56 1507 8192000000 10805155888 11190067200 1859339440 18.498 100 89 175 0 1895443264 11987280 24116544
17:07:04 1955 8192000000 10808538880 11196657664 1861272512 18.514 100 92 184 0 1900109936 12929664 25907760
17:07:13 1743 8192000000 10813419680 11199434752 1863944400 18.535 100 93 186 1 1903730528 14063760 25722368
17:07:21 2184 8192000000 10800113376 11193925632 1862472528 18.523 100 79 158 2 1899874880 15711872 21690480
17:07:30 2054 8192000000 10794304176 11194810368 1862403440 18.523 100 72 145 2 1896062928 12939328 20720160
17:07:38 2980 8192000000 10805145232 11201708032 1870845600 18.591 100 84 168 1 1905790752 12053472 22891680
17:07:48 2741 8192000000 10789297680 11200159744 1865183968 18.545 100 60 120 0 1894168576 11006896 17977712
17:07:57 31753 8192000000 10800688720 11201421312 1866072736 18.552 100 61 122 0 1891127840 6304048 18751056
17:08:35 9486 8192000000 10785001568 11199582208 1863507520 18.532 100 25 50 1 1876499200 5669680 7322000
17:08:51 2729 8192000000 10777719264 11201957888 1868288240 18.570 100 36 72 1 1886601104 8551568 9761296
17:09:02 7820 8192000000 10772754032 11203698688 1870350160 18.587 100 23 45 2 1883331264 5845120 7135984
17:09:18 12246 8192000000 10784553504 11209658368 1873009488 18.609 100 23 46 3 1885807632 6058240 6739904
17:09:38 8105 8192000000 10782375152 11213025280 1873370080 18.612 100 24 46 1 1886047632 6467008 6210544
17:09:52 9144 8192000000 10781956048 11215597568 1878117056 18.650 100 18 37 0 1889316368 5885248 5314064
17:10:11 10042 8192000000 10783165456 11218776064 1881843536 18.680 100 19 38 0 1892576416 5310544 5422336
17:10:27 9373 8192000000 10791874160 11223916544 1885000784 18.705 100 23 44 1 1901551280 10193680 6356816
17:10:43 8036 8192000000 10793554960 11224649728 1883026784 18.690 100 16 32 0 1892829520 5357680 4445056
17:11:01 11070 8192000000 10794035168 11223855104 1889171408 18.739 100 23 46 2 1901362864 5848144 6343312
17:11:21 9306 8192000000 10787818160 11225821184 1888247904 18.732 100 14 27 2 1897966080 5893760 3824416
17:11:37 16590 8192000000 10801086848 11232403456 1889902080 18.745 100 14 27 3 1899298592 5213712 4182800
17:12:00 16006 8192000000 10806861168 11236716544 1896861600 18.801 100 32 64 1 1911458160 5913936 8682624
17:12:24 62658 8192000000 10836853600 11248386048 1901109744 18.835 100 45 90 1 1920259152 5957360 13192048
17:13:33 5736 8192000000 10804049536 11246645248 1898602560 18.815 100 28 56 4 1914900752 8737072 7561120
17:13:45 6628 8192000000 10806381632 11244888064 1896998032 18.802 100 21 42 3 1908974144 5951392 6024720
17:13:58 5785 8192000000 10814900144 11253166080 1899102784 18.819 100 23 45 2 1912639760 7067328 6469648
17:14:11 9602 8192000000 10816079696 11248599040 1903109648 18.851 100 32 65 0 1919267568 6294880 9863040
17:14:27 8481 8192000000 10822386976 11246174208 1899555440 18.823 100 24 47 0 1912031664 5515264 6960960
17:14:42 7723 8192000000 10814923760 11250806784 1901492320 18.838 100 27 54 3 1915263120 5850576 7920224
17:14:57 6275 8192000000 10820416912 11256541184 1905148944 18.868 100 31 61 3 1924405232 10094112 9162176
17:15:10 11762 8192000000 10821049824 11254419456 1906576688 18.879 100 25 49 0 1919640592 5649536 7414368
17:15:32 10160 8192000000 10793041488 11229417472 1858987808 18.495 98 26 52 0 1872381360 5595808 7797744
17:15:48 10393 8192000000 10803093248 11234791424 1874486976 18.621 99 16 32 1 1884696864 5208640 5001248
17:16:05 11821 8192000000 10773012240 11209080832 1820755920 18.184 97 11 22 1 1828783584 5363280 2664384
17:16:23 8000 8192000000 10766648656 11199778816 1858465792 18.491 99 33 66 3 1875247072 7037120 9744160
17:16:40 9826 8192000000 10772286736 11195318272 1817913536 18.161 97 18 37 1 1827911648 4481216 5516896
17:16:56 70550 8192000000 10714611616 11141324800 1679699440 17.015 90 16 31 1 1688614576 4346624 4568512
17:18:14 6776 8192000000 10740813872 11156127744 1788595936 17.920 98 40 81 1 1807762800 8196288 10970576
17:18:30 6969 8192000000 10757063552 11172667392 1797861312 17.996 98 40 81 0 1816430240 7501056 11067872
17:18:45 4595 8192000000 10740037024 11148611584 1808712656 18.085 99 41 82 1 1827490368 7436176 11341536
17:18:56 3507 8192000000 10733226768 11146088448 1774721376 17.806 97 43 86 0 1796230368 9046000 12462992
17:19:07 7553 8192000000 10715464848 11130601472 1783205536 17.876 99 25 50 3 1800430416 10486592 6738288
17:19:21 6819 8192000000 10712303488 11128573952 1775367056 17.811 98 27 54 2 1789208864 5597328 8244480
17:19:37 7798 8192000000 10703493056 11126456320 1794530528 17.969 100 24 48 0 1807604976 6167440 6907008
17:19:52 7531 8192000000 10695831280 11104710656 1724536112 17.390 96 18 36 0 1735163120 4507184 6119824
17:20:07 8161 8192000000 10704134928 11110924288 1739833984 17.517 97 22 44 1 1751492480 4907232 6751264
17:20:25 18076 8192000000 10698556816 11110748160 1704671456 17.224 95 22 44 2 1717155088 5677968 6805664
17:20:49 6475 8192000000 10700732640 11113664512 1781907856 17.865 100 31 63 0 1796871728 5585136 9378736
17:21:03 7718 8192000000 10706988944 11126194176 1783068768 17.875 99 22 44 0 1795436896 6269728 6098400
17:21:17 7794 8192000000 10718270016 11141869568 1810306736 18.098 100 30 60 2 1824467440 5622880 8537824
17:21:34 69416 8192000000 10693815584 11118133248 1719472496 17.348 95 27 54 1 1732450768 5115648 7862624
17:22:50 13678 8192000000 10717814528 11144675328 1808034368 18.080 100 26 52 1 1825169984 10164512 6971104
17:23:09 7560 8192000000 10736690368 11157528576 1822876912 18.201 100 26 52 2 1835829552 6182816 6769824
17:23:23 6814 8192000000 10739292112 11162329088 1829212896 18.253 100 24 49 2 1842336176 6423712 6699568
17:23:37 7082 8192000000 10749074528 11169169408 1816929344 18.153 99 31 63 1 1832597680 7084688 8583648
17:23:50 8264 8192000000 10748360416 11173359616 1837051664 18.317 100 32 64 2 1853231776 6637824 9542288
17:24:05 9826 8192000000 10770532880 11186507776 1845341344 18.384 100 30 60 2 1864122784 10634928 8146512
17:24:22 6559 8192000000 10759438352 11183960064 1847868256 18.405 100 32 61 4 1861949872 5164432 8917184
17:24:37 12333 8192000000 10760869952 11188305920 1848779168 18.412 100 15 30 0 1863315088 10309808 4226112
17:24:57 8390 8192000000 10752742288 11189325824 1849452784 18.418 100 17 34 0 1859325104 5375648 4496672
17:25:13 14341 8192000000 10766314928 11194814464 1853226304 18.448 100 15 30 0 1863040768 5671424 4143040
17:25:33 9345 8192000000 10768880272 11197964288 1858588320 18.492 100 16 32 1 1868526240 5493040 4444880
17:25:49 8163 8192000000 10781912448 11205275648 1864610336 18.541 100 18 34 3 1874713344 5397520 4705488
17:26:07 14786 8192000000 10778667360 11209748480 1866130128 18.553 100 15 30 0 1875686608 5233280 4323200
17:26:32 69032 8192000000 10811408144 11233202176 1885241776 18.707 100 39 78 1 1903016560 6343936 11430848
17:27:53 10548 8192000000 10847831792 11260538880 1910198416 18.908 100 60 121 1 1935598096 8579072 16820608
17:28:10 12401 8192000000 10848186976 11266883584 1919781280 18.985 100 62 123 1 1947445984 10608736 17055968
17:28:33 20943 8192000000 10859263920 11277324288 1924794032 19.025 100 58 115 5 1950686912 9559312 16333568
17:29:01 30334 8192000000 10867402432 11290439680 1929145952 19.060 100 42 84 1 1950784128 9915264 11722912
17:29:46 18706 8192000000 10862341472 11294998528 1940283136 19.149 100 33 66 1 1958182528 8647200 9252192
17:30:17 12724 8192000000 10878632304 11310100480 1947776400 19.209 100 39 78 1 1970228752 10793232 11659120
17:30:38 17207 8192000000 10894328192 11318616064 1955466256 19.270 100 56 112 0 1984464464 12158272 16839936
17:31:03 11626 8192000000 10900019616 11329396736 1961081008 19.315 100 49 97 0 1987851472 13091248 13679216
17:31:23 11255 8192000000 10912990448 11335843840 1971864000 19.400 100 60 120 1 2001695536 13166976 16664560
17:31:48 13014 8192000000 10913490160 11333160960 1963857632 19.337 99 71 139 2 1999217792 15214592 20145568
17:32:13 9985 8192000000 10927622912 11346530304 1980311408 19.467 100 62 123 0 2014612304 16604176 17696720
17:32:31 8941 8192000000 10923576848 11348320256 1981727760 19.478 100 61 121 1 2016153216 17204064 17221392
17:32:48 26329 8192000000 10929081744 11360468992 1989108832 19.537 100 49 97 1 2019767808 16542192 14116784
17:33:23 7892 8192000000 10926340016 11357294592 1992733712 19.565 100 50 100 0 2023928256 17122272 14072272
17:33:46 13468 8192000000 10928679680 11364843520 1995408496 19.587 100 52 105 1 2027923376 17105248 15409632
17:34:10 14120 8192000000 10930864736 11369426944 1984038816 19.497 99 46 92 1 2018175984 18937968 15199200
17:34:37 6371 8192000000 10953690624 11385835520 2007107920 19.679 100 50 100 2 2044202352 21838368 15256064
17:34:51 7771 8192000000 10969922304 11392524288 1998547376 19.611 99 67 131 1 2040767376 23456160 18763840
17:35:07 7018 8192000000 10975134896 11400982528 2016636032 19.754 100 62 124 0 2061487376 26563904 18287440
17:35:25 9456 8192000000 10950908144 11376963584 1980032448 19.465 98 69 138 1 2028530416 27537872 20960096
17:35:43 3739 8192000000 10972589792 11395440640 2007750656 19.684 100 69 138 0 2059311312 31056192 20504464
17:35:55 1997 8192000000 10959339472 11376128000 1969973168 19.385 98 73 146 1 2024465616 32118368 22374080
17:36:07 5003 8192000000 10964697744 11391774720 2001715552 19.636 100 62 124 0 2054423616 33344304 19363760
17:36:18 6130 8192000000 10959241776 11389231104 2002331872 19.641 100 64 128 0 2054507104 32917248 19257984
17:36:34 2706 8192000000 10955611792 11380559872 1979732544 19.463 99 70 138 1 2033291520 32484560 21074416
17:36:46 4509 8192000000 10951247440 11367313408 1978000736 19.449 99 65 128 0 2033653280 36508976 19143568
17:36:58 1476 8192000000 10953649712 11377049600 1993255216 19.570 100 77 154 0 2047525824 30411680 23858928
17:37:07 1690 8192000000 10967797728 11382644736 1992354768 19.562 100 82 165 0 2049310912 31877040 25079104
17:37:16 4163 8192000000 10967608544 11387502592 1996557328 19.596 100 87 174 5 2059550896 36918992 26074576
17:37:31 1735 8192000000 10950448528 11362328576 1967304288 19.364 99 83 166 2 2026454464 33704496 25445680
17:37:39 9065 8192000000 10956914688 11373682688 1984831424 19.503 100 78 155 2 2043202656 35378880 22992352
17:38:02 2399 8192000000 10975148288 11396505600 1999584848 19.619 100 70 140 0 2059790960 38965808 21240304
17:38:12 3033 8192000000 10945922048 11358396416 1956061568 19.275 98 80 160 1 2020000224 38895136 25043520
17:38:23 1366 8192000000 10957667744 11366354944 1973259552 19.411 99 80 159 3 2038375280 40400272 24715456
17:38:30 2550 8192000000 10975542080 11384066048 1989238528 19.538 100 87 173 1 2056098112 40780384 26079200
17:38:39 7181 8192000000 10955873856 11373572096 1957253072 19.284 99 77 154 2 2023296192 42520432 23522688
17:38:59 4068 8192000000 10959095600 11376840704 1977639888 19.446 100 71 141 2 2042846128 43170880 22035360
17:39:10 2929 8192000000 10958088240 11374514176 1978572576 19.453 100 77 151 1 2043279392 41366064 23340752
17:39:20 2281 8192000000 10965296272 11384889344 1983411760 19.492 100 72 146 4 2047383104 42500592 21470752
17:39:30 4153 8192000000 10935147168 11353251840 1957390368 19.285 100 70 140 1 2018977712 39990304 21597040
17:39:41 2864 8192000000 10934153312 11351736320 1953983040 19.258 100 66 130 1 2014249792 40439088 19827664
17:39:58 11271 8192000000 10923028912 11347496960 1941939888 19.162 99 58 116 2 2002110816 42591536 17579392
17:40:18 5843 8192000000 10950319136 11369566208 1966274496 19.356 100 61 121 0 2028508048 43826208 18407344
17:40:33 2083 8192000000 10963292752 11379331072 1978643520 19.454 100 79 158 3 2046166080 43167216 24355344
17:40:41 3979 8192000000 10957637248 11376025600 1963304800 19.332 99 79 155 4 2032034928 44358080 24372048
17:40:53 3137 8192000000 10968816880 11389390848 1981185264 19.474 100 77 152 1 2050077504 45701344 23190896
17:41:02 10823 8192000000 10937447152 11381768192 1980497488 19.469 100 44 88 0 2039885936 45523184 13865264
17:41:24 24482 8192000000 10940201504 11379499008 1954712496 19.264 99 35 70 2 2010583184 44063504 11807184
17:42:22 11968 8192000000 10893094736 11329646592 1929038176 19.059 98 39 78 1 1985634288 43742960 12853152
17:42:42 12969 8192000000 10926609296 11374854144 1958078384 19.291 100 32 64 0 2006965680 38937760 9949536
17:43:02 15277 8192000000 10915010240 11356180480 1924457936 19.023 98 28 56 0 1974029536 40380384 9191216
17:43:29 25546 8192000000 10922289808 11367448576 1923715056 19.017 98 25 50 1 1975403808 43457152 8231600
17:44:02 19927 8192000000 10914493040 11358138368 1956901088 19.281 100 29 58 1 2009832496 43001328 9930080
17:44:29 19294 8192000000 10899115344 11338735616 1913249600 18.933 99 30 60 0 1970582736 46936448 10396688
17:45:04 21892 8192000000 10870278624 11301707776 1861208944 18.513 97 25 50 1 1917837264 46830048 9798272
17:45:36 15618 8192000000 10881451872 11325341696 1884241360 18.699 98 34 68 1 1944073552 48555056 11277136
17:45:58 15207 8192000000 10890552896 11331919872 1907932560 18.890 99 26 52 1 1967265744 50259312 9073872
17:46:20 8530 8192000000 10909520672 11350396928 1927333664 19.046 100 34 68 1 1993519120 54004336 12181120
17:46:36 16029 8192000000 10896288512 11339169792 1887028768 18.722 98 27 53 2 1957593616 59814624 10750224
17:47:20 16793 8192000000 10895830208 11350032384 1905703792 18.872 99 26 52 3 1973573584 58157888 9711904
17:47:49 32401 8192000000 10872405920 11330928640 1886465088 18.717 98 19 39 0 1935853360 42498320 6889952
17:48:57 46332 8192000000 10880146016 11343380480 1926478512 19.039 100 11 22 0 1959107840 29062080 3567248
17:49:57 39384 8192000000 10848165584 11309502464 1896442880 18.798 99 9 18 0 1919081936 19880352 2758704
17:51:06 12802 8192000000 10852602512 11293515776 1898220576 18.812 99 46 92 1 1920607232 8612240 13774416
17:51:32 28426 8192000000 10821236288 11281584128 1893592496 18.775 99 10 18 1 1903846320 7409920 2843904
17:52:09 42417 8192000000 10823728272 11290783744 1882642992 18.686 98 11 22 0 1895987168 9918528 3425648
17:52:58 59009 8192000000 10837351888 11297673216 1883648608 18.695 98 21 42 4 1898379104 8854496 5876000
17:54:03 94856 8192000000 10853627008 11320295424 1899837216 18.825 99 10 20 1 1915538464 12671696 3029552
17:55:44 54449 8192000000 10849757072 11313537024 1893042192 18.770 98 18 35 2 1913996208 15460464 5493552
17:56:50 102381 8192000000 10869036816 11330863104 1889122672 18.739 97 13 26 0 1907809632 14978160 3708800
17:58:39 76306 8192000000 10860711408 11306209280 1902800976 18.849 98 26 51 0 1924149472 13563648 7784848
18:00:25 81498 8192000000 10865365424 11318513664 1889870112 18.745 97 25 51 2 1904525872 7562144 7093616
18:02:00 89476 8192000000 10892779456 11349045248 1956965904 19.282 100 13 26 1 1965834560 5838352 3030304
18:03:36 35348 8192000000 10896791856 11358879744 1958509456 19.294 99 14 28 1 1974042016 12062288 3470272
18:04:31 18447 8192000000 10925874400 11372113920 1982663392 19.486 100 39 75 2 2001836480 8450912 10722176
18:05:04 25972 8192000000 10914385488 11372449792 1992294192 19.562 100 46 91 1 2013793152 8017664 13481296
18:05:57 67040 8192000000 10910214288 11384963072 1995316832 19.586 100 15 30 0 2009491936 9557632 4617472
18:07:10 50239 8192000000 10919039392 11392167936 2001807840 19.637 100 15 30 1 2018452400 12005952 4638608
18:09:26 90366 8192000000 10898040352 11367272448 1975103744 19.426 99 27 54 0 1997462288 14168080 8190464
18:11:07 48635 8192000000 10936533280 11400028160 1997771744 19.605 100 19 38 0 2022299536 18993856 5533936
18:12:05 28633 8192000000 10933679408 11410337792 2003860608 19.653 100 10 20 1 2027241408 20685664 2695136
18:12:40 43151 8192000000 10926056448 11416207360 1984940416 19.504 99 16 32 0 2011505968 22036208 4529344
18:13:42 46937 8192000000 10915885984 11399454720 1996288000 19.593 100 6 12 1 2013757952 15803728 1666224
18:14:36 50802 8192000000 10941745152 11397341184 1991467488 19.555 99 28 56 0 2007496560 8212256 7816816
18:15:35 36724 8192000000 10926822768 11389558784 1973229264 19.411 98 35 70 1 1992181760 9445072 9507424
18:16:18 70259 8192000000 10945726352 11413016576 2013088976 19.726 100 28 55 1 2030716400 10430768 7196656
18:17:43 73078 8192000000 10964234192 11434774528 2021500848 19.792 100 26 51 0 2046265600 17240752 7524000
18:19:06 87056 8192000000 10937897504 11429806080 1997477296 19.603 99 15 30 0 2023585776 21495072 4613408
18:21:33 68509 8192000000 10937931440 11405053952 1951611216 19.239 97 15 28 2 1964867792 9185216 4071360
18:22:57 83516 8192000000 10933264688 11388035072 1922194816 19.004 96 20 40 0 1938416352 11051536 5170000
18:24:28 23554 8192000000 10936280656 11385241600 1969917040 19.385 99 38 72 0 1995799216 16353616 9528560
18:24:58 56339 8192000000 10905142432 11371843584 1913199120 18.932 96 22 44 1 1936057888 16377312 6481456
18:26:01 106483 8192000000 10901801264 11361800192 1951102160 19.235 99 29 58 0 1971690752 12664096 7924496
18:28:02 57531 8192000000 10871000352 11321167872 1873167024 18.610 95 36 72 1 1893914384 11079392 9667968
18:29:07 32553 8192000000 10913481328 11365683200 1969938144 19.385 100 30 60 1 1989401216 11181040 8282032
18:29:49 26135 8192000000 10902659360 11366019072 1976557584 19.437 100 43 86 0 2003763232 14559936 12645712
18:30:22 50875 8192000000 10865731264 11328729088 1881774224 18.679 96 15 30 1 1897912400 11982384 4155792
18:31:22 42091 8192000000 10861102752 11329982464 1914222192 18.941 98 17 34 0 1933684704 14366656 5095856
18:33:06 33558 8192000000 10861497088 11337785344 1924011600 19.019 100 7 14 0 1941767472 15767664 1988208
18:33:47 52018 8192000000 10885828448 11354300416 1932592528 19.088 99 18 36 0 1947869056 10446608 4829920
18:34:46 56699 8192000000 10885279824 11347492864 1917828464 18.969 98 18 37 1 1932657760 9010784 5818512
18:35:52 87649 8192000000 10881619472 11359096832 1902191200 18.844 97 11 22 1 1919074096 13708320 3174576
18:37:32 114625 8192000000 10844358656 11294744576 1746330192 17.571 90 15 30 0 1770803248 19882768 4590288
18:39:33 24476 8192000000 10867600400 11289137152 1879789376 18.663 98 50 98 2 1902349248 8320304 14239568
18:40:05 29980 8192000000 10854525200 11306303488 1896181584 18.796 99 40 80 1 1918439120 10955200 11302336
18:40:43 70068 8192000000 10857646544 11325636608 1860532560 18.508 97 26 52 0 1879283024 11705824 7044640
18:42:34 65256 8192000000 10851799888 11297775616 1875154928 18.626 97 29 56 0 1891557280 8798384 7603968
18:43:47 22661 8192000000 10871050624 11315765248 1913586512 18.935 99 45 86 2 1935845248 10190448 12068288
18:44:19 48938 8192000000 10866323008 11320332288 1920984384 18.995 99 27 54 2 1937534560 9423392 7126784
18:45:21 119600 8192000000 10872928000 11333709824 1928647824 19.056 99 43 86 2 1948942432 7959952 12334656
18:47:32 37936 8192000000 10876481008 11339612160 1954266496 19.260 100 22 44 1 1968898208 8639056 5992656
18:48:20 34584 8192000000 10866342800 11337187328 1950105856 19.227 100 17 34 1 1963449872 8306320 5037696
18:49:12 45981 8192000000 10873049808 11343884288 1932364400 19.086 99 13 26 1 1944213392 7779456 4069536
18:50:04 83806 8192000000 10873711984 11344482304 1906025520 18.875 97 11 22 1 1917518928 8435264 3058144
18:51:34 83368 8192000000 10871897008 11351502848 1941041856 19.155 99 20 40 1 1961809280 14312496 6454928
18:53:04 81806 8192000000 10864464800 11338006528 1898764720 18.816 97 11 22 0 1910585360 8830960 2989680
18:54:35 65413 8192000000 10884249408 11343032320 1931442592 19.078 99 19 38 0 1948329536 11692352 5194592
18:55:46 47701 8192000000 10887200464 11345780736 1901409856 18.838 97 27 54 0 1921391568 12572064 7409648
18:56:42 50030 8192000000 10900151008 11358167040 1941250480 19.157 99 14 28 3 1958766528 13693968 3822080
18:57:38 90021 8192000000 10912602512 11371790336 1969132400 19.379 100 14 28 2 1997363344 24223408 4007536
18:59:20 95500 8192000000 10902374752 11369050112 1962846624 19.329 99 16 30 0 1977206640 10177312 4182704
19:01:02 59995 8192000000 10925314080 11385528320 1989088288 19.537 100 31 60 2 2007855408 10501232 8265888
19:02:17 93467 8192000000 10922959088 11393355776 1955792752 19.273 98 21 42 1 1971382288 10059664 5529872
19:03:57 47721 8192000000 10925775088 11373469696 1954955120 19.266 98 20 40 2 1969092992 8523472 5614400
19:04:51 13404 8192000000 10937041472 11383930880 1988761504 19.534 100 53 103 2 2016192608 12465328 14965776
19:05:10 24291 8192000000 10912386512 11371077632 1959019200 19.298 99 33 66 0 1983082288 15127888 8935200
19:05:45 79150 8192000000 10906517920 11386044416 1967928992 19.369 99 21 42 1 1985001408 11450224 5622192
19:07:10 98790 8192000000 10914303184 11376234496 1948470368 19.214 98 18 36 0 1962867024 9282576 5114080
19:09:30 72382 8192000000 10843646224 11311710208 1822905328 18.201 92 13 26 0 1846785504 20869856 3010320
19:10:48 70533 8192000000 10867215488 11344470016 1929915488 19.066 99 11 22 0 1947621408 14374608 3331312
19:12:10 36093 8192000000 10860411920 11339857920 1929219904 19.061 99 7 14 1 1945845744 14348048 2277792
19:12:54 32356 8192000000 10853398768 11323514880 1896265296 18.796 97 12 24 2 1908939728 9020320 3654112
19:13:37 44228 8192000000 10847581936 11312353280 1873908672 18.616 96 23 46 1 1888381504 7973920 6498912
19:14:27 60806 8192000000 10856835456 11330686976 1897901376 18.809 98 10 20 0 1911166736 10011440 3253920
19:15:34 42933 8192000000 10878631920 11350614016 1947719872 19.208 100 23 46 1 1971823504 16317408 7786224
19:16:25 80089 8192000000 10906916576 11369811968 1961076416 19.315 100 13 26 0 1980883072 16051024 3755632
19:17:57 65183 8192000000 10882618688 11348021248 1925587600 19.032 98 8 15 1 1936756016 8918336 2250080
19:19:10 55643 8192000000 10909436256 11359633408 1945823248 19.193 99 36 72 1 1970006896 13596544 10587104
19:20:19 54434 8192000000 10878575392 11336302592 1884369008 18.700 96 36 73 1 1910133040 15592656 10171376
19:22:14 95557 8192000000 10851575824 11319582720 1852777792 18.445 95 14 28 0 1873170224 16632608 3759824
19:23:56 37279 8192000000 10865812416 11325014016 1890145104 18.747 98 19 38 2 1904625072 9373632 5106336
19:24:39 22192 8192000000 10860146448 11301552128 1877744752 18.647 97 42 84 0 1903119568 14237504 11137312
19:25:09 24843 8192000000 10854027856 11295866880 1862121936 18.520 97 42 84 2 1886867344 13221792 11523616
19:25:42 36521 8192000000 10884109024 11309486080 1885508528 18.710 98 60 121 1 1918885312 16910944 16465840
19:26:35 77511 8192000000 9427368112 9726967808 559737888 6.395 29 10 19 0 569515280 6961744 2815648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 22-12-2020 19:29:59 to 22-12-2020 19:30:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

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

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          245954
MON$OLDEST_ACTIVE               245955
MON$OLDEST_SNAPSHOT             245955
MON$NEXT_TRANSACTION            245955
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                       2019200
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

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

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

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