Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 24.02.2021 16:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16763576 kB
MemAvailable 31084972 kB
Buffers 0 kB
Cached 14901188 kB
SwapCached 3860 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-02-24 16:27:18
DTS_END                         2021-02-24 16:27:18.3040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/33806
TRN_ID                          244760
ATT_ID                          732
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: 9450.12 16621 1134014
customer order: creation 176.58 354 21189
customer order: refuse 15.04 365 1805
order to supplier: creation 46.98 1359 5638
order to supplier: removal 3.71 91620 445
invoice (draft): creation 47.27 3204 5672
invoice (draft): removal 54.39 657 6527
invoice accept: apply 42.74 18528 5129
invoice accept: cancel 48.70 729 5844
customer reserve: creation 3902.46 186 468295
customer reserve: removal 4808.55 56 577026
realization accept: apply 84.54 198 10145
realization accept: cancel 84.57 103 10148
payment from customer: creation 61.70 123 7404
payment from customer: removal 5.97 104 716
payment to supplier: creation 50.94 132 6113
payment to supplier: removal 3.72 109 446
service: total inventory turnovers 4.91 1070 589
service: total monetary turnovers 6.53 26 783
service: aggregate perf. data 0.80 20805 96
service: refresh index statistics 0.03 192683 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 24-02-2021 16:28:03 to 24-02-2021 16:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3502
TEST_TIME 2 6728
TEST_TIME 3 6383
TEST_TIME 4 5764
TEST_TIME 5 5783
TEST_TIME 6 6068
TEST_TIME 7 5940
TEST_TIME 8 5889
TEST_TIME 9 6147
TEST_TIME 10 5985
TEST_TIME 11 5835
TEST_TIME 12 5977
TEST_TIME 13 6144
TEST_TIME 14 6255
TEST_TIME 15 6422
TEST_TIME 16 6740
TEST_TIME 17 7008
TEST_TIME 18 6949
TEST_TIME 19 7671
TEST_TIME 20 8261
TEST_TIME 21 8642
TEST_TIME 22 8701
TEST_TIME 23 8817
TEST_TIME 24 9079
TEST_TIME 25 9646
TEST_TIME 26 9571
TEST_TIME 27 9901
TEST_TIME 28 10314
TEST_TIME 29 10469
TEST_TIME 30 10383
TEST_TIME 31 10227
TEST_TIME 32 10110
TEST_TIME 33 10045
TEST_TIME 34 9936
TEST_TIME 35 9802
TEST_TIME 36 10230
TEST_TIME 37 10272
TEST_TIME 38 10280
TEST_TIME 39 10131
TEST_TIME 40 10218
TEST_TIME 41 10026
TEST_TIME 42 9850
TEST_TIME 43 9948
TEST_TIME 44 9946
TEST_TIME 45 9807
TEST_TIME 46 9795
TEST_TIME 47 9770
TEST_TIME 48 9821
TEST_TIME 49 9721
TEST_TIME 50 9638
TEST_TIME 51 9570
TEST_TIME 52 9591
TEST_TIME 53 9475
TEST_TIME 54 9554
TEST_TIME 55 9633
TEST_TIME 56 9636
TEST_TIME 57 9677
TEST_TIME 58 9672
TEST_TIME 59 9772
TEST_TIME 60 9724
TEST_TIME 61 9920
TEST_TIME 62 9863
TEST_TIME 63 9866
TEST_TIME 64 10015
TEST_TIME 65 10026
TEST_TIME 66 10030
TEST_TIME 67 10018
TEST_TIME 68 9969
TEST_TIME 69 10039
TEST_TIME 70 10008
TEST_TIME 71 9948
TEST_TIME 72 9902
TEST_TIME 73 9874
TEST_TIME 74 9802
TEST_TIME 75 9732
TEST_TIME 76 9706
TEST_TIME 77 9681
TEST_TIME 78 9676
TEST_TIME 79 9675
TEST_TIME 80 9622
TEST_TIME 81 9632
TEST_TIME 82 9622
TEST_TIME 83 9614
TEST_TIME 84 9599
TEST_TIME 85 9566
TEST_TIME 86 9577
TEST_TIME 87 9596
TEST_TIME 88 9610
TEST_TIME 89 9568
TEST_TIME 90 9606
TEST_TIME 91 9625
TEST_TIME 92 9593
TEST_TIME 93 9608
TEST_TIME 94 9640
TEST_TIME 95 9636
TEST_TIME 96 9659
TEST_TIME 97 9700
TEST_TIME 98 9737
TEST_TIME 99 9648
TEST_TIME 100 9585
TEST_TIME 101 9533
TEST_TIME 102 9550
TEST_TIME 103 9545
TEST_TIME 104 9576
TEST_TIME 105 9538
TEST_TIME 106 9528
TEST_TIME 107 9507
TEST_TIME 108 9463
TEST_TIME 109 9467
TEST_TIME 110 9432
TEST_TIME 111 9432
TEST_TIME 112 9402
TEST_TIME 113 9377
TEST_TIME 114 9386
TEST_TIME 115 9354
TEST_TIME 116 9387
TEST_TIME 117 9417
TEST_TIME 118 9404
TEST_TIME 119 9520
TEST_TIME 120 9451

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 24-02-2021 16:28:07 to 24-02-2021 16:28:10.

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 1569108 1569108 0 0.00 0 40544 6 0 0
doc_list_biud 1569105 1569105 0 0.00 0 26029 26 0 0
sp_add_invoice_to_stock 5278 5129 149 2.82 46 195486 18529 0 149
sp_cancel_adding_invoice 5844 5844 0 0.00 5 64644 729 0 0
sp_cancel_client_order 1805 1805 0 0.00 4 21240 366 0 0
sp_cancel_customer_reserve 577026 577026 0 0.00 1 27993 56 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 3 9577 105 0 0
sp_cancel_pay_to_supplier 446 446 0 0.00 3 10165 109 0 0
sp_cancel_supplier_invoice 6541 6527 14 0.21 1 25232 657 0 14
sp_cancel_supplier_order 445 445 0 0.00 6 1056517 91621 0 0
sp_cancel_write_off 10148 10148 0 0.00 1 11022 104 0 0
sp_client_order 21189 21189 0 0.00 3 39834 354 0 0
sp_customer_reserve 468295 468295 0 0.00 0 173396 187 0 0
sp_fill_shopping_cart 32488 32488 0 0.00 1 17722 37 0 0
sp_fill_shopping_cart_clo_res 468292 468292 0 0.00 0 14401 13 0 0
sp_get_clo_for_invoice 5126 5126 0 0.00 0 15230 236 0 0
sp_kill_cost_storno 17154 17154 0 0.00 0 9560 50 0 0
sp_kill_qstorno_ret_qs2qd 1171172 1171172 0 0.00 0 25215 30 0 0
sp_kill_qty_storno 617064 617064 0 0.00 0 26027 65 0 0
sp_lock_selected_doc 21241 21241 0 0.00 0 10662 6 0 0
sp_make_cost_storno 28788 28788 0 0.00 0 17414 61 0 0
sp_multiply_rows_for_pdistr 28787 28787 0 0.00 0 7479 30 0 0
sp_multiply_rows_for_qdistr 21189 21189 0 0.00 0 11636 135 0 0
sp_pay_from_customer 7404 7404 0 0.00 4 14527 123 0 0
sp_pay_to_supplier 6113 6113 0 0.00 4 12228 133 0 0
sp_payment_common 13516 13516 0 0.00 1 10078 33 0 0
sp_qd_handle_on_cancel_clo 1805 1805 0 0.00 0 21234 322 0 0
sp_qd_handle_on_invoice_upd_sts 10968 10968 0 0.00 0 26027 333 0 0
sp_qd_handle_on_reserve_upd_sts 10145 10145 0 0.00 0 14587 64 0 0
sp_reserve_write_off 10145 10145 0 0.00 7 18843 199 0 0
sp_supplier_invoice 5672 5672 0 0.00 6 136803 3205 0 0
sp_supplier_order 5638 5638 0 0.00 5 46347 1359 0 0
srv_aggregate_perf_data 96 96 0 0.00 3001 296342 20805 0 0
srv_fill_mon_cache_memory 170 170 0 0.00 831 187428 29329 0 0
srv_find_qd_qs_mism 1085753 1085753 0 0.00 0 40543 6 0 0
srv_make_invnt_saldo 589 589 0 0.00 32 39891 1071 0 0
srv_make_money_saldo 783 783 0 0.00 1 2826 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 153502 245496 192684 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5129 5129 0 0.00 0 40622 201 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 1 3385 102 0 0
t$perf-norm:sp_cancel_client_order 1805 1805 0 0.00 0 3592 11 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 27865 63 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 11184 28 0 0
t$perf-norm:sp_cancel_pay_to_supplier 446 446 0 0.00 0 595 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 3636 20 0 0
t$perf-norm:sp_cancel_supplier_order 445 445 0 0.00 0 40800 1582 0 0
t$perf-norm:sp_cancel_write_off 1039 1039 0 0.00 0 3745 11 0 0
t$perf-norm:sp_client_order 21189 21189 0 0.00 0 10946 17 0 0
t$perf-norm:sp_customer_reserve 1007 1007 0 0.00 0 3513 9 0 0
t$perf-norm:sp_pay_from_customer 7404 7404 0 0.00 0 7724 14 0 0
t$perf-norm:sp_pay_to_supplier 6113 6113 0 0.00 0 10280 12 0 0
t$perf-norm:sp_reserve_write_off 10145 10145 0 0.00 0 36249 15 0 0
t$perf-norm:sp_supplier_invoice 5672 5672 0 0.00 0 5040 19 0 0
t$perf-norm:sp_supplier_order 5638 5638 0 0.00 0 12240 23 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 454 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 170 170 0 0.00 0 79 2 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 2005 23 0 0
t$perf-norm:srv_make_money_saldo 783 783 0 0.00 0 1652 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10542 10244 298 2.82 0 8276 20 0 298
v_all_customers 38840 38840 0 0.00 0 17 1 0 0
v_all_suppliers 31242 31242 0 0.00 0 20 1 0 0
v_all_wares 42374 42374 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 2440 12 0 0
v_cancel_client_order 3610 3610 0 0.00 0 3287 7 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 4419 11 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 1551 7 0 0
v_cancel_payment_to_supplier 892 892 0 0.00 0 1776 8 0 0
v_cancel_supplier_invoice 890 862 28 3.14 0 5451 28 0 28
v_cancel_supplier_order 890 890 0 0.00 0 279 3 0 0
v_cancel_write_off 2078 2078 0 0.00 0 4426 19 0 0
v_max_id_clo_ord 5633 5633 0 0.00 0 743 2 0 0
v_max_id_clo_res 1007 1007 0 0.00 0 3045 13 0 0
v_max_id_ord_sup 5667 5667 0 0.00 0 8355 4 0 0
v_max_non_paid_invoice 1792 1792 0 0.00 0 3788 5 0 0
v_max_non_paid_realizn 3916 3916 0 0.00 0 1241 3 0 0
v_min_id_clo_ord 5633 5633 0 0.00 0 3665 9 0 0
v_min_id_clo_res 1007 1007 0 0.00 0 6039 14 0 0
v_min_id_ord_sup 5667 5667 0 0.00 0 6531 5 0 0
v_min_non_paid_invoice 6113 6113 0 0.00 0 7096 23 0 0
v_min_non_paid_realizn 7403 7403 0 0.00 0 6656 22 0 0
v_our_firm 10508 10508 0 0.00 0 20 1 0 0
v_reserve_write_off 20288 20288 0 0.00 0 7505 8 0 0
x_lock_depdocs_on_canc_invoice 11940 11940 0 0.00 0 21127 125 0 0
x_lock_depdocs_on_canc_sup_ord 445 445 0 0.00 0 6992 324 0 0
x_make_qstorno_1000_1200 5638 5638 0 0.00 2 46338 1273 0 0
x_make_qstorno_1200_2000 5672 5672 0 0.00 3 130209 3079 0 0
x_make_qstorno_2100_3300 468295 468295 0 0.00 0 173394 171 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 24-02-2021 16:28:11 to 24-02-2021 16:28:16.

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:22 14 8192000000 8803274720 8815218688 6918096 0.084 2 1 2 0 7037472 56816 62560
13:57:28 7503 8192000000 10171851296 10474299392 854365184 9.444 68 54 109 1 874932240 2370128 18196928
13:57:43 32457 8192000000 10353539952 10670497792 1386542224 14.475 100 82 164 0 1418373552 4819680 27011648
13:58:25 43836 8192000000 10383992928 10710384640 1437640192 14.929 100 89 178 0 1473243984 6817456 28786336
13:59:19 26586 8192000000 10420442096 10747764736 1470134320 15.215 100 89 179 0 1506546640 7778272 28634048
13:59:56 24049 8192000000 10439145552 10767941632 1489691376 15.386 100 86 172 0 1525274576 8286016 27297184
14:00:28 24735 8192000000 10463920624 10798792704 1509129360 15.556 100 92 183 1 1547600640 9203360 29267920
14:01:04 18956 8192000000 10490624352 10829733888 1527974160 15.719 100 81 162 0 1563118688 9871856 25272672
14:01:32 8368 8192000000 10511746752 10853056512 1560732784 16.003 100 89 179 0 1598586688 10684960 27168944
14:01:53 21124 8192000000 10529924352 10877714432 1576895904 16.142 100 87 174 0 1619599392 16101136 26602352
14:02:31 15081 8192000000 10543870864 10897346560 1603320992 16.368 100 80 160 0 1638529952 11149136 24059824
14:02:56 11783 8192000000 10566736416 10924953600 1619657648 16.507 100 82 164 0 1656395792 11850512 24887632
14:03:15 9885 8192000000 10598568656 10958102528 1655070720 16.807 100 82 164 1 1691710928 12409200 24231008
14:03:34 9116 8192000000 10622778784 10984308736 1673019008 16.959 100 83 167 1 1710511424 12841840 24650576
14:03:49 8595 8192000000 10629009968 10997055488 1688876384 17.092 100 82 162 0 1724939008 12546768 23515856
14:04:05 7266 8192000000 10643475024 11013795840 1702382336 17.205 100 80 157 3 1737239264 12069232 22787696
14:04:20 8149 8192000000 10668632960 11037663232 1725737680 17.400 100 84 167 0 1762302608 12102208 24462720
14:04:35 6824 8192000000 10675045968 11048361984 1735003584 17.477 100 84 168 1 1772375680 13303504 24068592
14:04:49 4893 8192000000 10689634864 11062558720 1742142912 17.536 100 76 152 0 1776633264 12693648 21796704
14:05:01 5167 8192000000 10695485824 11069251584 1751231136 17.612 100 81 162 1 1787363184 13367056 22764992
14:05:13 6579 8192000000 10695293280 11072589824 1756137328 17.652 100 75 150 1 1789268816 12580624 20550864
14:05:26 4392 8192000000 10709995664 11085905920 1768894016 17.758 100 86 171 3 1806819104 14166576 23758512
14:05:38 2853 8192000000 10715493520 11089362944 1772424368 17.787 100 87 173 1 1809939328 14342208 23172752
14:05:48 2739 8192000000 10730304608 11104337920 1787939456 17.915 100 90 179 2 1826164704 13545216 24680032
14:05:58 3566 8192000000 10727507904 11110948864 1795067728 17.973 100 91 183 2 1834073328 12953760 26051840
14:06:08 2948 8192000000 10743365344 11123060736 1801112352 18.023 100 85 165 1 1837015856 12472928 23430576
14:06:17 2221 8192000000 10751650816 11131863040 1808802496 18.086 100 90 183 0 1847374832 12920432 25651904
14:06:27 9037 8192000000 10746086080 11139465216 1822517168 18.198 100 83 166 1 1858043344 12942560 22583616
14:06:45 3072 8192000000 10772013168 11157913600 1821792320 18.192 100 89 179 2 1860767920 14406496 24569104
14:06:55 2613 8192000000 10779752496 11164143616 1837672288 18.322 100 88 176 2 1878151936 14630864 25848784
14:07:04 2134 8192000000 10782494240 11167531008 1840717664 18.347 100 85 167 1 1877353520 13229168 23406688
14:07:12 1993 8192000000 10789015072 11173462016 1845848768 18.388 100 89 176 3 1882762960 12310592 24603600
14:07:20 1588 8192000000 10790199072 11172233216 1849069136 18.415 100 91 184 0 1886602608 12030064 25503408
14:07:28 1968 8192000000 10796748752 11182534656 1850327968 18.425 100 88 172 0 1888618480 14015760 24274752
14:07:37 2045 8192000000 10801034944 11190194176 1859321056 18.498 100 93 186 0 1900641184 14265744 27054384
14:07:45 1272 8192000000 10808565104 11196346368 1865285040 18.546 100 90 180 3 1904248736 13655664 25308032
14:07:53 1506 8192000000 10812817056 11198787584 1865065808 18.544 100 96 194 0 1907253392 15306112 26881472
14:08:00 1700 8192000000 10808568288 11196297216 1865646960 18.549 100 89 177 1 1903778032 12620624 25510448
14:08:08 1543 8192000000 10821527136 11206004736 1869275680 18.578 100 96 192 1 1910708400 12899024 28533696
14:08:16 2887 8192000000 10800849952 11199930368 1871528320 18.597 100 77 155 0 1905905888 12404800 21972768
14:08:26 28970 8192000000 10802409984 11200741376 1865766368 18.550 100 43 84 0 1886850688 8498656 12585664
14:09:04 13451 8192000000 10785612512 11204833280 1869068768 18.577 100 34 67 0 1885807632 7688240 9050624
14:09:25 6701 8192000000 10790228896 11205836800 1870092880 18.585 100 34 68 0 1886355584 7082048 9180656
14:09:40 6078 8192000000 10781534848 11206877184 1868663344 18.573 100 24 48 2 1881731904 6395488 6673072
14:09:56 7933 8192000000 10797519056 11220721664 1881250720 18.675 100 33 66 1 1898777616 7911344 9615552
14:10:14 6059 8192000000 10799522240 11225440256 1885630272 18.711 100 20 40 2 1896620016 5521776 5467968
14:10:26 13884 8192000000 10796210032 11230978048 1888709456 18.735 100 20 40 2 1904233456 10486944 5037056
14:10:47 11458 8192000000 10795421152 11229990912 1892388144 18.765 100 21 42 1 1904494752 6397152 5709456
14:11:05 10257 8192000000 10808592416 11243020288 1895184336 18.788 100 20 40 0 1910789072 10160880 5443856
14:11:23 8550 8192000000 10807294960 11241287680 1897333760 18.805 100 15 30 0 1912116080 10705024 4077296
14:11:42 8276 8192000000 10806826496 11244322816 1897737504 18.808 100 13 26 0 1907726912 5857760 4131648
14:11:56 7021 8192000000 10813831504 11247845376 1901532272 18.839 100 25 49 2 1915776064 7362784 6881008
14:12:10 8090 8192000000 10823365840 11250585600 1903701184 18.856 100 28 56 1 1919102304 7627904 7773216
14:12:27 57461 8192000000 10833189904 11252523008 1906303104 18.877 100 34 66 4 1921965808 6169216 9493488
14:13:31 28720 8192000000 10816066896 11256549376 1906412848 18.878 100 25 50 3 1919848416 6389760 7045808
14:14:06 8724 8192000000 10823719952 11258470400 1909092208 18.899 100 26 52 0 1922319104 6109568 7117328
14:14:27 6955 8192000000 10822022752 11262332928 1912290752 18.925 100 28 56 0 1930604304 10305840 8007712
14:14:43 3459 8192000000 10838541792 11265499136 1914802688 18.945 100 31 60 1 1931371376 6934432 9634256
14:14:55 6837 8192000000 10826573296 11264446464 1915677232 18.952 100 27 54 1 1929639392 6136720 7825440
14:15:10 3605 8192000000 10835154624 11266908160 1913940816 18.938 100 21 42 0 1926401024 6745376 5714832
14:15:23 9640 8192000000 10827076992 11265183744 1910013328 18.907 100 17 34 2 1924713968 10249616 4451024
14:15:47 9500 8192000000 10822480720 11265978368 1916485952 18.959 100 24 48 2 1928087936 5293984 6308000
14:16:03 7200 8192000000 10819993584 11253604352 1887633904 18.727 99 25 51 0 1901634304 6078480 7921920
14:16:18 6773 8192000000 10804473296 11239940096 1879562512 18.662 99 23 46 2 1892057024 5801008 6693504
14:16:35 8644 8192000000 10805479984 11245215744 1880725744 18.671 99 11 21 1 1888883856 5217968 2940144
14:16:52 8651 8192000000 10806985552 11246538752 1880642400 18.670 99 13 26 1 1890236320 6096384 3497536
14:17:07 13936 8192000000 10780992656 11217797120 1799155104 18.007 95 8 16 0 1806135056 4712384 2267568
14:17:27 17804 8192000000 10765742704 11173838848 1717771328 17.334 92 17 34 0 1728212256 4962016 5478912
14:18:35 28651 8192000000 10765043104 11186823168 1773914592 17.799 96 36 71 1 1790529136 5462208 11152336
14:19:10 8890 8192000000 10718755232 11146772480 1767006656 17.742 97 19 38 1 1778977312 6353904 5616752
14:19:26 5568 8192000000 10715502752 11131473920 1756598784 17.656 96 40 80 2 1774782992 6567952 11616256
14:19:38 5672 8192000000 10730978032 11146043392 1796500528 17.985 99 27 52 1 1810406048 5495584 8409936
14:19:51 5722 8192000000 10714613216 11133550592 1783507776 17.878 98 20 40 2 1794225248 5350336 5367136
14:20:03 7446 8192000000 10681356160 11084275712 1707967120 17.252 94 23 46 0 1719618912 4911344 6740448
14:20:17 9558 8192000000 10695784656 11109568512 1735272416 17.479 97 17 34 1 1750727600 9781248 5673936
14:20:40 11423 8192000000 10686115840 11099893760 1728300432 17.421 96 26 52 2 1741122560 5513728 7308400
14:20:59 7826 8192000000 10716202960 11131695104 1761542000 17.697 98 21 42 2 1777234992 9666272 6026720
14:21:13 4959 8192000000 10688785408 11105738752 1736191120 17.487 97 27 54 0 1749515264 5481904 7842240
14:21:26 7731 8192000000 10698492912 11107094528 1749250112 17.595 98 30 60 0 1763313600 5408704 8654784
14:21:42 11346 8192000000 10702320192 11120128000 1775531808 17.813 99 35 70 2 1795821216 9708864 10580544
14:22:00 19801 8192000000 10707747728 11121889280 1767946384 17.750 98 22 44 1 1779619232 5658432 6014416
14:22:26 60347 8192000000 10721364784 11138469888 1793014816 17.957 99 32 62 2 1807907328 5691728 9200784
14:23:38 18075 8192000000 10737364176 11164282880 1826915184 18.234 100 25 50 1 1840082672 6040800 7126688
14:24:02 11822 8192000000 10754179120 11176374272 1838090944 18.325 100 25 50 2 1851890784 6844784 6955056
14:24:22 8632 8192000000 10768633664 11191013376 1843325216 18.368 100 27 54 2 1856341616 4876016 8140384
14:24:37 6729 8192000000 10775198016 11196358656 1851684496 18.436 100 29 59 2 1867148240 7269008 8194736
14:24:50 6618 8192000000 10766060048 11191427072 1853371376 18.450 100 24 49 0 1866008272 5580768 7056128
14:25:06 8402 8192000000 10776188928 11200819200 1856095088 18.472 100 18 36 2 1867153120 5774560 5283472
14:25:21 13996 8192000000 10765400688 11202039808 1859754592 18.501 100 22 39 5 1872016064 5881296 6380176
14:25:41 14227 8192000000 10771068320 11202990080 1861181568 18.513 100 18 36 0 1873143552 6618048 5343936
14:26:02 10036 8192000000 10777454880 11208081408 1864151392 18.537 100 17 34 0 1874574400 5213568 5209440
14:26:18 12116 8192000000 10788053216 11215568896 1869173952 18.578 100 28 56 1 1883083856 5178112 8731792
14:26:44 6437 8192000000 10797203968 11223031808 1873764272 18.615 100 29 58 4 1887201216 5285248 8151696
14:26:58 13697 8192000000 10796473792 11228721152 1883203168 18.691 100 15 30 1 1892200080 4435776 4561136
14:27:19 6345 8192000000 10844246192 11252088832 1906335344 18.877 100 42 85 1 1923779184 5369568 12074272
14:27:33 1303 8192000000 10850258800 11260981248 1916034288 18.955 100 60 116 0 1938290080 6973264 15282528
14:27:44 7612 8192000000 10863353376 11274412032 1919523440 18.983 100 65 128 2 1947127376 9274704 18329232
14:28:00 13588 8192000000 10857252128 11274412032 1921089424 18.996 100 61 122 3 1947424656 9999744 16335488
14:28:53 19488 8192000000 10873588144 11288473600 1927803344 19.049 100 67 131 2 1956519600 10800320 17915936
14:29:20 2185 8192000000 10872732528 11288006656 1930502400 19.071 100 67 132 0 1960719712 11209120 19008192
14:29:30 3326 8192000000 10871129088 11286675456 1932972224 19.091 100 58 117 1 1962820672 14061312 15787136
14:29:41 12850 8192000000 10862533408 11295010816 1936373632 19.118 100 53 106 0 1960913216 9287296 15252288
14:30:06 9781 8192000000 10869668592 11292205056 1935571328 19.111 100 53 106 2 1959724048 8602992 15549728
14:30:22 5756 8192000000 10876805872 11303153664 1943824432 19.177 100 54 106 2 1970017344 9848752 16344160
14:30:37 6349 8192000000 10893498720 11309838336 1951531744 19.239 100 66 133 1 1984054368 11294768 21227856
14:30:53 9263 8192000000 10885979440 11311607808 1950560624 19.231 100 53 104 1 1975508960 10310416 14637920
14:31:10 46699 8192000000 10898442736 11328163840 1964844672 19.345 100 63 125 1 1994944688 12517120 17582896
14:32:12 12328 8192000000 10888925824 11328610304 1962112640 19.323 100 48 96 0 1988197184 12245888 13838656
14:32:36 5766 8192000000 10894247104 11331330048 1966942720 19.361 100 53 106 1 1995338800 11940608 16455472
14:32:51 12126 8192000000 10900985184 11335532544 1967544496 19.366 100 48 94 0 1992520128 11298944 13676688
14:33:14 13695 8192000000 10889939264 11328307200 1961478464 19.318 100 34 66 1 1981944368 10457168 10008736
14:33:38 12270 8192000000 10871295856 11307380736 1907081392 18.883 97 42 84 1 1931624032 11604496 12938144
14:33:58 13244 8192000000 10885265424 11317583872 1951895424 19.242 100 40 80 1 1973140848 9477904 11767520
14:34:21 20629 8192000000 10903360848 11333382144 1965648128 19.351 100 60 119 2 1993793280 10864752 17280400
14:34:51 16665 8192000000 10910191648 11340079104 1952808800 19.249 99 43 84 0 1978113792 13427280 11877712
14:35:16 31412 8192000000 10916144768 11355029504 1985343328 19.507 100 47 94 2 2016183520 15844224 14995968
14:35:58 7938 8192000000 10916382576 11352346624 1980397120 19.468 100 51 102 1 2012049440 16283824 15368496
14:36:17 10710 8192000000 10927000928 11353985024 1978147440 19.450 100 63 124 2 2012383392 15917984 18317968
14:36:37 5761 8192000000 10928369632 11361026048 1986209792 19.514 100 55 108 2 2019237904 16847856 16180256
14:36:56 18793 8192000000 10903872384 11332521984 1950070000 19.227 98 58 107 3 1983175040 17491376 15613664
14:37:22 30703 8192000000 10919573936 11353280512 1961822096 19.321 99 48 95 0 1994339264 18385648 14131520
14:38:08 9176 8192000000 10920914880 11352735744 1960653872 19.311 99 45 89 1 1993957456 19296128 14007456
14:38:24 11939 8192000000 10913292912 11351126016 1967403808 19.365 100 47 95 1 2002768208 20653568 14710832
14:38:54 7489 8192000000 10934886240 11366621184 1984353680 19.499 100 46 92 2 2018048720 20207584 13487456
14:39:11 5985 8192000000 10946866464 11374915584 1992944544 19.567 100 55 110 0 2030854480 21099104 16810832
14:39:24 4557 8192000000 10925369584 11352088576 1955558400 19.271 98 57 113 1 1994467456 21569952 17339104
14:39:39 8709 8192000000 10925961824 11358380032 1979749088 19.463 100 54 107 1 2016825904 20647024 16429792
14:39:56 7207 8192000000 10931675360 11360657408 1968651296 19.375 99 60 120 1 2007855248 21369632 17834320
14:40:17 7262 8192000000 10932999344 11361742848 1979164608 19.458 100 52 102 4 2016672768 21816800 15691360
14:40:33 1291 8192000000 10962617760 11375210496 1994396416 19.579 100 88 176 1 2045099392 23284064 27418912
14:40:40 2506 8192000000 10939101952 11367337984 1984900608 19.503 100 80 160 3 2032819872 23329360 24589904
14:40:50 3662 8192000000 10939838144 11358367744 1976846112 19.440 99 80 160 1 2024151616 22976448 24329056
14:41:05 13793 8192000000 10950387584 11371331584 1971947456 19.401 99 64 127 1 2014700720 23703120 19050144
14:41:26 5046 8192000000 10947272960 11375796224 1990072928 19.544 100 68 134 1 2035722928 24963568 20686432
14:41:40 4065 8192000000 10958605104 11384250368 1999544112 19.619 100 69 139 2 2046543456 25264032 21735312
14:41:51 1748 8192000000 10973370736 11392700416 2007528928 19.682 100 86 172 1 2058488560 25235936 25723696
14:42:00 4898 8192000000 10971651632 11394523136 2007423344 19.681 100 76 151 3 2056797568 26441584 22932640
14:42:14 2312 8192000000 10970906208 11386826752 1988226864 19.530 99 82 160 1 2041169024 27541392 25400768
14:42:24 3016 8192000000 10964268864 11389894656 2001369104 19.634 100 78 156 0 2053417040 28282768 23765168
14:42:35 4952 8192000000 10950290784 11376242688 1965389008 19.349 98 79 158 0 2017726048 28009456 24327584
14:42:48 1087 8192000000 10940542752 11351740416 1957835824 19.289 99 94 186 0 2013195872 27923856 27436192
14:42:57 2767 8192000000 10926342672 11339853824 1930395120 19.070 98 75 147 1 1982368720 28574768 23398832
14:43:06 4200 8192000000 10913445152 11330424832 1930084336 19.068 98 79 158 1 1982685648 28958112 23643200
14:43:17 2172 8192000000 10923630912 11344850944 1956774432 19.280 100 69 138 0 2006260048 28187504 21298112
14:43:27 8169 8192000000 10932126624 11354558464 1955076128 19.267 99 79 156 1 2008722944 29591024 24055792
14:43:50 3807 8192000000 10931193072 11357433856 1969338352 19.380 100 66 132 0 2019197136 29717504 20141280
14:44:04 3076 8192000000 10945033904 11355639808 1966905360 19.361 100 87 174 1 2022799616 29699888 26194368
14:44:14 7882 8192000000 10949995424 11365376000 1979395200 19.460 100 76 152 1 2032044080 29687952 22960928
14:44:29 4185 8192000000 10963354576 11375665152 1972908928 19.409 99 93 186 1 2033023728 31493792 28621008
14:44:42 3469 8192000000 10969445040 11385507840 1989172336 19.537 100 86 172 0 2050499584 33945792 27381456
14:44:53 829 8192000000 10978533104 11389956096 1996846272 19.598 100 84 168 0 2057747856 34872592 26028992
14:45:00 2449 8192000000 10950093760 11362201600 1966447280 19.357 99 86 173 0 2030477536 37878496 26151760
14:45:10 4415 8192000000 10956974832 11367264256 1974466800 19.421 100 88 173 1 2040400192 39918528 26014864
14:45:24 4856 8192000000 10950724176 11366084608 1970043520 19.386 100 81 161 2 2035976912 41163232 24770160
14:45:36 6224 8192000000 10956964448 11375230976 1974393152 19.420 100 79 158 0 2039749920 41534704 23822064
14:45:52 3970 8192000000 10940187808 11357118464 1946986672 19.202 99 76 152 3 2014405840 42431104 24988064
14:46:03 2005 8192000000 10944788608 11350466560 1946941392 19.202 99 90 180 1 2019603952 43507568 29154992
14:46:13 1786 8192000000 10943382960 11345092608 1944143952 19.180 100 94 188 0 2018895744 45248224 29503568
14:46:22 2210 8192000000 10935352672 11342213120 1927325200 19.045 99 88 173 1 2001649136 47403472 26920464
14:46:31 1637 8192000000 10925135248 11325976576 1927556288 19.047 99 90 178 1 1995852080 41060816 27234976
14:46:39 1670 8192000000 10940884336 11342524416 1943479728 19.175 100 93 185 1 2013962848 42341936 28141184
14:46:48 3596 8192000000 10894213072 11316953088 1911662912 18.920 99 54 108 0 1970524928 41742032 17119984
14:47:22 2003 8192000000 10898761632 11323400192 1931743504 19.081 100 52 104 4 1982892368 34067456 17081408
14:47:32 3151 8192000000 10900943632 11316559872 1924156784 19.020 99 62 124 2 1980419904 36887312 19375808
14:47:42 9693 8192000000 10902841616 11341172736 1942075392 19.163 100 48 96 1 1996322336 38702624 15544320
14:48:09 17718 8192000000 10912845024 11345715200 1946924032 19.202 100 44 85 4 1992923424 32265232 13734160
14:48:36 4156 8192000000 10931291808 11358109696 1960174672 19.307 100 62 125 2 2012559024 33153200 19231152
14:48:48 10184 8192000000 10918918992 11358720000 1956708944 19.280 100 40 81 2 2002733120 33744928 12279248
14:49:09 11895 8192000000 10904579568 11342360576 1942751792 19.169 99 32 65 1 1988343744 36211024 9380928
14:49:28 5542 8192000000 10909132368 11350245376 1939365936 19.142 99 45 89 1 1987496464 33877744 14252784
14:49:41 7940 8192000000 10902776336 11343052800 1917046944 18.963 98 42 84 2 1966580496 35908048 13625504
14:50:14 14658 8192000000 10903782912 11340455936 1890797040 18.752 97 30 60 0 1940841040 39852752 10191248
14:50:35 11072 8192000000 10899343552 11340468224 1930778160 19.073 100 34 69 1 1984023568 41619232 11626176
14:50:53 12844 8192000000 10915734496 11354656768 1924149712 19.020 99 39 79 1 1982043504 44946752 12947040
14:51:17 12488 8192000000 10902204240 11341553664 1919781952 18.985 99 36 72 1 1976990096 45220784 11987360
14:51:38 17440 8192000000 10915540608 11354664960 1937889600 19.130 100 28 57 2 1996111120 48202576 10018944
14:52:04 11122 8192000000 10896864624 11352731648 1907570224 18.887 98 40 80 1 1968399280 47499024 13330032
14:52:23 11425 8192000000 10889898944 11349995520 1935890240 19.114 100 20 39 2 1974225168 31166144 7168784
14:52:43 20424 8192000000 10878207136 11321860096 1899645296 18.823 98 19 38 1 1936845712 30217424 6982992
14:53:10 39888 8192000000 10882910320 11326406656 1922913504 19.010 100 42 84 3 1969603264 33151424 13538336
14:54:19 23792 8192000000 10860317632 11326836736 1918071536 18.971 100 31 62 1 1960857120 33251056 9534528
14:54:55 47335 8192000000 10843542928 11315433472 1888671392 18.735 99 12 24 2 1918959728 26796896 3491440
14:55:48 91950 8192000000 10866319200 11316064256 1897993648 18.810 99 8 16 2 1927407840 27945552 1468640
14:58:13 36317 8192000000 10894684176 11330846720 1936217536 19.117 99 40 80 3 1955285040 6894960 12172544
14:58:55 15033 8192000000 10887003104 11338641408 1959739952 19.304 100 43 87 0 1978993280 6879248 12374080
14:59:16 39035 8192000000 10897697632 11339067392 1921012032 18.995 98 20 40 1 1934597472 7463168 6122272
15:00:04 30935 8192000000 10908494000 11342819328 1937939456 19.130 99 37 74 0 1960108176 11220864 10947856
15:00:41 44933 8192000000 10889570400 11341590528 1940770896 19.153 99 33 65 0 1964936080 14421072 9744112
15:01:45 67825 8192000000 10896618080 11349176320 1921671216 19.000 98 20 40 1 1946994208 18640160 6682832
15:03:16 68977 8192000000 10899383424 11371913216 1954586672 19.263 100 7 13 0 1979115104 21913520 2614912
15:04:35 96265 8192000000 10924579056 11357302784 1931249968 19.077 98 15 30 0 1949861840 14582544 4029328
15:06:21 22643 8192000000 10924055664 11359805440 1970718688 19.391 100 34 64 2 1987645712 7682448 9244576
15:06:51 17413 8192000000 10890203936 11351891968 1949159552 19.220 99 28 55 0 1971426192 14771808 7494832
15:07:15 59974 8192000000 10898926848 11342168064 1943572384 19.175 99 20 40 3 1959353024 9921904 5858736
15:08:26 124883 8192000000 10896185376 11360296960 1933334064 19.094 98 41 82 1 1964316224 18947040 12035120
15:12:43 1320 8192000000 10926663328 11361353728 1979250880 19.459 100 76 148 1 2008217792 8308320 20658592
15:12:51 13108 8192000000 10918595728 11368570880 1983227296 19.490 100 60 119 2 2010821296 10889904 16704096
15:13:12 30738 8192000000 10890703408 11341131776 1917027856 18.963 97 26 52 0 1933121808 8592624 7501328
15:13:52 33714 8192000000 10910649376 11369422848 1955614032 19.271 99 31 60 0 1977203584 12518976 9070576
15:14:40 28005 8192000000 10893580256 11357499392 1963809408 19.336 99 48 97 1 1990835824 12688976 14337440
15:15:29 27217 8192000000 10908663488 11374362624 1975361824 19.428 100 34 69 0 2005049040 19189856 10497360
15:16:03 16404 8192000000 10923504736 11381850112 1977150144 19.442 100 17 34 0 1997958784 15992464 4816176
15:16:29 187427 8192000000 10919791360 11399274496 1937654336 19.128 97 17 34 1 1962074224 19774400 4645488
15:20:50 58099 8192000000 10915058096 11383668736 1952917360 19.250 98 35 72 3 1990039184 26130832 10990992
15:21:58 24415 8192000000 10922478336 11396751360 1981472800 19.476 100 16 32 2 2006703440 20297952 4932688
15:22:29 18820 8192000000 10912751888 11401850880 1984435520 19.500 100 11 23 1 2006776928 18810448 3530960
15:23:12 40369 8192000000 10895798496 11383054336 1925896480 19.034 97 11 22 0 1944989904 15923824 3169600
15:23:59 50187 8192000000 10915728928 11388514304 1952950448 19.250 99 16 32 1 1977410736 19522304 4937984
15:25:06 23444 8192000000 10903122848 11370291200 1957443536 19.286 99 47 88 2 1983144208 13798448 11902224
15:25:39 23381 8192000000 10909278448 11373080576 1957279200 19.284 99 34 67 3 1977361520 10340768 9741552
15:26:14 46773 8192000000 10902482416 11384639488 1960724608 19.312 99 21 42 0 1981372736 14516352 6131776
15:27:12 59507 8192000000 10913065360 11384348672 1929512624 19.063 97 12 24 0 1954708048 22079552 3115872
15:28:18 49030 8192000000 10916295920 11407253504 1971705680 19.399 100 15 30 2 2003110112 26896368 4508064
15:29:19 71243 8192000000 10902823776 11364380672 1865443984 18.547 94 12 23 0 1888741248 20239984 3057280
15:30:44 38563 8192000000 10873781424 11355734016 1898374384 18.813 97 16 32 0 1916977520 14180416 4422720
15:31:37 105841 8192000000 10836556736 11307380736 1750382496 17.605 90 14 28 0 1775263216 21190816 3689904
15:33:35 33665 8192000000 10862150320 11324403712 1913518944 18.935 99 27 54 2 1928857728 7661872 7676912
15:34:23 30624 8192000000 10876214640 11338584064 1929595632 19.064 99 36 69 1 1949797632 10453392 9748608
15:35:07 39946 8192000000 10894143632 11346276352 1893549568 18.774 97 22 44 0 1917752016 18290096 5912352
15:35:55 56812 8192000000 10881628608 11326599168 1887740288 18.728 97 27 54 0 1905871840 10994336 7137216
15:36:59 119339 8192000000 10863687520 11320926208 1880849568 18.672 97 26 52 1 1898871664 9989216 8032880
15:39:16 55044 8192000000 10839270544 11305205760 1856601360 18.476 96 25 50 3 1872226960 7917312 7708288
15:40:22 62099 8192000000 10844220176 11299172352 1829442768 18.255 95 32 62 2 1845535120 8179136 7913216
15:41:31 16881 8192000000 10846039600 11295440896 1895563424 18.791 99 34 68 0 1914819392 9500032 9755936
15:41:58 35424 8192000000 10872324432 11326914560 1931856016 19.082 100 29 58 1 1952946704 12473232 8617456
15:42:43 40665 8192000000 10881098416 11347079168 1944380736 19.182 100 27 54 0 1964584096 11780480 8422880
15:43:30 83065 8192000000 10846138176 11319758848 1853118304 18.447 95 14 28 2 1873091808 15399392 4574112
15:45:32 35409 8192000000 10857753568 11330551808 1913615744 18.936 99 20 40 2 1936131184 16592288 5923152
15:46:14 34571 8192000000 10850203344 11334369280 1912881376 18.930 99 11 22 0 1931692352 15475408 3335568
15:46:57 20815 8192000000 10871290416 11339210752 1929717408 19.065 100 9 18 0 1947383824 15046256 2620160
15:48:28 64686 8192000000 10873011088 11345256448 1925979248 19.035 99 20 40 1 1939132368 7592624 5560496
15:49:51 46002 8192000000 10866375696 11356184576 1948675680 19.216 100 9 18 0 1962676320 11481424 2519216
15:50:43 39536 8192000000 10866370256 11333017600 1909258592 18.901 98 18 36 0 1921935200 7686736 4989872
15:51:33 52370 8192000000 10852477520 11317379072 1887646800 18.727 97 17 33 1 1900462432 7838528 4977104
15:52:32 45867 8192000000 10873697632 11337658368 1931206128 19.077 100 24 48 1 1948790608 10833616 6750864
15:53:35 37203 8192000000 10883570080 11356618752 1949630576 19.224 100 29 58 0 1967531152 9896608 8003968
15:54:18 52575 8192000000 10861569232 11339296768 1898471696 18.814 97 12 23 0 1910396768 8708240 3216832
15:55:20 76003 8192000000 10902814160 11361443840 1919623216 18.984 98 24 46 1 1934938912 8605216 6710480
15:56:43 28936 8192000000 10889825216 11354624000 1928337856 19.054 98 26 53 0 1944611504 9009104 7264544
15:57:21 105207 8192000000 10900503376 11375230976 1936537936 19.119 98 15 30 0 1950130896 9492928 4100032
15:59:12 55908 8192000000 10915840336 11372257280 1946228304 19.196 98 29 58 0 1963342832 9169376 7945152
16:00:16 21228 8192000000 10934450336 11389734912 1983492448 19.492 100 41 82 0 2004871312 10402304 10976560
16:00:44 32851 8192000000 10928310048 11401031680 1990373504 19.547 100 31 62 0 2010493088 11471584 8648000
16:01:25 48995 8192000000 10926174592 11406467072 1974503600 19.421 99 15 30 0 1993040560 13999824 4537136
16:02:20 74285 8192000000 10917779280 11390001152 1953673024 19.256 98 12 23 1 1967164128 10659888 2831216
16:03:41 64562 8192000000 10917972496 11396272128 1921115680 18.996 96 17 33 1 1939044688 13328624 4600384
16:04:56 97525 8192000000 10910627088 11403624448 1959975168 19.306 99 11 22 0 1982204640 19301776 2927696
16:07:03 45671 8192000000 10902354848 11378556928 1973289680 19.412 100 14 28 0 1986311584 8787536 4234368
16:08:00 20353 8192000000 10914886272 11379453952 1969057408 19.378 99 38 76 1 1990117792 10075648 10984736
16:08:27 80426 8192000000 10915570304 11403505664 1971287232 19.396 99 21 42 1 1992189552 14512048 6390272
16:11:42 54462 8192000000 10889709216 11366973440 1919401600 18.982 97 8 16 0 1935611312 14190000 2019712
16:12:43 62073 8192000000 10899371664 11373813760 1933582064 19.096 98 21 42 0 1947379744 7778288 6019392
16:14:08 90653 8192000000 10881863792 11369865216 1941474048 19.159 98 17 33 1 1957035952 9756832 5805072
16:15:46 54314 8192000000 10904312592 11384475648 1976339296 19.436 100 16 32 1 1991322528 10650384 4332848
16:17:23 67884 8192000000 10873792688 11359653888 1903342128 18.853 96 17 34 0 1916485824 8620784 4522912
16:18:37 63512 8192000000 10863797888 11358334976 1902198752 18.844 97 7 14 0 1912979600 8769152 2011696
16:20:04 41779 8192000000 10874175472 11333361664 1854802608 18.461 95 19 38 0 1867515696 7665568 5047520
16:20:56 25410 8192000000 10877890864 11344875520 1928335520 19.054 99 34 68 0 1953936432 15533712 10067200
16:21:37 39216 8192000000 10887413040 11349102592 1911451904 18.918 98 17 33 2 1929585840 13478032 4655904
16:22:28 26772 8192000000 10898819040 11366170624 1951235680 19.236 100 28 56 1 1975104560 15455920 8412960
16:23:01 31222 8192000000 10881722096 11354652672 1895561392 18.791 97 23 46 0 1919366640 16917200 6888048
16:23:43 51099 8192000000 10883813824 11356094464 1939956512 19.146 100 24 48 1 1960480064 13373968 7149584
16:25:05 67093 8192000000 10841967888 11318091776 1786519600 17.903 92 24 47 3 1810251712 16759408 6972704
16:26:23 54368 8192000000 10854640384 11311427584 1862355920 18.522 97 6 12 0 1872528000 8682336 1489744

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 24-02-2021 16:28:17 to 24-02-2021 16:28:49.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-02-2021 16:28:50 to 24-02-2021 16:28:52.

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          243878
MON$OLDEST_ACTIVE               244984
MON$OLDEST_SNAPSHOT             244984
MON$NEXT_TRANSACTION            244984
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                       2053600
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:238: 
:239: mscs-test-161.budzdorov.ru    Wed Feb 24 16:27:21 2021
:240:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:241: 
:242: 
:243: mscs-test-161.budzdorov.ru    Wed Feb 24 16:27:23 2021
:244:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:245: 
:246: 
:247: mscs-test-161.budzdorov.ru    Wed Feb 24 16:27:23 2021
:248:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:249: 
--- end of diff output ---

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

24.02.21 16:28:53. 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-02-24 16:28:56 No severe PSQL-related problems occured
24.02.21 16:28:57. End of report.