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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-14 01:27:15
DTS_END                         2021-02-14 01:27:15.7000
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/38198
TRN_ID                          230673
ATT_ID                          647
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: 9081.80 17225 1089816
customer order: creation 165.27 369 19832
customer order: refuse 13.92 378 1670
order to supplier: creation 43.28 1384 5193
order to supplier: removal 3.31 115448 397
invoice (draft): creation 45.45 3597 5454
invoice (draft): removal 52.35 846 6282
invoice accept: apply 39.85 20131 4782
invoice accept: cancel 46.76 821 5611
customer reserve: creation 3728.02 197 447362
customer reserve: removal 4660.32 64 559238
realization accept: apply 79.21 206 9505
realization accept: cancel 79.74 114 9569
payment from customer: creation 56.12 112 6734
payment from customer: removal 5.71 89 685
payment to supplier: creation 47.24 146 5669
payment to supplier: removal 3.14 99 377
service: total inventory turnovers 4.58 1139 550
service: total monetary turnovers 6.77 27 812
service: aggregate perf. data 0.75 23887 90
service: refresh index statistics 0.03 175436 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-02-2021 01:28:13 to 14-02-2021 01:28:15.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5913
TEST_TIME 2 5089
TEST_TIME 3 5153
TEST_TIME 4 4868
TEST_TIME 5 4984
TEST_TIME 6 5048
TEST_TIME 7 5137
TEST_TIME 8 5464
TEST_TIME 9 6029
TEST_TIME 10 6470
TEST_TIME 11 6368
TEST_TIME 12 6519
TEST_TIME 13 6617
TEST_TIME 14 6876
TEST_TIME 15 6917
TEST_TIME 16 7053
TEST_TIME 17 7265
TEST_TIME 18 7181
TEST_TIME 19 7517
TEST_TIME 20 7849
TEST_TIME 21 7861
TEST_TIME 22 7901
TEST_TIME 23 8298
TEST_TIME 24 8859
TEST_TIME 25 8710
TEST_TIME 26 9011
TEST_TIME 27 9255
TEST_TIME 28 9327
TEST_TIME 29 10226
TEST_TIME 30 10590
TEST_TIME 31 10418
TEST_TIME 32 10433
TEST_TIME 33 10379
TEST_TIME 34 10362
TEST_TIME 35 10110
TEST_TIME 36 10120
TEST_TIME 37 10065
TEST_TIME 38 10010
TEST_TIME 39 9937
TEST_TIME 40 9930
TEST_TIME 41 9871
TEST_TIME 42 9734
TEST_TIME 43 9767
TEST_TIME 44 9662
TEST_TIME 45 9629
TEST_TIME 46 9525
TEST_TIME 47 9472
TEST_TIME 48 9457
TEST_TIME 49 9484
TEST_TIME 50 9469
TEST_TIME 51 9307
TEST_TIME 52 9181
TEST_TIME 53 9225
TEST_TIME 54 9169
TEST_TIME 55 9104
TEST_TIME 56 8988
TEST_TIME 57 9101
TEST_TIME 58 9073
TEST_TIME 59 9030
TEST_TIME 60 9137
TEST_TIME 61 9117
TEST_TIME 62 9111
TEST_TIME 63 9088
TEST_TIME 64 9154
TEST_TIME 65 9157
TEST_TIME 66 9281
TEST_TIME 67 9326
TEST_TIME 68 9295
TEST_TIME 69 9287
TEST_TIME 70 9313
TEST_TIME 71 9464
TEST_TIME 72 9459
TEST_TIME 73 9463
TEST_TIME 74 9366
TEST_TIME 75 9300
TEST_TIME 76 9283
TEST_TIME 77 9246
TEST_TIME 78 9213
TEST_TIME 79 9220
TEST_TIME 80 9217
TEST_TIME 81 9204
TEST_TIME 82 9192
TEST_TIME 83 9184
TEST_TIME 84 9105
TEST_TIME 85 9137
TEST_TIME 86 9112
TEST_TIME 87 9132
TEST_TIME 88 9136
TEST_TIME 89 9097
TEST_TIME 90 9170
TEST_TIME 91 9162
TEST_TIME 92 9141
TEST_TIME 93 9144
TEST_TIME 94 9204
TEST_TIME 95 9315
TEST_TIME 96 9302
TEST_TIME 97 9369
TEST_TIME 98 9362
TEST_TIME 99 9341
TEST_TIME 100 9417
TEST_TIME 101 9396
TEST_TIME 102 9319
TEST_TIME 103 9301
TEST_TIME 104 9253
TEST_TIME 105 9248
TEST_TIME 106 9200
TEST_TIME 107 9173
TEST_TIME 108 9177
TEST_TIME 109 9162
TEST_TIME 110 9131
TEST_TIME 111 9094
TEST_TIME 112 9101
TEST_TIME 113 9127
TEST_TIME 114 9112
TEST_TIME 115 9097
TEST_TIME 116 9136
TEST_TIME 117 9131
TEST_TIME 118 9143
TEST_TIME 119 9128
TEST_TIME 120 9084

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-02-2021 01:28:17 to 14-02-2021 01:28:20.

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 1503841 1503841 0 0.00 0 32697 6 0 0
doc_list_biud 1503841 1503841 0 0.00 0 32877 30 0 0
sp_add_invoice_to_stock 4829 4782 47 0.97 42 214459 20132 0 47
sp_cancel_adding_invoice 5611 5611 0 0.00 4 50362 822 0 0
sp_cancel_client_order 1670 1670 0 0.00 4 19142 378 0 0
sp_cancel_customer_reserve 559238 559238 0 0.00 1 32896 64 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 2 8077 90 0 0
sp_cancel_pay_to_supplier 377 377 0 0.00 2 12938 100 0 0
sp_cancel_supplier_invoice 6284 6282 2 0.03 1 11006 846 0 2
sp_cancel_supplier_order 397 397 0 0.00 5 867873 115448 0 0
sp_cancel_write_off 9569 9569 0 0.00 1 7707 115 0 0
sp_client_order 19832 19832 0 0.00 4 17571 370 0 0
sp_customer_reserve 447362 447362 0 0.00 0 51701 198 0 0
sp_fill_shopping_cart 30468 30468 0 0.00 1 16831 43 0 0
sp_fill_shopping_cart_clo_res 447360 447360 0 0.00 0 13880 13 0 0
sp_get_clo_for_invoice 4779 4779 0 0.00 0 39490 339 0 0
sp_kill_cost_storno 16242 16242 0 0.00 0 5453 58 0 0
sp_kill_qstorno_ret_qs2qd 1134724 1134724 0 0.00 0 32862 35 0 0
sp_kill_qty_storno 597051 597051 0 0.00 0 32875 75 0 0
sp_lock_selected_doc 19842 19842 0 0.00 0 10672 6 0 0
sp_make_cost_storno 26687 26687 0 0.00 0 18824 58 0 0
sp_multiply_rows_for_pdistr 26687 26687 0 0.00 0 7555 31 0 0
sp_multiply_rows_for_qdistr 19832 19832 0 0.00 0 17554 162 0 0
sp_pay_from_customer 6734 6734 0 0.00 4 18332 113 0 0
sp_pay_to_supplier 5669 5669 0 0.00 5 18265 147 0 0
sp_payment_common 12403 12403 0 0.00 1 7894 26 0 0
sp_qd_handle_on_cancel_clo 1670 1670 0 0.00 0 19132 348 0 0
sp_qd_handle_on_invoice_upd_sts 10390 10390 0 0.00 0 16171 357 0 0
sp_qd_handle_on_reserve_upd_sts 9505 9505 0 0.00 0 17674 73 0 0
sp_reserve_write_off 9505 9505 0 0.00 6 19998 206 0 0
sp_supplier_invoice 5454 5454 0 0.00 7 90106 3597 0 0
sp_supplier_order 5193 5193 0 0.00 6 33293 1385 0 0
srv_aggregate_perf_data 90 90 0 0.00 2425 372358 23887 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 1283 124939 30362 0 0
srv_find_qd_qs_mism 1043719 1043719 0 0.00 0 32696 5 0 0
srv_make_invnt_saldo 550 550 0 0.00 23 108888 1140 0 0
srv_make_money_saldo 812 812 0 0.00 1 1484 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 117219 272008 175436 0 0
t$perf-abend:sp_add_invoice_to_stock 47 47 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4782 4782 0 0.00 0 16568 193 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 2869 87 0 0
t$perf-norm:sp_cancel_client_order 1670 1670 0 0.00 0 3563 18 0 0
t$perf-norm:sp_cancel_customer_reserve 639 639 0 0.00 0 4780 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 2626 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 377 377 0 0.00 0 1004 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 2442 27 0 0
t$perf-norm:sp_cancel_supplier_order 397 397 0 0.00 0 25345 1695 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 2309 12 0 0
t$perf-norm:sp_client_order 19832 19832 0 0.00 0 7668 19 0 0
t$perf-norm:sp_customer_reserve 902 902 0 0.00 0 2861 10 0 0
t$perf-norm:sp_pay_from_customer 6734 6734 0 0.00 0 7395 11 0 0
t$perf-norm:sp_pay_to_supplier 5669 5669 0 0.00 0 7679 8 0 0
t$perf-norm:sp_reserve_write_off 9505 9505 0 0.00 0 25393 15 0 0
t$perf-norm:sp_supplier_invoice 5454 5454 0 0.00 0 5493 19 0 0
t$perf-norm:sp_supplier_order 5193 5193 0 0.00 0 17350 24 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 877 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 1602 13 0 0
t$perf-norm:srv_make_invnt_saldo 550 550 0 0.00 0 1250 21 0 0
t$perf-norm:srv_make_money_saldo 812 812 0 0.00 0 1855 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 9652 9558 94 0.97 0 7002 16 0 94
v_all_customers 35824 35824 0 0.00 0 26 1 0 0
v_all_suppliers 29812 29812 0 0.00 0 14 1 0 0
v_all_wares 39658 39658 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 7085 16 0 0
v_cancel_client_order 3340 3340 0 0.00 0 1647 6 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 2070 6 0 0
v_cancel_customer_reserve 1278 1278 0 0.00 0 1054 5 0 0
v_cancel_payment_to_supplier 754 754 0 0.00 0 12908 27 0 0
v_cancel_supplier_invoice 790 786 4 0.50 0 1493 20 0 4
v_cancel_supplier_order 794 794 0 0.00 0 1938 8 0 0
v_cancel_write_off 2010 2010 0 0.00 0 2499 15 0 0
v_max_id_clo_ord 5193 5193 0 0.00 0 2598 2 0 0
v_max_id_clo_res 902 902 0 0.00 0 867 7 0 0
v_max_id_ord_sup 5446 5446 0 0.00 0 4993 6 0 0
v_max_non_paid_invoice 1402 1402 0 0.00 0 162 2 0 0
v_max_non_paid_realizn 3728 3728 0 0.00 0 3493 5 0 0
v_min_id_clo_ord 5193 5193 0 0.00 0 3891 8 0 0
v_min_id_clo_res 902 902 0 0.00 0 5781 33 0 0
v_min_id_ord_sup 5446 5446 0 0.00 0 5214 6 0 0
v_min_non_paid_invoice 5669 5669 0 0.00 0 6503 17 0 0
v_min_non_paid_realizn 6734 6734 0 0.00 0 7892 17 0 0
v_our_firm 9846 9846 0 0.00 0 19 1 0 0
v_reserve_write_off 19010 19010 0 0.00 0 12760 9 0 0
x_lock_depdocs_on_canc_invoice 11500 11500 0 0.00 0 28083 128 0 0
x_lock_depdocs_on_canc_sup_ord 397 397 0 0.00 0 14763 418 0 0
x_make_qstorno_1000_1200 5193 5193 0 0.00 2 33270 1292 0 0
x_make_qstorno_1200_2000 5454 5454 0 0.00 4 89923 3449 0 0
x_make_qstorno_2100_3300 447362 447362 0 0.00 0 51698 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-02-2021 01:28:21 to 14-02-2021 01:28:25.

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
22:57:19 11 8192000000 8804636640 8816984064 10067136 0.122 3 1 2 0 10187872 58176 62560
22:57:26 20655 8192000000 10268034928 10578550784 1047787584 11.339 80 64 129 0 1071993376 3142096 21063696
22:57:54 27734 8192000000 10330916160 10647556096 1377360016 14.393 100 85 170 0 1410152816 5125664 27667136
22:58:30 19747 8192000000 10362049888 10686222336 1417956816 14.755 100 91 183 0 1454316784 6402464 29957504
22:58:58 24275 8192000000 10382208016 10707828736 1438568048 14.937 100 84 168 0 1473518784 7263232 27687504
22:59:36 22098 8192000000 10398474128 10728456192 1459400512 15.121 100 92 184 0 1497387136 7897856 30088768
23:00:04 24837 8192000000 10426575488 10755272704 1476577952 15.271 100 93 186 0 1515420944 8241296 30601696
23:00:41 17649 8192000000 10454968608 10787074048 1503929232 15.510 100 89 178 2 1541092752 8785104 28378416
23:01:10 18739 8192000000 10470975168 10808229888 1525431504 15.697 100 91 180 2 1563613296 9705536 28476256
23:01:51 13726 8192000000 10495270528 10843136000 1555981488 15.962 100 85 170 0 1593250240 10333344 26935408
23:02:12 17937 8192000000 10543645488 10895966208 1586893152 16.227 100 83 166 2 1623202832 10466784 25842896
23:02:37 7961 8192000000 10557056976 10916306944 1616471488 16.480 100 81 158 1 1651886992 10697584 24717920
23:02:53 13453 8192000000 10591562832 10950049792 1640180976 16.681 100 85 167 2 1677659744 11025616 26453152
23:03:15 7698 8192000000 10597461232 10965114880 1661064064 16.858 100 83 166 0 1697997792 11826688 25107040
23:03:32 7909 8192000000 10620192432 10984755200 1672890928 16.958 100 72 144 1 1706886352 12287168 21708256
23:03:48 14578 8192000000 10643817712 11009228800 1689054800 17.093 100 80 160 1 1725715968 12821488 23839680
23:04:10 8094 8192000000 10654195104 11024990208 1710279136 17.271 100 79 155 1 1745491952 12331680 22881136
23:04:32 7392 8192000000 10667877360 11040563200 1731993600 17.452 100 83 166 0 1768447024 12655888 23797536
23:04:49 8946 8192000000 10688383008 11064655872 1747830080 17.584 100 83 166 1 1784307536 12925632 23551824
23:05:06 6320 8192000000 10711382496 11087708160 1768616672 17.756 100 86 170 0 1805708416 12997184 24094560
23:05:19 5525 8192000000 10725491360 11104129024 1777322048 17.827 100 85 167 0 1814861744 13609136 23930560
23:05:31 3725 8192000000 10727638784 11107311616 1782965424 17.874 100 83 167 0 1820369408 13462976 23941008
23:05:42 4236 8192000000 10724287424 11109359616 1787985280 17.915 100 82 164 2 1823007664 12800528 22221856
23:05:53 3949 8192000000 10733784800 11117547520 1795192688 17.974 100 85 170 1 1832888768 13903296 23792784
23:06:04 4107 8192000000 10747408512 11127631872 1806500688 18.067 100 91 178 1 1844122448 13454144 24167616
23:06:15 9835 8192000000 10748154848 11133120512 1806278816 18.065 100 78 156 1 1842770144 15355504 21135824
23:06:32 1902 8192000000 10761263200 11147571200 1809620992 18.093 100 82 164 0 1846518272 13655888 23241392
23:06:40 2379 8192000000 10763132816 11147530240 1825693040 18.224 100 85 168 2 1862936560 13448432 23795088
23:06:49 2482 8192000000 10776523952 11160502272 1831458176 18.271 100 92 182 3 1871576704 14147792 25970736
23:06:57 2187 8192000000 10779706560 11167764480 1840120320 18.342 100 92 184 1 1879978912 13927440 25931152
23:07:06 1314 8192000000 10788397152 11174346752 1844994944 18.381 100 86 172 0 1882719264 13228256 24496064
23:07:14 1957 8192000000 10790385312 11178455040 1848839424 18.413 100 87 174 3 1886463328 13054144 24569760
23:07:23 2074 8192000000 10804012592 11189583872 1854636688 18.460 100 94 188 6 1894772800 13464272 26671840
23:07:31 2542 8192000000 10807545200 11195580416 1859066992 18.496 100 92 179 0 1899033072 14225744 25740336
23:07:40 2133 8192000000 10812308192 11200364544 1868135344 18.569 100 90 180 0 1907096208 13028672 25932192
23:07:49 2468 8192000000 10815108080 11204268032 1868060272 18.569 100 90 181 1 1907063920 13677424 25326224
23:07:58 1821 8192000000 10822220544 11209326592 1872817024 18.607 100 95 192 0 1913540528 14122768 26600736
23:08:06 1560 8192000000 10815929104 11209400320 1876141040 18.634 100 91 182 0 1916140304 14045760 25953504
23:08:13 1383 8192000000 10820550016 11210563584 1877936464 18.648 100 90 180 1 1918048464 13541456 26570544
23:08:21 1337 8192000000 10823774464 11214790656 1882908704 18.689 100 93 188 0 1922258304 12395536 26954064
23:08:29 2670 8192000000 10821922704 11215183872 1882438144 18.685 100 90 182 1 1919395248 11511280 25445824
23:08:38 13545 8192000000 10828754720 11217838080 1883454096 18.693 100 76 154 1 1915165312 11471568 20239648
23:08:57 1263 8192000000 10833679760 11225997312 1886762864 18.720 100 94 189 1 1927125200 14469680 25892656
23:09:09 47572 8192000000 10798648016 11220070400 1875469888 18.629 100 30 60 1 1890407360 6704368 8233104
23:10:08 12924 8192000000 10783005584 11214635008 1882781088 18.688 100 40 80 0 1901554096 6702208 12070800
23:10:29 5554 8192000000 10808672272 11228725248 1884491184 18.701 100 43 87 2 1903329040 6532160 12305696
23:10:48 11207 8192000000 10792627104 11223187456 1890436688 18.749 100 26 51 1 1903687024 5580032 7670304
23:11:06 7193 8192000000 10795289312 11228311552 1891881152 18.761 100 29 56 1 1906174832 6319072 7974608
23:11:22 9636 8192000000 10809790096 11232247808 1889769120 18.744 100 19 38 0 1901445120 6145328 5530672
23:11:38 4516 8192000000 10806585680 11237507072 1899294928 18.821 100 29 58 1 1913688112 6195008 8198176
23:11:49 4409 8192000000 10815825552 11241603072 1899330928 18.821 100 39 77 2 1917782480 7102688 11348864
23:12:00 9128 8192000000 10807387888 11238772736 1894385744 18.781 100 13 26 1 1903852064 5787104 3679216
23:12:16 8230 8192000000 10810040848 11240632320 1900700704 18.832 100 27 51 1 1913960416 5545472 7714240
23:12:30 7141 8192000000 10803726192 11240628224 1899922704 18.826 100 21 42 1 1912471072 6560704 5987664
23:12:44 11359 8192000000 10821985712 11249217536 1901707808 18.840 100 17 34 1 1911859232 5091616 5059808
23:13:03 5433 8192000000 10813793872 11248373760 1905539936 18.871 100 28 56 1 1921147568 7509792 8097840
23:13:19 9812 8192000000 10822042544 11251736576 1907995408 18.891 100 21 42 1 1919680704 5948880 5736416
23:13:38 8864 8192000000 10817595056 11254255616 1909428800 18.902 100 20 40 0 1921504960 6092384 5983776
23:13:55 12392 8192000000 10820178736 11256664064 1910091792 18.907 100 16 32 1 1921249232 6527984 4629456
23:14:18 18455 8192000000 10828467984 11257188352 1912917040 18.930 100 19 38 1 1923830480 5120816 5792624
23:14:42 71466 8192000000 10812845280 11255386112 1897324112 18.805 99 27 54 0 1910121184 4585552 8211520
23:16:00 6588 8192000000 10825945904 11259064320 1914502880 18.943 100 27 54 0 1928250992 6049648 7698464
23:16:14 5741 8192000000 10839099600 11272474624 1920989232 18.995 100 36 72 3 1938591424 7343120 10259072
23:16:28 6877 8192000000 10825486304 11262017536 1910048272 18.907 100 30 60 1 1925007504 7035920 7923312
23:16:42 5935 8192000000 10835365600 11262160896 1908274928 18.893 100 26 52 1 1921560896 5460896 7825072
23:16:55 9106 8192000000 10806897696 11243429888 1868927840 18.576 98 15 30 0 1878798096 5638240 4232016
23:17:10 6184 8192000000 10806655904 11241918464 1890617328 18.751 100 23 44 0 1902721312 5580960 6523024
23:17:23 11669 8192000000 10795779440 11231088640 1858990848 18.495 98 30 61 0 1871709808 5039184 7679776
23:17:41 10026 8192000000 10806103248 11242930176 1891663680 18.759 100 16 32 1 1901934400 5621920 4648800
23:17:59 6987 8192000000 10795546560 11227684864 1840496832 18.345 97 24 48 3 1852758160 5181216 7080112
23:18:15 13435 8192000000 10769418080 11183910912 1751178688 17.611 93 23 46 2 1763517776 5449792 6889296
23:18:35 11286 8192000000 10762707024 11191201792 1824210672 18.212 98 13 26 0 1833023008 5018736 3793600
23:18:53 12548 8192000000 10748310496 11171729408 1738767936 17.508 93 14 28 0 1748601040 5332912 4500192
23:19:12 67335 8192000000 10729190608 11140911104 1622429632 16.531 89 20 40 0 1637930640 9197344 6303664
23:20:27 22517 8192000000 10689513872 11108499456 1674614864 16.972 93 26 52 1 1687226432 5220560 7391008
23:21:00 4640 8192000000 10702759168 11115388928 1745465408 17.564 97 41 81 5 1763101472 6425072 11210992
23:21:12 6428 8192000000 10696971808 11109388288 1732176352 17.454 97 26 52 2 1745550880 6196160 7178368
23:21:25 5233 8192000000 10703975024 11108663296 1745319696 17.563 98 29 59 0 1759769088 6290944 8158448
23:21:39 5337 8192000000 10698261264 11110989824 1748411632 17.588 98 27 54 1 1762293216 6204240 7677344
23:21:51 8769 8192000000 10702027024 11127246848 1779201136 17.843 99 30 60 1 1793599424 5818032 8580256
23:22:08 4830 8192000000 10715934176 11134373888 1801169472 18.024 100 24 48 3 1814520688 6059776 7291440
23:22:22 6518 8192000000 10718800896 11136487424 1785980544 17.899 99 21 42 0 1797447744 5180416 6286784
23:22:37 10544 8192000000 10722527264 11137613824 1760853040 17.691 97 31 62 0 1779812736 10094752 8864944
23:22:59 8512 8192000000 10737224416 11159511040 1815843488 18.144 100 24 48 2 1828658784 5258592 7556704
23:23:16 10175 8192000000 10751348272 11171016704 1830432800 18.263 100 29 59 1 1844390256 5302080 8655376
23:23:33 9886 8192000000 10742101296 11174952960 1833709328 18.290 100 23 46 1 1846742832 5947760 7085744
23:23:49 13064 8192000000 10765434400 11183587328 1839626560 18.338 100 31 62 2 1854668672 5936464 9105648
23:24:12 66146 8192000000 10784708512 11190239232 1841142672 18.350 100 41 82 1 1859405280 5470528 12792080
23:25:24 5945 8192000000 10764596784 11190575104 1846749664 18.396 100 31 62 0 1864348208 8348272 9250272
23:25:37 6968 8192000000 10769025008 11193065472 1851957856 18.438 100 20 40 1 1862218528 5163584 5097088
23:25:50 8685 8192000000 10777909360 11195674624 1853947168 18.454 100 30 62 1 1868663824 5812784 8903872
23:26:05 7402 8192000000 10786718160 11197911040 1856378432 18.474 100 29 56 2 1869908224 4968672 8561120
23:26:21 3750 8192000000 10785497328 11205910528 1861477040 18.515 100 38 76 0 1880644688 8881504 10286144
23:26:31 8356 8192000000 10793374288 11214172160 1860951168 18.511 100 30 59 0 1874147008 5171040 8024800
23:26:49 8810 8192000000 10776457296 11205689344 1863803440 18.534 100 26 52 0 1878096528 6028848 8264240
23:27:06 8409 8192000000 10800490752 11227598848 1884081520 18.698 100 25 50 1 1896643808 5264016 7298272
23:27:24 8492 8192000000 10830611840 11244662784 1897719120 18.808 100 45 89 1 1916352288 4879040 13754128
23:27:40 15559 8192000000 10836128016 11254538240 1904754256 18.865 100 55 104 3 1927078096 6709728 15614112
23:28:05 28653 8192000000 10846928784 11265740800 1913655680 18.936 100 50 101 0 1936317280 8379328 14282272
23:28:41 38912 8192000000 10851930224 11277664256 1918537744 18.975 100 44 86 1 1938347552 8072288 11737520
23:29:28 13809 8192000000 10856777872 11286097920 1927745456 19.049 100 46 92 0 1949962992 9300560 12916976
23:29:53 20698 8192000000 10865384672 11291365376 1930537616 19.071 100 49 98 3 1953856336 9316656 14002064
23:30:22 20164 8192000000 10865962432 11299782656 1939372144 19.142 100 43 84 2 1962643344 10905456 12365744
23:30:49 11607 8192000000 10862068480 11294298112 1921836528 19.002 99 44 88 2 1944266240 10070048 12359664
23:31:15 8660 8192000000 10883676336 11302031360 1942839328 19.169 100 58 116 2 1971302608 11330608 17132672
23:31:34 2828 8192000000 10898100736 11311398912 1949478416 19.222 100 67 128 0 1979577488 11990784 18108288
23:31:45 4217 8192000000 10894697824 11312046080 1950167696 19.228 100 69 137 1 1982168448 12802880 19197872
23:31:57 28138 8192000000 10889857136 11322589184 1953244704 19.252 100 58 116 2 1985685520 15279888 17160928
23:32:34 18905 8192000000 10885905808 11319115776 1957648000 19.287 100 56 112 1 1988512352 14997456 15866896
23:33:06 2509 8192000000 10908003296 11331301376 1969705408 19.383 100 73 143 1 2006028416 14883104 21439904
23:33:23 5164 8192000000 10916069664 11340513280 1973802816 19.416 100 66 134 1 2009099568 15439104 19857648
23:33:37 18081 8192000000 10905526208 11334897664 1949884816 19.226 99 51 102 2 1979304224 15215120 14204288
23:34:05 3881 8192000000 10915201472 11337625600 1970485040 19.389 100 59 117 2 2003833216 16349696 16998480
23:34:16 14561 8192000000 10915272384 11345813504 1978241296 19.451 100 58 116 0 2012527584 17512224 16774064
23:34:38 8911 8192000000 10923696944 11349229568 1980116192 19.466 100 49 99 3 2011547888 17001520 14430176
23:34:56 6381 8192000000 10937232720 11358117888 1983508864 19.492 100 59 117 1 2019335792 18657984 17168944
23:35:10 7014 8192000000 10934298256 11360477184 1986792304 19.518 100 65 128 1 2025331840 19433584 19105952
23:35:26 5440 8192000000 10946909760 11373694976 1989587408 19.541 100 65 130 1 2029159408 19575824 19996176
23:35:39 4590 8192000000 10945791904 11368357888 1992772864 19.566 100 71 141 3 2034944688 20829904 21341920
23:35:53 15125 8192000000 10944669760 11374501888 1992742608 19.565 100 63 125 1 2033514928 21806800 18965520
23:36:15 4419 8192000000 10933117632 11362103296 1987769168 19.526 100 62 123 2 2026219328 19243040 19207120
23:36:27 6964 8192000000 10925115472 11348283392 1969506480 19.382 99 72 144 1 2009571376 19449872 20615024
23:36:51 13666 8192000000 10924782672 11363913728 1981206992 19.474 100 53 107 0 2017789536 19761616 16820928
23:37:15 18203 8192000000 10921657296 11364827136 1982122320 19.481 100 43 85 0 2010071504 15453344 12495840
23:37:45 18752 8192000000 10935792640 11373387776 1995278256 19.585 100 53 106 2 2027457520 16397024 15782240
23:38:13 13076 8192000000 10943148048 11380273152 1996498352 19.595 100 50 100 1 2028854752 17679616 14676784
23:38:35 8064 8192000000 10940166528 11377717248 1994472832 19.579 100 52 104 2 2030880672 19667024 16740816
23:38:51 5548 8192000000 10928769872 11365761024 1972801568 19.408 99 54 108 1 2007384320 18265472 16317280
23:39:06 6050 8192000000 10936825024 11371241472 1990745072 19.550 100 62 123 4 2029803328 20485936 18572320
23:39:19 2133 8192000000 10945762592 11378659328 1996665392 19.596 100 66 132 2 2037520512 21310944 19544176
23:39:31 5848 8192000000 10944636896 11375390720 1992460608 19.563 100 61 119 4 2030923184 20755472 17707104
23:39:45 5316 8192000000 10930186176 11360555008 1979276448 19.459 99 64 127 4 2017023424 18418544 19328432
23:40:01 8354 8192000000 10949954864 11384745984 1998291344 19.609 100 50 101 0 2033466944 19878288 15297312
23:40:18 7801 8192000000 10946441072 11383083008 1997034448 19.599 100 59 115 0 2037546784 22695600 17816736
23:40:34 3064 8192000000 10981751248 11396022272 2013320592 19.728 100 83 166 1 2061256592 22507376 25428624
23:40:44 3351 8192000000 10963851552 11376001024 1993165648 19.569 99 72 143 1 2039007616 23767968 22074000
23:40:55 2638 8192000000 10957619008 11380482048 1995691872 19.589 100 84 168 0 2046680720 25215168 25773680
23:41:06 2829 8192000000 10952575968 11362975744 1977084288 19.442 99 90 179 3 2031205968 26743440 27378240
23:41:16 2305 8192000000 10956024288 11367505920 1969353216 19.380 99 84 164 2 2022193920 27581312 25259392
23:41:28 1278 8192000000 10963234624 11378728960 1989316576 19.538 100 91 180 2 2044952704 27212704 28423424
23:41:36 8512 8192000000 10965985744 11389444096 1997378080 19.602 100 74 148 0 2048906048 28202464 23325504
23:41:53 1990 8192000000 10955412016 11370983424 1983593424 19.493 99 76 152 2 2033261120 25578528 24089168
23:42:07 6400 8192000000 10959488432 11389366272 1999351904 19.618 100 68 136 2 2047925584 27138000 21435680
23:42:21 2219 8192000000 10982293744 11403026432 2013366288 19.728 100 79 157 0 2064959392 27518592 24074512
23:42:30 3802 8192000000 10978803568 11399516160 2008429056 19.689 100 85 171 0 2063094592 28516240 26149296
23:42:50 4684 8192000000 10968226976 11385061376 1991564720 19.556 100 85 170 1 2049785856 31246112 26975024
23:43:03 3714 8192000000 10954987600 11373846528 1981379664 19.476 100 71 139 0 2034040480 30488192 22172624
23:43:15 11580 8192000000 10936346512 11354259456 1959100064 19.299 99 77 152 4 2014792224 32027760 23664400
23:43:36 5251 8192000000 10943258416 11371458560 1978154256 19.450 100 67 134 0 2029861440 30458240 21248944
23:43:49 3378 8192000000 10956754928 11382439936 1987144544 19.521 100 66 131 3 2039850416 31820464 20885408
23:44:00 7304 8192000000 10967951968 11386900480 1995468592 19.587 100 73 142 3 2047352464 28899088 22984784
23:44:15 5552 8192000000 10962384816 11386585088 1992418016 19.563 100 73 146 0 2045215712 29879600 22918096
23:44:28 6893 8192000000 10952005232 11385516032 1992621280 19.565 100 54 108 0 2038791952 28846736 17323936
23:44:43 5224 8192000000 10956358736 11391774720 1998816128 19.613 100 62 123 0 2047013872 28599264 19598480
23:44:58 5118 8192000000 10974822304 11395383296 1999011168 19.615 100 80 161 2 2054677808 30439088 25227552
23:45:13 3765 8192000000 10971879104 11394805760 2001377408 19.634 100 74 147 0 2055314592 31289680 22647504
23:45:23 3051 8192000000 10989179584 11411193856 2009464976 19.697 100 80 160 1 2068744768 34429360 24850432
23:45:34 1780 8192000000 10987455744 11398430720 1990307520 19.546 99 87 172 3 2052367168 35218160 26841488
23:45:43 3030 8192000000 10979137856 11396530176 1985827440 19.511 99 85 171 1 2048870560 37066240 25976880
23:45:54 3903 8192000000 10967057632 11388530688 1974062272 19.418 99 75 151 1 2035089856 37393792 23633792
23:46:08 3167 8192000000 10967033984 11382472704 1954469376 19.262 98 76 152 0 2019811584 41281680 24060528
23:46:18 3264 8192000000 10973379280 11393712128 1973488576 19.413 99 80 160 2 2041404896 42174448 25741872
23:46:30 2212 8192000000 10988412672 11398524928 1992468848 19.563 100 89 179 0 2065514576 45376832 27668896
23:46:42 2795 8192000000 10980730000 11394711552 1992307024 19.562 100 83 165 0 2060771984 42577136 25887824
23:46:51 1622 8192000000 10964646656 11385479168 1987752352 19.526 100 78 156 1 2052816816 38958176 26106288
23:47:00 2524 8192000000 10991511488 11404423168 2001520848 19.635 100 89 174 0 2068593808 39470064 27602896
23:47:09 2817 8192000000 10974531152 11398164480 1994906144 19.583 100 74 148 0 2058890528 40147552 23836832
23:47:18 8898 8192000000 10960361792 11399667712 1991815696 19.558 100 49 97 2 2047651312 39782240 16053376
23:47:35 6575 8192000000 10948720704 11386916864 1982589408 19.485 100 44 88 1 2036326880 38830064 14907408
23:47:50 8017 8192000000 10943022208 11382964224 1959455360 19.302 99 38 76 1 2008617024 36533856 12627808
23:48:08 2998 8192000000 10974437760 11396808704 1989837296 19.543 100 82 164 1 2055455024 39022544 26595184
23:48:21 2261 8192000000 10975785664 11395645440 1988068448 19.529 100 78 156 1 2053450160 41284512 24097200
23:48:34 9133 8192000000 10975938960 11405590528 1994143408 19.577 100 64 128 1 2058491328 43485296 20862624
23:48:53 1753 8192000000 10950960752 11363291136 1949262912 19.221 98 77 154 2 2018796384 44132864 25400608
23:49:03 2418 8192000000 10981023024 11393228800 1985345888 19.507 100 80 158 1 2055846464 45574880 24925696
23:49:14 3728 8192000000 10979695872 11400630272 1990944288 19.551 100 77 154 0 2062277120 45958128 25374704
23:49:25 5533 8192000000 10975416832 11397828608 1986016384 19.512 100 76 151 2 2058672896 47884400 24772112
23:49:39 1495 8192000000 10987765792 11405447168 1996072528 19.592 100 90 177 3 2070945216 45795264 29077424
23:49:50 3681 8192000000 11000001072 11412824064 1998346128 19.610 100 88 177 0 2074181536 48055232 27780176
23:50:00 5304 8192000000 10967581216 11397222400 1979605136 19.462 100 66 132 0 2051286928 49345680 22336112
23:50:17 11778 8192000000 10964034944 11399348224 1980153296 19.466 100 51 102 0 2046584656 49141472 17289888
23:50:45 10277 8192000000 10953628448 11388088320 1956460512 19.278 99 58 115 2 2024675632 48928688 19286432
23:51:05 6344 8192000000 10965453040 11396833280 1977937728 19.448 100 53 106 1 2044717744 48985056 17794960
23:51:23 11017 8192000000 10950107312 11391242240 1959585232 19.303 99 39 78 1 2020833968 47320048 13928688
23:51:47 14432 8192000000 10924612208 11383320576 1934767728 19.105 98 36 70 2 1989602960 42839920 11995312
23:52:08 7631 8192000000 10931793408 11381600256 1962890560 19.329 100 37 74 1 2013291520 38497776 11903184
23:52:28 17712 8192000000 10926973952 11369369600 1957959904 19.290 100 36 72 1 2011084944 41066528 12058512
23:52:52 24654 8192000000 10933458560 11379032064 1957137328 19.283 100 34 68 0 2012544944 43969920 11437696
23:53:33 20956 8192000000 10906484656 11365498880 1919754016 18.985 98 29 58 2 1979900000 49579632 10566352
23:54:36 34589 8192000000 10867056992 11328741376 1894359600 18.781 98 18 36 1 1944133136 43299120 6474416
23:55:21 29615 8192000000 10883694704 11338678272 1893119664 18.771 99 17 34 1 1948152688 48146128 6886896
23:56:03 43187 8192000000 10878396064 11353743360 1897948384 18.810 99 21 42 1 1959560592 53624432 7987776
23:57:07 43117 8192000000 10868865728 11336384512 1918604400 18.976 99 20 38 0 1948873232 24937600 5331232
23:57:57 40754 8192000000 10876817440 11328204800 1928432144 19.054 99 16 32 0 1944184352 11176768 4575440
23:58:48 10097 8192000000 10884204288 11327283200 1933078992 19.091 99 50 99 0 1958000736 10562272 14359472
23:59:52 124939 8192000000 10867405584 11335036928 1892076096 18.763 97 14 28 0 1915913136 19956432 3880608
00:02:04 97308 8192000000 10877026256 11338412032 1920215664 18.989 99 20 40 0 1944625104 17567072 6842368
00:03:51 90572 8192000000 10880982800 11329683456 1923067312 19.011 99 40 81 0 1949272288 14236944 11968032
00:05:30 95809 8192000000 10857549504 11328045056 1907892800 18.890 98 16 33 0 1921099728 9141120 4065808
00:07:22 67694 8192000000 10872789616 11340075008 1913863888 18.938 98 15 27 0 1925353424 7928192 3561344
00:08:45 40881 8192000000 10902308288 11349491712 1946467824 19.198 99 29 58 1 1964845440 9738368 8639248
00:09:41 119084 8192000000 10863362976 11326001152 1883595760 18.694 96 16 30 1 1896096080 8324080 4176240
00:11:47 73416 8192000000 10891083168 11341819904 1939372080 19.142 99 21 41 3 1953424560 8445584 5606896
00:13:27 56357 8192000000 10903658352 11349131264 1963093008 19.331 100 27 55 0 1980228320 9089296 8046016
00:14:29 3773 8192000000 10918669984 11365339136 1978934416 19.456 100 51 102 1 2004051616 10576800 14540400
00:14:40 18938 8192000000 10915288112 11366973440 1978896672 19.456 100 35 70 1 2000496160 11426896 10172592
00:15:07 35045 8192000000 10932495536 11373735936 1963788336 19.336 99 50 100 1 1990645424 12329040 14528048
00:15:59 74234 8192000000 10893304256 11374563328 1975970160 19.433 100 17 34 0 1993223536 12432576 4820800
00:17:25 36669 8192000000 10889787376 11377614848 1971963840 19.401 100 5 10 0 1984061056 10599168 1498048
00:18:58 75682 8192000000 10913840544 11383386112 1987594704 19.525 100 26 52 0 2001261712 6225328 7441680
00:20:25 103656 8192000000 10921500416 11397087232 1986283792 19.514 100 11 23 2 2001292528 11836128 3172608
00:22:17 37898 8192000000 10915928992 11399475200 1997155936 19.600 100 22 44 0 2017603952 14115696 6332320
00:23:01 59371 8192000000 10919247072 11401404416 1974222928 19.419 99 12 24 1 1992872960 14669968 3980064
00:24:28 71110 8192000000 10909570848 11397382144 1930405216 19.070 97 9 18 1 1951757968 18612048 2740704
00:25:51 60250 8192000000 10912059712 11387871232 1986995808 19.520 100 21 42 0 2008497696 15549568 5952320
00:27:03 65347 8192000000 10903690512 11380879360 1930848304 19.074 97 20 40 0 1945454736 8908848 5697584
00:28:16 53587 8192000000 10931370800 11387830272 1955441808 19.270 98 25 50 2 1970283920 8150720 6691392
00:29:16 58188 8192000000 10928846544 11404374016 1977884704 19.448 99 33 66 0 1999218896 12406960 8927232
00:31:01 83231 8192000000 10904895120 11377807360 1922928064 19.010 97 19 38 0 1953020848 24054368 6038416
00:32:32 59714 8192000000 10894924688 11369869312 1913663680 18.936 97 19 38 0 1942173360 22746976 5762704
00:33:45 43076 8192000000 10897067872 11358756864 1923216960 19.013 98 25 50 1 1942528656 12571168 6740528
00:34:40 42775 8192000000 10916062640 11379437568 1974786992 19.423 100 22 45 0 1993928912 13015216 6126704
00:35:39 55408 8192000000 10921236624 11385896960 1965151760 19.347 99 34 66 1 1990075856 15234800 9689296
00:36:41 58733 8192000000 10915497520 11370983424 1866159616 18.553 94 17 34 0 1889501872 18329104 5013152
00:37:47 45616 8192000000 10881460480 11368710144 1898930512 18.818 97 19 38 2 1933651520 29187872 5533136
00:38:47 77293 8192000000 10893564528 11360997376 1916359456 18.958 98 20 40 0 1940388880 18188528 5840896
00:41:43 57390 8192000000 10877412848 11323551744 1905346480 18.869 97 31 63 0 1920715344 6324720 9044144
00:42:46 28323 8192000000 10876570112 11327500288 1933126112 19.092 99 38 73 2 1954814384 11062416 10625856
00:43:29 24223 8192000000 10878858736 11326861312 1893926384 18.777 97 51 100 5 1917576240 10271472 13378384
00:44:03 47233 8192000000 10853287648 11304837120 1882473584 18.685 97 45 90 1 1906427824 11053600 12900640
00:44:57 12796 8192000000 10826832368 11277348864 1873456464 18.612 98 43 86 2 1896525776 10833152 12236160
00:45:17 16934 8192000000 10843315152 11293118464 1893805664 18.776 99 39 77 3 1914106672 9616912 10684096
00:45:51 36701 8192000000 10826471872 11290632192 1876323216 18.635 98 40 74 2 1897922112 10969584 10629312
00:46:34 57334 8192000000 10821014112 11295567872 1893001568 18.770 99 12 24 1 1906142848 9263024 3878256
00:47:40 66355 8192000000 10794324352 11268751360 1788453408 17.919 93 11 22 0 1802008256 10363024 3191824
00:49:00 33598 8192000000 10807105424 11274739712 1866545040 18.556 99 14 26 0 1880812848 10582400 3685408
00:49:40 44945 8192000000 10811519328 11276607488 1874286464 18.619 99 16 32 1 1890350432 11206496 4857472
00:50:36 82550 8192000000 10812033248 11275595776 1876317632 18.635 99 21 42 2 1893938864 10888128 6733104
00:52:17 66618 8192000000 10812300080 11292188672 1879934496 18.665 99 9 18 1 1890691296 7964192 2792608
00:53:30 60817 8192000000 10824646272 11294208000 1853709152 18.452 97 21 42 1 1868449824 8953584 5787088
00:55:14 70485 8192000000 10840478368 11301830656 1859797040 18.502 97 13 26 1 1877181536 13583536 3800960
00:56:34 68285 8192000000 10838339744 11313311744 1891081824 18.754 98 20 40 1 1908651568 11629248 5940496
00:57:53 93920 8192000000 10876684896 11339821056 1844282176 18.376 95 12 24 1 1856493264 9267952 2943136
00:59:33 69409 8192000000 10890347744 11354726400 1927993744 19.051 99 18 35 2 1945539248 12336784 5208720
01:00:58 58218 8192000000 10879861904 11345506304 1935223152 19.109 99 27 54 1 1963408368 20301072 7884144
01:02:25 42381 8192000000 10885838032 11356749824 1927552128 19.047 99 18 36 0 1952363520 18817136 5994256
01:03:13 25821 8192000000 10895508144 11367546880 1957529840 19.286 100 18 36 0 1981522112 18904368 5087904
01:03:48 80492 8192000000 10898239840 11385892864 1960435936 19.310 100 16 32 0 1983266304 18252336 4578032
01:05:15 86392 8192000000 10911474672 11374878720 1934470928 19.103 98 23 46 1 1951238304 10213232 6554144
01:06:51 34179 8192000000 10926712128 11394445312 1980894864 19.472 100 29 58 0 1999460032 10823024 7742144
01:07:38 74390 8192000000 10896779808 11386724352 1956021888 19.274 99 16 31 1 1974017584 13812048 4183648
01:08:58 117262 8192000000 10895184368 11367034880 1913590592 18.935 97 16 32 1 1929982432 11769824 4622016
01:11:06 40342 8192000000 10914888576 11373199360 1973632592 19.414 100 41 81 2 1994485632 9734560 11118480
01:11:54 12341 8192000000 10906768272 11375808512 1977358576 19.444 100 36 71 1 1997086272 9494048 10233648
01:12:13 30073 8192000000 10907888224 11386642432 1987572752 19.525 100 39 75 1 2006892992 8113520 11206720
01:13:07 72302 8192000000 10908477552 11395698688 1985777600 19.510 100 8 16 0 1998111488 10094496 2239392
01:14:30 58830 8192000000 10893970304 11377246208 1968663808 19.375 99 11 22 1 1985608080 13745728 3198544
01:15:39 58024 8192000000 10870058608 11355312128 1947858944 19.209 98 14 28 0 1960957312 8902880 4195488
01:16:51 47673 8192000000 10872530944 11364519936 1945325232 19.189 99 6 12 0 1953478400 6735648 1417520
01:18:04 58638 8192000000 10900052384 11389841408 1981796848 19.479 100 29 58 0 2000545968 10231280 8517840
01:20:07 82911 8192000000 10873979872 11371040768 1939090800 19.140 99 7 14 1 1956706816 15728768 1887248
01:21:38 65474 8192000000 10870885776 11347992576 1869044320 18.577 95 13 25 1 1880133136 7355408 3733408
01:23:03 80072 8192000000 10846204704 11328122880 1857678976 18.484 95 15 30 1 1875822800 13778896 4364928
01:24:29 61524 8192000000 10877218960 11346354176 1911395088 18.918 98 29 57 1 1928045088 8734960 7915040
01:25:37 69158 8192000000 10885489376 11359592448 1943432064 19.174 99 24 48 0 1960082464 9792864 6857536
01:26:56 25836 8192000000 9441806448 9738911744 573745568 6.545 29 4 8 0 579357728 4534144 1078016

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-02-2021 01:28:27 to 14-02-2021 01:28:59.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 47 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

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

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          230950
MON$OLDEST_ACTIVE               230951
MON$OLDEST_SNAPSHOT             230951
MON$NEXT_TRANSACTION            230951
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                       2023040
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:345: 
:346: mscs-test-161.budzdorov.ru    Sun Feb 14 01:27:24 2021
:347:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:348: 
:349: 
:350: mscs-test-161.budzdorov.ru    Sun Feb 14 01:27:24 2021
:351:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:352: 
:353: 
:354: mscs-test-161.budzdorov.ru    Sun Feb 14 01:27:24 2021
:355:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:356: 
:357: 
:358: mscs-test-161.budzdorov.ru    Sun Feb 14 01:27:34 2021
:359:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:360: 
--- end of diff output ---

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

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