Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.11.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 17087104 kB
MemAvailable 31465972 kB
Buffers 0 kB
Cached 14569264 kB
SwapCached 3100 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-11-23 16:27:05
DTS_END                         2020-11-23 16:27:05.0120
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/50594
TRN_ID                          250945
ATT_ID                          686
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: 9644.26 22597 1157311
customer order: creation 178.64 345 21437
customer order: refuse 16.07 369 1928
order to supplier: creation 48.49 1277 5819
order to supplier: removal 3.43 118775 411
invoice (draft): creation 47.70 3408 5724
invoice (draft): removal 54.83 989 6580
invoice accept: apply 44.63 18252 5356
invoice accept: cancel 49.89 857 5987
customer reserve: creation 4084.65 180 490158
customer reserve: removal 4809.99 63 577199
realization accept: apply 86.25 203 10350
realization accept: cancel 82.08 132 9849
payment from customer: creation 61.98 140 7438
payment from customer: removal 6.15 97 738
payment to supplier: creation 52.03 177 6243
payment to supplier: removal 3.76 98 451
service: total inventory turnovers 5.34 1096 641
service: total monetary turnovers 7.42 57 890
service: aggregate perf. data 0.90 18190 108
service: refresh index statistics 0.03 287241 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-11-2020 16:27:44 to 23-11-2020 16:27:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4682
TEST_TIME 2 3232
TEST_TIME 3 4127
TEST_TIME 4 4935
TEST_TIME 5 5417
TEST_TIME 6 5801
TEST_TIME 7 5681
TEST_TIME 8 5905
TEST_TIME 9 6207
TEST_TIME 10 5994
TEST_TIME 11 6807
TEST_TIME 12 7066
TEST_TIME 13 7159
TEST_TIME 14 7331
TEST_TIME 15 7995
TEST_TIME 16 7843
TEST_TIME 17 7972
TEST_TIME 18 8032
TEST_TIME 19 7986
TEST_TIME 20 8029
TEST_TIME 21 8367
TEST_TIME 22 8663
TEST_TIME 23 8639
TEST_TIME 24 8917
TEST_TIME 25 9188
TEST_TIME 26 9884
TEST_TIME 27 9957
TEST_TIME 28 10193
TEST_TIME 29 11543
TEST_TIME 30 11734
TEST_TIME 31 11547
TEST_TIME 32 11432
TEST_TIME 33 11483
TEST_TIME 34 11338
TEST_TIME 35 11199
TEST_TIME 36 11060
TEST_TIME 37 10942
TEST_TIME 38 10830
TEST_TIME 39 10876
TEST_TIME 40 10958
TEST_TIME 41 10920
TEST_TIME 42 10878
TEST_TIME 43 10674
TEST_TIME 44 10604
TEST_TIME 45 10520
TEST_TIME 46 10419
TEST_TIME 47 10300
TEST_TIME 48 10304
TEST_TIME 49 10282
TEST_TIME 50 10325
TEST_TIME 51 10426
TEST_TIME 52 10395
TEST_TIME 53 10281
TEST_TIME 54 10213
TEST_TIME 55 10122
TEST_TIME 56 10198
TEST_TIME 57 10151
TEST_TIME 58 10202
TEST_TIME 59 10153
TEST_TIME 60 10095
TEST_TIME 61 9992
TEST_TIME 62 9978
TEST_TIME 63 9881
TEST_TIME 64 9921
TEST_TIME 65 9837
TEST_TIME 66 9934
TEST_TIME 67 9989
TEST_TIME 68 9978
TEST_TIME 69 9954
TEST_TIME 70 9969
TEST_TIME 71 10217
TEST_TIME 72 10180
TEST_TIME 73 10209
TEST_TIME 74 10223
TEST_TIME 75 10255
TEST_TIME 76 10208
TEST_TIME 77 10137
TEST_TIME 78 10088
TEST_TIME 79 10051
TEST_TIME 80 10046
TEST_TIME 81 9968
TEST_TIME 82 9901
TEST_TIME 83 9835
TEST_TIME 84 9769
TEST_TIME 85 9825
TEST_TIME 86 9830
TEST_TIME 87 9781
TEST_TIME 88 9819
TEST_TIME 89 9821
TEST_TIME 90 9823
TEST_TIME 91 9829
TEST_TIME 92 9802
TEST_TIME 93 9864
TEST_TIME 94 9900
TEST_TIME 95 9910
TEST_TIME 96 9884
TEST_TIME 97 9935
TEST_TIME 98 9973
TEST_TIME 99 9986
TEST_TIME 100 9931
TEST_TIME 101 9907
TEST_TIME 102 9843
TEST_TIME 103 9807
TEST_TIME 104 9813
TEST_TIME 105 9766
TEST_TIME 106 9754
TEST_TIME 107 9736
TEST_TIME 108 9661
TEST_TIME 109 9632
TEST_TIME 110 9626
TEST_TIME 111 9585
TEST_TIME 112 9594
TEST_TIME 113 9578
TEST_TIME 114 9652
TEST_TIME 115 9667
TEST_TIME 116 9645
TEST_TIME 117 9642
TEST_TIME 118 9693
TEST_TIME 119 9716
TEST_TIME 120 9645

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-11-2020 16:27:47 to 23-11-2020 16:27:51.

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 1610504 1610504 0 0.00 0 49423 7 0 0
doc_list_biud 1610503 1610503 0 0.00 0 81639 29 0 0
sp_add_invoice_to_stock 5493 5356 137 2.49 22 231684 18252 0 137
sp_cancel_adding_invoice 5987 5987 0 0.00 4 51013 857 0 0
sp_cancel_client_order 1928 1928 0 0.00 3 14922 369 0 0
sp_cancel_customer_reserve 577199 577199 0 0.00 1 26383 63 0 0
sp_cancel_pay_from_customer 738 738 0 0.00 3 5626 98 0 0
sp_cancel_pay_to_supplier 451 451 0 0.00 2 6715 98 0 0
sp_cancel_supplier_invoice 6589 6580 9 0.13 2 81644 990 0 9
sp_cancel_supplier_order 411 411 0 0.00 14 1248065 118776 0 0
sp_cancel_write_off 9849 9849 0 0.00 1 26904 132 0 0
sp_client_order 21437 21437 0 0.00 4 27598 345 0 0
sp_customer_reserve 490158 490158 0 0.00 0 115374 180 0 0
sp_fill_shopping_cart 32973 32973 0 0.00 1 16173 41 0 0
sp_fill_shopping_cart_clo_res 490156 490156 0 0.00 0 19904 14 0 0
sp_get_clo_for_invoice 5354 5354 0 0.00 0 21487 304 0 0
sp_kill_cost_storno 17025 17025 0 0.00 0 26868 70 0 0
sp_kill_qstorno_ret_qs2qd 1171238 1171238 0 0.00 0 81637 35 0 0
sp_kill_qty_storno 617658 617658 0 0.00 0 81638 76 0 0
sp_lock_selected_doc 21927 21927 0 0.00 0 10584 6 0 0
sp_make_cost_storno 29385 29385 0 0.00 0 49364 69 0 0
sp_multiply_rows_for_pdistr 29385 29385 0 0.00 0 26804 38 0 0
sp_multiply_rows_for_qdistr 21437 21437 0 0.00 0 10245 140 0 0
sp_pay_from_customer 7438 7438 0 0.00 4 17603 140 0 0
sp_pay_to_supplier 6243 6243 0 0.00 5 29553 177 0 0
sp_payment_common 13681 13681 0 0.00 1 24051 36 0 0
sp_qd_handle_on_cancel_clo 1928 1928 0 0.00 0 14871 319 0 0
sp_qd_handle_on_invoice_upd_sts 11341 11341 0 0.00 0 20101 378 0 0
sp_qd_handle_on_reserve_upd_sts 10350 10350 0 0.00 0 19566 57 0 0
sp_reserve_write_off 10350 10350 0 0.00 6 30761 204 0 0
sp_supplier_invoice 5724 5724 0 0.00 6 122163 3408 0 0
sp_supplier_order 5819 5819 0 0.00 5 30947 1277 0 0
srv_aggregate_perf_data 108 108 0 0.00 2910 254213 18190 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 714 158512 27778 0 0
srv_find_qd_qs_mism 1106650 1106650 0 0.00 0 11608 5 0 0
srv_make_invnt_saldo 641 641 0 0.00 38 122782 1096 0 0
srv_make_money_saldo 890 890 0 0.00 0 17748 57 0 0
srv_recalc_idx_stat 4 4 0 0.00 215253 433903 287241 0 0
t$perf-abend:sp_add_invoice_to_stock 137 137 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5356 5356 0 0.00 0 19977 224 0 0
t$perf-norm:sp_cancel_adding_invoice 466 466 0 0.00 0 8758 105 0 0
t$perf-norm:sp_cancel_client_order 1928 1928 0 0.00 0 5168 21 0 0
t$perf-norm:sp_cancel_customer_reserve 720 720 0 0.00 0 9061 24 0 0
t$perf-norm:sp_cancel_pay_from_customer 738 738 0 0.00 0 5605 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 451 451 0 0.00 0 1332 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 458 458 0 0.00 0 1369 18 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 21079 1805 0 0
t$perf-norm:sp_cancel_write_off 1051 1051 0 0.00 0 2272 16 0 0
t$perf-norm:sp_client_order 21437 21437 0 0.00 0 10144 24 0 0
t$perf-norm:sp_customer_reserve 1051 1051 0 0.00 0 1373 6 0 0
t$perf-norm:sp_pay_from_customer 7438 7438 0 0.00 0 9444 12 0 0
t$perf-norm:sp_pay_to_supplier 6243 6243 0 0.00 0 9306 13 0 0
t$perf-norm:sp_reserve_write_off 10350 10350 0 0.00 0 9316 14 0 0
t$perf-norm:sp_supplier_invoice 5724 5724 0 0.00 0 10063 27 0 0
t$perf-norm:sp_supplier_order 5819 5819 0 0.00 0 9621 23 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 83 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 931 13 0 0
t$perf-norm:srv_make_invnt_saldo 641 641 0 0.00 0 622 19 0 0
t$perf-norm:srv_make_money_saldo 890 890 0 0.00 0 2157 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10982 10708 274 2.49 0 7162 27 0 274
v_all_customers 38952 38952 0 0.00 0 15 1 0 0
v_all_suppliers 32032 32032 0 0.00 0 19 1 0 0
v_all_wares 42874 42874 0 0.00 0 154 1 0 0
v_cancel_adding_invoice 932 932 0 0.00 0 813 7 0 0
v_cancel_client_order 3856 3856 0 0.00 0 9540 9 0 0
v_cancel_customer_prepayment 1476 1476 0 0.00 0 5585 12 0 0
v_cancel_customer_reserve 1440 1440 0 0.00 0 3255 5 0 0
v_cancel_payment_to_supplier 902 902 0 0.00 0 6260 14 0 0
v_cancel_supplier_invoice 934 916 18 1.92 0 1406 19 0 18
v_cancel_supplier_order 822 822 0 0.00 0 4913 17 0 0
v_cancel_write_off 2102 2102 0 0.00 0 4059 18 0 0
v_max_id_clo_ord 5816 5816 0 0.00 0 2237 2 0 0
v_max_id_clo_res 1051 1051 0 0.00 0 1932 10 0 0
v_max_id_ord_sup 5718 5718 0 0.00 0 3309 5 0 0
v_max_non_paid_invoice 1761 1761 0 0.00 0 570 3 0 0
v_max_non_paid_realizn 4020 4020 0 0.00 0 3552 5 0 0
v_min_id_clo_ord 5816 5816 0 0.00 0 4911 10 0 0
v_min_id_clo_res 1051 1051 0 0.00 0 4980 16 0 0
v_min_id_ord_sup 5718 5718 0 0.00 0 3978 5 0 0
v_min_non_paid_invoice 6243 6243 0 0.00 0 24045 30 0 0
v_min_non_paid_realizn 7438 7438 0 0.00 0 17522 21 0 0
v_our_firm 10758 10758 0 0.00 0 18 1 0 0
v_reserve_write_off 20700 20700 0 0.00 0 9522 11 0 0
x_lock_depdocs_on_canc_invoice 12109 12109 0 0.00 0 21313 143 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 8586 445 0 0
x_make_qstorno_1000_1200 5819 5819 0 0.00 2 30796 1186 0 0
x_make_qstorno_1200_2000 5724 5724 0 0.00 3 115553 3266 0 0
x_make_qstorno_2100_3300 490158 490158 0 0.00 0 115373 163 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-11-2020 16:27:52 to 23-11-2020 16:27:56.

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:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:15 11846 8192000000 10195596864 10502475776 788412496 8.779 62 46 92 0 805854240 2145072 15296672
13:57:35 28780 8192000000 10350994192 10673745920 1374929392 14.371 100 79 158 0 1405004176 4248704 25826080
13:58:14 29384 8192000000 10390517888 10714042368 1439246128 14.943 100 88 176 2 1474401552 6506688 28648736
13:58:52 29183 8192000000 10425128816 10753433600 1472426704 15.235 100 90 180 2 1509374416 7791968 29155744
13:59:31 14792 8192000000 10443190448 10774552576 1495413536 15.436 100 91 182 1 1532809824 8631392 28764896
13:59:55 19296 8192000000 10459515392 10793185280 1506303520 15.531 100 85 170 2 1542675536 8994256 27377760
14:00:29 20443 8192000000 10483890464 10824708096 1536711472 15.795 100 87 174 0 1574028368 10104976 27211920
14:00:57 13573 8192000000 10488661216 10835607552 1553228096 15.938 100 85 170 0 1590531376 10558096 26745184
14:01:18 18308 8192000000 10516021760 10867023872 1572115696 16.100 100 81 162 1 1607284176 10336672 24831808
14:01:45 14496 8192000000 10551758208 10904502272 1604746688 16.380 100 81 163 0 1640111760 10849552 24515520
14:02:14 11830 8192000000 10562756416 10922352640 1622782512 16.534 100 81 162 1 1658408208 11607344 24018352
14:02:38 12877 8192000000 10589812800 10948784128 1642720944 16.703 100 81 161 1 1678764848 11773200 24270704
14:03:00 14104 8192000000 10609340000 10976198656 1664314912 16.885 100 75 150 1 1698092304 12314320 21463072
14:03:23 12410 8192000000 10627798112 10996797440 1687712288 17.082 100 89 178 0 1726950160 13035808 26202064
14:03:45 9062 8192000000 10646017984 11014799360 1702078032 17.202 100 76 150 3 1736799136 13157120 21563984
14:04:04 9996 8192000000 10655242800 11031752704 1717631904 17.332 100 79 158 2 1753713680 13456496 22625280
14:04:23 5222 8192000000 10668864208 11038695424 1726861440 17.409 100 86 171 1 1765307200 14356608 24089152
14:04:36 5125 8192000000 10675981664 11044667392 1732363248 17.455 100 79 158 0 1769315616 13897328 23055040
14:04:50 6880 8192000000 10676404688 11054845952 1742125440 17.536 100 84 169 1 1780152304 13791024 24235840
14:05:04 3714 8192000000 10688982672 11065462784 1746996432 17.577 100 78 154 2 1781996896 13006192 21994272
14:05:14 4562 8192000000 10695997328 11075850240 1760385680 17.688 100 77 153 0 1794303344 12854592 21063072
14:05:26 3732 8192000000 10713893440 11089383424 1773210000 17.794 100 89 178 1 1812813440 13983440 25620000
14:05:36 3028 8192000000 10712885536 11094790144 1778787456 17.839 100 86 169 0 1817059968 14238896 24033616
14:05:45 2548 8192000000 10731749920 11113029632 1792389776 17.951 100 88 174 1 1829703776 12961168 24352832
14:05:55 5354 8192000000 10735828944 11118419968 1797445680 17.993 100 80 160 2 1830907632 12052128 21409824
14:06:07 4996 8192000000 10748983200 11131146240 1801603216 18.027 100 84 166 1 1838321936 13339920 23378800
14:06:19 2889 8192000000 10758715088 11142852608 1817330304 18.156 100 84 169 2 1854562272 13366512 23865456
14:06:29 2574 8192000000 10762374576 11147886592 1826143808 18.228 100 95 190 1 1866016336 13051808 26820720
14:06:38 2128 8192000000 10767044160 11152482304 1826606976 18.232 100 82 164 2 1862953456 13638672 22707808
14:06:46 2933 8192000000 10775604128 11161346048 1833246384 18.286 100 84 169 1 1870477568 13371168 23860016
14:06:56 1331 8192000000 10795278736 11180871680 1851633968 18.435 100 89 178 0 1889039920 12859376 24546576
14:07:04 1882 8192000000 10798593248 11186372608 1857273840 18.481 100 92 183 0 1895749696 12831136 25644720
14:07:12 1687 8192000000 10805179248 11192537088 1860104912 18.504 100 91 180 0 1899255952 13030384 26120656
14:07:20 1396 8192000000 10816579008 11204452352 1867016976 18.560 100 90 180 1 1907175312 14143776 26014560
14:07:28 1462 8192000000 10814463712 11201736704 1868626768 18.573 100 93 187 1 1909403104 13974560 26801776
14:07:36 1585 8192000000 10818650032 11207540736 1871818576 18.599 100 92 186 0 1911595104 12687040 27089488
14:07:44 1159 8192000000 10812750256 11205697536 1873206208 18.610 100 89 178 1 1910861808 12488544 25167056
14:07:51 25415 8192000000 10797936416 11201732608 1872910848 18.608 100 65 130 0 1902454208 10926080 18617280
14:08:24 11503 8192000000 10813498464 11213115392 1879358000 18.660 100 75 151 2 1909028688 8844800 20825888
14:08:41 14380 8192000000 10803701360 11210952704 1875188880 18.626 100 53 106 1 1900005456 10373440 14443136
14:09:02 7902 8192000000 10788124672 11207024640 1872056176 18.601 100 32 64 2 1888043312 7403712 8583424
14:09:18 2917 8192000000 10790366672 11209179136 1875918208 18.632 100 40 80 2 1895953056 9362160 10672688
14:09:28 5011 8192000000 10796165152 11214319616 1879486448 18.661 100 33 65 0 1895782256 7099680 9196128
14:09:40 7781 8192000000 10802624448 11218501632 1879723056 18.663 100 35 70 3 1898248160 7990304 10534800
14:09:55 6600 8192000000 10786481536 11213938688 1878634336 18.654 100 20 40 1 1891070720 6435280 6001104
14:10:09 4242 8192000000 10788647568 11217887232 1880207088 18.667 100 28 54 2 1895688032 7105728 8375216
14:10:22 7667 8192000000 10793626752 11217674240 1881727376 18.679 100 24 48 2 1895679600 7066448 6885776
14:10:37 6268 8192000000 10795330832 11226849280 1884150448 18.699 100 23 46 1 1901291952 10683264 6458240
14:10:50 10823 8192000000 10791695584 11223801856 1884966864 18.705 100 17 34 1 1896239952 6404928 4868160
14:11:08 5479 8192000000 10798643376 11228372992 1890982768 18.754 100 29 58 3 1905553936 6076656 8494512
14:11:20 7502 8192000000 10793178912 11228000256 1889482944 18.742 100 19 38 2 1901808928 6802608 5523376
14:11:35 7726 8192000000 10790471840 11227402240 1890212272 18.747 100 24 47 2 1903016832 6361248 6443312
14:11:51 14620 8192000000 10802892576 11235938304 1891772560 18.760 100 18 36 0 1902714400 5799344 5142496
14:12:12 16510 8192000000 10806909152 11238248448 1898910592 18.818 100 39 78 0 1915652688 6432864 10309232
14:12:44 54041 8192000000 10803356960 11244343296 1896759328 18.800 100 29 59 1 1911284144 6153536 8371280
14:13:44 9106 8192000000 10814283536 11248525312 1899787616 18.825 100 23 46 0 1912920368 6042352 7090400
14:14:01 7421 8192000000 10822384176 11255582720 1903393680 18.854 100 22 44 2 1919883136 10664240 5825216
14:14:17 3816 8192000000 10821500960 11257581568 1908277888 18.893 100 33 66 0 1924846640 7295024 9273728
14:14:27 6068 8192000000 10823775072 11252039680 1904951840 18.866 100 32 64 1 1920924096 6942736 9029520
14:14:39 5801 8192000000 10820767040 11248504832 1888668336 18.735 99 41 82 3 1908866432 8439232 11758864
14:14:55 5981 8192000000 10810095408 11246256128 1899668032 18.824 100 20 40 1 1911398928 5491024 6239872
14:15:08 5794 8192000000 10812027808 11248185344 1899012560 18.818 100 30 59 0 1913951424 6007104 8931760
14:15:21 9072 8192000000 10820868032 11254579200 1902972992 18.850 100 18 36 0 1914567760 6116864 5477904
14:15:38 9582 8192000000 10809655296 11253817344 1906509968 18.879 100 19 38 1 1917556336 5349472 5696896
14:15:54 7495 8192000000 10790562736 11216748544 1849422112 18.417 97 19 38 2 1859403712 4777600 5204000
14:16:10 9086 8192000000 10811968768 11245158400 1881029104 18.673 99 19 38 0 1892315136 5875392 5410640
14:16:25 7149 8192000000 10786212816 11221585920 1841926816 18.356 97 18 36 1 1852366192 4903424 5535952
14:16:39 11361 8192000000 10787085632 11221291008 1848749296 18.412 98 14 28 0 1858108896 5480160 3879440
14:16:58 8093 8192000000 10806062336 11233832960 1887666192 18.727 100 27 54 0 1902248224 6631408 7950624
14:17:14 78305 8192000000 10725970528 11150503936 1656031040 16.815 88 25 50 1 1667646448 4898496 6716912
14:18:38 9412 8192000000 10748914928 11170791424 1806353776 18.066 98 36 70 4 1823202032 6120256 10728000
14:18:55 6730 8192000000 10713920672 11129151488 1716411904 17.322 94 32 64 2 1733022768 7547440 9063424
14:19:08 5798 8192000000 10708458768 11125395456 1716452784 17.323 95 22 44 2 1728656992 6150176 6054032
14:19:20 6525 8192000000 10711607584 11131514880 1780397760 17.853 99 22 44 1 1793486976 6641808 6447408
14:19:34 6887 8192000000 10713327360 11137142784 1800364256 18.017 100 26 52 2 1814045504 6643408 7037840
14:19:48 6445 8192000000 10684982368 11101806592 1730686384 17.441 97 33 66 0 1746781600 6378848 9716368
14:20:03 10896 8192000000 10699376512 11113406464 1738724528 17.508 97 20 40 0 1749818960 5788640 5305792
14:20:21 5745 8192000000 10703388352 11111317504 1744468048 17.556 97 24 48 2 1756011136 4696432 6846656
14:20:38 6392 8192000000 10680595264 11089043456 1742569616 17.540 97 23 46 1 1754158144 4750208 6838320
14:20:51 6714 8192000000 10711264320 11120611328 1748161088 17.586 97 23 46 3 1760504992 5057552 7286352
14:21:04 12085 8192000000 10724371600 11142709248 1788333536 17.918 99 22 44 0 1800049536 5547664 6168336
14:21:23 6584 8192000000 10722371072 11144425472 1808158112 18.081 100 26 51 1 1825440768 10210496 7072160
14:21:40 12130 8192000000 10719558176 11147395072 1804630384 18.052 99 26 53 1 1821427920 9590560 7206976
14:22:02 58130 8192000000 10774887600 11186122752 1838013536 18.325 100 38 76 0 1853743616 5004784 10725296
14:23:07 29629 8192000000 10758297840 11182780416 1825992496 18.227 99 27 54 1 1839677920 5428752 8256672
14:23:43 5619 8192000000 10759551408 11182149632 1825038176 18.219 99 23 46 1 1838357408 6249072 7070160
14:23:56 3527 8192000000 10765396432 11182686208 1845889360 18.389 100 27 54 1 1859084400 6269808 6925232
14:24:06 4926 8192000000 10758292288 11185418240 1849535104 18.418 100 43 87 1 1869808304 7196912 13076288
14:24:17 7254 8192000000 10755482672 11189678080 1852535184 18.443 100 32 64 2 1867930352 6038944 9356224
14:24:33 6452 8192000000 10779969952 11203903488 1863096128 18.528 100 31 62 1 1878103872 6290976 8716768
14:24:47 9484 8192000000 10773121632 11203485696 1860349344 18.506 100 20 40 0 1871870864 5810352 5711168
14:25:08 12723 8192000000 10784750864 11207438336 1867787744 18.566 100 18 36 2 1878311008 5354736 5168528
14:25:30 8588 8192000000 10783244224 11214295040 1873281424 18.611 100 16 32 1 1883223552 5525344 4416784
14:25:45 14278 8192000000 10781688848 11217264640 1870000544 18.584 100 10 20 0 1882380272 9757264 2622464
14:26:05 9704 8192000000 10785378656 11213504512 1871387488 18.595 100 16 32 1 1884899664 9113488 4398688
14:26:21 11902 8192000000 10798493008 11221311488 1872970544 18.608 100 25 50 3 1885788752 5192816 7625392
14:26:39 14561 8192000000 10786014176 11220185088 1871457152 18.596 100 14 28 0 1881074112 5629872 3987088
14:27:01 43070 8192000000 10816764480 11235381248 1868031568 18.568 99 27 54 0 1880494800 5138512 7324720
14:28:02 72473 8192000000 10851589520 11270062080 1912208816 18.924 100 56 112 3 1936301952 7909728 16183408
14:30:03 27106 8192000000 10856041200 11272376320 1915538048 18.951 100 51 100 1 1940637504 10228640 14870816
14:30:38 24279 8192000000 10850229344 11285364736 1922090192 19.004 100 26 52 0 1942313456 13037712 7185552
14:31:10 24472 8192000000 10868324208 11295793152 1936063152 19.115 100 46 92 1 1959686416 10993104 12630160
14:31:46 5740 8192000000 10891099968 11310235648 1943798416 19.177 100 56 109 2 1970481344 11020016 15662912
14:31:59 9451 8192000000 10883848752 11309314048 1947847856 19.209 100 53 104 0 1974353776 11978448 14527472
14:32:26 5726 8192000000 10881068912 11306209280 1945999056 19.195 100 48 95 2 1968662288 9286288 13376944
14:32:40 7964 8192000000 10889647120 11312754688 1953149296 19.252 100 60 122 2 1980466160 9873408 17443456
14:33:00 2841 8192000000 10905914000 11325390848 1957964864 19.290 100 60 119 2 1990000528 14994384 17041280
14:33:10 5020 8192000000 10903570768 11322994688 1963966464 19.338 100 72 141 1 1995669696 11123264 20579968
14:33:30 21636 8192000000 10889757360 11327483904 1944963712 19.186 99 43 84 2 1971446704 14175792 12307200
14:33:59 2222 8192000000 10905713888 11330564096 1964706384 19.343 100 58 116 0 1993980032 12226976 17046672
14:34:09 3276 8192000000 10905004240 11319734272 1959077856 19.299 100 71 141 1 1991038448 12389904 19570688
14:34:20 16952 8192000000 10906731744 11326189568 1959375888 19.301 100 61 122 0 1990898640 14653728 16869024
14:34:45 7476 8192000000 10920684032 11340967936 1968812304 19.376 100 66 131 2 2005652880 17699648 19140928
14:35:12 6235 8192000000 10918147200 11341131776 1970053696 19.386 100 66 131 1 2010337696 20548240 19735760
14:35:26 2872 8192000000 10918648144 11335274496 1965267424 19.348 100 62 124 3 2002699088 18695104 18736560
14:35:35 4465 8192000000 10912298848 11337093120 1968147600 19.371 100 58 116 0 2004742368 19544496 17050272
14:35:49 11419 8192000000 10911080064 11329593344 1935478976 19.111 98 72 144 0 1979660384 22555552 21625856
14:36:10 5436 8192000000 10900789936 11334217728 1959757408 19.304 100 53 106 1 2001359616 24934576 16667632
14:36:25 18154 8192000000 10912545376 11338465280 1961600048 19.319 100 56 110 1 1999002000 21115200 16286752
14:36:51 6424 8192000000 10903215328 11326824448 1950120304 19.227 99 56 108 0 1989058240 21704128 17233808
14:37:05 5316 8192000000 10922882496 11345477632 1966966992 19.361 100 54 106 2 2004852704 22068912 15816800
14:37:24 17482 8192000000 10936093872 11369316352 1981889760 19.480 100 62 123 5 2028737536 28556192 18291584
14:37:51 12777 8192000000 10955251328 11386990592 1990049296 19.544 100 55 109 2 2036383456 29348224 16985936
14:38:12 2991 8192000000 10961067488 11383144448 1998927792 19.614 100 79 158 2 2050900768 28707200 23265776
14:38:24 6453 8192000000 10964971312 11387781120 2004292352 19.657 100 78 154 0 2055892096 28603600 22996144
14:38:37 1910 8192000000 10986544432 11403186176 2012218736 19.719 100 91 183 1 2069530576 29647056 27664784
14:38:45 1266 8192000000 10949370112 11357904896 1980810848 19.471 99 93 186 1 2039980144 30733888 28435408
14:38:53 2179 8192000000 10967383232 11380015104 1994552960 19.580 100 87 171 3 2051420576 30862016 26005600
14:39:03 3700 8192000000 10961329712 11377545216 1992324624 19.562 100 87 174 3 2049421184 31458896 25637664
14:39:13 3000 8192000000 10945985456 11368144896 1981791776 19.479 100 73 147 3 2036014384 31848464 22374144
14:39:23 3811 8192000000 10950120928 11371728896 1987371712 19.523 100 79 156 1 2042209504 31285232 23552560
14:39:39 2446 8192000000 10967241936 11377709056 1993869728 19.574 100 84 167 2 2054830464 35547776 25412960
14:39:51 2078 8192000000 10951480480 11363352576 1962371664 19.325 99 87 170 1 2022715296 34453056 25890576
14:40:00 3578 8192000000 10948066608 11362357248 1977009968 19.441 100 81 162 2 2036994416 35662256 24322192
14:40:11 6594 8192000000 10955798640 11368583168 1975910640 19.432 100 81 163 1 2036800944 36321600 24568704
14:40:27 5132 8192000000 10956151792 11369730048 1983949440 19.496 100 77 154 0 2044266528 36798976 23518112
14:40:41 3124 8192000000 10968577696 11380396032 1986050608 19.513 100 77 153 0 2044987568 35666000 23270960
14:40:52 6278 8192000000 10958249616 11375263744 1970681792 19.391 99 76 152 0 2031982976 37795152 23506032
14:41:08 3752 8192000000 10971102448 11384872960 1985369856 19.507 100 79 158 1 2052618704 42677920 24570928
14:41:20 3869 8192000000 10957718560 11377758208 1972877088 19.408 99 70 139 2 2038114656 43870032 21367536
14:41:32 3946 8192000000 10965861888 11374903296 1970988864 19.393 99 81 163 0 2041724624 44911024 25824736
14:41:45 5912 8192000000 10973385152 11388547072 1984310672 19.499 100 85 170 0 2056560080 45639792 26609616
14:42:01 2470 8192000000 10975664144 11389337600 1987580048 19.525 100 74 147 0 2055451936 45535696 22336192
14:42:12 3201 8192000000 10955128640 11368161280 1968940272 19.377 100 81 162 1 2035052368 41610656 24501440
14:42:22 2743 8192000000 10967782464 11379712000 1982123952 19.482 100 88 178 0 2051271936 42339856 26808128
14:42:32 3695 8192000000 10932784208 11343568896 1950062176 19.227 99 80 156 2 2014333296 41035120 23236000
14:42:44 3816 8192000000 10941461264 11348492288 1950948144 19.234 99 82 155 0 2015645824 41448304 23249376
14:42:55 1336 8192000000 10963516096 11376676864 1977564032 19.445 100 86 170 0 2046870304 42772144 26534128
14:43:04 2140 8192000000 10957892304 11363495936 1956910176 19.281 99 80 157 2 2020475792 39009024 24556592
14:43:13 4896 8192000000 10941817344 11355848704 1949773056 19.225 99 68 136 1 2011661360 41337744 20550560
14:43:25 2651 8192000000 10944902304 11354189824 1960726544 19.312 100 83 165 2 2028184464 42442512 25015408
14:43:35 7735 8192000000 10951968016 11360489472 1965265232 19.348 100 80 160 0 2032395872 43293552 23837088
14:43:51 1622 8192000000 10959431344 11366305792 1968829264 19.376 100 83 163 2 2038244336 44159616 25255456
14:44:00 6258 8192000000 10945724160 11370397696 1969155776 19.379 100 68 133 2 2036493200 46294464 21042960
14:44:14 5637 8192000000 10958492864 11372802048 1959259872 19.300 99 78 153 1 2032202704 48085920 24856912
14:44:27 1948 8192000000 10986310480 11389026304 1984860976 19.503 100 91 182 0 2064801824 52809520 27131328
14:44:37 2076 8192000000 10984763744 11395743744 1986335840 19.515 100 88 176 1 2068547072 54661088 27550144
14:44:46 1631 8192000000 10991603920 11400032256 1993245952 19.569 100 89 173 0 2069894720 50551712 26097056
14:44:54 2877 8192000000 10988083600 11403247616 1995866880 19.590 100 80 159 0 2071508688 51173856 24467952
14:45:04 9097 8192000000 10982515600 11401330688 1995958688 19.591 100 74 148 1 2069472848 50547088 22967072
14:45:22 1287 8192000000 10982481808 11387637760 1984410848 19.500 100 83 163 1 2058490688 49186512 24893328
14:45:30 4007 8192000000 10983696256 11393077248 1985493056 19.508 100 90 180 0 2064670320 51592400 27584864
14:45:40 7538 8192000000 10980669920 11392184320 1984506864 19.500 100 81 162 0 2061420784 51695120 25218800
14:45:59 4734 8192000000 10980330784 11399086080 1985871344 19.511 100 79 154 2 2063004256 51993280 25139632
14:46:12 3588 8192000000 10953796448 11356921856 1947436688 19.206 98 82 157 2 2029231200 57038560 24755952
14:46:23 2253 8192000000 10982759488 11387015168 1971313600 19.396 100 93 185 2 2058660272 58356576 28990096
14:46:34 2243 8192000000 10964279472 11367792640 1949720576 19.224 99 88 175 1 2036563168 59521968 27320624
14:46:44 3502 8192000000 10974693744 11376480256 1956881040 19.281 99 91 182 0 2047940912 61950912 29108960
14:46:56 3003 8192000000 10991734368 11395112960 1977912544 19.448 100 92 183 1 2069304384 62309136 29082704
14:47:10 2344 8192000000 10995968544 11406798848 1987264608 19.522 100 85 169 3 2077045136 62564560 27215968
14:47:19 2655 8192000000 11019627248 11426312192 2000296512 19.625 100 95 190 3 2095619232 66217152 29105568
14:47:30 1355 8192000000 11020354832 11426099200 2001190944 19.632 100 94 188 1 2097926272 67076752 29658576
14:47:38 713 8192000000 11024436576 11428556800 2000930016 19.630 100 94 188 1 2098091440 67968800 29192624
14:47:47 3250 8192000000 11015692800 11431055360 2001494032 19.635 100 82 162 1 2096098896 68253168 26351696
14:47:57 4245 8192000000 11019792672 11434885120 2002925312 19.646 100 87 174 0 2102608384 71296720 28386352
14:48:08 2818 8192000000 11033217824 11445088256 2013452384 19.729 100 90 180 1 2113515040 71409312 28653344
14:48:19 1962 8192000000 11015141504 11426676736 1982524416 19.485 99 79 159 0 2081216208 72030720 26661072
14:48:32 2393 8192000000 10995090912 11412271104 1965553232 19.350 99 74 148 0 2064300032 74409280 24337520
14:48:42 8244 8192000000 10961957152 11386359808 1946279808 19.197 99 55 110 0 2039522752 74680576 18562368
14:48:57 9669 8192000000 10973733584 11402158080 1968210304 19.371 100 51 100 2 2059828448 73767536 17850608
14:49:18 8094 8192000000 10989959344 11418660864 1977679088 19.446 100 47 94 1 2066334368 73033296 15621984
14:49:33 8652 8192000000 10978517488 11418103808 1976290176 19.435 100 46 92 1 2068470656 75947472 16233008
14:49:52 12037 8192000000 10978647056 11409637376 1972131088 19.402 100 46 92 0 2058890528 70977632 15781808
14:50:23 7952 8192000000 10974019664 11407548416 1971968384 19.401 100 42 84 2 2059224704 72664688 14591632
14:50:55 3859 8192000000 10994144384 11418722304 1979700144 19.462 100 58 111 2 2074126064 74809344 19616576
14:51:06 6150 8192000000 10991775712 11423600640 1979597632 19.462 100 50 98 2 2072023744 75005632 17420480
14:51:19 11255 8192000000 10988338400 11427127296 1979721776 19.462 100 47 94 2 2066961872 70881120 16358976
14:51:40 8442 8192000000 10985564336 11421745152 1981267472 19.475 100 51 102 0 2070002272 70954864 17779936
14:52:07 2559 8192000000 10977222704 11416162304 1971739856 19.399 100 45 90 0 2062008544 74253168 16015520
14:52:18 6435 8192000000 10981252080 11413393408 1966887728 19.361 100 47 94 4 2058911104 75134880 16888496
14:52:36 15117 8192000000 10958698736 11406057472 1944585792 19.183 99 31 62 1 2031265200 75154288 11525120
14:52:59 5454 8192000000 10971075392 11410255872 1963694048 19.335 100 38 76 1 2054612400 77094000 13824352
14:53:48 22341 8192000000 10936982816 11405291520 1942067744 19.163 100 26 52 2 2030605168 78518656 10018768
14:54:16 36019 8192000000 10947890896 11395461120 1935173536 19.108 100 30 60 0 2022597280 75724400 11699344
14:55:00 18321 8192000000 10937966080 11393740800 1936615360 19.120 100 25 50 2 2015202960 69467168 9120432
14:55:34 24635 8192000000 10942972352 11392761856 1939486320 19.143 100 26 52 0 2015088336 66046832 9555184
14:56:16 1554 8192000000 10944594976 11368775680 1942433568 19.166 100 83 165 2 2023543712 56342944 24767200
14:56:24 8738 8192000000 10941165920 11383734272 1943725712 19.176 100 50 99 2 2014764288 56279520 14759056
14:57:21 60053 8192000000 10894265824 11346292736 1930646096 19.072 99 12 24 1 1951878880 17807216 3425568
14:58:27 44308 8192000000 10901970816 11359232000 1964345648 19.341 100 17 36 1 1977364608 7611232 5407728
14:59:45 26494 8192000000 10897570768 11354636288 1951397648 19.238 99 17 34 2 1968981184 12861120 4722416
15:00:18 75452 8192000000 10878928032 11328802816 1876475040 18.637 95 7 14 0 1888073296 10103792 1494464
15:01:40 63999 8192000000 10908932624 11346063360 1943219712 19.172 99 19 37 4 1955114976 7056368 4838896
15:02:51 42129 8192000000 10907725280 11365281792 1975144384 19.426 100 39 76 0 1992884400 7672608 10067408
15:03:42 38358 8192000000 10914515568 11370786816 1960428208 19.309 99 33 64 2 1976159200 6887008 8843984
15:05:07 43226 8192000000 10930714064 11384397824 1968762720 19.376 99 16 32 2 1987128896 13227232 5138944
15:06:01 24503 8192000000 10925641472 11390889984 1991665536 19.557 100 26 51 0 2012320544 12162224 8492784
15:06:40 60474 8192000000 10915270848 11394064384 1981745088 19.479 100 10 20 0 2001098560 16191584 3161888
15:07:49 64293 8192000000 10906994592 11367833600 1905787552 18.873 96 9 18 1 1918485264 9757424 2940288
15:10:06 100986 8192000000 10914978640 11363291136 1964908912 19.345 100 31 62 2 1983315104 9414208 8991984
15:11:56 36947 8192000000 10918778432 11365322752 1954705808 19.264 99 48 95 1 1979759360 12140128 12913424
15:12:50 100013 8192000000 10904460992 11377545216 1952097104 19.243 99 19 38 1 1975217424 17670096 5450224
15:14:55 68969 8192000000 10903712720 11374931968 1917660976 18.968 97 16 32 0 1939049408 16727616 4660816
15:16:10 14103 8192000000 10908807792 11371601920 1964890992 19.345 100 13 26 0 1990496656 21515584 4090080
15:16:32 14244 8192000000 10917466224 11366211584 1936089024 19.116 98 48 97 1 1972201760 20993008 15119728
15:16:54 15779 8192000000 10912283648 11357843456 1912405024 18.926 97 61 122 1 1949701920 18413456 18883440
15:17:19 17819 8192000000 10909456752 11338936320 1941586352 19.159 99 72 140 4 1978311328 16725824 19999152
15:17:45 19142 8192000000 10938215264 11379691520 1970159616 19.387 100 66 132 2 2010871280 22197568 18514096
15:18:18 37696 8192000000 10904235744 11384352768 1967382400 19.365 100 39 78 2 1998820080 20451104 10986576
15:19:05 100761 8192000000 10884554592 11353616384 1909256704 18.901 97 14 28 0 1930971392 18303680 3411008
15:20:52 158512 8192000000 10899673744 11388952576 1937362288 19.126 98 14 28 0 1957975168 16452256 4160624
15:23:43 72273 8192000000 10880696448 11356114944 1918079552 18.971 97 21 42 2 1940750816 16723312 5947952
15:25:04 28318 8192000000 10875632176 11373125632 1951968592 19.242 100 13 26 0 1974175104 18773968 3432544
15:25:47 26129 8192000000 10865454112 11328417792 1878212992 18.651 96 17 34 0 1893641776 10510624 4918160
15:26:27 31554 8192000000 10857243296 11325509632 1917810096 18.969 99 19 38 0 1930024048 6425792 5788160
15:27:23 81118 8192000000 10881995296 11352182784 1935728720 19.113 99 22 44 1 1947693904 6299200 5665984
15:30:39 33175 8192000000 10879921328 11357667328 1952862880 19.249 100 22 44 1 1965877776 6751344 6263552
15:31:29 50587 8192000000 10882215824 11357929472 1918633088 18.976 98 13 26 1 1930275392 8343024 3299280
15:32:26 48430 8192000000 10892728288 11371458560 1951025968 19.235 99 29 58 0 1973871104 14680672 8164464
15:33:29 81445 8192000000 10877165056 11359657984 1877831936 18.648 96 10 20 0 1891809520 11232688 2744896
15:34:56 55277 8192000000 10872862944 11341606912 1848653040 18.411 94 17 34 0 1871100432 17059952 5387440
15:35:58 93033 8192000000 10908290128 11380244480 1923904480 19.018 98 22 44 0 1950508064 20012768 6590816
15:37:37 55642 8192000000 10881411008 11346665472 1861469392 18.515 95 26 52 1 1889098992 19412096 8217504
15:39:17 26884 8192000000 10851688992 11310510080 1873391968 18.612 97 10 20 0 1887483680 11050688 3041024
15:39:53 30284 8192000000 10880455472 11342442496 1938012080 19.131 100 34 68 2 1959010384 11033072 9965232
15:40:34 68516 8192000000 10878869456 11352285184 1865522336 18.548 96 20 40 2 1883957552 12737888 5697328
15:41:52 81285 8192000000 10883856240 11359739904 1908184000 18.892 98 9 18 0 1922341744 11917568 2240176
15:43:36 114317 8192000000 10877180832 11328954368 1901272464 18.837 97 29 59 2 1920233776 10662672 8298640
15:45:53 58329 8192000000 10881995984 11345563648 1929112304 19.060 99 16 32 1 1941598272 8365888 4120080
15:46:57 37437 8192000000 10854150592 11331928064 1906738448 18.880 98 34 68 1 1923886832 7836560 9311824
15:47:54 60148 8192000000 10864298816 11345764352 1941292608 19.157 100 8 16 1 1949942368 6873776 1775984
15:50:19 54635 8192000000 10879820336 11352346624 1937195088 19.124 99 17 34 0 1954609648 12432992 4981568
15:51:33 97674 8192000000 10884173632 11377295360 1938129680 19.132 99 15 30 0 1958232880 15782560 4320640
15:53:18 80246 8192000000 10887952752 11357749248 1878331888 18.652 96 14 28 0 1895019920 12894768 3793264
15:54:46 46732 8192000000 10875845088 11353436160 1940043152 19.147 99 24 48 0 1958993856 11309392 7641312
15:55:39 46747 8192000000 10882991328 11351289856 1951361904 19.237 100 30 59 2 1971800064 11477504 8960656
15:56:33 19339 8192000000 10860118320 11308949504 1880291520 18.667 96 21 42 1 1893238496 7269152 5677824
15:56:59 50388 8192000000 10865977600 11330297856 1898259504 18.812 97 29 58 1 1915338784 9407856 7671424
15:57:58 49934 8192000000 10884620832 11351023616 1936572160 19.119 99 29 56 1 1960155056 15790384 7792512
15:58:57 42575 8192000000 10876395312 11319504896 1855642240 18.468 95 23 45 0 1868371648 6586752 6142656
15:59:49 64421 8192000000 10868253504 11349815296 1900578496 18.831 97 26 52 1 1920168192 12523744 7065952
16:01:09 52235 8192000000 10878361600 11349499904 1947926304 19.210 100 12 24 2 1962375152 11177200 3271648
16:02:51 44398 8192000000 10905547264 11358130176 1925096464 19.028 98 25 50 1 1941090848 9516416 6477968
16:03:45 43086 8192000000 10896845520 11370188800 1961868240 19.321 100 26 52 3 1982188320 12905328 7414752
16:04:38 74663 8192000000 10899235872 11375607808 1931733648 19.081 98 15 28 0 1946104144 10445728 3924768
16:06:00 62161 8192000000 10905520720 11379834880 1898174560 18.812 96 16 32 2 1916044528 13645152 4224816
16:07:14 83820 8192000000 10885474960 11363160064 1935814656 19.113 98 14 28 2 1962179424 22271120 4093648
16:10:28 68482 8192000000 10870426656 11358871552 1907806528 18.889 97 13 26 1 1919794624 8148896 3839200
16:11:45 54052 8192000000 10864978624 11350163456 1901300848 18.837 97 5 10 0 1911677200 9132448 1243904
16:12:46 55813 8192000000 10876483056 11353329664 1954554560 19.263 100 6 12 0 1965870880 9513104 1803216
16:13:51 49428 8192000000 10876502336 11356377088 1946175008 19.196 99 13 26 0 1958470192 8492160 3803024
16:14:56 66569 8192000000 10889666016 11349745664 1927620464 19.048 98 26 52 0 1941333472 6659328 7053680
16:16:09 32918 8192000000 10879622432 11334164480 1909365360 18.902 98 30 60 1 1929338576 11765856 8207360
16:16:53 69357 8192000000 10859720048 11334901760 1891998128 18.762 97 20 40 1 1907444000 9594672 5851200
16:19:45 45273 8192000000 10885217984 11343712256 1875543056 18.629 96 20 40 0 1895705808 14244688 5918064
16:21:03 71296 8192000000 10887684608 11374911488 1944871488 19.186 100 14 28 1 1969549888 20340384 4338016
16:22:21 52570 8192000000 10875269120 11344908288 1863329328 18.530 95 21 42 1 1887722352 18878960 5514064
16:23:23 29929 8192000000 10881003584 11338907648 1906726848 18.880 98 32 65 0 1927805776 12120592 8958336
16:24:01 33808 8192000000 10877499056 11332804608 1892616672 18.767 97 31 62 0 1914424000 13069264 8738064
16:24:44 37955 8192000000 10887137888 11332587520 1896059168 18.795 98 26 52 1 1918649136 15269632 7320336
16:25:29 102509 8192000000 9501994080 9834266624 333833232 3.915 18 4 8 0 337439664 2701680 904752

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 23-11-2020 16:27:57 to 23-11-2020 16:28:30.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 137 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-11-2020 16:28:31 to 23-11-2020 16:28:33.

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          251250
MON$OLDEST_ACTIVE               251251
MON$OLDEST_SNAPSHOT             251251
MON$NEXT_TRANSACTION            251251
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                       2065504
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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'

23.11.20 16:28:34. 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-11-23 16:28:36 No severe PSQL-related problems occured
23.11.20 16:28:37. End of report.