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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17177792 kB
MemAvailable 31211332 kB
Buffers 0 kB
Cached 14489732 kB
SwapCached 4876 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-02 16:27:17
DTS_END                         2021-02-02 16:27:17.9200
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/58742
TRN_ID                          242095
ATT_ID                          656
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: 9245.07 19244 1109408
customer order: creation 182.09 373 21851
customer order: refuse 15.77 350 1892
order to supplier: creation 47.43 1255 5692
order to supplier: removal 3.57 98832 428
invoice (draft): creation 47.70 3251 5724
invoice (draft): removal 51.55 785 6186
invoice accept: apply 42.58 17611 5109
invoice accept: cancel 46.49 760 5579
customer reserve: creation 3976.68 172 477202
customer reserve: removal 4525.17 61 543020
realization accept: apply 88.23 160 10588
realization accept: cancel 81.99 111 9839
payment from customer: creation 61.88 120 7426
payment from customer: removal 6.18 67 741
payment to supplier: creation 51.44 115 6173
payment to supplier: removal 3.75 58 450
service: total inventory turnovers 5.28 867 633
service: total monetary turnovers 6.32 26 758
service: aggregate perf. data 0.94 19913 113
service: refresh index statistics 0.03 239986 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 02-02-2021 16:28:23 to 02-02-2021 16:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10252
TEST_TIME 2 6375
TEST_TIME 3 5021
TEST_TIME 4 5217
TEST_TIME 5 5473
TEST_TIME 6 5538
TEST_TIME 7 5557
TEST_TIME 8 5897
TEST_TIME 9 5808
TEST_TIME 10 6035
TEST_TIME 11 5932
TEST_TIME 12 6015
TEST_TIME 13 6361
TEST_TIME 14 6570
TEST_TIME 15 6849
TEST_TIME 16 7049
TEST_TIME 17 7776
TEST_TIME 18 7589
TEST_TIME 19 8009
TEST_TIME 20 8448
TEST_TIME 21 9073
TEST_TIME 22 9163
TEST_TIME 23 9313
TEST_TIME 24 9749
TEST_TIME 25 9917
TEST_TIME 26 10150
TEST_TIME 27 10994
TEST_TIME 28 10796
TEST_TIME 29 10938
TEST_TIME 30 10601
TEST_TIME 31 10368
TEST_TIME 32 10463
TEST_TIME 33 10297
TEST_TIME 34 10435
TEST_TIME 35 10202
TEST_TIME 36 10101
TEST_TIME 37 10014
TEST_TIME 38 10001
TEST_TIME 39 10078
TEST_TIME 40 9912
TEST_TIME 41 9822
TEST_TIME 42 9782
TEST_TIME 43 9725
TEST_TIME 44 9603
TEST_TIME 45 9615
TEST_TIME 46 9528
TEST_TIME 47 9554
TEST_TIME 48 9559
TEST_TIME 49 9579
TEST_TIME 50 9658
TEST_TIME 51 9632
TEST_TIME 52 9599
TEST_TIME 53 9587
TEST_TIME 54 9739
TEST_TIME 55 9713
TEST_TIME 56 9793
TEST_TIME 57 9795
TEST_TIME 58 9808
TEST_TIME 59 9922
TEST_TIME 60 9909
TEST_TIME 61 9764
TEST_TIME 62 9705
TEST_TIME 63 9676
TEST_TIME 64 9579
TEST_TIME 65 9534
TEST_TIME 66 9513
TEST_TIME 67 9538
TEST_TIME 68 9533
TEST_TIME 69 9518
TEST_TIME 70 9506
TEST_TIME 71 9591
TEST_TIME 72 9597
TEST_TIME 73 9607
TEST_TIME 74 9622
TEST_TIME 75 9645
TEST_TIME 76 9693
TEST_TIME 77 9668
TEST_TIME 78 9642
TEST_TIME 79 9704
TEST_TIME 80 9621
TEST_TIME 81 9546
TEST_TIME 82 9497
TEST_TIME 83 9510
TEST_TIME 84 9443
TEST_TIME 85 9373
TEST_TIME 86 9341
TEST_TIME 87 9302
TEST_TIME 88 9337
TEST_TIME 89 9331
TEST_TIME 90 9337
TEST_TIME 91 9317
TEST_TIME 92 9356
TEST_TIME 93 9344
TEST_TIME 94 9437
TEST_TIME 95 9418
TEST_TIME 96 9419
TEST_TIME 97 9470
TEST_TIME 98 9490
TEST_TIME 99 9466
TEST_TIME 100 9499
TEST_TIME 101 9503
TEST_TIME 102 9448
TEST_TIME 103 9376
TEST_TIME 104 9407
TEST_TIME 105 9379
TEST_TIME 106 9328
TEST_TIME 107 9303
TEST_TIME 108 9303
TEST_TIME 109 9247
TEST_TIME 110 9225
TEST_TIME 111 9205
TEST_TIME 112 9205
TEST_TIME 113 9206
TEST_TIME 114 9214
TEST_TIME 115 9208
TEST_TIME 116 9292
TEST_TIME 117 9285
TEST_TIME 118 9283
TEST_TIME 119 9317
TEST_TIME 120 9250

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 02-02-2021 16:28:27 to 02-02-2021 16:28:30.

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 1551017 1551017 0 0.00 0 18095 6 0 0
doc_list_biud 1551016 1551016 0 0.00 0 71279 27 0 0
sp_add_invoice_to_stock 5263 5109 154 2.92 45 206173 17611 0 154
sp_cancel_adding_invoice 5579 5579 0 0.00 6 58383 761 0 0
sp_cancel_client_order 1892 1892 0 0.00 4 10623 351 0 0
sp_cancel_customer_reserve 543020 543020 0 0.00 1 24709 61 0 0
sp_cancel_pay_from_customer 741 741 0 0.00 2 2891 67 0 0
sp_cancel_pay_to_supplier 450 450 0 0.00 2 2141 58 0 0
sp_cancel_supplier_invoice 6203 6186 17 0.27 2 71289 785 0 17
sp_cancel_supplier_order 428 428 0 0.00 6 1072374 98833 0 0
sp_cancel_write_off 9839 9839 0 0.00 1 9217 111 0 0
sp_client_order 21851 21851 0 0.00 3 17475 373 0 0
sp_customer_reserve 477202 477202 0 0.00 0 81833 173 0 0
sp_fill_shopping_cart 33259 33259 0 0.00 1 10366 37 0 0
sp_fill_shopping_cart_clo_res 477199 477199 0 0.00 0 18707 15 0 0
sp_get_clo_for_invoice 5102 5102 0 0.00 0 14041 260 0 0
sp_kill_cost_storno 16609 16609 0 0.00 0 8487 53 0 0
sp_kill_qstorno_ret_qs2qd 1102493 1102493 0 0.00 0 71273 33 0 0
sp_kill_qty_storno 582632 582632 0 0.00 0 71276 71 0 0
sp_lock_selected_doc 21856 21856 0 0.00 0 7411 5 0 0
sp_make_cost_storno 29287 29287 0 0.00 0 14767 48 0 0
sp_multiply_rows_for_pdistr 29286 29286 0 0.00 0 17867 30 0 0
sp_multiply_rows_for_qdistr 21851 21851 0 0.00 0 14578 194 0 0
sp_pay_from_customer 7426 7426 0 0.00 4 17394 120 0 0
sp_pay_to_supplier 6173 6173 0 0.00 5 16882 115 0 0
sp_payment_common 13598 13598 0 0.00 2 17063 30 0 0
sp_qd_handle_on_cancel_clo 1892 1892 0 0.00 0 10617 324 0 0
sp_qd_handle_on_invoice_upd_sts 10679 10679 0 0.00 0 32262 318 0 0
sp_qd_handle_on_reserve_upd_sts 10588 10588 0 0.00 0 14908 49 0 0
sp_reserve_write_off 10588 10588 0 0.00 6 18126 161 0 0
sp_supplier_invoice 5724 5724 0 0.00 6 78025 3251 0 0
sp_supplier_order 5692 5692 0 0.00 5 23934 1255 0 0
srv_aggregate_perf_data 113 113 0 0.00 2984 298138 19914 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1273 142756 30766 0 0
srv_find_qd_qs_mism 1059435 1059435 0 0.00 0 14675 5 0 0
srv_make_invnt_saldo 633 633 0 0.00 45 28476 868 0 0
srv_make_money_saldo 758 758 0 0.00 0 1606 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 87058 502526 239986 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5109 5109 0 0.00 0 11760 180 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 0 9551 120 0 0
t$perf-norm:sp_cancel_client_order 1892 1892 0 0.00 0 3667 17 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 3064 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 741 741 0 0.00 0 3899 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 450 450 0 0.00 0 2524 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 435 435 0 0.00 0 1112 15 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 22492 1545 0 0
t$perf-norm:sp_cancel_write_off 1058 1058 0 0.00 0 3343 7 0 0
t$perf-norm:sp_client_order 21851 21851 0 0.00 0 6980 18 0 0
t$perf-norm:sp_customer_reserve 1051 1051 0 0.00 0 3906 10 0 0
t$perf-norm:sp_pay_from_customer 7426 7426 0 0.00 0 6870 12 0 0
t$perf-norm:sp_pay_to_supplier 6173 6173 0 0.00 0 5149 10 0 0
t$perf-norm:sp_reserve_write_off 10588 10588 0 0.00 0 10286 11 0 0
t$perf-norm:sp_supplier_invoice 5724 5724 0 0.00 0 7988 19 0 0
t$perf-norm:sp_supplier_order 5692 5692 0 0.00 0 6514 16 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 559 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 304 3 0 0
t$perf-norm:srv_make_invnt_saldo 633 633 0 0.00 0 3641 26 0 0
t$perf-norm:srv_make_money_saldo 758 758 0 0.00 0 1691 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 7 4 0 0
v_add_invoice_to_stock 10508 10200 308 2.93 0 6185 18 0 308
v_all_customers 39706 39706 0 0.00 0 54 1 0 0
v_all_suppliers 31726 31726 0 0.00 0 20 1 0 0
v_all_wares 43702 43702 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 1067 8 0 0
v_cancel_client_order 3784 3784 0 0.00 0 4021 5 0 0
v_cancel_customer_prepayment 1482 1482 0 0.00 0 758 4 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 959 4 0 0
v_cancel_payment_to_supplier 900 900 0 0.00 0 746 4 0 0
v_cancel_supplier_invoice 904 870 34 3.76 0 4191 17 0 34
v_cancel_supplier_order 856 856 0 0.00 0 1143 5 0 0
v_cancel_write_off 2116 2116 0 0.00 0 6217 17 0 0
v_max_id_clo_ord 5692 5692 0 0.00 0 124 1 0 0
v_max_id_clo_res 1051 1051 0 0.00 0 3126 22 0 0
v_max_id_ord_sup 5716 5716 0 0.00 0 5057 5 0 0
v_max_non_paid_invoice 1717 1717 0 0.00 0 217 2 0 0
v_max_non_paid_realizn 4012 4012 0 0.00 0 4473 5 0 0
v_min_id_clo_ord 5692 5692 0 0.00 0 1366 4 0 0
v_min_id_clo_res 1051 1051 0 0.00 0 5584 18 0 0
v_min_id_ord_sup 5716 5716 0 0.00 0 4646 7 0 0
v_min_non_paid_invoice 6172 6172 0 0.00 0 16800 16 0 0
v_min_non_paid_realizn 7426 7426 0 0.00 0 17053 24 0 0
v_our_firm 10824 10824 0 0.00 0 29 1 0 0
v_reserve_write_off 21176 21176 0 0.00 0 8996 6 0 0
x_lock_depdocs_on_canc_invoice 11330 11330 0 0.00 0 42965 115 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 9089 296 0 0
x_make_qstorno_1000_1200 5692 5692 0 0.00 2 23923 1178 0 0
x_make_qstorno_1200_2000 5724 5724 0 0.00 3 73978 3117 0 0
x_make_qstorno_2100_3300 477202 477202 0 0.00 0 81832 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 02-02-2021 16:28:31 to 02-02-2021 16:28:35.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:21 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:28 19462 8192000000 10275548960 10580905984 1030443440 11.173 79 66 133 0 1055439920 2842064 22154416
13:57:56 30601 8192000000 10351385360 10667233280 1401400608 14.607 100 82 164 0 1433144000 5360512 26382880
13:58:34 29676 8192000000 10381815968 10703933440 1429617040 14.858 100 91 182 0 1465657840 6601328 29439472
13:59:15 15679 8192000000 10398495488 10723954688 1456491472 15.095 100 88 176 0 1492714480 7575472 28647536
13:59:46 25846 8192000000 10432688368 10765500416 1478396256 15.287 100 89 178 0 1514763312 7958704 28408352
14:00:21 14600 8192000000 10448604368 10781450240 1503071456 15.503 100 85 170 0 1538829584 8657616 27100512
14:00:46 18717 8192000000 10468793328 10808078336 1525738384 15.700 100 94 188 0 1564274864 9293200 29243280
14:01:20 20939 8192000000 10491832400 10833870848 1542912288 15.849 100 92 181 1 1580973488 9882032 28179168
14:01:50 16646 8192000000 10506308576 10854715392 1568009856 16.065 100 79 158 0 1601878704 10364656 23504192
14:02:16 22808 8192000000 10553353328 10903490560 1594916000 16.296 100 81 162 2 1629750224 10664448 24169776
14:02:48 9884 8192000000 10557647424 10915852288 1617350048 16.487 100 76 152 0 1651159616 10529760 23279808
14:03:07 14010 8192000000 10588574592 10948689920 1640412720 16.683 100 83 167 1 1676372064 11409072 24550272
14:03:30 11536 8192000000 10597890032 10965848064 1655527312 16.811 100 83 166 1 1692969232 12636016 24805904
14:03:52 11355 8192000000 10620011776 10985271296 1677213200 16.994 100 78 156 0 1712543792 12678656 22651936
14:04:12 9131 8192000000 10633675968 11005005824 1696690816 17.157 100 73 146 0 1729716768 12091712 20934240
14:04:31 6436 8192000000 10658615600 11031941120 1711850592 17.284 100 73 144 2 1745101408 12129632 21121184
14:04:47 7471 8192000000 10669835200 11044265984 1733111344 17.461 100 78 157 0 1768387680 12222912 23053424
14:05:02 6217 8192000000 10676221472 11055890432 1743880912 17.551 100 82 162 0 1779100720 12232272 22987536
14:05:15 6135 8192000000 10692827040 11069734912 1753970736 17.634 100 83 166 1 1790939456 13427840 23540880
14:05:29 4567 8192000000 10711844272 11085725696 1764339008 17.720 100 81 162 0 1799771008 13094880 22337120
14:05:41 3548 8192000000 10710246688 11091419136 1771118128 17.776 100 78 156 0 1806732704 12894256 22720320
14:05:52 6586 8192000000 10719881440 11101511680 1782008576 17.866 100 83 166 4 1817194336 11978240 23207520
14:06:05 4109 8192000000 10728572800 11109969920 1790779904 17.938 100 88 176 3 1828456656 12928112 24748640
14:06:17 3357 8192000000 10729547152 11114274816 1794780384 17.971 100 81 160 1 1828640208 12327872 21531952
14:06:27 1940 8192000000 10742473280 11126001664 1804970688 18.055 100 91 182 1 1843025456 12778176 25276592
14:06:35 5061 8192000000 10746483552 11131940864 1806847600 18.070 100 82 166 1 1842564144 12613808 23102736
14:06:47 2792 8192000000 10760320640 11142160384 1815531536 18.141 100 87 172 0 1852021648 12605680 23884432
14:06:56 9464 8192000000 10757332464 11147079680 1821645920 18.191 100 81 163 0 1856600528 12936128 22018480
14:07:15 4590 8192000000 10763800416 11152670720 1825916592 18.226 100 82 164 1 1861416720 13377824 22122304
14:07:26 2614 8192000000 10781883120 11165691904 1839252144 18.335 100 89 178 2 1877467296 13522112 24693040
14:07:35 3270 8192000000 10782741104 11171450880 1844825040 18.380 100 86 172 2 1882637648 13414560 24398048
14:07:45 2192 8192000000 10788811296 11176153088 1852517584 18.443 100 94 188 1 1892808000 13588928 26701488
14:07:54 2330 8192000000 10799441824 11189551104 1859121072 18.496 100 91 185 1 1897798160 13403488 25273600
14:08:03 2285 8192000000 10798917152 11195277312 1858578256 18.492 100 82 165 3 1894708624 13173952 22956416
14:08:12 2478 8192000000 10807129392 11199541248 1867587168 18.565 100 86 172 1 1904708480 12093088 25028224
14:08:21 1987 8192000000 10816374608 11206021120 1872019120 18.601 100 94 192 0 1911734960 13124656 26591184
14:08:30 1943 8192000000 10813034384 11205218304 1874881312 18.624 100 86 172 1 1916230640 17408832 23940496
14:08:39 2158 8192000000 10814917840 11210231808 1876383984 18.636 100 82 164 1 1912802656 13039040 23379632
14:08:48 1675 8192000000 10813907616 11211501568 1876712640 18.639 100 92 184 0 1915740208 13205952 25821616
14:08:56 2427 8192000000 10822829312 11211423744 1879439552 18.661 100 94 186 1 1919927440 13996240 26491648
14:09:05 1163 8192000000 10830466544 11221618688 1881945520 18.681 100 98 197 2 1924680416 14285232 28449664
14:09:13 3653 8192000000 10828988832 11223736320 1885404256 18.709 100 88 176 0 1924967728 13614960 25948512
14:09:23 1336 8192000000 10823063392 11222044672 1886050128 18.714 100 89 179 1 1925280080 13766384 25463568
14:09:32 14021 8192000000 10829132928 11224846336 1884865680 18.704 100 76 153 1 1918342960 12962672 20514608
14:09:52 1415 8192000000 10840554240 11230863360 1890236176 18.748 100 97 194 1 1930396480 12454384 27705920
14:10:00 38728 8192000000 10804174672 11225493504 1880678912 18.671 100 33 66 2 1901472064 11669152 9124000
14:10:47 10579 8192000000 10798777920 11220316160 1879694480 18.663 100 20 40 1 1896268832 11069040 5505312
14:11:04 6124 8192000000 10800034992 11222114304 1884144944 18.699 100 30 61 1 1899979536 7667296 8167296
14:11:16 5643 8192000000 10794407888 11221598208 1883567136 18.694 100 27 55 1 1898276464 7796912 6912416
14:11:29 8615 8192000000 10795576128 11224461312 1888271200 18.732 100 26 53 3 1902226272 6538800 7416272
14:11:44 6926 8192000000 10808421104 11229851648 1890518112 18.750 100 29 58 1 1905821328 7068976 8234240
14:11:59 9715 8192000000 10799185440 11234447360 1891700576 18.759 100 20 41 2 1903420704 6504608 5215520
14:12:15 11366 8192000000 10809109088 11240001536 1899473584 18.822 100 30 60 5 1915488512 7016544 8998384
14:12:33 8350 8192000000 10810529264 11243458560 1898743616 18.816 100 13 26 0 1908360064 5982688 3633760
14:12:48 5078 8192000000 10814479312 11248128000 1902784096 18.849 100 32 64 0 1919694480 7199920 9710464
14:13:01 10260 8192000000 10818511920 11246985216 1901473952 18.838 100 24 48 0 1914158416 6138368 6546096
14:13:18 12440 8192000000 10812029040 11247099904 1900495600 18.830 100 10 20 0 1912865136 9868368 2501168
14:13:38 8998 8192000000 10814203840 11248230400 1905767680 18.873 100 30 59 2 1920988128 7059616 8160832
14:13:58 10583 8192000000 10811482336 11248152576 1904560624 18.863 100 23 45 0 1916840320 5972176 6307520
14:14:18 14817 8192000000 10821402784 11248648192 1903441920 18.854 100 17 34 1 1913440608 5604480 4394208
14:14:42 9129 8192000000 10816673840 11251793920 1908737728 18.897 100 38 77 3 1925862688 6833824 10291136
14:14:58 77387 8192000000 10810473536 11251392512 1888713632 18.735 99 27 54 2 1901996608 5176240 8106736
14:16:21 9272 8192000000 10820333600 11251752960 1886332992 18.716 99 24 48 1 1900253072 6753696 7166384
14:16:39 4784 8192000000 10821204928 11250622464 1900205632 18.828 100 29 59 3 1914713392 6556896 7950864
14:16:53 6791 8192000000 10825027008 11260547072 1907393200 18.886 100 22 44 2 1920530160 6383504 6753456
14:17:07 5115 8192000000 10832722336 11265028096 1909418432 18.902 100 23 44 1 1921479200 5676736 6384032
14:17:21 9997 8192000000 10818156976 11241607168 1850158672 18.423 97 21 43 0 1865527952 9728528 5640752
14:17:38 9932 8192000000 10834799760 11256602624 1904621664 18.863 100 18 33 5 1915226000 5087392 5516944
14:17:55 8858 8192000000 10812110048 11250954240 1889841280 18.745 99 14 28 2 1899299072 5793168 3664624
14:18:10 7871 8192000000 10788011216 11225640960 1867682496 18.566 99 23 46 2 1880424640 5761376 6980768
14:18:26 15024 8192000000 10748717184 11179380736 1750322464 17.604 93 8 16 0 1757370288 4922512 2125312
14:18:51 9689 8192000000 10757102144 11193851904 1807180304 18.073 97 15 31 0 1816873424 5228192 4464928
14:19:07 16327 8192000000 10775129632 11205853184 1804918496 18.054 97 11 22 0 1813330112 5155712 3255904
14:19:32 10876 8192000000 10765051664 11189260288 1823884880 18.209 98 29 58 0 1837421920 5371952 8165088
14:20:37 17216 8192000000 10750406480 11173486592 1781001504 17.858 96 45 90 2 1800688400 5259552 14427344
14:21:00 14382 8192000000 10706431200 11131305984 1659922976 16.848 90 16 33 0 1669440784 4939072 4578736
14:21:22 6051 8192000000 10698010784 11117617152 1729489616 17.431 96 20 41 0 1740881584 5774592 5617376
14:21:35 6837 8192000000 10683257504 11107414016 1739073376 17.511 97 30 60 1 1753758880 6063408 8622096
14:21:52 6443 8192000000 10695320720 11114655744 1748088064 17.586 97 39 77 2 1765916816 6409248 11419504
14:22:04 8506 8192000000 10701212288 11113897984 1691960496 17.118 94 26 52 0 1705830640 6444448 7425696
14:22:21 6699 8192000000 10674295984 11090857984 1720581216 17.357 96 22 44 0 1732670512 5843264 6246032
14:22:34 8662 8192000000 10700294160 11112366080 1722494768 17.373 96 32 64 0 1738390896 5589424 10306704
14:22:52 13772 8192000000 10725453648 11151589376 1804815712 18.053 100 22 44 0 1817656800 6869152 5971936
14:23:13 8224 8192000000 10752103696 11168174080 1822790640 18.200 100 25 51 0 1839656176 9823856 7041680
14:23:27 7990 8192000000 10731058000 11160887296 1810477808 18.100 99 21 42 1 1821976192 5864480 5633904
14:23:42 6695 8192000000 10755829296 11176165376 1811118320 18.105 99 31 61 2 1825560960 5456560 8986080
14:23:55 11899 8192000000 10745280592 11179544576 1824419872 18.214 99 18 35 1 1835396608 5437648 5539088
14:24:13 11845 8192000000 10750059552 11184865280 1844989248 18.381 100 18 35 1 1856043712 6130112 4924352
14:24:32 47400 8192000000 10779575056 11185389568 1844784256 18.380 100 43 86 2 1863946000 5584944 13576800
14:25:35 17978 8192000000 10776786224 11204186112 1854196352 18.456 100 21 42 2 1869876608 10122192 5558064
14:26:01 14183 8192000000 10789422704 11211833344 1865142624 18.545 100 30 60 3 1879165616 5823776 8199216
14:26:22 5267 8192000000 10779993216 11211747328 1868147104 18.569 100 27 51 3 1882948976 5965120 8836752
14:26:35 6978 8192000000 10790718256 11218804736 1871947744 18.600 100 31 62 2 1887339664 6587888 8804032
14:26:48 5394 8192000000 10797206384 11218636800 1874538208 18.621 100 33 68 1 1891597840 6628816 10430816
14:27:06 8384 8192000000 10802592240 11232264192 1890476864 18.750 100 28 56 2 1903782160 5282432 8022864
14:27:23 9516 8192000000 10826519264 11248656384 1904560256 18.863 100 40 78 4 1921462608 5203712 11698640
14:27:41 9348 8192000000 10846113328 11265331200 1916403376 18.958 100 53 106 2 1944744320 12368832 15972112
14:27:57 20335 8192000000 10854531472 11281022976 1924481488 19.023 100 47 93 1 1945377456 7731344 13164624
14:28:29 13840 8192000000 10861932400 11285712896 1928494480 19.055 100 54 106 1 1953442368 9547616 15400272
14:28:51 2994 8192000000 10875826176 11293757440 1937406224 19.126 100 57 113 1 1962756368 9187120 16163024
14:29:00 4545 8192000000 10878910064 11296665600 1942132432 19.164 100 66 131 2 1970333072 9537296 18663344
14:29:24 40124 8192000000 10886021648 11310268416 1942696320 19.168 100 54 108 1 1968626368 10944976 14985072
14:30:17 96212 8192000000 10886952736 11333132288 1954594208 19.263 100 47 92 1 1981949728 13813904 13541616
14:32:24 25552 8192000000 10892588512 11340713984 1960449888 19.310 100 17 34 2 1981416096 15958208 5008000
14:33:05 14422 8192000000 10918430064 11349434368 1973494224 19.413 100 39 75 0 2002542544 17843440 11204880
14:33:29 5509 8192000000 10930532784 11359010816 1983018912 19.489 100 50 100 1 2017881504 19290096 15572496
14:33:42 4741 8192000000 10934997056 11361001472 1987983392 19.528 100 62 121 3 2025658608 19238480 18436736
14:34:01 6989 8192000000 10941094032 11367571456 1989149344 19.537 100 56 112 1 2025579232 19692320 16737568
14:34:16 4374 8192000000 10946068256 11375169536 1994288384 19.578 100 65 130 3 2033677696 20964960 18424352
14:34:28 7768 8192000000 10944622656 11374993408 1997072768 19.600 100 61 122 2 2035646864 21333376 17240720
14:34:43 3363 8192000000 10954693712 11377459200 1995732048 19.589 100 66 131 0 2037000848 22528128 18740672
14:34:53 7875 8192000000 10947904736 11378790400 1997609760 19.604 100 66 132 1 2039707520 22806944 19290816
14:35:07 6906 8192000000 10935268544 11362902016 1981295616 19.475 99 54 108 1 2020092832 22562640 16234576
14:35:24 15688 8192000000 10948287152 11379040256 2000437088 19.626 100 70 139 2 2044247184 23261920 20548176
14:35:53 6444 8192000000 10953294064 11384958976 2004883840 19.661 100 55 109 2 2044445248 23776272 15785136
14:36:06 9498 8192000000 10952488272 11389620224 2006480704 19.674 100 57 114 1 2047126512 23723136 16922672
14:36:29 15503 8192000000 10955149920 11392565248 2005635440 19.667 100 43 86 2 2043390896 24810448 12945008
14:36:52 3777 8192000000 10963034736 11397734400 2008897536 19.693 100 50 100 0 2049667552 25616864 15153152
14:37:07 6124 8192000000 10961011120 11395837952 2010363360 19.704 100 52 104 0 2053060512 26326592 16370560
14:37:21 3739 8192000000 10973946896 11404562432 2014426656 19.736 100 68 138 0 2066055536 30856384 20772496
14:37:32 5705 8192000000 10973969056 11408187392 2018039424 19.765 100 68 135 3 2069279920 31205712 20034784
14:37:47 15058 8192000000 10984663248 11413024768 2020802784 19.786 100 74 148 2 2073601024 30832624 21965616
14:38:10 10450 8192000000 10985799200 11411042304 2014241824 19.735 100 73 146 0 2068609568 32628640 21739104
14:38:29 9861 8192000000 10976182848 11407155200 2014422800 19.736 100 65 130 1 2068377536 34018080 19936656
14:38:53 9172 8192000000 10983378912 11415179264 2018003408 19.764 100 61 122 0 2071878528 35775024 18100096
14:39:14 6186 8192000000 10994254160 11421933568 2024626320 19.816 100 65 129 2 2082501056 38285072 19589664
14:39:28 1562 8192000000 10996471232 11416080384 2012088208 19.718 99 81 161 1 2073251088 37537408 23625472
14:39:37 2909 8192000000 11008418432 11427561472 2025693360 19.825 100 86 170 0 2090051008 39091920 25265728
14:39:48 3233 8192000000 11015371520 11437809664 2033615776 19.887 100 84 167 0 2097840416 38969984 25254656
14:40:00 3206 8192000000 11003332928 11427643392 2025161792 19.821 100 75 149 0 2087890208 39487328 23241088
14:40:13 7325 8192000000 11006535680 11429531648 2028115568 19.844 100 79 158 0 2091287424 39504752 23667104
14:40:27 5227 8192000000 11006207760 11433668608 2028234560 19.845 100 81 162 1 2093290016 41202352 23853104
14:40:39 3957 8192000000 11006993120 11425947648 2027565312 19.840 100 83 165 4 2092441280 39229712 25646256
14:40:49 4253 8192000000 11012076336 11431723008 2029512864 19.855 100 79 157 2 2092663920 40173840 22977216
14:41:01 11465 8192000000 11014752368 11438669824 2030611072 19.863 100 71 142 0 2093673552 41777856 21284624
14:41:21 1870 8192000000 11023505520 11445661696 2037440944 19.917 100 79 159 2 2104265184 41734096 25090144
14:41:32 7072 8192000000 11018465776 11445248000 2034066160 19.890 100 85 169 1 2102352720 41870016 26416544
14:41:48 1271 8192000000 10990998608 11421454336 2017038832 19.757 99 70 139 2 2078432448 40078592 21315024
14:41:56 5514 8192000000 11015950144 11444695040 2034457984 19.894 100 73 146 1 2099637904 42560368 22619552
14:42:15 1297 8192000000 11033927136 11458895872 2044188064 19.970 100 78 157 1 2114496000 45947968 24359968
14:42:24 4995 8192000000 11021910288 11446562816 2025046448 19.820 99 84 166 0 2094983712 44155104 25782160
14:42:36 7650 8192000000 11010567072 11436933120 2015859056 19.748 99 78 154 3 2083385296 43593696 23932544
14:42:53 13381 8192000000 11015361536 11441668096 2016908656 19.756 99 77 154 1 2089747392 48285952 24552784
14:43:13 1551 8192000000 11020079632 11448643584 2032759200 19.880 100 70 139 0 2104632800 50087424 21786176
14:43:23 1376 8192000000 11027264704 11446149120 2027454896 19.839 100 89 178 4 2106134064 50993312 27685856
14:43:31 2025 8192000000 11028966864 11446317056 2029650160 19.856 100 91 182 1 2111788224 53811472 28326592
14:43:40 3341 8192000000 11018504176 11448352768 2026605568 19.832 100 79 157 0 2106004592 54532880 24866144
14:43:51 2898 8192000000 11033712720 11448029184 2027961008 19.843 100 86 168 3 2108771312 53999856 26810448
14:44:01 4146 8192000000 11015001280 11434967040 2015965648 19.748 99 81 162 1 2096709552 55544208 25199696
14:44:13 2131 8192000000 11039615632 11457593344 2037402672 19.917 100 90 180 3 2120978032 55875264 27700096
14:44:24 2052 8192000000 11028763648 11452915712 2016102336 19.750 99 78 156 1 2096724272 56226512 24395424
14:44:33 12030 8192000000 10987723888 11436986368 1998583200 19.612 99 49 98 1 2066111456 51635872 15892384
14:44:51 18857 8192000000 10981749776 11421097984 1980999104 19.473 99 43 86 1 2045060560 49221680 14839776
14:45:21 4363 8192000000 10997137584 11415171072 1994765952 19.581 100 72 142 4 2068017888 51492688 21759248
14:45:32 2292 8192000000 11010430736 11425931264 2007593568 19.683 100 87 172 1 2087768272 54126496 26048208
14:45:42 1561 8192000000 11013939952 11434225664 2009474432 19.697 100 81 162 1 2091731552 55611968 26645152
14:45:52 5677 8192000000 10998018160 11423707136 2002044208 19.639 100 71 142 1 2081068256 56773264 22250784
14:46:06 1835 8192000000 10994879552 11412963328 1977151376 19.442 99 92 180 2 2065684592 59926480 28606736
14:46:16 2848 8192000000 10997514336 11415482368 1992421824 19.563 100 83 166 0 2078442928 59771168 26249936
14:46:28 1817 8192000000 10998833328 11419357184 1996914176 19.598 100 85 167 2 2083519760 59619088 26986496
14:46:45 4952 8192000000 10972036032 11407626240 1971376496 19.396 99 60 120 2 2049917136 59006752 19533888
14:46:59 4920 8192000000 10993239776 11415052288 1994383296 19.578 100 58 116 2 2073591392 58595264 20612832
14:47:12 4179 8192000000 10984067040 11401789440 1980779296 19.471 100 70 138 2 2061645440 58173312 22692832
14:47:27 3819 8192000000 10998130224 11419041792 1994000928 19.575 100 82 165 2 2077911952 57499984 26411040
14:47:38 4001 8192000000 10984549488 11404603392 1986108160 19.513 100 81 161 0 2065169680 52976112 26085408
14:47:52 2081 8192000000 10984556512 11406147584 1975745376 19.431 99 81 161 0 2056931792 55619264 25567152
14:48:02 5324 8192000000 10961868064 11388096512 1966966192 19.361 100 61 122 0 2042455024 56240768 19248064
14:48:17 22045 8192000000 10940043376 11380310016 1923469584 19.015 98 34 68 1 1991990608 57159648 11361376
14:48:46 17938 8192000000 10942991776 11386847232 1959580928 19.303 100 32 63 0 2018560688 48640864 10338896
14:49:10 24209 8192000000 10940269872 11384598528 1965416592 19.349 100 40 80 1 2028382240 49971664 12993984
14:49:41 5026 8192000000 10927914784 11371511808 1951308544 19.237 99 38 76 1 2006341136 42704768 12327824
14:49:56 16912 8192000000 10933014096 11377958912 1962922960 19.329 100 43 87 0 2022191808 44590208 14678640
14:50:22 11951 8192000000 10936828032 11389878272 1964314128 19.340 100 30 60 3 2022357984 47683136 10360720
14:50:49 7119 8192000000 10906570160 11352727552 1911170816 18.916 98 28 57 1 1966331744 45316816 9844112
14:51:29 35883 8192000000 10907047152 11369684992 1923640432 19.016 99 18 36 1 1978535600 48511808 6383360
14:52:16 18593 8192000000 10915056304 11368570880 1938699680 19.136 100 22 44 2 1993264208 46715136 7849392
14:52:50 26300 8192000000 10889131120 11350069248 1923172064 19.012 100 14 28 0 1969374896 40843024 5359808
14:53:26 43078 8192000000 10890815360 11349516288 1909637104 18.904 99 15 30 0 1960873520 45585296 5651120
14:54:15 18934 8192000000 10861491008 11319898112 1907651568 18.888 99 16 32 0 1946444944 33324352 5469024
14:54:43 32334 8192000000 10848274464 11279290368 1853565216 18.451 96 39 78 2 1873505120 8417024 11522880
14:55:23 19587 8192000000 10833596272 11260682240 1850686624 18.428 97 40 80 1 1871760448 9919680 11154144
14:55:56 49599 8192000000 10814177616 11279585280 1831608912 18.272 97 15 30 1 1852453728 15952640 4892176
14:56:52 87473 8192000000 10837659728 11284324352 1880251664 18.667 99 16 32 0 1901699216 17258576 4188976
14:58:27 19762 8192000000 10840274368 11278487552 1903974448 18.858 100 53 99 0 1924153424 5911680 14267296
14:58:57 72771 8192000000 10835897552 11290075136 1836935440 18.316 96 19 36 0 1850202752 8559776 4707536
15:00:24 65074 8192000000 10857516528 11314688000 1906813104 18.881 99 36 72 1 1927814240 10615088 10386048
15:01:36 50730 8192000000 10850622832 11314397184 1894391744 18.781 98 8 16 0 1910687536 13801792 2494000
15:02:51 5092 8192000000 10855174512 11319234560 1930204528 19.069 100 9 18 0 1944653792 11765376 2683888
15:03:03 61048 8192000000 10881690704 11335483392 1931144576 19.076 99 31 62 4 1949028144 8962048 8921520
15:04:11 37679 8192000000 10880493232 11333746688 1929001664 19.059 99 11 22 0 1942001504 9372784 3627056
15:04:55 29396 8192000000 10908710624 11340435456 1936154800 19.116 99 57 115 1 1963622832 10087536 17380496
15:05:33 24267 8192000000 10891768880 11340472320 1950977376 19.234 100 35 70 1 1972580400 11719120 9883904
15:06:07 10931 8192000000 10892488816 11346522112 1957130368 19.283 100 41 80 2 1984829920 16138560 11560992
15:06:39 73298 8192000000 10880551696 11341213696 1922240432 19.005 98 14 29 1 1935205328 9413872 3551024
15:07:59 38722 8192000000 10897919088 11362533376 1970046720 19.386 100 11 22 0 1983408576 10140448 3221408
15:08:44 97586 8192000000 10874777808 11348738048 1897297664 18.805 96 12 24 0 1910839760 10243952 3298144
15:10:35 75233 8192000000 10879839024 11348324352 1943084784 19.171 99 18 36 1 1955184912 6460496 5639632
15:12:03 3021 8192000000 10892888368 11355414528 1966664592 19.359 100 20 40 0 1980900464 8834576 5401296
15:12:21 11392 8192000000 10883182224 11354152960 1949940016 19.226 99 16 33 3 1962939584 8478928 4520640
15:12:56 53391 8192000000 10888355248 11341529088 1937233152 19.125 99 17 34 2 1949802592 7556256 5013184
15:13:55 96296 8192000000 10889369392 11373436928 1947572464 19.207 99 29 58 2 1968386016 12449872 8363680
15:15:37 79486 8192000000 10902208480 11379871744 1977960096 19.449 100 13 25 3 1996662288 15188656 3513536
15:17:05 70615 8192000000 10908091984 11386384384 1978671664 19.454 100 11 22 0 1998064640 16036080 3356896
15:18:26 118531 8192000000 10928951920 11405516800 1957580704 19.287 98 18 36 2 1989054240 26196736 5276800
15:21:02 51795 8192000000 10911215920 11383820288 1951485856 19.238 99 13 26 1 1970897728 15793344 3618528
15:22:04 69266 8192000000 10912817504 11392593920 1965080928 19.346 99 13 27 1 1983597600 14666192 3850480
15:23:23 120265 8192000000 10881257344 11358552064 1828827504 18.250 92 11 22 1 1848404336 16443040 3133792
15:25:31 31990 8192000000 10895958704 11349970944 1927319344 19.045 98 23 46 0 1946437952 13027152 6091456
15:27:18 100236 8192000000 10888707056 11356110848 1929823584 19.065 98 17 34 1 1946057360 12016192 4217584
15:29:07 42861 8192000000 10895595552 11363254272 1967181808 19.363 100 12 24 2 1982845808 12798800 2865200
15:29:56 10185 8192000000 10880058320 11347431424 1957704816 19.288 100 22 43 0 1971603632 7998352 5900464
15:30:39 46011 8192000000 10881359552 11359141888 1962427744 19.325 100 8 16 0 1974596304 10174960 1993600
15:31:57 37349 8192000000 10885278592 11362365440 1945503792 19.191 99 8 16 0 1959460848 11850128 2106928
15:32:40 55287 8192000000 10864540416 11347734528 1878749632 18.655 96 6 12 0 1890266336 10214656 1302048
15:33:42 43749 8192000000 10888287904 11363635200 1958742080 19.296 100 21 40 0 1976654448 12110368 5802000
15:34:45 63553 8192000000 10881000224 11361767424 1913534496 18.935 97 10 20 0 1929245616 12970720 2740400
15:35:55 50443 8192000000 10887581888 11358089216 1906615680 18.879 97 26 52 2 1929506128 15921232 6969216
15:37:01 50504 8192000000 10861530912 11327717376 1884314224 18.700 97 18 36 1 1903326656 14322032 4690400
15:38:38 56756 8192000000 10888171216 11342487552 1912398736 18.926 98 34 68 1 1932682880 10703408 9580736
15:39:42 29953 8192000000 10902343456 11358449664 1961025328 19.314 100 44 87 2 1982322368 9337088 11959952
15:40:18 42212 8192000000 10879141296 11343917056 1919363440 18.982 98 19 38 1 1939092736 14699456 5029840
15:41:07 68773 8192000000 10883417072 11343773696 1873380384 18.612 96 20 40 1 1900602768 21509248 5713136
15:42:21 141375 8192000000 10866543296 11325300736 1790457328 17.936 92 16 32 1 1808274512 13861424 3955760
15:44:58 18089 8192000000 10891536320 11338018816 1942891776 19.170 100 31 62 1 1959726208 8289200 8545232
15:45:27 32381 8192000000 10872620496 11332640768 1878276368 18.651 96 29 58 3 1897793424 11647072 7869984
15:46:06 68150 8192000000 10889118960 11325607936 1922117632 19.004 99 19 37 1 1938392528 11042240 5232656
15:47:21 90281 8192000000 10877116416 11334103040 1919571328 18.983 98 48 97 2 1942007824 8655328 13781168
15:49:19 33122 8192000000 10879060912 11351662592 1957134080 19.283 100 21 42 0 1975287936 11985216 6168640
15:50:00 3529 8192000000 10891922448 11360833536 1963798608 19.336 100 19 38 0 1981390352 11816368 5775376
15:50:11 37758 8192000000 10879795968 11350609920 1944994944 19.187 99 16 32 1 1961909216 11818528 5095744
15:51:02 56720 8192000000 10856111360 11338723328 1878153728 18.650 96 6 12 0 1889684448 10300272 1230448
15:52:05 26511 8192000000 10857533696 11339968512 1941658208 19.160 100 6 12 0 1954125024 11106848 1359968
15:53:32 53355 8192000000 10876774992 11343302656 1896384720 18.797 97 14 30 0 1909878704 9107664 4386320
15:54:47 61558 8192000000 10851426944 11333894144 1884316016 18.700 97 9 18 0 1905546336 18469840 2760480
15:55:55 41372 8192000000 10854089616 11315224576 1877246960 18.643 97 18 36 2 1890713760 8139232 5327568
15:56:49 21491 8192000000 10866239632 11322347520 1918543504 18.975 99 42 84 2 1938024272 7743264 11737504
15:57:17 33344 8192000000 10853482432 11325747200 1902053312 18.843 98 22 44 0 1919414688 11565376 5796000
15:57:57 64357 8192000000 10886732176 11353255936 1928417200 19.054 99 24 48 1 1947228576 11830016 6981360
15:59:10 41971 8192000000 10898236336 11371089920 1942605328 19.168 99 21 42 1 1964719168 16569968 5543872
15:59:58 39383 8192000000 10926159664 11392675840 1974921632 19.424 100 30 59 1 1999119616 15652432 8545552
16:00:47 120303 8192000000 10912490400 11375611904 1917140832 18.964 97 16 32 3 1931814848 10426240 4247776
16:03:03 30875 8192000000 10923980816 11384061952 1959502160 19.302 99 37 74 0 1980041712 10255120 10284432
16:03:40 46979 8192000000 10928050912 11397099520 1985243744 19.506 100 24 48 1 2005048768 13137456 6667568
16:04:40 52318 8192000000 10931896944 11401228288 1984766480 19.502 100 21 42 1 2008597616 17948832 5882304
16:05:43 43594 8192000000 10912257248 11382935552 1949901856 19.226 98 18 36 1 1966166720 11466016 4798848
16:06:41 21291 8192000000 10918915472 11361255424 1906365888 18.877 96 50 100 1 1929697824 8609856 14722080
16:07:13 36899 8192000000 10907344032 11378290688 1967216848 19.363 100 37 75 1 1988961136 11490384 10253904
16:07:57 40745 8192000000 10902836528 11372818432 1935311024 19.109 98 11 22 0 1950834544 12233328 3290192
16:08:46 142756 8192000000 10866951184 11332780032 1857046000 18.479 94 19 38 2 1876601168 13788736 5766432
16:11:25 15931 8192000000 10878567424 11357999104 1939062656 19.139 99 33 66 0 1965586624 17107632 9416336
16:12:08 59026 8192000000 10880847568 11365564416 1947045840 19.203 99 19 38 0 1960619616 7926064 5647712
16:13:17 43921 8192000000 10881643632 11365412864 1946774688 19.201 99 7 14 0 1958169840 9453856 1941296
16:14:07 29757 8192000000 10893103920 11381043200 1968288320 19.372 100 9 18 1 1981966736 11370480 2307936
16:14:43 14374 8192000000 10886761536 11364954112 1935680080 19.112 98 11 22 0 1949691920 11062928 2948912
16:15:13 41851 8192000000 10861617872 11344596992 1917698736 18.968 98 11 22 0 1927210464 6875984 2635744
16:16:03 47590 8192000000 10885549008 11366113280 1952194784 19.244 100 5 10 0 1960481968 7068336 1218848
16:18:26 49833 8192000000 10864363120 11332714496 1867340640 18.563 95 22 44 1 1890975008 16403280 7231088
16:19:25 26876 8192000000 10892040288 11363192832 1950834720 19.233 100 23 46 1 1975889296 17594704 7459872
16:20:18 75747 8192000000 10899474384 11372249088 1947083152 19.203 99 28 56 2 1975943024 20618144 8241728
16:21:47 84152 8192000000 10883550880 11359653888 1889428112 18.741 96 22 45 0 1915552032 19382000 6741920
16:23:35 62414 8192000000 10863075520 11332722688 1854407088 18.458 95 17 34 0 1871328448 11221088 5700272
16:24:43 54871 8192000000 10862571360 11333603328 1849489984 18.418 95 21 42 1 1865162736 10486208 5186544
16:25:44 70805 8192000000 10884102640 11362258944 1939742336 19.145 100 17 34 1 1965769568 20881952 5145280
16:27:04 31138 8192000000 9277607264 9550020608 427918976 4.964 22 3 6 0 439411968 10615056 877936

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 02-02-2021 16:28:37 to 02-02-2021 16:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 154 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 02-02-2021 16:29:10 to 02-02-2021 16:29:11.

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          242358
MON$OLDEST_ACTIVE               242359
MON$OLDEST_SNAPSHOT             242359
MON$NEXT_TRANSACTION            242359
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                       2019008
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.33411 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33411 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33411 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33411 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 ---
:62: 
:63: mscs-test-161.budzdorov.ru    Tue Feb  2 16:27:45 2021
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
--- end of diff output ---

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

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