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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-16 16:31:18
DTS_END                         2021-02-16 16:31:18.2270
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/50376
TRN_ID                          231917
ATT_ID                          590
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: 9151.88 23441 1098225
customer order: creation 170.97 366 20516
customer order: refuse 14.54 348 1745
order to supplier: creation 45.80 1435 5496
order to supplier: removal 3.47 110590 416
invoice (draft): creation 47.32 3763 5678
invoice (draft): removal 51.38 871 6166
invoice accept: apply 41.72 21166 5006
invoice accept: cancel 45.84 980 5501
customer reserve: creation 3869.97 209 464396
customer reserve: removal 4570.37 66 548444
realization accept: apply 82.79 183 9935
realization accept: cancel 79.18 129 9502
payment from customer: creation 57.76 121 6931
payment from customer: removal 5.58 74 669
payment to supplier: creation 48.71 128 5845
payment to supplier: removal 3.88 83 465
service: total inventory turnovers 4.85 1186 582
service: total monetary turnovers 6.92 31 830
service: aggregate perf. data 0.82 18950 98
service: refresh index statistics 0.03 308144 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-02-2021 16:32:27 to 16-02-2021 16:32:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2229
TEST_TIME 2 3743
TEST_TIME 3 4614
TEST_TIME 4 4664
TEST_TIME 5 4628
TEST_TIME 6 4761
TEST_TIME 7 5012
TEST_TIME 8 5576
TEST_TIME 9 5630
TEST_TIME 10 6053
TEST_TIME 11 6391
TEST_TIME 12 6935
TEST_TIME 13 6737
TEST_TIME 14 6685
TEST_TIME 15 6763
TEST_TIME 16 6862
TEST_TIME 17 7130
TEST_TIME 18 7255
TEST_TIME 19 7377
TEST_TIME 20 7443
TEST_TIME 21 7953
TEST_TIME 22 7888
TEST_TIME 23 8188
TEST_TIME 24 8276
TEST_TIME 25 8473
TEST_TIME 26 8412
TEST_TIME 27 8366
TEST_TIME 28 8553
TEST_TIME 29 8867
TEST_TIME 30 9103
TEST_TIME 31 8978
TEST_TIME 32 9519
TEST_TIME 33 9770
TEST_TIME 34 10024
TEST_TIME 35 9915
TEST_TIME 36 10075
TEST_TIME 37 10112
TEST_TIME 38 10093
TEST_TIME 39 9936
TEST_TIME 40 9919
TEST_TIME 41 9894
TEST_TIME 42 9751
TEST_TIME 43 9588
TEST_TIME 44 9476
TEST_TIME 45 9493
TEST_TIME 46 9617
TEST_TIME 47 9445
TEST_TIME 48 9405
TEST_TIME 49 9344
TEST_TIME 50 9348
TEST_TIME 51 9384
TEST_TIME 52 9335
TEST_TIME 53 9227
TEST_TIME 54 9158
TEST_TIME 55 9236
TEST_TIME 56 9294
TEST_TIME 57 9411
TEST_TIME 58 9406
TEST_TIME 59 9397
TEST_TIME 60 9486
TEST_TIME 61 9485
TEST_TIME 62 9450
TEST_TIME 63 9492
TEST_TIME 64 9467
TEST_TIME 65 9477
TEST_TIME 66 9536
TEST_TIME 67 9515
TEST_TIME 68 9568
TEST_TIME 69 9589
TEST_TIME 70 9576
TEST_TIME 71 9681
TEST_TIME 72 9591
TEST_TIME 73 9510
TEST_TIME 74 9464
TEST_TIME 75 9444
TEST_TIME 76 9397
TEST_TIME 77 9405
TEST_TIME 78 9394
TEST_TIME 79 9341
TEST_TIME 80 9337
TEST_TIME 81 9289
TEST_TIME 82 9253
TEST_TIME 83 9244
TEST_TIME 84 9207
TEST_TIME 85 9174
TEST_TIME 86 9106
TEST_TIME 87 9086
TEST_TIME 88 9071
TEST_TIME 89 9067
TEST_TIME 90 9046
TEST_TIME 91 9114
TEST_TIME 92 9134
TEST_TIME 93 9168
TEST_TIME 94 9205
TEST_TIME 95 9240
TEST_TIME 96 9254
TEST_TIME 97 9302
TEST_TIME 98 9314
TEST_TIME 99 9319
TEST_TIME 100 9315
TEST_TIME 101 9348
TEST_TIME 102 9335
TEST_TIME 103 9314
TEST_TIME 104 9278
TEST_TIME 105 9217
TEST_TIME 106 9227
TEST_TIME 107 9202
TEST_TIME 108 9144
TEST_TIME 109 9136
TEST_TIME 110 9149
TEST_TIME 111 9187
TEST_TIME 112 9167
TEST_TIME 113 9167
TEST_TIME 114 9151
TEST_TIME 115 9206
TEST_TIME 116 9205
TEST_TIME 117 9222
TEST_TIME 118 9229
TEST_TIME 119 9205
TEST_TIME 120 9153

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 16-02-2021 16:32:31 to 16-02-2021 16:32:34.

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 1527068 1527068 0 0.00 0 14896 7 0 0
doc_list_biud 1527067 1527067 0 0.00 0 49650 30 0 0
sp_add_invoice_to_stock 5109 5006 103 2.01 34 254330 21167 0 103
sp_cancel_adding_invoice 5501 5501 0 0.00 4 75408 980 0 0
sp_cancel_client_order 1745 1745 0 0.00 4 10098 348 0 0
sp_cancel_customer_reserve 548444 548444 0 0.00 1 49652 67 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 2004 75 0 0
sp_cancel_pay_to_supplier 465 465 0 0.00 2 5430 84 0 0
sp_cancel_supplier_invoice 6176 6166 10 0.16 2 15859 871 0 10
sp_cancel_supplier_order 416 416 0 0.00 6 1059820 110590 0 0
sp_cancel_write_off 9502 9502 0 0.00 1 11085 130 0 0
sp_client_order 20516 20516 0 0.00 3 18200 367 0 0
sp_customer_reserve 464396 464396 0 0.00 0 86442 210 0 0
sp_fill_shopping_cart 31684 31684 0 0.00 1 10400 40 0 0
sp_fill_shopping_cart_clo_res 464386 464386 0 0.00 0 12819 13 0 0
sp_get_clo_for_invoice 4997 4997 0 0.00 0 27861 267 0 0
sp_kill_cost_storno 16137 16137 0 0.00 0 11059 64 0 0
sp_kill_qstorno_ret_qs2qd 1112972 1112972 0 0.00 0 49642 36 0 0
sp_kill_qty_storno 586705 586705 0 0.00 0 49650 78 0 0
sp_lock_selected_doc 20724 20724 0 0.00 0 12019 5 0 0
sp_make_cost_storno 27707 27707 0 0.00 0 14362 59 0 0
sp_multiply_rows_for_pdistr 27707 27707 0 0.00 0 8767 34 0 0
sp_multiply_rows_for_qdistr 20516 20516 0 0.00 0 18190 157 0 0
sp_pay_from_customer 6931 6931 0 0.00 4 12763 122 0 0
sp_pay_to_supplier 5845 5845 0 0.00 5 13302 128 0 0
sp_payment_common 12776 12776 0 0.00 1 12613 29 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 10074 321 0 0
sp_qd_handle_on_invoice_upd_sts 10497 10497 0 0.00 0 13626 383 0 0
sp_qd_handle_on_reserve_upd_sts 9935 9935 0 0.00 0 17300 62 0 0
sp_reserve_write_off 9935 9935 0 0.00 7 17327 183 0 0
sp_supplier_invoice 5678 5678 0 0.00 5 71839 3763 0 0
sp_supplier_order 5496 5496 0 0.00 5 30206 1435 0 0
srv_aggregate_perf_data 98 98 0 0.00 3656 155841 18950 0 0
srv_fill_mon_cache_memory 183 183 0 0.00 1261 142917 27706 0 0
srv_find_qd_qs_mism 1049933 1049933 0 0.00 0 14895 6 0 0
srv_make_invnt_saldo 582 582 0 0.00 40 58127 1186 0 0
srv_make_money_saldo 830 830 0 0.00 0 3136 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 184033 489948 308145 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5006 5006 0 0.00 0 11439 195 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 4697 99 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 1987 13 0 0
t$perf-norm:sp_cancel_customer_reserve 686 686 0 0.00 0 3674 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 3092 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 465 465 0 0.00 0 3300 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 797 13 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 21710 1788 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 892 7 0 0
t$perf-norm:sp_client_order 20516 20516 0 0.00 0 8689 20 0 0
t$perf-norm:sp_customer_reserve 998 998 0 0.00 0 1172 6 0 0
t$perf-norm:sp_pay_from_customer 6931 6931 0 0.00 0 4892 10 0 0
t$perf-norm:sp_pay_to_supplier 5845 5845 0 0.00 0 5409 13 0 0
t$perf-norm:sp_reserve_write_off 9935 9935 0 0.00 0 5480 14 0 0
t$perf-norm:sp_supplier_invoice 5678 5678 0 0.00 0 6163 27 0 0
t$perf-norm:sp_supplier_order 5496 5496 0 0.00 0 5997 21 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 759 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 183 183 0 0.00 0 643 11 0 0
t$perf-norm:srv_make_invnt_saldo 582 582 0 0.00 0 6659 41 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 1079 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10198 9992 206 2.02 0 3191 16 0 206
v_all_customers 37292 37292 0 0.00 0 17 1 0 0
v_all_suppliers 30790 30790 0 0.00 0 39 1 0 0
v_all_wares 41032 41032 0 0.00 0 55 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 341 6 0 0
v_cancel_client_order 3490 3490 0 0.00 0 1700 3 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 1246 4 0 0
v_cancel_customer_reserve 1372 1372 0 0.00 0 1701 6 0 0
v_cancel_payment_to_supplier 930 930 0 0.00 0 5287 11 0 0
v_cancel_supplier_invoice 824 804 20 2.42 0 438 15 0 20
v_cancel_supplier_order 832 832 0 0.00 0 256 3 0 0
v_cancel_write_off 2000 2000 0 0.00 0 1109 14 0 0
v_max_id_clo_ord 5495 5495 0 0.00 0 429 1 0 0
v_max_id_clo_res 997 997 0 0.00 0 2828 17 0 0
v_max_id_ord_sup 5672 5672 0 0.00 0 7900 6 0 0
v_max_non_paid_invoice 1617 1617 0 0.00 0 156 2 0 0
v_max_non_paid_realizn 3652 3652 0 0.00 0 5244 5 0 0
v_min_id_clo_ord 5495 5495 0 0.00 0 2270 6 0 0
v_min_id_clo_res 997 997 0 0.00 0 4952 15 0 0
v_min_id_ord_sup 5672 5672 0 0.00 0 3581 5 0 0
v_min_non_paid_invoice 5845 5845 0 0.00 0 5047 15 0 0
v_min_non_paid_realizn 6931 6931 0 0.00 0 9237 17 0 0
v_our_firm 10298 10298 0 0.00 0 230 1 0 0
v_reserve_write_off 19868 19868 0 0.00 0 3667 5 0 0
x_lock_depdocs_on_canc_invoice 11265 11265 0 0.00 0 11851 135 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 4115 330 0 0
x_make_qstorno_1000_1200 5496 5496 0 0.00 2 30194 1340 0 0
x_make_qstorno_1200_2000 5678 5678 0 0.00 2 71820 3628 0 0
x_make_qstorno_2100_3300 464396 464396 0 0.00 0 86438 194 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-02-2021 16:32:35 to 16-02-2021 16:32:39.

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:20 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:01:27 16913 8192000000 10244210048 10547220480 797305616 8.869 63 48 94 1 815138960 2382800 15450544
14:01:53 39172 8192000000 10347134304 10663849984 1379496368 14.412 100 82 164 0 1411112128 4897472 26718288
14:02:52 21332 8192000000 10384065296 10710380544 1442537840 14.972 100 83 166 1 1476744624 6983152 27223632
14:03:24 34858 8192000000 10418459408 10750861312 1467657296 15.193 100 90 180 0 1504675104 7757792 29260016
14:04:16 18196 8192000000 10442982384 10777505792 1497796752 15.457 100 88 176 1 1534762848 8775664 28190432
14:04:50 26682 8192000000 10471475616 10809413632 1523258944 15.679 100 85 170 0 1560203200 9534208 27410048
14:05:28 14657 8192000000 10487119648 10828144640 1541389984 15.836 100 89 178 0 1579054528 9956032 27708512
14:05:55 18070 8192000000 10515484496 10859966464 1567410768 16.060 100 85 170 1 1604712832 10621600 26680464
14:06:19 11321 8192000000 10536387440 10885226496 1588246192 16.239 100 84 168 3 1625741600 11472144 26023264
14:06:40 16560 8192000000 10542147440 10898911232 1600568368 16.344 100 71 142 1 1633144976 11304752 21271856
14:07:05 12527 8192000000 10567505936 10923433984 1623476016 16.539 100 85 169 1 1660456848 11996128 24984704
14:07:29 12433 8192000000 10586491808 10946134016 1643642176 16.711 100 86 171 0 1681820768 12640560 25538032
14:07:50 11459 8192000000 10599408864 10960551936 1658402656 16.835 100 83 166 1 1696397024 13655744 24338624
14:08:09 8319 8192000000 10620840960 10982264832 1665982096 16.899 100 78 156 1 1702496304 12997888 23516320
14:08:29 9428 8192000000 10636233376 11002433536 1694246624 17.137 100 84 164 1 1730757104 12848336 23662144
14:08:48 9326 8192000000 10653672352 11026251776 1708547152 17.257 100 84 168 0 1746551200 13577504 24426544
14:09:05 7395 8192000000 10662084864 11034828800 1723500368 17.381 100 82 164 2 1760791472 13530016 23761088
14:09:20 6789 8192000000 10672368880 11048763392 1735733120 17.483 100 82 164 1 1772821568 13033696 24054752
14:09:36 6462 8192000000 10692057888 11069935616 1744774656 17.558 100 70 140 2 1781618864 16966720 19877488
14:09:48 6405 8192000000 10701275856 11079081984 1758751536 17.674 100 80 158 1 1794468048 13166176 22550336
14:10:01 5370 8192000000 10702684688 11081396224 1764691680 17.723 100 72 144 0 1797375568 12066320 20617568
14:10:14 4865 8192000000 10711482320 11094605824 1779738112 17.847 100 77 153 0 1812860544 11803904 21318528
14:10:25 3552 8192000000 10722514960 11103211520 1783165024 17.876 100 82 164 1 1818353984 11829632 23359328
14:10:37 3900 8192000000 10732413264 11112574976 1792417360 17.952 100 82 165 1 1827910368 11646448 23846560
14:10:48 5366 8192000000 10728755552 11115704320 1800158848 18.015 100 76 153 4 1832794656 11914928 20720880
14:11:01 2854 8192000000 10746154448 11129761792 1812200608 18.114 100 82 165 2 1846563312 11480320 22882384
14:11:10 3951 8192000000 10749788544 11132739584 1816358256 18.148 100 88 176 0 1853006832 11910240 24738336
14:11:21 8890 8192000000 10753416512 11138162688 1817508000 18.157 100 68 136 1 1848153600 11788896 18856704
14:11:36 6170 8192000000 10760149216 11147350016 1825523328 18.223 100 81 162 0 1861260928 13310544 22427056
14:11:49 2721 8192000000 10778436576 11161575424 1833883136 18.291 100 84 168 2 1872038016 14193200 23961680
14:11:59 2455 8192000000 10779000304 11165892608 1838920656 18.332 100 84 168 2 1876953232 13637248 24395328
14:12:08 3182 8192000000 10789537712 11175776256 1846372944 18.393 100 90 180 3 1886181744 14478912 25329888
14:12:18 2556 8192000000 10790770944 11174842368 1847609136 18.403 100 84 169 1 1883576128 12030320 23936672
14:12:27 2606 8192000000 10797614368 11184009216 1853577936 18.451 100 89 180 1 1891887632 12854000 25455696
14:12:36 1804 8192000000 10804380320 11190505472 1857124544 18.480 100 88 176 1 1896252800 13922160 25206096
14:12:45 2331 8192000000 10804811696 11197153280 1864087168 18.536 100 91 182 3 1904508080 14254464 26166448
14:12:54 1721 8192000000 10811298576 11198386176 1867214896 18.562 100 87 174 1 1905237744 13028832 24994016
14:13:02 1261 8192000000 10811863888 11198537728 1867816176 18.567 100 90 179 1 1906876080 14141792 24918112
14:13:09 1720 8192000000 10812668464 11205885952 1874732624 18.623 100 96 192 0 1913904816 11693360 27478832
14:13:17 3657 8192000000 10798531968 11203063808 1874211344 18.618 100 78 154 2 1908444768 13198480 21034944
14:13:31 2548 8192000000 10810924592 11204513792 1879355552 18.660 100 83 164 0 1914123600 10706784 24061264
14:13:41 1983 8192000000 10816961808 11209203712 1872686656 18.606 100 78 156 1 1905980816 10448976 22845184
14:13:49 3478 8192000000 10792362000 11205120000 1874388192 18.620 100 51 102 0 1898937072 10334416 14214464
14:13:59 5486 8192000000 10783754784 11205181440 1872926992 18.608 100 33 66 0 1890699280 8695376 9076912
14:14:12 6801 8192000000 10782724224 11210858496 1876200640 18.634 100 41 83 1 1895748080 7304944 12242496
14:14:31 5110 8192000000 10793805264 11213807616 1877529248 18.645 100 36 72 1 1895708160 8507120 9671792
14:14:45 5109 8192000000 10794115856 11219963904 1880063904 18.666 100 30 60 1 1900429312 11739984 8625424
14:14:58 7644 8192000000 10795139328 11215663104 1880292672 18.667 100 28 56 0 1895502624 6717568 8492384
14:15:12 15995 8192000000 10809665072 11219267584 1888150816 18.731 100 40 80 0 1908825136 9794208 10880112
14:15:39 62207 8192000000 10807548464 11231719424 1885707072 18.711 100 29 58 1 1900119616 5579584 8832960
14:16:53 13555 8192000000 10801493264 11231084544 1888459600 18.733 100 29 56 0 1901937856 5104240 8374016
14:17:16 4680 8192000000 10800266368 11234799616 1891355328 18.757 100 28 56 2 1906079552 6909712 7814512
14:17:27 6639 8192000000 10808258832 11241627648 1893519840 18.774 100 26 52 0 1906629472 5110384 7999248
14:17:41 4601 8192000000 10821146832 11246624768 1898077232 18.811 100 34 68 1 1915529536 7006160 10446144
14:17:54 7858 8192000000 10809352368 11244580864 1897886960 18.809 100 18 36 0 1908702288 5643328 5172000
14:18:09 7418 8192000000 10809641968 11246813184 1903330400 18.853 100 16 32 0 1913553776 5524816 4698560
14:18:25 9432 8192000000 10825632928 11253534720 1903030752 18.851 100 17 35 2 1914429056 5769936 5628368
14:18:40 13568 8192000000 10823506640 11256184832 1905534128 18.871 100 24 48 1 1918917568 6316784 7066656
14:19:04 6048 8192000000 10821389680 11252027392 1905791968 18.873 100 26 50 2 1920102416 6674416 7636032
14:19:18 7567 8192000000 10820084800 11257135104 1907793376 18.889 100 22 45 0 1919509840 4973296 6743168
14:19:31 11328 8192000000 10821110112 11258007552 1910376672 18.910 100 21 42 1 1922229232 5832528 6020032
14:19:51 12516 8192000000 10817508224 11253874688 1889338784 18.740 99 14 28 0 1898653600 5544912 3769904
14:20:09 21541 8192000000 10818430128 11261206528 1909239904 18.901 100 20 40 0 1920622192 5595856 5786432
14:20:41 57684 8192000000 10851661808 11259768832 1901377216 18.837 99 46 93 1 1920383808 5351888 13654704
14:21:47 16921 8192000000 10822938960 11261865984 1912879088 18.930 100 20 41 0 1924411520 5114560 6417872
14:22:10 9457 8192000000 10817452112 11247239168 1874505056 18.621 98 31 60 0 1889514864 6592944 8416864
14:22:27 7605 8192000000 10775348768 11198025728 1845208368 18.383 97 37 74 0 1862911600 7577744 10125488
14:22:42 6529 8192000000 10779271952 11200921600 1794497328 17.969 95 34 68 1 1811454400 7080896 9876176
14:22:56 4305 8192000000 10779656256 11202375680 1842773296 18.363 99 26 52 4 1856429056 6753536 6902224
14:23:12 5316 8192000000 10755857648 11179671552 1810274768 18.098 97 26 51 2 1824048944 5521808 8252368
14:23:27 14653 8192000000 10730034928 11157692416 1754822224 17.642 95 18 36 0 1765632976 5633312 5177440
14:23:48 8825 8192000000 10752799760 11177275392 1806509328 18.067 98 19 38 1 1817291936 5751552 5031056
14:24:03 8483 8192000000 10731511200 11152703488 1768866688 17.758 96 19 38 0 1779317056 4664304 5786064
14:24:21 12038 8192000000 10744159856 11173097472 1816235056 18.147 99 23 47 0 1828952976 6147808 6570112
14:24:45 6921 8192000000 10711147408 11135844352 1776355472 17.819 97 20 41 1 1787827744 5696080 5776192
14:24:58 8565 8192000000 10703239808 11125645312 1756661664 17.657 97 25 50 1 1769680848 5744912 7274272
14:25:16 35385 8192000000 10719934528 11120533504 1791115600 17.941 100 26 51 1 1804062352 5934672 7012080
14:25:57 45853 8192000000 10663607808 11078385664 1592271728 16.273 88 29 58 0 1606014480 5448400 8294352
14:26:50 6155 8192000000 10667189040 11078373376 1704206112 17.220 96 36 72 0 1721786224 7021744 10558368
14:27:03 7617 8192000000 10709536656 11129782272 1793509024 17.961 100 40 80 3 1811036880 6566848 10961008
14:27:16 7387 8192000000 10725675744 11144908800 1811982880 18.112 100 32 64 2 1827688576 6751104 8954592
14:27:34 5603 8192000000 10732110768 11156901888 1821491936 18.190 100 28 57 0 1836172560 6386656 8293968
14:27:49 7454 8192000000 10731719424 11138306048 1795346816 17.976 98 28 56 1 1808982352 5636032 7999504
14:28:04 6755 8192000000 10744734960 11166773248 1827156192 18.236 100 23 46 1 1840304976 7114832 6033952
14:28:22 6522 8192000000 10742185568 11157463040 1797030128 17.990 98 34 69 1 1812968816 5064640 10874048
14:28:37 8181 8192000000 10741440688 11168333824 1825733760 18.225 100 17 33 0 1835352688 5167824 4451104
14:28:53 8123 8192000000 10770100128 11186073600 1841779392 18.355 100 27 52 1 1855296496 5723328 7793776
14:29:09 8465 8192000000 10743881648 11165442048 1825195968 18.220 99 39 78 0 1843286384 5939360 12151056
14:29:29 10103 8192000000 10754083632 11182247936 1842184384 18.359 100 25 51 1 1855350000 5687472 7478144
14:29:54 65193 8192000000 10771300064 11196256256 1852302640 18.441 100 32 62 1 1868319568 5801968 10214960
14:31:05 10152 8192000000 10788035024 11209125888 1864325936 18.538 100 16 30 2 1873355232 5044576 3984720
14:31:26 40316 8192000000 10821875424 11236642816 1883961344 18.697 100 42 84 2 1901937968 5807648 12168976
14:32:18 35136 8192000000 10822678960 11245584384 1896515584 18.798 100 41 80 2 1915372464 7656656 11200224
14:33:05 9959 8192000000 10833817424 11255308288 1906920864 18.882 100 43 85 2 1927467104 8075056 12471184
14:33:22 18055 8192000000 10852735792 11264311296 1913302432 18.933 100 46 92 2 1935441360 9159952 12978976
14:33:47 4199 8192000000 10850647984 11271872512 1919922288 18.986 100 58 113 3 1945878960 9809904 16146768
14:33:58 5205 8192000000 10854595184 11276566528 1925728496 19.033 100 58 112 3 1951465600 9510048 16227056
14:34:11 4039 8192000000 10862389728 11278172160 1924691936 19.024 100 50 100 3 1950663040 10082672 15888432
14:34:28 4565 8192000000 10867520432 11289391104 1932608416 19.088 100 63 124 1 1961052000 10338000 18105584
14:34:42 23989 8192000000 10864114192 11294187520 1937095920 19.124 100 54 108 0 1963618752 11288592 15234240
14:35:13 16303 8192000000 10886305888 11308736512 1942496592 19.167 100 54 108 3 1969107264 11113328 15497344
14:35:39 4966 8192000000 10883462096 11308978176 1947275248 19.205 100 54 108 0 1974818240 12299168 15243824
14:35:52 11860 8192000000 10904105040 11320139776 1953715184 19.256 100 61 122 0 1984734544 13302784 17716576
14:36:31 19398 8192000000 10887896160 11316785152 1956645136 19.279 100 51 100 2 1984043536 13394928 14003472
14:36:57 23031 8192000000 10887063440 11321995264 1955934064 19.274 100 48 96 1 1983537920 13505232 14098624
14:37:29 9860 8192000000 10886680464 11325083648 1958453168 19.294 100 38 72 3 1982785904 12978320 11354416
14:37:52 14319 8192000000 10901190288 11332464640 1961258224 19.316 100 49 95 2 1989175264 13863632 14053408
14:38:18 10635 8192000000 10898152160 11330191360 1964140576 19.339 100 52 104 1 1993585376 13586080 15858720
14:38:35 38453 8192000000 10900693280 11342630912 1968442032 19.373 100 43 85 1 1996991200 15544880 13004288
14:39:29 8785 8192000000 10918260448 11348271104 1972905968 19.408 100 46 92 2 2002464960 15386208 14172784
14:39:46 4494 8192000000 10924432576 11352358912 1977540000 19.445 100 67 132 2 2014494800 16655936 20298864
14:39:57 2586 8192000000 10924986752 11345977344 1976058752 19.433 100 68 133 1 2009104032 13387056 19658224
14:40:07 8616 8192000000 10932494208 11355725824 1980620128 19.470 100 74 145 3 2017665536 16624320 20421088
14:40:32 2396 8192000000 10938848352 11361497088 1985729664 19.510 100 73 147 0 2026160832 19203072 21228096
14:40:41 3327 8192000000 10938261664 11361685504 1986461856 19.516 100 70 138 2 2026030816 19033744 20535216
14:40:55 2268 8192000000 10941535232 11366481920 1988934256 19.535 100 75 148 0 2030970208 19707872 22328080
14:41:05 25365 8192000000 10939998528 11369197568 1993615952 19.572 100 67 132 1 2030698672 17812224 19270496
14:41:40 13999 8192000000 10943831920 11375960064 1992502784 19.564 100 66 132 2 2032166592 19959888 19703920
14:42:03 9534 8192000000 10951763280 11382116352 1997074096 19.600 100 73 146 0 2040945312 22270448 21600768
14:42:30 4685 8192000000 10955345440 11386273792 2003589328 19.651 100 72 144 0 2048403072 23188640 21625104
14:42:55 8728 8192000000 10925509360 11365998592 1984041920 19.497 99 55 110 0 2019996256 18704416 17249920
14:43:12 3242 8192000000 10961994800 11384320000 2002864512 19.645 100 78 155 3 2044428672 18499568 23064592
14:43:22 8865 8192000000 10962131744 11392126976 2008683888 19.691 100 75 147 0 2050510464 19011200 22815376
14:43:39 5538 8192000000 10954694144 11390902272 2008390752 19.689 100 62 124 3 2045153648 18158928 18603968
14:43:52 12328 8192000000 10959234048 11395305472 2012098592 19.718 100 71 140 2 2049377200 16862320 20416288
14:44:14 5125 8192000000 10967189840 11397836800 2015086064 19.742 100 67 133 3 2052007600 17086672 19834864
14:44:30 14332 8192000000 10972151104 11403231232 2018034928 19.765 100 65 128 1 2057536000 20380528 19120544
14:44:54 6810 8192000000 10985656592 11415400448 2029261856 19.853 100 78 156 1 2073587856 21247648 23078352
14:45:08 3905 8192000000 10982963856 11414396928 2027732464 19.841 100 65 129 0 2068190928 21579088 18879376
14:45:34 5735 8192000000 10994486784 11427012608 2030833168 19.865 100 74 147 1 2075617072 22267392 22516512
14:45:48 3441 8192000000 11005135808 11426017280 2034789664 19.896 100 77 152 1 2083613488 25626256 23197568
14:46:00 7056 8192000000 10981711776 11413278720 2021636032 19.793 100 67 129 0 2072184976 30747216 19801728
14:46:16 5660 8192000000 10980272448 11413794816 2003707472 19.652 99 75 150 2 2052810048 26521904 22580672
14:46:29 5361 8192000000 10979952352 11412987904 2021410768 19.791 100 65 125 1 2067332032 26885040 19036224
14:46:42 4032 8192000000 10994374112 11420110848 2027030032 19.835 100 76 146 3 2075832544 27085456 21717056
14:46:54 4623 8192000000 10994756960 11423666176 2027501024 19.839 100 72 144 3 2078183136 28408496 22273616
14:47:08 3369 8192000000 10997290592 11423870976 2032001664 19.874 100 74 148 1 2079219472 25258784 21959024
14:47:19 2870 8192000000 11011171552 11434622976 2037056208 19.914 100 84 164 1 2088767360 26352288 25358864
14:47:30 9568 8192000000 10992980496 11422404608 2013052720 19.726 99 75 149 1 2061940624 26333616 22554288
14:47:47 4202 8192000000 10993552864 11415388160 2020294480 19.782 100 82 163 2 2072538736 27633520 24610736
14:48:01 3800 8192000000 10997215088 11420971008 2024501008 19.815 100 76 152 0 2075969312 27957920 23510384
14:48:12 1259 8192000000 10999680912 11421954048 2026639760 19.832 100 87 171 0 2081582704 28423984 26518960
14:48:21 3090 8192000000 11002849536 11424555008 2030358032 19.861 100 83 165 1 2080949392 25630608 24960752
14:48:30 6382 8192000000 11005492032 11429625856 2031920272 19.874 100 82 161 0 2082558160 26428352 24209536
14:48:45 12874 8192000000 10996645360 11425828864 2032962048 19.882 100 78 156 0 2084061328 27107696 23991584
14:49:05 5821 8192000000 10988416624 11418939392 2025369856 19.822 100 78 157 0 2077408592 27460704 24578032
14:49:21 2977 8192000000 11022533936 11442130944 2039385984 19.932 100 85 168 0 2095764288 30658208 25720096
14:49:30 3257 8192000000 11024936624 11449892864 2043665920 19.966 100 89 178 0 2100985744 30210464 27109360
14:49:41 2405 8192000000 11026744256 11445952512 2046214976 19.986 100 89 178 0 2105376464 31411088 27750400
14:49:51 3478 8192000000 11026857632 11447570432 2047189472 19.993 100 85 170 1 2105049648 31560736 26299440
14:50:05 4053 8192000000 11015688016 11438759936 2037822240 19.920 100 84 167 3 2095052704 32438144 24792320
14:50:16 3190 8192000000 11000666112 11423330304 2013956144 19.733 99 80 160 2 2070838944 32288896 24593904
14:50:26 2911 8192000000 11009763312 11429625856 2029043808 19.851 100 92 182 1 2089932240 33742288 27146144
14:50:36 5484 8192000000 11008307936 11429773312 2030477312 19.862 100 82 165 0 2089981952 33888432 25616208
14:50:48 3916 8192000000 11001866656 11425275904 2010956000 19.709 99 84 168 3 2070462800 33570992 25935808
14:50:58 3823 8192000000 11003534592 11419832320 2016800576 19.755 100 88 175 0 2077683040 34090880 26791584
14:51:09 2853 8192000000 10986695488 11410894848 1994486864 19.579 99 79 158 0 2053812096 34501232 24824000
14:51:19 2565 8192000000 10976242928 11399565312 2003453728 19.650 100 80 160 1 2061806000 33515728 24836544
14:51:28 5099 8192000000 10994476736 11408920576 2010808528 19.708 100 90 180 1 2073021264 34654176 27558560
14:51:41 2507 8192000000 10986581472 11404951552 1998070608 19.608 99 89 179 1 2063448848 37845648 27532592
14:51:51 1458 8192000000 10998618784 11413868544 1995137888 19.584 99 93 184 0 2064629024 40076976 29414160
14:52:00 1963 8192000000 10979671152 11395981312 1988414224 19.531 99 93 186 1 2057207712 39920352 28873136
14:52:09 2154 8192000000 10989206784 11400552448 1999973360 19.623 100 92 187 0 2068056592 38559200 29524032
14:52:18 9651 8192000000 10965549216 11393585152 1987808400 19.526 100 64 128 2 2047265120 39577472 19879248
14:52:36 2356 8192000000 10946870288 11364560896 1969714480 19.383 99 75 148 1 2027769552 34989184 23065888
14:52:47 4233 8192000000 10961421968 11392397312 1985383616 19.507 100 57 114 0 2041403936 37642576 18377744
14:52:59 1619 8192000000 10978272464 11390316544 1989488800 19.540 100 72 142 1 2046849456 35733120 21627536
14:53:14 4149 8192000000 10950128112 11372695552 1973971600 19.417 99 72 142 1 2037664400 41732336 21960464
14:53:26 2926 8192000000 10972280976 11385982976 1979226432 19.459 99 90 180 0 2047701984 41426336 27049216
14:53:37 3142 8192000000 10991765536 11404959744 1996949792 19.599 100 87 174 2 2066892880 43294240 26648848
14:53:46 2556 8192000000 10974045824 11393929216 1988595456 19.533 100 75 150 4 2055270144 43357696 23316992
14:54:00 2110 8192000000 10973520368 11392712704 1970909584 19.393 99 79 158 1 2040067408 44953504 24204320
14:54:09 3254 8192000000 10971586448 11390660608 1979587504 19.461 100 72 144 1 2048060000 45855664 22616832
14:54:22 3134 8192000000 10967196816 11391414272 1982753664 19.486 100 69 136 0 2047317536 43209824 21354048
14:54:33 4638 8192000000 10944903536 11373522944 1959148400 19.299 99 59 118 0 2025554160 47939968 18465792
14:54:45 2785 8192000000 10968624544 11386888192 1979392640 19.460 100 71 142 0 2045247504 43028048 22826816
14:54:56 8373 8192000000 10954436976 11386916864 1982007760 19.481 100 51 102 0 2039490768 41171920 16311088
14:55:13 5712 8192000000 10946847104 11367829504 1942686832 19.168 98 59 114 1 1996689680 35286752 18716096
14:55:25 8369 8192000000 10937169120 11371454464 1956620656 19.279 99 49 98 1 2009309312 36816032 15872624
14:55:52 14517 8192000000 10929578416 11365171200 1930358736 19.070 98 41 80 2 1980018272 36445728 13213808
14:56:15 12705 8192000000 10942312304 11370106880 1964349664 19.341 100 64 128 2 2023150000 38496528 20303808
14:56:38 3644 8192000000 10927315328 11356708864 1954023904 19.259 100 58 115 1 2011769472 39702000 18043568
14:56:48 11856 8192000000 10911472944 11358089216 1944622208 19.184 100 40 80 0 1998088000 40730128 12735664
14:57:26 25490 8192000000 10902528096 11349594112 1941342016 19.157 100 34 68 0 1998743184 46091104 11310064
14:58:09 10075 8192000000 10893897536 11336331264 1924544528 19.023 99 39 78 2 1978323552 40429792 13349232
14:58:27 3462 8192000000 10912219584 11344080896 1923477360 19.015 99 51 101 1 1979302336 39508672 16316304
14:58:47 4209 8192000000 10919853168 11356041216 1940132160 19.148 100 42 84 0 1998567968 44438016 13997792
14:58:58 3439 8192000000 10939998160 11362762752 1954425616 19.262 100 66 131 1 2020831376 45547376 20858384
14:59:11 6392 8192000000 10932200848 11359010816 1945403328 19.190 100 62 124 2 2014517808 49094272 20020208
14:59:28 12116 8192000000 10926546800 11344175104 1934465392 19.103 99 57 112 2 2000613520 48566896 17581232
14:59:48 8504 8192000000 10905600064 11345186816 1916852304 18.962 99 43 86 0 1982497904 51461520 14184080
15:00:06 15478 8192000000 10905752336 11349278720 1932762176 19.089 100 38 77 0 1988840192 43377104 12700912
15:00:32 10050 8192000000 10893353664 11350011904 1933048320 19.091 100 22 44 1 1984929280 43722608 8158352
15:01:12 34519 8192000000 10908857792 11361968128 1940204176 19.148 100 24 48 0 1991265776 43345392 7716208
15:02:17 46968 8192000000 10903965232 11363577856 1933130128 19.092 100 20 40 1 1987656752 47832976 6693648
15:03:11 31992 8192000000 10900741504 11372326912 1936432144 19.118 100 18 37 1 1991236560 48606960 6197456
15:03:59 37269 8192000000 10868198784 11326087168 1870951760 18.592 97 10 20 2 1907506048 32975168 3579120
15:05:07 49314 8192000000 10854103744 11301572608 1890496784 18.750 99 13 26 0 1906847088 12317408 4032896
15:06:06 50407 8192000000 10841621408 11295105024 1884997632 18.705 98 19 38 1 1903059232 12619968 5441632
15:07:07 107510 8192000000 10867624864 11327066112 1849278592 18.416 96 7 14 1 1867289344 16122192 1888560
15:09:01 110336 8192000000 10888137776 11335581696 1904844912 18.865 98 17 34 0 1919060048 9604320 4610816
15:10:59 39771 8192000000 10886702736 11328155648 1937149696 19.124 99 46 93 1 1958383744 8323632 12910416
15:11:48 53024 8192000000 10878095648 11339014144 1931402800 19.078 99 18 36 1 1946336224 10005104 4928320
15:12:53 52300 8192000000 10878537824 11304296448 1877657280 18.646 96 36 68 1 1895935088 8079520 10198288
15:13:52 109301 8192000000 10882686656 11341959168 1945229296 19.188 100 29 58 2 1964619888 10937584 8453008
15:15:47 59139 8192000000 10873027216 11334463488 1910624256 18.912 98 23 46 0 1928495216 10934000 6936960
15:16:54 40920 8192000000 10885737024 11341783040 1920504176 18.991 98 41 80 2 1945086192 12252800 12329216
15:17:41 95402 8192000000 10918618064 11350130688 1932897152 19.090 99 56 112 1 1960151088 9942224 17311712
15:19:23 11055 8192000000 10895894768 11347431424 1944985072 19.187 99 35 70 0 1966557680 11612064 9960544
15:19:44 68109 8192000000 10891632672 11362467840 1966469104 19.357 100 18 36 0 1982725168 10700624 5555440
15:20:58 38647 8192000000 10919259616 11370213376 1953506336 19.254 99 34 68 0 1975051552 11361728 10183488
15:21:47 16581 8192000000 10925442336 11378032640 1976520000 19.437 100 45 90 0 2004351440 14673392 13158048
15:22:16 21895 8192000000 10925143376 11393208320 1980779792 19.471 100 39 78 3 2013601904 21580784 11241328
15:22:47 63154 8192000000 10918772064 11398074368 1983671520 19.494 100 17 34 1 2013435904 23999648 5764736
15:24:06 46099 8192000000 10915248288 11387744256 1966740816 19.360 99 12 24 2 1989987536 19372512 3874208
15:24:58 31956 8192000000 10921719680 11394793472 1982107744 19.481 100 13 27 0 2009869648 23776160 3985744
15:25:38 26185 8192000000 10927692928 11398856704 1982881840 19.488 100 13 26 1 2010954640 23630352 4442448
15:26:34 69300 8192000000 10924524480 11403202560 1985309360 19.507 100 16 32 0 2016986832 25764736 5912736
15:28:13 69039 8192000000 10917823456 11410751488 1985358592 19.507 100 13 26 0 2004749376 15781312 3609472
15:29:33 69106 8192000000 10905218608 11373359104 1939993872 19.147 98 20 41 2 1961343664 15451552 5898240
15:30:49 61953 8192000000 10901536384 11379535872 1933648000 19.096 98 9 18 0 1951785664 15748736 2388928
15:31:57 54182 8192000000 10899921056 11370950656 1944444640 19.182 99 10 20 0 1960584496 13343360 2796496
15:32:57 27216 8192000000 10895780528 11360751616 1940770864 19.153 98 43 81 1 1959361936 7453728 11137344
15:33:35 45832 8192000000 10888873152 11354370048 1910608880 18.912 97 20 40 0 1924270656 8163088 5498688
15:34:42 49763 8192000000 10883489776 11343605760 1910074592 18.907 97 15 30 2 1920932176 7262480 3595104
15:35:39 35291 8192000000 10886709040 11347877888 1909345904 18.901 97 22 44 0 1927927056 12722592 5858560
15:36:26 24990 8192000000 10862079088 11325448192 1917830032 18.969 98 18 36 0 1931775216 9211600 4733584
15:37:03 51455 8192000000 10907907488 11351977984 1923035600 19.011 98 16 32 0 1936983872 8978992 4969280
15:38:05 13005 8192000000 10912039600 11368124416 1968394448 19.373 100 35 70 2 1989481776 11335600 9751728
15:38:27 31845 8192000000 10915830512 11373666304 1955472064 19.270 99 26 52 0 1974979824 12418864 7088896
15:39:56 23280 8192000000 10924306848 11366264832 1911043440 18.915 96 55 110 1 1938125952 11458656 15623856
15:40:28 24457 8192000000 10909126640 11369586688 1948127952 19.212 99 46 92 2 1972456320 11498032 12830336
15:40:59 40342 8192000000 10875395648 11346305024 1902798064 18.849 97 19 38 0 1919599936 11104640 5697232
15:42:23 142917 8192000000 10851087856 11308593152 1805260816 18.057 93 20 40 1 1820858176 9972512 5624848
15:45:09 46671 8192000000 10876956848 11328368640 1881780560 18.679 97 25 50 1 1897247728 8528192 6938976
15:46:02 62575 8192000000 10897628240 11340435456 1938686112 19.136 100 43 86 1 1965129584 13974544 12468928
15:47:11 29282 8192000000 10881526384 11320586240 1910352048 18.909 98 45 89 1 1933825552 10815168 12658336
15:47:48 29774 8192000000 10881106272 11328847872 1915190640 18.948 99 45 88 3 1937886912 10290432 12405840
15:48:25 95102 8192000000 10862190736 11337818112 1885806432 18.712 97 15 30 0 1897685808 7587664 4291712
15:50:07 73209 8192000000 10866662112 11334938624 1889486064 18.742 97 16 32 0 1904820688 10650784 4683840
15:52:19 39274 8192000000 10839199312 11310985216 1875008768 18.625 97 13 26 0 1889453248 11005248 3439232
15:54:18 66889 8192000000 10837857504 11306885120 1893106640 18.771 98 16 33 1 1904044224 6251504 4686080
15:55:32 24734 8192000000 10834769072 11306082304 1908379904 18.894 99 21 41 2 1920980240 5815088 6785248
15:56:12 65048 8192000000 10833774560 11316248576 1896355680 18.797 98 16 32 0 1908647536 8050448 4241408
15:57:48 56352 8192000000 10833511264 11317923840 1889903152 18.745 98 7 14 1 1900251664 8263600 2084912
15:58:51 69049 8192000000 10857321424 11331620864 1884136224 18.698 97 15 30 3 1898881520 10529584 4215712
16:00:09 44828 8192000000 10872227504 11355844608 1937908768 19.130 100 10 20 1 1951203072 10549968 2744336
16:01:00 43342 8192000000 10886491264 11352834048 1903283280 18.853 97 15 30 1 1921102976 13541424 4278272
16:01:50 62394 8192000000 10883765168 11354181632 1897239824 18.804 97 21 40 2 1916881024 13992160 5649040
16:03:01 36301 8192000000 10882672448 11358289920 1938752464 19.137 99 30 60 0 1960849008 13415248 8681296
16:04:22 68956 8192000000 10868496528 11342290944 1866226112 18.554 95 14 28 0 1884890768 14645040 4019616
16:05:41 44867 8192000000 10874594352 11343319040 1908147296 18.892 98 22 44 1 1923278384 8750784 6380304
16:06:33 36292 8192000000 10897661552 11357253632 1955514320 19.270 100 39 78 0 1976371824 10204720 10652784
16:07:19 30282 8192000000 10901578240 11366498304 1946258832 19.197 99 37 74 1 1966570208 10296144 10015232
16:08:14 85784 8192000000 10910669616 11389935616 1955855408 19.273 99 14 26 0 1970711360 11277312 3578640
16:09:47 65124 8192000000 10928997504 11399356416 1987700128 19.526 100 15 30 0 2008878240 17044000 4134112
16:10:58 117940 8192000000 10915756464 11389378560 1914663760 18.944 96 13 26 1 1926431552 8637280 3130512
16:13:02 20719 8192000000 10910312784 11374223360 1947947360 19.210 98 21 42 0 1962079760 8532896 5599504
16:13:34 37631 8192000000 10921981152 11391754240 1964178608 19.339 99 28 56 0 1982934480 11064480 7691392
16:14:26 97630 8192000000 10906538192 11380891648 1974792016 19.423 100 34 68 1 1996039056 11759760 9487280
16:16:29 50611 8192000000 10923056288 11397775360 1984894048 19.503 100 23 46 0 2009248112 18153952 6200112
16:17:26 45141 8192000000 10916472592 11397840896 1964254016 19.340 99 13 26 1 1982036688 14304784 3477888
16:18:18 77296 8192000000 10918204176 11407704064 1990277760 19.546 100 9 18 0 2006952000 13698944 2975296
16:19:42 52150 8192000000 10892368032 11385675776 1930855360 19.074 97 9 18 2 1946106560 12616992 2634208
16:20:55 35173 8192000000 10876775120 11369529344 1955648400 19.271 99 9 17 0 1965128784 7239360 2241024
16:21:43 46184 8192000000 10906070800 11392688128 1980895920 19.472 100 30 60 0 1998904208 8946272 9062016
16:22:35 54893 8192000000 10902382192 11373723648 1939587296 19.143 98 9 18 1 1949857888 7863840 2406752
16:23:36 47792 8192000000 10925943232 11396415488 1966599088 19.358 99 28 57 1 1983755616 9132768 8023760
16:24:37 60718 8192000000 10894097696 11375960064 1931403664 19.078 97 22 45 1 1951889280 13761760 6723856
16:25:44 93728 8192000000 10899633312 11387994112 1955567536 19.271 99 18 36 1 1979243024 17492512 6182976
16:27:56 69569 8192000000 10906692992 11381731328 1940720752 19.153 98 21 42 2 1954562592 7782048 6059792
16:29:12 32919 8192000000 10896057632 11364732928 1913100896 18.932 97 36 72 2 1936293712 13077904 10114912
16:30:01 34513 8192000000 10881456640 11349356544 1896949296 18.802 97 21 42 1 1915005184 12169296 5886592
16:30:42 40089 8192000000 10425556240 10861252608 1515633920 15.612 78 26 50 3 1539879136 16650128 7595088

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 16-02-2021 16:32:41 to 16-02-2021 16:33:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-02-2021 16:33:15 to 16-02-2021 16:33:17.

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          232167
MON$OLDEST_ACTIVE               232168
MON$OLDEST_SNAPSHOT             232168
MON$NEXT_TRANSACTION            232168
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                       2020672
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 Feb 16 16:31:49 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Tue Feb 16 16:31:50 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Tue Feb 16 16:32:00 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
--- end of diff output ---

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

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