Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.03.2021 16:27
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 17672372 kB
MemAvailable 31582924 kB
Buffers 0 kB
Cached 13980532 kB
SwapCached 0 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-03-08 16:27:21
DTS_END                         2021-03-08 16:27:21.2100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36604
TRN_ID                          240693
ATT_ID                          682
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: 9249.12 23743 1109894
customer order: creation 173.75 337 20850
customer order: refuse 14.73 314 1768
order to supplier: creation 45.93 1216 5511
order to supplier: removal 3.67 95119 440
invoice (draft): creation 46.19 2980 5543
invoice (draft): removal 52.55 811 6306
invoice accept: apply 42.08 17893 5049
invoice accept: cancel 47.15 666 5658
customer reserve: creation 3896.13 178 467535
customer reserve: removal 4633.63 58 556036
realization accept: apply 84.29 160 10115
realization accept: cancel 77.13 105 9256
payment from customer: creation 60.68 118 7281
payment from customer: removal 5.51 61 661
payment to supplier: creation 49.61 115 5953
payment to supplier: removal 3.61 66 433
service: total inventory turnovers 4.96 1066 595
service: total monetary turnovers 6.70 30 804
service: aggregate perf. data 0.80 21053 96
service: refresh index statistics 0.03 332514 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2021 16:28:10 to 08-03-2021 16:28:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3502
TEST_TIME 2 3511
TEST_TIME 3 4472
TEST_TIME 4 4421
TEST_TIME 5 4720
TEST_TIME 6 5274
TEST_TIME 7 5521
TEST_TIME 8 5846
TEST_TIME 9 5617
TEST_TIME 10 6193
TEST_TIME 11 6281
TEST_TIME 12 6308
TEST_TIME 13 6608
TEST_TIME 14 6628
TEST_TIME 15 6771
TEST_TIME 16 7222
TEST_TIME 17 7430
TEST_TIME 18 7833
TEST_TIME 19 7794
TEST_TIME 20 7825
TEST_TIME 21 7759
TEST_TIME 22 8697
TEST_TIME 23 9401
TEST_TIME 24 10634
TEST_TIME 25 10789
TEST_TIME 26 10727
TEST_TIME 27 10552
TEST_TIME 28 10435
TEST_TIME 29 10373
TEST_TIME 30 10255
TEST_TIME 31 10281
TEST_TIME 32 10330
TEST_TIME 33 10146
TEST_TIME 34 10021
TEST_TIME 35 9913
TEST_TIME 36 9830
TEST_TIME 37 9851
TEST_TIME 38 9754
TEST_TIME 39 9849
TEST_TIME 40 9642
TEST_TIME 41 9776
TEST_TIME 42 9637
TEST_TIME 43 9592
TEST_TIME 44 9509
TEST_TIME 45 9427
TEST_TIME 46 9347
TEST_TIME 47 9382
TEST_TIME 48 9424
TEST_TIME 49 9353
TEST_TIME 50 9449
TEST_TIME 51 9432
TEST_TIME 52 9445
TEST_TIME 53 9543
TEST_TIME 54 9605
TEST_TIME 55 9573
TEST_TIME 56 9578
TEST_TIME 57 9594
TEST_TIME 58 9743
TEST_TIME 59 9744
TEST_TIME 60 9711
TEST_TIME 61 9608
TEST_TIME 62 9546
TEST_TIME 63 9491
TEST_TIME 64 9428
TEST_TIME 65 9345
TEST_TIME 66 9392
TEST_TIME 67 9437
TEST_TIME 68 9396
TEST_TIME 69 9353
TEST_TIME 70 9392
TEST_TIME 71 9387
TEST_TIME 72 9454
TEST_TIME 73 9432
TEST_TIME 74 9414
TEST_TIME 75 9443
TEST_TIME 76 9437
TEST_TIME 77 9460
TEST_TIME 78 9538
TEST_TIME 79 9608
TEST_TIME 80 9645
TEST_TIME 81 9586
TEST_TIME 82 9482
TEST_TIME 83 9431
TEST_TIME 84 9455
TEST_TIME 85 9384
TEST_TIME 86 9354
TEST_TIME 87 9333
TEST_TIME 88 9307
TEST_TIME 89 9305
TEST_TIME 90 9307
TEST_TIME 91 9278
TEST_TIME 92 9420
TEST_TIME 93 9429
TEST_TIME 94 9480
TEST_TIME 95 9472
TEST_TIME 96 9477
TEST_TIME 97 9491
TEST_TIME 98 9469
TEST_TIME 99 9478
TEST_TIME 100 9556
TEST_TIME 101 9545
TEST_TIME 102 9456
TEST_TIME 103 9421
TEST_TIME 104 9409
TEST_TIME 105 9386
TEST_TIME 106 9352
TEST_TIME 107 9309
TEST_TIME 108 9330
TEST_TIME 109 9269
TEST_TIME 110 9254
TEST_TIME 111 9241
TEST_TIME 112 9281
TEST_TIME 113 9257
TEST_TIME 114 9255
TEST_TIME 115 9248
TEST_TIME 116 9231
TEST_TIME 117 9263
TEST_TIME 118 9324
TEST_TIME 119 9308
TEST_TIME 120 9253

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-03-2021 16:28:13 to 08-03-2021 16:28:17.

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 1543035 1543035 0 0.00 0 33264 7 0 0
doc_list_biud 1543034 1543034 0 0.00 0 20864 27 0 0
sp_add_invoice_to_stock 5135 5049 86 1.67 18 172580 17893 0 86
sp_cancel_adding_invoice 5658 5658 0 0.00 3 40742 666 0 0
sp_cancel_client_order 1768 1768 0 0.00 4 16911 314 0 0
sp_cancel_customer_reserve 556036 556036 0 0.00 1 20866 59 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 3 2767 62 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 3 2657 66 0 0
sp_cancel_supplier_invoice 6314 6306 8 0.12 1 17156 812 0 8
sp_cancel_supplier_order 440 440 0 0.00 8 903734 95119 0 0
sp_cancel_write_off 9256 9256 0 0.00 1 9484 106 0 0
sp_client_order 20850 20850 0 0.00 3 13976 337 0 0
sp_customer_reserve 467535 467535 0 0.00 0 64050 178 0 0
sp_fill_shopping_cart 31895 31895 0 0.00 1 16967 35 0 0
sp_fill_shopping_cart_clo_res 467535 467535 0 0.00 0 13775 14 0 0
sp_get_clo_for_invoice 5045 5045 0 0.00 0 22970 290 0 0
sp_kill_cost_storno 16008 16008 0 0.00 0 7390 52 0 0
sp_kill_qstorno_ret_qs2qd 1128074 1128074 0 0.00 0 20862 32 0 0
sp_kill_qty_storno 594623 594623 0 0.00 0 20864 69 0 0
sp_lock_selected_doc 20899 20899 0 0.00 0 7609 4 0 0
sp_make_cost_storno 28394 28394 0 0.00 0 33041 50 0 0
sp_multiply_rows_for_pdistr 28394 28394 0 0.00 0 10052 29 0 0
sp_multiply_rows_for_qdistr 20850 20850 0 0.00 0 10090 167 0 0
sp_pay_from_customer 7281 7281 0 0.00 4 13780 119 0 0
sp_pay_to_supplier 5953 5953 0 0.00 5 33275 115 0 0
sp_payment_common 13234 13234 0 0.00 1 8095 31 0 0
sp_qd_handle_on_cancel_clo 1768 1768 0 0.00 0 16905 290 0 0
sp_qd_handle_on_invoice_upd_sts 10703 10703 0 0.00 0 19180 293 0 0
sp_qd_handle_on_reserve_upd_sts 10114 10114 0 0.00 0 10203 50 0 0
sp_reserve_write_off 10115 10115 0 0.00 6 13612 160 0 0
sp_supplier_invoice 5543 5543 0 0.00 5 77374 2981 0 0
sp_supplier_order 5511 5511 0 0.00 5 27010 1217 0 0
srv_aggregate_perf_data 96 96 0 0.00 2389 155376 21053 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1362 144107 34155 0 0
srv_find_qd_qs_mism 1061667 1061667 0 0.00 0 14032 6 0 0
srv_make_invnt_saldo 595 595 0 0.00 40 67058 1067 0 0
srv_make_money_saldo 804 804 0 0.00 1 6310 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 209202 423869 332515 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5049 5049 0 0.00 0 15003 146 0 0
t$perf-norm:sp_cancel_adding_invoice 392 392 0 0.00 0 22654 144 0 0
t$perf-norm:sp_cancel_client_order 1768 1768 0 0.00 0 5101 11 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 3073 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 1642 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 567 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 2980 27 0 0
t$perf-norm:sp_cancel_supplier_order 440 440 0 0.00 0 25246 1392 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 2208 6 0 0
t$perf-norm:sp_client_order 20850 20850 0 0.00 0 11375 16 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 638 5 0 0
t$perf-norm:sp_pay_from_customer 7281 7281 0 0.00 0 5092 9 0 0
t$perf-norm:sp_pay_to_supplier 5953 5953 0 0.00 0 11498 13 0 0
t$perf-norm:sp_reserve_write_off 10115 10115 0 0.00 0 20504 15 0 0
t$perf-norm:sp_supplier_invoice 5543 5543 0 0.00 0 5377 19 0 0
t$perf-norm:sp_supplier_order 5511 5511 0 0.00 0 8256 17 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 480 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 2850 25 0 0
t$perf-norm:srv_make_invnt_saldo 595 595 0 0.00 0 2182 16 0 0
t$perf-norm:srv_make_money_saldo 804 804 0 0.00 0 4131 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 12 7 0 0
v_add_invoice_to_stock 10262 10090 172 1.67 0 3409 17 0 172
v_all_customers 37726 37726 0 0.00 0 14 1 0 0
v_all_suppliers 30940 30940 0 0.00 0 23 1 0 0
v_all_wares 41700 41700 0 0.00 0 64 1 0 0
v_cancel_adding_invoice 784 784 0 0.00 0 890 7 0 0
v_cancel_client_order 3536 3536 0 0.00 0 2963 5 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 2644 6 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 2912 9 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 487 5 0 0
v_cancel_supplier_invoice 816 800 16 1.96 0 2928 19 0 16
v_cancel_supplier_order 880 880 0 0.00 0 330 3 0 0
v_cancel_write_off 1924 1924 0 0.00 0 3215 15 0 0
v_max_id_clo_ord 5509 5509 0 0.00 0 2205 2 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 2065 14 0 0
v_max_id_ord_sup 5536 5536 0 0.00 0 1957 3 0 0
v_max_non_paid_invoice 1528 1528 0 0.00 0 1301 4 0 0
v_max_non_paid_realizn 3893 3893 0 0.00 0 3344 5 0 0
v_min_id_clo_ord 5509 5509 0 0.00 0 3565 8 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 1611 7 0 0
v_min_id_ord_sup 5536 5536 0 0.00 0 8619 7 0 0
v_min_non_paid_invoice 5953 5953 0 0.00 0 6786 17 0 0
v_min_non_paid_realizn 7281 7281 0 0.00 0 8091 23 0 0
v_our_firm 10750 10750 0 0.00 0 15 1 0 0
v_reserve_write_off 20226 20226 0 0.00 0 3416 4 0 0
x_lock_depdocs_on_canc_invoice 11564 11564 0 0.00 0 22337 112 0 0
x_lock_depdocs_on_canc_sup_ord 440 440 0 0.00 0 6709 265 0 0
x_make_qstorno_1000_1200 5511 5511 0 0.00 2 26819 1136 0 0
x_make_qstorno_1200_2000 5543 5543 0 0.00 2 77367 2860 0 0
x_make_qstorno_2100_3300 467535 467535 0 0.00 0 64046 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2021 16:28:18 to 08-03-2021 16:28:22.

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:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:31 25301 8192000000 10299403952 10610499584 1160795088 12.411 88 72 143 0 1188299072 3508752 23995232
13:58:05 26041 8192000000 10357673600 10675531776 1398945648 14.586 100 87 174 0 1432769040 5347216 28476176
13:58:47 27093 8192000000 10387317680 10712100864 1434089040 14.897 100 87 173 0 1469203024 6829872 28284112
13:59:30 25189 8192000000 10423655584 10751807488 1477344800 15.278 100 87 174 1 1513402624 8117024 27940800
14:00:10 17868 8192000000 10442429696 10773909504 1499593232 15.473 100 89 178 0 1536787616 8511024 28683360
14:00:36 29875 8192000000 10470644896 10806218752 1518495936 15.637 100 88 176 2 1555551024 9196832 27858256
14:01:19 11020 8192000000 10479249648 10816454656 1534337520 15.775 100 89 178 1 1572113088 10026880 27748688
14:01:47 14736 8192000000 10496188016 10845913088 1548695472 15.899 100 72 144 0 1580599168 9965360 21938336
14:02:12 10127 8192000000 10521783424 10876260352 1586397040 16.223 100 80 160 1 1620639456 10307360 23935056
14:02:34 12765 8192000000 10554709168 10912526336 1613188368 16.452 100 75 150 0 1646299536 10667232 22443936
14:02:55 13297 8192000000 10577766000 10934870016 1636450992 16.650 100 81 163 1 1672084528 11494720 24138816
14:03:19 13141 8192000000 10611045536 10971729920 1657824512 16.831 100 78 156 0 1693215872 12445712 22945648
14:03:40 8907 8192000000 10618342512 10985041920 1681054896 17.026 100 81 162 0 1717604672 12310144 24239632
14:04:03 9530 8192000000 10632646080 11004403712 1697707008 17.166 100 77 154 1 1732270128 12388800 22174320
14:04:27 9153 8192000000 10660604032 11031035904 1717410000 17.331 100 70 140 0 1749430944 12278432 19742512
14:04:49 8988 8192000000 10659062016 11037380608 1730739792 17.442 100 75 150 2 1764530704 12549568 21241344
14:05:05 5173 8192000000 10672384864 11046268928 1735878464 17.484 100 78 156 0 1769759728 12153984 21727280
14:05:18 4507 8192000000 10676713376 11059073024 1745267712 17.562 100 78 156 1 1780505392 13082320 22155360
14:05:30 6586 8192000000 10700544448 11079499776 1759659040 17.682 100 78 156 0 1794473792 13216160 21598592
14:05:44 3934 8192000000 10703113760 11082842112 1767738064 17.748 100 74 146 1 1801070800 13353408 19979328
14:05:57 5103 8192000000 10706802608 11092533248 1775097264 17.809 100 70 140 0 1807613312 13248096 19267952
14:06:09 5598 8192000000 10729394800 11109724160 1779525120 17.846 100 80 160 0 1814811632 13517488 21769024
14:06:22 3636 8192000000 10732057904 11115978752 1796525232 17.985 100 79 157 1 1832260416 13870640 21864544
14:06:32 3127 8192000000 10759878656 11141558272 1811219232 18.106 100 84 169 0 1848829488 14313136 23297120
14:06:42 4491 8192000000 10771152176 11153588224 1822331216 18.197 100 80 161 2 1858434768 13531088 22572464
14:06:54 2476 8192000000 10765970016 11153993728 1828873664 18.250 100 89 177 1 1866935088 13640352 24421072
14:07:04 2965 8192000000 10776018208 11162009600 1833023232 18.284 100 93 186 3 1874359552 15462784 25873536
14:07:14 2067 8192000000 10780368896 11165282304 1835700944 18.306 100 89 178 1 1876005264 14790944 25513376
14:07:22 2680 8192000000 10780844240 11167051776 1841282592 18.351 100 88 176 3 1879135312 12705264 25147456
14:07:31 1842 8192000000 10785629264 11170357248 1843442192 18.369 100 96 192 2 1884887600 13491712 27953696
14:07:40 1679 8192000000 10792420144 11176763392 1843763936 18.371 100 85 167 0 1880230416 12851216 23615264
14:07:48 2309 8192000000 10796045056 11183104000 1851582176 18.435 100 92 183 2 1891055440 13181088 26292176
14:07:56 2729 8192000000 10793210288 11180859392 1851029392 18.430 100 94 187 0 1889217680 12210432 25977856
14:08:05 2233 8192000000 10796337648 11182620672 1853251584 18.449 100 93 181 1 1892736160 13470752 26013824
14:08:13 1793 8192000000 10805063424 11192135680 1856801120 18.477 100 94 188 4 1896372448 13012496 26558832
14:08:22 2199 8192000000 10801098464 11188084736 1857053840 18.479 100 87 174 1 1892674624 11292416 24328368
14:08:32 2090 8192000000 10811388448 11194630144 1861761696 18.518 100 94 189 0 1900215568 11854624 26599248
14:08:40 2466 8192000000 10810947648 11198771200 1865264592 18.546 100 91 179 1 1903963120 13014512 25684016
14:08:49 1890 8192000000 10810643232 11203956736 1868796784 18.575 100 92 182 1 1907355200 13435472 25122944
14:08:57 31981 8192000000 10792592000 11200425984 1869072656 18.577 100 62 124 0 1897447472 10772256 17602560
14:09:37 13742 8192000000 10806694640 11210211328 1873365792 18.611 100 64 128 3 1902360256 10909968 18084496
14:09:57 1803 8192000000 10828893792 11217903616 1882308896 18.684 100 93 186 2 1923550288 14228880 27012512
14:10:06 2244 8192000000 10818807456 11217358848 1876580128 18.637 100 74 148 0 1911274816 14149744 20544944
14:10:16 4782 8192000000 10798400784 11209666560 1875522784 18.629 100 50 101 1 1900147168 10934544 13689840
14:10:27 2248 8192000000 10792607056 11207397376 1873152672 18.610 100 42 82 1 1894310592 9487264 11670656
14:10:36 3278 8192000000 10800512352 11211829248 1880117664 18.666 100 61 125 0 1904837744 7244128 17475952
14:10:48 5343 8192000000 10786959632 11207368704 1874275600 18.619 100 25 50 0 1888020320 7099280 6645440
14:11:01 6306 8192000000 10801842880 11216453632 1884358128 18.700 100 50 100 2 1905144192 6141280 14644784
14:11:13 4784 8192000000 10802196992 11221209088 1880361280 18.668 100 29 58 3 1895275520 7337008 7577232
14:11:24 9865 8192000000 10780653600 11217141760 1883312672 18.692 100 25 49 1 1896350752 6032976 7005104
14:11:43 43117 8192000000 10798280112 11225423872 1886800320 18.720 100 47 95 1 1906231936 5743968 13687648
14:12:33 9021 8192000000 10814092144 11230900224 1888467952 18.733 100 33 64 3 1904975904 7857328 8650624
14:12:49 4114 8192000000 10812499088 11237044224 1893779056 18.776 100 37 74 1 1911604848 6849792 10976000
14:13:04 6501 8192000000 10812355296 11236491264 1894059456 18.778 100 36 71 1 1912356592 8269584 10027552
14:13:20 7428 8192000000 10815433872 11236425728 1891398592 18.757 100 23 46 2 1903873920 6167936 6307392
14:13:35 8539 8192000000 10798767792 11234131968 1897169696 18.804 100 28 56 0 1911160912 5712432 8278784
14:13:50 7621 8192000000 10817067088 11244912640 1896638048 18.799 100 30 60 1 1911518288 7031648 7848592
14:14:05 7640 8192000000 10801048480 11235762176 1898181600 18.812 100 28 57 4 1914323648 7221360 8920688
14:14:19 8236 8192000000 10816171392 11243970560 1899638368 18.823 100 21 42 2 1911585232 5996688 5950176
14:14:34 7744 8192000000 10811996720 11242565632 1902252800 18.844 100 28 56 3 1916794192 6932624 7608768
14:14:48 9628 8192000000 10820932400 11245277184 1902877008 18.849 100 23 46 5 1915884128 6149024 6858096
14:15:05 10975 8192000000 10812697968 11247407104 1902247648 18.844 100 20 40 0 1914333344 5939568 6146128
14:15:23 11887 8192000000 10809060688 11245641728 1901338384 18.837 100 16 32 1 1910715984 4380496 4997104
14:15:41 53719 8192000000 10807545216 11228905472 1881804816 18.680 99 31 62 0 1898053440 5773280 10475344
14:16:41 15983 8192000000 10792910352 11228078080 1874763728 18.623 99 23 46 1 1886738496 5393296 6581472
14:17:03 5306 8192000000 10815257888 11241414656 1892064304 18.762 100 26 52 2 1905986368 6013664 7908400
14:17:15 8240 8192000000 10808166704 11229130752 1858073872 18.488 98 28 56 1 1872456512 5641248 8741392
14:17:36 4511 8192000000 10816921008 11234848768 1889350336 18.741 100 26 53 0 1902629008 6394528 6884144
14:17:47 8056 8192000000 10808293744 11234500608 1885798640 18.712 100 28 56 1 1900489616 6389024 8301952
14:18:01 6092 8192000000 10825070976 11241041920 1893877712 18.777 100 42 81 4 1913116352 5857408 13381232
14:18:17 6239 8192000000 10780632880 11207086080 1813526544 18.125 96 13 26 1 1822256688 4840864 3889280
14:18:30 5395 8192000000 10780648624 11217190912 1857458848 18.483 99 29 58 3 1871445392 5721776 8264768
14:18:46 6589 8192000000 10725357312 11152736256 1807485232 18.075 98 25 50 0 1821270192 6746864 7038096
14:18:59 5516 8192000000 10716858096 11131469824 1735184800 17.479 95 36 73 1 1755754592 11171248 9398544
14:19:11 6310 8192000000 10726346976 11150729216 1788898912 17.923 98 14 27 2 1799644800 6582304 4163584
14:19:24 10807 8192000000 10717391312 11137921024 1743044704 17.544 95 21 42 1 1755035984 4818480 7172800
14:19:41 13896 8192000000 10723333200 11152457728 1779433920 17.845 97 22 44 2 1791578592 5433872 6710800
14:20:04 6552 8192000000 10696410192 11114717184 1751389472 17.613 97 26 50 3 1763739712 5088896 7261344
14:20:18 53693 8192000000 10703558048 11093733376 1713556832 17.298 95 50 97 1 1736630480 9168304 13905344
14:21:18 11066 8192000000 10713870112 11135696896 1786220960 17.901 99 26 52 2 1799596880 5992064 7383856
14:21:38 7827 8192000000 10692943904 11103801344 1740859440 17.526 97 32 63 3 1760512272 10964448 8688384
14:21:53 8422 8192000000 10680947504 11089551360 1749099680 17.594 98 33 66 0 1764914912 6752672 9062560
14:22:07 3803 8192000000 10719846112 11123339264 1764700928 17.723 98 54 108 1 1792880592 12959440 15220224
14:22:20 6097 8192000000 10727635376 11124629504 1782357696 17.869 99 31 61 3 1797981344 6473456 9150192
14:22:33 7248 8192000000 10721561280 11126288384 1769844592 17.766 98 20 38 1 1780764592 4875104 6044896
14:22:47 7339 8192000000 10719102880 11143581696 1806181632 18.065 100 15 30 0 1815931296 5475104 4274560
14:23:00 8327 8192000000 10743582544 11152154624 1804867040 18.054 99 32 64 3 1819399328 5337408 9194880
14:23:16 8382 8192000000 10733052688 11151458304 1798853408 18.005 99 23 46 0 1815387360 10086416 6447536
14:23:32 10587 8192000000 10739164064 11163299840 1825613696 18.224 100 25 50 0 1838325456 5484160 7227600
14:23:50 10998 8192000000 10763393456 11177390080 1838261232 18.327 100 36 72 1 1854748992 4935232 11552528
14:24:10 6250 8192000000 10759656672 11186995200 1847708832 18.404 100 24 47 1 1860443232 5433008 7301392
14:24:25 5736 8192000000 10759008320 11190956032 1850629264 18.427 100 18 36 1 1862186256 6149664 5407328
14:24:38 11123 8192000000 10770618624 11195740160 1856110480 18.472 100 25 48 2 1868648304 4676224 7861600
14:24:57 73183 8192000000 10779544288 11203416064 1857629440 18.484 100 21 42 0 1869308896 5577984 6101472
14:26:19 10585 8192000000 10794184736 11213668352 1867573728 18.565 100 32 65 1 1882938416 6330496 9034192
14:26:38 7642 8192000000 10791642688 11216289792 1873468768 18.612 100 26 52 2 1887438528 6934592 7035168
14:26:53 7817 8192000000 10794170992 11219873792 1876590416 18.638 100 34 67 1 1892048800 6451840 9006544
14:27:08 5856 8192000000 10799352480 11229691904 1888373056 18.733 100 23 46 1 1901009008 6309616 6326336
14:27:20 25710 8192000000 10819503888 11240591360 1897090368 18.803 100 36 70 2 1912075072 4580368 10404336
14:27:57 8843 8192000000 10835284192 11254874112 1907848848 18.889 100 47 92 3 1927284064 6346144 13089072
14:28:20 24762 8192000000 10843772288 11268345856 1918421168 18.974 100 49 97 1 1940098928 7924016 13753744
14:29:06 18202 8192000000 10853115488 11281035264 1925660400 19.032 100 39 77 1 1945263440 8361136 11241904
14:29:33 18752 8192000000 10870869008 11295674368 1939381264 19.142 100 47 94 1 1964092784 11294640 13416880
14:30:06 28488 8192000000 10882649984 11308933120 1945460832 19.190 100 45 90 2 1973657696 15252656 12944208
14:30:44 15055 8192000000 10882358288 11311071232 1948931840 19.218 100 43 86 2 1975845184 14298704 12614640
14:31:12 9630 8192000000 10901283696 11326070784 1959318032 19.301 100 55 110 0 1992821392 17207488 16295872
14:31:35 12180 8192000000 10892150432 11324805120 1959018992 19.298 100 52 102 0 1993123792 18782928 15321872
14:31:56 48547 8192000000 10882986736 11317547008 1939641648 19.144 99 36 72 0 1966224400 16370272 10212480
14:32:55 54369 8192000000 10888733024 11329073152 1955531856 19.271 100 36 70 0 1986945600 20668560 10745184
14:33:57 25498 8192000000 10893514912 11330502656 1955662640 19.272 100 34 68 1 1983484128 17720608 10100880
14:34:59 8592 8192000000 10912152720 11346116608 1971850928 19.400 100 41 81 2 2004863264 19950640 13061696
14:35:18 7069 8192000000 10921622992 11354320896 1975914336 19.432 100 44 84 2 2010202016 20739296 13548384
14:35:35 13481 8192000000 10922767024 11358863360 1981510944 19.477 100 45 88 2 2013758656 18380256 13867456
14:35:56 4898 8192000000 10928104752 11357478912 1978494064 19.453 100 53 105 3 2015264736 21591888 15178784
14:36:15 4945 8192000000 10932391264 11363938304 1984114048 19.497 100 54 108 2 2025608960 25268048 16226864
14:36:26 18695 8192000000 10948588240 11379929088 1990107312 19.545 100 66 129 0 2034915376 25290656 19517408
14:36:55 6485 8192000000 10961880944 11388121088 1999213344 19.617 100 63 122 3 2044755280 27748944 17792992
14:37:13 3876 8192000000 10969960832 11398344704 2009603936 19.698 100 61 122 0 2056314608 28350832 18359840
14:37:24 4158 8192000000 10968318624 11392258048 2004857824 19.661 100 68 136 1 2054504592 29017552 20629216
14:37:36 7840 8192000000 10965730032 11396943872 2008748368 19.692 100 67 133 1 2058262128 29129888 20383872
14:37:54 2900 8192000000 10982712512 11405623296 2012814032 19.724 100 75 149 2 2065568432 30427360 22327040
14:38:04 4118 8192000000 10987419232 11409223680 2019300688 19.775 100 87 171 1 2075531168 31014320 25216160
14:38:16 3528 8192000000 10985939056 11402297344 2002098576 19.639 99 83 167 4 2056450112 30610432 23741104
14:38:27 1882 8192000000 10981710816 11408891904 2015572608 19.745 100 69 136 1 2066401680 30708976 20120096
14:38:41 10114 8192000000 10999458096 11432357888 2023906896 19.811 100 59 118 1 2075880496 33737936 18235664
14:39:02 3939 8192000000 11008367376 11434930176 2035970368 19.905 100 66 130 0 2091634016 35814384 19849264
14:39:17 4169 8192000000 11005359344 11433897984 2032582640 19.879 100 65 128 2 2090558560 37939792 20036128
14:39:30 5658 8192000000 11014252000 11435732992 2016675680 19.754 99 79 158 1 2079243648 38606880 23961088
14:39:45 3403 8192000000 11015367856 11440963584 2035703728 19.903 100 82 164 2 2100794592 39360144 25730720
14:39:56 3814 8192000000 11015061536 11439202304 2035303296 19.900 100 69 137 1 2096251184 39572592 21375296
14:40:08 3590 8192000000 11014270128 11444588544 2038116560 19.922 100 69 138 2 2100229296 40858592 21254144
14:40:19 11435 8192000000 11007727024 11435868160 2019962544 19.780 99 73 146 0 2080351232 38287008 22101680
14:40:38 4746 8192000000 11014863776 11442483200 2036475760 19.909 100 68 136 0 2099615008 41204144 21935104
14:41:01 4341 8192000000 10998162272 11429449728 2026657552 19.832 100 64 128 1 2088706880 41585808 20463520
14:41:15 3681 8192000000 10983289744 11410747392 1991896368 19.559 99 73 145 0 2057786480 42778976 23111136
14:41:26 6995 8192000000 10999737088 11427647488 2013289680 19.727 100 72 143 0 2081552656 45553648 22709328
14:41:40 2466 8192000000 11009272080 11430449152 2019043040 19.773 100 76 152 0 2089284048 46625712 23615296
14:41:53 1493 8192000000 11017777936 11433988096 2024420640 19.815 100 91 182 5 2101004560 48586896 27997024
14:42:02 2182 8192000000 11029115120 11447111680 2032867168 19.881 100 93 187 0 2111124576 49649872 28607536
14:42:11 5946 8192000000 11024130912 11446837248 2030429392 19.862 100 83 166 0 2105597152 48896784 26270976
14:42:24 4975 8192000000 11016554080 11443814400 2014578000 19.738 99 67 134 0 2083142608 46943040 21621568
14:42:36 7048 8192000000 11004631040 11429769216 2010031424 19.702 99 71 140 3 2079588992 47046400 22511168
14:42:50 1740 8192000000 11021453968 11449593856 2031950960 19.874 100 80 160 1 2105989904 49266976 24771968
14:42:59 1359 8192000000 11021235344 11440701440 2025297952 19.822 100 87 170 0 2103069920 51265840 26506128
14:43:12 6850 8192000000 11004696400 11424768000 2010269232 19.704 99 75 147 1 2082177280 49404272 22503776
14:43:27 2203 8192000000 11000873792 11414716416 2007437040 19.681 99 83 162 3 2078043056 44707360 25898656
14:43:38 2661 8192000000 11017963824 11436572672 2028574368 19.847 100 95 190 1 2103679136 45603088 29501680
14:43:48 3822 8192000000 10990060784 11418013696 2006923888 19.677 100 72 144 2 2075379536 45201424 23254224
14:44:05 3953 8192000000 11011218080 11437817856 2020585184 19.785 100 81 162 2 2098656800 51491168 26580448
14:44:17 2679 8192000000 10985830544 11412398080 1988490528 19.532 99 79 157 0 2060290016 47359296 24440192
14:44:30 2128 8192000000 11004892768 11424919552 2008607728 19.691 100 86 170 2 2082855792 48245264 26002800
14:44:40 3774 8192000000 10994783088 11417653248 1997076272 19.600 99 75 150 1 2071791328 51120928 23594128
14:44:52 2593 8192000000 10998948944 11416756224 1999887280 19.622 99 78 157 0 2070747696 45991312 24869104
14:45:03 2500 8192000000 11012596336 11434315776 2018825200 19.771 100 77 152 1 2089210720 46820672 23564848
14:45:12 4322 8192000000 10999577968 11427639296 1999650336 19.620 99 72 142 1 2072387696 50082480 22654880
14:45:24 11378 8192000000 10995486272 11430584320 2015596736 19.746 100 67 133 2 2083460480 46929424 20934320
14:45:55 15288 8192000000 10990467456 11440168960 2020290064 19.782 100 41 82 2 2079416688 45120144 14006480
14:46:20 10500 8192000000 10987086432 11435470848 2005555536 19.667 99 37 74 0 2060958240 43229072 12173632
14:46:43 21194 8192000000 10982400816 11426373632 1983429008 19.492 98 50 99 2 2045567776 45790320 16348448
14:47:12 21313 8192000000 10959813232 11402977280 1967968208 19.369 98 38 74 5 2030616592 49654368 12994016
14:47:55 17135 8192000000 10958515280 11405221888 1967844208 19.368 99 40 80 1 2033406048 51554160 14007680
14:48:21 13822 8192000000 10962020816 11410935808 1975369424 19.428 100 40 78 0 2047474256 57863888 14240944
14:48:41 15298 8192000000 10955126864 11400683520 1941342064 19.157 98 41 82 0 2016393664 59903600 15148000
14:49:05 14839 8192000000 10919382800 11381673984 1947770800 19.209 100 33 66 2 2022460176 61522432 13166944
14:49:31 25377 8192000000 10896880768 11353321472 1880229632 18.667 97 31 62 2 1944875472 52420992 12224848
14:50:22 41956 8192000000 10870972160 11327660032 1877050592 18.641 98 20 40 2 1941106848 56457744 7598512
14:51:16 32921 8192000000 10855301184 11324030976 1912794368 18.929 100 17 34 0 1959607504 40956880 5856256
14:52:02 88296 8192000000 10848622176 11324575744 1873861408 18.616 97 10 19 3 1893257664 16919392 2476864
14:53:37 35981 8192000000 10883190064 11317207040 1939884192 19.146 100 45 90 3 1959593264 6492112 13216960
14:54:22 51368 8192000000 10901744448 11348717568 1957369712 19.285 100 38 74 0 1979348544 10813024 11165808
14:55:24 60873 8192000000 10855408240 11331280896 1877447408 18.644 96 11 22 0 1891964912 11921664 2595840
14:56:39 99212 8192000000 10870206800 11326611456 1863985184 18.536 96 33 66 1 1882861600 8545904 10330512
14:58:25 57477 8192000000 10859305024 11316232192 1894332672 18.781 97 14 28 1 1909811472 11554864 3923936
14:59:34 33348 8192000000 10872300768 11342147584 1942182896 19.164 100 23 46 0 1962098352 13674016 6241440
15:00:35 37639 8192000000 10869769552 11306516480 1901993248 18.842 98 37 74 1 1920922400 8484320 10444832
15:01:19 58835 8192000000 10869220656 11316240384 1899434464 18.822 97 27 54 0 1920467136 13206656 7826016
15:02:27 15361 8192000000 10851433600 11296702464 1879454256 18.661 97 47 93 1 1907840640 14865280 13521104
15:02:54 52615 8192000000 10863555600 11312898048 1921655648 19.000 99 30 59 1 1946458320 16514096 8288576
15:03:53 36777 8192000000 10863325088 11337560064 1937937296 19.130 100 16 31 0 1963320176 19951200 5431680
15:04:44 24160 8192000000 10864621552 11340558336 1944534272 19.183 100 15 30 1 1963371296 14374560 4462464
15:05:15 23938 8192000000 10867114064 11330068480 1924112864 19.020 99 14 28 0 1945426288 17060240 4253184
15:05:45 43744 8192000000 10865120512 11342254080 1921742128 19.001 99 9 18 1 1937419648 13268800 2408720
15:06:37 10438 8192000000 10872416096 11350265856 1942687936 19.168 100 6 12 0 1961566144 17336256 1541952
15:06:56 79554 8192000000 10857775904 11327348736 1908056544 18.891 98 14 28 0 1929017824 16437520 4523760
15:08:58 24275 8192000000 10881914720 11330777088 1940651376 19.152 100 31 62 2 1955073760 6078432 8343952
15:09:29 43053 8192000000 10869896144 11335852032 1949761792 19.225 100 36 72 1 1968682080 9214144 9706144
15:10:19 39514 8192000000 10878496112 11345620992 1953739664 19.256 100 3 6 0 1964372528 9461520 1171344
15:11:24 88064 8192000000 10865084256 11346862080 1939358768 19.142 99 13 26 4 1953569008 10171584 4038656
15:13:02 43459 8192000000 10872742416 11352657920 1939100928 19.140 99 5 10 0 1954108224 13688144 1319152
15:13:52 106293 8192000000 10883547008 11363807232 1963203184 19.331 100 10 20 1 1978202000 12016704 2982112
15:15:45 40727 8192000000 10916050848 11377274880 1980722000 19.470 100 34 68 2 1998708336 7943552 10042784
15:16:34 49473 8192000000 10910746928 11378712576 1986768496 19.518 100 25 51 0 2004593472 10968992 6855984
15:17:46 67476 8192000000 10914672144 11379167232 1966639440 19.359 99 18 36 0 1980615968 9006672 4969856
15:19:05 66519 8192000000 10918387472 11390529536 1990224080 19.546 100 16 32 1 2008365152 13470656 4670416
15:20:21 55240 8192000000 10908631728 11389792256 1960645072 19.311 98 21 42 2 1981597904 14975184 5977648
15:21:22 77927 8192000000 10898666560 11365285888 1897238224 18.804 95 23 46 1 1917408384 14161856 6008304
15:22:46 13913 8192000000 10947916800 11383635968 1992003184 19.560 100 57 114 2 2016866608 8477760 16385664
15:23:07 9552 8192000000 10916550624 11363487744 1934764320 19.105 97 50 100 1 1958677248 10264304 13648624
15:23:37 22998 8192000000 10918908688 11379335168 1982492688 19.484 100 42 84 2 2008166016 14143568 11529760
15:24:08 48241 8192000000 10906478688 11377909760 1946000624 19.195 98 23 46 1 1968062816 16032896 6029296
15:25:03 55776 8192000000 10887199280 11362283520 1909302144 18.901 97 6 12 2 1930695216 19720448 1672624
15:26:05 60020 8192000000 10870171392 11332792320 1903147088 18.852 97 16 32 0 1920258912 12615984 4495840
15:27:12 94514 8192000000 10851100480 11308519424 1910209520 18.908 98 13 26 1 1923424208 8854176 4360512
15:29:03 40020 8192000000 10871724944 11309568000 1849875536 18.421 94 42 83 0 1868008848 7144960 10988352
15:29:54 25764 8192000000 10879205104 11308597248 1910093824 18.907 98 45 88 0 1930970992 8708256 12168912
15:30:37 3758 8192000000 10893052784 11334873088 1944139824 19.180 100 44 88 2 1968117104 11743296 12233984
15:30:47 40656 8192000000 10870203664 11334762496 1937580208 19.127 99 25 50 0 1958363920 13740096 7043616
15:31:36 49482 8192000000 10857027840 11326824448 1915926752 18.954 98 12 24 1 1934032096 14852304 3253040
15:32:38 47343 8192000000 10879065552 11340460032 1914984096 18.947 98 13 26 1 1932284832 13475456 3825280
15:33:32 71295 8192000000 10852693808 11341213696 1902899552 18.850 98 8 16 2 1919106912 14139472 2067888
15:34:50 15991 8192000000 10853443600 11319042048 1933591136 19.096 100 26 52 0 1949356112 8563536 7201440
15:35:16 39217 8192000000 10862354928 11326427136 1892389408 18.765 97 30 60 1 1911687952 10562512 8736032
15:36:07 42736 8192000000 10851552480 11303206912 1875894128 18.632 97 23 46 1 1894447728 11952128 6601472
15:37:01 71214 8192000000 10887608640 11362525184 1947822592 19.209 100 31 62 0 1970874704 14380608 8671504
15:38:47 45211 8192000000 10873042448 11340439552 1943827664 19.177 100 4 8 0 1955036128 10299648 908816
15:39:44 28243 8192000000 10870193024 11327311872 1879276608 18.659 96 45 89 2 1901340304 9781344 12282352
15:40:27 16055 8192000000 10868078208 11300397056 1886385072 18.717 97 49 98 1 1910384496 9863600 14135824
15:40:53 28493 8192000000 10855726864 11304787968 1871895760 18.600 97 37 74 1 1892536720 10511136 10129824
15:41:31 50043 8192000000 10859860096 11322224640 1887256544 18.724 98 41 82 2 1910783024 11734624 11791856
15:42:28 31516 8192000000 10868274992 11323695104 1908068064 18.891 99 23 46 0 1925483888 11113376 6302448
15:43:14 50187 8192000000 10868496848 11324436480 1887598064 18.726 97 30 60 2 1910844816 14538784 8707968
15:44:15 80936 8192000000 10876166848 11351822336 1874059648 18.617 96 24 48 1 1899407344 18541360 6806336
15:46:00 92141 8192000000 10889817536 11354030080 1905030976 18.867 98 8 16 0 1925805520 18501984 2272560
15:47:46 138940 8192000000 10851830032 11324907520 1872443632 18.604 96 13 26 0 1888064912 11641056 3980224
15:50:22 33746 8192000000 10853273296 11319353344 1881742816 18.679 97 15 30 1 1899111456 13016816 4351824
15:51:09 50959 8192000000 10847279056 11338305536 1929394368 19.062 100 10 20 0 1949017216 16693712 2929136
15:52:50 59794 8192000000 10864728912 11335602176 1926670000 19.040 99 9 18 1 1937393776 7935008 2788768
15:54:03 76924 8192000000 10876386928 11349188608 1906173152 18.876 98 12 24 2 1918243072 8706416 3363504
15:55:31 58156 8192000000 10897946080 11359707136 1958401552 19.293 100 24 48 4 1978672288 12840192 7430544
15:56:57 49149 8192000000 10889653024 11354476544 1921492848 18.999 98 19 38 4 1943002576 15690048 5819680
15:58:08 55695 8192000000 10892184432 11355500544 1922591440 19.008 98 30 59 0 1949656192 18377840 8686912
15:59:48 87270 8192000000 10891566864 11357888512 1937009200 19.123 99 18 36 0 1954123728 12567840 4546688
16:01:31 93498 8192000000 10891915936 11353407488 1890254480 18.748 96 12 24 1 1904660784 11325152 3081152
16:03:19 67388 8192000000 10900329552 11374444544 1973701680 19.415 100 33 65 5 1994337792 11579600 9056512
16:04:38 52101 8192000000 10906640016 11372679168 1956752512 19.280 99 26 52 3 1978346192 13806528 7787152
16:05:41 28473 8192000000 10894623856 11356643328 1950739776 19.232 99 34 68 0 1969083712 9148000 9195936
16:06:15 20398 8192000000 10914255536 11363786752 1938609088 19.136 98 34 68 0 1957150128 9285872 9255168
16:06:43 36526 8192000000 10875295296 11339300864 1909196896 18.900 97 41 82 1 1933043984 12496480 11350608
16:07:29 144106 8192000000 10879018112 11355070464 1950613056 19.231 100 11 22 0 1966483296 12608912 3261328
16:10:00 67956 8192000000 10893836896 11359326208 1958050272 19.291 100 28 56 1 1977445248 11803872 7591104
16:11:18 30268 8192000000 10870103104 11341697024 1936205552 19.116 99 9 18 1 1947578112 9048992 2323568
16:11:56 32610 8192000000 10849171104 11329781760 1933360720 19.094 99 12 24 1 1944708080 7851104 3496256
16:12:39 65060 8192000000 10869221056 11350003712 1919761120 18.985 98 11 22 0 1929905648 6967648 3176880
16:13:50 66290 8192000000 10887665584 11362050048 1943720272 19.176 99 8 16 0 1954206512 8161376 2324864
16:15:37 80870 8192000000 10877571616 11350745088 1922891136 19.010 98 15 30 0 1936852464 9427824 4533504
16:17:12 59924 8192000000 10873663424 11336982528 1920563440 18.991 98 20 40 0 1937509984 10830832 6115712
16:18:22 45672 8192000000 10883438656 11362779136 1965969520 19.353 100 19 38 1 1982724736 10792288 5962928
16:19:16 64042 8192000000 10898281472 11359363072 1945194384 19.188 99 12 25 1 1956219760 7353904 3671472
16:20:26 43899 8192000000 10884729856 11349037056 1921146288 18.996 98 36 72 1 1941660304 9208736 11305280
16:21:18 50311 8192000000 10887240256 11358629888 1945108912 19.188 99 24 48 0 1960927568 9469744 6348912
16:22:26 23400 8192000000 10906487760 11368271872 1932852096 19.090 98 31 62 1 1949707616 7739424 9116096
16:23:01 65915 8192000000 10883484800 11357310976 1911097312 18.915 97 28 56 0 1934497504 14813648 8586544
16:24:16 38952 8192000000 10867864336 11332780032 1875954880 18.632 96 25 50 2 1899962016 17030384 6976752
16:25:09 74435 8192000000 10858592240 11316367360 1853686816 18.452 96 14 28 0 1873110720 16107952 3315952
16:26:31 58279 8192000000 9481435888 9787965440 627963232 7.119 33 12 24 0 635950816 4771456 3216128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 08-03-2021 16:28:23 to 08-03-2021 16:28:54.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2021 16:28:55 to 08-03-2021 16:28:57.

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          240936
MON$OLDEST_ACTIVE               240937
MON$OLDEST_SNAPSHOT             240937
MON$NEXT_TRANSACTION            240937
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                       2004992
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:177: 
:178: mscs-test-161.budzdorov.ru    Mon Mar  8 16:27:34 2021
:179:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:180: 
--- end of diff output ---

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

08.03.21 16:28:58. 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-03-08 16:29:01 No severe PSQL-related problems occured
08.03.21 16:29:02. End of report.