Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.12.2020 16: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 17251800 kB
MemAvailable 31466220 kB
Buffers 0 kB
Cached 14410752 kB
SwapCached 3696 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-21 16:28:07
DTS_END                         2020-12-21 16:28:07.8010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44934
TRN_ID                          249432
ATT_ID                          728
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: 9825.92 21111 1179111
customer order: creation 174.50 354 20940
customer order: refuse 14.99 331 1799
order to supplier: creation 48.17 1188 5780
order to supplier: removal 3.88 86176 465
invoice (draft): creation 46.03 2845 5524
invoice (draft): removal 58.78 623 7053
invoice accept: apply 41.88 16768 5025
invoice accept: cancel 52.86 659 6343
customer reserve: creation 3887.28 166 466474
customer reserve: removal 5184.59 50 622151
realization accept: apply 88.20 158 10584
realization accept: cancel 93.55 94 11226
payment from customer: creation 59.89 89 7187
payment from customer: removal 5.90 80 708
payment to supplier: creation 50.09 112 6011
payment to supplier: removal 3.51 68 421
service: total inventory turnovers 4.68 959 561
service: total monetary turnovers 6.28 33 754
service: aggregate perf. data 0.84 18815 101
service: refresh index statistics 0.03 292658 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-12-2020 16:29:12 to 21-12-2020 16:29:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2102
TEST_TIME 2 3589
TEST_TIME 3 4516
TEST_TIME 4 4849
TEST_TIME 5 4907
TEST_TIME 6 5089
TEST_TIME 7 5369
TEST_TIME 8 5630
TEST_TIME 9 5532
TEST_TIME 10 5866
TEST_TIME 11 6353
TEST_TIME 12 6935
TEST_TIME 13 6930
TEST_TIME 14 7347
TEST_TIME 15 7961
TEST_TIME 16 8692
TEST_TIME 17 9053
TEST_TIME 18 9157
TEST_TIME 19 10200
TEST_TIME 20 11105
TEST_TIME 21 11593
TEST_TIME 22 11970
TEST_TIME 23 11816
TEST_TIME 24 11927
TEST_TIME 25 11618
TEST_TIME 26 11326
TEST_TIME 27 11568
TEST_TIME 28 11670
TEST_TIME 29 11327
TEST_TIME 30 11078
TEST_TIME 31 10933
TEST_TIME 32 10768
TEST_TIME 33 10748
TEST_TIME 34 10648
TEST_TIME 35 10523
TEST_TIME 36 10334
TEST_TIME 37 10240
TEST_TIME 38 10187
TEST_TIME 39 10308
TEST_TIME 40 10529
TEST_TIME 41 10682
TEST_TIME 42 10640
TEST_TIME 43 10586
TEST_TIME 44 10528
TEST_TIME 45 10614
TEST_TIME 46 10591
TEST_TIME 47 10641
TEST_TIME 48 10731
TEST_TIME 49 10653
TEST_TIME 50 10727
TEST_TIME 51 10633
TEST_TIME 52 10539
TEST_TIME 53 10439
TEST_TIME 54 10337
TEST_TIME 55 10293
TEST_TIME 56 10281
TEST_TIME 57 10289
TEST_TIME 58 10208
TEST_TIME 59 10154
TEST_TIME 60 10016
TEST_TIME 61 9937
TEST_TIME 62 9939
TEST_TIME 63 10129
TEST_TIME 64 10108
TEST_TIME 65 10165
TEST_TIME 66 10164
TEST_TIME 67 10204
TEST_TIME 68 10279
TEST_TIME 69 10295
TEST_TIME 70 10340
TEST_TIME 71 10306
TEST_TIME 72 10301
TEST_TIME 73 10285
TEST_TIME 74 10378
TEST_TIME 75 10363
TEST_TIME 76 10260
TEST_TIME 77 10230
TEST_TIME 78 10137
TEST_TIME 79 10097
TEST_TIME 80 10074
TEST_TIME 81 10087
TEST_TIME 82 10031
TEST_TIME 83 9995
TEST_TIME 84 9918
TEST_TIME 85 9838
TEST_TIME 86 9901
TEST_TIME 87 9837
TEST_TIME 88 9849
TEST_TIME 89 9858
TEST_TIME 90 9822
TEST_TIME 91 9882
TEST_TIME 92 9941
TEST_TIME 93 9958
TEST_TIME 94 9927
TEST_TIME 95 10013
TEST_TIME 96 9995
TEST_TIME 97 10037
TEST_TIME 98 10007
TEST_TIME 99 9995
TEST_TIME 100 10013
TEST_TIME 101 10045
TEST_TIME 102 10061
TEST_TIME 103 9981
TEST_TIME 104 9935
TEST_TIME 105 9907
TEST_TIME 106 9925
TEST_TIME 107 9877
TEST_TIME 108 9835
TEST_TIME 109 9780
TEST_TIME 110 9790
TEST_TIME 111 9849
TEST_TIME 112 9863
TEST_TIME 113 9838
TEST_TIME 114 9850
TEST_TIME 115 9814
TEST_TIME 116 9800
TEST_TIME 117 9884
TEST_TIME 118 9875
TEST_TIME 119 9905
TEST_TIME 120 9826

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-12-2020 16:29:16 to 21-12-2020 16:29:19.

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 1612474 1612474 0 0.00 0 34787 5 0 0
doc_list_biud 1612474 1612474 0 0.00 0 37965 25 0 0
sp_add_invoice_to_stock 5155 5025 130 2.52 40 165568 16768 0 130
sp_cancel_adding_invoice 6343 6343 0 0.00 5 67866 659 0 0
sp_cancel_client_order 1799 1799 0 0.00 4 12605 331 0 0
sp_cancel_customer_reserve 622151 622151 0 0.00 1 21936 51 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 4271 80 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 5454 69 0 0
sp_cancel_supplier_invoice 7069 7053 16 0.22 1 16341 623 0 16
sp_cancel_supplier_order 465 465 0 0.00 8 1113712 86176 0 0
sp_cancel_write_off 11226 11226 0 0.00 1 7974 95 0 0
sp_client_order 20940 20940 0 0.00 4 37857 355 0 0
sp_customer_reserve 466474 466474 0 0.00 0 51735 166 0 0
sp_fill_shopping_cart 32235 32235 0 0.00 1 13835 35 0 0
sp_fill_shopping_cart_clo_res 466474 466474 0 0.00 0 16360 12 0 0
sp_get_clo_for_invoice 5025 5025 0 0.00 0 15695 300 0 0
sp_kill_cost_storno 18698 18698 0 0.00 0 6669 44 0 0
sp_kill_qstorno_ret_qs2qd 1263046 1263046 0 0.00 0 21224 27 0 0
sp_kill_qty_storno 664646 664646 0 0.00 0 37965 59 0 0
sp_lock_selected_doc 21609 21609 0 0.00 0 9164 6 0 0
sp_make_cost_storno 28807 28807 0 0.00 0 34775 49 0 0
sp_multiply_rows_for_pdistr 28807 28807 0 0.00 0 7720 23 0 0
sp_multiply_rows_for_qdistr 20940 20940 0 0.00 0 10484 161 0 0
sp_pay_from_customer 7187 7187 0 0.00 4 8884 90 0 0
sp_pay_to_supplier 6011 6011 0 0.00 5 9476 112 0 0
sp_payment_common 13198 13198 0 0.00 1 8469 23 0 0
sp_qd_handle_on_cancel_clo 1799 1799 0 0.00 0 12594 291 0 0
sp_qd_handle_on_invoice_upd_sts 11368 11368 0 0.00 0 37964 280 0 0
sp_qd_handle_on_reserve_upd_sts 10584 10584 0 0.00 0 19411 59 0 0
sp_reserve_write_off 10584 10584 0 0.00 6 19487 159 0 0
sp_supplier_invoice 5524 5524 0 0.00 7 72139 2846 0 0
sp_supplier_order 5780 5780 0 0.00 5 39135 1188 0 0
srv_aggregate_perf_data 101 101 0 0.00 2683 461331 18815 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1310 165628 33930 0 0
srv_find_qd_qs_mism 1131400 1131400 0 0.00 0 27793 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 36 19546 959 0 0
srv_make_money_saldo 754 754 0 0.00 1 6838 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 134551 367072 292658 0 0
t$perf-abend:sp_add_invoice_to_stock 130 130 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 16 16 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5025 5025 0 0.00 0 21139 164 0 0
t$perf-norm:sp_cancel_adding_invoice 398 398 0 0.00 0 3786 96 0 0
t$perf-norm:sp_cancel_client_order 1799 1799 0 0.00 0 19701 21 0 0
t$perf-norm:sp_cancel_customer_reserve 727 727 0 0.00 0 907 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 2853 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 3175 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 614 16 0 0
t$perf-norm:sp_cancel_supplier_order 465 465 0 0.00 0 28016 1307 0 0
t$perf-norm:sp_cancel_write_off 1060 1060 0 0.00 0 4845 16 0 0
t$perf-norm:sp_client_order 20940 20940 0 0.00 0 13744 18 0 0
t$perf-norm:sp_customer_reserve 1008 1008 0 0.00 0 5201 9 0 0
t$perf-norm:sp_pay_from_customer 7187 7187 0 0.00 0 12196 14 0 0
t$perf-norm:sp_pay_to_supplier 6011 6011 0 0.00 0 13421 10 0 0
t$perf-norm:sp_reserve_write_off 10584 10584 0 0.00 0 10816 10 0 0
t$perf-norm:sp_supplier_invoice 5524 5524 0 0.00 0 5527 17 0 0
t$perf-norm:sp_supplier_order 5780 5780 0 0.00 0 10205 12 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 176 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 3263 32 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 946 13 0 0
t$perf-norm:srv_make_money_saldo 754 754 0 0.00 0 1806 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10310 10050 260 2.52 0 6126 17 0 260
v_all_customers 37766 37766 0 0.00 0 25 1 0 0
v_all_suppliers 31366 31366 0 0.00 0 18 1 0 0
v_all_wares 41878 41878 0 0.00 0 58 1 0 0
v_cancel_adding_invoice 796 796 0 0.00 0 755 7 0 0
v_cancel_client_order 3598 3598 0 0.00 0 2942 7 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 1776 4 0 0
v_cancel_customer_reserve 1454 1454 0 0.00 0 451 3 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 2810 8 0 0
v_cancel_supplier_invoice 876 844 32 3.65 0 622 14 0 32
v_cancel_supplier_order 930 930 0 0.00 0 3387 9 0 0
v_cancel_write_off 2120 2120 0 0.00 0 2117 14 0 0
v_max_id_clo_ord 5780 5780 0 0.00 0 195 1 0 0
v_max_id_clo_res 1008 1008 0 0.00 0 2047 15 0 0
v_max_id_ord_sup 5516 5516 0 0.00 0 4572 4 0 0
v_max_non_paid_invoice 1624 1624 0 0.00 0 1624 3 0 0
v_max_non_paid_realizn 3967 3967 0 0.00 0 4712 6 0 0
v_min_id_clo_ord 5780 5780 0 0.00 0 1742 5 0 0
v_min_id_clo_res 1008 1008 0 0.00 0 7001 15 0 0
v_min_id_ord_sup 5516 5516 0 0.00 0 5245 7 0 0
v_min_non_paid_invoice 6011 6011 0 0.00 0 4593 11 0 0
v_min_non_paid_realizn 7187 7187 0 0.00 0 8464 11 0 0
v_our_firm 10552 10552 0 0.00 0 20 1 0 0
v_reserve_write_off 21168 21168 0 0.00 0 3182 5 0 0
x_lock_depdocs_on_canc_invoice 12974 12974 0 0.00 0 18567 107 0 0
x_lock_depdocs_on_canc_sup_ord 465 465 0 0.00 0 21100 340 0 0
x_make_qstorno_1000_1200 5780 5780 0 0.00 1 39119 1120 0 0
x_make_qstorno_1200_2000 5524 5524 0 0.00 3 71085 2714 0 0
x_make_qstorno_2100_3300 466474 466474 0 0.00 0 51734 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-12-2020 16:29:20 to 21-12-2020 16:29:24.

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
13:58:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:58:18 8143 8192000000 10178440992 10477592576 864898720 9.549 67 55 111 0 885984608 2522432 18563456
13:58:33 7885 8192000000 10292526656 10605535232 1341415936 14.070 100 83 164 1 1373282928 4162816 27704176
13:58:51 18994 8192000000 10341796720 10665099264 1405933792 14.648 100 87 174 0 1439389968 5303344 28152832
13:59:22 27442 8192000000 10407714496 10732138496 1452390448 15.059 100 90 180 1 1488411760 7008336 29012976
13:59:58 29190 8192000000 10435552576 10766532608 1485249840 15.347 100 85 170 0 1520491120 7993328 27247952
14:00:35 17109 8192000000 10456104688 10795044864 1508578048 15.551 100 88 176 1 1545192624 8778224 27836352
14:01:13 25672 8192000000 10488834640 10829852672 1537331328 15.800 100 83 166 1 1572546656 9375904 25839424
14:01:48 16483 8192000000 10493848928 10840580096 1554679792 15.950 100 85 170 1 1590633120 9972240 25981088
14:02:17 14743 8192000000 10519719712 10865385472 1573007264 16.108 100 82 165 0 1608638128 10597952 25032912
14:02:40 3885 8192000000 10536204480 10886074368 1595430032 16.300 100 86 172 1 1632435744 11137248 25868464
14:02:58 9014 8192000000 10555043728 10910060544 1610906704 16.432 100 84 167 1 1646711344 11134800 24669840
14:03:15 13081 8192000000 10570810032 10928074752 1624258288 16.546 100 79 158 2 1659199760 11479616 23461856
14:03:37 9956 8192000000 10585440112 10944876544 1640102032 16.681 100 80 160 1 1675338896 11559424 23677440
14:03:55 11696 8192000000 10607805872 10973171712 1661362992 16.860 100 80 160 1 1696494192 12150336 22980864
14:04:15 10940 8192000000 10618085584 10987466752 1680512800 17.022 100 76 152 0 1714857376 12575392 21769184
14:04:33 9797 8192000000 10646485008 11017756672 1701198240 17.195 100 75 150 0 1735012944 12618416 21196288
14:04:50 6265 8192000000 10658157472 11030839296 1720114608 17.353 100 81 159 3 1755481472 12503200 22863664
14:05:04 4858 8192000000 10669215808 11041042432 1730225360 17.437 100 76 152 1 1764396896 12415296 21756240
14:05:17 6888 8192000000 10687000528 11063967744 1740561600 17.523 100 81 161 2 1776365888 13610512 22193776
14:05:30 3579 8192000000 10694164992 11066531840 1752025440 17.618 100 90 180 1 1792467280 14910112 25531728
14:05:40 3999 8192000000 10709131808 11084754944 1763810208 17.716 100 84 168 0 1801745888 13906528 24029152
14:05:51 3979 8192000000 10712568752 11092918272 1772460848 17.787 100 84 170 0 1808829920 13099920 23269152
14:06:02 4776 8192000000 10717322016 11097399296 1778664384 17.838 100 84 168 0 1815076192 13440720 22971088
14:06:14 2602 8192000000 10717644080 11096338432 1787223584 17.909 100 90 179 2 1826771152 14781488 24766080
14:06:23 3501 8192000000 10728474128 11108286464 1790951760 17.940 100 83 163 1 1828797760 15007920 22838080
14:06:33 2285 8192000000 10739355936 11121348608 1800208864 18.016 100 87 174 2 1838727664 13979424 24539376
14:06:42 1855 8192000000 10757631808 11135856640 1810290304 18.098 100 88 173 0 1848016032 13955088 23770640
14:06:51 7193 8192000000 10746615728 11136122880 1814731920 18.135 100 77 150 4 1849140656 12849616 21559120
14:07:04 3732 8192000000 10751841792 11142283264 1816050928 18.145 100 76 151 1 1848876096 11760304 21064864
14:07:14 2360 8192000000 10781482704 11165138944 1836849616 18.315 100 88 176 2 1874165520 12608304 24707600
14:07:23 1817 8192000000 10787024304 11172622336 1847039424 18.398 100 92 185 1 1885882320 13061248 25781648
14:07:31 1404 8192000000 10795367280 11182723072 1850606976 18.427 100 94 185 4 1890851680 13671200 26573504
14:07:39 1417 8192000000 10803798512 11189190656 1859102976 18.496 100 97 195 1 1900413536 13957680 27352880
14:07:46 2503 8192000000 10801466864 11192360960 1862003968 18.520 100 92 184 2 1902361728 14143696 26214064
14:07:55 1579 8192000000 10811142752 11197878272 1863816144 18.534 100 97 192 2 1904598720 13844304 26938272
14:08:03 1402 8192000000 10813501824 11202035712 1864465264 18.539 100 88 174 1 1903148736 14211184 24472288
14:08:11 1132 8192000000 10811913824 11202662400 1868521952 18.572 100 94 189 2 1909286832 13983152 26781728
14:08:18 2029 8192000000 10800911008 11200385024 1869885920 18.583 100 85 171 2 1907164592 12928928 24349744
14:08:27 3140 8192000000 10793987088 11200716800 1864094832 18.536 100 60 121 2 1893184880 11861600 17228448
14:08:37 8166 8192000000 10773307376 11189612544 1864737504 18.542 100 54 108 2 1889809792 9267280 15805008
14:08:56 1477 8192000000 10796549008 11201265664 1872062784 18.601 100 69 136 3 1898790912 7309616 19418512
14:09:03 44874 8192000000 10808960096 11211259904 1870345952 18.587 100 55 110 0 1898188784 11898992 15943840
14:09:56 10103 8192000000 10783477280 11206709248 1865796176 18.550 100 19 38 1 1880748448 9773696 5178576
14:10:13 6279 8192000000 10789599328 11211567104 1871049136 18.593 100 33 66 0 1888360832 8461616 8850080
14:10:31 7842 8192000000 10787416384 11211685888 1873050112 18.609 100 30 60 0 1888625808 7628688 7947008
14:10:45 2263 8192000000 10802465920 11218161664 1877112528 18.642 100 41 82 2 1896270576 7310816 11847232
14:10:54 2612 8192000000 10799364624 11217993728 1880018688 18.665 100 35 68 0 1897886928 7946464 9921776
14:11:04 4412 8192000000 10798225600 11224788992 1880405200 18.668 100 26 52 1 1899320640 11107168 7808272
14:11:18 7427 8192000000 10796125088 11228684288 1883616112 18.694 100 31 62 1 1902777408 10240464 8920832
14:11:32 9382 8192000000 10803326752 11228131328 1890174448 18.747 100 33 65 2 1905814816 6973712 8666656
14:11:48 8438 8192000000 10794596240 11229298688 1890617568 18.751 100 29 58 1 1904813824 5548432 8647824
14:12:03 6513 8192000000 10802862096 11235172352 1889007488 18.738 100 20 40 3 1900890448 5881920 6001040
14:12:19 9726 8192000000 10802177808 11234209792 1892204656 18.764 100 28 56 0 1906953120 5954288 8794176
14:12:37 11370 8192000000 10810079376 11239075840 1889354448 18.741 100 14 28 1 1898598544 5200032 4044064
14:12:55 14220 8192000000 10815352416 11248898048 1893579584 18.775 100 14 28 1 1906938032 9845536 3512912
14:13:17 59057 8192000000 10830826816 11251453952 1900900560 18.834 100 28 56 1 1915898560 5180720 9817280
14:14:22 22055 8192000000 10807034160 11248992256 1903771248 18.857 100 27 54 4 1917267024 6240304 7255472
14:14:51 5480 8192000000 10818178576 11252101120 1901218464 18.836 100 25 50 0 1913962560 5837600 6906496
14:15:05 4876 8192000000 10816284368 11250814976 1900639248 18.831 100 22 44 1 1916677360 10175120 5862992
14:15:17 3572 8192000000 10817169504 11249307648 1901519184 18.839 100 37 73 3 1919444016 7427104 10497728
14:15:28 6662 8192000000 10816659328 11251027968 1906263568 18.877 100 31 63 2 1920919296 5906384 8749344
14:15:44 6681 8192000000 10822792448 11258200064 1905417520 18.870 100 28 57 1 1920017984 7034400 7566064
14:15:58 9237 8192000000 10812265520 11252744192 1885268064 18.708 99 23 46 3 1901368576 10036752 6063760
14:16:14 6513 8192000000 10804513888 11241312256 1878788160 18.655 99 23 46 3 1895191728 10285280 6118288
14:16:30 7754 8192000000 10806455760 11237462016 1876973936 18.641 99 17 33 2 1887563792 5580880 5008976
14:16:44 9668 8192000000 10790823760 11220566016 1843953536 18.373 98 15 29 3 1854190496 5869472 4367488
14:17:02 11920 8192000000 10796504016 11224457216 1848683632 18.411 98 20 40 0 1859951072 5540240 5727200
14:17:20 10939 8192000000 10798691888 11220058112 1840907680 18.348 98 20 41 2 1851232752 5341904 4983168
14:17:46 10724 8192000000 10762481520 11183562752 1804488704 18.051 97 18 36 1 1814943440 5055456 5399280
14:18:04 60260 8192000000 10733891680 11157659648 1766672144 17.740 95 26 52 0 1783649872 9442336 7535392
14:19:10 11757 8192000000 10704652304 11130032128 1697808512 17.167 92 11 20 1 1705840912 4872304 3160096
14:19:28 7861 8192000000 10685568992 11102232576 1723702512 17.383 96 19 37 2 1734200864 5255280 5243072
14:19:42 6481 8192000000 10683841328 11093749760 1747212416 17.578 99 30 60 0 1761916288 6523600 8180272
14:19:55 9596 8192000000 10701412032 11114545152 1706473680 17.239 95 19 38 0 1717599008 5543248 5582080
14:20:11 7253 8192000000 10707592816 11122696192 1762884288 17.708 98 28 56 1 1777105680 6269584 7951808
14:20:25 5100 8192000000 10707978384 11124805632 1778219984 17.835 99 28 57 0 1796611056 10918592 7472480
14:20:37 9561 8192000000 10659248016 11070300160 1624315520 16.547 91 20 40 4 1635658096 5825520 5517056
14:20:56 8956 8192000000 10689681728 11104653312 1756511872 17.656 99 24 48 0 1768844848 5546624 6786352
14:21:13 11169 8192000000 10701136224 11116740608 1724977568 17.394 96 12 24 0 1733770208 5221600 3571040
14:21:31 9532 8192000000 10712425264 11133960192 1781939696 17.865 99 20 40 0 1792906896 5157936 5809264
14:21:49 12821 8192000000 10726075136 11154345984 1815018752 18.137 100 15 30 1 1824573920 5294256 4260912
14:22:10 10432 8192000000 10746080720 11158384640 1824321296 18.213 100 29 58 6 1837385808 4789936 8274576
14:22:27 10806 8192000000 10735363792 11163111424 1828646784 18.248 100 16 31 1 1838886720 5312960 4926976
14:22:43 68905 8192000000 10747826672 11173613568 1802312096 18.033 98 35 70 1 1818589104 5126592 11150416
14:24:04 9436 8192000000 10751059248 11179565056 1840103936 18.342 100 23 45 1 1852385312 5563696 6717680
14:24:20 6780 8192000000 10766416256 11185152000 1846727280 18.396 100 28 56 0 1865263520 10751616 7784624
14:24:39 9678 8192000000 10755749280 11187290112 1848240960 18.408 100 23 46 1 1861003840 5898528 6864352
14:24:55 7618 8192000000 10756649264 11191533568 1853198768 18.448 100 38 76 3 1870529536 6377744 10953024
14:25:13 8973 8192000000 10760813552 11193901056 1851568736 18.435 100 25 50 0 1864127984 5993888 6565360
14:25:28 6494 8192000000 10766637808 11194875904 1854180464 18.456 100 22 43 4 1866017968 5619248 6218256
14:25:43 8479 8192000000 10774068448 11201650688 1856146384 18.472 100 19 38 0 1867119728 5633232 5340112
14:26:04 6757 8192000000 10772772096 11204030464 1860306736 18.506 100 16 31 0 1870131392 5492368 4332288
14:26:18 8017 8192000000 10786901184 11208732672 1864464368 18.539 100 24 48 0 1876667552 4823216 7379968
14:26:32 8030 8192000000 10773647328 11209412608 1865615760 18.549 100 14 28 2 1875711312 5839712 4255840
14:26:53 13595 8192000000 10780742400 11215089664 1870368656 18.587 100 13 26 0 1879870416 6010528 3491232
14:27:12 11334 8192000000 10783275696 11217833984 1870460320 18.588 100 18 36 2 1880610224 5436800 4713104
14:27:32 9974 8192000000 10791084336 11224838144 1876491216 18.637 100 13 25 1 1885695904 5987232 3217456
14:27:52 54566 8192000000 10795392688 11226750976 1883734144 18.695 100 17 35 1 1894331600 4563888 6033568
14:28:56 20500 8192000000 10841745856 11254841344 1906303520 18.877 100 47 93 2 1925375072 5848128 13223424
14:29:30 17602 8192000000 10854359568 11276165120 1920550544 18.991 100 49 96 0 1943554320 9089568 13914208
14:30:03 50339 8192000000 10855144480 11285872640 1910789168 18.913 99 44 87 0 1934009136 11509600 11710368
14:31:05 38755 8192000000 10881223872 11313242112 1946555440 19.199 100 31 62 1 1971226144 15372160 9298544
14:32:01 12798 8192000000 10890113088 11325177856 1955681616 19.272 100 39 77 0 1984802928 17189184 11932128
14:32:24 2865 8192000000 10914714624 11334893568 1964179472 19.339 100 48 94 1 1995721248 17764512 13777264
14:32:35 7905 8192000000 10916862928 11342049280 1971208848 19.395 100 62 124 1 2008891136 19767184 17915104
14:33:03 3634 8192000000 10931160672 11354337280 1982305136 19.483 100 70 136 1 2022220160 20163040 19751984
14:33:17 6929 8192000000 10931976896 11357532160 1981335216 19.475 100 58 114 2 2019085424 21561472 16188736
14:33:35 8248 8192000000 10925886912 11356889088 1980550288 19.469 100 56 110 0 2018562432 21717600 16294544
14:33:52 10910 8192000000 10932002000 11364667392 1986552816 19.517 100 57 113 2 2026943216 24057888 16332512
14:34:13 3981 8192000000 10941393184 11363373056 1982184416 19.482 100 52 102 3 2025968608 28265904 15518288
14:34:28 7139 8192000000 10929380048 11365584896 1985413568 19.508 100 47 94 3 2023125472 23376032 14335872
14:34:43 6268 8192000000 10942983776 11374321664 1991781456 19.558 100 57 113 1 2033191392 24591360 16818576
14:35:01 9267 8192000000 10951200800 11381948416 2000050064 19.623 100 68 135 1 2048234832 28348496 19836272
14:35:18 9377 8192000000 10933540928 11362816000 1961202800 19.316 98 59 118 1 2005461232 27236576 17021856
14:35:39 9298 8192000000 10946342256 11379441664 1994907792 19.583 100 46 92 1 2037022144 28553216 13561136
14:35:56 8698 8192000000 10942806544 11380473856 1982881744 19.488 99 38 76 1 2022526688 27707296 11937648
14:36:14 15658 8192000000 10964338048 11401154560 2007104432 19.679 100 53 106 3 2052907648 29281776 16521440
14:36:41 6360 8192000000 10958163808 11392192512 2003554080 19.651 100 53 105 4 2047748112 27731968 16462064
14:36:56 2923 8192000000 10959426464 11392159744 1988193312 19.530 99 61 119 1 2034598304 29096352 17308640
14:37:07 2841 8192000000 10960633712 11393142784 2005307392 19.665 100 72 142 3 2057077280 30168224 21601664
14:37:23 10370 8192000000 10938482448 11359100928 1973602576 19.414 98 72 144 2 2027362624 32517520 21242528
14:37:42 3390 8192000000 10930622496 11350298624 1940084400 19.147 97 68 136 0 1993497792 33553952 19859440
14:37:55 2101 8192000000 10948534400 11375796224 1989788272 19.542 100 75 146 0 2043698960 32534240 21376448
14:38:04 4571 8192000000 10934799680 11358228480 1972122176 19.402 100 81 162 2 2031047744 34345280 24580288
14:38:15 10579 8192000000 10959405408 11376758784 1985645024 19.509 100 72 142 3 2041919328 34292144 21982160
14:38:32 6617 8192000000 10956174752 11383205888 1991187120 19.553 100 64 128 3 2045617248 35141536 19288592
14:38:56 2198 8192000000 10973213408 11392393216 2000859584 19.630 100 68 134 1 2056137280 34994064 20283632
14:39:07 2226 8192000000 10979333968 11398397952 2002065264 19.639 100 70 139 2 2058821776 35410048 21346464
14:39:20 9358 8192000000 10948563568 11382550528 1976477136 19.437 99 66 132 1 2034931968 38063312 20391520
14:39:37 1799 8192000000 10968002624 11380752384 1971211520 19.395 99 90 177 5 2036424128 37829600 27383008
14:39:50 2277 8192000000 10947082752 11358367744 1966225136 19.355 99 88 178 3 2031548992 38123664 27200192
14:40:00 4882 8192000000 10913399184 11329032192 1927747552 19.049 98 72 142 0 1986676432 37480976 21447904
14:40:12 4238 8192000000 10927053072 11347984384 1953116624 19.251 100 68 136 1 2012416880 38757712 20542544
14:40:25 5515 8192000000 10906148336 11325440000 1918958752 18.978 99 68 136 0 1979726112 39770784 20996576
14:40:39 1671 8192000000 10918498976 11330801664 1944561312 19.183 100 86 172 2 2006543040 36116192 25865536
14:40:47 5763 8192000000 10913881584 11336269824 1944873040 19.186 100 68 136 4 2003134096 37124128 21136928
14:41:00 1309 8192000000 10929846624 11335729152 1941358752 19.158 100 80 155 1 2002400864 36584192 24457920
14:41:12 3121 8192000000 10928485824 11346419712 1952376720 19.245 100 78 157 1 2015070224 38997296 23696208
14:41:23 3594 8192000000 10934746400 11349434368 1961459664 19.318 100 85 170 1 2027293648 40219648 25614336
14:41:34 4886 8192000000 10930529408 11340894208 1942098880 19.164 99 86 171 1 2010830080 41726944 27004256
14:41:46 4918 8192000000 10919543104 11335434240 1932424640 19.086 99 71 141 0 1994129504 39938384 21766480
14:41:58 3378 8192000000 10938151648 11345575936 1954638912 19.263 100 79 156 3 2021277504 43067264 23571328
14:42:09 2192 8192000000 10943033552 11354861568 1957589008 19.287 100 81 161 1 2026868016 43707456 25571552
14:42:19 3011 8192000000 10945655632 11360292864 1960373616 19.309 100 84 168 1 2032304816 45204768 26726432
14:42:32 1395 8192000000 10949035344 11356442624 1956548144 19.279 100 89 177 3 2029235376 45141776 27545456
14:42:41 5945 8192000000 10936418448 11345715200 1934061552 19.099 99 79 158 1 2005633968 46777936 24794480
14:42:55 1561 8192000000 10938294896 11345674240 1943511184 19.175 100 85 168 2 2019031600 49030528 26489888
14:43:04 2012 8192000000 10953854128 11363504128 1956083152 19.275 100 87 174 2 2033156112 48880144 28192816
14:43:17 5281 8192000000 10943484656 11368644608 1959217648 19.300 100 65 128 2 2027704608 48333936 20153024
14:43:30 7776 8192000000 10924445552 11359670272 1949626080 19.223 99 60 119 3 2017131824 48099616 19406128
14:43:46 4908 8192000000 10942768112 11362979840 1959449248 19.302 100 65 130 0 2019785936 40428928 19907760
14:44:00 4811 8192000000 10968706128 11376447488 1972941312 19.409 100 74 147 0 2040148224 43621648 23585264
14:44:14 1624 8192000000 10967485616 11382648832 1962525696 19.326 99 83 166 1 2033616400 45213664 25877040
14:44:23 5881 8192000000 10973455824 11390918656 1976777072 19.439 100 80 156 0 2051825280 50178720 24869488
14:44:37 9085 8192000000 10938607440 11374460928 1959154464 19.299 100 56 110 1 2028890448 51424000 18311984
14:44:56 7524 8192000000 10917631360 11366907904 1958432640 19.294 100 37 74 3 2012811360 41536976 12841744
14:45:11 9575 8192000000 10929111744 11365494784 1960690160 19.312 100 38 76 1 2010260480 36921360 12648960
14:45:30 5237 8192000000 10947038240 11369631744 1948755840 19.217 99 59 115 0 2010606192 42366384 19483968
14:45:43 1411 8192000000 10945680112 11374006272 1966491056 19.358 100 70 141 2 2032772896 44525792 21756048
14:45:59 19646 8192000000 10920370080 11361742848 1942031824 19.163 99 34 68 2 1998085952 44270960 11783168
14:46:37 19033 8192000000 10916969808 11353288704 1903978704 18.858 98 31 62 0 1969100976 53631760 11490512
14:47:02 27843 8192000000 10912821696 11361632256 1939341424 19.142 100 30 60 1 2003306304 52999296 10965584
14:47:37 15072 8192000000 10895690608 11341750272 1921579008 18.999 99 34 69 1 1972316176 38761504 11975664
14:48:05 21397 8192000000 10901832720 11361095680 1940217472 19.148 100 25 50 2 1988724624 39516720 8990432
14:48:38 25343 8192000000 10887280272 11341037568 1925417680 19.030 99 16 32 1 1958225696 27681696 5126320
14:49:16 26319 8192000000 10878173120 11347120128 1920883824 18.994 99 18 35 0 1957926528 31632432 5410272
14:49:50 37011 8192000000 10866326992 11343069184 1917660720 18.968 99 8 16 1 1943679760 23610064 2408976
14:50:33 86785 8192000000 10876769120 11338637312 1882251584 18.683 97 17 34 2 1901612944 14835152 4526208
14:53:07 48583 8192000000 10862688624 11320975360 1928078944 19.052 99 29 58 2 1943777440 6645760 9052736
14:54:05 14974 8192000000 10875481968 11312726016 1924447792 19.022 99 50 97 1 1944846864 7091136 13307936
14:54:30 11247 8192000000 10870165808 11303931904 1907769680 18.889 98 52 104 0 1935741968 12846144 15126144
14:54:48 93075 8192000000 10866908736 11336560640 1910073872 18.907 99 14 28 0 1936361856 21885120 4402864
14:56:31 165628 8192000000 10854003792 11311534080 1857221648 18.481 96 14 28 0 1877914736 16347536 4345552
14:59:24 71265 8192000000 10896159568 11352092672 1927873936 19.050 98 18 36 1 1939500112 6504928 5121248
15:00:50 24880 8192000000 10905857744 11352018944 1937061024 19.123 98 48 96 0 1962159312 11796352 13301936
15:01:23 46414 8192000000 10894931136 11357872128 1961802752 19.320 100 36 72 0 1983814784 12234032 9778000
15:02:34 56443 8192000000 10915267984 11368787968 1971870832 19.400 100 14 28 1 1988374896 11781520 4722544
15:03:38 22688 8192000000 10920290576 11388411904 1988164224 19.529 100 21 42 3 2008775920 14263648 6348048
15:04:29 58236 8192000000 10936028656 11399778304 1997925232 19.606 100 33 66 1 2030986496 23322352 9738912
15:05:40 46701 8192000000 10946701888 11409903616 1999649440 19.620 100 27 54 0 2033879344 25162880 9067024
15:07:30 46589 8192000000 10945257808 11408637952 2006330576 19.673 100 30 60 1 2031444848 16382368 8731904
15:08:35 61126 8192000000 10946139216 11403780096 1997115648 19.600 100 12 24 0 2019632800 18369552 4147600
15:09:42 74777 8192000000 10922804672 11377078272 1958224448 19.292 98 12 24 0 1971657040 10204736 3227856
15:11:05 15318 8192000000 10927361296 11388346368 1976218432 19.435 99 46 91 1 1996842784 8262176 12362176
15:11:30 37588 8192000000 10927253216 11395457024 1977790416 19.447 99 23 47 1 1993143408 8591248 6761744
15:12:28 20877 8192000000 10933873632 11390939136 1984844112 19.503 99 41 82 0 2005700352 8137424 12718816
15:12:57 41134 8192000000 10919031216 11382566912 1959817856 19.305 98 35 68 1 1980816960 10945248 10053856
15:13:45 42609 8192000000 10914596240 11376787456 1927579744 19.048 97 24 48 2 1945642976 11552928 6510304
15:14:58 84006 8192000000 10904344992 11389710336 1954768176 19.264 99 9 18 0 1968941088 12069200 2103712
15:16:28 62463 8192000000 10910323712 11385065472 1955430528 19.270 99 10 20 1 1969799552 11845232 2523792
15:17:39 70867 8192000000 10883427776 11361001472 1868025328 18.568 94 26 49 1 1887111376 12075280 7010768
15:19:00 37892 8192000000 10920705072 11369074688 1934297168 19.101 98 25 49 1 1952750096 12126816 6326112
15:19:44 20094 8192000000 10897969600 11351576576 1933456176 19.095 98 37 74 1 1953530368 10021088 10053104
15:20:11 87121 8192000000 10930111008 11371855872 1972601232 19.406 100 44 88 0 1995383984 10456672 12326080
15:24:04 35784 8192000000 10894582432 11376332800 1963774176 19.336 99 35 70 4 1988018976 13349104 10895696
15:24:53 58176 8192000000 10876826384 11363901440 1893993936 18.778 96 11 23 0 1911253376 13788944 3470496
15:25:58 16426 8192000000 10876247760 11368681472 1955306960 19.269 100 6 12 0 1971356480 14692464 1357056
15:26:20 18598 8192000000 10879243616 11360649216 1940236176 19.149 99 24 47 3 1957082192 10991568 5854448
15:26:46 44896 8192000000 10856150432 11312558080 1867287008 18.562 95 25 50 1 1885494720 10910832 7296880
15:27:37 68879 8192000000 10878564528 11352915968 1910929552 18.914 98 10 20 0 1926048000 12641936 2476512
15:28:52 56350 8192000000 10878564000 11350069248 1931147824 19.076 99 16 33 1 1954854064 19099728 4606512
15:30:09 51125 8192000000 10879076336 11353587712 1914126672 18.940 98 14 29 0 1934669680 16365104 4177904
15:31:21 53055 8192000000 10863006560 11316121600 1829112352 18.252 94 20 40 0 1846206224 11255792 5838080
15:32:22 68247 8192000000 10822445232 11292184576 1806983200 18.071 94 19 38 0 1827301184 15163568 5154416
15:33:40 71818 8192000000 10882616928 11338022912 1914738080 18.945 99 19 38 3 1935595248 15275968 5581200
15:35:13 43480 8192000000 10888056976 11355881472 1921009264 18.995 98 28 56 0 1944777472 15668704 8099504
15:36:09 99341 8192000000 10871283664 11347189760 1871535600 18.597 96 9 18 0 1892337792 18354736 2447456
15:38:55 43663 8192000000 10855926448 11316342784 1863529136 18.532 96 14 28 0 1883209248 16018496 3661616
15:39:50 61482 8192000000 10889678000 11331706880 1911163888 18.916 99 23 45 2 1926599568 9107408 6328272
15:40:59 16600 8192000000 10895224000 11335872512 1941306336 19.157 100 53 106 3 1965696368 9984384 14405648
15:41:26 9748 8192000000 10886505408 11331014656 1924412736 19.022 99 47 92 2 1952897072 16121632 12362704
15:41:42 21719 8192000000 10906971792 11358158848 1946005296 19.195 100 42 84 0 1969287072 12037680 11244096
15:42:13 94843 8192000000 10868011888 11337199616 1883024192 18.690 97 16 32 2 1905339760 18021216 4294352
15:43:54 104932 8192000000 10858774048 11327070208 1890803584 18.752 97 32 64 0 1911035664 10536432 9695648
15:45:54 79251 8192000000 10889670144 11355635712 1953393216 19.253 100 23 45 2 1972913808 12823936 6696656
15:47:23 44039 8192000000 10889496528 11365089280 1962764240 19.328 100 21 42 0 1980386928 11414400 6208288
15:48:14 79459 8192000000 10861161200 11350286336 1910309408 18.909 98 11 22 0 1925967648 12394000 3264240
15:49:40 31152 8192000000 10859435040 11350962176 1925948688 19.034 99 7 14 0 1938924768 11329056 1647024
15:50:46 43285 8192000000 10873033888 11350450176 1953667456 19.256 100 16 32 1 1964797600 6478624 4651520
15:51:43 52000 8192000000 10894433984 11374284800 1966038976 19.354 100 9 18 0 1978190720 9912448 2239296
15:52:58 40563 8192000000 10901154848 11370283008 1950813856 19.233 99 13 26 0 1967644720 13287008 3543856
15:53:45 64084 8192000000 10884308048 11377098752 1943791232 19.177 99 15 30 2 1967103984 19224416 4088336
15:55:25 57283 8192000000 10895770944 11372580864 1965551680 19.350 100 7 14 0 1975621424 8075312 1994432
15:56:28 45823 8192000000 10902199488 11378569216 1976506880 19.437 100 19 38 0 1992826352 11117808 5201664
15:57:21 58501 8192000000 10913043712 11389669376 1980999856 19.473 100 22 44 1 1999126144 12167744 5958544
15:58:25 38640 8192000000 10891114848 11345936384 1886999248 18.722 95 38 77 1 1909110480 11777280 10333952
15:59:10 49195 8192000000 10900698960 11374219264 1968872112 19.376 100 23 44 1 1985203792 10445696 5885984
16:01:45 47151 8192000000 10897424880 11361751040 1944287536 19.181 99 15 30 0 1956798480 8644720 3866224
16:02:41 49454 8192000000 10915547344 11384446976 1971842000 19.400 100 15 30 1 1992586816 16100832 4643984
16:04:10 23463 8192000000 10913740592 11365777408 1968120496 19.371 100 27 53 1 1984120944 8475088 7525360
16:04:44 60952 8192000000 10904604352 11377283072 1928792016 19.057 98 24 48 1 1948301792 12976352 6533424
16:05:53 67480 8192000000 10907685568 11363622912 1931900784 19.082 98 33 65 2 1949706720 8855424 8950512
16:07:10 24110 8192000000 10915669168 11373879296 1951120656 19.235 99 28 55 1 1970835008 11901264 7813088
16:07:41 49776 8192000000 10904794832 11374694400 1959767968 19.304 100 25 50 2 1980879424 14277344 6834112
16:08:36 38078 8192000000 10905968032 11376201728 1919599072 18.984 97 29 56 1 1942162704 14759312 7804320
16:09:22 88165 8192000000 10889016160 11373895680 1932223408 19.085 98 22 44 1 1955898480 17508592 6166480
16:11:45 102992 8192000000 10855850592 11328782336 1815417536 18.140 92 19 38 0 1828047408 7632336 4997536
16:13:45 49410 8192000000 10869413216 11358998528 1931902144 19.082 99 12 24 1 1948036640 12633824 3500672
16:14:50 69094 8192000000 10861026864 11334291456 1886723728 18.719 97 5 10 0 1898845216 10715072 1406416
16:16:22 70922 8192000000 10856577264 11322490880 1844336288 18.376 95 14 28 1 1860371968 12011136 4024544
16:17:46 73073 8192000000 10841297968 11319742464 1887224576 18.723 99 15 30 0 1912494960 20486224 4784160
16:19:19 49373 8192000000 10848648256 11334025216 1908525360 18.895 100 9 18 0 1931718016 20029056 3163600
16:20:15 68895 8192000000 10863169120 11329417216 1905716160 18.872 99 19 38 1 1921030848 10450304 4864384
16:21:35 64382 8192000000 10835542896 11291545600 1851808544 18.437 96 28 56 0 1868421424 8730768 7882112
16:22:49 65610 8192000000 10842325072 11307110400 1850978240 18.430 96 19 37 1 1869633664 12879616 5775808
16:24:07 59482 8192000000 10850525040 11312599040 1896105312 18.795 99 20 40 2 1917430688 15576816 5748560
16:25:13 99896 8192000000 10877514432 11334885376 1886829472 18.720 98 14 28 1 1916061680 24981984 4250224
16:27:10 43086 8192000000 10884639536 11356909568 1939406832 19.142 100 19 38 1 1969553200 24590304 5556064

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 21-12-2020 16:29:26 to 21-12-2020 16:29:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 130 v_add_invoice_to_stock 335544517
except 16 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-12-2020 16:29:57 to 21-12-2020 16:29:59.

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          247531
MON$OLDEST_ACTIVE               249658
MON$OLDEST_SNAPSHOT             249658
MON$NEXT_TRANSACTION            249658
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                       2038368
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
--- end of diff output ---

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

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