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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
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.26
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 17606184 kB
MemAvailable 31578120 kB
Buffers 0 kB
Cached 14049668 kB
SwapCached 0 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-03-10 01:27:21
DTS_END                         2021-03-10 01:27:21.5490
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/58522
TRN_ID                          244353
ATT_ID                          695
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: 9251.96 21804 1110235
customer order: creation 177.17 368 21260
customer order: refuse 15.16 336 1819
order to supplier: creation 48.48 1317 5817
order to supplier: removal 3.55 89058 426
invoice (draft): creation 47.36 3350 5683
invoice (draft): removal 52.21 695 6265
invoice accept: apply 42.52 17870 5102
invoice accept: cancel 46.55 716 5586
customer reserve: creation 3897.93 177 467752
customer reserve: removal 4625.23 53 555028
realization accept: apply 86.18 184 10342
realization accept: cancel 74.33 119 8919
payment from customer: creation 61.95 126 7434
payment from customer: removal 5.79 57 695
payment to supplier: creation 51.39 153 6167
payment to supplier: removal 3.33 70 399
service: total inventory turnovers 4.78 1108 574
service: total monetary turnovers 7.23 47 867
service: aggregate perf. data 0.80 18414 96
service: refresh index statistics 0.03 301854 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-03-2021 01:28:31 to 10-03-2021 01:28:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4163
TEST_TIME 2 4103
TEST_TIME 3 4586
TEST_TIME 4 3915
TEST_TIME 5 4023
TEST_TIME 6 4520
TEST_TIME 7 5551
TEST_TIME 8 5986
TEST_TIME 9 5981
TEST_TIME 10 6179
TEST_TIME 11 6246
TEST_TIME 12 6240
TEST_TIME 13 6369
TEST_TIME 14 6775
TEST_TIME 15 6956
TEST_TIME 16 7055
TEST_TIME 17 7077
TEST_TIME 18 7535
TEST_TIME 19 7798
TEST_TIME 20 8293
TEST_TIME 21 8504
TEST_TIME 22 9094
TEST_TIME 23 9319
TEST_TIME 24 9426
TEST_TIME 25 10168
TEST_TIME 26 10561
TEST_TIME 27 10324
TEST_TIME 28 10187
TEST_TIME 29 10062
TEST_TIME 30 10003
TEST_TIME 31 10051
TEST_TIME 32 9846
TEST_TIME 33 9750
TEST_TIME 34 9650
TEST_TIME 35 9836
TEST_TIME 36 9751
TEST_TIME 37 9665
TEST_TIME 38 9604
TEST_TIME 39 9654
TEST_TIME 40 9454
TEST_TIME 41 9418
TEST_TIME 42 9355
TEST_TIME 43 9197
TEST_TIME 44 9095
TEST_TIME 45 9164
TEST_TIME 46 9139
TEST_TIME 47 9147
TEST_TIME 48 9188
TEST_TIME 49 9337
TEST_TIME 50 9331
TEST_TIME 51 9325
TEST_TIME 52 9466
TEST_TIME 53 9426
TEST_TIME 54 9496
TEST_TIME 55 9580
TEST_TIME 56 9543
TEST_TIME 57 9669
TEST_TIME 58 9666
TEST_TIME 59 9550
TEST_TIME 60 9436
TEST_TIME 61 9428
TEST_TIME 62 9372
TEST_TIME 63 9284
TEST_TIME 64 9322
TEST_TIME 65 9259
TEST_TIME 66 9281
TEST_TIME 67 9281
TEST_TIME 68 9283
TEST_TIME 69 9350
TEST_TIME 70 9311
TEST_TIME 71 9351
TEST_TIME 72 9360
TEST_TIME 73 9397
TEST_TIME 74 9449
TEST_TIME 75 9394
TEST_TIME 76 9491
TEST_TIME 77 9487
TEST_TIME 78 9467
TEST_TIME 79 9628
TEST_TIME 80 9610
TEST_TIME 81 9500
TEST_TIME 82 9475
TEST_TIME 83 9411
TEST_TIME 84 9444
TEST_TIME 85 9405
TEST_TIME 86 9346
TEST_TIME 87 9282
TEST_TIME 88 9269
TEST_TIME 89 9180
TEST_TIME 90 9235
TEST_TIME 91 9346
TEST_TIME 92 9323
TEST_TIME 93 9365
TEST_TIME 94 9362
TEST_TIME 95 9351
TEST_TIME 96 9400
TEST_TIME 97 9434
TEST_TIME 98 9420
TEST_TIME 99 9388
TEST_TIME 100 9414
TEST_TIME 101 9466
TEST_TIME 102 9455
TEST_TIME 103 9500
TEST_TIME 104 9493
TEST_TIME 105 9497
TEST_TIME 106 9413
TEST_TIME 107 9390
TEST_TIME 108 9379
TEST_TIME 109 9387
TEST_TIME 110 9346
TEST_TIME 111 9317
TEST_TIME 112 9290
TEST_TIME 113 9257
TEST_TIME 114 9215
TEST_TIME 115 9185
TEST_TIME 116 9217
TEST_TIME 117 9220
TEST_TIME 118 9301
TEST_TIME 119 9278
TEST_TIME 120 9255

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 10-03-2021 01:28:35 to 10-03-2021 01:28:38.

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 1543730 1543730 0 0.00 0 32583 6 0 0
doc_list_biud 1543730 1543730 0 0.00 0 31909 25 0 0
sp_add_invoice_to_stock 5199 5102 97 1.86 37 180403 17871 0 97
sp_cancel_adding_invoice 5586 5586 0 0.00 5 52417 717 0 0
sp_cancel_client_order 1819 1819 0 0.00 4 11670 336 0 0
sp_cancel_customer_reserve 555028 555028 0 0.00 1 26497 54 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 3 2420 57 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 3 4333 71 0 0
sp_cancel_supplier_invoice 6275 6265 10 0.15 2 26237 696 0 10
sp_cancel_supplier_order 426 426 0 0.00 7 1053447 89058 0 0
sp_cancel_write_off 8919 8919 0 0.00 1 31919 120 0 0
sp_client_order 21260 21260 0 0.00 3 26629 369 0 0
sp_customer_reserve 467752 467752 0 0.00 0 49185 178 0 0
sp_fill_shopping_cart 32742 32742 0 0.00 1 10080 38 0 0
sp_fill_shopping_cart_clo_res 467747 467747 0 0.00 0 22535 13 0 0
sp_get_clo_for_invoice 5097 5097 0 0.00 0 19055 302 0 0
sp_kill_cost_storno 15599 15599 0 0.00 0 15649 55 0 0
sp_kill_qstorno_ret_qs2qd 1125666 1125666 0 0.00 0 31905 29 0 0
sp_kill_qty_storno 593482 593482 0 0.00 0 31909 64 0 0
sp_lock_selected_doc 21350 21350 0 0.00 0 6798 6 0 0
sp_make_cost_storno 29040 29040 0 0.00 0 32461 56 0 0
sp_multiply_rows_for_pdistr 29040 29040 0 0.00 0 19745 31 0 0
sp_multiply_rows_for_qdistr 21260 21260 0 0.00 0 12929 169 0 0
sp_pay_from_customer 7434 7434 0 0.00 4 23731 126 0 0
sp_pay_to_supplier 6167 6167 0 0.00 4 33852 154 0 0
sp_payment_common 13601 13601 0 0.00 1 33818 44 0 0
sp_qd_handle_on_cancel_clo 1819 1819 0 0.00 0 11658 307 0 0
sp_qd_handle_on_invoice_upd_sts 10683 10683 0 0.00 0 26619 327 0 0
sp_qd_handle_on_reserve_upd_sts 10342 10342 0 0.00 0 25371 56 0 0
sp_reserve_write_off 10342 10342 0 0.00 6 25421 185 0 0
sp_supplier_invoice 5683 5683 0 0.00 5 72369 3350 0 0
sp_supplier_order 5817 5817 0 0.00 6 25343 1318 0 0
srv_aggregate_perf_data 96 96 0 0.00 2154 157419 18415 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 800 128063 33132 0 0
srv_find_qd_qs_mism 1061269 1061269 0 0.00 0 15594 5 0 0
srv_make_invnt_saldo 574 574 0 0.00 22 71723 1108 0 0
srv_make_money_saldo 867 867 0 0.00 1 9638 48 0 0
srv_recalc_idx_stat 4 4 0 0.00 146775 414827 301855 0 0
t$perf-abend:sp_add_invoice_to_stock 97 97 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5102 5102 0 0.00 0 14411 170 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 4596 98 0 0
t$perf-norm:sp_cancel_client_order 1819 1819 0 0.00 0 6541 18 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 2977 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 750 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 1798 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 3385 18 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 18705 1318 0 0
t$perf-norm:sp_cancel_write_off 1025 1025 0 0.00 0 7273 13 0 0
t$perf-norm:sp_client_order 21260 21260 0 0.00 0 8632 16 0 0
t$perf-norm:sp_customer_reserve 1011 1011 0 0.00 0 893 7 0 0
t$perf-norm:sp_pay_from_customer 7434 7434 0 0.00 0 8106 10 0 0
t$perf-norm:sp_pay_to_supplier 6167 6167 0 0.00 0 3956 10 0 0
t$perf-norm:sp_reserve_write_off 10342 10342 0 0.00 0 8525 11 0 0
t$perf-norm:sp_supplier_invoice 5683 5683 0 0.00 0 5969 17 0 0
t$perf-norm:sp_supplier_order 5817 5817 0 0.00 0 18412 20 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 567 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 602 4 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 1142 19 0 0
t$perf-norm:srv_make_money_saldo 867 867 0 0.00 0 7151 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 10 4 0 0
v_add_invoice_to_stock 10384 10190 194 1.86 0 4947 18 0 194
v_all_customers 39026 39026 0 0.00 0 89 1 0 0
v_all_suppliers 31854 31854 0 0.00 0 89 1 0 0
v_all_wares 42512 42512 0 0.00 0 44 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 1283 8 0 0
v_cancel_client_order 3638 3638 0 0.00 0 2758 7 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 1126 3 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 5094 9 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 781 5 0 0
v_cancel_supplier_invoice 850 830 20 2.35 0 1725 18 0 20
v_cancel_supplier_order 852 852 0 0.00 0 2707 6 0 0
v_cancel_write_off 2050 2050 0 0.00 0 2636 14 0 0
v_max_id_clo_ord 5810 5810 0 0.00 0 5417 2 0 0
v_max_id_clo_res 1011 1011 0 0.00 0 3158 20 0 0
v_max_id_ord_sup 5675 5675 0 0.00 0 4759 4 0 0
v_max_non_paid_invoice 1725 1725 0 0.00 0 170 2 0 0
v_max_non_paid_realizn 3885 3885 0 0.00 0 4315 5 0 0
v_min_id_clo_ord 5810 5810 0 0.00 0 7988 14 0 0
v_min_id_clo_res 1011 1011 0 0.00 0 726 2 0 0
v_min_id_ord_sup 5675 5675 0 0.00 0 6118 6 0 0
v_min_non_paid_invoice 6167 6167 0 0.00 0 19252 30 0 0
v_min_non_paid_realizn 7434 7434 0 0.00 0 19552 33 0 0
v_our_firm 10584 10584 0 0.00 0 15 1 0 0
v_reserve_write_off 20684 20684 0 0.00 0 7456 8 0 0
x_lock_depdocs_on_canc_invoice 11436 11436 0 0.00 0 14277 113 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 8575 316 0 0
x_make_qstorno_1000_1200 5817 5817 0 0.00 2 23710 1229 0 0
x_make_qstorno_1200_2000 5683 5683 0 0.00 2 72360 3225 0 0
x_make_qstorno_2100_3300 467752 467752 0 0.00 0 41366 162 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-03-2021 01:28:39 to 10-03-2021 01:28:43.

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
22:57:25 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:32 14259 8192000000 10235764944 10539761664 998512672 10.864 78 65 130 1 1023061232 2761104 21787456
22:57:54 22303 8192000000 10318411936 10630684672 1366082352 14.292 100 86 172 0 1398213024 4215520 27915152
22:58:34 26920 8192000000 10372379552 10694144000 1425177312 14.819 100 89 177 0 1460702752 6530592 28994848
22:59:12 22916 8192000000 10418058928 10745049088 1458779344 15.115 100 90 180 0 1495836112 7437376 29619392
22:59:59 25286 8192000000 10446972464 10779648000 1498377056 15.462 100 92 184 0 1536615632 8795120 29443456
23:00:38 21413 8192000000 10456849904 10793463808 1512744144 15.587 100 88 176 1 1550910480 9756496 28409840
23:01:11 15396 8192000000 10469206512 10809688064 1527522288 15.716 100 85 170 0 1564320144 9713856 27084000
23:01:35 19877 8192000000 10504162624 10846416896 1550725968 15.916 100 83 166 0 1587480544 10295856 26458720
23:02:05 14673 8192000000 10521047392 10871869440 1581207920 16.179 100 78 156 1 1615214176 10001952 24004304
23:02:29 10420 8192000000 10532656128 10888699904 1602733872 16.363 100 77 154 1 1636958624 10414096 23810656
23:02:53 17596 8192000000 10581001888 10939195392 1629463600 16.590 100 78 156 3 1663958944 10978880 23516464
23:03:18 13484 8192000000 10585364976 10954571776 1652124624 16.782 100 79 158 0 1686778544 11196720 23457200
23:03:40 9236 8192000000 10620930736 10988302336 1685122032 17.060 100 77 154 0 1718450784 11462336 21866416
23:03:58 9105 8192000000 10640857840 11011624960 1698743984 17.175 100 73 146 0 1731970864 12269120 20957760
23:04:15 8290 8192000000 10656374336 11029180416 1715555888 17.315 100 75 147 2 1749041392 11737776 21747728
23:04:30 7214 8192000000 10672761856 11045863424 1731578064 17.449 100 77 154 0 1765762608 12257552 21926992
23:04:46 7263 8192000000 10678371008 11059306496 1741523824 17.531 100 73 145 2 1774404896 11796496 21084576
23:05:02 6953 8192000000 10689694848 11067801600 1754846960 17.642 100 74 148 2 1787997232 12347904 20802368
23:05:17 6893 8192000000 10707730848 11087671296 1767928560 17.750 100 75 151 0 1801706144 12621344 21156240
23:05:31 5543 8192000000 10718253072 11100803072 1781919856 17.865 100 80 160 0 1817200976 12255984 23025136
23:05:44 4248 8192000000 10727810736 11110416384 1792709504 17.954 100 87 175 0 1829688224 11987680 24991040
23:05:55 10274 8192000000 10727297744 11115847680 1792809472 17.955 100 69 136 2 1824423072 12986976 18626624
23:06:12 3223 8192000000 10735142560 11124162560 1806542800 18.068 100 72 143 2 1839022048 11788608 20690640
23:06:23 2998 8192000000 10762410496 11147415552 1821059952 18.186 100 81 162 1 1855577648 11676896 22840800
23:06:33 4783 8192000000 10768111936 11157983232 1829800320 18.258 100 85 170 2 1866182048 12426480 23955248
23:06:44 2732 8192000000 10778228080 11162394624 1836455328 18.312 100 86 170 3 1873312624 12701600 24155696
23:06:54 2484 8192000000 10785930720 11173957632 1842069440 18.358 100 88 176 1 1880404528 13911392 24423696
23:07:03 3028 8192000000 10790090864 11175477248 1843747120 18.371 100 88 172 0 1883247472 14637152 24863200
23:07:12 3200 8192000000 10800274896 11186118656 1849422304 18.417 100 88 177 0 1887597456 13579936 24595216
23:07:22 2958 8192000000 10799654784 11184689152 1855601824 18.468 100 89 175 0 1893637520 13711696 24324000
23:07:31 2412 8192000000 10803476896 11190579200 1857674848 18.484 100 90 180 0 1898709696 15396624 25638224
23:07:41 2381 8192000000 10800980848 11190161408 1862003776 18.520 100 91 182 1 1902658144 15296544 25357824
23:07:49 1876 8192000000 10805244784 11199762432 1865652048 18.549 100 91 182 1 1906403088 14746800 26004240
23:07:58 2207 8192000000 10811087248 11200122880 1865018976 18.544 100 86 172 1 1901628544 12880496 23729072
23:08:07 2283 8192000000 10813986064 11201507328 1871497760 18.596 100 91 177 0 1909001408 11994704 25508944
23:08:15 2221 8192000000 10817358944 11205742592 1873905216 18.616 100 94 189 1 1914853520 14644384 26303920
23:08:24 2546 8192000000 10817093600 11208626176 1876178256 18.634 100 94 188 2 1916818896 13606944 27033696
23:08:32 1940 8192000000 10818864576 11212808192 1875523216 18.629 100 95 188 3 1916066400 14361728 26181456
23:08:41 2639 8192000000 10812359840 11203850240 1874393872 18.620 100 87 173 2 1911877344 13262224 24221248
23:08:50 3245 8192000000 10809215440 11208798208 1874332816 18.619 100 68 134 3 1905588704 12657072 18598816
23:09:00 3447 8192000000 10809224160 11210346496 1875848592 18.632 100 71 141 1 1905905136 10154112 19902432
23:09:10 5219 8192000000 10813848432 11215695872 1880665200 18.670 100 69 137 1 1910907504 10869792 19372512
23:09:24 15240 8192000000 10819917488 11216363520 1883847808 18.696 100 77 153 1 1916841360 12023488 20970064
23:09:45 1026 8192000000 10834919152 11229880320 1892612672 18.767 100 84 168 0 1928938832 13050272 23275888
23:09:54 20505 8192000000 10795347776 11221499904 1885308192 18.708 100 48 90 0 1907355376 9780096 12267088
23:10:24 4908 8192000000 10808129408 11220627456 1887261680 18.724 100 52 101 1 1909592688 7357024 14973984
23:10:35 5261 8192000000 10794289408 11220598784 1885160144 18.707 100 31 62 4 1901928608 8187072 8581392
23:10:47 3995 8192000000 10791221664 11221114880 1889479760 18.742 100 29 58 0 1902573744 5550480 7543504
23:10:57 3465 8192000000 10806479632 11229523968 1892492752 18.766 100 43 86 1 1912797056 7333088 12971216
23:11:08 2626 8192000000 10823167856 11238338560 1896617056 18.799 100 54 108 1 1917832560 6409584 14805920
23:11:18 5593 8192000000 10802254672 11230248960 1894902336 18.785 100 40 80 2 1915337552 9257408 11177808
23:11:34 10741 8192000000 10800351360 11231481856 1896332112 18.797 100 16 33 0 1907534176 5578192 5623872
23:11:51 10982 8192000000 10795300048 11231158272 1896607264 18.799 100 27 54 2 1910355024 6777104 6970656
23:12:10 7891 8192000000 10814494720 11238334464 1900659488 18.832 100 35 71 1 1918246064 7800352 9786224
23:12:27 6736 8192000000 10814736128 11246977024 1900677760 18.832 100 20 38 2 1911679168 5168992 5832416
23:12:46 7738 8192000000 10804546512 11244773376 1902238256 18.844 100 26 52 1 1921188448 11504560 7445632
23:13:01 6778 8192000000 10820560800 11249930240 1907240928 18.884 100 32 64 2 1922422144 5761760 9419456
23:13:17 10967 8192000000 10812793792 11248832512 1909787136 18.905 100 20 40 1 1921356080 5979152 5589792
23:13:37 16602 8192000000 10830485568 11256557568 1911527120 18.919 100 23 46 0 1927757328 10196608 6033600
23:14:02 77389 8192000000 10827051536 11263348736 1912926224 18.930 100 36 74 4 1928658656 5373024 10359408
23:15:25 6907 8192000000 10828244528 11263262720 1914382288 18.942 100 18 37 1 1925382608 5625312 5375008
23:15:40 6432 8192000000 10845807856 11266904064 1913476912 18.935 100 38 77 1 1931246208 6820016 10949280
23:15:54 7397 8192000000 10833881088 11264290816 1913478672 18.935 100 32 64 1 1928524720 6066176 8979872
23:16:09 5777 8192000000 10836042096 11261255680 1900568144 18.831 99 40 80 2 1919605520 8653232 10384144
23:16:21 5907 8192000000 10831166304 11268595712 1913472480 18.935 100 31 61 1 1933099328 11632320 7994528
23:16:33 5985 8192000000 10837511568 11273773056 1916726752 18.961 100 34 69 2 1936775936 10341216 9707968
23:16:49 9085 8192000000 10836412240 11271229440 1923549248 19.015 100 34 68 1 1939581952 6103088 9929616
23:17:05 7284 8192000000 10827562304 11264221184 1902439312 18.846 99 29 58 1 1916941280 5676432 8825536
23:17:19 9500 8192000000 10820130432 11258519552 1893959504 18.778 99 16 32 0 1903688416 4912784 4816128
23:17:35 5550 8192000000 10819239024 11246731264 1885786576 18.712 99 33 66 2 1901905344 7199440 8919328
23:17:50 8592 8192000000 10798083712 11230486528 1871993568 18.600 99 22 44 0 1885101792 6162544 6945680
23:18:06 6100 8192000000 10769376096 11197591552 1802170720 18.032 96 26 52 1 1815201616 5223888 7807008
23:18:18 7041 8192000000 10737869648 11150876672 1773333680 17.795 95 32 65 2 1787160512 5108576 8718256
23:18:36 10551 8192000000 10737500448 11158798336 1776849520 17.824 97 20 40 1 1788358112 6002672 5505920
23:18:53 70503 8192000000 10720232096 11138179072 1711455776 17.281 93 42 84 2 1728962208 4930672 12575760
23:20:14 9585 8192000000 10704645824 11113279488 1672865104 16.957 92 31 62 0 1687015584 5801792 8348688
23:20:29 5674 8192000000 10706019760 11112116224 1723667440 17.383 96 28 54 2 1736617184 5432320 7517424
23:20:45 7261 8192000000 10723676944 11145216000 1793978976 17.964 99 28 58 0 1809143328 7217392 7946960
23:21:01 7040 8192000000 10714356272 11117793280 1711900272 17.285 95 32 64 0 1726879568 5952336 9026960
23:21:15 7825 8192000000 10698869328 11113291776 1750500352 17.606 98 23 46 0 1762626848 5618592 6507904
23:21:33 5601 8192000000 10708674496 11125313536 1778454960 17.837 99 25 50 0 1792941728 6211856 8274912
23:21:45 6663 8192000000 10720286368 11140558848 1801597312 18.027 100 24 48 1 1813838208 6386016 5854880
23:22:01 4754 8192000000 10724856912 11142463488 1807927920 18.079 100 34 68 2 1824172480 6456208 9788352
23:22:18 8429 8192000000 10695318512 11105386496 1725396080 17.397 96 30 61 1 1739545664 5052464 9097120
23:22:34 11217 8192000000 10737797824 11151118336 1810787360 18.102 100 37 75 0 1827064592 5046800 11230432
23:22:57 12316 8192000000 10756730528 11172831232 1830912688 18.267 100 27 52 0 1844907184 5565296 8429200
23:23:16 13754 8192000000 10749702816 11172704256 1836773696 18.315 100 25 50 1 1849294816 5270704 7250416
23:23:38 12942 8192000000 10764594560 11176169472 1841231904 18.351 100 43 84 0 1860358832 6220512 12906416
23:23:57 59444 8192000000 10763392592 11187732480 1845531968 18.386 100 34 68 2 1861792416 5668576 10591872
23:25:06 8572 8192000000 10760462432 11190358016 1851994048 18.438 100 33 64 4 1866660176 5286192 9379936
23:25:21 6263 8192000000 10767520704 11196653568 1857329072 18.482 100 31 62 1 1871882544 5920112 8633360
23:25:36 7736 8192000000 10766980960 11202285568 1861698352 18.517 100 33 65 1 1876968912 5679760 9590800
23:25:51 7922 8192000000 10774852064 11201241088 1857592800 18.484 100 26 52 1 1870572032 5193584 7785648
23:26:06 6821 8192000000 10790894064 11205165056 1863841568 18.534 100 32 65 0 1878980496 6281728 8857200
23:26:19 5666 8192000000 10777537152 11207929856 1862413568 18.523 100 20 40 1 1873751376 5985008 5352800
23:26:36 7975 8192000000 10785641680 11211436032 1867727184 18.566 100 31 62 2 1882922352 6159232 9035936
23:26:53 9079 8192000000 10781402672 11213553664 1866297472 18.554 100 18 36 3 1876494848 5407296 4790080
23:27:09 8165 8192000000 10791335536 11225157632 1882326128 18.684 100 24 46 3 1894260128 5224112 6709888
23:27:23 23329 8192000000 10820443776 11245080576 1896504752 18.798 100 38 76 0 1917877360 10699504 10673104
23:28:06 20655 8192000000 10834456752 11254505472 1905232528 18.868 100 44 88 1 1925583232 7317344 13033360
23:28:34 14135 8192000000 10840455248 11262550016 1913646736 18.936 100 38 76 0 1931981296 7737008 10597552
23:28:56 17337 8192000000 10849531216 11274055680 1921546448 18.999 100 37 74 1 1939628880 7856080 10226352
23:29:32 4566 8192000000 10863084336 11284365312 1932547104 19.087 100 56 110 3 1958001920 9334768 16120048
23:29:48 43866 8192000000 10870317168 11296788480 1935583968 19.112 100 33 64 1 1954870320 9590416 9695936
23:30:41 96099 8192000000 10863624832 11307880448 1943759248 19.177 100 34 69 0 1967882880 13958064 10165568
23:32:25 47017 8192000000 10876022624 11317837824 1952149648 19.244 100 37 74 2 1978821504 15245328 11426528
23:33:22 6860 8192000000 10898439312 11326087168 1959681648 19.304 100 57 112 1 1991640432 15547888 16410896
23:33:39 3901 8192000000 10912594768 11334840320 1966332720 19.356 100 67 132 1 2005326336 19360944 19632672
23:33:58 21886 8192000000 10901915440 11340120064 1964021104 19.338 100 53 105 1 2001966336 21915152 16030080
23:34:36 41579 8192000000 10913564896 11353026560 1962983520 19.330 100 32 64 0 1990811504 17481360 10346624
23:35:26 26049 8192000000 10927817888 11361374208 1982562352 19.485 100 37 74 2 2011511728 17447248 11502128
23:36:02 17344 8192000000 10938274000 11374743552 1993982384 19.575 100 56 111 3 2029659088 19438464 16238240
23:36:32 6775 8192000000 10944802448 11378573312 1996963920 19.599 100 57 112 1 2035560688 20281264 18315504
23:36:45 8838 8192000000 10941256016 11380125696 1996320688 19.594 100 45 90 1 2029634240 19835840 13477712
23:37:02 3897 8192000000 10940729056 11376603136 1979751232 19.463 99 53 106 1 2016915296 20742096 16421968
23:37:15 5726 8192000000 10942929824 11378786304 1994619392 19.580 100 64 127 2 2034770368 20191440 19959536
23:37:32 5673 8192000000 10941792512 11375677440 1981191296 19.474 99 72 137 1 2022998944 20442784 21364864
23:37:47 5663 8192000000 10954349040 11382423552 1997806224 19.605 100 68 136 0 2042007632 23279488 20921920
23:38:01 11890 8192000000 10949508512 11388624896 1996540512 19.595 100 56 112 1 2039838608 26426160 16871936
23:38:22 6589 8192000000 10948276080 11385114624 1999918608 19.622 100 58 115 2 2039672784 22288288 17465888
23:38:36 7669 8192000000 10930931072 11368505344 1982605984 19.485 99 54 108 0 2019916560 20496320 16814256
23:38:54 5279 8192000000 10950707328 11386179584 2000852032 19.629 100 59 120 2 2040458560 21451664 18154864
23:39:07 4520 8192000000 10957905344 11391430656 1982525056 19.485 99 56 111 4 2024975648 25576768 16873824
23:39:20 8292 8192000000 10973912352 11396255744 2007452656 19.681 100 74 148 0 2051527952 22188944 21886352
23:39:37 5882 8192000000 10973556480 11402149888 2010722176 19.707 100 71 140 3 2054493312 23162704 20608432
23:39:50 7380 8192000000 10968937008 11395821568 2008336448 19.688 100 76 150 2 2055010848 24911184 21763216
23:40:06 6188 8192000000 10963872896 11393679360 2003470368 19.650 100 73 145 2 2049187952 24224032 21493552
23:40:19 3004 8192000000 10941057632 11352690688 1974388464 19.420 99 84 165 0 2024360560 25667968 24304128
23:40:30 2307 8192000000 10960314256 11379449856 1993862224 19.574 100 86 172 0 2045710400 25732640 26115536
23:40:40 7060 8192000000 10952335920 11383418880 1990170352 19.545 100 65 129 0 2035710080 26253344 19286384
23:40:54 3700 8192000000 10958760368 11381399552 1992843168 19.566 100 82 161 1 2044181904 27368928 23969808
23:41:05 5705 8192000000 10950901584 11375091712 1975656064 19.430 99 75 150 1 2026795632 28298816 22840752
23:41:19 2737 8192000000 10956445152 11384963072 1993506848 19.571 100 76 152 0 2045966960 29202016 23258096
23:41:29 6152 8192000000 10952914720 11376373760 1985787840 19.510 100 77 153 2 2037444720 28636464 23020416
23:41:46 5377 8192000000 10952510688 11385991168 1991400192 19.555 100 66 132 1 2039507472 27554688 20552592
23:41:59 7860 8192000000 10964263920 11394269184 1985595792 19.509 99 71 139 1 2032615008 26436064 20583152
23:42:18 1682 8192000000 10967911024 11383840768 1985033200 19.505 99 84 165 2 2037660416 27953568 24673648
23:42:27 1119 8192000000 10979799024 11397226496 2003095408 19.647 100 85 170 3 2054377376 26577920 24704048
23:42:34 3148 8192000000 10966345104 11387346944 1988118656 19.529 99 82 163 0 2040542240 28345776 24077808
23:42:44 2568 8192000000 10974485328 11396530176 2003692112 19.652 100 88 177 1 2058620928 29269408 25659408
23:42:54 4236 8192000000 10947548768 11366092800 1974622528 19.422 100 83 165 0 2028363360 28788800 24952032
23:43:07 3727 8192000000 10954781760 11375542272 1982107424 19.481 100 82 163 0 2036095648 29973184 24015040
23:43:19 1747 8192000000 10950802128 11365494784 1975335040 19.428 100 82 162 1 2030650400 30806528 24508832
23:43:28 4011 8192000000 10931524656 11348672512 1929893456 19.066 98 82 164 0 1984796592 30443440 24459696
23:43:39 3996 8192000000 10931747232 11343527936 1954190400 19.260 99 86 172 1 2012580048 32303824 26085824
23:43:49 2026 8192000000 10929454192 11343269888 1926586976 19.040 98 80 159 0 1983712160 32850768 24274416
23:44:00 7104 8192000000 10934938608 11353145344 1943067632 19.171 99 86 172 0 2002520144 32843248 26609264
23:44:16 5528 8192000000 10935879856 11348320256 1952284976 19.245 100 79 158 1 2013415264 35745792 25384496
23:44:29 3822 8192000000 10949948784 11358121984 1962983376 19.330 100 86 169 3 2026176000 36590608 26602016
23:44:43 3944 8192000000 10946133216 11364089856 1964782032 19.344 100 85 167 3 2029020016 38233872 26004112
23:44:55 2422 8192000000 10947749024 11368431616 1970738128 19.391 100 77 155 0 2033144272 37908672 24497472
23:45:04 2458 8192000000 10967521488 11376685056 1979354576 19.460 100 86 173 1 2043571712 38185552 26031584
23:45:13 2371 8192000000 10951798896 11369259008 1970851824 19.392 100 87 169 0 2034736592 38258592 25626176
23:45:24 2570 8192000000 10957621856 11372027904 1957832480 19.289 99 82 164 1 2023621792 40094192 25695120
23:45:34 6057 8192000000 10958906704 11379372032 1979426816 19.460 100 73 142 1 2039264624 37940256 21897552
23:45:48 1559 8192000000 10970316960 11380625408 1979492720 19.461 100 92 185 2 2048114976 40067200 28555056
23:45:57 4489 8192000000 10976150624 11387338752 1983130128 19.489 100 87 174 2 2050475632 39726832 27618672
23:46:09 1999 8192000000 10981807760 11393064960 1992596112 19.564 100 83 165 0 2056849376 39404608 24848656
23:46:19 2000 8192000000 10963098528 11367075840 1968440320 19.373 99 89 174 1 2031128400 36574960 26113120
23:46:29 1794 8192000000 10981923360 11390754816 1994179040 19.577 100 96 190 1 2060947888 37473264 29295584
23:46:38 2230 8192000000 10975062864 11382964224 1984935264 19.504 100 88 177 2 2049366800 37083312 27348224
23:46:49 4285 8192000000 10949606256 11370115072 1971301312 19.396 100 74 148 0 2031934512 38161136 22472064
23:47:00 3210 8192000000 10952459152 11372924928 1970709040 19.391 100 75 150 2 2033576784 39875712 22992032
23:47:11 3663 8192000000 10952328464 11380736000 1977760256 19.447 100 64 128 1 2041407456 42995136 20652064
23:47:22 8974 8192000000 10933440944 11373711360 1956572560 19.279 99 52 104 2 2014577632 41036480 16968592
23:47:43 8724 8192000000 10914108464 11347279872 1946876928 19.202 100 41 83 4 1995665616 34890240 13898448
23:47:59 14618 8192000000 10910353968 11356209152 1937695344 19.128 99 35 69 2 1988940352 39565776 11679232
23:48:20 19709 8192000000 10913941840 11344687104 1930240080 19.069 99 30 60 4 1975859568 35452080 10167408
23:48:49 5417 8192000000 10927524560 11345985536 1915195408 18.948 98 59 118 1 1969548320 35303552 19049360
23:49:02 10750 8192000000 10891571584 11329454080 1917293168 18.965 99 44 88 0 1969763872 37815216 14655488
23:49:19 24254 8192000000 10880576384 11335364608 1919252944 18.981 99 30 60 1 1964218512 34498000 10467568
23:49:51 13903 8192000000 10886639504 11327066112 1919980016 18.987 99 31 62 1 1962428624 32238208 10210400
23:50:40 35098 8192000000 10878164864 11340554240 1908387472 18.894 99 21 42 2 1950485616 34168640 7929504
23:51:27 14502 8192000000 10898103088 11344830464 1934734368 19.105 100 29 57 3 1980306832 36372880 9199584
23:51:55 25419 8192000000 10884186304 11340619776 1931138896 19.076 100 17 34 0 1973085584 35499216 6447472
23:52:27 33635 8192000000 10881487808 11344691200 1912159744 18.924 99 18 36 1 1951175104 32314400 6700960
23:53:13 39106 8192000000 10861539088 11305492480 1891664096 18.759 98 20 38 1 1911830240 14420352 5745792
23:53:59 21890 8192000000 10867897104 11307442176 1911025472 18.915 99 41 82 2 1928831600 6679168 11126960
23:54:29 42620 8192000000 10871234704 11320238080 1931518976 19.079 100 26 52 2 1950315072 11163008 7633088
23:55:18 112269 8192000000 10887072896 11343958016 1946548608 19.199 100 38 72 5 1966146432 9778800 9819024
23:57:16 92190 8192000000 10868570656 11333808128 1897542640 18.807 97 16 32 0 1919079728 17210144 4326944
00:00:12 6308 8192000000 10909119472 11346137088 1962219344 19.324 100 39 77 2 1980077360 7093568 10764448
00:00:25 31545 8192000000 10899355024 11350437888 1968962016 19.377 100 43 86 0 1991633728 10082464 12589248
00:01:04 56875 8192000000 10899295232 11350401024 1932573184 19.087 98 27 54 2 1950388848 9866496 7949168
00:02:08 33741 8192000000 10901942688 11368751104 1969600928 19.382 100 21 42 2 1994077072 17935152 6540992
00:02:49 44158 8192000000 10882113616 11361816576 1961636160 19.319 100 17 34 0 1977959184 11776208 4546816
00:03:44 37733 8192000000 10878496000 11338498048 1950089312 19.227 99 18 33 2 1963863456 9225760 4548384
00:04:29 39739 8192000000 10868308864 11335798784 1904021056 18.859 97 20 40 1 1922883952 12725936 6136960
00:05:31 33262 8192000000 10863475472 11325448192 1926305760 19.037 99 17 34 2 1947834240 15860544 5667936
00:06:11 29291 8192000000 10859896448 11327176704 1937159280 19.124 100 7 14 0 1950891632 11575088 2157264
00:06:56 63594 8192000000 10910730480 11354304512 1956708768 19.280 100 26 52 1 1974982304 10385632 7887904
00:08:08 48186 8192000000 10887439040 11348807680 1945006832 19.187 99 28 57 2 1962997648 10030048 7960768
00:09:03 25376 8192000000 10893192176 11357859840 1962612624 19.327 100 27 54 0 1979096592 8927088 7556880
00:09:47 38878 8192000000 10889041456 11360296960 1972466352 19.405 100 18 36 0 1986157488 8389808 5301328
00:11:27 73036 8192000000 10883936512 11372228608 1953975152 19.258 99 11 22 0 1966481872 9276960 3229760
00:12:54 17989 8192000000 10886912240 11372191744 1952821312 19.249 99 7 14 2 1965218752 10511792 1885648
00:13:23 53606 8192000000 10895107664 11370881024 1941071344 19.155 98 9 18 0 1957232704 12817808 3343552
00:14:25 45676 8192000000 10922774496 11376050176 1959576768 19.303 99 12 24 0 1974929776 11944976 3408032
00:15:21 68474 8192000000 10897676928 11370307584 1937832544 19.129 98 22 44 2 1960310736 15865744 6612448
00:16:36 68785 8192000000 10904497600 11368939520 1952981360 19.250 99 16 32 0 1968322032 10768144 4572528
00:17:59 30057 8192000000 10885969664 11353362432 1916554720 18.959 97 19 38 1 1932913616 10241120 6117776
00:18:48 88634 8192000000 10890629744 11371347968 1933074368 19.091 98 17 34 0 1950231280 12459584 4697328
00:20:23 35434 8192000000 10907774704 11364499456 1951919024 19.242 99 25 50 2 1970239936 11315680 7005232
00:21:05 33219 8192000000 10923695584 11382165504 1941602816 19.160 98 35 70 2 1962097680 10875808 9619056
00:22:07 61538 8192000000 10894324000 11372486656 1933170208 19.092 98 11 22 0 1951332736 14898000 3264528
00:23:17 128063 8192000000 10899836208 11393540096 1914805120 18.945 97 17 32 1 1940003712 20886944 4311648
00:25:32 118343 8192000000 10896572384 11347914752 1858029264 18.487 94 35 70 1 1878550208 10563488 9957456
00:27:39 96560 8192000000 10857457200 11337392128 1878240992 18.651 96 27 54 2 1894964960 8851456 7872512
00:29:32 28781 8192000000 10860833216 11337662464 1947603824 19.207 100 7 14 0 1956786416 7512976 1669616
00:30:17 20605 8192000000 10849142368 11324260352 1906214624 18.876 98 9 18 0 1916429440 8113024 2101792
00:30:44 15253 8192000000 10847364048 11325198336 1928504032 19.055 100 7 14 1 1943710288 13418864 1787392
00:31:05 800 8192000000 10843402800 11325460480 1924204464 19.021 100 5 10 0 1940209952 14792448 1213040
00:32:35 69452 8192000000 10846471424 11313221632 1865449216 18.547 96 13 26 0 1878655072 9539520 3666336
00:33:51 37977 8192000000 10839332752 11299528704 1831026544 18.268 95 14 28 0 1841165232 6172160 3966528
00:34:37 35025 8192000000 10841842560 11295735808 1847325568 18.400 96 29 58 1 1863948752 8234336 8388848
00:35:20 41129 8192000000 10833193200 11295703040 1855199232 18.464 97 26 52 1 1875389968 12318656 7872080
00:36:08 37533 8192000000 10831118080 11294785536 1878965616 18.657 98 23 46 3 1897397520 12166656 6265248
00:36:52 49048 8192000000 10860679360 11316367360 1883772608 18.696 98 16 32 2 1899472784 10869504 4830672
00:37:55 62577 8192000000 10866606848 11328724992 1886410640 18.717 98 10 20 0 1901078800 11944624 2723536
00:39:19 68142 8192000000 10859482944 11341680640 1915758800 18.953 99 20 41 2 1942559744 20838352 5962592
00:40:42 49636 8192000000 10853413120 11332808704 1906482896 18.878 99 15 30 0 1925842256 15120496 4238864
00:41:37 51910 8192000000 10870362496 11324751872 1890814736 18.752 98 16 32 3 1906918320 11545968 4557616
00:42:36 81082 8192000000 10887057552 11361120256 1944484176 19.183 100 23 46 0 1967585488 16459696 6641616
00:44:03 27886 8192000000 10893512464 11356528640 1899938464 18.826 97 24 48 1 1921530928 14911696 6680768
00:44:39 32700 8192000000 10907607936 11362934784 1943523216 19.175 99 44 87 2 1970145056 13625824 12996016
00:45:18 68177 8192000000 10903897408 11396608000 1962759136 19.328 100 16 32 0 1995140240 27760768 4620336
00:46:32 65236 8192000000 10912126752 11368747008 1945340224 19.189 99 23 46 3 1964433424 12868768 6224432
00:47:46 87974 8192000000 10881003232 11355549696 1949557968 19.223 99 24 47 3 1964785168 8451424 6775776
00:49:22 39634 8192000000 10893565344 11349811200 1945007440 19.187 99 40 80 0 1963884704 7441568 11435696
00:50:09 57557 8192000000 10897297904 11357757440 1953508112 19.254 99 41 84 0 1974644880 9181376 11955392
00:51:13 54126 8192000000 10874100688 11360796672 1965365424 19.349 100 22 40 1 1979025072 7016912 6642736
00:52:13 50936 8192000000 10887152128 11367989248 1969467104 19.381 100 8 14 1 1978455248 6644448 2343696
00:53:40 84636 8192000000 10901286176 11387056128 1966292000 19.356 99 12 24 1 1984406080 14416832 3697248
00:55:43 83125 8192000000 10879182272 11354624000 1913102064 18.932 97 19 38 0 1936971776 18622048 5247664
00:57:13 44450 8192000000 10882764624 11349815296 1902299840 18.845 97 9 18 1 1926850048 22090272 2459936
00:58:04 68865 8192000000 10858997232 11342712832 1879243920 18.659 96 8 17 1 1899016912 17737952 2035040
00:59:19 40868 8192000000 10896696384 11364110336 1959269680 19.300 100 15 30 0 1974003568 10603056 4130832
01:00:06 50947 8192000000 10896996976 11376545792 1957496512 19.286 99 21 42 3 1974215536 10450176 6268848
01:01:07 24304 8192000000 10919222768 11375763456 1965728576 19.352 99 30 60 0 1980530528 6079424 8722528
01:01:37 16063 8192000000 10906983664 11372040192 1943561456 19.175 98 36 72 3 1962386560 8072144 10752960
01:02:08 36284 8192000000 10915021680 11376615424 1968876576 19.377 99 38 76 0 1989546576 9708208 10961792
01:03:07 62731 8192000000 10944796432 11410976768 1994663088 19.581 100 21 42 1 2009052016 8583600 5805328
01:04:25 70907 8192000000 10920090736 11392073728 1943682000 19.176 97 13 26 1 1958083936 10811888 3590048
01:05:45 40513 8192000000 10925252752 11398545408 1961286944 19.316 98 20 40 1 1974228080 7722384 5218752
01:06:32 22325 8192000000 10935011696 11396222976 1961078272 19.315 98 36 72 1 1980399968 9387168 9934528
01:07:02 48093 8192000000 10916968912 11396755456 1976877696 19.440 99 45 90 2 2001534080 12537424 12118960
01:08:00 121715 8192000000 10916336416 11398955008 1890023264 18.746 95 12 24 0 1910561536 17143840 3394432
01:10:38 111150 8192000000 10884389120 11363557376 1856332032 18.474 94 18 36 1 1870611616 9687920 4591664
01:12:36 92731 8192000000 10827446304 11293589504 1831938656 18.275 94 17 34 0 1844373376 7472800 4961920
01:14:19 81598 8192000000 10856235824 11318038528 1800337024 18.017 93 19 38 1 1815455744 9710112 5408608
01:15:53 56528 8192000000 10842194032 11325276160 1919626848 18.984 100 30 60 1 1942712256 14142896 8942512
01:17:31 52276 8192000000 10827561520 11303813120 1857983088 18.487 97 12 24 1 1869389088 7865296 3540704
01:18:37 80529 8192000000 10833241584 11312193536 1863343648 18.530 97 12 24 1 1879653552 12838368 3471536
01:20:05 77517 8192000000 10862464576 11333988352 1892086736 18.763 98 14 28 0 1910345840 13733872 4525232
01:22:48 82323 8192000000 10860016976 11343536128 1921745312 19.001 100 12 24 1 1950727088 25672224 3309552
01:24:29 80008 8192000000 10835986272 11312648192 1836465856 18.312 95 18 36 0 1855724288 13472352 5786080
01:25:59 48386 8192000000 10857144496 11329064960 1917048768 18.963 99 24 48 1 1931615552 7355008 7211776
01:26:54 39104 8192000000 9158820848 9396240384 302203456 3.557 16 2 4 0 305281920 2665376 413088

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-03-2021 01:28:45 to 10-03-2021 01:29:16.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-03-2021 01:29:17 to 10-03-2021 01:29:19.

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          244679
MON$OLDEST_ACTIVE               244680
MON$OLDEST_SNAPSHOT             244680
MON$NEXT_TRANSACTION            244680
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                       2014016
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:256: 
:257: mscs-test-161.budzdorov.ru    Wed Mar 10 01:27:34 2021
:258:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:259: 
--- end of diff output ---

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

10.03.21 01:29:20. 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-03-10 01:29:23 No severe PSQL-related problems occured
10.03.21 01:29:24. End of report.