Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.02.2021 16:32
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 17397964 kB
MemAvailable 31195564 kB
Buffers 0 kB
Cached 14284804 kB
SwapCached 4876 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 2021-02-06 16:32:09
DTS_END                         2021-02-06 16:32:09.1250
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_CLIENT_ORDER(32:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36672
TRN_ID                          239144
ATT_ID                          640
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: 9026.28 21941 1083154
customer order: creation 174.80 377 20976
customer order: refuse 14.72 363 1766
order to supplier: creation 46.43 1267 5571
order to supplier: removal 3.34 95487 401
invoice (draft): creation 46.88 3519 5626
invoice (draft): removal 51.33 746 6159
invoice accept: apply 42.15 18601 5058
invoice accept: cancel 46.22 829 5546
customer reserve: creation 3819.42 189 458330
customer reserve: removal 4471.63 56 536596
realization accept: apply 86.19 208 10343
realization accept: cancel 91.43 119 10972
payment from customer: creation 59.83 116 7179
payment from customer: removal 5.63 80 675
payment to supplier: creation 50.70 129 6084
payment to supplier: removal 3.38 79 406
service: total inventory turnovers 4.86 964 583
service: total monetary turnovers 6.49 34 779
service: aggregate perf. data 0.83 22112 100
service: refresh index statistics 0.03 293544 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-02-2021 16:33:04 to 06-02-2021 16:33:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7243
TEST_TIME 2 6083
TEST_TIME 3 5374
TEST_TIME 4 7675
TEST_TIME 5 6890
TEST_TIME 6 6612
TEST_TIME 7 6598
TEST_TIME 8 6402
TEST_TIME 9 6237
TEST_TIME 10 6283
TEST_TIME 11 6126
TEST_TIME 12 6262
TEST_TIME 13 6402
TEST_TIME 14 6487
TEST_TIME 15 6627
TEST_TIME 16 6622
TEST_TIME 17 6678
TEST_TIME 18 7298
TEST_TIME 19 7457
TEST_TIME 20 7977
TEST_TIME 21 8168
TEST_TIME 22 8227
TEST_TIME 23 8401
TEST_TIME 24 8764
TEST_TIME 25 8852
TEST_TIME 26 9839
TEST_TIME 27 10116
TEST_TIME 28 9879
TEST_TIME 29 9745
TEST_TIME 30 9794
TEST_TIME 31 9629
TEST_TIME 32 9477
TEST_TIME 33 9470
TEST_TIME 34 9531
TEST_TIME 35 9550
TEST_TIME 36 9418
TEST_TIME 37 9318
TEST_TIME 38 9253
TEST_TIME 39 9123
TEST_TIME 40 8987
TEST_TIME 41 9110
TEST_TIME 42 9011
TEST_TIME 43 9085
TEST_TIME 44 9104
TEST_TIME 45 9200
TEST_TIME 46 9292
TEST_TIME 47 9317
TEST_TIME 48 9269
TEST_TIME 49 9228
TEST_TIME 50 9175
TEST_TIME 51 9238
TEST_TIME 52 9216
TEST_TIME 53 9244
TEST_TIME 54 9272
TEST_TIME 55 9158
TEST_TIME 56 9113
TEST_TIME 57 9072
TEST_TIME 58 8974
TEST_TIME 59 8916
TEST_TIME 60 8996
TEST_TIME 61 8968
TEST_TIME 62 8947
TEST_TIME 63 8858
TEST_TIME 64 8838
TEST_TIME 65 8773
TEST_TIME 66 8880
TEST_TIME 67 8906
TEST_TIME 68 8891
TEST_TIME 69 8890
TEST_TIME 70 8972
TEST_TIME 71 8969
TEST_TIME 72 9007
TEST_TIME 73 8953
TEST_TIME 74 9066
TEST_TIME 75 9192
TEST_TIME 76 9251
TEST_TIME 77 9281
TEST_TIME 78 9322
TEST_TIME 79 9247
TEST_TIME 80 9196
TEST_TIME 81 9220
TEST_TIME 82 9176
TEST_TIME 83 9168
TEST_TIME 84 9118
TEST_TIME 85 9099
TEST_TIME 86 9086
TEST_TIME 87 9020
TEST_TIME 88 9028
TEST_TIME 89 9038
TEST_TIME 90 9100
TEST_TIME 91 9079
TEST_TIME 92 9095
TEST_TIME 93 9144
TEST_TIME 94 9158
TEST_TIME 95 9141
TEST_TIME 96 9235
TEST_TIME 97 9191
TEST_TIME 98 9166
TEST_TIME 99 9160
TEST_TIME 100 9210
TEST_TIME 101 9243
TEST_TIME 102 9225
TEST_TIME 103 9189
TEST_TIME 104 9139
TEST_TIME 105 9101
TEST_TIME 106 9095
TEST_TIME 107 9129
TEST_TIME 108 9099
TEST_TIME 109 9049
TEST_TIME 110 9042
TEST_TIME 111 9029
TEST_TIME 112 9007
TEST_TIME 113 8983
TEST_TIME 114 8966
TEST_TIME 115 8994
TEST_TIME 116 8993
TEST_TIME 117 9051
TEST_TIME 118 9084
TEST_TIME 119 9098
TEST_TIME 120 9031

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-02-2021 16:33:08 to 06-02-2021 16:33:11.

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 1507652 1507652 0 0.00 0 24622 7 0 0
doc_list_biud 1507651 1507651 0 0.00 0 42265 26 0 0
sp_add_invoice_to_stock 5164 5058 106 2.05 31 198889 18601 0 106
sp_cancel_adding_invoice 5546 5546 0 0.00 5 116888 830 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 13425 363 0 0
sp_cancel_customer_reserve 536596 536596 0 0.00 1 38372 57 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 4525 81 0 0
sp_cancel_pay_to_supplier 406 406 0 0.00 3 8802 80 0 0
sp_cancel_supplier_invoice 6164 6159 5 0.08 1 16704 747 0 5
sp_cancel_supplier_order 401 401 0 0.00 9 1021827 95488 0 0
sp_cancel_write_off 10972 10972 0 0.00 1 12843 119 0 0
sp_client_order 20976 20976 0 0.00 3 31750 378 0 0
sp_customer_reserve 458330 458330 0 0.00 0 107769 189 0 0
sp_fill_shopping_cart 32161 32161 0 0.00 1 12688 39 0 0
sp_fill_shopping_cart_clo_res 458326 458326 0 0.00 0 13696 14 0 0
sp_get_clo_for_invoice 5049 5049 0 0.00 0 32731 260 0 0
sp_kill_cost_storno 17599 17599 0 0.00 0 7956 53 0 0
sp_kill_qstorno_ret_qs2qd 1090724 1090724 0 0.00 0 38348 31 0 0
sp_kill_qty_storno 576831 576831 0 0.00 0 42260 67 0 0
sp_lock_selected_doc 21255 21255 0 0.00 0 8995 8 0 0
sp_make_cost_storno 28654 28654 0 0.00 0 23866 54 0 0
sp_multiply_rows_for_pdistr 28654 28654 0 0.00 0 9458 29 0 0
sp_multiply_rows_for_qdistr 20976 20976 0 0.00 0 14682 178 0 0
sp_pay_from_customer 7179 7179 0 0.00 4 12588 117 0 0
sp_pay_to_supplier 6084 6084 0 0.00 4 24230 129 0 0
sp_payment_common 13263 13263 0 0.00 1 9244 26 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 13377 332 0 0
sp_qd_handle_on_invoice_upd_sts 10594 10594 0 0.00 0 42254 323 0 0
sp_qd_handle_on_reserve_upd_sts 10343 10343 0 0.00 0 15833 69 0 0
sp_reserve_write_off 10343 10343 0 0.00 7 22584 209 0 0
sp_supplier_invoice 5626 5626 0 0.00 6 85717 3520 0 0
sp_supplier_order 5571 5571 0 0.00 5 67202 1268 0 0
srv_aggregate_perf_data 100 100 0 0.00 3029 436260 22113 0 0
srv_fill_mon_cache_memory 162 162 0 0.00 1518 135417 32987 0 0
srv_find_qd_qs_mism 1035076 1035076 0 0.00 0 24621 6 0 0
srv_make_invnt_saldo 583 583 0 0.00 33 26535 965 0 0
srv_make_money_saldo 779 779 0 0.00 1 7718 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 163740 399437 293545 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5058 5058 0 0.00 0 15409 167 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 3912 102 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 1480 10 0 0
t$perf-norm:sp_cancel_customer_reserve 747 747 0 0.00 0 1492 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 546 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 406 406 0 0.00 0 3770 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 450 450 0 0.00 0 2331 23 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 28589 1596 0 0
t$perf-norm:sp_cancel_write_off 983 983 0 0.00 0 1654 9 0 0
t$perf-norm:sp_client_order 20976 20976 0 0.00 0 12935 18 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 2677 6 0 0
t$perf-norm:sp_pay_from_customer 7179 7179 0 0.00 0 9327 12 0 0
t$perf-norm:sp_pay_to_supplier 6084 6084 0 0.00 0 5377 11 0 0
t$perf-norm:sp_reserve_write_off 10343 10343 0 0.00 0 4240 10 0 0
t$perf-norm:sp_supplier_invoice 5626 5626 0 0.00 0 10368 22 0 0
t$perf-norm:sp_supplier_order 5571 5571 0 0.00 0 9486 20 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 164 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 489 10 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 641 14 0 0
t$perf-norm:srv_make_money_saldo 779 779 0 0.00 0 2616 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 33 11 0 0
v_add_invoice_to_stock 10308 10096 212 2.05 0 25183 25 0 212
v_all_customers 38212 38212 0 0.00 0 54 1 0 0
v_all_suppliers 31212 31212 0 0.00 0 28 1 0 0
v_all_wares 41946 41946 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 806 8 0 0
v_cancel_client_order 3532 3532 0 0.00 0 9340 6 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 1255 7 0 0
v_cancel_customer_reserve 1494 1494 0 0.00 0 22683 26 0 0
v_cancel_payment_to_supplier 812 812 0 0.00 0 350 4 0 0
v_cancel_supplier_invoice 910 900 10 1.09 0 4117 22 0 10
v_cancel_supplier_order 802 802 0 0.00 0 5100 11 0 0
v_cancel_write_off 1966 1966 0 0.00 0 8525 19 0 0
v_max_id_clo_ord 5570 5570 0 0.00 0 612 1 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 3336 20 0 0
v_max_id_ord_sup 5618 5618 0 0.00 0 8063 5 0 0
v_max_non_paid_invoice 1666 1666 0 0.00 0 5539 7 0 0
v_max_non_paid_realizn 3830 3830 0 0.00 0 1011 3 0 0
v_min_id_clo_ord 5570 5570 0 0.00 0 8170 13 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 7986 20 0 0
v_min_id_ord_sup 5618 5618 0 0.00 0 6175 11 0 0
v_min_non_paid_invoice 6084 6084 0 0.00 0 6389 13 0 0
v_min_non_paid_realizn 7179 7179 0 0.00 0 8973 19 0 0
v_our_firm 10432 10432 0 0.00 0 13 1 0 0
v_reserve_write_off 20686 20686 0 0.00 0 22554 10 0 0
x_lock_depdocs_on_canc_invoice 11255 11255 0 0.00 0 11983 111 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 25715 377 0 0
x_make_qstorno_1000_1200 5571 5571 0 0.00 2 67196 1182 0 0
x_make_qstorno_1200_2000 5626 5626 0 0.00 2 79913 3379 0 0
x_make_qstorno_2100_3300 458329 458329 0 0.00 0 107685 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-02-2021 16:33:12 to 06-02-2021 16:33:16.

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
14:02:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:19 6146 8192000000 10031982896 10301956096 812379840 9.022 66 52 109 0 831989168 2152096 17457232
14:02:34 35835 8192000000 10343236752 10655969280 1363330448 14.267 100 78 156 0 1393261168 4610192 25320528
14:03:27 37587 8192000000 10386396208 10708090880 1430830432 14.869 100 95 188 2 1468760656 6916384 31013840
14:04:24 26553 8192000000 10407426512 10734469120 1459334864 15.120 100 93 186 2 1498413392 8534704 30543824
14:04:59 23828 8192000000 10433498256 10764271616 1476787296 15.273 100 86 172 1 1514381216 9439984 28153936
14:05:37 19803 8192000000 10451127440 10787340288 1505244320 15.522 100 90 180 1 1544323488 10383632 28695536
14:06:13 15322 8192000000 10467974528 10806771712 1524352096 15.688 100 87 175 0 1562066000 10440800 27273104
14:06:40 12329 8192000000 10489751376 10832248832 1545625536 15.872 100 84 167 2 1582909952 11159712 26124704
14:07:08 9827 8192000000 10494458560 10841575424 1552722912 15.933 100 79 158 0 1588773312 11535904 24514496
14:07:32 14896 8192000000 10513890976 10868801536 1574757296 16.123 100 77 154 0 1609376848 11143040 23476512
14:07:55 11107 8192000000 10551158480 10908499968 1599285344 16.333 100 76 151 1 1633596864 11495456 22816064
14:08:13 9013 8192000000 10566791504 10924343296 1625703856 16.558 100 81 161 1 1662166976 12362624 24100496
14:08:31 12851 8192000000 10585880304 10950770688 1646580416 16.735 100 82 164 2 1683458096 12249008 24628672
14:08:52 9308 8192000000 10617244736 10981322752 1674681264 16.973 100 83 166 1 1711478832 12564272 24233296
14:09:10 10295 8192000000 10626868752 11000549376 1694899216 17.142 100 79 157 2 1730136896 12749376 22488304
14:09:27 6924 8192000000 10654093360 11023745024 1714547680 17.307 100 83 166 1 1751535184 12763024 24224480
14:09:41 7329 8192000000 10660689536 11036422144 1725014128 17.394 100 67 129 1 1753569184 10671136 17883920
14:09:56 5267 8192000000 10679573872 11058040832 1747836480 17.584 100 78 156 2 1782342128 11878224 22627424
14:10:09 6441 8192000000 10696578272 11070828544 1757162416 17.661 100 75 149 1 1789783152 12137952 20482784
14:10:22 5073 8192000000 10707853424 11086385152 1772935136 17.791 100 91 177 2 1809929712 12468656 24525920
14:10:34 5383 8192000000 10712440576 11090960384 1777410624 17.828 100 79 157 0 1812187840 12997328 21779888
14:10:46 5619 8192000000 10724252384 11102720000 1783739808 17.880 100 83 164 2 1820664144 13825696 23098640
14:11:00 5943 8192000000 10732485184 11113783296 1793608704 17.961 100 78 156 0 1827897696 12591584 21697408
14:11:12 2980 8192000000 10739958720 11121594368 1804123744 18.048 100 81 158 0 1839850176 12918784 22807648
14:11:22 4389 8192000000 10745891472 11129614336 1807697888 18.077 100 88 172 0 1844769392 13175712 23895792
14:11:33 8797 8192000000 10752296976 11136061440 1808813824 18.086 100 80 160 2 1844645472 13940336 21891312
14:11:52 5908 8192000000 10752507616 11136503808 1811472480 18.108 100 75 150 1 1845814000 13764752 20576768
14:12:04 2825 8192000000 10777093360 11162697728 1831621408 18.273 100 80 158 3 1866862896 13892784 21348704
14:12:13 1898 8192000000 10786501728 11170541568 1841700496 18.355 100 92 182 1 1881266384 14056416 25509472
14:12:22 2882 8192000000 10786515696 11172581376 1842910352 18.364 100 86 171 2 1881275536 14387824 23977360
14:12:32 2238 8192000000 10790638288 11175800832 1846655200 18.395 100 90 181 0 1885732272 14648800 24428272
14:12:41 1489 8192000000 10797386672 11179433984 1852821248 18.445 100 97 192 0 1894127232 14392800 26913184
14:12:49 2084 8192000000 10796763248 11184934912 1852374864 18.441 100 93 186 1 1893675552 15336208 25964480
14:12:57 2186 8192000000 10800299840 11187027968 1855200800 18.464 100 83 163 0 1892608752 13942032 23465920
14:13:06 1663 8192000000 10803977584 11192221696 1859618160 18.500 100 91 184 1 1899021584 13412976 25990448
14:13:14 1498 8192000000 10808845280 11193733120 1861200096 18.513 100 90 178 1 1900107488 12513184 26394208
14:13:22 1666 8192000000 10809219680 11195514880 1866811024 18.558 100 96 191 1 1908010080 13449680 27749376
14:13:30 1832 8192000000 10814455584 11202678784 1871002352 18.592 100 95 190 3 1911441504 13377408 27061744
14:13:38 1557 8192000000 10817652576 11205865472 1873594288 18.613 100 92 181 2 1912107248 12072224 26440736
14:13:46 1990 8192000000 10813954448 11203710976 1872394976 18.604 100 86 171 1 1908707776 11634416 24678384
14:13:54 24906 8192000000 10809295680 11208699904 1872399360 18.604 100 66 130 2 1901266480 10585040 18282080
14:14:25 13568 8192000000 10819499440 11212783616 1880730912 18.671 100 78 154 1 1914590400 12723472 21136016
14:14:45 1807 8192000000 10821953152 11217276928 1886727920 18.719 100 95 190 3 1925643376 12320944 26594512
14:14:54 3881 8192000000 10831923936 11223502848 1883881216 18.696 100 83 166 2 1921121840 13798688 23441936
14:15:04 18961 8192000000 10805812000 11216551936 1880831936 18.672 100 51 102 4 1904897136 10268480 13796720
14:15:31 9220 8192000000 10779004112 11211816960 1877266864 18.643 100 29 57 1 1896337504 11623712 7446928
14:15:47 6362 8192000000 10794951808 11220406272 1879488832 18.661 100 36 71 0 1901136336 11657216 9990288
14:16:06 7599 8192000000 10789452320 11216936960 1881496752 18.677 100 22 45 0 1893654192 6120800 6036640
14:16:25 10839 8192000000 10788361360 11221508096 1883710768 18.695 100 24 47 1 1896771856 6108016 6953072
14:16:42 13699 8192000000 10797349392 11227467776 1884982304 18.705 100 19 38 2 1896217648 5763728 5471616
14:17:07 4994 8192000000 10794175392 11227942912 1889422448 18.741 100 19 38 1 1901453760 6532672 5498640
14:17:19 6181 8192000000 10794557696 11228663808 1890134000 18.747 100 21 42 3 1902238496 6371280 5733216
14:17:32 9157 8192000000 10799278816 11232337920 1895943712 18.794 100 24 48 1 1909199184 6985296 6270176
14:17:48 8251 8192000000 10802436784 11232477184 1895768464 18.792 100 23 46 0 1908996480 5632656 7595360
14:18:05 7692 8192000000 10808803792 11237625856 1896032928 18.794 100 29 56 2 1911082944 6774832 8275184
14:18:19 8613 8192000000 10804860240 11237576704 1897407232 18.805 100 14 24 2 1906754720 5277840 4069648
14:18:36 5535 8192000000 10797816416 11236319232 1898657824 18.815 100 14 28 0 1907270000 4865088 3747088
14:18:49 12012 8192000000 10807386160 11243687936 1903832512 18.857 100 12 24 1 1916901280 10090864 2977904
14:19:11 31362 8192000000 10813553520 11257421824 1908971440 18.898 100 22 44 0 1920663440 5719744 5972256
14:20:24 33843 8192000000 10814128080 11250745344 1869512400 18.580 98 17 34 0 1880047920 5678944 4856576
14:21:06 5369 8192000000 10817436240 11249963008 1900709472 18.832 100 35 69 1 1918734768 8100512 9924784
14:21:17 5094 8192000000 10834461120 11264262144 1906548960 18.879 100 37 74 1 1927332368 11155120 9628288
14:21:30 7811 8192000000 10823798672 11257831424 1906253328 18.877 100 25 50 0 1918644288 5554464 6836496
14:21:45 5910 8192000000 10826845760 11256799232 1912227088 18.925 100 35 70 1 1929500080 5752592 11520400
14:22:00 7854 8192000000 10804315568 11240845312 1866402336 18.555 98 19 36 1 1877791920 5698448 5691136
14:22:19 6415 8192000000 10797005152 11232010240 1872376992 18.604 99 19 38 1 1883715120 5953920 5384208
14:22:31 5197 8192000000 10784605792 11211898880 1844006704 18.373 98 25 46 1 1856394464 5977424 6410336
14:22:43 8925 8192000000 10783150160 11206619136 1840272512 18.343 98 18 34 3 1850591888 5634320 4685056
14:22:59 9896 8192000000 10786740944 11216179200 1854184912 18.456 99 19 38 0 1865145072 5700048 5260112
14:23:16 10134 8192000000 10775553600 11200176128 1822427344 18.198 98 13 26 0 1831513744 5197504 3888896
14:23:32 7702 8192000000 10778980688 11209736192 1864796960 18.542 100 23 46 0 1877924320 6600528 6526832
14:23:52 14650 8192000000 10750376208 11182555136 1790551856 17.936 96 20 39 1 1801696864 5603856 5541152
14:24:16 8394 8192000000 10749237056 11168268288 1793520544 17.961 98 21 40 3 1805131776 5841936 5769296
14:24:30 70274 8192000000 10760328000 11183554560 1788382752 17.918 96 36 72 0 1805095536 6305168 10407616
14:25:47 8494 8192000000 10738882352 11154075648 1801964288 18.030 98 24 48 1 1815388752 6321920 7102544
14:26:04 5702 8192000000 10734877872 11143163904 1785194848 17.892 99 33 67 2 1801286160 6585888 9505424
14:26:16 4837 8192000000 10744274448 11155927040 1811209904 18.106 100 46 92 2 1831281152 7630240 12441008
14:26:28 3999 8192000000 10722072800 11139952640 1794803920 17.971 99 28 56 1 1809719392 6768480 8146992
14:26:38 8828 8192000000 10687642848 11089215488 1684535264 17.055 94 22 44 0 1697005184 5637248 6832672
14:26:54 5648 8192000000 10699204928 11112374272 1751740608 17.616 98 26 52 4 1769858080 11142752 6974720
14:27:07 7805 8192000000 10710452432 11128025088 1779104896 17.842 99 27 54 1 1796924512 9844096 7975520
14:27:22 6770 8192000000 10715738128 11133448192 1756611808 17.656 97 25 50 0 1769465968 5644448 7209712
14:27:36 5386 8192000000 10729625136 11146190848 1792162944 17.950 99 21 40 1 1803544672 5316816 6064912
14:27:48 6627 8192000000 10742081056 11151003648 1793429200 17.960 99 40 79 1 1814851584 10455344 10967040
14:28:02 7146 8192000000 10731794544 11150241792 1813769856 18.127 100 26 52 0 1826980384 5043232 8167296
14:28:16 10907 8192000000 10734483744 11151290368 1784349760 17.885 98 32 64 1 1799501968 5009168 10143040
14:28:35 9839 8192000000 10745947856 11169755136 1825612528 18.224 100 30 60 2 1843501088 9496496 8392064
14:28:51 8935 8192000000 10745385600 11171721216 1833288512 18.286 100 20 40 1 1844707888 5174784 6244592
14:29:10 55878 8192000000 10763262800 11176800256 1822026368 18.194 99 31 62 1 1836528048 4382016 10119664
14:30:31 26134 8192000000 10750123296 11183484928 1844411120 18.377 100 23 46 0 1856927328 6378784 6137424
14:31:04 14644 8192000000 10764871664 11185631232 1851573024 18.435 100 28 57 2 1865099600 4834864 8691712
14:31:25 6893 8192000000 10782872496 11197026304 1857660448 18.484 100 42 84 1 1876611904 6704704 12246752
14:31:38 9545 8192000000 10766061312 11193913344 1857143920 18.480 100 39 78 2 1875086592 5863456 12079216
14:31:55 7402 8192000000 10770157264 11198275584 1858450240 18.491 100 34 67 0 1874412960 5956848 10005872
14:32:09 10049 8192000000 10797330832 11213254656 1872339920 18.603 100 25 50 0 1884425760 5014624 7071216
14:32:32 13902 8192000000 10814482048 11230429184 1885026816 18.706 100 44 87 3 1903859824 6221936 12611072
14:32:55 6160 8192000000 10835994448 11245887488 1898489024 18.814 100 63 122 2 1925762304 9850976 17422304
14:33:09 8811 8192000000 10843264896 11254501376 1904510512 18.863 100 63 126 2 1932317552 9928416 17878624
14:33:39 11358 8192000000 10847640784 11258019840 1913012144 18.931 100 58 114 2 1938302512 9847376 15442992
14:33:58 14350 8192000000 10857803968 11269324800 1914120624 18.940 100 56 110 2 1942286912 12783296 15382992
14:34:19 16454 8192000000 10858059120 11275993088 1923228864 19.013 100 62 124 2 1954864560 13243728 18391968
14:34:43 82623 8192000000 10864017072 11289440256 1929701120 19.064 100 50 100 0 1957443088 13415664 14326304
14:36:15 27163 8192000000 10863426720 11300954112 1930700848 19.072 100 38 76 2 1958210528 16350592 11159088
14:36:50 2790 8192000000 10881545088 11305459712 1944231504 19.181 100 62 126 1 1973421200 9539696 19650000
14:37:02 15821 8192000000 10890674192 11311726592 1947880736 19.210 100 60 120 3 1975683936 11584352 16218848
14:37:26 5188 8192000000 10901392704 11318816768 1951241248 19.236 100 67 131 1 1981817424 12580208 17995968
14:37:46 7289 8192000000 10894984544 11317907456 1954432656 19.262 100 64 128 2 1986652256 14077664 18141936
14:38:04 10894 8192000000 10892718656 11317432320 1952716896 19.248 100 65 129 1 1985439248 14069488 18652864
14:38:24 7175 8192000000 10900897152 11323416576 1960535728 19.310 100 68 135 0 1993931984 14638448 18757808
14:38:44 19488 8192000000 10906596608 11331592192 1962978208 19.330 100 55 110 1 1993211216 14510480 15722528
14:39:10 10486 8192000000 10907134512 11331723264 1965456336 19.349 100 63 126 3 1997498432 13626880 18415216
14:39:29 15916 8192000000 10908284608 11335684096 1963729424 19.336 100 54 108 1 1993547744 14393680 15424640
14:40:01 12614 8192000000 10924094256 11348090880 1978518336 19.453 100 64 128 1 2014195040 15940192 19736512
14:40:35 16791 8192000000 10920521056 11354120192 1981681152 19.478 100 46 91 1 2010390992 14814912 13894928
14:41:17 8563 8192000000 10938201632 11368570880 1991264784 19.554 100 56 110 3 2028414400 21125056 16024560
14:41:50 5410 8192000000 10939836448 11372195840 1988092576 19.529 100 50 100 2 2025419152 22148048 15178528
14:42:04 14101 8192000000 10943926832 11381334016 1994789344 19.582 100 47 88 0 2033336880 24699840 13847696
14:42:29 12674 8192000000 10941159616 11376431104 1981635424 19.478 99 45 88 0 2021690608 25448544 14606640
14:42:50 7708 8192000000 10948616784 11383279616 1997286304 19.601 100 47 90 2 2036111872 24677216 14148352
14:43:08 3798 8192000000 10957498976 11395010560 2002004512 19.639 100 51 99 1 2042435600 25190528 15240560
14:43:21 2860 8192000000 10968801296 11396546560 2009103856 19.694 100 62 124 2 2054360944 27023600 18233488
14:43:36 7475 8192000000 10952559904 11384033280 1984937328 19.504 99 56 112 1 2031226832 29296272 16993232
14:43:52 3154 8192000000 10972768800 11393576960 2003179936 19.648 100 70 139 2 2053484064 29989200 20314928
14:44:07 6769 8192000000 10971797056 11402530816 2006471456 19.674 100 60 120 0 2055363312 30441488 18450368
14:44:21 3306 8192000000 10974093408 11401351168 2010718640 19.707 100 67 134 3 2061079040 29496656 20863744
14:44:34 2225 8192000000 10970247168 11385827328 1997078800 19.600 100 67 131 1 2046338816 29544816 19715200
14:44:44 5264 8192000000 10976005312 11396517888 2002883760 19.645 100 76 152 1 2058084016 32617504 22582752
14:44:57 2839 8192000000 10959790384 11385896960 1993600896 19.572 100 75 150 0 2050462944 34060464 22801584
14:45:08 4661 8192000000 10973761472 11400630272 2000207376 19.624 100 75 150 0 2057045136 34660624 22177136
14:45:25 5290 8192000000 10986782400 11404345344 2004574064 19.659 100 77 153 0 2061837728 34561776 22701888
14:45:37 4381 8192000000 10986781968 11409432576 2009977168 19.701 100 79 156 3 2070383792 37224464 23182160
14:45:49 3144 8192000000 10991874256 11415973888 2017090624 19.757 100 79 158 0 2083058960 42453504 23514832
14:46:01 2725 8192000000 10992248784 11416387584 2016598640 19.753 100 79 155 2 2078238160 37791088 23848432
14:46:12 1834 8192000000 10995448976 11415851008 2014345136 19.736 100 79 157 3 2076090224 37199632 24545456
14:46:22 2020 8192000000 10997744384 11419754496 2020979856 19.788 100 84 168 0 2083938224 37098624 25859744
14:46:33 8038 8192000000 10983410752 11411042304 2001212688 19.632 99 73 145 1 2061515408 38024592 22278128
14:46:50 3693 8192000000 10990997424 11416027136 2012413648 19.721 100 73 143 1 2073763264 38762672 22586944
14:47:04 3942 8192000000 10981243296 11400810496 1985752224 19.510 99 79 157 1 2051370688 41400768 24217696
14:47:15 5559 8192000000 10991155152 11405357056 2000527344 19.627 100 80 158 1 2067934944 42265808 25141792
14:47:30 4977 8192000000 10978803840 11411324928 2002845808 19.645 100 66 133 0 2065276752 41672336 20758608
14:47:47 2767 8192000000 10984521968 11405168640 1997678992 19.604 100 66 132 1 2060056592 41475360 20902240
14:47:57 9072 8192000000 10945413120 11365699584 1917383408 18.966 96 62 124 2 1979535232 42750160 19401664
14:48:13 11384 8192000000 10903984640 11328540672 1912021984 18.923 97 64 128 1 1976872320 44079024 20771312
14:48:32 4722 8192000000 10934186640 11362021376 1951675456 19.240 100 66 127 2 2015232560 42884352 20672752
14:48:44 1518 8192000000 10960449344 11377700864 1973151360 19.410 100 80 159 0 2043717184 45162768 25403056
14:48:54 2603 8192000000 10970595744 11389214720 1981463312 19.476 100 76 152 0 2050696544 46376432 22856800
14:49:07 4418 8192000000 10983327472 11402682368 1990347168 19.547 100 80 160 1 2064148496 49479568 24321760
14:49:20 3830 8192000000 10976202176 11401064448 1990236608 19.546 100 70 139 0 2058793984 47605536 20951840
14:49:32 5386 8192000000 10989578272 11411337216 1999065568 19.615 100 84 166 1 2074137440 48934624 26137248
14:49:46 3408 8192000000 10991698704 11411513344 2005306352 19.665 100 84 168 0 2080176240 47748016 27121872
14:49:59 7705 8192000000 10999044928 11421048832 2001892848 19.638 100 73 145 0 2074439248 49061616 23484784
14:50:20 6259 8192000000 10984693792 11418030080 2003119200 19.647 100 61 121 1 2072027984 49387200 19521584
14:50:34 3686 8192000000 10989774224 11419377664 1998375472 19.610 100 70 140 0 2074710400 53552224 22782704
14:50:46 7557 8192000000 10975611296 11411308544 1971704688 19.399 99 56 110 0 2043874432 53553088 18616656
14:51:02 2339 8192000000 10960991968 11377324032 1975310928 19.428 100 87 172 4 2039414880 38025568 26078384
14:51:12 3030 8192000000 10954891136 11368886272 1953777904 19.257 99 83 166 3 2019919648 40197216 25944528
14:51:23 1736 8192000000 10941015600 11351228416 1948796112 19.217 99 83 164 1 2013417008 39485104 25135792
14:51:32 8965 8192000000 10942261936 11363352576 1955808960 19.273 100 68 134 1 2019092800 42451456 20832384
14:51:52 2206 8192000000 10955536080 11371270144 1965104592 19.347 100 74 146 1 2030860032 43535296 22220144
14:52:02 3683 8192000000 10958992816 11377606656 1952996416 19.250 99 83 165 1 2023190224 44480176 25713632
14:52:14 3970 8192000000 10932865456 11360153600 1938232288 19.133 99 75 150 1 2011141168 48974000 23934880
14:52:30 15424 8192000000 10919125600 11359277056 1949638224 19.224 100 38 76 2 2003515024 40959072 12917728
14:52:52 6150 8192000000 10919275648 11350937600 1937694928 19.128 99 44 87 0 1989959136 38585920 13678288
14:53:05 7094 8192000000 10906209616 11344363520 1943032144 19.171 100 56 109 2 1997503728 37805120 16666464
14:53:22 2340 8192000000 10920741552 11350716416 1948286928 19.213 100 49 98 2 1999675232 36237456 15150848
14:53:33 13153 8192000000 10902058784 11348361216 1934682832 19.104 99 35 69 2 1985193728 39153072 11357824
14:53:55 16439 8192000000 10905851344 11349868544 1916358784 18.958 98 26 51 0 1963408528 38581008 8468736
14:54:27 22687 8192000000 10891823840 11336933376 1898477792 18.814 98 29 58 3 1951139552 42240016 10421744
14:55:23 6442 8192000000 10904260784 11334397952 1902108624 18.843 98 46 92 1 1952665056 35921472 14634960
14:55:37 16876 8192000000 10905059936 11351732224 1945252608 19.189 100 33 66 0 1996054624 39404304 11397712
14:56:02 13383 8192000000 10882951376 11325603840 1881443424 18.677 97 28 56 1 1932794112 41824320 9526368
14:56:29 29779 8192000000 10874354608 11319222272 1894793632 18.784 99 23 46 1 1942754128 39751296 8209200
14:57:36 37914 8192000000 10835417040 11282894848 1815736144 18.143 96 22 44 2 1872807648 48611120 8460384
14:58:23 26603 8192000000 10836118160 11284299776 1860432544 18.507 98 16 32 1 1889974720 24492064 5050112
14:59:00 29969 8192000000 10809718560 11258245120 1837803792 18.323 97 20 40 1 1855431712 11950992 5676928
14:59:37 97449 8192000000 10843996128 11279110144 1859520704 18.499 98 27 54 0 1878351664 11135040 7695920
15:01:33 41964 8192000000 10858363152 11295404032 1906300848 18.877 100 42 83 1 1926488544 7981120 12206576
15:02:26 37476 8192000000 10877155328 11310460928 1919227456 18.981 99 33 67 1 1935679824 7582592 8869776
15:03:12 85122 8192000000 10858882576 11304038400 1882836448 18.688 97 37 75 0 1904866720 10727792 11302480
15:04:44 96862 8192000000 10864199840 11311779840 1899858768 18.825 98 28 56 0 1927979664 19838368 8282528
15:06:29 19718 8192000000 10860616736 11320012800 1932987712 19.091 100 24 48 0 1950778480 11383264 6407504
15:06:55 13809 8192000000 10868149984 11329785856 1936640384 19.120 100 21 42 1 1955384688 12659808 6084496
15:07:25 7035 8192000000 10868589472 11342368768 1943025088 19.171 100 10 20 0 1957213136 11537120 2650928
15:07:44 39789 8192000000 10859636560 11312402432 1908553504 18.895 98 17 32 0 1921273824 8607184 4113136
15:08:30 32604 8192000000 10873440160 11336617984 1946732240 19.200 100 18 35 3 1966643536 14602848 5308448
15:09:13 22003 8192000000 10875099088 11337814016 1933828688 19.097 99 4 8 0 1947746784 12794208 1123888
15:09:41 17372 8192000000 10870644608 11336253440 1948735984 19.216 100 6 12 1 1963827712 13232896 1858832
15:10:04 104460 8192000000 10878743056 11341697024 1942621184 19.168 99 23 47 1 1965193792 14765216 7807392
15:11:56 82655 8192000000 10892743248 11362271232 1957621024 19.287 100 17 34 1 1980192640 17132288 5439328
15:13:38 80804 8192000000 10899236608 11375153152 1941962224 19.162 99 12 24 1 1959494896 14288400 3244272
15:15:05 49627 8192000000 10884978416 11355934720 1935454896 19.110 99 16 32 0 1965374976 25117392 4802688
15:16:02 28664 8192000000 10918041168 11352911872 1961736544 19.320 100 49 97 1 1986820032 11121872 13961616
15:16:51 38796 8192000000 10873339904 11345264640 1938883856 19.138 99 29 58 1 1957783248 10787856 8111536
15:17:51 96860 8192000000 10890399856 11372494848 1961139904 19.315 100 14 28 0 1982143280 17008496 3994880
15:19:34 30494 8192000000 10895589760 11354882048 1926120320 19.036 98 14 28 1 1942554928 12296448 4138160
15:20:13 91101 8192000000 10880777568 11352981504 1939995456 19.147 99 7 14 1 1951578416 9720032 1862928
15:21:51 24222 8192000000 10906579824 11346096128 1949112544 19.219 99 46 90 0 1970005216 7899440 12993232
15:22:23 20175 8192000000 10924009888 11362385920 1973785600 19.415 100 60 118 2 2002356224 11984144 16586480
15:22:51 59026 8192000000 10901920496 11366436864 1969982368 19.385 100 23 46 0 1986449760 10303792 6163600
15:23:59 36225 8192000000 10889052608 11344891904 1910038320 18.907 97 20 40 1 1924439984 9261440 5140224
15:24:47 50554 8192000000 10853165120 11310153728 1882248992 18.683 96 20 40 0 1897214272 9770432 5194848
15:25:45 83878 8192000000 10879525584 11336568832 1899876928 18.825 98 20 40 1 1922302224 17377936 5047360
15:27:15 97278 8192000000 10884042384 11335581696 1938010800 19.131 99 18 36 1 1955910656 12575792 5324064
15:29:12 67055 8192000000 10894998672 11352346624 1942035296 19.163 99 26 52 0 1956012144 7394192 6582656
15:30:40 30386 8192000000 10905965360 11361402880 1972815376 19.408 100 30 60 2 1989493264 7606816 9071072
15:31:22 36056 8192000000 10911942032 11369533440 1978525456 19.453 100 22 44 3 1995748320 10442240 6780624
15:32:21 80240 8192000000 10902080352 11388329984 1985096928 19.505 100 15 30 0 2007645984 18555664 3993392
15:33:48 24348 8192000000 10860701424 11334217728 1906675296 18.880 96 14 26 1 1922416448 11869232 3871920
15:34:22 43869 8192000000 10880647056 11354456064 1944997744 19.187 99 14 28 0 1957069088 8412192 3659152
15:35:17 34960 8192000000 10874702112 11355521024 1948864032 19.217 99 7 14 0 1960843408 10113536 1865840
15:35:58 44666 8192000000 10879244192 11360571392 1940489344 19.151 99 8 16 0 1953117360 10485392 2142624
15:36:49 42806 8192000000 10882007056 11363086336 1928326992 19.053 98 5 10 0 1938939520 9759584 852944
15:37:38 55009 8192000000 10906567312 11378249728 1977460064 19.445 100 23 46 0 1998571520 14627792 6483664
15:38:41 61485 8192000000 10889293440 11361566720 1914448608 18.942 96 23 46 1 1930157088 9624336 6084144
15:39:50 48816 8192000000 10899717664 11362222080 1903997840 18.858 96 34 68 3 1922980400 9356368 9626192
15:40:49 53125 8192000000 10884780720 11351928832 1896756448 18.800 96 35 70 0 1916048288 9293408 9998432
15:41:51 76319 8192000000 10891583088 11364274176 1955614752 19.271 100 22 44 2 1976961520 15185680 6161088
15:43:26 64967 8192000000 10889947280 11357917184 1851141824 18.431 94 17 34 2 1875778368 19571936 5064608
15:44:37 97639 8192000000 10893284592 11355271168 1872196368 18.602 95 16 32 1 1897156176 20128992 4830816
15:46:21 56679 8192000000 10887871856 11355791360 1918162800 18.972 98 21 42 0 1954208032 29640592 6404640
15:47:44 98275 8192000000 10853433440 11320246272 1827077568 18.235 94 10 21 0 1845205504 14878736 3249200
15:50:13 92726 8192000000 10867618816 11321360384 1850722848 18.428 96 22 43 1 1870942496 13840896 6378752
15:51:52 135417 8192000000 10862951968 11328303104 1911593776 18.919 99 20 40 0 1928287248 10392352 6301120
15:54:14 68096 8192000000 10851296768 11328176128 1897302736 18.805 98 13 26 1 1913946000 12955872 3687392
15:55:31 35046 8192000000 10823877344 11290742784 1877916640 18.648 97 11 22 0 1892468400 11479408 3072352
15:57:48 72062 8192000000 10854429968 11322388480 1932036256 19.083 100 13 24 2 1946273920 10150672 4086992
15:59:07 91038 8192000000 10870127008 11339112448 1924321040 19.021 99 17 35 1 1935987648 6430000 5236608
16:00:46 55163 8192000000 10881787040 11355815936 1957320240 19.285 100 19 38 1 1974588560 11876896 5391424
16:01:57 46066 8192000000 10881947488 11363446784 1930889584 19.074 98 15 30 0 1945178528 10405520 3883424
16:02:51 64783 8192000000 10912021632 11379179520 1958312112 19.293 99 15 30 0 1971822960 9665744 3845104
16:04:02 80217 8192000000 10910431136 11389775872 1971073504 19.394 99 14 28 0 1986601472 10972128 4555840
16:05:29 80159 8192000000 10912385936 11387711488 1965609664 19.351 99 18 36 1 1984598208 14211568 4776976
16:07:01 116817 8192000000 10917289152 11409268736 1957410000 19.285 98 19 37 1 1975995760 13000208 5585552
16:09:04 41220 8192000000 10927475248 11393728512 1997148784 19.600 100 27 54 1 2013654240 7882752 8622704
16:10:00 20567 8192000000 10929401120 11389558784 1992431264 19.563 100 23 46 1 2006268448 7541808 6295376
16:10:31 26624 8192000000 10929359872 11382886400 1955337376 19.269 98 34 68 0 1974463680 9925264 9201040
16:11:06 11463 8192000000 10940990368 11387039744 1988226992 19.530 100 62 125 3 2018392448 13080576 17084880
16:11:28 23146 8192000000 10925091296 11370741760 1962346272 19.325 99 49 98 1 1988736848 13039776 13350800
16:11:59 13228 8192000000 10927818032 11371401216 1956325392 19.277 99 48 96 0 1984785584 15221152 13239040
16:12:18 22286 8192000000 10930130112 11375091712 1973073600 19.410 100 43 85 3 2000449184 15668896 11706688
16:12:47 34774 8192000000 10899982304 11368333312 1936945392 19.122 98 29 58 0 1962688976 17753744 7989840
16:13:32 70848 8192000000 10896958080 11340808192 1915336000 18.949 97 28 55 5 1932638464 9444064 7858400
16:14:52 84178 8192000000 10882170640 11343503360 1929730640 19.065 98 24 48 2 1944964608 8042816 7191152
16:16:27 102832 8192000000 10877912864 11337351168 1889786192 18.744 96 19 38 2 1905146112 10158384 5201536
16:18:23 36451 8192000000 10894071008 11348692992 1928869616 19.058 98 22 44 2 1946785568 11327584 6588368
16:19:08 50546 8192000000 10874631552 11359547392 1961494496 19.318 100 17 34 1 1980377792 13403584 5479712
16:20:04 47010 8192000000 10870579904 11343446016 1904510816 18.863 97 16 32 1 1918197136 8610672 5075648
16:21:02 63261 8192000000 10848869232 11317493760 1889020464 18.738 97 10 20 1 1899065072 6923136 3121472
16:22:55 67747 8192000000 10838925024 11320451072 1908559328 18.895 99 14 28 0 1923515984 10738464 4218192
16:24:09 64138 8192000000 10879222752 11355721728 1942042960 19.163 100 14 28 0 1952326336 6617488 3665888
16:25:22 96382 8192000000 10897310368 11368230912 1912898576 18.930 97 23 46 0 1934859856 15934320 6026960
16:27:05 64370 8192000000 10890737456 11356676096 1897403504 18.805 96 22 44 0 1922657392 18676112 6577776
16:28:17 55474 8192000000 10881681488 11352203264 1920494432 18.991 98 25 49 1 1943522288 15179088 7848768
16:29:19 19487 8192000000 10832051936 11298250752 1834923408 18.299 94 25 51 0 1859644736 16908752 7812576
16:30:38 51585 8192000000 10852435728 11320348672 1873908448 18.616 97 17 34 0 1893246928 14649408 4689072
16:31:39 39546 8192000000 9427224880 9726951424 576570784 6.575 30 6 12 0 584359264 6388320 1400160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 06-02-2021 16:33:18 to 06-02-2021 16:33:49.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-02-2021 16:33:50 to 06-02-2021 16:33:52.

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          239429
MON$OLDEST_ACTIVE               239430
MON$OLDEST_SNAPSHOT             239430
MON$NEXT_TRANSACTION            239430
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                       1996352
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sat Feb  6 16:32:24 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sat Feb  6 16:32:25 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

06.02.21 16:33:53. 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
2021-02-06 16:33:55 No severe PSQL-related problems occured
06.02.21 16:33:57. End of report.