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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-01 22:27:03
DTS_END                         2020-12-01 22:27:03.1460
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/44898
TRN_ID                          240885
ATT_ID                          658
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: 9579.03 21560 1149484
customer order: creation 174.59 346 20951
customer order: refuse 14.69 354 1763
order to supplier: creation 46.94 1363 5633
order to supplier: removal 3.62 95757 434
invoice (draft): creation 46.23 3474 5548
invoice (draft): removal 52.92 822 6350
invoice accept: apply 43.05 16966 5166
invoice accept: cancel 47.88 871 5746
customer reserve: creation 4087.03 163 490444
customer reserve: removal 4761.02 57 571322
realization accept: apply 84.49 161 10139
realization accept: cancel 86.12 109 10334
payment from customer: creation 59.37 107 7124
payment from customer: removal 6.07 90 728
payment to supplier: creation 49.91 116 5989
payment to supplier: removal 3.21 59 385
service: total inventory turnovers 4.73 942 568
service: total monetary turnovers 6.28 43 754
service: aggregate perf. data 0.85 23662 102
service: refresh index statistics 0.03 285735 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-12-2020 22:28:53 to 01-12-2020 22:28:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7753
TEST_TIME 2 6371
TEST_TIME 3 6447
TEST_TIME 4 6133
TEST_TIME 5 6180
TEST_TIME 6 6142
TEST_TIME 7 5876
TEST_TIME 8 5751
TEST_TIME 9 6448
TEST_TIME 10 6319
TEST_TIME 11 6580
TEST_TIME 12 7099
TEST_TIME 13 7414
TEST_TIME 14 7323
TEST_TIME 15 7454
TEST_TIME 16 8071
TEST_TIME 17 8186
TEST_TIME 18 8610
TEST_TIME 19 8611
TEST_TIME 20 8759
TEST_TIME 21 9062
TEST_TIME 22 9627
TEST_TIME 23 9618
TEST_TIME 24 9758
TEST_TIME 25 9931
TEST_TIME 26 10088
TEST_TIME 27 10514
TEST_TIME 28 10684
TEST_TIME 29 10531
TEST_TIME 30 10471
TEST_TIME 31 10202
TEST_TIME 32 10306
TEST_TIME 33 10428
TEST_TIME 34 10472
TEST_TIME 35 10491
TEST_TIME 36 10449
TEST_TIME 37 10650
TEST_TIME 38 10600
TEST_TIME 39 10528
TEST_TIME 40 10404
TEST_TIME 41 10176
TEST_TIME 42 10273
TEST_TIME 43 10185
TEST_TIME 44 10062
TEST_TIME 45 10032
TEST_TIME 46 10036
TEST_TIME 47 10054
TEST_TIME 48 10090
TEST_TIME 49 10033
TEST_TIME 50 9985
TEST_TIME 51 9874
TEST_TIME 52 9903
TEST_TIME 53 10078
TEST_TIME 54 10039
TEST_TIME 55 10053
TEST_TIME 56 10064
TEST_TIME 57 10107
TEST_TIME 58 10077
TEST_TIME 59 10100
TEST_TIME 60 10187
TEST_TIME 61 10167
TEST_TIME 62 10230
TEST_TIME 63 10317
TEST_TIME 64 10284
TEST_TIME 65 10180
TEST_TIME 66 10071
TEST_TIME 67 10149
TEST_TIME 68 10078
TEST_TIME 69 10050
TEST_TIME 70 10043
TEST_TIME 71 9984
TEST_TIME 72 9953
TEST_TIME 73 9895
TEST_TIME 74 9824
TEST_TIME 75 9821
TEST_TIME 76 9787
TEST_TIME 77 9815
TEST_TIME 78 9824
TEST_TIME 79 9796
TEST_TIME 80 9788
TEST_TIME 81 9874
TEST_TIME 82 9853
TEST_TIME 83 9800
TEST_TIME 84 9907
TEST_TIME 85 9884
TEST_TIME 86 9882
TEST_TIME 87 9977
TEST_TIME 88 9997
TEST_TIME 89 9928
TEST_TIME 90 9910
TEST_TIME 91 9857
TEST_TIME 92 9865
TEST_TIME 93 9838
TEST_TIME 94 9786
TEST_TIME 95 9754
TEST_TIME 96 9744
TEST_TIME 97 9732
TEST_TIME 98 9764
TEST_TIME 99 9761
TEST_TIME 100 9812
TEST_TIME 101 9820
TEST_TIME 102 9841
TEST_TIME 103 9812
TEST_TIME 104 9856
TEST_TIME 105 9844
TEST_TIME 106 9893
TEST_TIME 107 9881
TEST_TIME 108 9926
TEST_TIME 109 9892
TEST_TIME 110 9874
TEST_TIME 111 9829
TEST_TIME 112 9766
TEST_TIME 113 9776
TEST_TIME 114 9757
TEST_TIME 115 9754
TEST_TIME 116 9720
TEST_TIME 117 9722
TEST_TIME 118 9680
TEST_TIME 119 9661
TEST_TIME 120 9583

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-12-2020 22:28:56 to 01-12-2020 22:29:00.

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 1601365 1601365 0 0.00 0 28167 6 0 0
doc_list_biud 1601361 1601361 0 0.00 0 97328 26 0 0
sp_add_invoice_to_stock 5286 5166 120 2.27 28 199764 16967 0 120
sp_cancel_adding_invoice 5746 5746 0 0.00 4 60822 871 0 0
sp_cancel_client_order 1763 1763 0 0.00 4 10081 355 0 0
sp_cancel_customer_reserve 571322 571322 0 0.00 1 24297 57 0 0
sp_cancel_pay_from_customer 728 728 0 0.00 3 8303 91 0 0
sp_cancel_pay_to_supplier 385 385 0 0.00 3 3069 59 0 0
sp_cancel_supplier_invoice 6360 6350 10 0.15 2 97341 823 0 10
sp_cancel_supplier_order 434 434 0 0.00 6 916562 95758 0 0
sp_cancel_write_off 10334 10334 0 0.00 1 18922 109 0 0
sp_client_order 20951 20951 0 0.00 3 16415 346 0 0
sp_customer_reserve 490444 490444 0 0.00 0 40185 164 0 0
sp_fill_shopping_cart 32130 32130 0 0.00 1 10024 38 0 0
sp_fill_shopping_cart_clo_res 490439 490439 0 0.00 0 16088 12 0 0
sp_get_clo_for_invoice 5160 5160 0 0.00 0 25978 271 0 0
sp_kill_cost_storno 17193 17193 0 0.00 0 28157 52 0 0
sp_kill_qstorno_ret_qs2qd 1159762 1159762 0 0.00 0 97320 31 0 0
sp_kill_qty_storno 611246 611246 0 0.00 0 97324 67 0 0
sp_lock_selected_doc 21112 21112 0 0.00 0 9095 5 0 0
sp_make_cost_storno 28412 28412 0 0.00 0 12390 49 0 0
sp_multiply_rows_for_pdistr 28410 28410 0 0.00 0 7401 27 0 0
sp_multiply_rows_for_qdistr 20950 20950 0 0.00 0 13471 165 0 0
sp_pay_from_customer 7124 7124 0 0.00 4 16411 108 0 0
sp_pay_to_supplier 5989 5989 0 0.00 4 9992 116 0 0
sp_payment_common 13113 13113 0 0.00 1 6026 25 0 0
sp_qd_handle_on_cancel_clo 1763 1763 0 0.00 0 10075 327 0 0
sp_qd_handle_on_invoice_upd_sts 10904 10904 0 0.00 0 25012 329 0 0
sp_qd_handle_on_reserve_upd_sts 10139 10139 0 0.00 0 10844 53 0 0
sp_reserve_write_off 10139 10139 0 0.00 6 16188 161 0 0
sp_supplier_invoice 5548 5548 0 0.00 6 104773 3475 0 0
sp_supplier_order 5633 5633 0 0.00 5 31264 1363 0 0
srv_aggregate_perf_data 102 102 0 0.00 2358 409007 23662 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1393 137664 33985 0 0
srv_find_qd_qs_mism 1099195 1099195 0 0.00 0 19234 5 0 0
srv_make_invnt_saldo 568 568 0 0.00 40 31843 943 0 0
srv_make_money_saldo 754 754 0 0.00 0 10107 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 158736 469791 285735 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5167 5167 0 0.00 0 15959 151 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 2115 65 0 0
t$perf-norm:sp_cancel_client_order 1763 1763 0 0.00 0 1312 8 0 0
t$perf-norm:sp_cancel_customer_reserve 694 694 0 0.00 0 9709 27 0 0
t$perf-norm:sp_cancel_pay_from_customer 728 728 0 0.00 0 4293 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 385 385 0 0.00 0 2193 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 430 430 0 0.00 0 401 8 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 36453 1847 0 0
t$perf-norm:sp_cancel_write_off 952 952 0 0.00 0 2425 10 0 0
t$perf-norm:sp_client_order 20951 20951 0 0.00 0 15210 18 0 0
t$perf-norm:sp_customer_reserve 977 977 0 0.00 0 2413 9 0 0
t$perf-norm:sp_pay_from_customer 7124 7124 0 0.00 0 9584 10 0 0
t$perf-norm:sp_pay_to_supplier 5989 5989 0 0.00 0 6630 9 0 0
t$perf-norm:sp_reserve_write_off 10139 10139 0 0.00 0 9559 11 0 0
t$perf-norm:sp_supplier_invoice 5548 5548 0 0.00 0 7617 18 0 0
t$perf-norm:sp_supplier_order 5633 5633 0 0.00 0 12623 25 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 76 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 449 5 0 0
t$perf-norm:srv_make_invnt_saldo 568 568 0 0.00 0 828 19 0 0
t$perf-norm:srv_make_money_saldo 754 754 0 0.00 0 896 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10556 10316 240 2.27 0 18352 21 0 240
v_all_customers 38132 38132 0 0.00 0 23 1 0 0
v_all_suppliers 31244 31244 0 0.00 0 20 1 0 0
v_all_wares 41900 41900 0 0.00 0 73 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 606 6 0 0
v_cancel_client_order 3526 3526 0 0.00 0 4305 6 0 0
v_cancel_customer_prepayment 1456 1456 0 0.00 0 8285 14 0 0
v_cancel_customer_reserve 1388 1388 0 0.00 0 404 3 0 0
v_cancel_payment_to_supplier 770 770 0 0.00 0 906 5 0 0
v_cancel_supplier_invoice 880 860 20 2.27 0 2094 13 0 20
v_cancel_supplier_order 868 868 0 0.00 0 1102 4 0 0
v_cancel_write_off 1904 1904 0 0.00 0 17940 34 0 0
v_max_id_clo_ord 5633 5633 0 0.00 0 1104 1 0 0
v_max_id_clo_res 977 977 0 0.00 0 2549 17 0 0
v_max_id_ord_sup 5547 5547 0 0.00 0 5048 5 0 0
v_max_non_paid_invoice 1547 1547 0 0.00 0 4722 6 0 0
v_max_non_paid_realizn 3860 3860 0 0.00 0 1967 3 0 0
v_min_id_clo_ord 5633 5633 0 0.00 0 3846 4 0 0
v_min_id_clo_res 977 977 0 0.00 0 4546 15 0 0
v_min_id_ord_sup 5547 5547 0 0.00 0 6892 8 0 0
v_min_non_paid_invoice 5989 5989 0 0.00 0 5708 18 0 0
v_min_non_paid_realizn 7124 7124 0 0.00 0 6024 13 0 0
v_our_firm 10296 10296 0 0.00 0 18 1 0 0
v_reserve_write_off 20278 20278 0 0.00 0 16142 6 0 0
x_lock_depdocs_on_canc_invoice 11666 11666 0 0.00 0 19036 111 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 14205 305 0 0
x_make_qstorno_1000_1200 5633 5633 0 0.00 2 31249 1288 0 0
x_make_qstorno_1200_2000 5548 5548 0 0.00 3 94745 3331 0 0
x_make_qstorno_2100_3300 490444 490444 0 0.00 0 37724 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-12-2020 22:29:01 to 01-12-2020 22:29:05.

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
19:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:12 24783 8192000000 10274999392 10583781376 1008181488 10.958 77 58 117 1 1029852480 2931392 18739600
19:57:47 33003 8192000000 10347705536 10667450368 1398157456 14.579 100 82 164 0 1429906736 5691280 26058000
19:58:34 29091 8192000000 10402429680 10724573184 1451698736 15.053 100 94 188 0 1490306144 7481392 31126016
19:59:17 20063 8192000000 10400747152 10734620672 1462884816 15.151 100 84 168 0 1498497616 8555968 27056832
19:59:48 18585 8192000000 10441422640 10776563712 1494282688 15.426 100 89 176 1 1531363808 8697264 28383856
20:00:17 20625 8192000000 10472316176 10807914496 1518321952 15.636 100 86 172 0 1554964864 9502880 27140032
20:00:52 8444 8192000000 10483359904 10823348224 1535378880 15.784 100 88 176 0 1573826016 10647104 27800032
20:01:12 17123 8192000000 10499306336 10844151808 1556991616 15.970 100 87 174 0 1595136064 11214176 26930272
20:01:41 10207 8192000000 10518462432 10867929088 1571441104 16.095 100 80 160 0 1607176384 11352528 24382752
20:02:00 8514 8192000000 10524178256 10880266240 1585175776 16.213 100 79 158 2 1620871296 11335376 24360144
20:02:17 12991 8192000000 10555715456 10912952320 1605945152 16.390 100 81 162 0 1641407808 11145408 24317248
20:02:38 11157 8192000000 10577578928 10937909248 1632770976 16.618 100 80 160 1 1668548320 11642592 24134752
20:02:56 11868 8192000000 10591561328 10954596352 1651560912 16.778 100 81 162 0 1688030064 12314336 24154816
20:03:16 9267 8192000000 10604791184 10968915968 1661478096 16.861 100 81 160 1 1697857520 12750064 23629360
20:03:34 11374 8192000000 10621338848 10990374912 1678290960 17.003 100 80 159 4 1714800560 13062976 23446624
20:03:54 8662 8192000000 10646188144 11013181440 1704876192 17.226 100 82 163 1 1741494688 12966144 23652352
20:04:12 6962 8192000000 10658052128 11030265856 1716336384 17.322 100 75 150 1 1750480240 12729120 21414736
20:04:28 5237 8192000000 10673947904 11050471424 1736155040 17.487 100 76 152 1 1770132592 12823968 21153584
20:04:40 4927 8192000000 10690220192 11065794560 1752649072 17.624 100 81 162 0 1789062544 13492688 22920784
20:04:53 4982 8192000000 10699021584 11078086656 1759690096 17.682 100 83 166 1 1796262848 13464304 23108448
20:05:05 4403 8192000000 10706236752 11086811136 1770537072 17.771 100 85 169 2 1807568336 13694864 23336400
20:05:16 5287 8192000000 10721240096 11099029504 1776681712 17.822 100 82 164 1 1813572352 13912752 22977888
20:05:28 3804 8192000000 10730592992 11108864000 1788308608 17.918 100 82 164 0 1827874096 18012432 21553056
20:05:39 4240 8192000000 10733505472 11121975296 1797458096 17.993 100 77 153 0 1830785968 12443584 20884288
20:05:50 4071 8192000000 10743300752 11129114624 1805240400 18.057 100 78 156 0 1839166304 12558384 21367520
20:06:01 2720 8192000000 10760135296 11141140480 1814038864 18.129 100 84 166 0 1850860048 13390560 23430624
20:06:10 5259 8192000000 10766852624 11149684736 1819639232 18.175 100 92 182 1 1859133584 14456096 25038256
20:06:25 5891 8192000000 10759020336 11148951552 1821250704 18.188 100 82 158 1 1857326640 14558832 21517104
20:06:38 2544 8192000000 10787682992 11170721792 1837079936 18.317 100 82 164 0 1872189104 12482976 22626192
20:06:48 1845 8192000000 10783118400 11171549184 1846279792 18.392 100 98 196 2 1885498704 12362784 26856128
20:06:56 1392 8192000000 10801368224 11188252672 1854504960 18.459 100 95 190 0 1895258240 13575776 27177504
20:07:04 2384 8192000000 10797311408 11190353920 1858366960 18.490 100 85 170 1 1895304800 12921840 24016000
20:07:13 3273 8192000000 10808630208 11196502016 1860687920 18.509 100 88 177 1 1898822576 13092432 25042224
20:07:23 2775 8192000000 10811555264 11199991808 1865241472 18.546 100 88 176 0 1903682384 13593456 24847456
20:07:32 1945 8192000000 10819079504 11206393856 1869472544 18.580 100 99 199 0 1911481424 14310896 27697984
20:07:40 1870 8192000000 10806372112 11203588096 1872198912 18.602 100 87 174 1 1909797008 12368912 25229184
20:07:49 1768 8192000000 10816864096 11205664768 1874164816 18.618 100 89 178 1 1911356624 12009920 25181888
20:07:57 1257 8192000000 10811740000 11205931008 1875635248 18.630 100 87 174 4 1913501264 12332784 25533232
20:08:05 2310 8192000000 10824081776 11213406208 1877965216 18.649 100 92 186 1 1916465760 12085904 26414640
20:08:15 6942 8192000000 10830632016 11218915328 1880205632 18.667 100 83 167 2 1915998736 12787632 23005472
20:08:28 1398 8192000000 10822137728 11218403328 1883570992 18.694 100 91 182 0 1924042624 14921712 25549920
20:08:36 33655 8192000000 10783547760 11209203712 1871264384 18.595 100 36 72 0 1889742880 8464928 10013568
20:09:16 3026 8192000000 10796333648 11212754944 1875306608 18.627 100 38 75 2 1893848320 7358912 11182800
20:09:27 3478 8192000000 10804233216 11218894848 1881916640 18.681 100 44 86 0 1902070656 8516880 11637136
20:09:37 6075 8192000000 10804710944 11230728192 1884348288 18.700 100 39 77 0 1907365456 12529952 10487216
20:09:49 5346 8192000000 10797141504 11227643904 1887290880 18.724 100 31 62 1 1911917744 15306496 9320368
20:10:01 5775 8192000000 10799597440 11227549696 1888468912 18.733 100 30 60 2 1903255328 6158160 8628256
20:10:13 6526 8192000000 10790610256 11227029504 1892449344 18.766 100 25 50 2 1905894064 6684864 6759856
20:10:28 7458 8192000000 10794345600 11228958720 1891492032 18.758 100 23 46 1 1904606832 6852992 6261808
20:10:42 9143 8192000000 10803223376 11232899072 1893439184 18.773 100 24 50 1 1906301120 6285968 6575968
20:10:59 8310 8192000000 10797236864 11232145408 1894634784 18.783 100 20 40 0 1905556640 5717728 5204128
20:11:14 11221 8192000000 10807017440 11238871040 1894770800 18.784 100 19 38 1 1906155040 6080592 5303648
20:11:32 9212 8192000000 10803132096 11238912000 1898268960 18.812 100 16 32 3 1908781936 6047872 4465104
20:11:51 7372 8192000000 10806127520 11242176512 1901288288 18.837 100 25 51 1 1914527424 6571296 6667840
20:12:04 7804 8192000000 10807846016 11243327488 1901050016 18.835 100 16 32 1 1911775600 5895152 4830432
20:12:22 72525 8192000000 10848775280 11259334656 1909046320 18.899 100 41 81 2 1931397488 9228336 13122832
20:13:40 3660 8192000000 10829959776 11262590976 1913719696 18.936 100 46 94 0 1935276416 8606352 12950368
20:13:50 9054 8192000000 10833141184 11259371520 1911624720 18.920 100 29 58 0 1926671824 6944848 8102256
20:14:06 5681 8192000000 10828936704 11266240512 1914130048 18.940 100 34 68 0 1932150960 8716992 9303920
20:14:18 4008 8192000000 10854801472 11274326016 1915650976 18.952 100 41 81 3 1939298512 11874864 11772672
20:14:29 6999 8192000000 10840730192 11270246400 1916640256 18.960 100 29 58 1 1935263088 10689936 7932896
20:14:42 5058 8192000000 10832083984 11264348160 1915220944 18.949 100 32 64 3 1930977328 6250368 9506016
20:14:57 4927 8192000000 10839785760 11270725632 1917467744 18.967 100 29 58 1 1931629904 6014304 8147856
20:15:08 7596 8192000000 10829951024 11267985408 1916205280 18.956 100 22 44 0 1928261200 6040864 6015056
20:15:22 7621 8192000000 10829678336 11266899968 1918285840 18.973 100 26 52 0 1931732016 5676080 7770096
20:15:39 11005 8192000000 10837271712 11271409664 1918633536 18.976 100 14 28 1 1927622672 4948576 4040560
20:15:58 8844 8192000000 10815947264 11249188864 1867464528 18.564 97 38 74 1 1884319168 4587856 12266784
20:16:17 62156 8192000000 10806701136 11245105152 1898720832 18.816 100 28 55 0 1912647328 5268544 8657952
20:17:26 11015 8192000000 10806825264 11239682048 1846308912 18.392 97 17 35 0 1856848272 5544032 4995328
20:17:48 5870 8192000000 10788654736 11217899520 1839385840 18.336 98 16 32 2 1850022400 5665584 4970976
20:18:03 6400 8192000000 10754051584 11186987008 1785756928 17.897 95 17 34 0 1800438480 9984176 4697376
20:18:18 5614 8192000000 10732955056 11149721600 1736669696 17.491 94 24 48 1 1749366304 5416144 7280464
20:18:34 3295 8192000000 10730127552 11148996608 1814010528 18.129 100 19 38 1 1825318256 5840336 5467392
20:18:46 5698 8192000000 10689492720 11103285248 1756963024 17.659 98 16 32 1 1767411392 5218208 5230160
20:18:58 6722 8192000000 10684322480 11098533888 1689980592 17.101 94 16 32 4 1699145552 4831616 4333344
20:19:12 8225 8192000000 10720291792 11124555776 1763055072 17.710 98 30 59 0 1777588432 5383408 9149952
20:19:27 7041 8192000000 10726370880 11136479232 1773185248 17.793 98 25 49 2 1785922160 4918016 7818896
20:19:45 10063 8192000000 10731278624 11157094400 1797617040 17.994 99 23 46 1 1810451904 6007552 6827312
20:20:01 6636 8192000000 10729292176 11137597440 1775967232 17.816 98 32 65 1 1791796448 6795040 9034176
20:20:14 7423 8192000000 10697864256 11114000384 1751620224 17.615 97 27 53 0 1768875456 10010672 7244560
20:20:31 9943 8192000000 10696599888 11102826496 1723980816 17.385 97 18 36 0 1734355200 5057392 5316992
20:20:50 67488 8192000000 10703282880 11119226880 1728493104 17.423 96 44 88 1 1747054080 6059536 12501440
20:22:04 9352 8192000000 10696551808 11116376064 1759054928 17.677 98 21 41 0 1771279776 5873488 6351360
20:22:22 4590 8192000000 10717204896 11132301312 1783625408 17.879 99 30 60 0 1798789216 5944752 9219056
20:22:33 9248 8192000000 10747080416 11160129536 1814750880 18.135 100 25 48 0 1826961840 5546960 6664000
20:22:52 8319 8192000000 10739563936 11161231360 1825287776 18.221 100 30 60 3 1843482400 10097856 8096768
20:23:09 4032 8192000000 10748542144 11168497664 1833014944 18.284 100 39 77 3 1850702768 6370224 11317600
20:23:19 7110 8192000000 10757874160 11180572672 1842795760 18.364 100 32 60 2 1857453968 5432240 9225968
20:23:33 9283 8192000000 10762117424 11188264960 1844183168 18.375 100 20 40 1 1855508272 5659072 5666032
20:23:50 11982 8192000000 10766752224 11191861248 1850360048 18.425 100 23 47 2 1862429248 5756944 6312256
20:24:10 10139 8192000000 10778804304 11198619648 1853324704 18.449 100 22 43 1 1863916752 4951728 5640320
20:24:27 10650 8192000000 10785922976 11208577024 1861961920 18.519 100 38 76 1 1883502672 10656096 10884656
20:24:45 8668 8192000000 10785419056 11209723904 1861094144 18.512 100 25 49 0 1874632608 5645952 7892512
20:25:00 14310 8192000000 10769757088 11207766016 1865360560 18.547 100 13 25 1 1874659616 5780832 3518224
20:25:21 10763 8192000000 10776435376 11209793536 1867341184 18.563 100 19 38 0 1878349696 5799280 5209232
20:25:39 54982 8192000000 10791925536 11212468224 1873482208 18.612 100 34 67 4 1888803280 5514672 9806400
20:26:40 30215 8192000000 10791425440 11217977344 1872491296 18.604 100 24 47 0 1885017760 5695504 6830960
20:27:16 11214 8192000000 10829564400 11246206976 1898078112 18.811 100 51 102 3 1919442384 7261920 14102352
20:27:35 39217 8192000000 10837546448 11261153280 1905968144 18.874 100 57 112 5 1930477136 9198112 15310880
20:28:21 7250 8192000000 10850849792 11267190784 1916355024 18.958 100 55 107 1 1939977312 9334080 14288208
20:28:42 18582 8192000000 10853778080 11275362304 1921198992 18.996 100 45 88 1 1941508176 8416608 11892576
20:29:08 20960 8192000000 10864253312 11290021888 1937192688 19.124 100 53 106 2 1962264096 10209024 14862384
20:29:40 17577 8192000000 10879990368 11303305216 1943607472 19.176 100 50 100 0 1968457632 11089584 13760576
20:30:08 20560 8192000000 10885501840 11314311168 1947902976 19.210 100 43 86 1 1971570496 11526656 12140864
20:30:38 24544 8192000000 10889460144 11320610816 1953352400 19.253 100 50 100 0 1981730128 14514832 13862896
20:31:10 13409 8192000000 10882036848 11315941376 1940651216 19.152 99 53 106 1 1969522080 13755200 15115664
20:31:35 10867 8192000000 10897450480 11323138048 1957556144 19.287 100 49 98 1 1985433760 13641328 14236288
20:31:53 5114 8192000000 10914180000 11329601536 1968920256 19.377 100 59 118 1 2000021184 13941424 17159504
20:32:09 9654 8192000000 10916633072 11341107200 1972264016 19.403 100 57 114 1 2004791024 15426896 17100112
20:32:27 2654 8192000000 10925110288 11345350656 1977360960 19.444 100 64 128 3 2011450288 15290272 18799056
20:32:37 21297 8192000000 10909647088 11346042880 1977027232 19.441 100 59 118 0 2011454688 16692624 17734832
20:33:26 12213 8192000000 10912987536 11351928832 1981255184 19.475 100 39 78 0 2010148640 17002576 11890880
20:33:48 14736 8192000000 10932516512 11363213312 1988726320 19.534 100 41 82 1 2018540800 17467344 12347136
20:34:10 3723 8192000000 10938116112 11368157184 1992046080 19.560 100 48 96 0 2026178192 20308048 13824064
20:34:23 21941 8192000000 10946324816 11380015104 2001133312 19.632 100 62 124 1 2040029680 20679216 18217152
20:34:55 10872 8192000000 10952103184 11383238656 2000444512 19.626 100 50 100 0 2039548384 23335936 15767936
20:35:13 16277 8192000000 10953363488 11385929728 2000299360 19.625 100 55 110 2 2042415568 24636544 17479664
20:35:52 9471 8192000000 10958465552 11394265088 2008761648 19.692 100 54 107 0 2052605776 26288176 17555952
20:36:09 13459 8192000000 10963904320 11401469952 2010409696 19.705 100 47 94 1 2052783920 27126736 15247488
20:36:29 32678 8192000000 10965792864 11414413312 2019549808 19.777 100 50 100 0 2064769824 29052992 16167024
20:37:10 8381 8192000000 10972564416 11411529728 2016461360 19.752 100 52 104 3 2062032896 28870784 16700752
20:37:34 7494 8192000000 10987830256 11416272896 2022505872 19.800 100 62 120 4 2072599600 30495680 19598048
20:37:51 6634 8192000000 10981967824 11413016576 2016252512 19.751 100 70 138 1 2069474624 31990800 21231312
20:38:06 3496 8192000000 10977169536 11403952128 1993668144 19.573 99 66 132 1 2050656656 36751632 20236880
20:38:21 4959 8192000000 10989555936 11409440768 2012740272 19.723 100 65 128 1 2065787392 32931168 20115952
20:38:33 8140 8192000000 10979768064 11412267008 2011769376 19.715 100 56 112 0 2063414144 34460032 17184736
20:38:50 2799 8192000000 10989709856 11417927680 2022549120 19.800 100 63 126 0 2075121824 32753792 19818912
20:39:00 4626 8192000000 10986710928 11414593536 2017485824 19.760 100 85 170 1 2079093360 35375936 26231600
20:39:13 11017 8192000000 10978846144 11404124160 2006325968 19.673 100 72 144 0 2063532544 35187696 22018880
20:39:31 9124 8192000000 10965534320 11398828032 2007185728 19.679 100 70 139 3 2061951600 33898976 20866896
20:39:50 7241 8192000000 10969507616 11409473536 2008381472 19.689 100 51 102 2 2057181136 32988496 15811168
20:40:05 14187 8192000000 10969923568 11410161664 2019447328 19.776 100 58 115 0 2068640592 31514832 17678432
20:40:26 5358 8192000000 10967167104 11398848512 2004641440 19.659 99 65 132 0 2049786960 25559728 19585792
20:40:38 11748 8192000000 10972552528 11412365312 2017161104 19.758 100 55 108 0 2060202272 26886656 16154512
20:40:57 7873 8192000000 10971792208 11403169792 2010636464 19.707 100 58 116 1 2059182704 30738304 17807936
20:41:12 5817 8192000000 10985165136 11413401600 2015386912 19.744 100 65 125 1 2066610640 32101984 19121744
20:41:25 2378 8192000000 10991375840 11417989120 2019023136 19.772 100 75 150 4 2076295184 33921152 23350896
20:41:37 3753 8192000000 11000399072 11429359616 2023642480 19.809 100 74 148 1 2082614240 35803456 23168304
20:41:47 6088 8192000000 10999037168 11430596608 2029951440 19.858 100 72 145 0 2089334896 35899408 23484048
20:42:01 2562 8192000000 10977951152 11400237056 2000370960 19.626 99 73 149 1 2061052320 37098784 23582576
20:42:15 3229 8192000000 10982437296 11417845760 2010971728 19.709 100 62 122 0 2068747984 38375744 19400512
20:42:25 3501 8192000000 10997833232 11419865088 2014076848 19.734 100 72 145 1 2073468224 36196784 23194592
20:42:38 10527 8192000000 10988111712 11423477760 2011961680 19.717 100 57 114 0 2068370112 38193136 18215296
20:42:58 9931 8192000000 10981024928 11431071744 2019558400 19.777 100 56 112 0 2076845424 39482880 17804144
20:43:24 7004 8192000000 10963255280 11399770112 1984982944 19.504 99 55 110 1 2032856304 31118912 16754448
20:43:41 7207 8192000000 10939054336 11364245504 1957114048 19.283 99 75 150 0 2010691472 29470944 24106480
20:43:57 4035 8192000000 10945495088 11364106240 1970919920 19.393 100 74 149 2 2023734096 30758576 22055600
20:44:11 3346 8192000000 10945449856 11369541632 1971350832 19.396 100 73 145 1 2026779728 32513248 22915648
20:44:21 2615 8192000000 10948472704 11369070592 1957248800 19.284 99 77 154 0 2015336048 34539824 23547424
20:44:34 4237 8192000000 10953747120 11369005056 1958050688 19.291 99 87 174 3 2022430144 36538192 27841264
20:44:46 5136 8192000000 10963742672 11379027968 1978033360 19.449 100 73 146 2 2038598720 37547776 23017584
20:45:00 1392 8192000000 10938645904 11355389952 1958875424 19.297 100 72 142 1 2018705376 37940064 21889888
20:45:11 4073 8192000000 10946948768 11365470208 1964223184 19.340 100 81 160 2 2028246320 39620336 24402800
20:45:23 3283 8192000000 10957419520 11378356224 1975636176 19.430 100 83 166 1 2043192720 41964736 25591808
20:45:33 2858 8192000000 10962082944 11382054912 1977646816 19.446 100 74 148 1 2042321680 41703792 22971072
20:45:42 4840 8192000000 10957879616 11394043904 1986647632 19.517 100 51 102 0 2043649168 41406816 15594720
20:45:55 15575 8192000000 10936594784 11382378496 1944460928 19.182 98 38 76 1 1995399696 38810304 12128464
20:46:31 6158 8192000000 10940517600 11372568576 1952703328 19.248 99 55 108 4 2010820576 40759712 17357536
20:46:43 7822 8192000000 10936597360 11371311104 1950182624 19.228 99 43 86 1 2004596864 40453680 13960560
20:46:58 10574 8192000000 10939320016 11372994560 1948995616 19.218 99 35 70 1 2003700896 42135552 12569728
20:47:20 9959 8192000000 10947919440 11378216960 1965548416 19.350 100 66 130 4 2034108064 47616864 20942784
20:47:37 5291 8192000000 10915840096 11342438400 1927267456 19.045 98 57 114 0 1996822944 50744016 18811472
20:47:49 25722 8192000000 10928015744 11375837184 1956532608 19.278 100 36 72 0 2020498048 51250112 12715328
20:48:23 17340 8192000000 10916260192 11365007360 1953241808 19.252 100 34 66 3 2010521056 45577632 11701616
20:48:48 21461 8192000000 10919993728 11373789184 1952062112 19.243 100 35 70 1 2011619168 47225360 12331696
20:49:21 8158 8192000000 10928233824 11374694400 1965195504 19.347 100 36 70 3 2017179904 39939008 12045392
20:49:37 17284 8192000000 10897230640 11358904320 1935540736 19.111 99 31 62 2 1979146416 33559648 10046032
20:50:01 13290 8192000000 10911900704 11360604160 1951297728 19.237 100 27 52 2 1991056224 30891632 8866864
20:50:22 24700 8192000000 10908751184 11364814848 1935422960 19.110 99 35 71 0 1981311136 34678048 11210128
20:51:06 34088 8192000000 10867582096 11317579776 1870944000 18.592 97 29 58 1 1914222896 33551312 9727584
20:52:07 46346 8192000000 10835105840 11276902400 1842335232 18.360 96 19 39 0 1877085088 28551760 6198096
20:53:17 24449 8192000000 10830779184 11277832192 1875452256 18.628 99 37 74 1 1916420032 28801040 12166736
20:53:48 32885 8192000000 10819152432 11274072064 1854270960 18.457 99 17 33 4 1891554960 30805696 6478304
20:54:27 33570 8192000000 10799242112 11263377408 1823558000 18.207 98 10 20 1 1850021600 22863424 3600176
20:55:33 39541 8192000000 10842608480 11260604416 1836634352 18.313 97 40 79 1 1861147264 12784848 11728064
20:56:22 38309 8192000000 10831869504 11279781888 1886814688 18.720 99 24 48 3 1905960624 12581760 6564176
20:57:06 88631 8192000000 10888619664 11320279040 1896795824 18.801 99 15 29 0 1913482016 12823440 3862752
20:58:47 32509 8192000000 10903355920 11326009344 1930838272 19.074 99 49 92 0 1960179200 16024800 13316128
20:59:29 42294 8192000000 10891746352 11325218816 1933303552 19.093 99 48 93 1 1959177744 12426256 13447936
21:00:30 55474 8192000000 10872286576 11331645440 1902153232 18.844 98 12 24 0 1917998288 12534864 3310192
21:01:34 78196 8192000000 10867388480 11322687488 1889772160 18.744 97 10 20 1 1907843792 15391280 2680352
21:03:12 61781 8192000000 10888682288 11355004928 1949433024 19.222 100 7 12 1 1963768800 12398992 1936784
21:04:23 89181 8192000000 10885276576 11350540288 1927767584 19.049 98 12 24 1 1947074640 16154096 3152960
21:06:12 46812 8192000000 10911372384 11344994304 1915873360 18.954 97 43 86 1 1939382416 10907456 12601600
21:07:05 24196 8192000000 10883815008 11332722688 1947768656 19.209 99 56 113 3 1972240688 8605936 15866096
21:07:56 113147 8192000000 10897624112 11366891520 1967517776 19.366 100 33 65 4 1987631824 10756512 9357536
21:09:59 45545 8192000000 10915922432 11365756928 1954208944 19.260 99 40 80 0 1975494384 10370592 10914848
21:10:51 92581 8192000000 10907147056 11372322816 1979142864 19.458 100 27 54 4 1999482048 12668592 7670592
21:12:32 34197 8192000000 10917686400 11373314048 1966159136 19.355 99 18 36 0 1982926176 11632640 5134400
21:13:24 26526 8192000000 10942791808 11391000576 1992445408 19.563 100 49 94 2 2021718672 14581856 14691408
21:14:13 31152 8192000000 10929452736 11403186176 1996756176 19.597 100 17 34 0 2014203184 12467312 4979696
21:14:56 38904 8192000000 10914468112 11388465152 1963405056 19.333 98 18 36 1 1979136128 10740848 4990224
21:15:42 32787 8192000000 10908452576 11389239296 1991091712 19.552 100 15 30 2 2007670272 12053152 4525408
21:17:34 23548 8192000000 10927033776 11411787776 2003070880 19.647 100 5 10 0 2020092928 15660640 1361408
21:19:00 71628 8192000000 10939805712 11415371776 1999381792 19.618 100 21 43 1 2027905488 23203024 5320672
21:20:19 62595 8192000000 10939962064 11407224832 2004326848 19.657 100 9 18 1 2020729072 13411808 2990416
21:21:31 53810 8192000000 10956246320 11415662592 1971164560 19.395 98 27 54 0 1986718864 8180560 7373744
21:22:32 33730 8192000000 10920904320 11395637248 1963873488 19.337 98 16 32 0 1978567888 10062464 4631936
21:23:20 61574 8192000000 10910069168 11382833152 1935481472 19.111 97 13 25 1 1950253168 11105472 3666224
21:24:27 46158 8192000000 10883675968 11357483008 1903285584 18.853 96 15 30 1 1916681904 9230912 4165408
21:25:20 67795 8192000000 10892470384 11366563840 1901264736 18.836 96 21 42 1 1916491120 9793088 5433296
21:26:35 56103 8192000000 10908620160 11384868864 1974244832 19.419 100 17 34 1 1991251312 12192496 4813984
21:27:40 43210 8192000000 10881489120 11332460544 1839752048 18.339 93 17 32 1 1853773632 9832464 4189120
21:28:34 47545 8192000000 10883749440 11354615808 1937698144 19.128 99 19 36 3 1953345888 10482000 5165744
21:29:33 87778 8192000000 10872615568 11349372928 1824057008 18.211 93 4 8 0 1841921440 17153392 711040
21:31:07 35061 8192000000 10889065520 11340681216 1881971584 18.681 96 36 73 1 1907618176 15440192 10206400
21:31:48 35350 8192000000 10899016752 11339587584 1893926656 18.777 97 36 71 1 1915290448 10796160 10567632
21:32:30 132337 8192000000 10862728976 11325456384 1889357664 18.741 97 36 72 0 1912042304 11966192 10718448
21:34:58 69896 8192000000 10882255488 11345444864 1926993632 19.043 99 31 61 1 1946960320 11806176 8160512
21:36:14 2879 8192000000 10885404688 11346952192 1948749776 19.217 100 35 70 0 1972223424 14150560 9323088
21:36:25 25108 8192000000 10870357168 11340800000 1943130768 19.172 100 19 38 1 1959577296 11050560 5395968
21:37:01 72417 8192000000 10834369792 11311017984 1833356928 18.287 94 14 28 0 1843711408 6830704 3523776
21:38:19 42358 8192000000 10848112592 11321507840 1926720336 19.041 100 19 36 3 1939834336 8021856 5092144
21:39:16 65172 8192000000 10854416160 11319955456 1906956224 18.882 98 20 40 0 1921763744 9421840 5385680
21:40:28 60421 8192000000 10863288336 11342065664 1947007296 19.203 100 8 16 0 1960412128 10981184 2423648
21:41:36 53071 8192000000 10850741376 11330805760 1893689600 18.776 97 23 46 1 1912201248 11724064 6787584
21:42:40 77365 8192000000 10818625984 11283689472 1855130608 18.464 96 13 26 0 1870000592 10930288 3939696
21:44:17 26862 8192000000 10834849264 11294560256 1898235728 18.812 99 30 60 1 1917201120 9632928 9332464
21:44:55 50392 8192000000 10817748272 11289964544 1846289664 18.392 96 16 32 0 1860906352 9902336 4714352
21:45:52 34744 8192000000 10826623408 11293032448 1860229008 18.505 97 20 39 0 1878134736 11962176 5943552
21:46:43 39217 8192000000 10853087232 11312967680 1914654560 18.944 100 35 70 1 1939749904 14971552 10123792
21:47:42 58603 8192000000 10846966448 11310063616 1846422544 18.393 96 26 52 1 1873527760 19076736 8028480
21:48:46 65415 8192000000 10853901200 11320107008 1889038736 18.738 98 19 38 1 1906721808 12260560 5422512
21:49:59 43921 8192000000 10871860448 11327414272 1914908880 18.946 99 21 42 0 1934266560 13358032 5999648
21:50:49 91641 8192000000 10882432944 11350413312 1906214528 18.876 98 24 48 0 1928240288 15196848 6828912
21:52:27 57404 8192000000 10895622112 11362619392 1936505328 19.119 99 15 30 1 1955039088 14279440 4254320
21:53:30 83453 8192000000 10909114080 11357454336 1938650544 19.136 99 17 34 0 1961305776 17567360 5087872
21:55:00 25190 8192000000 10901508080 11361837056 1965392896 19.349 100 35 70 1 1985188480 9962032 9833552
21:55:32 62842 8192000000 10895583008 11375448064 1967933168 19.369 100 23 46 2 1991651456 17230544 6487744
21:57:18 74997 8192000000 10898389648 11370237952 1943479440 19.175 98 26 52 1 1961157264 10597728 7080096
21:58:40 39773 8192000000 10915118464 11382915072 1976815248 19.439 100 22 44 1 1996218784 13168976 6234560
21:59:28 8317 8192000000 10918016816 11385487360 1983381728 19.491 100 19 38 1 1999463952 11103008 4979216
21:59:44 37523 8192000000 10896932784 11378569216 1967874864 19.369 99 15 30 1 1979261600 7325504 4061232
22:00:34 44861 8192000000 10878201296 11361345536 1924462336 19.023 97 7 14 1 1932643456 6361600 1819520
22:01:25 26069 8192000000 10889661536 11366297600 1954594640 19.263 99 9 18 0 1962332624 5570256 2167728
22:01:57 34183 8192000000 10885192080 11359318016 1934636976 19.104 98 12 25 0 1944474832 6631488 3206368
22:02:38 59758 8192000000 10904733552 11384553472 1958719376 19.296 99 14 28 0 1976932768 13985920 4227472
22:03:44 26605 8192000000 10901817312 11375988736 1961074240 19.315 99 13 26 1 1976275568 11263488 3937840
22:04:32 25838 8192000000 10918462784 11392598016 1985911024 19.511 100 17 34 0 2002482560 12163376 4408160
22:05:20 56528 8192000000 10942803408 11421933568 1999989616 19.623 100 17 34 1 2022909296 18639056 4280624
22:06:23 42972 8192000000 10946772480 11406950400 1988096368 19.529 99 26 52 0 2011074464 14978688 7999408
22:07:19 50347 8192000000 10919663056 11397373952 1976026912 19.433 99 15 30 3 1993544464 13298096 4219456
22:08:40 37271 8192000000 10907955584 11376427008 1920262880 18.989 96 29 56 1 1936377024 8647440 7466704
22:09:26 76765 8192000000 10899060304 11364864000 1900206992 18.828 96 12 24 0 1915348272 11958624 3182656
22:10:59 104949 8192000000 10901668176 11372126208 1902371136 18.845 96 32 65 2 1924393952 12536560 9486256
22:12:57 88246 8192000000 10876722336 11339788288 1813826672 18.127 92 8 16 0 1827530432 11903584 1800176
22:14:32 120326 8192000000 10880561168 11346612224 1845334656 18.384 94 8 16 1 1858820320 11577568 1908096
22:16:45 47057 8192000000 10879836688 11340300288 1917996928 18.971 98 22 44 0 1935935920 11726576 6212416
22:18:29 137664 8192000000 10872187584 11349250048 1920244288 18.989 98 27 54 1 1942726592 13958672 8523632
22:20:56 68270 8192000000 10869328896 11355267072 1915320592 18.949 98 20 40 1 1932111824 10747376 6043856
22:22:11 70278 8192000000 10861102736 11332898816 1889932720 18.745 97 12 24 1 1902972032 9521424 3517888
22:23:30 47671 8192000000 10865537712 11343114240 1929799008 19.065 99 13 27 2 1942408464 9043696 3565760
22:24:26 58081 8192000000 10856472704 11337371648 1922795888 19.009 99 14 28 0 1939034816 11551792 4687136
22:25:30 53052 8192000000 10869769968 11349221376 1928432368 19.054 99 16 32 2 1940763584 7793040 4538176
22:26:44 33480 8192000000 9314586832 9597751296 399374800 4.648 21 3 4 1 404997616 4749408 873408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 01-12-2020 22:29:07 to 01-12-2020 22:29:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-12-2020 22:29:39 to 01-12-2020 22:29:41.

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          241811
MON$OLDEST_ACTIVE               241812
MON$OLDEST_SNAPSHOT             241812
MON$NEXT_TRANSACTION            241812
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                       2037408
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.33394 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33394 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33394 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33394 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 ---
:206: 
:207: mscs-test-161.budzdorov.ru    Tue Dec  1 22:27:19 2020
:208:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:209: 
--- end of diff output ---

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

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