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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17115228 kB
MemAvailable 31239024 kB
Buffers 0 kB
Cached 14601936 kB
SwapCached 4876 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-06 19:27:16
DTS_END                         2021-02-06 19:27:16.8700
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38882
TRN_ID                          240514
ATT_ID                          692
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: 9397.68 24307 1127722
customer order: creation 171.43 340 20572
customer order: refuse 14.88 351 1785
order to supplier: creation 46.01 1246 5521
order to supplier: removal 3.62 89781 434
invoice (draft): creation 46.08 3171 5529
invoice (draft): removal 53.83 706 6459
invoice accept: apply 41.65 19096 4998
invoice accept: cancel 49.15 689 5898
customer reserve: creation 3878.19 188 465383
customer reserve: removal 4789.96 52 574795
realization accept: apply 83.28 173 9993
realization accept: cancel 91.08 106 10929
payment from customer: creation 59.28 124 7114
payment from customer: removal 5.53 98 664
payment to supplier: creation 48.85 116 5862
payment to supplier: removal 3.53 61 424
service: total inventory turnovers 4.62 1331 554
service: total monetary turnovers 5.97 32 716
service: aggregate perf. data 0.73 27258 88
service: refresh index statistics 0.03 341230 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 06-02-2021 19:28:56 to 06-02-2021 19:28:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7176
TEST_TIME 2 6169
TEST_TIME 3 5702
TEST_TIME 4 5711
TEST_TIME 5 5371
TEST_TIME 6 5319
TEST_TIME 7 5633
TEST_TIME 8 5609
TEST_TIME 9 5497
TEST_TIME 10 5749
TEST_TIME 11 6190
TEST_TIME 12 6395
TEST_TIME 13 6588
TEST_TIME 14 7271
TEST_TIME 15 7121
TEST_TIME 16 7631
TEST_TIME 17 7677
TEST_TIME 18 8128
TEST_TIME 19 8245
TEST_TIME 20 8798
TEST_TIME 21 8704
TEST_TIME 22 9255
TEST_TIME 23 9549
TEST_TIME 24 9687
TEST_TIME 25 10024
TEST_TIME 26 10725
TEST_TIME 27 10872
TEST_TIME 28 10945
TEST_TIME 29 10832
TEST_TIME 30 10806
TEST_TIME 31 10821
TEST_TIME 32 10736
TEST_TIME 33 10730
TEST_TIME 34 10450
TEST_TIME 35 10227
TEST_TIME 36 10454
TEST_TIME 37 10222
TEST_TIME 38 10196
TEST_TIME 39 10105
TEST_TIME 40 10040
TEST_TIME 41 10258
TEST_TIME 42 10118
TEST_TIME 43 9976
TEST_TIME 44 9930
TEST_TIME 45 9823
TEST_TIME 46 9668
TEST_TIME 47 9896
TEST_TIME 48 9773
TEST_TIME 49 9707
TEST_TIME 50 9779
TEST_TIME 51 9785
TEST_TIME 52 9823
TEST_TIME 53 9722
TEST_TIME 54 9734
TEST_TIME 55 9749
TEST_TIME 56 9979
TEST_TIME 57 9945
TEST_TIME 58 9946
TEST_TIME 59 9928
TEST_TIME 60 10029
TEST_TIME 61 10094
TEST_TIME 62 10178
TEST_TIME 63 10163
TEST_TIME 64 10136
TEST_TIME 65 10006
TEST_TIME 66 9986
TEST_TIME 67 9900
TEST_TIME 68 9941
TEST_TIME 69 9872
TEST_TIME 70 9844
TEST_TIME 71 9807
TEST_TIME 72 9755
TEST_TIME 73 9742
TEST_TIME 74 9786
TEST_TIME 75 9853
TEST_TIME 76 9805
TEST_TIME 77 9989
TEST_TIME 78 9990
TEST_TIME 79 9969
TEST_TIME 80 9941
TEST_TIME 81 10003
TEST_TIME 82 10000
TEST_TIME 83 9978
TEST_TIME 84 9882
TEST_TIME 85 9882
TEST_TIME 86 9822
TEST_TIME 87 9802
TEST_TIME 88 9812
TEST_TIME 89 9835
TEST_TIME 90 9788
TEST_TIME 91 9751
TEST_TIME 92 9680
TEST_TIME 93 9608
TEST_TIME 94 9668
TEST_TIME 95 9703
TEST_TIME 96 9689
TEST_TIME 97 9676
TEST_TIME 98 9752
TEST_TIME 99 9705
TEST_TIME 100 9692
TEST_TIME 101 9678
TEST_TIME 102 9698
TEST_TIME 103 9726
TEST_TIME 104 9790
TEST_TIME 105 9816
TEST_TIME 106 9784
TEST_TIME 107 9795
TEST_TIME 108 9776
TEST_TIME 109 9705
TEST_TIME 110 9682
TEST_TIME 111 9641
TEST_TIME 112 9618
TEST_TIME 113 9631
TEST_TIME 114 9594
TEST_TIME 115 9561
TEST_TIME 116 9523
TEST_TIME 117 9495
TEST_TIME 118 9501
TEST_TIME 119 9446
TEST_TIME 120 9407

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 06-02-2021 19:28:59 to 06-02-2021 19:29:03.

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 1556718 1556718 0 0.00 0 25914 6 0 0
doc_list_biud 1556718 1556718 0 0.00 0 76983 25 0 0
sp_add_invoice_to_stock 5153 4998 155 3.00 22 206241 19097 0 155
sp_cancel_adding_invoice 5898 5898 0 0.00 3 66181 689 0 0
sp_cancel_client_order 1785 1785 0 0.00 4 21480 352 0 0
sp_cancel_customer_reserve 574795 574795 0 0.00 1 76985 52 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 3 11200 98 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 4497 61 0 0
sp_cancel_supplier_invoice 6470 6459 11 0.17 2 25170 707 0 11
sp_cancel_supplier_order 434 434 0 0.00 5 1070971 89782 0 0
sp_cancel_write_off 10929 10929 0 0.00 1 19735 106 0 0
sp_client_order 20572 20572 0 0.00 3 24368 341 0 0
sp_customer_reserve 465383 465383 0 0.00 0 79080 189 0 0
sp_fill_shopping_cart 31617 31617 0 0.00 1 13045 36 0 0
sp_fill_shopping_cart_clo_res 465366 465366 0 0.00 0 15321 14 0 0
sp_get_clo_for_invoice 4981 4981 0 0.00 0 19829 297 0 0
sp_kill_cost_storno 17915 17915 0 0.00 0 10273 56 0 0
sp_kill_qstorno_ret_qs2qd 1167412 1167412 0 0.00 0 76980 28 0 0
sp_kill_qty_storno 615274 615274 0 0.00 0 76982 62 0 0
sp_lock_selected_doc 20775 20775 0 0.00 0 11422 6 0 0
sp_make_cost_storno 27950 27950 0 0.00 0 25896 48 0 0
sp_multiply_rows_for_pdistr 27950 27950 0 0.00 0 6706 27 0 0
sp_multiply_rows_for_qdistr 20572 20572 0 0.00 0 15535 141 0 0
sp_pay_from_customer 7114 7114 0 0.00 4 18390 124 0 0
sp_pay_to_supplier 5862 5862 0 0.00 5 15724 117 0 0
sp_payment_common 12976 12976 0 0.00 1 16572 30 0 0
sp_qd_handle_on_cancel_clo 1785 1785 0 0.00 0 21466 305 0 0
sp_qd_handle_on_invoice_upd_sts 10879 10879 0 0.00 0 25303 324 0 0
sp_qd_handle_on_reserve_upd_sts 9993 9993 0 0.00 0 19455 58 0 0
sp_reserve_write_off 9993 9993 0 0.00 7 19473 174 0 0
sp_supplier_invoice 5529 5529 0 0.00 6 90959 3172 0 0
sp_supplier_order 5521 5521 0 0.00 5 24919 1247 0 0
srv_aggregate_perf_data 88 88 0 0.00 2792 568174 27258 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1041 135421 31148 0 0
srv_find_qd_qs_mism 1078975 1078975 0 0.00 0 6892 5 0 0
srv_make_invnt_saldo 554 554 0 0.00 23 43304 1331 0 0
srv_make_money_saldo 716 716 0 0.00 0 5610 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 107590 581676 341230 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5001 5001 0 0.00 0 15869 176 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 3640 105 0 0
t$perf-norm:sp_cancel_client_order 1785 1785 0 0.00 0 1636 11 0 0
t$perf-norm:sp_cancel_customer_reserve 692 692 0 0.00 0 1809 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 2567 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 842 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 3008 19 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 20199 1553 0 0
t$perf-norm:sp_cancel_write_off 1004 1004 0 0.00 0 5081 14 0 0
t$perf-norm:sp_client_order 20572 20572 0 0.00 0 7786 19 0 0
t$perf-norm:sp_customer_reserve 1036 1036 0 0.00 0 2240 7 0 0
t$perf-norm:sp_pay_from_customer 7114 7114 0 0.00 0 4928 14 0 0
t$perf-norm:sp_pay_to_supplier 5862 5862 0 0.00 0 3519 9 0 0
t$perf-norm:sp_reserve_write_off 9993 9993 0 0.00 0 10370 15 0 0
t$perf-norm:sp_supplier_invoice 5529 5529 0 0.00 0 4278 19 0 0
t$perf-norm:sp_supplier_order 5521 5521 0 0.00 0 5951 18 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 279 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 430 6 0 0
t$perf-norm:srv_make_invnt_saldo 554 554 0 0.00 0 1496 20 0 0
t$perf-norm:srv_make_money_saldo 716 716 0 0.00 0 2531 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 4 3 0 0
v_add_invoice_to_stock 10272 9962 310 3.01 0 6231 20 0 310
v_all_customers 37406 37406 0 0.00 0 165 1 0 0
v_all_suppliers 30668 30668 0 0.00 0 96 1 0 0
v_all_wares 41144 41144 0 0.00 0 117 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 276 6 0 0
v_cancel_client_order 3570 3570 0 0.00 0 4073 9 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 3597 9 0 0
v_cancel_customer_reserve 1384 1384 0 0.00 0 3945 6 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 4434 9 0 0
v_cancel_supplier_invoice 818 796 22 2.68 0 4456 28 0 22
v_cancel_supplier_order 868 868 0 0.00 0 2066 7 0 0
v_cancel_write_off 2008 2008 0 0.00 0 1829 14 0 0
v_max_id_clo_ord 5520 5520 0 0.00 0 213 1 0 0
v_max_id_clo_res 1036 1036 0 0.00 0 5210 19 0 0
v_max_id_ord_sup 5525 5525 0 0.00 0 5794 4 0 0
v_max_non_paid_invoice 1573 1573 0 0.00 0 853 3 0 0
v_max_non_paid_realizn 3743 3743 0 0.00 0 957 3 0 0
v_min_id_clo_ord 5520 5520 0 0.00 0 5386 6 0 0
v_min_id_clo_res 1036 1036 0 0.00 0 1151 3 0 0
v_min_id_ord_sup 5525 5525 0 0.00 0 3933 5 0 0
v_min_non_paid_invoice 5862 5862 0 0.00 0 6964 16 0 0
v_min_non_paid_realizn 7114 7114 0 0.00 0 9653 18 0 0
v_our_firm 10480 10480 0 0.00 0 14 1 0 0
v_reserve_write_off 19986 19986 0 0.00 0 5615 9 0 0
x_lock_depdocs_on_canc_invoice 11959 11959 0 0.00 0 26831 123 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 25194 364 0 0
x_make_qstorno_1000_1200 5521 5521 0 0.00 2 24913 1168 0 0
x_make_qstorno_1200_2000 5529 5529 0 0.00 2 90951 3052 0 0
x_make_qstorno_2100_3300 465383 465383 0 0.00 0 79079 173 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 06-02-2021 19:29:03 to 06-02-2021 19:29:08.

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
16:57:20 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:26 13698 8192000000 10203968096 10511056896 930485104 10.199 74 53 108 0 950965680 2429536 18051040
16:57:50 17179 8192000000 10329822960 10645913600 1377481840 14.394 100 82 163 0 1407959056 4285728 26191488
16:58:19 29638 8192000000 10391848032 10712367104 1432464880 14.883 100 85 170 0 1465959376 5962064 27532432
16:59:01 21404 8192000000 10410717648 10742640640 1472016368 15.231 100 80 159 1 1504506176 7178336 25311472
16:59:31 32328 8192000000 10454730784 10787672064 1499771344 15.474 100 84 168 0 1534597536 8072832 26753360
17:00:14 15275 8192000000 10471844304 10805248000 1519486608 15.646 100 91 182 0 1557397440 8917472 28993360
17:00:43 21806 8192000000 10489103568 10828980224 1537459568 15.802 100 83 166 0 1573280576 9304720 26516288
17:01:16 17946 8192000000 10503879184 10849234944 1559906480 15.995 100 79 158 2 1594695536 9495808 25293248
17:01:44 12464 8192000000 10525716624 10876661760 1584862560 16.210 100 81 162 0 1619226912 9378720 24985632
17:02:10 13996 8192000000 10544845904 10905903104 1604812752 16.380 100 68 136 0 1635094800 9028784 21253264
17:02:31 14296 8192000000 10570971744 10930343936 1630839120 16.602 100 75 148 2 1663106064 9918608 22348336
17:02:55 13395 8192000000 10598917856 10961260544 1655715360 16.813 100 79 157 2 1689582240 10285504 23581376
17:03:16 11968 8192000000 10610034848 10982453248 1673777680 16.965 100 70 140 0 1704607504 10210720 20619104
17:03:36 10578 8192000000 10630367680 11004264448 1693698816 17.132 100 73 146 0 1725556800 10532544 21325440
17:03:56 9636 8192000000 10657940912 11035140096 1719406624 17.347 100 66 132 1 1749666976 11207376 19052976
17:04:19 7251 8192000000 10678454912 11053727744 1740763104 17.525 100 81 162 1 1776695648 12434592 23497952
17:04:34 7992 8192000000 10696116208 11075239936 1754945792 17.643 100 80 159 0 1789084192 12050800 22087600
17:04:50 8088 8192000000 10708152032 11087097856 1768313920 17.753 100 79 157 2 1801840352 11903392 21623040
17:05:05 5895 8192000000 10722537440 11098726400 1779607696 17.846 100 83 167 1 1815733152 12467552 23657904
17:05:18 7037 8192000000 10726389584 11103682560 1787415248 17.911 100 87 172 3 1825891568 14191952 24284368
17:05:32 4155 8192000000 10724504864 11105992704 1789995984 17.932 100 85 171 1 1827103008 13795824 23311200
17:05:43 4606 8192000000 10738913408 11120844800 1793462512 17.960 100 90 181 1 1833359088 14689072 25207504
17:05:56 4079 8192000000 10750025344 11128467456 1802090288 18.031 100 83 163 2 1838259808 13514048 22655472
17:06:07 3117 8192000000 10742258368 11129577472 1806442816 18.067 100 81 162 0 1842854512 13669360 22742336
17:06:18 3718 8192000000 10748390128 11135668224 1813731440 18.126 100 78 152 0 1846643664 12242384 20669840
17:06:28 3173 8192000000 10755413472 11139686400 1819967104 18.177 100 89 175 1 1858122832 13113088 25042640
17:06:38 3696 8192000000 10772997584 11155460096 1826551312 18.231 100 83 164 2 1862923472 13479744 22892416
17:06:52 2727 8192000000 10761630352 11149357056 1829736432 18.257 100 84 168 2 1865829984 13007312 23086240
17:07:03 2386 8192000000 10771626272 11153551360 1829670432 18.257 100 88 175 1 1867408400 13597424 24140544
17:07:12 1736 8192000000 10780110576 11163893760 1837552528 18.321 100 89 174 1 1876949824 13912224 25485072
17:07:20 1843 8192000000 10777017088 11163979776 1839076320 18.333 100 83 166 0 1876585488 13672160 23837008
17:07:29 2561 8192000000 10788158240 11176341504 1845599360 18.386 100 93 182 2 1889486448 17899872 25987216
17:07:38 2762 8192000000 10794456464 11181670400 1850873616 18.429 100 92 185 3 1890141776 12541104 26727056
17:07:47 1601 8192000000 10794820944 11182366720 1852775840 18.445 100 85 172 0 1888446048 11430640 24239568
17:07:55 1255 8192000000 10801421968 11188944896 1858552272 18.492 100 88 176 1 1895147456 12215968 24379216
17:08:03 3562 8192000000 10801195792 11188809728 1861213952 18.513 100 85 170 1 1897669152 12784480 23670720
17:08:13 1544 8192000000 10809114448 11197992960 1870682416 18.590 100 92 184 2 1910219472 13598752 25938304
17:08:21 1800 8192000000 10815513408 11205586944 1869572160 18.581 100 95 191 1 1909173776 13022496 26579120
17:08:29 1849 8192000000 10807834096 11203538944 1870591280 18.589 100 87 172 1 1908727376 13446464 24689632
17:08:37 1806 8192000000 10824400640 11214204928 1876321312 18.635 100 89 176 1 1916374896 14621360 25432224
17:08:45 38097 8192000000 10813313376 11211337728 1875554544 18.629 100 66 130 1 1904814464 10984688 18275232
17:09:30 1612 8192000000 10828229760 11222081536 1884820432 18.704 100 92 187 1 1923146240 11958672 26367136
17:09:38 2487 8192000000 10817432848 11221712896 1881263984 18.675 100 67 135 1 1912402208 12661456 18476768
17:09:49 3209 8192000000 10805106624 11218190336 1880269136 18.667 100 53 106 1 1907025360 11722352 15033872
17:09:59 5523 8192000000 10796443440 11219976192 1882669120 18.687 100 40 80 0 1903806624 9953296 11184208
17:10:11 4343 8192000000 10790816096 11215093760 1879177408 18.658 100 32 64 0 1895436432 7738080 8520944
17:10:23 3372 8192000000 10801953968 11224084480 1887920608 18.729 100 46 92 0 1910342256 8936080 13485568
17:10:34 2409 8192000000 10814682448 11229523968 1893393760 18.773 100 70 143 1 1923387600 8708096 21285744
17:10:43 7767 8192000000 10801851392 11224043520 1888188512 18.731 100 41 80 0 1908441888 8734880 11518496
17:10:58 2743 8192000000 10802611200 11225747456 1887431776 18.725 100 35 70 1 1905162160 7177760 10552624
17:11:09 46604 8192000000 10808387392 11230736384 1886609616 18.718 100 29 58 3 1901008896 4871408 9527872
17:12:09 15200 8192000000 10797246224 11234639872 1896542416 18.798 100 45 91 0 1917093344 7775520 12775408
17:12:33 7611 8192000000 10800767504 11238436864 1894025424 18.778 100 25 49 3 1911974512 10239776 7709312
17:12:47 5408 8192000000 10818275888 11242659840 1897705312 18.808 100 35 70 1 1914996112 7279536 10011264
17:12:58 3407 8192000000 10826732128 11255533568 1901371664 18.837 100 35 68 1 1922828032 12341168 9115200
17:13:08 8916 8192000000 10814042224 11247972352 1904514016 18.863 100 23 43 6 1917735392 6485792 6735584
17:13:23 6907 8192000000 10807352896 11248185344 1902823840 18.849 100 25 50 1 1916594896 6055680 7715376
17:13:37 7623 8192000000 10827085392 11256291328 1904611184 18.863 100 35 70 2 1925637904 11079584 9947136
17:13:53 8664 8192000000 10820835648 11251490816 1905091552 18.867 100 26 50 3 1917237296 5224496 6921248
17:14:10 6035 8192000000 10832118576 11259768832 1905851728 18.873 100 25 50 1 1922677168 10112096 6713344
17:14:25 10572 8192000000 10821306592 11255984128 1905154288 18.868 100 21 42 2 1916983280 6013984 5815008
17:14:43 8409 8192000000 10823811280 11251290112 1901752304 18.840 100 17 33 2 1911971072 5265648 4953120
17:14:58 14389 8192000000 10820240512 11254726656 1907634896 18.888 100 26 52 2 1921644688 6902048 7107744
17:15:20 47973 8192000000 10823011312 11254980608 1887602304 18.726 99 27 53 3 1900627808 5704496 7321008
17:16:18 14749 8192000000 10836880176 11263492096 1906788512 18.881 100 22 44 2 1918654784 5291888 6574384
17:16:40 5863 8192000000 10802278864 11239055360 1866769472 18.558 98 24 48 0 1880396672 6760256 6866944
17:16:54 6473 8192000000 10816297584 11247198208 1898807472 18.817 100 28 56 0 1920581456 13898640 7875344
17:17:07 5188 8192000000 10820187664 11249868800 1898584016 18.815 100 34 68 1 1916429072 8928624 8916432
17:17:19 5435 8192000000 10803165744 11233394688 1864208416 18.537 98 29 58 1 1877982368 5514032 8259920
17:17:33 5850 8192000000 10781578640 11217829888 1850590592 18.427 98 22 44 3 1862494272 5987056 5916624
17:17:46 5538 8192000000 10767685088 11182383104 1823125232 18.203 97 36 72 1 1838325568 4889184 10311152
17:18:01 7669 8192000000 10773525808 11205287936 1852945488 18.446 99 24 47 1 1865686992 5792240 6949264
17:18:15 6591 8192000000 10775505952 11191058432 1811588400 18.109 97 27 54 0 1824230864 4848528 7793936
17:18:29 6361 8192000000 10779829872 11201880064 1815820768 18.144 97 36 72 1 1838437968 11436592 11180608
17:18:42 8436 8192000000 10718660816 11137593344 1772891360 17.791 96 24 48 5 1785450880 5662320 6897200
17:18:57 7060 8192000000 10733746832 11154300928 1790579104 17.937 97 26 52 2 1803816240 5442912 7794224
17:19:10 5986 8192000000 10738890480 11166097408 1802685264 18.036 98 24 46 0 1815091776 5545456 6861056
17:19:22 4875 8192000000 10726506608 11141181440 1755205472 17.645 96 35 71 2 1775143056 9617792 10319792
17:19:34 6637 8192000000 10717821632 11135705088 1784982144 17.891 98 27 55 2 1798904688 6211136 7711408
17:19:46 12339 8192000000 10739434448 11146207232 1757859600 17.667 96 39 79 1 1774721808 5404096 11458112
17:20:05 67365 8192000000 10729216608 11153063936 1691940912 17.118 93 19 38 1 1702657920 4602736 6114272
17:21:19 8163 8192000000 10718342592 11132825600 1731926848 17.452 95 27 54 1 1745781968 6297904 7557216
17:21:36 3260 8192000000 10729599168 11138797568 1776011216 17.817 98 33 66 0 1793149936 8136192 9002528
17:21:48 6376 8192000000 10724195024 11140354048 1807840240 18.078 100 33 66 0 1823531440 6465984 9225216
17:22:02 6622 8192000000 10693362240 11109638144 1754041696 17.635 97 29 57 0 1768441200 5800400 8599104
17:22:16 9419 8192000000 10718238000 11144929280 1766479008 17.738 97 22 44 2 1778629776 6220560 5930208
17:22:32 6941 8192000000 10741992336 11150913536 1789045008 17.924 98 35 70 0 1804987728 5531968 10410752
17:22:45 5065 8192000000 10754925600 11165048832 1825074128 18.219 100 36 72 2 1842511040 5926608 11510304
17:22:57 8668 8192000000 10768101616 11185848320 1838201200 18.326 100 28 56 3 1856014528 9827120 7986208
17:23:17 4740 8192000000 10762988048 11185053696 1845241024 18.383 100 28 56 4 1859288368 5705888 8341456
17:23:28 12994 8192000000 10767496304 11198578688 1849372848 18.417 100 29 57 1 1868248112 9796944 9078320
17:23:47 7415 8192000000 10772539264 11199721472 1858193424 18.489 100 21 42 0 1869793664 6124512 5475728
17:24:04 11251 8192000000 10761528944 11191980032 1838023776 18.325 99 21 41 3 1849895296 5609840 6261680
17:24:22 14016 8192000000 10771880240 11202109440 1856150672 18.472 100 12 24 0 1864721552 5277104 3293776
17:24:42 17483 8192000000 10773985312 11207774208 1865271280 18.546 100 31 65 1 1880479392 5826624 9381488
17:25:12 63569 8192000000 10811004112 11218554880 1869215104 18.578 100 40 80 0 1886246912 5983792 11048016
17:26:21 7621 8192000000 10789767280 11217989632 1873455888 18.612 100 32 64 1 1889667760 7455872 8756000
17:26:39 5349 8192000000 10790180096 11222560768 1877409424 18.644 100 36 72 0 1894844944 7636864 9798656
17:26:51 3289 8192000000 10805179984 11224322048 1877335936 18.644 100 36 72 0 1894081456 7129440 9616080
17:27:03 4326 8192000000 10806319136 11233517568 1892034672 18.762 100 38 76 4 1909348128 6644528 10668928
17:27:16 15479 8192000000 10821874816 11242799104 1896896384 18.801 100 32 64 0 1912354752 6757648 8700720
17:27:39 18597 8192000000 10835121600 11253891072 1909583824 18.903 100 55 108 2 1931891840 7141616 15166400
17:28:19 12152 8192000000 10855393200 11275120640 1915346608 18.950 100 48 95 1 1945110832 16380336 13383888
17:28:39 15285 8192000000 10866935472 11284451328 1928939984 19.058 100 72 140 2 1961437072 12312448 20184640
17:29:17 11703 8192000000 10880635456 11297308672 1937344256 19.126 100 67 135 1 1971297664 15666144 18287264
17:29:35 14512 8192000000 10884980224 11307012096 1941922672 19.162 100 62 125 3 1979002320 19008560 18071088
17:29:59 16630 8192000000 10893298640 11310768128 1944770128 19.185 100 47 94 0 1973925584 16180352 12975104
17:30:31 36840 8192000000 10885429072 11310678016 1930935488 19.074 99 54 108 1 1964458384 17705872 15817024
17:31:16 18402 8192000000 10888361776 11318390784 1947755280 19.209 100 49 98 0 1979185184 17487312 13942592
17:31:42 18236 8192000000 10900885888 11322138624 1954170704 19.260 100 56 108 0 1987990000 18671312 15147984
17:32:13 12231 8192000000 10906856256 11331743744 1960353472 19.309 100 56 112 2 1995964224 19742144 15868608
17:32:41 29255 8192000000 10905942064 11332829184 1962501056 19.326 100 52 104 2 1996722592 19729648 14491888
17:33:23 12322 8192000000 10912044464 11343044608 1969745104 19.383 100 52 103 0 2008075984 23014128 15316752
17:33:48 11295 8192000000 10916179600 11345248256 1971261504 19.395 100 41 82 0 2005916960 22004640 12650816
17:34:08 15121 8192000000 10926087216 11356397568 1977942752 19.448 100 56 110 0 2016381456 22622736 15815968
17:34:35 18553 8192000000 10929904096 11366277120 1983904192 19.496 100 39 78 0 2020493184 24512736 12076256
17:35:02 22827 8192000000 10926220368 11366612992 1976792880 19.439 99 43 85 2 2011727920 22163200 12771840
17:35:35 3573 8192000000 10939890416 11374653440 1994731104 19.581 100 44 86 1 2029783472 21683280 13369088
17:35:49 3841 8192000000 10953829712 11380932608 2004156976 19.656 100 52 104 0 2043333440 23354000 15822464
17:36:00 12352 8192000000 10966668496 11389964288 2007641584 19.683 100 58 116 1 2049725568 24830176 17253808
17:36:21 11259 8192000000 10987682192 11407708160 2016525184 19.753 100 73 144 1 2067020976 29339760 21156032
17:36:49 5620 8192000000 10970478096 11397197824 2006741808 19.676 100 57 113 1 2053261904 29405808 17114288
17:37:03 4005 8192000000 10959913328 11397431296 2009423376 19.697 100 58 115 2 2057199616 30174128 17602112
17:37:15 6266 8192000000 10953509744 11385106432 1999099248 19.616 100 67 132 2 2049794544 30151488 20543808
17:37:30 8416 8192000000 10957042752 11390693376 2000499136 19.627 100 53 105 2 2046997408 30562016 15936256
17:37:46 4998 8192000000 10964730544 11395887104 2004666304 19.660 100 63 123 0 2054859776 31327888 18865584
17:38:01 4737 8192000000 10980305152 11398008832 2006783488 19.676 100 79 154 1 2062146544 32748688 22614368
17:38:15 4262 8192000000 10970391824 11390676992 1997030048 19.599 100 75 150 0 2053813312 34607072 22176192
17:38:28 3146 8192000000 10959897520 11379499008 1988360912 19.531 100 76 153 1 2044977584 33863248 22753424
17:38:38 1829 8192000000 10960349200 11385507840 1995345680 19.586 100 63 125 1 2047809520 33173792 19290048
17:38:47 2640 8192000000 10983552768 11396907008 2005206608 19.664 100 82 164 4 2062543056 33391888 23944560
17:39:01 2198 8192000000 10977055712 11399606272 2009826416 19.700 100 74 149 1 2064959680 32133392 22999872
17:39:16 1041 8192000000 10986725456 11397427200 2002255728 19.641 100 90 181 0 2064572192 34836992 27479472
17:39:24 4607 8192000000 10979818848 11405430784 2006761632 19.676 100 74 144 2 2063846160 35661216 21423312
17:39:36 4082 8192000000 10963418944 11375009792 1966173360 19.355 98 72 145 2 2026351168 39167216 21010592
17:39:48 4433 8192000000 10972862016 11386781696 1993387584 19.571 100 73 144 0 2051955920 36713744 21854592
17:39:59 4515 8192000000 10981699200 11395043328 1995211264 19.585 100 91 179 2 2059845008 37292848 27340896
17:40:11 3873 8192000000 10974901280 11387600896 1989982448 19.544 100 81 162 1 2053076192 38989168 24104576
17:40:24 3261 8192000000 10961962416 11388010496 1975361280 19.428 99 71 140 1 2037732016 40135648 22235088
17:40:35 2708 8192000000 10986660048 11396661248 1996937248 19.599 100 93 186 0 2066113520 41131888 28044384
17:40:45 2266 8192000000 10968072288 11383357440 1985731472 19.510 100 90 180 4 2055772176 42407808 27632896
17:40:54 3055 8192000000 10962006896 11383005184 1982587776 19.485 100 73 147 3 2045653488 40967808 22097904
17:41:08 2569 8192000000 10978553456 11389968384 1989315056 19.538 100 83 166 2 2058187616 43437024 25435536
17:41:20 4340 8192000000 10962764496 11384360960 1988569424 19.532 100 77 152 0 2049373792 37579184 23225184
17:41:35 12220 8192000000 10952953280 11389538304 1988876848 19.535 100 53 106 0 2042328368 36803120 16648400
17:41:57 4954 8192000000 10945221056 11375198208 1947022064 19.203 98 53 105 3 1998385216 35538384 15824768
17:42:12 4977 8192000000 10963226336 11391356928 1989241152 19.538 100 71 140 1 2050388992 39738960 21408880
17:42:24 2381 8192000000 10964189104 11390046208 1990724160 19.550 100 71 142 3 2054096384 41160448 22211776
17:42:36 4853 8192000000 10976551568 11402235904 1994909664 19.583 100 68 135 3 2057727520 42155504 20662352
17:42:49 3960 8192000000 10975077296 11407142912 1998655008 19.612 100 64 128 0 2062477824 44161792 19661024
17:43:03 6073 8192000000 10953420784 11387400192 1957037760 19.282 98 61 120 2 2021038464 44550048 19450656
17:43:19 3959 8192000000 10949964880 11391246336 1963894864 19.337 99 52 104 1 2028403344 47468464 17040016
17:43:35 3253 8192000000 10957131440 11386056704 1981389072 19.476 100 64 125 1 2043374704 41543904 20441728
17:43:47 8059 8192000000 10957715920 11385327616 1970153744 19.387 99 73 146 1 2029703472 37353520 22196208
17:44:05 4740 8192000000 10969449152 11393810432 1991729408 19.557 100 66 130 0 2050749520 39139568 19880544
17:44:19 2682 8192000000 10976746032 11396042752 1987552384 19.524 100 63 121 1 2048758912 41313664 19892864
17:44:30 4403 8192000000 10979935200 11408248832 1998802944 19.613 100 75 150 2 2066121472 42835200 24483328
17:44:41 5800 8192000000 10983913536 11413807104 2002529616 19.643 100 65 128 3 2067824672 44673200 20621856
17:44:58 3725 8192000000 10973703792 11401232384 1979551744 19.461 99 70 139 2 2044525728 43092992 21880992
17:45:08 2866 8192000000 10967148704 11393368064 1974284208 19.419 99 79 157 2 2045993056 47378496 24330352
17:45:18 2638 8192000000 10989346240 11408646144 1996632304 19.596 100 89 174 0 2069514432 45773920 27108208
17:45:29 1958 8192000000 10989356608 11407212544 1999617408 19.620 100 92 183 1 2073230496 45317664 28295424
17:45:38 6455 8192000000 10978319136 11410837504 2001027392 19.631 100 67 134 1 2066594096 44231856 21334848
17:46:02 9183 8192000000 10946595024 11388620800 1962582112 19.327 98 39 78 0 2018826272 42586288 13657872
17:46:26 6282 8192000000 10957310224 11398864896 1981622336 19.478 100 42 84 2 2037722944 41800736 14299872
17:46:38 10077 8192000000 10967236720 11406950400 1995587728 19.588 100 50 100 2 2059720704 47999920 16133056
17:46:56 3447 8192000000 10975571424 11405365248 1992002048 19.560 100 54 108 1 2053580336 44405216 17173072
17:47:14 7636 8192000000 10946335904 11385655296 1970371248 19.388 99 48 96 0 2032394048 46011232 16011568
17:47:28 8095 8192000000 10954258368 11408867328 1984687968 19.502 100 36 72 4 2047814784 51183072 11943744
17:47:46 11889 8192000000 10936383760 11388657664 1962438768 19.325 99 34 66 1 2013441792 39648944 11354080
17:48:05 9553 8192000000 10920863040 11371380736 1962537424 19.326 100 32 64 1 2013699744 40088336 11073984
17:48:30 13054 8192000000 10939753440 11386728448 1971910336 19.401 100 34 68 2 2024655040 41407184 11337520
17:48:54 4633 8192000000 10952234560 11397103616 1981903648 19.480 100 50 99 1 2040805088 43161072 15740368
17:49:11 13700 8192000000 10946761472 11394220032 1965411344 19.349 99 29 58 2 2016371808 41143040 9817424
17:49:35 22866 8192000000 10937892864 11390144512 1958323360 19.293 99 34 68 2 2008829360 39918176 10587824
17:50:20 15728 8192000000 10919090896 11384442880 1945143952 19.188 99 19 38 1 1992272288 40789440 6338896
17:50:49 23323 8192000000 10918560800 11375697920 1954122944 19.259 100 18 36 0 2003014016 42392160 6498912
17:51:26 4506 8192000000 10935951312 11376156672 1935362672 19.110 99 34 67 3 1997034688 50583824 11088192
17:51:37 11604 8192000000 10924222528 11377651712 1950701040 19.232 100 30 60 1 2007183248 46447200 10035008
17:51:55 18140 8192000000 10906415232 11355791360 1929686032 19.064 99 32 64 1 1984060464 43730704 10643728
17:52:24 13224 8192000000 10911620032 11373899776 1943998608 19.179 100 29 58 2 2002527888 48003616 10525664
17:52:58 49821 8192000000 10892174064 11360858112 1905907184 18.874 98 18 36 1 1948407344 36115712 6384448
17:53:54 36076 8192000000 10878189136 11345887232 1903349248 18.853 98 12 23 0 1923750256 17266592 3134416
17:54:37 75705 8192000000 10869943920 11318624256 1877503376 18.645 97 6 12 0 1892107008 12912304 1691328
17:56:10 19110 8192000000 10878821120 11329900544 1927060672 19.043 99 35 71 1 1952605552 14979536 10565344
17:56:43 25739 8192000000 10841519184 11301863424 1887481504 18.725 98 20 40 1 1905126736 12251456 5393776
17:57:19 67560 8192000000 10857840112 11313172480 1901521488 18.839 99 15 29 1 1920184304 14502832 4159984
17:58:38 29971 8192000000 10871835520 11317886976 1916452752 18.958 99 32 64 0 1932606960 7790288 8363920
17:59:14 33536 8192000000 10874634592 11328237568 1922103712 19.004 99 18 36 4 1938951360 12141792 4705856
18:01:17 72387 8192000000 10880290608 11333218304 1939650256 19.144 100 32 60 2 1961429648 12429760 9349632
18:02:35 36691 8192000000 10911143744 11351953408 1935627488 19.112 99 42 82 1 1960600912 13209488 11763936
18:03:20 116973 8192000000 10885777664 11365138432 1957768608 19.288 100 16 31 1 1977721184 15193904 4758672
18:05:27 52893 8192000000 10922060112 11378589696 1980300944 19.467 100 41 82 1 2004682016 11908368 12472704
18:07:02 33442 8192000000 10926037392 11385200640 1949046144 19.219 98 43 87 1 1974730608 12357808 13326656
18:07:53 61130 8192000000 10886107200 11372208128 1938997392 19.139 99 12 23 0 1966153536 23109488 4046656
18:09:56 54261 8192000000 10895052240 11369222144 1975892016 19.432 100 9 18 0 1985630720 7206304 2532400
18:10:57 87652 8192000000 10916066784 11392458752 1945449344 19.190 98 14 28 0 1969214736 19671520 4093872
18:12:31 73885 8192000000 10931320064 11393069056 1982229280 19.482 100 23 46 1 2008082784 18924848 6928656
18:13:59 81440 8192000000 10902863456 11389505536 1981060752 19.473 100 20 40 1 1998724976 11811024 5853200
18:15:33 14325 8192000000 10919321344 11390427136 1988504976 19.532 100 21 40 1 2005064800 10391440 6168384
18:15:55 1586 8192000000 10929288624 11371208704 1980663696 19.470 99 73 145 4 2007717728 7442976 19611056
18:16:16 51609 8192000000 10919312000 11387957248 1971039632 19.394 99 30 60 1 1995985616 16767136 8178848
18:17:17 62149 8192000000 10896094416 11384516608 1965276928 19.348 99 17 33 0 1981624144 11365456 4981760
18:18:25 52003 8192000000 10896300688 11368153088 1902758880 18.848 96 11 22 0 1919318208 13133536 3425792
18:19:29 42131 8192000000 10898495904 11371192320 1953908208 19.258 99 15 30 0 1967636384 9466512 4261664
18:20:19 50433 8192000000 10902906784 11373936640 1924840192 19.026 97 22 44 0 1942990080 11572496 6577392
18:21:17 46121 8192000000 10923710544 11364167680 1942799872 19.169 98 34 70 1 1971305248 18379952 10125424
18:22:09 38519 8192000000 10891294512 11357368320 1931747968 19.081 98 33 66 1 1958972128 17535552 9688608
18:22:54 44312 8192000000 10897633744 11383492608 1962669984 19.327 100 28 57 1 1997024576 25163856 9190736
18:23:52 63903 8192000000 10908307488 11360653312 1915948048 18.954 97 13 26 1 1932028720 12668160 3412512
18:25:05 29233 8192000000 10906504880 11359281152 1946030272 19.195 99 20 40 1 1960019712 8520064 5469376
18:25:41 31806 8192000000 10901860896 11359645696 1934068128 19.099 98 25 50 0 1952540832 11647936 6824768
18:26:22 44746 8192000000 10903050352 11373441024 1953891312 19.257 99 30 60 0 1975932816 13773344 8268160
18:27:15 135421 8192000000 10921152320 11385155584 1895275472 18.788 96 8 16 0 1910478864 13819504 1383888
18:29:38 68103 8192000000 10896630384 11371868160 1916601936 18.960 97 13 26 1 1938137504 18222464 3313104
18:30:52 79191 8192000000 10887681392 11351089152 1873788320 18.615 95 14 28 1 1892312976 14637872 3886784
18:32:38 60248 8192000000 10867611248 11334463488 1918489632 18.975 98 31 60 3 1933817200 6175408 9152160
18:33:51 47865 8192000000 10880359040 11355770880 1943301792 19.173 99 12 24 0 1956261824 9486688 3473344
18:34:45 49812 8192000000 10886193152 11365203968 1958795232 19.296 100 12 24 0 1972741696 10627920 3318544
18:35:47 38006 8192000000 10877388848 11363131392 1948708704 19.216 100 5 10 0 1961068528 11350944 1008880
18:36:31 20358 8192000000 10877986096 11324489728 1870979472 18.592 96 18 37 0 1884790736 9162160 4649104
18:37:00 9984 8192000000 10882975456 11325366272 1932769776 19.089 100 54 108 2 1955063072 6760112 15533184
18:37:17 20869 8192000000 10887021680 11348656128 1946736304 19.200 100 26 52 1 1961763360 7842192 7184864
18:37:54 30273 8192000000 10882086576 11346792448 1919251904 18.981 98 23 48 1 1935402928 9588176 6562848
18:38:36 53909 8192000000 10906378352 11366928384 1944530400 19.183 99 27 53 0 1962035536 10218912 7286224
18:39:35 19189 8192000000 10928873280 11377995776 1975405136 19.428 100 46 89 0 1998323472 10288016 12630320
18:40:06 76786 8192000000 10893401840 11369013248 1919032240 18.979 97 22 44 1 1937625808 12134848 6458720
18:41:30 71378 8192000000 10886791280 11377733632 1940619120 19.152 99 16 32 2 1963450896 18117808 4713968
18:43:39 104583 8192000000 10884762128 11379994624 1897931488 18.810 96 15 30 0 1927034416 24432544 4670384
18:45:29 85954 8192000000 10877459440 11346903040 1842021712 18.357 94 15 29 2 1857114976 11583488 3509776
18:47:01 43268 8192000000 10902144816 11358957568 1923137488 19.012 99 16 32 0 1936693648 9074672 4481488
18:47:55 22338 8192000000 10907032704 11357609984 1951352544 19.237 100 38 76 1 1974997744 12930096 10715104
18:48:24 48611 8192000000 10894673552 11365519360 1945380336 19.190 100 24 46 1 1973305056 21240560 6684160
18:49:19 134402 8192000000 10882083920 11362504704 1898160576 18.811 97 17 35 1 1924435392 20869328 5405488
18:51:53 80946 8192000000 10868993728 11332669440 1839442128 18.336 94 17 34 0 1853947728 9911680 4593920
18:53:23 27122 8192000000 10882126400 11343884288 1943088016 19.171 100 36 72 0 1966576192 13026768 10461408
18:53:59 19888 8192000000 10871623824 11334184960 1928417104 19.054 99 35 70 1 1948794832 10674176 9703552
18:54:25 24619 8192000000 10910756832 11361849344 1958283552 19.292 100 48 97 1 1982848672 10700528 13864592
18:54:59 30923 8192000000 10875937216 11353227264 1943253504 19.173 99 36 72 3 1967162608 13812256 10096848
18:55:38 48720 8192000000 10866641344 11349479424 1913110000 18.932 98 12 24 1 1931138688 14611952 3416736
18:56:32 40591 8192000000 10844970368 11326152704 1896667696 18.799 98 14 28 0 1914378704 13626400 4084608
18:58:03 74209 8192000000 10873129136 11351441408 1930759808 19.073 99 15 30 0 1942752016 8063600 3928608
18:59:49 74731 8192000000 10886904128 11359465472 1954210064 19.260 100 17 33 1 1971929008 12780720 4938224
19:01:23 62337 8192000000 10896786496 11378483200 1949809568 19.225 99 9 18 0 1961469856 9471408 2188880
19:02:32 98253 8192000000 10914273648 11370553344 1885478112 18.709 95 13 26 0 1901691968 12691648 3522208
19:04:17 61716 8192000000 10913177600 11380158464 1943933808 19.178 98 37 74 0 1967178736 12438448 10806480
19:05:39 64174 8192000000 10886651168 11354902528 1862588176 18.524 95 16 33 0 1875256416 8051440 4616800
19:06:49 26638 8192000000 10909605120 11373715456 1966012176 19.354 100 36 72 2 1988821888 11987232 10822480
19:07:34 27688 8192000000 10913184848 11379449856 1958439392 19.294 99 26 52 1 1978498912 12490208 7569312
19:08:12 65704 8192000000 10922734624 11390566400 1954258448 19.260 99 20 40 1 1973870704 13732112 5880144
19:09:31 38892 8192000000 10940008256 11406712832 1993098800 19.568 100 37 74 1 2020883888 17197616 10587472
19:11:31 70322 8192000000 10895848080 11383267328 1957865424 19.289 99 13 26 0 1975197840 13731840 3600576
19:13:14 54949 8192000000 10888350400 11349028864 1892874432 18.769 96 24 48 0 1907627184 8180736 6572016
19:14:17 31588 8192000000 10921571648 11375878144 1967149216 19.363 100 38 76 0 1995266016 17778880 10337920
19:14:58 83448 8192000000 10877356832 11358244864 1888171376 18.731 96 20 40 1 1907701200 13758176 5771648
19:16:44 88379 8192000000 10869593376 11341176832 1899679552 18.824 97 30 60 0 1917275808 8705040 8891216
19:18:29 23090 8192000000 10900528384 11367780352 1963862592 19.337 100 35 70 1 1983319168 9800736 9655840
19:18:58 70711 8192000000 10891139424 11370237952 1948913024 19.218 99 28 56 1 1971090128 14842880 7334224
19:20:22 40931 8192000000 10879425312 11373613056 1941371232 19.158 99 7 13 1 1956870288 14041968 1457088
19:21:10 30207 8192000000 10852637392 11344371712 1896712304 18.800 97 9 18 0 1913386448 14074784 2599360
19:21:46 35229 8192000000 10833958752 11310583808 1860958832 18.511 96 19 37 1 1872769856 6887408 4923616
19:22:27 61215 8192000000 10835879520 11308118016 1846527280 18.394 96 12 24 1 1855428272 6067760 2833232
19:23:35 57446 8192000000 10857016816 11326337024 1930810816 19.073 100 17 34 0 1946019024 10696720 4511488
19:24:38 57953 8192000000 10854290576 11330441216 1911306640 18.917 99 13 26 0 1923847344 8879616 3661088
19:26:10 48284 8192000000 10882852112 11352346624 1942507344 19.167 100 18 36 2 1958166400 10978208 4680848

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 06-02-2021 19:29:09 to 06-02-2021 19:29:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-02-2021 19:29:42 to 06-02-2021 19:29:44.

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          240217
MON$OLDEST_ACTIVE               240759
MON$OLDEST_SNAPSHOT             240759
MON$NEXT_TRANSACTION            240759
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                       2028320
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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Sat Feb  6 19:27:26 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Sat Feb  6 19:27:28 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Sat Feb  6 19:27:29 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
--- end of diff output ---

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

06.02.21 19:29:45. 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-06 19:29:48 No severe PSQL-related problems occured
06.02.21 19:29:49. End of report.