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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-31 01:27:06
DTS_END                         2020-12-31 01:27:06.7100
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51996
TRN_ID                          232067
ATT_ID                          675
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: 9251.24 21828 1110149
customer order: creation 164.02 387 19682
customer order: refuse 14.13 388 1696
order to supplier: creation 43.65 1358 5238
order to supplier: removal 3.41 112899 409
invoice (draft): creation 42.98 3940 5157
invoice (draft): removal 54.30 809 6516
invoice accept: apply 39.69 19230 4763
invoice accept: cancel 49.45 825 5934
customer reserve: creation 3688.92 189 442670
customer reserve: removal 4865.88 63 583905
realization accept: apply 78.30 180 9396
realization accept: cancel 84.93 109 10192
payment from customer: creation 56.01 127 6721
payment from customer: removal 5.66 86 679
payment to supplier: creation 45.56 159 5467
payment to supplier: removal 2.88 118 346
service: total inventory turnovers 4.37 1377 524
service: total monetary turnovers 6.31 39 757
service: aggregate perf. data 0.78 24695 93
service: refresh index statistics 0.03 269572 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-12-2020 01:27:57 to 31-12-2020 01:27:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8200
TEST_TIME 2 7062
TEST_TIME 3 6568
TEST_TIME 4 6298
TEST_TIME 5 6378
TEST_TIME 6 6361
TEST_TIME 7 6473
TEST_TIME 8 6468
TEST_TIME 9 6912
TEST_TIME 10 7359
TEST_TIME 11 7620
TEST_TIME 12 7785
TEST_TIME 13 8196
TEST_TIME 14 8295
TEST_TIME 15 8254
TEST_TIME 16 8149
TEST_TIME 17 8047
TEST_TIME 18 8326
TEST_TIME 19 8323
TEST_TIME 20 8374
TEST_TIME 21 8160
TEST_TIME 22 8681
TEST_TIME 23 8622
TEST_TIME 24 9045
TEST_TIME 25 9409
TEST_TIME 26 9493
TEST_TIME 27 9251
TEST_TIME 28 9381
TEST_TIME 29 10925
TEST_TIME 30 11580
TEST_TIME 31 11304
TEST_TIME 32 11228
TEST_TIME 33 11079
TEST_TIME 34 10923
TEST_TIME 35 10859
TEST_TIME 36 10709
TEST_TIME 37 10564
TEST_TIME 38 10570
TEST_TIME 39 10622
TEST_TIME 40 10424
TEST_TIME 41 10230
TEST_TIME 42 10131
TEST_TIME 43 10084
TEST_TIME 44 10123
TEST_TIME 45 10064
TEST_TIME 46 10114
TEST_TIME 47 9987
TEST_TIME 48 9882
TEST_TIME 49 9772
TEST_TIME 50 9745
TEST_TIME 51 9749
TEST_TIME 52 9729
TEST_TIME 53 9662
TEST_TIME 54 9595
TEST_TIME 55 9623
TEST_TIME 56 9526
TEST_TIME 57 9454
TEST_TIME 58 9427
TEST_TIME 59 9438
TEST_TIME 60 9393
TEST_TIME 61 9372
TEST_TIME 62 9408
TEST_TIME 63 9493
TEST_TIME 64 9461
TEST_TIME 65 9512
TEST_TIME 66 9523
TEST_TIME 67 9594
TEST_TIME 68 9625
TEST_TIME 69 9633
TEST_TIME 70 9669
TEST_TIME 71 9700
TEST_TIME 72 9762
TEST_TIME 73 9750
TEST_TIME 74 9643
TEST_TIME 75 9579
TEST_TIME 76 9539
TEST_TIME 77 9521
TEST_TIME 78 9457
TEST_TIME 79 9401
TEST_TIME 80 9356
TEST_TIME 81 9331
TEST_TIME 82 9306
TEST_TIME 83 9267
TEST_TIME 84 9238
TEST_TIME 85 9190
TEST_TIME 86 9142
TEST_TIME 87 9259
TEST_TIME 88 9223
TEST_TIME 89 9221
TEST_TIME 90 9185
TEST_TIME 91 9225
TEST_TIME 92 9364
TEST_TIME 93 9321
TEST_TIME 94 9419
TEST_TIME 95 9426
TEST_TIME 96 9457
TEST_TIME 97 9449
TEST_TIME 98 9448
TEST_TIME 99 9469
TEST_TIME 100 9547
TEST_TIME 101 9479
TEST_TIME 102 9455
TEST_TIME 103 9404
TEST_TIME 104 9408
TEST_TIME 105 9399
TEST_TIME 106 9340
TEST_TIME 107 9324
TEST_TIME 108 9318
TEST_TIME 109 9259
TEST_TIME 110 9225
TEST_TIME 111 9266
TEST_TIME 112 9244
TEST_TIME 113 9247
TEST_TIME 114 9227
TEST_TIME 115 9228
TEST_TIME 116 9287
TEST_TIME 117 9298
TEST_TIME 118 9303
TEST_TIME 119 9332
TEST_TIME 120 9255

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 31-12-2020 01:28:01 to 31-12-2020 01:28:04.

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 1521763 1521763 0 0.00 0 18850 6 0 0
doc_list_biud 1521763 1521763 0 0.00 0 48162 30 0 0
sp_add_invoice_to_stock 4846 4763 83 1.71 65 206001 19231 0 83
sp_cancel_adding_invoice 5934 5934 0 0.00 5 62146 826 0 0
sp_cancel_client_order 1696 1696 0 0.00 4 23694 389 0 0
sp_cancel_customer_reserve 583905 583905 0 0.00 1 48163 63 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 3 5025 86 0 0
sp_cancel_pay_to_supplier 346 346 0 0.00 3 8289 118 0 0
sp_cancel_supplier_invoice 6521 6516 5 0.07 2 38754 810 0 5
sp_cancel_supplier_order 409 409 0 0.00 8 1015136 112899 0 0
sp_cancel_write_off 10192 10192 0 0.00 1 13256 110 0 0
sp_client_order 19682 19682 0 0.00 3 61711 387 0 0
sp_customer_reserve 442670 442670 0 0.00 0 86514 189 0 0
sp_fill_shopping_cart 30056 30056 0 0.00 1 16892 44 0 0
sp_fill_shopping_cart_clo_res 442660 442660 0 0.00 0 15419 14 0 0
sp_get_clo_for_invoice 4753 4753 0 0.00 0 37581 368 0 0
sp_kill_cost_storno 17151 17151 0 0.00 0 18836 56 0 0
sp_kill_qstorno_ret_qs2qd 1184927 1184927 0 0.00 0 48159 34 0 0
sp_kill_qty_storno 622801 622801 0 0.00 0 48162 73 0 0
sp_lock_selected_doc 19617 19617 0 0.00 0 6506 4 0 0
sp_make_cost_storno 26337 26337 0 0.00 0 17481 59 0 0
sp_multiply_rows_for_pdistr 26337 26337 0 0.00 0 6231 25 0 0
sp_multiply_rows_for_qdistr 19682 19682 0 0.00 0 61678 174 0 0
sp_pay_from_customer 6721 6721 0 0.00 4 23502 128 0 0
sp_pay_to_supplier 5467 5467 0 0.00 5 18283 160 0 0
sp_payment_common 12188 12188 0 0.00 1 11950 28 0 0
sp_qd_handle_on_cancel_clo 1696 1696 0 0.00 0 8171 326 0 0
sp_qd_handle_on_invoice_upd_sts 10687 10687 0 0.00 0 30807 339 0 0
sp_qd_handle_on_reserve_upd_sts 9396 9396 0 0.00 0 15655 56 0 0
sp_reserve_write_off 9396 9396 0 0.00 7 20383 181 0 0
sp_supplier_invoice 5157 5157 0 0.00 7 93626 3941 0 0
sp_supplier_order 5238 5238 0 0.00 5 40916 1358 0 0
srv_aggregate_perf_data 93 93 0 0.00 2726 402095 24695 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 1536 173041 30291 0 0
srv_find_qd_qs_mism 1065691 1065691 0 0.00 0 11839 5 0 0
srv_make_invnt_saldo 524 524 0 0.00 43 109641 1378 0 0
srv_make_money_saldo 757 757 0 0.00 1 5717 39 0 0
srv_recalc_idx_stat 4 4 0 0.00 133265 485419 269573 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4763 4763 0 0.00 0 17961 215 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 0 5288 112 0 0
t$perf-norm:sp_cancel_client_order 1696 1696 0 0.00 0 10802 23 0 0
t$perf-norm:sp_cancel_customer_reserve 637 637 0 0.00 0 585 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 9391 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 346 346 0 0.00 0 4352 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 1673 27 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 20972 1594 0 0
t$perf-norm:sp_cancel_write_off 899 899 0 0.00 0 10458 24 0 0
t$perf-norm:sp_client_order 19682 19682 0 0.00 0 10849 18 0 0
t$perf-norm:sp_customer_reserve 1032 1032 0 0.00 0 3511 10 0 0
t$perf-norm:sp_pay_from_customer 6721 6721 0 0.00 0 9093 13 0 0
t$perf-norm:sp_pay_to_supplier 5467 5467 0 0.00 0 6185 13 0 0
t$perf-norm:sp_reserve_write_off 9396 9396 0 0.00 0 9661 15 0 0
t$perf-norm:sp_supplier_invoice 5157 5157 0 0.00 0 5595 20 0 0
t$perf-norm:sp_supplier_order 5238 5238 0 0.00 0 6452 18 0 0
t$perf-norm:srv_aggregate_perf_data 93 93 0 0.00 0 270 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 9166 65 0 0
t$perf-norm:srv_make_invnt_saldo 524 524 0 0.00 0 6348 45 0 0
t$perf-norm:srv_make_money_saldo 757 757 0 0.00 0 2258 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 9664 9498 166 1.71 0 13208 23 0 166
v_all_customers 35864 35864 0 0.00 0 20 1 0 0
v_all_suppliers 28448 28448 0 0.00 0 25 1 0 0
v_all_wares 39354 39354 0 0.00 0 16 1 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 2335 13 0 0
v_cancel_client_order 3392 3392 0 0.00 0 23435 22 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 2504 5 0 0
v_cancel_customer_reserve 1274 1274 0 0.00 0 20111 21 0 0
v_cancel_payment_to_supplier 692 692 0 0.00 0 8177 30 0 0
v_cancel_supplier_invoice 812 802 10 1.23 0 4295 26 0 10
v_cancel_supplier_order 818 818 0 0.00 0 23432 31 0 0
v_cancel_write_off 1798 1798 0 0.00 0 1583 13 0 0
v_max_id_clo_ord 5228 5228 0 0.00 0 412 1 0 0
v_max_id_clo_res 1032 1032 0 0.00 0 2399 10 0 0
v_max_id_ord_sup 5151 5151 0 0.00 0 6938 5 0 0
v_max_non_paid_invoice 1622 1622 0 0.00 0 649 2 0 0
v_max_non_paid_realizn 3591 3591 0 0.00 0 1838 4 0 0
v_min_id_clo_ord 5228 5228 0 0.00 0 4161 9 0 0
v_min_id_clo_res 1032 1032 0 0.00 0 3638 14 0 0
v_min_id_ord_sup 5151 5151 0 0.00 0 5674 7 0 0
v_min_non_paid_invoice 5467 5467 0 0.00 0 6792 15 0 0
v_min_non_paid_realizn 6721 6721 0 0.00 0 7238 20 0 0
v_our_firm 9750 9750 0 0.00 0 18 1 0 0
v_reserve_write_off 18780 18780 0 0.00 0 20114 12 0 0
x_lock_depdocs_on_canc_invoice 12049 12049 0 0.00 0 18425 120 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 13282 399 0 0
x_make_qstorno_1000_1200 5238 5238 0 0.00 1 40892 1271 0 0
x_make_qstorno_1200_2000 5157 5157 0 0.00 3 86297 3777 0 0
x_make_qstorno_2100_3300 442670 442670 0 0.00 0 86511 173 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-12-2020 01:28:05 to 31-12-2020 01:28:09.

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
22:57:10 7 8192000000 8807437696 8820396032 12184800 0.148 3 1 2 0 12363744 67056 111888
22:57:16 17225 8192000000 10232928400 10544541696 869653184 9.597 68 58 116 1 891654592 2389104 19612304
22:57:44 21042 8192000000 10316544192 10634190848 1364400640 14.277 100 82 164 1 1396492752 4864784 27227328
22:58:12 15940 8192000000 10359971744 10677145600 1414127648 14.721 100 88 178 0 1448146016 5549280 28469088
22:58:38 17927 8192000000 10387635008 10708172800 1438704512 14.938 100 88 176 0 1474117392 6343536 29069344
22:59:10 18664 8192000000 10413140416 10737942528 1455514704 15.086 100 77 154 1 1487867136 7054160 25298272
22:59:35 23183 8192000000 10433310272 10762264576 1478659376 15.290 100 84 168 1 1513722512 7399600 27663536
23:00:14 23922 8192000000 10459112032 10792853504 1512337712 15.584 100 92 184 0 1550041168 8221088 29482368
23:00:47 17816 8192000000 10456199408 10798170112 1518829536 15.640 100 84 168 0 1554022032 8562208 26630288
23:01:13 7311 8192000000 10464447856 10806964224 1529835840 15.736 100 79 158 0 1563055920 8571792 24648288
23:01:33 11453 8192000000 10486647504 10833362944 1547151152 15.885 100 73 146 0 1578587984 8785584 22651248
23:01:55 17076 8192000000 10517214032 10869092352 1566102448 16.049 100 76 152 2 1598461184 8520992 23837744
23:02:20 18045 8192000000 10545460432 10900701184 1609455536 16.420 100 86 172 1 1645352000 9785232 26111232
23:02:47 12365 8192000000 10577200048 10934382592 1630880688 16.602 100 75 150 0 1663335584 10232832 22222064
23:03:08 15959 8192000000 10598558240 10964275200 1655560912 16.811 100 72 144 1 1687160176 10302256 21297008
23:03:31 12626 8192000000 10622314480 10988740608 1682659680 17.040 100 77 153 1 1715932128 10850560 22421888
23:03:52 8554 8192000000 10645395872 11015933952 1695579392 17.148 100 76 152 2 1728581600 11557504 21444704
23:04:09 12063 8192000000 10670286976 11042353152 1725232656 17.396 100 84 168 4 1762373808 12842752 24298400
23:04:31 8342 8192000000 10682408016 11058536448 1740797424 17.525 100 81 159 2 1776900208 13509344 22593440
23:04:46 6233 8192000000 10697904080 11075280896 1757044240 17.660 100 83 166 0 1793818784 13207680 23566864
23:05:00 8006 8192000000 10708564848 11086864384 1766495200 17.738 100 81 162 1 1802447680 13238512 22713968
23:05:15 3280 8192000000 10724872560 11104677888 1776873632 17.824 100 86 173 0 1813746080 12352432 24520016
23:05:25 3696 8192000000 10728705152 11106299904 1792260160 17.950 100 89 177 0 1830714416 13165072 25289184
23:05:35 3174 8192000000 10731939920 11114283008 1791510416 17.944 100 86 172 1 1830168112 14436416 24221280
23:05:45 3335 8192000000 10734009456 11121307648 1794855648 17.972 100 80 158 2 1830485936 13490672 22139616
23:05:55 2849 8192000000 10744674912 11131334656 1801511680 18.026 100 88 174 1 1840910640 14151408 25247552
23:06:05 2677 8192000000 10750619104 11131990016 1808513456 18.084 100 85 171 0 1846031968 13914224 23604288
23:06:14 9892 8192000000 10748980112 11135852544 1807650336 18.077 100 79 158 1 1842073792 13179760 21243696
23:06:31 3366 8192000000 10759705008 11147730944 1813943632 18.128 100 79 156 0 1848046352 12084672 22018048
23:06:41 2907 8192000000 10772317728 11157540864 1828624608 18.248 100 88 176 2 1867288576 13520096 25143872
23:06:51 2259 8192000000 10777492256 11161473024 1834147088 18.293 100 89 177 2 1872285936 13430544 24708304
23:06:59 1981 8192000000 10772424752 11161845760 1839158512 18.334 100 87 174 0 1877799776 13530272 25110992
23:07:07 2420 8192000000 10786113472 11177238528 1843733008 18.371 100 85 169 1 1880668912 12933968 24001936
23:07:17 1886 8192000000 10789317136 11180711936 1847419600 18.401 100 91 183 1 1887154640 14127072 25607968
23:07:25 1680 8192000000 10791594720 11178409984 1850780752 18.428 100 93 185 2 1889766880 13484944 25501184
23:07:34 1586 8192000000 10797722208 11187077120 1856781328 18.477 100 90 178 1 1894370960 12496080 25093552
23:07:42 1925 8192000000 10799212976 11188637696 1857147408 18.480 100 82 162 1 1893404560 13112592 23144560
23:07:50 1489 8192000000 10808426464 11194941440 1859390896 18.498 100 89 178 1 1898654784 14359200 24904688
23:07:58 1775 8192000000 10806006784 11194273792 1860323584 18.506 100 93 187 3 1900060336 13577232 26159520
23:08:07 1593 8192000000 10802356496 11191451648 1862521216 18.524 100 92 184 1 1902481024 14125776 25834032
23:08:15 1672 8192000000 10812119792 11200516096 1864890064 18.543 100 88 174 1 1902928400 13124640 24913696
23:08:24 4581 8192000000 10805550160 11195416576 1865092896 18.545 100 88 177 2 1903459728 13290304 25076528
23:08:35 1355 8192000000 10809553520 11201122304 1867894944 18.567 100 94 189 0 1907527904 12846416 26786544
23:08:43 6263 8192000000 10791593760 11200475136 1865086368 18.544 100 73 146 1 1899625120 13865744 20673008
23:08:56 1047 8192000000 10818879648 11208142848 1873732784 18.614 100 96 192 0 1914233040 13684704 26815552
23:09:03 5478 8192000000 10791185712 11205812224 1866387616 18.555 100 53 106 0 1892121648 10672160 15061872
23:09:16 3754 8192000000 10783250960 11197861888 1867661744 18.565 100 28 56 0 1882131584 7244112 7225728
23:09:26 5478 8192000000 10790631824 11207565312 1869804304 18.583 100 38 76 1 1893447808 12666176 10977328
23:09:40 8454 8192000000 10801221600 11210842112 1872406752 18.604 100 33 65 1 1888411296 5938160 10066384
23:09:56 3457 8192000000 10799467712 11215065088 1878110240 18.650 100 50 101 0 1901583296 9508752 13964304
23:10:06 5671 8192000000 10808799328 11219267584 1877627104 18.646 100 44 89 0 1902168000 11786320 12754576
23:10:20 19231 8192000000 10793363312 11216355328 1881237568 18.675 100 23 47 2 1894541936 6493472 6810896
23:10:46 9151 8192000000 10782207424 11217408000 1883927344 18.697 100 27 54 3 1902630384 11330496 7372544
23:11:06 17491 8192000000 10781210208 11223302144 1881231744 18.675 100 17 33 2 1893062816 7374400 4456672
23:11:31 5118 8192000000 10803110736 11230916608 1888899456 18.737 100 31 62 0 1905376528 8011216 8465856
23:11:45 72463 8192000000 10795193808 11236597760 1890198592 18.747 100 40 80 0 1907757200 5266176 12292432
23:13:08 5550 8192000000 10814799936 11244175360 1894937168 18.786 100 32 63 2 1911395488 7674720 8783600
23:13:24 5069 8192000000 10800478368 11239792640 1900864928 18.833 100 27 54 3 1914019088 5317744 7836416
23:13:41 7022 8192000000 10818092240 11248078848 1899909664 18.826 100 30 60 0 1914794080 6105360 8779056
23:13:54 9670 8192000000 10805283904 11246714880 1898992896 18.818 100 18 36 1 1909994896 6022224 4979776
23:14:13 10688 8192000000 10814132400 11252244480 1904204272 18.860 100 20 40 0 1915618688 6019664 5394752
23:14:31 6710 8192000000 10814365888 11253374976 1904840496 18.865 100 27 54 1 1918577696 6379584 7357616
23:14:46 6254 8192000000 10828851200 11259559936 1905782288 18.873 100 18 36 0 1920766128 9749600 5234240
23:15:00 7955 8192000000 10819823824 11260055552 1906706096 18.880 100 15 30 2 1916981040 5986496 4288448
23:15:18 5910 8192000000 10820065088 11253035008 1890973936 18.754 99 28 58 1 1905893872 7183584 7736352
23:15:30 13293 8192000000 10806517280 11250069504 1884458752 18.701 99 22 44 2 1897101584 5900080 6742752
23:15:51 6335 8192000000 10818432160 11256664064 1906584448 18.879 100 23 45 3 1918976432 6053600 6338384
23:16:10 8080 8192000000 10801637456 11235414016 1844404128 18.377 97 16 32 1 1853684592 5110576 4169888
23:16:25 8374 8192000000 10775823696 11209281536 1825839936 18.225 97 22 44 2 1837635408 5374224 6421248
23:16:42 64588 8192000000 10789301136 11221397504 1878198496 18.651 100 43 86 3 1896304976 4701632 13404848
23:17:54 11585 8192000000 10799336128 11225919488 1850359024 18.425 98 30 59 1 1864551216 5993872 8198320
23:18:15 6262 8192000000 10779198336 11184672768 1809459104 18.091 96 43 85 2 1827361632 5618336 12284192
23:18:29 7191 8192000000 10742785280 11163611136 1770373024 17.770 96 24 48 1 1782609760 5448544 6788192
23:18:42 6966 8192000000 10756999904 11180294144 1824411504 18.214 99 27 54 0 1838624816 6370832 7842480
23:18:59 4937 8192000000 10695588240 11111026688 1702865936 17.209 93 36 70 3 1719890672 7299648 9725088
23:19:10 5317 8192000000 10724087840 11132383232 1779948272 17.849 99 28 56 1 1798202912 10690144 7564496
23:19:24 5288 8192000000 10726778096 11144355840 1794857216 17.972 99 30 60 0 1810546240 6483216 9205808
23:19:35 9159 8192000000 10689342960 11100139520 1677112336 16.993 93 24 48 1 1689191232 5029936 7048960
23:19:51 6477 8192000000 10680631504 11089403904 1716068336 17.319 97 23 45 0 1727854176 5064368 6721472
23:20:06 3808 8192000000 10704306480 11123392512 1793386096 17.960 100 21 42 1 1805604176 6111104 6106976
23:20:16 6320 8192000000 10704960288 11116273664 1778599360 17.838 99 24 48 3 1790445248 5607040 6238848
23:20:28 6109 8192000000 10716468592 11123818496 1760103616 17.685 98 25 50 3 1773778336 6529472 7145248
23:20:41 10118 8192000000 10683522752 11097903104 1739182784 17.512 97 23 46 1 1751387504 4969536 7235184
23:21:04 55966 8192000000 10698673056 11106926592 1700949456 17.193 94 34 66 0 1715487568 4874192 9663920
23:22:13 16308 8192000000 10726352544 11146416128 1787350512 17.910 99 18 36 0 1797997904 4897600 5749792
23:22:37 7587 8192000000 10744361824 11159683072 1806349728 18.066 99 38 76 2 1824442416 7489952 10602736
23:22:51 3669 8192000000 10760469584 11168530432 1831368544 18.270 100 42 84 0 1849752352 6493872 11889936
23:23:01 5846 8192000000 10761165984 11178455040 1834995488 18.300 100 41 82 2 1854386096 7733696 11656912
23:23:14 5488 8192000000 10775972576 11189653504 1846060512 18.390 100 31 62 1 1860682224 5651184 8970528
23:23:26 5162 8192000000 10772320592 11194507264 1855045744 18.463 100 40 82 0 1873576992 6592640 11938608
23:23:37 5676 8192000000 10755046976 11185053696 1846001504 18.390 100 21 42 2 1857728192 6019376 5707312
23:23:51 7580 8192000000 10766531712 11192057856 1852393232 18.442 100 21 42 1 1864053488 6290224 5370032
23:24:06 8836 8192000000 10775569536 11204366336 1857546304 18.483 100 21 41 2 1869816560 6054384 6215872
23:24:24 5564 8192000000 10778425200 11202928640 1861779168 18.518 100 25 51 1 1874627280 5855872 6992240
23:24:35 6064 8192000000 10775711840 11206721536 1861703232 18.517 100 22 44 0 1874420096 6107856 6609008
23:24:52 11317 8192000000 10775527872 11205369856 1864289376 18.538 100 22 45 0 1876366144 5581792 6494976
23:25:11 8704 8192000000 10789329840 11211096064 1863927056 18.535 100 19 38 1 1875116112 5223936 5965120
23:25:26 24056 8192000000 10794826064 11216003072 1871964576 18.600 100 16 32 1 1881559248 5478368 4116304
23:25:57 68338 8192000000 10786007856 11218911232 1876658160 18.638 100 31 60 2 1890646576 5722400 8266016
23:27:12 29172 8192000000 10828042496 11248320512 1902116480 18.843 100 43 84 0 1919955440 6115232 11723728
23:27:47 4630 8192000000 10832590512 11257917440 1916351088 18.958 100 50 99 3 1937688848 7398592 13939168
23:28:00 7745 8192000000 10850012656 11271606272 1920048464 18.987 100 48 97 0 1942049200 8150848 13849888
23:28:16 19278 8192000000 10846825568 11273543680 1922877744 19.010 100 46 90 0 1944845632 9327040 12640848
23:28:47 5189 8192000000 10866114208 11285983232 1930184176 19.068 100 46 92 2 1953457488 10212912 13060400
23:29:17 5076 8192000000 10885141376 11302354944 1944607456 19.184 100 62 126 1 1974029312 11251136 18170720
23:29:29 3315 8192000000 10886171760 11306549248 1951076464 19.235 100 65 130 0 1980479776 11601760 17801552
23:29:41 8733 8192000000 10890831952 11314192384 1951436064 19.238 100 60 120 0 1980988816 12673056 16879696
23:29:59 21646 8192000000 10889933568 11318132736 1952224528 19.244 100 52 104 3 1984575632 17979968 14371136
23:30:28 14263 8192000000 10893382080 11318738944 1959075600 19.299 100 45 90 1 1984109024 12556880 12476544
23:30:51 26621 8192000000 10888096576 11321544704 1942352064 19.166 99 46 92 0 1968436256 12816112 13268080
23:31:32 29242 8192000000 10882786208 11319123968 1951889520 19.242 100 41 81 2 1976979904 13483760 11606624
23:32:09 16041 8192000000 10898786464 11329409024 1962502064 19.326 100 30 60 0 1985937136 14082368 9352704
23:32:35 16529 8192000000 10913419104 11335434240 1968912416 19.377 100 56 110 1 1999515456 13198400 17404640
23:33:01 32602 8192000000 10904915456 11350511616 1975059920 19.426 100 41 82 3 2001669344 14799824 11809600
23:33:46 13259 8192000000 10914865600 11349667840 1978769824 19.455 100 40 80 0 2004289680 14083952 11435904
23:34:09 5935 8192000000 10921817376 11356651520 1983414256 19.492 100 46 90 2 2011576928 14517568 13645104
23:34:25 10882 8192000000 10911751280 11349712896 1978324656 19.451 100 43 86 1 2005705904 14805456 12575792
23:34:43 13643 8192000000 10914147360 11350773760 1980365872 19.468 100 39 77 1 2004464128 13243984 10854272
23:35:09 10237 8192000000 10918125088 11358916608 1985682224 19.510 100 44 86 1 2014220272 15782960 12755088
23:35:31 5852 8192000000 10921910000 11352694784 1972826944 19.408 99 53 106 3 2007482672 18524080 16131648
23:35:44 7355 8192000000 10943560416 11367665664 1975953824 19.433 99 64 128 1 2015896576 21097440 18845312
23:35:58 2332 8192000000 10940873536 11365007360 1991582416 19.556 100 62 119 0 2028909968 20973424 16354128
23:36:08 6188 8192000000 10959184576 11376537600 1993772480 19.574 100 67 131 1 2035605632 22545760 19287392
23:36:22 2830 8192000000 10955656176 11381522432 2001293392 19.633 100 69 139 0 2044390816 22846640 20250784
23:36:34 6221 8192000000 10949668000 11379093504 1978982368 19.457 99 59 117 1 2020753936 24735008 17036560
23:36:47 1814 8192000000 10954290448 11383848960 2002452960 19.642 100 69 136 0 2049162224 26558832 20150432
23:36:55 3524 8192000000 10966004304 11386744832 1999804720 19.621 100 78 151 2 2048890720 26325744 22760256
23:37:05 4205 8192000000 10962595152 11388145664 2000596944 19.627 100 78 156 1 2051124048 27090224 23436880
23:37:17 7124 8192000000 10946586592 11374178304 1992092960 19.560 100 71 139 1 2038475408 26168656 20213792
23:37:31 2102 8192000000 10954137120 11372945408 1989397312 19.539 100 76 151 0 2037710848 25695216 22618320
23:37:40 4202 8192000000 10933151424 11356549120 1971526128 19.398 100 53 104 3 2012501488 24861248 16114112
23:37:51 12160 8192000000 10934582464 11366735872 1979443264 19.460 100 66 132 1 2024591840 25568272 19580304
23:38:13 4609 8192000000 10931657904 11360731136 1975227120 19.427 100 58 116 0 2019769120 26731088 17810912
23:38:29 2922 8192000000 10941711488 11373531136 1984044224 19.497 100 66 131 1 2032423776 28149552 20230000
23:38:39 6289 8192000000 10925269984 11352481792 1963122112 19.331 99 48 96 2 2006165296 28285248 14757936
23:38:59 3510 8192000000 10941538960 11360690176 1973721600 19.415 100 74 146 2 2021320848 25487472 22111776
23:39:10 2662 8192000000 10948992640 11361677312 1981171728 19.474 100 82 164 2 2029763424 25065792 23525904
23:39:19 2606 8192000000 10949653856 11367755776 1980813968 19.471 100 79 156 1 2030099616 26266176 23019472
23:39:29 2103 8192000000 10958542496 11378884608 1986647888 19.517 100 83 166 2 2039682672 29297920 23736864
23:39:38 4670 8192000000 10946473552 11359379456 1967662560 19.367 99 74 148 0 2020929776 31591328 21675888
23:39:49 3235 8192000000 10953393648 11370512384 1976330576 19.436 100 80 160 1 2032168352 32417968 23419808
23:39:59 3476 8192000000 10940268656 11361288192 1957594048 19.287 99 77 154 0 2013061744 32816816 22650880
23:40:10 3803 8192000000 10940957472 11361710080 1972206368 19.403 100 81 160 2 2029059856 33138144 23715344
23:40:25 7181 8192000000 10935893584 11360329728 1956895952 19.281 99 71 142 2 2012021184 33674768 21450464
23:40:39 3329 8192000000 10926136256 11344527360 1948650480 19.216 99 76 152 0 2001481536 29736240 23094816
23:40:49 2601 8192000000 10912627248 11329007616 1922608576 19.008 98 80 156 2 1972625280 25778928 24237776
23:40:59 2158 8192000000 10860820688 11275481088 1863426576 18.531 96 77 149 2 1913512064 27199984 22885504
23:41:10 4862 8192000000 10891572944 11302359040 1919556000 18.983 100 72 145 1 1970736752 28484416 22696336
23:41:22 7689 8192000000 10868408896 11293298688 1910789088 18.913 100 53 107 0 1955782048 28683984 16308976
23:41:41 12737 8192000000 10867854512 11293917184 1908720976 18.896 100 47 92 5 1952108480 28430288 14957216
23:42:03 6385 8192000000 10866689664 11294236672 1896777696 18.800 99 44 88 2 1937638112 27282512 13577904
23:42:17 2682 8192000000 10882524688 11300483072 1916606368 18.960 100 51 102 3 1960253536 28161472 15485696
23:42:26 10812 8192000000 10866580672 11287232512 1876521184 18.637 98 57 112 1 1922646384 28930976 17194224
23:42:47 8956 8192000000 10872782064 11301425152 1909142352 18.900 100 45 90 2 1951016208 27908848 13965008
23:43:09 11269 8192000000 10889589552 11307950080 1919549248 18.983 100 56 113 1 1967076304 30398272 17128784
23:43:30 2114 8192000000 10888151392 11302899712 1919416592 18.982 100 69 139 0 1974078848 33817904 20844352
23:43:39 7520 8192000000 10909592544 11321401344 1936771472 19.121 100 67 133 2 1991198704 33921136 20506096
23:44:01 4603 8192000000 10924040304 11345391616 1947082640 19.203 100 57 112 0 2001715216 37295120 17337456
23:44:15 1855 8192000000 10945284320 11346927616 1953179200 19.252 100 88 176 0 2020427072 40056704 27191168
23:44:23 4544 8192000000 10927976608 11335061504 1928327584 19.054 99 84 165 0 1995470976 42087392 25056000
23:44:37 3458 8192000000 10938087680 11353214976 1954099216 19.259 100 79 158 0 2022720736 43581312 25040208
23:44:49 4359 8192000000 10946086800 11354828800 1942973008 19.170 99 84 168 3 2013132880 44403088 25756784
23:45:01 1535 8192000000 10932591792 11338162176 1935940144 19.114 99 79 156 1 2004377584 44416768 24020672
23:45:14 6990 8192000000 10943872272 11362750464 1957853232 19.289 100 75 149 2 2028347216 47459088 23034896
23:45:31 4917 8192000000 10942122656 11358937088 1963608512 19.335 100 76 150 1 2032176256 44571744 23996000
23:45:54 6507 8192000000 10900975184 11333857280 1908821728 18.897 98 39 77 1 1964606816 42489904 13295184
23:46:08 6382 8192000000 10916054432 11345760256 1941804640 19.161 100 46 92 0 2001187984 44646400 14736944
23:46:24 5202 8192000000 10921571440 11350810624 1950080208 19.227 100 41 82 3 2005251232 41717664 13453360
23:46:36 13126 8192000000 10916509152 11343781888 1943482560 19.175 100 39 78 1 1999361312 43238640 12640112
23:47:02 2551 8192000000 10961366624 11365797888 1967707888 19.367 100 90 180 2 2041068016 45946384 27413744
23:47:12 2036 8192000000 10954218128 11364450304 1962391040 19.325 100 83 166 1 2035788096 48081248 25315808
23:47:20 7253 8192000000 10940541584 11364421632 1957404752 19.285 100 59 116 2 2024380544 48684288 18291504
23:47:36 12043 8192000000 10919817632 11354722304 1933113392 19.092 99 40 80 0 1996201856 48895264 14193200
23:47:54 6721 8192000000 10931843200 11354169344 1945575680 19.191 100 43 86 0 2007616160 47607408 14433072
23:48:08 3568 8192000000 10940006880 11363852288 1956173808 19.276 100 53 104 2 2022097904 48554032 17370064
23:48:20 5123 8192000000 10962807616 11379236864 1966803792 19.360 100 57 114 1 2038803328 52940576 19058960
23:48:32 8337 8192000000 10966362416 11378810880 1952240960 19.244 99 72 144 1 2032521872 57038208 23242704
23:48:49 7993 8192000000 10969223840 11380604928 1948495824 19.214 99 74 143 2 2032334272 60872640 22965808
23:49:07 4398 8192000000 10994394448 11402772480 1978413968 19.452 100 81 162 1 2071007248 66892640 25700640
23:49:18 2418 8192000000 11011727152 11412504576 1985438064 19.508 100 92 184 2 2084140992 69614816 29088112
23:49:28 3576 8192000000 10978430880 11383865344 1951306160 19.237 98 83 166 3 2048817472 70525920 26985392
23:49:42 2187 8192000000 11000583760 11412176896 1980025184 19.465 100 87 172 1 2078528080 71359120 27143776
23:49:50 6850 8192000000 10978687296 11416965120 1977902816 19.448 100 55 110 0 2065146736 69407600 17836320
23:50:16 10237 8192000000 10981680608 11412148224 1979591440 19.461 100 45 90 0 2061880256 66465728 15823088
23:50:37 11777 8192000000 10983627920 11412193280 1977508848 19.445 100 53 106 2 2065560224 69926304 18125072
23:50:59 13492 8192000000 10972162320 11423444992 1978865824 19.456 100 39 78 1 2057356624 64924752 13566048
23:51:19 6225 8192000000 10963599920 11398258688 1957682656 19.288 99 40 80 1 2033816800 62493392 13640752
23:51:34 2282 8192000000 10971474112 11401760768 1971957472 19.401 100 58 116 2 2057864688 66903184 19004032
23:51:43 8005 8192000000 10972778608 11409231872 1971734096 19.399 100 38 76 0 2051905728 66972656 13198976
23:51:57 8397 8192000000 10971271680 11411161088 1974246880 19.419 100 45 90 1 2057660256 67746640 15666736
23:52:22 10925 8192000000 10973652800 11414118400 1981157152 19.474 100 38 76 2 2056747504 62832736 12757616
23:52:44 12527 8192000000 10972137776 11418218496 1984227216 19.498 100 33 66 1 2055832912 60452464 11153232
23:53:03 7495 8192000000 10971137856 11413999616 1992086000 19.560 100 36 72 0 2062222336 58220816 11915520
23:53:17 18704 8192000000 10977353536 11425112064 1988558864 19.532 100 30 60 1 2063567888 64862240 10146784
23:53:55 20074 8192000000 10970815248 11423318016 1974053728 19.418 100 28 56 0 2051716608 67433552 10229328
23:54:22 25732 8192000000 10964065456 11412246528 1954418432 19.262 99 32 64 0 2040953696 74811392 11723872
23:55:04 15800 8192000000 10964322784 11419152384 1948867664 19.217 100 32 64 1 2044499184 83487936 12143584
23:55:43 22747 8192000000 10931770592 11396169728 1926428480 19.038 100 24 48 0 2030459360 93814192 10216688
23:56:12 25699 8192000000 10887719040 11340308480 1870127120 18.585 97 17 34 0 1941064416 64190880 6746416
23:56:49 39136 8192000000 10847989632 11322015744 1895716720 18.792 99 25 50 1 1942134640 38876592 7541328
23:57:40 6162 8192000000 10875713392 11314405376 1922379136 19.006 100 26 50 0 1942666944 13654720 6633088
23:58:01 24318 8192000000 10884726992 11322798080 1945741328 19.193 100 27 56 1 1965971744 12700752 7529664
23:58:40 106869 8192000000 10888445248 11339243520 1942170176 19.164 99 50 100 2 1970490464 14119328 14200960
00:00:34 34412 8192000000 10893579392 11346591744 1961045792 19.314 100 17 34 1 1981394560 16221696 4127072
00:02:09 100919 8192000000 10916029648 11384455168 1973611520 19.414 100 17 34 0 1996966128 18560720 4793888
00:03:57 66258 8192000000 10936763120 11379421184 1986259424 19.514 100 30 60 0 2007961808 13029280 8673104
00:05:11 92690 8192000000 10895938496 11375669248 1943201040 19.172 98 16 33 1 1962879520 14978160 4700320
00:06:53 111876 8192000000 10896854752 11361505280 1945095600 19.187 98 26 52 1 1964954064 12258656 7599808
00:08:54 71306 8192000000 10888055440 11354996736 1917978144 18.971 97 27 54 3 1938796784 12058992 8759648
00:10:50 30665 8192000000 10908817424 11367489536 1964915680 19.345 99 52 104 0 1995466000 15122224 15428096
00:12:16 30133 8192000000 10893596880 11370070016 1970967552 19.393 100 17 35 0 1993324464 17052144 5304768
00:12:57 53279 8192000000 10922886144 11373416448 1972582128 19.406 100 9 18 2 1992969056 17178576 3208352
00:14:08 76675 8192000000 10905417616 11382300672 1986631264 19.517 100 11 22 0 2003415296 13652576 3131456
00:15:37 55735 8192000000 10909980832 11391176704 1989270416 19.538 100 12 24 0 2006381936 13483312 3628208
00:16:49 85923 8192000000 10920057072 11396775936 1988827184 19.535 100 16 32 0 2012359104 18433376 5098544
00:18:23 24206 8192000000 10916654992 11390218240 1994143216 19.577 100 45 87 0 2016360928 9787152 12430560
00:18:55 74008 8192000000 10901290944 11385114624 1977208192 19.443 99 28 55 2 1994187488 9415216 7564080
00:20:19 18935 8192000000 10914252176 11377442816 1977338256 19.444 99 22 44 4 1990539760 6844960 6356544
00:20:46 52524 8192000000 10912162672 11386834944 1978703056 19.454 99 30 60 0 1996429920 8949728 8777136
00:21:51 54235 8192000000 10892738096 11362435072 1952763840 19.248 98 19 38 1 1968136672 9665248 5707584
00:23:16 83732 8192000000 10875767232 11354337280 1944878016 19.186 98 10 20 0 1956563312 8871744 2813552
00:24:47 56342 8192000000 10879391760 11367858176 1929531568 19.063 98 10 20 1 1944042880 11571152 2940160
00:26:24 65750 8192000000 10910355552 11379585024 1941133728 19.156 98 16 32 2 1962336048 16973136 4229184
00:27:57 68684 8192000000 10903287440 11372982272 1949677568 19.224 99 17 34 0 1968013008 13596672 4738768
00:29:28 87302 8192000000 10913227680 11369357312 1951697792 19.240 98 24 47 1 1971226112 12721728 6806592
00:31:05 27063 8192000000 10905632480 11364368384 1959721520 19.304 99 51 102 1 1985637856 11207952 14708384
00:31:41 36716 8192000000 10879257552 11339677696 1947043424 19.203 99 40 80 1 1972201712 13810416 11347872
00:32:24 27454 8192000000 10884259008 11343822848 1901092624 18.835 97 37 74 0 1922364848 10958496 10313728
00:32:59 35699 8192000000 10896809760 11344019456 1906102016 18.875 97 33 66 1 1925423888 10318544 9003328
00:33:44 90505 8192000000 10891681024 11373453312 1962972096 19.330 100 26 52 2 1982658032 12920448 6765488
00:35:21 173041 8192000000 10872285920 11339460608 1795576400 17.978 91 14 27 1 1819866816 20581088 3709328
00:38:24 76527 8192000000 10877680288 11348799488 1853610256 18.451 95 16 32 1 1872072176 14243936 4217984
00:39:56 125769 8192000000 10922244272 11353116672 1952450768 19.246 100 10 19 1 1974724336 19729760 2543808
00:42:16 80928 8192000000 10839801696 11304304640 1864851024 18.543 95 19 38 0 1878337488 8324800 5161664
00:43:44 2088 8192000000 10860001424 11320872960 1918616240 18.976 99 34 65 3 1939278240 11225120 9436880
00:43:58 24446 8192000000 10866908608 11336495104 1941062160 19.155 100 29 58 1 1962516432 13241968 8212304
00:44:42 37261 8192000000 10817832272 11294158848 1852631296 18.443 96 11 22 0 1863795104 8468656 2695152
00:45:25 45879 8192000000 10839976928 11309875200 1884322784 18.700 98 13 25 1 1899920528 12401504 3196240
00:46:17 70859 8192000000 10853937376 11314331648 1873097360 18.609 97 9 18 2 1888301856 12614624 2589872
00:47:38 104587 8192000000 10858407312 11325480960 1915843504 18.954 99 13 26 0 1933005680 13496208 3665968
00:49:41 49832 8192000000 10833900592 11309477888 1874289744 18.619 97 11 22 1 1889021056 11702480 3028832
00:50:37 27432 8192000000 10829409264 11301322752 1912403424 18.926 100 16 31 1 1926394400 9139552 4851424
00:51:11 46177 8192000000 10834666416 11297193984 1891203280 18.755 98 26 52 1 1906902064 7856896 7841888
00:52:04 93201 8192000000 10840154912 11309776896 1888282608 18.732 98 25 48 1 1907186160 10758944 8144608
00:53:43 67033 8192000000 10846730144 11339198464 1926323744 19.037 100 11 22 1 1946009056 16432064 3253248
00:55:00 34253 8192000000 10858293248 11317854208 1900049424 18.827 98 23 46 1 1918927856 11665904 7212528
00:55:41 49683 8192000000 10863222848 11320705024 1884530240 18.702 97 25 50 0 1907212832 15408272 7274320
00:56:47 48804 8192000000 10897681136 11344551936 1929458704 19.063 99 23 46 3 1954035088 17985728 6590656
00:57:45 83240 8192000000 10888210208 11350028288 1903913616 18.858 97 31 60 1 1931538512 19046672 8578224
00:59:24 58669 8192000000 10882062048 11339456512 1936165872 19.116 99 13 26 0 1961189200 21443088 3580240
01:00:30 54202 8192000000 10902590336 11367972864 1966553344 19.358 100 33 66 3 1990946368 15580352 8812672
01:01:40 72778 8192000000 10905395936 11365724160 1937561456 19.127 98 17 34 1 1954070416 11593968 4914992
01:03:00 36245 8192000000 10914822816 11364270080 1926732160 19.041 98 29 58 0 1959018016 24523520 7762336
01:03:45 57266 8192000000 10901580960 11358679040 1910283712 18.909 97 31 62 0 1934252656 15147264 8821680
01:04:53 41158 8192000000 10912950224 11368243200 1969459120 19.381 100 29 58 2 1988889632 11366640 8063872
01:06:00 34557 8192000000 10934053968 11394834432 1984057040 19.497 100 39 78 2 2010225632 14692784 11475808
01:06:43 109915 8192000000 10905573440 11386294272 1948744800 19.216 98 21 41 1 1973803328 19304288 5754240
01:08:44 76473 8192000000 10903791168 11385528320 1988083248 19.529 100 24 48 0 2009662128 14855568 6723312
01:10:13 53678 8192000000 10927309728 11387146240 1993504752 19.571 100 33 66 0 2012289488 9542400 9242336
01:11:13 38163 8192000000 10910056832 11377442816 1972049376 19.402 99 34 70 1 1992980000 10274480 10656144
01:12:18 85262 8192000000 10855908624 11333255168 1880863312 18.672 95 6 12 0 1890052384 7612480 1576592
01:13:53 74292 8192000000 10877683936 11352588288 1939022864 19.139 99 13 26 0 1950396400 7576368 3797168
01:15:28 93735 8192000000 10894910448 11376390144 1960136544 19.307 99 8 16 0 1973079472 10566704 2376224
01:17:11 72070 8192000000 10900283200 11391492096 1976120848 19.434 100 11 22 0 1997014304 16837904 4055552
01:18:32 51586 8192000000 10890394656 11381907456 1947962256 19.210 98 13 26 0 1963069024 11792144 3314624
01:19:44 22917 8192000000 10911624512 11374686208 1959415936 19.301 99 22 44 0 1973241296 6682880 7142480
01:20:18 48473 8192000000 10914044160 11387199488 1965707552 19.351 99 13 26 0 1981536848 12236128 3593168
01:21:12 31905 8192000000 10911930320 11388514304 1953299504 19.253 98 20 40 0 1970632704 11319552 6013648
01:22:11 99518 8192000000 10907750368 11392245760 1970443600 19.389 99 21 42 0 1995405280 18457360 6504320
01:23:57 62004 8192000000 10904450608 11368280064 1906362768 18.877 96 18 36 0 1922005296 10560928 5081600
01:25:08 48407 8192000000 10896207088 11351343104 1917550448 18.967 97 27 54 0 1937255712 11769824 7935440
01:26:24 37443 8192000000 10903966960 11364073472 1942482544 19.167 99 19 38 0 1960773904 12897136 5394224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 31-12-2020 01:28:11 to 31-12-2020 01:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 83 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-12-2020 01:28:45 to 31-12-2020 01:28:47.

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

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