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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-10 22:27:07
DTS_END                         2020-12-10 22:27:07.2640
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45580
TRN_ID                          257658
ATT_ID                          717
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: 9970.17 19761 1196421
customer order: creation 184.50 346 22140
customer order: refuse 16.22 245 1946
order to supplier: creation 50.58 1121 6070
order to supplier: removal 3.65 74093 438
invoice (draft): creation 50.23 2644 6028
invoice (draft): removal 56.04 583 6725
invoice accept: apply 46.43 16317 5571
invoice accept: cancel 50.98 624 6118
customer reserve: creation 4184.58 168 502149
customer reserve: removal 5005.66 43 600679
realization accept: apply 91.45 155 10974
realization accept: cancel 86.97 99 10436
payment from customer: creation 65.69 90 7883
payment from customer: removal 6.48 65 778
payment to supplier: creation 54.13 108 6496
payment to supplier: removal 3.46 64 415
service: total inventory turnovers 5.21 925 625
service: total monetary turnovers 6.92 28 830
service: aggregate perf. data 0.97 19382 116
service: refresh index statistics 0.03 278111 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-12-2020 22:29:54 to 10-12-2020 22:29:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7553
TEST_TIME 2 8162
TEST_TIME 3 6827
TEST_TIME 4 6551
TEST_TIME 5 6665
TEST_TIME 6 7172
TEST_TIME 7 7553
TEST_TIME 8 8227
TEST_TIME 9 8237
TEST_TIME 10 8424
TEST_TIME 11 8653
TEST_TIME 12 9069
TEST_TIME 13 9727
TEST_TIME 14 9883
TEST_TIME 15 10330
TEST_TIME 16 10554
TEST_TIME 17 10978
TEST_TIME 18 11359
TEST_TIME 19 11145
TEST_TIME 20 11278
TEST_TIME 21 12437
TEST_TIME 22 12558
TEST_TIME 23 12663
TEST_TIME 24 12286
TEST_TIME 25 12124
TEST_TIME 26 12208
TEST_TIME 27 12406
TEST_TIME 28 12187
TEST_TIME 29 11814
TEST_TIME 30 11581
TEST_TIME 31 11398
TEST_TIME 32 11388
TEST_TIME 33 11227
TEST_TIME 34 11133
TEST_TIME 35 11264
TEST_TIME 36 11094
TEST_TIME 37 10986
TEST_TIME 38 10864
TEST_TIME 39 10660
TEST_TIME 40 10942
TEST_TIME 41 10813
TEST_TIME 42 10837
TEST_TIME 43 10806
TEST_TIME 44 10822
TEST_TIME 45 11014
TEST_TIME 46 10902
TEST_TIME 47 10929
TEST_TIME 48 10929
TEST_TIME 49 10891
TEST_TIME 50 10956
TEST_TIME 51 10970
TEST_TIME 52 10886
TEST_TIME 53 10744
TEST_TIME 54 10672
TEST_TIME 55 10579
TEST_TIME 56 10550
TEST_TIME 57 10459
TEST_TIME 58 10432
TEST_TIME 59 10321
TEST_TIME 60 10281
TEST_TIME 61 10246
TEST_TIME 62 10170
TEST_TIME 63 10191
TEST_TIME 64 10278
TEST_TIME 65 10341
TEST_TIME 66 10404
TEST_TIME 67 10486
TEST_TIME 68 10498
TEST_TIME 69 10488
TEST_TIME 70 10467
TEST_TIME 71 10520
TEST_TIME 72 10513
TEST_TIME 73 10520
TEST_TIME 74 10561
TEST_TIME 75 10486
TEST_TIME 76 10441
TEST_TIME 77 10396
TEST_TIME 78 10366
TEST_TIME 79 10330
TEST_TIME 80 10276
TEST_TIME 81 10225
TEST_TIME 82 10187
TEST_TIME 83 10226
TEST_TIME 84 10173
TEST_TIME 85 10119
TEST_TIME 86 10071
TEST_TIME 87 10044
TEST_TIME 88 10086
TEST_TIME 89 10099
TEST_TIME 90 10174
TEST_TIME 91 10177
TEST_TIME 92 10152
TEST_TIME 93 10165
TEST_TIME 94 10194
TEST_TIME 95 10154
TEST_TIME 96 10169
TEST_TIME 97 10155
TEST_TIME 98 10190
TEST_TIME 99 10156
TEST_TIME 100 10063
TEST_TIME 101 10032
TEST_TIME 102 10016
TEST_TIME 103 9955
TEST_TIME 104 9884
TEST_TIME 105 9909
TEST_TIME 106 9946
TEST_TIME 107 9915
TEST_TIME 108 9899
TEST_TIME 109 9914
TEST_TIME 110 9908
TEST_TIME 111 9905
TEST_TIME 112 9915
TEST_TIME 113 9895
TEST_TIME 114 9975
TEST_TIME 115 9987
TEST_TIME 116 9993
TEST_TIME 117 10045
TEST_TIME 118 10010
TEST_TIME 119 10049
TEST_TIME 120 9972

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-12-2020 22:29:58 to 10-12-2020 22:30:01.

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 1661388 1661388 0 0.00 0 28844 6 0 0
doc_list_biud 1661386 1661386 0 0.00 0 34787 20 0 0
sp_add_invoice_to_stock 5709 5571 138 2.41 47 167338 16317 0 138
sp_cancel_adding_invoice 6118 6118 0 0.00 5 57210 624 0 0
sp_cancel_client_order 1946 1946 0 0.00 4 7407 245 0 0
sp_cancel_customer_reserve 600679 600679 0 0.00 1 18415 43 0 0
sp_cancel_pay_from_customer 778 778 0 0.00 2 4958 65 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 3 3570 64 0 0
sp_cancel_supplier_invoice 6740 6725 15 0.22 2 33020 584 0 15
sp_cancel_supplier_order 438 438 0 0.00 6 933883 74094 0 0
sp_cancel_write_off 10436 10436 0 0.00 1 9719 99 0 0
sp_client_order 22140 22140 0 0.00 3 30162 347 0 0
sp_customer_reserve 502149 502149 0 0.00 0 62442 168 0 0
sp_fill_shopping_cart 34230 34230 0 0.00 1 12086 32 0 0
sp_fill_shopping_cart_clo_res 502146 502146 0 0.00 0 16068 11 0 0
sp_get_clo_for_invoice 5568 5568 0 0.00 0 20443 300 0 0
sp_kill_cost_storno 17747 17747 0 0.00 0 8684 40 0 0
sp_kill_qstorno_ret_qs2qd 1218957 1218957 0 0.00 0 32062 23 0 0
sp_kill_qty_storno 642884 642884 0 0.00 0 34786 51 0 0
sp_lock_selected_doc 22846 22846 0 0.00 0 5904 4 0 0
sp_make_cost_storno 30921 30921 0 0.00 0 28838 42 0 0
sp_multiply_rows_for_pdistr 30921 30921 0 0.00 0 8691 27 0 0
sp_multiply_rows_for_qdistr 22140 22140 0 0.00 0 14788 167 0 0
sp_pay_from_customer 7883 7883 0 0.00 4 6978 91 0 0
sp_pay_to_supplier 6496 6496 0 0.00 5 9675 109 0 0
sp_payment_common 14379 14379 0 0.00 1 6360 26 0 0
sp_qd_handle_on_cancel_clo 1946 1946 0 0.00 0 7402 226 0 0
sp_qd_handle_on_invoice_upd_sts 11686 11686 0 0.00 0 34784 244 0 0
sp_qd_handle_on_reserve_upd_sts 10974 10974 0 0.00 0 18509 53 0 0
sp_reserve_write_off 10974 10974 0 0.00 6 18591 156 0 0
sp_supplier_invoice 6028 6028 0 0.00 6 79950 2644 0 0
sp_supplier_order 6070 6070 0 0.00 5 39206 1121 0 0
srv_aggregate_perf_data 116 116 0 0.00 3176 458147 19383 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1353 141992 33249 0 0
srv_find_qd_qs_mism 1144354 1144354 0 0.00 0 24969 5 0 0
srv_make_invnt_saldo 625 625 0 0.00 39 39295 926 0 0
srv_make_money_saldo 830 830 0 0.00 1 6305 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 155539 434586 278111 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 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 5571 5571 0 0.00 0 35132 138 0 0
t$perf-norm:sp_cancel_adding_invoice 455 455 0 0.00 0 6988 100 0 0
t$perf-norm:sp_cancel_client_order 1946 1946 0 0.00 0 12729 20 0 0
t$perf-norm:sp_cancel_customer_reserve 706 706 0 0.00 0 752 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 778 778 0 0.00 0 1692 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1781 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 441 441 0 0.00 0 3871 21 0 0
t$perf-norm:sp_cancel_supplier_order 438 438 0 0.00 0 28191 1206 0 0
t$perf-norm:sp_cancel_write_off 1125 1125 0 0.00 0 3559 10 0 0
t$perf-norm:sp_client_order 22140 22140 0 0.00 0 8952 14 0 0
t$perf-norm:sp_customer_reserve 1122 1122 0 0.00 0 9031 18 0 0
t$perf-norm:sp_pay_from_customer 7883 7883 0 0.00 0 9359 10 0 0
t$perf-norm:sp_pay_to_supplier 6496 6496 0 0.00 0 25645 14 0 0
t$perf-norm:sp_reserve_write_off 10974 10974 0 0.00 0 8320 11 0 0
t$perf-norm:sp_supplier_invoice 6028 6028 0 0.00 0 7527 13 0 0
t$perf-norm:sp_supplier_order 6070 6070 0 0.00 0 6443 13 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 31 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 3129 42 0 0
t$perf-norm:srv_make_invnt_saldo 625 625 0 0.00 0 2720 20 0 0
t$perf-norm:srv_make_money_saldo 830 830 0 0.00 0 4221 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11412 11136 276 2.41 0 4162 17 0 276
v_all_customers 40324 40324 0 0.00 0 17 1 0 0
v_all_suppliers 33242 33242 0 0.00 0 304 1 0 0
v_all_wares 44280 44280 0 0.00 0 33 1 0 0
v_cancel_adding_invoice 910 910 0 0.00 0 2341 12 0 0
v_cancel_client_order 3892 3892 0 0.00 0 3060 3 0 0
v_cancel_customer_prepayment 1556 1556 0 0.00 0 4949 7 0 0
v_cancel_customer_reserve 1412 1412 0 0.00 0 623 3 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 1091 5 0 0
v_cancel_supplier_invoice 912 882 30 3.28 0 2585 18 0 30
v_cancel_supplier_order 876 876 0 0.00 0 2740 7 0 0
v_cancel_write_off 2250 2250 0 0.00 0 4425 17 0 0
v_max_id_clo_ord 6067 6067 0 0.00 0 545 1 0 0
v_max_id_clo_res 1122 1122 0 0.00 0 1976 13 0 0
v_max_id_ord_sup 6023 6023 0 0.00 0 2975 4 0 0
v_max_non_paid_invoice 1965 1965 0 0.00 0 3649 5 0 0
v_max_non_paid_realizn 4320 4320 0 0.00 0 4870 4 0 0
v_min_id_clo_ord 6067 6067 0 0.00 0 4470 4 0 0
v_min_id_clo_res 1122 1122 0 0.00 0 4642 17 0 0
v_min_id_ord_sup 6023 6023 0 0.00 0 6040 5 0 0
v_min_non_paid_invoice 6496 6496 0 0.00 0 5635 16 0 0
v_min_non_paid_realizn 7883 7883 0 0.00 0 6353 20 0 0
v_our_firm 11082 11082 0 0.00 0 165 1 0 0
v_reserve_write_off 21948 21948 0 0.00 0 7316 7 0 0
x_lock_depdocs_on_canc_invoice 12402 12402 0 0.00 0 16163 89 0 0
x_lock_depdocs_on_canc_sup_ord 438 438 0 0.00 0 9959 246 0 0
x_make_qstorno_1000_1200 6070 6070 0 0.00 1 39198 1053 0 0
x_make_qstorno_1200_2000 6028 6028 0 0.00 3 79678 2534 0 0
x_make_qstorno_2100_3300 502149 502149 0 0.00 0 62442 155 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-12-2020 22:30:02 to 10-12-2020 22:30:06.

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:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:17 26716 8192000000 10290438816 10599309312 937632896 10.270 72 61 122 0 960142640 2668320 19841424
19:57:55 24621 8192000000 10357704736 10671587328 1397005296 14.568 100 87 175 0 1430367056 5578224 27783536
19:58:26 18724 8192000000 10382712704 10703147008 1436537120 14.919 100 94 188 0 1474314304 7028160 30749024
19:58:53 24215 8192000000 10398751744 10724667392 1451672560 15.053 100 89 178 0 1488105280 7751200 28681520
19:59:45 20076 8192000000 10450019952 10782715904 1491761552 15.404 100 86 172 0 1528293584 8747520 27784512
20:00:17 10929 8192000000 10464463120 10799484928 1517995392 15.633 100 90 180 0 1556286656 9468224 28823040
20:00:39 24271 8192000000 10487762640 10826969088 1536758752 15.796 100 94 188 0 1577251904 10557024 29936128
20:01:16 21975 8192000000 10509746272 10856468480 1562675024 16.019 100 86 172 0 1600454000 11325040 26453936
20:01:46 18794 8192000000 10532430784 10887811072 1590022288 16.254 100 76 152 0 1624030048 10830864 23176896
20:02:13 16021 8192000000 10565777088 10920767488 1619079552 16.502 100 85 170 1 1656226720 11212544 25934624
20:02:40 13965 8192000000 10585273008 10949799936 1639698640 16.677 100 78 156 1 1675556752 11904288 23953824
20:03:03 14733 8192000000 10610026896 10978701312 1668087360 16.917 100 72 144 1 1701011648 11682256 21242032
20:03:25 10248 8192000000 10622845360 10993328128 1681846096 17.033 100 76 152 0 1716752560 12948144 21958320
20:03:42 8556 8192000000 10631080288 11003817984 1694637776 17.140 100 74 148 0 1728350432 12401360 21311296
20:03:57 5782 8192000000 10643152064 11016884224 1708804656 17.259 100 83 166 2 1750073920 17510112 23759152
20:04:10 3721 8192000000 10659041920 11030982656 1723443680 17.381 100 75 148 2 1758599152 13569392 21586080
20:04:21 4137 8192000000 10663298976 11038302208 1728489808 17.423 100 74 146 2 1762668880 13161472 21017600
20:04:33 4766 8192000000 10677754832 11054133248 1740849664 17.526 100 75 151 2 1774622272 12621616 21150992
20:04:44 3514 8192000000 10680315504 11060707328 1747353568 17.580 100 77 154 1 1782026912 12674496 21998848
20:04:55 3471 8192000000 10687179872 11067195392 1759347536 17.679 100 73 146 1 1792203600 12373088 20482976
20:05:05 2712 8192000000 10700855600 11079147520 1766994368 17.742 100 84 168 1 1802847504 12713856 23139280
20:05:14 2490 8192000000 10716808768 11092164608 1772150896 17.785 100 89 177 1 1810950352 14306304 24493152
20:05:24 7251 8192000000 10718650096 11096064000 1772700080 17.789 100 74 148 0 1807332032 14202368 20429584
20:05:40 3406 8192000000 10726886544 11109457920 1794309776 17.967 100 84 168 0 1832996848 14922560 23764512
20:05:49 2417 8192000000 10746571840 11130523648 1804464432 18.051 100 82 164 0 1840457632 13045616 22947584
20:05:59 1554 8192000000 10758231248 11142324224 1822606944 18.199 100 92 182 2 1862384512 13583136 26194432
20:06:07 2430 8192000000 10773417760 11157188608 1828494176 18.247 100 87 174 3 1867030608 12788160 25748272
20:06:16 1949 8192000000 10775527184 11160809472 1834156144 18.293 100 88 174 0 1872152912 13312928 24683840
20:06:25 1604 8192000000 10772927008 11160821760 1838826256 18.331 100 90 177 1 1874848192 11058224 24963712
20:06:33 1576 8192000000 10785997280 11168419840 1840508656 18.345 100 89 178 1 1878386080 13063344 24814080
20:06:41 1531 8192000000 10785837120 11171696640 1844682480 18.379 100 92 182 0 1884241792 13971648 25587664
20:06:49 2033 8192000000 10792225808 11176837120 1847720512 18.404 100 85 170 1 1884184192 13168960 23294720
20:06:58 1255 8192000000 10805975920 11189157888 1860315792 18.506 100 91 183 0 1899999760 13294784 26389184
20:07:06 6957 8192000000 10790607296 11193462784 1862577520 18.524 100 69 138 0 1894073808 12288032 19208256
20:07:20 38700 8192000000 10785458112 11197444096 1856978496 18.479 100 44 88 1 1877538192 6955680 13604016
20:08:06 10100 8192000000 10781343792 11199803392 1861436928 18.515 100 37 74 0 1883254128 11060432 10756768
20:08:25 3877 8192000000 10779328112 11197263872 1870031728 18.585 100 54 108 0 1894356336 7816800 16507808
20:08:38 7497 8192000000 10785159824 11198091264 1864411152 18.539 100 28 54 1 1883389488 11166368 7811968
20:08:53 6620 8192000000 10777736720 11205496832 1870082704 18.585 100 31 62 2 1887191632 7860768 9248160
20:09:08 7265 8192000000 10775778176 11205611520 1869077824 18.577 100 19 36 2 1880858144 6885488 4894832
20:09:22 7912 8192000000 10785207744 11208560640 1873965344 18.616 100 22 44 0 1885759568 4940784 6853440
20:09:39 11674 8192000000 10782714544 11212206080 1875447344 18.628 100 14 28 1 1884792096 5626944 3717808
20:10:01 8151 8192000000 10797509792 11226460160 1883384432 18.692 100 30 60 1 1898654256 6417824 8852000
20:10:18 8421 8192000000 10791976848 11220602880 1880555056 18.670 100 24 48 1 1894175328 7007360 6612912
20:10:35 9446 8192000000 10797964672 11226734592 1880132048 18.666 100 22 44 2 1896268336 10449120 5687168
20:10:51 21766 8192000000 10796934400 11228639232 1885515312 18.710 100 28 56 2 1899277408 5895264 7866832
20:11:51 20654 8192000000 10810551600 11241984000 1892662432 18.767 100 37 74 3 1909307120 6351472 10293216
20:12:18 15905 8192000000 10816792752 11245899776 1896091888 18.795 100 32 64 1 1912029328 7334768 8602672
20:12:41 3179 8192000000 10822739312 11247226880 1900493984 18.830 100 36 72 0 1918201760 7205648 10502128
20:12:51 5464 8192000000 10818449744 11244703744 1897941120 18.810 100 35 70 2 1914855408 6729184 10185104
20:13:03 7507 8192000000 10818665872 11250446336 1897250704 18.804 100 31 63 1 1920827232 14972016 8604512
20:13:17 7239 8192000000 10811828752 11247329280 1900787344 18.833 100 29 58 0 1915101840 5428080 8886416
20:13:30 5643 8192000000 10821521840 11254853632 1903547888 18.855 100 31 63 1 1923512816 11089584 8875344
20:13:48 8429 8192000000 10822160880 11252903936 1903585104 18.855 100 28 55 2 1918170096 6603904 7981088
20:14:04 10629 8192000000 10820556576 11253981184 1901869024 18.841 100 17 34 0 1912182672 5335872 4977776
20:14:26 11254 8192000000 10820229856 11254890496 1902558944 18.847 100 12 22 2 1911850768 5642128 3649696
20:14:43 9486 8192000000 10813846208 11244232704 1882942176 18.689 99 13 26 0 1891844176 5183184 3718816
20:15:00 10879 8192000000 10815721440 11250352128 1897997376 18.810 100 18 36 1 1909230800 6534448 4698976
20:15:21 15199 8192000000 10800092800 11232890880 1859214288 18.497 98 17 32 1 1869238496 5749904 4274304
20:15:42 56512 8192000000 10793487008 11220021248 1820930832 18.185 96 43 87 2 1838764400 5533392 12300176
20:16:53 17690 8192000000 10779175424 11204804608 1787623152 17.912 95 14 28 0 1796481840 5184304 3674384
20:17:17 6542 8192000000 10771795696 11189927936 1844740416 18.379 99 32 64 0 1861652816 8402736 8509664
20:17:32 6540 8192000000 10753142464 11176501248 1788174864 17.917 96 17 33 0 1798124784 5177280 4772640
20:17:47 5414 8192000000 10773369136 11202260992 1846582816 18.394 99 24 48 1 1859035984 5106432 7346736
20:18:01 5581 8192000000 10767594528 11180380160 1785668880 17.896 96 37 74 3 1802989936 7162368 10158688
20:18:13 6342 8192000000 10704931072 11127386112 1699885872 17.184 93 25 50 0 1713185248 6165216 7134160
20:18:25 5659 8192000000 10700289056 11117424640 1755862352 17.650 98 33 65 1 1771366096 6036976 9466768
20:18:38 7917 8192000000 10710197216 11129716736 1752509376 17.622 97 25 50 1 1765693136 5376816 7806944
20:18:52 14282 8192000000 10665239296 11071557632 1667171088 16.909 93 19 38 2 1677070032 4313872 5585072
20:19:16 8692 8192000000 10713196848 11122688000 1755937824 17.651 98 21 42 0 1767302176 5010944 6353408
20:19:33 5296 8192000000 10688055344 11098247168 1754648880 17.640 99 39 78 2 1772090976 5518384 11923712
20:19:46 9323 8192000000 10700727856 11109834752 1746947216 17.576 98 28 55 2 1760922528 4853696 9121616
20:20:02 8105 8192000000 10697183456 11120279552 1777799456 17.831 99 37 74 1 1794205920 5498096 10908368
20:20:20 70883 8192000000 10733796432 11160276992 1803598080 18.043 99 39 76 4 1820193792 5677152 10918560
20:21:37 10089 8192000000 10730391808 11146121216 1787350528 17.910 98 33 67 1 1802896544 5727984 9818032
20:21:54 7400 8192000000 10736247904 11154575360 1804895568 18.054 99 29 58 1 1819856896 6544352 8416976
20:22:09 5895 8192000000 10754207984 11167010816 1827220416 18.237 100 32 63 1 1843461616 7617984 8623216
20:22:21 6693 8192000000 10751884560 11178213376 1840148704 18.342 100 31 62 1 1855971744 7045456 8777584
20:22:34 6896 8192000000 10765692144 11184590848 1843388704 18.368 100 31 62 3 1857781568 5582704 8810160
20:22:48 8962 8192000000 10767428720 11192909824 1851412816 18.434 100 31 62 2 1867041104 6825600 8802688
20:23:05 9091 8192000000 10773482816 11201794048 1854513376 18.459 100 24 49 1 1875469136 14793248 6162512
20:23:23 10251 8192000000 10765404240 11200372736 1857020128 18.479 100 24 48 0 1869421504 5627904 6773472
20:23:40 7486 8192000000 10777842512 11205754880 1860689488 18.509 100 23 46 0 1872959584 5673472 6596624
20:23:55 12162 8192000000 10777162608 11210973184 1860749024 18.509 100 10 20 0 1873476272 9417984 3309264
20:24:16 9079 8192000000 10790894144 11212513280 1864639776 18.541 100 15 30 3 1874251296 5101648 4509872
20:24:33 11992 8192000000 10793828432 11219607552 1869570976 18.581 100 19 38 0 1880955312 5619216 5765120
20:24:57 14110 8192000000 10794239168 11220283392 1874119168 18.618 100 12 24 1 1883810240 5567840 4123232
20:25:20 70521 8192000000 10798901200 11228508160 1879758288 18.663 100 27 54 2 1893884768 6824560 7301920
20:26:42 7311 8192000000 10790777040 11226259456 1878492064 18.653 100 17 32 2 1889058976 5934800 4632112
20:26:55 7733 8192000000 10797548720 11226501120 1884804064 18.704 100 20 40 0 1896182384 5547152 5831168
20:27:14 11768 8192000000 10842566256 11256016896 1908842192 18.897 100 58 115 1 1931147248 5765472 16539584
20:27:33 12043 8192000000 10835323776 11255869440 1910845648 18.913 100 49 98 0 1932604048 7754976 14003424
20:27:53 16652 8192000000 10853415856 11274240000 1919720224 18.985 100 45 91 0 1942864992 10624752 12520016
20:28:17 4279 8192000000 10869112896 11285233664 1932202720 19.084 100 61 122 0 1961089824 11748576 17138528
20:28:30 28695 8192000000 10872690896 11293114368 1938093472 19.132 100 52 103 0 1965117456 12238448 14785536
20:29:19 12371 8192000000 10874559664 11302281216 1940090560 19.147 100 48 96 1 1966829888 12978976 13760352
20:29:41 22547 8192000000 10874649632 11304284160 1940545168 19.151 100 34 68 0 1961974912 11735728 9694016
20:30:11 15014 8192000000 10892224304 11315822592 1952261520 19.244 100 51 102 1 1981652256 14674864 14715872
20:30:41 9088 8192000000 10907718928 11331592192 1959725696 19.304 100 54 108 0 1993841728 18758224 15357808
20:30:57 15228 8192000000 10911747952 11340754944 1964525664 19.342 100 55 110 2 2001917360 21248992 16142704
20:31:20 17110 8192000000 10914232544 11353190400 1970843936 19.392 100 47 93 3 2011182512 26277904 14060672
20:32:03 30573 8192000000 10917485840 11353448448 1975665408 19.430 100 37 73 1 2010623664 24094048 10864208
20:32:42 7914 8192000000 10924105760 11362377728 1978028512 19.449 100 43 85 0 2014952432 23271488 13652432
20:32:56 5081 8192000000 10917292416 11355729920 1973923728 19.417 100 49 97 1 2013098432 24709296 14465408
20:33:10 10132 8192000000 10917350864 11355820032 1973374400 19.412 100 59 116 2 2016957152 26422144 17160608
20:33:29 6141 8192000000 10933467840 11361841152 1963451568 19.333 99 57 114 0 2011120896 30603040 17066288
20:33:42 2286 8192000000 10930638640 11357822976 1976204080 19.435 100 64 127 1 2022858944 27566544 19088320
20:33:52 5562 8192000000 10931982032 11358842880 1979526112 19.461 100 53 106 1 2020710512 25674016 15510384
20:34:05 4216 8192000000 10937538448 11363840000 1983162352 19.490 100 64 125 1 2027627040 26493712 17970976
20:34:18 7968 8192000000 10942444992 11374428160 1984390688 19.499 100 57 114 1 2028778976 27510816 16877472
20:34:34 4608 8192000000 10944542688 11375919104 1991603408 19.556 100 59 118 0 2037669760 28683616 17382736
20:34:48 2245 8192000000 10953322928 11377020928 1992262352 19.562 100 69 138 2 2042548368 29723392 20562624
20:34:59 2191 8192000000 10955357776 11374338048 1991612896 19.557 100 88 175 1 2046745440 30228640 24903904
20:35:08 3264 8192000000 10964448928 11376648192 1988797456 19.534 100 77 152 2 2040443680 30005072 21641152
20:35:20 1621 8192000000 10962333568 11378151424 1992365728 19.562 100 75 150 3 2045365104 30088352 22911024
20:35:29 4391 8192000000 10974981440 11386200064 1998137584 19.608 100 81 158 0 2052856016 31844640 22873792
20:35:40 2606 8192000000 10964879952 11379216384 1994428688 19.579 100 83 165 3 2047773184 29205088 24139408
20:35:50 12171 8192000000 10970281984 11388289024 1995982016 19.591 100 70 140 0 2046008864 29743056 20283792
20:36:09 4600 8192000000 10969933712 11392225280 2000221200 19.624 100 76 152 0 2053757984 31438960 22097824
20:36:21 5150 8192000000 10949714704 11383242752 1994676320 19.581 100 66 129 0 2044356416 30586912 19093184
20:36:39 3480 8192000000 10932734656 11356798976 1956177168 19.276 99 58 114 1 2003960112 30471680 17311264
20:36:48 5464 8192000000 10945552336 11368689664 1977833280 19.448 100 75 149 1 2031048464 30823488 22391696
20:37:00 1352 8192000000 10937975392 11350491136 1960403424 19.309 99 76 152 2 2014912288 31361760 23147104
20:37:11 5837 8192000000 10904176320 11325313024 1930748544 19.073 98 69 138 2 1985475200 33678016 21048640
20:37:26 7658 8192000000 10919885648 11355267072 1961881056 19.321 100 57 114 0 2012316672 32306320 18129296
20:37:41 2641 8192000000 10919796560 11342680064 1943894736 19.178 99 64 129 1 1996459712 32400576 20164400
20:37:50 3743 8192000000 10932036944 11353182208 1961474416 19.318 100 74 148 2 2017402752 34012720 21915616
20:38:01 2814 8192000000 10930391232 11338612736 1954400512 19.262 99 84 165 2 2013859440 34030512 25428416
20:38:11 6985 8192000000 10944586288 11366256640 1969660592 19.383 100 76 146 0 2030496848 39486080 21350176
20:38:31 7875 8192000000 10939973344 11368656896 1972180000 19.403 100 73 147 1 2033345248 38210880 22954368
20:38:46 8313 8192000000 10939687696 11363299328 1935977968 19.115 98 68 136 2 1997138432 40384240 20776224
20:39:02 2354 8192000000 10923918432 11331997696 1941657680 19.160 99 85 171 2 2004643360 36002976 26982704
20:39:11 1734 8192000000 10939878000 11363688448 1956064352 19.275 99 80 160 1 2018085456 37295824 24725280
20:39:20 1921 8192000000 10928905872 11333824512 1945271424 19.189 100 80 158 1 2001021056 31240000 24509632
20:39:28 1872 8192000000 10926842112 11335778304 1940063264 19.147 99 81 164 3 1999861280 35816256 23981760
20:39:38 7861 8192000000 10921506000 11335049216 1928607040 19.056 99 71 142 0 1985548864 35626624 21315200
20:39:56 7521 8192000000 10922231296 11349340160 1948299168 19.213 100 61 122 1 2007083856 39843232 18941456
20:40:11 4544 8192000000 10932417904 11360481280 1953567872 19.255 100 53 106 0 2015495152 45271184 16656096
20:40:31 4253 8192000000 10916251376 11350437888 1938905760 19.138 99 46 92 0 1986970240 33697952 14366528
20:40:47 18625 8192000000 10834773584 11265904640 1805002832 18.055 93 39 78 1 1851296096 33942736 12350528
20:41:16 3108 8192000000 10842862048 11265335296 1854622848 18.460 98 52 101 2 1905672512 35061520 15988144
20:41:26 6835 8192000000 10840738976 11263971328 1846819024 18.396 98 45 90 0 1897486704 36110912 14556768
20:41:43 3475 8192000000 10875195808 11292758016 1884835776 18.704 99 63 125 1 1945472832 40183472 20453584
20:41:54 23642 8192000000 10858094128 11302289408 1911553840 18.919 100 32 64 3 1963456688 40446576 11456272
20:42:30 13993 8192000000 10864723344 11297935360 1878625600 18.654 98 35 70 1 1921528144 31313632 11588912
20:42:59 8064 8192000000 10877702544 11302793216 1897084432 18.803 99 43 85 0 1946928400 36395952 13448016
20:43:18 10625 8192000000 10886656448 11322392576 1923706240 19.017 100 44 86 1 1973503472 35897760 13899472
20:43:35 18247 8192000000 10846468496 11286061056 1858105856 18.488 97 27 54 3 1903714880 36319808 9289216
20:44:02 9382 8192000000 10870647792 11303825408 1902176544 18.844 100 34 68 0 1952022160 38008320 11837296
20:44:18 19268 8192000000 10869488416 11305996288 1899104208 18.819 99 28 56 0 1940013760 30961936 9947616
20:45:09 25063 8192000000 10877593888 11319042048 1927779088 19.049 100 27 52 1 1972836592 36328112 8729392
20:45:50 17212 8192000000 10890179008 11328479232 1938168176 19.132 100 26 52 2 1970058192 23640112 8249904
20:46:16 9051 8192000000 10893404736 11335401472 1944966224 19.186 100 30 61 0 1979361872 24710704 9684944
20:46:39 22875 8192000000 10867822448 11308552192 1876242096 18.635 97 25 48 1 1909137984 25025952 7869936
20:47:24 26989 8192000000 10860989184 11315507200 1884537344 18.702 98 19 38 1 1914801664 23798080 6466240
20:47:57 27529 8192000000 10861801696 11312463872 1913649680 18.936 100 20 40 2 1950652624 30054864 6948080
20:48:34 21008 8192000000 10854696784 11333722112 1909284432 18.901 100 7 14 0 1941573168 29717600 2571136
20:49:36 58071 8192000000 10857610912 11312594944 1885430576 18.709 98 9 16 0 1904338208 16679632 2228000
20:50:41 49161 8192000000 10867162336 11289448448 1906986352 18.882 99 35 65 0 1925683120 10259008 8437760
20:51:38 19148 8192000000 10890547648 11309293568 1920658320 18.992 99 64 128 2 1948813584 10375680 17779584
20:52:06 27848 8192000000 10861900864 11302416384 1882757184 18.687 98 35 70 1 1909130672 16315280 10058208
20:52:46 114943 8192000000 10882925424 11359174656 1927045296 19.043 100 30 58 2 1954112784 18972160 8095328
20:54:47 141991 8192000000 10894697344 11326468096 1911080800 18.915 98 19 37 2 1929142640 12690240 5371600
20:57:22 80508 8192000000 10903408976 11360169984 1967447296 19.365 100 37 71 1 1985478688 8461504 9569888
20:58:50 41015 8192000000 10937920560 11377737728 1980693296 19.470 100 25 50 1 1997455728 9846832 6915600
20:59:38 16426 8192000000 10918652240 11382460416 1992781040 19.566 100 34 66 0 2010569248 8855472 8932736
21:00:01 24858 8192000000 10927068000 11382595584 1992341968 19.562 100 39 78 0 2011475984 7876928 11257088
21:00:33 20160 8192000000 10934101264 11387977728 1999753072 19.621 100 44 86 1 2021845984 10515264 11577648
21:01:02 49253 8192000000 10922708688 11388641280 1990870656 19.551 100 25 50 1 2010369408 12052576 7446176
21:01:58 31995 8192000000 10909755744 11393998848 1987026944 19.520 100 13 26 0 2010834016 19348832 4458240
21:02:47 3709 8192000000 10903813488 11394162688 1983806816 19.495 100 5 10 1 1995703472 10603632 1293024
21:03:02 53823 8192000000 10916898960 11390332928 1989223168 19.538 100 11 21 1 2004169024 11291856 3654000
21:04:02 76272 8192000000 10926233568 11400265728 2001030512 19.631 100 21 42 0 2018727424 11341408 6355504
21:05:25 76310 8192000000 10944852544 11410182144 2010477728 19.705 100 24 48 0 2030924464 13551024 6895712
21:06:54 70468 8192000000 10935337040 11436421120 2004436624 19.658 100 11 22 1 2029173696 21382144 3354928
21:08:10 24213 8192000000 10961339968 11412172800 2018532336 19.769 100 34 68 1 2034153824 6498880 9122608
21:08:49 30214 8192000000 10968713504 11420041216 2023865584 19.811 100 45 88 1 2045069440 9417296 11786560
21:09:28 29225 8192000000 10946598832 11414847488 2002648176 19.644 99 40 81 0 2025566528 11430304 11488048
21:10:10 59991 8192000000 10939362576 11406114816 1976541840 19.437 98 16 32 0 1994768384 13865904 4360640
21:11:17 41427 8192000000 10946989136 11427459072 2011172880 19.711 100 29 58 0 2038609632 18638368 8798384
21:12:08 54143 8192000000 10944639616 11429888000 2010508304 19.706 100 12 24 0 2034299312 20127440 3663568
21:13:57 42642 8192000000 10930936112 11406700544 1977832032 19.448 99 12 24 1 1994495536 12999760 3663744
21:14:53 75177 8192000000 10931764272 11389853696 1940319824 19.149 97 27 54 0 1961568144 13909392 7338928
21:16:22 45761 8192000000 10927057424 11394973696 1945191440 19.188 97 40 80 0 1965453744 8526544 11735760
21:17:14 57605 8192000000 10942769968 11405737984 1970562336 19.390 99 15 28 2 1989416064 14843184 4010544
21:18:18 137169 8192000000 10899221840 11362066432 1866324240 18.555 94 16 32 0 1883065152 12640592 4100320
21:21:00 66834 8192000000 10882616864 11334782976 1830904848 18.267 93 31 61 0 1845732640 6493440 8334352
21:22:23 29632 8192000000 10872893200 11326058496 1932127584 19.084 99 40 80 2 1951932464 8828480 10976400
21:22:59 38678 8192000000 10820193552 11283599360 1775792240 17.815 91 20 40 0 1788922512 6992064 6138208
21:23:51 47482 8192000000 10831688208 11303407616 1877385312 18.644 98 11 22 1 1888471120 8085184 3000624
21:24:45 11658 8192000000 10821701792 11296886784 1895036384 18.786 99 10 20 0 1906746368 9019920 2690064
21:25:02 8008 8192000000 10819619248 11293077504 1889422656 18.741 99 5 10 0 1901612016 10537168 1652192
21:25:16 1908 8192000000 10814989424 11295711232 1902696464 18.848 100 3 6 1 1911758976 8312976 749536
21:25:24 1783 8192000000 10819022016 11299770368 1905766688 18.873 100 2 4 0 1914650512 8360560 523264
21:25:32 2753 8192000000 10809138880 11292241920 1885032720 18.706 99 2 4 0 1893493184 8066976 393488
21:25:45 37143 8192000000 10825383328 11295698944 1867433568 18.564 98 10 20 1 1877050256 7021616 2595072
21:26:28 42931 8192000000 10819162944 11298807808 1893208208 18.772 99 5 10 0 1903151200 8489392 1453600
21:27:24 28152 8192000000 10807636224 11270279168 1820889424 18.185 95 4 8 1 1827206832 5590880 726528
21:27:59 50648 8192000000 10863612240 11324649472 1904855120 18.865 99 26 50 1 1922917456 11267664 6794672
21:29:01 35907 8192000000 10856988256 11310067712 1881135872 18.674 97 25 49 1 1901142080 12824448 7181760
21:29:43 82175 8192000000 10857598304 11313172480 1839816544 18.339 95 18 36 2 1861105712 16274976 5014192
21:31:17 53164 8192000000 10817372240 11282378752 1808179296 18.081 94 8 16 0 1826406608 16286144 1941168
21:32:21 50490 8192000000 10864888208 11325046784 1903283824 18.853 99 20 40 2 1920250912 11427408 5539680
21:34:29 62582 8192000000 10862116880 11338022912 1898742208 18.816 98 17 34 0 1922993296 19050464 5200624
21:35:42 22168 8192000000 10875060464 11310301184 1859929824 18.503 96 38 76 3 1880219184 9099936 11189424
21:36:12 11291 8192000000 10864113088 11308294144 1917785072 18.969 100 44 88 1 1943476352 13308736 12382544
21:36:31 33656 8192000000 10867027232 11296571392 1875910832 18.632 97 52 104 1 1901145936 11155728 14079376
21:37:16 18530 8192000000 10863941984 11299278848 1881497184 18.677 98 46 90 2 1906060432 12312608 12250640
21:37:41 10886 8192000000 10878396960 11319054336 1928733168 19.057 100 41 82 2 1950710096 10514336 11462592
21:38:02 13642 8192000000 10908598144 11330424832 1942872800 19.170 100 60 120 0 1970970096 11936160 16161136
21:38:25 29388 8192000000 10890211408 11353923584 1948205248 19.212 100 39 78 1 1975872816 16716624 10950944
21:39:03 53319 8192000000 10905896896 11354284032 1915882592 18.954 98 27 54 0 1937673888 14269008 7522288
21:40:03 30975 8192000000 10909038736 11370573824 1962682672 19.327 100 33 66 1 1987502208 15674640 9144896
21:40:44 58183 8192000000 10875498352 11350028288 1922245872 19.005 98 13 26 0 1944561744 18374768 3941104
21:42:08 112304 8192000000 10914254816 11373875200 1963974608 19.338 100 28 56 1 1985857200 13817872 8064720
21:44:07 64571 8192000000 10909295008 11384516608 1971430032 19.397 100 22 44 0 1990443968 12845088 6168848
21:45:23 46240 8192000000 10909847248 11388780544 1979455200 19.460 100 24 46 3 2003512960 17887200 6170560
21:48:27 64623 8192000000 10903640352 11382136832 1978302576 19.451 100 15 30 1 1992965760 10371088 4292096
21:49:42 83320 8192000000 10891684736 11374125056 1975057760 19.426 100 18 36 0 1993356736 13495648 4803328
21:51:46 48944 8192000000 10901504784 11385372672 1981793456 19.479 100 11 19 2 1993614720 9259056 2562208
21:52:50 73383 8192000000 10925228176 11401715712 1997169728 19.600 100 20 40 1 2016800496 13604560 6026208
21:54:18 69085 8192000000 10937862448 11413684224 1993496256 19.571 100 23 46 0 2015144048 15249760 6398032
21:55:34 79488 8192000000 10900568944 11382616064 1914316864 18.941 96 14 28 1 1939825696 21459024 4049808
21:56:59 53381 8192000000 10904308592 11376001024 1958888272 19.297 99 19 38 1 1974889280 10663280 5337728
21:57:59 82379 8192000000 10896112512 11379814400 1938510832 19.135 98 8 16 0 1950129968 9789888 1829248
21:59:28 15961 8192000000 10927520608 11375976448 1982346496 19.483 100 47 92 2 2000908160 5667616 12894048
21:59:52 17226 8192000000 10927785600 11384877056 1993587920 19.572 100 64 129 1 2019861760 8710368 17563472
22:00:15 40073 8192000000 10904169376 11371061248 1950436256 19.230 98 27 54 1 1968651568 10992816 7222496
22:01:02 73050 8192000000 10930009184 11388678144 1967357392 19.364 99 20 39 2 1983781104 10907136 5516576
22:02:22 30157 8192000000 10930686160 11388350464 1960356432 19.309 98 35 69 1 1979100416 9280576 9463408
22:03:02 67354 8192000000 10919378208 11362959360 1883650064 18.695 95 28 56 2 1905335520 13738496 7946960
22:04:18 28249 8192000000 10916434064 11371253760 1969963264 19.385 100 49 97 3 1995658384 12387536 13307584
22:04:56 74252 8192000000 10883771488 11361824768 1872955632 18.608 95 14 28 2 1888535456 11683248 3896576
22:06:21 130412 8192000000 10864532480 11325333504 1872144064 18.602 96 23 46 1 1888033520 9643120 6246336
22:08:37 42119 8192000000 10888353520 11342336000 1918750944 18.977 98 32 64 0 1940416416 12862816 8802656
22:09:34 60987 8192000000 10857799136 11340095488 1910732640 18.913 98 14 26 0 1926063760 10889856 4441264
22:11:01 46095 8192000000 10857438112 11328258048 1899947056 18.826 98 9 18 0 1914713520 12181232 2585232
22:12:03 66894 8192000000 10814835504 11288743936 1834358848 18.295 95 10 20 2 1853032560 15381008 3292704
22:13:28 124639 8192000000 10847487824 11320086528 1827939568 18.243 95 5 10 0 1838456768 9193328 1323872
22:15:40 79499 8192000000 10849319776 11309350912 1815567520 18.141 94 17 33 0 1832073152 11972448 4533184
22:17:16 46707 8192000000 10828681792 11295420416 1831167104 18.269 95 15 30 1 1847077568 11778384 4132080
22:18:09 88302 8192000000 10858790576 11316912128 1845480656 18.385 96 9 18 0 1868085360 19762320 2842384
22:19:48 61370 8192000000 10859010656 11321966592 1863564928 18.532 97 18 36 1 1887010640 17979504 5466208
22:21:08 32173 8192000000 10858205344 11326906368 1907841760 18.889 99 28 56 0 1926168544 10884736 7442048
22:21:51 40147 8192000000 10862822416 11328565248 1892126928 18.763 98 17 34 1 1910900048 13984560 4788560
22:22:44 52212 8192000000 10878490864 11339980800 1902305184 18.845 98 31 62 0 1922775936 11778032 8692720
22:24:02 68371 8192000000 10866992160 11337035776 1911542400 18.919 99 17 34 1 1933935072 17300688 5091984
22:25:19 20460 8192000000 10882966816 11334758400 1936983632 19.123 100 36 72 2 1956094336 8973360 10137344
22:25:57 53693 8192000000 10870844112 11339247616 1889491920 18.742 98 31 62 1 1918222576 20071360 8659296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 10-12-2020 22:30:08 to 10-12-2020 22:30:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 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 10-12-2020 22:30:39 to 10-12-2020 22:30:41.

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          257959
MON$OLDEST_ACTIVE               257960
MON$OLDEST_SNAPSHOT             257960
MON$NEXT_TRANSACTION            257960
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                       2042144
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.33399 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33399 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33399 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33399 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 ---
:24: 
:25: mscs-test-161.budzdorov.ru    Thu Dec 10 22:27:58 2020
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
--- end of diff output ---

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

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