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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-04 19:27:18
DTS_END                         2021-02-04 19:27:18.0740
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/35576
TRN_ID                          247434
ATT_ID                          650
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: 9682.95 16610 1161954
customer order: creation 188.80 338 22656
customer order: refuse 15.70 326 1884
order to supplier: creation 48.76 1232 5851
order to supplier: removal 3.56 97197 427
invoice (draft): creation 49.56 3004 5947
invoice (draft): removal 53.32 863 6398
invoice accept: apply 45.24 15631 5429
invoice accept: cancel 47.98 747 5757
customer reserve: creation 4156.53 156 498784
customer reserve: removal 4760.72 57 571286
realization accept: apply 89.36 182 10723
realization accept: cancel 84.27 105 10112
payment from customer: creation 63.95 101 7674
payment from customer: removal 6.18 66 742
payment to supplier: creation 52.33 118 6280
payment to supplier: removal 3.74 65 449
service: total inventory turnovers 5.48 1086 657
service: total monetary turnovers 6.53 47 784
service: aggregate perf. data 0.92 21671 110
service: refresh index statistics 0.03 189209 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 04-02-2021 19:28:06 to 04-02-2021 19:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6699
TEST_TIME 2 6696
TEST_TIME 3 5626
TEST_TIME 4 5346
TEST_TIME 5 5527
TEST_TIME 6 5486
TEST_TIME 7 5404
TEST_TIME 8 5544
TEST_TIME 9 5690
TEST_TIME 10 5933
TEST_TIME 11 5786
TEST_TIME 12 5983
TEST_TIME 13 6437
TEST_TIME 14 6851
TEST_TIME 15 6904
TEST_TIME 16 7228
TEST_TIME 17 7294
TEST_TIME 18 7403
TEST_TIME 19 7916
TEST_TIME 20 8299
TEST_TIME 21 8792
TEST_TIME 22 8761
TEST_TIME 23 9072
TEST_TIME 24 10171
TEST_TIME 25 10722
TEST_TIME 26 10801
TEST_TIME 27 10612
TEST_TIME 28 11017
TEST_TIME 29 10819
TEST_TIME 30 10813
TEST_TIME 31 10638
TEST_TIME 32 10547
TEST_TIME 33 10555
TEST_TIME 34 10532
TEST_TIME 35 10510
TEST_TIME 36 10475
TEST_TIME 37 10538
TEST_TIME 38 10650
TEST_TIME 39 10631
TEST_TIME 40 10525
TEST_TIME 41 10497
TEST_TIME 42 10516
TEST_TIME 43 10369
TEST_TIME 44 10235
TEST_TIME 45 10205
TEST_TIME 46 10265
TEST_TIME 47 10089
TEST_TIME 48 10027
TEST_TIME 49 9965
TEST_TIME 50 9972
TEST_TIME 51 9907
TEST_TIME 52 10030
TEST_TIME 53 10078
TEST_TIME 54 10098
TEST_TIME 55 10031
TEST_TIME 56 9907
TEST_TIME 57 10048
TEST_TIME 58 10008
TEST_TIME 59 10027
TEST_TIME 60 10022
TEST_TIME 61 10004
TEST_TIME 62 10028
TEST_TIME 63 10057
TEST_TIME 64 10019
TEST_TIME 65 10018
TEST_TIME 66 10002
TEST_TIME 67 10088
TEST_TIME 68 10127
TEST_TIME 69 10199
TEST_TIME 70 10245
TEST_TIME 71 10183
TEST_TIME 72 10077
TEST_TIME 73 9988
TEST_TIME 74 10045
TEST_TIME 75 9955
TEST_TIME 76 9951
TEST_TIME 77 9908
TEST_TIME 78 9914
TEST_TIME 79 9867
TEST_TIME 80 9816
TEST_TIME 81 9760
TEST_TIME 82 9666
TEST_TIME 83 9657
TEST_TIME 84 9666
TEST_TIME 85 9622
TEST_TIME 86 9631
TEST_TIME 87 9654
TEST_TIME 88 9619
TEST_TIME 89 9687
TEST_TIME 90 9656
TEST_TIME 91 9708
TEST_TIME 92 9711
TEST_TIME 93 9731
TEST_TIME 94 9732
TEST_TIME 95 9709
TEST_TIME 96 9743
TEST_TIME 97 9864
TEST_TIME 98 9873
TEST_TIME 99 9881
TEST_TIME 100 9798
TEST_TIME 101 9751
TEST_TIME 102 9764
TEST_TIME 103 9742
TEST_TIME 104 9760
TEST_TIME 105 9741
TEST_TIME 106 9698
TEST_TIME 107 9671
TEST_TIME 108 9621
TEST_TIME 109 9591
TEST_TIME 110 9587
TEST_TIME 111 9595
TEST_TIME 112 9639
TEST_TIME 113 9610
TEST_TIME 114 9597
TEST_TIME 115 9660
TEST_TIME 116 9643
TEST_TIME 117 9702
TEST_TIME 118 9659
TEST_TIME 119 9671
TEST_TIME 120 9685

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-02-2021 19:28:10 to 04-02-2021 19:28:13.

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 1623727 1623727 0 0.00 0 28660 6 0 0
doc_list_biud 1623727 1623727 0 0.00 0 64919 26 0 0
sp_add_invoice_to_stock 5529 5429 100 1.80 23 159402 15631 0 100
sp_cancel_adding_invoice 5757 5757 0 0.00 4 58050 747 0 0
sp_cancel_client_order 1884 1884 0 0.00 3 8891 327 0 0
sp_cancel_customer_reserve 571286 571286 0 0.00 1 64922 57 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 3 5339 66 0 0
sp_cancel_pay_to_supplier 449 449 0 0.00 2 5229 65 0 0
sp_cancel_supplier_invoice 6408 6398 10 0.15 2 16327 863 0 10
sp_cancel_supplier_order 427 427 0 0.00 8 1172812 97197 0 0
sp_cancel_write_off 10112 10112 0 0.00 1 12065 106 0 0
sp_client_order 22656 22656 0 0.00 3 27681 338 0 0
sp_customer_reserve 498784 498784 0 0.00 0 117499 156 0 0
sp_fill_shopping_cart 34434 34434 0 0.00 1 13995 36 0 0
sp_fill_shopping_cart_clo_res 498782 498782 0 0.00 0 14598 11 0 0
sp_get_clo_for_invoice 5427 5427 0 0.00 0 26901 257 0 0
sp_kill_cost_storno 17060 17060 0 0.00 0 28646 54 0 0
sp_kill_qstorno_ret_qs2qd 1159509 1159509 0 0.00 0 64906 31 0 0
sp_kill_qty_storno 612014 612014 0 0.00 0 64919 68 0 0
sp_lock_selected_doc 22401 22401 0 0.00 0 8041 5 0 0
sp_make_cost_storno 30104 30104 0 0.00 0 15388 47 0 0
sp_multiply_rows_for_pdistr 30104 30104 0 0.00 0 7364 27 0 0
sp_multiply_rows_for_qdistr 22656 22656 0 0.00 0 14415 134 0 0
sp_pay_from_customer 7674 7674 0 0.00 4 11176 102 0 0
sp_pay_to_supplier 6280 6280 0 0.00 4 14551 118 0 0
sp_payment_common 13954 13954 0 0.00 1 11007 30 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 8839 297 0 0
sp_qd_handle_on_invoice_upd_sts 11184 11184 0 0.00 0 33560 293 0 0
sp_qd_handle_on_reserve_upd_sts 10723 10723 0 0.00 0 28610 66 0 0
sp_reserve_write_off 10723 10723 0 0.00 6 28637 182 0 0
sp_supplier_invoice 5947 5947 0 0.00 6 110751 3004 0 0
sp_supplier_order 5851 5851 0 0.00 5 37317 1233 0 0
srv_aggregate_perf_data 110 110 0 0.00 2477 443750 21671 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1663 191073 34424 0 0
srv_find_qd_qs_mism 1110307 1110307 0 0.00 0 18006 5 0 0
srv_make_invnt_saldo 657 657 0 0.00 31 77784 1087 0 0
srv_make_money_saldo 784 784 0 0.00 1 8872 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 104257 291974 189210 0 0
t$perf-abend:sp_add_invoice_to_stock 100 100 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5429 5429 0 0.00 0 32680 147 0 0
t$perf-norm:sp_cancel_adding_invoice 481 481 0 0.00 1 3269 70 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 3637 12 0 0
t$perf-norm:sp_cancel_customer_reserve 764 764 0 0.00 0 5004 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 1951 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 449 449 0 0.00 0 5501 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 1971 16 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 20439 1388 0 0
t$perf-norm:sp_cancel_write_off 1084 1084 0 0.00 0 10038 21 0 0
t$perf-norm:sp_client_order 22656 22656 0 0.00 0 8685 17 0 0
t$perf-norm:sp_customer_reserve 1122 1122 0 0.00 0 701 3 0 0
t$perf-norm:sp_pay_from_customer 7674 7674 0 0.00 0 4836 9 0 0
t$perf-norm:sp_pay_to_supplier 6280 6280 0 0.00 0 4918 11 0 0
t$perf-norm:sp_reserve_write_off 10723 10723 0 0.00 0 10046 10 0 0
t$perf-norm:sp_supplier_invoice 5947 5947 0 0.00 0 34270 20 0 0
t$perf-norm:sp_supplier_order 5851 5851 0 0.00 0 4831 15 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 86 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 296 6 0 0
t$perf-norm:srv_make_invnt_saldo 657 657 0 0.00 0 484 14 0 0
t$perf-norm:srv_make_money_saldo 784 784 0 0.00 0 1796 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11054 10854 200 1.80 0 5713 18 0 200
v_all_customers 41098 41098 0 0.00 0 17 1 0 0
v_all_suppliers 32696 32696 0 0.00 0 28 1 0 0
v_all_wares 45312 45312 0 0.00 0 24 1 0 0
v_cancel_adding_invoice 962 962 0 0.00 0 2386 13 0 0
v_cancel_client_order 3768 3768 0 0.00 0 3411 5 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 3628 8 0 0
v_cancel_customer_reserve 1528 1528 0 0.00 0 3779 5 0 0
v_cancel_payment_to_supplier 898 898 0 0.00 0 2853 5 0 0
v_cancel_supplier_invoice 860 840 20 2.32 0 3205 18 0 20
v_cancel_supplier_order 854 854 0 0.00 0 3208 14 0 0
v_cancel_write_off 2168 2168 0 0.00 0 3758 17 0 0
v_max_id_clo_ord 5851 5851 0 0.00 0 1814 1 0 0
v_max_id_clo_res 1122 1122 0 0.00 0 3388 16 0 0
v_max_id_ord_sup 5926 5926 0 0.00 0 2234 2 0 0
v_max_non_paid_invoice 1709 1709 0 0.00 0 2920 5 0 0
v_max_non_paid_realizn 4086 4086 0 0.00 0 2769 4 0 0
v_min_id_clo_ord 5851 5851 0 0.00 0 2288 4 0 0
v_min_id_clo_res 1122 1122 0 0.00 0 5584 6 0 0
v_min_id_ord_sup 5926 5926 0 0.00 0 6990 9 0 0
v_min_non_paid_invoice 6280 6280 0 0.00 0 8773 18 0 0
v_min_non_paid_realizn 7674 7674 0 0.00 0 11001 21 0 0
v_our_firm 11390 11390 0 0.00 0 12 1 0 0
v_reserve_write_off 21446 21446 0 0.00 0 5162 7 0 0
x_lock_depdocs_on_canc_invoice 11735 11735 0 0.00 0 13429 103 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 3131 255 0 0
x_make_qstorno_1000_1200 5851 5851 0 0.00 2 37304 1165 0 0
x_make_qstorno_1200_2000 5947 5947 0 0.00 3 110731 2862 0 0
x_make_qstorno_2100_3300 498784 498784 0 0.00 0 117498 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-02-2021 19:28:15 to 04-02-2021 19:28:19.

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
16:57:21 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:28 25913 8192000000 10288794704 10600513536 958129392 10.471 73 59 116 1 979706144 2694704 18882048
16:58:01 37161 8192000000 10364123328 10681774080 1406646976 14.654 100 90 180 0 1441688176 5792480 29248720
16:58:56 27254 8192000000 10405164416 10731319296 1456706848 15.097 100 95 190 1 1495375696 7658928 31009920
16:59:32 38819 8192000000 10431957232 10762850304 1481699616 15.316 100 89 178 0 1519428960 8620704 29108640
17:00:22 27689 8192000000 10455805952 10789920768 1499923392 15.476 100 89 177 1 1537743264 9334080 28485792
17:01:04 15817 8192000000 10466448816 10805977088 1520851136 15.658 100 91 182 1 1559500448 10022288 28627024
17:01:30 17670 8192000000 10475001088 10818936832 1536188208 15.791 100 84 166 3 1572397392 10396704 25812480
17:01:58 19440 8192000000 10493098064 10843271168 1556648352 15.967 100 79 158 0 1591859936 10530544 24681040
17:02:32 15461 8192000000 10542405728 10895405056 1594971952 16.296 100 79 158 0 1629492672 10921424 23599296
17:02:56 10601 8192000000 10556178336 10907656192 1609900992 16.424 100 89 178 1 1648358256 11193360 27263904
17:03:18 7305 8192000000 10565730032 10929967104 1622659696 16.533 100 71 142 1 1655378368 11748128 20970544
17:03:33 14504 8192000000 10593484384 10957680640 1651423200 16.776 100 75 150 0 1685909088 12214160 22271728
17:03:57 9375 8192000000 10624032000 10993823744 1679889728 17.016 100 81 162 3 1716296272 13044592 23361952
17:04:15 12165 8192000000 10644592448 11016175616 1706211280 17.237 100 80 161 0 1741854896 12636144 23007472
17:04:35 9693 8192000000 10658990272 11031687168 1713696768 17.300 100 81 162 1 1750207792 13619104 22891920
17:04:53 6140 8192000000 10655840160 11032727552 1724857840 17.393 100 73 146 0 1758697472 13226480 20613152
17:05:06 6192 8192000000 10666956720 11044659200 1732316976 17.455 100 76 152 1 1767004032 13076416 21610640
17:05:20 4645 8192000000 10687165168 11061186560 1741270704 17.529 100 82 164 1 1777430368 13286816 22872848
17:05:32 4192 8192000000 10677516384 11061506048 1748423360 17.589 100 64 128 1 1778807728 12695584 17688784
17:05:42 5740 8192000000 10701760832 11082743808 1767917280 17.750 100 85 170 3 1804555424 13000368 23637776
17:05:54 10432 8192000000 10707178480 11091091456 1773066576 17.792 100 77 152 2 1807732976 13296912 21369488
17:06:13 4301 8192000000 10740960304 11117957120 1782013696 17.866 100 73 148 0 1815321824 12525824 20782304
17:06:24 3342 8192000000 10741080992 11124113408 1800850144 18.021 100 76 149 1 1834291296 12408848 21032304
17:06:34 3888 8192000000 10751072368 11132432384 1809125408 18.089 100 80 160 0 1844959104 12292112 23541584
17:06:45 2513 8192000000 10761049008 11145482240 1814839296 18.135 100 79 158 0 1849699840 12102000 22758544
17:06:55 2874 8192000000 10767579120 11148865536 1826624832 18.232 100 82 165 2 1861709440 12537680 22546928
17:07:04 3035 8192000000 10774926048 11162750976 1833632416 18.289 100 81 162 0 1868862896 12629696 22600784
17:07:14 2191 8192000000 10772204400 11160571904 1838799584 18.331 100 93 186 1 1879033008 13343472 26889952
17:07:23 3218 8192000000 10784323008 11170148352 1839156112 18.334 100 86 172 0 1876422016 12608288 24657616
17:07:32 2501 8192000000 10789950320 11175407616 1846695840 18.395 100 86 170 0 1882784832 12275568 23813424
17:07:41 2197 8192000000 10795397664 11183398912 1855911136 18.470 100 89 179 1 1892874512 12031248 24932128
17:07:50 3724 8192000000 10801684608 11186388992 1856029376 18.471 100 85 170 1 1893227952 13269840 23928736
17:08:01 2472 8192000000 10803322400 11194138624 1859543200 18.500 100 89 176 0 1897625984 13210032 24872752
17:08:09 2235 8192000000 10802834864 11193356288 1861968816 18.519 100 91 183 5 1901135728 13348912 25818000
17:08:18 1583 8192000000 10803404576 11192774656 1862713808 18.525 100 86 171 1 1899462992 12749664 23999520
17:08:26 1562 8192000000 10811535040 11200217088 1865053344 18.544 100 90 181 1 1904187792 13888800 25245648
17:08:35 1981 8192000000 10814596480 11200667648 1869962704 18.584 100 90 180 2 1908779152 12545168 26271280
17:08:43 3022 8192000000 10809585168 11204128768 1871097008 18.593 100 83 165 0 1907002544 12620752 23284784
17:08:53 15076 8192000000 10813133280 11209478144 1871619920 18.597 100 66 132 1 1901912016 11854544 18437552
17:09:16 13837 8192000000 10810966080 11210276864 1873538256 18.613 100 72 145 0 1905622992 11661840 20422896
17:09:36 2371 8192000000 10828201008 11217731584 1881227152 18.675 100 93 182 0 1920094608 12704640 26162816
17:09:44 1235 8192000000 10812476304 11212898304 1877257488 18.643 100 69 138 1 1907997856 12021392 18718976
17:09:52 2107 8192000000 10799459376 11212836864 1875761376 18.631 100 53 106 0 1902508944 11813776 14933792
17:10:01 3754 8192000000 10800801616 11215167488 1878682032 18.654 100 47 95 2 1902140992 10023504 13435456
17:10:12 2904 8192000000 10797188064 11216105472 1881803984 18.680 100 58 114 3 1907523824 8945744 16774096
17:10:22 4277 8192000000 10804476048 11218264064 1882491232 18.685 100 50 101 2 1904958048 8138416 14328400
17:10:38 6319 8192000000 10787427616 11217465344 1879406368 18.660 100 24 49 1 1893010272 6754576 6849328
17:10:54 4749 8192000000 10799762944 11220672512 1887689984 18.727 100 39 78 1 1910782512 10937136 12155392
17:11:05 7637 8192000000 10797503632 11220992000 1884536752 18.702 100 19 36 1 1895652144 5945456 5169936
17:11:20 6812 8192000000 10790477072 11222843392 1889294576 18.740 100 19 38 1 1900807552 6150672 5362304
17:11:37 12802 8192000000 10806593520 11234009088 1898934400 18.818 100 29 58 2 1913416192 6254416 8227376
17:11:58 60335 8192000000 10805617360 11239473152 1890872976 18.753 100 20 41 2 1905455312 9105920 5476416
17:13:05 5758 8192000000 10814630960 11246043136 1897931472 18.810 100 32 64 1 1913833056 6956848 8944736
17:13:20 5639 8192000000 10819900208 11251523584 1899820480 18.825 100 25 49 0 1917798672 11298576 6679616
17:13:32 5871 8192000000 10828973760 11255377920 1906409328 18.878 100 37 74 1 1926403072 10553024 9440720
17:13:45 5441 8192000000 10822930912 11250778112 1904468080 18.862 100 36 73 3 1920396480 5625120 10303280
17:13:58 7924 8192000000 10820478160 11249528832 1901146304 18.836 100 16 32 0 1912124208 5803824 5174080
17:14:13 7060 8192000000 10819393232 11252830208 1906155712 18.876 100 27 52 0 1919626368 5720128 7750528
17:14:26 7101 8192000000 10820893760 11253854208 1904841616 18.865 100 23 47 2 1917464768 5744544 6878608
17:14:40 8834 8192000000 10818372688 11254026240 1904610608 18.863 100 21 42 0 1916411936 5783648 6017680
17:14:55 5843 8192000000 10822516928 11256139776 1904403472 18.862 100 20 40 2 1916270928 6338240 5529216
17:15:07 7101 8192000000 10824777872 11259908096 1906787568 18.881 100 18 36 2 1917774736 5675024 5312144
17:15:23 11025 8192000000 10829177440 11260579840 1909125296 18.900 100 16 32 2 1918757360 4852816 4779248
17:15:41 4873 8192000000 10832151424 11267440640 1915524896 18.951 100 29 58 2 1929839424 5534416 8780112
17:15:54 7983 8192000000 10828081392 11266502656 1917593632 18.968 100 17 34 2 1928987056 5953200 5440224
17:16:08 13861 8192000000 10826848048 11261915136 1899492112 18.822 99 22 44 1 1911334016 5752880 6089024
17:16:28 66681 8192000000 10818581104 11248402432 1877470528 18.645 98 40 78 2 1894567776 5850256 11246992
17:17:41 3982 8192000000 10820527504 11256492032 1905184496 18.868 100 19 38 1 1916764672 6565904 5014272
17:17:51 5814 8192000000 10789878416 11221385216 1868194096 18.570 99 34 68 0 1883882480 6524256 9164128
17:18:04 7657 8192000000 10753715088 11179122688 1779047920 17.842 95 26 52 0 1792124032 5214384 7861728
17:18:20 5841 8192000000 10780771120 11191889920 1806873344 18.070 97 33 67 3 1823183440 6536832 9773264
17:18:35 4355 8192000000 10733017488 11147419648 1776881984 17.824 96 29 58 0 1791550016 6757568 7910464
17:18:45 4799 8192000000 10750723760 11172462592 1834201568 18.294 100 29 58 1 1848546208 6743408 7601232
17:18:56 8566 8192000000 10753687488 11181867008 1813928160 18.128 98 23 46 1 1826957232 6119168 6909904
17:19:11 7997 8192000000 10759698304 11172757504 1797591568 17.994 97 29 56 3 1811035232 5590256 7853408
17:19:30 12022 8192000000 10741319728 11159674880 1776987728 17.825 97 24 48 1 1788743936 4925616 6830592
17:19:52 9024 8192000000 10719558384 11145551872 1740624272 17.524 95 21 42 3 1752741296 5696208 6420816
17:20:13 6999 8192000000 10708541936 11124609024 1740926640 17.526 96 21 42 1 1752683472 5888592 5868240
17:20:31 14746 8192000000 10651943056 11051769856 1630122304 16.596 92 19 38 1 1641289376 4550608 6616464
17:20:53 11182 8192000000 10692478960 11112017920 1768312128 17.753 99 23 46 1 1780772032 5385088 7074816
17:21:10 18833 8192000000 10671176992 11096756224 1692033232 17.118 94 38 76 0 1709721456 6193312 11494912
17:22:02 36820 8192000000 10692945360 11110998016 1670753440 16.940 93 21 41 1 1681662944 4971312 5938192
17:22:45 6068 8192000000 10715869744 11123896320 1792931360 17.956 100 25 50 1 1805903392 6316400 6655632
17:22:59 7891 8192000000 10730340912 11148271616 1797665056 17.995 99 35 70 1 1813812272 6637952 9509264
17:23:14 8799 8192000000 10731504240 11154993152 1818033360 18.162 100 23 44 1 1829697744 5046512 6617872
17:23:31 4538 8192000000 10755606608 11172245504 1831532896 18.272 100 35 70 1 1848444928 6989824 9922208
17:23:43 8680 8192000000 10761065664 11184095232 1840781504 18.347 100 23 46 1 1853122432 5643168 6697760
17:23:57 12892 8192000000 10751927344 11181428736 1841585888 18.354 100 22 44 2 1854251648 5649408 7016352
17:24:17 5668 8192000000 10757191648 11179737088 1839941456 18.340 100 25 49 4 1852975504 5449024 7585024
17:24:31 9581 8192000000 10766529872 11191185408 1848762576 18.412 100 30 60 1 1863165392 5086864 9315952
17:24:47 12587 8192000000 10777977568 11197001728 1852592432 18.443 100 27 53 2 1866574208 6094352 7887424
17:25:08 8387 8192000000 10763934592 11200741376 1858505088 18.491 100 21 42 2 1874481520 9999520 5976912
17:25:26 14258 8192000000 10765030784 11201716224 1861323456 18.514 100 29 56 3 1875163008 5470656 8368896
17:25:47 8047 8192000000 10775830880 11209248768 1869206016 18.578 100 24 48 3 1882145392 5802896 7136480
17:26:01 19956 8192000000 10779190400 11214557184 1871487952 18.596 100 23 45 1 1884215648 5507248 7220448
17:26:39 46458 8192000000 10798573088 11229753344 1882292368 18.684 100 37 74 1 1898727984 5660272 10775344
17:27:35 35925 8192000000 10832994928 11252006912 1900893312 18.833 100 44 87 1 1919483648 5685344 12904992
17:28:20 5251 8192000000 10842560016 11263336448 1914518704 18.943 100 61 120 2 1941945088 10314976 17111408
17:28:34 9905 8192000000 10849819536 11273293824 1919299296 18.981 100 53 105 1 1945845328 11883008 14663024
17:28:51 10691 8192000000 10862208864 11281653760 1926180928 19.036 100 63 126 3 1956234304 11822496 18230880
17:29:15 8072 8192000000 10860056160 11287453696 1927903584 19.050 100 53 106 0 1955542672 12364800 15274288
17:29:30 19595 8192000000 10862751056 11292299264 1934708304 19.105 100 48 95 1 1961013616 12202304 14103008
17:29:58 25479 8192000000 10867926608 11302830080 1937399200 19.126 100 37 73 2 1957891200 10210320 10281680
17:30:34 17830 8192000000 10889181376 11316649984 1950790400 19.233 100 49 98 0 1979645744 14389888 14465456
17:31:00 8388 8192000000 10898654048 11324203008 1957705920 19.288 100 55 110 0 1988886592 15705712 15474960
17:31:16 25528 8192000000 10905115056 11333754880 1959572720 19.303 100 48 96 0 1993178464 19013040 14592704
17:31:52 8176 8192000000 10909950672 11338604544 1963842800 19.337 100 52 104 1 2000157040 20979216 15335024
17:32:10 19820 8192000000 10916574960 11343773696 1970697408 19.391 100 58 116 0 2005832448 18014176 17120864
17:32:42 17256 8192000000 10920690880 11355480064 1976893728 19.440 100 56 110 0 2015602288 22266880 16441680
17:33:09 12360 8192000000 10919273504 11355049984 1978452912 19.452 100 49 93 3 2012954480 20684560 13817008
17:33:31 26713 8192000000 10933355056 11372683264 1984031008 19.497 100 43 86 0 2018271408 21348560 12891840
17:34:13 22035 8192000000 10943618864 11379933184 1995655424 19.588 100 46 92 2 2036186048 25716448 14814176
17:34:52 17852 8192000000 10939045456 11385294848 1994529360 19.580 100 32 64 0 2032912976 28134896 10248720
17:35:26 10216 8192000000 10951180416 11390164992 1999537360 19.619 100 37 74 2 2039845344 28268480 12039504
17:35:50 8702 8192000000 10960582848 11396587520 2004167008 19.656 100 48 96 1 2048789920 29179024 15443888
17:36:10 12397 8192000000 10960296592 11401625600 2007810800 19.684 100 46 92 0 2050830528 29063840 13955888
17:36:33 16108 8192000000 10974651488 11404341248 1995430432 19.587 99 55 106 0 2041349984 30157936 15761616
17:36:57 10524 8192000000 10967769584 11401211904 1993130768 19.569 99 54 108 0 2041063504 31466032 16466704
17:37:18 7038 8192000000 10983739376 11411869696 2012994880 19.725 100 57 114 1 2064454688 33246624 18213184
17:37:33 12011 8192000000 10978889776 11420512256 2018488384 19.768 100 47 94 2 2067562880 34301936 14772560
17:37:54 7424 8192000000 10988225552 11424645120 2021506176 19.792 100 53 106 1 2071761664 33727104 16528384
17:38:16 3022 8192000000 10985231136 11421908992 2025161648 19.821 100 55 111 0 2076050112 34629648 16258816
17:38:26 5026 8192000000 10995584320 11430244352 2026861664 19.834 100 61 122 0 2083002752 37467904 18673184
17:38:38 4432 8192000000 11010007728 11437174784 2034091248 19.891 100 85 168 0 2098339760 38244592 26003920
17:38:51 4210 8192000000 11009738832 11438358528 2036340016 19.908 100 78 155 1 2099143248 39505440 23297792
17:39:02 3767 8192000000 11014275744 11443458048 2037173360 19.915 100 78 154 1 2102152144 41649424 23329360
17:39:13 4510 8192000000 11029919072 11449167872 2041882048 19.952 100 89 177 0 2111531856 42797888 26851920
17:39:26 4176 8192000000 11024221328 11451265024 2040925200 19.944 100 78 156 1 2107711392 43135120 23651072
17:39:40 2923 8192000000 11000673728 11427536896 2006022032 19.670 99 80 161 3 2072842512 43131104 23689376
17:39:51 2288 8192000000 11009730960 11430862848 2024128832 19.813 100 81 162 2 2092943824 44340608 24474384
17:40:01 2168 8192000000 11009865024 11430256640 2024198592 19.813 100 83 165 1 2095194880 45625056 25371232
17:40:10 2541 8192000000 11001701312 11421749248 2016241120 19.751 100 88 171 1 2086823392 44896032 25686240
17:40:19 2929 8192000000 10991558688 11413000192 1994771216 19.581 99 86 171 1 2067360976 46265216 26324544
17:40:30 3618 8192000000 10989297664 11411488768 2001517680 19.635 100 74 148 0 2072953360 48367728 23067952
17:40:42 2257 8192000000 10989179888 11415396352 1991364832 19.555 99 78 156 0 2064080384 47890224 24825328
17:40:52 3825 8192000000 10986764800 11407151104 2000870672 19.630 100 78 153 1 2070192288 46400016 22921600
17:41:08 2930 8192000000 10990702944 11422048256 2011022576 19.710 100 73 144 1 2079446688 45854048 22570064
17:41:17 3170 8192000000 10985690224 11407831040 1996377248 19.594 99 89 179 0 2069801312 46550144 26873920
17:41:28 1663 8192000000 11004274224 11425853440 2011605424 19.714 100 80 160 2 2085636992 48411424 25620144
17:41:37 3248 8192000000 10978550704 11400904704 1989449648 19.539 100 79 156 1 2065480224 51316384 24714192
17:41:48 4103 8192000000 10990201520 11410354176 1994195440 19.577 100 79 158 1 2070002400 51456416 24350544
17:41:59 3730 8192000000 10971659520 11394637824 1982395872 19.484 100 75 149 0 2055956240 50067616 23492752
17:42:11 5916 8192000000 10974921264 11406422016 1988474416 19.532 100 63 126 0 2059022832 51518544 19029872
17:42:27 8745 8192000000 10971165088 11405062144 1992667312 19.565 100 64 128 1 2061620112 48870816 20081984
17:42:50 3083 8192000000 10994793296 11410800640 1997738896 19.605 100 84 165 1 2075228480 51085088 26404496
17:43:00 5059 8192000000 10994949168 11414147072 2002270720 19.641 100 74 148 2 2075570976 50721216 22579040
17:43:15 3316 8192000000 10994603312 11425173504 2007750448 19.684 100 71 143 1 2083310640 51475744 24084448
17:43:28 3714 8192000000 11002532544 11425038336 2008790688 19.692 100 73 146 1 2078733024 47299056 22643280
17:43:39 1796 8192000000 11004474736 11426025472 2014315232 19.735 100 82 164 1 2087255552 47367040 25573280
17:43:48 6953 8192000000 10972761280 11402575872 1980524688 19.469 99 73 146 0 2051219344 48313200 22381456
17:44:09 8273 8192000000 10991280480 11421024256 2006735184 19.676 100 69 136 1 2079793376 51357616 21700576
17:44:26 1661 8192000000 10986818080 11413069824 1990188352 19.545 99 70 140 1 2065034576 52737440 22108784
17:44:34 2474 8192000000 11015549600 11432501248 2016718624 19.754 100 75 150 0 2095477856 54956480 23802752
17:44:47 5959 8192000000 11007408016 11428102144 1995452000 19.587 99 75 150 1 2073182496 54211136 23519360
17:45:00 12541 8192000000 10982738624 11427545088 2002289952 19.641 100 45 90 0 2070196528 52693648 15212928
17:45:20 10415 8192000000 10983760880 11424182272 2002610016 19.643 100 47 92 0 2065190016 48017760 14562240
17:45:38 2872 8192000000 10975890928 11406307328 1976515808 19.437 99 60 119 0 2048309792 52544192 19249792
17:45:50 5288 8192000000 10961545632 11383054336 1952849120 19.249 98 69 140 0 2028705888 53951120 21905648
17:46:03 2223 8192000000 10968406000 11380269056 1957176304 19.284 99 76 152 0 2037931744 56001136 24754304
17:46:12 3423 8192000000 10948327824 11359723520 1942161584 19.164 98 74 144 3 2022504720 57292784 23050352
17:46:23 8485 8192000000 10930047280 11371913216 1948714752 19.216 100 55 111 0 2021704400 54417168 18572480
17:46:40 17125 8192000000 10902052528 11335991296 1897323984 18.805 97 38 76 1 1963190848 52928896 12937968
17:47:04 18304 8192000000 10929971008 11368742912 1951237776 19.236 100 36 72 2 2017521424 53455952 12827696
17:47:36 4456 8192000000 10943675568 11373449216 1941758656 19.161 99 56 111 0 2015431408 55365552 18307200
17:47:46 8018 8192000000 10930710352 11375775744 1938417072 19.134 99 42 83 1 2009459536 55547232 15495232
17:48:06 15354 8192000000 10915323792 11351961600 1932307200 19.085 99 38 74 2 1998025184 52540352 13177632
17:48:33 20452 8192000000 10890109760 11338489856 1906615968 18.879 98 34 68 1 1968001184 49550656 11834560
17:49:10 4663 8192000000 10905858768 11345952768 1914536032 18.943 99 52 104 0 1980820960 48349648 17935280
17:49:24 14283 8192000000 10933426496 11371180032 1952350688 19.245 100 53 104 1 2020393072 50676768 17365616
17:50:07 22621 8192000000 10913064256 11362664448 1918823120 18.977 99 34 68 0 1991978032 60550928 12603984
17:50:49 14581 8192000000 10913659280 11371585536 1933678784 19.096 100 25 50 0 2003107136 60253440 9174912
17:51:10 39651 8192000000 10887715072 11342557184 1914466960 18.942 99 24 48 0 1981557280 58669856 8420464
17:52:11 40544 8192000000 10847581680 11309223936 1845878288 18.389 96 25 50 0 1896012464 41396672 8737504
17:52:58 28722 8192000000 10833832256 11276517376 1865499488 18.548 98 31 60 0 1899938096 24946400 9492208
17:53:51 26235 8192000000 10853923312 11301318656 1914343440 18.941 100 30 60 1 1940697392 17453008 8900944
17:54:24 33811 8192000000 10858637280 11314257920 1901412304 18.838 99 29 58 2 1931286416 21373696 8500416
17:55:05 27044 8192000000 10844495728 11324354560 1894156544 18.779 99 7 14 1 1922409440 25803136 2449760
17:55:38 71797 8192000000 10842248240 11277918208 1799267408 18.008 94 23 42 4 1813855488 8965216 5622864
17:56:59 58110 8192000000 10850846144 11308412928 1903890896 18.858 99 16 33 2 1917459856 9615344 3953616
17:58:04 122843 8192000000 10872764064 11336261632 1919596480 18.984 99 11 22 0 1932930272 10772432 2561360
18:00:14 144521 8192000000 10877884832 11346206720 1872052016 18.601 96 10 20 0 1886644080 12201712 2390352
18:02:45 79358 8192000000 10901058992 11356860416 1897554912 18.807 97 13 25 0 1916646800 15487104 3604784
18:04:21 191050 8192000000 10885853328 11348832256 1904876208 18.865 97 7 14 0 1918983904 12600608 1507088
18:07:39 24001 8192000000 10888691424 11342733312 1920829312 18.993 98 10 20 2 1929743168 6776432 2137424
18:08:12 52362 8192000000 10917181152 11369709568 1966007264 19.354 100 13 26 2 1977385568 7850400 3527904
18:09:16 46690 8192000000 10897562048 11358580736 1915187472 18.948 97 20 40 0 1933305552 12357984 5760096
18:10:10 110572 8192000000 10930596656 11375022080 1969511824 19.382 100 32 64 3 1993946096 15263040 9171232
18:12:07 42856 8192000000 10918810384 11377983488 1961391216 19.317 99 30 60 0 1978550272 8326480 8832576
18:12:56 34927 8192000000 10927004224 11376340992 1960757632 19.312 99 49 97 3 1985208880 10797776 13653472
18:13:39 123189 8192000000 10883613744 11351076864 1898407280 18.813 96 12 24 1 1910017424 8348560 3261584
18:15:49 27509 8192000000 10906095712 11369472000 1959854784 19.305 99 31 61 2 1982933696 13673200 9405712
18:16:28 30757 8192000000 10910106336 11370508288 1940736224 19.153 98 27 53 1 1969045200 20282640 8026336
18:17:05 55327 8192000000 10930501200 11395571712 1992689824 19.565 100 45 91 2 2023945024 17709472 13545728
18:18:07 63218 8192000000 10923952304 11398815744 1966856928 19.361 99 20 38 2 1995411920 21893408 6661584
18:19:16 14606 8192000000 10917271392 11400105984 1978170256 19.450 100 11 22 1 2005274144 23388128 3715760
18:20:03 45389 8192000000 10899247360 11374469120 1958737824 19.296 99 11 22 0 1976637072 14327520 3571728
18:20:55 49996 8192000000 10908631648 11394363392 1966421440 19.357 99 8 16 0 1979690880 11071216 2198224
18:21:51 49565 8192000000 10907660864 11383672832 1951534768 19.239 98 18 36 1 1972087456 15289968 5262720
18:24:07 45259 8192000000 10908440368 11388293120 1942401056 19.166 98 9 18 0 1963702496 18755456 2545984
18:25:01 92440 8192000000 10870593712 11340427264 1864294080 18.538 94 14 28 0 1885248112 16914720 4039312
18:26:44 37031 8192000000 10873428560 11332915200 1861779200 18.518 95 44 89 0 1883059904 8815904 12464800
18:27:28 39378 8192000000 10855561040 11324968960 1892149024 18.763 97 34 68 1 1911928288 10058704 9720560
18:28:14 57416 8192000000 10875868288 11334791168 1853727104 18.452 95 18 36 1 1867997840 9476512 4794224
18:29:20 31710 8192000000 10886315872 11355250688 1935268752 19.109 99 21 42 1 1951601216 10592960 5739504
18:30:02 20809 8192000000 10892467056 11344707584 1928758272 19.057 98 48 96 2 1952156448 9031632 14366544
18:30:33 42658 8192000000 10882053216 11357949952 1936625216 19.120 99 18 36 0 1951839232 10404320 4809696
18:31:27 40137 8192000000 10906641008 11363201024 1934063360 19.099 98 32 64 0 1950252752 7895904 8293488
18:32:17 44135 8192000000 10912548960 11372613632 1913506736 18.935 97 26 52 1 1931398656 10817056 7074864
18:33:14 65172 8192000000 10896640560 11372421120 1922382528 19.006 98 16 31 1 1949809568 22866848 4560192
18:34:33 112645 8192000000 10852573536 11332132864 1721863152 17.368 88 15 30 1 1741486016 15557024 4065840
18:36:33 117950 8192000000 10866285072 11340316672 1861387376 18.515 97 12 24 0 1879280672 14943648 2949648
18:38:46 117810 8192000000 10862895872 11326640128 1892133680 18.763 98 33 64 2 1911827776 9662560 10031536
18:40:54 99864 8192000000 10846365792 11307757568 1818632800 18.167 94 13 26 1 1839953088 18183600 3136688
18:42:40 27788 8192000000 10876488016 11334754304 1941425344 19.158 100 34 68 2 1958741616 7984688 9331584
18:43:14 32204 8192000000 10889699968 11347714048 1947915456 19.210 100 50 100 1 1976796144 14074288 14806400
18:44:09 128960 8192000000 10849591232 11337469952 1827782400 18.241 94 8 16 1 1844921808 14868000 2271408
18:46:25 58762 8192000000 10835427696 11318247424 1867629968 18.565 97 12 24 0 1879407920 8399744 3378208
18:47:32 26985 8192000000 10828807296 11305574400 1887756736 18.728 98 6 12 0 1896313072 6862560 1693776
18:48:17 38066 8192000000 10827224544 11304513536 1904328256 18.861 99 13 26 0 1915229568 6983712 3917600
18:49:28 60280 8192000000 10843942176 11336290304 1920601776 18.992 100 12 24 1 1930654320 6897616 3154928
18:50:39 25735 8192000000 10863471712 11344666624 1940502480 19.151 100 9 18 0 1949025184 6510496 2012208
18:51:11 71874 8192000000 10867466896 11337494528 1885521120 18.710 97 9 18 0 1896843408 8923248 2399040
18:52:31 23301 8192000000 10873921648 11350298624 1946784544 19.201 100 23 46 0 1960391568 7430672 6176352
18:53:06 45101 8192000000 10879346624 11360313344 1950049888 19.227 100 18 36 1 1964696272 9588592 5057792
18:54:04 73812 8192000000 10885509312 11366502400 1925920896 19.034 98 17 34 0 1944698544 14024016 4753632
18:55:24 48751 8192000000 10898646304 11375169536 1951025184 19.235 99 36 72 1 1975736448 14300304 10410960
18:56:23 69948 8192000000 10901423856 11374706688 1945121344 19.188 99 15 30 1 1967749792 18068256 4560192
18:57:40 57516 8192000000 10884252576 11359170560 1931411088 19.078 98 15 30 0 1951016784 15244944 4360752
18:58:48 21194 8192000000 10912870064 11376656384 1960243040 19.308 99 38 76 1 1982458944 12088640 10127264
18:59:17 23145 8192000000 10915946960 11384832000 1963143104 19.331 99 29 58 1 1979676112 8590720 7942288
18:59:52 41564 8192000000 10913183344 11388813312 1947826000 19.209 98 26 53 2 1962456272 7989520 6640752
19:00:39 38697 8192000000 10916981248 11389247488 1949558128 19.223 98 37 74 1 1968843312 8848640 10436544
19:01:30 34197 8192000000 10938797824 11400699904 1967205200 19.363 99 34 67 1 1985753104 9226352 9321552
19:02:11 45225 8192000000 10941779024 11421081600 1998954592 19.614 100 36 72 0 2022404064 13715696 9733776
19:03:04 108669 8192000000 10926026864 11427840000 1953000064 19.250 98 12 24 1 1984953136 27951280 4001792
19:05:01 135201 8192000000 10886030784 11378106368 1886602208 18.718 95 4 8 0 1901862656 14392576 867872
19:07:29 84542 8192000000 10915739888 11392622592 1941316320 19.157 98 23 47 1 1956031936 7736272 6979344
19:09:07 81127 8192000000 10868503776 11347861504 1897706464 18.808 96 28 56 0 1917096832 11447680 7942688
19:10:36 10274 8192000000 10889672432 11364048896 1952890464 19.249 100 32 65 1 1972748944 10348880 9509600
19:11:12 29318 8192000000 10862642240 11343802368 1921601136 19.000 98 23 46 1 1936332944 7069584 7662224
19:12:37 40833 8192000000 10869533888 11348381696 1911249600 18.917 98 6 12 0 1921133456 8282928 1600928
19:13:25 51862 8192000000 10855959936 11338715136 1892082928 18.763 97 7 14 0 1905281264 10730128 2468208
19:14:34 74844 8192000000 10899537136 11380482048 1948778720 19.217 99 9 16 0 1961320896 10020928 2521248
19:16:02 84108 8192000000 10889445408 11367694336 1931948864 19.082 98 25 50 1 1953234816 13565808 7720144
19:18:28 68823 8192000000 10871255776 11350888448 1873098640 18.609 95 16 32 1 1885737744 7967568 4671536
19:19:58 35265 8192000000 10857551376 11323834368 1831206320 18.269 94 32 64 1 1847096160 7065744 8824096
19:20:41 51813 8192000000 10848712736 11314348032 1826403104 18.230 95 30 60 1 1844956288 10276928 8276256
19:21:38 52081 8192000000 10841690496 11326291968 1901058256 18.835 99 25 50 1 1918613072 10585488 6969328
19:22:37 50186 8192000000 10881199040 11340382208 1883552160 18.694 97 20 40 0 1898984112 9808624 5623328
19:23:48 57233 8192000000 10859536096 11350749184 1904177648 18.860 98 21 42 1 1925250944 14752432 6320864
19:24:59 44623 8192000000 10902306576 11357966336 1937781040 19.129 99 37 74 2 1956237472 8702496 9753936
19:25:50 15318 8192000000 10902636752 11357777920 1920209792 18.989 98 44 88 2 1943203728 10718848 12275088
19:26:11 45128 8192000000 10888545152 11369209856 1951012480 19.235 100 32 64 1 1974462128 14328288 9121360
19:27:03 25503 8192000000 9460601760 9778380800 595481104 6.776 31 4 8 0 605411552 9354832 575616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-02-2021 19:28:20 to 04-02-2021 19:28:51.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-02-2021 19:28:52 to 04-02-2021 19: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          247747
MON$OLDEST_ACTIVE               247748
MON$OLDEST_SNAPSHOT             247748
MON$NEXT_TRANSACTION            247748
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                       2038240
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.33413 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33413 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33413 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33413 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'

04.02.21 19: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
2021-02-04 19:28:58 No severe PSQL-related problems occured
04.02.21 19:28:59. End of report.