Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.12.2020 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 e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17427880 kB
MemAvailable 31437892 kB
Buffers 0 kB
Cached 14236208 kB
SwapCached 4820 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-26 16:27:09
DTS_END                         2020-12-26 16:27:09.7980
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/39712
TRN_ID                          242147
ATT_ID                          629
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: 9367.78 23588 1124133
customer order: creation 173.04 417 20765
customer order: refuse 14.99 331 1799
order to supplier: creation 46.45 1376 5574
order to supplier: removal 3.61 106556 433
invoice (draft): creation 47.00 3693 5640
invoice (draft): removal 54.91 842 6589
invoice accept: apply 41.64 17677 4997
invoice accept: cancel 48.97 818 5876
customer reserve: creation 3833.48 175 460018
customer reserve: removal 4804.59 63 576551
realization accept: apply 84.19 186 10103
realization accept: cancel 85.10 110 10212
payment from customer: creation 59.34 122 7121
payment from customer: removal 5.90 78 708
payment to supplier: creation 48.28 135 5793
payment to supplier: removal 3.53 72 424
service: total inventory turnovers 5.08 1061 609
service: total monetary turnovers 6.87 70 824
service: aggregate perf. data 0.78 24380 93
service: refresh index statistics 0.03 313599 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-12-2020 16:28:05 to 26-12-2020 16:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3868
TEST_TIME 2 3974
TEST_TIME 3 4476
TEST_TIME 4 4632
TEST_TIME 5 5099
TEST_TIME 6 4977
TEST_TIME 7 5006
TEST_TIME 8 5094
TEST_TIME 9 5126
TEST_TIME 10 5511
TEST_TIME 11 5665
TEST_TIME 12 5852
TEST_TIME 13 6430
TEST_TIME 14 6443
TEST_TIME 15 6365
TEST_TIME 16 6648
TEST_TIME 17 6685
TEST_TIME 18 6805
TEST_TIME 19 7350
TEST_TIME 20 7820
TEST_TIME 21 8532
TEST_TIME 22 8665
TEST_TIME 23 8933
TEST_TIME 24 9476
TEST_TIME 25 10058
TEST_TIME 26 10958
TEST_TIME 27 10785
TEST_TIME 28 10502
TEST_TIME 29 10545
TEST_TIME 30 10454
TEST_TIME 31 10412
TEST_TIME 32 10311
TEST_TIME 33 10142
TEST_TIME 34 10091
TEST_TIME 35 10080
TEST_TIME 36 10152
TEST_TIME 37 10057
TEST_TIME 38 9951
TEST_TIME 39 9812
TEST_TIME 40 9808
TEST_TIME 41 9653
TEST_TIME 42 9457
TEST_TIME 43 9525
TEST_TIME 44 9473
TEST_TIME 45 9502
TEST_TIME 46 9423
TEST_TIME 47 9400
TEST_TIME 48 9512
TEST_TIME 49 9569
TEST_TIME 50 9633
TEST_TIME 51 9664
TEST_TIME 52 9770
TEST_TIME 53 9760
TEST_TIME 54 9780
TEST_TIME 55 9800
TEST_TIME 56 9836
TEST_TIME 57 9845
TEST_TIME 58 9893
TEST_TIME 59 9751
TEST_TIME 60 9633
TEST_TIME 61 9612
TEST_TIME 62 9557
TEST_TIME 63 9571
TEST_TIME 64 9506
TEST_TIME 65 9508
TEST_TIME 66 9535
TEST_TIME 67 9515
TEST_TIME 68 9493
TEST_TIME 69 9452
TEST_TIME 70 9433
TEST_TIME 71 9520
TEST_TIME 72 9646
TEST_TIME 73 9703
TEST_TIME 74 9673
TEST_TIME 75 9687
TEST_TIME 76 9704
TEST_TIME 77 9772
TEST_TIME 78 9699
TEST_TIME 79 9593
TEST_TIME 80 9562
TEST_TIME 81 9530
TEST_TIME 82 9552
TEST_TIME 83 9567
TEST_TIME 84 9547
TEST_TIME 85 9513
TEST_TIME 86 9489
TEST_TIME 87 9398
TEST_TIME 88 9398
TEST_TIME 89 9345
TEST_TIME 90 9308
TEST_TIME 91 9364
TEST_TIME 92 9384
TEST_TIME 93 9394
TEST_TIME 94 9352
TEST_TIME 95 9384
TEST_TIME 96 9461
TEST_TIME 97 9472
TEST_TIME 98 9426
TEST_TIME 99 9436
TEST_TIME 100 9526
TEST_TIME 101 9483
TEST_TIME 102 9522
TEST_TIME 103 9530
TEST_TIME 104 9525
TEST_TIME 105 9439
TEST_TIME 106 9475
TEST_TIME 107 9420
TEST_TIME 108 9436
TEST_TIME 109 9427
TEST_TIME 110 9401
TEST_TIME 111 9354
TEST_TIME 112 9351
TEST_TIME 113 9317
TEST_TIME 114 9374
TEST_TIME 115 9358
TEST_TIME 116 9343
TEST_TIME 117 9369
TEST_TIME 118 9463
TEST_TIME 119 9450
TEST_TIME 120 9379

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-12-2020 16:28:09 to 26-12-2020 16:28:12.

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 1551295 1551295 0 0.00 0 24561 6 0 0
doc_list_biud 1551295 1551295 0 0.00 0 26534 30 0 0
sp_add_invoice_to_stock 5133 4997 136 2.64 46 209591 17677 0 136
sp_cancel_adding_invoice 5876 5876 0 0.00 3 96569 818 0 0
sp_cancel_client_order 1799 1799 0 0.00 4 10853 331 0 0
sp_cancel_customer_reserve 576551 576551 0 0.00 1 26541 64 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 2 5203 79 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 2 2371 72 0 0
sp_cancel_supplier_invoice 6600 6589 11 0.16 2 15210 843 0 11
sp_cancel_supplier_order 433 433 0 0.00 7 1127170 106557 0 0
sp_cancel_write_off 10212 10212 0 0.00 1 12499 111 0 0
sp_client_order 20765 20765 0 0.00 3 56937 418 0 0
sp_customer_reserve 460018 460018 0 0.00 0 68568 175 0 0
sp_fill_shopping_cart 31971 31971 0 0.00 1 13440 39 0 0
sp_fill_shopping_cart_clo_res 460006 460006 0 0.00 0 12666 14 0 0
sp_get_clo_for_invoice 4983 4983 0 0.00 0 29416 315 0 0
sp_kill_cost_storno 17220 17220 0 0.00 0 18651 58 0 0
sp_kill_qstorno_ret_qs2qd 1170336 1170336 0 0.00 0 26533 35 0 0
sp_kill_qty_storno 616546 616546 0 0.00 0 26534 74 0 0
sp_lock_selected_doc 21058 21058 0 0.00 0 6925 5 0 0
sp_make_cost_storno 28000 28000 0 0.00 0 23626 55 0 0
sp_multiply_rows_for_pdistr 28000 28000 0 0.00 0 7616 29 0 0
sp_multiply_rows_for_qdistr 20765 20765 0 0.00 0 52547 193 0 0
sp_pay_from_customer 7121 7121 0 0.00 4 25536 122 0 0
sp_pay_to_supplier 5793 5793 0 0.00 4 18933 135 0 0
sp_payment_common 12914 12914 0 0.00 1 7992 31 0 0
sp_qd_handle_on_cancel_clo 1799 1799 0 0.00 0 10847 304 0 0
sp_qd_handle_on_invoice_upd_sts 10859 10859 0 0.00 0 23183 334 0 0
sp_qd_handle_on_reserve_upd_sts 10103 10103 0 0.00 0 18101 57 0 0
sp_reserve_write_off 10103 10103 0 0.00 5 25535 186 0 0
sp_supplier_invoice 5640 5640 0 0.00 6 96881 3694 0 0
sp_supplier_order 5574 5574 0 0.00 4 84621 1377 0 0
srv_aggregate_perf_data 93 93 0 0.00 2441 536132 24381 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1556 126892 32570 0 0
srv_find_qd_qs_mism 1076903 1076903 0 0.00 0 14589 5 0 0
srv_make_invnt_saldo 609 609 0 0.00 42 34863 1061 0 0
srv_make_money_saldo 824 824 0 0.00 1 30007 70 0 0
srv_recalc_idx_stat 4 4 0 0.00 217101 488770 313600 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 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 4998 4998 0 0.00 0 9301 189 0 0
t$perf-norm:sp_cancel_adding_invoice 448 448 0 0.00 1 5569 97 0 0
t$perf-norm:sp_cancel_client_order 1799 1799 0 0.00 0 12724 27 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 379 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 2372 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 5217 26 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 869 14 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 24014 1588 0 0
t$perf-norm:sp_cancel_write_off 991 991 0 0.00 0 3297 14 0 0
t$perf-norm:sp_client_order 20765 20765 0 0.00 0 9996 18 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 4382 11 0 0
t$perf-norm:sp_pay_from_customer 7121 7121 0 0.00 0 4502 9 0 0
t$perf-norm:sp_pay_to_supplier 5794 5794 0 0.00 0 9216 11 0 0
t$perf-norm:sp_reserve_write_off 10103 10103 0 0.00 0 8878 11 0 0
t$perf-norm:sp_supplier_invoice 5640 5640 0 0.00 0 4123 18 0 0
t$perf-norm:sp_supplier_order 5574 5574 0 0.00 0 9191 16 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 1514 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 521 6 0 0
t$perf-norm:srv_make_invnt_saldo 609 609 0 0.00 0 2545 34 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 4500 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 10238 9966 272 2.65 0 12905 20 0 272
v_all_customers 37614 37614 0 0.00 0 89 1 0 0
v_all_suppliers 30750 30750 0 0.00 0 19 1 0 0
v_all_wares 41530 41530 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 896 896 0 0.00 0 3373 17 0 0
v_cancel_client_order 3598 3598 0 0.00 0 4382 6 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 3206 11 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 3257 7 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 2367 9 0 0
v_cancel_supplier_invoice 912 890 22 2.41 0 2145 17 0 22
v_cancel_supplier_order 866 866 0 0.00 0 2218 10 0 0
v_cancel_write_off 1982 1982 0 0.00 0 4716 18 0 0
v_max_id_clo_ord 5571 5571 0 0.00 0 1317 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 8926 20 0 0
v_max_id_ord_sup 5635 5635 0 0.00 0 5498 4 0 0
v_max_non_paid_invoice 1621 1621 0 0.00 0 783 2 0 0
v_max_non_paid_realizn 3788 3788 0 0.00 0 5423 8 0 0
v_min_id_clo_ord 5571 5571 0 0.00 0 3200 5 0 0
v_min_id_clo_res 981 981 0 0.00 0 3026 7 0 0
v_min_id_ord_sup 5635 5635 0 0.00 0 6869 8 0 0
v_min_non_paid_invoice 5793 5793 0 0.00 0 5686 18 0 0
v_min_non_paid_realizn 7121 7121 0 0.00 0 6477 22 0 0
v_our_firm 10582 10582 0 0.00 0 86 1 0 0
v_reserve_write_off 20206 20206 0 0.00 0 4796 7 0 0
x_lock_depdocs_on_canc_invoice 12020 12020 0 0.00 0 17583 111 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 6527 378 0 0
x_make_qstorno_1000_1200 5574 5574 0 0.00 2 82343 1297 0 0
x_make_qstorno_1200_2000 5640 5640 0 0.00 3 96868 3554 0 0
x_make_qstorno_2100_3300 460018 460018 0 0.00 0 68567 159 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-12-2020 16:28:13 to 26-12-2020 16:28:17.

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:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 23597 8192000000 10270797264 10579509248 1050685328 11.367 83 61 122 0 1073419600 2895008 19839264
13:57:51 26504 8192000000 10347092592 10665328640 1390788112 14.513 100 84 169 0 1424373216 5486816 28098288
13:58:35 29724 8192000000 10396691136 10719227904 1440363936 14.953 100 91 182 1 1477482736 7059472 30059328
13:59:16 22723 8192000000 10401833008 10735083520 1460225904 15.128 100 86 172 0 1497051184 7942416 28882864
13:59:48 22194 8192000000 10435940464 10767560704 1485099760 15.346 100 89 177 1 1526554784 12502576 28952448
14:00:22 19613 8192000000 10447567472 10783490048 1501229392 15.487 100 89 178 1 1539463104 8874448 29359264
14:00:56 22566 8192000000 10467777920 10809241600 1524919232 15.693 100 84 168 0 1560484896 9087472 26478192
14:01:26 15916 8192000000 10505571856 10846826496 1551272400 15.921 100 83 166 0 1586577680 9399712 25905568
14:01:49 14678 8192000000 10520111936 10872725504 1578591760 16.156 100 80 160 0 1613393696 9795552 25006384
14:02:14 13817 8192000000 10538637120 10897641472 1602045696 16.357 100 76 152 0 1635549728 10169888 23334144
14:02:37 17132 8192000000 10575953120 10934956032 1629221376 16.588 100 83 166 0 1665144192 11230560 24692256
14:03:01 13202 8192000000 10587620432 10950541312 1648210736 16.749 100 76 151 0 1681761872 11121248 22429888
14:03:23 12362 8192000000 10609777888 10974109696 1667937152 16.916 100 83 165 1 1704172720 12286320 23949248
14:03:43 14900 8192000000 10629020880 10996117504 1681349696 17.029 100 78 156 1 1716745840 12660528 22735616
14:04:07 7331 8192000000 10641865296 11012251648 1700485632 17.189 100 79 154 1 1735245936 12575968 22184336
14:04:21 7335 8192000000 10646826384 11025588224 1713703360 17.300 100 74 148 4 1748163856 12952128 21508368
14:04:37 6981 8192000000 10655633360 11035594752 1724977680 17.394 100 75 149 3 1758864864 12007904 21879280
14:04:52 8088 8192000000 10675934480 11056766976 1738081504 17.503 100 71 141 1 1769966880 11253360 20632016
14:05:08 5133 8192000000 10691425696 11075092480 1760075712 17.685 100 75 149 0 1792755312 11608032 21071568
14:05:20 6785 8192000000 10710689424 11092525056 1771019504 17.775 100 69 136 0 1801995616 12033104 18943008
14:05:34 5011 8192000000 10715254064 11096383488 1782520752 17.870 100 75 150 0 1816691696 12880720 21290224
14:05:46 4796 8192000000 10731187600 11112591360 1792275840 17.950 100 82 164 0 1828708864 13446416 22986608
14:05:59 8813 8192000000 10719112016 11115487232 1793031504 17.957 100 68 136 1 1825852192 13870880 18949808
14:06:15 2988 8192000000 10746930576 11133362176 1802539776 18.035 100 85 168 2 1837719824 12096048 23084000
14:06:25 3278 8192000000 10759592896 11143135232 1816277456 18.147 100 82 164 4 1851251616 12071536 22902624
14:06:34 3774 8192000000 10757572864 11146932224 1822452432 18.198 100 76 152 0 1855567568 11880080 21235056
14:06:45 3088 8192000000 10768314976 11153838080 1829919568 18.259 100 84 169 2 1864762896 11712512 23130816
14:06:56 3705 8192000000 10762989200 11155116032 1830040336 18.260 100 83 167 1 1866358128 12903936 23413856
14:07:07 3188 8192000000 10769052304 11158552576 1835218480 18.302 100 88 175 1 1873376848 13775104 24383264
14:07:16 3456 8192000000 10786457424 11171561472 1843173248 18.367 100 93 186 1 1882899568 13559488 26166832
14:07:26 1562 8192000000 10788164304 11177209856 1845476704 18.385 100 89 177 0 1884077040 13829776 24770560
14:07:34 2589 8192000000 10793561408 11180056576 1849545648 18.418 100 94 186 1 1890876800 14683920 26647232
14:07:44 2513 8192000000 10789862640 11181686784 1850464144 18.426 100 87 172 1 1888932160 14085040 24382976
14:07:53 2018 8192000000 10798890592 11190247424 1856890128 18.478 100 86 173 0 1895294352 14030672 24373552
14:08:02 1764 8192000000 10799234880 11187105792 1864536384 18.540 100 91 182 4 1903068896 13521392 25011120
14:08:10 1734 8192000000 10811302848 11199623168 1864004032 18.536 100 88 176 1 1902405616 12379456 26022128
14:08:18 4212 8192000000 10805255008 11199238144 1862745904 18.526 100 84 165 2 1898686496 12463136 23477456
14:08:30 3380 8192000000 10803622928 11198443520 1864797792 18.542 100 86 171 0 1901759360 12713616 24247952
14:08:40 2158 8192000000 10811480512 11204521984 1870086320 18.585 100 92 182 2 1908607840 12969920 25551600
14:08:49 2168 8192000000 10823660096 11210674176 1873602992 18.613 100 90 180 3 1912510432 13932176 24975264
14:08:57 2161 8192000000 10821407744 11212120064 1879107408 18.658 100 94 186 0 1918206128 11984288 27114432
14:09:05 2800 8192000000 10817449504 11208396800 1875009552 18.625 100 84 165 2 1911112544 12060784 24042208
14:09:16 1328 8192000000 10821017408 11211378688 1876815552 18.639 100 91 182 2 1915820608 13317680 25687376
14:09:24 8466 8192000000 10822503888 11217481728 1878947712 18.657 100 86 173 0 1920430336 18285744 23196880
14:09:38 1648 8192000000 10816619856 11217043456 1883848512 18.696 100 87 175 0 1922847856 13747376 25251968
14:09:47 18511 8192000000 10818875104 11218886656 1878177552 18.650 100 65 129 0 1907663008 11338224 18147232
14:10:12 2032 8192000000 10821995520 11223330816 1886458256 18.717 100 77 153 1 1919647264 11567536 21621472
14:10:20 6272 8192000000 10793158896 11218014208 1882533776 18.686 100 35 70 1 1900931488 8655984 9741728
14:10:33 4201 8192000000 10799419728 11221819392 1892381024 18.765 100 46 93 0 1913298880 7851536 13066320
14:10:43 5278 8192000000 10802603552 11224326144 1893401168 18.773 100 41 82 2 1912632928 7227984 12003776
14:10:57 6251 8192000000 10806024320 11229876224 1894030144 18.778 100 36 72 1 1910609280 6532928 10046208
14:11:10 7020 8192000000 10804411424 11228651520 1892515520 18.766 100 20 38 1 1903856736 6080720 5260496
14:11:23 8011 8192000000 10805036544 11236208640 1899846864 18.825 100 37 74 1 1918737248 7739472 11150912
14:11:38 7308 8192000000 10817130336 11241185280 1907198336 18.884 100 46 93 2 1928205280 7919392 13087552
14:11:55 7662 8192000000 10812458064 11241467904 1902286576 18.845 100 30 60 1 1917436256 6589344 8560336
14:12:10 14155 8192000000 10807548480 11240914944 1903697232 18.856 100 19 38 1 1915428544 5416480 6314832
14:12:30 8250 8192000000 10814548800 11244789760 1910685408 18.912 100 28 54 6 1924497824 5858352 7954064
14:12:45 8675 8192000000 10813626528 11247570944 1907816912 18.889 100 20 40 2 1919952416 7004432 5131072
14:13:02 11081 8192000000 10817056672 11253305344 1910603456 18.911 100 18 36 3 1922172272 6049232 5519584
14:13:31 25715 8192000000 10824595808 11255717888 1897494560 18.806 99 17 34 1 1909004624 5607648 5902416
14:14:05 70631 8192000000 10850231168 11270885376 1918473008 18.975 100 33 67 2 1934207280 5651936 10082336
14:15:22 1709 8192000000 10876091920 11284701184 1931688176 19.080 100 99 204 4 1970405792 9460288 29257328
14:15:34 7021 8192000000 10844266016 11269849088 1917407392 18.966 100 23 44 0 1929294240 5086032 6800816
14:15:49 2431 8192000000 10837232816 11255742464 1909649312 18.904 99 56 112 2 1931117920 4908048 16560560
14:15:58 5513 8192000000 10830828256 11264307200 1912435568 18.926 100 26 52 0 1926986976 6970160 7581248
14:16:13 8168 8192000000 10836465840 11270565888 1920870688 18.994 100 35 70 2 1938186736 7389920 9926128
14:16:28 4039 8192000000 10851065184 11270086656 1921239296 18.997 100 34 68 3 1937460288 5999840 10221152
14:16:40 8162 8192000000 10840055136 11272617984 1919608832 18.984 100 26 53 1 1933614784 7092864 6913088
14:16:55 6839 8192000000 10843671376 11270127616 1906486384 18.878 99 35 70 1 1925050400 8849904 9714112
14:17:09 5324 8192000000 10830436240 11251822592 1892528448 18.766 99 21 41 2 1904340528 5450912 6361168
14:17:21 6165 8192000000 10812342544 11243212800 1885790384 18.712 99 27 54 1 1900744752 5987008 8967360
14:17:35 13843 8192000000 10800065664 11219636224 1845312736 18.384 97 22 45 1 1855770128 4749680 5707712
14:17:55 24937 8192000000 10767980144 11204489216 1848842816 18.413 97 42 86 0 1865796640 5336224 11617600
14:18:45 8253 8192000000 10792964160 11215409152 1857380672 18.482 99 38 78 0 1874631872 5910864 11340336
14:19:04 7618 8192000000 10790252560 11214233600 1853007168 18.447 99 20 40 1 1864336816 5758896 5570752
14:19:17 10067 8192000000 10769978352 11191541760 1832901456 18.283 98 23 46 4 1844981136 5712016 6367664
14:19:34 5290 8192000000 10799946496 11223134208 1878587152 18.654 100 40 80 2 1897183072 7255408 11340512
14:19:48 6406 8192000000 10742917584 11155603456 1770576560 17.772 95 42 82 3 1788434336 6091280 11766496
14:20:01 8632 8192000000 10743947440 11154706432 1761491376 17.697 96 28 56 1 1774965520 5265152 8208992
14:20:17 8307 8192000000 10732977808 11157245952 1795857392 17.980 98 24 46 3 1808830688 5261152 7712144
14:20:36 9215 8192000000 10675912352 11084951552 1653335264 16.793 92 23 46 1 1665856368 5627712 6893392
14:20:53 6159 8192000000 10691106384 11106844672 1749815584 17.600 98 24 48 0 1762722096 6392704 6513808
14:21:09 9769 8192000000 10710210688 11135295488 1752175648 17.620 97 16 32 1 1762842800 5345344 5321808
14:21:26 9810 8192000000 10721800880 11141705728 1793745024 17.963 99 27 54 1 1808045552 6029456 8271072
14:21:47 6277 8192000000 10733630960 11149287424 1802251376 18.032 99 30 60 0 1816349184 5921536 8176272
14:22:02 69146 8192000000 10738409456 11157532672 1753799792 17.633 96 35 70 2 1777888704 14007648 10081264
14:23:22 8442 8192000000 10723384384 11143901184 1767538704 17.747 97 32 64 1 1786997760 10029312 9429744
14:23:41 7803 8192000000 10738809184 11157217280 1817596224 18.158 100 28 56 0 1831155552 6221536 7337792
14:23:55 8473 8192000000 10750836176 11169116160 1825058448 18.219 100 28 56 3 1843706544 10542032 8106064
14:24:10 5569 8192000000 10752428608 11168403456 1832586096 18.280 100 27 54 0 1847170768 6405184 8179488
14:24:25 7709 8192000000 10758446480 11181613056 1835280224 18.302 100 25 50 0 1848110704 5816848 7013632
14:24:40 11592 8192000000 10765669872 11185827840 1845544880 18.386 100 31 60 2 1859324208 5150848 8628480
14:24:58 5228 8192000000 10751059248 11178614784 1826713088 18.233 99 25 50 1 1840061008 5811840 7536080
14:25:10 6628 8192000000 10760413280 11183812608 1845649232 18.387 100 20 40 0 1856168784 5494064 5025488
14:25:29 8089 8192000000 10754195888 11190325248 1849382656 18.417 100 21 42 0 1861179904 5886496 5910752
14:25:44 9455 8192000000 10764140240 11198660608 1854053104 18.455 100 25 50 2 1871310640 9871376 7386160
14:26:01 8658 8192000000 10776021200 11202564096 1857439168 18.483 100 14 28 2 1866432144 5209760 3783216
14:26:17 9491 8192000000 10777105744 11204833280 1864236112 18.538 100 29 59 0 1878152720 5527584 8389024
14:26:32 12070 8192000000 10776726544 11208437760 1867361744 18.563 100 14 28 0 1876380160 5201872 3816544
14:26:51 11714 8192000000 10808498048 11224035328 1879206560 18.659 100 52 106 3 1900157648 5244752 15706336
14:27:08 111987 8192000000 10857913488 11267342336 1907785296 18.889 100 50 98 0 1929931184 8823184 13322704
14:29:07 8487 8192000000 10845717600 11261509632 1914237376 18.941 100 60 119 0 1941993920 11472448 16284096
14:29:23 15014 8192000000 10860038080 11278667776 1925146208 19.028 100 54 107 0 1951948192 11910288 14891696
14:29:47 2938 8192000000 10875604560 11290292224 1931680128 19.080 100 69 139 1 1967283008 16577824 19025056
14:29:59 15290 8192000000 10875605088 11298770944 1935512320 19.111 100 56 110 4 1968618960 17781344 15325296
14:30:24 21152 8192000000 10874367328 11299422208 1941672192 19.160 100 56 110 4 1970877392 13807184 15398016
14:30:52 33567 8192000000 10877725248 11314188288 1951138288 19.236 100 44 88 4 1978513072 15165616 12209168
14:31:38 8465 8192000000 10890622000 11319422976 1957135072 19.283 100 46 92 1 1986494560 16400640 12958848
14:31:54 21386 8192000000 10895960208 11327827968 1960722640 19.312 100 53 106 1 1993475904 17088144 15665120
14:32:45 9170 8192000000 10897236496 11334160384 1961403568 19.317 100 28 56 0 1986751456 17072400 8275488
14:33:02 21631 8192000000 10894262432 11329163264 1951783840 19.241 99 49 98 0 1984195712 17509952 14901920
14:33:43 11582 8192000000 10915994448 11346976768 1976966400 19.441 100 50 99 1 2013396688 22171520 14258768
14:34:02 30240 8192000000 10920422944 11357569024 1978348864 19.452 100 43 85 0 2013634320 23020848 12264608
14:34:40 5503 8192000000 10926387408 11360034816 1983672784 19.494 100 50 96 1 2020171584 22015344 14483456
14:34:57 9945 8192000000 10928126720 11363913728 1989969168 19.544 100 54 108 0 2028376304 22654976 15752160
14:35:21 9817 8192000000 10952325792 11384512512 2001294688 19.633 100 57 114 0 2043943296 25097648 17550960
14:35:38 6393 8192000000 10949952000 11380740096 2003415712 19.650 100 49 98 1 2042593456 23721744 15456000
14:35:59 18576 8192000000 10950703344 11390889984 2006061552 19.671 100 52 105 0 2048828480 25951088 16815840
14:36:26 9276 8192000000 10957048400 11392327680 2008091648 19.686 100 51 103 2 2050571296 25887712 16591936
14:36:44 6000 8192000000 10971594944 11393929216 2006962816 19.678 100 58 116 1 2052170432 27186688 18020928
14:37:00 11202 8192000000 10970437904 11402436608 2013468032 19.729 100 63 126 1 2062109728 28890736 19750960
14:37:28 7366 8192000000 10962323744 11400495104 2013996176 19.733 100 43 86 1 2052243920 24899232 13348512
14:37:55 13774 8192000000 10980761488 11416129536 2022158528 19.797 100 53 106 1 2069551744 30993024 16400192
14:38:28 6899 8192000000 10953700016 11392679936 2001518864 19.635 99 50 101 1 2045644928 28148912 15977152
14:38:43 10819 8192000000 10970590128 11404517376 2016944928 19.756 100 55 107 4 2060432144 26255264 17231952
14:39:03 4457 8192000000 10989987440 11414491136 2006037360 19.670 99 65 129 4 2055074352 29170688 19866304
14:39:16 7906 8192000000 10981670320 11407818752 2015352672 19.744 100 70 137 1 2068265664 31694080 21218912
14:39:36 3593 8192000000 10959062448 11389374464 1980177248 19.466 98 60 120 3 2032708112 34173232 18357632
14:39:48 6451 8192000000 10988180544 11414257664 2018989440 19.772 100 82 163 3 2080444896 36457344 24998112
14:40:02 5391 8192000000 11000344704 11422662656 2021666464 19.793 100 74 146 0 2081859872 38423872 21769536
14:40:20 3562 8192000000 11009257456 11425452032 2014569712 19.737 99 91 184 4 2080910656 38964928 27376016
14:40:32 3509 8192000000 10991872816 11407769600 1997204784 19.601 99 83 166 2 2062405056 39915600 25284672
14:40:44 1555 8192000000 10983989120 11395522560 1984589472 19.501 99 92 182 3 2050124832 39483248 26052112
14:40:53 2552 8192000000 10971580544 11381403648 1983121472 19.489 99 83 162 1 2045302112 37892064 24288576
14:41:03 7571 8192000000 10955836656 11382206464 1960148144 19.307 98 77 155 3 2023591328 39953488 23489696
14:41:22 10743 8192000000 10969239696 11395809280 1974936800 19.425 99 63 126 0 2035615120 41310384 19367936
14:41:43 5592 8192000000 10988699312 11413299200 2010830384 19.708 100 68 136 0 2075762128 43385776 21545968
14:41:56 6634 8192000000 10979883776 11409059840 1990148608 19.545 99 66 132 2 2054428320 43015520 21264192
14:42:09 4115 8192000000 10984701760 11410608128 2006774928 19.676 100 63 126 1 2069781504 42537376 20469200
14:42:21 2728 8192000000 10988599776 11414466560 2009831344 19.700 100 62 124 0 2072905536 43341408 19732784
14:42:33 2316 8192000000 10986890656 11403968512 1987937424 19.527 99 81 160 1 2058028992 45107904 24983664
14:42:43 7521 8192000000 10985610000 11402809344 1991370688 19.555 100 75 148 3 2062203088 47422384 23410016
14:42:58 2123 8192000000 10995696224 11414450176 2008280032 19.688 100 88 175 0 2083688352 48650064 26758256
14:43:07 3534 8192000000 11007673952 11424641024 2014738976 19.739 100 81 161 0 2091002384 50207776 26055632
14:43:18 3958 8192000000 11021676416 11437563904 2019017696 19.772 100 83 166 2 2094925424 49793984 26113744
14:43:31 4287 8192000000 10999629712 11412942848 2004413760 19.658 100 88 175 1 2083096352 51287168 27395424
14:43:46 4502 8192000000 10960431728 11372429312 1969039520 19.378 98 80 157 2 2045834704 51982880 24812304
14:43:57 3348 8192000000 11007703808 11420766208 2006667072 19.675 100 84 169 0 2084582928 51559904 26355952
14:44:10 5463 8192000000 11001623568 11427647488 2011802048 19.716 100 75 148 3 2088006896 52438272 23766576
14:44:25 3161 8192000000 11003521264 11421155328 2004522416 19.658 100 80 159 3 2085607600 55492448 25592736
14:44:35 3086 8192000000 11006914736 11418390528 1988565440 19.532 99 89 179 3 2073391536 56301648 28524448
14:44:48 3788 8192000000 10969616368 11388837888 1964485488 19.342 99 82 160 0 2045826016 55947616 25392912
14:45:01 5437 8192000000 10963929888 11384545280 1967227328 19.363 99 83 168 0 2053601280 59918960 26454992
14:45:15 4333 8192000000 10957232944 11371053056 1955064288 19.267 99 78 156 1 2039561776 58918512 25578976
14:45:26 4937 8192000000 10983897216 11396120576 1974814464 19.424 100 78 158 1 2059892672 60081120 24997088
14:45:39 3285 8192000000 10980019552 11392933888 1975966928 19.433 100 90 179 2 2067152080 61847184 29337968
14:45:49 1729 8192000000 10997479440 11406671872 1982988192 19.488 100 85 170 1 2076271216 65945424 27337600
14:45:57 1837 8192000000 10994940112 11403137024 1979958064 19.464 100 88 175 0 2075315488 67187744 28169680
14:46:06 1873 8192000000 11004890944 11414085632 1974323632 19.420 99 90 180 1 2070550416 68018416 28208368
14:46:15 3072 8192000000 11001994240 11417030656 1988725904 19.534 100 85 170 0 2087085392 70787008 27572480
14:46:26 4902 8192000000 11001397936 11422191616 1986802208 19.519 100 67 134 0 2080182272 71309776 22070288
14:46:39 5848 8192000000 10999462896 11425800192 1986609024 19.517 100 61 120 0 2078255680 71550208 20096448
14:46:54 11739 8192000000 10977282752 11423363072 1982571808 19.485 100 46 92 1 2063875056 65717280 15585968
14:47:15 11254 8192000000 10981725520 11425198080 1988118432 19.529 100 47 94 2 2072023696 66889728 17015536
14:47:35 3713 8192000000 10980262352 11407872000 1979712464 19.462 100 54 108 2 2062105888 63575280 18818144
14:47:50 16828 8192000000 10939126304 11376349184 1933539632 19.095 98 49 98 1 2014128464 63530576 17058256
14:48:14 8746 8192000000 10949224112 11396227072 1942999184 19.171 99 46 90 1 2021676688 63194208 15483296
14:48:34 16871 8192000000 10956501280 11408465920 1974229648 19.419 100 38 76 0 2041985728 54750064 13006016
14:49:02 15880 8192000000 10929185808 11382095872 1934026800 19.099 98 27 54 3 1990736720 47353520 9356400
14:49:25 5234 8192000000 10927854256 11378597888 1955892016 19.273 100 33 66 2 2017651392 50417152 11342224
14:49:54 16341 8192000000 10918468848 11368730624 1926270144 19.037 99 30 60 2 1992793552 55064112 11459296
14:50:30 24488 8192000000 10897028432 11361583104 1905432768 18.870 98 35 70 3 1972228128 54671568 12123792
14:51:01 16305 8192000000 10894830720 11343622144 1906397376 18.878 99 24 48 2 1964440272 48993136 9049760
14:51:23 26827 8192000000 10877779872 11327836160 1880755088 18.671 98 24 48 1 1946390736 56235552 9400096
14:51:58 32823 8192000000 10886819488 11341877248 1912184080 18.924 100 26 52 2 1968464640 46513168 9767392
14:52:41 32122 8192000000 10878180256 11338080256 1911555936 18.919 100 14 28 0 1953426544 37147776 4722832
14:53:20 39539 8192000000 10847064640 11301695488 1875844832 18.632 97 27 54 3 1890229568 6752544 7632192
14:54:06 43418 8192000000 10837168944 11294076928 1874310448 18.619 97 40 77 2 1893200864 7908480 10981936
14:54:59 69626 8192000000 10871660944 11310817280 1921932176 19.002 100 18 36 2 1938023552 10207216 5884160
14:56:16 52786 8192000000 10844199376 11310686208 1888807488 18.736 98 16 32 1 1906805568 13105264 4892816
14:58:23 29393 8192000000 10887316784 11341590528 1957421888 19.286 100 37 74 2 1980053344 11195184 11436272
14:59:01 32705 8192000000 10893037040 11356659712 1969171216 19.379 100 19 38 3 1984193472 10048608 4973648
14:59:42 62724 8192000000 10925496880 11359006720 1946609248 19.199 98 49 97 0 1969076400 8962976 13504176
15:00:51 20275 8192000000 10886997888 11348373504 1949331344 19.221 99 31 62 1 1971022336 12965312 8725680
15:01:24 33199 8192000000 10925131920 11364769792 1969786384 19.384 100 25 50 0 1987910896 11314752 6809760
15:02:06 26407 8192000000 10925517072 11368472576 1977927120 19.448 100 46 92 1 2009802448 18727136 13148192
15:02:40 56286 8192000000 10892953360 11363127296 1937661472 19.128 98 16 32 2 1956833264 14341888 4829904
15:04:09 40124 8192000000 10887147168 11358171136 1959946880 19.306 99 11 22 0 1969732128 6651232 3134016
15:04:57 37241 8192000000 10887369232 11355635712 1950637392 19.232 99 17 34 1 1962648416 7173520 4837504
15:05:41 44708 8192000000 10891437712 11359215616 1968623632 19.375 100 16 32 0 1985647488 12419328 4604528
15:07:04 38900 8192000000 10891244144 11369918464 1961442080 19.318 99 14 28 0 1980946912 15074080 4430752
15:08:56 62377 8192000000 10898455824 11342958592 1945879328 19.194 98 32 66 1 1967148960 12258768 9010864
15:10:05 27931 8192000000 10881229392 11349479424 1950725696 19.232 99 16 32 0 1965133568 10074464 4333408
15:10:45 45439 8192000000 10877030032 11349905408 1939135440 19.140 98 18 36 0 1951135824 7266560 4733824
15:12:29 55914 8192000000 10904085200 11374469120 1973678880 19.415 100 10 20 0 1987123520 10791104 2653536
15:13:31 11209 8192000000 10911072544 11365634048 1968240608 19.371 99 39 78 1 1987627920 8490112 10897200
15:13:55 29579 8192000000 10916659872 11385651200 1985635424 19.509 100 32 64 2 2007338336 13042208 8660704
15:14:32 56502 8192000000 10926642160 11394670592 1993550176 19.572 100 14 28 3 2014792464 17123360 4118928
15:15:37 72186 8192000000 10943921248 11400785920 1979422320 19.460 99 20 40 1 2003494224 18448096 5623808
15:17:00 83629 8192000000 10922610272 11407880192 1975191552 19.427 99 12 24 0 1990908688 12556160 3160976
15:18:30 63911 8192000000 10904173392 11371446272 1915113920 18.948 96 18 34 1 1934414432 14736000 4564512
15:19:40 90700 8192000000 10917482352 11363704832 1906276208 18.877 96 18 36 0 1923820224 12792272 4751744
15:21:19 79065 8192000000 10877637104 11358052352 1884118640 18.698 95 22 44 1 1902624736 12071040 6435056
15:22:44 37705 8192000000 10923823616 11372986368 1937350784 19.126 98 30 57 1 1960697168 15770096 7576288
15:23:28 45985 8192000000 10892808736 11362807808 1936805312 19.121 98 33 66 2 1962450384 16066016 9579056
15:24:26 83012 8192000000 10879824784 11353403392 1907654176 18.888 97 16 32 0 1933264976 21318128 4292672
15:25:55 101032 8192000000 10890235088 11354750976 1946691392 19.200 99 28 54 0 1969754576 15052592 8010592
15:27:43 31346 8192000000 10919680944 11370057728 1980570368 19.469 100 48 94 1 2005511680 11727408 13213904
15:28:20 36210 8192000000 10859176944 11328294912 1938584448 19.135 98 33 66 2 1959409920 12022208 8803264
15:29:04 51024 8192000000 10864919808 11343065088 1920564768 18.991 98 10 20 0 1934128736 11130464 2433504
15:30:01 38019 8192000000 10849237616 11326271488 1892299104 18.764 97 8 16 0 1905590064 11399840 1891120
15:30:57 52738 8192000000 10858990480 11337519104 1905806864 18.873 98 6 12 0 1916992736 9832832 1353040
15:31:59 60608 8192000000 10851284016 11324473344 1855276816 18.465 95 21 42 2 1871025728 10344624 5404288
15:33:20 52287 8192000000 10845218048 11299942400 1795236016 17.975 92 9 18 0 1804877056 7355936 2285104
15:34:18 28517 8192000000 10829669968 11289972736 1863662640 18.533 97 23 46 1 1881585696 11474880 6448176
15:35:00 37052 8192000000 10875460992 11319963648 1888263408 18.732 98 27 53 3 1906747584 10684784 7799392
15:36:30 55680 8192000000 10885553712 11342221312 1921604144 19.000 99 28 54 1 1948969840 19317360 8048336
15:37:32 68425 8192000000 10866908592 11345346560 1905369776 18.869 98 15 31 0 1929335888 19310336 4655776
15:38:46 81638 8192000000 10861979680 11316318208 1874587200 18.621 97 13 26 1 1895487824 17403664 3496960
15:40:15 46935 8192000000 10866806368 11313786880 1866747104 18.558 97 24 48 0 1888026576 13873008 7406464
15:41:12 13425 8192000000 10882228000 11320152064 1933841744 19.098 100 47 95 1 1958335664 10549792 13944128
15:41:34 26636 8192000000 10881494272 11330437120 1938593120 19.136 100 44 88 0 1968586016 18041248 11951648
15:42:07 24387 8192000000 10875047216 11312062464 1886693472 18.719 97 52 104 1 1913867296 12673024 14500800
15:42:40 54076 8192000000 10867695056 11323924480 1917762400 18.969 99 41 82 3 1943364944 14494880 11107664
15:43:43 24766 8192000000 10875903056 11322142720 1917897328 18.970 99 29 58 3 1935074400 8984528 8192544
15:44:19 63596 8192000000 10865514048 11325726720 1879545920 18.661 97 19 37 4 1902376896 17555136 5275840
15:45:33 5409 8192000000 10889769632 11318996992 1927344144 19.046 99 75 152 3 1956279552 7173216 21762192
15:45:49 99697 8192000000 10895425376 11347288064 1948572480 19.215 100 51 102 0 1974282176 11379568 14330128
15:47:50 66358 8192000000 10884257248 11345575936 1954292656 19.261 100 25 50 0 1971977088 11006672 6677760
15:49:03 43886 8192000000 10881391280 11358539776 1959326864 19.301 100 45 90 1 1986571728 13996208 13248656
15:50:01 66657 8192000000 10857939056 11344388096 1911986576 18.923 98 9 18 0 1931670976 17263360 2421040
15:51:13 7853 8192000000 10858563632 11352993792 1938535264 19.135 100 4 8 0 1959487120 19877600 1074256
15:51:31 37409 8192000000 10866728736 11335380992 1950063792 19.227 100 12 24 2 1959974000 6653888 3256320
15:52:22 44006 8192000000 10891895232 11354341376 1960506272 19.310 100 30 60 1 1976881856 8301312 8074272
15:53:14 70073 8192000000 10891533792 11359891456 1970234736 19.387 100 12 22 1 1982905168 9443312 3227120
15:54:30 102393 8192000000 10886909936 11353546752 1935103952 19.108 98 36 70 2 1954405088 8801232 10499904
15:56:20 41819 8192000000 10870029264 11346825216 1945365632 19.190 99 26 52 3 1960708720 7978080 7365008
15:57:24 70074 8192000000 10885306928 11367874560 1948678032 19.216 99 14 29 0 1968957712 16650816 3628864
15:58:40 78783 8192000000 10883179136 11353505792 1895616608 18.791 96 11 22 5 1908418048 9696800 3104640
16:00:08 22284 8192000000 10894557136 11354816512 1933510000 19.095 98 26 52 1 1949414864 8878448 7026416
16:00:37 58474 8192000000 10884632016 11341987840 1890520272 18.750 96 16 32 2 1908986128 14052928 4412928
16:01:44 44874 8192000000 10875413008 11345928192 1917868880 18.970 98 22 44 2 1942757760 18320480 6568400
16:03:21 41974 8192000000 10883213856 11341778944 1934138192 19.100 99 22 44 0 1951507152 11318864 6050096
16:04:10 55556 8192000000 10914065312 11367739392 1943149056 19.172 99 15 30 0 1955025680 8138144 3738480
16:05:14 52424 8192000000 10882440464 11339743232 1872606064 18.605 95 35 70 1 1894539712 12740160 9193488
16:06:22 83089 8192000000 10878265184 11351355392 1934372704 19.102 99 16 32 1 1955075456 16246272 4456480
16:07:53 51654 8192000000 10904983472 11360468992 1944712800 19.184 99 20 40 1 1958386272 8211600 5461872
16:08:52 30504 8192000000 10907351280 11367751680 1955773808 19.272 99 38 76 0 1983442688 16966208 10702672
16:09:35 126892 8192000000 10864384544 11323502592 1788768656 17.922 91 9 18 0 1805458704 14347808 2342240
16:13:05 87875 8192000000 10827825424 11281711104 1837699168 18.322 94 26 51 2 1853141120 8870496 6571456
16:14:39 59391 8192000000 10861846912 11329552384 1907938240 18.890 98 33 66 0 1929726752 11724320 10064192
16:15:54 72441 8192000000 10845766992 11334123520 1899617056 18.823 98 7 14 0 1917746192 15807120 2322016
16:18:13 50905 8192000000 10875374240 11332825088 1936959296 19.122 100 14 27 3 1953254736 11646256 4649184
16:19:27 64328 8192000000 10881353792 11351052288 1955305552 19.269 100 25 50 2 1971382048 8873248 7203248
16:20:46 69427 8192000000 10865029776 11351613440 1901008624 18.834 97 10 20 2 1916315120 12465952 2840544
16:22:03 75385 8192000000 10878161680 11354808320 1890964752 18.754 97 15 30 1 1914469616 19418592 4086272
16:24:29 41415 8192000000 10879771936 11356774400 1951497632 19.238 100 11 22 1 1972829712 17765040 3567040
16:25:20 69660 8192000000 10854303440 11338158080 1853800304 18.453 95 11 22 1 1870632704 13583808 3248592
16:26:40 38163 8192000000 9301633696 9568960512 439819472 5.095 23 5 10 0 443072096 2263600 989024

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-12-2020 16:28:19 to 26-12-2020 16:28:51.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-12-2020 16:28:52 to 26-12-2020 16:28:54.

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          242443
MON$OLDEST_ACTIVE               242444
MON$OLDEST_SNAPSHOT             242444
MON$NEXT_TRANSACTION            242444
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                       2017408
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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