Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.01.2021 01: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 17197676 kB
MemAvailable 31264316 kB
Buffers 0 kB
Cached 14472896 kB
SwapCached 4868 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-01-26 01:27:12
DTS_END                         2021-01-26 01:27:12.5100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/57482
TRN_ID                          236979
ATT_ID                          677
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: 9357.28 24371 1122873
customer order: creation 165.04 408 19805
customer order: refuse 14.38 360 1725
order to supplier: creation 44.03 1417 5284
order to supplier: removal 3.51 108862 421
invoice (draft): creation 45.41 3483 5449
invoice (draft): removal 54.12 793 6494
invoice accept: apply 40.59 19131 4871
invoice accept: cancel 48.97 849 5876
customer reserve: creation 3810.05 187 457206
customer reserve: removal 4843.57 63 581228
realization accept: apply 81.55 176 9786
realization accept: cancel 79.22 118 9506
payment from customer: creation 58.79 123 7055
payment from customer: removal 5.48 78 657
payment to supplier: creation 47.51 141 5701
payment to supplier: removal 3.32 50 398
service: total inventory turnovers 4.69 1079 563
service: total monetary turnovers 6.17 29 740
service: aggregate perf. data 0.87 20053 104
service: refresh index statistics 0.03 330025 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-01-2021 01:28:29 to 26-01-2021 01:28:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7026
TEST_TIME 2 7192
TEST_TIME 3 6506
TEST_TIME 4 6151
TEST_TIME 5 6226
TEST_TIME 6 5978
TEST_TIME 7 5839
TEST_TIME 8 5666
TEST_TIME 9 6172
TEST_TIME 10 5972
TEST_TIME 11 5963
TEST_TIME 12 5937
TEST_TIME 13 6055
TEST_TIME 14 6433
TEST_TIME 15 6561
TEST_TIME 16 6907
TEST_TIME 17 7053
TEST_TIME 18 7710
TEST_TIME 19 8174
TEST_TIME 20 8443
TEST_TIME 21 8705
TEST_TIME 22 9094
TEST_TIME 23 9358
TEST_TIME 24 9307
TEST_TIME 25 9600
TEST_TIME 26 10234
TEST_TIME 27 11114
TEST_TIME 28 11079
TEST_TIME 29 10989
TEST_TIME 30 10969
TEST_TIME 31 10770
TEST_TIME 32 10574
TEST_TIME 33 10486
TEST_TIME 34 10476
TEST_TIME 35 10490
TEST_TIME 36 10384
TEST_TIME 37 10333
TEST_TIME 38 10367
TEST_TIME 39 10353
TEST_TIME 40 10297
TEST_TIME 41 10213
TEST_TIME 42 10078
TEST_TIME 43 9995
TEST_TIME 44 10036
TEST_TIME 45 10119
TEST_TIME 46 10088
TEST_TIME 47 9963
TEST_TIME 48 9943
TEST_TIME 49 9934
TEST_TIME 50 9803
TEST_TIME 51 9686
TEST_TIME 52 9613
TEST_TIME 53 9540
TEST_TIME 54 9553
TEST_TIME 55 9620
TEST_TIME 56 9696
TEST_TIME 57 9835
TEST_TIME 58 9936
TEST_TIME 59 9868
TEST_TIME 60 9915
TEST_TIME 61 10011
TEST_TIME 62 10036
TEST_TIME 63 10053
TEST_TIME 64 10138
TEST_TIME 65 10150
TEST_TIME 66 10086
TEST_TIME 67 9999
TEST_TIME 68 9923
TEST_TIME 69 9873
TEST_TIME 70 9819
TEST_TIME 71 9849
TEST_TIME 72 9783
TEST_TIME 73 9715
TEST_TIME 74 9720
TEST_TIME 75 9677
TEST_TIME 76 9660
TEST_TIME 77 9770
TEST_TIME 78 9740
TEST_TIME 79 9747
TEST_TIME 80 9725
TEST_TIME 81 9728
TEST_TIME 82 9778
TEST_TIME 83 9798
TEST_TIME 84 9771
TEST_TIME 85 9760
TEST_TIME 86 9766
TEST_TIME 87 9836
TEST_TIME 88 9788
TEST_TIME 89 9707
TEST_TIME 90 9682
TEST_TIME 91 9648
TEST_TIME 92 9633
TEST_TIME 93 9572
TEST_TIME 94 9550
TEST_TIME 95 9555
TEST_TIME 96 9527
TEST_TIME 97 9488
TEST_TIME 98 9466
TEST_TIME 99 9525
TEST_TIME 100 9561
TEST_TIME 101 9528
TEST_TIME 102 9530
TEST_TIME 103 9592
TEST_TIME 104 9552
TEST_TIME 105 9576
TEST_TIME 106 9578
TEST_TIME 107 9563
TEST_TIME 108 9585
TEST_TIME 109 9523
TEST_TIME 110 9505
TEST_TIME 111 9473
TEST_TIME 112 9455
TEST_TIME 113 9426
TEST_TIME 114 9371
TEST_TIME 115 9355
TEST_TIME 116 9381
TEST_TIME 117 9414
TEST_TIME 118 9458
TEST_TIME 119 9430
TEST_TIME 120 9360

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-01-2021 01:28:33 to 26-01-2021 01:28:36.

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 1545933 1545933 0 0.00 0 20918 6 0 0
doc_list_biud 1545933 1545933 0 0.00 0 43379 30 0 0
sp_add_invoice_to_stock 4996 4871 125 2.50 33 170428 19131 0 125
sp_cancel_adding_invoice 5876 5876 0 0.00 6 90431 849 0 0
sp_cancel_client_order 1725 1725 0 0.00 4 15082 360 0 0
sp_cancel_customer_reserve 581228 581228 0 0.00 1 24174 63 0 0
sp_cancel_pay_from_customer 657 657 0 0.00 3 4453 79 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 939 51 0 0
sp_cancel_supplier_invoice 6502 6494 8 0.12 2 28831 794 0 8
sp_cancel_supplier_order 421 421 0 0.00 6 1073772 108862 0 0
sp_cancel_write_off 9506 9506 0 0.00 1 17505 119 0 0
sp_client_order 19805 19805 0 0.00 4 92341 408 0 0
sp_customer_reserve 457206 457206 0 0.00 0 62435 188 0 0
sp_fill_shopping_cart 30526 30526 0 0.00 1 16777 39 0 0
sp_fill_shopping_cart_clo_res 457198 457198 0 0.00 0 18174 14 0 0
sp_get_clo_for_invoice 4863 4863 0 0.00 0 22591 343 0 0
sp_kill_cost_storno 16437 16437 0 0.00 0 11294 58 0 0
sp_kill_qstorno_ret_qs2qd 1178877 1178877 0 0.00 0 28758 34 0 0
sp_kill_qty_storno 619899 619899 0 0.00 0 43377 73 0 0
sp_lock_selected_doc 20352 20352 0 0.00 0 8284 5 0 0
sp_make_cost_storno 27405 27405 0 0.00 0 20915 63 0 0
sp_multiply_rows_for_pdistr 27405 27405 0 0.00 0 7975 28 0 0
sp_multiply_rows_for_qdistr 19805 19805 0 0.00 0 92332 224 0 0
sp_pay_from_customer 7055 7055 0 0.00 4 19276 124 0 0
sp_pay_to_supplier 5701 5701 0 0.00 4 13402 141 0 0
sp_payment_common 12756 12756 0 0.00 1 11280 28 0 0
sp_qd_handle_on_cancel_clo 1725 1725 0 0.00 0 15074 334 0 0
sp_qd_handle_on_invoice_upd_sts 10739 10739 0 0.00 0 43374 338 0 0
sp_qd_handle_on_reserve_upd_sts 9786 9786 0 0.00 0 13427 59 0 0
sp_reserve_write_off 9786 9786 0 0.00 6 20924 176 0 0
sp_supplier_invoice 5449 5449 0 0.00 6 105473 3483 0 0
sp_supplier_order 5284 5284 0 0.00 6 38906 1418 0 0
srv_aggregate_perf_data 104 104 0 0.00 2629 363676 20054 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 832 132093 31754 0 0
srv_find_qd_qs_mism 1076018 1076018 0 0.00 0 18497 5 0 0
srv_make_invnt_saldo 563 563 0 0.00 41 50685 1080 0 0
srv_make_money_saldo 740 740 0 0.00 0 3001 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 55635 629261 330025 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4871 4871 0 0.00 0 9239 163 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 1 3736 101 0 0
t$perf-norm:sp_cancel_client_order 1725 1725 0 0.00 0 5762 17 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 1665 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 657 657 0 0.00 0 1572 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 1605 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 2827 25 0 0
t$perf-norm:sp_cancel_supplier_order 421 421 0 0.00 0 22242 1546 0 0
t$perf-norm:sp_cancel_write_off 1042 1042 0 0.00 0 6506 15 0 0
t$perf-norm:sp_client_order 19805 19805 0 0.00 0 7714 16 0 0
t$perf-norm:sp_customer_reserve 964 964 0 0.00 0 4405 13 0 0
t$perf-norm:sp_pay_from_customer 7055 7055 0 0.00 0 12863 12 0 0
t$perf-norm:sp_pay_to_supplier 5701 5701 0 0.00 0 4747 9 0 0
t$perf-norm:sp_reserve_write_off 9786 9786 0 0.00 0 13204 13 0 0
t$perf-norm:sp_supplier_invoice 5449 5449 0 0.00 0 4163 20 0 0
t$perf-norm:sp_supplier_order 5284 5284 0 0.00 0 4281 15 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 120 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 312 3 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 734 19 0 0
t$perf-norm:srv_make_money_saldo 740 740 0 0.00 0 3812 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 5 0 0
v_add_invoice_to_stock 9973 9724 249 2.49 0 9949 18 0 249
v_all_customers 36850 36850 0 0.00 0 17 1 0 0
v_all_suppliers 30034 30034 0 0.00 0 172 1 0 0
v_all_wares 39610 39610 0 0.00 0 219 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 857 7 0 0
v_cancel_client_order 3450 3450 0 0.00 0 3689 5 0 0
v_cancel_customer_prepayment 1314 1314 0 0.00 0 393 3 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 7838 14 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 838 5 0 0
v_cancel_supplier_invoice 774 758 16 2.06 0 1763 17 0 16
v_cancel_supplier_order 842 842 0 0.00 0 8249 13 0 0
v_cancel_write_off 2084 2084 0 0.00 0 765 11 0 0
v_max_id_clo_ord 5277 5277 0 0.00 0 2644 2 0 0
v_max_id_clo_res 964 964 0 0.00 0 1569 14 0 0
v_max_id_ord_sup 5444 5444 0 0.00 0 3679 3 0 0
v_max_non_paid_invoice 1405 1405 0 0.00 0 751 4 0 0
v_max_non_paid_realizn 3614 3614 0 0.00 0 889 3 0 0
v_min_id_clo_ord 5277 5277 0 0.00 0 12339 9 0 0
v_min_id_clo_res 964 964 0 0.00 0 10994 28 0 0
v_min_id_ord_sup 5444 5444 0 0.00 0 5813 8 0 0
v_min_non_paid_invoice 5701 5701 0 0.00 0 7193 19 0 0
v_min_non_paid_realizn 7055 7055 0 0.00 0 6534 16 0 0
v_our_firm 9642 9642 0 0.00 0 11 1 0 0
v_reserve_write_off 19572 19572 0 0.00 0 5240 4 0 0
x_lock_depdocs_on_canc_invoice 11991 11991 0 0.00 0 21982 120 0 0
x_lock_depdocs_on_canc_sup_ord 421 421 0 0.00 0 23360 391 0 0
x_make_qstorno_1000_1200 5284 5284 0 0.00 2 38736 1332 0 0
x_make_qstorno_1200_2000 5449 5449 0 0.00 3 105430 3350 0 0
x_make_qstorno_2100_3300 457206 457206 0 0.00 0 58704 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-01-2021 01:28:37 to 26-01-2021 01:28:41.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:22 12882 8192000000 10197069168 10503925760 880512000 9.705 71 50 102 0 899650736 2412096 16726640
22:57:43 20355 8192000000 10311925984 10627674112 1358175488 14.221 100 82 164 1 1389953760 4818112 26960160
22:58:14 26447 8192000000 10363423328 10686808064 1412782080 14.709 100 86 171 1 1446418432 5798496 27837856
22:58:56 24587 8192000000 10411794704 10743394304 1457898352 15.107 100 87 174 0 1493974832 7199936 28876544
22:59:32 16667 8192000000 10423297840 10756976640 1482244688 15.321 100 86 172 0 1518020736 7814240 27961808
23:00:03 23340 8192000000 10455426864 10788753408 1503454080 15.506 100 91 182 0 1541168352 8470560 29243712
23:00:33 23022 8192000000 10470656608 10806349824 1519208464 15.643 100 88 176 0 1556260048 8882464 28169120
23:01:04 19472 8192000000 10480381552 10822148096 1529529440 15.733 100 79 158 2 1563796368 9394352 24872576
23:01:35 16490 8192000000 10501102096 10847125504 1554249104 15.947 100 82 164 1 1589140608 9604624 25286880
23:02:02 14668 8192000000 10523173392 10877566976 1582501520 16.190 100 72 144 2 1613712512 9595584 21615408
23:02:25 7476 8192000000 10537091472 10890821632 1599804144 16.338 100 79 159 0 1633452480 10022992 23625344
23:02:43 19865 8192000000 10569136960 10925297664 1623498624 16.540 100 78 156 0 1656543792 10219296 22825872
23:03:15 9587 8192000000 10587623104 10950238208 1647302560 16.742 100 82 162 1 1682401600 11743184 23355856
23:03:33 11743 8192000000 10606689696 10974621696 1667342800 16.911 100 81 162 1 1702919280 12037488 23538992
23:03:52 8521 8192000000 10641130144 11006742528 1690240928 17.103 100 81 162 1 1725487216 12495808 22750480
23:04:08 8478 8192000000 10654162704 11026182144 1713939088 17.302 100 84 169 1 1751651632 13428784 24283760
23:04:25 6520 8192000000 10667417024 11040882688 1728323248 17.422 100 84 168 0 1766261920 13956048 23982624
23:04:38 9078 8192000000 10679368272 11056693248 1742904080 17.543 100 86 172 1 1782631376 15238640 24488656
23:04:54 3681 8192000000 10692602128 11067981824 1751337568 17.613 100 88 176 2 1790438912 14432576 24668768
23:05:05 5626 8192000000 10689385632 11069067264 1754684896 17.640 100 82 164 0 1791668944 13637120 23346928
23:05:18 4348 8192000000 10693615856 11074826240 1764521088 17.722 100 81 160 3 1800345200 13421248 22402864
23:05:29 3426 8192000000 10708048576 11086970880 1770446080 17.771 100 86 168 3 1807560720 12784224 24330416
23:05:39 4249 8192000000 10720688192 11100692480 1780200992 17.851 100 88 175 2 1818613168 13946144 24466032
23:05:50 4289 8192000000 10724144864 11103125504 1785029792 17.891 100 90 180 0 1825232160 14545216 25657152
23:06:02 3011 8192000000 10733811760 11112296448 1795887536 17.980 100 90 179 1 1835511968 14728480 24895952
23:06:12 3026 8192000000 10738906560 11120742400 1797447280 17.993 100 90 180 0 1836797808 14434960 24915568
23:06:21 6935 8192000000 10744360656 11127275520 1804802192 18.053 100 85 169 0 1842105616 13885200 23418224
23:06:35 4049 8192000000 10748824000 11132182528 1810923232 18.103 100 78 156 0 1846526032 13201472 22401328
23:06:46 3117 8192000000 10763174672 11151486976 1823569616 18.207 100 85 171 1 1860719760 13466800 23683344
23:06:55 1114 8192000000 10782752592 11165044736 1830873504 18.266 100 90 185 1 1869565904 13541744 25150656
23:07:03 1941 8192000000 10783181184 11171344384 1839591184 18.337 100 91 181 2 1878722160 13792752 25338224
23:07:11 1714 8192000000 10791160368 11177828352 1844526016 18.378 100 91 181 0 1882079984 11571248 25982720
23:07:20 2064 8192000000 10792450496 11178455040 1848611584 18.411 100 92 184 0 1887185648 12033056 26541008
23:07:28 1247 8192000000 10785855440 11174477824 1849568336 18.419 100 88 176 1 1888147264 12606928 25972000
23:07:36 1733 8192000000 10795348640 11183595520 1854074448 18.455 100 91 183 2 1891660960 12115008 25471504
23:07:45 1468 8192000000 10803342592 11191250944 1863087296 18.528 100 96 191 1 1902126352 12438608 26600448
23:07:53 11121 8192000000 10801042544 11190489088 1856474864 18.475 100 66 130 4 1886431648 11831712 18125072
23:08:10 2340 8192000000 10787198096 11192414208 1861759024 18.518 100 62 124 3 1889922688 10907616 17256048
23:08:19 2792 8192000000 10779895328 11192483840 1859656000 18.500 100 56 112 1 1886364912 10251264 16457648
23:08:28 3784 8192000000 10785505664 11191697408 1862365904 18.522 100 49 97 1 1885383760 9127616 13890240
23:08:39 2177 8192000000 10791064816 11204943872 1865729792 18.550 100 42 84 0 1890358368 13187664 11440912
23:08:48 2936 8192000000 10792143456 11206041600 1871619744 18.597 100 47 95 2 1893843120 9643584 12579792
23:08:58 8235 8192000000 10786814608 11206508544 1870182672 18.586 100 35 71 0 1886596224 6510256 9903296
23:09:30 19409 8192000000 10826185056 11218096128 1881655936 18.678 100 72 145 3 1908806112 6438240 20711936
23:09:56 27075 8192000000 10786307888 11210371072 1877044080 18.641 100 32 63 1 1892894832 5826000 10024752
23:10:29 10979 8192000000 10787143136 11215093760 1875370544 18.628 100 21 42 1 1888140832 6669104 6101184
23:10:47 6043 8192000000 10785393904 11216506880 1875099072 18.626 100 16 32 0 1886088176 6658096 4331008
23:11:00 8613 8192000000 10797865680 11230670848 1884831408 18.704 100 22 44 2 1900734384 9937872 5965104
23:11:17 7776 8192000000 10798800080 11230027776 1887981584 18.730 100 16 32 2 1902735264 9884240 4869440
23:11:31 9976 8192000000 10802848032 11236806656 1891327664 18.756 100 25 50 0 1908502384 10226128 6948592
23:11:49 8816 8192000000 10808374544 11236147200 1894085856 18.779 100 23 46 4 1907011936 6193648 6732432
23:12:05 8562 8192000000 10792940864 11233501184 1892683920 18.767 100 19 38 0 1904691072 6760592 5246560
23:12:26 8616 8192000000 10802748912 11238273024 1894694112 18.784 100 22 44 0 1907517152 6790464 6032576
23:12:43 10692 8192000000 10809873344 11240427520 1894833008 18.785 100 7 14 1 1902041088 5165824 2042256
23:13:02 11723 8192000000 10803561040 11243986944 1897221936 18.804 100 13 27 1 1906171328 5639008 3310384
23:13:20 7490 8192000000 10813935408 11248599040 1899714992 18.824 100 26 49 4 1913494304 6141888 7637424
23:13:36 11241 8192000000 10807012128 11245936640 1902646128 18.848 100 13 21 2 1911959936 6049792 3264016
23:13:53 7792 8192000000 10815741600 11250184192 1904776416 18.865 100 23 46 0 1917093344 5359264 6957664
23:14:10 57822 8192000000 10810044384 11254112256 1907346224 18.885 100 29 55 0 1921909776 5800192 8763360
23:15:16 20109 8192000000 10817922128 11260669952 1907992000 18.891 100 26 52 0 1920854560 5967168 6895392
23:15:43 8006 8192000000 10828957632 11259555840 1908506080 18.895 100 26 51 1 1921010288 5730064 6774144
23:15:57 5307 8192000000 10837280320 11269292032 1913968848 18.938 100 40 81 0 1934454160 7993600 12491712
23:16:11 9473 8192000000 10820627728 11260059648 1914645120 18.944 100 29 58 2 1930258160 6272352 9340688
23:16:29 10026 8192000000 10817523792 11259715584 1910753808 18.913 100 32 64 1 1926020720 6359840 8907072
23:16:45 6864 8192000000 10819279728 11252645888 1873097168 18.609 98 31 62 1 1888007360 5863792 9046400
23:16:58 6582 8192000000 10803735072 11235328000 1873364928 18.611 99 23 46 0 1884957952 5621680 5971344
23:17:11 11281 8192000000 10786274400 11213524992 1829968896 18.259 97 9 18 0 1838135504 5890848 2275760
23:17:28 9673 8192000000 10778494288 11214540800 1828830640 18.250 97 27 54 1 1842905232 6670768 7403824
23:17:47 11154 8192000000 10779960096 11210162176 1831026704 18.268 98 28 56 2 1845709152 6843872 7838576
23:18:06 8180 8192000000 10748800928 11176873984 1769399088 17.762 95 19 38 1 1781155264 5801616 5954560
23:18:21 7921 8192000000 10713949664 11132018688 1718470336 17.339 94 21 42 1 1729986960 5075392 6441232
23:18:38 4435 8192000000 10686599392 11098415104 1731747792 17.450 95 17 34 1 1741648176 5097664 4802720
23:18:52 24130 8192000000 10738011520 11161612288 1799443408 18.009 99 17 34 0 1809409856 5074800 4891648
23:19:28 35270 8192000000 10770684224 11163869184 1786656352 17.904 97 59 121 2 1809622400 5037152 17928896
23:20:09 11588 8192000000 10722883136 11148517376 1755655888 17.648 96 18 36 1 1766380656 5516112 5208656
23:20:27 8333 8192000000 10680108480 11084632064 1652224352 16.783 91 27 54 0 1665324336 5588272 7511712
23:20:42 8121 8192000000 10727156864 11133046784 1771281248 17.778 99 25 49 2 1784227728 5389088 7557392
23:20:56 7433 8192000000 10694632832 11109421056 1708765584 17.258 95 30 60 1 1724188688 6771088 8652016
23:21:11 11536 8192000000 10701600864 11120259072 1775748176 17.814 99 30 60 2 1791215840 6365408 9102256
23:21:29 9852 8192000000 10738844112 11152138240 1817855184 18.160 100 35 70 2 1838528864 10083056 10590624
23:21:46 10023 8192000000 10707286272 11122540544 1767355680 17.745 97 23 46 0 1779329328 5299168 6674480
23:22:02 8644 8192000000 10732445072 11148464128 1793931456 17.964 99 14 28 1 1803601568 5669648 4000464
23:22:23 7819 8192000000 10739531360 11161255936 1813949296 18.128 99 31 61 1 1829389376 5981984 9458096
23:22:37 7391 8192000000 10753536128 11167166464 1834775040 18.298 100 38 74 1 1852220576 5062256 12383280
23:22:52 7150 8192000000 10739364992 11163217920 1818892112 18.169 99 34 69 2 1834612736 5470656 10249968
23:23:07 8086 8192000000 10749024752 11165790208 1831581424 18.272 100 22 44 0 1843716976 5336880 6798672
23:23:24 7887 8192000000 10761124320 11172757504 1821802832 18.192 99 22 44 0 1833679120 5427072 6449216
23:23:38 42545 8192000000 10782105424 11191705600 1846299632 18.392 100 32 64 3 1861276784 5169040 9808112
23:24:31 18721 8192000000 10806146448 11201089536 1860380688 18.506 100 73 147 3 1888030176 5540144 22109344
23:24:56 19663 8192000000 10775235600 11199864832 1861862480 18.518 100 29 57 1 1875760672 5409968 8488224
23:25:23 3932 8192000000 10777412896 11205963776 1863781280 18.534 100 30 62 1 1883340416 11537280 8021856
23:25:33 7642 8192000000 10782684048 11205046272 1866795488 18.558 100 43 83 6 1885215296 6016736 12403072
23:25:48 5066 8192000000 10788645008 11212107776 1866259824 18.554 100 32 64 0 1882924512 8093712 8570976
23:26:02 6151 8192000000 10784836496 11209535488 1870626896 18.589 100 40 80 3 1889006464 6763984 11615584
23:26:15 9541 8192000000 10790352960 11216068608 1869591600 18.581 100 26 52 0 1886968496 9532576 7844320
23:26:32 7882 8192000000 10793101760 11217899520 1874984400 18.625 100 20 40 1 1885808752 5903888 4920464
23:26:46 8173 8192000000 10793362736 11225550848 1877031616 18.641 100 26 52 0 1894995472 10751120 7212736
23:27:00 7999 8192000000 10800553952 11231801344 1888655664 18.735 100 23 46 1 1900296272 5234272 6406336
23:27:15 5280 8192000000 10839093168 11252264960 1909215728 18.900 100 49 95 6 1929187120 5424960 14546432
23:27:29 7094 8192000000 10857326512 11271319552 1921241664 18.997 100 67 135 3 1949178240 7928048 20008528
23:27:43 5443 8192000000 10876317920 11280302080 1928005200 19.051 100 71 142 2 1956454000 9014080 19434720
23:27:55 15450 8192000000 10870938000 11289694208 1933464480 19.095 100 77 154 2 1966334768 10794528 22075760
23:28:18 58076 8192000000 10860502832 11296784384 1934096224 19.100 100 51 102 0 1961296912 12552128 14648560
23:29:26 20502 8192000000 10879952784 11300364288 1943357728 19.174 100 55 110 2 1968102000 9321248 15423024
23:29:53 20982 8192000000 10887660352 11312779264 1952928176 19.250 100 62 125 2 1982824576 12072864 17823536
23:30:29 23519 8192000000 10900157040 11327893504 1960129264 19.307 100 54 108 0 1995344784 18996352 16219168
23:30:59 26186 8192000000 10901748320 11333533696 1966667072 19.359 100 50 99 1 1995530640 14258176 14605392
23:31:36 12890 8192000000 10922563600 11351183360 1977262032 19.443 100 60 119 0 2014064112 19763824 17038256
23:32:00 11772 8192000000 10914279840 11341844480 1958586224 19.295 99 56 110 1 1994137408 19710016 15841168
23:32:19 8906 8192000000 10927398640 11351330816 1976944624 19.441 100 65 128 0 2015650688 20487984 18218080
23:32:35 3712 8192000000 10932543600 11353833472 1974581920 19.422 100 65 129 0 2014505552 21499088 18424544
23:32:47 7059 8192000000 10939170112 11360571392 1984406800 19.500 100 75 150 2 2028208336 22278496 21523040
23:33:13 6118 8192000000 10933380576 11360079872 1987042656 19.520 100 65 130 2 2028748512 22962192 18743664
23:33:42 7272 8192000000 10944479168 11373125632 1989918848 19.543 100 58 116 1 2029213360 22904608 16389904
23:34:09 7750 8192000000 10940373408 11374145536 1997087104 19.600 100 58 115 3 2035661936 22624528 15950304
23:34:28 14646 8192000000 10933714928 11374686208 1992408080 19.563 100 51 100 1 2030290272 22882336 14999856
23:34:57 34954 8192000000 10952329408 11392290816 1996033184 19.591 100 50 100 2 2042895280 31781344 15080752
23:35:46 5223 8192000000 10960536720 11394277376 2007128064 19.679 100 58 117 0 2054901040 29415408 18357568
23:36:03 10655 8192000000 10960348064 11397496832 2007091408 19.679 100 48 98 0 2052438592 30488480 14858704
23:36:21 6372 8192000000 10968022320 11402051584 2009946640 19.701 100 48 96 1 2056398992 31751392 14700960
23:36:36 6043 8192000000 10976231408 11413061632 2014308272 19.735 100 56 112 2 2064096656 33486096 16302288
23:36:54 10623 8192000000 10963728288 11404169216 2012779696 19.723 100 48 96 0 2056045952 28163952 15102304
23:37:11 14625 8192000000 10974831760 11411476480 2018364912 19.767 100 49 97 1 2061690640 28191232 15134496
23:37:34 10874 8192000000 10989498928 11422162944 2028698768 19.848 100 65 129 4 2078337008 29743552 19894688
23:37:54 10131 8192000000 10979430368 11420016640 2025129328 19.820 100 55 109 5 2072952160 30335648 17487184
23:38:13 8383 8192000000 10985709072 11428454400 2026507216 19.831 100 44 88 0 2070600560 30176288 13917056
23:38:31 6684 8192000000 10994361584 11432595456 2034618224 19.895 100 60 120 4 2085900208 32256416 19025568
23:38:44 1925 8192000000 10990097184 11424432128 2030835728 19.865 100 59 118 0 2083084560 33507632 18741200
23:38:56 7474 8192000000 10974519008 11408461824 1993443456 19.571 98 54 108 0 2045136752 34808192 16885104
23:39:16 9345 8192000000 10999676816 11431161856 2023438768 19.807 100 58 116 1 2078634480 37526592 17669120
23:39:35 5914 8192000000 11006595648 11442434048 2012489376 19.721 99 61 123 1 2070329024 39509600 18330048
23:39:50 4608 8192000000 11013839184 11435909120 2037365984 19.916 100 81 163 0 2102711152 39563840 25781328
23:40:02 5742 8192000000 11021141984 11445456896 2041029392 19.945 100 70 140 0 2104311040 41420672 21860976
23:40:14 3043 8192000000 10981347008 11401576448 1998379248 19.610 99 73 144 0 2063921280 42872656 22669376
23:40:24 6037 8192000000 11000856128 11420971008 2014956256 19.741 100 73 145 2 2082784496 44250000 23578240
23:40:38 3449 8192000000 10997061536 11418718208 2012246560 19.719 100 76 152 1 2083045712 46919584 23879568
23:40:48 2714 8192000000 10997606320 11416154112 2009039120 19.694 100 80 160 0 2080891376 46568048 25284208
23:41:01 6847 8192000000 10996296672 11420938240 2012137664 19.718 100 68 135 0 2079701136 46459760 21103712
23:41:17 4877 8192000000 10975484896 11408125952 1997950240 19.607 100 58 116 1 2063198400 45587008 19661152
23:41:31 5338 8192000000 10970482016 11383750656 1990472576 19.548 99 83 165 2 2059517984 44012976 25032432
23:41:44 5521 8192000000 10983552048 11400519680 1997363120 19.602 100 75 148 0 2064521472 44560160 22598192
23:42:00 4436 8192000000 10986773808 11407106048 1987477264 19.524 99 83 166 1 2059313152 45718880 26117008
23:42:13 4434 8192000000 10977635264 11393634304 1979772064 19.463 99 83 165 1 2051150944 45214752 26164128
23:42:25 7784 8192000000 10987134176 11402924032 1995635424 19.588 100 80 160 1 2068169952 48252416 24282112
23:42:40 3179 8192000000 11014554000 11422625792 2013532960 19.729 100 82 164 1 2087682352 48841248 25308144
23:42:54 3288 8192000000 11009069824 11426004992 2015555120 19.745 100 84 168 2 2092309776 50335136 26419520
23:43:07 5992 8192000000 11001325904 11424817152 2011387344 19.712 100 73 146 1 2084371248 49893968 23089936
23:43:22 7419 8192000000 10981365568 11411169280 1985158000 19.506 99 64 128 1 2053203536 47935168 20110368
23:43:37 3804 8192000000 10990493360 11413905408 2003783008 19.653 100 66 131 2 2073962624 49512368 20667248
23:43:49 1757 8192000000 10971201520 11386765312 1976129520 19.434 99 75 149 2 2048280768 48501392 23649856
23:44:03 4136 8192000000 10982261376 11398971392 1987998864 19.528 100 78 156 1 2064530320 51209872 25321584
23:44:17 1458 8192000000 10976970128 11386441728 1976912224 19.440 100 79 156 2 2053922496 52012832 24997440
23:44:25 2730 8192000000 10959016640 11367436288 1942360432 19.166 98 80 158 0 2023735376 55589680 25785264
23:44:35 3305 8192000000 10977754384 11390672896 1977207008 19.443 100 86 172 0 2059886640 55518576 27161056
23:44:45 2019 8192000000 10992301184 11398955008 1981915840 19.480 100 94 188 0 2070010592 58334864 29759888
23:44:55 3293 8192000000 10983028432 11390566400 1963472608 19.334 99 83 166 0 2049689664 60081008 26136048
23:45:06 4958 8192000000 10978026128 11392454656 1977185600 19.442 100 72 144 0 2057492064 57223552 23082912
23:45:20 1622 8192000000 10987840512 11392729088 1976181376 19.434 100 91 180 1 2063373584 57915136 29277072
23:45:29 1055 8192000000 10990624928 11397537792 1985445536 19.508 100 94 185 1 2069040832 55592480 28002816
23:45:36 831 8192000000 10970395040 11384119296 1956863488 19.281 99 80 159 1 2038356768 56795104 24698176
23:45:47 3855 8192000000 10935617792 11360436224 1930544960 19.071 98 69 136 0 2005733056 53146144 22041952
23:45:58 5489 8192000000 10954966704 11377967104 1967113968 19.363 100 62 124 3 2038786672 51244272 20428432
23:46:12 8858 8192000000 10935413296 11362762752 1935362784 19.110 99 46 88 2 2001548608 51060096 15125728
23:46:28 3647 8192000000 10934896912 11366154240 1959631744 19.303 100 49 98 0 2022520816 46515200 16373872
23:46:45 15654 8192000000 10927928224 11365318656 1950144048 19.228 100 51 102 0 2019046736 52060592 16842096
23:47:12 3749 8192000000 10936922176 11363229696 1957749936 19.288 100 64 128 0 2022749952 44832096 20167920
23:47:29 10812 8192000000 10928110400 11364085760 1944041440 19.179 99 45 90 0 2004892384 45803600 15047344
23:47:52 12749 8192000000 10924003984 11370053632 1959933696 19.306 100 36 72 1 2016651888 44736336 11981856
23:48:11 22159 8192000000 10922525936 11362029568 1921518112 18.999 98 37 74 2 1983200928 48925680 12757136
23:48:40 12485 8192000000 10924589424 11367112704 1947631056 19.208 100 39 78 0 2015448944 54760016 13057872
23:49:06 21099 8192000000 10907421088 11351379968 1910417808 18.910 98 37 74 1 1968515600 44834976 13262816
23:49:38 13679 8192000000 10899344032 11339689984 1919661984 18.984 99 35 70 0 1979117120 47251968 12203168
23:50:08 8605 8192000000 10898969920 11341991936 1923398752 19.014 99 37 74 0 1975491664 39354368 12738544
23:50:24 16532 8192000000 10894648192 11338452992 1912184048 18.924 99 27 54 0 1959525280 38206080 9135152
23:50:47 14101 8192000000 10871686304 11325202432 1915267360 18.949 100 23 46 1 1961875936 38410128 8198448
23:51:11 22670 8192000000 10904240784 11341189120 1915533776 18.951 99 37 74 2 1966425552 38799504 12092272
23:51:42 11608 8192000000 10911958640 11354796032 1933961888 19.099 100 30 60 0 1993046544 48485600 10599056
23:52:04 8722 8192000000 10901323824 11343241216 1920940032 18.994 100 26 52 0 1978127088 48440224 8746832
23:52:25 13407 8192000000 10883861792 11327856640 1886845936 18.720 98 30 61 0 1946843232 49433472 10563824
23:52:45 16449 8192000000 10883854336 11330883584 1912693040 18.928 100 22 44 0 1968178976 47249040 8236896
23:53:09 9232 8192000000 10880006768 11339472896 1910399120 18.910 100 27 54 0 1971023840 50943952 9680768
23:53:26 21762 8192000000 10885721584 11335757824 1918396672 18.974 100 32 64 2 1973749552 44398944 10953936
23:53:58 23244 8192000000 10885093248 11350220800 1902112016 18.843 99 13 26 0 1948246720 41673552 4461152
23:54:29 29524 8192000000 10864211616 11348582400 1927215536 19.045 100 12 24 0 1960692048 29900800 3575712
23:55:09 19064 8192000000 10874573536 11321774080 1922652672 19.008 99 25 51 1 1938559440 8777680 7129088
23:55:37 26177 8192000000 10859898832 11311038464 1902990656 18.850 98 49 96 2 1929987184 12427664 14568864
23:56:17 93846 8192000000 10865922016 11320483840 1895021248 18.786 98 18 36 0 1916584448 16173984 5389216
23:57:57 125551 8192000000 10890068320 11342934016 1934153232 19.100 99 39 76 3 1960357824 15056640 11147952
00:00:28 65555 8192000000 10881636256 11347292160 1917316688 18.965 98 28 56 0 1940566192 15652240 7597264
00:02:15 45531 8192000000 10865275136 11319754752 1840066688 18.341 95 24 48 1 1865288192 18845088 6376416
00:03:15 60525 8192000000 10882987104 11331358720 1894502672 18.782 97 26 51 0 1911492224 8986256 8003296
00:04:35 41994 8192000000 10886450576 11345035264 1951496720 19.238 100 20 40 3 1974386064 16815632 6073712
00:05:24 32816 8192000000 10889564576 11355103232 1958456128 19.294 100 11 22 0 1972313328 10751056 3106144
00:06:06 30624 8192000000 10906280144 11362779136 1967583472 19.366 100 13 26 1 1981481584 10363488 3534624
00:06:46 29051 8192000000 10886268880 11357970432 1960377824 19.309 99 12 24 1 1972850672 9241488 3231360
00:07:25 37421 8192000000 10893026512 11362492416 1974385984 19.420 100 11 22 1 1985263744 8128752 2749008
00:08:11 24395 8192000000 10895376016 11356954624 1958019344 19.290 99 33 66 0 1978377472 10379952 9978176
00:08:45 44843 8192000000 10916451584 11369295872 1960476592 19.310 99 24 46 1 1977577104 10520656 6579856
00:09:41 61051 8192000000 10923703264 11391361024 1992786048 19.566 100 29 58 1 2020680656 19093552 8801056
00:11:23 119790 8192000000 10909140640 11372761088 1976189120 19.435 99 18 37 1 1998862960 16894864 5778976
00:13:31 84033 8192000000 10928030832 11396558848 1996375232 19.594 100 15 30 1 2008069376 7371776 4322368
00:15:06 2037 8192000000 10939077552 11404480512 2006384864 19.673 100 29 60 0 2023035120 8894944 7755312
00:15:14 34579 8192000000 10962531024 11411431424 2011270240 19.712 100 28 56 0 2030319312 11446240 7602832
00:16:08 36849 8192000000 10911515472 11385991168 1969173264 19.379 98 18 36 0 1983156352 8996080 4987008
00:16:56 62699 8192000000 10926116928 11396628480 2000792912 19.629 100 15 29 1 2012862112 7515216 4553984
00:18:05 91912 8192000000 10935445360 11412455424 2010703136 19.707 100 23 46 2 2026721328 8900944 7117248
00:19:43 76819 8192000000 10931808592 11427090432 1993930928 19.575 99 10 20 1 2010452288 13310944 3210416
00:21:06 62794 8192000000 10952161664 11435618304 2017686608 19.762 100 14 28 2 2047667984 25389680 4591696
00:22:16 51855 8192000000 10951168128 11435515904 2023557104 19.808 100 16 32 1 2048251168 19828384 4865680
00:23:15 47156 8192000000 10944555568 11426226176 2008410112 19.689 99 20 40 1 2028952704 14637936 5904656
00:24:15 60827 8192000000 10937685840 11415158784 1962230864 19.324 97 22 44 2 1977984752 10059056 5694832
00:25:34 64140 8192000000 10931904240 11423473664 1991576768 19.556 99 15 30 0 2009594208 13707504 4309936
00:26:48 44466 8192000000 10942197312 11406934016 1986514224 19.516 99 26 52 1 2009067808 14358640 8194944
00:27:40 42181 8192000000 10924085600 11403206656 1970501312 19.389 98 21 40 1 1987290928 11249904 5539712
00:28:29 67452 8192000000 10910570208 11395436544 1926683200 19.040 96 11 22 1 1946333120 16695904 2954016
00:29:43 106253 8192000000 10927455152 11407327232 1962953248 19.330 98 17 34 1 1979775296 12062464 4759584
00:31:36 41422 8192000000 10909507920 11386589184 1936787120 19.121 97 13 26 0 1951388096 11480656 3120320
00:33:34 21278 8192000000 10924605616 11365474304 1959210272 19.300 99 45 91 3 1977927168 6698256 12018640
00:34:03 132093 8192000000 10878931984 11354574848 1923026160 19.011 97 33 66 0 1941901056 9235456 9639440
00:36:26 37809 8192000000 10907091488 11365957632 1928789552 19.057 97 31 62 0 1948281008 11003712 8487744
00:37:11 12544 8192000000 10872676128 11326902272 1924557360 19.023 97 36 72 3 1948708240 14176800 9974080
00:37:46 61479 8192000000 10889391216 11362791424 1959530336 19.302 100 30 60 0 1981779360 13813936 8435088
00:38:57 68972 8192000000 10872978224 11355213824 1904845488 18.865 97 7 14 0 1920413968 13634784 1933696
00:40:12 39378 8192000000 10875384336 11350564864 1939530944 19.143 99 20 39 1 1957261232 12312720 5417568
00:41:03 48445 8192000000 10869733744 11350315008 1906045632 18.875 97 15 30 0 1924631824 13711440 4874752
00:42:47 49191 8192000000 10889529104 11380129792 1950846816 19.233 99 11 22 2 1966955008 12612352 3495840
00:43:43 41520 8192000000 10855681472 11335479296 1905599728 18.871 97 16 32 1 1919771296 9622112 4549456
00:44:32 71401 8192000000 10874119616 11353485312 1937727552 19.129 99 16 32 1 1953014416 10865568 4421296
00:45:55 83726 8192000000 10897660528 11361955840 1917099168 18.964 97 22 44 0 1931300784 7889344 6312272
00:47:24 62060 8192000000 10871218368 11352805376 1880695856 18.671 95 23 46 0 1901549152 14470464 6382832
00:48:33 42862 8192000000 10886881808 11341615104 1876400960 18.636 96 21 41 1 1896580592 14640896 5538736
00:49:27 47734 8192000000 10884902512 11369123840 1946993008 19.203 100 16 32 0 1971116096 19337040 4786048
00:50:22 53277 8192000000 10897807056 11350831104 1917019664 18.963 98 26 52 0 1936636416 12802800 6813952
00:51:22 28910 8192000000 10898183792 11353853952 1938962176 19.138 99 38 76 2 1960536656 10730208 10844272
00:51:58 40339 8192000000 10894939984 11347476480 1894414016 18.781 97 45 89 0 1919106800 12538368 12154416
00:52:47 13919 8192000000 10904711504 11350880256 1957444032 19.286 100 49 97 1 1981609504 10796608 13368864
00:53:12 7952 8192000000 10890980288 11335557120 1942105184 19.164 100 54 108 1 1969654800 12607872 14941744
00:53:31 73463 8192000000 10828056592 11286212608 1785213616 17.892 92 26 52 1 1805426592 13135616 7077360
00:54:52 111109 8192000000 10867754320 11321929728 1901693968 18.840 99 12 24 1 1923627344 18145664 3787712
00:57:00 39554 8192000000 10859271328 11327123456 1908725936 18.896 98 46 92 0 1933486784 11897424 12863424
00:57:50 52258 8192000000 10867899984 11333246976 1918426592 18.974 98 36 72 0 1935909696 7701536 9781568
00:58:48 36416 8192000000 10872885200 11343360000 1954725024 19.264 100 18 36 0 1969335728 9701264 4909440
00:59:34 50113 8192000000 10876667296 11360387072 1967725440 19.367 100 10 20 0 1978774560 8360480 2688640
01:02:50 55068 8192000000 10902960208 11376521216 1964075856 19.338 99 12 24 0 1974254560 6861808 3316896
01:03:58 45915 8192000000 10918353744 11389530112 1989502784 19.540 100 18 37 2 2006372240 11056688 5812768
01:04:57 37466 8192000000 10942644208 11401965568 1997292272 19.601 100 30 59 3 2017736656 11751936 8692448
01:05:55 96922 8192000000 10918123344 11398402048 1921703856 19.000 96 15 30 0 1949322144 23240304 4377984
01:08:04 54642 8192000000 10914965216 11381825536 1971718384 19.399 99 15 29 0 1987313840 11432016 4163440
01:09:05 32141 8192000000 10926076496 11385995264 1953476192 19.254 98 37 73 1 1980231488 16296832 10458464
01:09:43 99633 8192000000 10915059728 11389702144 1939641920 19.144 98 10 20 0 1962155312 19784480 2728912
01:11:39 47619 8192000000 10907099040 11363684352 1891377216 18.757 95 27 54 2 1911794080 12245824 8171040
01:12:33 28174 8192000000 10880284112 11355729920 1940613936 19.152 99 24 48 1 1961753776 14571824 6568016
01:13:13 89572 8192000000 10888095808 11341250560 1892039072 18.762 96 22 44 0 1910436240 12218560 6178608
01:14:50 25324 8192000000 10869931456 11323260928 1900153232 18.828 97 36 72 2 1920492032 10302448 10036352
01:15:22 128880 8192000000 10875226896 11334238208 1916603632 18.960 98 22 44 2 1934547792 11627280 6316880
01:17:45 84930 8192000000 10905458784 11378425856 1966261952 19.356 100 22 44 1 1987815776 15629104 5924720
01:19:16 22090 8192000000 10891982832 11368054784 1964549584 19.342 100 18 36 1 1987086576 16915072 5621920
01:20:00 103654 8192000000 10896795328 11375198208 1942262544 19.165 98 19 38 0 1962138832 14294352 5581936
01:22:13 64746 8192000000 10902353696 11385720832 1934941456 19.106 98 17 34 1 1964763136 24599360 5222320
01:23:24 61363 8192000000 10880603232 11365453824 1941923120 19.162 99 7 14 0 1960493056 16417200 2152736
01:25:39 76445 8192000000 10897268576 11345637376 1905227152 18.868 97 22 44 1 1920742896 9235664 6280080

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-01-2021 01:28:43 to 26-01-2021 01:29:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

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          235146
MON$OLDEST_ACTIVE               237378
MON$OLDEST_SNAPSHOT             237378
MON$NEXT_TRANSACTION            237378
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                       2025888
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:437: 
:438: mscs-test-161.budzdorov.ru    Tue Jan 26 01:27:13 2021
:439:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:440: 
:441: 
:442: mscs-test-161.budzdorov.ru    Tue Jan 26 01:27:18 2021
:443:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:444: 
:445: 
:446: mscs-test-161.budzdorov.ru    Tue Jan 26 01:27:18 2021
:447:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:448: 
:449: 
:450: mscs-test-161.budzdorov.ru    Tue Jan 26 01:27:18 2021
:451:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:452: 
:453: 
:454: mscs-test-161.budzdorov.ru    Tue Jan 26 01:27:18 2021
:455:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:456: 
--- end of diff output ---

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

26.01.21 01:29:19. 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-01-26 01:29:21 No severe PSQL-related problems occured
26.01.21 01:29:23. End of report.