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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-24 19:27:07
DTS_END                         2020-11-24 19:27:07.0750
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_PAY_FROM_CUSTOMER(18:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39878
TRN_ID                          247860
ATT_ID                          679
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: 9529.09 24111 1143491
customer order: creation 173.95 325 20874
customer order: refuse 14.76 347 1771
order to supplier: creation 47.39 1242 5687
order to supplier: removal 3.69 109323 443
invoice (draft): creation 47.64 3405 5717
invoice (draft): removal 56.21 886 6745
invoice accept: apply 41.54 17826 4985
invoice accept: cancel 50.82 861 6098
customer reserve: creation 3828.02 177 459362
customer reserve: removal 4958.28 63 594994
realization accept: apply 85.86 197 10303
realization accept: cancel 89.91 108 10789
payment from customer: creation 59.88 135 7186
payment from customer: removal 5.78 83 693
payment to supplier: creation 49.37 121 5924
payment to supplier: removal 3.36 88 403
service: total inventory turnovers 4.66 1225 559
service: total monetary turnovers 7.19 25 863
service: aggregate perf. data 0.76 25043 91
service: refresh index statistics 0.03 320744 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 24-11-2020 19:28:09 to 24-11-2020 19:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8332
TEST_TIME 2 6646
TEST_TIME 3 6527
TEST_TIME 4 5269
TEST_TIME 5 5177
TEST_TIME 6 5308
TEST_TIME 7 5220
TEST_TIME 8 5486
TEST_TIME 9 5641
TEST_TIME 10 5895
TEST_TIME 11 6228
TEST_TIME 12 6705
TEST_TIME 13 6766
TEST_TIME 14 6746
TEST_TIME 15 7114
TEST_TIME 16 7176
TEST_TIME 17 7451
TEST_TIME 18 7637
TEST_TIME 19 8114
TEST_TIME 20 8691
TEST_TIME 21 8581
TEST_TIME 22 8643
TEST_TIME 23 8708
TEST_TIME 24 8629
TEST_TIME 25 8668
TEST_TIME 26 9163
TEST_TIME 27 9391
TEST_TIME 28 9849
TEST_TIME 29 10631
TEST_TIME 30 11465
TEST_TIME 31 11362
TEST_TIME 32 11415
TEST_TIME 33 11366
TEST_TIME 34 11458
TEST_TIME 35 11309
TEST_TIME 36 11157
TEST_TIME 37 11057
TEST_TIME 38 10906
TEST_TIME 39 10748
TEST_TIME 40 10723
TEST_TIME 41 10620
TEST_TIME 42 10632
TEST_TIME 43 10601
TEST_TIME 44 10682
TEST_TIME 45 10611
TEST_TIME 46 10683
TEST_TIME 47 10702
TEST_TIME 48 10553
TEST_TIME 49 10371
TEST_TIME 50 10333
TEST_TIME 51 10307
TEST_TIME 52 10199
TEST_TIME 53 10169
TEST_TIME 54 10096
TEST_TIME 55 10139
TEST_TIME 56 10067
TEST_TIME 57 10227
TEST_TIME 58 10220
TEST_TIME 59 10152
TEST_TIME 60 10110
TEST_TIME 61 9966
TEST_TIME 62 9947
TEST_TIME 63 9941
TEST_TIME 64 9905
TEST_TIME 65 9914
TEST_TIME 66 9928
TEST_TIME 67 9941
TEST_TIME 68 9920
TEST_TIME 69 9951
TEST_TIME 70 9986
TEST_TIME 71 10026
TEST_TIME 72 10072
TEST_TIME 73 10068
TEST_TIME 74 10085
TEST_TIME 75 10107
TEST_TIME 76 10065
TEST_TIME 77 10096
TEST_TIME 78 10100
TEST_TIME 79 9990
TEST_TIME 80 9926
TEST_TIME 81 9853
TEST_TIME 82 9845
TEST_TIME 83 9821
TEST_TIME 84 9759
TEST_TIME 85 9764
TEST_TIME 86 9735
TEST_TIME 87 9652
TEST_TIME 88 9644
TEST_TIME 89 9659
TEST_TIME 90 9684
TEST_TIME 91 9628
TEST_TIME 92 9614
TEST_TIME 93 9656
TEST_TIME 94 9733
TEST_TIME 95 9745
TEST_TIME 96 9773
TEST_TIME 97 9802
TEST_TIME 98 9804
TEST_TIME 99 9821
TEST_TIME 100 9820
TEST_TIME 101 9805
TEST_TIME 102 9850
TEST_TIME 103 9893
TEST_TIME 104 9810
TEST_TIME 105 9765
TEST_TIME 106 9729
TEST_TIME 107 9730
TEST_TIME 108 9704
TEST_TIME 109 9676
TEST_TIME 110 9640
TEST_TIME 111 9619
TEST_TIME 112 9548
TEST_TIME 113 9569
TEST_TIME 114 9534
TEST_TIME 115 9536
TEST_TIME 116 9546
TEST_TIME 117 9526
TEST_TIME 118 9581
TEST_TIME 119 9610
TEST_TIME 120 9534

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-11-2020 19:28:13 to 24-11-2020 19:28:16.

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 1570223 1570223 0 0.00 0 21153 6 0 0
doc_list_biud 1570219 1570219 0 0.00 0 28736 30 0 0
sp_add_invoice_to_stock 5094 4985 109 2.13 18 203837 17826 0 109
sp_cancel_adding_invoice 6098 6098 0 0.00 6 50849 861 0 0
sp_cancel_client_order 1771 1771 0 0.00 5 9381 348 0 0
sp_cancel_customer_reserve 594994 594994 0 0.00 1 22175 63 0 0
sp_cancel_pay_from_customer 693 693 0 0.00 3 7950 84 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 3 6373 89 0 0
sp_cancel_supplier_invoice 6758 6745 13 0.19 2 13760 887 0 13
sp_cancel_supplier_order 443 443 0 0.00 8 1207200 109324 0 0
sp_cancel_write_off 10789 10789 0 0.00 1 8111 109 0 0
sp_client_order 20874 20874 0 0.00 3 41965 325 0 0
sp_customer_reserve 459362 459362 0 0.00 0 159701 177 0 0
sp_fill_shopping_cart 32266 32266 0 0.00 1 17964 39 0 0
sp_fill_shopping_cart_clo_res 459357 459357 0 0.00 0 13135 12 0 0
sp_get_clo_for_invoice 4979 4979 0 0.00 0 28812 280 0 0
sp_kill_cost_storno 17983 17983 0 0.00 0 5538 61 0 0
sp_kill_qstorno_ret_qs2qd 1207965 1207965 0 0.00 0 19585 34 0 0
sp_kill_qty_storno 636121 636121 0 0.00 0 28734 74 0 0
sp_lock_selected_doc 21090 21090 0 0.00 0 9658 6 0 0
sp_make_cost_storno 28392 28392 0 0.00 0 20099 60 0 0
sp_multiply_rows_for_pdistr 28390 28390 0 0.00 0 16822 31 0 0
sp_multiply_rows_for_qdistr 20874 20874 0 0.00 0 18015 149 0 0
sp_pay_from_customer 7186 7186 0 0.00 4 23197 135 0 0
sp_pay_to_supplier 5924 5924 0 0.00 4 16841 122 0 0
sp_payment_common 13106 13106 0 0.00 1 20310 33 0 0
sp_qd_handle_on_cancel_clo 1771 1771 0 0.00 0 9372 312 0 0
sp_qd_handle_on_invoice_upd_sts 11077 11077 0 0.00 0 28734 367 0 0
sp_qd_handle_on_reserve_upd_sts 10302 10302 0 0.00 0 20496 65 0 0
sp_reserve_write_off 10303 10303 0 0.00 6 20982 198 0 0
sp_supplier_invoice 5717 5717 0 0.00 6 103002 3406 0 0
sp_supplier_order 5687 5687 0 0.00 5 55072 1243 0 0
srv_aggregate_perf_data 91 91 0 0.00 2612 323699 25043 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 856 217860 30890 0 0
srv_find_qd_qs_mism 1096075 1096075 0 0.00 0 13188 5 0 0
srv_make_invnt_saldo 559 559 0 0.00 43 128026 1226 0 0
srv_make_money_saldo 863 863 0 0.00 1 1309 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 128003 483320 320744 0 0
t$perf-abend:sp_add_invoice_to_stock 109 109 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 4986 4986 0 0.00 0 25614 181 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 8284 127 0 0
t$perf-norm:sp_cancel_client_order 1771 1771 0 0.00 0 4744 20 0 0
t$perf-norm:sp_cancel_customer_reserve 635 635 0 0.00 0 1026 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 693 693 0 0.00 0 270 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 2029 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 423 423 0 0.00 0 1912 16 0 0
t$perf-norm:sp_cancel_supplier_order 443 443 0 0.00 0 31254 1840 0 0
t$perf-norm:sp_cancel_write_off 1029 1029 0 0.00 0 5520 18 0 0
t$perf-norm:sp_client_order 20874 20874 0 0.00 0 9099 20 0 0
t$perf-norm:sp_customer_reserve 1024 1024 0 0.00 0 1752 7 0 0
t$perf-norm:sp_pay_from_customer 7186 7186 0 0.00 0 11611 15 0 0
t$perf-norm:sp_pay_to_supplier 5924 5924 0 0.00 0 5587 12 0 0
t$perf-norm:sp_reserve_write_off 10303 10303 0 0.00 0 6296 10 0 0
t$perf-norm:sp_supplier_invoice 5717 5717 0 0.00 0 6026 21 0 0
t$perf-norm:sp_supplier_order 5687 5687 0 0.00 0 7872 18 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 510 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 422 7 0 0
t$perf-norm:srv_make_invnt_saldo 559 559 0 0.00 0 1179 18 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 1441 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10166 9948 218 2.14 0 9267 19 0 218
v_all_customers 38056 38056 0 0.00 0 62 1 0 0
v_all_suppliers 31342 31342 0 0.00 0 65 1 0 0
v_all_wares 41738 41738 0 0.00 0 65 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 243 6 0 0
v_cancel_client_order 3542 3542 0 0.00 0 2488 5 0 0
v_cancel_customer_prepayment 1386 1386 0 0.00 0 5056 12 0 0
v_cancel_customer_reserve 1270 1270 0 0.00 0 420 3 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 2055 8 0 0
v_cancel_supplier_invoice 872 846 26 2.98 0 955 14 0 26
v_cancel_supplier_order 886 886 0 0.00 0 1050 5 0 0
v_cancel_write_off 2058 2058 0 0.00 0 1743 13 0 0
v_max_id_clo_ord 5683 5683 0 0.00 0 131 1 0 0
v_max_id_clo_res 1024 1024 0 0.00 0 1921 12 0 0
v_max_id_ord_sup 5710 5710 0 0.00 0 17955 7 0 0
v_max_non_paid_invoice 1644 1644 0 0.00 0 759 3 0 0
v_max_non_paid_realizn 3784 3784 0 0.00 0 1301 4 0 0
v_min_id_clo_ord 5683 5683 0 0.00 0 2847 5 0 0
v_min_id_clo_res 1024 1024 0 0.00 0 3964 9 0 0
v_min_id_ord_sup 5710 5710 0 0.00 0 9830 9 0 0
v_min_non_paid_invoice 5922 5922 0 0.00 0 8263 12 0 0
v_min_non_paid_realizn 7183 7183 0 0.00 0 12617 19 0 0
v_our_firm 10480 10480 0 0.00 0 29 1 0 0
v_reserve_write_off 20604 20604 0 0.00 0 4281 7 0 0
x_lock_depdocs_on_canc_invoice 12420 12420 0 0.00 0 25529 125 0 0
x_lock_depdocs_on_canc_sup_ord 443 443 0 0.00 0 4312 373 0 0
x_make_qstorno_1000_1200 5687 5687 0 0.00 2 53527 1166 0 0
x_make_qstorno_1200_2000 5717 5717 0 0.00 3 102987 3264 0 0
x_make_qstorno_2100_3300 459362 459362 0 0.00 0 159684 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-11-2020 19:28:17 to 24-11-2020 19:28:21.

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:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:17 12593 8192000000 10240540976 10544607232 899210576 9.890 71 49 100 0 917882784 2428656 16243552
16:57:37 35236 8192000000 10354191680 10668814336 1394829088 14.549 100 91 182 0 1429153824 4919440 29405296
16:58:30 17901 8192000000 10372193440 10693468160 1422670944 14.796 100 91 182 0 1459983056 7140688 30171424
16:59:14 18828 8192000000 10397554384 10724376576 1452940080 15.064 100 82 164 0 1488078928 8273808 26865040
16:59:41 23769 8192000000 10424394048 10751168512 1470021040 15.214 100 87 173 1 1507278912 8759776 28498096
17:00:22 16314 8192000000 10444240032 10777411584 1492490656 15.411 100 86 172 0 1530133632 9513904 28129072
17:00:48 16018 8192000000 10461497440 10798755840 1515614176 15.612 100 95 188 1 1555631744 9584656 30432912
17:01:14 16722 8192000000 10487872528 10835062784 1533343344 15.766 100 76 152 0 1567115904 9867920 23904640
17:01:42 19319 8192000000 10522776416 10878255104 1580071936 16.169 100 77 155 1 1613928384 10324048 23532400
17:02:08 12100 8192000000 10559884448 10912014336 1609235440 16.418 100 83 166 2 1645254176 10989120 25029616
17:02:30 11184 8192000000 10570175104 10930417664 1626800720 16.568 100 79 158 1 1662516512 11991088 23724704
17:02:50 9222 8192000000 10590688224 10954133504 1646911184 16.738 100 81 162 0 1682894912 12232784 23750944
17:03:12 8535 8192000000 10605533168 10973151232 1670348608 16.936 100 82 163 1 1706766576 12462176 23955792
17:03:27 9564 8192000000 10620168032 10992345088 1684507552 17.055 100 81 162 2 1720938480 12376336 24054592
17:03:44 6903 8192000000 10645873008 11010596864 1705368560 17.230 100 94 187 0 1745766464 12887408 27510496
17:04:05 6694 8192000000 10666785984 11037315072 1726050208 17.403 100 83 166 4 1762990128 13493120 23446800
17:04:19 5123 8192000000 10680466112 11053805568 1739289488 17.513 100 76 152 0 1773659200 13282960 21086752
17:04:33 4885 8192000000 10696844800 11073253376 1757940448 17.667 100 82 164 0 1794114592 13555536 22618608
17:04:45 6119 8192000000 10699785120 11079467008 1766542880 17.738 100 86 172 0 1804483392 12995360 24945152
17:04:58 4752 8192000000 10709756976 11090849792 1772311920 17.786 100 86 171 3 1809280176 13614576 23353680
17:05:10 3876 8192000000 10724562880 11100954624 1781197840 17.859 100 87 173 2 1819147696 13843712 24106144
17:05:20 2899 8192000000 10716864336 11097878528 1782379280 17.869 100 86 172 0 1821081280 14494992 24207008
17:05:30 2577 8192000000 10733948032 11111874560 1791677728 17.946 100 87 172 1 1829495904 14005392 23812784
17:05:39 3130 8192000000 10736245360 11115565056 1797464480 17.993 100 91 178 1 1836727088 14528752 24733856
17:05:50 2186 8192000000 10743078016 11124899840 1805129088 18.056 100 89 178 5 1842581568 13982256 23470224
17:05:58 2380 8192000000 10756211072 11134689280 1810959024 18.104 100 86 171 0 1848196880 13779584 23458272
17:06:08 2203 8192000000 10762430144 11145576448 1820189984 18.179 100 92 180 1 1859001216 13179760 25631472
17:06:16 8097 8192000000 10743017696 11137241088 1819706672 18.175 100 72 144 0 1852912464 13079984 20125808
17:06:31 3289 8192000000 10775147184 11160838144 1824394896 18.214 100 92 184 0 1862951024 13084656 25471472
17:06:40 1621 8192000000 10782843856 11165003776 1837562832 18.321 100 96 191 1 1878249216 13974736 26711648
17:06:49 1786 8192000000 10794095232 11178057728 1851722880 18.436 100 93 187 1 1891971344 13288608 26959856
17:06:57 1459 8192000000 10794766384 11181547520 1856174128 18.472 100 90 180 1 1894343488 13397568 24771792
17:07:05 1896 8192000000 10801178320 11187449856 1855879344 18.470 100 91 181 1 1893867840 12830400 25158096
17:07:13 1996 8192000000 10803817744 11189280768 1859567760 18.500 100 94 188 0 1899335872 13716992 26051120
17:07:21 1387 8192000000 10803523520 11191767040 1862340816 18.522 100 93 184 2 1901025520 13362816 25321888
17:07:28 1644 8192000000 10814243392 11201925120 1865982064 18.552 100 93 186 4 1905050864 12353392 26715408
17:07:36 1214 8192000000 10813786544 11203244032 1867216720 18.562 100 93 187 0 1906596064 12525728 26853616
17:07:44 26661 8192000000 10773757360 11196456960 1859285824 18.497 100 41 82 0 1879820640 8819632 11715184
17:08:18 8734 8192000000 10786030288 11202912256 1872116576 18.601 100 42 84 4 1892447552 8428208 11902768
17:08:34 4974 8192000000 10776273904 11199275008 1867755520 18.566 100 27 54 1 1882620496 6989136 7875840
17:08:45 5169 8192000000 10802885136 11212455936 1873634592 18.614 100 39 78 2 1891739856 7280944 10824320
17:08:58 6704 8192000000 10782077024 11206680576 1874225136 18.618 100 25 50 1 1887708576 6442400 7041040
17:09:11 5611 8192000000 10791853152 11213643776 1876366960 18.636 100 30 60 3 1891992304 7111056 8514288
17:09:25 4934 8192000000 10799257328 11218939904 1881481024 18.677 100 49 97 1 1904040336 8726768 13832544
17:09:37 4419 8192000000 10790217936 11218313216 1881490096 18.677 100 41 82 1 1902870592 10006912 11373584
17:09:52 11791 8192000000 10782568208 11216035840 1881341872 18.676 100 25 51 1 1895054240 6633200 7079168
17:10:13 9833 8192000000 10785712560 11215630336 1883663760 18.695 100 16 32 2 1893727728 6202496 3861472
17:10:30 28945 8192000000 10791421568 11227512832 1882662496 18.687 100 15 30 3 1893322816 5435696 5224624
17:11:43 11752 8192000000 10822437840 11239010304 1895223152 18.788 100 59 116 2 1920410656 6907488 18280016
17:12:06 8821 8192000000 10802170656 11230793728 1884499952 18.701 100 17 34 0 1894164288 5595808 4068528
17:12:21 2386 8192000000 10811071440 11235241984 1889057040 18.738 100 31 62 2 1904834448 6594240 9183168
17:12:29 4248 8192000000 10815542416 11243909120 1895432384 18.790 100 49 98 2 1918909552 9555552 13921616
17:12:41 4584 8192000000 10824565440 11248185344 1896870464 18.801 100 50 98 2 1924252528 13450128 13931936
17:12:51 2178 8192000000 10823994304 11248381952 1897810464 18.809 100 49 99 3 1919343440 6514032 15018944
17:13:01 5399 8192000000 10816786240 11247493120 1897223712 18.804 100 32 64 2 1913148656 7111008 8813936
17:13:14 5782 8192000000 10812631328 11246096384 1899929936 18.826 100 35 69 2 1917356880 7081584 10345360
17:13:28 6728 8192000000 10824825408 11254804480 1901245328 18.836 100 29 58 1 1919378336 10669440 7463568
17:13:40 6904 8192000000 10824782224 11254673408 1900936352 18.834 100 25 51 1 1918744992 10383552 7425088
17:13:57 9740 8192000000 10828997248 11263098880 1903710432 18.856 100 26 52 1 1917331888 5967200 7654256
17:14:15 7771 8192000000 10821049312 11259658240 1911052368 18.915 100 23 44 2 1922919792 5707792 6159632
17:14:30 8920 8192000000 10823903312 11258294272 1905734032 18.872 100 21 42 2 1917136000 6005456 5396512
17:14:46 9118 8192000000 10823642272 11261628416 1906966256 18.882 100 25 48 1 1923615936 9374960 7274720
17:15:02 27046 8192000000 10823058992 11261337600 1909523536 18.903 100 21 42 0 1921194976 5720816 5950624
17:16:03 20528 8192000000 10810180624 11239272448 1880935312 18.673 98 50 100 1 1901899056 5272368 15691376
17:16:33 10600 8192000000 10795136960 11235389440 1871127840 18.593 99 27 54 1 1889761792 11098880 7535072
17:16:50 4396 8192000000 10801779920 11224113152 1852778992 18.445 98 25 49 2 1865534512 6370912 6384608
17:17:01 5355 8192000000 10778094752 11204718592 1843674912 18.371 98 24 48 1 1856551472 6023728 6852832
17:17:15 5368 8192000000 10737035952 11156537344 1754424272 17.638 94 35 70 1 1770319552 5520480 10374800
17:17:28 6707 8192000000 10747815776 11158790144 1767948064 17.750 96 34 68 2 1783203104 4799376 10455664
17:17:41 9282 8192000000 10739013248 11170770944 1794920288 17.972 98 24 47 1 1811819568 10123632 6775648
17:18:02 4878 8192000000 10740747712 11152924672 1777586000 17.830 97 31 60 0 1791842112 4693760 9562352
17:18:13 11871 8192000000 10696592640 11106050048 1729593504 17.432 96 19 37 1 1740594320 4631248 6369568
17:18:31 6056 8192000000 10719563264 11137179648 1772247008 17.786 98 23 44 2 1784794944 6428480 6119456
17:18:45 7652 8192000000 10707306384 11132895232 1739704576 17.516 96 14 28 1 1748792240 5004528 4083136
17:18:59 10243 8192000000 10678072320 11095080960 1675807104 16.982 92 18 36 1 1686956544 5890368 5259072
17:19:16 12076 8192000000 10702042832 11118051328 1708386720 17.255 95 23 46 1 1720023552 4948960 6687872
17:19:37 13856 8192000000 10725262560 11116724224 1741066640 17.527 97 16 32 1 1751043632 4912848 5064144
17:20:00 67554 8192000000 10703421088 11126390784 1749708064 17.599 97 33 66 2 1764730912 4973136 10049712
17:21:14 11266 8192000000 10741093616 11158462464 1798576176 18.002 99 33 66 1 1814635264 6779776 9279312
17:21:33 7082 8192000000 10744736192 11164745728 1809682496 18.093 99 33 66 1 1825617024 6700320 9234208
17:21:46 6541 8192000000 10734242304 11158261760 1794874656 17.972 98 30 60 0 1809429936 5393504 9161776
17:22:00 7625 8192000000 10749887008 11165028352 1810115856 18.097 99 21 42 1 1821922320 5207472 6598992
17:22:16 10449 8192000000 10753679952 11182858240 1841924624 18.356 100 27 54 0 1855148448 4700656 8523168
17:22:34 5280 8192000000 10767113744 11195031552 1851680304 18.436 100 33 66 2 1867507760 6752784 9074672
17:22:48 11518 8192000000 10773260208 11200565248 1852863936 18.445 100 13 26 0 1865714784 9344512 3506336
17:23:06 5665 8192000000 10772824304 11201056768 1860074128 18.504 100 21 42 0 1873044016 7029968 5939920
17:23:18 12373 8192000000 10783091744 11209871360 1860497456 18.507 100 16 32 2 1870135488 5267984 4370048
17:23:37 9368 8192000000 10781637536 11205210112 1861036528 18.512 100 10 20 0 1869478176 5338560 3103088
17:23:53 6447 8192000000 10778077632 11207905280 1867072832 18.561 100 22 44 1 1879885440 6366000 6446608
17:24:08 11970 8192000000 10774115040 11208671232 1865875808 18.551 100 13 25 1 1874895072 5474448 3544816
17:24:27 7262 8192000000 10789602608 11216887808 1871616544 18.597 100 25 50 2 1884100832 5712864 6771424
17:24:41 72990 8192000000 10789271952 11216392192 1875074464 18.625 100 29 57 0 1887780432 4610896 8095072
17:26:00 23132 8192000000 10795383504 11227267072 1880206096 18.667 100 33 63 3 1895430064 6089744 9134224
17:26:29 8334 8192000000 10792065424 11227607040 1883572320 18.694 100 30 59 1 1899113200 7302064 8238816
17:26:46 7764 8192000000 10805123456 11230162944 1884486128 18.701 100 34 67 2 1899582224 5833216 9262880
17:27:00 8147 8192000000 10810533968 11237822464 1888280176 18.732 100 27 51 4 1899490448 4745856 6464416
17:27:15 4993 8192000000 10843275184 11262226432 1911976544 18.923 100 48 95 1 1933069360 7015120 14077696
17:27:31 9527 8192000000 10848967760 11273306112 1919119456 18.980 100 41 82 1 1937625328 7325696 11180176
17:27:48 33172 8192000000 10863475024 11285995520 1930450672 19.070 100 53 106 2 1954668400 9801136 14416592
17:28:30 5353 8192000000 10884460528 11301195776 1942202512 19.164 100 67 134 1 1971102816 9510512 19389792
17:28:44 30450 8192000000 10877417504 11304038400 1940810544 19.153 100 48 94 1 1964100784 10080544 13209696
17:29:26 2485 8192000000 10888183248 11307098112 1947789616 19.209 100 55 108 1 1974809056 11920880 15098560
17:29:42 15415 8192000000 10894473632 11318091776 1954019280 19.258 100 55 110 1 1983619024 13814336 15785408
17:30:07 27341 8192000000 10888938112 11323846656 1956510496 19.278 100 47 94 1 1984855216 14989424 13355296
17:30:44 92445 8192000000 10901336656 11341602816 1965338656 19.348 100 39 78 2 1992794752 16031536 11424560
17:33:22 10635 8192000000 10895184064 11328675840 1951741984 19.240 99 35 68 3 1982105488 20398944 9964560
17:33:44 2679 8192000000 10928591296 11352326144 1973713616 19.415 100 56 111 2 2009662528 19653328 16295584
17:33:54 6395 8192000000 10908895872 11327688704 1950940720 19.234 99 54 108 0 1988831648 21927488 15963440
17:34:08 11535 8192000000 10915401504 11345883136 1973162912 19.411 100 56 112 1 2012630048 23038656 16428480
17:34:36 25199 8192000000 10932888336 11368300544 1985042144 19.505 100 54 108 1 2025446448 24955968 15448336
17:35:25 9524 8192000000 10929990832 11372748800 1989619120 19.541 100 45 87 4 2027178256 24476864 13082272
17:35:45 6508 8192000000 10906296384 11334647808 1958110640 19.291 98 47 94 0 1997041312 25171888 13758784
17:36:01 9587 8192000000 10939736944 11375206400 1991679952 19.557 100 57 114 1 2035411936 26078560 17653424
17:36:24 7479 8192000000 10947766384 11373527040 1956628064 19.279 98 63 121 0 2004990048 29808800 18553184
17:36:39 3870 8192000000 10939892352 11365015552 1977778384 19.447 99 59 118 3 2027252080 31378096 18095600
17:36:51 3665 8192000000 10950245584 11375738880 1976350048 19.436 99 63 124 2 2029310480 33993792 18966640
17:37:02 6990 8192000000 10931807200 11352739840 1938959040 19.138 98 67 131 2 1992740192 33659248 20121904
17:37:17 11139 8192000000 10929571840 11353980928 1958543856 19.294 99 60 120 2 2011701632 34168144 18989632
17:37:38 15312 8192000000 10907884160 11334209536 1928386768 19.054 98 60 120 1 1983679328 36555168 18737392
17:38:00 5263 8192000000 10914913232 11341017088 1939937344 19.146 99 61 121 5 2001611920 43978560 17696016
17:38:12 2637 8192000000 10932160704 11351855104 1960192464 19.308 100 78 152 1 2019442368 37232400 22017504
17:38:22 5626 8192000000 10933809216 11348967424 1956703344 19.280 100 65 129 1 2014921968 38713152 19505472
17:38:35 12471 8192000000 10929326368 11347304448 1956240448 19.276 100 66 132 0 2014501952 38885792 19375712
17:38:57 8961 8192000000 10911978032 11332124672 1923158880 19.012 98 58 115 0 1977408112 37344768 16904464
17:39:14 1600 8192000000 10907762960 11312357376 1927907552 19.050 99 81 159 1 1988244944 36533232 23804160
17:39:23 4593 8192000000 10913442528 11333951488 1946999552 19.203 100 65 129 1 2003292048 37209888 19082608
17:39:37 9047 8192000000 10908272768 11321356288 1937184272 19.124 99 70 141 0 1991179376 32333632 21661472
17:39:59 5804 8192000000 10915073008 11325423616 1939594096 19.144 99 65 128 0 1991050064 32593968 18862000
17:40:13 7375 8192000000 10912775952 11340554240 1952838016 19.249 100 59 118 0 2003028944 32490272 17700656
17:40:30 11032 8192000000 10909316592 11335675904 1917442048 18.966 98 58 115 2 1965239312 30735984 17061280
17:40:57 8464 8192000000 10892896976 11319496704 1930441552 19.070 99 53 105 3 1980536000 33769712 16324736
17:41:16 3033 8192000000 10930027328 11352293376 1954751824 19.264 100 65 127 1 2012609360 38725056 19132480
17:41:28 5536 8192000000 10914202368 11329650688 1930935888 19.074 99 72 145 0 1991434400 37664576 22833936
17:41:40 6279 8192000000 10917970448 11342958592 1948811152 19.217 100 48 96 1 2002465872 38736480 14918240
17:41:54 2351 8192000000 10937765984 11350704128 1962058720 19.322 100 79 152 1 2021905408 36880576 22966112
17:42:04 2152 8192000000 10959258928 11367018496 1959720992 19.304 99 82 159 0 2022665568 39055776 23888800
17:42:12 2028 8192000000 10954210976 11361542144 1966341376 19.356 100 87 174 2 2031020608 38182944 26496288
17:42:22 1465 8192000000 10934013488 11344994304 1941959424 19.162 99 88 177 1 2008189136 38579984 27649728
17:42:34 3171 8192000000 10925030608 11340054528 1948993472 19.218 100 82 162 2 2013841264 39269456 25578336
17:42:46 5924 8192000000 10928099888 11341721600 1949621344 19.223 100 71 142 2 2010543968 38884288 22038336
17:43:02 3702 8192000000 10917982960 11326140416 1933656288 19.096 99 84 168 2 2001227808 41426736 26144784
17:43:13 6652 8192000000 10942051136 11359141888 1956846768 19.281 100 72 144 0 2022211712 42737952 22626992
17:43:26 4168 8192000000 10943994784 11362947072 1966937264 19.361 100 78 155 0 2034206752 42509984 24759504
17:43:37 2851 8192000000 10965109296 11369197568 1967336816 19.364 100 83 162 3 2034652016 43057472 24257728
17:43:47 3644 8192000000 10943368256 11355123712 1955257840 19.268 100 83 164 0 2026905392 45695488 25952064
17:43:58 3550 8192000000 10955927808 11367157760 1961056880 19.314 100 79 159 3 2032724896 46774064 24893952
17:44:09 3381 8192000000 10966723232 11368980480 1952242064 19.244 99 90 178 1 2027844992 48034928 27568000
17:44:20 1828 8192000000 10937630288 11337617408 1933646736 19.096 99 90 180 0 2009443248 48689904 27106608
17:44:29 4003 8192000000 10927562768 11331702784 1916132576 18.956 98 81 163 1 1990737456 48906464 25698416
17:44:40 1574 8192000000 10945251248 11355361280 1951826032 19.241 100 84 168 2 2027420848 49478448 26116368
17:44:50 1734 8192000000 10912338768 11319779328 1916044176 18.955 98 78 153 2 1990815584 51279264 23492144
17:45:00 3969 8192000000 10950921120 11358666752 1952166240 19.244 100 75 149 0 2028081920 52190384 23725296
17:45:15 6504 8192000000 10934886272 11354554368 1933065872 19.091 99 61 122 0 2005606720 52987760 19553088
17:45:29 4727 8192000000 10940909376 11351678976 1946990128 19.202 100 72 143 0 2024257952 54343104 22924720
17:45:41 1848 8192000000 10952896544 11363840000 1958141728 19.291 100 82 164 1 2035101024 50702512 26256784
17:45:50 1346 8192000000 10944617040 11355246592 1949498880 19.222 100 80 160 1 2027381360 52560848 25321632
17:46:01 1250 8192000000 10958687760 11365609472 1958580992 19.295 100 85 169 0 2040153488 54535200 27037296
17:46:10 1786 8192000000 10937791120 11341664256 1944588544 19.183 100 78 154 1 2015369120 47189360 23591216
17:46:22 1980 8192000000 10935508320 11338608640 1939804656 19.145 100 87 174 0 2014868192 46873680 28189856
17:46:31 4153 8192000000 10933343088 11339767808 1926728640 19.041 99 78 154 2 1998590304 47018240 24843424
17:46:44 6996 8192000000 10921575440 11330543616 1927371120 19.046 99 71 139 0 1996698224 47108016 22219088
17:47:01 855 8192000000 10944981136 11344924672 1948621168 19.215 100 91 180 2 2024199504 47220512 28357824
17:47:10 2694 8192000000 10951818064 11362004992 1956541328 19.279 100 72 144 0 2031016288 51530064 22944896
17:47:19 3390 8192000000 10973694336 11380482048 1970786048 19.392 100 91 180 1 2054262784 55439376 28037360
17:47:29 1905 8192000000 10955979392 11369713664 1960102128 19.307 100 75 150 3 2037417920 53969008 23346784
17:47:39 9726 8192000000 10945944592 11373666304 1965062112 19.346 100 48 95 1 2035282016 54769360 15450544
17:47:57 23495 8192000000 10948054688 11387858944 1969455776 19.381 100 31 62 0 2029752080 49733072 10563232
17:48:29 6642 8192000000 10949355504 11379240960 1968593808 19.374 100 44 88 2 2031005792 48083728 14328256
17:48:43 6832 8192000000 10972421728 11386929152 1977277568 19.443 100 60 120 2 2043870128 46951248 19641312
17:48:57 987 8192000000 10983803888 11397615616 1986105376 19.513 100 75 150 2 2058055600 48558880 23391344
17:49:08 2774 8192000000 10995394400 11410366464 1995572064 19.588 100 87 174 0 2075785408 52971904 27241440
17:49:22 6370 8192000000 10980026128 11415306240 1992626240 19.565 100 52 104 0 2065900928 56265920 17008768
17:49:38 4074 8192000000 10980003168 11413434368 1985685504 19.510 100 50 100 0 2061744128 59113968 16944656
17:50:04 6147 8192000000 10990607088 11422830592 1998753872 19.613 100 49 98 0 2074517424 59830912 15932640
17:50:16 17521 8192000000 10984037104 11420372992 1995380912 19.586 100 40 80 0 2068317024 59395120 13540992
17:50:40 9945 8192000000 10978495072 11416363008 1989781792 19.542 100 44 88 0 2063875440 59559952 14533696
17:51:00 7309 8192000000 10987879344 11425083392 1992289680 19.562 100 48 95 2 2069823728 62415888 15118160
17:51:14 11012 8192000000 10984630672 11429928960 1991372816 19.555 100 38 76 1 2068870832 64086000 13412016
17:51:35 11471 8192000000 10986396768 11428368384 1991066752 19.552 100 40 79 2 2070906512 65928608 13911152
17:51:58 12078 8192000000 10991793584 11434385408 1988662784 19.533 100 40 80 1 2072832080 69749072 14420224
17:52:23 13583 8192000000 10994758576 11435229184 1975385600 19.428 99 41 81 2 2061609408 71857264 14366544
17:52:44 9723 8192000000 11006164992 11433320448 1986012864 19.512 100 57 114 2 2080733888 75518400 19202624
17:53:01 8426 8192000000 10985900320 11439247360 1968638848 19.375 99 36 72 2 2057077568 75672576 12766144
17:53:57 10573 8192000000 10972595936 11425865728 1961031216 19.314 99 32 64 1 2044428336 71980608 11416512
17:54:21 23939 8192000000 10969901296 11433787392 1967834288 19.368 100 28 56 1 2057753488 79202944 10716256
17:55:04 18046 8192000000 10956324064 11423219712 1950701984 19.232 100 29 58 0 2045077472 82531984 11843504
17:55:30 23115 8192000000 10946188160 11411759104 1941843888 19.161 100 26 53 1 2030162032 77527952 10790192
17:56:03 15014 8192000000 10938253600 11389509632 1933947632 19.098 100 27 54 0 2020984720 76738976 10298112
17:56:25 1546 8192000000 10960293728 11401699328 1954519824 19.262 100 36 71 4 2038484336 71611456 12353056
17:56:33 23896 8192000000 10918275600 11387162624 1911999856 18.923 98 41 81 1 1993584784 67932912 13652016
17:57:12 26770 8192000000 10905792432 11358687232 1950227088 19.228 100 25 51 1 1982846416 25004528 7614800
17:57:46 57879 8192000000 10906337056 11364765696 1964246672 19.340 100 26 52 2 1990372496 18506032 7619792
17:58:57 45830 8192000000 10892749968 11371540480 1958664144 19.295 100 10 20 1 1974438496 13230464 2543888
18:01:13 151181 8192000000 10904154592 11365236736 1954444480 19.262 99 14 28 1 1974664800 16281072 3939248
18:04:02 98508 8192000000 10904148912 11363753984 1952563024 19.247 99 14 28 1 1966766784 10411552 3792208
18:05:55 72220 8192000000 10920733648 11378507776 1979911712 19.464 100 38 77 0 2001627952 10675344 11040896
18:07:34 69663 8192000000 10932267984 11389997056 1966560992 19.358 99 17 34 1 1981146592 9687232 4898368
18:08:52 37010 8192000000 10928052576 11389263872 1994642016 19.580 100 48 93 3 2021027056 12402464 13982576
18:09:42 75537 8192000000 10920879040 11389026304 1969229088 19.379 99 6 12 0 1981290640 10892752 1168800
18:11:07 109108 8192000000 10918327184 11394846720 1949327648 19.221 98 6 12 1 1965695360 14453408 1914304
18:13:03 100471 8192000000 10951041392 11433345024 1994025840 19.576 100 8 16 0 2019807440 23387776 2393824
18:14:55 115341 8192000000 10918859520 11380056064 1947260720 19.205 97 26 51 2 1964906928 9982160 7664048
18:17:02 40203 8192000000 10915015952 11379429376 1953061744 19.251 98 37 72 1 1972414880 8701232 10651904
18:17:50 34183 8192000000 10891615008 11336679424 1923658128 19.016 97 48 97 2 1945721792 8763920 13299744
18:18:35 217860 8192000000 10921895152 11395371008 1872093856 18.601 94 31 62 0 1897090784 15828496 9168432
18:22:22 46457 8192000000 10932538944 11402825728 1985813920 19.511 100 20 40 1 2008500416 15945248 6741248
18:23:15 25308 8192000000 10918957280 11371880448 1938226256 19.133 97 62 122 1 1970814672 12958496 19629920
18:23:49 59908 8192000000 10882415184 11366293504 1910496208 18.911 97 31 62 0 1939550848 19320816 9733824
18:24:59 41105 8192000000 10892572864 11374481408 1936915776 19.122 99 13 26 0 1962903744 22765664 3222304
18:25:54 31081 8192000000 10828290960 11297538048 1875905104 18.632 96 11 22 0 1893939472 14940272 3094096
18:26:45 61181 8192000000 10847303392 11320926208 1860331216 18.506 96 22 42 2 1877572096 11269152 5971728
18:27:52 95619 8192000000 10825009328 11293552640 1840803456 18.347 95 17 34 0 1857184656 11519072 4862128
18:29:44 34119 8192000000 10799767200 11265478656 1843410368 18.369 96 21 41 0 1860474720 10872880 6191472
18:30:24 16822 8192000000 10853588176 11308167168 1916643200 18.960 100 26 52 0 1932624128 8833344 7147584
18:30:58 52123 8192000000 10819353696 11294564352 1837386208 18.320 96 15 31 0 1847071648 6328368 3357072
18:32:37 84887 8192000000 10840454896 11303755776 1810404224 18.099 94 11 23 2 1826777808 13520064 2853520
18:34:09 31670 8192000000 10832798480 11299098624 1876744144 18.639 98 14 28 2 1887775984 7468768 3563072
18:34:47 39529 8192000000 10863085408 11324768256 1901699488 18.840 99 21 43 1 1915634816 8170816 5764512
18:35:35 34995 8192000000 10869830416 11322486784 1908168656 18.892 99 37 72 2 1929477616 10600160 10708800
18:36:18 59369 8192000000 10868181072 11344785408 1917760800 18.969 99 28 56 0 1943963024 18154256 8047968
18:37:31 48216 8192000000 10880893824 11327434752 1898205712 18.812 98 41 81 2 1932441712 21654832 12581168
18:38:30 10889 8192000000 10884386896 11339276288 1939053168 19.139 100 50 98 1 1970422928 16537824 14831936
18:38:51 36848 8192000000 10885418528 11350212608 1948336528 19.213 100 34 68 1 1970965776 13183248 9446000
18:39:48 63468 8192000000 10863915280 11340779520 1868410480 18.571 96 12 24 0 1883983856 12023024 3550352
18:41:01 67101 8192000000 10886695152 11353014272 1925768912 19.033 99 19 38 0 1946209392 14313136 6127344
18:42:19 32796 8192000000 10866940848 11335884800 1933230656 19.093 100 33 66 0 1954480144 12176432 9073056
18:42:58 62339 8192000000 10879120192 11332038656 1893559664 18.774 97 26 52 4 1910345392 9363424 7422304
18:44:11 67720 8192000000 10871465984 11348246528 1896460816 18.798 98 11 22 1 1909958928 10565696 2932416
18:45:26 114441 8192000000 10854955392 11303260160 1897834688 18.809 98 22 44 0 1912020896 8060288 6125920
18:47:32 59760 8192000000 10867629344 11335942144 1924606784 19.024 99 24 48 2 1943642512 11654736 7380992
18:48:38 46380 8192000000 10870717696 11349614592 1940308176 19.149 100 21 42 2 1956829536 10292528 6228832
18:49:51 52075 8192000000 10841999936 11325530112 1881673872 18.679 97 9 18 0 1897392928 12579168 3139888
18:50:49 45809 8192000000 10863282592 11341119488 1939361008 19.142 100 16 32 0 1951950880 7418832 5171040
18:51:47 57638 8192000000 10870212912 11353931776 1952800032 19.249 100 23 45 1 1968799440 9114432 6884976
18:52:51 42905 8192000000 10887998992 11364294656 1943589264 19.175 99 22 46 1 1957522528 7731248 6202016
18:53:52 74653 8192000000 10882620736 11357380608 1922824000 19.009 98 12 24 0 1938876096 12448928 3603168
18:55:34 14175 8192000000 10891848048 11355238400 1960153952 19.307 100 36 73 0 1979914208 9687856 10072400
18:56:01 79430 8192000000 10886202192 11377438720 1937813808 19.129 99 8 16 0 1951781840 11850224 2117808
18:57:26 73849 8192000000 10907815648 11380203520 1936701584 19.120 98 7 14 0 1948788176 10520064 1566528
18:58:49 64927 8192000000 10935904816 11406852096 1990504912 19.548 100 18 36 1 2011528928 15490576 5533440
19:00:18 70225 8192000000 10910883536 11396894720 1967577760 19.366 99 19 38 0 1988330704 15441232 5311712
19:01:35 81848 8192000000 10952805360 11413766144 1970579632 19.390 99 11 22 0 1984399200 10682960 3136608
19:03:09 61782 8192000000 10922127008 11413065728 1994768480 19.581 100 19 38 0 2012614864 12603680 5242704
19:04:18 91905 8192000000 10933957184 11398549504 1938224784 19.133 97 13 26 1 1955175328 12569184 4381360
19:05:58 38615 8192000000 10905859296 11392794624 1934823648 19.105 97 16 32 1 1956969360 17880160 4265552
19:06:59 35131 8192000000 10915685808 11366875136 1924087952 19.020 97 32 64 0 1942934992 9877024 8970016
19:07:41 25432 8192000000 10926985888 11392331776 1980085888 19.465 100 37 74 3 2004795584 14463616 10246080
19:08:12 11089 8192000000 10937432224 11384610816 1988289952 19.530 100 35 71 2 2004652752 7275376 9087424
19:08:33 37690 8192000000 10919004016 11381379072 1945860928 19.193 98 34 66 1 1966608016 11294336 9452752
19:09:17 81906 8192000000 10913236048 11387723776 1881935936 18.681 95 12 24 0 1900923760 15543104 3444720
19:11:48 85594 8192000000 10894425552 11358314496 1893349424 18.773 96 31 62 0 1908702512 6634128 8718960
19:13:22 63878 8192000000 10857215312 11330269184 1875231760 18.627 96 21 41 0 1889903824 9034800 5637264
19:14:34 52292 8192000000 10861979280 11337592832 1922412640 19.006 99 16 32 1 1936480160 9558272 4509248
19:15:33 65280 8192000000 10847000768 11332853760 1876652704 18.638 97 7 14 1 1887365104 8917600 1794800
19:16:52 64609 8192000000 10845855856 11319783424 1870756624 18.590 97 19 38 1 1882590576 6422480 5411472
19:18:03 90139 8192000000 10849645168 11321905152 1863926992 18.535 96 17 34 0 1877834688 8879376 5028320
19:20:15 66098 8192000000 10840711296 11328958464 1873405520 18.612 97 10 20 0 1890629408 14130544 3093344
19:21:27 47187 8192000000 10840183280 11316539392 1905086320 18.867 99 19 38 1 1919717072 8689824 5940928
19:22:21 66234 8192000000 10852693920 11320823808 1876801760 18.639 97 23 47 0 1891134384 7911664 6420960
19:23:37 29458 8192000000 10850532496 11316715520 1873895408 18.616 97 21 42 2 1887283952 7327040 6061504
19:24:15 35029 8192000000 10865945472 11332001792 1916112176 18.956 99 28 54 1 1934423904 10721760 7589968
19:25:01 53750 8192000000 10857611200 11329556480 1907665872 18.888 98 21 42 1 1925584048 11917840 6000336
19:26:59 13374 8192000000 9176603648 9468973056 295573664 3.482 16 1 2 0 297130288 1494496 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-11-2020 19:28:23 to 24-11-2020 19:28:55.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 109 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 24-11-2020 19:28:56 to 24-11-2020 19:28:58.

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          248165
MON$OLDEST_ACTIVE               248166
MON$OLDEST_SNAPSHOT             248166
MON$NEXT_TRANSACTION            248166
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                       2079136
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

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

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

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