Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.03.2021 22:29
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 df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17398756 kB
MemAvailable 31582160 kB
Buffers 0 kB
Cached 14309084 kB
SwapCached 0 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-03-19 22:27:22
DTS_END                         2021-03-19 22:27:22.9870
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/43142
TRN_ID                          242762
ATT_ID                          688
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: 9306.65 17587 1116798
customer order: creation 175.73 358 21088
customer order: refuse 15.28 401 1834
order to supplier: creation 46.60 1327 5592
order to supplier: removal 3.46 105993 415
invoice (draft): creation 46.98 3402 5638
invoice (draft): removal 53.31 782 6397
invoice accept: apply 42.29 19440 5075
invoice accept: cancel 48.24 818 5789
customer reserve: creation 3884.88 193 466186
customer reserve: removal 4683.98 61 562078
realization accept: apply 83.78 201 10054
realization accept: cancel 89.12 123 10694
payment from customer: creation 60.36 125 7243
payment from customer: removal 5.89 95 707
payment to supplier: creation 50.01 153 6001
payment to supplier: removal 3.79 101 455
service: total inventory turnovers 4.87 1204 584
service: total monetary turnovers 7.01 34 841
service: aggregate perf. data 1.03 14942 123
service: refresh index statistics 0.03 201986 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-03-2021 22:29:49 to 19-03-2021 22:29:51.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3028
TEST_TIME 2 4134
TEST_TIME 3 3687
TEST_TIME 4 4594
TEST_TIME 5 4517
TEST_TIME 6 4739
TEST_TIME 7 4581
TEST_TIME 8 4916
TEST_TIME 9 5092
TEST_TIME 10 5529
TEST_TIME 11 5643
TEST_TIME 12 5916
TEST_TIME 13 6141
TEST_TIME 14 6613
TEST_TIME 15 7135
TEST_TIME 16 7264
TEST_TIME 17 7687
TEST_TIME 18 7759
TEST_TIME 19 7880
TEST_TIME 20 8259
TEST_TIME 21 8461
TEST_TIME 22 8576
TEST_TIME 23 8855
TEST_TIME 24 8904
TEST_TIME 25 9142
TEST_TIME 26 9474
TEST_TIME 27 9908
TEST_TIME 28 10643
TEST_TIME 29 10488
TEST_TIME 30 10436
TEST_TIME 31 10200
TEST_TIME 32 10076
TEST_TIME 33 10175
TEST_TIME 34 10296
TEST_TIME 35 10263
TEST_TIME 36 10265
TEST_TIME 37 10217
TEST_TIME 38 10158
TEST_TIME 39 10074
TEST_TIME 40 9992
TEST_TIME 41 9906
TEST_TIME 42 9925
TEST_TIME 43 9842
TEST_TIME 44 9718
TEST_TIME 45 9692
TEST_TIME 46 9620
TEST_TIME 47 9598
TEST_TIME 48 9577
TEST_TIME 49 9735
TEST_TIME 50 9756
TEST_TIME 51 9637
TEST_TIME 52 9642
TEST_TIME 53 9688
TEST_TIME 54 9623
TEST_TIME 55 9660
TEST_TIME 56 9630
TEST_TIME 57 9767
TEST_TIME 58 9839
TEST_TIME 59 9753
TEST_TIME 60 10005
TEST_TIME 61 9955
TEST_TIME 62 9920
TEST_TIME 63 10029
TEST_TIME 64 10018
TEST_TIME 65 10037
TEST_TIME 66 9991
TEST_TIME 67 10018
TEST_TIME 68 9891
TEST_TIME 69 9879
TEST_TIME 70 9782
TEST_TIME 71 9746
TEST_TIME 72 9728
TEST_TIME 73 9666
TEST_TIME 74 9707
TEST_TIME 75 9676
TEST_TIME 76 9614
TEST_TIME 77 9555
TEST_TIME 78 9481
TEST_TIME 79 9579
TEST_TIME 80 9607
TEST_TIME 81 9642
TEST_TIME 82 9606
TEST_TIME 83 9627
TEST_TIME 84 9592
TEST_TIME 85 9536
TEST_TIME 86 9628
TEST_TIME 87 9618
TEST_TIME 88 9636
TEST_TIME 89 9639
TEST_TIME 90 9678
TEST_TIME 91 9668
TEST_TIME 92 9747
TEST_TIME 93 9657
TEST_TIME 94 9608
TEST_TIME 95 9543
TEST_TIME 96 9547
TEST_TIME 97 9521
TEST_TIME 98 9461
TEST_TIME 99 9439
TEST_TIME 100 9413
TEST_TIME 101 9417
TEST_TIME 102 9379
TEST_TIME 103 9351
TEST_TIME 104 9395
TEST_TIME 105 9379
TEST_TIME 106 9357
TEST_TIME 107 9407
TEST_TIME 108 9418
TEST_TIME 109 9406
TEST_TIME 110 9390
TEST_TIME 111 9420
TEST_TIME 112 9422
TEST_TIME 113 9434
TEST_TIME 114 9426
TEST_TIME 115 9480
TEST_TIME 116 9487
TEST_TIME 117 9436
TEST_TIME 118 9372
TEST_TIME 119 9359
TEST_TIME 120 9309

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-03-2021 22:29:52 to 19-03-2021 22:29:56.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1550225 1550225 0 0.00 0 30080 7 0 0
doc_list_biud 1550221 1550221 0 0.00 0 45843 28 0 0
sp_add_invoice_to_stock 5196 5075 121 2.32 37 179515 19440 0 121
sp_cancel_adding_invoice 5789 5789 0 0.00 6 91323 818 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 16796 401 0 0
sp_cancel_customer_reserve 562078 562078 0 0.00 1 45848 62 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 3 3996 96 0 0
sp_cancel_pay_to_supplier 455 455 0 0.00 3 9213 102 0 0
sp_cancel_supplier_invoice 6407 6397 10 0.15 2 17514 783 0 10
sp_cancel_supplier_order 415 415 0 0.00 5 936674 105993 0 0
sp_cancel_write_off 10694 10694 0 0.00 1 11127 124 0 0
sp_client_order 21088 21088 0 0.00 3 38779 359 0 0
sp_customer_reserve 466186 466186 0 0.00 0 101996 194 0 0
sp_fill_shopping_cart 32300 32300 0 0.00 1 13918 38 0 0
sp_fill_shopping_cart_clo_res 466179 466179 0 0.00 0 18430 14 0 0
sp_get_clo_for_invoice 5068 5068 0 0.00 0 34122 293 0 0
sp_kill_cost_storno 17645 17645 0 0.00 0 11746 60 0 0
sp_kill_qstorno_ret_qs2qd 1141662 1141662 0 0.00 0 45833 33 0 0
sp_kill_qty_storno 602326 602326 0 0.00 0 45842 72 0 0
sp_lock_selected_doc 21105 21105 0 0.00 0 7816 7 0 0
sp_make_cost_storno 28364 28364 0 0.00 0 17736 62 0 0
sp_multiply_rows_for_pdistr 28363 28363 0 0.00 0 10469 31 0 0
sp_multiply_rows_for_qdistr 21087 21087 0 0.00 0 20919 152 0 0
sp_pay_from_customer 7243 7243 0 0.00 4 17825 126 0 0
sp_pay_to_supplier 6001 6001 0 0.00 5 17275 153 0 0
sp_payment_common 13243 13243 0 0.00 2 16603 44 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 16786 369 0 0
sp_qd_handle_on_invoice_upd_sts 10854 10854 0 0.00 0 25948 343 0 0
sp_qd_handle_on_reserve_upd_sts 10054 10054 0 0.00 0 19051 70 0 0
sp_reserve_write_off 10054 10054 0 0.00 6 19075 202 0 0
sp_supplier_invoice 5638 5638 0 0.00 7 95045 3402 0 0
sp_supplier_order 5592 5592 0 0.00 6 70607 1327 0 0
srv_aggregate_perf_data 123 123 0 0.00 2482 173713 14942 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 697 133986 30518 0 0
srv_find_qd_qs_mism 1069082 1069082 0 0.00 0 30078 6 0 0
srv_make_invnt_saldo 584 584 0 0.00 34 94005 1205 0 0
srv_make_money_saldo 841 841 0 0.00 0 9636 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 101565 344031 201987 0 0
t$perf-abend:sp_add_invoice_to_stock 121 121 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5075 5075 0 0.00 0 13595 189 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 6015 108 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 2619 16 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 1275 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 3909 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 455 455 0 0.00 0 2561 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 1305 22 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 27698 1743 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 7340 24 0 0
t$perf-norm:sp_client_order 21088 21088 0 0.00 0 6724 21 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 950 6 0 0
t$perf-norm:sp_pay_from_customer 7243 7243 0 0.00 0 7401 10 0 0
t$perf-norm:sp_pay_to_supplier 6001 6001 0 0.00 0 5719 11 0 0
t$perf-norm:sp_reserve_write_off 10054 10054 0 0.00 0 6408 12 0 0
t$perf-norm:sp_supplier_invoice 5638 5638 0 0.00 0 18660 24 0 0
t$perf-norm:sp_supplier_order 5592 5592 0 0.00 0 8214 20 0 0
t$perf-norm:srv_aggregate_perf_data 123 123 0 0.00 0 459 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 332 4 0 0
t$perf-norm:srv_make_invnt_saldo 584 584 0 0.00 0 1345 23 0 0
t$perf-norm:srv_make_money_saldo 841 841 0 0.00 0 2715 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 89 25 0 0
v_add_invoice_to_stock 10364 10122 242 2.33 0 5333 19 0 242
v_all_customers 38702 38702 0 0.00 0 19 1 0 0
v_all_suppliers 31428 31428 0 0.00 0 36 1 0 0
v_all_wares 42170 42170 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 188 6 0 0
v_cancel_client_order 3668 3668 0 0.00 0 5960 10 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 3972 14 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 4601 12 0 0
v_cancel_payment_to_supplier 910 910 0 0.00 0 6270 15 0 0
v_cancel_supplier_invoice 848 828 20 2.35 0 2655 18 0 20
v_cancel_supplier_order 830 830 0 0.00 0 1985 7 0 0
v_cancel_write_off 2034 2034 0 0.00 0 7718 25 0 0
v_max_id_clo_ord 5592 5592 0 0.00 0 3428 2 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 3563 21 0 0
v_max_id_ord_sup 5622 5622 0 0.00 0 5327 5 0 0
v_max_non_paid_invoice 1500 1500 0 0.00 0 192 2 0 0
v_max_non_paid_realizn 3673 3673 0 0.00 0 3705 5 0 0
v_min_id_clo_ord 5592 5592 0 0.00 0 1996 5 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 9740 13 0 0
v_min_id_ord_sup 5622 5622 0 0.00 0 9818 14 0 0
v_min_non_paid_invoice 6000 6000 0 0.00 0 13577 33 0 0
v_min_non_paid_realizn 7243 7243 0 0.00 0 10177 31 0 0
v_our_firm 10608 10608 0 0.00 0 22 1 0 0
v_reserve_write_off 20108 20108 0 0.00 0 5336 7 0 0
x_lock_depdocs_on_canc_invoice 11772 11772 0 0.00 0 13402 119 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 6217 352 0 0
x_make_qstorno_1000_1200 5592 5592 0 0.00 1 70365 1244 0 0
x_make_qstorno_1200_2000 5638 5638 0 0.00 3 95035 3268 0 0
x_make_qstorno_2100_3300 466186 466186 0 0.00 0 101995 177 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:26 6 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 19416 8192000000 10219069952 10519126016 724194448 8.122 58 45 92 0 742457728 2124208 16139072
19:58:00 18610 8192000000 10298120720 10610724864 1358927600 14.228 100 85 170 0 1392150896 4248752 28974544
19:58:30 27480 8192000000 10349541024 10670333952 1402487200 14.617 100 85 170 1 1435968960 5708512 27773248
19:59:05 25323 8192000000 10382876496 10705408000 1431590384 14.875 100 85 170 0 1466060064 6552128 27917552
19:59:41 20627 8192000000 10425498016 10751033344 1479989632 15.301 100 93 186 0 1521365616 11409488 29966496
20:00:12 22448 8192000000 10444803136 10777829376 1489218976 15.382 100 90 180 1 1526214128 8097328 28897824
20:00:44 21249 8192000000 10466330688 10802667520 1514981936 15.607 100 82 164 0 1549537168 8706416 25848816
20:01:12 12857 8192000000 10480338864 10819227648 1533267360 15.765 100 87 175 1 1569501808 8961904 27272544
20:01:32 15809 8192000000 10495085616 10839105536 1549679312 15.907 100 84 168 0 1585141104 9290896 26170896
20:01:56 13427 8192000000 10514561552 10864123904 1574585568 16.122 100 82 162 2 1609136784 9713248 24837968
20:02:19 16966 8192000000 10538416464 10891034624 1595190496 16.298 100 81 162 1 1631002128 10610096 25201536
20:02:47 12353 8192000000 10549538848 10907938816 1610693744 16.431 100 81 162 0 1646098848 11020096 24385008
20:03:12 13184 8192000000 10576780720 10936528896 1637626176 16.660 100 85 171 1 1675073216 11548192 25898848
20:03:33 10685 8192000000 10575390736 10939559936 1649018256 16.756 100 76 152 0 1683034208 11237584 22778368
20:03:52 10425 8192000000 10609439408 10976075776 1665196560 16.893 100 78 157 2 1699666720 11473472 22996688
20:04:10 11680 8192000000 10649707792 11018711040 1699578352 17.182 100 76 152 1 1732927536 11258928 22090256
20:04:31 7567 8192000000 10669098736 11044024320 1729216112 17.429 100 77 155 1 1763747536 12049584 22481840
20:04:46 6685 8192000000 10682582032 11055136768 1737804368 17.500 100 72 142 0 1770167088 12099760 20262960
20:05:01 4905 8192000000 10698216144 11069669376 1754802416 17.641 100 77 154 1 1790220608 13223136 22195056
20:05:13 6679 8192000000 10705207920 11086381056 1770453568 17.771 100 78 154 2 1804747424 12560784 21733072
20:05:28 3882 8192000000 10711567776 11097251840 1779468064 17.845 100 77 154 2 1814232560 13093136 21671360
20:05:39 4924 8192000000 10734129968 11114815488 1794567648 17.969 100 86 170 3 1832390016 13326416 24495952
20:05:51 5284 8192000000 10737653040 11117772800 1800318224 18.017 100 86 168 2 1837179280 13378944 23482112
20:06:03 4913 8192000000 10741004640 11124166656 1805217664 18.057 100 84 167 1 1842448592 13617472 23613456
20:06:14 4233 8192000000 10746273472 11128856576 1806259808 18.065 100 87 174 1 1844248528 13492496 24496224
20:06:26 2945 8192000000 10757702768 11140440064 1815341088 18.140 100 89 176 3 1852952848 11881888 25729872
20:06:36 3200 8192000000 10758562272 11146612736 1823863808 18.209 100 85 168 3 1858572720 11256640 23452272
20:06:46 3107 8192000000 10770486720 11153563648 1828627232 18.248 100 94 185 1 1868082768 12710224 26745312
20:06:55 9915 8192000000 10764855312 11153756160 1832057504 18.276 100 88 176 1 1869542352 13627856 23856992
20:07:12 6102 8192000000 10773077568 11159658496 1833835792 18.291 100 88 175 1 1871861872 14256384 23769696
20:07:25 2456 8192000000 10782734352 11168092160 1840329936 18.343 100 86 170 1 1877992864 14654784 23008144
20:07:34 2226 8192000000 10789691152 11178819584 1850469568 18.426 100 89 179 1 1889019392 14115056 24434768
20:07:42 2947 8192000000 10793578960 11182510080 1851631440 18.435 100 90 181 2 1891951616 14661616 25658560
20:07:51 2457 8192000000 10792478704 11185524736 1854187632 18.456 100 94 186 1 1893808304 12830544 26790128
20:08:01 3544 8192000000 10810574560 11197214720 1862361888 18.522 100 87 174 0 1898026464 11514176 24150400
20:08:11 2960 8192000000 10809443712 11197579264 1864997168 18.544 100 97 195 1 1906012720 12816928 28198624
20:08:20 1718 8192000000 10806215584 11193483264 1863946544 18.535 100 91 180 1 1901570992 12975568 24648880
20:08:28 1869 8192000000 10803295056 11192049664 1865144272 18.545 100 94 187 1 1905309536 13174960 26990304
20:08:37 2382 8192000000 10810505984 11199168512 1865241616 18.546 100 89 176 0 1902628000 12761408 24624976
20:08:46 1616 8192000000 10803906720 11196338176 1867899984 18.567 100 91 183 1 1905480896 11487408 26093504
20:08:54 2254 8192000000 10816314496 11202846720 1868978400 18.576 100 84 168 0 1906684080 12698800 25006880
20:09:02 4649 8192000000 10811708256 11206537216 1874949952 18.624 100 82 163 0 1909740992 12329760 22461280
20:09:14 8583 8192000000 10821053696 11208470528 1874195440 18.618 100 88 178 3 1911301584 12411776 24694368
20:09:29 2755 8192000000 10810426112 11208781824 1872197024 18.602 100 77 154 0 1906788864 12480864 22110976
20:09:53 11379 8192000000 10772136432 11202445312 1870159600 18.586 100 40 80 1 1890055184 8331888 11563696
20:10:11 6908 8192000000 10808804448 11213352960 1873737520 18.615 100 50 98 0 1895782208 7795184 14249504
20:10:25 5464 8192000000 10783228128 11204456448 1871598000 18.597 100 28 56 0 1887642400 7925088 8119312
20:10:37 6304 8192000000 10782550768 11207118848 1877373936 18.644 100 29 59 2 1891557840 5361136 8822768
20:10:49 13681 8192000000 10784399744 11210981376 1874849232 18.623 100 22 44 1 1887298624 6213168 6236224
20:11:09 7692 8192000000 10799585168 11220361216 1878302224 18.651 100 31 62 1 1898389744 11544096 8543424
20:11:26 6261 8192000000 10792016672 11220099072 1883178464 18.691 100 32 65 1 1899746720 7836720 8731536
20:11:40 5872 8192000000 10787101072 11216162816 1881737312 18.679 100 23 47 2 1893880832 5552432 6591088
20:11:55 8837 8192000000 10798143264 11224371200 1884979552 18.705 100 24 48 2 1898615408 6329840 7306016
20:12:09 17937 8192000000 10792777104 11224338432 1885239040 18.707 100 18 35 2 1896488208 5863712 5385456
20:12:34 6367 8192000000 10790421504 11227987968 1888973648 18.738 100 15 30 2 1899205792 6215632 4016512
20:12:47 8424 8192000000 10792929392 11227791360 1890421584 18.749 100 22 43 2 1906949072 10404064 6123424
20:13:01 8155 8192000000 10799440992 11233955840 1895810848 18.793 100 32 64 1 1912957120 7910976 9235296
20:13:19 9707 8192000000 10798287392 11235225600 1891931424 18.761 100 20 39 3 1904065248 6282240 5851584
20:13:37 7450 8192000000 10795460976 11233431552 1892827840 18.769 100 18 36 0 1904076416 6034880 5213696
20:13:56 36340 8192000000 10806184848 11241836544 1899313840 18.821 100 27 54 0 1913020496 5639872 8066784
20:14:50 31004 8192000000 10846088016 11254464512 1907085120 18.883 100 67 134 1 1933043984 5397712 20561152
20:15:27 3280 8192000000 10828496976 11253407744 1900909024 18.834 100 55 108 2 1927013344 10139632 15964688
20:15:37 5059 8192000000 10824245248 11252854784 1902043664 18.843 100 38 75 0 1920067968 7775648 10248656
20:15:49 4229 8192000000 10825407312 11251449856 1900111744 18.827 100 41 82 3 1919617024 8409696 11095584
20:16:00 4616 8192000000 10828645936 11255160832 1900354272 18.829 100 33 66 0 1917098416 7695488 9048656
20:16:10 5445 8192000000 10801480800 11236851712 1891151888 18.755 100 37 74 1 1909577296 6885024 11540384
20:16:25 4649 8192000000 10816820336 11241492480 1890754560 18.752 100 34 68 0 1911112720 10597088 9761072
20:16:36 5500 8192000000 10791909168 11220434944 1875954000 18.632 99 27 54 2 1890562848 7059488 7549360
20:16:48 7855 8192000000 10780617968 11212259328 1850721072 18.428 98 43 86 0 1870591488 7495152 12375264
20:17:02 41207 8192000000 10778753104 11215327232 1843184064 18.367 98 19 38 0 1854485664 6215856 5085744
20:17:50 9080 8192000000 10769914560 11194351616 1789373200 17.927 96 17 34 1 1800386128 5883872 5129056
20:18:07 5533 8192000000 10772906512 11198730240 1854708128 18.460 100 29 58 0 1869144144 6485600 7950416
20:18:19 12377 8192000000 10744085216 11155922944 1742392144 17.538 94 24 48 0 1755105088 6113680 6599264
20:18:38 4344 8192000000 10735584272 11158036480 1819145472 18.171 100 29 59 2 1833980048 7290992 7543584
20:18:50 6203 8192000000 10732538512 11143262208 1775908544 17.816 98 27 54 1 1789894608 5418016 8568048
20:19:03 6266 8192000000 10709722000 11115925504 1756569760 17.656 97 29 57 2 1770301552 4878944 8852848
20:19:16 10336 8192000000 10696559200 11114455040 1759555184 17.681 98 25 50 1 1772839920 5187120 8097616
20:19:34 6154 8192000000 10700180192 11120611328 1748440320 17.589 97 25 48 2 1761842320 6599856 6802144
20:19:48 7993 8192000000 10698576176 11115253760 1744147520 17.553 97 21 43 0 1756231808 5317408 6766880
20:20:04 5539 8192000000 10690764416 11099574272 1752395504 17.621 98 30 59 3 1767575152 6597488 8582160
20:20:16 10200 8192000000 10693225568 11109638144 1749068912 17.594 98 23 46 0 1761740224 5652128 7019184
20:20:32 55827 8192000000 10727804400 11113713664 1720591312 17.357 96 56 112 1 1742916688 5029328 17296048
20:21:34 8802 8192000000 10683933552 11109728256 1759389216 17.679 98 25 47 3 1773597056 7232576 6975264
20:21:52 9461 8192000000 10744240736 11160530944 1803981056 18.047 99 34 68 1 1820951120 6712400 10257664
20:22:10 4286 8192000000 10744950768 11165929472 1827425744 18.238 100 31 62 2 1842900608 6637392 8837472
20:22:23 8226 8192000000 10743521392 11163209728 1762703760 17.707 96 38 76 0 1784146144 10625120 10817264
20:22:39 6650 8192000000 10751170224 11174985728 1834606080 18.297 100 31 62 1 1853597008 10579472 8411456
20:22:52 8367 8192000000 10726853472 11159134208 1804757504 18.053 99 22 42 1 1817749552 6464240 6527808
20:23:07 6485 8192000000 10732054032 11162292224 1813081664 18.121 99 23 45 2 1826093872 6831136 6181072
20:23:21 9628 8192000000 10740689776 11168911360 1816420592 18.148 99 20 40 1 1828177504 5167856 6589056
20:23:40 8725 8192000000 10766131008 11188076544 1847258208 18.400 100 17 34 0 1857914544 5401584 5254752
20:23:57 6548 8192000000 10777493680 11196178432 1853834336 18.453 100 22 44 2 1865785744 5100144 6851264
20:24:12 8208 8192000000 10757321488 11187781632 1849096480 18.415 100 11 22 1 1857574960 5123216 3355264
20:24:29 9176 8192000000 10770536928 11195322368 1855260240 18.465 100 34 68 1 1870440016 5187024 9992752
20:24:46 78727 8192000000 10776217264 11203174400 1865601952 18.549 100 39 77 2 1883623056 5447504 12573600
20:26:11 18362 8192000000 10782326480 11210956800 1864678096 18.541 100 28 56 0 1879104368 6630160 7796112
20:26:36 8272 8192000000 10786054640 11210616832 1867145232 18.561 100 29 58 0 1880910048 5816080 7948736
20:26:55 5876 8192000000 10799842432 11220021248 1877181072 18.642 100 43 85 3 1893760624 5330800 11248752
20:27:08 6412 8192000000 10795813600 11229499392 1886363824 18.716 100 33 66 2 1902616656 6877712 9375120
20:27:21 13921 8192000000 10821391776 11242213376 1898545136 18.815 100 43 86 2 1916991232 5288224 13157872
20:27:51 19473 8192000000 10843536048 11257884672 1909678592 18.904 100 50 98 1 1931182800 7582688 13921520
20:28:20 26539 8192000000 10858884816 11278725120 1918723440 18.977 100 54 108 0 1942802816 8671872 15407504
20:28:56 15909 8192000000 10857521120 11281793024 1925358352 19.030 100 47 93 4 1948386672 10062272 12966048
20:29:21 12903 8192000000 10862265296 11289903104 1930360224 19.070 100 53 106 0 1955597104 9607632 15629248
20:29:44 25412 8192000000 10870857600 11298418688 1937805904 19.129 100 48 96 1 1964024560 11672496 14546160
20:30:18 27267 8192000000 10888527472 11316744192 1944530016 19.183 100 50 100 0 1974198288 15415680 14252592
20:30:59 12652 8192000000 10899945472 11325460480 1954923968 19.266 100 51 102 0 1990031136 20277328 14829840
20:31:38 25694 8192000000 10904749104 11337490432 1964465472 19.342 100 44 88 1 1998167152 20383968 13317712
20:32:26 43916 8192000000 10899337616 11339333632 1963359408 19.333 100 33 66 1 1995058272 21702064 9996800
20:33:16 18106 8192000000 10915302240 11347771392 1966645536 19.359 100 33 66 1 1999473984 23152848 9675600
20:33:41 22995 8192000000 10915438288 11355205632 1970171648 19.387 100 28 54 2 2000393440 22202112 8019680
20:34:22 48091 8192000000 10923153728 11358490624 1977204432 19.443 100 35 70 0 2012116768 24112912 10799424
20:35:17 5959 8192000000 10924769600 11363700736 1984709696 19.502 100 44 88 2 2023065872 24453392 13902784
20:35:34 5721 8192000000 10949715920 11371835392 1990785264 19.550 100 70 140 0 2035620032 24096848 20737920
20:35:48 1638 8192000000 10958574480 11369402368 1976528304 19.437 99 83 166 0 2026410544 25121296 24760944
20:35:57 7629 8192000000 10935388800 11362004992 1983343264 19.491 100 73 146 0 2031869312 25995936 22530112
20:36:14 1932 8192000000 10946992000 11369566208 1988987072 19.536 100 74 148 1 2036651600 26013376 21651152
20:36:41 8486 8192000000 10958723696 11385188352 1995945744 19.591 100 63 124 2 2046925488 32468448 18511296
20:36:57 8274 8192000000 10960504576 11388624896 2000438160 19.626 100 66 130 1 2047088784 27290400 19360224
20:37:12 3250 8192000000 10966414000 11390210048 2003070128 19.647 100 73 144 0 2051219392 26764048 21385216
20:37:22 4347 8192000000 10963241152 11391049728 2002946672 19.646 100 63 123 0 2048570224 26711824 18911728
20:37:36 2260 8192000000 10964759424 11383975936 1988370768 19.531 99 72 142 1 2036498304 26840032 21287504
20:37:45 1365 8192000000 10971400064 11384172544 1999818800 19.621 100 91 177 4 2052755408 26693696 26242912
20:37:54 3328 8192000000 10972816240 11393581056 2007978032 19.686 100 84 166 1 2061715792 28068832 25668928
20:38:07 3121 8192000000 10962428864 11380363264 1992985424 19.567 100 72 143 1 2043838800 28947072 21906304
20:38:18 4207 8192000000 10956261472 11378008064 1976433136 19.436 99 71 141 0 2026538768 28634256 21471376
20:38:35 3047 8192000000 10936862176 11367591936 1981514672 19.477 100 69 137 1 2030608464 28932304 20161488
20:38:45 7090 8192000000 10950421040 11376336896 1983514736 19.493 100 69 138 0 2040943328 35917632 21510960
20:38:59 9701 8192000000 10955088240 11392688128 1992813408 19.566 100 55 110 0 2044156064 33271392 18071264
20:39:20 12799 8192000000 10967994128 11404050432 2003031520 19.647 100 62 124 0 2059878096 36129248 20717328
20:39:40 2079 8192000000 10958454464 11371450368 1978851072 19.456 99 81 158 0 2041731408 37038704 25841632
20:39:49 2164 8192000000 10980941616 11403558912 2000097984 19.624 100 81 163 1 2065540992 40392736 25050272
20:39:58 1928 8192000000 10959525072 11376820224 1977337840 19.444 99 85 168 2 2044595680 40991616 26266224
20:40:07 2535 8192000000 10978135808 11399213056 1994696752 19.581 100 85 169 1 2063148816 42086496 26365568
20:40:19 4363 8192000000 10979962912 11400433664 2000163760 19.624 100 76 152 2 2067883312 43972432 23747120
20:40:31 10009 8192000000 10971451056 11395223552 1990667824 19.549 100 65 126 1 2054233728 43155952 20409952
20:40:58 4578 8192000000 10980625072 11400503296 1977737840 19.447 99 74 148 1 2047522320 46132960 23651520
20:41:09 4408 8192000000 10967650592 11388489728 1979917072 19.464 100 73 145 1 2050978944 47543536 23518336
20:41:21 2080 8192000000 10961744144 11377135616 1959689072 19.304 99 79 158 2 2033709648 49029776 24990800
20:41:31 8218 8192000000 10968059936 11387654144 1979142976 19.458 100 81 161 0 2052756944 47309856 26304112
20:41:46 3454 8192000000 10966651552 11395424256 1981839888 19.479 100 69 138 2 2051743056 47245008 22658160
20:41:56 3041 8192000000 10972123088 11396911104 1970944240 19.393 99 75 147 0 2041239104 47308480 22986384
20:42:07 4231 8192000000 10968964800 11389353984 1987933296 19.527 100 77 154 0 2048438880 37220432 23285152
20:42:19 5694 8192000000 10964561680 11388239872 1986689280 19.518 100 67 131 0 2045130368 37234944 21206144
20:42:32 4185 8192000000 10958408592 11382796288 1983804928 19.495 100 74 146 0 2044436112 37917536 22713648
20:42:44 3528 8192000000 10931168464 11341541376 1930820640 19.073 97 80 158 2 1991745520 35870832 25054048
20:43:00 12500 8192000000 10934613968 11359203328 1947501296 19.207 99 60 120 3 2003648704 37221024 18926384
20:43:24 7911 8192000000 10916024912 11344846848 1931768832 19.081 99 58 116 0 1986416176 35642352 19004992
20:43:39 3420 8192000000 10928716896 11349897216 1946866448 19.202 99 72 139 2 2003760768 35263968 21630352
20:43:48 4352 8192000000 10925034192 11339886592 1913095856 18.931 97 80 159 2 1974115728 35881632 25138240
20:44:00 4172 8192000000 10930015824 11347222528 1948040016 19.211 100 79 155 4 2015740976 42508416 25192544
20:44:13 1822 8192000000 10940960000 11354423296 1962295984 19.324 100 89 178 2 2023505488 34044960 27164544
20:44:22 1431 8192000000 10959216144 11370004480 1976513712 19.437 100 94 188 1 2041391200 35068336 29809152
20:44:35 1976 8192000000 10954300912 11375144960 1980923568 19.472 100 85 169 0 2042751184 35597392 26230224
20:44:47 3478 8192000000 10901749072 11313500160 1908822112 18.897 97 82 161 1 1968114896 33614256 25678528
20:44:58 5858 8192000000 10931697520 11349757952 1959354800 19.301 100 73 146 0 2016424656 34097920 22971936
20:45:12 2068 8192000000 10938626080 11353022464 1964350048 19.341 100 87 174 1 2024369968 32953568 27066352
20:45:21 3470 8192000000 10942737952 11353591808 1962097008 19.323 100 82 162 2 2022505104 34802544 25605552
20:45:34 2436 8192000000 10943205952 11356057600 1966259120 19.356 100 89 178 1 2028927840 34994576 27674144
20:45:44 4212 8192000000 10936724784 11352371200 1960211904 19.308 100 77 150 2 2017414576 33795520 23407152
20:46:02 2942 8192000000 10924544656 11338903552 1937699712 19.128 99 78 156 1 1997190848 34829152 24661984
20:46:13 3307 8192000000 10942821888 11349983232 1959996800 19.306 100 88 175 0 2022907712 34482816 28428096
20:46:23 2732 8192000000 10919765312 11333734400 1942305792 19.165 100 90 180 0 2007961248 37292896 28362560
20:46:34 2907 8192000000 10940436432 11350163456 1953191440 19.252 100 84 168 0 2020874608 41110528 26572640
20:46:43 3312 8192000000 10948632080 11364409344 1962746464 19.328 100 81 161 1 2029206032 40913344 25546224
20:46:57 9905 8192000000 10932838816 11362750464 1959714720 19.304 100 60 119 1 2020969904 42215232 19039952
20:47:32 8641 8192000000 10933666544 11357396992 1944770976 19.185 99 66 132 1 2004882528 38496256 21615296
20:47:50 4318 8192000000 10937788064 11362484224 1961127184 19.315 100 58 112 2 2019329680 39296240 18906256
20:48:05 8727 8192000000 10925585536 11351957504 1949398544 19.222 100 55 107 1 2005436880 38539856 17498480
20:48:23 12848 8192000000 10916530720 11353919488 1950678560 19.232 100 35 70 2 1998854240 35796336 12379344
20:48:43 10599 8192000000 10908557008 11346931712 1935129792 19.108 99 31 62 0 1980654512 35050608 10474112
20:49:09 5639 8192000000 10921876064 11346931712 1947024832 19.203 100 50 100 1 2001401952 38139680 16237440
20:49:22 5311 8192000000 10921905408 11352096768 1951333392 19.237 100 45 90 0 2002976496 36657712 14985392
20:49:38 5255 8192000000 10938924176 11367825408 1962229952 19.324 100 55 110 0 2020546064 40188128 18127984
20:49:50 5334 8192000000 10920930752 11350753280 1946546000 19.199 100 47 94 4 2002391824 40667856 15177968
20:50:02 10923 8192000000 10919016064 11357556736 1949884064 19.226 100 36 70 0 2003081376 41032240 12165072
20:50:25 21430 8192000000 10885566480 11330056192 1893089616 18.771 97 29 58 0 1942052608 39034576 9928416
20:51:00 12215 8192000000 10907078832 11355623424 1938659264 19.136 100 25 50 1 1987729280 40636096 8433920
20:51:18 9392 8192000000 10901250016 11346538496 1939190064 19.140 100 27 54 3 1989842400 41343888 9308448
20:51:43 17826 8192000000 10903893456 11352555520 1934919392 19.106 100 28 56 1 1987787136 42984960 9882784
20:52:11 17801 8192000000 10913293136 11362045952 1937662512 19.128 100 30 61 2 2000136416 51762384 10711520
20:52:57 31673 8192000000 10900846752 11370987520 1943725936 19.176 100 20 40 1 1999218416 47536000 7956480
20:53:36 51369 8192000000 10873523888 11330416640 1878880672 18.656 98 18 36 1 1927740496 42246112 6613712
20:54:34 27120 8192000000 10878274144 11339251712 1920175264 18.988 100 17 33 2 1964166784 37629248 6362272
20:55:20 71915 8192000000 10851112816 11321368576 1908158864 18.892 99 13 26 0 1927057888 14596320 4302704
20:56:41 47600 8192000000 10850481760 11304660992 1898780656 18.816 98 12 24 1 1909825680 7876240 3168784
20:57:35 113543 8192000000 10898289760 11355992064 1939071200 19.139 99 21 41 1 1954022192 9310320 5640672
20:59:43 63409 8192000000 10877486320 11334545408 1929541920 19.063 98 25 48 3 1952055968 15086432 7427616
21:01:01 61876 8192000000 10870526544 11336105984 1920127824 18.988 98 14 29 1 1942024880 17874192 4022864
21:02:09 45616 8192000000 10883194144 11343122432 1925975360 19.035 98 5 10 1 1933831344 6656384 1199600
21:03:01 54024 8192000000 10896934336 11355717632 1933052208 19.091 98 12 24 0 1944818384 8392608 3373568
21:04:02 83260 8192000000 10919948880 11367464960 1913453088 18.934 97 17 34 0 1932034304 14092208 4489008
21:05:36 7798 8192000000 10920439072 11353505792 1962247472 19.324 99 55 109 0 1985433952 7157152 16029328
21:05:55 34218 8192000000 10905896864 11367677952 1976492080 19.437 100 31 63 1 1994131392 9278352 8360960
21:06:50 85478 8192000000 10920706208 11362918400 1946656080 19.200 98 43 87 0 1967614768 8120096 12838592
21:08:23 61100 8192000000 10945279168 11390484480 1962605552 19.327 99 27 54 0 1978764832 8669904 7489376
21:09:34 15414 8192000000 10947300624 11392884736 1995102448 19.584 100 54 108 0 2023200528 12442768 15655312
21:09:59 50185 8192000000 10919313120 11381358592 1975343488 19.428 99 22 44 2 1995615888 14154336 6118064
21:10:59 52922 8192000000 10928640224 11387596800 1977659152 19.446 99 20 40 0 1996946608 13215184 6072272
21:11:58 697 8192000000 10952064912 11400523776 1999479328 19.619 100 45 89 2 2027105824 13954336 13672160
21:12:10 8591 8192000000 10938570400 11393277952 1984064240 19.497 99 31 62 0 2007516352 13413312 10038800
21:12:25 11165 8192000000 10919652576 11381927936 1972431616 19.405 99 34 68 0 1996420112 13937680 10050816
21:12:44 23752 8192000000 10916205008 11377123328 1949807904 19.225 98 30 60 2 1973052480 14315280 8929296
21:13:15 38208 8192000000 10935765328 11396444160 1991855104 19.558 100 27 54 1 2015195184 15283856 8056224
21:14:01 34372 8192000000 10955274016 11399622656 1983172864 19.490 99 46 92 1 2013622608 15596672 14853072
21:14:48 49026 8192000000 10945903232 11415568384 1964706400 19.343 98 34 68 1 1993725920 18476400 10543120
21:17:23 37056 8192000000 10925122992 11400777728 1986427824 19.516 100 18 36 0 2010891184 19266816 5196544
21:18:11 37323 8192000000 10913349984 11385249792 1956366688 19.277 98 10 20 0 1974704928 14668624 3669616
21:20:56 32847 8192000000 10909072048 11384516608 1960368992 19.309 99 15 31 1 1978198704 13215328 4614384
21:21:37 49312 8192000000 10921694928 11399708672 1948821472 19.217 98 20 40 1 1978738464 24092784 5824208
21:22:42 15119 8192000000 10944147088 11395166208 1990405792 19.547 100 49 94 1 2020362480 16810672 13146016
21:23:07 55671 8192000000 10929118272 11402141696 1955306656 19.269 98 26 52 3 1982854016 20019616 7527744
21:24:29 49215 8192000000 10907970528 11407339520 1970652080 19.391 100 9 18 0 1995253648 22103136 2498432
21:25:27 49134 8192000000 10926810080 11387142144 1946702672 19.200 98 15 30 0 1967348464 15741264 4904528
21:26:25 28650 8192000000 10926944208 11391168512 1982312048 19.483 100 28 56 0 2006681504 16461552 7907904
21:27:10 98457 8192000000 10902797728 11367665664 1885026416 18.706 95 11 22 0 1900724240 13023200 2674624
21:28:57 61912 8192000000 10888210976 11351592960 1820520048 18.182 92 23 46 0 1837200944 10506640 6174256
21:30:18 108752 8192000000 10907415504 11380338688 1909599376 18.903 97 17 34 0 1933141792 19094720 4447696
21:32:17 57499 8192000000 10902669824 11366273024 1924932832 19.026 98 17 34 2 1944239904 14939680 4367392
21:33:34 45601 8192000000 10906581936 11365650432 1920514608 18.991 98 25 50 1 1945495280 17762288 7218384
21:34:32 91325 8192000000 10860279536 11314499584 1810680832 18.101 93 35 68 2 1828566944 7405456 10480656
21:36:30 87921 8192000000 10870630512 11348439040 1938100880 19.132 100 22 44 1 1954068480 10298576 5669024
21:38:04 22773 8192000000 10880855424 11347628032 1932505696 19.087 99 24 48 0 1946328416 7178720 6644000
21:38:37 15503 8192000000 10886410720 11333656576 1934201568 19.100 99 55 109 3 1960610256 10498416 15910272
21:39:00 73529 8192000000 10842810672 11315191808 1890691664 18.751 97 43 86 0 1917646528 14765008 12189856
21:40:26 69802 8192000000 10817556592 11291598848 1856501024 18.475 96 10 20 1 1875657648 15808960 3347664
21:41:49 28017 8192000000 10862856512 11327451136 1918653504 18.976 99 40 80 2 1939247536 9024384 11569648
21:42:33 43255 8192000000 10862838304 11339468800 1921125968 18.996 99 21 42 0 1938033648 11006752 5900928
21:43:27 29473 8192000000 10845484240 11321655296 1881597552 18.678 97 11 21 0 1893674144 9243744 2832848
21:44:06 23278 8192000000 10842926896 11314085888 1891464432 18.758 98 14 28 0 1907878496 12711200 3702864
21:44:39 72767 8192000000 10876896064 11346493440 1933134768 19.092 100 20 40 1 1955137920 15894784 6108368
21:45:59 62075 8192000000 10855084736 11336024064 1902147472 18.844 98 10 20 0 1920141232 14332656 3661104
21:47:15 83696 8192000000 10864335536 11348606976 1909386656 18.902 99 14 28 1 1928318944 14714064 4218224
21:48:47 37860 8192000000 10901174784 11349348352 1944579568 19.183 100 24 48 0 1962816448 11013840 7223040
21:49:31 35974 8192000000 10863442544 11330961408 1910646944 18.912 98 33 66 0 1930429648 10713744 9068960
21:50:16 60746 8192000000 10854885920 11328114688 1876698288 18.638 97 13 26 0 1890947888 10882192 3367408
21:51:27 28512 8192000000 10864541344 11326701568 1900668048 18.832 98 28 56 3 1920236016 12046816 7521152
21:52:03 41572 8192000000 10894376080 11355406336 1945084128 19.187 100 27 54 0 1965009232 11645200 8279904
21:52:54 54241 8192000000 10887340864 11355545600 1935733680 19.113 99 40 79 0 1962312880 15659760 10919440
21:53:55 40679 8192000000 10906099232 11369304064 1965033840 19.346 100 36 72 0 1985846800 10664816 10148144
21:54:45 74297 8192000000 10887583328 11366629376 1943721392 19.176 99 26 52 2 1966616368 15604208 7290768
21:56:08 67447 8192000000 10894252880 11370364928 1933809392 19.097 98 16 32 0 1947526608 9510496 4206720
21:57:22 95093 8192000000 10924847888 11392688128 1946386992 19.198 98 13 25 0 1960566832 10852064 3327776
21:59:04 115343 8192000000 10899455536 11384012800 1928139680 19.052 97 9 18 0 1945512416 15065248 2307488
22:01:26 69487 8192000000 10906987408 11392638976 1971567024 19.398 99 10 20 0 1982971136 8148960 3255152
22:02:42 51576 8192000000 10908735600 11400925184 1988670816 19.533 100 10 19 0 2000967168 9677888 2618464
22:03:40 43350 8192000000 10909571984 11405135872 1990385792 19.547 100 8 16 0 2005327280 12995232 1946256
22:04:29 42132 8192000000 10910716752 11406262272 1988845200 19.535 100 4 8 0 2002056592 12077152 1134240
22:05:45 89956 8192000000 10924823888 11397951488 1947569696 19.207 97 14 28 1 1959098416 7672080 3856640
22:08:03 60114 8192000000 10898829088 11382341632 1952935632 19.250 98 17 33 1 1968350512 10233856 5181024
22:09:16 79955 8192000000 10899087904 11379314688 1887126848 18.723 95 12 24 1 1900092352 9770960 3194544
22:10:42 50044 8192000000 10895869712 11376881664 1958900240 19.297 99 21 41 2 1975971200 11674064 5396896
22:11:38 53529 8192000000 10883148688 11357261824 1923256304 19.013 97 17 35 0 1940499920 12325952 4917664
22:13:02 31158 8192000000 10887936000 11356635136 1874361680 18.620 95 30 58 0 1893653184 10794400 8497104
22:14:12 78555 8192000000 10884538608 11361828864 1930713776 19.073 99 24 48 3 1953368976 14770560 7884640
22:15:37 39569 8192000000 10888119232 11355688960 1922506832 19.007 98 33 66 0 1941899824 10022896 9370096
22:16:45 37111 8192000000 10900907184 11364605952 1948896624 19.218 99 44 88 1 1973611072 12106480 12607968
22:17:32 10613 8192000000 10892430432 11348066304 1925301456 19.029 98 39 78 2 1946114048 9998128 10814464
22:17:55 43331 8192000000 10913636400 11374493696 1959916832 19.305 100 42 85 0 1984305056 12840288 11547936
22:18:49 69551 8192000000 10881008976 11348557824 1886754320 18.720 96 28 56 1 1905977072 11648624 7574128
22:20:05 33871 8192000000 10855765136 11335196672 1867414192 18.563 96 22 44 1 1885138224 11785072 5938960
22:20:55 41630 8192000000 10895632352 11355398144 1950704160 19.232 100 45 90 2 1973244272 10156272 12383840
22:21:48 30476 8192000000 10909901280 11369193472 1930505872 19.071 98 43 86 1 1953420880 10680544 12234464
22:23:26 133984 8192000000 10875203088 11337744384 1887925008 18.729 97 7 14 0 1905308624 15519680 1863936
22:25:53 42897 8192000000 10840908976 11322646528 1900267776 18.828 98 24 48 1 1915326016 8273312 6784928
22:26:51 43415 8192000000 9795690592 10156695552 927343088 10.168 49 7 14 0 938413456 9309168 1761200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-03-2021 22:30:36 to 19-03-2021 22:30:38.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          242232
MON$OLDEST_ACTIVE               242972
MON$OLDEST_SNAPSHOT             242972
MON$NEXT_TRANSACTION            242972
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                       2038304
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Fri Mar 19 22:27:56 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Fri Mar 19 22:27:57 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
:36: 
:37: mscs-test-161.budzdorov.ru    Fri Mar 19 22:27:57 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Fri Mar 19 22:27:59 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
--- end of diff output ---

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

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