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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-22 22:27:14
DTS_END                         2021-01-22 22:27:14.5620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CLIENT_ORDER(57:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36898
TRN_ID                          240317
ATT_ID                          656
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: 9287.33 19200 1114479
customer order: creation 175.20 342 21024
customer order: refuse 15.33 370 1839
order to supplier: creation 46.43 1276 5572
order to supplier: removal 3.33 103845 400
invoice (draft): creation 46.18 3478 5542
invoice (draft): removal 53.75 709 6450
invoice accept: apply 42.67 18059 5120
invoice accept: cancel 48.44 737 5813
customer reserve: creation 3867.59 181 464111
customer reserve: removal 4680.77 58 561692
realization accept: apply 87.04 186 10445
realization accept: cancel 88.61 106 10633
payment from customer: creation 60.15 118 7218
payment from customer: removal 5.72 80 686
payment to supplier: creation 50.35 125 6042
payment to supplier: removal 3.34 92 401
service: total inventory turnovers 4.92 1213 590
service: total monetary turnovers 6.66 47 799
service: aggregate perf. data 0.82 24161 98
service: refresh index statistics 0.03 228817 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-01-2021 22:28:32 to 22-01-2021 22:28:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6216
TEST_TIME 2 4947
TEST_TIME 3 5534
TEST_TIME 4 5724
TEST_TIME 5 5987
TEST_TIME 6 5896
TEST_TIME 7 6305
TEST_TIME 8 6277
TEST_TIME 9 6538
TEST_TIME 10 6382
TEST_TIME 11 6478
TEST_TIME 12 6985
TEST_TIME 13 7102
TEST_TIME 14 7222
TEST_TIME 15 7112
TEST_TIME 16 7249
TEST_TIME 17 7494
TEST_TIME 18 7826
TEST_TIME 19 8416
TEST_TIME 20 8350
TEST_TIME 21 8594
TEST_TIME 22 8873
TEST_TIME 23 9292
TEST_TIME 24 9140
TEST_TIME 25 9241
TEST_TIME 26 9830
TEST_TIME 27 10240
TEST_TIME 28 10205
TEST_TIME 29 10912
TEST_TIME 30 10888
TEST_TIME 31 10952
TEST_TIME 32 10900
TEST_TIME 33 10783
TEST_TIME 34 10622
TEST_TIME 35 10626
TEST_TIME 36 10344
TEST_TIME 37 10525
TEST_TIME 38 10283
TEST_TIME 39 10280
TEST_TIME 40 10179
TEST_TIME 41 10166
TEST_TIME 42 10121
TEST_TIME 43 10116
TEST_TIME 44 10088
TEST_TIME 45 10008
TEST_TIME 46 9986
TEST_TIME 47 10019
TEST_TIME 48 9889
TEST_TIME 49 9933
TEST_TIME 50 9884
TEST_TIME 51 9861
TEST_TIME 52 9748
TEST_TIME 53 9767
TEST_TIME 54 9691
TEST_TIME 55 9685
TEST_TIME 56 9814
TEST_TIME 57 9810
TEST_TIME 58 9768
TEST_TIME 59 9816
TEST_TIME 60 9835
TEST_TIME 61 9873
TEST_TIME 62 9894
TEST_TIME 63 9849
TEST_TIME 64 9798
TEST_TIME 65 9802
TEST_TIME 66 9839
TEST_TIME 67 9866
TEST_TIME 68 9788
TEST_TIME 69 9765
TEST_TIME 70 9666
TEST_TIME 71 9601
TEST_TIME 72 9609
TEST_TIME 73 9547
TEST_TIME 74 9551
TEST_TIME 75 9449
TEST_TIME 76 9470
TEST_TIME 77 9451
TEST_TIME 78 9504
TEST_TIME 79 9448
TEST_TIME 80 9419
TEST_TIME 81 9379
TEST_TIME 82 9557
TEST_TIME 83 9664
TEST_TIME 84 9645
TEST_TIME 85 9666
TEST_TIME 86 9693
TEST_TIME 87 9650
TEST_TIME 88 9670
TEST_TIME 89 9611
TEST_TIME 90 9580
TEST_TIME 91 9560
TEST_TIME 92 9519
TEST_TIME 93 9514
TEST_TIME 94 9459
TEST_TIME 95 9418
TEST_TIME 96 9412
TEST_TIME 97 9510
TEST_TIME 98 9467
TEST_TIME 99 9429
TEST_TIME 100 9496
TEST_TIME 101 9516
TEST_TIME 102 9466
TEST_TIME 103 9474
TEST_TIME 104 9516
TEST_TIME 105 9610
TEST_TIME 106 9604
TEST_TIME 107 9614
TEST_TIME 108 9582
TEST_TIME 109 9522
TEST_TIME 110 9493
TEST_TIME 111 9470
TEST_TIME 112 9446
TEST_TIME 113 9393
TEST_TIME 114 9387
TEST_TIME 115 9378
TEST_TIME 116 9349
TEST_TIME 117 9349
TEST_TIME 118 9359
TEST_TIME 119 9358
TEST_TIME 120 9288

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-01-2021 22:28:36 to 22-01-2021 22:28:39.

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 1544405 1544405 0 0.00 0 32829 6 0 0
doc_list_biud 1544405 1544405 0 0.00 0 46483 27 0 0
sp_add_invoice_to_stock 5269 5120 149 2.82 36 196007 18060 0 149
sp_cancel_adding_invoice 5813 5813 0 0.00 6 60976 737 0 0
sp_cancel_client_order 1839 1839 0 0.00 4 10853 371 0 0
sp_cancel_customer_reserve 561692 561692 0 0.00 1 35995 58 0 0
sp_cancel_pay_from_customer 686 686 0 0.00 3 4650 81 0 0
sp_cancel_pay_to_supplier 401 401 0 0.00 3 6904 92 0 0
sp_cancel_supplier_invoice 6465 6450 15 0.23 2 26193 710 0 15
sp_cancel_supplier_order 400 400 0 0.00 9 982446 103846 0 0
sp_cancel_write_off 10633 10633 0 0.00 1 8871 107 0 0
sp_client_order 21024 21024 0 0.00 3 26278 343 0 0
sp_customer_reserve 464111 464111 0 0.00 0 116471 181 0 0
sp_fill_shopping_cart 32123 32123 0 0.00 1 10800 39 0 0
sp_fill_shopping_cart_clo_res 464104 464104 0 0.00 0 16359 13 0 0
sp_get_clo_for_invoice 5113 5113 0 0.00 0 34305 271 0 0
sp_kill_cost_storno 17533 17533 0 0.00 0 10667 54 0 0
sp_kill_qstorno_ret_qs2qd 1140867 1140867 0 0.00 0 33303 31 0 0
sp_kill_qty_storno 602384 602384 0 0.00 0 46481 68 0 0
sp_lock_selected_doc 21441 21441 0 0.00 0 11020 8 0 0
sp_make_cost_storno 28817 28817 0 0.00 0 11206 53 0 0
sp_multiply_rows_for_pdistr 28817 28817 0 0.00 0 7281 28 0 0
sp_multiply_rows_for_qdistr 21024 21024 0 0.00 0 25736 169 0 0
sp_pay_from_customer 7218 7218 0 0.00 4 17446 119 0 0
sp_pay_to_supplier 6042 6042 0 0.00 4 9898 125 0 0
sp_payment_common 13260 13260 0 0.00 1 11487 30 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 0 10843 344 0 0
sp_qd_handle_on_invoice_upd_sts 10925 10925 0 0.00 0 46474 319 0 0
sp_qd_handle_on_reserve_upd_sts 10445 10445 0 0.00 0 15333 59 0 0
sp_reserve_write_off 10445 10445 0 0.00 7 15417 187 0 0
sp_supplier_invoice 5542 5542 0 0.00 6 101876 3479 0 0
sp_supplier_order 5572 5572 0 0.00 5 30587 1276 0 0
srv_aggregate_perf_data 98 98 0 0.00 2289 639714 24162 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1275 170923 30743 0 0
srv_find_qd_qs_mism 1066229 1066229 0 0.00 0 32827 5 0 0
srv_make_invnt_saldo 590 590 0 0.00 26 91058 1213 0 0
srv_make_money_saldo 799 799 0 0.00 1 7623 47 0 0
srv_recalc_idx_stat 4 4 0 0.00 144317 353040 228818 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5120 5120 0 0.00 0 8793 169 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 3375 86 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 14345 21 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 3300 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 686 686 0 0.00 0 5380 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 401 401 0 0.00 0 2554 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 434 434 0 0.00 0 1337 13 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 23661 1435 0 0
t$perf-norm:sp_cancel_write_off 1022 1022 0 0.00 0 9856 16 0 0
t$perf-norm:sp_client_order 21024 21024 0 0.00 0 11229 18 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 2625 6 0 0
t$perf-norm:sp_pay_from_customer 7218 7218 0 0.00 0 3915 9 0 0
t$perf-norm:sp_pay_to_supplier 6042 6042 0 0.00 0 7673 13 0 0
t$perf-norm:sp_reserve_write_off 10445 10445 0 0.00 0 8471 11 0 0
t$perf-norm:sp_supplier_invoice 5542 5542 0 0.00 0 11881 24 0 0
t$perf-norm:sp_supplier_order 5572 5572 0 0.00 0 4698 16 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 1967 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 143 2 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 2000 25 0 0
t$perf-norm:srv_make_money_saldo 799 799 0 0.00 0 9387 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10522 10224 298 2.83 0 4590 19 0 298
v_all_customers 38114 38114 0 0.00 0 19 1 0 0
v_all_suppliers 30944 30944 0 0.00 0 215 1 0 0
v_all_wares 42048 42048 0 0.00 0 21 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 3121 13 0 0
v_cancel_client_order 3678 3678 0 0.00 0 3340 5 0 0
v_cancel_customer_prepayment 1372 1372 0 0.00 0 4454 10 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 4522 10 0 0
v_cancel_payment_to_supplier 802 802 0 0.00 0 3376 9 0 0
v_cancel_supplier_invoice 898 868 30 3.34 0 1727 16 0 30
v_cancel_supplier_order 800 800 0 0.00 0 1284 5 0 0
v_cancel_write_off 2044 2044 0 0.00 0 4336 20 0 0
v_max_id_clo_ord 5572 5572 0 0.00 0 2062 2 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 4348 25 0 0
v_max_id_ord_sup 5527 5527 0 0.00 0 6546 6 0 0
v_max_non_paid_invoice 1669 1669 0 0.00 0 1494 4 0 0
v_max_non_paid_realizn 3915 3915 0 0.00 0 6125 8 0 0
v_min_id_clo_ord 5572 5572 0 0.00 0 4651 9 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 4016 11 0 0
v_min_id_ord_sup 5527 5527 0 0.00 0 6791 11 0 0
v_min_non_paid_invoice 6042 6042 0 0.00 0 6653 18 0 0
v_min_non_paid_realizn 7218 7218 0 0.00 0 7353 18 0 0
v_our_firm 10540 10540 0 0.00 0 22 1 0 0
v_reserve_write_off 20890 20890 0 0.00 0 5059 7 0 0
x_lock_depdocs_on_canc_invoice 11829 11829 0 0.00 0 16614 127 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 21168 477 0 0
x_make_qstorno_1000_1200 5572 5572 0 0.00 1 30573 1182 0 0
x_make_qstorno_1200_2000 5542 5542 0 0.00 2 101864 3347 0 0
x_make_qstorno_2100_3300 464111 464111 0 0.00 0 116398 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-01-2021 22:28:40 to 22-01-2021 22:28:44.

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
19:57:18 3 8192000000 8802568928 8814100480 8233680 0.100 2 1 2 0 8353088 56848 62560
19:57:24 11312 8192000000 10185985392 10485362688 833016384 9.230 67 49 102 0 852551264 2397056 17137824
19:57:45 26794 8192000000 10329215328 10643816448 1374807072 14.370 100 87 173 1 1406931856 4281120 27843664
19:58:25 24483 8192000000 10376578320 10697523200 1426203504 14.828 100 88 176 2 1461132544 6075120 28853920
19:59:06 18020 8192000000 10408411712 10734530560 1457942752 15.108 100 91 182 0 1495067600 7333760 29791088
19:59:37 15028 8192000000 10419148944 10748563456 1477827344 15.282 100 91 181 1 1515146896 8038064 29281488
20:00:00 17160 8192000000 10429141424 10761777152 1487334064 15.366 100 86 170 2 1523183584 8312736 27536784
20:00:30 19312 8192000000 10457574000 10794770432 1514677472 15.604 100 88 176 1 1551654224 8728688 28248064
20:01:00 18668 8192000000 10483281888 10828320768 1530260176 15.739 100 75 150 0 1563584000 8684464 24639360
20:01:28 10450 8192000000 10507488592 10857021440 1565148288 16.041 100 79 158 0 1598621840 8992752 24480800
20:01:47 17938 8192000000 10534209792 10888216576 1585363552 16.214 100 79 159 0 1619874272 9921104 24589616
20:02:20 11781 8192000000 10548531728 10904612864 1611336320 16.436 100 76 152 1 1644796288 9793552 23666416
20:02:42 15867 8192000000 10564492400 10931732480 1631660960 16.609 100 75 149 0 1664026608 10233168 22132480
20:03:06 11651 8192000000 10596453856 10962960384 1651511312 16.777 100 79 157 2 1685648848 10507808 23629728
20:03:26 15097 8192000000 10620315824 10986196992 1676813184 16.991 100 78 156 3 1710772032 11190800 22768048
20:03:50 7044 8192000000 10639254384 11005730816 1687169600 17.078 100 72 144 0 1719367664 11016512 21181552
20:04:06 7175 8192000000 10642238528 11010940928 1700595376 17.190 100 77 153 1 1734273936 11555360 22123200
20:04:19 10068 8192000000 10658377072 11028197376 1711579520 17.282 100 74 148 1 1744825248 11728832 21516896
20:04:38 7766 8192000000 10662779616 11039846400 1730587008 17.440 100 72 144 0 1763556512 12461664 20507840
20:04:55 7000 8192000000 10689068368 11067346944 1744740176 17.558 100 73 146 2 1778265584 13065728 20459680
20:05:10 6676 8192000000 10693527744 11075731456 1764233968 17.719 100 78 152 3 1798568240 12675472 21658800
20:05:28 5019 8192000000 10709319888 11092758528 1773693376 17.797 100 79 158 0 1809442560 12801024 22948160
20:05:40 7230 8192000000 10714170992 11101278208 1781305984 17.860 100 77 155 1 1814975152 12197456 21471712
20:05:57 4480 8192000000 10728266832 11113893888 1795885808 17.980 100 74 148 1 1829213712 12375216 20952688
20:06:08 3459 8192000000 10747192288 11130724352 1806941648 18.071 100 83 166 0 1842252704 12106624 23204432
20:06:19 4794 8192000000 10756021232 11140919296 1819115392 18.170 100 86 170 2 1853998496 11405696 23477408
20:06:36 4994 8192000000 10751050560 11142602752 1817778640 18.160 100 75 150 4 1850326064 11514224 21033200
20:06:47 2894 8192000000 10772365616 11161661440 1836216736 18.310 100 81 163 1 1871563952 12653376 22693840
20:06:57 3812 8192000000 10777311664 11169845248 1840265792 18.343 100 83 165 0 1876712256 12683680 23762784
20:07:08 3732 8192000000 10787847376 11174002688 1845361296 18.384 100 86 170 2 1882411072 12359936 24689840
20:07:18 3492 8192000000 10787367328 11178024960 1847650416 18.403 100 87 174 2 1885016192 13319904 24045872
20:07:29 2537 8192000000 10794290784 11182186496 1854206128 18.456 100 87 174 0 1893239744 14467456 24566160
20:07:39 2218 8192000000 10798255648 11189415936 1859523536 18.499 100 89 178 1 1898782208 14454352 24804320
20:07:49 2612 8192000000 10803522720 11193212928 1859454016 18.499 100 86 168 2 1897708960 13966544 24288400
20:07:58 3057 8192000000 10812457968 11200679936 1867161264 18.561 100 94 188 1 1907500912 14260080 26079568
20:08:08 2115 8192000000 10805172896 11199983616 1867940464 18.568 100 88 175 1 1905804208 13100592 24763152
20:08:16 1969 8192000000 10815603904 11205484544 1874325712 18.619 100 90 179 0 1912190192 12967216 24897264
20:08:24 1879 8192000000 10816054800 11204562944 1873694864 18.614 100 85 170 0 1910342000 12954112 23693024
20:08:32 1822 8192000000 10820094864 11209261056 1874241648 18.619 100 91 184 0 1914813536 14977696 25594192
20:08:42 1944 8192000000 10817911056 11212890112 1876660016 18.638 100 85 170 0 1915631248 14491456 24479776
20:08:51 1909 8192000000 10828045392 11219992576 1882807616 18.688 100 89 176 0 1921703424 14144656 24751152
20:08:59 2226 8192000000 10828819296 11220832256 1883566176 18.694 100 89 178 4 1922922576 14265056 25091344
20:09:08 1654 8192000000 10828901568 11222925312 1884789552 18.704 100 87 174 0 1923400800 14079568 24531680
20:09:16 1667 8192000000 10831433744 11222102016 1885237712 18.707 100 87 174 2 1924634224 12856192 26540320
20:09:24 1900 8192000000 10834210160 11227099136 1887061920 18.722 100 91 184 1 1926026640 12878608 26086112
20:09:33 13057 8192000000 10831446496 11227189248 1888714720 18.735 100 87 175 0 1926224592 12627840 24882032
20:09:53 1120 8192000000 10834836512 11231404032 1890802576 18.752 100 87 174 2 1927639856 12009168 24828112
20:10:00 1649 8192000000 10841724880 11234652160 1892863328 18.769 100 93 186 0 1932161824 11946032 27352464
20:10:08 1803 8192000000 10844687184 11236388864 1899203536 18.820 100 94 188 0 1939324016 13670800 26449680
20:10:16 11029 8192000000 10841132784 11237113856 1897338064 18.805 100 94 188 2 1937904352 13993952 26572336
20:10:34 1822 8192000000 10830741024 11234955264 1893880656 18.777 100 88 176 2 1932390752 12918304 25591792
20:10:42 17312 8192000000 10809890032 11223019520 1889347008 18.741 100 47 96 2 1909882224 7442240 13092976
20:11:09 4423 8192000000 10806218256 11225415680 1891744096 18.760 100 46 92 1 1912246480 7797808 12704576
20:11:20 5047 8192000000 10810339120 11227885568 1889877632 18.745 100 46 92 2 1912089488 9702000 12509856
20:11:31 3846 8192000000 10833215072 11233886208 1892627424 18.767 100 54 107 0 1917982464 10102464 15252576
20:11:43 3779 8192000000 10806257888 11233824768 1892752256 18.768 100 37 74 2 1912276288 8791056 10732976
20:11:54 7257 8192000000 10794354240 11229335552 1892269744 18.764 100 29 57 4 1907575312 7399056 7906512
20:12:10 10928 8192000000 10809192224 11236470784 1899970640 18.826 100 27 52 1 1914283056 7119184 7193232
20:12:31 6431 8192000000 10798565584 11236233216 1899415456 18.822 100 21 42 0 1912253808 7240192 5598160
20:12:44 14579 8192000000 10800564400 11240947712 1902066560 18.843 100 21 42 2 1914775232 6269760 6438912
20:13:05 10027 8192000000 10809354624 11243769856 1902243744 18.844 100 15 29 2 1912071216 5632400 4195072
20:13:21 6696 8192000000 10819622960 11251273728 1906048480 18.875 100 20 40 1 1921628448 10158768 5421200
20:13:34 4524 8192000000 10832799776 11248996352 1908257488 18.893 100 26 52 2 1921070864 4998816 7814560
20:13:45 6482 8192000000 10827814016 11256877056 1912115104 18.924 100 32 64 1 1927487408 6854816 8517488
20:14:03 16833 8192000000 10811940416 11246489600 1904838368 18.865 100 18 35 1 1916343264 6561648 4943248
20:14:27 9952 8192000000 10829307312 11250397184 1911971392 18.922 100 50 100 3 1933240384 6244976 15024016
20:14:46 49495 8192000000 10814868208 11256647680 1908469968 18.894 100 28 56 2 1922138896 5078096 8590832
20:15:54 14110 8192000000 10832793008 11262537728 1915542720 18.951 100 29 58 0 1930073904 6491072 8040112
20:16:14 8159 8192000000 10834485152 11272962048 1916639600 18.960 100 33 66 1 1933693248 8023920 9029728
20:16:33 6515 8192000000 10841424256 11269103616 1911306768 18.917 100 27 54 0 1925120704 5857072 7956864
20:16:48 6104 8192000000 10833682432 11268923392 1913804992 18.937 100 25 50 0 1927720832 6800464 7115376
20:17:01 7311 8192000000 10824477232 11263655936 1896751536 18.800 99 25 52 0 1911088624 6980176 7356912
20:17:15 5980 8192000000 10784219152 11212566528 1830487104 18.263 96 29 57 4 1844072176 5476896 8108176
20:17:31 9462 8192000000 10810773552 11244081152 1882520048 18.685 99 33 66 1 1898200688 5930800 9749840
20:17:48 7826 8192000000 10788918912 11217092608 1814258736 18.131 96 26 53 1 1828262640 6306272 7697632
20:18:03 8382 8192000000 10776579888 11209015296 1826843408 18.234 97 24 48 2 1838904896 5165584 6895904
20:18:19 8431 8192000000 10767324624 11195920384 1824365520 18.213 98 16 32 0 1834756512 5290256 5100736
20:18:36 4616 8192000000 10752681952 11171397632 1781855504 17.865 96 31 62 1 1796870448 6332048 8682896
20:18:47 6772 8192000000 10757747968 11183693824 1830594736 18.264 99 25 50 1 1844483136 6063456 7824944
20:19:03 8397 8192000000 10756331392 11182796800 1818799216 18.168 98 21 42 3 1830986240 5638064 6548960
20:19:17 8694 8192000000 10739686960 11159130112 1781717104 17.864 97 19 38 0 1792339520 4925504 5696912
20:19:39 10825 8192000000 10737917360 11153539072 1777473616 17.829 97 20 40 4 1789059392 5513376 6072400
20:19:57 73639 8192000000 10755503312 11154083840 1743044224 17.544 95 36 72 2 1761460528 5507808 12908496
20:21:17 1390 8192000000 10788547296 11187273728 1831942144 18.275 99 85 171 2 1867493696 10911696 24639856
20:21:31 4676 8192000000 10730326464 11144605696 1791843424 17.947 99 32 64 1 1811887920 10841472 9203024
20:21:44 7322 8192000000 10721385136 11137433600 1780020448 17.850 98 30 58 2 1793876512 5991696 7864368
20:21:57 3305 8192000000 10723853408 11128512512 1777242384 17.827 98 38 76 2 1796270256 7319472 11708400
20:22:08 2691 8192000000 10734550864 11134144512 1797748624 17.995 100 35 69 0 1816091392 8261856 10080912
20:22:16 7528 8192000000 10733740576 11145330688 1779842256 17.848 98 32 64 3 1796038656 6621760 9574640
20:22:30 5568 8192000000 10711984592 11127025664 1767136768 17.743 98 33 64 0 1787277824 11250736 8890320
20:22:42 4050 8192000000 10712026864 11127402496 1786030016 17.899 99 49 98 0 1810843968 10486048 14327904
20:22:52 8413 8192000000 10717436688 11132047360 1797960224 17.997 100 29 55 1 1811916176 5565888 8390064
20:23:09 38124 8192000000 10758698928 11169640448 1827701104 18.241 100 59 118 1 1851998448 6004832 18292512
20:23:58 9992 8192000000 10743022528 11167113216 1802099072 18.031 98 25 49 0 1814531440 5733360 6699008
20:24:16 7304 8192000000 10740480640 11156307968 1802067680 18.031 98 31 62 1 1817282816 6889136 8326000
20:24:31 4535 8192000000 10749052416 11170254848 1831750256 18.274 100 32 64 0 1848323792 7012496 9561040
20:24:42 4846 8192000000 10766047120 11185377280 1843464256 18.369 100 41 82 0 1862710736 7841440 11405040
20:24:56 7099 8192000000 10767977952 11191373824 1846235632 18.392 100 25 49 2 1863799584 10285456 7278496
20:25:10 7153 8192000000 10754892368 11189137408 1849453328 18.418 100 28 56 3 1863651920 6208096 7990496
20:25:23 6585 8192000000 10765615888 11192430592 1851428272 18.434 100 36 71 1 1867979088 6146416 10404400
20:25:37 6637 8192000000 10772372656 11188473856 1833902992 18.291 99 36 70 2 1850477968 6427744 10147232
20:25:51 6920 8192000000 10771797968 11193364480 1855349408 18.466 100 33 66 1 1871318416 6121856 9847152
20:26:05 9480 8192000000 10778500656 11199115264 1856100832 18.472 100 24 48 0 1868317888 4935520 7281536
20:26:21 5576 8192000000 10774331056 11201171456 1858186432 18.489 100 21 43 3 1869369360 4990784 6192144
20:26:38 10577 8192000000 10789153632 11204022272 1860935712 18.511 100 26 52 0 1873937616 4859376 8142528
20:27:02 63503 8192000000 10813094656 11230150656 1876843744 18.640 100 35 71 0 1892477712 4792384 10841584
20:28:13 11880 8192000000 10823906960 11244093440 1891500048 18.758 100 40 78 1 1909155184 7001072 10654064
20:28:33 6959 8192000000 10846816864 11259973632 1908163200 18.892 100 66 132 2 1935410048 8834336 18412512
20:28:55 2565 8192000000 10848753376 11263660032 1909802176 18.905 100 71 140 2 1939979104 11015472 19161456
20:29:06 16374 8192000000 10850168128 11266146304 1914793216 18.945 100 55 110 1 1940215280 9954400 15467664
20:29:35 29647 8192000000 10864522192 11281850368 1920874176 18.994 100 61 122 1 1949425312 11427888 17123248
20:30:38 15807 8192000000 10867544864 11289395200 1933202272 19.092 100 52 104 2 1962088208 14055056 14830880
20:31:02 10585 8192000000 10870392064 11295965184 1938335360 19.133 100 50 101 2 1965689472 12747392 14606720
20:31:20 10828 8192000000 10875437248 11303231488 1941011072 19.155 100 48 96 0 1967816720 12830976 13974672
20:31:40 6662 8192000000 10874138416 11302281216 1944515712 19.183 100 47 93 0 1974450000 16838176 13096112
20:32:02 14145 8192000000 10886473552 11313373184 1949873232 19.225 100 45 90 1 1978183744 15051184 13259328
20:32:28 19022 8192000000 10883403264 11318104064 1951458464 19.238 100 43 86 0 1977934944 13836976 12639504
20:32:55 9651 8192000000 10890787056 11318382592 1956153952 19.275 100 46 92 0 1982646560 13380992 13111616
20:33:14 1754 8192000000 10917397088 11326824448 1963116272 19.331 100 67 133 1 1995885504 13804336 18964896
20:33:23 2624 8192000000 10918334576 11331330048 1966394432 19.357 100 69 137 2 2001419200 14803728 20221040
20:33:34 20557 8192000000 10919084320 11343179776 1970471328 19.389 100 59 116 0 2003246256 16176272 16598656
20:34:08 4735 8192000000 10933776208 11351699456 1978293280 19.451 100 69 136 1 2017376336 19685552 19397504
20:34:21 17014 8192000000 10918109440 11345178624 1960660240 19.311 99 58 115 0 1998598144 21556480 16381424
20:34:46 8974 8192000000 10923460064 11346100224 1975738304 19.431 100 53 106 0 2013409648 21676912 15994432
20:35:02 10507 8192000000 10920225968 11355078656 1978148048 19.450 100 45 90 1 2012113104 20198304 13766752
20:35:37 13859 8192000000 10941722688 11369246720 1989050976 19.536 100 58 117 3 2030634176 24494784 17088416
20:36:04 9606 8192000000 10941167520 11364675584 1982347712 19.483 100 56 112 0 2024073008 25119712 16605584
20:36:23 14378 8192000000 10927060560 11358064640 1982042576 19.481 100 46 92 2 2017952064 22285040 13624448
20:36:45 16046 8192000000 10935712400 11369066496 1986387296 19.515 100 53 106 1 2023610720 21728272 15495152
20:37:18 9810 8192000000 10932431792 11369435136 1980565248 19.469 100 46 92 1 2018807552 24821472 13420832
20:37:35 2656 8192000000 10947901952 11372482560 1990781984 19.550 100 74 149 2 2038850144 24796640 23271520
20:37:45 6579 8192000000 10958659536 11378913280 1993811856 19.574 100 72 144 2 2042289408 26459056 22018496
20:38:04 2376 8192000000 10965057776 11385348096 1996556704 19.596 100 65 132 1 2046888832 31270400 19061728
20:38:13 6510 8192000000 10956866512 11387338752 1997202176 19.601 100 66 130 2 2045066560 28154128 19710256
20:38:26 2921 8192000000 10978611680 11396055040 2004549936 19.659 100 87 173 2 2060579904 29177072 26852896
20:38:36 5221 8192000000 10968319696 11393536000 2004984736 19.662 100 81 162 0 2060613632 31341552 24287344
20:38:52 10005 8192000000 10977053456 11397414912 2009125424 19.695 100 79 158 0 2064276688 31772304 23378960
20:39:13 5596 8192000000 10979251104 11403980800 2011903280 19.716 100 69 136 1 2063695440 31328656 20463504
20:39:25 2473 8192000000 10988918672 11409592320 2016596576 19.753 100 86 172 2 2075071472 33434000 25040896
20:39:35 4865 8192000000 10969740048 11397595136 1990823792 19.550 99 73 143 0 2044847056 32419504 21603760
20:39:48 4020 8192000000 10965548240 11374718976 1990470384 19.548 99 82 165 0 2046854960 31758688 24625888
20:39:59 1897 8192000000 10983812576 11394101248 2002699552 19.644 100 85 167 1 2059513040 32405584 24407904
20:40:10 4099 8192000000 10985809920 11404570624 2007592880 19.683 100 86 166 0 2065100080 33279392 24227808
20:40:22 5243 8192000000 10987867504 11407327232 2012723376 19.723 100 75 150 3 2069394176 34531552 22139248
20:40:34 6597 8192000000 10984325168 11401494528 2007678944 19.683 100 83 166 1 2067062352 34760608 24622800
20:40:47 6585 8192000000 10973640880 11400638464 2004379248 19.657 100 58 114 0 2055245712 34116544 16749920
20:41:02 5653 8192000000 10969166704 11402108928 2003456144 19.650 100 56 111 1 2053647264 33689152 16501968
20:41:14 2851 8192000000 10954695248 11369910272 1958984512 19.298 98 78 158 0 2016185264 33798176 23402576
20:41:25 5600 8192000000 10951171408 11374903296 1981763488 19.479 100 65 130 0 2034276832 33066624 19446720
20:41:37 3136 8192000000 10956119632 11367768064 1953091744 19.251 98 85 168 1 2011905424 32977696 25835984
20:41:50 5178 8192000000 10933694672 11356483584 1957899504 19.289 99 72 144 2 2013877376 33983568 21994304
20:42:02 4042 8192000000 10946682144 11359838208 1969419936 19.381 100 71 138 1 2025495648 34766704 21309008
20:42:13 13004 8192000000 10944345856 11363958784 1965722064 19.351 99 75 146 0 2026438144 39431392 21284688
20:42:34 4610 8192000000 10952891536 11373142016 1976369920 19.436 100 64 126 1 2035867664 40959376 18538368
20:42:46 2846 8192000000 10944638768 11349655552 1959903040 19.305 99 88 175 1 2023829216 37781280 26144896
20:42:56 5017 8192000000 10950418864 11355230208 1965154880 19.347 100 84 165 1 2028830928 39188448 24487600
20:43:07 2359 8192000000 10926169184 11336683520 1950009200 19.227 99 72 140 0 2011144496 39496432 21638864
20:43:17 4159 8192000000 10944737776 11360751616 1965121296 19.347 100 71 141 1 2026435664 39220736 22093632
20:43:33 2577 8192000000 10940589984 11355312128 1963362672 19.333 100 77 155 2 2026278784 39429040 23487072
20:43:43 5501 8192000000 10955851728 11369123840 1970481264 19.389 100 74 147 5 2033593232 40419472 22692496
20:44:03 2737 8192000000 10938130832 11350114304 1952040608 19.243 99 81 162 1 2019090896 41272496 25777792
20:44:15 4181 8192000000 10937186176 11345457152 1953489824 19.254 100 77 152 1 2014750160 37190304 24070032
20:44:25 3194 8192000000 10924447456 11344252928 1951416352 19.238 100 65 130 0 2008898864 37196048 20286464
20:44:37 4337 8192000000 10934684320 11359277056 1962041600 19.322 100 57 112 1 2021169728 40906240 18221888
20:44:49 7238 8192000000 10941839648 11361611776 1964066448 19.338 100 66 132 2 2027333984 42093840 21173696
20:45:05 5286 8192000000 10961037040 11378987008 1981950352 19.480 100 73 144 1 2047869792 43240608 22678832
20:45:18 1308 8192000000 10970202656 11381592064 1979117760 19.458 100 86 172 3 2052624400 45803600 27703040
20:45:26 2683 8192000000 10973903008 11386175488 1982894768 19.488 100 83 166 1 2054761248 46127904 25738576
20:45:37 2258 8192000000 10971960352 11379920896 1980371472 19.468 100 86 172 0 2050848112 43515088 26961552
20:45:46 3301 8192000000 10954590960 11374309376 1961909920 19.321 99 78 152 0 2029012576 43647248 23455408
20:45:56 2853 8192000000 10956129808 11370700800 1956672288 19.280 99 80 159 2 2025429216 43961200 24795728
20:46:06 1602 8192000000 10950084448 11356131328 1950791856 19.233 99 90 178 1 2022461040 43310624 28358560
20:46:14 4017 8192000000 10932735104 11357417472 1956410816 19.278 100 60 120 1 2019797744 44513424 18873504
20:46:26 11338 8192000000 10915221696 11353399296 1935262880 19.109 99 38 76 1 1986668416 39220112 12185424
20:46:48 9857 8192000000 10921516352 11352834048 1949867536 19.225 100 41 82 1 2005388256 41088288 14432432
20:47:04 6307 8192000000 10943539040 11359465472 1958199936 19.292 100 67 131 2 2019059504 39316800 21542768
20:47:17 2638 8192000000 10960056336 11374538752 1968659504 19.375 100 81 161 0 2037419456 43482880 25277072
20:47:27 2523 8192000000 10971277632 11378266112 1969535408 19.382 100 89 177 2 2046488928 50000224 26953296
20:47:36 1474 8192000000 10952346128 11367546880 1951901104 19.242 99 71 142 1 2022303232 48457136 21944992
20:47:52 8536 8192000000 10943081824 11368443904 1955511136 19.270 100 59 119 0 2023658800 49320288 18827376
20:48:22 11846 8192000000 10929610400 11361173504 1955661760 19.272 100 44 88 0 2012715216 42338304 14715152
20:48:59 5782 8192000000 10917593952 11345825792 1914567888 18.943 98 61 121 0 1982092592 46926592 20598112
20:49:13 11679 8192000000 10929180000 11370070016 1953891008 19.257 100 42 84 2 2016129872 47869824 14369040
20:49:32 6705 8192000000 10917215616 11359318016 1931225088 19.077 99 48 96 0 1993682384 46278000 16179296
20:49:48 2546 8192000000 10932212416 11350044672 1946197376 19.196 100 58 115 4 2005692384 41367584 18127424
20:49:59 1272 8192000000 10968892240 11373092864 1967360128 19.365 100 91 178 1 2036899856 42101008 27438720
20:50:07 6638 8192000000 10935798464 11363352576 1953578576 19.255 100 53 106 1 2017281664 45703504 17999584
20:50:25 6897 8192000000 10904992576 11330953216 1893294640 18.772 97 37 72 0 1943927216 38980128 11652448
20:50:39 12013 8192000000 10897164480 11339702272 1920505936 18.991 99 31 62 0 1970351056 39410640 10434480
20:51:01 13866 8192000000 10907870096 11343355904 1939205104 19.140 100 38 73 2 1988733904 36972752 12556048
20:51:21 20191 8192000000 10914378384 11333005312 1926127488 19.036 99 50 100 1 1979071968 36785136 16159344
20:51:56 7343 8192000000 10896649968 11328065536 1925169520 19.028 99 45 90 1 1980917680 40865760 14882400
20:52:24 15547 8192000000 10930691936 11365183488 1948734992 19.216 100 38 76 1 2006502160 44867504 12899664
20:53:01 10090 8192000000 10937129376 11375411200 1956521232 19.278 100 37 74 3 2012612128 43291616 12799280
20:53:27 16084 8192000000 10907967552 11361669120 1932370176 19.086 99 31 62 0 1986755440 43324432 11060832
20:53:57 24678 8192000000 10890121040 11356360704 1944423920 19.182 100 18 36 0 1980032320 29447424 6160976
20:54:29 20622 8192000000 10898559824 11355357184 1940542320 19.151 100 18 36 3 1983603792 36624112 6437360
20:55:21 35641 8192000000 10894287216 11348475904 1930841840 19.074 100 14 28 1 1972401584 36796976 4762768
20:56:27 24774 8192000000 10859506432 11337740288 1906976864 18.882 99 17 34 0 1938892304 26264448 5650992
20:57:19 32016 8192000000 10879977488 11341484032 1939148896 19.140 100 8 16 0 1957196928 15874144 2173888
20:58:00 85549 8192000000 10877936128 11332214784 1904317712 18.861 98 9 19 0 1918093296 11706432 2069152
20:59:37 55279 8192000000 10870354896 11319169024 1892713104 18.768 97 22 44 1 1908336064 9411648 6211312
21:00:40 15541 8192000000 10887246560 11337883648 1951643072 19.240 100 17 34 3 1971145824 14991504 4511248
21:01:07 42057 8192000000 10915247616 11368804352 1963126160 19.331 100 35 70 1 1989374816 16241968 10006688
21:02:00 135984 8192000000 10914094976 11366596608 1924180992 19.020 98 21 41 1 1948029040 17315776 6532272
21:04:23 170923 8192000000 10891688928 11345174528 1905521008 18.871 97 24 48 2 1926831104 14468080 6842016
21:07:20 17884 8192000000 10901294288 11355627520 1968274144 19.372 100 60 120 0 1998872784 13343072 17255568
21:08:08 41016 8192000000 10914989440 11366047744 1972899664 19.408 100 32 62 0 1996283376 13875856 9507856
21:08:55 20017 8192000000 10924729232 11368026112 1961992256 19.322 99 36 72 2 1985600944 13332640 10276048
21:09:23 30714 8192000000 10909455552 11374813184 1973558560 19.414 100 31 62 0 1997951728 15487680 8905488
21:10:07 42182 8192000000 10907301984 11374673920 1952653968 19.248 99 17 34 0 1976812544 18962416 5196160
21:10:56 63252 8192000000 10890607376 11357319168 1951627136 19.239 99 18 36 1 1970367024 14110608 4629280
21:12:25 94739 8192000000 10902985120 11381526528 1976990992 19.441 100 23 46 0 1999309984 15944992 6374000
21:14:38 84054 8192000000 10905229440 11383115776 1974559968 19.422 100 24 48 1 1996114976 14725520 6829488
21:16:57 50973 8192000000 10893277568 11373568000 1968504512 19.374 100 11 23 1 1982543728 11285936 2753280
21:17:54 45340 8192000000 10896208064 11376164864 1981943248 19.480 100 17 34 0 1997847904 11440224 4464432
21:18:49 37964 8192000000 10897831616 11380019200 1959480720 19.302 99 10 20 1 1971317328 9233056 2603552
21:19:35 53032 8192000000 10893319904 11387789312 1980242416 19.467 100 8 16 2 1993510608 10931488 2336704
21:20:36 47122 8192000000 10920277600 11383263232 1981932320 19.480 100 17 34 0 1997429920 11145344 4352256
21:21:37 137760 8192000000 10892141808 11352604672 1846704976 18.395 93 15 30 1 1865689280 14692400 4291904
21:24:03 56970 8192000000 10916157936 11370774528 1959467312 19.302 99 36 70 1 1980060224 10596032 9996880
21:25:14 54434 8192000000 10915696240 11382276096 1962416496 19.325 99 29 58 0 1983610080 12770320 8423264
21:26:15 106471 8192000000 10882231024 11341099008 1771768768 17.782 89 18 36 2 1791043344 13917984 5356592
21:28:10 61951 8192000000 10876471440 11351846912 1906268768 18.877 97 27 54 0 1924074544 10406768 7399008
21:29:18 86251 8192000000 10876580816 11336613888 1847129856 18.399 94 20 40 0 1860864080 8612832 5121392
21:30:50 30491 8192000000 10903585552 11337502720 1896533456 18.798 97 37 68 1 1914440368 8587744 9319168
21:31:38 5907 8192000000 10897862400 11331375104 1935030304 19.107 99 72 145 0 1964981760 9513552 20437904
21:31:50 21845 8192000000 10870097168 11317534720 1908841984 18.897 98 45 90 2 1933209248 12142176 12225088
21:32:18 34873 8192000000 10879027200 11326328832 1866714352 18.558 96 39 76 2 1887994176 11182736 10097088
21:32:59 57906 8192000000 10876633008 11333611520 1862284544 18.522 96 25 50 2 1879311792 10394160 6633088
21:35:24 114296 8192000000 10851661664 11309596672 1866506080 18.556 97 23 46 0 1882562736 9511504 6545152
21:37:25 43711 8192000000 10838669584 11299004416 1905361536 18.869 99 25 50 0 1924523488 12443888 6718064
21:38:16 18439 8192000000 10832456688 11287891968 1893030016 18.770 99 23 46 1 1911376672 12171760 6174896
21:38:50 46755 8192000000 10809875840 11287949312 1901144176 18.835 100 28 56 1 1917607104 8503456 7959472
21:39:43 53994 8192000000 10820842368 11294769152 1877465968 18.645 98 10 20 1 1887618816 7525248 2627600
21:40:55 72080 8192000000 10824240448 11298004992 1882409104 18.685 99 13 26 2 1894552208 8203872 3939232
21:42:14 37748 8192000000 10826906736 11303841792 1909104400 18.899 100 9 18 2 1922149952 10349264 2696288
21:43:03 59369 8192000000 10820223056 11297320960 1872165104 18.602 98 15 30 0 1893136448 16312400 4658944
21:44:09 32117 8192000000 10834565200 11303796736 1890752720 18.752 99 16 32 0 1908224368 12030240 5441408
21:44:47 57392 8192000000 10847128080 11318702080 1903140976 18.852 99 17 34 0 1920445664 12792672 4512016
21:45:57 72835 8192000000 10854152288 11321245696 1873915216 18.616 97 18 36 0 1893401808 13658112 5828480
21:47:28 68717 8192000000 10883727424 11349213184 1920284208 18.989 99 16 32 0 1947321968 21558080 5479680
21:48:44 64929 8192000000 10876278416 11363647488 1904004976 18.858 98 19 38 1 1938808976 28597744 6206256
21:50:21 105565 8192000000 10876125088 11350605824 1915875424 18.954 99 26 52 5 1941068864 18415120 6778320
21:52:15 42440 8192000000 10874014080 11341398016 1940626720 19.152 100 25 50 1 1960074048 12626464 6820864
21:53:28 92084 8192000000 10869453488 11329605632 1872348480 18.603 96 14 28 0 1889083664 13242016 3493168
21:55:06 46990 8192000000 10884673232 11337293824 1918633344 18.976 99 28 58 0 1935583440 8640880 8309216
21:56:10 96317 8192000000 10878368560 11342770176 1944486144 19.183 100 17 34 0 1962167408 12854192 4827072
21:57:53 62771 8192000000 10867570704 11340468224 1900472304 18.830 97 20 38 2 1913244416 6939120 5832992
21:59:55 30343 8192000000 10893332656 11358584832 1965785264 19.352 100 11 21 0 1976549712 8070000 2694448
22:00:36 58656 8192000000 10873146176 11345297408 1930983664 19.075 98 15 29 0 1944315280 9452336 3879280
22:01:43 30928 8192000000 10886042560 11364270080 1966073392 19.354 100 9 18 0 1978965680 10467936 2424352
22:02:20 22329 8192000000 10890390080 11365625856 1967912368 19.369 100 5 10 0 1980410640 11021904 1476368
22:03:34 46741 8192000000 10880648064 11365998592 1935019136 19.107 99 15 30 2 1956190000 16403840 4767024
22:04:28 70855 8192000000 10878337472 11355193344 1882334560 18.684 96 8 16 0 1900144432 15645312 2164560
22:05:44 31631 8192000000 10915391248 11369623552 1957395456 19.285 100 20 40 2 1975983584 12870432 5717696
22:06:23 85948 8192000000 10880443280 11370012672 1933888416 19.098 98 14 28 1 1952879040 14631520 4359104
22:08:03 112744 8192000000 10891845168 11355631616 1885879040 18.713 96 9 18 0 1898102304 9856976 2366288
22:10:07 39237 8192000000 10908622448 11366166528 1930820176 19.073 98 32 64 0 1961154576 20697984 9636416
22:10:55 67410 8192000000 10899761600 11376439296 1947919760 19.210 99 18 36 1 1969877488 16562784 5394944
22:12:12 66174 8192000000 10898951152 11392016384 1949837600 19.225 99 11 22 0 1976132576 23136624 3158352
22:14:43 55538 8192000000 10893755984 11356794880 1900703248 18.832 96 9 18 1 1914494208 11459744 2331216
22:15:52 97075 8192000000 10887356992 11347800064 1928779936 19.057 98 41 82 3 1952064704 12015920 11268848
22:18:14 59933 8192000000 10870123008 11343507456 1910472576 18.910 98 22 44 0 1928448992 11963376 6013040
22:19:24 9327 8192000000 10882508464 11354447872 1952906960 19.250 100 13 25 2 1968211424 11818656 3485808
22:19:43 56506 8192000000 10867122016 11344896000 1921109136 18.996 98 13 26 1 1937142000 12226688 3806176
22:20:46 65582 8192000000 10850811552 11331506176 1892326112 18.765 97 10 20 0 1905121008 9946320 2848576
22:22:04 79458 8192000000 10856545808 11330584576 1871558240 18.597 96 11 22 0 1884935840 9781664 3595936
22:23:47 73334 8192000000 10861291600 11344605184 1935536080 19.111 100 16 32 0 1952906048 12549568 4820400
22:25:28 65165 8192000000 10828801088 11302735872 1840950720 18.349 95 12 24 0 1853146560 9146720 3049120
22:26:44 35595 8192000000 9892974320 10257764352 1015306544 11.027 53 8 16 0 1023932144 6640080 1985520

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 22-01-2021 22:28:46 to 22-01-2021 22:29:19.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 149 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-01-2021 22:29:20 to 22-01-2021 22:29:22.

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          239633
MON$OLDEST_ACTIVE               240581
MON$OLDEST_SNAPSHOT             240581
MON$NEXT_TRANSACTION            240581
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                       2029280
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:272: 
:273: mscs-test-161.budzdorov.ru    Fri Jan 22 22:27:25 2021
:274:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:275: 
:276: 
:277: mscs-test-161.budzdorov.ru    Fri Jan 22 22:27:25 2021
:278:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:279: 
--- end of diff output ---

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

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