Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.11.2020 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 17654676 kB
MemAvailable 31622548 kB
Buffers 0 kB
Cached 14013752 kB
SwapCached 2236 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 2020-11-26 01:27:04
DTS_END                         2020-11-26 01:27:04.0180
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56478
TRN_ID                          241571
ATT_ID                          680
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: 9434.14 27008 1132097
customer order: creation 171.00 359 20520
customer order: refuse 14.72 334 1766
order to supplier: creation 47.37 1262 5684
order to supplier: removal 3.67 92261 440
invoice (draft): creation 46.03 3021 5523
invoice (draft): removal 55.48 752 6658
invoice accept: apply 41.09 16734 4931
invoice accept: cancel 50.02 703 6002
customer reserve: creation 3830.08 164 459610
customer reserve: removal 4879.58 54 585549
realization accept: apply 83.38 165 10005
realization accept: cancel 81.16 100 9739
payment from customer: creation 59.26 103 7111
payment from customer: removal 5.48 70 657
payment to supplier: creation 49.77 114 5972
payment to supplier: removal 3.46 85 415
service: total inventory turnovers 4.58 1194 549
service: total monetary turnovers 7.16 21 859
service: aggregate perf. data 0.86 16198 103
service: refresh index statistics 0.03 406458 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-11-2020 01:27:53 to 26-11-2020 01:27:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5907
TEST_TIME 2 5857
TEST_TIME 3 5296
TEST_TIME 4 6258
TEST_TIME 5 6479
TEST_TIME 6 5980
TEST_TIME 7 6243
TEST_TIME 8 6608
TEST_TIME 9 7082
TEST_TIME 10 6978
TEST_TIME 11 7184
TEST_TIME 12 7357
TEST_TIME 13 8247
TEST_TIME 14 8987
TEST_TIME 15 8918
TEST_TIME 16 9507
TEST_TIME 17 9374
TEST_TIME 18 9748
TEST_TIME 19 9782
TEST_TIME 20 9723
TEST_TIME 21 9895
TEST_TIME 22 10164
TEST_TIME 23 10163
TEST_TIME 24 10267
TEST_TIME 25 11006
TEST_TIME 26 11765
TEST_TIME 27 11566
TEST_TIME 28 11568
TEST_TIME 29 11396
TEST_TIME 30 11421
TEST_TIME 31 11155
TEST_TIME 32 11100
TEST_TIME 33 10945
TEST_TIME 34 10797
TEST_TIME 35 10723
TEST_TIME 36 10471
TEST_TIME 37 10386
TEST_TIME 38 10431
TEST_TIME 39 10216
TEST_TIME 40 10133
TEST_TIME 41 9973
TEST_TIME 42 10138
TEST_TIME 43 9978
TEST_TIME 44 10171
TEST_TIME 45 10169
TEST_TIME 46 10315
TEST_TIME 47 10237
TEST_TIME 48 10171
TEST_TIME 49 10222
TEST_TIME 50 10161
TEST_TIME 51 10186
TEST_TIME 52 10291
TEST_TIME 53 10205
TEST_TIME 54 10270
TEST_TIME 55 10208
TEST_TIME 56 10248
TEST_TIME 57 10158
TEST_TIME 58 10022
TEST_TIME 59 10047
TEST_TIME 60 9926
TEST_TIME 61 9909
TEST_TIME 62 9939
TEST_TIME 63 9946
TEST_TIME 64 9839
TEST_TIME 65 9786
TEST_TIME 66 9752
TEST_TIME 67 9763
TEST_TIME 68 9730
TEST_TIME 69 9806
TEST_TIME 70 9811
TEST_TIME 71 9788
TEST_TIME 72 9824
TEST_TIME 73 9894
TEST_TIME 74 9892
TEST_TIME 75 9875
TEST_TIME 76 9910
TEST_TIME 77 9954
TEST_TIME 78 9888
TEST_TIME 79 9970
TEST_TIME 80 9886
TEST_TIME 81 9820
TEST_TIME 82 9817
TEST_TIME 83 9767
TEST_TIME 84 9730
TEST_TIME 85 9697
TEST_TIME 86 9669
TEST_TIME 87 9621
TEST_TIME 88 9558
TEST_TIME 89 9601
TEST_TIME 90 9540
TEST_TIME 91 9566
TEST_TIME 92 9592
TEST_TIME 93 9605
TEST_TIME 94 9583
TEST_TIME 95 9597
TEST_TIME 96 9696
TEST_TIME 97 9664
TEST_TIME 98 9664
TEST_TIME 99 9688
TEST_TIME 100 9685
TEST_TIME 101 9715
TEST_TIME 102 9716
TEST_TIME 103 9740
TEST_TIME 104 9731
TEST_TIME 105 9681
TEST_TIME 106 9616
TEST_TIME 107 9574
TEST_TIME 108 9560
TEST_TIME 109 9519
TEST_TIME 110 9493
TEST_TIME 111 9470
TEST_TIME 112 9439
TEST_TIME 113 9521
TEST_TIME 114 9536
TEST_TIME 115 9512
TEST_TIME 116 9534
TEST_TIME 117 9509
TEST_TIME 118 9552
TEST_TIME 119 9524
TEST_TIME 120 9447

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-11-2020 01:27:57 to 26-11-2020 01:28:00.

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 1559839 1559839 0 0.00 0 18769 6 0 0
doc_list_biud 1559839 1559839 0 0.00 0 90357 26 0 0
sp_add_invoice_to_stock 5085 4931 154 3.02 42 173225 16734 0 154
sp_cancel_adding_invoice 6002 6002 0 0.00 5 47768 704 0 0
sp_cancel_client_order 1766 1766 0 0.00 4 12150 334 0 0
sp_cancel_customer_reserve 585549 585549 0 0.00 1 44197 54 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 3231 70 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 4257 85 0 0
sp_cancel_supplier_invoice 6676 6658 18 0.26 2 90385 752 0 18
sp_cancel_supplier_order 440 440 0 0.00 6 900961 92262 0 0
sp_cancel_write_off 9739 9739 0 0.00 1 10477 101 0 0
sp_client_order 20520 20520 0 0.00 3 22409 359 0 0
sp_customer_reserve 459610 459610 0 0.00 0 70204 164 0 0
sp_fill_shopping_cart 31724 31724 0 0.00 1 14418 38 0 0
sp_fill_shopping_cart_clo_res 459597 459597 0 0.00 0 15522 14 0 0
sp_get_clo_for_invoice 4917 4917 0 0.00 0 21669 307 0 0
sp_kill_cost_storno 16813 16813 0 0.00 0 13154 50 0 0
sp_kill_qstorno_ret_qs2qd 1187935 1187935 0 0.00 0 90354 30 0 0
sp_kill_qty_storno 625076 625076 0 0.00 0 90356 64 0 0
sp_lock_selected_doc 20654 20654 0 0.00 0 11063 6 0 0
sp_make_cost_storno 28005 28005 0 0.00 0 13556 45 0 0
sp_multiply_rows_for_pdistr 28005 28005 0 0.00 0 7120 29 0 0
sp_multiply_rows_for_qdistr 20520 20520 0 0.00 0 12910 177 0 0
sp_pay_from_customer 7111 7111 0 0.00 4 9511 104 0 0
sp_pay_to_supplier 5972 5972 0 0.00 5 24393 115 0 0
sp_payment_common 13083 13083 0 0.00 1 24347 31 0 0
sp_qd_handle_on_cancel_clo 1766 1766 0 0.00 0 11125 297 0 0
sp_qd_handle_on_invoice_upd_sts 10919 10919 0 0.00 0 29780 300 0 0
sp_qd_handle_on_reserve_upd_sts 10005 10005 0 0.00 0 17923 63 0 0
sp_reserve_write_off 10005 10005 0 0.00 6 17947 166 0 0
sp_supplier_invoice 5523 5523 0 0.00 5 115836 3022 0 0
sp_supplier_order 5684 5684 0 0.00 5 74493 1262 0 0
srv_aggregate_perf_data 103 103 0 0.00 2691 106836 16199 0 0
srv_fill_mon_cache_memory 154 154 0 0.00 1855 199338 34163 0 0
srv_find_qd_qs_mism 1085383 1085383 0 0.00 0 18716 5 0 0
srv_make_invnt_saldo 549 549 0 0.00 29 89287 1194 0 0
srv_make_money_saldo 859 859 0 0.00 1 1735 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 223525 640549 406459 0 0
t$perf-abend:sp_add_invoice_to_stock 154 154 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 18 18 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4934 4934 0 0.00 0 15307 142 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 1925 67 0 0
t$perf-norm:sp_cancel_client_order 1766 1766 0 0.00 0 3365 12 0 0
t$perf-norm:sp_cancel_customer_reserve 648 648 0 0.00 0 980 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 435 1 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 407 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 557 12 0 0
t$perf-norm:sp_cancel_supplier_order 440 440 0 0.00 0 29009 1617 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 4600 15 0 0
t$perf-norm:sp_client_order 20520 20520 0 0.00 0 7526 16 0 0
t$perf-norm:sp_customer_reserve 1002 1002 0 0.00 0 724 4 0 0
t$perf-norm:sp_pay_from_customer 7111 7111 0 0.00 0 6370 11 0 0
t$perf-norm:sp_pay_to_supplier 5972 5972 0 0.00 0 11657 13 0 0
t$perf-norm:sp_reserve_write_off 10005 10005 0 0.00 0 5578 10 0 0
t$perf-norm:sp_supplier_invoice 5523 5523 0 0.00 0 6715 14 0 0
t$perf-norm:sp_supplier_order 5684 5684 0 0.00 0 5779 15 0 0
t$perf-norm:srv_aggregate_perf_data 103 103 0 0.00 0 146 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 154 154 0 0.00 0 1675 24 0 0
t$perf-norm:srv_make_invnt_saldo 549 549 0 0.00 0 6533 21 0 0
t$perf-norm:srv_make_money_saldo 859 859 0 0.00 0 1503 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10136 9828 308 3.03 0 6748 20 0 308
v_all_customers 37564 37564 0 0.00 0 18 1 0 0
v_all_suppliers 31506 31506 0 0.00 0 40 1 0 0
v_all_wares 41040 41040 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 1634 9 0 0
v_cancel_client_order 3532 3532 0 0.00 0 2340 5 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 2625 5 0 0
v_cancel_customer_reserve 1296 1296 0 0.00 0 3410 6 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 2341 13 0 0
v_cancel_supplier_invoice 890 854 36 4.04 0 1808 21 0 36
v_cancel_supplier_order 880 880 0 0.00 0 1735 6 0 0
v_cancel_write_off 1926 1926 0 0.00 0 5074 18 0 0
v_max_id_clo_ord 5684 5684 0 0.00 0 3139 3 0 0
v_max_id_clo_res 1002 1002 0 0.00 0 3344 18 0 0
v_max_id_ord_sup 5520 5520 0 0.00 0 4531 4 0 0
v_max_non_paid_invoice 1423 1423 0 0.00 0 745 3 0 0
v_max_non_paid_realizn 3710 3710 0 0.00 0 1164 3 0 0
v_min_id_clo_ord 5684 5684 0 0.00 0 4936 6 0 0
v_min_id_clo_res 1002 1002 0 0.00 0 542 2 0 0
v_min_id_ord_sup 5520 5520 0 0.00 0 4942 6 0 0
v_min_non_paid_invoice 5972 5972 0 0.00 0 24343 22 0 0
v_min_non_paid_realizn 7111 7111 0 0.00 0 9490 19 0 0
v_our_firm 10278 10278 0 0.00 0 15 1 0 0
v_reserve_write_off 20010 20010 0 0.00 0 3477 4 0 0
x_lock_depdocs_on_canc_invoice 12233 12233 0 0.00 0 19073 116 0 0
x_lock_depdocs_on_canc_sup_ord 440 440 0 0.00 0 21190 398 0 0
x_make_qstorno_1000_1200 5684 5684 0 0.00 2 74484 1187 0 0
x_make_qstorno_1200_2000 5523 5523 0 0.00 2 115706 2886 0 0
x_make_qstorno_2100_3300 459610 459610 0 0.00 0 70202 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-11-2020 01:28:01 to 26-11-2020 01:28:05.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:13 19799 8192000000 10249499040 10556096512 1030232880 11.171 81 56 111 1 1051854992 2890544 18731568
22:57:42 10524 8192000000 10306597440 10618851328 1363453456 14.268 100 78 156 0 1393641792 4208736 25979600
22:58:03 19796 8192000000 10364197504 10680942592 1404759584 14.637 100 84 168 0 1438169968 5106288 28304096
22:58:30 28561 8192000000 10401901632 10731540480 1458557536 15.113 100 86 169 2 1491489808 5629360 27302912
22:59:08 16123 8192000000 10421176400 10748514304 1477098544 15.276 100 89 177 1 1512558432 6735968 28723920
22:59:37 28574 8192000000 10435161184 10768072704 1491574576 15.403 100 87 174 2 1526672976 7177408 27920992
23:00:19 23282 8192000000 10457950704 10791702528 1510607328 15.569 100 92 184 1 1548420464 8138272 29674864
23:00:58 22916 8192000000 10485225952 10830655488 1536790432 15.796 100 80 159 1 1570857360 8973328 25093600
23:01:34 19526 8192000000 10529370752 10881179648 1580902784 16.176 100 79 159 0 1614415024 9362960 24149280
23:02:01 17439 8192000000 10547064976 10906804224 1615615536 16.473 100 80 161 1 1649470288 9853936 24000816
23:02:30 14169 8192000000 10591443280 10947391488 1646048704 16.731 100 85 167 1 1680977488 10393712 24535072
23:02:54 13326 8192000000 10598402992 10963857408 1662327792 16.869 100 80 160 2 1697810128 11806080 23676256
23:03:15 17682 8192000000 10623887840 10991759360 1682084288 17.035 100 79 154 3 1715440640 11513632 21842720
23:03:43 7789 8192000000 10635459424 11006193664 1697323008 17.163 100 74 148 0 1730438672 11524816 21590848
23:04:03 12924 8192000000 10668936672 11039215616 1720762608 17.359 100 75 150 2 1754197712 11834592 21600512
23:04:23 9940 8192000000 10666385888 11046817792 1730196064 17.437 100 79 158 2 1765288224 12558912 22533248
23:04:42 9185 8192000000 10688333808 11060637696 1746178416 17.570 100 78 157 2 1780647712 12570432 21898864
23:04:58 6191 8192000000 10698504224 11080093696 1761976400 17.701 100 78 155 0 1795742240 12183776 21582064
23:05:11 5393 8192000000 10699127584 11079999488 1771148128 17.776 100 87 174 5 1808124688 12682448 24294112
23:05:24 7418 8192000000 10713576464 11095851008 1778919232 17.841 100 72 144 2 1811352624 12507984 19925408
23:05:39 6171 8192000000 10727094208 11109535744 1786946240 17.907 100 83 166 2 1823669920 13817776 22905904
23:05:58 5573 8192000000 10728063440 11113549824 1791561136 17.945 100 73 144 1 1824909808 13683872 19664800
23:06:11 3257 8192000000 10751628672 11136180224 1811446144 18.108 100 88 177 3 1850356368 13366416 25543808
23:06:21 3438 8192000000 10755631808 11139891200 1816232208 18.147 100 80 158 3 1852336256 13063888 23040160
23:06:31 3473 8192000000 10763360928 11148382208 1824307344 18.213 100 90 181 1 1863468640 13870288 25291008
23:06:41 3361 8192000000 10764603168 11153838080 1826531008 18.231 100 85 170 1 1864608688 14445072 23632608
23:06:52 2584 8192000000 10775255152 11162509312 1833948688 18.292 100 90 180 0 1873466624 14410352 25107584
23:07:02 2195 8192000000 10782406928 11167416320 1840284896 18.343 100 87 174 2 1877689440 13159712 24244832
23:07:10 1842 8192000000 10787866816 11174752256 1844315328 18.376 100 84 168 2 1881963632 14593888 23054416
23:07:18 1699 8192000000 10788937424 11176017920 1850438512 18.426 100 92 183 1 1891523520 14282592 26802416
23:07:27 1588 8192000000 10795137760 11182362624 1851974800 18.438 100 92 184 1 1892660608 14795648 25890160
23:07:35 2666 8192000000 10796274112 11184066560 1854222848 18.456 100 89 178 2 1894496032 15112528 25160656
23:07:44 2323 8192000000 10801288464 11189800960 1858708128 18.493 100 97 194 1 1902103712 15919760 27475824
23:07:53 1505 8192000000 10808712992 11194097664 1859030368 18.495 100 95 193 3 1900947792 15096320 26821104
23:08:01 2677 8192000000 10807589184 11201003520 1864853728 18.543 100 88 175 2 1903238000 13525168 24859104
23:08:10 1367 8192000000 10820428416 11206881280 1870156224 18.586 100 91 182 2 1909712928 13759536 25797168
23:08:18 2054 8192000000 10816860384 11208601600 1873917712 18.616 100 83 166 1 1909816768 11895520 24003536
23:08:26 26194 8192000000 10784301760 11205832704 1870327584 18.587 100 55 110 1 1896113136 10049888 15735664
23:08:58 5405 8192000000 10797202224 11208060928 1872268480 18.603 100 44 89 1 1891341680 6083520 12989680
23:09:10 3365 8192000000 10796778272 11207331840 1873099472 18.609 100 42 83 1 1892782800 7059424 12623904
23:09:20 6403 8192000000 10791196816 11210117120 1876988304 18.641 100 41 80 0 1896713808 8834832 10890672
23:09:34 8227 8192000000 10777027376 11209338880 1875403120 18.628 100 19 38 0 1887423072 6459184 5560768
23:09:49 6767 8192000000 10800463056 11222167552 1880630256 18.670 100 30 59 2 1903224416 14052624 8541536
23:10:04 7249 8192000000 10792594144 11220656128 1882677072 18.687 100 26 52 1 1897753312 7599840 7476400
23:10:18 14242 8192000000 10789315616 11224395776 1884679280 18.703 100 14 28 0 1894598304 6299872 3619152
23:10:39 11073 8192000000 10791149952 11228766208 1890842096 18.753 100 22 45 3 1903880256 6980576 6057584
23:10:59 4559 8192000000 10799503632 11233075200 1893716832 18.776 100 16 32 0 1903738960 5361376 4660752
23:11:11 6269 8192000000 10818251792 11237736448 1900497776 18.830 100 37 76 1 1917671408 6979904 10193728
23:11:24 5518 8192000000 10829858608 11241246720 1900641280 18.831 100 50 103 1 1920888144 5174096 15072768
23:11:37 72627 8192000000 10811422736 11243761664 1902155904 18.844 100 36 72 3 1918012336 4804560 11051872
23:12:57 8824 8192000000 10810744224 11248189440 1900560272 18.831 100 18 35 2 1911662208 5195584 5906352
23:13:13 4974 8192000000 10818577760 11250528256 1905882304 18.874 100 39 78 2 1924807248 7636064 11288880
23:13:25 5361 8192000000 10825171088 11252416512 1906326016 18.877 100 34 69 0 1922539728 6953696 9260016
23:13:38 5427 8192000000 10816426672 11252379648 1905768048 18.873 100 30 60 0 1920837984 6461856 8608080
23:13:52 7221 8192000000 10820952064 11256479744 1905597872 18.871 100 15 29 1 1915305456 5814384 3893200
23:14:06 3894 8192000000 10819877632 11259260928 1908604848 18.895 100 27 55 1 1923289520 6775760 7908912
23:14:16 6594 8192000000 10823190096 11256287232 1905906048 18.874 100 14 28 0 1914971680 5280608 3785024
23:14:30 6523 8192000000 10815529184 11258429440 1908327840 18.893 100 19 38 0 1919755296 6314144 5113312
23:14:43 5419 8192000000 10824100384 11261759488 1911465408 18.918 100 27 54 1 1925870224 6869136 7535680
23:14:56 5468 8192000000 10828725632 11259633664 1907273312 18.885 100 33 66 1 1923837616 6920560 9643744
23:15:10 7662 8192000000 10810599264 11250581504 1899994368 18.826 100 16 32 0 1910254880 5810048 4450464
23:15:27 19233 8192000000 10813940928 11248898048 1888685168 18.735 99 20 40 0 1900477296 6212560 5579568
23:15:52 11715 8192000000 10806775632 11242786816 1883602512 18.694 99 15 30 0 1893117888 4953104 4562272
23:16:10 13150 8192000000 10801419696 11221049344 1860693168 18.509 98 18 36 3 1870345296 4769744 4882384
23:16:29 63083 8192000000 10783797072 11213316096 1832144496 18.277 97 32 63 3 1846332800 4993424 9194880
23:17:45 9751 8192000000 10760157360 11188342784 1794557536 17.969 96 28 56 0 1812343504 10054864 7731104
23:18:02 4666 8192000000 10780202336 11210526720 1847322032 18.400 99 28 56 0 1861234864 6049216 7863616
23:18:14 4570 8192000000 10763360960 11186176000 1807117376 18.072 97 30 58 2 1826267168 10822160 8327632
23:18:27 5694 8192000000 10761913440 11188359168 1832686144 18.281 99 27 54 3 1846936272 5616928 8633200
23:18:40 7857 8192000000 10720890832 11138650112 1737323168 17.496 94 27 54 1 1751071904 5306432 8442304
23:18:56 7240 8192000000 10680347760 11091992576 1703511488 17.214 93 25 48 2 1716552816 6504256 6537072
23:19:11 6268 8192000000 10744369312 11163496448 1819941056 18.177 100 22 43 1 1832569152 6760176 5867920
23:19:26 9824 8192000000 10689920016 11101126656 1695145728 17.144 94 32 64 2 1711027840 6159376 9722736
23:19:43 6440 8192000000 10710445792 11123208192 1771506320 17.779 99 31 62 2 1786905840 5468320 9931200
23:19:56 8628 8192000000 10711400832 11121246208 1727941072 17.418 96 27 54 2 1741619664 5207664 8470928
23:20:11 11270 8192000000 10729433312 11149225984 1777512112 17.829 98 26 50 2 1789833904 4856032 7465760
23:20:29 9733 8192000000 10722310400 11135234048 1761266352 17.695 98 21 42 0 1772263968 5133712 5863904
23:20:46 11802 8192000000 10720281904 11120635904 1735181408 17.479 96 17 34 0 1745518272 5654368 4682496
23:21:05 57772 8192000000 10705132304 11133423616 1776626368 17.822 98 35 70 0 1792792912 5315120 10851424
23:22:12 12558 8192000000 10704307008 11118723072 1722693152 17.375 95 35 70 1 1738900992 6259968 9947872
23:22:32 5673 8192000000 10728183888 11140739072 1806225024 18.065 100 29 59 2 1821046112 5989024 8832064
23:22:46 7066 8192000000 10736395856 11150811136 1802976880 18.038 99 40 81 0 1821697472 7710592 11010000
23:22:59 8333 8192000000 10735141552 11152523264 1801621536 18.027 99 22 44 1 1813863632 6250064 5992032
23:23:15 3939 8192000000 10747424288 11169382400 1833418272 18.287 100 48 97 1 1854402032 7119088 13864672
23:23:25 6541 8192000000 10749474176 11174535168 1839198640 18.334 100 28 56 0 1853605520 5824080 8582800
23:23:40 7357 8192000000 10756390880 11180244992 1841865456 18.356 100 21 42 1 1853085168 5254800 5964912
23:23:57 6225 8192000000 10751835408 11183874048 1847058896 18.398 100 20 40 0 1858416496 5726400 5631200
23:24:13 7980 8192000000 10776573152 11193683968 1853255648 18.449 100 26 52 0 1870853136 9835248 7762240
23:24:32 9938 8192000000 10763409648 11192356864 1855433072 18.466 100 20 40 0 1871019664 10019232 5567360
23:24:51 6208 8192000000 10770232912 11198238720 1857258960 18.481 100 15 30 0 1866518352 5003008 4256384
23:25:03 7557 8192000000 10781611312 11205107712 1859814112 18.502 100 21 40 4 1870958944 5651040 5493792
23:25:23 6256 8192000000 10781196688 11212980224 1867630240 18.565 100 23 47 0 1879824240 5396480 6797520
23:25:39 63713 8192000000 10782262240 11213185024 1871328128 18.595 100 27 54 1 1885098880 5933792 7836960
23:26:51 9126 8192000000 10790505424 11221147648 1875586624 18.629 100 20 40 1 1887102720 5873904 5642192
23:27:08 35209 8192000000 10828954624 11242622976 1895937200 18.794 100 48 96 1 1916153968 7133664 13083104
23:27:57 33854 8192000000 10843781216 11267452928 1913019136 18.931 100 52 104 1 1937034288 9124400 14890752
23:28:41 28476 8192000000 10847170272 11279839232 1921508080 18.999 100 29 58 1 1939048352 8779616 8760656
23:29:21 51071 8192000000 10867965648 11294949376 1935818624 19.113 100 35 70 2 1959092608 13155152 10118832
23:30:32 21062 8192000000 10885114784 11315863552 1949128848 19.220 100 38 76 0 1974653312 13866368 11658096
23:31:14 24084 8192000000 10901069344 11325370368 1942063744 19.163 99 38 76 0 1967833824 14233728 11536352
23:31:54 16664 8192000000 10891531424 11325620224 1956811744 19.281 100 37 74 1 1984484416 15904704 11767968
23:32:23 17549 8192000000 10894252928 11330715648 1961669392 19.319 100 39 78 1 1988635520 14608656 12357472
23:32:48 5281 8192000000 10909820816 11337904128 1968079888 19.370 100 50 98 0 1996409776 12637872 15692016
23:33:06 9533 8192000000 10938677008 11352313856 1974460896 19.421 100 55 111 2 2010023056 18677632 16884528
23:33:30 32186 8192000000 10923153968 11358588928 1975408816 19.428 100 40 80 1 2010250288 22941840 11899632
23:34:12 16347 8192000000 10920140144 11359801344 1980431728 19.468 100 47 90 3 2014689344 20200048 14057568
23:34:40 4436 8192000000 10932898672 11362844672 1985432368 19.508 100 51 102 3 2019115728 17803968 15879392
23:34:53 6261 8192000000 10936587344 11365289984 1987790672 19.526 100 51 103 2 2021848896 18680768 15377456
23:35:07 8245 8192000000 10940779008 11373506560 1995102384 19.584 100 57 112 3 2031689264 20282912 16303968
23:35:22 3289 8192000000 10947428976 11379396608 1999092928 19.616 100 55 108 0 2036300080 21217232 15989920
23:35:36 7999 8192000000 10952127792 11374219264 1983361584 19.491 99 69 134 1 2026209760 22366864 20481312
23:35:50 3001 8192000000 10946611024 11369431040 1994253024 19.577 100 81 159 1 2039171184 21297296 23620864
23:36:01 4205 8192000000 10945214112 11373883392 1996952720 19.599 100 64 128 0 2037881008 21887424 19040864
23:36:12 3204 8192000000 10959197760 11384954880 2005416224 19.665 100 81 160 1 2053956016 23748576 24791216
23:36:24 3523 8192000000 10968022960 11393585152 2010840240 19.708 100 86 173 3 2061911568 24305248 26766080
23:36:37 4500 8192000000 10967409312 11395710976 2011263936 19.711 100 73 146 1 2056712528 23813088 21635504
23:36:54 3085 8192000000 10960635632 11391942656 2012315200 19.720 100 62 121 3 2052773440 21382688 19075552
23:37:05 2379 8192000000 10980418928 11403264000 2021868784 19.795 100 80 158 1 2066185104 21173104 23143216
23:37:14 2932 8192000000 10985528480 11397300224 2014657344 19.738 100 86 175 1 2063472224 22984352 25830528
23:37:24 6886 8192000000 10984351296 11401052160 2018344224 19.767 100 79 157 0 2066403328 24572976 23486128
23:37:38 6538 8192000000 10966821456 11392872448 1996577408 19.596 99 70 140 1 2043352384 25897824 20877152
23:37:53 14391 8192000000 10967671072 11399561216 2009405216 19.697 100 63 126 0 2054941888 26186688 19349984
23:38:17 5295 8192000000 10968021040 11397840896 2007659472 19.683 100 63 126 0 2054667840 27369456 19638912
23:38:33 6791 8192000000 10948805088 11382456320 1994269728 19.578 100 56 113 0 2040579984 28193104 18117152
23:38:49 5590 8192000000 10948864960 11382579200 1983056480 19.489 99 61 122 2 2030187792 27935904 19195408
23:39:01 6707 8192000000 10966522016 11396816896 2002817312 19.645 100 59 118 2 2050303408 29266336 18219760
23:39:15 3016 8192000000 10965058560 11394142208 1994374064 19.578 100 60 120 1 2048514112 34873840 19266208
23:39:25 2319 8192000000 10961073856 11378806784 1985561296 19.509 99 77 153 1 2038455248 29512112 23381840
23:39:34 3375 8192000000 10964045824 11386441728 1998470000 19.611 100 82 161 0 2054276112 30930224 24875888
23:39:44 7195 8192000000 10948453504 11376459776 1966434576 19.357 99 72 142 1 2018846032 30821360 21590096
23:40:00 6437 8192000000 10942166800 11367096320 1963424800 19.333 99 67 133 0 2018386368 34230288 20731280
23:40:15 2524 8192000000 10937318608 11372662784 1981351824 19.475 100 51 104 1 2029704176 31353632 16998720
23:40:26 1855 8192000000 10932613856 11341099008 1953830928 19.257 100 79 158 3 2007683536 29359776 24492832
23:40:34 2982 8192000000 10935834816 11351453696 1966483312 19.358 100 90 181 0 2024679520 30528160 27668048
23:40:44 5798 8192000000 10929453984 11342884864 1954160736 19.260 100 80 160 1 2011716064 33508432 24046896
23:40:59 3653 8192000000 10939154512 11356405760 1947374432 19.206 99 75 149 1 2001488592 31560400 22553760
23:41:10 2850 8192000000 10948955392 11366039552 1979174320 19.458 100 82 164 1 2034259280 30243504 24841456
23:41:21 3525 8192000000 10895837136 11301990400 1905732384 18.872 97 79 157 1 1960087408 30535168 23819856
23:41:33 2074 8192000000 10926427440 11348357120 1962270528 19.324 100 78 155 0 2016752960 29899888 24582544
23:41:43 8416 8192000000 10910530384 11357122560 1969346208 19.380 100 39 78 3 2009668544 28608288 11714048
23:42:01 4493 8192000000 10885137104 11316985856 1925012352 19.027 99 41 81 1 1970864976 33188448 12664176
23:42:13 7155 8192000000 10894592512 11320832000 1935576256 19.111 100 40 76 0 1975868912 28104064 12188592
23:42:28 4813 8192000000 10915080368 11336646656 1949969344 19.226 100 63 125 3 1999434240 30045328 19419568
23:42:40 2156 8192000000 10952419280 11365040128 1972616224 19.406 100 89 178 0 2034080592 33359712 28104656
23:42:48 4679 8192000000 10915581248 11337506816 1921719056 19.001 98 58 116 0 1975989280 35844576 18425648
23:43:04 9281 8192000000 10893646976 11326877696 1936328672 19.117 100 44 88 0 1985834112 35088864 14416576
23:43:22 5594 8192000000 10905196320 11331665920 1937202176 19.124 100 49 97 0 1988734752 35742976 15789600
23:43:35 9598 8192000000 10910507488 11343015936 1943029152 19.171 100 37 70 3 1989160816 34542928 11588736
23:43:52 13877 8192000000 10887411024 11317510144 1870927088 18.592 96 44 84 4 1915427872 31068128 13432656
23:44:14 2437 8192000000 10899835568 11313647616 1904907744 18.866 99 71 142 0 1961233584 34325680 22000160
23:44:26 10474 8192000000 10910499568 11329355776 1925749328 19.033 100 62 124 2 1986324640 42367616 18207696
23:44:46 3284 8192000000 10921802048 11334262784 1933718448 19.097 99 81 157 4 2000707024 43135056 23853520
23:44:55 3037 8192000000 10935983344 11343613952 1946614656 19.200 99 85 168 4 2017446480 44918784 25913040
23:45:06 9406 8192000000 10923102720 11354636288 1954195472 19.260 100 45 90 1 2006246608 37052752 14998384
23:45:24 14500 8192000000 10913329472 11356602368 1943826480 19.177 99 38 76 1 1995854848 39062704 12965664
23:45:49 4999 8192000000 10923142176 11348414464 1938391936 19.134 99 47 93 1 1991521600 38491616 14638048
23:46:09 5976 8192000000 10921410416 11357466624 1938243408 19.133 99 42 84 1 1991788656 39610528 13934720
23:46:23 13126 8192000000 10918975488 11362603008 1956118768 19.275 100 29 58 1 2002669440 36977440 9573232
23:46:43 11515 8192000000 10900829104 11342213120 1929491824 19.063 99 31 62 3 1977122336 37396896 10233616
23:47:24 19377 8192000000 10907116144 11342917632 1933105488 19.092 100 40 80 0 1990358704 43824304 13428912
23:47:54 12568 8192000000 10894835344 11338072064 1921433152 18.998 99 30 60 1 1974694448 43528208 9733088
23:48:15 11170 8192000000 10903353648 11345694720 1943104176 19.172 100 31 62 0 1991702384 37797200 10801008
23:48:40 10359 8192000000 10920186288 11361865728 1954351056 19.261 100 31 62 1 2002950768 38341360 10258352
23:49:08 13195 8192000000 10925205312 11368337408 1957892544 19.289 100 26 53 2 2008570432 41722992 8954896
23:49:30 12402 8192000000 10929408560 11370901504 1956323392 19.277 100 31 61 2 2012372192 45245424 10803376
23:50:06 15011 8192000000 10926887968 11378081792 1955451328 19.270 100 29 58 0 2010715152 44809648 10454176
23:50:51 14199 8192000000 10924225968 11379363840 1953671536 19.256 100 22 44 0 2009124368 47367920 8084912
23:51:12 13221 8192000000 10927549200 11377926144 1954445120 19.262 100 31 60 3 2012676560 47392208 10839232
23:51:32 21693 8192000000 10917573296 11371311104 1933780528 19.097 99 29 57 1 1988496304 44478256 10237520
23:52:01 25122 8192000000 10908848960 11371474944 1925389360 19.030 99 23 46 2 1983011632 49015296 8606976
23:52:36 22650 8192000000 10901527360 11371896832 1937907952 19.130 100 17 35 1 1991896896 47766992 6221952
23:53:05 9382 8192000000 10874022416 11333967872 1900100576 18.827 98 15 29 2 1934517216 29023632 5393008
23:53:21 10362 8192000000 10878789760 11339599872 1926452064 19.038 100 14 28 1 1958134400 27243904 4438432
23:53:47 28594 8192000000 10867868256 11334414336 1930605712 19.072 100 11 22 0 1954461328 20167120 3688496
23:54:22 45518 8192000000 10895492656 11327758336 1924661664 19.024 99 42 85 2 1950309360 14475936 11171760
23:55:14 19869 8192000000 10899129472 11325755392 1939862352 19.146 100 58 114 2 1969167776 13112624 16192800
23:55:46 13627 8192000000 10871115264 11316781056 1928987200 19.059 99 48 96 0 1955020304 11838752 14194352
23:56:20 48159 8192000000 10845209744 11297677312 1905986784 18.874 98 40 78 5 1926449664 9925600 10537280
23:57:25 32244 8192000000 10848809344 11317628928 1916252736 18.957 99 8 16 0 1929818864 11292288 2273840
23:58:05 78717 8192000000 10864804992 11327770624 1921749936 19.001 99 8 17 0 1931917328 8269472 1897920
23:59:34 122645 8192000000 10885348928 11345100800 1932982144 19.091 99 16 32 1 1944897984 7893008 4022832
00:01:43 199337 8192000000 10902470576 11355459584 1933223648 19.093 98 26 52 1 1954122800 12846288 8052864
00:05:11 82527 8192000000 10911144928 11379056640 1975760576 19.431 100 16 32 0 1992447408 11780208 4906624
00:06:42 14719 8192000000 10913936048 11377717248 1989322016 19.538 100 27 52 4 2011009520 14195856 7491648
00:07:04 17659 8192000000 10928741120 11390849024 1994232880 19.577 100 33 66 4 2018559696 14208048 10118768
00:07:49 49064 8192000000 10931225360 11403841536 1999275744 19.617 100 19 38 1 2026082048 20309424 6496880
00:08:44 59439 8192000000 10919735184 11404951552 1978235632 19.451 99 32 64 0 2017938144 28975872 10726640
00:10:06 52534 8192000000 10928893600 11408244736 1989519104 19.540 100 17 34 1 2022337120 27284432 5533584
00:11:06 38556 8192000000 10931822208 11417657344 1996782960 19.597 100 15 30 0 2023812352 21934624 5094768
00:11:53 87718 8192000000 10908762832 11403714560 1948347744 19.213 98 13 27 1 1971753168 19832176 3573248
00:13:45 133787 8192000000 10908501680 11374419968 1911087184 18.915 96 15 30 1 1924602448 9659344 3855920
00:16:05 128235 8192000000 10922433184 11402399744 1971113328 19.394 99 18 36 2 1989293520 13300960 4879232
00:18:33 117423 8192000000 10934569552 11408252928 1980062080 19.465 99 14 28 0 1993209600 9595872 3551648
00:20:44 50824 8192000000 10916639152 11372990464 1890858016 18.753 94 37 74 2 1921070480 19391376 10821088
00:21:46 57099 8192000000 10888463536 11356045312 1894012480 18.778 96 18 36 0 1912123968 13221296 4890192
00:22:52 146827 8192000000 10867831472 11338493952 1854874144 18.462 94 11 22 0 1869753968 11337056 3542768
00:25:48 107829 8192000000 10908823152 11357466624 1848849680 18.413 94 23 46 1 1871430384 16586128 5994576
00:27:44 39520 8192000000 10892923152 11346313216 1922779760 19.009 98 34 68 1 1952787712 20809552 9198400
00:28:30 11795 8192000000 10845560272 11312377856 1919822464 18.985 99 15 30 2 1936185248 12354912 4007872
00:28:47 23716 8192000000 10870265984 11317628928 1883711152 18.695 97 26 52 0 1901145088 9898256 7535680
00:29:29 34596 8192000000 10860908496 11340673024 1946927360 19.202 100 22 44 0 1963945104 10489248 6528496
00:30:13 22216 8192000000 10862254416 11325374464 1938539952 19.135 100 11 21 0 1947148848 6020224 2588672
00:30:54 82411 8192000000 10851768416 11313168384 1891693664 18.759 97 12 23 0 1902318128 7686416 2938048
00:34:02 40956 8192000000 10868148352 11326701568 1872698432 18.606 96 9 18 0 1884444128 8683120 3062576
00:34:51 32706 8192000000 10863864336 11322732544 1924226704 19.021 99 34 66 3 1941190752 7443360 9520688
00:35:35 52707 8192000000 10841951856 11311206400 1842026688 18.357 95 29 59 1 1861956576 11179888 8750000
00:37:18 55985 8192000000 10851672432 11315929088 1881640464 18.678 97 22 44 1 1901977680 13915648 6421568
00:38:49 94074 8192000000 10860370800 11349630976 1908961536 18.898 98 20 40 1 1928235392 13184448 6089408
00:40:33 40007 8192000000 10863316000 11320758272 1901003264 18.834 98 16 32 1 1915215328 9310448 4901616
00:41:31 49702 8192000000 10853153712 11304136704 1825197184 18.220 94 28 54 1 1843394208 10881328 7315696
00:42:30 27082 8192000000 10855795792 11304599552 1886841440 18.720 98 45 90 2 1909896304 10235520 12819344
00:43:12 35113 8192000000 10852550528 11308834816 1894360832 18.781 99 34 67 1 1919766624 15331632 10074160
00:44:00 79573 8192000000 10869917728 11304366080 1896946704 18.802 98 20 38 0 1912865584 10550192 5368688
00:45:26 11344 8192000000 10871876848 11316015104 1906925824 18.882 99 36 73 2 1925381296 8725824 9729648
00:45:44 63087 8192000000 10846833072 11308769280 1874538592 18.621 97 26 52 1 1895021168 13225792 7256784
00:47:01 110460 8192000000 10861928960 11323125760 1917394368 18.966 99 24 48 1 1934659952 10494496 6771088
00:49:01 59641 8192000000 10882342160 11343675392 1882480720 18.685 97 30 60 3 1908872144 18431296 7960128
00:50:07 40704 8192000000 10866123568 11346575360 1936529824 19.119 100 15 30 0 1965085392 24389632 4165936
00:51:23 49284 8192000000 10850959024 11327545344 1918706032 18.976 99 14 28 2 1938307840 15749760 3852048
00:52:21 64410 8192000000 10839667296 11301761024 1881870240 18.680 97 19 38 0 1894103056 6982912 5249904
00:53:42 55440 8192000000 10862566320 11326599168 1910374992 18.910 98 17 34 0 1927937616 12041904 5520720
00:54:49 61752 8192000000 10872907888 11337916416 1919356976 18.982 99 13 24 1 1937757456 14822832 3577648
00:56:02 63333 8192000000 10859856304 11343691776 1921691344 19.000 99 12 24 0 1939668016 14803792 3172880
00:57:34 72605 8192000000 10888483504 11364478976 1955483120 19.270 100 13 27 0 1972995216 14110592 3401504
00:58:57 59452 8192000000 10882756320 11362148352 1913662480 18.936 97 10 20 2 1932632752 16639296 2330976
01:00:03 47591 8192000000 10877162320 11353587712 1940389040 19.150 99 15 30 0 1952363376 8309328 3665008
01:00:59 34175 8192000000 10912950976 11371806720 1975202432 19.427 100 23 46 0 1989746240 8437888 6105920
01:01:39 36216 8192000000 10907805728 11365675008 1949005152 19.219 98 38 76 0 1970032368 10369152 10658064
01:02:25 54231 8192000000 10912956352 11396845568 1978193792 19.450 100 26 51 1 2002450720 17143984 7112944
01:03:26 90489 8192000000 10914708576 11386081280 1943582592 19.175 98 12 24 0 1957474512 10570656 3321264
01:05:12 49801 8192000000 10920995808 11391549440 1989270608 19.538 100 8 16 0 2002880816 11010720 2599488
01:06:11 19898 8192000000 10935627984 11397140480 1998329808 19.610 100 24 48 0 2013333120 8769296 6234016
01:06:39 42443 8192000000 10929925808 11400740864 1998074064 19.608 100 32 64 0 2019740880 12907792 8759024
01:07:27 61465 8192000000 10942286512 11407773696 1983365808 19.491 99 26 52 1 2011132048 21068800 6697440
01:08:49 80058 8192000000 10928904640 11384160256 1921560000 18.999 96 21 42 0 1938926064 11642720 5723344
01:10:21 73546 8192000000 10903816976 11364622336 1916631696 18.960 96 29 58 1 1936003536 11134464 8237376
01:11:47 117006 8192000000 10914920256 11379621888 1968125296 19.371 99 20 41 0 1983128256 8857840 6145120
01:13:54 76597 8192000000 10895112512 11363217408 1913386208 18.934 96 17 34 0 1927148976 8765760 4997008
01:15:18 76511 8192000000 10893648480 11369078784 1928408848 19.054 97 28 56 2 1951977056 14900576 8667632
01:16:57 55595 8192000000 10877411536 11358822400 1954263936 19.260 99 8 16 0 1977509456 20695024 2550496
01:18:27 56675 8192000000 10863149952 11335507968 1896274144 18.796 96 8 16 0 1912828960 14298752 2256064
01:19:37 75088 8192000000 10894417472 11372916736 1932798288 19.089 99 10 20 0 1949967904 14196208 2973408
01:22:11 64224 8192000000 10877717024 11347488768 1892719360 18.768 97 13 24 2 1907734528 11772576 3242592
01:23:22 35630 8192000000 10868072960 11339489280 1898672848 18.816 97 19 38 0 1915089824 11056912 5360064
01:24:04 40969 8192000000 10902561360 11350433792 1919372848 18.982 98 39 74 1 1941101456 11360624 10367984
01:24:54 41826 8192000000 10889106080 11342008320 1872866752 18.607 96 19 38 1 1891200752 13024288 5309712
01:25:45 38532 8192000000 10828123952 11278151680 1764909872 17.725 91 26 52 0 1781220880 9446656 6864352
01:26:35 18011 8192000000 10833121984 11277852672 1857287824 18.481 97 37 74 2 1877217712 9447728 10482160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 26-11-2020 01:28:07 to 26-11-2020 01:28:38.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-11-2020 01:28:38 to 26-11-2020 01:28:40.

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          241852
MON$OLDEST_ACTIVE               241853
MON$OLDEST_SNAPSHOT             241853
MON$NEXT_TRANSACTION            241853
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                       2015232
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:245: 
:246: mscs-test-161.budzdorov.ru    Thu Nov 26 01:27:16 2020
:247:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:248: 
:249: 
:250: mscs-test-161.budzdorov.ru    Thu Nov 26 01:27:17 2020
:251:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:252: 
--- end of diff output ---

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

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