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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17363916 kB
MemAvailable 31354940 kB
Buffers 0 kB
Cached 14285440 kB
SwapCached 2408 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-06-19 16:27:42
DTS_END                         2021-06-19 16:27:42.0250
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37980
TRN_ID                          227688
ATT_ID                          655
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: 9124.92 21801 1094991
customer order: creation 158.87 381 19064
customer order: refuse 13.47 355 1616
order to supplier: creation 41.93 1335 5031
order to supplier: removal 3.38 114676 406
invoice (draft): creation 42.11 3537 5053
invoice (draft): removal 54.44 837 6533
invoice accept: apply 38.58 17687 4630
invoice accept: cancel 49.87 772 5984
customer reserve: creation 3575.53 174 429063
customer reserve: removal 4865.63 62 583876
realization accept: apply 76.85 193 9222
realization accept: cancel 86.17 111 10340
payment from customer: creation 54.82 117 6578
payment from customer: removal 5.43 78 652
payment to supplier: creation 44.37 138 5324
payment to supplier: removal 3.05 101 366
service: total inventory turnovers 4.18 1023 502
service: total monetary turnovers 5.48 37 658
service: aggregate perf. data 0.74 20946 89
service: refresh index statistics 0.03 273462 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-06-2021 16:28:42 to 19-06-2021 16:28:44.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2973
TEST_TIME 2 3834
TEST_TIME 3 4064
TEST_TIME 4 4825
TEST_TIME 5 4568
TEST_TIME 6 4685
TEST_TIME 7 5018
TEST_TIME 8 4868
TEST_TIME 9 5308
TEST_TIME 10 5147
TEST_TIME 11 5464
TEST_TIME 12 5578
TEST_TIME 13 5851
TEST_TIME 14 5928
TEST_TIME 15 6501
TEST_TIME 16 6686
TEST_TIME 17 6819
TEST_TIME 18 6791
TEST_TIME 19 7249
TEST_TIME 20 7864
TEST_TIME 21 8017
TEST_TIME 22 8268
TEST_TIME 23 8201
TEST_TIME 24 8560
TEST_TIME 25 9301
TEST_TIME 26 9854
TEST_TIME 27 10473
TEST_TIME 28 10397
TEST_TIME 29 10563
TEST_TIME 30 10466
TEST_TIME 31 10722
TEST_TIME 32 10649
TEST_TIME 33 10477
TEST_TIME 34 10609
TEST_TIME 35 10508
TEST_TIME 36 10345
TEST_TIME 37 10281
TEST_TIME 38 10217
TEST_TIME 39 10040
TEST_TIME 40 10042
TEST_TIME 41 10012
TEST_TIME 42 9851
TEST_TIME 43 9773
TEST_TIME 44 9663
TEST_TIME 45 9516
TEST_TIME 46 9484
TEST_TIME 47 9472
TEST_TIME 48 9452
TEST_TIME 49 9573
TEST_TIME 50 9480
TEST_TIME 51 9419
TEST_TIME 52 9266
TEST_TIME 53 9148
TEST_TIME 54 9161
TEST_TIME 55 9116
TEST_TIME 56 9075
TEST_TIME 57 9066
TEST_TIME 58 9049
TEST_TIME 59 9033
TEST_TIME 60 9126
TEST_TIME 61 9118
TEST_TIME 62 9177
TEST_TIME 63 9226
TEST_TIME 64 9178
TEST_TIME 65 9283
TEST_TIME 66 9292
TEST_TIME 67 9250
TEST_TIME 68 9238
TEST_TIME 69 9322
TEST_TIME 70 9335
TEST_TIME 71 9391
TEST_TIME 72 9492
TEST_TIME 73 9375
TEST_TIME 74 9317
TEST_TIME 75 9301
TEST_TIME 76 9221
TEST_TIME 77 9233
TEST_TIME 78 9147
TEST_TIME 79 9174
TEST_TIME 80 9172
TEST_TIME 81 9182
TEST_TIME 82 9108
TEST_TIME 83 9074
TEST_TIME 84 8998
TEST_TIME 85 9003
TEST_TIME 86 8987
TEST_TIME 87 8981
TEST_TIME 88 9015
TEST_TIME 89 8975
TEST_TIME 90 8992
TEST_TIME 91 9065
TEST_TIME 92 9111
TEST_TIME 93 9146
TEST_TIME 94 9133
TEST_TIME 95 9145
TEST_TIME 96 9230
TEST_TIME 97 9227
TEST_TIME 98 9161
TEST_TIME 99 9251
TEST_TIME 100 9305
TEST_TIME 101 9282
TEST_TIME 102 9260
TEST_TIME 103 9228
TEST_TIME 104 9211
TEST_TIME 105 9149
TEST_TIME 106 9166
TEST_TIME 107 9152
TEST_TIME 108 9112
TEST_TIME 109 9109
TEST_TIME 110 9048
TEST_TIME 111 9041
TEST_TIME 112 9058
TEST_TIME 113 9052
TEST_TIME 114 9046
TEST_TIME 115 9037
TEST_TIME 116 9050
TEST_TIME 117 9146
TEST_TIME 118 9118
TEST_TIME 119 9152
TEST_TIME 120 9129

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-06-2021 16:28:45 to 19-06-2021 16:28:49.

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 1492243 1492243 0 0.00 0 20020 6 0 0
doc_list_biud 1492241 1492241 0 0.00 0 33394 31 0 0
sp_add_invoice_to_stock 4706 4630 76 1.61 41 193276 17688 0 76
sp_cancel_adding_invoice 5984 5984 0 0.00 6 60396 773 0 0
sp_cancel_client_order 1616 1616 0 0.00 4 17028 356 0 0
sp_cancel_customer_reserve 583876 583876 0 0.00 1 21276 63 0 0
sp_cancel_pay_from_customer 652 652 0 0.00 3 4034 79 0 0
sp_cancel_pay_to_supplier 366 366 0 0.00 3 8716 102 0 0
sp_cancel_supplier_invoice 6539 6533 6 0.09 2 33402 838 0 6
sp_cancel_supplier_order 406 406 0 0.00 4 990552 114677 0 0
sp_cancel_write_off 10340 10340 0 0.00 1 21636 112 0 0
sp_client_order 19064 19064 0 0.00 4 25888 382 0 0
sp_customer_reserve 429063 429063 0 0.00 0 54513 174 0 0
sp_fill_shopping_cart 29136 29136 0 0.00 1 12828 42 0 0
sp_fill_shopping_cart_clo_res 429057 429057 0 0.00 0 18540 15 0 0
sp_get_clo_for_invoice 4623 4623 0 0.00 0 28294 343 0 0
sp_kill_cost_storno 17342 17342 0 0.00 0 12032 60 0 0
sp_kill_qstorno_ret_qs2qd 1185031 1185031 0 0.00 0 33391 34 0 0
sp_kill_qty_storno 622599 622599 0 0.00 0 33393 73 0 0
sp_lock_selected_doc 19193 19193 0 0.00 0 16760 5 0 0
sp_make_cost_storno 25747 25747 0 0.00 0 20019 58 0 0
sp_multiply_rows_for_pdistr 25746 25746 0 0.00 0 11278 29 0 0
sp_multiply_rows_for_qdistr 19064 19064 0 0.00 0 21084 170 0 0
sp_pay_from_customer 6578 6578 0 0.00 4 16583 117 0 0
sp_pay_to_supplier 5324 5324 0 0.00 5 20171 139 0 0
sp_payment_common 11902 11902 0 0.00 1 11037 36 0 0
sp_qd_handle_on_cancel_clo 1616 1616 0 0.00 0 14996 324 0 0
sp_qd_handle_on_invoice_upd_sts 10606 10606 0 0.00 0 17559 340 0 0
sp_qd_handle_on_reserve_upd_sts 9222 9222 0 0.00 0 16303 73 0 0
sp_reserve_write_off 9222 9222 0 0.00 6 16353 193 0 0
sp_supplier_invoice 5053 5053 0 0.00 6 82042 3537 0 0
sp_supplier_order 5031 5031 0 0.00 5 66243 1335 0 0
srv_aggregate_perf_data 89 89 0 0.00 2661 191827 20947 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 980 140627 32797 0 0
srv_find_qd_qs_mism 1050967 1050967 0 0.00 0 12695 5 0 0
srv_make_invnt_saldo 502 502 0 0.00 37 28853 1024 0 0
srv_make_money_saldo 658 658 0 0.00 1 6264 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 87361 543865 273463 0 0
t$perf-abend:sp_add_invoice_to_stock 76 76 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4631 4631 0 0.00 0 35079 223 0 0
t$perf-norm:sp_cancel_adding_invoice 378 378 0 0.00 0 9793 169 0 0
t$perf-norm:sp_cancel_client_order 1616 1616 0 0.00 0 3981 15 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 7170 34 0 0
t$perf-norm:sp_cancel_pay_from_customer 652 652 0 0.00 0 6197 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 366 366 0 0.00 0 769 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 753 10 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 27570 1687 0 0
t$perf-norm:sp_cancel_write_off 892 892 0 0.00 0 15597 23 0 0
t$perf-norm:sp_client_order 19064 19064 0 0.00 0 15727 21 0 0
t$perf-norm:sp_customer_reserve 891 891 0 0.00 0 3255 7 0 0
t$perf-norm:sp_pay_from_customer 6578 6578 0 0.00 0 9644 19 0 0
t$perf-norm:sp_pay_to_supplier 5324 5324 0 0.00 0 12590 17 0 0
t$perf-norm:sp_reserve_write_off 9222 9222 0 0.00 0 9248 18 0 0
t$perf-norm:sp_supplier_invoice 5053 5053 0 0.00 0 8674 21 0 0
t$perf-norm:sp_supplier_order 5031 5031 0 0.00 0 12666 20 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 85 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 2119 30 0 0
t$perf-norm:srv_make_invnt_saldo 502 502 0 0.00 0 7845 39 0 0
t$perf-norm:srv_make_money_saldo 658 658 0 0.00 0 13055 33 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 14 5 0 0
v_add_invoice_to_stock 9396 9244 152 1.61 0 16803 21 0 152
v_all_customers 34638 34638 0 0.00 0 22 1 0 0
v_all_suppliers 28002 28002 0 0.00 0 20 1 0 0
v_all_wares 38128 38128 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 756 756 0 0.00 0 10441 40 0 0
v_cancel_client_order 3232 3232 0 0.00 0 16838 9 0 0
v_cancel_customer_prepayment 1304 1304 0 0.00 0 4026 9 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 176 3 0 0
v_cancel_payment_to_supplier 732 732 0 0.00 0 3292 14 0 0
v_cancel_supplier_invoice 758 746 12 1.58 0 965 12 0 12
v_cancel_supplier_order 812 812 0 0.00 0 1053 4 0 0
v_cancel_write_off 1784 1784 0 0.00 0 2191 15 0 0
v_max_id_clo_ord 5026 5026 0 0.00 0 293 1 0 0
v_max_id_clo_res 891 891 0 0.00 0 3092 15 0 0
v_max_id_ord_sup 5045 5045 0 0.00 0 4097 5 0 0
v_max_non_paid_invoice 1394 1394 0 0.00 0 1959 3 0 0
v_max_non_paid_realizn 3477 3477 0 0.00 0 6136 7 0 0
v_min_id_clo_ord 5026 5026 0 0.00 0 4061 8 0 0
v_min_id_clo_res 891 891 0 0.00 0 5622 25 0 0
v_min_id_ord_sup 5045 5045 0 0.00 0 4467 8 0 0
v_min_non_paid_invoice 5324 5324 0 0.00 0 11033 26 0 0
v_min_non_paid_realizn 6578 6578 0 0.00 0 9908 25 0 0
v_our_firm 9692 9692 0 0.00 0 17 1 0 0
v_reserve_write_off 18444 18444 0 0.00 0 10634 6 0 0
x_lock_depdocs_on_canc_invoice 12144 12144 0 0.00 0 38266 113 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 12189 369 0 0
x_make_qstorno_1000_1200 5031 5031 0 0.00 2 66207 1253 0 0
x_make_qstorno_1200_2000 5053 5053 0 0.00 3 82002 3382 0 0
x_make_qstorno_2100_3300 429063 429063 0 0.00 0 54511 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-06-2021 16:28:50 to 19-06-2021 16:28:54.

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
13:57:45 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:52 32568 8192000000 10309981808 10622840832 1021981664 11.091 77 56 112 0 1043614288 3017312 18615312
13:58:32 18834 8192000000 10354370688 10672324608 1414587680 14.725 100 89 178 0 1449702624 5597504 29517440
13:59:01 24944 8192000000 10397220736 10719756288 1442222272 14.969 100 92 184 0 1478608448 6204688 30181488
13:59:37 21967 8192000000 10417899616 10745819136 1472543024 15.236 100 87 174 2 1508050480 7107872 28399584
14:00:10 13735 8192000000 10433346736 10762248192 1491086160 15.398 100 89 179 0 1527824288 7814096 28924032
14:00:34 18081 8192000000 10451115968 10783162368 1507548192 15.542 100 91 182 2 1545112496 8428400 29135904
14:01:07 16050 8192000000 10455519056 10792837120 1513393280 15.593 100 84 166 1 1548707232 8735216 26578736
14:01:32 15256 8192000000 10470578496 10813886464 1528308288 15.722 100 80 160 0 1563025104 9091344 25625472
14:01:56 14354 8192000000 10489189248 10837762048 1550437168 15.914 100 74 148 1 1581674384 8908768 22328448
14:02:20 12617 8192000000 10510348144 10863939584 1569100640 16.075 100 75 150 0 1600819296 9085280 22633376
14:02:43 12891 8192000000 10549735616 10905034752 1605184560 16.384 100 77 154 1 1637476528 9037792 23254176
14:03:05 21979 8192000000 10589634336 10947018752 1642714304 16.703 100 82 162 1 1676857728 9659696 24483728
14:03:36 13722 8192000000 10593259280 10958368768 1658946272 16.840 100 75 150 0 1691293120 10468288 21878560
14:03:57 12631 8192000000 10627002800 10990481408 1686680896 17.073 100 87 174 1 1723359808 11153456 25525456
14:04:18 10291 8192000000 10641277712 11009867776 1696990640 17.160 100 84 167 0 1733222048 12155424 24075984
14:04:38 6046 8192000000 10651520752 11023663104 1709868656 17.268 100 81 160 2 1746235584 12485584 23881344
14:04:51 6763 8192000000 10674969504 11046653952 1725754448 17.400 100 78 156 0 1761037616 13118848 22164320
14:05:08 7960 8192000000 10680118576 11056893952 1739866400 17.518 100 77 154 1 1774575888 13162096 21547392
14:05:24 8278 8192000000 10706983280 11081969664 1750218144 17.603 100 80 160 0 1786964560 13790448 22955968
14:05:42 6350 8192000000 10710563408 11087482880 1765841744 17.733 100 80 159 4 1801786448 13802320 22142384
14:05:56 5261 8192000000 10724872464 11103449088 1781314160 17.860 100 88 174 2 1819791968 13851120 24626688
14:06:09 5778 8192000000 10729231424 11103936512 1785495296 17.895 100 87 173 1 1822793248 13662656 23635296
14:06:21 4763 8192000000 10730680496 11112542208 1788865008 17.922 100 81 160 0 1824642064 13715136 22061920
14:06:37 4687 8192000000 10751790544 11133251584 1805249648 18.057 100 87 172 3 1844245632 14695312 24300672
14:06:48 2805 8192000000 10748938560 11132280832 1808308368 18.082 100 90 180 2 1848933936 15703520 24922048
14:06:58 7596 8192000000 10747032688 11133972480 1812938656 18.120 100 84 164 2 1850141888 14813328 22389904
14:07:13 7178 8192000000 10757634640 11145547776 1818137712 18.162 100 81 162 1 1853541680 13730064 21673904
14:07:27 2608 8192000000 10771747200 11154915328 1830069968 18.260 100 92 182 0 1869984432 14356864 25557600
14:07:36 2537 8192000000 10775007536 11164090368 1838807072 18.331 100 84 168 0 1877237152 14564448 23865632
14:07:45 2690 8192000000 10780780256 11168337920 1843702192 18.371 100 89 178 2 1881652848 13479232 24471424
14:07:55 2433 8192000000 10791517024 11180556288 1848174240 18.407 100 91 182 1 1889053296 14726208 26152848
14:08:04 1732 8192000000 10793778416 11178844160 1852665120 18.444 100 88 176 0 1890365488 13524560 24175808
14:08:13 1526 8192000000 10802208480 11187957760 1856438304 18.474 100 91 178 2 1895282080 14090544 24753232
14:08:21 1910 8192000000 10810225296 11194822656 1862542432 18.524 100 93 187 2 1901584640 13199728 25842480
14:08:29 1698 8192000000 10809948256 11197456384 1865693504 18.549 100 96 193 0 1907544336 14827280 27023552
14:08:38 2072 8192000000 10810726752 11202338816 1865295472 18.546 100 90 180 0 1905484848 13983600 26205776
14:08:46 1237 8192000000 10803010720 11192909824 1865036192 18.544 100 91 180 0 1903559760 13563168 24960400
14:08:54 2955 8192000000 10813898384 11202252800 1872330496 18.603 100 92 184 1 1911980352 13105072 26544784
14:09:03 2066 8192000000 10823325936 11209998336 1875182544 18.626 100 92 183 2 1914553104 13153184 26217376
14:09:12 2072 8192000000 10825635664 11212922880 1878425584 18.652 100 96 194 1 1920215920 13644784 28145552
14:09:20 1254 8192000000 10834746944 11222319104 1885607424 18.710 100 96 192 0 1926435600 12908656 27919520
14:09:28 1463 8192000000 10829709872 11218051072 1884283008 18.700 100 92 184 1 1924199808 13099360 26817440
14:09:36 48203 8192000000 10817494992 11219038208 1882995008 18.689 100 78 153 2 1916945840 12536864 21413968
14:10:31 1107 8192000000 10837247744 11227578368 1889883680 18.745 100 80 162 0 1921408464 8835408 22689376
14:10:40 2557 8192000000 10833743376 11229986816 1891705904 18.760 100 85 169 1 1925823104 10373008 23744192
14:10:49 1566 8192000000 10835019840 11237175296 1893350992 18.773 100 90 181 1 1932372560 13790976 25230592
14:10:59 5507 8192000000 10797521024 11226566656 1884086576 18.698 100 41 80 1 1906091232 10864960 11139696
14:11:12 6315 8192000000 10793360512 11222777856 1884420368 18.701 100 41 80 1 1904378656 9366848 10591440
14:11:25 3814 8192000000 10801004256 11222507520 1884631120 18.702 100 39 77 3 1902819760 7031088 11157552
14:11:36 3433 8192000000 10812508896 11224666112 1886642144 18.719 100 48 93 3 1906907104 6411472 13853488
14:11:48 7553 8192000000 10814552288 11230703616 1892672672 18.767 100 39 78 3 1910013632 6123712 11217248
14:12:02 6873 8192000000 10802105104 11233304576 1893923888 18.777 100 38 76 2 1917099536 12248192 10927456
14:12:17 8070 8192000000 10798196704 11232657408 1894374512 18.781 100 23 46 0 1906944000 6049392 6520096
14:12:31 5091 8192000000 10814604416 11239436288 1899667584 18.824 100 41 82 0 1917986768 5894672 12424512
14:12:44 9863 8192000000 10801238848 11236835328 1895204096 18.788 100 16 32 1 1905842400 5928320 4709984
14:13:00 8672 8192000000 10808535840 11240923136 1898157664 18.811 100 21 42 1 1911164336 6868096 6138576
14:13:16 6361 8192000000 10819872048 11245260800 1902166192 18.844 100 28 54 1 1916486176 5337648 8982336
14:13:29 7400 8192000000 10812559488 11245256704 1902262048 18.844 100 22 44 2 1919100992 10588368 6250576
14:13:47 8888 8192000000 10810304480 11244728320 1902554784 18.847 100 23 46 0 1915478288 6160544 6762960
14:14:05 7242 8192000000 10813393328 11246403584 1906772448 18.881 100 23 46 4 1920208736 7290176 6146112
14:14:20 15142 8192000000 10845570272 11254525952 1908172096 18.892 100 25 50 3 1921920896 5670592 8078208
14:14:43 66495 8192000000 10859400608 11271131136 1914651776 18.944 100 47 93 0 1933906608 5639632 13615200
14:15:58 6776 8192000000 10829233792 11263111168 1912846656 18.929 100 32 65 2 1926990656 5378464 8765536
14:16:12 8025 8192000000 10816258560 11245969408 1894012032 18.778 99 31 60 1 1909230672 6434400 8784240
14:16:27 5766 8192000000 10844371056 11258605568 1908749728 18.897 100 36 70 1 1925016896 5771888 10495280
14:16:40 7176 8192000000 10812309616 11245191168 1880489776 18.669 99 22 44 1 1892041024 5456672 6094576
14:16:54 8491 8192000000 10798705648 11231506432 1857929872 18.486 98 27 54 0 1872068208 6004720 8133616
14:17:08 4342 8192000000 10813633872 11235463168 1894125136 18.779 100 44 88 0 1912480880 6723888 11631856
14:17:19 6650 8192000000 10812993936 11250651136 1896097984 18.795 100 31 62 1 1915697312 11501248 8098080
14:17:32 8426 8192000000 10796855600 11223699456 1858028528 18.487 98 15 30 0 1867788384 5291088 4468768
14:17:53 4581 8192000000 10800271504 11222990848 1870323024 18.587 99 29 56 1 1884569840 6168304 8078512
14:18:05 4055 8192000000 10791224528 11222695936 1877238304 18.643 100 30 60 0 1892203408 5889776 9075328
14:18:15 10191 8192000000 10802915568 11230285824 1875346288 18.628 100 13 26 0 1884848528 5728048 3774192
14:18:32 6045 8192000000 10765319888 11194023936 1829488976 18.255 98 17 34 1 1840198096 5834624 4874496
14:18:47 6173 8192000000 10774388160 11205091328 1865040752 18.544 100 28 55 2 1879615328 5927504 8647072
14:19:01 16023 8192000000 10763068320 11174367232 1778493072 17.837 95 37 72 2 1795744224 6051248 11199904
14:19:24 65833 8192000000 10707565552 11130691584 1644942448 16.722 89 29 58 1 1658520128 5095424 8482256
14:20:36 20280 8192000000 10675143552 11089588224 1690189008 17.103 94 28 56 1 1708199872 10645424 7365440
14:21:03 4704 8192000000 10689049840 11092221952 1738325600 17.505 97 36 71 1 1754698240 5638832 10733808
14:21:14 4956 8192000000 10696605376 11116838912 1748265072 17.587 97 27 54 5 1761345344 5199248 7881024
14:21:26 7743 8192000000 10700511600 11114676224 1728135152 17.420 96 21 42 1 1739767136 5328384 6303600
14:21:39 7104 8192000000 10689334624 11099844608 1713399120 17.297 96 21 42 0 1728817280 9819280 5598880
14:21:57 6160 8192000000 10673995392 11086626816 1714066976 17.303 96 19 38 0 1725033088 5433616 5532496
14:22:10 11516 8192000000 10701479424 11104948224 1733628496 17.466 97 26 52 0 1746439392 4742256 8068640
14:22:28 8214 8192000000 10711983744 11131871232 1790524560 17.936 100 22 44 0 1802199088 5484032 6190496
14:22:42 4950 8192000000 10730890240 11149488128 1801025600 18.022 99 36 73 0 1818861488 7344496 10491392
14:22:56 10801 8192000000 10727531840 11144249344 1765223184 17.728 97 22 42 2 1776829440 5366368 6239888
14:23:13 8114 8192000000 10733322384 11162853376 1807190416 18.073 99 22 44 1 1819449792 5915888 6343488
14:23:28 12322 8192000000 10746012192 11172081664 1816339600 18.148 99 18 36 2 1827291712 5493536 5458576
14:23:47 13453 8192000000 10764795888 11193606144 1844979504 18.381 100 19 38 1 1855475072 5558048 4937520
14:24:06 65845 8192000000 10786274688 11195932672 1853675504 18.452 100 30 58 1 1867478720 5463568 8339648
14:25:18 6447 8192000000 10765811184 11193147392 1856945248 18.479 100 24 48 0 1874669952 11313376 6411328
14:25:32 8700 8192000000 10768737056 11199287296 1855718448 18.469 100 25 50 2 1869165696 5824704 7622544
14:25:48 7773 8192000000 10775646384 11200823296 1860421760 18.507 100 29 58 0 1874455616 5596800 8437056
14:26:06 6004 8192000000 10780760736 11204624384 1862252528 18.522 100 28 56 0 1876154976 5658688 8243760
14:26:18 7271 8192000000 10779273616 11204747264 1863774544 18.534 100 32 64 2 1878777392 5902288 9100560
14:26:32 6209 8192000000 10784009392 11205566464 1864708128 18.541 100 24 46 2 1877127600 5873760 6545712
14:26:46 7284 8192000000 10790918368 11211907072 1868620832 18.573 100 26 52 0 1881817248 5601920 7594496
14:26:59 5883 8192000000 10787028624 11214049280 1871817648 18.599 100 34 67 2 1886648848 5236688 9594512
14:27:11 5038 8192000000 10803620848 11228504064 1886925664 18.721 100 31 61 1 1901767632 6096656 8745312
14:27:26 5964 8192000000 10804006048 11232935936 1892366624 18.765 100 22 44 2 1903712000 5085776 6259600
14:27:38 9650 8192000000 10825793680 11246972928 1899814000 18.825 100 31 62 2 1914687680 5931408 8942272
14:27:59 39496 8192000000 10844489056 11264856064 1911803728 18.921 100 45 90 1 1931915008 7452016 12659264
14:28:46 11811 8192000000 10856825056 11273568256 1918822608 18.977 100 53 106 2 1945373216 11448704 15101904
14:29:06 2122 8192000000 10875093648 11288662016 1925940736 19.034 100 72 143 0 1968054384 20299536 21814112
14:29:21 71099 8192000000 10860456864 11280936960 1927759856 19.049 100 54 108 0 1955805728 12911520 15134352
14:30:39 21873 8192000000 10857524912 11293822976 1930072848 19.067 100 34 68 0 1954713616 15121280 9519488
14:31:12 19448 8192000000 10862172032 11299315712 1930760976 19.073 100 23 43 3 1950111312 12638160 6712176
14:31:44 37780 8192000000 10871529024 11311927296 1942561968 19.167 100 24 47 0 1964826960 15765952 6499040
14:32:35 27585 8192000000 10890741824 11328749568 1958410208 19.293 100 29 58 2 1983453712 15938064 9105440
14:33:16 4872 8192000000 10908972704 11334737920 1965587072 19.350 100 51 100 2 1996695520 16902832 14205616
14:33:30 11711 8192000000 10927659680 11353374720 1974376336 19.420 100 67 132 1 2017479376 23524144 19578896
14:33:52 14402 8192000000 10926514480 11359141888 1982612992 19.485 100 66 132 1 2022942400 21368704 18960704
14:34:15 9475 8192000000 10931360960 11359375360 1981912256 19.480 100 60 120 3 2020281376 20851776 17517344
14:34:34 11236 8192000000 10925865744 11362480128 1981145936 19.474 100 48 95 1 2015037952 20172400 13719616
14:34:55 18691 8192000000 10929077904 11362729984 1983647440 19.494 100 51 100 3 2018447184 19914896 14884848
14:35:24 12390 8192000000 10942545600 11374231552 1992570000 19.564 100 57 115 2 2031015600 21958432 16487168
14:35:50 5587 8192000000 10948441248 11382358016 2001708080 19.636 100 61 123 0 2046402768 26468304 18226384
14:36:29 10712 8192000000 10948801216 11389652992 1988174064 19.529 99 40 80 2 2030363920 30084336 12105520
14:36:47 6968 8192000000 10944850496 11376209920 1990443136 19.547 100 46 91 1 2029442352 24346160 14653056
14:37:00 3261 8192000000 10954555568 11377147904 1988602944 19.533 100 68 134 3 2035976688 26730976 20642768
14:37:13 12533 8192000000 10957396240 11383083008 1995240528 19.585 100 54 108 3 2039474192 28322112 15911552
14:37:32 5173 8192000000 10968177248 11398189056 2003055008 19.647 100 70 141 1 2056709072 32585152 21068912
14:37:49 4744 8192000000 10979452288 11398541312 2009281632 19.696 100 76 151 4 2066227328 34684368 22261328
14:38:03 8183 8192000000 10983783104 11411812352 2013899920 19.732 100 68 136 1 2073442688 38307504 21235264
14:38:26 9950 8192000000 10988264640 11422674944 2021610032 19.793 100 58 115 1 2080022832 40854224 17558576
14:38:43 5277 8192000000 10994803392 11428044800 2020321536 19.783 100 58 117 0 2079713536 41151952 18240048
14:38:57 7707 8192000000 10989520880 11425021952 2020441088 19.784 100 59 118 1 2081584928 41794880 19348960
14:39:17 10052 8192000000 10994154608 11436150784 2025142960 19.821 100 55 110 1 2087386112 44690960 17552192
14:39:40 9798 8192000000 10999779392 11435782144 2022971200 19.803 100 63 124 1 2088263760 44446768 20845792
14:40:00 10385 8192000000 10994662128 11439435776 2027312160 19.838 100 57 114 1 2088239472 43115152 17812160
14:40:18 6746 8192000000 10985691280 11429638144 1999794176 19.621 99 49 97 2 2061668896 46780688 15094032
14:40:32 9821 8192000000 10993466896 11430313984 2017890368 19.764 100 56 110 1 2082840480 47190016 17760096
14:40:52 2781 8192000000 10981122608 11404562432 1989748960 19.542 99 62 120 1 2057790576 48989808 19051808
14:41:05 2296 8192000000 11005105040 11434733568 2023223824 19.805 100 75 150 0 2097447792 50656064 23567904
14:41:18 7193 8192000000 11017020640 11442806784 2023730960 19.809 100 71 141 0 2097924800 52551680 21642160
14:41:31 2315 8192000000 11018636336 11444514816 2030790128 19.865 100 74 148 0 2107346928 52307600 24249200
14:41:46 4825 8192000000 11018308080 11445755904 2027205440 19.837 100 69 138 1 2101797888 53261472 21330976
14:41:58 4049 8192000000 11010311968 11432542208 2005948432 19.670 99 80 159 0 2083665216 54548240 23168544
14:42:10 2702 8192000000 11033431744 11455062016 2032813600 19.881 100 92 185 0 2116260576 55350592 28096384
14:42:19 2024 8192000000 11034358448 11452674048 2033422512 19.885 100 92 184 1 2116731984 54224320 29085152
14:42:27 1680 8192000000 11042361760 11457695744 2035650208 19.903 100 91 182 1 2119241424 54880480 28710736
14:42:37 976 8192000000 11030579120 11446009856 2034521712 19.894 100 91 182 0 2112598192 50199248 27877232
14:42:48 3431 8192000000 11032587440 11450519552 2036369648 19.909 100 86 169 2 2113162048 50774160 26018240
14:42:58 2158 8192000000 10993018832 11412156416 1997840272 19.606 99 85 170 1 2077366336 52838688 26687376
14:43:07 2196 8192000000 11000844368 11416166400 2000076160 19.623 100 81 157 2 2076399680 51860832 24462688
14:43:17 2013 8192000000 11007582656 11430035456 2014786912 19.739 100 79 158 1 2091568048 51726160 25054976
14:43:26 3041 8192000000 10987513984 11407937536 1992235472 19.561 99 73 144 0 2067472336 52827056 22409808
14:43:37 3821 8192000000 10995560032 11422765056 1991974032 19.559 99 68 135 0 2065909392 52162112 21773248
14:43:49 8807 8192000000 10989342976 11422314496 2004436704 19.658 100 58 116 0 2076494560 53674064 18383792
14:44:08 2181 8192000000 10986661904 11416563712 1986754448 19.518 99 56 113 0 2058894144 54209424 17930272
14:44:19 3972 8192000000 11000343904 11421745152 2003645488 19.651 100 71 140 3 2078059776 52210864 22203424
14:44:29 4287 8192000000 10996084016 11420676096 1984901264 19.503 99 72 144 0 2062771104 54671072 23198768
14:44:42 3155 8192000000 10985755920 11418120192 1979261424 19.459 99 60 120 0 2057995008 59283568 19450016
14:44:55 6789 8192000000 10966322208 11409227776 1971277168 19.396 99 46 92 1 2046347120 59197552 15872400
14:45:17 9194 8192000000 10989652864 11416973312 1991744272 19.558 100 64 126 1 2070388096 57857808 20786016
14:45:33 3471 8192000000 10978893488 11404734464 1970511488 19.390 99 66 132 1 2052002208 60267760 21222960
14:45:45 2355 8192000000 10972055712 11387174912 1960109568 19.307 99 77 151 0 2046498624 60737232 25651824
14:45:56 4868 8192000000 10978947504 11396800512 1971852608 19.400 100 70 138 0 2056812512 62093072 22866832
14:46:11 13036 8192000000 10976144224 11401490432 1983821072 19.495 100 64 128 2 2059608768 54990592 20797104
14:46:31 2425 8192000000 11008923536 11421020160 2000601040 19.627 100 89 171 4 2083827696 55747072 27479584
14:46:41 2924 8192000000 11004469664 11431411712 2006445056 19.674 100 69 136 1 2088817264 60126080 22246128
14:46:56 4807 8192000000 11006443104 11440873472 2009453440 19.697 100 58 114 0 2089398432 61422032 18522960
14:47:11 13352 8192000000 10975195616 11419705344 1985268816 19.506 99 50 100 1 2051528800 49264336 16995648
14:47:31 4132 8192000000 10993528544 11432644608 2008629216 19.691 100 52 104 1 2076941664 51678128 16634320
14:47:45 13645 8192000000 10993126240 11438501888 2010059376 19.702 100 35 69 2 2072576960 50298368 12219216
14:48:05 14024 8192000000 10986198320 11426099200 1976407104 19.436 98 35 70 1 2043844320 55778640 11658576
14:48:30 11815 8192000000 10972108800 11419725824 1980757680 19.471 99 34 68 4 2047487920 55009632 11720608
14:48:54 9776 8192000000 10978697680 11431116800 1999412416 19.618 100 37 73 0 2067157872 55861744 11883712
14:49:24 17985 8192000000 10974333456 11429228544 1978020288 19.449 99 30 60 0 2042170768 54257392 9893088
14:49:58 19709 8192000000 10943500496 11390554112 1939777712 19.145 98 36 71 0 2008876832 56753328 12345792
14:50:24 11921 8192000000 10932153776 11376283648 1935093216 19.108 99 29 58 0 2004294896 58185472 11016208
14:50:43 8221 8192000000 10958621824 11392380928 1960526320 19.310 100 47 93 2 2040618688 64431008 15661360
14:50:59 23839 8192000000 10949654544 11393576960 1938981456 19.139 99 31 62 1 2018470416 68003376 11485584
14:51:50 16623 8192000000 10957626384 11412357120 1962282944 19.324 100 28 54 1 2037558064 65173408 10101712
14:52:27 11252 8192000000 10946787984 11402141696 1946570128 19.199 99 37 72 2 2017396528 58079936 12746464
14:52:52 6775 8192000000 10945815904 11410419712 1962886768 19.329 100 28 56 0 2033956688 61575728 9494192
14:53:07 15593 8192000000 10916363280 11364081664 1918466192 18.975 98 25 50 0 1989710496 61845728 9398576
14:53:29 20178 8192000000 10926509040 11395489792 1953283216 19.253 100 23 46 1 2007965008 46839600 7842192
14:54:05 15035 8192000000 10925261168 11382878208 1943190000 19.172 99 18 36 0 1996897200 47683712 6023488
14:54:41 29476 8192000000 10893482400 11351506944 1941445104 19.158 100 16 32 0 1986525888 39738416 5342368
14:55:18 48374 8192000000 10903232336 11366596608 1922434880 19.006 99 21 41 1 1969057968 39205536 7417552
14:56:15 41629 8192000000 10898950288 11361271808 1943797776 19.177 100 22 44 3 1979741792 29140464 6803552
14:57:04 46689 8192000000 10920262464 11364372480 1946045344 19.195 99 28 56 1 1976142400 22130048 7967008
14:58:11 48159 8192000000 10891600080 11365691392 1941885152 19.162 99 20 40 0 1968929360 21020880 6023328
15:00:18 29321 8192000000 10879061248 11336347648 1950765328 19.233 99 32 64 0 1974666784 14442288 9459168
15:00:54 47035 8192000000 10886084176 11358351360 1956811904 19.281 100 17 34 0 1981250224 19375184 5063136
15:01:47 22365 8192000000 10901504960 11362914304 1962942112 19.329 100 11 22 0 1979018800 13220672 2856016
15:02:17 31260 8192000000 10861598512 11325464576 1903488752 18.854 97 12 24 0 1914875344 8187456 3199136
15:02:54 92024 8192000000 10889321456 11342520320 1886751168 18.720 96 21 42 0 1902210528 9730336 5729024
15:04:38 97283 8192000000 10898962688 11362283520 1907010896 18.883 97 13 26 1 1929341056 18758480 3571680
15:06:30 49890 8192000000 10911108352 11370192896 1955867600 19.273 99 17 34 2 1979685008 18639392 5178016
15:07:29 99754 8192000000 10890407392 11347599360 1956044928 19.275 99 41 81 0 1980164688 11542176 12577584
15:09:22 71644 8192000000 10883186800 11334823936 1888135952 18.731 96 30 60 1 1907447840 10226640 9085248
15:10:41 40441 8192000000 10858151328 11320832000 1935215920 19.109 99 32 64 1 1952720352 8685088 8819344
15:11:28 46315 8192000000 10886747584 11335602176 1931028528 19.075 99 19 38 1 1946080768 9668256 5383984
15:12:21 7048 8192000000 10890915392 11346452480 1957737648 19.288 100 35 70 2 1979642848 11432816 10472384
15:12:44 5932 8192000000 10893326032 11341877248 1949095360 19.219 99 47 93 1 1974749648 11591584 14062704
15:13:03 33673 8192000000 10882988416 11351867392 1958956544 19.298 100 25 50 0 1978982256 12602592 7423120
15:13:42 43087 8192000000 10881021488 11348627456 1938206880 19.132 99 15 30 1 1955327840 12535920 4585040
15:14:34 35017 8192000000 10922219584 11364392960 1970564272 19.390 100 33 66 1 1993358304 12412912 10381120
15:15:27 78554 8192000000 10885935248 11373584384 1970194880 19.387 100 11 20 0 1987526400 14348512 2983008
15:17:07 59463 8192000000 10881287808 11351150592 1932886336 19.090 98 11 21 1 1944121392 8752800 2482256
15:18:23 103062 8192000000 10900881920 11364220928 1970018272 19.386 100 17 34 1 1980592432 5789232 4784928
15:20:17 66396 8192000000 10892272112 11376586752 1979699424 19.462 100 22 43 0 1994154560 8177776 6277360
15:21:48 27510 8192000000 10897256992 11362160640 1963617216 19.335 99 19 37 2 1976854160 8273552 4963392
15:22:21 45271 8192000000 10881942896 11370098688 1958463024 19.294 99 16 32 1 1976070336 12868496 4738816
15:23:13 41061 8192000000 10892593248 11379245056 1968211792 19.371 100 4 8 0 1979340368 9697216 1431360
15:24:25 41774 8192000000 10900475008 11381174272 1976606736 19.438 100 24 48 0 1992545664 8758512 7180416
15:25:15 59022 8192000000 10914208384 11381735424 1962505344 19.326 99 18 36 1 1976409376 8895936 5008096
15:26:21 31073 8192000000 10921086320 11384983552 1969227824 19.379 99 25 50 1 1987905824 11546000 7132000
15:26:58 44417 8192000000 10911006704 11384373248 1967179120 19.363 99 25 50 2 1988083488 13856320 7048048
15:27:49 75951 8192000000 10912277232 11383226368 1967681616 19.367 99 11 22 2 1982176160 11699328 2795216
15:30:22 78700 8192000000 10905912768 11370164224 1903378784 18.853 96 14 28 0 1917863728 10954240 3530704
15:31:47 74125 8192000000 10910509872 11393560576 1979587760 19.461 100 26 52 1 2002710000 15885824 7236416
15:34:03 20010 8192000000 10919016000 11375095808 1979309024 19.459 100 34 68 1 1996775968 8487040 8979904
15:34:37 10418 8192000000 10921306336 11358003200 1950090624 19.227 99 63 124 0 1977932512 10515280 17326608
15:34:56 26014 8192000000 10900863600 11350896640 1921488432 18.999 98 43 86 0 1944923744 11678800 11756512
15:35:35 25457 8192000000 10876800608 11325902848 1905940000 18.874 97 43 86 1 1930704848 12954256 11810592
15:36:07 61440 8192000000 10878158336 11324088320 1831793536 18.274 94 28 56 1 1852285472 12682848 7809088
15:37:15 33775 8192000000 10872193488 11325730816 1896530688 18.798 98 37 74 0 1918786752 11847152 10408912
15:38:00 126844 8192000000 10864301760 11345104896 1858544256 18.491 96 21 42 2 1879272112 15022656 5705200
15:40:13 101022 8192000000 10866964704 11336060928 1941007840 19.155 100 18 36 0 1964065600 17959200 5098560
15:42:11 65920 8192000000 10818066336 11280097280 1845508880 18.386 95 15 30 1 1861076352 10802032 4765440
15:43:26 17553 8192000000 10864448576 11319320576 1929408192 19.062 100 45 91 1 1954827072 11396416 14022464
15:43:52 42591 8192000000 10845295072 11327680512 1913748624 18.937 99 34 68 1 1935945072 12093008 10103440
15:44:46 73065 8192000000 10856329504 11335184384 1916309392 18.957 99 9 18 0 1939443200 20216464 2917344
15:46:05 28977 8192000000 10860437456 11325444096 1911774272 18.921 99 10 20 0 1932559008 17716864 3067872
15:47:37 63733 8192000000 10863035440 11342995456 1940660976 19.152 100 13 26 0 1952710208 7917744 4131488
15:48:56 53013 8192000000 10862768064 11339288576 1931214592 19.077 99 5 10 0 1939771424 7201712 1355120
15:49:57 7819 8192000000 10862433856 11308281856 1915965824 18.955 98 36 70 1 1934999440 8692800 10340816
15:50:16 73237 8192000000 10856985552 11337494528 1924021632 19.019 99 13 26 0 1938208880 10306944 3880304
15:51:50 76104 8192000000 10858927312 11351724032 1929813280 19.065 99 15 30 1 1944955072 10489616 4652176
15:53:13 57888 8192000000 10858494560 11342397440 1882474256 18.685 97 12 22 2 1895556496 10034752 3047488
15:54:19 40874 8192000000 10839479392 11308486656 1859868240 18.502 96 13 26 1 1872984080 9469040 3646800
15:55:07 59602 8192000000 10820518896 11284754432 1777969056 17.833 93 14 28 0 1794495312 12463648 4062608
15:56:12 23795 8192000000 10824915376 11280568320 1863621584 18.533 98 30 60 0 1881331520 9081040 8628896
15:56:44 46465 8192000000 10858265152 11324039168 1922239104 19.005 100 36 72 1 1946555296 14171104 10145088
15:57:41 67414 8192000000 10844151616 11301154816 1837982336 18.324 95 18 36 2 1856331504 13454944 4894224
15:58:59 76591 8192000000 10850477920 11320569856 1910596320 18.911 99 25 50 0 1935565808 17561872 7407616
16:00:29 73987 8192000000 10861000448 11327373312 1884090832 18.698 97 17 34 1 1895394784 7061488 4242464
16:01:53 91182 8192000000 10864083552 11342761984 1866231040 18.554 96 19 38 1 1887460352 16277504 4951808
16:03:31 140627 8192000000 10892860720 11348844544 1866658240 18.557 96 17 34 1 1888093360 17042624 4392496
16:05:59 45627 8192000000 10891983616 11357782016 1948138768 19.212 100 11 22 0 1963290960 11987712 3164480
16:06:50 118003 8192000000 10886882416 11358048256 1902472208 18.846 97 18 36 0 1918209264 11448736 4288320
16:08:55 55045 8192000000 10894471808 11364577280 1946166912 19.196 99 24 48 1 1965654896 11853568 7634416
16:10:21 126543 8192000000 10861972016 11337392128 1921018528 18.995 98 19 37 0 1937085872 10267408 5799936
16:12:34 6436 8192000000 10867301792 11343155200 1947667232 19.208 100 19 38 2 1960973136 8421088 4884816
16:12:46 42168 8192000000 10877107904 11358851072 1957677200 19.288 100 29 57 1 1978704768 12959744 8067824
16:13:43 45365 8192000000 10875759824 11358052352 1940160448 19.148 99 22 43 0 1959910464 13139344 6610672
16:14:35 26995 8192000000 10884012016 11362283520 1954516912 19.262 100 12 24 0 1970618000 12508288 3592800
16:15:09 24332 8192000000 10842862688 11324420096 1908772480 18.897 98 6 11 0 1921884112 11925616 1186016
16:16:10 43569 8192000000 10873442032 11336171520 1922147808 19.004 99 19 35 4 1938151552 11094064 4909680
16:17:00 70462 8192000000 10868152096 11336065024 1924650816 19.024 99 14 28 2 1937595104 8190848 4753440
16:18:26 67428 8192000000 10846804336 11331203072 1902643280 18.848 98 15 30 2 1919775824 12809088 4323456
16:19:39 52998 8192000000 10852523904 11319095296 1842930320 18.365 95 8 17 0 1856498752 11729312 1839120
16:20:49 58068 8192000000 10881274192 11349327872 1946645312 19.200 100 18 36 1 1964211952 11520624 6046016
16:21:59 48443 8192000000 10893684320 11360575488 1889319344 18.740 96 28 56 1 1909784784 11771424 8694016
16:22:54 65692 8192000000 10877279104 11337048064 1881165456 18.675 96 19 38 0 1899245104 13236752 4842896
16:24:06 79727 8192000000 10871725008 11340943360 1897834800 18.809 98 12 25 2 1912313184 11005408 3472976
16:25:44 74667 8192000000 10881756000 11364098048 1898060080 18.811 97 20 40 1 1922884032 18683712 6140240
16:27:04 46055 8192000000 9248033344 9501736960 398849744 4.642 21 3 6 0 406076720 6343744 883232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 19-06-2021 16:28:55 to 19-06-2021 16:29:27.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 76 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-06-2021 16:29:28 to 19-06-2021 16:29:30.

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          227994
MON$OLDEST_ACTIVE               227995
MON$OLDEST_SNAPSHOT             227995
MON$NEXT_TRANSACTION            227995
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                       2010560
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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'

19.06.21 16:29:31. 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-06-19 16:29:34 No severe PSQL-related problems occured
19.06.21 16:29:35. End of report.