Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.01.2021 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 17294520 kB
MemAvailable 31313868 kB
Buffers 0 kB
Cached 14426948 kB
SwapCached 4868 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-01-24 22:27:12
DTS_END                         2021-01-24 22:27:12.4700
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40300
TRN_ID                          235775
ATT_ID                          697
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: 9344.73 21943 1121368
customer order: creation 169.04 366 20285
customer order: refuse 14.57 347 1748
order to supplier: creation 46.74 1298 5609
order to supplier: removal 3.75 110424 450
invoice (draft): creation 44.98 3265 5397
invoice (draft): removal 53.78 806 6454
invoice accept: apply 41.39 18394 4967
invoice accept: cancel 49.16 849 5899
customer reserve: creation 3792.73 182 455127
customer reserve: removal 4836.66 69 580399
realization accept: apply 83.02 199 9962
realization accept: cancel 79.60 109 9552
payment from customer: creation 59.80 104 7176
payment from customer: removal 5.41 59 649
payment to supplier: creation 48.55 118 5826
payment to supplier: removal 3.25 98 390
service: total inventory turnovers 5.18 909 622
service: total monetary turnovers 6.28 24 753
service: aggregate perf. data 0.83 21610 99
service: refresh index statistics 0.03 279635 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-01-2021 22:28:49 to 24-01-2021 22:28:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6078
TEST_TIME 2 6547
TEST_TIME 3 5830
TEST_TIME 4 5815
TEST_TIME 5 5954
TEST_TIME 6 5621
TEST_TIME 7 5712
TEST_TIME 8 5890
TEST_TIME 9 5972
TEST_TIME 10 5940
TEST_TIME 11 5897
TEST_TIME 12 5826
TEST_TIME 13 6006
TEST_TIME 14 6041
TEST_TIME 15 6258
TEST_TIME 16 6422
TEST_TIME 17 6644
TEST_TIME 18 7735
TEST_TIME 19 8048
TEST_TIME 20 8520
TEST_TIME 21 8409
TEST_TIME 22 8380
TEST_TIME 23 9252
TEST_TIME 24 9446
TEST_TIME 25 10116
TEST_TIME 26 11655
TEST_TIME 27 11513
TEST_TIME 28 11357
TEST_TIME 29 11143
TEST_TIME 30 11000
TEST_TIME 31 10866
TEST_TIME 32 10701
TEST_TIME 33 10828
TEST_TIME 34 10579
TEST_TIME 35 10525
TEST_TIME 36 10420
TEST_TIME 37 10489
TEST_TIME 38 10570
TEST_TIME 39 10408
TEST_TIME 40 10337
TEST_TIME 41 10190
TEST_TIME 42 9989
TEST_TIME 43 10001
TEST_TIME 44 10116
TEST_TIME 45 10156
TEST_TIME 46 10148
TEST_TIME 47 10182
TEST_TIME 48 10116
TEST_TIME 49 10210
TEST_TIME 50 10135
TEST_TIME 51 10149
TEST_TIME 52 10122
TEST_TIME 53 10156
TEST_TIME 54 10198
TEST_TIME 55 10146
TEST_TIME 56 10210
TEST_TIME 57 10225
TEST_TIME 58 10285
TEST_TIME 59 10298
TEST_TIME 60 10139
TEST_TIME 61 10117
TEST_TIME 62 10019
TEST_TIME 63 10074
TEST_TIME 64 9993
TEST_TIME 65 9939
TEST_TIME 66 9844
TEST_TIME 67 9788
TEST_TIME 68 9694
TEST_TIME 69 9685
TEST_TIME 70 9704
TEST_TIME 71 9717
TEST_TIME 72 9675
TEST_TIME 73 9670
TEST_TIME 74 9695
TEST_TIME 75 9677
TEST_TIME 76 9706
TEST_TIME 77 9669
TEST_TIME 78 9710
TEST_TIME 79 9763
TEST_TIME 80 9786
TEST_TIME 81 9846
TEST_TIME 82 9858
TEST_TIME 83 9761
TEST_TIME 84 9763
TEST_TIME 85 9710
TEST_TIME 86 9660
TEST_TIME 87 9593
TEST_TIME 88 9543
TEST_TIME 89 9555
TEST_TIME 90 9552
TEST_TIME 91 9645
TEST_TIME 92 9602
TEST_TIME 93 9594
TEST_TIME 94 9597
TEST_TIME 95 9684
TEST_TIME 96 9670
TEST_TIME 97 9654
TEST_TIME 98 9692
TEST_TIME 99 9705
TEST_TIME 100 9709
TEST_TIME 101 9691
TEST_TIME 102 9644
TEST_TIME 103 9706
TEST_TIME 104 9789
TEST_TIME 105 9736
TEST_TIME 106 9649
TEST_TIME 107 9619
TEST_TIME 108 9605
TEST_TIME 109 9578
TEST_TIME 110 9555
TEST_TIME 111 9518
TEST_TIME 112 9504
TEST_TIME 113 9466
TEST_TIME 114 9436
TEST_TIME 115 9455
TEST_TIME 116 9427
TEST_TIME 117 9421
TEST_TIME 118 9410
TEST_TIME 119 9419
TEST_TIME 120 9349

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-01-2021 22:28:52 to 24-01-2021 22:28:56.

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 1543903 1543903 0 0.00 0 23524 6 0 0
doc_list_biud 1543903 1543903 0 0.00 0 45238 32 0 0
sp_add_invoice_to_stock 5132 4967 165 3.21 27 178870 18394 0 165
sp_cancel_adding_invoice 5899 5899 0 0.00 5 67147 849 0 0
sp_cancel_client_order 1748 1748 0 0.00 4 23982 348 0 0
sp_cancel_customer_reserve 580399 580399 0 0.00 1 45241 69 0 0
sp_cancel_pay_from_customer 649 649 0 0.00 3 1853 59 0 0
sp_cancel_pay_to_supplier 390 390 0 0.00 3 3988 98 0 0
sp_cancel_supplier_invoice 6466 6454 12 0.18 1 24730 806 0 12
sp_cancel_supplier_order 450 450 0 0.00 8 1120319 110425 0 0
sp_cancel_write_off 9552 9552 0 0.00 1 10452 109 0 0
sp_client_order 20285 20285 0 0.00 3 42182 366 0 0
sp_customer_reserve 455127 455127 0 0.00 0 84616 183 0 0
sp_fill_shopping_cart 31287 31287 0 0.00 1 11506 36 0 0
sp_fill_shopping_cart_clo_res 455105 455105 0 0.00 0 15642 15 0 0
sp_get_clo_for_invoice 4941 4941 0 0.00 0 24158 274 0 0
sp_kill_cost_storno 16490 16490 0 0.00 0 8667 56 0 0
sp_kill_qstorno_ret_qs2qd 1177254 1177254 0 0.00 0 45235 37 0 0
sp_kill_qty_storno 619405 619405 0 0.00 0 45237 79 0 0
sp_lock_selected_doc 20680 20680 0 0.00 0 9689 7 0 0
sp_make_cost_storno 27905 27905 0 0.00 0 23522 52 0 0
sp_multiply_rows_for_pdistr 27905 27905 0 0.00 0 14235 30 0 0
sp_multiply_rows_for_qdistr 20285 20285 0 0.00 0 11026 169 0 0
sp_pay_from_customer 7176 7176 0 0.00 4 14243 104 0 0
sp_pay_to_supplier 5826 5826 0 0.00 4 23530 118 0 0
sp_payment_common 13002 13002 0 0.00 1 10656 22 0 0
sp_qd_handle_on_cancel_clo 1748 1748 0 0.00 0 23974 321 0 0
sp_qd_handle_on_invoice_upd_sts 10840 10840 0 0.00 0 37245 333 0 0
sp_qd_handle_on_reserve_upd_sts 9962 9962 0 0.00 0 42974 75 0 0
sp_reserve_write_off 9962 9962 0 0.00 6 42996 199 0 0
sp_supplier_invoice 5397 5397 0 0.00 7 89219 3266 0 0
sp_supplier_order 5609 5609 0 0.00 5 44258 1299 0 0
srv_aggregate_perf_data 99 99 0 0.00 3003 509770 21611 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1192 173941 30705 0 0
srv_find_qd_qs_mism 1074643 1074643 0 0.00 0 23377 6 0 0
srv_make_invnt_saldo 622 622 0 0.00 26 27993 909 0 0
srv_make_money_saldo 753 753 0 0.00 1 2486 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 174913 375316 279636 0 0
t$perf-abend:sp_add_invoice_to_stock 165 165 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4967 4967 0 0.00 0 17551 181 0 0
t$perf-norm:sp_cancel_adding_invoice 457 457 0 0.00 0 8687 116 0 0
t$perf-norm:sp_cancel_client_order 1748 1748 0 0.00 0 5115 13 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 768 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 649 649 0 0.00 0 5459 22 0 0
t$perf-norm:sp_cancel_pay_to_supplier 390 390 0 0.00 0 541 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 7373 47 0 0
t$perf-norm:sp_cancel_supplier_order 450 450 0 0.00 0 22043 1410 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 2082 10 0 0
t$perf-norm:sp_client_order 20285 20285 0 0.00 0 20277 19 0 0
t$perf-norm:sp_customer_reserve 1060 1060 0 0.00 0 1822 9 0 0
t$perf-norm:sp_pay_from_customer 7176 7176 0 0.00 0 5418 11 0 0
t$perf-norm:sp_pay_to_supplier 5826 5826 0 0.00 0 4968 8 0 0
t$perf-norm:sp_reserve_write_off 9962 9962 0 0.00 0 10375 13 0 0
t$perf-norm:sp_supplier_invoice 5397 5397 0 0.00 0 10526 20 0 0
t$perf-norm:sp_supplier_order 5609 5609 0 0.00 0 10653 18 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 332 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 314 4 0 0
t$perf-norm:srv_make_invnt_saldo 622 622 0 0.00 0 949 21 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 2900 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 66 19 0 0
v_add_invoice_to_stock 10212 9882 330 3.23 0 7412 19 0 330
v_all_customers 37294 37294 0 0.00 0 50 1 0 0
v_all_suppliers 30750 30750 0 0.00 0 109 1 0 0
v_all_wares 40568 40568 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 914 914 0 0.00 0 389 5 0 0
v_cancel_client_order 3496 3496 0 0.00 0 2686 6 0 0
v_cancel_customer_prepayment 1298 1298 0 0.00 0 1093 4 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 1586 4 0 0
v_cancel_payment_to_supplier 780 780 0 0.00 0 1339 5 0 0
v_cancel_supplier_invoice 834 810 24 2.87 0 996 13 0 24
v_cancel_supplier_order 900 900 0 0.00 0 1342 6 0 0
v_cancel_write_off 2040 2040 0 0.00 0 3183 13 0 0
v_max_id_clo_ord 5609 5609 0 0.00 0 247 1 0 0
v_max_id_clo_res 1060 1060 0 0.00 0 2471 12 0 0
v_max_id_ord_sup 5394 5394 0 0.00 0 2795 2 0 0
v_max_non_paid_invoice 1454 1454 0 0.00 0 1965 4 0 0
v_max_non_paid_realizn 3676 3676 0 0.00 0 1675 4 0 0
v_min_id_clo_ord 5609 5609 0 0.00 0 3364 4 0 0
v_min_id_clo_res 1060 1060 0 0.00 0 2394 9 0 0
v_min_id_ord_sup 5394 5394 0 0.00 0 6387 8 0 0
v_min_non_paid_invoice 5826 5826 0 0.00 0 10653 16 0 0
v_min_non_paid_realizn 7176 7176 0 0.00 0 8790 11 0 0
v_our_firm 10274 10274 0 0.00 0 11 1 0 0
v_reserve_write_off 19924 19924 0 0.00 0 8152 8 0 0
x_lock_depdocs_on_canc_invoice 11948 11948 0 0.00 0 26973 123 0 0
x_lock_depdocs_on_canc_sup_ord 450 450 0 0.00 0 15701 364 0 0
x_make_qstorno_1000_1200 5609 5609 0 0.00 2 44253 1224 0 0
x_make_qstorno_1200_2000 5397 5397 0 0.00 2 89196 3137 0 0
x_make_qstorno_2100_3300 455127 455127 0 0.00 0 84614 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-01-2021 22:28:57 to 24-01-2021 22:29:01.

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:15 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:21 18748 8192000000 10253870048 10563358720 886988608 9.769 68 55 110 0 908792240 2545472 19258160
19:57:48 33407 8192000000 10345287344 10662125568 1382842576 14.442 100 83 165 1 1414653536 4771072 27039888
19:58:36 21699 8192000000 10375974208 10695569408 1421799888 14.789 100 88 176 0 1458069536 6645520 29624128
19:59:09 26757 8192000000 10397642192 10724261888 1452098160 15.056 100 86 169 2 1488126944 7627152 28401632
19:59:51 16972 8192000000 10426063632 10755145728 1480045632 15.302 100 89 178 0 1516618016 8192432 28379952
20:00:24 25630 8192000000 10439402544 10776854528 1500484240 15.480 100 89 178 0 1538078256 8877808 28716208
20:01:12 13631 8192000000 10468180736 10805936128 1522590224 15.673 100 83 167 0 1558341648 9149968 26601456
20:01:34 23264 8192000000 10486479632 10833895424 1538301808 15.809 100 86 172 0 1575532416 9945456 27285152
20:02:13 14325 8192000000 10533699312 10884042752 1581169024 16.178 100 79 158 0 1615729920 10167920 24392976
20:02:41 15302 8192000000 10553007968 10915258368 1619275712 16.504 100 75 149 2 1652792608 10385792 23131104
20:03:04 19254 8192000000 10590837984 10952413184 1643299200 16.708 100 72 144 0 1675518272 10665840 21553232
20:03:35 7001 8192000000 10615218864 10982821888 1671458432 16.945 100 75 150 1 1705270960 11930784 21881744
20:03:51 12841 8192000000 10638322928 11010039808 1693872064 17.134 100 82 164 1 1730175744 12850288 23453392
20:04:12 8030 8192000000 10657571600 11028783104 1716162096 17.320 100 86 172 3 1753832512 13553824 24116592
20:04:28 6295 8192000000 10658875792 11032301568 1717663824 17.333 100 79 158 1 1754193440 14179824 22349792
20:04:43 5406 8192000000 10674256736 11048316928 1733334864 17.463 100 90 177 2 1772901888 14448560 25118464
20:04:55 5603 8192000000 10677296512 11053731840 1739983856 17.518 100 77 154 2 1775587328 13724096 21879376
20:05:07 6850 8192000000 10688566832 11068723200 1751427360 17.613 100 75 149 1 1785057072 12785792 20843920
20:05:22 5518 8192000000 10700522688 11082141696 1766028256 17.734 100 78 154 2 1800053568 12591632 21433680
20:05:35 4407 8192000000 10710378096 11092725760 1772416608 17.787 100 76 152 1 1806365280 13048544 20900128
20:05:46 3178 8192000000 10724926544 11104538624 1780962784 17.857 100 85 169 4 1818799392 14380496 23456112
20:05:56 12712 8192000000 10721930944 11107930112 1785351168 17.894 100 84 168 3 1823512576 14465456 23695952
20:06:16 3441 8192000000 10738958240 11119386624 1795815488 17.980 100 81 162 1 1833360128 14284448 23260192
20:06:26 3267 8192000000 10747797824 11137499136 1808609568 18.084 100 84 169 0 1846899152 14279344 24010240
20:06:39 3325 8192000000 10747625744 11139592192 1814975664 18.137 100 77 155 2 1848560848 11734032 21851152
20:06:48 3038 8192000000 10755768976 11143929856 1817571488 18.158 100 76 152 2 1850455008 11014912 21868608
20:06:58 2058 8192000000 10766642992 11151556608 1828930928 18.251 100 90 178 0 1864708256 10791056 24986272
20:07:07 1838 8192000000 10774675120 11159011328 1837759504 18.323 100 88 176 1 1873812000 11324400 24728096
20:07:15 3169 8192000000 10775727488 11165777920 1848977248 18.414 100 88 176 0 1886015168 12648032 24389888
20:07:25 1443 8192000000 10799038928 11184082944 1847743824 18.404 100 88 176 0 1885527536 12736192 25047520
20:07:33 2266 8192000000 10787219232 11181268992 1852862304 18.445 100 93 183 0 1891337104 12055856 26418944
20:07:42 2249 8192000000 10790544944 11184439296 1855807008 18.469 100 87 172 2 1892709776 12590288 24312480
20:07:50 1284 8192000000 10801682400 11188383744 1859624464 18.500 100 91 182 1 1898921952 13673360 25624128
20:07:58 1495 8192000000 10809334336 11197448192 1860200592 18.505 100 90 180 3 1898435040 13284752 24949696
20:08:06 1968 8192000000 10806765968 11196887040 1866204976 18.554 100 94 188 1 1905921968 13021584 26695408
20:08:14 1295 8192000000 10818086832 11209191424 1871682832 18.598 100 98 198 3 1913820528 13921008 28216688
20:08:21 1432 8192000000 10822410400 11210465280 1876111200 18.634 100 95 190 1 1916146864 13091744 26943920
20:08:29 31778 8192000000 10781571488 11203014656 1867794176 18.566 100 51 102 1 1891565296 9736048 14035072
20:09:07 4633 8192000000 10796235648 11208650752 1869994928 18.584 100 47 95 2 1890996160 6040000 14961232
20:09:19 8309 8192000000 10771286704 11205079040 1870862448 18.591 100 23 46 2 1884477552 7474240 6140864
20:09:34 3773 8192000000 10798047744 11210465280 1876699680 18.638 100 50 99 0 1897734320 6448720 14585920
20:09:44 4625 8192000000 10790207856 11210264576 1875481264 18.629 100 42 85 2 1895718784 8177600 12059920
20:09:56 4945 8192000000 10797782608 11214020608 1877575152 18.646 100 39 77 0 1896168336 7655712 10937472
20:10:09 6533 8192000000 10794529280 11218800640 1876029968 18.633 100 29 58 1 1892068144 8308928 7729248
20:10:23 9362 8192000000 10787536832 11215011840 1877675440 18.646 100 30 59 1 1892485696 6209504 8600752
20:10:38 8998 8192000000 10785063984 11218190336 1878688144 18.655 100 16 33 1 1889541536 6300256 4553136
20:10:54 12496 8192000000 10786209952 11218452480 1882439840 18.685 100 15 30 1 1892119856 6106432 3573584
20:11:15 6941 8192000000 10795166528 11227205632 1884233280 18.699 100 20 40 1 1896532784 6860400 5439104
20:11:30 10430 8192000000 10795398896 11228123136 1888565024 18.734 100 18 36 2 1899385712 6359632 4461056
20:11:52 12679 8192000000 10796777776 11228270592 1888078000 18.730 100 18 36 0 1898710256 5808176 4824080
20:12:14 18912 8192000000 10793911504 11233804288 1892867776 18.769 100 28 56 0 1907472384 6023584 8581024
20:12:39 54451 8192000000 10851696224 11253710848 1900967200 18.834 100 67 135 0 1927017936 5550160 20500576
20:13:39 6845 8192000000 10812583952 11249332224 1899704896 18.824 100 42 83 2 1920265696 9126784 11434016
20:13:52 8515 8192000000 10813644880 11245006848 1897801376 18.809 100 30 60 1 1912950928 6868544 8281008
20:14:08 4588 8192000000 10834583760 11255779328 1902621984 18.847 100 48 95 1 1923706320 7576048 13508288
20:14:20 6778 8192000000 10814789408 11250528256 1903206496 18.852 100 40 82 0 1921932640 6667936 12058208
20:14:34 7110 8192000000 10823682320 11252973568 1903774208 18.857 100 32 64 0 1919110752 6267712 9068832
20:14:48 6595 8192000000 10818413920 11254497280 1903125424 18.851 100 22 44 3 1915627184 6263920 6237840
20:15:02 4529 8192000000 10830611008 11260977152 1905407264 18.870 100 35 70 2 1921276688 5787952 10081472
20:15:13 9634 8192000000 10822325360 11255951360 1902773456 18.849 100 12 24 0 1912053936 5708448 3572032
20:15:30 10470 8192000000 10807315072 11248881664 1887193232 18.723 99 16 32 0 1897046832 5571024 4282576
20:15:49 5917 8192000000 10813524016 11248668672 1897900976 18.809 100 25 51 0 1911230320 6049776 7279568
20:16:03 15508 8192000000 10810121968 11245608960 1882526736 18.686 99 20 36 0 1893624448 5231472 5866240
20:16:45 33932 8192000000 10791399520 11235938304 1887886944 18.729 99 23 46 0 1900507888 5523536 7097408
20:17:26 12667 8192000000 10783122720 11213717504 1804192288 18.048 95 17 34 0 1813961376 4796160 4972928
20:17:46 6478 8192000000 10793796064 11219329024 1860870224 18.510 99 35 69 1 1876204368 5117840 10216304
20:18:01 6661 8192000000 10796489728 11226030080 1881161120 18.674 100 41 82 2 1900717168 7456128 12099920
20:18:15 5474 8192000000 10788517152 11219402752 1858185984 18.489 99 28 56 1 1871619680 6030160 7403536
20:18:29 3893 8192000000 10766299968 11184398336 1830122048 18.260 99 29 59 2 1845082496 6755536 8204912
20:18:42 4786 8192000000 10763663840 11180507136 1824899408 18.218 98 41 79 2 1843373344 7071648 11402288
20:18:56 10659 8192000000 10763089360 11192778752 1823861888 18.209 98 25 50 2 1838628464 7419552 7347024
20:19:13 8432 8192000000 10737462336 11156729856 1789389680 17.927 96 23 46 0 1801980976 5950864 6640432
20:19:27 7752 8192000000 10712734800 11133980672 1711233072 17.279 93 23 45 3 1723092608 5507936 6351600
20:19:42 7765 8192000000 10685409984 11092168704 1652706224 16.787 92 21 42 1 1667891056 8948432 6236400
20:19:56 6061 8192000000 10693797760 11108831232 1752510864 17.622 98 19 38 1 1763553680 5631712 5411104
20:20:11 8331 8192000000 10684281472 11093839872 1655966272 16.815 92 20 40 0 1667981248 5597568 6417408
20:20:26 6610 8192000000 10677431440 11091144704 1735379632 17.480 98 30 60 3 1749826288 5810928 8635728
20:20:46 8354 8192000000 10669101984 11087200256 1710932800 17.277 96 29 59 0 1725013920 4873824 9207296
20:21:01 30879 8192000000 10689382832 11113095168 1764609680 17.722 99 25 50 2 1777567728 5833712 7124336
20:22:07 25886 8192000000 10715640832 11130515456 1745311696 17.563 97 20 40 1 1756697840 5803712 5582432
20:22:42 7697 8192000000 10744844336 11154726912 1802849952 18.037 99 38 75 4 1818275136 5258448 10166736
20:22:59 5244 8192000000 10741999104 11154432000 1815325008 18.139 99 31 62 0 1831793760 7761056 8707696
20:23:13 3907 8192000000 10765909040 11185205248 1842805856 18.364 100 38 76 0 1861273072 8027248 10439968
20:23:23 8073 8192000000 10757796368 11179847680 1830980656 18.267 99 41 83 0 1849202720 6453936 11768128
20:23:39 4527 8192000000 10776156416 11192733696 1853619280 18.452 100 45 89 1 1873621408 7179040 12823088
20:23:53 6140 8192000000 10769489952 11193131008 1852373184 18.441 100 38 76 2 1869309888 5369536 11567168
20:24:08 9980 8192000000 10774469488 11196186624 1852515616 18.443 100 25 50 0 1865024480 5430512 7078352
20:24:27 7102 8192000000 10769487680 11203432448 1860620768 18.508 100 19 37 0 1872119504 6492512 5006224
20:24:41 10734 8192000000 10764061344 11199492096 1858650624 18.492 100 16 32 0 1868797680 5248048 4899008
20:24:58 13899 8192000000 10782877216 11210162176 1865407296 18.547 100 24 47 1 1878084080 5307904 7368880
20:25:24 8385 8192000000 10791640832 11214180352 1867593200 18.565 100 22 43 1 1879811056 5136464 7081392
20:25:40 10991 8192000000 10785224624 11216924672 1870845024 18.591 100 16 32 0 1881002512 5642352 4515136
20:26:02 9720 8192000000 10775243712 11215663104 1870790000 18.591 100 15 30 0 1880586160 5606480 4189680
20:26:19 81282 8192000000 10826086640 11243249664 1880159760 18.666 100 32 62 0 1894950112 5510032 9280320
20:27:51 6553 8192000000 10844149440 11262222336 1910800416 18.913 100 47 94 1 1932046800 8256992 12989392
20:28:05 4267 8192000000 10852029568 11270598656 1922365344 19.006 100 57 113 1 1946677664 9135328 15176992
20:28:18 19896 8192000000 10860466272 11282034688 1926969616 19.043 100 58 117 0 1952421776 9488816 15963344
20:28:57 14752 8192000000 10875384192 11301560320 1940097920 19.148 100 63 126 1 1976786512 19580256 17108336
20:29:19 15414 8192000000 10878854768 11306594304 1944669920 19.184 100 55 110 0 1977299616 17869696 14760000
20:29:43 1456 8192000000 10885688928 11311927296 1950266112 19.229 100 56 114 0 1986208688 20710992 15231584
20:29:54 3116 8192000000 10893761968 11314720768 1954502112 19.262 100 57 111 2 1986194464 15965328 15727024
20:30:07 19865 8192000000 10896594256 11322871808 1955534080 19.271 100 51 102 1 1986054736 16537984 13982672
20:30:35 7370 8192000000 10908496448 11333193728 1965916800 19.353 100 56 113 2 2001823568 19912000 15994768
20:31:00 5925 8192000000 10911611824 11336450048 1968792304 19.376 100 58 117 0 2006719056 20265024 17661728
20:31:13 18470 8192000000 10912713056 11347664896 1970570240 19.390 100 46 91 2 2003932688 19947760 13414688
20:31:39 13288 8192000000 10915863472 11349364736 1973713632 19.415 100 43 86 0 2008310608 21556752 13040224
20:32:04 26271 8192000000 10924258624 11361701888 1975206464 19.427 100 36 72 0 2009937312 23647488 11083360
20:32:45 24957 8192000000 10926876368 11361296384 1967278160 19.364 99 38 76 4 2009336112 29566768 12491184
20:33:22 22553 8192000000 10927597120 11366682624 1980948464 19.472 100 37 74 0 2019908784 28070464 10889856
20:33:55 12048 8192000000 10943537792 11380559872 1989253072 19.538 100 44 84 4 2034039456 33080912 11705472
20:34:17 8761 8192000000 10960182064 11389095936 1999275536 19.617 100 57 114 1 2044763408 27939840 17548032
20:34:32 10006 8192000000 10961145184 11399528448 2001375056 19.634 100 52 104 5 2055576512 38276640 15924816
20:34:50 5557 8192000000 10956590672 11392712704 2005276784 19.664 100 52 104 3 2051796304 30289504 16230016
20:35:05 25637 8192000000 10966630064 11406503936 2008433712 19.689 100 48 96 1 2054492768 31427616 14631440
20:35:42 2905 8192000000 10986988944 11413282816 2021677312 19.793 100 64 126 1 2074846880 33989456 19180112
20:35:52 4060 8192000000 10976374096 11400187904 2005707072 19.668 99 70 140 1 2062387568 35411088 21269408
20:36:04 5606 8192000000 10972706624 11408543744 2015880320 19.748 100 57 110 1 2067783344 35084816 16818208
20:36:17 11163 8192000000 10994678256 11428343808 2024675440 19.817 100 62 124 2 2083376144 40066096 18634608
20:36:36 6998 8192000000 10988737264 11427532800 2026444272 19.831 100 52 104 0 2083018832 40475120 16099440
20:36:51 2322 8192000000 10998757216 11430801408 2033374000 19.885 100 60 120 1 2091843136 40445408 18023728
20:37:00 5970 8192000000 11001882720 11434303488 2032149248 19.875 100 58 116 0 2090035168 40495968 17389952
20:37:14 4345 8192000000 11019316768 11446718464 2042412816 19.956 100 76 152 2 2107937248 42299168 23225264
20:37:30 5596 8192000000 11017584112 11447779328 2042681216 19.958 100 68 136 0 2105764016 43007456 20075344
20:37:42 6071 8192000000 11026493936 11450335232 2045333936 19.979 100 66 131 1 2108516432 43715424 19467072
20:37:57 9093 8192000000 11027564160 11457789952 2049305936 20.010 100 69 138 3 2113962032 44142800 20513296
20:38:13 17540 8192000000 11020477072 11457142784 2049657408 20.012 100 58 114 1 2110825168 44217088 16950672
20:38:42 5879 8192000000 11034432080 11469979648 2056953088 20.069 100 64 126 0 2122863008 46240160 19669760
20:38:56 5436 8192000000 11040130240 11474362368 2064288032 20.127 100 66 131 1 2133433040 49072160 20072848
20:39:08 3519 8192000000 11060332192 11484717056 2064970400 20.132 100 75 148 4 2137949008 50443600 22535008
20:39:22 7264 8192000000 11050057824 11482136576 2064721680 20.130 100 68 136 1 2137949440 52031248 21196512
20:39:39 2786 8192000000 11067675760 11495923712 2072533536 20.191 100 82 162 0 2151043152 53380352 25129264
20:39:48 4187 8192000000 11073169472 11496632320 2073444080 20.198 100 79 158 1 2151471696 54115552 23912064
20:40:00 2445 8192000000 11064964192 11485765632 2054362960 20.049 99 84 167 1 2134889520 54664320 25862240
20:40:11 1681 8192000000 11041810352 11466743808 2046833696 19.990 100 81 159 1 2124985536 54046896 24104944
20:40:21 3237 8192000000 11024861840 11451944960 2021242176 19.790 99 78 157 2 2100713808 55228016 24243616
20:40:35 4898 8192000000 11042204944 11463270400 2045764128 19.982 100 86 169 0 2126829808 55479904 25585776
20:40:47 2002 8192000000 11040528048 11462307840 2042250448 19.955 100 75 149 4 2121488880 55507952 23730480
20:40:56 3069 8192000000 11035240192 11457904640 2043935824 19.968 100 80 160 0 2124934480 55861520 25137136
20:41:06 4307 8192000000 11026106816 11446935552 2017359312 19.759 99 79 157 2 2098978896 56584224 25035360
20:41:19 1617 8192000000 11024871648 11439697920 2014559776 19.737 99 75 141 3 2093902784 56028880 23314128
20:41:27 1271 8192000000 11037726352 11459076096 2035421936 19.901 100 77 151 0 2116244656 57010352 23812368
20:41:35 3157 8192000000 11033879648 11459661824 2034806400 19.896 100 75 148 0 2116897120 58498736 23591984
20:41:47 4128 8192000000 11027332016 11454763008 2037073728 19.914 100 77 152 1 2119397008 57944368 24378912
20:42:01 6091 8192000000 11047013312 11471962112 2043315680 19.963 100 77 154 0 2130673472 62615984 24741808
20:42:15 1228 8192000000 11051126576 11469950976 2039113936 19.930 100 85 171 0 2130328768 63812288 27402544
20:42:23 2392 8192000000 11050408272 11470815232 2041105136 19.946 100 83 165 1 2133719248 65718880 26895232
20:42:32 3969 8192000000 11049939504 11473764352 2040850800 19.944 100 78 153 2 2133088656 67370496 24867360
20:42:45 3409 8192000000 11054571536 11474026496 2037025232 19.914 100 81 162 2 2132260400 69477504 25757664
20:42:56 3200 8192000000 11048540032 11464609792 2022004752 19.796 99 79 157 0 2116641360 68558240 26078368
20:43:07 3265 8192000000 11037072592 11452620800 2016002976 19.749 99 91 178 0 2114447920 69368304 29076640
20:43:17 1717 8192000000 11053832080 11471687680 2030836016 19.865 100 84 168 2 2130540944 72658128 27046800
20:43:26 2267 8192000000 11052033920 11472367616 2031388976 19.870 100 80 160 1 2129820160 72824688 25606496
20:43:36 5170 8192000000 11056147152 11479826432 2037711888 19.919 100 75 150 1 2137822752 75286112 24824752
20:43:54 1192 8192000000 11073848368 11488735232 2048686544 20.005 100 85 164 1 2151225056 74897600 27640912
20:44:02 2701 8192000000 11062546448 11484000256 2034411776 19.893 99 81 160 1 2135643504 74553104 26678624
20:44:11 1617 8192000000 11050428240 11466399744 2023217152 19.805 100 90 178 0 2129373152 77306400 28849600
20:44:20 10091 8192000000 11047426032 11466809344 2026925472 19.835 100 83 166 2 2132602992 78152784 27524736
20:44:39 2731 8192000000 11047180560 11462651904 2007733056 19.684 99 78 155 2 2114213024 80626928 25853040
20:44:48 3052 8192000000 11047935152 11468406784 2023346400 19.806 100 78 156 0 2132117360 82325904 26445056
20:44:59 6381 8192000000 11030760832 11452153856 1991565072 19.556 99 71 142 0 2100909280 85185408 24158800
20:45:22 1561 8192000000 11025098720 11436584960 1975865472 19.432 99 78 156 0 2090187520 87954528 26367520
20:45:30 1953 8192000000 11036446208 11450986496 1999907200 19.622 100 90 180 2 2117087632 87750640 29429792
20:45:43 3907 8192000000 11034142400 11466964992 2002950640 19.646 100 67 134 1 2117486496 91726368 22809488
20:46:18 5596 8192000000 11019116144 11455750144 2012973696 19.725 100 54 107 0 2104584160 73627792 17982672
20:46:31 6808 8192000000 10997841568 11441004544 1993895872 19.575 99 48 97 0 2080567056 70396240 16274944
20:46:45 6322 8192000000 11015494160 11447332864 2010446912 19.705 100 60 118 2 2099186160 69536624 19202624
20:47:08 11383 8192000000 10978053584 11429462016 1974207472 19.419 99 41 82 1 2059255296 70537344 14510480
20:47:26 6702 8192000000 10972101760 11410522112 1983893728 19.496 100 43 86 2 2062069840 63653856 14522256
20:47:45 9962 8192000000 10983723232 11417788416 1990984784 19.552 100 50 99 2 2065193664 57981632 16227248
20:48:04 8935 8192000000 10996265392 11431383040 1998255248 19.609 100 45 91 1 2074275376 61054848 14965280
20:48:19 6567 8192000000 10996067200 11436584960 2001769088 19.637 100 43 86 2 2080378272 63395232 15213952
20:48:33 17399 8192000000 10981380560 11425705984 1970114128 19.386 99 40 80 1 2049949760 65389648 14445984
20:49:05 5946 8192000000 10987754832 11427090432 1971122384 19.394 99 39 78 2 2051838784 66978672 13737728
20:49:22 9788 8192000000 10982982784 11426631680 1984533600 19.501 100 51 100 2 2072842544 70405408 17903536
20:49:45 9186 8192000000 10984567344 11419758592 1959958320 19.306 99 48 96 2 2054355712 77979824 16417568
20:50:03 21157 8192000000 10975215440 11429101568 1977478784 19.445 100 38 76 1 2062223200 71414528 13329888
20:50:31 38077 8192000000 10940426224 11427475456 1946296960 19.197 99 29 58 2 2025532320 68551408 10683952
20:51:18 21278 8192000000 10942035104 11401699328 1956650224 19.279 100 25 50 2 2028516128 62752992 9112912
20:52:14 26353 8192000000 10919854400 11391901696 1917036240 18.963 99 16 31 1 1993386752 69631424 6719088
20:52:47 45082 8192000000 10881717328 11355455488 1875306432 18.627 97 15 30 0 1934288464 53908240 5073792
20:53:39 44121 8192000000 10879872224 11327299584 1915272080 18.949 99 29 61 2 1935634992 13243968 7118944
20:54:36 19515 8192000000 10866007792 11326361600 1938882080 19.138 100 28 57 2 1957989968 10851392 8256496
20:55:07 49548 8192000000 10857729024 11310866432 1878770656 18.655 97 22 45 1 1894720928 9449824 6500448
20:56:08 28176 8192000000 10863794304 11298910208 1902906272 18.850 99 33 66 2 1921076672 8990560 9179840
20:56:51 37700 8192000000 10872720032 11321004032 1928679264 19.056 100 32 63 0 1954295280 16505072 9110944
20:57:35 111192 8192000000 10847138384 11285114880 1837487872 18.320 95 38 76 2 1856084944 7490624 11106448
20:59:33 115868 8192000000 10857858736 11310714880 1856419616 18.474 96 16 32 2 1869847648 8538144 4889888
21:01:36 74646 8192000000 10869373024 11318980608 1886762016 18.720 97 29 58 1 1914685280 20449760 7473504
21:02:57 30484 8192000000 10907101216 11344752640 1953758096 19.256 100 39 78 1 1974277616 9387904 11131616
21:03:40 8819 8192000000 10901494512 11349016576 1959482848 19.302 100 36 72 1 1981062304 11188016 10391440
21:04:00 78514 8192000000 10869138224 11353325568 1945458032 19.190 99 38 77 3 1968048192 11914800 10675360
21:05:24 26875 8192000000 10880685264 11356905472 1960162400 19.307 100 7 14 0 1972580496 10321328 2096768
21:05:58 22981 8192000000 10901596624 11344535552 1963077328 19.330 100 27 54 1 1979307648 8690800 7539520
21:06:27 54656 8192000000 10890430944 11359186944 1970549584 19.390 100 33 62 3 1988974704 10016464 8408656
21:07:27 49453 8192000000 10906289616 11376812032 1977762272 19.447 100 15 30 2 1995040832 13270368 4008192
21:08:23 173937 8192000000 10907853264 11383517184 1967117968 19.363 99 21 42 0 1989257168 15770464 6368736
21:11:35 60101 8192000000 10890586160 11366572032 1939896448 19.146 98 17 34 0 1960154032 15321760 4935824
21:12:46 63186 8192000000 10911638752 11380862976 1972771360 19.407 100 10 20 0 1986482800 10944672 2766768
21:13:59 59754 8192000000 10911127696 11384979456 1957186400 19.284 99 8 16 0 1973671856 13900000 2585456
21:15:06 58279 8192000000 10894371136 11367104512 1964751600 19.344 99 23 45 0 1983416208 11657248 7007360
21:16:57 49951 8192000000 10902850720 11363680256 1928699568 19.056 97 23 46 2 1944325600 9205824 6420208
21:17:56 22843 8192000000 10903198960 11359756288 1936384608 19.118 98 25 50 0 1952326160 9307104 6634448
21:18:26 33367 8192000000 10891558576 11354050560 1941964688 19.162 99 36 72 2 1966082496 13729968 10387840
21:19:06 25168 8192000000 10903391328 11360088064 1952561040 19.247 99 33 66 3 1972858784 10455120 9842624
21:19:43 64272 8192000000 10882072496 11347337216 1887831360 18.728 96 20 40 2 1902783648 9660448 5291840
21:20:55 85042 8192000000 10894544400 11360722944 1962873664 19.329 100 18 36 3 1982268080 13999072 5395344
21:22:26 27237 8192000000 10923682864 11377172480 1962255712 19.324 99 31 62 1 1979846832 8332320 9258800
21:23:01 62204 8192000000 10919241440 11397738496 1988998176 19.536 100 33 66 1 2009791568 12259520 8533872
21:24:09 134209 8192000000 10935599200 11422523392 1957403088 19.285 98 10 20 2 1976206656 16248976 2554592
21:26:30 120556 8192000000 10930388272 11403747328 1983356000 19.491 99 24 48 2 2011801008 20983088 7461920
21:28:44 68281 8192000000 10899931744 11352084480 1909381680 18.902 95 29 58 1 1925626672 8202352 8042640
21:29:58 42352 8192000000 10887323952 11363020800 1943693648 19.176 98 29 58 2 1964366240 12812544 7860048
21:30:52 73950 8192000000 10847525664 11325378560 1867556336 18.564 95 4 8 0 1876607760 8460576 590848
21:32:12 27143 8192000000 10860617664 11321327616 1901059952 18.835 98 27 53 2 1915345600 6853600 7432048
21:33:06 39470 8192000000 10856825216 11328282624 1926085120 19.036 99 16 32 0 1940609792 9908432 4616240
21:33:56 51520 8192000000 10849196416 11326046208 1911627840 18.920 98 14 25 2 1921665520 6346064 3691616
21:34:58 49930 8192000000 10849392816 11310215168 1893879840 18.777 97 17 34 2 1907726496 8879152 4967504
21:36:33 64194 8192000000 10852276752 11333148672 1874732032 18.623 96 13 26 1 1891768992 13260912 3776048
21:37:44 57507 8192000000 10855058336 11330084864 1888714160 18.735 97 9 18 0 1899902800 8686768 2501872
21:38:48 25158 8192000000 10882859584 11346612224 1935420016 19.110 99 23 46 0 1952173968 10050192 6703760
21:39:22 61053 8192000000 10816898336 11287334912 1830373184 18.262 94 14 28 0 1848528912 14134160 4021568
21:40:32 27658 8192000000 10853240448 11311820800 1888888320 18.737 98 29 53 0 1906863600 10741168 7234112
21:41:06 7261 8192000000 10875341920 11318419456 1923016512 19.011 100 39 78 2 1948060528 13076176 11967840
21:41:23 22662 8192000000 10849623520 11306065920 1877167008 18.642 97 44 88 1 1899341888 10253776 11921104
21:41:52 23297 8192000000 10840705280 11282137088 1845759168 18.388 96 31 61 1 1863437296 9355888 8322240
21:42:21 20667 8192000000 10875030112 11321192448 1927158384 19.044 100 42 84 1 1949678080 10624912 11894784
21:42:50 13347 8192000000 10870992368 11305250816 1888277184 18.732 98 60 120 1 1917558576 12485440 16795952
21:43:10 36590 8192000000 10849991184 11305500672 1897177952 18.804 99 45 90 1 1922202176 12673776 12350448
21:43:53 40328 8192000000 10870436480 11318083584 1902026624 18.843 99 39 79 2 1924448944 12116736 10305584
21:44:45 32001 8192000000 10849268352 11303600128 1892042688 18.762 98 41 82 1 1918679568 15343712 11293168
21:45:23 42240 8192000000 10855298080 11311939584 1899430608 18.822 99 25 50 0 1922684256 15550624 7703024
21:46:11 35940 8192000000 10816336528 11268489216 1839911472 18.340 96 31 63 2 1857788736 8822864 9054400
21:46:55 36266 8192000000 10837836800 11294236672 1889795728 18.744 99 18 36 1 1904702352 10188432 4718192
21:47:38 23768 8192000000 10854920528 11295756288 1890614848 18.751 99 39 77 0 1910123744 8948160 10560736
21:48:08 96825 8192000000 10860040704 11320696832 1886181584 18.715 98 23 46 0 1904233392 11464480 6587328
21:51:03 64010 8192000000 10865581136 11340591104 1939547216 19.143 100 27 52 1 1954573520 7939424 7086880
21:52:16 55110 8192000000 10865923792 11332984832 1911879104 18.922 98 24 48 4 1928787024 10346096 6561824
21:53:17 20675 8192000000 10869165088 11347406848 1946255136 19.197 100 11 22 1 1960969040 11754896 2959008
21:53:50 61057 8192000000 10857689584 11332419584 1892671728 18.767 97 16 32 0 1913006256 15649728 4684800
21:54:57 69696 8192000000 10864941520 11336175616 1920857488 18.994 99 16 32 0 1944733328 18805232 5070608
21:56:14 44312 8192000000 10869692400 11352494080 1937595840 19.128 100 16 32 2 1964301808 21886736 4819232
21:57:04 21831 8192000000 10868788176 11354042368 1939152848 19.140 100 10 20 0 1962633952 20615392 2865712
21:57:35 17062 8192000000 10871646512 11368550400 1945423408 19.190 100 11 22 2 1972296480 23611856 3261216
21:59:27 33697 8192000000 10875827488 11341561856 1938329232 19.133 99 23 46 0 1952690272 8057712 6303328
22:00:07 46955 8192000000 10901585200 11362725888 1932080240 19.084 98 25 50 1 1949702400 10400576 7221584
22:01:02 42954 8192000000 10905623888 11373694976 1973189360 19.411 100 26 49 0 1992913696 12133520 7590816
22:01:51 50143 8192000000 10891941696 11375382528 1950217488 19.228 99 12 24 0 1966622256 13027600 3377168
22:02:55 87774 8192000000 10944491488 11389263872 1975211664 19.427 99 19 38 0 1991019440 10491040 5316736
22:04:31 45809 8192000000 10917573280 11385008128 1941037024 19.155 97 26 52 2 1962173328 13286752 7849552
22:05:29 85514 8192000000 10927232656 11395485696 1984721168 19.502 100 32 64 1 2013091072 19142816 9227088
22:07:00 93030 8192000000 10928622544 11401633792 1976388032 19.436 99 14 28 0 1991770208 11810560 3571616
22:08:46 58880 8192000000 10936733488 11386314752 1959483008 19.302 98 32 64 0 1978555488 9821536 9250944
22:09:55 18196 8192000000 10936170768 11395989504 1977289088 19.443 99 40 80 0 2000946656 12545712 11111856
22:10:30 65185 8192000000 10935089856 11425685504 1992507600 19.564 100 13 26 2 2013662496 17816256 3338640
22:11:42 103190 8192000000 10935022176 11403042816 1937345760 19.126 97 12 24 1 1955835376 15240144 3249472
22:14:12 62006 8192000000 10943047936 11409637376 2003412928 19.650 100 36 72 0 2033860624 20250160 10197536
22:15:20 28324 8192000000 10923002000 11398615040 1999980496 19.623 100 12 24 0 2013364496 10368080 3015920
22:15:58 68738 8192000000 10916530960 11402199040 2001933824 19.638 100 20 40 1 2017615360 9536528 6145008
22:17:16 48133 8192000000 10898934000 11382915072 1982520272 19.485 99 6 12 1 1993920560 9915200 1485088
22:18:10 31119 8192000000 10910181136 11390844928 1973726944 19.415 99 7 14 0 1988343824 13086800 1530080
22:18:48 59664 8192000000 10921043136 11399315456 1979445104 19.460 99 10 20 1 1995863248 13443760 2974384
22:20:59 33979 8192000000 10903965072 11381706752 1966623920 19.359 99 23 46 0 1983473856 10434112 6415824
22:21:50 82621 8192000000 10892292208 11371442176 1909209456 18.900 96 13 26 1 1920721232 8280944 3230832
22:23:22 48643 8192000000 10879151920 11347263488 1880306160 18.668 95 19 38 0 1896017712 9932960 5778592
22:24:23 39279 8192000000 10896397296 11363164160 1943298272 19.173 99 21 42 0 1964382208 14345696 6738240
22:25:12 82653 8192000000 10897950672 11377065984 1913100384 18.932 97 20 40 0 1936377216 17096848 6179984
22:26:41 45664 8192000000 8985443088 9176440832 150915488 1.808 8 4 8 0 163239712 11088448 1235776

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-01-2021 22:29:03 to 24-01-2021 22:29:35.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 165 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-01-2021 22:29:36 to 24-01-2021 22:29:38.

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          236068
MON$OLDEST_ACTIVE               236069
MON$OLDEST_SNAPSHOT             236069
MON$NEXT_TRANSACTION            236069
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                       2019456
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:392: 
:393: mscs-test-161.budzdorov.ru    Sun Jan 24 22:27:27 2021
:394:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:395: 
--- end of diff output ---

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

24.01.21 22:29:39. 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-01-24 22:29:41 No severe PSQL-related problems occured
24.01.21 22:29:43. End of report.