Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.01.2021 16:32
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 17273872 kB
MemAvailable 31265124 kB
Buffers 0 kB
Cached 14407292 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 16:31:45
DTS_END                         2021-01-26 16:31:45.8150
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/38890
TRN_ID                          227461
ATT_ID                          686
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: 8837.23 30145 1060467
customer order: creation 164.64 359 19757
customer order: refuse 14.31 381 1717
order to supplier: creation 44.34 1324 5321
order to supplier: removal 3.23 111781 388
invoice (draft): creation 43.25 3612 5190
invoice (draft): removal 49.98 846 5997
invoice accept: apply 40.25 19565 4830
invoice accept: cancel 45.44 963 5453
customer reserve: creation 3675.10 195 441012
customer reserve: removal 4477.26 64 537271
realization accept: apply 77.92 214 9350
realization accept: cancel 77.43 126 9292
payment from customer: creation 55.98 124 6718
payment from customer: removal 5.67 82 680
payment to supplier: creation 46.99 137 5639
payment to supplier: removal 3.28 68 394
service: total inventory turnovers 4.86 1125 583
service: total monetary turnovers 6.67 29 800
service: aggregate perf. data 0.59 32155 71
service: refresh index statistics 0.03 429743 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-01-2021 16:32:54 to 26-01-2021 16:32:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2629
TEST_TIME 2 2227
TEST_TIME 3 2888
TEST_TIME 4 3204
TEST_TIME 5 2934
TEST_TIME 6 3387
TEST_TIME 7 3768
TEST_TIME 8 4031
TEST_TIME 9 4348
TEST_TIME 10 4633
TEST_TIME 11 4925
TEST_TIME 12 5065
TEST_TIME 13 5479
TEST_TIME 14 5543
TEST_TIME 15 5774
TEST_TIME 16 5906
TEST_TIME 17 6245
TEST_TIME 18 6434
TEST_TIME 19 6477
TEST_TIME 20 6606
TEST_TIME 21 7107
TEST_TIME 22 7167
TEST_TIME 23 7357
TEST_TIME 24 7692
TEST_TIME 25 7725
TEST_TIME 26 7904
TEST_TIME 27 8083
TEST_TIME 28 8348
TEST_TIME 29 8406
TEST_TIME 30 8530
TEST_TIME 31 8632
TEST_TIME 32 8753
TEST_TIME 33 8960
TEST_TIME 34 8955
TEST_TIME 35 9074
TEST_TIME 36 9037
TEST_TIME 37 9205
TEST_TIME 38 9170
TEST_TIME 39 9024
TEST_TIME 40 9173
TEST_TIME 41 9221
TEST_TIME 42 9156
TEST_TIME 43 9076
TEST_TIME 44 8943
TEST_TIME 45 8880
TEST_TIME 46 8988
TEST_TIME 47 9106
TEST_TIME 48 9166
TEST_TIME 49 9114
TEST_TIME 50 9136
TEST_TIME 51 9139
TEST_TIME 52 9175
TEST_TIME 53 9031
TEST_TIME 54 8882
TEST_TIME 55 8944
TEST_TIME 56 8923
TEST_TIME 57 8857
TEST_TIME 58 8836
TEST_TIME 59 8799
TEST_TIME 60 8755
TEST_TIME 61 8798
TEST_TIME 62 8852
TEST_TIME 63 8771
TEST_TIME 64 8749
TEST_TIME 65 8848
TEST_TIME 66 8829
TEST_TIME 67 8867
TEST_TIME 68 8860
TEST_TIME 69 8919
TEST_TIME 70 8915
TEST_TIME 71 8924
TEST_TIME 72 8906
TEST_TIME 73 8923
TEST_TIME 74 8928
TEST_TIME 75 8914
TEST_TIME 76 8981
TEST_TIME 77 8967
TEST_TIME 78 8993
TEST_TIME 79 9053
TEST_TIME 80 9020
TEST_TIME 81 8921
TEST_TIME 82 8903
TEST_TIME 83 8834
TEST_TIME 84 8829
TEST_TIME 85 8756
TEST_TIME 86 8790
TEST_TIME 87 8740
TEST_TIME 88 8760
TEST_TIME 89 8694
TEST_TIME 90 8681
TEST_TIME 91 8601
TEST_TIME 92 8643
TEST_TIME 93 8629
TEST_TIME 94 8655
TEST_TIME 95 8659
TEST_TIME 96 8720
TEST_TIME 97 8742
TEST_TIME 98 8725
TEST_TIME 99 8752
TEST_TIME 100 8788
TEST_TIME 101 8873
TEST_TIME 102 8952
TEST_TIME 103 8914
TEST_TIME 104 8934
TEST_TIME 105 8943
TEST_TIME 106 9014
TEST_TIME 107 9021
TEST_TIME 108 8963
TEST_TIME 109 8931
TEST_TIME 110 8900
TEST_TIME 111 8873
TEST_TIME 112 8849
TEST_TIME 113 8836
TEST_TIME 114 8808
TEST_TIME 115 8841
TEST_TIME 116 8790
TEST_TIME 117 8756
TEST_TIME 118 8838
TEST_TIME 119 8879
TEST_TIME 120 8840

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 26-01-2021 16:32:57 to 26-01-2021 16:33:01.

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 1468594 1468594 0 0.00 0 18171 7 0 0
doc_list_biud 1468594 1468594 0 0.00 0 61946 30 0 0
sp_add_invoice_to_stock 4953 4830 123 2.48 20 178568 19565 0 123
sp_cancel_adding_invoice 5453 5453 0 0.00 5 76073 963 0 0
sp_cancel_client_order 1717 1717 0 0.00 4 16867 381 0 0
sp_cancel_customer_reserve 537271 537271 0 0.00 1 61949 64 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 2 5782 82 0 0
sp_cancel_pay_to_supplier 394 394 0 0.00 3 1211 69 0 0
sp_cancel_supplier_invoice 6008 5997 11 0.18 1 21964 847 0 11
sp_cancel_supplier_order 388 388 0 0.00 6 1103455 111782 0 0
sp_cancel_write_off 9292 9292 0 0.00 1 14835 126 0 0
sp_client_order 19757 19757 0 0.00 3 23172 359 0 0
sp_customer_reserve 441012 441012 0 0.00 0 101479 195 0 0
sp_fill_shopping_cart 30259 30259 0 0.00 1 12779 39 0 0
sp_fill_shopping_cart_clo_res 441003 441003 0 0.00 0 23025 15 0 0
sp_get_clo_for_invoice 4820 4820 0 0.00 0 17293 321 0 0
sp_kill_cost_storno 15819 15819 0 0.00 0 8593 64 0 0
sp_kill_qstorno_ret_qs2qd 1090219 1090219 0 0.00 0 61943 35 0 0
sp_kill_qty_storno 574288 574288 0 0.00 0 61946 76 0 0
sp_lock_selected_doc 19777 19777 0 0.00 0 8684 6 0 0
sp_make_cost_storno 26527 26527 0 0.00 0 11564 56 0 0
sp_multiply_rows_for_pdistr 26527 26527 0 0.00 0 6748 31 0 0
sp_multiply_rows_for_qdistr 19757 19757 0 0.00 0 11589 168 0 0
sp_pay_from_customer 6718 6718 0 0.00 4 13009 124 0 0
sp_pay_to_supplier 5639 5639 0 0.00 4 23075 138 0 0
sp_payment_common 12357 12357 0 0.00 2 10394 28 0 0
sp_qd_handle_on_cancel_clo 1717 1717 0 0.00 0 16858 342 0 0
sp_qd_handle_on_invoice_upd_sts 10273 10273 0 0.00 0 16005 405 0 0
sp_qd_handle_on_reserve_upd_sts 9350 9350 0 0.00 0 20965 84 0 0
sp_reserve_write_off 9350 9350 0 0.00 5 23030 215 0 0
sp_supplier_invoice 5190 5190 0 0.00 6 84994 3612 0 0
sp_supplier_order 5321 5321 0 0.00 5 32663 1325 0 0
srv_aggregate_perf_data 71 71 0 0.00 2320 381529 32155 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 805 148274 31122 0 0
srv_find_qd_qs_mism 1014731 1014731 0 0.00 0 18148 6 0 0
srv_make_invnt_saldo 583 583 0 0.00 29 48233 1126 0 0
srv_make_money_saldo 800 800 0 0.00 1 3328 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 203523 577908 429744 0 0
t$perf-abend:sp_add_invoice_to_stock 123 123 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4830 4830 0 0.00 0 9192 181 0 0
t$perf-norm:sp_cancel_adding_invoice 376 376 0 0.00 0 3213 131 0 0
t$perf-norm:sp_cancel_client_order 1717 1717 0 0.00 0 1459 14 0 0
t$perf-norm:sp_cancel_customer_reserve 675 675 0 0.00 0 840 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 2795 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 394 394 0 0.00 0 1384 10 0 0
t$perf-norm:sp_cancel_supplier_invoice 414 414 0 0.00 0 3610 30 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 24278 1654 0 0
t$perf-norm:sp_cancel_write_off 963 963 0 0.00 0 4061 11 0 0
t$perf-norm:sp_client_order 19757 19757 0 0.00 0 8999 23 0 0
t$perf-norm:sp_customer_reserve 950 950 0 0.00 0 1219 5 0 0
t$perf-norm:sp_pay_from_customer 6718 6718 0 0.00 0 7231 10 0 0
t$perf-norm:sp_pay_to_supplier 5639 5639 0 0.00 0 7337 11 0 0
t$perf-norm:sp_reserve_write_off 9350 9350 0 0.00 0 7215 12 0 0
t$perf-norm:sp_supplier_invoice 5190 5190 0 0.00 0 7308 22 0 0
t$perf-norm:sp_supplier_order 5321 5321 0 0.00 0 7265 17 0 0
t$perf-norm:srv_aggregate_perf_data 71 71 0 0.00 0 167 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 3709 27 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 851 22 0 0
t$perf-norm:srv_make_money_saldo 800 800 0 0.00 0 1079 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9884 9638 246 2.48 0 14245 25 0 246
v_all_customers 36278 36278 0 0.00 0 52 1 0 0
v_all_suppliers 29088 29088 0 0.00 0 16 1 0 0
v_all_wares 39510 39510 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 752 752 0 0.00 0 16642 29 0 0
v_cancel_client_order 3434 3434 0 0.00 0 8513 10 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 2586 6 0 0
v_cancel_customer_reserve 1350 1350 0 0.00 0 560 3 0 0
v_cancel_payment_to_supplier 788 788 0 0.00 0 699 4 0 0
v_cancel_supplier_invoice 850 828 22 2.58 0 21287 46 0 22
v_cancel_supplier_order 776 776 0 0.00 0 1511 5 0 0
v_cancel_write_off 1926 1926 0 0.00 0 3562 16 0 0
v_max_id_clo_ord 5317 5317 0 0.00 0 6415 3 0 0
v_max_id_clo_res 950 950 0 0.00 0 1726 17 0 0
v_max_id_ord_sup 5186 5186 0 0.00 0 5166 4 0 0
v_max_non_paid_invoice 1598 1598 0 0.00 0 471 3 0 0
v_max_non_paid_realizn 3405 3405 0 0.00 0 990 3 0 0
v_min_id_clo_ord 5317 5317 0 0.00 0 4687 13 0 0
v_min_id_clo_res 950 950 0 0.00 0 4297 12 0 0
v_min_id_ord_sup 5186 5186 0 0.00 0 6011 8 0 0
v_min_non_paid_invoice 5639 5639 0 0.00 0 8927 17 0 0
v_min_non_paid_realizn 6718 6718 0 0.00 0 10389 15 0 0
v_our_firm 9858 9858 0 0.00 0 14 1 0 0
v_reserve_write_off 18700 18700 0 0.00 0 22777 10 0 0
x_lock_depdocs_on_canc_invoice 11036 11036 0 0.00 0 17932 138 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 4293 364 0 0
x_make_qstorno_1000_1200 5321 5321 0 0.00 1 32637 1226 0 0
x_make_qstorno_1200_2000 5190 5190 0 0.00 3 84915 3482 0 0
x_make_qstorno_2100_3300 441012 441012 0 0.00 0 101476 178 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-01-2021 16:33:02 to 26-01-2021 16:33:06.

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
14:01:49 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:55 20390 8192000000 10239503616 10547400704 906352640 9.961 70 53 107 0 926529760 2517200 17659920
14:02:24 19467 8192000000 10330240320 10644377600 1370063152 14.328 100 85 170 1 1403475648 4684928 28727568
14:02:53 25019 8192000000 10371036864 10692505600 1410879472 14.692 100 89 178 1 1445958464 5936448 29142544
14:03:26 30441 8192000000 10401574528 10726461440 1445603856 14.999 100 88 175 1 1480773600 6789728 28380016
14:04:07 32488 8192000000 10432764480 10762141696 1482100176 15.320 100 93 186 0 1519149824 7535584 29514064
14:04:46 26581 8192000000 10450105232 10782027776 1504548304 15.516 100 96 192 1 1543189552 8251872 30389376
14:05:25 33369 8192000000 10471545552 10806509568 1522496320 15.672 100 92 184 2 1560538816 8998944 29043552
14:06:13 27780 8192000000 10489130768 10830782464 1539096896 15.816 100 87 174 0 1575782816 9458960 27226960
14:06:50 17607 8192000000 10496853776 10850893824 1563785168 16.029 100 82 164 1 1598571232 9759840 25026224
14:07:18 12014 8192000000 10519659568 10872086528 1584968352 16.211 100 79 158 0 1618701520 10053376 23679792
14:07:41 14913 8192000000 10552347360 10906234880 1611726320 16.439 100 84 168 1 1648014992 11276992 25011680
14:08:06 12668 8192000000 10574029072 10936213504 1631777504 16.610 100 81 162 2 1667780816 12376752 23626560
14:08:27 14103 8192000000 10602103776 10968928256 1656367216 16.818 100 79 158 0 1692442640 12464560 23610864
14:08:49 10866 8192000000 10611451152 10982785024 1677042368 16.992 100 77 154 1 1711493600 12108224 22343008
14:09:10 9102 8192000000 10632483328 11003293696 1696258880 17.154 100 72 143 1 1728522448 11490832 20772736
14:09:26 11133 8192000000 10657611696 11030482944 1715897792 17.318 100 79 159 0 1751119488 12191456 23030240
14:09:45 7880 8192000000 10662073536 11040608256 1724183968 17.387 100 68 133 3 1754560000 11755392 18620640
14:09:59 7016 8192000000 10678928640 11055034368 1738121312 17.503 100 76 152 0 1771670896 12249888 21299696
14:10:14 5659 8192000000 10681411008 11062001664 1748024096 17.585 100 87 176 1 1785853776 13815584 24014096
14:10:27 6446 8192000000 10696623680 11077693440 1759511616 17.680 100 73 146 2 1791904768 12414736 19978416
14:10:41 4219 8192000000 10707620112 11087572992 1771996768 17.783 100 85 170 0 1807850976 12320896 23533312
14:10:52 3909 8192000000 10709554160 11093340160 1775143408 17.809 100 75 148 2 1808066720 12698688 20224624
14:11:05 12292 8192000000 10709223056 11096678400 1779404144 17.845 100 63 124 3 1808100384 11570256 17125984
14:11:25 4597 8192000000 10740908240 11123245056 1798926992 18.005 100 72 145 0 1831427952 12638000 19862960
14:11:36 2859 8192000000 10737300048 11123724288 1806136816 18.064 100 87 172 1 1843559824 12766528 24656480
14:11:46 3141 8192000000 10746939840 11136720896 1814414096 18.132 100 85 165 3 1849378928 11914768 23050064
14:11:55 3423 8192000000 10759310704 11146235904 1821739216 18.192 100 84 169 2 1856283984 11398576 23146192
14:12:06 4078 8192000000 10773510224 11158880256 1833649872 18.289 100 93 186 0 1873115120 13232128 26233120
14:12:17 2225 8192000000 10772664080 11162308608 1839495984 18.337 100 89 176 3 1877767440 13133376 25138080
14:12:25 3562 8192000000 10781454608 11170680832 1842429952 18.361 100 83 165 0 1879009408 13587648 22991808
14:12:35 2596 8192000000 10783592512 11172532224 1841776448 18.355 100 84 166 3 1879318336 14070176 23471712
14:12:44 2783 8192000000 10792870272 11178119168 1844725440 18.379 100 87 174 1 1883715296 14617440 24372416
14:12:54 2306 8192000000 10790373984 11177791488 1850585664 18.427 100 94 188 0 1891765696 15294752 25885280
14:13:03 2083 8192000000 10793346992 11183087616 1852700848 18.444 100 90 180 3 1891080240 14127040 24252352
14:13:12 2362 8192000000 10800633200 11185999872 1857769040 18.485 100 93 185 2 1897802240 14888656 25144544
14:13:23 2485 8192000000 10801447872 11189829632 1861720320 18.517 100 91 180 1 1902606240 14217056 26668864
14:13:32 1921 8192000000 10806686576 11196178432 1861788032 18.518 100 90 180 3 1901271728 13769440 25714256
14:13:41 2141 8192000000 10811658688 11200307200 1868326352 18.571 100 93 184 2 1908922080 14523760 26071968
14:13:49 1449 8192000000 10819555200 11206074368 1872502832 18.605 100 94 186 1 1913580016 14738352 26338832
14:13:57 1080 8192000000 10822145840 11213524992 1879750896 18.663 100 92 184 3 1918631216 13872208 25008112
14:14:05 1333 8192000000 10821284976 11213213696 1877507312 18.645 100 89 179 1 1917002480 13595856 25899312
14:14:13 13882 8192000000 10817799040 11208228864 1876828288 18.639 100 71 142 3 1906865616 9029648 21007680
14:14:33 16376 8192000000 10824987120 11215679488 1883608624 18.694 100 81 162 0 1916451184 10192896 22649664
14:14:56 20901 8192000000 10816967120 11222167552 1885216928 18.707 100 73 146 0 1920575312 14895264 20463120
14:15:24 1749 8192000000 10834978736 11227279360 1888225920 18.731 100 94 188 4 1926644896 10610976 27808000
14:15:32 2950 8192000000 10809806048 11221028864 1882659376 18.687 100 58 115 0 1909562272 11371536 15531360
14:15:41 3508 8192000000 10804897632 11219034112 1880776752 18.671 100 48 97 0 1904463664 10262384 13424528
14:15:55 4057 8192000000 10797708496 11212537856 1881924432 18.681 100 33 65 2 1898357552 6146736 10286384
14:16:06 3318 8192000000 10800360928 11216429056 1882000928 18.681 100 42 83 3 1900510208 7194304 11314976
14:16:17 3309 8192000000 10800349824 11221405696 1885528864 18.710 100 42 84 1 1906797120 9566512 11701744
14:16:26 6035 8192000000 10804200960 11220803584 1885290592 18.708 100 37 74 2 1902595728 6567600 10737536
14:16:40 11339 8192000000 10787264896 11218067456 1883163008 18.691 100 18 37 1 1893924432 5755360 5006064
14:16:58 5587 8192000000 10798661024 11226877952 1891375984 18.757 100 33 66 0 1908596288 6949648 10270656
14:17:11 8871 8192000000 10798500208 11228409856 1889789888 18.744 100 20 41 2 1901954128 6715472 5448768
14:17:27 10642 8192000000 10792852560 11233464320 1892332256 18.765 100 19 38 0 1908727120 10910752 5484112
14:17:44 5754 8192000000 10797560912 11233832960 1893999872 18.778 100 13 26 1 1903338544 5602016 3736656
14:17:56 6954 8192000000 10817422032 11242872832 1900065424 18.827 100 26 52 1 1918803696 9637088 9101184
14:18:17 53310 8192000000 10822010560 11249725440 1901092096 18.835 100 39 78 0 1917727696 5416912 11218688
14:19:19 10429 8192000000 10821441536 11254456320 1901754976 18.840 100 28 55 1 1919738928 11051536 6932416
14:19:37 6504 8192000000 10820662368 11250663424 1901820528 18.841 100 27 53 3 1915313568 5819200 7673840
14:19:49 7115 8192000000 10824645888 11251585024 1903836288 18.857 100 22 44 1 1916054464 5719616 6498560
14:20:07 6511 8192000000 10828707248 11260190720 1906327536 18.877 100 28 56 0 1929510576 15338736 7844304
14:20:20 4537 8192000000 10833387152 11262816256 1909082032 18.899 100 43 85 3 1932271488 10573088 12616368
14:20:32 9244 8192000000 10825504960 11258925056 1908107328 18.891 100 30 61 2 1923471152 6734576 8629248
14:20:49 7998 8192000000 10825363632 11258761216 1906257216 18.877 100 20 40 1 1922110800 10377856 5475728
14:21:03 12972 8192000000 10826542496 11266150400 1907602928 18.887 100 13 26 0 1916541632 5831504 3107200
14:21:22 7545 8192000000 10825743344 11263496192 1913014848 18.931 100 27 54 1 1926810208 5889296 7906064
14:21:38 10904 8192000000 10809109280 11241840640 1869882448 18.583 98 30 61 2 1884917600 6386192 8648960
14:21:57 4428 8192000000 10813895552 11249958912 1901000352 18.834 100 26 46 3 1915266144 6604144 7661648
14:22:07 6820 8192000000 10805919264 11243282432 1882132320 18.682 99 16 33 0 1893719792 6233584 5353888
14:22:22 5586 8192000000 10811746352 11245248512 1899682864 18.824 100 35 70 2 1916007856 6639392 9685600
14:22:35 9755 8192000000 10780578992 11222347776 1854929024 18.462 98 27 54 3 1868998480 5771520 8297936
14:22:51 11037 8192000000 10792833968 11228020736 1869412816 18.580 99 29 58 1 1884301824 6491216 8397792
14:23:09 69867 8192000000 10787716064 11210358784 1799353664 18.009 95 21 42 1 1810368608 5648064 5366880
14:24:25 9240 8192000000 10780211024 11210432512 1831376976 18.271 98 27 52 3 1849154304 10290912 7486416
14:24:45 5311 8192000000 10773686928 11186974720 1824511536 18.215 99 40 79 3 1842984432 6505648 11967248
14:25:00 6935 8192000000 10760549664 11191119872 1839485376 18.337 99 41 81 3 1858425568 7215152 11725040
14:25:14 6137 8192000000 10776420656 11197489152 1839186848 18.334 99 45 91 2 1860132288 7585424 13360016
14:25:27 5149 8192000000 10751173392 11168735232 1805061312 18.055 98 26 52 1 1818941168 6660816 7219040
14:25:39 5620 8192000000 10709345104 11125739520 1731455104 17.448 95 24 48 1 1744771568 6202096 7114368
14:25:55 7354 8192000000 10689370144 11105427456 1742863520 17.542 97 21 42 1 1758264272 9666320 5734432
14:26:12 10711 8192000000 10682822864 11093540864 1657933296 16.831 92 23 44 2 1669091856 4569088 6589472
14:26:33 9335 8192000000 10716352944 11135856640 1783627632 17.879 99 29 57 1 1798908608 6834256 8446720
14:26:50 7319 8192000000 10724119696 11142856704 1804336016 18.049 100 35 68 1 1824469136 9866048 10267072
14:27:04 8513 8192000000 10738443504 11151147008 1779914464 17.849 98 28 57 1 1797565040 9072544 8578032
14:27:21 4677 8192000000 10720411888 11128676352 1758897456 17.675 97 35 69 2 1773275488 4976112 9401920
14:27:32 16112 8192000000 10713776656 11137765376 1769482672 17.763 98 12 24 2 1777512560 4701760 3328128
14:27:55 11869 8192000000 10729885712 11140698112 1792858848 17.955 99 42 84 1 1814769808 9123040 12787920
14:28:30 48680 8192000000 10719753664 11143585792 1778754256 17.839 98 21 42 1 1790559664 5610816 6194592
14:29:29 12663 8192000000 10724777904 11138150400 1802347440 18.033 99 32 64 0 1817777312 6812656 8617216
14:29:49 10766 8192000000 10745061488 11159855104 1807961824 18.079 99 24 48 1 1821227792 6608832 6657136
14:30:08 14199 8192000000 10749919616 11171196928 1834579360 18.297 100 23 45 0 1846754016 5493840 6680816
14:30:30 7055 8192000000 10765168592 11180244992 1841163024 18.350 100 25 50 0 1854481136 5770320 7547792
14:30:46 6868 8192000000 10757581856 11184427008 1846678272 18.395 100 29 56 1 1861431568 6022144 8731152
14:30:59 6872 8192000000 10762630736 11189669888 1854193616 18.456 100 31 62 2 1868408704 5286464 8928624
14:31:13 11057 8192000000 10789836016 11211698176 1871164816 18.594 100 23 46 0 1882626352 4819872 6641664
14:31:31 5704 8192000000 10799060928 11221794816 1882497168 18.685 100 28 56 1 1897633648 5647216 9489264
14:31:43 32426 8192000000 10798880176 11222478848 1886398800 18.717 100 26 52 1 1899102832 5278464 7425568
14:32:32 54972 8192000000 10833641232 11255083008 1899744208 18.824 100 36 72 0 1916576688 6899296 9933184
14:33:41 18539 8192000000 10851679296 11268317184 1915370032 18.950 100 43 84 3 1938424512 10791648 12262832
14:34:07 18199 8192000000 10866559632 11278200832 1927290816 19.045 100 51 101 1 1953820288 11464640 15064832
14:34:46 11570 8192000000 10866568496 11283853312 1930759424 19.073 100 56 110 1 1960472544 13236960 16476160
14:35:05 19788 8192000000 10866687808 11285913600 1931760800 19.081 100 47 95 0 1958090608 13006336 13323472
14:35:36 49477 8192000000 10875973952 11296264192 1935151744 19.108 100 48 94 0 1962252480 13495088 13605648
14:36:50 31415 8192000000 10864737776 11306176512 1940384800 19.150 100 44 88 2 1968145520 15108976 12651744
14:37:32 35373 8192000000 10874050544 11310501888 1942303552 19.165 100 29 58 2 1967050576 16095344 8651680
14:38:18 12823 8192000000 10878796576 11315859456 1947090000 19.203 100 29 58 0 1971631872 16184672 8357200
14:38:43 36754 8192000000 10873636752 11319865344 1948287824 19.213 100 24 48 2 1971795744 16416544 7091376
14:39:27 24991 8192000000 10893615696 11327180800 1957188192 19.284 100 29 58 3 1983106400 16660512 9257696
14:40:02 27105 8192000000 10900344624 11336986624 1961606288 19.319 100 37 74 0 1987800272 14993232 11200752
14:40:42 11163 8192000000 10914216064 11340042240 1968089408 19.370 100 51 101 2 1998085040 14809696 15185936
14:41:04 6236 8192000000 10919886864 11347255296 1972954896 19.409 100 55 108 3 2009119536 20757536 15407104
14:41:21 15367 8192000000 10917763264 11350827008 1977533808 19.445 100 53 106 1 2011115120 18356720 15224592
14:41:45 3425 8192000000 10922696448 11349725184 1985088096 19.505 100 69 135 1 2021039344 15302256 20648992
14:42:00 6678 8192000000 10931857536 11354275840 1984402944 19.500 100 66 128 1 2020154032 16961248 18789840
14:42:15 6745 8192000000 10920867280 11352514560 1979084688 19.457 100 61 122 1 2014954192 17861792 18007712
14:42:31 3441 8192000000 10942617872 11358912512 1983473920 19.492 100 70 139 2 2019785168 16561040 19750208
14:42:42 4809 8192000000 10938580608 11362930688 1988443872 19.531 100 64 127 0 2024986400 17566064 18976464
14:42:55 4143 8192000000 10948257344 11369246720 1992124624 19.561 100 76 152 2 2033021024 18451120 22445280
14:43:08 6276 8192000000 10944562640 11367600128 1991058000 19.552 100 66 130 3 2027073792 17296832 18718960
14:43:23 7580 8192000000 10953427184 11372863488 1994984320 19.583 100 67 132 4 2033322288 19123232 19214736
14:43:38 3302 8192000000 10964636800 11379511296 2002774016 19.645 100 88 176 0 2050125536 20834864 26516656
14:43:50 1307 8192000000 10969437072 11382214656 2004528224 19.658 100 90 178 6 2053292192 21253904 27510064
14:43:59 5261 8192000000 10968152960 11383996416 2007685200 19.683 100 82 160 0 2054384208 22508080 24190928
14:44:14 3098 8192000000 10974782832 11390238720 2008768032 19.692 100 79 156 0 2054935984 22704576 23463376
14:44:24 3063 8192000000 10973351776 11388084224 2007465136 19.682 100 75 150 1 2051029616 21286144 22278336
14:44:35 2797 8192000000 10978273984 11391406080 2009099824 19.694 100 81 162 0 2058434032 24001424 25332784
14:44:47 3559 8192000000 10962158000 11390177280 2006254032 19.672 100 63 126 0 2047632944 23447264 17931648
14:45:02 17327 8192000000 10947538048 11387719680 2003406096 19.650 100 57 114 3 2042622240 21469104 17747040
14:45:36 18912 8192000000 10956497728 11392679936 2002957232 19.646 100 44 88 1 2038708400 22021232 13729936
14:46:03 12789 8192000000 10953010160 11394428928 1993427984 19.571 99 46 92 1 2029499856 21897744 14174128
14:46:26 5994 8192000000 10980646912 11415773184 2016131296 19.750 100 58 116 0 2059333664 25178496 18023872
14:46:39 5755 8192000000 10979942864 11408642048 2014747648 19.739 100 66 131 0 2060374928 25525104 20102176
14:46:53 5845 8192000000 10989544112 11417677824 2026299264 19.830 100 78 156 0 2075254736 25408032 23547440
14:47:06 3273 8192000000 10994384336 11421757440 2024506928 19.816 100 65 130 2 2069831024 25627456 19696640
14:47:17 1369 8192000000 11011379488 11429781504 2035941856 19.905 100 88 176 2 2090572080 27390816 27239408
14:47:26 3530 8192000000 11006849776 11429945344 2036690080 19.911 100 93 186 0 2094706384 30078208 27938096
14:47:37 7123 8192000000 10990451536 11422248960 2025687120 19.825 100 64 128 1 2075659184 30525040 19447024
14:47:51 5592 8192000000 11003253200 11428753408 2029595296 19.855 100 75 151 2 2084094080 30964336 23534448
14:48:05 3764 8192000000 11004120704 11432198144 2032133152 19.875 100 87 175 2 2091113520 31950048 27030320
14:48:15 804 8192000000 11006839680 11432488960 2034212448 19.892 100 86 170 1 2091086912 30663856 26210608
14:48:23 2340 8192000000 11006731120 11426955264 2028834784 19.849 100 83 166 1 2083998704 28786448 26377472
14:48:35 2638 8192000000 11008700640 11429462016 2029695712 19.856 100 83 166 1 2086192320 30970848 25525760
14:48:47 1783 8192000000 11004690912 11426856960 2026738976 19.833 100 87 174 1 2085051376 31144240 27168160
14:48:55 4160 8192000000 10979061728 11410935808 2006043472 19.670 99 68 136 1 2058568768 31642400 20882896
14:49:08 5350 8192000000 10983832976 11400286208 2004174448 19.656 100 85 169 0 2059510096 29856384 25479264
14:49:25 2121 8192000000 10987700720 11406393344 2010741680 19.707 100 81 162 0 2067839424 31808000 25289744
14:49:34 3846 8192000000 10991039952 11414360064 2013978432 19.733 100 82 161 1 2070789600 31511488 25299680
14:49:48 5011 8192000000 10970625824 11403800576 1994405152 19.579 99 65 128 2 2043117040 28634272 20077616
14:50:02 4297 8192000000 10977044896 11408703488 2011949776 19.717 100 60 119 0 2059767744 28546736 19271232
14:50:13 2678 8192000000 10984230224 11405762560 1998066912 19.607 99 90 180 2 2055130672 29997296 27066464
14:50:24 5077 8192000000 10991660896 11414446080 2015583152 19.745 100 77 153 0 2070155744 31497776 23074816
14:50:36 5889 8192000000 10988760992 11411845120 2020249536 19.782 100 89 178 1 2080331552 33430256 26651760
14:50:56 5276 8192000000 10978961008 11410391040 1996750272 19.597 99 64 126 0 2049435648 33177840 19507536
14:51:08 9420 8192000000 10977892560 11393466368 1983326624 19.491 99 80 155 0 2040260784 32635328 24298832
14:51:26 3484 8192000000 10960997232 11391754240 1997131280 19.600 100 65 132 0 2045162864 27767120 20264464
14:51:37 6115 8192000000 10939194192 11369234432 1952327600 19.245 98 61 120 1 2000335680 28436464 19571616
14:51:51 2067 8192000000 10965254304 11382652928 1970609200 19.390 99 86 170 2 2027074560 29749424 26715936
14:52:05 3024 8192000000 10971475248 11389440000 1992602928 19.564 100 82 163 2 2050752784 32847760 25302096
14:52:15 6761 8192000000 10962438000 11385962496 1988008192 19.528 100 72 143 3 2042727168 32066000 22652976
14:52:29 1667 8192000000 10964370624 11383181312 1983510320 19.492 100 74 146 2 2038934016 32735232 22688464
14:52:37 3432 8192000000 10968279904 11393503232 1998664752 19.612 100 78 156 1 2056071488 33232576 24174160
14:52:49 7111 8192000000 10921976096 11362635776 1966867760 19.361 100 50 100 1 2013705712 30621408 16216544
14:53:17 3441 8192000000 10948282400 11374657536 1963815760 19.336 99 69 139 0 2014598304 29933552 20848992
14:53:29 1830 8192000000 10968583072 11389849600 1997471392 19.603 100 82 163 1 2056223984 33937792 24814800
14:53:38 1809 8192000000 10963930208 11386953728 1988614000 19.533 100 78 153 3 2047668176 35486224 23567952
14:53:47 6780 8192000000 10962198528 11395915776 1988533632 19.532 100 64 127 1 2046859760 38440336 19885792
14:54:12 7597 8192000000 10968337552 11401707520 1992823280 19.566 100 59 118 0 2050108768 38776288 18509200
14:54:29 3243 8192000000 10972116464 11406352384 1999845456 19.622 100 63 125 3 2058753680 38835632 20072592
14:54:40 7415 8192000000 10974745808 11408510976 2002271952 19.641 100 69 141 1 2059843248 36199728 21371568
14:54:54 9257 8192000000 10936503552 11378663424 1968897392 19.377 99 49 97 1 2021651120 37450992 15302736
14:55:10 13315 8192000000 10938690432 11384328192 1965734560 19.352 99 44 87 2 2019538656 40561440 13242656
14:55:30 14515 8192000000 10922308880 11374260224 1953978144 19.258 99 34 68 0 1998416192 33931872 10506176
14:55:52 8965 8192000000 10930395872 11370287104 1964112736 19.339 100 34 68 1 2007867936 33275280 10479920
14:56:16 10698 8192000000 10932440976 11383308288 1980279456 19.467 100 39 78 2 2024762416 32475264 12007696
14:56:33 16054 8192000000 10942826416 11383181312 1960177936 19.307 99 34 68 0 2006015776 35194752 10643088
14:56:57 12265 8192000000 10924845504 11362275328 1955009408 19.266 99 33 66 1 1999311104 33548016 10753680
14:57:25 5091 8192000000 10945564800 11378180096 1973087968 19.410 100 62 123 2 2029936144 37628528 19219648
14:57:42 2710 8192000000 10978378624 11395375104 1973308032 19.412 99 89 178 3 2044196016 42301600 28586384
14:57:54 12378 8192000000 10940660000 11392581632 1979401440 19.460 100 37 74 0 2030232176 38737552 12093184
14:58:18 9696 8192000000 10949087904 11402223616 1985808176 19.511 100 27 54 2 2033576416 38519536 9248704
14:58:39 14348 8192000000 10940223616 11387637760 1964443728 19.341 99 36 72 0 2011296128 35233104 11619296
14:59:00 12595 8192000000 10924773200 11371433984 1945215568 19.188 99 26 52 1 1987148112 33445616 8486928
14:59:20 25092 8192000000 10900798864 11349315584 1938290752 19.133 99 24 49 1 1977270688 31258608 7721328
14:59:51 28305 8192000000 10913365904 11363201024 1937154336 19.124 99 25 50 2 1978272208 32619184 8498688
15:00:26 23025 8192000000 10920329904 11377467392 1958968448 19.298 100 23 46 1 2002722384 36206608 7547328
15:01:03 31161 8192000000 10924458528 11383865344 1964749888 19.344 100 26 51 3 2009071088 35750112 8571088
15:01:41 16428 8192000000 10921527872 11366805504 1947497328 19.207 99 27 53 1 1987206480 31186576 8522576
15:02:10 35698 8192000000 10886067936 11335745536 1891690672 18.759 97 18 36 1 1932566528 34593568 6282288
15:02:54 21622 8192000000 10915006112 11358425088 1933296752 19.093 99 32 64 0 1980928272 37207792 10423728
15:03:23 54028 8192000000 10914541264 11356348416 1928035680 19.051 99 45 90 0 1975385648 33603216 13746752
15:04:27 47490 8192000000 10904961056 11367350272 1953362128 19.253 100 20 40 1 1989506832 30255152 5889552
15:05:28 46639 8192000000 10862330768 11316559872 1914020720 18.939 98 14 28 0 1941502976 23550400 3931856
15:06:21 20942 8192000000 10879759648 11353993216 1939736560 19.145 100 9 19 1 1962545936 20711056 2098320
15:06:51 18833 8192000000 10869596032 11342151680 1931947376 19.082 100 10 20 0 1960336080 25466880 2921824
15:07:19 18752 8192000000 10845191696 11288510464 1828437648 18.247 95 16 32 0 1859962576 26519888 5005040
15:07:45 85284 8192000000 10807972208 11261530112 1819152816 18.171 95 18 36 0 1834559776 10136672 5270288
15:09:17 45157 8192000000 10820592528 11277549568 1858215056 18.489 98 7 14 0 1870035376 10049488 1770832
15:10:09 73486 8192000000 10838807280 11290058752 1867813232 18.567 98 31 59 1 1895539072 18532560 9193280
15:11:29 148274 8192000000 10826437760 11289485312 1774641984 17.805 93 9 18 0 1789469136 13227120 1600032
15:14:03 39421 8192000000 10847839120 11287633920 1870505136 18.588 98 14 28 1 1882536976 8202832 3829008
15:14:53 52118 8192000000 10882080896 11318628352 1925721456 19.033 100 37 74 1 1949311952 13304400 10286096
15:15:56 60200 8192000000 10891237936 11324481536 1917150336 18.964 99 30 60 3 1942529568 15832896 9546336
15:17:14 31223 8192000000 10871744736 11319455744 1928588064 19.056 100 31 62 1 1956405344 18869136 8948144
15:18:14 84835 8192000000 10851357456 11313364992 1895618784 18.791 98 12 24 1 1917533296 18249904 3664608
15:20:03 133151 8192000000 10879965152 11343110144 1918843376 18.978 99 8 16 2 1934170304 13211344 2115584
15:22:34 98203 8192000000 10891262480 11370815488 1957871328 19.289 100 7 14 2 1978516464 18329152 2315984
15:24:18 87869 8192000000 10915639040 11354615808 1948183824 19.212 99 36 71 1 1967798080 9444112 10170144
15:25:57 144821 8192000000 10884589248 11352436736 1951563408 19.239 99 29 58 0 1971845232 12653264 7628560
15:28:30 57560 8192000000 10889904768 11335557120 1928910736 19.058 98 28 55 1 1944969168 8549504 7508928
15:29:35 18883 8192000000 10917643552 11359236096 1967950928 19.369 100 28 56 1 1985517040 9142720 8423392
15:30:05 26635 8192000000 10929840080 11378987008 1988218944 19.530 100 46 92 1 2013881200 12160064 13502192
15:31:05 40580 8192000000 10930068640 11390369792 2000699616 19.628 100 56 112 0 2030659120 14378704 15580800
15:31:56 45735 8192000000 10927920560 11393015808 1976336592 19.436 99 21 42 2 1999200816 16312992 6551232
15:33:09 40843 8192000000 10908105168 11388612608 1988657616 19.533 100 20 40 0 2010721616 16348576 5715424
15:33:57 48776 8192000000 10888233712 11359952896 1954065904 19.259 98 12 24 0 1969293024 12379744 2847376
15:35:03 63472 8192000000 10890546720 11366555648 1970949680 19.393 100 17 34 1 1989258304 13291840 5016784
15:36:21 14912 8192000000 10906127296 11379699712 1974259824 19.419 100 13 26 1 1998559568 20193152 4106592
15:36:42 13179 8192000000 10894538272 11391926272 1975657360 19.430 100 7 14 0 1996918560 19273280 1987920
15:37:07 49199 8192000000 10866778032 11336585216 1885972912 18.713 95 29 53 1 1899021328 6113360 6935056
15:38:10 92795 8192000000 10892097120 11362992128 1910876496 18.914 97 18 34 3 1928718576 13514416 4327664
15:39:49 71353 8192000000 10893211952 11365670912 1939442432 19.142 98 20 40 0 1959904992 15066384 5396176
15:41:06 53000 8192000000 10898193968 11364995072 1932717392 19.089 98 12 24 1 1949088800 12894592 3476816
15:42:27 10415 8192000000 10914028032 11357827072 1962769360 19.328 100 50 100 1 1987301248 9176240 15355648
15:42:46 51693 8192000000 10892507104 11340931072 1929585264 19.064 98 45 90 1 1954794448 12618304 12590880
15:43:48 14431 8192000000 10882908736 11324715008 1880926352 18.673 96 43 86 0 1907383104 13709104 12747648
15:44:34 18121 8192000000 10882050384 11324342272 1918265504 18.973 99 45 89 2 1940564352 9370336 12928512
15:45:01 28369 8192000000 10868634864 11322482688 1906379104 18.878 98 33 66 0 1926604096 11230096 8994896
15:45:43 44806 8192000000 10893704400 11351719936 1932151920 19.084 98 28 56 1 1951679808 11763680 7764208
15:46:40 72361 8192000000 10907328368 11355451392 1929398400 19.062 98 23 46 1 1953674288 17770960 6504928
15:48:01 20300 8192000000 10857552320 11311206400 1868988816 18.576 96 29 58 0 1885463952 8650992 7824144
15:48:31 35194 8192000000 10853722784 11307995136 1852834736 18.445 96 32 64 1 1877841104 15548544 9457824
15:50:47 144389 8192000000 10869163664 11323666432 1888100848 18.730 97 21 42 1 1905496608 11413136 5982624
15:53:25 76158 8192000000 10845622496 11315941376 1880142768 18.666 97 15 30 0 1891022864 6969456 3910640
15:54:47 1463 8192000000 10854279728 11314372608 1923951680 19.018 100 31 62 2 1944255408 11443744 8859984
15:55:34 71142 8192000000 10858785392 11334680576 1916794272 18.961 99 16 32 2 1933708672 12468848 4445552
15:56:51 40701 8192000000 10871949200 11345985536 1937962464 19.130 100 11 22 0 1963505744 21958048 3585232
15:57:43 96980 8192000000 10866253568 11341246464 1913259088 18.933 98 12 25 0 1928794384 12204576 3330720
15:59:34 65333 8192000000 10815649216 11276144640 1787387712 17.910 92 19 38 1 1801251136 8698224 5165200
16:00:50 17456 8192000000 10828562576 11291041792 1900868416 18.833 100 25 50 2 1916623056 8004704 7749936
16:01:16 77417 8192000000 10809319904 11280232448 1876568944 18.637 98 12 24 0 1888730992 8851136 3310912
16:03:12 51226 8192000000 10832472352 11284021248 1853141888 18.448 97 14 28 1 1864073392 7573952 3357552
16:04:11 28982 8192000000 10830421088 11293200384 1860130272 18.504 97 23 46 2 1874598048 8656368 5811408
16:04:51 60118 8192000000 10859134928 11325476864 1890210160 18.747 98 16 32 2 1907837072 13268640 4358272
16:05:58 42431 8192000000 10861268672 11319672832 1908949600 18.898 98 23 46 2 1925930976 10856096 6125280
16:07:43 54146 8192000000 10854959216 11311239168 1884231616 18.699 97 20 40 1 1905128960 14521728 6375616
16:08:46 42903 8192000000 10872074608 11326865408 1910093936 18.907 99 20 40 0 1924639968 8587072 5958960
16:09:41 66542 8192000000 10894098128 11361050624 1929925072 19.066 99 20 40 1 1951634032 15780304 5928656
16:11:18 43124 8192000000 10882958176 11354800128 1935846560 19.114 99 16 32 0 1961839856 20837056 5156240
16:12:07 27714 8192000000 10913029376 11364601856 1964059824 19.338 100 35 69 2 1991802224 17974000 9768400
16:12:48 116395 8192000000 10898664048 11359129600 1948243696 19.212 99 20 40 0 1970175120 16820512 5110912
16:14:56 20284 8192000000 10912059280 11364483072 1959222336 19.300 99 44 88 0 1983262592 11740912 12299344
16:15:27 74603 8192000000 10895800336 11375386624 1960465312 19.310 99 23 45 1 1979103712 12319280 6319120
16:16:49 66371 8192000000 10907581328 11396386816 1977145952 19.442 100 26 52 0 1998558576 14063824 7348800
16:18:02 82602 8192000000 10902288048 11369558016 1916108800 18.956 97 10 20 0 1936294256 17485072 2700384
16:19:31 102159 8192000000 10895655664 11364540416 1961616128 19.319 100 13 26 0 1976937664 11727280 3594256
16:21:20 51190 8192000000 10905112624 11369451520 1972120816 19.402 100 35 70 0 1992382400 10437920 9823664
16:22:20 29110 8192000000 10888532704 11369058304 1962569584 19.326 100 16 31 0 1978000848 11099696 4331568
16:22:56 40119 8192000000 10899532256 11377590272 1973226640 19.411 100 12 24 0 1994417712 17688864 3502208
16:23:49 53259 8192000000 10892839232 11376373760 1954705696 19.264 99 8 16 1 1967929520 11080496 2143328
16:24:48 14982 8192000000 10888892032 11362095104 1938791952 19.137 98 26 52 6 1958441344 11054512 8594880
16:25:12 76440 8192000000 10896673216 11351027712 1911135680 18.916 97 20 40 2 1928422768 11931248 5355840
16:26:45 76201 8192000000 10892791488 11366019072 1952412128 19.246 99 21 42 1 1976376240 18023728 5940384
16:28:07 93757 8192000000 10893972736 11388510208 1941799936 19.161 98 19 38 0 1972438688 24183184 6455568
16:29:47 83905 8192000000 10900300624 11361558528 1936408848 19.118 99 14 28 0 1963153680 22475712 4269120
16:31:18 33762 8192000000 9103374832 9320157184 268937168 3.178 14 4 8 0 275313680 5602016 774496

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 16:33:08 to 26-01-2021 16:33:40.

Exceptions occured during test was in run

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

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

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          227748
MON$OLDEST_ACTIVE               227749
MON$OLDEST_SNAPSHOT             227749
MON$NEXT_TRANSACTION            227749
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                       2019648
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Tue Jan 26 16:31:53 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Tue Jan 26 16:31:54 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

26.01.21 16:33:44. 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 16:33:46 No severe PSQL-related problems occured
26.01.21 16:33:48. End of report.