Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.06.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 58e1ddde69c44dad93d327777e5becec
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 2021-05-09 08:45
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 4793.92
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 16970652 kB
MemAvailable 31428312 kB
Buffers 0 kB
Cached 14699784 kB
SwapCached 16 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-06-12 22:27:37
DTS_END                         2021-06-12 22:27:37.2190
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(69:14) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45172
TRN_ID                          244888
ATT_ID                          687
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: 9315.97 25862 1117916
customer order: creation 176.82 358 21218
customer order: refuse 14.55 354 1746
order to supplier: creation 49.03 1303 5883
order to supplier: removal 3.54 108870 425
invoice (draft): creation 47.33 3580 5679
invoice (draft): removal 52.03 911 6243
invoice accept: apply 42.30 18421 5076
invoice accept: cancel 47.35 863 5682
customer reserve: creation 3947.24 180 473669
customer reserve: removal 4632.41 65 555889
realization accept: apply 86.88 181 10426
realization accept: cancel 82.95 123 9954
payment from customer: creation 61.04 140 7325
payment from customer: removal 5.81 72 697
payment to supplier: creation 50.72 152 6086
payment to supplier: removal 3.63 133 436
service: total inventory turnovers 5.00 1280 600
service: total monetary turnovers 6.50 31 780
service: aggregate perf. data 0.82 20767 98
service: refresh index statistics 0.03 359451 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-06-2021 22:29:00 to 12-06-2021 22:29:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2894
TEST_TIME 2 4299
TEST_TIME 3 4471
TEST_TIME 4 4481
TEST_TIME 5 4399
TEST_TIME 6 4802
TEST_TIME 7 5148
TEST_TIME 8 5453
TEST_TIME 9 5424
TEST_TIME 10 5875
TEST_TIME 11 5947
TEST_TIME 12 6136
TEST_TIME 13 6622
TEST_TIME 14 7038
TEST_TIME 15 7443
TEST_TIME 16 7945
TEST_TIME 17 8078
TEST_TIME 18 7907
TEST_TIME 19 7964
TEST_TIME 20 8265
TEST_TIME 21 8333
TEST_TIME 22 8589
TEST_TIME 23 8704
TEST_TIME 24 8741
TEST_TIME 25 8809
TEST_TIME 26 8750
TEST_TIME 27 9480
TEST_TIME 28 9979
TEST_TIME 29 10663
TEST_TIME 30 11510
TEST_TIME 31 11388
TEST_TIME 32 11221
TEST_TIME 33 11064
TEST_TIME 34 11140
TEST_TIME 35 11196
TEST_TIME 36 11165
TEST_TIME 37 10983
TEST_TIME 38 10893
TEST_TIME 39 10685
TEST_TIME 40 10557
TEST_TIME 41 10550
TEST_TIME 42 10655
TEST_TIME 43 10504
TEST_TIME 44 10394
TEST_TIME 45 10412
TEST_TIME 46 10409
TEST_TIME 47 10335
TEST_TIME 48 10266
TEST_TIME 49 10273
TEST_TIME 50 10184
TEST_TIME 51 10099
TEST_TIME 52 10032
TEST_TIME 53 10081
TEST_TIME 54 9924
TEST_TIME 55 9914
TEST_TIME 56 9886
TEST_TIME 57 9770
TEST_TIME 58 9963
TEST_TIME 59 10031
TEST_TIME 60 9960
TEST_TIME 61 9911
TEST_TIME 62 9835
TEST_TIME 63 9784
TEST_TIME 64 9907
TEST_TIME 65 9902
TEST_TIME 66 9908
TEST_TIME 67 9935
TEST_TIME 68 9867
TEST_TIME 69 9949
TEST_TIME 70 9929
TEST_TIME 71 9993
TEST_TIME 72 9940
TEST_TIME 73 9966
TEST_TIME 74 10022
TEST_TIME 75 9943
TEST_TIME 76 10016
TEST_TIME 77 10005
TEST_TIME 78 9932
TEST_TIME 79 9832
TEST_TIME 80 9818
TEST_TIME 81 9838
TEST_TIME 82 9772
TEST_TIME 83 9738
TEST_TIME 84 9734
TEST_TIME 85 9727
TEST_TIME 86 9721
TEST_TIME 87 9675
TEST_TIME 88 9613
TEST_TIME 89 9545
TEST_TIME 90 9522
TEST_TIME 91 9515
TEST_TIME 92 9480
TEST_TIME 93 9506
TEST_TIME 94 9497
TEST_TIME 95 9506
TEST_TIME 96 9520
TEST_TIME 97 9525
TEST_TIME 98 9561
TEST_TIME 99 9533
TEST_TIME 100 9584
TEST_TIME 101 9573
TEST_TIME 102 9565
TEST_TIME 103 9602
TEST_TIME 104 9599
TEST_TIME 105 9623
TEST_TIME 106 9650
TEST_TIME 107 9642
TEST_TIME 108 9572
TEST_TIME 109 9504
TEST_TIME 110 9549
TEST_TIME 111 9505
TEST_TIME 112 9461
TEST_TIME 113 9433
TEST_TIME 114 9398
TEST_TIME 115 9371
TEST_TIME 116 9409
TEST_TIME 117 9412
TEST_TIME 118 9389
TEST_TIME 119 9366
TEST_TIME 120 9317

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-06-2021 22:29:04 to 12-06-2021 22:29:07.

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 1555799 1555799 0 0.00 0 15392 6 0 0
doc_list_biud 1555799 1555799 0 0.00 0 87985 29 0 0
sp_add_invoice_to_stock 5208 5076 132 2.53 23 185019 18422 0 132
sp_cancel_adding_invoice 5682 5682 0 0.00 6 99684 863 0 0
sp_cancel_client_order 1746 1746 0 0.00 5 17288 354 0 0
sp_cancel_customer_reserve 555889 555889 0 0.00 1 75179 65 0 0
sp_cancel_pay_from_customer 697 697 0 0.00 2 4344 73 0 0
sp_cancel_pay_to_supplier 436 436 0 0.00 3 8910 133 0 0
sp_cancel_supplier_invoice 6253 6243 10 0.15 2 87997 911 0 10
sp_cancel_supplier_order 425 425 0 0.00 7 1072781 108871 0 0
sp_cancel_write_off 9954 9954 0 0.00 1 12667 123 0 0
sp_client_order 21218 21218 0 0.00 4 70940 358 0 0
sp_customer_reserve 473669 473669 0 0.00 0 73781 181 0 0
sp_fill_shopping_cart 32767 32767 0 0.00 1 11098 41 0 0
sp_fill_shopping_cart_clo_res 473666 473666 0 0.00 0 12685 13 0 0
sp_get_clo_for_invoice 5073 5073 0 0.00 0 28658 285 0 0
sp_kill_cost_storno 16769 16769 0 0.00 0 12665 63 0 0
sp_kill_qstorno_ret_qs2qd 1128400 1128400 0 0.00 0 87978 35 0 0
sp_kill_qty_storno 595438 595438 0 0.00 0 87982 76 0 0
sp_lock_selected_doc 21451 21451 0 0.00 0 9150 7 0 0
sp_make_cost_storno 28910 28910 0 0.00 0 11606 53 0 0
sp_multiply_rows_for_pdistr 28910 28910 0 0.00 0 9695 32 0 0
sp_multiply_rows_for_qdistr 21218 21218 0 0.00 0 70930 152 0 0
sp_pay_from_customer 7325 7325 0 0.00 4 17193 140 0 0
sp_pay_to_supplier 6086 6086 0 0.00 5 28337 153 0 0
sp_payment_common 13411 13411 0 0.00 1 14945 33 0 0
sp_qd_handle_on_cancel_clo 1746 1746 0 0.00 0 16284 302 0 0
sp_qd_handle_on_invoice_upd_sts 10755 10755 0 0.00 0 23695 352 0 0
sp_qd_handle_on_reserve_upd_sts 10426 10426 0 0.00 0 14765 57 0 0
sp_reserve_write_off 10426 10426 0 0.00 6 17183 181 0 0
sp_supplier_invoice 5679 5679 0 0.00 6 87411 3580 0 0
sp_supplier_order 5883 5883 0 0.00 5 36491 1303 0 0
srv_aggregate_perf_data 98 98 0 0.00 2809 182270 20767 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1044 148822 31075 0 0
srv_find_qd_qs_mism 1068354 1068354 0 0.00 0 15391 5 0 0
srv_make_invnt_saldo 600 600 0 0.00 25 188324 1281 0 0
srv_make_money_saldo 780 780 0 0.00 1 1866 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 187852 444707 359452 0 0
t$perf-abend:sp_add_invoice_to_stock 132 132 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5076 5076 0 0.00 0 15678 181 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 1 2820 79 0 0
t$perf-norm:sp_cancel_client_order 1746 1746 0 0.00 0 3491 16 0 0
t$perf-norm:sp_cancel_customer_reserve 689 689 0 0.00 0 3913 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 697 697 0 0.00 0 1612 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 436 436 0 0.00 0 582 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 437 437 0 0.00 0 1118 15 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 26738 1707 0 0
t$perf-norm:sp_cancel_write_off 1076 1076 0 0.00 0 1357 8 0 0
t$perf-norm:sp_client_order 21218 21218 0 0.00 0 9005 19 0 0
t$perf-norm:sp_customer_reserve 1081 1081 0 0.00 0 1510 6 0 0
t$perf-norm:sp_pay_from_customer 7325 7325 0 0.00 0 2769 7 0 0
t$perf-norm:sp_pay_to_supplier 6086 6086 0 0.00 0 9118 8 0 0
t$perf-norm:sp_reserve_write_off 10426 10426 0 0.00 0 6950 10 0 0
t$perf-norm:sp_supplier_invoice 5679 5679 0 0.00 0 10785 24 0 0
t$perf-norm:sp_supplier_order 5883 5883 0 0.00 0 7344 19 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 713 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 606 6 0 0
t$perf-norm:srv_make_invnt_saldo 600 600 0 0.00 0 2228 30 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 2744 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 7 4 0 0
v_add_invoice_to_stock 10410 10146 264 2.53 0 16800 24 0 264
v_all_customers 38662 38662 0 0.00 0 50 1 0 0
v_all_suppliers 32200 32200 0 0.00 0 167 1 0 0
v_all_wares 42436 42436 0 0.00 0 237 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 1872 9 0 0
v_cancel_client_order 3492 3492 0 0.00 0 16973 15 0 0
v_cancel_customer_prepayment 1394 1394 0 0.00 0 4325 8 0 0
v_cancel_customer_reserve 1378 1378 0 0.00 0 17001 20 0 0
v_cancel_payment_to_supplier 872 872 0 0.00 0 2059 7 0 0
v_cancel_supplier_invoice 894 874 20 2.23 0 7010 31 0 20
v_cancel_supplier_order 850 850 0 0.00 0 692 5 0 0
v_cancel_write_off 2152 2152 0 0.00 0 2687 14 0 0
v_max_id_clo_ord 5882 5882 0 0.00 0 545 1 0 0
v_max_id_clo_res 1081 1081 0 0.00 0 2175 10 0 0
v_max_id_ord_sup 5667 5667 0 0.00 0 4489 4 0 0
v_max_non_paid_invoice 1535 1535 0 0.00 0 3058 5 0 0
v_max_non_paid_realizn 3753 3753 0 0.00 0 3057 4 0 0
v_min_id_clo_ord 5882 5882 0 0.00 0 3531 7 0 0
v_min_id_clo_res 1081 1081 0 0.00 0 733 3 0 0
v_min_id_ord_sup 5667 5667 0 0.00 0 7933 6 0 0
v_min_non_paid_invoice 6086 6086 0 0.00 0 11250 20 0 0
v_min_non_paid_realizn 7325 7325 0 0.00 0 14935 20 0 0
v_our_firm 10918 10918 0 0.00 0 31 1 0 0
v_reserve_write_off 20852 20852 0 0.00 0 16866 9 0 0
x_lock_depdocs_on_canc_invoice 11488 11488 0 0.00 0 22220 130 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 7114 358 0 0
x_make_qstorno_1000_1200 5883 5883 0 0.00 2 36471 1213 0 0
x_make_qstorno_1200_2000 5679 5679 0 0.00 3 85189 3435 0 0
x_make_qstorno_2100_3300 473669 473669 0 0.00 0 73781 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-06-2021 22:29:08 to 12-06-2021 22:29:12.

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:40 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
19:57:47 30833 8192000000 10297732480 10607726592 1024287328 11.113 78 67 135 1 1049619184 2933360 22398496
19:58:26 30560 8192000000 10353959328 10669043712 1398298656 14.580 100 87 174 0 1432170032 5460336 28411040
19:59:07 25898 8192000000 10379080976 10702143488 1431000688 14.870 100 83 166 0 1464987328 6991008 26995632
19:59:42 24427 8192000000 10409799712 10733428736 1461954176 15.143 100 88 176 0 1497792928 7886048 27952704
20:00:19 23058 8192000000 10427326592 10758737920 1478325712 15.287 100 84 168 1 1513901104 8557248 27018144
20:00:52 21471 8192000000 10456348528 10789814272 1508951248 15.554 100 89 178 0 1545942896 9092944 27898704
20:01:22 16894 8192000000 10478630336 10814124032 1531093200 15.746 100 91 182 0 1569155488 9883808 28178480
20:01:52 19235 8192000000 10513029456 10855854080 1555391616 15.957 100 84 168 3 1591362976 10323072 25648288
20:02:34 12887 8192000000 10534639248 10889142272 1597448176 16.318 100 78 156 3 1632708784 11320336 23940272
20:02:56 12986 8192000000 10569904512 10921672704 1621938480 16.526 100 78 156 1 1656419280 11334464 23146336
20:03:17 12347 8192000000 10576749792 10934235136 1634174256 16.630 100 85 170 1 1671620576 12082608 25363712
20:03:44 9962 8192000000 10593887472 10955833344 1653864640 16.797 100 79 158 0 1688851888 12120416 22866832
20:04:01 10655 8192000000 10611248368 10976022528 1673611008 16.964 100 78 156 1 1708436864 12515728 22310128
20:04:19 10310 8192000000 10627933952 10992295936 1685136048 17.060 100 83 166 3 1723130688 13689696 24304944
20:04:38 10416 8192000000 10648105824 11019198464 1707230336 17.246 100 80 157 1 1743075088 13393296 22451456
20:04:55 7607 8192000000 10649583488 11023708160 1721921168 17.368 100 79 158 0 1756626848 12197888 22507792
20:05:11 7958 8192000000 10673861552 11045572608 1731335264 17.447 100 78 156 0 1765881760 12577456 21969040
20:05:28 6323 8192000000 10688559888 11063926784 1751760848 17.616 100 90 179 1 1791249712 14226416 25262448
20:05:41 4612 8192000000 10699700864 11075825664 1760072192 17.685 100 90 177 2 1799545808 14538256 24935360
20:05:52 3292 8192000000 10712945760 11092545536 1772551008 17.788 100 84 167 2 1810833856 14536640 23746208
20:06:02 3210 8192000000 10729296464 11106791424 1783606496 17.879 100 92 181 3 1823593504 13980576 26006432
20:06:12 4157 8192000000 10728383712 11109490688 1796086496 17.982 100 82 162 2 1831968704 13414208 22468000
20:06:24 3632 8192000000 10738180000 11117309952 1797406320 17.993 100 84 168 0 1835999456 14844864 23748272
20:06:34 3931 8192000000 10741138480 11117617152 1808476912 18.083 100 93 182 2 1848473248 14646016 25350320
20:06:45 9941 8192000000 10745949232 11127672832 1805557088 18.059 100 86 172 2 1844014064 14460688 23996288
20:07:02 2417 8192000000 10757507856 11142467584 1809606048 18.093 100 81 162 0 1845794144 13548192 22639904
20:07:11 2328 8192000000 10768321376 11151921152 1828399008 18.246 100 85 171 1 1865505664 13153584 23953072
20:07:20 2329 8192000000 10768468672 11156398080 1831186800 18.269 100 88 176 1 1869371568 13548192 24636576
20:07:28 2776 8192000000 10783910064 11167649792 1843346768 18.368 100 91 182 1 1882217712 13236016 25634928
20:07:38 1529 8192000000 10788682448 11174457344 1842611616 18.362 100 92 180 2 1885351952 17257664 25482672
20:07:45 1482 8192000000 10793108992 11177181184 1847130896 18.399 100 92 184 0 1891295360 18026688 26137776
20:07:53 1813 8192000000 10796043168 11180560384 1851242144 18.432 100 93 186 2 1889919392 12938448 25738800
20:08:01 2185 8192000000 10809031792 11194793984 1861254384 18.513 100 90 180 2 1900395072 13616832 25523856
20:08:10 1760 8192000000 10809865584 11196760064 1864017280 18.536 100 89 178 2 1902747888 13237488 25493120
20:08:18 1845 8192000000 10812172656 11200557056 1867681040 18.566 100 92 183 1 1906974608 12417024 26876544
20:08:26 5100 8192000000 10794933360 11198951424 1865630816 18.549 100 65 129 1 1895639024 12000400 18007808
20:08:38 17148 8192000000 10803974336 11206438912 1868072448 18.569 100 67 136 1 1897588080 11176048 18339584
20:09:02 1346 8192000000 10808821008 11205636096 1874240704 18.619 100 89 175 1 1912781680 12866832 25674144
20:09:09 20403 8192000000 10772609424 11197992960 1869299600 18.579 100 33 66 2 1886856032 8296864 9259568
20:09:39 5397 8192000000 10790524544 11197792256 1868422160 18.572 100 32 64 4 1883474800 6368704 8683936
20:09:51 8664 8192000000 10781862512 11203059712 1870524368 18.589 100 28 56 2 1886041504 7646784 7870352
20:10:06 8784 8192000000 10777402464 11203821568 1873719104 18.614 100 36 72 3 1890154240 6651760 9783376
20:10:22 6284 8192000000 10777778432 11205619712 1873538224 18.613 100 25 48 1 1887588096 7219168 6830704
20:10:34 10939 8192000000 10775359152 11205820416 1872828000 18.607 100 13 25 2 1881781536 5521168 3432368
20:10:52 3995 8192000000 10788034688 11212648448 1879546544 18.661 100 25 50 2 1893502720 6594432 7361744
20:11:02 7150 8192000000 10793420592 11219386368 1879909344 18.664 100 19 38 1 1891213792 6320560 4983888
20:11:15 10146 8192000000 10791928576 11225194496 1885392704 18.709 100 17 34 0 1896345376 5801808 5150864
20:11:34 9826 8192000000 10796975808 11227492352 1890395568 18.749 100 20 40 2 1902622144 6572544 5654032
20:11:52 16857 8192000000 10802626416 11233087488 1894472144 18.782 100 21 43 0 1910599568 10140784 5986640
20:12:15 6420 8192000000 10802489056 11235155968 1896335696 18.797 100 17 34 1 1907190048 6450400 4403952
20:12:32 7730 8192000000 10806062432 11238453248 1898827040 18.817 100 21 42 2 1910250848 5480192 5943616
20:12:49 81703 8192000000 10820515664 11255906304 1902913808 18.850 100 29 56 1 1921050128 9799504 8336816
20:14:17 9710 8192000000 10828725344 11262857216 1908799600 18.897 100 37 74 2 1930492800 11563520 10129680
20:14:36 6532 8192000000 10829179920 11256987648 1910116576 18.908 100 30 60 1 1925027008 6558544 8351888
20:14:49 4599 8192000000 10823572096 11264102400 1913553472 18.935 100 32 64 0 1930248032 7648720 9045840
20:15:02 8299 8192000000 10821462672 11259748352 1912951280 18.930 100 30 60 1 1928137584 6362624 8823680
20:15:17 3777 8192000000 10833823696 11266347008 1914106720 18.940 100 29 56 2 1928191872 5764080 8321072
20:15:29 7804 8192000000 10828972896 11265028096 1913329456 18.933 100 23 46 1 1927499696 7376272 6793968
20:15:43 6382 8192000000 10830778608 11265978368 1916126224 18.956 100 32 64 0 1931503664 6013664 9363776
20:15:56 7954 8192000000 10819798704 11258691584 1896344352 18.797 99 24 48 3 1909454464 6402080 6708032
20:16:11 12024 8192000000 10825768432 11258032128 1907364704 18.885 100 17 34 0 1917805424 5406736 5033984
20:16:30 9856 8192000000 10807226592 11245707264 1869607584 18.581 98 17 33 1 1880654736 6221200 4825952
20:16:47 6783 8192000000 10809791616 11243909120 1878884848 18.656 99 17 34 1 1889194480 5457952 4851680
20:17:03 9738 8192000000 10819521808 11256119296 1883657920 18.695 99 14 28 1 1893863904 5472416 4733568
20:17:19 5069 8192000000 10826060976 11255939072 1889815408 18.744 99 29 56 2 1904906688 6972304 8118976
20:17:31 68101 8192000000 10759165408 11201036288 1751621952 17.615 92 34 68 1 1766947440 4847712 10477776
20:18:46 9433 8192000000 10760025920 11183243264 1798458448 18.001 97 20 40 1 1809904464 5969344 5476672
20:19:02 3397 8192000000 10765575280 11188256768 1814110016 18.130 98 35 70 1 1831709808 7582880 10016912
20:19:12 1978 8192000000 10749104768 11161317376 1812801840 18.119 99 48 95 2 1837764272 11621120 13341312
20:19:22 7201 8192000000 10737164512 11153149952 1767961840 17.750 96 38 75 2 1788290544 9538704 10790000
20:19:35 4753 8192000000 10713811936 11129311232 1753548432 17.631 96 43 86 2 1773136480 6936400 12651648
20:19:46 8021 8192000000 10743754416 11160481792 1786424144 17.902 98 29 57 1 1799678704 5147392 8107168
20:20:02 4823 8192000000 10710474560 11130941440 1754551296 17.639 97 28 54 2 1768759632 5945712 8262624
20:20:13 7870 8192000000 10681938528 11084984320 1709079024 17.261 95 26 52 1 1722350416 5181456 8089936
20:20:30 3196 8192000000 10735614912 11143274496 1807151152 18.073 100 32 64 3 1822472672 5713280 9608240
20:20:41 10344 8192000000 10692460976 11112943616 1682758656 17.041 93 23 46 0 1695326848 5607744 6960448
20:20:58 7417 8192000000 10691122208 11102670848 1712705424 17.291 96 15 28 4 1722332528 5403200 4223904
20:21:11 11005 8192000000 10705981104 11117486080 1765349408 17.729 99 24 48 3 1777903120 5198592 7355120
20:21:29 10784 8192000000 10695548000 11105394688 1725912560 17.401 97 27 54 1 1743907008 10755456 7238992
20:21:49 17765 8192000000 10680384496 11096805376 1681767424 17.032 94 36 72 1 1697680960 4926096 10987440
20:22:17 54231 8192000000 10719758176 11113037824 1778930112 17.841 99 54 108 0 1799666160 4279744 16456304
20:23:17 5769 8192000000 10712597888 11140554752 1806367024 18.066 100 25 50 1 1820303568 7225504 6711040
20:23:33 9613 8192000000 10729310688 11153096704 1805854016 18.062 99 30 61 2 1820788704 6483360 8451328
20:23:53 9676 8192000000 10741426656 11170263040 1834408288 18.295 100 33 65 0 1850567728 7015600 9143840
20:24:09 3134 8192000000 10772544656 11186257920 1840250976 18.343 100 38 75 1 1858542384 7128384 11163024
20:24:18 8597 8192000000 10764954176 11185491968 1851645600 18.435 100 36 72 2 1868882800 7098224 10138976
20:24:33 5127 8192000000 10756620000 11184553984 1845710064 18.387 100 18 36 1 1856323456 5571200 5042192
20:24:48 9494 8192000000 10772346688 11194744832 1849145616 18.415 100 20 40 1 1864124256 9710336 5268304
20:25:05 11244 8192000000 10761081184 11194810368 1853072640 18.447 100 20 39 2 1864085904 5902896 5110368
20:25:23 9464 8192000000 10775652032 11198062592 1856087168 18.472 100 19 37 1 1866181040 5544288 4549584
20:25:38 9950 8192000000 10769026432 11200925696 1858682528 18.493 100 21 42 0 1871104192 6184128 6237536
20:25:57 7237 8192000000 10782360240 11206057984 1862229200 18.521 100 27 54 0 1875018144 5254064 7534880
20:26:14 10307 8192000000 10773082032 11207118848 1864271744 18.538 100 21 43 0 1876325008 5923008 6130256
20:26:31 8160 8192000000 10780670544 11212640256 1866346336 18.555 100 23 46 1 1879279328 5749808 7183184
20:26:48 56214 8192000000 10790503856 11216420864 1870110144 18.585 100 25 49 1 1882232416 5001920 7120352
20:27:55 29323 8192000000 10828227488 11245514752 1895452000 18.790 100 44 86 3 1914342320 7008192 11882128
20:28:39 13452 8192000000 10835114832 11256070144 1904847936 18.865 100 54 108 1 1928572880 8491232 15233712
20:29:03 17052 8192000000 10856999808 11268907008 1912683200 18.928 100 54 106 5 1938037168 11026560 14327408
20:29:28 25910 8192000000 10858478832 11276632064 1920785008 18.993 100 59 117 1 1949253728 12838656 15630064
20:30:04 5423 8192000000 10873492032 11289997312 1927775824 19.049 100 52 103 1 1955034544 12831520 14427200
20:30:26 31617 8192000000 10871376288 11304710144 1938339568 19.134 100 44 88 1 1963098736 12338448 12420720
20:31:07 20222 8192000000 10875739024 11310276608 1942854944 19.170 100 33 66 4 1964145856 11029184 10261728
20:31:36 10561 8192000000 10877881712 11312046080 1951090224 19.235 100 45 88 3 1976004016 11452944 13460848
20:32:10 13154 8192000000 10902553248 11325988864 1957473088 19.286 100 45 90 1 1986042624 15727184 12842352
20:32:35 8311 8192000000 10899602880 11329245184 1960244208 19.308 100 46 92 0 1991088912 16961632 13883072
20:32:49 18132 8192000000 10917997408 11343134720 1968052208 19.370 100 64 126 1 2006223344 18252560 19918576
20:33:26 10932 8192000000 10911622256 11343945728 1970242288 19.387 100 49 97 1 2002483120 18233024 14007808
20:33:45 11395 8192000000 10927820336 11346649088 1972343104 19.404 100 48 96 1 2004814768 17849552 14622112
20:34:14 4671 8192000000 10912088864 11346419712 1974842032 19.424 100 46 92 2 2005838288 17165936 13830320
20:34:30 26361 8192000000 10918689504 11359289344 1978807440 19.455 100 44 88 1 2010193264 17825056 13560768
20:35:09 9621 8192000000 10931699744 11363590144 1986274096 19.514 100 60 120 1 2023915552 20340000 17301456
20:35:26 2653 8192000000 10926485264 11353853952 1965220896 19.348 99 56 112 1 2000885824 18411008 17253920
20:35:43 5858 8192000000 10930035760 11358720000 1981161264 19.474 100 58 115 1 2017877392 19644368 17071760
20:35:58 8403 8192000000 10934996208 11364589568 1983903168 19.496 100 61 122 1 2022939168 20754016 18281984
20:36:18 7961 8192000000 10918486848 11346706432 1943887680 19.178 98 58 115 3 1982631808 22117968 16626160
20:36:40 9193 8192000000 10932542736 11356590080 1976122448 19.434 100 59 114 2 2016948576 23489568 17336560
20:36:59 18156 8192000000 10925867600 11359825920 1977799120 19.447 100 46 91 2 2015199472 23702256 13698096
20:37:24 5081 8192000000 10940375008 11370373120 1985996416 19.512 100 56 108 0 2027537872 23734944 17806512
20:37:46 4578 8192000000 10930493568 11372539904 1987107520 19.521 100 50 100 2 2027969392 25268304 15593568
20:37:58 5208 8192000000 10930730656 11370364928 1984157200 19.498 100 52 104 1 2025629312 24962512 16509600
20:38:10 9287 8192000000 10927817168 11355893760 1973356384 19.412 100 46 89 1 2007287072 20722000 13208688
20:38:28 5462 8192000000 10923939136 11346653184 1962752800 19.328 99 59 117 1 2002783920 21453072 18578048
20:38:41 6711 8192000000 10923442320 11345416192 1948790096 19.217 99 68 136 2 1992388720 23585088 20013536
20:38:56 3582 8192000000 10935968448 11354898432 1972021632 19.401 100 80 160 1 2021814016 25111456 24680928
20:39:08 1822 8192000000 10949892528 11367378944 1981698160 19.478 100 83 163 2 2029935888 24431312 23806416
20:39:17 8105 8192000000 10945029552 11369218048 1980032496 19.465 100 80 160 1 2031223712 27775744 23415472
20:39:40 5298 8192000000 10961701840 11382886400 1992101648 19.560 100 76 153 0 2045040992 30656432 22282912
20:39:54 4932 8192000000 10949537616 11382337536 1987964752 19.528 100 60 120 1 2036781472 31100480 17716240
20:40:08 5910 8192000000 10960540496 11392585728 1991716304 19.557 100 66 132 0 2045212528 33398096 20098128
20:40:24 5481 8192000000 10959751120 11387932672 1992880048 19.567 100 75 147 1 2046934000 32139360 21914592
20:40:36 6519 8192000000 10970632800 11399892992 1999214048 19.617 100 76 152 1 2055728048 33032096 23481904
20:40:50 2632 8192000000 10976466688 11403575296 2000865600 19.630 100 75 147 1 2056009648 33303216 21840832
20:41:00 2871 8192000000 10975473360 11405254656 2001704144 19.636 100 80 156 0 2063367840 38086400 23577296
20:41:11 2564 8192000000 10955417488 11386322944 1976288112 19.435 99 73 146 0 2035758992 36690816 22780064
20:41:21 3512 8192000000 10960922160 11381522432 1976222336 19.435 100 73 146 3 2035128528 36700640 22205552
20:41:35 6807 8192000000 10956872560 11378577408 1978852704 19.456 100 77 151 0 2037992016 35766064 23373248
20:41:51 2853 8192000000 10962560704 11386675200 1989393552 19.539 100 82 161 1 2051653856 37164032 25096272
20:42:01 1161 8192000000 10969073280 11386437632 1984329744 19.499 100 91 182 1 2052563840 40038368 28195728
20:42:09 3261 8192000000 10956761264 11379605504 1977144176 19.442 100 82 164 1 2043480096 41194192 25141728
20:42:20 3048 8192000000 10961186304 11372634112 1970911312 19.393 100 85 169 1 2036415792 39519776 25984704
20:42:30 1148 8192000000 10941960128 11348824064 1938963008 19.138 99 92 186 2 2008253984 40065888 29225088
20:42:38 5622 8192000000 10939946672 11364151296 1958483312 19.294 100 73 146 1 2022064208 41167616 22413280
20:42:52 1936 8192000000 10949852928 11374542848 1968783168 19.376 100 77 151 3 2033623984 41165936 23674880
20:43:00 4327 8192000000 10959580336 11381260288 1973153600 19.410 100 84 166 2 2040855664 41074416 26627648
20:43:15 10436 8192000000 10945882976 11384258560 1975126144 19.426 100 58 114 0 2030927088 38007520 17793424
20:43:35 10964 8192000000 10950376048 11385823232 1963249040 19.332 99 47 94 2 2014584288 36668800 14666448
20:43:54 3444 8192000000 10936637792 11367833600 1969577536 19.382 99 63 125 2 2025967040 37324528 19064976
20:44:07 4938 8192000000 10977594016 11400622080 1992198400 19.561 100 76 151 2 2050744160 36594016 21951744
20:44:19 1043 8192000000 10947696000 11360874496 1950465312 19.230 98 76 150 2 2011398112 38858208 22074592
20:44:28 1236 8192000000 10941088432 11348791296 1933211984 19.093 98 90 178 2 1999157088 39467312 26477792
20:44:36 3008 8192000000 10923474000 11352461312 1932888960 19.090 99 68 136 0 1993679984 39783056 21007968
20:44:46 7081 8192000000 10915969760 11350134784 1932340560 19.086 99 48 97 2 1985935568 38734176 14860832
20:45:03 5041 8192000000 10886141632 11316432896 1906382592 18.878 98 45 90 1 1958472944 38482704 13607648
20:45:21 9692 8192000000 10921906128 11346415616 1946309792 19.197 100 56 112 0 2004083776 40354208 17419776
20:45:40 5361 8192000000 10949944720 11369590784 1961958624 19.322 100 76 152 1 2030077984 45137328 22982032
20:45:55 1490 8192000000 10943862160 11362365440 1943160400 19.172 99 79 154 4 2014541376 47378592 24002384
20:46:04 1626 8192000000 10958666048 11373379584 1963809408 19.336 100 84 166 2 2038776432 48899248 26067776
20:46:14 2185 8192000000 10926717616 11330973696 1916620928 18.960 98 83 164 0 1990943088 49873824 24448336
20:46:23 1690 8192000000 10956089328 11371298816 1956942256 19.282 100 78 156 0 2032372896 51452784 23977856
20:46:33 1389 8192000000 10949405920 11354615808 1933967856 19.099 99 87 171 0 2012750560 51739680 27043024
20:46:47 3456 8192000000 10954338592 11369889792 1955963728 19.274 100 74 147 1 2031668752 52143744 23561280
20:46:57 2303 8192000000 10936652064 11350487040 1927897776 19.050 99 78 156 1 2002928880 50922352 24108752
20:47:06 2513 8192000000 10951201584 11366281216 1956461152 19.278 100 77 151 1 2030969680 50175360 24333168
20:47:15 1310 8192000000 10955968496 11361894400 1960336320 19.309 100 91 181 1 2034525664 45196880 28992464
20:47:23 1809 8192000000 10960416752 11365580800 1962590848 19.327 100 84 166 1 2035221440 46276800 26353792
20:47:34 2221 8192000000 10960448368 11368071168 1963580720 19.334 100 92 182 1 2040151664 48513424 28057520
20:47:43 2913 8192000000 10974774112 11384889344 1979031984 19.457 100 80 160 1 2053211472 48280368 25899120
20:47:53 4827 8192000000 10964878928 11388702720 1976965456 19.441 100 58 114 1 2044248144 48402896 18879792
20:48:07 2794 8192000000 10972616048 11393273856 1983818832 19.495 100 76 150 0 2057813504 50178032 23816640
20:48:17 5697 8192000000 10953665408 11383566336 1978075024 19.449 100 51 102 1 2041786736 47627328 16084384
20:48:31 7964 8192000000 10956180912 11390787584 1978865808 19.456 100 56 112 0 2046150480 48952464 18332208
20:48:52 4663 8192000000 10929432176 11355136000 1945084528 19.187 98 53 107 0 2012286448 49277104 17924816
20:49:07 3334 8192000000 10996150736 11401695232 1984307344 19.499 100 87 170 2 2063305792 51189568 27808880
20:49:17 4399 8192000000 10962914288 11379855360 1970036384 19.386 100 76 153 1 2046998544 52656576 24305584
20:49:30 1903 8192000000 10983558288 11384569856 1973968320 19.417 100 97 196 1 2057332000 53408368 29955312
20:49:39 6100 8192000000 10953631392 11386331136 1970724976 19.391 100 52 102 1 2041089888 53307104 17057808
20:49:54 8261 8192000000 10953319008 11394207744 1974521664 19.421 100 46 92 5 2045201280 55080144 15599472
20:50:09 4758 8192000000 10969469632 11407765504 1979785312 19.463 100 54 109 2 2053603440 55858272 17959856
20:50:22 5654 8192000000 10971742096 11400077312 1981768016 19.479 100 52 104 2 2051915184 52910688 17236480
20:50:37 6593 8192000000 10968678624 11405529088 1984288064 19.499 100 45 90 0 2053660768 53935696 15437008
20:51:00 10430 8192000000 10973353184 11407122432 1985528912 19.508 100 46 92 3 2053541584 52581504 15431168
20:51:23 6744 8192000000 10972805680 11399335936 1977081232 19.442 100 58 114 2 2051039936 54786832 19171872
20:51:36 4776 8192000000 10969534832 11403165696 1976510864 19.437 100 65 130 0 2057891456 59841488 21539104
20:51:59 16082 8192000000 10954117120 11393720320 1968567200 19.374 100 41 81 1 2042907248 60614176 13725872
20:52:22 10634 8192000000 10956519248 11396378624 1966761248 19.360 100 39 78 1 2041299504 61042128 13496128
20:52:39 14904 8192000000 10950499424 11380801536 1941619264 19.160 99 39 76 3 2016180576 61237216 13324096
20:53:07 5747 8192000000 10951418928 11384365056 1953157296 19.252 100 41 82 2 2031581952 63924176 14500480
20:53:30 20413 8192000000 10950743664 11396861952 1952986128 19.250 100 41 83 3 2036400880 68618656 14796096
20:53:59 7365 8192000000 10934515568 11372531712 1915907072 18.954 99 35 70 1 2005856080 76467536 13481472
20:54:15 17389 8192000000 10935914192 11381723136 1931902336 19.082 100 38 77 2 2025110256 78600800 14607120
20:54:41 26376 8192000000 10908461600 11360890880 1917581664 18.967 100 28 56 0 1994501712 65064624 11855424
20:55:50 35009 8192000000 10898750480 11348537344 1874911280 18.624 98 17 34 0 1943537792 61850752 6775760
20:56:32 4737 8192000000 10911328128 11343867904 1903079312 18.851 99 47 95 2 1971118960 53123520 14916128
20:56:47 16188 8192000000 10886129776 11349561344 1916789296 18.961 100 34 68 1 1982625664 54564352 11272016
20:57:16 26881 8192000000 10878535856 11340701696 1927766240 19.049 100 12 24 0 1947177280 16062768 3348272
20:57:56 39638 8192000000 10884854896 11349172224 1943670176 19.176 100 15 30 3 1970543872 22715488 4158208
20:59:12 30543 8192000000 10882169024 11331170304 1940238800 19.149 100 43 82 2 1968012832 14784880 12989152
20:59:49 28120 8192000000 10910627648 11341750272 1952071904 19.243 100 50 93 1 1983893744 18300048 13521792
21:00:24 30819 8192000000 10923513136 11363328000 1964061360 19.338 100 44 88 0 1999032144 22405872 12564912
21:01:01 72634 8192000000 10898789856 11358117888 1944845008 19.185 99 18 36 0 1967839520 18051808 4942704
21:02:20 137225 8192000000 10892380976 11346870272 1918993440 18.979 98 13 27 0 1939514000 17408176 3112384
21:04:52 77548 8192000000 10902139680 11354861568 1965560160 19.350 100 28 57 1 1983391104 10154240 7676704
21:06:21 132249 8192000000 10909836016 11370000384 1931484832 19.079 98 26 51 3 1953012384 14539984 6987568
21:08:47 119864 8192000000 10898086448 11364507648 1944245376 19.181 99 13 24 2 1964453488 17360480 2847632
21:10:53 29702 8192000000 10900142736 11352350720 1934765712 19.105 98 39 80 1 1955709904 9171856 11772336
21:11:36 33961 8192000000 10912197008 11364917248 1974021952 19.417 100 27 52 0 1991436672 9488176 7926544
21:12:29 148822 8192000000 10898148288 11364487168 1878813696 18.656 95 7 14 0 1893757840 12956320 1987824
21:15:04 49734 8192000000 10910329200 11359600640 1950406672 19.230 99 32 64 1 1966824032 7291152 9126208
21:16:00 41342 8192000000 10893601872 11366731776 1951378640 19.237 99 9 18 1 1964426096 10677088 2370368
21:16:53 90760 8192000000 10872963488 11339952128 1925164016 19.028 97 13 26 0 1943773744 14502672 4107056
21:18:33 122955 8192000000 10887551632 11348459520 1913588208 18.935 97 34 68 2 1933786240 10071008 10127024
21:20:42 68015 8192000000 10912692944 11362340864 1972672320 19.407 100 40 80 2 1992081936 8346288 11063328
21:22:08 5397 8192000000 10921744592 11370987520 1981449296 19.476 100 57 113 2 2009123600 10996512 16677792
21:22:22 9072 8192000000 10945039328 11382026240 1986149856 19.513 100 54 109 2 2015862032 14119040 15593136
21:22:38 24267 8192000000 10925936032 11394273280 1990233088 19.546 100 35 70 1 2017944880 17783664 9928128
21:23:26 27399 8192000000 10916228880 11389784064 1981531936 19.477 100 14 28 0 2002073472 16260128 4281408
21:24:02 49781 8192000000 10948623584 11403472896 1994310512 19.578 100 33 66 0 2021711088 17602720 9797856
21:25:40 43383 8192000000 10907402432 11390517248 1956308032 19.277 99 14 28 0 1983266288 22831184 4127072
21:26:38 39933 8192000000 10814785856 11278696448 1875372096 18.628 96 11 22 1 1895238384 16797040 3069248
21:27:24 141231 8192000000 10855560992 11331620864 1825232128 18.220 93 12 24 1 1838300816 9944944 3123744
21:30:11 99695 8192000000 10877711936 11370074112 1925736368 19.033 99 10 20 1 1951654848 23277520 2640960
21:32:02 74643 8192000000 10864237408 11340472320 1884451776 18.701 96 12 23 0 1899971088 12552112 2967200
21:33:25 69477 8192000000 10844552688 11311214592 1791478800 17.944 92 18 36 0 1806366352 9228128 5659424
21:34:41 41504 8192000000 10864587312 11317780480 1869107936 18.577 97 23 46 0 1885421424 10305952 6007536
21:35:32 19366 8192000000 10879175920 11325767680 1917071984 18.963 99 46 90 2 1942322496 12398176 12852336
21:36:12 42944 8192000000 10862406272 11329527808 1930647568 19.072 100 39 78 2 1958727408 16514624 11565216
21:37:08 124400 8192000000 10883814704 11350650880 1892629824 18.767 97 17 34 0 1918635984 21224944 4781216
21:39:19 18433 8192000000 10878656208 11333963776 1927189392 19.044 99 44 88 0 1947959104 8732128 12037584
21:39:46 25743 8192000000 10891040928 11341983744 1932231344 19.085 99 41 82 3 1953293504 9849584 11212576
21:40:25 56516 8192000000 10895047968 11367149568 1931213392 19.077 99 26 51 0 1951755600 13905440 6636768
21:41:28 47984 8192000000 10880334080 11339722752 1894617504 18.783 97 10 20 2 1911351840 13740032 2994304
21:42:28 61843 8192000000 10892902368 11352743936 1916605312 18.960 98 36 71 1 1938101472 11298928 10197232
21:43:40 69540 8192000000 10873406096 11339321344 1886608400 18.718 97 16 32 0 1910878208 19497744 4772064
21:44:56 115609 8192000000 10869530896 11313373184 1880840880 18.672 97 23 46 3 1895900656 8204960 6854816
21:47:05 84832 8192000000 10860372656 11323543552 1874532160 18.621 97 35 70 1 1894356976 10290688 9534128
21:48:40 77002 8192000000 10841439392 11304144896 1872456144 18.604 97 25 50 0 1890421312 11433904 6531264
21:50:07 10349 8192000000 10861810912 11314614272 1922463232 19.007 100 46 91 2 1945388176 9635888 13289056
21:50:24 30586 8192000000 10874666288 11321106432 1920454688 18.990 100 40 80 1 1941923104 9985488 11482928
21:51:01 91547 8192000000 10854306944 11324350464 1886812016 18.720 97 25 51 1 1904059504 10029760 7217728
21:52:39 45962 8192000000 10859660896 11324649472 1934253808 19.101 100 13 26 1 1946804400 8822880 3727712
21:53:37 48893 8192000000 10857989104 11346980864 1934833792 19.106 100 11 21 0 1955166576 17565264 2767520
21:54:42 47257 8192000000 10851533280 11327422464 1905045776 18.867 98 9 18 1 1917997360 10810720 2140864
21:55:40 75217 8192000000 10855997776 11329413120 1918102096 18.972 99 16 32 0 1932798480 10670144 4026240
21:57:12 94244 8192000000 10881804352 11364020224 1940980000 19.155 99 17 34 1 1952588016 7307200 4300816
21:59:29 98106 8192000000 10887734208 11369107456 1937013680 19.123 98 9 18 0 1950474864 10877856 2583328
22:01:15 61683 8192000000 10901554928 11371839488 1952457472 19.246 99 19 37 1 1964947344 8160304 4329568
22:02:33 53877 8192000000 10912780128 11387129856 1966264608 19.356 99 15 30 1 1979020336 8796528 3959200
22:03:36 47211 8192000000 10913362352 11387600896 1951033856 19.235 98 24 48 3 1968592672 10805296 6753520
22:04:30 77409 8192000000 10923011456 11386728448 1963061360 19.330 99 18 36 0 1976306256 8247008 4997888
22:05:58 25006 8192000000 10959241232 11408596992 1997716000 19.605 100 67 134 3 2028535664 11999152 18820512
22:06:31 21143 8192000000 10916846416 11379298304 1950086800 19.227 98 43 86 1 1976134768 13779872 12268096
22:06:58 64487 8192000000 10885246144 11364728832 1896336752 18.797 96 26 52 2 1920347664 16760912 7250000
22:08:11 88295 8192000000 10894176064 11361951744 1895441056 18.790 96 14 28 1 1911585856 12112800 4032000
22:09:50 61769 8192000000 10882332976 11353079808 1925859280 19.034 98 24 48 0 1943747664 11225616 6662768
22:11:13 53600 8192000000 10893382096 11360673792 1933300544 19.093 98 22 44 0 1947697680 8314240 6082896
22:12:19 71649 8192000000 10909394048 11380023296 1953379408 19.253 99 17 34 2 1971173824 12936496 4857920
22:13:41 142155 8192000000 10898211664 11379576832 1898389200 18.813 96 7 14 1 1910187152 9588944 2209008
22:16:28 70976 8192000000 10860863216 11340505088 1861158816 18.513 94 28 57 0 1880746896 11182032 8406048
22:17:45 35175 8192000000 10859895408 11340947456 1898991200 18.818 98 7 14 0 1909504752 7943824 2569728
22:18:33 53984 8192000000 10853493536 11333898240 1890096160 18.747 97 6 12 1 1898263712 6498880 1668672
22:19:34 49392 8192000000 10849262112 11327848448 1899195136 18.820 98 11 22 1 1911533184 8906032 3432016
22:20:29 60556 8192000000 10855596256 11335188480 1903593008 18.855 98 15 30 0 1920143344 12253968 4296368
22:21:36 104399 8192000000 10841183808 11333533696 1857065760 18.479 96 8 16 0 1873385248 14045024 2274464
22:23:27 53405 8192000000 10851642288 11329458176 1908663200 18.896 99 13 27 1 1927090480 14355456 4071824
22:24:31 59812 8192000000 10856534832 11333365760 1879525904 18.661 97 15 30 0 1892547648 8470592 4551152
22:25:37 39417 8192000000 10887884624 11362091008 1928139984 19.052 99 24 47 2 1944134064 8936272 7057808
22:26:23 66756 8192000000 10908469952 11381010432 1968080880 19.370 100 21 42 1 1986648960 12416848 6151232
22:27:36 16613 8192000000 9314343184 9597157376 469120176 5.416 24 5 6 2 478797024 8452224 1224624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-06-2021 22:29:14 to 12-06-2021 22:29:46.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 12-06-2021 22:29:47 to 12-06-2021 22:29:49.

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          245158
MON$OLDEST_ACTIVE               245159
MON$OLDEST_SNAPSHOT             245159
MON$NEXT_TRANSACTION            245159
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                       2067232
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.33473 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33473 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33473 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33473 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 ---
:36: 
:37: mscs-test-161.budzdorov.ru    Sat Jun 12 22:27:55 2021
:38:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:39: 
:40: 
:41: mscs-test-161.budzdorov.ru    Sat Jun 12 22:27:56 2021
:42:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:43: 
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Jun 12 22:28:09 2021
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Jun 12 22:28:10 2021
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Sat Jun 12 22:28:14 2021
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
--- end of diff output ---

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

12.06.21 22:29:50. 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-06-12 22:29:53 No severe PSQL-related problems occured
12.06.21 22:29:54. End of report.