Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.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 17044784 kB
MemAvailable 31449788 kB
Buffers 0 kB
Cached 14609240 kB
SwapCached 2864 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.7
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-04 19:26:58
DTS_END                         2020-11-04 19:26:58.6600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35608
TRN_ID                          251104
ATT_ID                          738
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: 10025.63 21248 1203075
customer order: creation 178.61 346 21433
customer order: refuse 15.63 313 1875
order to supplier: creation 49.00 1223 5880
order to supplier: removal 3.72 100555 446
invoice (draft): creation 48.49 3153 5819
invoice (draft): removal 58.03 731 6963
invoice accept: apply 43.84 17070 5261
invoice accept: cancel 52.67 661 6320
customer reserve: creation 4076.45 168 489174
customer reserve: removal 5180.48 57 621658
realization accept: apply 87.84 169 10541
realization accept: cancel 93.68 107 11241
payment from customer: creation 63.13 124 7576
payment from customer: removal 5.88 82 706
payment to supplier: creation 51.65 143 6198
payment to supplier: removal 4.02 70 482
service: total inventory turnovers 4.78 1084 574
service: total monetary turnovers 6.94 25 833
service: aggregate perf. data 0.76 26018 91
service: refresh index statistics 0.03 272853 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 04-11-2020 19:27:43 to 04-11-2020 19:27:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 734
TEST_TIME 2 2199
TEST_TIME 3 2172
TEST_TIME 4 3105
TEST_TIME 5 3295
TEST_TIME 6 3610
TEST_TIME 7 4011
TEST_TIME 8 4307
TEST_TIME 9 4362
TEST_TIME 10 4430
TEST_TIME 11 5142
TEST_TIME 12 5229
TEST_TIME 13 5698
TEST_TIME 14 6152
TEST_TIME 15 6349
TEST_TIME 16 6634
TEST_TIME 17 6844
TEST_TIME 18 7161
TEST_TIME 19 7789
TEST_TIME 20 7976
TEST_TIME 21 7902
TEST_TIME 22 8349
TEST_TIME 23 8344
TEST_TIME 24 8738
TEST_TIME 25 9150
TEST_TIME 26 9174
TEST_TIME 27 9411
TEST_TIME 28 10514
TEST_TIME 29 10644
TEST_TIME 30 11261
TEST_TIME 31 11095
TEST_TIME 32 10890
TEST_TIME 33 11023
TEST_TIME 34 11214
TEST_TIME 35 11065
TEST_TIME 36 11051
TEST_TIME 37 11050
TEST_TIME 38 10840
TEST_TIME 39 10759
TEST_TIME 40 10580
TEST_TIME 41 10596
TEST_TIME 42 10635
TEST_TIME 43 10578
TEST_TIME 44 10435
TEST_TIME 45 10387
TEST_TIME 46 10353
TEST_TIME 47 10313
TEST_TIME 48 10475
TEST_TIME 49 10533
TEST_TIME 50 10445
TEST_TIME 51 10383
TEST_TIME 52 10325
TEST_TIME 53 10246
TEST_TIME 54 10090
TEST_TIME 55 10041
TEST_TIME 56 10162
TEST_TIME 57 10071
TEST_TIME 58 10087
TEST_TIME 59 10018
TEST_TIME 60 10050
TEST_TIME 61 10041
TEST_TIME 62 10080
TEST_TIME 63 10112
TEST_TIME 64 10175
TEST_TIME 65 10181
TEST_TIME 66 10145
TEST_TIME 67 10379
TEST_TIME 68 10338
TEST_TIME 69 10331
TEST_TIME 70 10407
TEST_TIME 71 10375
TEST_TIME 72 10408
TEST_TIME 73 10455
TEST_TIME 74 10324
TEST_TIME 75 10294
TEST_TIME 76 10253
TEST_TIME 77 10220
TEST_TIME 78 10173
TEST_TIME 79 10143
TEST_TIME 80 10107
TEST_TIME 81 10088
TEST_TIME 82 10112
TEST_TIME 83 10072
TEST_TIME 84 10049
TEST_TIME 85 10099
TEST_TIME 86 10104
TEST_TIME 87 10101
TEST_TIME 88 10092
TEST_TIME 89 10144
TEST_TIME 90 10128
TEST_TIME 91 10087
TEST_TIME 92 10097
TEST_TIME 93 10120
TEST_TIME 94 10104
TEST_TIME 95 10187
TEST_TIME 96 10144
TEST_TIME 97 10230
TEST_TIME 98 10199
TEST_TIME 99 10146
TEST_TIME 100 10101
TEST_TIME 101 10077
TEST_TIME 102 10011
TEST_TIME 103 10013
TEST_TIME 104 9965
TEST_TIME 105 9931
TEST_TIME 106 9896
TEST_TIME 107 9852
TEST_TIME 108 9879
TEST_TIME 109 9901
TEST_TIME 110 9900
TEST_TIME 111 9884
TEST_TIME 112 9903
TEST_TIME 113 9922
TEST_TIME 114 9988
TEST_TIME 115 9949
TEST_TIME 116 9981
TEST_TIME 117 9961
TEST_TIME 118 9969
TEST_TIME 119 10002
TEST_TIME 120 10037

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-11-2020 19:27:47 to 04-11-2020 19:27:51.

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 1655408 1655408 0 0.00 0 27470 6 0 0
doc_list_biud 1655408 1655408 0 0.00 0 27826 27 0 0
sp_add_invoice_to_stock 5397 5261 136 2.51 32 179981 17071 0 136
sp_cancel_adding_invoice 6320 6320 0 0.00 5 55631 662 0 0
sp_cancel_client_order 1875 1875 0 0.00 4 7743 313 0 0
sp_cancel_customer_reserve 621658 621658 0 0.00 1 27829 57 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 2 5241 82 0 0
sp_cancel_pay_to_supplier 482 482 0 0.00 3 1796 70 0 0
sp_cancel_supplier_invoice 6976 6963 13 0.18 2 12563 732 0 13
sp_cancel_supplier_order 446 446 0 0.00 9 1357183 100556 0 0
sp_cancel_write_off 11241 11241 0 0.00 1 8617 108 0 0
sp_client_order 21433 21433 0 0.00 3 22108 346 0 0
sp_customer_reserve 489174 489174 0 0.00 0 52137 169 0 0
sp_fill_shopping_cart 33123 33123 0 0.00 1 23076 35 0 0
sp_fill_shopping_cart_clo_res 489172 489172 0 0.00 0 11087 12 0 0
sp_get_clo_for_invoice 5247 5247 0 0.00 0 21437 247 0 0
sp_kill_cost_storno 18749 18749 0 0.00 0 7931 52 0 0
sp_kill_qstorno_ret_qs2qd 1261966 1261966 0 0.00 0 27823 31 0 0
sp_kill_qty_storno 664291 664291 0 0.00 0 27826 66 0 0
sp_lock_selected_doc 21961 21961 0 0.00 0 8919 7 0 0
sp_make_cost_storno 29562 29562 0 0.00 0 27348 59 0 0
sp_multiply_rows_for_pdistr 29562 29562 0 0.00 0 6518 28 0 0
sp_multiply_rows_for_qdistr 21433 21433 0 0.00 0 11139 158 0 0
sp_pay_from_customer 7576 7576 0 0.00 4 15347 125 0 0
sp_pay_to_supplier 6198 6198 0 0.00 5 15302 143 0 0
sp_payment_common 13774 13774 0 0.00 1 12770 37 0 0
sp_qd_handle_on_cancel_clo 1875 1875 0 0.00 0 6984 290 0 0
sp_qd_handle_on_invoice_upd_sts 11567 11567 0 0.00 0 19261 298 0 0
sp_qd_handle_on_reserve_upd_sts 10541 10541 0 0.00 0 10834 52 0 0
sp_reserve_write_off 10541 10541 0 0.00 6 14627 169 0 0
sp_supplier_invoice 5819 5819 0 0.00 8 86717 3153 0 0
sp_supplier_order 5880 5880 0 0.00 5 27898 1223 0 0
srv_aggregate_perf_data 91 91 0 0.00 3206 480203 26018 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1142 130108 31386 0 0
srv_find_qd_qs_mism 1152372 1152372 0 0.00 0 13408 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 52 29354 1084 0 0
srv_make_money_saldo 833 833 0 0.00 1 927 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 126314 378893 272854 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 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 5261 5261 0 0.00 0 19278 156 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 0 4287 94 0 0
t$perf-norm:sp_cancel_client_order 1875 1875 0 0.00 0 2948 12 0 0
t$perf-norm:sp_cancel_customer_reserve 754 754 0 0.00 0 1779 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 2567 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 482 482 0 0.00 0 4697 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 7272 31 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 28328 1472 0 0
t$perf-norm:sp_cancel_write_off 1067 1067 0 0.00 0 3062 9 0 0
t$perf-norm:sp_client_order 21433 21433 0 0.00 0 9745 18 0 0
t$perf-norm:sp_customer_reserve 1136 1136 0 0.00 0 1399 6 0 0
t$perf-norm:sp_pay_from_customer 7576 7576 0 0.00 0 9298 11 0 0
t$perf-norm:sp_pay_to_supplier 6198 6198 0 0.00 0 6795 11 0 0
t$perf-norm:sp_reserve_write_off 10541 10541 0 0.00 0 7650 11 0 0
t$perf-norm:sp_supplier_invoice 5819 5819 0 0.00 0 7701 17 0 0
t$perf-norm:sp_supplier_order 5880 5880 0 0.00 0 8133 16 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 380 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 312 5 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 713 19 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 2245 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 10766 10494 272 2.52 0 6642 18 0 272
v_all_customers 39626 39626 0 0.00 0 27 1 0 0
v_all_suppliers 32330 32330 0 0.00 0 20 1 0 0
v_all_wares 42866 42866 0 0.00 0 81 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 1016 12 0 0
v_cancel_client_order 3750 3750 0 0.00 0 3199 4 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 1158 4 0 0
v_cancel_customer_reserve 1508 1508 0 0.00 0 2272 8 0 0
v_cancel_payment_to_supplier 964 964 0 0.00 0 1747 10 0 0
v_cancel_supplier_invoice 894 868 26 2.90 0 1709 16 0 26
v_cancel_supplier_order 892 892 0 0.00 0 1927 10 0 0
v_cancel_write_off 2134 2134 0 0.00 0 2304 12 0 0
v_max_id_clo_ord 5877 5877 0 0.00 0 1581 1 0 0
v_max_id_clo_res 1136 1136 0 0.00 0 3391 17 0 0
v_max_id_ord_sup 5810 5810 0 0.00 0 1946 2 0 0
v_max_non_paid_invoice 1720 1720 0 0.00 0 4574 7 0 0
v_max_non_paid_realizn 3890 3890 0 0.00 0 3859 6 0 0
v_min_id_clo_ord 5877 5877 0 0.00 0 2433 5 0 0
v_min_id_clo_res 1136 1136 0 0.00 0 8323 10 0 0
v_min_id_ord_sup 5810 5810 0 0.00 0 3769 5 0 0
v_min_non_paid_invoice 6198 6198 0 0.00 0 5615 20 0 0
v_min_non_paid_realizn 7576 7576 0 0.00 0 10077 22 0 0
v_our_firm 10612 10612 0 0.00 0 25 1 0 0
v_reserve_write_off 21082 21082 0 0.00 0 3007 5 0 0
x_lock_depdocs_on_canc_invoice 12849 12849 0 0.00 0 12889 100 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 7623 301 0 0
x_make_qstorno_1000_1200 5880 5880 0 0.00 2 27889 1145 0 0
x_make_qstorno_1200_2000 5819 5819 0 0.00 3 86403 3032 0 0
x_make_qstorno_2100_3300 489174 489174 0 0.00 0 51175 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-11-2020 19:27:52 to 04-11-2020 19:27:56.

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:02 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:08 23109 8192000000 10295479264 10607546368 916679344 10.063 69 49 98 0 934810592 2628576 15502672
16:57:38 25363 8192000000 10362264880 10680639488 1404198464 14.632 100 80 160 0 1434128256 4666624 25263168
16:58:13 24828 8192000000 10415479872 10745753600 1457408624 15.103 100 84 168 0 1490804400 6276848 27118928
16:58:50 31641 8192000000 10442933296 10777698304 1496635728 15.447 100 90 180 0 1533053808 7631792 28786288
16:59:30 21046 8192000000 10460947968 10796167168 1511090448 15.573 100 90 180 0 1548774928 8643568 29040912
17:00:01 16039 8192000000 10473538816 10810810368 1520175488 15.652 100 90 180 0 1558477168 9389312 28912368
17:00:29 21927 8192000000 10483698768 10823122944 1536263296 15.791 100 89 178 0 1574765936 9902336 28600304
17:01:02 20510 8192000000 10486238128 10831564800 1543140096 15.851 100 86 172 0 1580601680 10254688 27206896
17:01:33 19599 8192000000 10523362704 10874335232 1574982048 16.125 100 79 158 1 1608921072 9737744 24201280
17:02:01 13457 8192000000 10544250656 10898214912 1596019632 16.305 100 81 162 0 1631178880 10561168 24598080
17:02:27 18123 8192000000 10563669296 10923323392 1621779392 16.525 100 76 152 1 1655106448 10743232 22583824
17:02:53 12011 8192000000 10598612176 10961227776 1651645760 16.778 100 88 176 0 1689727712 12094080 25987872
17:03:19 12997 8192000000 10624644960 10993438720 1678016656 17.001 100 79 156 1 1711689680 11699600 21973424
17:03:42 9567 8192000000 10640338112 11012460544 1700607952 17.190 100 77 154 0 1735174912 12483312 22083648
17:03:59 9130 8192000000 10650314416 11025620992 1710332128 17.272 100 72 144 1 1743455680 12102048 21021504
17:04:17 8119 8192000000 10665631040 11040591872 1728811600 17.426 100 80 160 1 1764336864 12827824 22697440
17:04:32 5581 8192000000 10686805568 11058814976 1740692368 17.524 100 81 162 1 1776622848 12439760 23490720
17:04:47 6708 8192000000 10678777024 11065819136 1749702048 17.599 100 66 132 1 1780737616 12197776 18837792
17:05:03 3419 8192000000 10697272896 11079741440 1766098448 17.735 100 71 139 2 1795834048 10446864 19288736
17:05:14 3769 8192000000 10706794752 11094188032 1777285824 17.827 100 70 139 1 1807274208 10990528 18997856
17:05:25 4435 8192000000 10719692192 11104251904 1785324320 17.893 100 72 145 0 1817538688 11895952 20318416
17:05:37 5512 8192000000 10722059936 11110379520 1790297808 17.934 100 68 136 0 1821149488 11465328 19386352
17:05:50 5334 8192000000 10750024832 11131326464 1799184912 18.007 100 71 142 1 1831207904 12423856 19599136
17:06:02 3697 8192000000 10756535872 11142778880 1815128512 18.138 100 85 171 1 1852888160 13441232 24318416
17:06:12 3795 8192000000 10760054864 11144957952 1819101584 18.170 100 86 172 0 1857738432 14121440 24515408
17:06:22 3207 8192000000 10764252688 11151917056 1825250912 18.221 100 83 166 1 1862669424 14097472 23321040
17:06:33 2745 8192000000 10757887536 11151441920 1828318928 18.246 100 78 156 1 1863554656 12964800 22270928
17:06:42 2049 8192000000 10778169584 11164241920 1836404656 18.312 100 87 172 0 1873004448 12742288 23857504
17:06:51 2193 8192000000 10782714880 11170926592 1840305600 18.343 100 89 178 2 1877987616 12693040 24988976
17:06:59 2400 8192000000 10788930896 11177615360 1847035200 18.398 100 92 182 3 1885651072 13140992 25474880
17:07:08 2274 8192000000 10791229456 11178864640 1848756800 18.412 100 93 186 1 1888244288 13175024 26312464
17:07:17 2307 8192000000 10788949888 11181207552 1853680096 18.452 100 91 180 3 1892603600 12750064 26173440
17:07:25 1876 8192000000 10794409744 11183214592 1857006512 18.479 100 90 180 3 1894159520 11928272 25224736
17:07:34 1360 8192000000 10804235824 11190145024 1861058080 18.512 100 88 177 2 1897938032 12034144 24845808
17:07:41 9353 8192000000 10794191184 11191967744 1860860896 18.510 100 61 122 0 1890015888 11568944 17586048
17:07:57 11662 8192000000 10814095328 11206107136 1867459664 18.564 100 81 162 3 1901742256 11225040 23057552
17:08:15 7880 8192000000 10784366896 11200819200 1874394080 18.620 100 84 169 1 1909597712 11195872 24007760
17:08:36 5357 8192000000 10784798032 11200925696 1869892384 18.583 100 42 85 0 1890114144 8125792 12095968
17:08:51 5212 8192000000 10790969392 11210432512 1876467456 18.637 100 46 92 2 1899042800 8914288 13661056
17:09:05 3034 8192000000 10796912544 11212529664 1876306752 18.635 100 43 86 1 1896064128 7879344 11878032
17:09:14 7451 8192000000 10782941184 11213910016 1877976560 18.649 100 29 57 1 1893920256 8401344 7542352
17:09:28 7942 8192000000 10785950656 11210366976 1876856256 18.640 100 24 47 1 1889435232 6280928 6298048
17:09:42 3181 8192000000 10805548128 11222831104 1884053648 18.698 100 39 76 1 1900862592 6389120 10419824
17:09:52 5901 8192000000 10791196816 11221073920 1884849696 18.704 100 30 61 1 1900861408 7402480 8609232
17:10:06 7385 8192000000 10797226752 11226247168 1888787312 18.736 100 27 52 0 1902065584 6187312 7090960
17:10:21 13084 8192000000 10789181808 11224662016 1888066288 18.730 100 16 31 2 1898405280 6039776 4299216
17:10:45 6560 8192000000 10803140944 11236376576 1892049760 18.762 100 26 53 0 1909915792 10659728 7206304
17:10:58 11421 8192000000 10798298688 11232649216 1892980880 18.770 100 14 28 0 1902096752 5824624 3291248
17:11:15 7430 8192000000 10819148656 11243065344 1895188512 18.788 100 30 60 0 1913459808 10256064 8015232
17:11:31 8707 8192000000 10810195616 11236818944 1899219632 18.820 100 35 71 1 1916179120 6845344 10114144
17:11:46 78226 8192000000 10804672848 11248869376 1897860256 18.809 100 27 54 1 1915401872 9652496 7889120
17:13:11 5608 8192000000 10821901872 11252039680 1898563696 18.815 100 19 38 1 1909562320 5450784 5547840
17:13:22 5066 8192000000 10832180256 11260379136 1905851392 18.873 100 43 86 0 1925329152 7976768 11500992
17:13:34 3305 8192000000 10826192336 11256512512 1905030048 18.867 100 30 60 1 1921215168 8160256 8024864
17:13:44 3210 8192000000 10833761440 11260080128 1907587600 18.887 100 39 78 0 1925829520 6877168 11364752
17:13:56 5505 8192000000 10822948832 11259559936 1907977536 18.890 100 27 53 0 1920855552 5588352 7289664
17:14:10 8000 8192000000 10826506192 11260903424 1909440752 18.902 100 24 49 0 1923244960 6813200 6991008
17:14:28 6545 8192000000 10821757520 11256545280 1904250720 18.860 100 21 42 1 1916895328 6524512 6120096
17:14:44 5313 8192000000 10826303312 11257626624 1903828944 18.857 100 20 40 1 1916219504 6220688 6169872
17:14:57 8047 8192000000 10823063136 11258576896 1904751920 18.864 100 18 36 2 1916001120 5777728 5471472
17:15:12 10427 8192000000 10822627488 11257954304 1905650048 18.872 100 23 46 1 1918467840 5441760 7376032
17:15:28 6948 8192000000 10818745216 11256758272 1905805872 18.873 100 16 32 3 1915747984 5481552 4460560
17:15:42 8948 8192000000 10821194288 11254636544 1888870960 18.737 99 26 53 1 1902291088 5684192 7735936
17:15:58 8619 8192000000 10816817600 11249766400 1868447632 18.572 98 17 32 3 1878922816 6265408 4209776
17:16:14 8458 8192000000 10798069296 11232952320 1870112208 18.585 99 17 33 0 1881108592 6146656 4849728
17:16:31 58010 8192000000 10787209136 11218198528 1816905568 18.152 96 29 58 1 1830792032 5842848 8043616
17:17:40 32241 8192000000 10769307440 11190726656 1799944464 18.013 96 24 48 1 1812953616 5874976 7134176
17:18:19 5452 8192000000 10755333568 11182317568 1839444992 18.336 100 20 40 2 1855211968 10455744 5311232
17:18:30 3290 8192000000 10757277552 11180912640 1844696832 18.379 100 37 75 0 1862141392 6384832 11059728
17:18:40 3721 8192000000 10760311056 11176370176 1794556720 17.969 97 38 77 4 1810165504 6030144 9578640
17:18:52 6209 8192000000 10744231024 11166515200 1824841968 18.217 100 33 66 1 1841049856 6608960 9598928
17:19:07 4861 8192000000 10671327152 11073507328 1699861008 17.184 96 31 61 0 1714510096 5515728 9133360
17:19:18 11653 8192000000 10679460032 11091836928 1680816864 17.024 94 20 42 2 1691576896 5068256 5691776
17:19:38 3230 8192000000 10695286512 11105390592 1761034176 17.693 99 39 76 2 1778896864 5767200 12095488
17:19:51 7280 8192000000 10690475008 11106430976 1751438816 17.614 98 32 64 1 1767149984 6268272 9442896
17:20:07 8940 8192000000 10729439632 11148169216 1810297792 18.098 100 36 72 0 1827440544 5892464 11250288
17:20:28 6264 8192000000 10694678000 11100483584 1757203392 17.661 98 30 60 1 1772124768 5376656 9544720
17:20:40 7426 8192000000 10722320320 11138408448 1771136288 17.776 98 27 54 1 1789055680 9895056 8024336
17:20:54 7175 8192000000 10737378832 11148271616 1808271808 18.082 100 17 34 1 1818353984 5244000 4838176
17:21:10 9740 8192000000 10755348096 11169513472 1821359024 18.189 100 17 34 0 1832316736 5406960 5550752
17:21:30 13742 8192000000 10723600832 11139903488 1782512992 17.870 98 23 46 1 1795058576 6413904 6131680
17:21:51 59442 8192000000 10741764112 11162099712 1824759776 18.217 100 32 63 2 1839774224 5372912 9641536
17:22:58 7430 8192000000 10758776480 11183820800 1843958352 18.373 100 29 58 0 1858272048 6665392 7648304
17:23:12 6900 8192000000 10768300304 11187376128 1847065056 18.398 100 41 82 1 1865443952 6998592 11380304
17:23:28 4025 8192000000 10789814368 11201908736 1859275664 18.497 100 41 81 0 1878003232 7086000 11641568
17:23:40 6461 8192000000 10781714880 11202179072 1860004688 18.503 100 35 70 1 1875783968 5971616 9807664
17:23:52 7126 8192000000 10768198528 11198242816 1858897840 18.494 100 23 46 1 1871138416 5198496 7042080
17:24:06 5295 8192000000 10790525776 11202502656 1861649232 18.517 100 28 56 0 1875698880 6145152 7904496
17:24:20 6885 8192000000 10784326416 11211366400 1868794128 18.575 100 22 44 1 1884941664 9725200 6422336
17:24:33 8960 8192000000 10788079056 11215863808 1868456064 18.572 100 16 33 0 1878595184 5614512 4524608
17:24:53 9451 8192000000 10785169424 11217235968 1873951168 18.616 100 24 49 0 1888008400 6848704 7208528
17:25:08 6514 8192000000 10794761968 11222769664 1877876144 18.648 100 28 56 0 1892572752 6538400 8158208
17:25:21 9003 8192000000 10814863840 11231535104 1881993872 18.681 100 37 74 0 1903022752 9685504 11343376
17:25:41 8256 8192000000 10800908384 11231830016 1883005744 18.689 100 27 54 1 1896954192 5875504 8072944
17:25:58 11065 8192000000 10804860400 11235155968 1887726448 18.727 100 16 32 1 1898080864 6041808 4312608
17:26:18 9694 8192000000 10802140064 11237212160 1887446544 18.725 100 14 28 0 1896891392 5669008 3775840
17:26:37 15725 8192000000 10816021120 11243237376 1896567936 18.799 100 27 54 0 1911507072 6058864 8880272
17:28:02 55543 8192000000 10870389024 11292229632 1935151680 19.108 100 42 82 3 1954770800 7097264 12521856
17:29:05 11735 8192000000 10879490464 11301429248 1945688800 19.192 100 43 86 0 1966094432 8923248 11482384
17:29:24 29304 8192000000 10894066064 11316019200 1953074256 19.251 100 48 96 1 1978566832 12384576 13108000
17:30:06 12129 8192000000 10900406480 11327541248 1962465632 19.326 100 48 96 0 1992033104 15788144 13779328
17:30:28 9939 8192000000 10911929824 11337089024 1965235104 19.348 100 39 77 0 1990102768 13963696 10903968
17:30:48 12647 8192000000 10906843632 11337863168 1974165360 19.418 100 46 92 1 2001477680 14130976 13181344
17:31:09 10374 8192000000 10920556752 11342548992 1977601344 19.446 100 48 96 1 2006064624 15007824 13455456
17:31:43 13862 8192000000 10914053296 11347451904 1982057344 19.481 100 36 70 3 2010205392 17373456 10774592
17:32:04 18658 8192000000 10908234368 11339358208 1972079616 19.402 100 46 88 2 2003077936 18566672 12431648
17:32:31 36793 8192000000 10910723616 11358539776 1978950272 19.456 100 36 72 2 2015477328 26151024 10376032
17:33:20 25104 8192000000 10933526704 11369164800 1991824992 19.558 100 37 75 1 2023694912 20946432 10923488
17:33:57 35038 8192000000 10940558992 11383123968 1998954688 19.614 100 39 78 4 2032969280 22084768 11929824
17:34:44 13580 8192000000 10953236480 11391651840 2005624656 19.667 100 40 80 3 2044818496 27095328 12098512
17:35:06 4204 8192000000 10973823328 11393933312 2014924480 19.740 100 54 106 0 2054241632 24182848 15134304
17:35:18 6976 8192000000 10977507760 11404369920 2017909344 19.764 100 60 118 1 2063522064 27698848 17913872
17:35:37 6646 8192000000 10977945376 11408101376 2020816768 19.787 100 61 122 0 2066240656 27819056 17604832
17:35:52 8755 8192000000 10990434192 11412860928 2026340240 19.830 100 68 134 1 2075006176 28882064 19783872
17:36:11 6620 8192000000 10973480352 11404972032 2018623056 19.769 100 57 114 1 2065942448 29626432 17692960
17:36:27 13477 8192000000 10988501584 11415597056 2019712832 19.778 100 63 125 2 2069209584 30353856 19142896
17:36:49 19406 8192000000 10972494560 11408109568 2003331616 19.649 99 62 124 0 2054201664 31880256 18989792
17:37:16 2813 8192000000 10964200816 11389865984 1993096368 19.568 99 58 116 3 2042416576 30377312 18942896
17:37:28 4864 8192000000 10982658224 11409711104 2016215904 19.750 100 69 136 2 2072991440 35908176 20867360
17:37:40 5172 8192000000 10952711296 11370819584 1979662608 19.462 98 62 124 0 2029961344 31020720 19278016
17:37:52 3170 8192000000 10965794432 11389014016 1998268240 19.609 100 70 140 0 2052357216 31991168 22097808
17:38:08 2504 8192000000 10971745952 11383480320 1992910496 19.567 100 82 163 2 2049222464 31167744 25144224
17:38:17 4660 8192000000 10946793152 11372388352 1979894464 19.464 99 71 143 1 2035488272 34646976 20946832
17:38:30 5951 8192000000 10968419680 11396333568 2001101888 19.631 100 70 140 0 2056865360 34833120 20930352
17:38:46 7198 8192000000 10950747632 11372220416 1976286768 19.435 99 70 141 1 2032879424 34596384 21996272
17:39:04 1499 8192000000 10981390160 11398729728 2008245856 19.688 100 89 176 3 2071540720 37235856 26059008
17:39:13 3955 8192000000 10979324816 11391250432 1993750144 19.573 99 76 151 0 2055430272 38107984 23572144
17:39:27 3355 8192000000 10968775088 11391614976 1982600640 19.485 99 71 141 1 2044432096 39900304 21931152
17:39:42 1978 8192000000 10975349280 11398692864 1997747104 19.605 100 80 158 0 2063506432 41018384 24740944
17:39:52 1140 8192000000 10995190752 11408334848 2004397248 19.657 100 80 161 0 2069518256 40478640 24642368
17:40:01 2235 8192000000 10980288432 11399884800 1988982304 19.536 99 82 165 3 2052535136 39415680 24137152
17:40:09 8837 8192000000 10941894256 11372417024 1953812688 19.257 98 64 129 0 2009907872 36939584 19155600
17:40:26 3960 8192000000 10948459760 11371483136 1974862064 19.424 100 68 136 0 2034802656 38790368 21150224
17:40:37 3668 8192000000 10966004608 11385733120 1985684128 19.510 100 82 164 1 2052815920 41901856 25229936
17:40:48 12475 8192000000 10969010320 11387887616 1983478832 19.492 100 71 139 0 2047801920 43262944 21060144
17:41:09 2237 8192000000 10976091904 11391197184 1988762848 19.534 100 84 166 0 2057599008 44144832 24691328
17:41:20 6660 8192000000 10942798672 11362082816 1961550512 19.318 99 73 145 0 2026703552 43364832 21788208
17:41:41 1223 8192000000 10974187552 11381071872 1982762096 19.487 100 90 181 1 2054226832 43899152 27565584
17:41:49 4787 8192000000 10960963888 11379924992 1975053168 19.426 100 76 153 3 2043397424 44948272 23395984
17:42:01 1730 8192000000 10954993600 11365777408 1953586912 19.255 99 85 168 2 2024768592 45152560 26029120
17:42:10 5450 8192000000 10942128032 11362275328 1947557776 19.207 99 75 150 1 2017033392 46169280 23306336
17:42:24 2244 8192000000 10969688832 11380383744 1972801264 19.408 100 86 172 3 2045110688 45715136 26594288
17:42:34 3172 8192000000 10939172560 11352518656 1936424624 19.118 98 69 138 0 2002357120 43798608 22133888
17:42:44 1517 8192000000 10949270000 11365179392 1964898160 19.345 100 86 173 3 2036319264 44609888 26811216
17:42:54 6650 8192000000 10932707200 11347439616 1946943728 19.202 100 72 144 2 2015897664 46361936 22592000
17:43:14 2399 8192000000 10943290752 11358998528 1953196848 19.252 100 80 159 2 2027718768 49109232 25412688
17:43:24 5446 8192000000 10953289680 11369701376 1958741696 19.296 100 83 165 1 2034399280 50394080 25263504
17:43:37 1951 8192000000 10950986384 11365527552 1962158640 19.323 100 75 148 2 2036916304 50625456 24132208
17:43:47 2154 8192000000 10955092032 11362263040 1957424208 19.286 100 85 169 1 2035811472 51923504 26463760
17:43:57 2686 8192000000 10941588416 11363233792 1953897856 19.258 100 75 148 2 2028667232 50339664 24429712
17:44:07 5539 8192000000 10952702880 11373678592 1964302272 19.340 100 70 138 0 2036830848 50838432 21690144
17:44:22 5198 8192000000 10932021440 11347480576 1930242080 19.069 99 60 120 0 2000209312 49911888 20055344
17:44:33 2888 8192000000 10946489024 11358240768 1941718928 19.160 99 74 147 4 2014634656 49370112 23545616
17:44:46 1618 8192000000 10922909968 11327049728 1909513232 18.903 98 88 174 3 1988430000 51343248 27573520
17:44:55 2331 8192000000 10936336032 11347390464 1940497136 19.151 100 69 138 0 2015030672 52142624 22390912
17:45:07 2249 8192000000 10938496096 11347333120 1939079600 19.139 100 73 143 1 2016063344 53007088 23976656
17:45:16 4207 8192000000 10939699664 11357626368 1949986640 19.226 100 71 142 0 2026208768 53451904 22770224
17:45:29 7893 8192000000 10921605632 11354001408 1944584560 19.183 100 53 106 0 2012809152 50968304 17256288
17:45:44 14038 8192000000 10916864192 11350224896 1945743104 19.193 100 36 72 0 2001009152 42834320 12431728
17:46:09 7064 8192000000 10933514160 11366068224 1953316944 19.253 100 40 80 2 2017550384 50573552 13659888
17:46:24 7673 8192000000 10931458704 11356495872 1951048112 19.235 100 52 102 5 2013744528 45850640 16845776
17:46:39 16688 8192000000 10919966704 11357745152 1934506416 19.103 99 40 80 1 1995032272 46736304 13789552
17:47:03 7324 8192000000 10926012208 11353231360 1927152880 19.044 99 45 88 1 1989225920 47622032 14451008
17:47:22 13352 8192000000 10947472592 11372507136 1945097728 19.187 99 56 112 0 2016036496 52836768 18102000
17:47:41 10600 8192000000 10941977264 11373019136 1942818272 19.169 99 42 84 2 2011452384 54673312 13960800
17:48:28 3575 8192000000 10957328192 11359019008 1943827632 19.177 99 86 176 1 2025710128 54579024 27303472
17:48:38 2156 8192000000 10946228944 11363262464 1952868640 19.249 100 79 156 2 2030767520 53975104 23923776
17:48:48 9466 8192000000 10934949520 11363102720 1952208832 19.244 100 46 93 1 2016747696 49328176 15210688
17:49:05 7099 8192000000 10932920688 11367067648 1955996160 19.274 100 48 95 0 2020264896 48953568 15315168
17:49:20 10046 8192000000 10915269728 11344863232 1917913824 18.970 98 34 68 0 1978785136 49243552 11627760
17:49:39 8133 8192000000 10932235920 11370438656 1954881392 19.265 100 46 91 3 2023913280 53994304 15037584
17:50:03 9681 8192000000 10958715872 11388571648 1964840160 19.344 100 48 96 1 2037955456 57442192 15673104
17:50:22 9028 8192000000 10948320688 11384107008 1971742256 19.399 100 47 94 3 2036347280 48856944 15748080
17:50:43 14647 8192000000 10945506640 11380842496 1963502368 19.334 100 35 68 4 2025784432 50125376 12156688
17:51:05 20337 8192000000 10946617664 11391926272 1966034352 19.354 100 33 66 3 2029832752 52286048 11512352
17:51:35 26247 8192000000 10940930928 11388628992 1955544608 19.271 99 33 66 1 2014847328 47680144 11622576
17:52:08 25910 8192000000 10941613920 11383623680 1964001632 19.338 100 29 56 2 2027974432 53871568 10101232
17:52:43 20384 8192000000 10932836112 11386245120 1956143184 19.275 100 26 52 2 2018901216 52730880 10027152
17:53:10 18996 8192000000 10935499936 11391152128 1957381072 19.285 100 24 48 0 2023698320 56775104 9542144
17:53:35 15907 8192000000 10936975760 11394678784 1960620608 19.311 100 24 48 1 2026440448 56666144 9153696
17:53:57 30321 8192000000 10925335008 11380813824 1916828160 18.961 98 23 46 0 1980544848 55979696 7736992
17:55:11 39784 8192000000 10904265296 11367841792 1944172752 19.180 100 13 27 0 1986523424 38249920 4100752
17:56:01 32349 8192000000 10888781296 11356098560 1926134784 19.036 99 11 22 3 1952065920 23212576 2718560
17:56:40 106319 8192000000 10902724656 11363942400 1923022064 19.011 98 8 17 1 1941324352 16442128 1860160
17:58:32 44597 8192000000 10918092224 11362856960 1947910928 19.210 99 19 38 0 1966636784 13647824 5078032
17:59:26 101824 8192000000 10892884192 11370733568 1891373040 18.757 96 22 44 1 1920614464 22617360 6624064
18:01:16 112040 8192000000 10900831120 11359313920 1924689152 19.024 98 10 20 0 1938371040 11314400 2367488
18:03:15 80832 8192000000 10918912240 11356532736 1919216672 18.981 97 26 51 1 1938639360 11932432 7490256
18:04:46 53835 8192000000 10905876608 11364200448 1951002480 19.234 99 28 56 2 1969834400 10565360 8266560
18:06:39 75943 8192000000 10901531904 11371712512 1928365440 19.054 98 19 38 2 1942763216 8659056 5738720
18:08:02 69019 8192000000 10919659264 11366096896 1910501504 18.911 97 28 56 0 1926759920 8565856 7692560
18:09:27 37143 8192000000 10909986800 11372142592 1978741136 19.455 100 57 114 1 2004717680 10163056 15813488
18:10:19 54752 8192000000 10919858240 11381592064 1984303840 19.499 100 34 68 1 2005329152 11107648 9917664
18:11:20 3371 8192000000 10916371408 11377967104 1980548368 19.469 100 27 55 0 1997969904 9912464 7509072
18:12:19 58862 8192000000 10914393280 11380977664 1944552432 19.183 98 19 38 1 1962922640 12759712 5610496
18:13:46 17587 8192000000 10922568336 11361312768 1931619936 19.080 98 40 80 2 1960718592 16903680 12194976
18:14:14 34371 8192000000 10910614208 11377041408 1976008032 19.433 100 46 92 2 2001817248 12809600 12999616
18:14:58 58745 8192000000 10896521296 11382546432 1929678112 19.064 98 21 40 1 1950280880 14983360 5619408
18:17:21 36679 8192000000 10879659040 11352469504 1927188896 19.044 98 15 28 1 1937582176 6444624 3948656
18:18:11 29237 8192000000 10899864128 11364102144 1965172304 19.347 100 10 21 1 1973985248 6126416 2686528
18:18:51 20821 8192000000 10881125824 11356983296 1931734752 19.081 98 11 22 0 1945285632 10954704 2596176
18:19:22 54467 8192000000 10872902272 11345141760 1913506448 18.935 98 20 41 0 1925474912 6306112 5662352
18:20:28 103078 8192000000 10863734912 11347832832 1891438592 18.757 97 19 38 0 1914525520 17530608 5556320
18:22:28 61336 8192000000 10838691632 11314892800 1845307056 18.384 95 17 33 1 1857271072 7463040 4500976
18:23:37 19407 8192000000 10871407728 11335671808 1940699520 19.152 100 20 40 3 1955046144 8724016 5622608
18:24:04 28097 8192000000 10862232448 11338268672 1926972256 19.043 99 19 38 1 1945381024 12817792 5590976
18:24:43 54759 8192000000 10853485888 11335389184 1885219168 18.707 97 7 14 0 1901226496 14185104 1822224
18:25:44 63264 8192000000 10863557040 11336224768 1898805440 18.817 98 15 30 2 1913391824 10420160 4166224
18:26:53 35157 8192000000 10867799584 11338899456 1939125680 19.140 100 21 42 1 1960258096 15566240 5566176
18:27:36 19297 8192000000 10876811232 11318767616 1890979472 18.754 97 28 54 2 1904550992 5521440 8050080
18:28:04 30674 8192000000 10872898432 11330961408 1891481600 18.758 97 27 54 1 1905140880 6999776 6659504
18:28:47 43850 8192000000 10868063824 11334516736 1889660192 18.743 97 21 42 2 1909680160 14409392 5610576
18:29:38 54197 8192000000 10868998112 11323559936 1861855936 18.518 96 16 32 0 1886052336 19494512 4701888
18:30:48 44639 8192000000 10862213136 11324604416 1849709840 18.420 95 28 55 2 1873833968 15628656 8495472
18:31:42 45724 8192000000 10881851616 11339116544 1893301456 18.772 98 22 44 3 1914555168 14309552 6944160
18:33:05 52429 8192000000 10862646432 11352539136 1918258080 18.973 99 12 24 1 1946800176 24733472 3808624
18:34:03 53465 8192000000 10897388816 11356180480 1894149664 18.779 97 29 58 0 1917751792 15626816 7975312
18:35:09 73001 8192000000 10862335968 11328221184 1879454848 18.661 97 17 34 0 1902626640 18189072 4982720
18:36:28 88548 8192000000 10889133712 11347587072 1874458624 18.620 96 28 56 1 1893413200 11844928 7109648
18:38:03 31057 8192000000 10905282688 11354742784 1930843056 19.074 99 48 94 2 1960119488 16054624 13221808
18:38:45 51923 8192000000 10869859600 11350261760 1924752144 19.025 99 22 44 1 1944609648 14025312 5832192
18:40:04 88482 8192000000 10867680208 11334905856 1911005632 18.915 98 18 36 0 1924149552 8211216 4932704
18:41:44 60660 8192000000 10897108096 11357990912 1919282096 18.981 98 34 68 2 1937097200 8259712 9555392
18:43:09 42348 8192000000 10895653792 11371880448 1958417632 19.293 100 24 48 1 1980093008 14629296 7046080
18:44:01 42882 8192000000 10894797616 11371638784 1967686096 19.367 100 25 49 3 1988004256 12357136 7961024
18:45:01 59815 8192000000 10900036464 11369091072 1967322928 19.364 100 21 43 1 1989986064 17069344 5593792
18:46:07 31676 8192000000 10904416848 11375038464 1971723872 19.399 100 15 30 1 1991658800 15110736 4824192
18:46:51 43411 8192000000 10903160048 11380207616 1939495008 19.143 98 23 46 1 1961923184 15390096 7038080
18:47:41 44276 8192000000 10888754720 11374698496 1962837760 19.329 100 7 14 0 1979916048 14773888 2304400
18:48:31 54047 8192000000 10893766112 11364581376 1949913808 19.226 99 12 24 0 1964047888 10225216 3908864
18:49:34 52061 8192000000 10877358576 11362553856 1943163328 19.172 99 13 26 0 1957999280 11325552 3510400
18:50:32 73023 8192000000 10883815504 11375833088 1926447840 19.038 98 13 26 0 1942351680 12433936 3469904
18:51:53 61026 8192000000 10860210368 11342176256 1891368736 18.757 96 20 40 0 1905466048 8667568 5429744
18:53:01 46614 8192000000 10888780240 11366146048 1960232656 19.308 100 28 55 1 1976307936 8572208 7503072
18:54:05 36167 8192000000 10888866624 11356082176 1929476016 19.063 98 33 66 2 1948755904 9099488 10180400
18:54:52 79166 8192000000 10885450464 11382353920 1921475024 18.999 98 14 28 2 1935457232 10076928 3905280
18:56:19 37368 8192000000 10914000672 11368574976 1947552816 19.207 99 15 31 0 1963166048 11716528 3896704
18:57:19 31617 8192000000 10907899840 11356598272 1914668256 18.944 97 40 80 3 1935267904 9526816 11072832
18:57:58 6349 8192000000 10911376832 11360436224 1967158384 19.363 100 65 131 0 1996041248 10361680 18521184
18:58:12 23807 8192000000 10918458464 11368325120 1951477760 19.238 99 46 91 2 1975880192 11736320 12666112
18:58:42 54898 8192000000 10912558848 11378315264 1907852464 18.889 97 34 68 1 1928321552 11992752 8476336
19:00:26 125280 8192000000 10894003792 11362902016 1869304848 18.579 95 11 22 0 1893131936 21203632 2623456
19:02:53 26083 8192000000 10915451552 11378442240 1971449184 19.397 100 41 82 0 1998357584 15502800 11405600
19:03:26 66256 8192000000 10900984704 11372908544 1930628976 19.072 98 20 40 0 1949770032 13785504 5355552
19:04:42 68426 8192000000 10862830176 11334012928 1868167424 18.569 95 22 44 1 1884941552 10184928 6589200
19:06:07 130108 8192000000 10881430464 11347800064 1868388768 18.571 96 23 45 1 1883058288 8356832 6312688
19:08:24 10038 8192000000 10873797152 11343085568 1943089312 19.171 100 28 56 0 1963079376 12286832 7703232
19:08:42 39346 8192000000 10868102784 11343491072 1930193312 19.068 99 17 34 1 1941529552 7169424 4166816
19:09:28 54959 8192000000 10877465824 11359477760 1938477712 19.135 99 9 18 0 1948351168 7254288 2619168
19:10:41 34890 8192000000 10853188304 11331629056 1913490688 18.935 98 14 30 1 1926025520 8274784 4260048
19:11:22 72488 8192000000 10826573200 11288993792 1825150688 18.220 94 14 28 1 1837447136 8093872 4202576
19:12:47 66377 8192000000 10851961632 11327422464 1907815728 18.889 99 14 28 1 1923871120 11869680 4185712
19:14:43 67820 8192000000 10833670496 11307712512 1866482944 18.556 97 16 32 0 1884269776 12989456 4797376
19:15:58 54447 8192000000 10861519056 11328884736 1908529216 18.895 99 20 40 1 1930374208 16528752 5316240
19:17:04 73417 8192000000 10870468336 11333611520 1891164704 18.755 98 16 32 0 1908599808 13004864 4430240
19:18:33 63436 8192000000 10852279296 11314991104 1879621520 18.662 97 20 40 0 1897890592 12222848 6046224
19:19:43 76688 8192000000 10874395904 11352416256 1940611168 19.152 100 16 32 3 1960636592 15327088 4698336
19:21:11 56178 8192000000 10894368784 11361062912 1948935744 19.218 100 26 52 1 1971810608 14940016 7934848
19:22:15 69024 8192000000 10890691280 11358633984 1937616704 19.128 99 20 40 4 1954052944 11144784 5291456
19:23:32 26288 8192000000 10917025072 11373826048 1970412624 19.389 100 30 60 1 1987860160 9361088 8086448
19:24:13 46723 8192000000 10908983968 11362787328 1911510784 18.919 97 20 40 0 1928767872 11771712 5485376
19:25:07 60942 8192000000 10901659056 11380756480 1938934512 19.138 99 18 36 1 1958982352 15341856 4705984
19:26:14 53325 8192000000 8924368096 9258856448 5226624 0.063 1 1 2 0 5350784 62032 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 04-11-2020 19:27:57 to 04-11-2020 19:28:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 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 04-11-2020 19:28:30 to 04-11-2020 19:28: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          251410
MON$OLDEST_ACTIVE               251411
MON$OLDEST_SNAPSHOT             251411
MON$NEXT_TRANSACTION            251411
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                       2066080
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33385 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33385 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33385 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33385 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'

04.11.20 19:28: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-11-04 19:28:35 No severe PSQL-related problems occured
04.11.20 19:28:37. End of report.