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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17469556 kB
MemAvailable 31488156 kB
Buffers 0 kB
Cached 14250204 kB
SwapCached 2812 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.7
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-08 22:26:59
DTS_END                         2020-11-08 22:26:59.6640
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/43764
TRN_ID                          249161
ATT_ID                          721
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: 9608.86 22405 1153063
customer order: creation 179.88 388 21585
customer order: refuse 15.76 313 1891
order to supplier: creation 47.98 1323 5758
order to supplier: removal 3.45 108710 414
invoice (draft): creation 47.61 3222 5713
invoice (draft): removal 54.45 839 6534
invoice accept: apply 43.16 16514 5179
invoice accept: cancel 49.18 792 5901
customer reserve: creation 4016.20 161 481944
customer reserve: removal 4842.99 61 581159
realization accept: apply 87.52 186 10502
realization accept: cancel 85.33 106 10240
payment from customer: creation 61.71 135 7405
payment from customer: removal 6.40 88 768
payment to supplier: creation 50.83 133 6100
payment to supplier: removal 3.68 101 442
service: total inventory turnovers 4.90 946 588
service: total monetary turnovers 6.94 27 833
service: aggregate perf. data 0.86 19576 103
service: refresh index statistics 0.03 294480 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-11-2020 22:29:18 to 08-11-2020 22:29:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2097
TEST_TIME 2 2476
TEST_TIME 3 3227
TEST_TIME 4 3060
TEST_TIME 5 3022
TEST_TIME 6 3969
TEST_TIME 7 4275
TEST_TIME 8 4059
TEST_TIME 9 4099
TEST_TIME 10 4267
TEST_TIME 11 4481
TEST_TIME 12 4529
TEST_TIME 13 4725
TEST_TIME 14 5339
TEST_TIME 15 5709
TEST_TIME 16 5726
TEST_TIME 17 6065
TEST_TIME 18 6182
TEST_TIME 19 6742
TEST_TIME 20 7146
TEST_TIME 21 7286
TEST_TIME 22 8026
TEST_TIME 23 8068
TEST_TIME 24 8128
TEST_TIME 25 8466
TEST_TIME 26 8971
TEST_TIME 27 9827
TEST_TIME 28 10575
TEST_TIME 29 10532
TEST_TIME 30 10554
TEST_TIME 31 10334
TEST_TIME 32 10108
TEST_TIME 33 10231
TEST_TIME 34 10160
TEST_TIME 35 10051
TEST_TIME 36 9988
TEST_TIME 37 9995
TEST_TIME 38 9886
TEST_TIME 39 9965
TEST_TIME 40 10102
TEST_TIME 41 9978
TEST_TIME 42 9826
TEST_TIME 43 9804
TEST_TIME 44 9743
TEST_TIME 45 9580
TEST_TIME 46 9642
TEST_TIME 47 9676
TEST_TIME 48 9654
TEST_TIME 49 9675
TEST_TIME 50 9716
TEST_TIME 51 9746
TEST_TIME 52 9776
TEST_TIME 53 9719
TEST_TIME 54 9863
TEST_TIME 55 9913
TEST_TIME 56 9858
TEST_TIME 57 9998
TEST_TIME 58 10042
TEST_TIME 59 10007
TEST_TIME 60 9877
TEST_TIME 61 9842
TEST_TIME 62 9802
TEST_TIME 63 9749
TEST_TIME 64 9678
TEST_TIME 65 9638
TEST_TIME 66 9634
TEST_TIME 67 9626
TEST_TIME 68 9636
TEST_TIME 69 9656
TEST_TIME 70 9607
TEST_TIME 71 9646
TEST_TIME 72 9715
TEST_TIME 73 9714
TEST_TIME 74 9718
TEST_TIME 75 9792
TEST_TIME 76 9847
TEST_TIME 77 9930
TEST_TIME 78 9896
TEST_TIME 79 9807
TEST_TIME 80 9744
TEST_TIME 81 9722
TEST_TIME 82 9721
TEST_TIME 83 9658
TEST_TIME 84 9597
TEST_TIME 85 9546
TEST_TIME 86 9537
TEST_TIME 87 9509
TEST_TIME 88 9545
TEST_TIME 89 9522
TEST_TIME 90 9533
TEST_TIME 91 9585
TEST_TIME 92 9624
TEST_TIME 93 9680
TEST_TIME 94 9700
TEST_TIME 95 9695
TEST_TIME 96 9687
TEST_TIME 97 9715
TEST_TIME 98 9678
TEST_TIME 99 9816
TEST_TIME 100 9743
TEST_TIME 101 9657
TEST_TIME 102 9638
TEST_TIME 103 9609
TEST_TIME 104 9537
TEST_TIME 105 9510
TEST_TIME 106 9520
TEST_TIME 107 9542
TEST_TIME 108 9558
TEST_TIME 109 9547
TEST_TIME 110 9545
TEST_TIME 111 9516
TEST_TIME 112 9634
TEST_TIME 113 9610
TEST_TIME 114 9603
TEST_TIME 115 9692
TEST_TIME 116 9716
TEST_TIME 117 9714
TEST_TIME 118 9689
TEST_TIME 119 9662
TEST_TIME 120 9612
TEST_TIME 121 9533

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-11-2020 22:29:21 to 08-11-2020 22:29:25.

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 1598671 1598671 0 0.00 0 16214 6 0 0
doc_list_biud 1598669 1598669 0 0.00 0 49578 28 0 0
sp_add_invoice_to_stock 5323 5179 144 2.70 22 188063 16515 0 144
sp_cancel_adding_invoice 5901 5901 0 0.00 4 92651 792 0 0
sp_cancel_client_order 1891 1891 0 0.00 5 9136 313 0 0
sp_cancel_customer_reserve 581159 581159 0 0.00 1 49580 62 0 0
sp_cancel_pay_from_customer 768 768 0 0.00 3 12159 88 0 0
sp_cancel_pay_to_supplier 442 442 0 0.00 2 7665 101 0 0
sp_cancel_supplier_invoice 6543 6534 9 0.13 2 24519 840 0 9
sp_cancel_supplier_order 414 414 0 0.00 6 1170139 108710 0 0
sp_cancel_write_off 10240 10240 0 0.00 1 15758 107 0 0
sp_client_order 21585 21585 0 0.00 3 48374 388 0 0
sp_customer_reserve 481944 481944 0 0.00 0 81345 161 0 0
sp_fill_shopping_cart 33048 33048 0 0.00 1 16448 36 0 0
sp_fill_shopping_cart_clo_res 481941 481941 0 0.00 0 21893 15 0 0
sp_get_clo_for_invoice 5176 5176 0 0.00 0 29827 336 0 0
sp_kill_cost_storno 17351 17351 0 0.00 0 15702 58 0 0
sp_kill_qstorno_ret_qs2qd 1179506 1179506 0 0.00 0 49576 34 0 0
sp_kill_qty_storno 621815 621815 0 0.00 0 49578 72 0 0
sp_lock_selected_doc 21763 21763 0 0.00 0 8273 7 0 0
sp_make_cost_storno 29183 29183 0 0.00 0 16148 55 0 0
sp_multiply_rows_for_pdistr 29181 29181 0 0.00 0 15993 33 0 0
sp_multiply_rows_for_qdistr 21585 21585 0 0.00 0 44853 200 0 0
sp_pay_from_customer 7405 7405 0 0.00 4 16248 136 0 0
sp_pay_to_supplier 6100 6100 0 0.00 4 14806 134 0 0
sp_payment_common 13505 13505 0 0.00 1 16195 45 0 0
sp_qd_handle_on_cancel_clo 1891 1891 0 0.00 0 9130 278 0 0
sp_qd_handle_on_invoice_upd_sts 11076 11076 0 0.00 0 46331 318 0 0
sp_qd_handle_on_reserve_upd_sts 10501 10501 0 0.00 0 16338 51 0 0
sp_reserve_write_off 10502 10502 0 0.00 6 16360 187 0 0
sp_supplier_invoice 5713 5713 0 0.00 6 85269 3222 0 0
sp_supplier_order 5758 5758 0 0.00 5 36568 1324 0 0
srv_aggregate_perf_data 103 103 0 0.00 2666 256175 19577 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1035 133921 33978 0 0
srv_find_qd_qs_mism 1102889 1102889 0 0.00 0 9666 5 0 0
srv_make_invnt_saldo 588 588 0 0.00 19 42956 947 0 0
srv_make_money_saldo 833 833 0 0.00 1 7931 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 218106 331227 294481 0 0
t$perf-abend:sp_add_invoice_to_stock 144 144 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5180 5180 0 0.00 0 6806 129 0 0
t$perf-norm:sp_cancel_adding_invoice 409 409 0 0.00 1 3515 92 0 0
t$perf-norm:sp_cancel_client_order 1891 1891 0 0.00 0 3874 12 0 0
t$perf-norm:sp_cancel_customer_reserve 740 740 0 0.00 0 927 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 768 768 0 0.00 0 3083 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 442 442 0 0.00 0 622 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 841 13 0 0
t$perf-norm:sp_cancel_supplier_order 414 414 0 0.00 0 20343 1482 0 0
t$perf-norm:sp_cancel_write_off 997 997 0 0.00 0 869 3 0 0
t$perf-norm:sp_client_order 21585 21585 0 0.00 0 7210 14 0 0
t$perf-norm:sp_customer_reserve 1021 1021 0 0.00 0 1513 5 0 0
t$perf-norm:sp_pay_from_customer 7406 7406 0 0.00 0 6179 9 0 0
t$perf-norm:sp_pay_to_supplier 6100 6100 0 0.00 0 6919 8 0 0
t$perf-norm:sp_reserve_write_off 10502 10502 0 0.00 0 5433 8 0 0
t$perf-norm:sp_supplier_invoice 5713 5713 0 0.00 0 4362 15 0 0
t$perf-norm:sp_supplier_order 5758 5758 0 0.00 0 3432 15 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 311 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 1864 13 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 2490 22 0 0
t$perf-norm:srv_make_money_saldo 833 833 0 0.00 0 3433 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 3 3 0 0
v_add_invoice_to_stock 10638 10350 288 2.70 0 6015 18 0 288
v_all_customers 38944 38944 0 0.00 0 51 1 0 0
v_all_suppliers 31816 31816 0 0.00 0 23 1 0 0
v_all_wares 43168 43168 0 0.00 0 68 1 0 0
v_cancel_adding_invoice 818 818 0 0.00 0 2423 17 0 0
v_cancel_client_order 3782 3782 0 0.00 0 2760 6 0 0
v_cancel_customer_prepayment 1536 1536 0 0.00 0 1357 5 0 0
v_cancel_customer_reserve 1480 1480 0 0.00 0 2272 4 0 0
v_cancel_payment_to_supplier 884 884 0 0.00 0 2608 10 0 0
v_cancel_supplier_invoice 870 852 18 2.06 0 2940 24 0 18
v_cancel_supplier_order 828 828 0 0.00 0 1529 6 0 0
v_cancel_write_off 1994 1994 0 0.00 0 3540 14 0 0
v_max_id_clo_ord 5755 5755 0 0.00 0 1095 1 0 0
v_max_id_clo_res 1021 1021 0 0.00 0 3200 22 0 0
v_max_id_ord_sup 5709 5709 0 0.00 0 5697 6 0 0
v_max_non_paid_invoice 1656 1656 0 0.00 0 3751 7 0 0
v_max_non_paid_realizn 4126 4126 0 0.00 0 6646 5 0 0
v_min_id_clo_ord 5755 5755 0 0.00 0 6697 12 0 0
v_min_id_clo_res 1021 1021 0 0.00 0 2455 9 0 0
v_min_id_ord_sup 5709 5709 0 0.00 0 4690 6 0 0
v_min_non_paid_invoice 6100 6100 0 0.00 0 14700 27 0 0
v_min_non_paid_realizn 7405 7405 0 0.00 0 16165 35 0 0
v_our_firm 10782 10782 0 0.00 0 14 1 0 0
v_reserve_write_off 21002 21002 0 0.00 0 3046 5 0 0
x_lock_depdocs_on_canc_invoice 12009 12009 0 0.00 0 9867 101 0 0
x_lock_depdocs_on_canc_sup_ord 414 414 0 0.00 0 11906 313 0 0
x_make_qstorno_1000_1200 5758 5758 0 0.00 2 36530 1242 0 0
x_make_qstorno_1200_2000 5713 5713 0 0.00 3 75423 3097 0 0
x_make_qstorno_2100_3300 481944 481944 0 0.00 0 81344 144 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-11-2020 22:29:26 to 08-11-2020 22:29:30.

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:02 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:09 26250 8192000000 10292159024 10600894464 1076742512 11.616 83 59 121 0 1098356128 3067008 18546608
19:57:43 16312 8192000000 10335950656 10655219712 1397209088 14.570 100 90 180 0 1431577504 5128080 29240336
19:58:11 21145 8192000000 10379999856 10705674240 1431331056 14.873 100 81 162 1 1464548848 6622928 26594864
19:58:46 32875 8192000000 10423457792 10750955520 1473391024 15.243 100 89 178 1 1510549600 7812128 29346448
19:59:37 9384 8192000000 10444829296 10775650304 1499161088 15.469 100 90 179 0 1536343824 8431888 28750848
19:59:56 23397 8192000000 10463741072 10798678016 1518469216 15.637 100 89 178 1 1555716176 8859744 28387216
20:00:32 23313 8192000000 10475787136 10816991232 1531423264 15.749 100 88 176 1 1569031216 9693376 27914576
20:01:12 13638 8192000000 10497169392 10841358336 1547553344 15.889 100 83 166 1 1583614960 9205616 26856000
20:01:39 14973 8192000000 10525906128 10874765312 1574872896 16.124 100 79 158 0 1608587040 9473264 24240880
20:02:03 12300 8192000000 10548027408 10900176896 1607455248 16.403 100 87 174 1 1643935344 9912944 26567152
20:02:26 10690 8192000000 10564361248 10920128512 1622572608 16.532 100 81 162 0 1657359232 10715504 24071120
20:02:46 14319 8192000000 10580056224 10942504960 1635420976 16.641 100 75 150 0 1669123376 11728272 21974128
20:03:09 11364 8192000000 10605632944 10971185152 1660698080 16.855 100 77 154 1 1695767888 12073216 22996592
20:03:40 7368 8192000000 10620374992 10991329280 1683440576 17.046 100 76 151 2 1717734704 12246720 22047408
20:03:54 8575 8192000000 10637688752 11009449984 1697466832 17.164 100 86 171 2 1734642544 12637904 24537808
20:04:15 6177 8192000000 10651358224 11026001920 1717019152 17.327 100 75 150 3 1750725888 12153872 21552864
20:04:29 8439 8192000000 10677016464 11052019712 1734837584 17.476 100 75 150 2 1768376240 12232576 21306080
20:04:45 8140 8192000000 10702875536 11073933312 1754203568 17.636 100 89 177 2 1792383136 13784400 24395168
20:05:00 4799 8192000000 10698864096 11074949120 1762090848 17.702 100 86 170 2 1799812752 14202064 23519840
20:05:13 4196 8192000000 10707199712 11083571200 1767344656 17.745 100 84 168 0 1805445584 14372544 23728384
20:05:24 4310 8192000000 10713430528 11092754432 1771675232 17.781 100 88 177 3 1810215936 14306224 24234480
20:05:35 2320 8192000000 10712860688 11091849216 1777112176 17.826 100 81 162 0 1814016624 14292720 22611728
20:05:44 2738 8192000000 10726268304 11103612928 1786943216 17.907 100 87 173 0 1825507776 14561392 24003168
20:05:54 3157 8192000000 10733822896 11110793216 1791874112 17.947 100 86 171 0 1829922432 14349456 23698864
20:06:03 3344 8192000000 10734186640 11113807872 1795359200 17.976 100 87 171 3 1834524800 14221312 24944288
20:06:13 7267 8192000000 10734403312 11120496640 1796454576 17.985 100 78 156 1 1832378816 14079520 21844720
20:06:29 4767 8192000000 10745922432 11132579840 1811760640 18.110 100 79 157 3 1846654400 12832816 22060944
20:06:41 2154 8192000000 10755994208 11144343552 1823227856 18.204 100 83 166 2 1860333984 13289616 23816512
20:06:50 2769 8192000000 10773104592 11157229568 1829975776 18.259 100 85 168 0 1871568544 18629568 22963200
20:06:59 2296 8192000000 10779295232 11166322688 1838448240 18.328 100 93 184 1 1878767200 13973584 26345376
20:07:07 1359 8192000000 10792224864 11173859328 1840714304 18.347 100 89 179 0 1880350832 13769984 25866544
20:07:15 1922 8192000000 10781505488 11171508224 1851274208 18.432 100 88 176 2 1888657680 11422176 25961296
20:07:23 1492 8192000000 10792849296 11179454464 1850154864 18.423 100 82 164 1 1884405248 11429024 22821360
20:07:31 3147 8192000000 10790592272 11184353280 1855164208 18.464 100 88 177 1 1892110640 12273520 24672912
20:07:41 1046 8192000000 10802783168 11187380224 1854236048 18.457 100 89 177 1 1891152016 12180576 24735392
20:07:48 1636 8192000000 10791526576 11179503616 1857794640 18.485 100 93 187 0 1897466656 13018464 26653552
20:07:56 1650 8192000000 10812072160 11198525440 1864170240 18.537 100 95 190 2 1904784544 13438368 27175936
20:08:04 1358 8192000000 10816162256 11202088960 1866408752 18.555 100 93 186 0 1904774704 12278880 26087072
20:08:11 1631 8192000000 10812733968 11202342912 1867166192 18.561 100 95 191 1 1907613632 13598112 26849328
20:08:19 44043 8192000000 10785720016 11192164352 1858889520 18.494 100 54 108 0 1884356336 8801600 16665216
20:09:11 6589 8192000000 10801449712 11199438848 1865489088 18.548 100 75 147 1 1896501664 10398864 20613712
20:09:24 12554 8192000000 10776320608 11197157376 1862570096 18.524 100 43 86 0 1884851056 10434512 11846448
20:09:44 9356 8192000000 10778312992 11201024000 1863076736 18.528 100 32 64 1 1878613216 6186096 9350384
20:10:03 6722 8192000000 10768970208 11197661184 1863981152 18.536 100 24 49 1 1877922816 7282096 6659568
20:10:16 8403 8192000000 10783731616 11208134656 1868439280 18.572 100 24 48 1 1882811344 7365376 7006688
20:10:32 3978 8192000000 10788711520 11211276288 1871346144 18.595 100 35 71 2 1887558816 6212032 10000640
20:10:44 4911 8192000000 10797989360 11219329024 1875161312 18.626 100 34 68 0 1895933552 11589632 9182608
20:10:58 7170 8192000000 10787975456 11215400960 1877365952 18.644 100 29 58 2 1893911088 7811696 8733440
20:11:12 4805 8192000000 10789296192 11217514496 1877753712 18.647 100 25 48 2 1891011392 6639232 6618448
20:11:23 7497 8192000000 10800174352 11224096768 1882979728 18.689 100 27 54 2 1897333824 6379856 7974240
20:11:42 10118 8192000000 10780244656 11218477056 1886351328 18.716 100 17 34 0 1896087344 5308576 4427440
20:11:58 2955 8192000000 10790899008 11224817664 1887551232 18.726 100 26 52 0 1902381824 6825216 8005376
20:12:13 13155 8192000000 10798799120 11229634560 1885676624 18.711 100 11 22 0 1894757840 5642832 3438384
20:12:37 9126 8192000000 10805071872 11236458496 1889946080 18.745 100 13 26 1 1903898416 10503552 3448784
20:12:56 9005 8192000000 10803149904 11235594240 1891091360 18.755 100 19 38 1 1902925088 6536560 5297168
20:13:12 14262 8192000000 10802910032 11235635200 1894048544 18.778 100 20 38 2 1905725264 6115104 5561616
20:13:34 59977 8192000000 10825332960 11249176576 1901684016 18.840 100 47 94 1 1921794128 5702112 14408000
20:14:43 11363 8192000000 10826221152 11260215296 1901665584 18.840 100 30 58 3 1924868624 15431792 7771248
20:15:02 7128 8192000000 10812000512 11244208128 1884923024 18.705 99 24 48 2 1897996352 6384576 6688752
20:15:16 7655 8192000000 10820784272 11253178368 1900701328 18.832 100 30 60 2 1915013264 5997504 8314432
20:15:32 6725 8192000000 10810639296 11235495936 1868034064 18.568 98 25 50 1 1881263440 6012608 7216768
20:15:46 7767 8192000000 10808449168 11247423488 1903787600 18.857 100 24 48 1 1917879136 5859584 8231952
20:16:01 8969 8192000000 10811756528 11250716672 1887362032 18.725 99 19 38 1 1898720800 5345328 6013440
20:16:18 6641 8192000000 10819700976 11253612544 1901639152 18.839 100 20 40 1 1916827680 9413232 5775296
20:16:31 5923 8192000000 10795406144 11227828224 1845924848 18.389 97 16 31 4 1856012160 5463584 4623728
20:16:43 12307 8192000000 10797905712 11222843392 1802032832 18.031 95 17 34 1 1812121584 5500496 4588256
20:17:02 10615 8192000000 10784407088 11218255872 1859520224 18.499 99 18 36 3 1870651504 5340480 5790800
20:17:19 16278 8192000000 10765106464 11194249216 1785489008 17.895 95 17 34 3 1800527744 10171088 4867648
20:17:42 11974 8192000000 10761876816 11190784000 1792538928 17.953 96 13 24 1 1801461376 5428800 3493648
20:18:02 79326 8192000000 10718666768 11133386752 1583763440 16.200 85 31 62 1 1596722240 4385456 8573344
20:19:29 8999 8192000000 10724897264 11145719808 1784549664 17.887 98 34 68 0 1800061712 5572256 9939792
20:19:47 7009 8192000000 10708012736 11131170816 1745831616 17.567 96 30 60 2 1761075024 6198384 9045024
20:20:00 7219 8192000000 10726620160 11140042752 1768198048 17.752 97 41 82 0 1786749872 7122768 11429056
20:20:14 4908 8192000000 10737453744 11148582912 1805886336 18.062 100 39 77 2 1824921808 8300800 10734672
20:20:31 6086 8192000000 10683509568 11095814144 1721247584 17.363 96 23 46 1 1733633600 5727472 6658544
20:20:44 5782 8192000000 10705590896 11114807296 1755296416 17.645 98 35 70 2 1771641920 6088320 10257184
20:20:57 8139 8192000000 10712744704 11139276800 1804105856 18.048 100 20 40 1 1820469232 10124976 6238400
20:21:13 9467 8192000000 10716735760 11124731904 1746037280 17.569 96 25 51 1 1758437552 4941504 7458768
20:21:29 10268 8192000000 10691336288 11109904384 1743110448 17.544 97 28 56 0 1757319168 5929200 8279520
20:21:46 11247 8192000000 10710309424 11133067264 1796677632 17.987 100 22 44 3 1808925328 5450992 6796704
20:22:03 10402 8192000000 10728809248 11149324288 1815448800 18.140 100 29 58 1 1830784032 5825728 9509504
20:22:22 11118 8192000000 10745607344 11168751616 1828342736 18.246 100 21 42 1 1840261968 5631984 6287248
20:22:40 24983 8192000000 10732874272 11168587776 1814624912 18.134 99 28 57 2 1828681600 5408848 8647840
20:23:42 28149 8192000000 10758570272 11177496576 1839553424 18.337 100 29 58 1 1853336544 5949136 7833984
20:24:17 9430 8192000000 10759578032 11187707904 1844500208 18.377 100 23 46 0 1856747568 5889952 6357408
20:24:33 7019 8192000000 10752035760 11187458048 1848546160 18.410 100 27 54 2 1862996880 6117744 8332976
20:24:47 9639 8192000000 10769159616 11189620736 1847905952 18.405 100 27 54 0 1861292016 5821568 7564496
20:25:06 5130 8192000000 10760764192 11191263232 1852613568 18.443 100 24 47 0 1865206336 5673840 6918928
20:25:21 11789 8192000000 10766417344 11193831424 1854534928 18.459 100 29 58 0 1869060368 6424592 8100848
20:25:39 7358 8192000000 10780578896 11204317184 1857457296 18.483 100 24 48 3 1870117024 5492288 7167440
20:25:57 13613 8192000000 10775006656 11206365184 1858548464 18.492 100 18 36 2 1869573520 6075648 4949408
20:26:20 10860 8192000000 10773792736 11207176192 1863420448 18.531 100 22 43 2 1875267856 5572784 6274624
20:26:37 9033 8192000000 10781433184 11210924032 1863687232 18.533 100 25 48 1 1875545344 4715120 7142992
20:26:55 40791 8192000000 10819229696 11235241984 1874609888 18.622 100 34 67 4 1889639168 5347264 9682016
20:27:43 44374 8192000000 10826012272 11253837824 1907224528 18.884 100 28 56 0 1922329680 6889168 8215984
20:28:54 10611 8192000000 10851212016 11273900032 1922610112 19.008 100 35 69 1 1941014000 7646624 10757264
20:29:12 26447 8192000000 10852629648 11281485824 1929100240 19.060 100 37 74 1 1947721616 8292800 10328576
20:29:45 65421 8192000000 10869139584 11298803712 1938529472 19.135 100 45 89 2 1962895488 10650816 13715200
20:31:09 74777 8192000000 10869957584 11315609600 1946407024 19.198 100 23 46 1 1967876000 14550800 6918176
20:32:31 51279 8192000000 10888526016 11327807488 1952758032 19.248 100 30 59 1 1977043872 15192240 9093600
20:33:38 26369 8192000000 10903088400 11347931136 1970241248 19.387 100 35 70 4 1993338496 12541008 10556240
20:34:12 13783 8192000000 10917102256 11346743296 1946141088 19.196 98 43 86 1 1974963952 15553696 13269168
20:34:33 30899 8192000000 10922775824 11352309760 1979291312 19.459 100 51 101 1 2011857344 17120688 15445344
20:35:13 7627 8192000000 10928511344 11356848128 1985068224 19.505 100 60 117 2 2020841344 19039056 16734064
20:35:30 17701 8192000000 10925006656 11362164736 1986050944 19.513 100 42 84 1 2018565632 19480896 13033792
20:35:56 5116 8192000000 10938789616 11366514688 1992401936 19.563 100 59 118 2 2030700672 20071744 18226992
20:36:13 2829 8192000000 10942990256 11366207488 1991109808 19.553 100 64 128 1 2030788368 20924352 18754208
20:36:24 8277 8192000000 10939760176 11371061248 1994242400 19.577 100 55 107 1 2030918304 20611520 16064384
20:36:46 11047 8192000000 10947674384 11383500800 2000114240 19.624 100 51 102 2 2038975984 23469216 15392528
20:37:04 10272 8192000000 10958651296 11386503168 2000908256 19.630 100 54 108 1 2041583120 23859888 16814976
20:37:22 4878 8192000000 10959630000 11383414784 1998020176 19.607 100 63 126 2 2045367840 28409440 18938224
20:37:35 17209 8192000000 10963406896 11391389696 2003002560 19.646 100 55 110 2 2049621536 29518848 17100128
20:38:10 13797 8192000000 10957483328 11387588608 1983617520 19.493 99 47 94 1 2030975280 32486528 14871232
20:38:31 4289 8192000000 10959416624 11389550592 1994604720 19.580 100 52 102 0 2044100384 33276832 16218832
20:38:43 9031 8192000000 10960207024 11391217664 1999549856 19.619 100 57 115 1 2052953232 34051872 19351504
20:39:00 4684 8192000000 10959737104 11383816192 1990579712 19.548 100 60 120 2 2044211376 34220976 19410688
20:39:15 6032 8192000000 10970435136 11394080768 2004132016 19.655 100 67 134 0 2061278304 35959088 21187200
20:39:31 13436 8192000000 10958379536 11388899328 1982165328 19.482 99 58 112 1 2036035680 36075344 17795008
20:39:55 13791 8192000000 10975654176 11400638464 2000493920 19.627 100 66 127 4 2058135648 37009264 20632464
20:40:18 8011 8192000000 10964230512 11395551232 1987342224 19.523 99 57 114 1 2040983792 35207296 18434272
20:40:36 2256 8192000000 10976723584 11398963200 2004156384 19.655 100 71 139 0 2060170544 33873072 22141088
20:40:45 2987 8192000000 10976968032 11402973184 2005365360 19.665 100 76 152 1 2062644576 33681040 23598176
20:40:56 4755 8192000000 10986678032 11411976192 2011689440 19.715 100 75 148 2 2071782448 36758528 23334480
20:41:09 2286 8192000000 10971698096 11394101248 1997641664 19.604 100 76 152 2 2057820784 36059808 24119312
20:41:18 1034 8192000000 10977749440 11391975424 1996779296 19.597 100 93 188 2 2062391088 36694864 28916928
20:41:27 3697 8192000000 10990819232 11410018304 2008428960 19.689 100 80 160 1 2071525616 38087568 25009088
20:41:38 2467 8192000000 10989226112 11401334784 2003775712 19.652 100 83 165 2 2066697696 37270432 25651552
20:41:47 2679 8192000000 10984719200 11407114240 2006273792 19.672 100 75 150 0 2066922128 37272000 23376336
20:41:58 8456 8192000000 10990146208 11407323136 1992510512 19.564 99 73 147 1 2052962864 38187744 22264608
20:42:15 5424 8192000000 10978592848 11403657216 1986668768 19.517 99 72 144 1 2048873040 39812560 22391712
20:42:28 1986 8192000000 10978612224 11388698624 1977581296 19.446 99 83 165 1 2044929824 41679408 25669120
20:42:39 6845 8192000000 10977099664 11398909952 1985282080 19.506 99 75 150 2 2056245184 47827632 23135472
20:42:58 7086 8192000000 10989766752 11412951040 2004108784 19.655 100 77 154 2 2072703456 44389328 24205344
20:43:14 8065 8192000000 10998656832 11423944704 2015525696 19.745 100 66 132 2 2081637424 45374112 20737616
20:43:32 4949 8192000000 11010217600 11434110976 2023943472 19.811 100 71 142 1 2093208256 45318240 23946544
20:43:44 1907 8192000000 11001946272 11417489408 2010324448 19.704 99 86 171 0 2081650240 44267392 27058400
20:43:53 1712 8192000000 11020498128 11436081152 2022141232 19.797 100 82 166 5 2093580928 45510256 25929440
20:44:01 2851 8192000000 11006984464 11431079936 2017850400 19.763 100 75 150 0 2086589568 45435840 23303328
20:44:11 2755 8192000000 11008586544 11428560896 2005312064 19.665 99 84 168 0 2077870624 46371584 26186976
20:44:21 1100 8192000000 11019817216 11436834816 2026121408 19.828 100 91 184 0 2102579120 48214928 28242784
20:44:29 4115 8192000000 10997405824 11413262336 1989172016 19.537 99 85 170 2 2065891152 50236928 26482208
20:44:41 1691 8192000000 11000512704 11410890752 1993942240 19.575 100 84 168 1 2073697232 52851152 26903840
20:44:49 2735 8192000000 10986480688 11411001344 1997045536 19.599 100 71 142 0 2073754112 53459936 23248640
20:45:12 6782 8192000000 10976529248 11396972544 1969945008 19.385 99 69 138 2 2048883968 55620096 23318864
20:45:37 3561 8192000000 10970222816 11400278016 1964633104 19.343 99 60 120 2 2042656976 57138640 20885232
20:45:51 3502 8192000000 10986587312 11401027584 1970089728 19.386 99 75 148 2 2046914112 52368080 24456304
20:46:03 3444 8192000000 10971375808 11387346944 1963025312 19.330 99 77 153 1 2044146336 56126080 24994944
20:46:15 2272 8192000000 10983240000 11402850304 1985985232 19.512 100 84 170 3 2069728320 57070096 26672992
20:46:24 5377 8192000000 10979355648 11400912896 1968511296 19.374 99 69 138 1 2045035536 54405968 22118272
20:46:38 7452 8192000000 10959016112 11389874176 1945993088 19.195 98 54 108 0 2018152496 54811840 17347568
20:46:53 4063 8192000000 10960299872 11392999424 1978536832 19.453 100 54 106 2 2047012784 51768080 16707872
20:47:22 11068 8192000000 10977869504 11412312064 1986702480 19.518 100 51 102 1 2063661936 59404992 17554464
20:47:41 5237 8192000000 10955412960 11389620224 1947773744 19.209 98 49 98 0 2026822416 62360032 16688640
20:47:55 5542 8192000000 10973726096 11399389184 1981429760 19.476 100 51 102 1 2052313728 54121392 16762576
20:48:08 9151 8192000000 10979160176 11415764992 1986836800 19.519 100 48 95 2 2061863184 59054848 15971536
20:48:38 21354 8192000000 10946405632 11392782336 1966122832 19.355 99 35 70 2 2030073488 51896656 12054000
20:49:06 8005 8192000000 10961856288 11408748544 1980954336 19.472 100 39 78 0 2040116080 45849344 13312400
20:49:21 12606 8192000000 10966343888 11413401600 1989564960 19.540 100 31 62 0 2050142224 49618128 10959136
20:49:43 14063 8192000000 10963333984 11416522752 1989472352 19.540 100 32 64 0 2052583728 51937088 11174288
20:50:08 10037 8192000000 10976667584 11417923584 1994620704 19.580 100 42 84 1 2058158144 48821616 14715824
20:50:25 42269 8192000000 10946039584 11399331840 1929143536 19.060 97 30 60 0 1997127712 57154896 10829280
20:51:14 17704 8192000000 10930167840 11391041536 1935145840 19.108 99 24 48 0 2002254560 57794624 9314096
20:52:01 20932 8192000000 10938128576 11386560512 1952504128 19.246 100 30 60 0 2024680912 60600656 11576128
20:52:57 22359 8192000000 10919421216 11397324800 1950017456 19.227 100 24 47 4 2006776624 48222528 8536640
20:53:34 31190 8192000000 10894313200 11368407040 1919514608 18.983 98 17 34 1 1972860544 47419056 5926880
20:54:13 49014 8192000000 10883256880 11315380224 1895339328 18.789 97 24 49 0 1923983600 20527504 8116768
20:55:09 34229 8192000000 10873202992 11347738624 1945834048 19.193 100 22 43 3 1965797520 13297408 6666064
20:55:51 46798 8192000000 10871137408 11339816960 1913051488 18.931 99 14 28 3 1930196896 13390544 3754864
20:56:59 61808 8192000000 10876918672 11320152064 1868648608 18.573 95 42 85 3 1890634080 10844800 11140672
20:58:07 133920 8192000000 10875774048 11347968000 1899116208 18.819 98 30 60 0 1925770304 18043408 8610688
21:00:35 66028 8192000000 10893211552 11334299648 1868913696 18.575 95 52 104 2 1892871408 9465376 14492336
21:01:49 73718 8192000000 10886489120 11317207040 1877015984 18.641 97 43 86 1 1906116288 15448624 13651680
21:03:09 33815 8192000000 10857375808 11321241600 1925046592 19.027 99 32 65 0 1947975408 13716192 9212624
21:04:01 38106 8192000000 10861173840 11320897536 1900887536 18.833 98 18 36 0 1919538928 13542192 5109200
21:04:51 11670 8192000000 10888816224 11333685248 1940971392 19.155 100 20 40 0 1962202512 15053136 6177984
21:05:13 15577 8192000000 10892596752 11341066240 1949689072 19.224 100 56 112 1 1979251584 12485680 17076832
21:05:35 33194 8192000000 10881563712 11317813248 1912990976 18.931 98 46 91 0 1938525920 11589408 13945536
21:06:15 38210 8192000000 10871402768 11342884864 1951518080 19.239 100 42 83 0 1975538416 12465072 11555264
21:07:01 99592 8192000000 10896392224 11347431424 1926498288 19.039 98 26 52 2 1946364704 12007728 7858688
21:08:51 21427 8192000000 10883273968 11349983232 1956708192 19.280 100 23 46 3 1977547088 14135984 6702912
21:09:24 28183 8192000000 10886314800 11359862784 1957928048 19.290 100 10 20 1 1972317072 11526576 2862448
21:10:12 54486 8192000000 10889183744 11363164160 1969480624 19.381 100 18 36 1 1984437376 10033968 4922784
21:11:13 87102 8192000000 10883559552 11360481280 1890326688 18.748 96 28 56 2 1912674096 14554176 7793232
21:13:17 44449 8192000000 10880239360 11360092160 1939242256 19.141 99 6 12 0 1953936704 12845120 1849328
21:14:09 38843 8192000000 10886776576 11358662656 1968720416 19.375 100 28 56 1 1984705648 7837984 8147248
21:14:55 62580 8192000000 10905520304 11371012096 1952844320 19.249 99 22 43 2 1973153488 14328752 5980416
21:16:05 58030 8192000000 10894621696 11373277184 1951823776 19.241 99 22 44 1 1975432240 17350480 6257984
21:17:10 53946 8192000000 10905939280 11370844160 1938518608 19.135 98 15 30 1 1955898624 12827344 4552672
21:18:23 38540 8192000000 10906580384 11371016192 1940957168 19.154 98 23 46 3 1965373120 18124512 6291440
21:19:09 65839 8192000000 10894399904 11361112064 1927012992 19.043 98 33 65 3 1951852144 15500000 9339152
21:20:27 81806 8192000000 10894152528 11365441536 1924521104 19.023 98 24 48 1 1945026928 13641536 6864288
21:21:58 66545 8192000000 10894507008 11349979136 1884719120 18.703 96 29 60 0 1906637120 13752000 8166000
21:23:14 55816 8192000000 10881462528 11361546240 1944132560 19.180 100 16 32 0 1965885120 16914080 4838480
21:24:20 64730 8192000000 10905369776 11362590720 1943902800 19.178 99 23 46 1 1961485744 11516720 6066224
21:25:31 104861 8192000000 10893407920 11358220288 1949062128 19.219 99 31 62 1 1968452624 10006560 9383936
21:27:22 70631 8192000000 10900617520 11366383616 1917470544 18.967 97 30 60 0 1938564624 12899136 8194944
21:28:39 7047 8192000000 10881297424 11363217408 1964061408 19.338 100 11 22 0 1977541536 10793376 2686752
21:29:12 35275 8192000000 10862710896 11332149248 1924908320 19.026 98 19 38 1 1936366768 6079568 5378880
21:30:10 45797 8192000000 10865120448 11342364672 1949759008 19.225 100 6 12 0 1956218448 5162800 1296640
21:31:01 47330 8192000000 10876928368 11357962240 1958919824 19.297 100 8 16 1 1966925840 6131472 1874544
21:31:55 57961 8192000000 10876031280 11339956224 1850750976 18.428 94 15 30 1 1861921152 7257808 3912368
21:33:05 43921 8192000000 10870027584 11348668416 1941266384 19.157 99 15 30 1 1956690608 10266880 5157344
21:34:09 50307 8192000000 10883606480 11330527232 1855948640 18.470 95 31 62 0 1878416656 13109856 9358160
21:35:22 60661 8192000000 10882493008 11345371136 1876142096 18.634 96 24 48 0 1897747200 14651248 6953856
21:36:29 65312 8192000000 10893225536 11356463104 1929859600 19.066 99 25 50 2 1957508848 20313968 7335280
21:37:45 62024 8192000000 10892004208 11368861696 1922829552 19.010 98 29 58 1 1949681088 18980368 7871168
21:38:55 52175 8192000000 10904707152 11355299840 1877288336 18.643 96 23 45 0 1899874304 15931792 6654176
21:40:37 56813 8192000000 10883523888 11346558976 1871355520 18.595 96 18 36 0 1895966864 19743792 4867552
21:41:43 78695 8192000000 10880116784 11346255872 1914703664 18.944 99 4 8 1 1935157248 19487968 965616
21:43:08 101984 8192000000 10856133760 11303591936 1787096704 17.908 92 21 42 1 1801420112 8640656 5682752
21:45:04 79021 8192000000 10852169312 11297918976 1863739168 18.534 97 36 72 0 1882179312 7818240 10621904
21:46:37 69027 8192000000 10818767376 11281756160 1887240896 18.724 98 29 57 0 1904980080 9726192 8012992
21:47:54 12642 8192000000 10846270160 11310387200 1921826800 19.001 100 13 26 0 1932581584 6978496 3776288
21:48:13 32914 8192000000 10872564000 11334307840 1940401680 19.150 100 22 44 0 1955441776 8448288 6591808
21:48:59 45242 8192000000 10841369152 11318558720 1900987440 18.834 98 4 8 0 1911931968 9904496 1040032
21:49:50 9393 8192000000 10840677952 11321909248 1925526400 19.031 100 2 4 0 1935804032 9860656 416976
21:50:06 2181 8192000000 10839618800 11322224640 1924025280 19.019 100 2 4 0 1935139472 10538544 575648
21:50:14 2360 8192000000 10837248816 11322011648 1924376672 19.022 100 2 4 0 1933337984 8716688 244624
21:50:26 3163 8192000000 10837697648 11323392000 1925424144 19.030 100 1 2 0 1934117936 8631664 62128
21:50:35 15861 8192000000 10841614288 11320958976 1930792800 19.073 100 7 14 0 1939583424 6962176 1828448
21:51:17 22369 8192000000 10875382864 11313668096 1917859344 18.970 99 48 95 1 1941957440 10530160 13567936
21:51:46 38441 8192000000 10840321568 11316146176 1914254720 18.941 99 18 36 1 1927466992 8301440 4910832
21:52:35 57206 8192000000 10865133088 11329024000 1900589664 18.831 98 17 34 1 1915763680 10498416 4675600
21:53:39 31751 8192000000 10869308656 11340083200 1929442624 19.062 99 22 42 2 1945501712 10537024 5522064
21:54:23 74080 8192000000 10869121808 11325726720 1847975856 18.406 95 14 29 3 1863834304 12241280 3617168
21:55:43 42093 8192000000 10871334288 11336159232 1928420784 19.054 99 31 62 3 1953286272 15422784 9442704
21:56:39 63270 8192000000 10892542416 11354832896 1949515712 19.223 100 20 40 0 1969680208 14522240 5642256
21:57:54 57258 8192000000 10894618768 11363868672 1932728192 19.089 98 17 34 3 1953401120 15764512 4908416
21:58:57 75027 8192000000 10891812160 11367305216 1946054032 19.195 99 15 30 1 1973131440 22825120 4252288
22:00:20 52704 8192000000 10891982144 11355398144 1948455776 19.214 99 24 48 2 1965373056 10078736 6838544
22:01:20 23788 8192000000 10920864400 11359096832 1945602944 19.191 99 42 83 2 1964844848 7573232 11668672
22:01:51 49746 8192000000 10901424192 11361611776 1929039616 19.059 98 27 54 0 1945550384 9284672 7226096
22:02:49 17356 8192000000 10908001296 11354574848 1929608624 19.064 98 31 62 1 1947088320 9063360 8416336
22:03:16 35477 8192000000 10892733504 11364405248 1960413184 19.309 100 25 50 3 1976042592 9068304 6561104
22:03:58 42979 8192000000 10926820512 11371544576 1951179792 19.236 99 28 57 1 1969523408 10721616 7622000
22:04:50 103073 8192000000 10882669728 11362807808 1911252768 18.917 97 17 34 3 1937298384 21207744 4837872
22:06:39 86370 8192000000 10847729920 11291058176 1893680288 18.775 97 24 47 1 1909271456 8938784 6652384
22:08:12 40823 8192000000 10862477200 11340492800 1949336288 19.221 100 27 54 0 1965291968 8381424 7574256
22:09:01 46857 8192000000 10862564912 11339653120 1924403248 19.022 99 12 24 0 1935295200 7774608 3117344
22:09:54 50023 8192000000 10837535792 11315900416 1903792544 18.857 98 5 10 0 1916282256 11032880 1456832
22:10:51 42373 8192000000 10853822784 11332833280 1919825952 18.985 99 11 22 0 1936784880 13744064 3214864
22:11:45 60924 8192000000 10858251344 11343208448 1898743760 18.816 98 9 18 1 1914605664 13471824 2390080
22:13:01 52417 8192000000 10881371280 11358879744 1942327536 19.165 100 10 20 0 1961916864 16558384 3030944
22:14:04 36983 8192000000 10883217408 11346034688 1921312944 18.997 98 20 40 1 1936774816 9602896 5858976
22:14:50 26502 8192000000 10889624864 11353485312 1958482096 19.294 100 24 48 1 1972775728 7802688 6490944
22:15:31 55297 8192000000 10900152656 11372331008 1943961712 19.178 99 14 28 0 1962403056 14244736 4196608
22:16:32 55546 8192000000 10879508416 11347914752 1884915664 18.705 96 19 38 0 1905573392 14871024 5786704
22:17:34 69155 8192000000 10871090464 11342712832 1874210096 18.618 96 18 36 2 1905550880 25706000 5634784
22:19:28 48342 8192000000 10903165712 11341905920 1921287536 18.997 99 26 49 0 1941450720 13563392 6599792
22:20:25 51300 8192000000 10897426688 11348201472 1934249872 19.101 99 37 74 2 1958460288 14057664 10152752
22:21:25 59018 8192000000 10890791904 11362390016 1947413040 19.206 100 7 14 0 1965627392 15702256 2512096
22:22:39 55792 8192000000 10874948896 11349061632 1878988832 18.657 96 13 26 1 1898092064 15143856 3959376
22:23:52 104260 8192000000 10876103536 11349417984 1877063216 18.641 96 16 32 0 1898137712 16954192 4120304
22:25:54 76510 8192000000 9527188400 9845313536 676887760 7.632 35 7 14 0 684520688 6024224 1608704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-11-2020 22:29:32 to 08-11-2020 22:30:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 144 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-11-2020 22:30:03 to 08-11-2020 22:30:05.

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          249407
MON$OLDEST_ACTIVE               249408
MON$OLDEST_SNAPSHOT             249408
MON$NEXT_TRANSACTION            249408
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                       2020672
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:120: 
:121: mscs-test-161.budzdorov.ru    Sun Nov  8 22:27:26 2020
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
:124: 
:125: mscs-test-161.budzdorov.ru    Sun Nov  8 22:27:26 2020
:126:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:127: 
:128: 
:129: mscs-test-161.budzdorov.ru    Sun Nov  8 22:27:26 2020
:130:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:131: 
--- end of diff output ---

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

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