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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-04 16:27:09
DTS_END                         2021-01-04 16:27:09.9290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39216
TRN_ID                          238460
ATT_ID                          616
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: 9503.84 24839 1140461
customer order: creation 169.09 347 20291
customer order: refuse 14.88 364 1785
order to supplier: creation 44.63 1274 5356
order to supplier: removal 3.41 102908 409
invoice (draft): creation 45.49 3141 5459
invoice (draft): removal 54.03 789 6483
invoice accept: apply 42.46 16761 5095
invoice accept: cancel 48.88 772 5865
customer reserve: creation 3981.16 162 477739
customer reserve: removal 4812.07 57 577448
realization accept: apply 82.10 164 9852
realization accept: cancel 77.33 112 9279
payment from customer: creation 57.75 104 6930
payment from customer: removal 5.63 89 675
payment to supplier: creation 49.12 126 5894
payment to supplier: removal 3.47 78 416
service: total inventory turnovers 4.76 1087 571
service: total monetary turnovers 6.82 45 818
service: aggregate perf. data 0.77 23698 92
service: refresh index statistics 0.03 344698 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-01-2021 16:29:26 to 04-01-2021 16:29:28.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6231
TEST_TIME 2 5373
TEST_TIME 3 5244
TEST_TIME 4 4962
TEST_TIME 5 4804
TEST_TIME 6 5396
TEST_TIME 7 5209
TEST_TIME 8 5758
TEST_TIME 9 6029
TEST_TIME 10 6627
TEST_TIME 11 6584
TEST_TIME 12 6658
TEST_TIME 13 6900
TEST_TIME 14 7110
TEST_TIME 15 7397
TEST_TIME 16 7751
TEST_TIME 17 7882
TEST_TIME 18 8178
TEST_TIME 19 8568
TEST_TIME 20 8973
TEST_TIME 21 9230
TEST_TIME 22 8971
TEST_TIME 23 9891
TEST_TIME 24 10078
TEST_TIME 25 10623
TEST_TIME 26 11090
TEST_TIME 27 11321
TEST_TIME 28 11780
TEST_TIME 29 11584
TEST_TIME 30 11515
TEST_TIME 31 11424
TEST_TIME 32 11437
TEST_TIME 33 11298
TEST_TIME 34 11327
TEST_TIME 35 11322
TEST_TIME 36 11356
TEST_TIME 37 11177
TEST_TIME 38 10929
TEST_TIME 39 10823
TEST_TIME 40 10651
TEST_TIME 41 10570
TEST_TIME 42 10536
TEST_TIME 43 10487
TEST_TIME 44 10589
TEST_TIME 45 10476
TEST_TIME 46 10365
TEST_TIME 47 10339
TEST_TIME 48 10253
TEST_TIME 49 10189
TEST_TIME 50 10076
TEST_TIME 51 9939
TEST_TIME 52 9943
TEST_TIME 53 9860
TEST_TIME 54 9808
TEST_TIME 55 9809
TEST_TIME 56 9848
TEST_TIME 57 9840
TEST_TIME 58 9809
TEST_TIME 59 9806
TEST_TIME 60 9808
TEST_TIME 61 9914
TEST_TIME 62 9974
TEST_TIME 63 10100
TEST_TIME 64 10102
TEST_TIME 65 10103
TEST_TIME 66 10046
TEST_TIME 67 10067
TEST_TIME 68 10144
TEST_TIME 69 10050
TEST_TIME 70 9971
TEST_TIME 71 9971
TEST_TIME 72 9895
TEST_TIME 73 9897
TEST_TIME 74 9828
TEST_TIME 75 9760
TEST_TIME 76 9770
TEST_TIME 77 9688
TEST_TIME 78 9628
TEST_TIME 79 9626
TEST_TIME 80 9647
TEST_TIME 81 9625
TEST_TIME 82 9682
TEST_TIME 83 9663
TEST_TIME 84 9735
TEST_TIME 85 9842
TEST_TIME 86 9852
TEST_TIME 87 9804
TEST_TIME 88 9905
TEST_TIME 89 9876
TEST_TIME 90 9892
TEST_TIME 91 9920
TEST_TIME 92 9875
TEST_TIME 93 9819
TEST_TIME 94 9792
TEST_TIME 95 9774
TEST_TIME 96 9729
TEST_TIME 97 9708
TEST_TIME 98 9670
TEST_TIME 99 9668
TEST_TIME 100 9674
TEST_TIME 101 9669
TEST_TIME 102 9706
TEST_TIME 103 9732
TEST_TIME 104 9722
TEST_TIME 105 9760
TEST_TIME 106 9734
TEST_TIME 107 9770
TEST_TIME 108 9756
TEST_TIME 109 9782
TEST_TIME 110 9786
TEST_TIME 111 9769
TEST_TIME 112 9705
TEST_TIME 113 9715
TEST_TIME 114 9683
TEST_TIME 115 9647
TEST_TIME 116 9616
TEST_TIME 117 9621
TEST_TIME 118 9628
TEST_TIME 119 9578
TEST_TIME 120 9512

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 04-01-2021 16:29:30 to 04-01-2021 16:29:33.

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 1582230 1582230 0 0.00 0 18743 6 0 0
doc_list_biud 1582230 1582230 0 0.00 0 51961 27 0 0
sp_add_invoice_to_stock 5181 5095 86 1.65 33 170880 16761 0 86
sp_cancel_adding_invoice 5865 5865 0 0.00 4 49972 773 0 0
sp_cancel_client_order 1785 1785 0 0.00 4 9723 364 0 0
sp_cancel_customer_reserve 577448 577448 0 0.00 1 51962 57 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 2 7563 89 0 0
sp_cancel_pay_to_supplier 416 416 0 0.00 3 8726 78 0 0
sp_cancel_supplier_invoice 6495 6483 12 0.18 2 43557 789 0 12
sp_cancel_supplier_order 409 409 0 0.00 7 1150363 102909 0 0
sp_cancel_write_off 9279 9279 0 0.00 1 13319 113 0 0
sp_client_order 20291 20291 0 0.00 4 20328 348 0 0
sp_customer_reserve 477739 477739 0 0.00 0 68413 163 0 0
sp_fill_shopping_cart 31098 31098 0 0.00 1 11097 33 0 0
sp_fill_shopping_cart_clo_res 477726 477726 0 0.00 0 14460 12 0 0
sp_get_clo_for_invoice 5082 5082 0 0.00 0 24147 312 0 0
sp_kill_cost_storno 16235 16235 0 0.00 0 7555 56 0 0
sp_kill_qstorno_ret_qs2qd 1171067 1171067 0 0.00 0 50679 31 0 0
sp_kill_qty_storno 616203 616203 0 0.00 0 51961 67 0 0
sp_lock_selected_doc 20729 20729 0 0.00 0 9341 6 0 0
sp_make_cost_storno 27758 27758 0 0.00 0 15403 50 0 0
sp_multiply_rows_for_pdistr 27758 27758 0 0.00 0 6546 32 0 0
sp_multiply_rows_for_qdistr 20291 20291 0 0.00 0 10503 160 0 0
sp_pay_from_customer 6930 6930 0 0.00 4 15251 104 0 0
sp_pay_to_supplier 5894 5894 0 0.00 5 13523 126 0 0
sp_payment_common 12824 12824 0 0.00 1 11545 27 0 0
sp_qd_handle_on_cancel_clo 1785 1785 0 0.00 0 8812 322 0 0
sp_qd_handle_on_invoice_upd_sts 10947 10947 0 0.00 0 20317 336 0 0
sp_qd_handle_on_reserve_upd_sts 9852 9852 0 0.00 0 27947 52 0 0
sp_reserve_write_off 9852 9852 0 0.00 7 27964 165 0 0
sp_supplier_invoice 5459 5459 0 0.00 6 81485 3142 0 0
sp_supplier_order 5356 5356 0 0.00 5 34724 1275 0 0
srv_aggregate_perf_data 92 92 0 0.00 2929 440141 23699 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1378 131570 33468 0 0
srv_find_qd_qs_mism 1092269 1092269 0 0.00 0 18727 5 0 0
srv_make_invnt_saldo 571 571 0 0.00 37 39152 1088 0 0
srv_make_money_saldo 818 818 0 0.00 0 19366 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 204228 603927 344698 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5096 5096 0 0.00 0 20795 166 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 2077 80 0 0
t$perf-norm:sp_cancel_client_order 1785 1785 0 0.00 0 5946 27 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 1301 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1000 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 416 416 0 0.00 0 253 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 1395 21 0 0
t$perf-norm:sp_cancel_supplier_order 409 409 0 0.00 0 20544 1562 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 2580 7 0 0
t$perf-norm:sp_client_order 20291 20291 0 0.00 0 13017 19 0 0
t$perf-norm:sp_customer_reserve 947 947 0 0.00 0 2644 8 0 0
t$perf-norm:sp_pay_from_customer 6930 6930 0 0.00 0 7440 14 0 0
t$perf-norm:sp_pay_to_supplier 5894 5894 0 0.00 0 3499 9 0 0
t$perf-norm:sp_reserve_write_off 9852 9852 0 0.00 0 14378 14 0 0
t$perf-norm:sp_supplier_invoice 5459 5459 0 0.00 0 5419 19 0 0
t$perf-norm:sp_supplier_order 5356 5356 0 0.00 0 7801 19 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 904 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 569 11 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 1899 17 0 0
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 4400 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10336 10164 172 1.66 0 6866 19 0 172
v_all_customers 36756 36756 0 0.00 0 26 1 0 0
v_all_suppliers 30448 30448 0 0.00 0 26 1 0 0
v_all_wares 40582 40582 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 725 7 0 0
v_cancel_client_order 3570 3570 0 0.00 0 6775 7 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 934 4 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 1895 8 0 0
v_cancel_payment_to_supplier 832 832 0 0.00 0 1773 5 0 0
v_cancel_supplier_invoice 790 766 24 3.03 0 1086 18 0 24
v_cancel_supplier_order 818 818 0 0.00 0 562 6 0 0
v_cancel_write_off 2000 2000 0 0.00 0 2162 13 0 0
v_max_id_clo_ord 5355 5355 0 0.00 0 181 1 0 0
v_max_id_clo_res 947 947 0 0.00 0 1395 7 0 0
v_max_id_ord_sup 5451 5451 0 0.00 0 3866 4 0 0
v_max_non_paid_invoice 1476 1476 0 0.00 0 360 3 0 0
v_max_non_paid_realizn 3811 3811 0 0.00 0 1877 4 0 0
v_min_id_clo_ord 5355 5355 0 0.00 0 2705 7 0 0
v_min_id_clo_res 947 947 0 0.00 0 2185 4 0 0
v_min_id_ord_sup 5451 5451 0 0.00 0 4132 5 0 0
v_min_non_paid_invoice 5894 5894 0 0.00 0 11085 21 0 0
v_min_non_paid_realizn 6930 6930 0 0.00 0 5414 12 0 0
v_our_firm 10064 10064 0 0.00 0 26 1 0 0
v_reserve_write_off 19704 19704 0 0.00 0 2666 5 0 0
x_lock_depdocs_on_canc_invoice 11965 11965 0 0.00 0 16492 109 0 0
x_lock_depdocs_on_canc_sup_ord 409 409 0 0.00 0 14634 383 0 0
x_make_qstorno_1000_1200 5356 5356 0 0.00 2 34589 1198 0 0
x_make_qstorno_1200_2000 5459 5459 0 0.00 3 81471 3030 0 0
x_make_qstorno_2100_3300 477739 477739 0 0.00 0 68410 148 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-01-2021 16:29:34 to 04-01-2021 16:29:38.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:20 12112 8192000000 10202851872 10505609216 875289104 9.653 70 55 112 0 897176288 2613600 19273584
13:57:39 41373 8192000000 10343121312 10660560896 1380301504 14.419 100 86 172 0 1413827728 4955520 28570704
13:58:35 44563 8192000000 10401609184 10724888576 1444271200 14.987 100 93 186 0 1482154240 7342080 30540960
13:59:31 24345 8192000000 10411113632 10740932608 1461752656 15.141 100 89 178 0 1499279488 8546192 28980640
14:00:09 24979 8192000000 10444577504 10778628096 1495206208 15.434 100 93 186 0 1535415520 9248176 30961136
14:00:48 23168 8192000000 10460376816 10800623616 1512527360 15.585 100 92 184 0 1551940352 9962208 29450784
14:01:23 18204 8192000000 10491589088 10834456576 1539210720 15.817 100 86 171 1 1576238576 10541680 26486176
14:01:52 12158 8192000000 10498003936 10846838784 1557424752 15.974 100 83 166 0 1594242160 10942400 25875008
14:02:13 15176 8192000000 10528956400 10880040960 1583749744 16.200 100 83 166 0 1620206528 11303648 25153136
14:02:35 10031 8192000000 10542151536 10902310912 1601426512 16.352 100 79 157 1 1635936800 11506592 23003696
14:02:54 11363 8192000000 10571427184 10930102272 1628665808 16.584 100 82 164 1 1665315776 12023088 24626880
14:03:14 11337 8192000000 10582497760 10945646592 1641709424 16.694 100 78 156 0 1676880496 12349312 22821760
14:03:36 10148 8192000000 10602081728 10971906048 1669470800 16.929 100 79 158 3 1704648080 11856528 23320752
14:03:53 6644 8192000000 10629178944 10997010432 1684466496 17.055 100 79 159 0 1720426640 12069424 23890720
14:04:08 7397 8192000000 10639673024 11010625536 1699355840 17.180 100 67 132 1 1731187232 12217200 19614192
14:04:23 5650 8192000000 10655630608 11032289280 1719281616 17.346 100 82 164 0 1756142160 12634240 24226304
14:04:36 6894 8192000000 10667076496 11044798464 1729332896 17.430 100 81 162 1 1766145344 13488832 23323616
14:04:51 6071 8192000000 10682549184 11063246848 1742892192 17.543 100 74 145 1 1775725568 12704896 20128480
14:05:04 5996 8192000000 10698822272 11076808704 1759732176 17.682 100 80 160 2 1795574496 12901984 22940336
14:05:16 4205 8192000000 10701084400 11086876672 1769912672 17.766 100 75 149 0 1803194112 12353168 20928272
14:05:29 3483 8192000000 10724983344 11105722368 1786074736 17.899 100 79 156 3 1818948784 11078832 21795216
14:05:40 9593 8192000000 10726106960 11115188224 1791567648 17.945 100 67 135 1 1822253600 11822320 18863632
14:05:58 3837 8192000000 10743015008 11131133952 1798817584 18.004 100 76 151 0 1831691312 11835904 21037824
14:06:09 2466 8192000000 10750079184 11147190272 1821971648 18.194 100 79 158 1 1857033024 12702528 22358848
14:06:18 3025 8192000000 10770912992 11154288640 1828081680 18.244 100 90 181 0 1866407088 12423728 25901680
14:06:28 2828 8192000000 10770736576 11162525696 1835313968 18.303 100 89 178 2 1873449424 12924512 25210944
14:06:37 2507 8192000000 10781871920 11169808384 1843162000 18.367 100 93 185 0 1883535696 15075552 25298144
14:06:46 2676 8192000000 10790286032 11175927808 1844751200 18.379 100 95 190 0 1887155616 15818496 26585920
14:06:55 2278 8192000000 10795189008 11179655168 1845875952 18.389 100 88 174 1 1885623008 15089232 24657824
14:07:04 2788 8192000000 10794280800 11181547520 1852108208 18.439 100 89 179 1 1892274720 14839296 25327216
14:07:14 1798 8192000000 10801616784 11188826112 1857453776 18.483 100 91 180 0 1895024480 12386608 25184096
14:07:22 1301 8192000000 10802171056 11192139776 1859577056 18.500 100 89 178 0 1899609280 13362192 26670032
14:07:30 1892 8192000000 10793004112 11189878784 1859367744 18.498 100 74 148 3 1892361056 12373200 20620112
14:07:38 3065 8192000000 10798223616 11192983552 1865147616 18.545 100 87 174 1 1902136288 12247744 24740928
14:07:48 2011 8192000000 10812077088 11202351104 1871579088 18.597 100 95 190 1 1911016448 12259104 27178256
14:07:56 3064 8192000000 10809617200 11201613824 1869123664 18.577 100 87 175 0 1907055136 12909600 25021872
14:08:06 5442 8192000000 10814388400 11207618560 1867708016 18.566 100 75 147 3 1900761328 12633632 20419680
14:08:19 1616 8192000000 10817500272 11215548416 1872238944 18.602 100 87 174 0 1915783104 18948224 24595936
14:08:27 13396 8192000000 10790556112 11202592768 1866746176 18.558 100 54 107 0 1892213216 10269728 15197312
14:08:46 12508 8192000000 10775943504 11197878272 1863538624 18.532 100 27 54 1 1876556400 5730832 7286944
14:09:05 5179 8192000000 10785593136 11200884736 1866598544 18.557 100 31 60 2 1881879840 6540352 8740944
14:09:17 5155 8192000000 10773495312 11201183744 1867615232 18.565 100 35 68 1 1885367888 8264752 9487904
14:09:30 4344 8192000000 10783852752 11206582272 1868945232 18.576 100 32 62 2 1884836944 6677232 9214480
14:09:41 7277 8192000000 10772929360 11203706880 1868867664 18.575 100 15 30 1 1879091680 6065824 4158192
14:09:54 5660 8192000000 10771594224 11203567616 1874300304 18.619 100 28 56 1 1887235136 4908176 8026656
14:10:07 6841 8192000000 10782710784 11210088448 1871530096 18.597 100 22 44 1 1884493264 6628368 6334800
14:10:24 10430 8192000000 10772783264 11208982528 1872430016 18.604 100 16 33 0 1883323040 6730496 4162528
14:10:41 6648 8192000000 10799596624 11219693568 1878601824 18.654 100 33 66 2 1894671488 6766080 9303584
14:10:53 10523 8192000000 10787039648 11216711680 1883311216 18.692 100 29 59 1 1897503936 6684496 7508224
14:11:12 10655 8192000000 10784216640 11225440256 1877268864 18.643 100 16 31 1 1895937408 14876352 3792192
14:11:29 76398 8192000000 10792164832 11230601216 1881689936 18.679 100 31 63 1 1899858544 9888544 8280064
14:12:58 3211 8192000000 10813689216 11236081664 1885456448 18.709 100 42 83 3 1906596672 8481344 12658880
14:13:08 9297 8192000000 10811459424 11231424512 1886469264 18.717 100 28 56 1 1901100080 5956768 8674048
14:13:24 5977 8192000000 10809062544 11237859328 1889254304 18.740 100 36 73 0 1906708512 7322256 10131952
14:13:37 8197 8192000000 10795808176 11232718848 1887284240 18.724 100 26 52 1 1900345312 5689952 7371120
14:13:53 3014 8192000000 10818848192 11244736512 1895909952 18.793 100 48 94 0 1918275872 9111424 13254496
14:14:03 10949 8192000000 10810539232 11239178240 1891443072 18.757 100 22 42 1 1904379584 6226512 6710000
14:14:20 4355 8192000000 10815672272 11244482560 1897181440 18.804 100 37 71 3 1915449584 6896256 11371888
14:14:34 5547 8192000000 10811454224 11245682688 1899522432 18.822 100 30 60 3 1913886544 6285952 8078160
14:14:49 3779 8192000000 10823072576 11255328768 1905115120 18.867 100 49 98 1 1927680960 8463712 14102128
14:15:01 2297 8192000000 10817139072 11245088768 1899865296 18.825 100 40 79 3 1917670432 6500688 11304448
14:15:10 5154 8192000000 10824522912 11251453952 1902928544 18.850 100 35 69 2 1919634544 6520272 10185728
14:15:27 6222 8192000000 10811113520 11248017408 1897185744 18.804 100 22 44 2 1909905424 6743984 5975696
14:15:44 9941 8192000000 10810540896 11242680320 1884402624 18.701 99 23 46 0 1897378608 6737408 6238576
14:16:00 70504 8192000000 10782853744 11220959232 1826043760 18.227 96 27 55 0 1839463696 5720816 7699120
14:17:19 8410 8192000000 10794311696 11231576064 1885299216 18.708 100 20 40 1 1897158208 6311376 5547616
14:17:34 5939 8192000000 10805360736 11241885696 1895839920 18.793 100 32 64 2 1911868816 6387936 9640960
14:17:46 3623 8192000000 10801480096 11232325632 1858234704 18.489 98 35 70 0 1874694512 6900496 9559312
14:17:57 4629 8192000000 10791459936 11209187328 1852684992 18.444 99 28 55 0 1867056016 6562768 7808256
14:18:09 4310 8192000000 10750142512 11172917248 1817267648 18.155 98 30 58 0 1833374976 7370816 8736512
14:18:19 5531 8192000000 10748928272 11167612928 1802822128 18.037 98 34 69 1 1820132992 7372224 9938640
14:18:33 8270 8192000000 10752548176 11169841152 1773150896 17.793 96 30 60 4 1787489744 5168224 9170624
14:18:48 5112 8192000000 10737218624 11150839808 1787854128 17.914 98 36 72 1 1804169312 6594448 9720736
14:18:59 6730 8192000000 10721741296 11144757248 1765962096 17.734 97 25 47 0 1778831856 5939696 6930064
14:19:12 5559 8192000000 10718984592 11133313024 1736514864 17.490 95 26 52 0 1749682544 5736080 7431600
14:19:30 5082 8192000000 10726858064 11143798784 1805116608 18.056 100 25 49 4 1818229664 5613216 7499840
14:19:41 4968 8192000000 10712409136 11128696832 1768704384 17.756 98 34 68 2 1785212608 5385312 11122912
14:19:54 8671 8192000000 10744906144 11145940992 1782565120 17.871 98 24 50 2 1794254016 4795136 6893760
14:20:09 8884 8192000000 10689634736 11105611776 1706707168 17.241 94 27 54 2 1720114144 5716736 7690240
14:20:23 67528 8192000000 10688851536 11100282880 1620269664 16.512 90 31 59 1 1634054080 4720352 9064064
14:21:38 12383 8192000000 10712420864 11116404736 1755648624 17.648 97 28 56 1 1769273696 5012752 8612320
14:21:58 7696 8192000000 10723234192 11134349312 1767698624 17.748 98 31 60 2 1782252864 6208208 8346032
14:22:12 7884 8192000000 10749551824 11159994368 1820618208 18.183 100 32 64 1 1839125072 9636272 8870592
14:22:27 6718 8192000000 10742882560 11165089792 1832923872 18.283 100 21 42 0 1844191472 5089056 6178544
14:22:43 9587 8192000000 10749963024 11170316288 1820313392 18.180 99 32 64 1 1834763936 5371584 9078960
14:23:00 9007 8192000000 10727842560 11149123584 1781247856 17.860 97 20 40 2 1797103360 9898896 5956608
14:23:15 7919 8192000000 10754099312 11175456768 1833326848 18.286 100 25 46 4 1845345792 5402128 6616816
14:23:31 7194 8192000000 10740998144 11160711168 1820090256 18.178 99 28 58 0 1834658896 6995312 7573328
14:23:45 11070 8192000000 10758196752 11181453312 1841263360 18.351 100 24 48 1 1853867456 5804992 6799104
14:24:04 5936 8192000000 10773641168 11196346368 1855379264 18.466 100 29 60 1 1870153408 5679824 9094320
14:24:16 11825 8192000000 10780988512 11205955584 1860567824 18.508 100 21 42 0 1872445040 5623088 6254128
14:24:43 11949 8192000000 10783081568 11211767808 1868071664 18.569 100 25 50 1 1881605952 6634528 6899760
14:25:01 8258 8192000000 10794119904 11215212544 1877287184 18.643 100 41 82 1 1896178128 6612448 12278496
14:25:16 67379 8192000000 10780142288 11219877888 1877604752 18.646 100 29 57 1 1891431456 5550672 8276032
14:26:29 9704 8192000000 10787470112 11221954560 1878373232 18.652 100 12 24 1 1887193408 5124352 3695824
14:26:45 6914 8192000000 10799351840 11232759808 1889517920 18.742 100 35 68 2 1905905248 6921504 9465824
14:27:01 5797 8192000000 10821459840 11244699648 1898257296 18.812 100 38 76 0 1916012800 7048976 10706528
14:27:13 6850 8192000000 10839374272 11252834304 1910394736 18.910 100 40 80 2 1927057616 4930464 11732416
14:27:29 50883 8192000000 10859108304 11279101952 1924248480 19.021 100 45 86 0 1943255664 6783584 12223600
14:28:28 20722 8192000000 10867286000 11294314496 1938973936 19.139 100 55 110 3 1963993296 9857696 15161664
14:29:00 19282 8192000000 10870756080 11298680832 1940814736 19.153 100 47 94 2 1963889792 10345424 12729632
14:29:43 23786 8192000000 10887625568 11314458624 1949147328 19.220 100 37 72 1 1971892416 11758304 10986784
14:30:17 12651 8192000000 10889080512 11320389632 1958962736 19.298 100 46 90 1 1986307456 14077120 13267600
14:30:42 22583 8192000000 10903809568 11329261568 1963447520 19.333 100 49 98 1 1992630656 15311088 13872048
14:31:15 14207 8192000000 10906365536 11338334208 1970735904 19.391 100 42 84 0 2002502992 17996640 13770448
14:31:40 28449 8192000000 10920170480 11354644480 1979288352 19.459 100 49 98 3 2015090384 20770224 15031808
14:32:16 59453 8192000000 10916678528 11358597120 1982803280 19.487 100 41 82 2 2016895424 21723104 12369040
14:33:43 21180 8192000000 10931603760 11368058880 1985321584 19.507 100 37 72 4 2019990704 23590176 11078944
14:34:16 11912 8192000000 10943917632 11373424640 1990671760 19.549 100 38 76 1 2028510496 26029024 11809712
14:34:37 7308 8192000000 10951900928 11382431744 1995691584 19.589 100 45 90 2 2036097984 26886224 13520176
14:34:56 3029 8192000000 10951978240 11382480896 1999159472 19.616 100 55 110 3 2043439824 27954000 16326352
14:35:10 7274 8192000000 10962907552 11389657088 2001137984 19.632 100 64 128 1 2051552032 31211824 19202224
14:35:28 3928 8192000000 10968909488 11390242816 2003664512 19.652 100 71 141 0 2054889440 30412032 20812896
14:35:40 5921 8192000000 10946628512 11377041408 1978454000 19.452 99 76 151 1 2032969568 31701568 22814000
14:35:55 2136 8192000000 10950477712 11379937280 1994453632 19.579 100 69 137 2 2046691984 31756848 20481504
14:36:06 8083 8192000000 10969922656 11394228224 2000554736 19.627 100 66 130 1 2054559440 33693424 20311280
14:36:21 3834 8192000000 10972408368 11396894720 2002440128 19.642 100 67 133 0 2058015760 35615840 19959792
14:36:36 14097 8192000000 10965833312 11395579904 1984982176 19.504 99 59 118 1 2038500368 36254672 17263520
14:37:00 12727 8192000000 10974378112 11405758464 2007295744 19.680 100 64 123 1 2063681872 38915520 17470608
14:37:20 3191 8192000000 10981531760 11412996096 2010409808 19.705 100 63 124 1 2067441984 38529232 18502944
14:37:33 1964 8192000000 10982713120 11406024704 2011083664 19.710 100 69 138 1 2067681888 36232432 20365792
14:37:42 4141 8192000000 10989364960 11415621632 2014126272 19.734 100 74 148 1 2073212464 37320000 21766192
14:37:55 4733 8192000000 10997612336 11421929472 2024302752 19.814 100 84 166 0 2085720256 36631152 24786352
14:38:09 6795 8192000000 11005086128 11431133184 2029317968 19.853 100 75 150 4 2090080112 39074352 21687792
14:38:23 5404 8192000000 10984811296 11407826944 2006000832 19.670 99 75 150 2 2067288944 38859024 22429088
14:38:36 3812 8192000000 10998317360 11419250688 2021012608 19.788 100 86 169 0 2085463680 38724672 25726400
14:38:48 3682 8192000000 10993615344 11414269952 2017372528 19.760 100 73 146 1 2079471984 40858240 21241216
14:38:59 8423 8192000000 11005222752 11427590144 2022882464 19.803 100 77 154 1 2092690432 46253008 23554960
14:39:17 3331 8192000000 10996728960 11418918912 2004241360 19.656 99 78 157 0 2071841328 43416016 24183952
14:39:27 6040 8192000000 10992755872 11413450752 2009089936 19.694 100 73 148 1 2074203232 43615408 21497888
14:39:44 4585 8192000000 10995299104 11418443776 2013737696 19.731 100 77 154 0 2082582960 45676816 23168448
14:39:57 2798 8192000000 10995210576 11412721664 2010444736 19.705 100 86 171 2 2082618032 46720656 25452640
14:40:07 6592 8192000000 10993757472 11423260672 2014062416 19.733 100 67 132 4 2082563040 47932448 20568176
14:40:25 8898 8192000000 11007588048 11443290112 2025777600 19.826 100 65 131 0 2097144224 50858704 20507920
14:40:42 8751 8192000000 11011217936 11445301248 2011614608 19.714 99 57 114 1 2078700592 49113888 17972096
14:40:58 9645 8192000000 11000832992 11430297600 2013367040 19.728 99 66 132 1 2088212992 54272656 20573296
14:41:19 2819 8192000000 11015155472 11442647040 2022707552 19.801 100 75 150 0 2099417360 53565424 23144384
14:41:32 4154 8192000000 10992023616 11418542080 2005159936 19.663 100 66 133 0 2079301280 53781168 20360176
14:41:44 2873 8192000000 11013932128 11430813696 2014669248 19.738 100 84 169 0 2095873712 54905616 26298848
14:41:57 4850 8192000000 10976931344 11400548352 1979034208 19.457 99 75 147 2 2062210896 60554080 22622608
14:42:10 6804 8192000000 10950883600 11372728320 1930435952 19.070 96 70 140 1 2010604080 58566560 21601568
14:42:23 2675 8192000000 10982178976 11401293824 1982567184 19.485 100 82 165 2 2068213984 60253968 25392832
14:42:38 2080 8192000000 10997216416 11412054016 1995265968 19.585 100 79 158 1 2076464928 56036016 25162944
14:42:47 3307 8192000000 11014007024 11426832384 2005684320 19.668 100 85 170 1 2090249616 58405440 26159856
14:42:58 3901 8192000000 11008515504 11425382400 2012913344 19.724 100 87 173 1 2098113440 58486960 26713136
14:43:09 2024 8192000000 11017384832 11434614784 2010528128 19.706 100 84 167 0 2095955104 59172720 26254256
14:43:19 2841 8192000000 11033877440 11447902208 2027979104 19.843 100 90 180 2 2115924928 59276768 28669056
14:43:28 2222 8192000000 11035194624 11455791104 2029886048 19.858 100 90 177 2 2116587376 59356832 27344496
14:43:38 1374 8192000000 11024200128 11443027968 2018306432 19.767 100 87 175 1 2105933040 60293344 27333264
14:43:47 4363 8192000000 10990315712 11414368256 1994875552 19.582 100 77 152 0 2073338000 55123216 23339232
14:44:01 2337 8192000000 10965707952 11381452800 1961842400 19.321 99 79 155 3 2041909856 55670960 24396496
14:44:11 8676 8192000000 10963829408 11387572224 1975194176 19.427 100 71 141 1 2050843424 53631376 22017872
14:44:29 5005 8192000000 10960800464 11381706752 1956005536 19.274 99 71 140 0 2032320288 54573104 21741648
14:44:42 5390 8192000000 10961525840 11381936128 1950144272 19.228 99 71 143 0 2025410496 53543840 21722384
14:44:58 2806 8192000000 10941256800 11361062912 1944364640 19.182 99 71 139 0 2021154208 55221296 21568272
14:45:07 3760 8192000000 10945249728 11363856384 1945587824 19.191 99 71 142 0 2024137104 55854752 22694528
14:45:21 5546 8192000000 10957907168 11371945984 1957160016 19.283 100 73 146 0 2034461600 54061456 23240128
14:45:33 4745 8192000000 10952654208 11373441024 1952402416 19.246 100 66 131 1 2029748208 56166752 21179040
14:45:52 11560 8192000000 10939771392 11370545152 1944588032 19.183 99 56 112 3 2018888640 56000832 18299776
14:46:11 9820 8192000000 10925265968 11361501184 1934463632 19.103 99 33 67 1 1998363056 52025264 11874160
14:46:28 4306 8192000000 10929183952 11363131392 1949489728 19.222 100 47 92 2 2018377792 53336016 15552048
14:46:39 8905 8192000000 10928270528 11362291712 1946885680 19.202 100 46 91 3 2009762160 48166304 14710176
14:46:59 2341 8192000000 10953956880 11370098688 1947048784 19.203 99 91 182 1 2027609328 51900336 28660208
14:47:08 14707 8192000000 10911050720 11359961088 1911696560 18.920 98 31 62 0 1973900704 51638896 10565248
14:47:33 9290 8192000000 10911235216 11354918912 1932471296 19.087 99 38 76 0 1993807360 48835760 12500304
14:47:57 22750 8192000000 10906275872 11336359936 1903020704 18.851 98 41 80 3 1959919760 43753264 13145792
14:48:29 14079 8192000000 10918169712 11352100864 1923438016 19.014 99 46 92 0 1988165856 49398736 15329104
14:48:51 13517 8192000000 10906475184 11339714560 1900622816 18.831 98 32 64 0 1960169744 48688912 10858016
14:49:15 18681 8192000000 10930880128 11362078720 1937414096 19.126 100 36 72 2 2009081760 59222656 12445008
14:49:43 2332 8192000000 10943902256 11365474304 1945714832 19.192 100 50 98 3 2016692096 55257392 15719872
14:49:52 4128 8192000000 10952505552 11372490752 1945979168 19.194 100 65 128 1 2026759280 60127344 20652768
14:50:02 16730 8192000000 10921415776 11364716544 1926267920 19.037 99 33 66 2 2001479808 63125184 12086704
14:50:30 20560 8192000000 10904303248 11359342592 1919000864 18.979 99 30 60 1 1990951424 61101472 10849088
14:51:00 26419 8192000000 10894559776 11341762560 1914510448 18.943 99 23 45 1 1963138272 40260448 8367376
14:51:33 14940 8192000000 10914361392 11360100352 1946599392 19.199 100 36 72 0 2003750544 45197536 11953616
14:51:55 24486 8192000000 10899960192 11346079744 1899405536 18.822 98 28 56 0 1958439344 48545056 10488752
14:52:29 23862 8192000000 10900147936 11342618624 1930202416 19.068 100 26 52 1 1983157360 43959056 8995888
14:53:04 27110 8192000000 10888275536 11338739712 1909725232 18.904 99 20 40 0 1958115472 41129104 7261136
14:53:40 19806 8192000000 10859406896 11335569408 1898268768 18.812 99 17 34 0 1940636624 35854288 6513568
14:54:07 41767 8192000000 10858991216 11325370368 1898670096 18.816 99 8 16 1 1928108400 26728912 2709392
14:55:09 32391 8192000000 10844873728 11317796864 1862330384 18.522 97 13 26 1 1901116656 34169456 4616816
14:56:34 43417 8192000000 10861394208 11313016832 1905450816 18.870 99 18 36 1 1926182784 15535344 5196624
14:57:23 46451 8192000000 10861145792 11317223424 1907862976 18.889 99 16 32 0 1927110224 15234688 4012560
14:58:16 66138 8192000000 10857564192 11323412480 1887108528 18.722 97 28 56 0 1906889152 12295408 7485216
14:59:31 64528 8192000000 10873451520 11327541248 1916892720 18.962 99 8 16 0 1929631584 11239344 1499520
15:00:43 113533 8192000000 10882940816 11336560640 1892496576 18.766 97 14 27 0 1911160912 15350384 3313952
15:02:43 109534 8192000000 10895733904 11354492928 1936008976 19.115 99 12 23 1 1953323792 13983920 3330896
15:04:39 99932 8192000000 10915208656 11356209152 1960607136 19.311 100 15 30 0 1971597520 7253440 3736944
15:06:28 109292 8192000000 10892464224 11340050432 1932850032 19.090 98 33 66 0 1953892736 11817808 9224896
15:08:24 60955 8192000000 10901912768 11360792576 1929710576 19.065 98 25 50 0 1947320288 10471696 7138016
15:09:40 46537 8192000000 10909676960 11364081664 1960638480 19.311 99 24 48 3 1980208352 11385216 8184656
15:10:33 28594 8192000000 10918884352 11371036672 1972552464 19.406 100 37 74 0 1996446848 13215792 10678592
15:11:18 44039 8192000000 10887510400 11368505344 1950235504 19.228 99 7 14 1 1963343248 10790208 2317536
15:12:08 52654 8192000000 10916945920 11381420032 1974423504 19.421 100 17 34 0 1994022592 14724816 4874272
15:13:09 81501 8192000000 10909734176 11389800448 1983210272 19.490 100 22 44 2 2006377696 17481760 5685664
15:14:53 53679 8192000000 10899539920 11363299328 1921819648 19.001 97 19 38 0 1933921712 6682784 5419280
15:15:53 68784 8192000000 10867999344 11345793024 1930708096 19.073 98 12 25 0 1942512912 8554128 3250688
15:17:36 52824 8192000000 10860984352 11335548928 1941503072 19.159 99 8 16 0 1950626560 7106832 2016656
15:18:45 17246 8192000000 10881695040 11345039360 1943862400 19.178 99 26 53 0 1958215824 7170880 7182544
15:19:10 45243 8192000000 10897762272 11369205760 1962964272 19.330 100 20 40 1 1978089504 9523696 5601536
15:20:02 57038 8192000000 10880379744 11361005568 1932556336 19.087 98 11 23 0 1946634352 9853184 4224832
15:21:05 41516 8192000000 10882100096 11365277696 1958406240 19.293 100 20 40 1 1978464624 14445472 5612912
15:22:05 27617 8192000000 10881899888 11374686208 1959605328 19.303 100 8 15 0 1976101408 14449520 2046560
15:22:38 56166 8192000000 10899254224 11380789248 1966400208 19.357 100 11 22 1 1985514496 15835104 3279184
15:24:03 51540 8192000000 10890778368 11366699008 1952170816 19.244 99 7 13 0 1965177792 11065856 1941120
15:25:02 19448 8192000000 10896646016 11368607744 1956569168 19.279 99 22 44 1 1973368032 9879136 6919728
15:25:34 46272 8192000000 10932862784 11387908096 1969145344 19.379 99 22 43 0 1987059392 11906656 6007392
15:26:26 51640 8192000000 10914169232 11388334080 1950999648 19.234 98 34 68 1 1978524208 17972064 9552496
15:27:24 62809 8192000000 10920182320 11395616768 1936596240 19.120 98 11 22 1 1960756944 20256864 3903840
15:28:47 53651 8192000000 10904210352 11387092992 1936698544 19.120 98 10 20 0 1959412160 19850640 2862976
15:30:50 41620 8192000000 10913879344 11371634688 1917967360 18.971 97 32 64 0 1940743616 13409184 9367072
15:31:41 79268 8192000000 10902331264 11346821120 1832900208 18.283 93 21 43 0 1849890192 11096416 5893568
15:33:07 16187 8192000000 10896877248 11348987904 1937271328 19.125 99 36 72 3 1954476672 7359952 9845392
15:33:35 34933 8192000000 10886936832 11344805888 1913175808 18.932 98 34 68 1 1934568208 12097856 9294544
15:34:20 18663 8192000000 10871191088 11327778816 1934821824 19.105 99 41 82 1 1955903856 9039840 12042192
15:34:47 82542 8192000000 10865136768 11342143488 1885735248 18.711 97 26 51 2 1905457248 12517408 7204592
15:36:20 101379 8192000000 10861884688 11339886592 1929972656 19.067 99 20 40 1 1945376608 9990672 5413280
15:38:16 105996 8192000000 10882512544 11342655488 1908345056 18.893 97 36 72 0 1927844880 9822880 9676944
15:40:08 44202 8192000000 10857666992 11335114752 1928593408 19.056 99 32 62 2 1945805648 8598464 8613776
15:41:15 86898 8192000000 10868648464 11338702848 1910814560 18.913 98 11 22 1 1924071776 9734000 3523216
15:42:51 72701 8192000000 10826211856 11308265472 1868917360 18.576 96 9 18 1 1880354656 8958176 2479120
15:44:21 80929 8192000000 10839645168 11330641920 1905910928 18.874 99 10 20 0 1922533600 13660784 2961888
15:45:48 60300 8192000000 10847986688 11325968384 1894515040 18.782 98 16 32 1 1913614112 14115872 4983200
15:46:56 38559 8192000000 10817651200 11285561344 1833237008 18.286 95 13 26 0 1845425888 8530368 3658512
15:47:42 30614 8192000000 10828766032 11284029440 1826233104 18.229 95 20 39 1 1840638288 8527296 5877888
15:48:28 40441 8192000000 10871234288 11337392128 1925624832 19.032 100 26 52 2 1946047888 12823824 7599232
15:49:32 80226 8192000000 10870111840 11338129408 1909902976 18.906 98 17 34 1 1930106560 15300672 4902912
15:51:33 81637 8192000000 10879917696 11368669184 1930988576 19.075 99 15 30 0 1953717936 18190496 4538864
15:53:05 74986 8192000000 10913233632 11361697792 1938590368 19.136 99 17 33 1 1956019568 12892208 4536992
15:54:58 40841 8192000000 10881680208 11366469632 1915818016 18.953 98 23 46 1 1936388112 14077168 6492928
15:55:51 71008 8192000000 10894687008 11345227776 1870729184 18.590 96 6 12 0 1882389488 10233648 1426656
15:57:11 9864 8192000000 10919897664 11362123776 1947978848 19.210 99 54 108 2 1974083168 10862304 15242016
15:57:42 52056 8192000000 10924157040 11390869504 1969551408 19.382 100 26 52 1 1992238576 15350560 7336608
15:58:41 131570 8192000000 10907197520 11387535360 1980619456 19.470 100 20 40 0 1996226896 10444656 5162784
16:01:06 39741 8192000000 10893191808 11377508352 1979964800 19.464 100 30 60 1 1996453152 8108272 8380080
16:01:58 26125 8192000000 10908063216 11386408960 1986690080 19.518 100 16 32 0 1998277152 7185728 4401344
16:03:53 83499 8192000000 10899623584 11389718528 1965560016 19.350 99 5 10 0 1974938448 7976704 1401728
16:05:23 43328 8192000000 10913061440 11389558784 1971095168 19.394 99 27 54 1 1987904096 8619200 8189728
16:06:38 58322 8192000000 10896728912 11378896896 1908733696 18.896 96 10 20 1 1923588128 11909104 2945328
16:07:43 86077 8192000000 10911438288 11396599808 1967490832 19.366 99 21 43 0 1984464336 11287120 5686384
16:09:28 75203 8192000000 10921247968 11399098368 1973115440 19.410 99 11 22 0 1992367056 16320144 2931472
16:10:49 68632 8192000000 10930619360 11411255296 1993799296 19.574 100 12 24 0 2009218816 12201008 3218512
16:12:05 44398 8192000000 10921822672 11407904768 1997977824 19.607 100 28 55 4 2016624112 10600224 8046064
16:13:01 56100 8192000000 10951207536 11409129472 1965299152 19.348 98 42 84 1 1990372032 13562400 11510480
16:14:10 62887 8192000000 10927610784 11393597440 1940456016 19.150 97 14 28 0 1954748384 10988272 3304096
16:15:22 37774 8192000000 10924294768 11374706688 1897640352 18.807 95 38 76 0 1917681792 9659568 10381872
16:16:06 20795 8192000000 10918142032 11374104576 1938924496 19.138 98 42 84 1 1965270576 14999392 11346688
16:16:36 10525 8192000000 10908371264 11366686720 1937925712 19.130 98 49 98 2 1964696816 12336240 14434864
16:16:53 110056 8192000000 10879496688 11371241472 1912739760 18.929 97 23 45 0 1931585392 12313312 6532320
16:19:05 93742 8192000000 10871480560 11360010240 1904679200 18.864 97 19 38 0 1917757520 7384960 5693360
16:21:07 15399 8192000000 10882519424 11361406976 1938644928 19.136 99 22 44 1 1961896992 16646144 6605920
16:21:29 20253 8192000000 10875215632 11366014976 1951035824 19.235 100 5 10 0 1969328992 17093632 1199536
16:22:06 64447 8192000000 10862021344 11346030592 1936448160 19.118 100 13 26 0 1948927584 8920384 3559040
16:23:16 116837 8192000000 10854956848 11344449536 1897307952 18.805 97 9 18 1 1909605008 9741408 2555648
16:25:20 93855 8192000000 10860980976 11340226560 1871607392 18.597 96 16 33 0 1886778768 10881328 4290048
16:27:01 21058 8192000000 9701728992 10047938560 838155696 9.281 44 3 6 0 849104144 10362608 585840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-01-2021 16:29:40 to 04-01-2021 16:30:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-01-2021 16:30:12 to 04-01-2021 16:30:14.

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          238683
MON$OLDEST_ACTIVE               239216
MON$OLDEST_SNAPSHOT             239216
MON$NEXT_TRANSACTION            239216
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                       2040992
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:334: 
:335: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:336:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:337: 
:338: 
:339: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:340:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:341: 
:342: 
:343: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:344:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:345: 
:346: 
:347: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:348:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:349: 
:350: 
:351: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:352:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:353: 
:354: 
:355: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:356:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:357: 
:358: 
:359: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:360:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:361: 
:362: 
:363: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:364:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:365: 
:366: 
:367: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:368:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:369: 
:370: 
:371: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:372:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:373: 
:374: 
:375: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:376:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:377: 
:378: 
:379: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:380:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:381: 
:382: 
:383: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:384:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:385: 
:386: 
:387: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:388:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:389: 
:390: 
:391: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:392:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:393: 
:394: 
:395: mscs-test-161.budzdorov.ru    Mon Jan  4 16:27:33 2021
:396:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:397: 
--- end of diff output ---

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

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