Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.06.2021 16:29
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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 17217368 kB
MemAvailable 31404256 kB
Buffers 0 kB
Cached 14484420 kB
SwapCached 2412 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-06-21 16:27:42
DTS_END                         2021-06-21 16:27:42.8520
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/41458
TRN_ID                          242831
ATT_ID                          663
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: 9411.50 21466 1129380
customer order: creation 175.39 386 21047
customer order: refuse 14.71 352 1765
order to supplier: creation 44.66 1362 5359
order to supplier: removal 3.73 96182 448
invoice (draft): creation 45.84 3372 5501
invoice (draft): removal 54.14 762 6497
invoice accept: apply 41.73 17615 5007
invoice accept: cancel 49.38 763 5925
customer reserve: creation 3867.22 175 464066
customer reserve: removal 4808.51 59 577021
realization accept: apply 84.32 176 10118
realization accept: cancel 93.20 109 11184
payment from customer: creation 59.03 110 7083
payment from customer: removal 5.28 96 634
payment to supplier: creation 48.59 122 5831
payment to supplier: removal 3.47 54 416
service: total inventory turnovers 5.16 1036 619
service: total monetary turnovers 6.19 24 743
service: aggregate perf. data 0.93 15737 112
service: refresh index statistics 0.03 290834 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-06-2021 16:29:59 to 21-06-2021 16:30:01.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2416
TEST_TIME 2 2791
TEST_TIME 3 3579
TEST_TIME 4 3350
TEST_TIME 5 4031
TEST_TIME 6 4316
TEST_TIME 7 4790
TEST_TIME 8 4577
TEST_TIME 9 4611
TEST_TIME 10 4805
TEST_TIME 11 5004
TEST_TIME 12 5192
TEST_TIME 13 5216
TEST_TIME 14 5658
TEST_TIME 15 5975
TEST_TIME 16 6283
TEST_TIME 17 6797
TEST_TIME 18 7301
TEST_TIME 19 7395
TEST_TIME 20 7622
TEST_TIME 21 7981
TEST_TIME 22 8402
TEST_TIME 23 8880
TEST_TIME 24 9418
TEST_TIME 25 9628
TEST_TIME 26 9964
TEST_TIME 27 10532
TEST_TIME 28 10601
TEST_TIME 29 10769
TEST_TIME 30 10627
TEST_TIME 31 10469
TEST_TIME 32 10467
TEST_TIME 33 10172
TEST_TIME 34 10380
TEST_TIME 35 10372
TEST_TIME 36 10180
TEST_TIME 37 10042
TEST_TIME 38 9981
TEST_TIME 39 9981
TEST_TIME 40 9895
TEST_TIME 41 9838
TEST_TIME 42 9833
TEST_TIME 43 9742
TEST_TIME 44 9716
TEST_TIME 45 9539
TEST_TIME 46 9712
TEST_TIME 47 9706
TEST_TIME 48 9682
TEST_TIME 49 9688
TEST_TIME 50 9841
TEST_TIME 51 9897
TEST_TIME 52 9873
TEST_TIME 53 9834
TEST_TIME 54 9769
TEST_TIME 55 9910
TEST_TIME 56 9984
TEST_TIME 57 10016
TEST_TIME 58 10113
TEST_TIME 59 10107
TEST_TIME 60 9974
TEST_TIME 61 9866
TEST_TIME 62 9853
TEST_TIME 63 9859
TEST_TIME 64 9746
TEST_TIME 65 9710
TEST_TIME 66 9695
TEST_TIME 67 9686
TEST_TIME 68 9697
TEST_TIME 69 9685
TEST_TIME 70 9773
TEST_TIME 71 9816
TEST_TIME 72 9868
TEST_TIME 73 9965
TEST_TIME 74 9950
TEST_TIME 75 9937
TEST_TIME 76 9938
TEST_TIME 77 9933
TEST_TIME 78 9922
TEST_TIME 79 9864
TEST_TIME 80 9821
TEST_TIME 81 9774
TEST_TIME 82 9738
TEST_TIME 83 9675
TEST_TIME 84 9639
TEST_TIME 85 9588
TEST_TIME 86 9586
TEST_TIME 87 9620
TEST_TIME 88 9580
TEST_TIME 89 9609
TEST_TIME 90 9590
TEST_TIME 91 9628
TEST_TIME 92 9635
TEST_TIME 93 9640
TEST_TIME 94 9682
TEST_TIME 95 9696
TEST_TIME 96 9660
TEST_TIME 97 9658
TEST_TIME 98 9660
TEST_TIME 99 9663
TEST_TIME 100 9596
TEST_TIME 101 9559
TEST_TIME 102 9531
TEST_TIME 103 9480
TEST_TIME 104 9433
TEST_TIME 105 9410
TEST_TIME 106 9416
TEST_TIME 107 9407
TEST_TIME 108 9429
TEST_TIME 109 9412
TEST_TIME 110 9418
TEST_TIME 111 9405
TEST_TIME 112 9419
TEST_TIME 113 9401
TEST_TIME 114 9449
TEST_TIME 115 9444
TEST_TIME 116 9461
TEST_TIME 117 9493
TEST_TIME 118 9467
TEST_TIME 119 9456
TEST_TIME 120 9413

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-06-2021 16:30:02 to 21-06-2021 16:30:05.

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 1559802 1559802 0 0.00 0 28754 6 0 0
doc_list_biud 1559802 1559802 0 0.00 0 41698 28 0 0
sp_add_invoice_to_stock 5132 5007 125 2.43 29 169598 17616 0 125
sp_cancel_adding_invoice 5925 5925 0 0.00 4 108368 763 0 0
sp_cancel_client_order 1765 1765 0 0.00 4 14227 353 0 0
sp_cancel_customer_reserve 577021 577021 0 0.00 1 32989 59 0 0
sp_cancel_pay_from_customer 634 634 0 0.00 3 7460 97 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 1845 55 0 0
sp_cancel_supplier_invoice 6508 6497 11 0.16 2 18937 762 0 11
sp_cancel_supplier_order 448 448 0 0.00 6 1197386 96183 0 0
sp_cancel_write_off 11184 11184 0 0.00 1 10419 110 0 0
sp_client_order 21047 21047 0 0.00 3 29432 386 0 0
sp_customer_reserve 464066 464066 0 0.00 0 57814 175 0 0
sp_fill_shopping_cart 31894 31894 0 0.00 1 11913 37 0 0
sp_fill_shopping_cart_clo_res 464065 464065 0 0.00 0 14350 14 0 0
sp_get_clo_for_invoice 5005 5005 0 0.00 0 15472 261 0 0
sp_kill_cost_storno 18159 18159 0 0.00 0 28746 54 0 0
sp_kill_qstorno_ret_qs2qd 1172171 1172171 0 0.00 0 32950 32 0 0
sp_kill_qty_storno 617962 617962 0 0.00 0 41694 69 0 0
sp_lock_selected_doc 20901 20901 0 0.00 0 8554 6 0 0
sp_make_cost_storno 28036 28036 0 0.00 0 16776 49 0 0
sp_multiply_rows_for_pdistr 28036 28036 0 0.00 0 7454 24 0 0
sp_multiply_rows_for_qdistr 21047 21047 0 0.00 0 22737 171 0 0
sp_pay_from_customer 7083 7083 0 0.00 4 20651 110 0 0
sp_pay_to_supplier 5831 5831 0 0.00 5 20718 123 0 0
sp_payment_common 12914 12914 0 0.00 1 10821 24 0 0
sp_qd_handle_on_cancel_clo 1765 1765 0 0.00 0 14219 312 0 0
sp_qd_handle_on_invoice_upd_sts 10929 10929 0 0.00 0 41684 329 0 0
sp_qd_handle_on_reserve_upd_sts 10118 10118 0 0.00 0 27140 57 0 0
sp_reserve_write_off 10118 10118 0 0.00 7 27435 176 0 0
sp_supplier_invoice 5501 5501 0 0.00 6 98151 3372 0 0
sp_supplier_order 5359 5359 0 0.00 5 50460 1362 0 0
srv_aggregate_perf_data 112 112 0 0.00 2583 136495 15738 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1159 143301 33820 0 0
srv_find_qd_qs_mism 1081907 1081907 0 0.00 0 12933 5 0 0
srv_make_invnt_saldo 619 619 0 0.00 26 81823 1037 0 0
srv_make_money_saldo 743 743 0 0.00 1 1432 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 156120 374886 290835 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5007 5007 0 0.00 0 17340 144 0 0
t$perf-norm:sp_cancel_adding_invoice 419 419 0 0.00 0 8015 123 0 0
t$perf-norm:sp_cancel_client_order 1765 1765 0 0.00 0 4336 11 0 0
t$perf-norm:sp_cancel_customer_reserve 722 722 0 0.00 0 2017 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 634 634 0 0.00 0 4740 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 590 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 2073 13 0 0
t$perf-norm:sp_cancel_supplier_order 448 448 0 0.00 0 26958 1405 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 1803 8 0 0
t$perf-norm:sp_client_order 21047 21047 0 0.00 0 5496 15 0 0
t$perf-norm:sp_customer_reserve 929 929 0 0.00 0 2233 6 0 0
t$perf-norm:sp_pay_from_customer 7083 7083 0 0.00 0 8735 13 0 0
t$perf-norm:sp_pay_to_supplier 5831 5831 0 0.00 0 11686 12 0 0
t$perf-norm:sp_reserve_write_off 10118 10118 0 0.00 0 4624 9 0 0
t$perf-norm:sp_supplier_invoice 5501 5501 0 0.00 0 5921 20 0 0
t$perf-norm:sp_supplier_order 5359 5359 0 0.00 0 7273 17 0 0
t$perf-norm:srv_aggregate_perf_data 112 112 0 0.00 0 37 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 255 4 0 0
t$perf-norm:srv_make_invnt_saldo 619 619 0 0.00 0 668 15 0 0
t$perf-norm:srv_make_money_saldo 743 743 0 0.00 0 793 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 10258 10008 250 2.43 0 9154 22 0 250
v_all_customers 38276 38276 0 0.00 0 34 1 0 0
v_all_suppliers 30446 30446 0 0.00 0 153 1 0 0
v_all_wares 42088 42088 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 838 838 0 0.00 0 2419 11 0 0
v_cancel_client_order 3530 3530 0 0.00 0 10924 11 0 0
v_cancel_customer_prepayment 1268 1268 0 0.00 0 1906 8 0 0
v_cancel_customer_reserve 1444 1444 0 0.00 0 2405 8 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 822 4 0 0
v_cancel_supplier_invoice 784 762 22 2.80 0 1399 22 0 22
v_cancel_supplier_order 896 896 0 0.00 0 2103 7 0 0
v_cancel_write_off 1988 1988 0 0.00 0 3000 13 0 0
v_max_id_clo_ord 5357 5357 0 0.00 0 4477 2 0 0
v_max_id_clo_res 929 929 0 0.00 0 1884 10 0 0
v_max_id_ord_sup 5492 5492 0 0.00 0 6027 5 0 0
v_max_non_paid_invoice 1457 1457 0 0.00 0 437 3 0 0
v_max_non_paid_realizn 3730 3730 0 0.00 0 1690 3 0 0
v_min_id_clo_ord 5357 5357 0 0.00 0 4942 6 0 0
v_min_id_clo_res 929 929 0 0.00 0 4562 9 0 0
v_min_id_ord_sup 5492 5492 0 0.00 0 8734 9 0 0
v_min_non_paid_invoice 5831 5831 0 0.00 0 6746 16 0 0
v_min_non_paid_realizn 7083 7083 0 0.00 0 10811 14 0 0
v_our_firm 10518 10518 0 0.00 0 43 1 0 0
v_reserve_write_off 20236 20236 0 0.00 0 8807 7 0 0
x_lock_depdocs_on_canc_invoice 12041 12041 0 0.00 0 24775 100 0 0
x_lock_depdocs_on_canc_sup_ord 448 448 0 0.00 0 2534 261 0 0
x_make_qstorno_1000_1200 5359 5359 0 0.00 1 50449 1291 0 0
x_make_qstorno_1200_2000 5501 5501 0 0.00 3 98137 3228 0 0
x_make_qstorno_2100_3300 464066 464066 0 0.00 0 57810 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-06-2021 16:30:06 to 21-06-2021 16:30:10.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:46 2 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
13:57:52 15333 8192000000 10248272208 10555916288 961652736 10.505 76 57 114 0 984724448 2727488 20344224
13:58:16 23736 8192000000 10358898320 10676473856 1401164416 14.605 100 87 174 0 1433697360 4857648 27675296
13:58:53 31724 8192000000 10394316336 10723160064 1447817552 15.019 100 90 180 0 1484234672 6948576 29468544
13:59:40 11831 8192000000 10417165856 10749779968 1477960704 15.284 100 86 172 0 1514108432 8279664 27868064
14:00:05 15712 8192000000 10444406256 10778472448 1496583744 15.446 100 86 172 0 1532810144 8599296 27627104
14:00:33 7063 8192000000 10461802096 10797768704 1518749328 15.639 100 88 176 0 1556286720 9400560 28136832
14:00:50 23317 8192000000 10478714528 10817019904 1530670240 15.743 100 90 180 2 1569551248 10066704 28814304
14:01:26 14988 8192000000 10488932048 10829287424 1542607712 15.846 100 87 174 0 1580646688 10390624 27648352
14:02:03 20852 8192000000 10503454960 10852663296 1562709632 16.020 100 77 154 0 1598176144 10971376 24495136
14:02:38 20564 8192000000 10539593744 10891292672 1595568256 16.301 100 82 164 0 1632179808 11905552 24706000
14:03:07 11384 8192000000 10555000592 10914021376 1609306800 16.419 100 82 164 0 1646413472 12448416 24658256
14:03:26 10341 8192000000 10566396496 10924539904 1622331712 16.530 100 79 158 0 1658174016 11829248 24013056
14:03:45 11127 8192000000 10580145840 10948902912 1647513344 16.743 100 72 144 0 1680422608 11138832 21770432
14:04:10 9002 8192000000 10611283632 10980827136 1679428224 17.013 100 77 154 0 1713836128 11673680 22734224
14:04:28 4991 8192000000 10631943104 11003138048 1696653120 17.157 100 81 162 0 1733594720 13272896 23668704
14:04:40 7024 8192000000 10652676336 11020062720 1707706960 17.250 100 85 170 0 1745466016 13753632 24005424
14:04:58 7172 8192000000 10660847008 11035844608 1722199600 17.371 100 85 170 1 1760566832 14477152 23890080
14:05:12 7216 8192000000 10674577072 11053993984 1733299936 17.463 100 73 145 2 1766409280 12923840 20185504
14:05:26 4659 8192000000 10679484560 11061710848 1749069904 17.594 100 83 167 1 1785695024 12754176 23870944
14:05:39 5614 8192000000 10697204160 11077242880 1765374912 17.729 100 84 167 0 1799599616 12185024 22039680
14:05:51 4771 8192000000 10715223680 11095834624 1773709456 17.798 100 84 166 2 1810529104 13519712 23299936
14:06:04 3396 8192000000 10729182032 11106201600 1783596928 17.879 100 80 160 1 1818205616 12651584 21957104
14:06:14 4592 8192000000 10730642448 11110948864 1792991728 17.956 100 87 171 1 1831192832 13721920 24479184
14:06:26 9595 8192000000 10736872080 11127115776 1800775728 18.020 100 79 158 0 1836895920 14168576 21951616
14:06:42 5209 8192000000 10748613088 11136184320 1811885760 18.111 100 77 154 0 1846671664 13746608 21039296
14:06:53 3054 8192000000 10770528752 11159695360 1824541360 18.215 100 84 169 1 1863518688 14241696 24735632
14:07:03 3779 8192000000 10775540080 11162443776 1836498832 18.312 100 88 175 1 1874893776 13782784 24612160
14:07:14 1509 8192000000 10789002720 11173859328 1843699872 18.371 100 89 176 1 1882811952 14534112 24577968
14:07:22 1686 8192000000 10790559920 11176763392 1844870624 18.380 100 94 187 2 1885695120 13832976 26991520
14:07:30 2807 8192000000 10786311296 11182829568 1851800112 18.437 100 87 174 0 1890298528 13864144 24634272
14:07:39 2169 8192000000 10796033952 11182768128 1856423040 18.474 100 92 184 3 1896929152 14753760 25752352
14:07:48 1353 8192000000 10805785056 11193262080 1857292272 18.481 100 91 181 3 1897776208 15013664 25470272
14:07:56 2197 8192000000 10797605888 11185512448 1858841664 18.494 100 91 182 2 1899161104 14417248 25902192
14:08:05 1929 8192000000 10810132800 11197902848 1864388256 18.539 100 94 187 1 1905557808 13621440 27548112
14:08:13 2319 8192000000 10808730560 11201236992 1869238960 18.578 100 91 182 0 1908207360 12816768 26151632
14:08:22 2155 8192000000 10824917808 11211837440 1871542432 18.597 100 92 184 2 1911284512 13071056 26671024
14:08:30 1684 8192000000 10818899056 11211014144 1873837632 18.615 100 90 181 0 1912446000 12410576 26197792
14:08:38 1953 8192000000 10813066208 11203735552 1876526240 18.637 100 89 178 0 1913699024 11812480 25360304
14:08:46 2428 8192000000 10821170800 11212034048 1874162560 18.618 100 82 164 0 1910021952 12964992 22894400
14:08:56 9244 8192000000 10820878896 11212353536 1879231168 18.659 100 85 171 1 1916060480 13059776 23769536
14:09:11 1526 8192000000 10823807664 11216687104 1882145088 18.682 100 87 175 2 1918648592 12899312 23604192
14:09:19 1674 8192000000 10828888592 11218616320 1883392048 18.692 100 91 182 1 1923005984 13902416 25711520
14:09:27 1317 8192000000 10821733024 11222216704 1881824016 18.680 100 81 160 0 1919023712 15358768 21840928
14:09:35 2613 8192000000 10806946512 11219095552 1880938960 18.673 100 71 139 1 1914407808 13540896 19927952
14:09:45 4750 8192000000 10796869952 11213922304 1878576352 18.654 100 44 86 2 1900028352 9605440 11846560
14:09:57 3643 8192000000 10810618896 11223891968 1883037280 18.690 100 41 82 0 1905856848 12023200 10796368
14:10:10 5152 8192000000 10804131968 11223810048 1883151232 18.691 100 36 72 1 1905669824 12793456 9725136
14:10:22 4119 8192000000 10809638992 11227709440 1886700048 18.719 100 40 80 1 1910265760 10978496 12587216
14:10:33 9101 8192000000 10799254288 11226144768 1890126032 18.747 100 39 78 0 1908506752 6965296 11415424
14:10:50 5590 8192000000 10794800608 11224272896 1889806016 18.744 100 39 79 1 1908608416 7246960 11555440
14:11:02 68965 8192000000 10802423248 11237748736 1891437504 18.757 100 27 53 0 1904800352 5423440 7939408
14:12:17 5889 8192000000 10804594448 11235405824 1897368880 18.805 100 28 56 0 1910184144 5341584 7473680
14:12:30 4548 8192000000 10813221248 11241967616 1895623712 18.791 100 38 75 1 1913445696 7222176 10599808
14:12:42 4145 8192000000 10821479792 11241078784 1896231376 18.796 100 41 83 1 1915077408 7259632 11586400
14:12:56 5177 8192000000 10816597152 11242696704 1896620736 18.799 100 35 69 0 1914430528 7484848 10324944
14:13:08 4931 8192000000 10815595648 11243716608 1900153392 18.828 100 40 78 1 1918704336 7500192 11050752
14:13:23 5128 8192000000 10812050720 11243937792 1900256736 18.828 100 26 51 3 1914581536 6096320 8228480
14:13:37 5918 8192000000 10813179760 11248467968 1897785536 18.808 100 24 48 0 1911256352 5542928 7927888
14:13:53 9143 8192000000 10807941440 11244032000 1900228368 18.828 100 18 35 3 1911461968 5658192 5575408
14:14:09 7757 8192000000 10814161104 11254894592 1900832512 18.833 100 19 38 2 1912304272 6030432 5441328
14:14:25 9066 8192000000 10820011744 11254575104 1902402928 18.846 100 27 54 3 1920090768 10066176 7621664
14:14:42 14619 8192000000 10812839216 11246899200 1885709072 18.711 99 17 35 3 1896047120 5775920 4562128
14:15:04 13641 8192000000 10821428064 11253448704 1898293232 18.813 100 22 44 0 1914374384 9984944 6096208
14:15:24 56490 8192000000 10821430016 11253092352 1905914784 18.874 100 27 52 2 1918806864 5430416 7461664
14:16:30 22590 8192000000 10823692448 11252465664 1887251920 18.724 99 23 46 1 1903342896 9801728 6289248
14:17:00 8194 8192000000 10796970448 11236634624 1885292288 18.708 99 31 62 1 1899877536 5067792 9517456
14:17:15 5754 8192000000 10819161792 11244937216 1884587280 18.702 99 32 66 0 1900397808 6806816 9003712
14:17:28 4901 8192000000 10802569824 11233787904 1891670384 18.759 100 33 67 1 1907231856 6383792 9177680
14:17:42 3764 8192000000 10806818672 11237748736 1891122912 18.755 100 32 65 1 1907549280 6714640 9711728
14:17:53 5481 8192000000 10816588896 11250614272 1900698224 18.832 100 35 69 2 1918392000 7302672 10391104
14:18:04 3755 8192000000 10802075040 11223965696 1866933056 18.559 98 35 69 1 1882395232 5535808 9926368
14:18:15 3783 8192000000 10784368608 11206782976 1828504064 18.247 97 30 60 0 1842501680 5182976 8814640
14:18:26 5837 8192000000 10758003232 11178135552 1807653616 18.077 97 29 58 1 1822281328 5541888 9085824
14:18:38 7940 8192000000 10726764928 11153543168 1790810048 17.938 98 20 40 0 1801979456 5381264 5788144
14:18:56 7631 8192000000 10733731136 11153997824 1790780880 17.938 98 16 30 0 1801182848 5478816 4923152
14:19:10 7060 8192000000 10710422496 11118256128 1722358304 17.372 95 24 47 0 1738709648 9552800 6798544
14:19:24 8852 8192000000 10730931808 11151626240 1807240688 18.073 100 22 44 1 1819226128 5407072 6578368
14:19:41 8912 8192000000 10708059344 11118125056 1686247360 17.070 93 27 54 0 1699115664 5195296 7673008
14:19:56 5696 8192000000 10693321232 11110875136 1777845168 17.832 100 18 36 1 1788305072 5403536 5056368
14:20:08 69630 8192000000 10673679856 11095437312 1632144400 16.613 91 30 60 0 1645916064 4443520 9328144
14:21:24 10410 8192000000 10707339264 11115491328 1713008944 17.294 95 43 86 1 1732247296 6546416 12691936
14:21:40 6180 8192000000 10703761472 11120078848 1790872992 17.939 100 20 40 1 1802332656 5637184 5822480
14:22:00 3346 8192000000 10705610736 11123908608 1791161008 17.941 100 36 72 3 1808735568 6947200 10627360
14:22:11 7062 8192000000 10727604032 11144564736 1808229728 18.081 100 35 70 5 1827013280 8457360 10326192
14:22:26 9703 8192000000 10734472752 11155070976 1801498096 18.026 99 30 60 1 1816159424 5812240 8849088
14:22:45 8094 8192000000 10746583536 11175481344 1833045520 18.284 100 25 50 0 1846389232 6078096 7265616
14:22:59 5897 8192000000 10750843008 11169841152 1807884144 18.079 98 45 90 0 1832042560 11624544 12533872
14:23:12 4162 8192000000 10763853856 11182256128 1844332352 18.376 100 38 76 1 1863135136 7782816 11019968
14:23:23 9902 8192000000 10753703104 11172167680 1809958064 18.096 98 30 57 3 1828840128 9842352 9039712
14:23:39 8108 8192000000 10776456400 11194474496 1847396160 18.401 100 31 62 1 1862627184 5077440 10153584
14:23:55 10611 8192000000 10778732896 11186335744 1842314240 18.360 99 39 79 1 1859827872 5579776 11933856
14:24:14 13589 8192000000 10774943504 11204014080 1856874368 18.478 100 16 32 0 1871276432 10064592 4337472
14:24:35 8081 8192000000 10777841552 11205435392 1864603024 18.541 100 16 32 3 1875060512 5728928 4728560
14:24:51 50661 8192000000 10803909728 11221065728 1873646640 18.614 100 48 93 3 1892608832 5684496 13277696
14:25:50 14713 8192000000 10779370896 11216273408 1876711440 18.639 100 29 58 1 1890791184 5753088 8326656
14:26:13 10900 8192000000 10795389840 11221737472 1877909456 18.648 100 27 54 3 1891611248 5369776 8332016
14:26:30 6633 8192000000 10788861344 11224870912 1882623504 18.686 100 34 68 2 1898559296 6035376 9900416
14:26:46 7515 8192000000 10799120768 11228291072 1882690416 18.687 100 19 37 0 1893564880 5522208 5352256
14:26:59 7424 8192000000 10805111600 11239071744 1895664208 18.791 100 21 41 1 1906645264 5145600 5835456
14:27:19 9675 8192000000 10826373104 11254149120 1908184336 18.892 100 20 40 2 1918514384 4908528 5421520
14:27:38 11707 8192000000 10833191952 11257409536 1910797504 18.913 100 25 50 0 1922992768 4982880 7212384
14:28:02 23935 8192000000 10851243072 11276750848 1926497152 19.039 100 57 114 0 1949862688 6445328 16920208
14:28:57 28677 8192000000 10870992272 11290083328 1935028976 19.107 100 49 96 1 1959212160 10379616 13803568
14:29:35 17920 8192000000 10879937472 11299262464 1941278304 19.157 100 45 90 1 1966179456 10789136 14112016
14:30:01 9397 8192000000 10882060784 11308306432 1948561296 19.215 100 59 120 2 1977282064 11844192 16876576
14:30:20 21482 8192000000 10886204128 11315286016 1950467408 19.230 100 52 104 1 1977515440 12839328 14208704
14:30:51 29980 8192000000 10891423728 11323260928 1959505952 19.302 100 46 90 0 1985393808 11947568 13940288
14:31:36 56149 8192000000 10870907840 11315875840 1943463104 19.174 99 29 58 1 1965326432 13005936 8857392
14:32:42 25967 8192000000 10889358560 11331035136 1941575200 19.159 99 34 68 0 1967365776 15197856 10592720
14:33:38 10834 8192000000 10887650784 11328208896 1952541008 19.247 100 38 75 3 1983329008 18758768 12029232
14:34:04 21235 8192000000 10902371184 11340115968 1962305296 19.324 100 34 68 2 1984963584 12348128 10310160
14:34:34 31754 8192000000 10896975456 11341021184 1953914160 19.258 99 35 69 2 1976892320 12609536 10368624
14:35:25 16075 8192000000 10928164528 11363790848 1981757936 19.479 100 47 94 1 2012800448 17155040 13887472
14:35:50 12314 8192000000 10943799824 11375738880 1989340896 19.539 100 57 112 4 2027028400 20674160 17013344
14:36:09 7987 8192000000 10947218384 11376689152 1999053744 19.615 100 58 116 0 2038522288 21952000 17516544
14:36:35 5634 8192000000 10965465168 11395575808 2009539776 19.698 100 62 124 0 2053568672 25275632 18753264
14:36:51 10421 8192000000 10966999296 11401789440 2013673920 19.730 100 57 114 2 2056806368 25219632 17912816
14:37:08 11334 8192000000 10969284320 11405602816 2015324400 19.743 100 52 103 1 2056708144 24812176 16571568
14:37:29 9666 8192000000 10969906960 11408777216 2019533728 19.776 100 51 102 2 2062828576 26066624 17228224
14:37:52 3970 8192000000 10982586400 11409633280 2005648784 19.667 99 61 121 2 2049885248 25312496 18923968
14:38:04 4237 8192000000 10966895072 11404087296 1981363152 19.475 98 53 105 1 2024493136 26824576 16305408
14:38:16 3194 8192000000 10988175920 11409158144 2019479664 19.776 100 74 146 1 2070644768 28989328 22175776
14:38:27 4392 8192000000 10998252720 11420418048 2026348640 19.830 100 86 171 1 2084839920 32226256 26265024
14:38:46 3754 8192000000 10985232624 11414564864 2026805792 19.834 100 73 142 0 2079483008 31100192 21577024
14:38:57 4264 8192000000 10982880736 11408977920 2020577552 19.785 100 71 143 3 2072368848 29815584 21975712
14:39:13 9317 8192000000 10978018560 11416469504 2021623536 19.793 100 47 94 1 2064057856 27624480 14809840
14:39:31 6941 8192000000 10980795104 11411787776 2006833264 19.677 99 54 107 2 2051917248 28231440 16852544
14:39:49 5973 8192000000 10987927792 11425263616 2033515520 19.886 100 67 134 0 2083919456 29502080 20901856
14:40:08 3526 8192000000 10988330128 11413000192 2018274288 19.767 100 70 137 1 2070051568 30434736 21342544
14:40:18 5775 8192000000 10987291344 11416813568 2018961632 19.772 100 63 126 1 2070418208 31495760 19960816
14:40:32 3975 8192000000 10984170304 11412938752 2015398144 19.744 100 69 138 0 2071051360 33141296 22511920
14:40:48 7256 8192000000 10974874384 11403411456 1977042368 19.441 98 69 136 0 2035548416 37141808 21364240
14:41:03 7974 8192000000 10972611712 11400470528 1999655104 19.620 100 59 116 2 2056948528 38264096 19029328
14:41:20 7208 8192000000 10974669392 11409711104 2005751376 19.668 100 61 122 2 2066442112 40369824 20320912
14:41:36 7404 8192000000 10970297440 11398873088 1997511184 19.603 100 58 116 3 2057491184 40505360 19474640
14:41:51 1159 8192000000 10952125600 11363356672 1971467584 19.397 99 76 156 3 2034444944 37912496 25064864
14:41:59 3587 8192000000 10940641376 11357126656 1942623536 19.168 98 75 150 0 2005010624 38854208 23532880
14:42:11 3427 8192000000 10952565776 11368304640 1971356336 19.396 100 74 148 1 2033179168 38931680 22891152
14:42:21 4355 8192000000 10968778240 11385778176 1984154800 19.498 100 82 160 1 2048272416 39336560 24781056
14:42:39 2119 8192000000 10979438272 11392073728 1990087168 19.544 100 82 164 0 2056369360 40892688 25389504
14:42:50 5069 8192000000 10969516224 11389378560 1974418544 19.420 99 72 144 2 2037491872 40535744 22537584
14:43:03 2310 8192000000 10979778272 11395731456 1993829328 19.574 100 80 160 0 2061155200 42374912 24950960
14:43:12 1221 8192000000 10984145600 11398987776 2001876656 19.638 100 86 168 1 2068117696 39870032 26371008
14:43:22 5739 8192000000 10988627408 11404926976 1999166240 19.616 100 77 154 0 2067016096 43480416 24369440
14:43:41 4484 8192000000 10984046080 11405135872 1996712416 19.597 100 59 116 0 2061019328 45285488 19021424
14:43:53 4329 8192000000 10988540288 11412103168 1995403376 19.586 100 64 128 1 2063126624 46764624 20958624
14:44:06 3966 8192000000 10982316080 11407671296 1981839648 19.479 99 64 125 0 2050445744 47445088 21161008
14:44:17 5548 8192000000 10990802080 11410739200 1998133328 19.608 100 84 164 2 2069936416 46939200 24863888
14:44:29 1525 8192000000 10994335744 11406020608 1995288176 19.586 100 86 171 1 2069567072 47593776 26685120
14:44:38 1785 8192000000 11006563680 11421970432 2009205200 19.695 100 92 185 2 2087809552 50325088 28279264
14:44:46 1651 8192000000 11006063520 11417198592 2004435760 19.658 100 93 187 1 2082269600 48271872 29561968
14:44:54 2083 8192000000 10991119856 11413041152 1988964176 19.536 99 81 160 0 2062064848 48241616 24859056
14:45:03 5466 8192000000 10970011040 11393429504 1982656544 19.486 100 64 128 1 2046096288 43566576 19873168
14:45:18 14413 8192000000 10949503312 11394183168 1969603168 19.382 99 54 109 1 2036869952 49945424 17321360
14:45:46 17604 8192000000 10959750976 11404259328 1988051664 19.528 100 45 90 1 2050104176 46528848 15523664
14:46:11 9581 8192000000 10943113728 11379798016 1970141840 19.387 100 49 98 4 2029219488 43080016 15997632
14:46:27 4309 8192000000 10951593344 11385171968 1972705840 19.407 100 47 94 1 2031086880 43519968 14861072
14:46:43 5315 8192000000 10940140240 11370774528 1956130848 19.275 99 49 98 2 2020678384 48817440 15730096
14:46:58 10652 8192000000 10941371120 11379511296 1949034320 19.219 99 37 72 0 2011353344 50280976 12038048
14:47:32 10757 8192000000 10958017696 11397193728 1977486816 19.445 100 42 84 0 2043680128 51867520 14325792
14:48:04 14968 8192000000 10944357504 11382689792 1928898848 19.058 98 42 85 1 2001436976 57357808 15180320
14:48:27 14340 8192000000 10955482704 11387629568 1944039728 19.179 99 42 84 1 2021972592 62950000 14982864
14:48:49 11264 8192000000 10936463872 11379761152 1951138320 19.236 100 39 77 1 2019929984 55457200 13334464
14:49:06 27855 8192000000 10960967680 11385225216 1939633632 19.144 99 47 92 1 2009272608 53824480 15814496
14:49:41 1763 8192000000 10962616720 11389972480 1969022000 19.378 100 65 124 1 2044693488 55642496 20028992
14:49:58 14413 8192000000 10948848160 11395526656 1973599904 19.414 100 36 72 0 2040382064 54457984 12324176
14:50:26 16349 8192000000 10959670560 11413970944 1974006752 19.417 100 38 75 4 2038897184 51485696 13404736
14:50:55 28186 8192000000 10900644800 11362848768 1899841584 18.825 97 18 36 1 1949050896 42592848 6616464
14:51:32 21652 8192000000 10903463344 11363258368 1920600560 18.992 99 17 34 0 1970359008 43785424 5973024
14:52:01 22960 8192000000 10899648656 11362881536 1936420832 19.118 100 15 30 1 1979659008 38090256 5147920
14:52:31 19590 8192000000 10888436528 11347730432 1910462672 18.910 99 16 32 0 1962641536 46629424 5549440
14:53:14 19190 8192000000 10892290896 11352858624 1913005872 18.931 99 22 44 0 1968465456 47826672 7632912
14:53:42 17816 8192000000 10898257152 11367444480 1931307680 19.077 100 15 30 0 1980184240 43530880 5345680
14:54:06 10661 8192000000 10900905168 11376648192 1933514976 19.095 100 10 20 1 1981613744 44670512 3428256
14:54:24 26169 8192000000 10883286480 11363995648 1917898352 18.970 99 5 9 0 1950860432 31579280 1382800
14:55:04 27603 8192000000 10889046752 11367206912 1920654208 18.992 99 9 18 0 1955508800 31909456 2945136
14:55:56 47114 8192000000 10875351584 11340619776 1921532176 18.999 99 11 22 1 1936863216 11606816 3724224
14:56:50 53744 8192000000 10885963856 11330535424 1906624896 18.880 98 15 30 0 1918407888 8219552 3563440
14:57:59 124402 8192000000 10892380080 11362934784 1948380912 19.214 99 27 52 1 1965424384 10116976 6926496
15:00:48 100785 8192000000 10885409840 11353321472 1884486192 18.701 96 27 54 0 1905805296 13983088 7336016
15:02:51 47293 8192000000 10887791488 11358609408 1962626064 19.327 100 11 22 1 1978994976 13370848 2998064
15:03:46 66832 8192000000 10912653472 11356385280 1929766864 19.065 98 33 66 1 1948633456 9586736 9279856
15:05:06 31166 8192000000 10901291808 11350355968 1939108576 19.140 98 36 73 2 1958112128 9157216 9846336
15:05:51 22487 8192000000 10899369040 11351920640 1966478928 19.358 100 45 89 2 1988036720 8155152 13402640
15:06:20 32054 8192000000 10900046608 11370491904 1977062304 19.441 100 23 46 1 1994847584 10715168 7070112
15:07:11 28635 8192000000 10906634480 11383644160 1982160960 19.482 100 13 26 0 1995578528 9303104 4114464
15:07:46 52963 8192000000 10897788528 11377328128 1963710608 19.336 99 13 26 0 1975220928 8320272 3190048
15:08:46 13792 8192000000 10905344432 11382706176 1980008448 19.465 100 8 16 1 1996534048 14204496 2321104
15:09:53 17520 8192000000 10927855568 11390337024 1992827504 19.566 100 35 69 1 2016211328 13487824 9896000
15:10:21 44956 8192000000 10909561424 11379404800 1951913536 19.242 98 20 40 1 1972576880 14738416 5924928
15:11:12 77446 8192000000 10904983360 11378446336 1956820992 19.281 99 18 36 2 1975985632 13606064 5558576
15:12:39 47150 8192000000 10894336816 11366694912 1953864400 19.257 99 24 48 1 1981158288 20257168 7036720
15:13:39 76180 8192000000 10911007920 11397857280 1966973664 19.361 99 15 30 2 1986767792 14996096 4798032
15:15:18 44039 8192000000 10917205232 11390259200 1970022576 19.386 99 27 55 1 1993305664 15420096 7862992
15:16:08 46818 8192000000 10913126416 11381358592 1956833360 19.281 98 10 20 0 1970474256 10629904 3010992
15:17:03 63728 8192000000 10913714912 11401605120 1979999424 19.465 99 29 58 0 2003172800 14577184 8596192
15:18:14 35548 8192000000 10898656032 11367821312 1950613168 19.231 98 12 22 0 1964698400 11014912 3070320
15:18:59 44682 8192000000 10909248976 11388186624 1962718656 19.328 99 13 25 1 1974704400 8636992 3348752
15:19:54 14962 8192000000 10936199984 11381432320 1959115152 19.299 98 38 75 1 1979106688 9129776 10861760
15:20:26 14896 8192000000 10917468320 11379294208 1967939376 19.369 99 28 56 0 1987011888 11340160 7732352
15:20:50 38376 8192000000 10912644304 11379654656 1946409792 19.198 98 23 46 1 1965351328 12641376 6300160
15:21:43 45162 8192000000 10928518112 11398209536 1969170768 19.379 99 27 54 0 1992861744 16028528 7662448
15:22:42 50231 8192000000 10930338816 11397222400 1977365328 19.444 99 17 34 1 1993111344 11193168 4552848
15:23:39 78229 8192000000 10909095936 11383918592 1911961728 18.922 96 17 34 1 1935644384 18697216 4985440
15:25:10 76448 8192000000 10910440400 11376631808 1861785600 18.518 94 10 20 1 1885296352 20759424 2751328
15:26:35 124214 8192000000 10877701168 11339935744 1847525392 18.402 94 26 51 2 1868601664 13466368 7609904
15:28:50 30732 8192000000 10870968704 11332493312 1923242688 19.013 99 29 56 1 1944971840 14070464 7658688
15:29:27 42275 8192000000 10844793600 11320410112 1909314240 18.901 98 38 76 1 1929560432 9632496 10613696
15:30:20 82794 8192000000 10865511392 11344470016 1909796080 18.905 98 15 30 0 1925732400 11877904 4058416
15:33:08 39633 8192000000 10884618048 11371413504 1943169440 19.172 100 9 18 0 1962221184 16690960 2360784
15:35:23 56143 8192000000 10901310816 11360792576 1932807792 19.089 98 36 72 1 1964062432 20941088 10313552
15:36:28 41092 8192000000 10914548560 11381248000 1967020752 19.362 100 28 56 0 1990743264 15582864 8139648
15:37:17 84169 8192000000 10911527504 11401089024 1915097888 18.948 97 11 22 1 1941772816 23098000 3576928
15:38:47 78391 8192000000 10887503760 11371589632 1911725648 18.920 97 11 22 0 1944422912 29538928 3158336
15:40:21 34995 8192000000 10889105856 11357470720 1909865760 18.906 98 26 52 0 1928793968 12076768 6851440
15:41:11 75291 8192000000 10877332368 11342299136 1908424704 18.894 98 31 63 1 1933229424 15839664 8965056
15:42:37 9035 8192000000 10887536864 11330404352 1908230528 18.892 98 51 102 3 1931960592 9507424 14222640
15:42:56 22458 8192000000 10901371584 11353399296 1946125536 19.196 100 44 89 0 1969488208 11079840 12282832
15:43:24 21304 8192000000 10884930736 11343364096 1893672240 18.775 97 39 78 0 1916964672 12382576 10909856
15:43:54 41102 8192000000 10857410224 11324706816 1878607280 18.654 97 28 57 0 1898731200 12460496 7663424
15:44:56 38551 8192000000 10899737216 11340730368 1923961088 19.019 99 34 68 0 1947776128 14390048 9424992
15:45:45 69993 8192000000 10890917952 11340632064 1929452816 19.063 99 44 88 0 1954174704 12281136 12440752
15:47:05 89288 8192000000 10840226384 11313500160 1890210864 18.747 97 29 58 2 1907351488 8913952 8226672
15:48:41 35023 8192000000 10852710880 11338399744 1937447600 19.126 100 5 10 0 1950039136 11615312 976224
15:49:25 67811 8192000000 10858162352 11334328320 1922924752 19.010 99 10 20 1 1935004400 9373520 2706128
15:50:39 57238 8192000000 10869398832 11355361280 1952081424 19.243 100 9 18 0 1965412864 10431664 2899776
15:51:42 98796 8192000000 10882855392 11371483136 1942753232 19.169 99 17 36 0 1960289376 11825888 5710256
15:53:50 54930 8192000000 10868973696 11357589504 1948875760 19.218 100 19 38 1 1968219712 13755072 5588880
15:54:57 38236 8192000000 10879033120 11349966848 1932902080 19.090 99 20 40 0 1947150832 8354432 5894320
15:55:43 50479 8192000000 10872252992 11364933632 1959873920 19.305 100 21 42 3 1977182448 11252704 6055824
15:56:42 38587 8192000000 10900996080 11370201088 1955339264 19.269 99 24 48 0 1974579552 12618320 6621968
15:57:30 88489 8192000000 10883823408 11368402944 1932666240 19.088 98 13 26 2 1947495344 11326544 3502560
15:59:05 143300 8192000000 10922860560 11414802432 1968091216 19.370 99 10 20 0 1984874832 14184912 2598704
16:01:35 111182 8192000000 10902240176 11384512512 1899098528 18.819 95 14 26 1 1912687776 10181424 3407824
16:03:32 8930 8192000000 10903031504 11357261824 1941307440 19.157 98 37 74 0 1958485376 6260672 10917264
16:03:50 28774 8192000000 10922817392 11380617216 1953099472 19.251 99 52 103 1 1978355808 10637200 14619136
16:04:27 43959 8192000000 10939789120 11389943808 1966723376 19.359 99 35 70 0 1986908256 10405072 9779808
16:05:23 36246 8192000000 10928516736 11398119424 1977958752 19.449 99 41 83 0 2002131936 13029408 11143776
16:06:09 46035 8192000000 10921432912 11387756544 1954466048 19.262 98 18 35 3 1968162176 9326224 4369904
16:07:02 93142 8192000000 10913368224 11383709696 1976958272 19.441 99 47 95 0 1999458560 9654048 12846240
16:08:42 51593 8192000000 10903224208 11381325824 1957364848 19.285 98 24 48 3 1971066896 6680144 7021904
16:09:42 48080 8192000000 10901017120 11396042752 1990338912 19.546 100 9 18 0 2000668000 7736832 2592256
16:10:41 41604 8192000000 10910541680 11400347648 1994893936 19.582 100 6 12 0 2004643648 8113696 1636016
16:12:04 89283 8192000000 10913628576 11402063872 1965543136 19.350 98 12 24 0 1977414304 8440928 3430240
16:13:44 67552 8192000000 10918631584 11401375744 1939559664 19.143 97 13 26 1 1951279968 8030128 3690176
16:15:05 46494 8192000000 10886507232 11361644544 1903972512 18.858 96 15 30 0 1914440448 6739728 3728208
16:15:58 37084 8192000000 10885137920 11349917696 1932971648 19.091 98 18 36 0 1943944192 5881360 5091184
16:16:42 21430 8192000000 10893693104 11362115584 1950870976 19.233 99 23 45 0 1965451600 7653824 6926800
16:17:12 39196 8192000000 10874524704 11340189696 1882261536 18.683 96 15 30 1 1893497280 7067920 4167824
16:18:01 33061 8192000000 10890365264 11340570624 1891548352 18.758 97 28 56 0 1908342192 8536576 8257264
16:18:43 14924 8192000000 10899688432 11350323200 1941069888 19.155 99 39 76 0 1959954864 8464400 10420576
16:19:08 24261 8192000000 10857083552 11319824384 1905227408 18.868 98 39 78 0 1928416496 12260128 10928960
16:19:38 63733 8192000000 10841639008 11306729472 1788306080 17.918 92 15 30 0 1804943360 12744400 3892880
16:20:49 124160 8192000000 10841130864 11319087104 1808347296 18.082 94 13 26 0 1824564528 12091920 4125312
16:22:59 54671 8192000000 10862124304 11324207104 1839762704 18.339 95 28 56 1 1861448288 13570448 8115136
16:24:08 78907 8192000000 10856189904 11327221760 1885458944 18.709 98 7 14 0 1900259312 12895120 1905248
16:25:34 134366 8192000000 10633829840 11084627968 1688807504 17.091 87 19 38 0 1711069328 16687536 5574288

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-06-2021 16:30:12 to 21-06-2021 16:30:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 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 21-06-2021 16:30:44 to 21-06-2021 16:30:46.

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          242201
MON$OLDEST_ACTIVE               242987
MON$OLDEST_SNAPSHOT             242987
MON$NEXT_TRANSACTION            242987
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                       2029152
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:146: 
:147: mscs-test-161.budzdorov.ru    Mon Jun 21 16:27:51 2021
:148:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:149: 
:150: 
:151: mscs-test-161.budzdorov.ru    Mon Jun 21 16:28:01 2021
:152:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:153: 
--- end of diff output ---

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

21.06.21 16:30:47. 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-06-21 16:30:50 No severe PSQL-related problems occured
21.06.21 16:30:51. End of report.