Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.04.2021 16:33
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 17370580 kB
MemAvailable 31404996 kB
Buffers 0 kB
Cached 14269988 kB
SwapCached 120 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-04-07 16:32:18
DTS_END                         2021-04-07 16:32:18.9880
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51496
TRN_ID                          241540
ATT_ID                          723
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: 8819.99 25680 1058399
customer order: creation 172.26 337 20671
customer order: refuse 15.33 315 1839
order to supplier: creation 46.22 1227 5546
order to supplier: removal 3.10 119818 372
invoice (draft): creation 46.20 3338 5544
invoice (draft): removal 49.72 859 5966
invoice accept: apply 41.24 17788 4949
invoice accept: cancel 45.31 846 5437
customer reserve: creation 3733.76 180 448051
customer reserve: removal 4375.71 66 525085
realization accept: apply 83.85 174 10062
realization accept: cancel 76.08 125 9129
payment from customer: creation 59.35 118 7122
payment from customer: removal 5.93 81 712
payment to supplier: creation 50.16 147 6019
payment to supplier: removal 3.43 111 412
service: total inventory turnovers 4.88 1156 586
service: total monetary turnovers 6.47 27 776
service: aggregate perf. data 0.98 16969 117
service: refresh index statistics 0.03 349915 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-04-2021 16:33:33 to 07-04-2021 16:33:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2541
TEST_TIME 2 3837
TEST_TIME 3 4762
TEST_TIME 4 3944
TEST_TIME 5 3632
TEST_TIME 6 4090
TEST_TIME 7 4438
TEST_TIME 8 4881
TEST_TIME 9 5449
TEST_TIME 10 5576
TEST_TIME 11 5503
TEST_TIME 12 5623
TEST_TIME 13 5609
TEST_TIME 14 5629
TEST_TIME 15 5833
TEST_TIME 16 6486
TEST_TIME 17 6756
TEST_TIME 18 7018
TEST_TIME 19 7107
TEST_TIME 20 7297
TEST_TIME 21 7738
TEST_TIME 22 7951
TEST_TIME 23 8371
TEST_TIME 24 8335
TEST_TIME 25 8702
TEST_TIME 26 8741
TEST_TIME 27 9214
TEST_TIME 28 10545
TEST_TIME 29 10971
TEST_TIME 30 10651
TEST_TIME 31 10740
TEST_TIME 32 10629
TEST_TIME 33 10445
TEST_TIME 34 10305
TEST_TIME 35 10182
TEST_TIME 36 10022
TEST_TIME 37 9901
TEST_TIME 38 9875
TEST_TIME 39 9839
TEST_TIME 40 9790
TEST_TIME 41 9771
TEST_TIME 42 9562
TEST_TIME 43 9414
TEST_TIME 44 9405
TEST_TIME 45 9351
TEST_TIME 46 9191
TEST_TIME 47 9073
TEST_TIME 48 9036
TEST_TIME 49 9051
TEST_TIME 50 8984
TEST_TIME 51 9090
TEST_TIME 52 9086
TEST_TIME 53 9091
TEST_TIME 54 9096
TEST_TIME 55 9026
TEST_TIME 56 9146
TEST_TIME 57 9201
TEST_TIME 58 9191
TEST_TIME 59 9234
TEST_TIME 60 9221
TEST_TIME 61 9245
TEST_TIME 62 9231
TEST_TIME 63 9249
TEST_TIME 64 9120
TEST_TIME 65 9076
TEST_TIME 66 9057
TEST_TIME 67 9086
TEST_TIME 68 9074
TEST_TIME 69 9014
TEST_TIME 70 8984
TEST_TIME 71 8936
TEST_TIME 72 8906
TEST_TIME 73 8987
TEST_TIME 74 8996
TEST_TIME 75 8996
TEST_TIME 76 8968
TEST_TIME 77 9035
TEST_TIME 78 9068
TEST_TIME 79 9102
TEST_TIME 80 9118
TEST_TIME 81 9079
TEST_TIME 82 9073
TEST_TIME 83 9076
TEST_TIME 84 9184
TEST_TIME 85 9211
TEST_TIME 86 9240
TEST_TIME 87 9171
TEST_TIME 88 9143
TEST_TIME 89 9080
TEST_TIME 90 9100
TEST_TIME 91 9047
TEST_TIME 92 8975
TEST_TIME 93 8938
TEST_TIME 94 8987
TEST_TIME 95 9106
TEST_TIME 96 9128
TEST_TIME 97 9093
TEST_TIME 98 9093
TEST_TIME 99 9144
TEST_TIME 100 9169
TEST_TIME 101 9165
TEST_TIME 102 9142
TEST_TIME 103 9152
TEST_TIME 104 9177
TEST_TIME 105 9192
TEST_TIME 106 9212
TEST_TIME 107 9195
TEST_TIME 108 9176
TEST_TIME 109 9101
TEST_TIME 110 9099
TEST_TIME 111 9059
TEST_TIME 112 9034
TEST_TIME 113 8993
TEST_TIME 114 8982
TEST_TIME 115 8954
TEST_TIME 116 8943
TEST_TIME 117 8907
TEST_TIME 118 8884
TEST_TIME 119 8870
TEST_TIME 120 8823

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-04-2021 16:33:37 to 07-04-2021 16:33:40.

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 1474063 1474063 0 0.00 0 20467 7 0 0
doc_list_biud 1474063 1474063 0 0.00 0 42830 30 0 0
sp_add_invoice_to_stock 5082 4949 133 2.61 18 193867 17789 0 133
sp_cancel_adding_invoice 5437 5437 0 0.00 5 49238 847 0 0
sp_cancel_client_order 1839 1839 0 0.00 4 13597 316 0 0
sp_cancel_customer_reserve 525085 525085 0 0.00 1 21541 67 0 0
sp_cancel_pay_from_customer 712 712 0 0.00 3 4879 82 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 9564 112 0 0
sp_cancel_supplier_invoice 5979 5966 13 0.21 1 42836 859 0 13
sp_cancel_supplier_order 372 372 0 0.00 6 1104704 119818 0 0
sp_cancel_write_off 9129 9129 0 0.00 1 18708 125 0 0
sp_client_order 20671 20671 0 0.00 3 25197 338 0 0
sp_customer_reserve 448051 448051 0 0.00 0 85086 180 0 0
sp_fill_shopping_cart 31757 31757 0 0.00 1 14517 39 0 0
sp_fill_shopping_cart_clo_res 448047 448047 0 0.00 0 18905 13 0 0
sp_get_clo_for_invoice 4943 4943 0 0.00 0 19171 320 0 0
sp_kill_cost_storno 15690 15690 0 0.00 0 7413 63 0 0
sp_kill_qstorno_ret_qs2qd 1065637 1065637 0 0.00 0 42827 36 0 0
sp_kill_qty_storno 562833 562833 0 0.00 0 42829 77 0 0
sp_lock_selected_doc 20817 20817 0 0.00 0 10106 5 0 0
sp_make_cost_storno 28146 28146 0 0.00 0 20460 52 0 0
sp_multiply_rows_for_pdistr 28146 28146 0 0.00 0 16998 29 0 0
sp_multiply_rows_for_qdistr 20671 20671 0 0.00 0 18527 145 0 0
sp_pay_from_customer 7122 7122 0 0.00 4 19238 118 0 0
sp_pay_to_supplier 6019 6019 0 0.00 5 19212 148 0 0
sp_payment_common 13141 13141 0 0.00 1 18762 43 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 0 13575 292 0 0
sp_qd_handle_on_invoice_upd_sts 10380 10380 0 0.00 0 28494 329 0 0
sp_qd_handle_on_reserve_upd_sts 10062 10062 0 0.00 0 13314 57 0 0
sp_reserve_write_off 10062 10062 0 0.00 6 16466 174 0 0
sp_supplier_invoice 5544 5544 0 0.00 6 92139 3338 0 0
sp_supplier_order 5546 5546 0 0.00 5 38048 1227 0 0
srv_aggregate_perf_data 117 117 0 0.00 2517 190156 16970 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1363 134805 33625 0 0
srv_find_qd_qs_mism 1011318 1011318 0 0.00 0 11820 6 0 0
srv_make_invnt_saldo 586 586 0 0.00 42 75669 1156 0 0
srv_make_money_saldo 776 776 0 0.00 0 3478 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 199260 598543 349915 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4949 4949 0 0.00 0 22273 179 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 2299 80 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 8896 25 0 0
t$perf-norm:sp_cancel_customer_reserve 687 687 0 0.00 0 2267 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 712 712 0 0.00 0 2615 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 283 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 1756 14 0 0
t$perf-norm:sp_cancel_supplier_order 372 372 0 0.00 0 31938 1849 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 22381 33 0 0
t$perf-norm:sp_client_order 20671 20671 0 0.00 0 24129 21 0 0
t$perf-norm:sp_customer_reserve 1005 1005 0 0.00 0 2740 11 0 0
t$perf-norm:sp_pay_from_customer 7122 7122 0 0.00 0 11837 12 0 0
t$perf-norm:sp_pay_to_supplier 6019 6019 0 0.00 0 22517 15 0 0
t$perf-norm:sp_reserve_write_off 10062 10062 0 0.00 0 14053 12 0 0
t$perf-norm:sp_supplier_invoice 5544 5544 0 0.00 0 7528 19 0 0
t$perf-norm:sp_supplier_order 5546 5546 0 0.00 0 6462 17 0 0
t$perf-norm:srv_aggregate_perf_data 117 117 0 0.00 0 98 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 271 3 0 0
t$perf-norm:srv_make_invnt_saldo 586 586 0 0.00 0 1188 26 0 0
t$perf-norm:srv_make_money_saldo 776 776 0 0.00 0 6528 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10150 9884 266 2.62 0 4138 20 0 266
v_all_customers 37556 37556 0 0.00 0 21 1 0 0
v_all_suppliers 30994 30994 0 0.00 0 66 1 0 0
v_all_wares 41342 41342 0 0.00 0 88 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 1327 8 0 0
v_cancel_client_order 3678 3678 0 0.00 0 1934 3 0 0
v_cancel_customer_prepayment 1424 1424 0 0.00 0 2722 5 0 0
v_cancel_customer_reserve 1374 1374 0 0.00 0 1456 4 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 7285 19 0 0
v_cancel_supplier_invoice 820 794 26 3.17 0 552 17 0 26
v_cancel_supplier_order 744 744 0 0.00 0 7750 21 0 0
v_cancel_write_off 1926 1926 0 0.00 0 649 10 0 0
v_max_id_clo_ord 5546 5546 0 0.00 0 2059 2 0 0
v_max_id_clo_res 1005 1005 0 0.00 0 2543 15 0 0
v_max_id_ord_sup 5540 5540 0 0.00 0 5718 4 0 0
v_max_non_paid_invoice 1608 1608 0 0.00 0 1090 3 0 0
v_max_non_paid_realizn 3919 3919 0 0.00 0 1549 3 0 0
v_min_id_clo_ord 5546 5546 0 0.00 0 4088 10 0 0
v_min_id_clo_res 1005 1005 0 0.00 0 5784 13 0 0
v_min_id_ord_sup 5540 5540 0 0.00 0 6698 8 0 0
v_min_non_paid_invoice 6019 6019 0 0.00 0 16960 37 0 0
v_min_non_paid_realizn 7122 7122 0 0.00 0 16398 30 0 0
v_our_firm 10192 10192 0 0.00 0 11 1 0 0
v_reserve_write_off 20124 20124 0 0.00 0 3982 5 0 0
x_lock_depdocs_on_canc_invoice 11006 11006 0 0.00 0 16063 137 0 0
x_lock_depdocs_on_canc_sup_ord 372 372 0 0.00 0 9875 386 0 0
x_make_qstorno_1000_1200 5546 5546 0 0.00 1 38039 1146 0 0
x_make_qstorno_1200_2000 5544 5544 0 0.00 2 86747 3201 0 0
x_make_qstorno_2100_3300 448051 448051 0 0.00 0 85085 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-04-2021 16:33:41 to 07-04-2021 16:33:45.

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
14:02:22 4 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:29 7727 8192000000 10157510608 10451587072 816363056 9.062 66 58 120 0 838878384 2308656 20206672
14:02:45 30448 8192000000 10330339072 10644578304 1362028048 14.256 100 84 168 0 1395332288 4394528 28909712
14:03:24 11937 8192000000 10355494400 10670047232 1407921728 14.665 100 86 171 0 1441856832 5461024 28474080
14:03:47 17085 8192000000 10387297296 10708652032 1434952640 14.905 100 86 170 1 1468663824 6258688 27452496
14:04:16 27039 8192000000 10420688304 10746458112 1466801008 15.186 100 90 180 1 1503291920 7227344 29263568
14:04:53 23226 8192000000 10432172368 10763563008 1490598208 15.394 100 87 174 0 1526688880 8023856 28066816
14:05:25 13716 8192000000 10447290928 10777706496 1503285952 15.505 100 90 180 0 1540844192 8391456 29166784
14:05:53 25534 8192000000 10457597344 10797481984 1517228320 15.626 100 89 178 1 1554652880 8986112 28438448
14:06:26 10417 8192000000 10470971872 10810793984 1529799552 15.735 100 78 156 0 1563363136 8702624 24860960
14:06:49 10607 8192000000 10498176304 10846609408 1552440592 15.931 100 82 163 1 1587311296 8845088 26025616
14:07:09 12249 8192000000 10532464304 10889994240 1591986976 16.271 100 71 142 0 1622649520 9182288 21480256
14:07:33 21553 8192000000 10584944416 10945155072 1632810256 16.619 100 78 156 1 1665928128 9866336 23251536
14:08:05 11927 8192000000 10598905312 10964312064 1663856048 16.881 100 83 166 1 1700465808 11540096 25069664
14:08:29 8761 8192000000 10623399952 10988281856 1680062032 17.018 100 82 164 2 1716536176 12261488 24212656
14:08:46 9474 8192000000 10640108096 11013050368 1704749648 17.225 100 83 166 2 1741598592 12438736 24410208
14:09:04 13104 8192000000 10666442464 11036291072 1717718640 17.333 100 79 158 0 1752951728 12257456 22975632
14:09:24 6055 8192000000 10683465600 11054092288 1738810560 17.509 100 86 172 2 1777370000 13861008 24698432
14:09:37 8124 8192000000 10685048304 11060830208 1743657344 17.549 100 79 158 1 1778802896 13035200 22110352
14:09:52 6743 8192000000 10684272768 11062910976 1746186288 17.570 100 79 157 1 1781551808 13094832 22270688
14:10:06 4669 8192000000 10694082128 11072880640 1753983120 17.635 100 85 169 1 1792188560 14381936 23823504
14:10:20 3832 8192000000 10700227600 11079483392 1759251216 17.678 100 86 173 1 1797768496 14362352 24154928
14:10:31 3551 8192000000 10716524512 11092557824 1771004960 17.775 100 88 178 0 1810548720 14611120 24932640
14:10:42 3203 8192000000 10716324864 11095228416 1778371600 17.836 100 84 168 0 1815181456 13742560 23067296
14:10:52 3069 8192000000 10728637024 11107872768 1788141216 17.916 100 84 165 3 1824095984 13489872 22464896
14:11:01 4164 8192000000 10733064912 11115200512 1794193504 17.966 100 86 170 0 1831960736 14263712 23503520
14:11:12 2381 8192000000 10741152528 11123384320 1803393248 18.042 100 88 175 0 1841838944 13832688 24613008
14:11:21 11172 8192000000 10743845088 11129434112 1805096944 18.056 100 78 156 3 1840144384 14408816 20638624
14:11:40 1926 8192000000 10765468272 11146276864 1818640256 18.167 100 85 169 0 1856339008 14424816 23273936
14:11:48 2248 8192000000 10769152592 11151978496 1826525616 18.231 100 89 178 2 1866765456 14913152 25326688
14:11:57 1743 8192000000 10782739184 11165970432 1834481376 18.296 100 95 192 1 1876064400 14408800 27174224
14:12:05 1880 8192000000 10779704064 11168137216 1837991008 18.324 100 88 176 1 1878318032 14512480 25814544
14:12:13 1186 8192000000 10784131472 11167358976 1841261952 18.351 100 94 189 3 1880563984 12995504 26306528
14:12:21 2327 8192000000 10797840432 11183759360 1851264224 18.432 100 87 175 1 1888890816 13344864 24281728
14:12:29 2448 8192000000 10798961872 11189514240 1856479984 18.475 100 87 175 0 1892948048 12819456 23648608
14:12:38 1416 8192000000 10803347904 11190247424 1859510144 18.499 100 95 193 2 1899673360 13447184 26716032
14:12:46 1922 8192000000 10812468992 11198189568 1864375216 18.539 100 97 192 1 1905641952 13502912 27763824
14:12:54 1330 8192000000 10810255344 11198197760 1865521648 18.548 100 88 180 2 1902724208 12327216 24875344
14:13:02 2024 8192000000 10814869520 11203977216 1871727136 18.598 100 95 189 1 1912619696 13367136 27525424
14:13:10 30168 8192000000 10788670528 11195138048 1867658288 18.565 100 68 136 0 1898384416 11073680 19652448
14:13:47 10581 8192000000 10811375472 11206270976 1870848480 18.591 100 79 157 1 1903463232 9011552 23603200
14:14:04 6260 8192000000 10782437680 11201773568 1867345600 18.563 100 47 94 2 1890598480 10326912 12925968
14:14:17 5665 8192000000 10786127328 11204886528 1867620992 18.565 100 33 65 0 1884451888 8171408 8659488
14:14:30 3304 8192000000 10795232416 11211796480 1876035120 18.633 100 47 93 0 1897586448 8460960 13090368
14:14:42 8415 8192000000 10783017920 11211157504 1876169008 18.634 100 28 56 1 1890619264 6386704 8063552
14:14:58 9187 8192000000 10785462400 11211440128 1877991632 18.649 100 24 48 1 1891027056 5838000 7197424
14:15:18 8756 8192000000 10788142912 11219189760 1881820224 18.680 100 24 48 1 1895521824 6913536 6788064
14:15:37 9602 8192000000 10802659104 11223842816 1883813888 18.696 100 19 38 4 1895139392 5861744 5463760
14:15:53 11337 8192000000 10788118176 11222945792 1885225440 18.707 100 11 20 2 1894260128 5752192 3282496
14:16:11 12102 8192000000 10798177600 11231809536 1892781360 18.768 100 18 36 0 1903299408 5195088 5322960
14:16:29 6677 8192000000 10799838688 11230244864 1892974512 18.770 100 21 42 0 1904833664 5558896 6300256
14:16:43 50772 8192000000 10804485840 11237543936 1893254144 18.772 100 23 45 0 1905015584 5201936 6559504
14:18:02 4771 8192000000 10820155936 11247681536 1902285264 18.845 100 52 104 0 1926452480 9807664 14359552
14:18:18 9487 8192000000 10807990336 11244388352 1897914336 18.810 100 16 31 0 1907761104 5503232 4343536
14:18:34 4912 8192000000 10822466832 11251019776 1903584688 18.855 100 38 77 1 1922266624 8078768 10603168
14:18:46 5642 8192000000 10823457552 11250274304 1902403856 18.846 100 32 65 0 1918210944 6522048 9285040
14:19:00 7311 8192000000 10830116784 11252678656 1902926544 18.850 100 28 56 2 1917050224 5843408 8280272
14:19:17 3907 8192000000 10825808656 11252051968 1903850912 18.857 100 31 62 0 1919078272 5501008 9726352
14:19:29 3406 8192000000 10827166608 11259875328 1906117888 18.875 100 31 60 2 1925333232 10710288 8505056
14:19:39 9260 8192000000 10814674736 11251851264 1904305328 18.861 100 20 40 3 1915273232 5495184 5472720
14:19:55 3562 8192000000 10820700560 11253751808 1906646160 18.880 100 31 63 1 1922468432 6943216 8879056
14:20:07 6682 8192000000 10815332016 11252142080 1907142832 18.884 100 19 38 1 1917974944 5544624 5287488
14:20:19 8441 8192000000 10817881520 11253252096 1908292176 18.893 100 28 55 2 1922198912 6097376 7809360
14:20:38 9601 8192000000 10831195328 11260801024 1909752592 18.905 100 19 38 3 1921052080 6265664 5033824
14:20:56 64756 8192000000 10807588480 11237183488 1856154272 18.472 97 28 55 0 1869341808 5236672 7950864
14:22:10 9205 8192000000 10812199760 11248467968 1882449152 18.685 99 23 46 1 1894358224 5496416 6412656
14:22:27 3825 8192000000 10801807616 11232718848 1884145376 18.699 99 32 65 2 1900752560 7738912 8868272
14:22:38 10900 8192000000 10809640704 11230728192 1859184208 18.497 98 25 48 2 1872370656 5530496 7655952
14:22:56 5196 8192000000 10782773456 11206434816 1808321600 18.082 96 32 64 2 1825189584 7422880 9445104
14:23:07 6749 8192000000 10767616176 11194441728 1821621808 18.191 98 21 42 1 1834365536 6054240 6689488
14:23:20 6663 8192000000 10777027088 11197550592 1839575248 18.337 99 30 60 0 1854924192 5452752 9896192
14:23:33 8671 8192000000 10749769344 11170590720 1785239712 17.893 96 31 62 1 1800430016 5644624 9545680
14:23:50 8925 8192000000 10729532336 11154055168 1773674480 17.797 96 19 37 0 1784260240 5974608 4611152
14:24:05 8177 8192000000 10724894096 11149180928 1772345584 17.786 97 18 36 1 1783509904 5527392 5636928
14:24:22 10263 8192000000 10700485264 11113562112 1705649904 17.232 95 30 60 1 1719868464 4968256 9250304
14:24:42 9169 8192000000 10707339024 11123167232 1752143648 17.619 97 27 54 1 1765868272 5647232 8077392
14:24:58 40873 8192000000 10719681920 11119300608 1733415328 17.464 96 39 76 5 1750159600 5556304 11187968
14:26:04 5587 8192000000 10700171616 11120517120 1767353488 17.745 98 39 76 0 1786226000 8032576 10839936
14:26:16 10113 8192000000 10733694416 11151360000 1797766880 17.996 99 32 64 2 1813785520 7040544 8978096
14:26:35 6255 8192000000 10708010960 11127369728 1766336448 17.737 97 29 58 0 1781789280 7070848 8381984
14:26:47 10516 8192000000 10705682416 11119349760 1762400208 17.704 98 32 65 2 1778272672 6101600 9770864
14:27:06 7002 8192000000 10717114752 11132481536 1786814320 17.906 99 26 52 1 1800606192 6234640 7557232
14:27:20 8520 8192000000 10722504592 11142549504 1807722768 18.077 100 27 54 1 1822632528 6864768 8044992
14:27:34 5907 8192000000 10714223904 11135410176 1791395696 17.943 99 17 34 0 1801896672 5698784 4802192
14:27:48 9439 8192000000 10742705744 11154489344 1801986624 18.030 99 20 38 4 1812743840 5445824 5311392
14:28:05 5786 8192000000 10746187584 11169435648 1830816832 18.266 100 41 83 0 1850770816 7560912 12393072
14:28:16 9852 8192000000 10751303824 11180269568 1843067280 18.366 100 17 34 2 1853717184 5218192 5431712
14:28:33 9326 8192000000 10758041856 11180568576 1829982832 18.259 99 29 58 3 1844562240 5187088 9392320
14:28:48 18542 8192000000 10767330832 11194757120 1853795808 18.453 100 20 40 0 1865474880 5870656 5808416
14:29:17 33585 8192000000 10763920032 11193937920 1843984048 18.373 99 35 69 2 1861233440 6581680 10667712
14:30:18 25247 8192000000 10773356208 11203805184 1857890640 18.486 100 23 43 1 1869869552 5270608 6708304
14:30:50 10748 8192000000 10789076272 11214331904 1867699008 18.566 100 24 46 4 1881351120 6272816 7379296
14:31:09 4760 8192000000 10790519408 11217330176 1875142112 18.626 100 33 67 2 1891782800 7637792 9002896
14:31:21 7021 8192000000 10805653696 11228647424 1878980368 18.657 100 32 61 2 1897457504 10145440 8331696
14:31:38 7686 8192000000 10793709488 11225403392 1879621424 18.662 100 32 64 3 1895594144 7269696 8703024
14:31:52 8551 8192000000 10798633616 11227516928 1884712944 18.703 100 30 60 1 1899969392 5944432 9312016
14:32:11 12776 8192000000 10816303104 11241541632 1899264976 18.820 100 25 50 1 1911210784 5096880 6848928
14:32:36 16275 8192000000 10842023184 11259670528 1912861152 18.930 100 42 85 2 1931302656 6414624 12026880
14:33:09 37152 8192000000 10863207056 11287289856 1920543520 18.991 100 44 86 2 1944770592 12427760 11799312
14:33:54 15459 8192000000 10863598112 11282264064 1926055104 19.035 100 44 88 2 1949236352 10932816 12248432
14:34:19 14431 8192000000 10869760432 11293073408 1934460576 19.103 100 50 100 0 1963020736 14069552 14490608
14:34:46 30340 8192000000 10879657824 11305623552 1944091952 19.179 100 39 76 2 1968067456 12782432 11193072
14:35:24 30426 8192000000 10869831856 11299373056 1935602912 19.112 99 52 103 2 1962595600 11587504 15405184
14:36:22 67609 8192000000 10889164352 11331301376 1956624128 19.279 100 32 63 0 1979546640 13675072 9247440
14:37:37 14910 8192000000 10899338096 11334787072 1963734336 19.336 100 46 93 0 1995021040 17391904 13894800
14:38:07 13348 8192000000 10907713200 11345240064 1967851376 19.368 100 38 76 0 2000601040 21391072 11358592
14:38:28 6638 8192000000 10920799168 11351285760 1974499344 19.421 100 59 119 1 2013677280 21599600 17578336
14:38:43 15537 8192000000 10920902832 11355365376 1978150624 19.450 100 60 115 5 2015634928 20933184 16551120
14:39:08 2592 8192000000 10936495536 11364380672 1983622480 19.493 100 63 127 0 2026035680 24142768 18270432
14:39:19 3471 8192000000 10942951264 11363799040 1984848384 19.503 100 63 124 0 2026677040 24161792 17666864
14:39:31 7567 8192000000 10942506928 11369590784 1987955088 19.528 100 67 134 1 2032778096 25896672 18926336
14:39:46 4689 8192000000 10952166768 11378102272 1988684752 19.533 100 65 128 2 2032476960 25479808 18312400
14:40:02 10146 8192000000 10940909040 11372232704 1989803856 19.542 100 59 117 3 2031079664 24472560 16803248
14:40:21 2897 8192000000 10952847680 11377893376 1992823616 19.566 100 67 133 0 2036160080 23718688 19617776
14:40:40 5176 8192000000 10953385760 11383431168 1999884528 19.622 100 63 125 0 2044067120 25562848 18619744
14:40:53 14270 8192000000 10953805552 11389317120 2003335168 19.649 100 68 136 0 2049368592 26271424 19762000
14:41:15 3382 8192000000 10945232352 11370983424 1977025776 19.441 99 75 149 1 2024555376 25831824 21697776
14:41:25 2435 8192000000 10961857408 11376279552 1989542192 19.540 100 77 151 2 2039813328 26930832 23340304
14:41:34 2644 8192000000 10951433056 11379490816 1995474592 19.587 100 75 146 1 2044689760 27174656 22040512
14:41:44 2508 8192000000 10961698608 11383570432 1994175632 19.577 100 77 154 1 2045504032 28827808 22500592
14:41:55 1994 8192000000 10950412544 11371798528 1987053824 19.521 100 80 159 3 2038945168 27839936 24051408
14:42:06 24742 8192000000 10929603696 11358015488 1929301376 19.061 97 64 128 2 1975480736 27604480 18574880
14:42:49 8951 8192000000 10951063472 11379322880 1990465744 19.547 100 59 118 3 2038025168 30066976 17492448
14:43:13 14658 8192000000 10949141360 11380252672 1972447168 19.405 99 52 103 1 2019016768 31225968 15343632
14:43:35 11587 8192000000 10950768720 11386933248 1996184320 19.593 100 50 100 0 2045066112 33327984 15553808
14:43:59 4358 8192000000 10948212416 11375890432 1983765488 19.495 100 48 96 0 2032163264 33313408 15084368
14:44:10 3690 8192000000 10968176336 11393515520 1997037376 19.599 100 69 134 4 2051701920 34511552 20152992
14:44:21 8875 8192000000 10970621728 11394916352 1998526272 19.611 100 65 129 1 2057575504 38887472 20161760
14:44:40 6750 8192000000 10969765264 11401256960 1983716208 19.494 99 57 114 0 2042856848 41300592 17840048
14:44:53 2921 8192000000 10985917968 11412979712 2006451232 19.674 100 66 132 1 2073788384 46490992 20846160
14:45:08 5256 8192000000 10985408320 11418648576 2014170144 19.734 100 59 118 1 2075991616 43323536 18497936
14:45:21 3218 8192000000 10973802768 11399372800 1994094832 19.576 99 61 122 2 2057222096 44369648 18757616
14:45:34 4951 8192000000 11006026960 11422072832 2019295648 19.775 100 82 164 0 2089103824 44428160 25380016
14:45:46 5215 8192000000 11000323200 11429335040 2016895664 19.756 100 71 140 1 2086327872 46888816 22543392
14:46:16 10008 8192000000 10985615104 11421204480 2008375120 19.689 100 65 128 2 2078288112 49073056 20839936
14:46:40 9401 8192000000 10977460240 11405631488 1980474736 19.468 99 64 128 0 2052579136 51329504 20774896
14:47:02 3733 8192000000 10975476304 11407433728 1988394896 19.531 100 61 119 3 2060983296 53064608 19523792
14:47:14 8061 8192000000 10969474272 11397709824 1982700432 19.486 100 62 123 1 2056732656 54117344 19914880
14:47:30 3184 8192000000 10980250160 11409002496 1990304272 19.546 100 62 124 1 2066806048 56859120 19642656
14:47:40 9890 8192000000 10969732064 11399094272 1977129792 19.442 99 55 108 3 2051546496 56194464 18222240
14:48:01 4615 8192000000 10956582624 11380551680 1958559440 19.295 98 55 110 0 2033988272 57839728 17589104
14:48:14 3641 8192000000 10984330592 11408326656 1985397008 19.507 100 70 140 0 2066862512 58459888 23005616
14:48:25 2444 8192000000 10987966864 11409420288 1974633200 19.422 99 73 146 1 2057045184 58244352 24167632
14:48:35 7740 8192000000 10982982304 11408650240 1994664208 19.581 100 71 143 1 2075815536 58147056 23004272
14:48:53 1697 8192000000 10992226752 11406151680 1987025840 19.520 99 77 152 2 2065072176 53502528 24543808
14:49:02 1573 8192000000 11001826800 11413282816 2005622592 19.667 100 85 169 1 2082105792 49931808 26551392
14:49:10 1549 8192000000 11015206112 11427049472 2015411504 19.744 100 92 184 1 2098038720 53878016 28749200
14:49:20 1456 8192000000 11011627264 11425370112 2010180240 19.703 100 86 174 3 2092129808 54460304 27489264
14:49:30 6103 8192000000 11009483904 11432071168 2015309808 19.743 100 79 158 1 2096951472 56566736 25074928
14:49:42 6740 8192000000 11002118976 11430526976 2008216336 19.687 100 70 138 0 2089874160 59560816 22097008
14:50:05 2125 8192000000 10997577440 11424264192 2002866320 19.645 100 70 140 1 2083378736 57924464 22587952
14:50:16 1994 8192000000 10982183136 11394994176 1975646320 19.430 99 79 159 1 2059270352 57962544 25661488
14:50:26 6883 8192000000 10995772624 11422965760 1996895632 19.598 100 68 136 0 2083830576 64237728 22697216
14:50:42 2705 8192000000 11005288000 11428564992 2002256864 19.641 100 66 132 0 2084403680 60171280 21975536
14:50:52 5371 8192000000 10998882112 11433783296 2007123952 19.679 100 61 119 1 2084306944 57411968 19771024
14:51:10 13161 8192000000 10995602960 11435433984 2007989568 19.686 100 41 82 3 2076856880 54709888 14157424
14:51:36 6819 8192000000 10996231152 11431985152 2005793360 19.668 100 47 94 0 2078282928 56981152 15508416
14:51:56 1362 8192000000 10994098976 11410300928 1986090496 19.513 100 78 155 0 2072026208 60049264 25886448
14:52:06 1703 8192000000 10999411856 11412762624 1985374720 19.507 100 86 169 0 2074712944 61450128 27888096
14:52:17 3245 8192000000 10985274272 11400957952 1947536144 19.207 98 80 160 0 2037377456 63904784 25936528
14:52:27 4872 8192000000 10973202688 11401306112 1969586608 19.382 100 68 137 2 2059766048 66656848 23522592
14:52:39 11258 8192000000 10939020656 11373887488 1928639920 19.056 98 43 86 1 2005982288 62665136 14677232
14:52:57 5248 8192000000 10970212048 11379073024 1958785232 19.296 100 73 143 2 2047629040 65330288 23513520
14:53:10 3872 8192000000 10985948288 11402203136 1973488976 19.413 100 75 150 2 2062597232 65773952 23334304
14:53:21 3717 8192000000 10986156176 11411361792 1979393936 19.460 100 69 138 2 2072827792 70925504 22508352
14:53:32 5518 8192000000 10979550608 11406729216 1963439136 19.333 99 68 136 2 2059677872 74165408 22073328
14:53:47 3747 8192000000 10978376384 11397804032 1938401168 19.134 98 65 130 0 2028454352 68015648 22037536
14:54:01 2192 8192000000 10971098560 11398938624 1969055040 19.378 100 55 110 1 2056477488 68674800 18747648
14:54:15 6548 8192000000 10967426288 11396694016 1949485824 19.222 99 55 110 1 2034392448 66646176 18260448
14:54:32 15094 8192000000 10952247616 11383025664 1923714416 19.017 98 47 94 2 2011431904 71024176 16693312
14:54:53 8134 8192000000 10957239792 11399745536 1956768416 19.280 100 47 93 1 2044085120 71790864 15525840
14:55:12 12539 8192000000 10953656080 11402743808 1960220544 19.308 100 41 82 0 2036566448 61975520 14370384
14:55:31 19777 8192000000 10954983616 11396354048 1968864672 19.376 100 32 64 1 2035456544 55931248 10660624
14:56:01 15796 8192000000 10958173360 11400933376 1970201504 19.387 100 31 62 2 2040338032 59358976 10777552
14:56:33 14446 8192000000 10961568832 11408711680 1975295232 19.427 100 34 68 0 2048644608 61503856 11845520
14:56:57 11447 8192000000 10966788672 11410432000 1976127040 19.434 100 30 59 2 2049605504 63346576 10131888
14:57:22 15393 8192000000 10977738512 11425595392 1978685792 19.454 100 30 60 3 2058698960 68886304 11126864
14:57:50 23074 8192000000 10962273488 11414614016 1984505952 19.500 100 29 58 2 2057036064 62521152 10008960
14:58:47 18034 8192000000 10965141376 11429023744 1968808672 19.376 100 24 48 0 2054745664 76668800 9268192
14:59:12 12274 8192000000 10970106768 11428880384 1968624064 19.375 100 25 50 0 2054931504 76924304 9383136
14:59:32 25846 8192000000 10953193680 11418165248 1941998176 19.163 99 22 44 2 2025217664 74537440 8682048
15:00:04 25754 8192000000 10922594272 11400798208 1932936976 19.090 99 20 40 2 2019548768 78742720 7869072
15:00:36 10972 8192000000 10908006928 11374845952 1945531776 19.191 100 12 24 1 2000087440 50191632 4364032
15:01:00 15574 8192000000 10883127312 11350081536 1913988880 18.939 98 28 54 1 1946526624 24219280 8318464
15:01:28 19489 8192000000 10888040160 11351252992 1954653728 19.264 100 16 32 0 1973912256 14776416 4482112
15:01:55 75955 8192000000 10871885888 11306340352 1901451312 18.838 97 42 84 1 1926037104 11601344 12984448
15:03:47 42247 8192000000 10881731616 11355574272 1952483088 19.246 100 14 27 1 1968891296 12738032 3670176
15:04:36 60147 8192000000 10865494400 11332554752 1903143728 18.852 97 23 45 1 1917911152 8644496 6122928
15:05:56 111201 8192000000 10890057296 11349389312 1931469520 19.079 99 15 30 0 1946197280 10622080 4105680
15:08:06 93439 8192000000 10896382544 11360899072 1929474128 19.063 98 15 30 0 1950779280 17392000 3913152
15:09:49 67429 8192000000 10900252672 11362332672 1948587392 19.215 99 15 30 0 1967690192 14878080 4224720
15:11:11 54561 8192000000 10915905984 11379052544 1981615776 19.477 100 19 37 2 1996206960 9241152 5350032
15:12:16 125654 8192000000 10867854672 11337981952 1891146960 18.755 95 13 26 0 1904825632 10101760 3576912
15:14:48 20265 8192000000 10917834880 11359621120 1972973568 19.409 100 48 96 0 1995816672 8617136 14225968
15:15:14 33754 8192000000 10890416880 11346894848 1930521232 19.071 98 44 88 1 1954595920 10787120 13287568
15:16:07 46416 8192000000 10881519472 11353354240 1960726400 19.312 100 22 44 1 1983369328 16414080 6228848
15:17:52 89823 8192000000 10888886896 11371225088 1970353568 19.388 100 14 28 1 1985379856 10985088 4041200
15:19:34 61379 8192000000 10887461616 11367215104 1959599600 19.303 99 13 26 0 1973082448 9613616 3869232
15:21:06 85214 8192000000 10901300416 11380379648 1980862960 19.472 100 14 28 0 1998056816 13147808 4046048
15:22:42 86172 8192000000 10900605008 11377758208 1927159696 19.044 97 14 28 0 1940944368 9372592 4412080
15:24:23 70599 8192000000 10909021152 11384270848 1945916256 19.194 98 14 28 1 1960159568 10046912 4196400
15:25:39 105208 8192000000 10933468672 11401211904 1997217888 19.601 100 19 38 0 2018743296 15880400 5645008
15:27:40 83887 8192000000 10910788736 11372011520 1914695888 18.944 96 19 36 1 1933065264 12996160 5373216
15:29:33 39572 8192000000 10913116832 11376283648 1929488592 19.063 97 23 46 1 1950062048 13841584 6731872
15:30:19 62591 8192000000 10900399408 11368046592 1887681600 18.727 95 19 36 3 1901959456 9445456 4832400
15:31:34 36059 8192000000 10882677936 11336880128 1905954336 18.874 97 11 22 0 1916925984 8277232 2694416
15:32:18 68657 8192000000 10904220720 11361628160 1945973696 19.194 99 34 66 2 1966940080 11166976 9799408
15:33:33 52716 8192000000 10898200352 11362988032 1912576816 18.927 97 25 50 2 1927731616 8828032 6326768
15:34:33 51075 8192000000 10875001392 11342376960 1852393184 18.442 94 18 36 1 1866441216 8814304 5233728
15:35:30 102541 8192000000 10839629680 11303059456 1876767120 18.639 96 20 40 1 1895312928 12638560 5907248
15:37:23 100954 8192000000 10828348224 11279581184 1808225232 18.081 93 27 54 0 1834464912 17839792 8399888
15:39:22 4492 8192000000 10823146960 11269890048 1890281520 18.748 99 37 74 2 1911138848 9733008 11124320
15:39:33 7255 8192000000 10835954320 11287158784 1903793408 18.857 100 31 62 1 1921879904 9928448 8158048
15:39:49 11786 8192000000 10815994752 11279163392 1886777904 18.720 99 28 56 1 1903317504 8975072 7564528
15:40:13 56202 8192000000 10835597872 11301097472 1867232944 18.562 97 18 36 1 1881268784 9022048 5013792
15:41:16 87529 8192000000 10843051936 11314073600 1864868896 18.543 97 10 20 0 1877896784 9914592 3113296
15:42:50 70719 8192000000 10863888320 11334295552 1926242720 19.037 99 19 38 0 1941920864 10025776 5652368
15:45:20 45310 8192000000 10866075328 11333390336 1922414304 19.006 99 17 34 0 1938631920 10933648 5283968
15:46:12 41121 8192000000 10849686016 11322441728 1917060832 18.963 99 22 45 1 1931881856 8487456 6333568
15:47:07 60642 8192000000 10879505056 11342393344 1904179184 18.860 98 21 42 1 1920582672 10715168 5688320
15:48:14 85628 8192000000 10888091584 11355639808 1918109984 18.972 98 30 60 1 1941109456 14656848 8342624
15:50:58 118888 8192000000 10877455952 11359289344 1892572464 18.767 97 10 20 0 1907730880 12361856 2796560
15:53:05 35060 8192000000 10886114688 11346026496 1947294432 19.205 99 28 56 1 1964093168 8520864 8277872
15:53:48 36701 8192000000 10869983968 11323793408 1915812752 18.953 98 28 56 1 1932891184 9609424 7469008
15:54:34 21688 8192000000 10897287504 11345010688 1931778336 19.081 99 45 89 2 1953740736 9566368 12396032
15:55:07 88428 8192000000 10890835120 11362639872 1885059472 18.706 96 34 68 0 1907478512 13145680 9273360
15:56:42 92637 8192000000 10886496848 11360722944 1908864784 18.898 98 8 16 0 1935180800 23848544 2467472
15:58:22 111008 8192000000 10900245264 11358441472 1960127632 19.307 100 14 28 1 1975040480 10475040 4437808
16:00:19 113915 8192000000 10868325600 11333894144 1871632304 18.597 95 18 36 0 1884019760 7833296 4554160
16:02:19 32911 8192000000 10884348048 11357159424 1958111824 19.291 100 17 32 0 1969895408 7524288 4259296
16:02:58 58639 8192000000 10890111712 11368710144 1961580976 19.319 99 11 22 0 1976417728 12084640 2752112
16:04:04 71194 8192000000 10909957648 11392647168 1988117952 19.529 100 13 26 0 2008321248 16507680 3695616
16:05:38 76886 8192000000 10921258000 11416178688 1972626448 19.406 99 14 28 1 2001937232 25318384 3992400
16:07:01 38041 8192000000 10926536976 11407630336 1981981552 19.480 100 14 28 0 2016065024 29874928 4208544
16:07:46 102141 8192000000 10916451600 11395260416 1954475008 19.262 98 14 28 1 1969511088 11130992 3905088
16:09:35 43432 8192000000 10920895952 11382702080 1953544400 19.255 98 26 52 0 1972561360 11409216 7607744
16:10:25 37217 8192000000 10917392016 11384381440 1953661568 19.256 98 28 54 0 1972586432 11449808 7475056
16:11:09 134805 8192000000 10921804192 11417137152 1948210256 19.212 98 12 24 1 1966234896 14472736 3551904
16:13:34 36881 8192000000 10917577520 11376930816 1951681520 19.240 98 27 54 1 1968945264 9938448 7325296
16:14:22 26937 8192000000 10909622928 11365634048 1932402464 19.086 98 29 57 2 1948480048 8014544 8063040
16:14:57 47221 8192000000 10904504064 11365900288 1928799056 19.057 98 39 78 0 1953141424 13499440 10842928
16:15:53 14318 8192000000 10897384016 11353939968 1943700288 19.176 99 40 80 1 1965449712 10986608 10762816
16:16:45 130324 8192000000 10885041792 11366023168 1860642896 18.508 94 19 37 1 1877560240 11455312 5462032
16:19:04 49553 8192000000 10884971552 11345502208 1882701680 18.687 96 20 40 0 1899102784 10897024 5504080
16:20:00 60820 8192000000 10878725872 11338473472 1892588992 18.767 97 31 62 1 1912105552 11103440 8413120
16:21:40 95714 8192000000 10862993280 11345555456 1910699536 18.912 98 28 56 1 1926426688 7647696 8079456
16:23:23 29415 8192000000 10860722064 11337924608 1911195360 18.916 98 11 22 0 1924040576 9297280 3547936
16:24:18 88234 8192000000 10823783536 11297980416 1802516688 18.035 93 14 28 1 1817803120 11120736 4165696
16:25:53 75980 8192000000 10782483776 11256819712 1792561072 17.953 94 6 12 0 1805640816 11383984 1695760
16:27:51 37785 8192000000 10847780352 11299758080 1893715232 18.776 99 26 53 0 1908119024 6857856 7545936
16:28:35 63633 8192000000 10849298032 11326038016 1904907728 18.866 99 14 28 0 1915935120 6788640 4238752
16:29:53 61158 8192000000 10833802000 11310903296 1859991456 18.503 97 4 8 1 1868030096 6999168 1039472
16:31:01 67554 8192000000 10854833936 11325374464 1871933600 18.600 97 22 43 1 1888476816 10322352 6220864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 07-04-2021 16:33:47 to 07-04-2021 16:34:18.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 133 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-04-2021 16:34:19 to 07-04-2021 16:34:21.

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          240993
MON$OLDEST_ACTIVE               241682
MON$OLDEST_SNAPSHOT             241682
MON$NEXT_TRANSACTION            241682
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                       2019200
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.33442 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33442 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33442 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33442 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
:18: 
:19: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:20:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:21: 
:22: 
:23: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:24:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:25: 
:26: 
:27: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:28:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:29: 
:30: 
:31: mscs-test-161.budzdorov.ru    Wed Apr  7 16:32:24 2021
:32:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:33: 
--- end of diff output ---

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

07.04.21 16:34:22. There are 6 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-04-07 16:34:25 No severe PSQL-related problems occured
07.04.21 16:34:26. End of report.