Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.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 17124464 kB
MemAvailable 31140512 kB
Buffers 0 kB
Cached 14538260 kB
SwapCached 4724 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-14 16:27:20
DTS_END                         2021-02-14 16:27:20.0310
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47674
TRN_ID                          234989
ATT_ID                          676
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: 9198.24 25306 1103789
customer order: creation 164.42 378 19730
customer order: refuse 13.82 371 1658
order to supplier: creation 43.78 1269 5254
order to supplier: removal 3.44 108899 413
invoice (draft): creation 43.18 3727 5181
invoice (draft): removal 53.26 807 6391
invoice accept: apply 39.92 18786 4791
invoice accept: cancel 48.61 817 5833
customer reserve: creation 3699.04 184 443885
customer reserve: removal 4801.96 61 576235
realization accept: apply 79.50 209 9540
realization accept: cancel 82.60 112 9912
payment from customer: creation 56.77 140 6812
payment from customer: removal 5.51 76 661
payment to supplier: creation 46.85 149 5622
payment to supplier: removal 3.33 74 399
service: total inventory turnovers 4.58 1513 549
service: total monetary turnovers 6.79 28 815
service: aggregate perf. data 0.87 16866 104
service: refresh index statistics 0.03 351660 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4973
TEST_TIME 2 3133
TEST_TIME 3 4985
TEST_TIME 4 4724
TEST_TIME 5 4645
TEST_TIME 6 4890
TEST_TIME 7 4950
TEST_TIME 8 5098
TEST_TIME 9 5278
TEST_TIME 10 5305
TEST_TIME 11 5504
TEST_TIME 12 5680
TEST_TIME 13 5663
TEST_TIME 14 5822
TEST_TIME 15 5850
TEST_TIME 16 6609
TEST_TIME 17 7151
TEST_TIME 18 7379
TEST_TIME 19 8132
TEST_TIME 20 8061
TEST_TIME 21 8441
TEST_TIME 22 8587
TEST_TIME 23 8789
TEST_TIME 24 8649
TEST_TIME 25 8911
TEST_TIME 26 9363
TEST_TIME 27 10065
TEST_TIME 28 10895
TEST_TIME 29 10995
TEST_TIME 30 10988
TEST_TIME 31 10949
TEST_TIME 32 10882
TEST_TIME 33 10687
TEST_TIME 34 10502
TEST_TIME 35 10299
TEST_TIME 36 10235
TEST_TIME 37 10155
TEST_TIME 38 10046
TEST_TIME 39 9839
TEST_TIME 40 9853
TEST_TIME 41 9833
TEST_TIME 42 9912
TEST_TIME 43 9777
TEST_TIME 44 9616
TEST_TIME 45 9554
TEST_TIME 46 9421
TEST_TIME 47 9579
TEST_TIME 48 9754
TEST_TIME 49 9661
TEST_TIME 50 9525
TEST_TIME 51 9369
TEST_TIME 52 9391
TEST_TIME 53 9345
TEST_TIME 54 9278
TEST_TIME 55 9228
TEST_TIME 56 9085
TEST_TIME 57 9045
TEST_TIME 58 9184
TEST_TIME 59 9103
TEST_TIME 60 9238
TEST_TIME 61 9266
TEST_TIME 62 9325
TEST_TIME 63 9287
TEST_TIME 64 9436
TEST_TIME 65 9401
TEST_TIME 66 9374
TEST_TIME 67 9394
TEST_TIME 68 9415
TEST_TIME 69 9525
TEST_TIME 70 9532
TEST_TIME 71 9602
TEST_TIME 72 9504
TEST_TIME 73 9401
TEST_TIME 74 9482
TEST_TIME 75 9391
TEST_TIME 76 9394
TEST_TIME 77 9345
TEST_TIME 78 9289
TEST_TIME 79 9283
TEST_TIME 80 9254
TEST_TIME 81 9203
TEST_TIME 82 9146
TEST_TIME 83 9112
TEST_TIME 84 9084
TEST_TIME 85 9107
TEST_TIME 86 9085
TEST_TIME 87 9071
TEST_TIME 88 9141
TEST_TIME 89 9124
TEST_TIME 90 9102
TEST_TIME 91 9121
TEST_TIME 92 9234
TEST_TIME 93 9229
TEST_TIME 94 9298
TEST_TIME 95 9353
TEST_TIME 96 9398
TEST_TIME 97 9402
TEST_TIME 98 9379
TEST_TIME 99 9407
TEST_TIME 100 9351
TEST_TIME 101 9301
TEST_TIME 102 9250
TEST_TIME 103 9251
TEST_TIME 104 9215
TEST_TIME 105 9227
TEST_TIME 106 9209
TEST_TIME 107 9170
TEST_TIME 108 9205
TEST_TIME 109 9174
TEST_TIME 110 9182
TEST_TIME 111 9150
TEST_TIME 112 9186
TEST_TIME 113 9145
TEST_TIME 114 9179
TEST_TIME 115 9183
TEST_TIME 116 9228
TEST_TIME 117 9220
TEST_TIME 118 9274
TEST_TIME 119 9259
TEST_TIME 120 9200

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 14-02-2021 16:28:05 to 14-02-2021 16:28:09.

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 1515341 1515341 0 0.00 0 20022 6 0 0
doc_list_biud 1515340 1515340 0 0.00 0 38558 29 0 0
sp_add_invoice_to_stock 4951 4791 160 3.23 28 150153 18786 0 160
sp_cancel_adding_invoice 5833 5833 0 0.00 4 63897 817 0 0
sp_cancel_client_order 1658 1658 0 0.00 4 10713 372 0 0
sp_cancel_customer_reserve 576235 576235 0 0.00 1 23051 62 0 0
sp_cancel_pay_from_customer 661 661 0 0.00 2 3571 76 0 0
sp_cancel_pay_to_supplier 399 399 0 0.00 2 1741 75 0 0
sp_cancel_supplier_invoice 6402 6391 11 0.17 1 38562 807 0 11
sp_cancel_supplier_order 413 413 0 0.00 5 1123511 108900 0 0
sp_cancel_write_off 9912 9912 0 0.00 1 6877 113 0 0
sp_client_order 19730 19730 0 0.00 3 15897 378 0 0
sp_customer_reserve 443885 443885 0 0.00 0 29392 185 0 0
sp_fill_shopping_cart 30157 30157 0 0.00 1 32483 45 0 0
sp_fill_shopping_cart_clo_res 443880 443880 0 0.00 0 14959 14 0 0
sp_get_clo_for_invoice 4784 4784 0 0.00 0 37943 376 0 0
sp_kill_cost_storno 16805 16805 0 0.00 0 9478 58 0 0
sp_kill_qstorno_ret_qs2qd 1169186 1169186 0 0.00 0 38551 33 0 0
sp_kill_qty_storno 614765 614765 0 0.00 0 38558 72 0 0
sp_lock_selected_doc 19857 19857 0 0.00 0 8104 6 0 0
sp_make_cost_storno 26758 26758 0 0.00 0 19994 65 0 0
sp_multiply_rows_for_pdistr 26757 26757 0 0.00 0 16764 31 0 0
sp_multiply_rows_for_qdistr 19730 19730 0 0.00 0 13335 158 0 0
sp_pay_from_customer 6812 6812 0 0.00 4 19393 140 0 0
sp_pay_to_supplier 5622 5622 0 0.00 5 18795 150 0 0
sp_payment_common 12434 12434 0 0.00 1 16788 41 0 0
sp_qd_handle_on_cancel_clo 1658 1658 0 0.00 0 10705 348 0 0
sp_qd_handle_on_invoice_upd_sts 10617 10617 0 0.00 0 16307 348 0 0
sp_qd_handle_on_reserve_upd_sts 9539 9539 0 0.00 0 19712 75 0 0
sp_reserve_write_off 9540 9540 0 0.00 6 20033 209 0 0
sp_supplier_invoice 5181 5181 0 0.00 6 91135 3727 0 0
sp_supplier_order 5254 5254 0 0.00 5 26620 1269 0 0
srv_aggregate_perf_data 104 104 0 0.00 2923 116466 16866 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1152 150268 32789 0 0
srv_find_qd_qs_mism 1058308 1058308 0 0.00 0 10126 5 0 0
srv_make_invnt_saldo 549 549 0 0.00 34 143439 1514 0 0
srv_make_money_saldo 815 815 0 0.00 0 873 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 182991 450077 351660 0 0
t$perf-abend:sp_add_invoice_to_stock 160 160 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4792 4792 0 0.00 0 19143 222 0 0
t$perf-norm:sp_cancel_adding_invoice 408 408 0 0.00 0 10720 128 0 0
t$perf-norm:sp_cancel_client_order 1658 1658 0 0.00 0 6665 16 0 0
t$perf-norm:sp_cancel_customer_reserve 651 651 0 0.00 0 5099 25 0 0
t$perf-norm:sp_cancel_pay_from_customer 661 661 0 0.00 0 3416 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 399 399 0 0.00 0 1548 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 949 20 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 35797 1689 0 0
t$perf-norm:sp_cancel_write_off 934 934 0 0.00 0 1274 7 0 0
t$perf-norm:sp_client_order 19730 19730 0 0.00 0 18283 25 0 0
t$perf-norm:sp_customer_reserve 965 965 0 0.00 0 19149 33 0 0
t$perf-norm:sp_pay_from_customer 6812 6812 0 0.00 0 6426 12 0 0
t$perf-norm:sp_pay_to_supplier 5622 5622 0 0.00 0 15285 18 0 0
t$perf-norm:sp_reserve_write_off 9540 9540 0 0.00 0 11593 18 0 0
t$perf-norm:sp_supplier_invoice 5181 5181 0 0.00 0 11389 20 0 0
t$perf-norm:sp_supplier_order 5254 5254 0 0.00 0 4061 20 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 670 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 6310 45 0 0
t$perf-norm:srv_make_invnt_saldo 549 549 0 0.00 0 3695 24 0 0
t$perf-norm:srv_make_money_saldo 815 815 0 0.00 0 5413 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 20 8 0 0
v_add_invoice_to_stock 9884 9564 320 3.23 0 4141 17 0 320
v_all_customers 35674 35674 0 0.00 0 22 1 0 0
v_all_suppliers 28960 28960 0 0.00 0 17 1 0 0
v_all_wares 39460 39460 0 0.00 0 140 1 0 0
v_cancel_adding_invoice 816 816 0 0.00 0 544 6 0 0
v_cancel_client_order 3316 3316 0 0.00 0 2655 4 0 0
v_cancel_customer_prepayment 1322 1322 0 0.00 0 3530 6 0 0
v_cancel_customer_reserve 1302 1302 0 0.00 0 421 4 0 0
v_cancel_payment_to_supplier 798 798 0 0.00 0 1726 5 0 0
v_cancel_supplier_invoice 846 824 22 2.60 0 670 16 0 22
v_cancel_supplier_order 826 826 0 0.00 0 519 4 0 0
v_cancel_write_off 1868 1868 0 0.00 0 3677 16 0 0
v_max_id_clo_ord 5254 5254 0 0.00 0 946 1 0 0
v_max_id_clo_res 965 965 0 0.00 0 1973 8 0 0
v_max_id_ord_sup 5173 5173 0 0.00 0 7630 5 0 0
v_max_non_paid_invoice 1569 1569 0 0.00 0 527 2 0 0
v_max_non_paid_realizn 3735 3735 0 0.00 0 3496 5 0 0
v_min_id_clo_ord 5254 5254 0 0.00 0 8425 8 0 0
v_min_id_clo_res 965 965 0 0.00 0 1738 6 0 0
v_min_id_ord_sup 5173 5173 0 0.00 0 4495 7 0 0
v_min_non_paid_invoice 5622 5622 0 0.00 0 16622 28 0 0
v_min_non_paid_realizn 6812 6812 0 0.00 0 16733 23 0 0
v_our_firm 9940 9940 0 0.00 0 25 1 0 0
v_reserve_write_off 19078 19078 0 0.00 0 5095 5 0 0
x_lock_depdocs_on_canc_invoice 11812 11812 0 0.00 0 26304 131 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 18435 405 0 0
x_make_qstorno_1000_1200 5254 5254 0 0.00 1 26539 1179 0 0
x_make_qstorno_1200_2000 5181 5181 0 0.00 2 77393 3559 0 0
x_make_qstorno_2100_3300 443883 443883 0 0.00 0 29319 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-02-2021 16:28:10 to 14-02-2021 16:28:14.

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:23 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 17712 8192000000 10244677408 10548723712 924577056 10.141 74 51 102 1 943589616 2391664 16620896
13:57:57 28729 8192000000 10322546240 10639618048 1378572880 14.404 100 84 168 0 1410640096 4614080 27453136
13:58:34 11382 8192000000 10351780304 10671091712 1407381296 14.661 100 86 173 0 1442198304 5858848 28958160
13:58:55 33192 8192000000 10389942000 10713473024 1435205808 14.907 100 88 176 0 1470683520 6637808 28839904
13:59:39 15337 8192000000 10408711728 10736934912 1459434928 15.121 100 85 170 0 1493620720 6948976 27236816
14:00:01 24913 8192000000 10427261120 10757832704 1485083232 15.346 100 87 174 0 1521110512 7992528 28034752
14:00:35 16680 8192000000 10430932224 10765131776 1493151312 15.416 100 88 176 0 1529902272 8468752 28282208
14:01:02 14919 8192000000 10458583184 10792501248 1509904240 15.562 100 86 172 0 1545612224 8720720 26987264
14:01:28 19155 8192000000 10464360016 10806931456 1529956896 15.737 100 83 166 0 1564584832 8880528 25747408
14:02:01 17810 8192000000 10513065616 10866393088 1568648640 16.071 100 73 145 2 1599642592 8813952 22180000
14:02:37 12786 8192000000 10557412480 10913517568 1617800672 16.491 100 81 162 0 1652047168 10076736 24169760
14:02:59 9310 8192000000 10573071312 10933137408 1636048960 16.646 100 80 160 0 1671220272 10973360 24197952
14:03:18 12568 8192000000 10604019392 10967879680 1667635600 16.913 100 83 166 1 1704296160 11906144 24754416
14:03:41 8611 8192000000 10627443728 10994139136 1681018000 17.026 100 82 164 0 1718789936 12814352 24957584
14:03:58 12391 8192000000 10638332624 11009925120 1697709968 17.166 100 81 161 1 1734630912 13319536 23601408
14:04:19 7935 8192000000 10648638640 11020029952 1714493840 17.306 100 81 162 0 1751702544 13529088 23679616
14:04:36 8796 8192000000 10670447712 11041820672 1726000640 17.402 100 76 152 2 1761479152 13329024 22149488
14:04:53 4464 8192000000 10679157536 11052867584 1738007072 17.502 100 81 162 0 1774937040 13748544 23181424
14:05:04 6356 8192000000 10689564656 11063828480 1747798544 17.583 100 84 168 1 1785914112 14290016 23825552
14:05:17 6214 8192000000 10700635968 11073544192 1756542144 17.656 100 84 168 2 1794307920 14542768 23223008
14:05:30 3799 8192000000 10700894256 11078807552 1765835200 17.733 100 83 165 2 1802886320 14111744 22939376
14:05:41 3979 8192000000 10715894080 11092869120 1774399072 17.803 100 82 163 1 1809404448 12895664 22109712
14:05:51 3851 8192000000 10720076880 11094839296 1783207376 17.876 100 84 166 4 1820157584 13577632 23372576
14:06:01 2925 8192000000 10733835840 11113230336 1788197584 17.917 100 91 180 2 1827409344 13959968 25251792
14:06:10 3335 8192000000 10736489088 11116523520 1798620608 18.003 100 83 166 1 1836043760 13663008 23760144
14:06:21 2729 8192000000 10739150000 11120963584 1800526592 18.018 100 86 169 1 1837422752 13402064 23494096
14:06:30 2833 8192000000 10751113376 11128623104 1805600480 18.060 100 88 176 2 1843702592 13931776 24170336
14:06:39 1836 8192000000 10749439248 11133095936 1812787120 18.119 100 87 174 0 1851381712 13054032 25540560
14:06:48 9276 8192000000 10755142592 11144130560 1816212336 18.147 100 72 142 1 1849181936 13370832 19598768
14:07:04 4149 8192000000 10771564784 11161321472 1826888416 18.234 100 83 166 1 1863893264 13875776 23129072
14:07:15 1798 8192000000 10788613504 11169173504 1839030048 18.333 100 91 183 2 1878199920 13799968 25369904
14:07:23 1593 8192000000 10789842304 11176681472 1847352192 18.401 100 92 184 3 1885852272 12472240 26027840
14:07:32 1633 8192000000 10791926656 11179069440 1849002928 18.414 100 88 175 0 1887853104 14455728 24394448
14:07:40 1423 8192000000 10792310704 11183144960 1855495408 18.467 100 90 178 2 1894487088 13589376 25402304
14:07:48 1741 8192000000 10805452224 11189260288 1858209792 18.489 100 87 171 0 1896054432 12364992 25479648
14:07:56 1590 8192000000 10798082336 11187494912 1862773616 18.526 100 97 196 1 1903497840 12731568 27992656
14:08:03 2331 8192000000 10806722848 11196379136 1862485888 18.523 100 87 174 0 1899745680 12919376 24340416
14:08:12 1307 8192000000 10814519200 11200036864 1865183552 18.545 100 92 186 0 1905474768 14221728 26069488
14:08:20 25246 8192000000 10787544896 11188584448 1860456096 18.507 100 49 98 2 1884843568 10188960 14198512
14:08:52 18051 8192000000 10805996816 11198038016 1868133360 18.569 100 79 155 2 1896644064 6945392 21565312
14:09:16 17503 8192000000 10783079664 11198656512 1866570672 18.557 100 59 117 2 1893542336 9636640 17335024
14:09:43 7545 8192000000 10768960976 11195215872 1864953584 18.543 100 38 76 1 1883474384 6998560 11522240
14:09:59 2301 8192000000 10789530048 11201347584 1869440528 18.580 100 64 130 2 1894818144 7431280 17946336
14:10:13 4999 8192000000 10782690064 11207729152 1871832160 18.599 100 36 72 2 1889626704 8307968 9486576
14:10:27 6565 8192000000 10784589968 11212689408 1874304832 18.619 100 21 42 2 1887408816 6778032 6325952
14:10:40 4424 8192000000 10804795520 11220951040 1886991056 18.722 100 37 73 0 1903787344 6733456 10062832
14:10:52 8605 8192000000 10792526208 11219894272 1881749296 18.679 100 18 36 3 1892686656 6025360 4912000
14:11:08 4332 8192000000 10796371792 11226726400 1884917968 18.705 100 25 50 1 1903217632 11029408 7270256
14:11:19 5512 8192000000 10798636576 11223396352 1887870528 18.729 100 31 62 4 1903672368 6250336 9551504
14:11:33 14945 8192000000 10790778128 11223887872 1890475520 18.750 100 20 39 1 1902582496 5752208 6354768
14:11:56 14903 8192000000 10795163040 11229999104 1891131728 18.755 100 10 20 1 1898890000 5605312 2152960
14:12:17 10970 8192000000 10810039792 11237298176 1896012032 18.794 100 19 38 1 1906922976 5328800 5582144
14:12:34 9363 8192000000 10810840912 11243769856 1907098544 18.883 100 17 34 1 1918056496 5681520 5276432
14:12:49 12666 8192000000 10814380816 11248361472 1906747024 18.881 100 15 30 0 1917190608 5842656 4600928
14:13:13 66554 8192000000 10821742752 11253424128 1915153568 18.948 100 38 76 1 1932602048 5823408 11625072
14:14:28 8920 8192000000 10825447808 11256893440 1909686848 18.904 100 30 60 2 1924783824 7077040 8019936
14:14:45 5711 8192000000 10824971232 11256672256 1910838928 18.913 100 33 66 2 1927714832 7122032 9753872
14:14:57 5138 8192000000 10831783328 11262951424 1915827392 18.953 100 45 91 0 1936945152 7720608 13397152
14:15:09 4167 8192000000 10828153264 11261833216 1912951808 18.930 100 27 55 3 1927057472 5661424 8444240
14:15:22 5518 8192000000 10820080848 11258593280 1914234448 18.941 100 29 58 3 1928547104 6246688 8065968
14:15:37 5785 8192000000 10820679520 11260420096 1912188912 18.924 100 27 54 0 1930471008 10635104 7646992
14:15:49 6319 8192000000 10823707872 11254534144 1890969680 18.754 99 26 52 2 1904845392 6603776 7271936
14:16:03 11726 8192000000 10821867616 11255578624 1904749872 18.864 100 9 18 0 1912505120 5482000 2273248
14:16:23 10616 8192000000 10815466160 11247742976 1872023808 18.601 98 15 30 1 1882242720 6013872 4205040
14:16:43 5099 8192000000 10815295632 11245559808 1889671696 18.743 99 33 67 0 1905757360 6418752 9666912
14:16:56 8032 8192000000 10767471088 11197530112 1831429328 18.271 97 20 39 1 1842283952 5422640 5431984
14:17:11 6934 8192000000 10772487536 11199750144 1817764384 18.159 97 18 36 0 1828613872 5467232 5382256
14:17:28 10547 8192000000 10783828272 11212693504 1849469312 18.418 99 24 48 4 1861259216 5469744 6320160
14:17:45 59713 8192000000 10771000832 11190214656 1759284336 17.678 94 28 56 1 1772396096 4805456 8306304
14:18:51 19494 8192000000 10716666432 11145261056 1686529312 17.072 91 23 46 4 1698166528 5604672 6032544
14:19:22 7346 8192000000 10751717488 11173183488 1812745136 18.118 99 25 50 2 1826852304 6032688 8074480
14:19:36 6571 8192000000 10747418032 11172077568 1833109248 18.285 100 28 56 2 1848744608 7568560 8066800
14:19:49 5795 8192000000 10742599040 11157688320 1786971632 17.907 97 22 44 0 1798474896 5135616 6367648
14:20:02 6632 8192000000 10709600768 11118157824 1701749200 17.200 93 34 68 2 1718819088 5478960 11590928
14:20:21 6926 8192000000 10699811536 11110318080 1749617088 17.598 97 28 56 1 1764102656 6673168 7812400
14:20:35 6976 8192000000 10720193360 11129044992 1777258672 17.827 99 25 50 1 1790376192 5678080 7439440
14:20:50 6884 8192000000 10697934032 11114840064 1760332208 17.687 98 28 56 3 1774237232 5560768 8344256
14:21:04 8112 8192000000 10707207648 11114360832 1735305920 17.480 96 21 40 1 1746618016 5103872 6208224
14:21:19 13026 8192000000 10722004480 11136036864 1737530064 17.498 96 26 50 2 1750695712 5272976 7892672
14:21:38 14498 8192000000 10675926080 11094319104 1705139520 17.228 95 15 30 1 1714669600 4769584 4760496
14:21:59 13641 8192000000 10721256544 11137294336 1782767536 17.872 99 26 52 2 1795835728 4877232 8190960
14:22:22 7270 8192000000 10733445648 11152293888 1817209824 18.155 100 29 60 1 1836440320 10642768 8587728
14:22:40 18021 8192000000 10726511728 11147325440 1809496480 18.092 99 25 48 1 1822280496 5804384 6979632
14:23:10 41298 8192000000 10791284304 11179241472 1846039952 18.390 100 73 148 2 1874091376 5220064 22831360
14:23:58 13068 8192000000 10754212560 11181182976 1836285792 18.311 100 16 31 1 1846421712 5634320 4501600
14:24:19 10373 8192000000 10755026080 11176243200 1824929584 18.218 99 23 46 0 1837007744 5950240 6127920
14:24:35 3439 8192000000 10755883472 11180240896 1844128576 18.374 100 37 74 1 1862452096 7744880 10578640
14:24:49 5602 8192000000 10771564096 11187101696 1848566080 18.410 100 40 80 1 1867648304 8053808 11028416
14:25:04 8156 8192000000 10761133664 11187077120 1846629264 18.395 100 19 38 2 1857727856 6040368 5058224
14:25:18 7953 8192000000 10759514384 11190280192 1853044288 18.447 100 31 62 2 1868644384 6369424 9230672
14:25:38 9526 8192000000 10763059792 11192606720 1852272576 18.441 100 16 32 0 1861688656 5155632 4260448
14:25:56 5572 8192000000 10777186832 11200024576 1859407312 18.498 100 29 57 0 1873549360 5892384 8249664
14:26:08 9333 8192000000 10768040560 11201904640 1862240752 18.521 100 31 62 0 1877807680 6603808 8963120
14:26:24 9449 8192000000 10789156976 11213742080 1862548800 18.524 100 17 34 0 1872935056 5357568 5028688
14:26:40 8654 8192000000 10781013424 11213291520 1866929648 18.559 100 25 50 0 1884795056 10147632 7717776
14:26:56 12328 8192000000 10783072144 11212558336 1872915856 18.608 100 19 38 1 1884376256 5966816 5493584
14:27:15 8643 8192000000 10816543168 11238760448 1888301072 18.732 100 24 48 1 1912549424 18332112 5916240
14:27:31 12973 8192000000 10834235472 11247833088 1898758096 18.816 100 42 82 1 1916182608 5444480 11980032
14:27:55 47727 8192000000 10841352272 11261227008 1912511920 18.927 100 51 101 3 1937006352 9554656 14939776
14:28:56 76066 8192000000 10859728656 11284041728 1919955728 18.986 100 43 86 1 1945914864 13102368 12856768
14:30:20 17556 8192000000 10866708032 11297443840 1934786304 19.105 100 52 104 2 1967672400 17051776 15834320
14:30:45 6195 8192000000 10875152032 11302440960 1939564000 19.143 100 48 96 1 1972497664 18809888 14123776
14:31:02 10291 8192000000 10881265680 11309072384 1944140336 19.180 100 54 104 1 1975570720 16359584 15070800
14:31:31 9319 8192000000 10887598608 11315740672 1949287696 19.221 100 56 111 1 1985942080 21044384 15610000
14:31:48 22089 8192000000 10891029472 11320086528 1954304672 19.261 100 49 97 0 1985598880 16904896 14389312
14:32:20 16331 8192000000 10906088224 11329966080 1959151440 19.299 100 49 96 2 1990890608 17556032 14183136
14:32:44 23268 8192000000 10909561328 11336101888 1964768656 19.344 100 54 105 0 1998407184 18139840 15498688
14:33:24 12404 8192000000 10900580416 11334684672 1963972112 19.338 100 47 94 0 1999475888 21141312 14362464
14:33:43 6856 8192000000 10913970848 11339526144 1969112400 19.378 100 52 104 0 2004289040 20124432 15052208
14:33:58 7024 8192000000 10930857872 11351195648 1978123216 19.450 100 72 143 2 2022095648 22215200 21757232
14:34:13 13697 8192000000 10929663664 11353939968 1963305712 19.332 99 72 143 0 2007936512 23370000 21260800
14:34:40 7603 8192000000 10936514992 11353055232 1975031440 19.425 100 72 144 1 2021876416 25827232 21017744
14:34:58 18763 8192000000 10936308656 11358486528 1981245376 19.475 100 66 132 2 2027456784 27477936 18733472
14:35:24 8743 8192000000 10954251264 11373596672 1986959520 19.520 100 59 118 1 2035132928 30635968 17537440
14:35:41 16989 8192000000 10951868048 11376115712 1991836416 19.558 100 64 125 2 2039688800 29342080 18510304
14:36:07 4721 8192000000 10942123712 11372961792 1993346256 19.570 100 60 120 0 2041337184 30056544 17934384
14:36:19 4588 8192000000 10953778016 11380940800 1996950400 19.599 100 61 122 2 2045294320 30194640 18149280
14:36:49 9821 8192000000 10951934656 11384090624 1996916832 19.598 100 57 112 0 2046324704 32752640 16655232
14:37:07 14961 8192000000 10966423792 11399012352 2003693056 19.652 100 56 112 3 2055784656 35373600 16718000
14:37:29 3129 8192000000 10971526896 11403268096 2009339376 19.696 100 64 129 1 2064644608 36529232 18776000
14:37:45 7085 8192000000 10967159040 11392352256 1997745568 19.605 100 69 137 1 2055665344 37281488 20638288
14:38:02 6224 8192000000 10964762384 11401052160 2004256176 19.656 100 52 102 2 2059863360 39536544 16070640
14:38:17 2776 8192000000 10966978096 11392679936 1998201360 19.609 100 68 136 1 2055454352 37308160 19944832
14:38:28 3728 8192000000 10976320304 11398803456 2002346224 19.641 100 67 134 0 2062488560 39690800 20451536
14:38:40 5047 8192000000 10983968528 11397230592 2001271584 19.633 100 82 162 2 2065740704 40371616 24097504
14:38:52 2048 8192000000 10978799392 11391717376 1982529008 19.485 99 76 149 3 2045115024 40100528 22485488
14:39:01 4583 8192000000 10950563184 11377246208 1978972832 19.457 100 65 130 1 2039911088 41095872 19842384
14:39:14 2091 8192000000 10977425872 11387396096 1992185984 19.561 100 84 165 3 2058210864 40378848 25646032
14:39:24 1922 8192000000 10970159136 11386081280 1990478784 19.548 100 79 155 6 2054163408 40503504 23181120
14:39:33 3326 8192000000 10977155136 11393294336 1998736752 19.613 100 82 162 1 2065542448 42217632 24588064
14:39:45 9205 8192000000 10985171280 11399307264 2003099840 19.647 100 77 156 0 2070152752 43091376 23961536
14:40:04 5008 8192000000 10992375616 11413245952 2005695760 19.668 100 66 132 1 2073143440 47605280 19842400
14:40:18 5491 8192000000 10992992704 11417026560 1994327840 19.578 99 73 146 1 2061538048 44113456 23096752
14:40:34 4748 8192000000 10982390128 11403014144 1998212560 19.609 100 73 144 2 2066851824 45594848 23044416
14:40:48 11621 8192000000 10944356192 11362840576 1957540448 19.286 99 66 132 0 2024793600 45625072 21628080
14:41:10 3743 8192000000 10974559024 11395178496 1988803184 19.534 100 77 153 0 2061799920 49517616 23479120
14:41:20 1989 8192000000 10982535600 11399528448 1991430256 19.555 100 78 154 2 2063424768 48691232 23303280
14:41:29 4120 8192000000 10972280272 11392589824 1987323424 19.523 100 76 151 1 2060597632 49749936 23524272
14:41:43 2187 8192000000 10985714496 11399999488 1987999184 19.528 100 83 163 3 2064796976 51658448 25139344
14:41:52 3914 8192000000 10982065760 11406663680 1996360272 19.594 100 77 155 1 2075041984 53250288 25431424
14:42:07 6146 8192000000 10964408272 11385401344 1950838416 19.233 98 83 167 1 2032412432 54248208 27325808
14:42:26 8765 8192000000 10971907664 11399983104 1982374016 19.483 100 69 139 1 2061519376 56853760 22291600
14:42:48 3991 8192000000 10979271328 11403067392 1976963168 19.441 99 83 165 2 2064348800 60238208 27147424
14:43:01 4723 8192000000 10980407680 11397349376 1960547952 19.310 99 80 159 0 2052178736 66783376 24847408
14:43:20 3202 8192000000 10972230256 11394510848 1964803024 19.344 99 71 138 1 2046535696 58347664 23385008
14:43:29 6664 8192000000 10960372896 11379658752 1962572736 19.326 99 77 149 1 2049499328 63193104 23733488
14:43:43 4383 8192000000 10970832512 11392536576 1962627344 19.327 99 73 143 3 2045028768 60029536 22371888
14:43:57 3704 8192000000 10964100560 11373920256 1961146736 19.315 100 80 160 1 2047309424 60877744 25284944
14:44:09 5321 8192000000 10971695632 11389034496 1971484704 19.397 100 84 166 1 2056162784 58810224 25867856
14:44:22 4063 8192000000 10965998656 11377811456 1952227776 19.244 99 83 162 1 2035465328 58799456 24438096
14:44:34 1274 8192000000 10988601376 11396026368 1961150416 19.315 99 85 170 0 2047853760 60522560 26180784
14:44:42 1967 8192000000 10963677440 11378720768 1962978688 19.330 99 83 166 2 2049251680 59959056 26313936
14:44:51 1997 8192000000 10940038512 11346669568 1914122048 18.940 97 86 169 4 2000973072 59706192 27144832
14:45:00 1656 8192000000 10967456720 11375579136 1965823312 19.352 100 88 174 0 2048616784 56097504 26695968
14:45:08 1151 8192000000 10971888240 11380391936 1970821152 19.392 100 89 177 0 2051611216 53255984 27534080
14:45:16 3167 8192000000 10974095248 11389743104 1979012080 19.457 100 79 158 1 2057708784 53995536 24701168
14:45:26 2404 8192000000 10971095984 11379183616 1954359872 19.261 99 90 182 0 2036981840 55279232 27342736
14:45:35 2483 8192000000 10968689504 11381256192 1968674576 19.375 100 85 167 1 2050985920 57348144 24963200
14:45:45 3635 8192000000 10975484608 11391991808 1971595968 19.398 100 78 154 2 2053294304 57272240 24426096
14:45:55 4162 8192000000 10986084000 11399286784 1978984416 19.457 100 89 177 1 2065092544 59320464 26787664
14:46:10 2285 8192000000 10986602864 11403120640 1978393776 19.452 100 79 158 0 2065591072 61636048 25561248
14:46:21 1443 8192000000 10998581264 11412869120 1988609968 19.533 100 89 177 0 2078107136 62222768 27274400
14:46:31 3250 8192000000 10966905104 11391053824 1963338480 19.333 99 77 154 0 2044286352 56413904 24533968
14:46:59 8943 8192000000 10918909488 11355815936 1941534176 19.159 99 40 80 0 2004322576 49695648 13092752
14:47:27 8184 8192000000 10935658592 11376611328 1959919232 19.305 100 46 92 2 2025365792 50064576 15381984
14:47:50 12057 8192000000 10937035296 11370090496 1940058864 19.147 99 39 78 1 2005289120 51741568 13488688
14:48:16 19059 8192000000 10916599168 11352866816 1928077312 19.052 99 41 82 0 1996346400 54688288 13580800
14:48:47 27738 8192000000 10914875408 11354488832 1921783456 19.001 99 30 59 2 1981804688 49822752 10198480
14:49:22 17011 8192000000 10925573712 11357192192 1922346912 19.006 99 35 69 1 1987832560 53580432 11905216
14:49:47 11982 8192000000 10930983808 11371225088 1948789792 19.217 100 41 82 3 2014340096 52214288 13336016
14:50:10 18589 8192000000 10932552512 11374235648 1950508160 19.231 100 30 60 1 2011872224 51309776 10054288
14:50:35 7666 8192000000 10930486704 11372199936 1951627456 19.239 100 34 69 1 2013505296 50155440 11722400
14:50:53 4976 8192000000 10932966400 11383091200 1955628976 19.271 100 41 80 3 2020548928 51245696 13674256
14:51:09 14083 8192000000 10927931376 11369746432 1920311472 18.989 98 33 66 2 1982646576 50953776 11381328
14:51:33 15373 8192000000 10936957472 11381092352 1953086736 19.251 100 36 72 0 2020943424 55278272 12578416
14:51:56 12017 8192000000 10949378576 11397996544 1962335360 19.325 100 44 88 1 2035236960 57920960 14980640
14:52:16 14471 8192000000 10942612832 11392643072 1961573696 19.319 100 27 54 1 2026371744 54943152 9854896
14:52:52 25003 8192000000 10954225824 11416465408 1968522304 19.374 100 24 48 1 2036964704 59644192 8798208
14:53:39 34313 8192000000 10935124608 11404759040 1926931072 19.042 98 28 56 0 1998965072 62477920 9556080
14:54:21 32255 8192000000 10905327648 11368349696 1921396272 18.998 99 17 34 0 1973040016 45457472 6186272
14:54:59 48093 8192000000 10884468384 11353833472 1893265520 18.772 98 16 32 0 1951054464 52052624 5736320
14:56:08 62301 8192000000 10900393840 11340120064 1940040496 19.147 100 23 46 0 1964645904 17880784 6724624
14:57:27 55896 8192000000 10871972288 11318648832 1907241040 18.884 98 30 60 2 1934537648 18520048 8776560
14:58:29 28779 8192000000 10871882320 11338055680 1939533408 19.143 100 18 36 1 1962473648 18055088 4885152
14:59:26 53853 8192000000 10876336208 11335720960 1932472432 19.087 99 18 37 0 1943013744 5849568 4691744
15:00:28 64052 8192000000 10869983360 11322118144 1912389488 18.926 98 20 40 0 1925803872 7906080 5508304
15:01:39 45847 8192000000 10862045520 11322118144 1929569344 19.063 99 12 24 1 1940943520 8515264 2858912
15:02:31 9253 8192000000 10870141536 11329024000 1949099040 19.219 100 10 20 0 1961629456 9685536 2844880
15:04:07 37041 8192000000 10876497120 11341365248 1927952656 19.051 98 19 39 2 1942487440 9561728 4973056
15:05:09 109920 8192000000 10903876720 11354947584 1965579504 19.350 100 36 72 2 1990401520 13703680 11118336
15:07:06 54432 8192000000 10897261056 11365167104 1942737136 19.169 98 26 52 2 1964685456 14366032 7582288
15:08:06 150268 8192000000 10880487328 11350728704 1857426064 18.482 94 15 30 1 1877757840 15939264 4392512
15:10:43 63701 8192000000 10877506928 11332427776 1949021952 19.219 99 24 48 0 1966227744 10631312 6574480
15:11:54 5014 8192000000 10901356608 11349852160 1969174432 19.379 100 44 87 0 1993946720 11799120 12973168
15:12:06 10600 8192000000 10939601696 11375833088 1988327824 19.531 100 61 123 2 2024785120 17658656 18798640
15:12:25 23321 8192000000 10919105280 11380326400 1985416784 19.508 100 29 58 0 2013475440 19340032 8718624
15:13:04 65773 8192000000 10943785936 11397414912 1990654560 19.549 100 34 68 1 2022045920 21445040 9946320
15:14:46 40964 8192000000 10902853440 11376910336 1969051408 19.378 99 24 48 0 1996032112 19762768 7217936
15:15:35 42308 8192000000 10888258000 11381719040 1968009536 19.370 100 11 22 0 1988312272 17547872 2754864
15:16:23 13402 8192000000 10888209344 11374645248 1968960720 19.377 100 4 8 0 1986129728 16063536 1105472
15:16:43 63043 8192000000 10882119456 11354398720 1932305376 19.085 98 7 14 0 1944752160 10697872 1748912
15:18:25 99438 8192000000 10886867760 11368214528 1947293696 19.205 98 29 57 1 1964362736 7858784 9210256
15:20:15 50858 8192000000 10887922608 11350294528 1919030768 18.979 97 30 60 0 1934363536 7513568 7819200
15:21:13 19525 8192000000 10909046880 11368132608 1974418784 19.420 100 25 48 1 1990031552 9189856 6422912
15:22:01 40792 8192000000 10889359280 11372793856 1975149824 19.426 100 15 30 1 1995278560 15770848 4357888
15:24:33 76965 8192000000 10907435376 11386716160 1982722864 19.486 100 12 22 1 1998737648 12941440 3073344
15:25:58 35631 8192000000 10906636016 11372793856 1958371376 19.293 98 31 60 0 1975497712 8126496 8999840
15:26:51 74895 8192000000 10889241344 11382411264 1944495616 19.183 98 17 34 0 1962194272 12926992 4771664
15:28:12 63662 8192000000 10881128688 11347410944 1901104160 18.835 96 14 28 1 1916085184 11389472 3591552
15:29:22 56785 8192000000 10882079936 11344293888 1902072032 18.843 97 20 39 1 1914969040 7679264 5217744
15:30:25 40518 8192000000 10913880352 11373924352 1968667552 19.375 100 25 50 3 1984522736 9411680 6443504
15:31:12 98656 8192000000 10875136272 11338981376 1860290432 18.506 94 18 36 0 1876638144 11891056 4456656
15:32:57 25204 8192000000 10901627312 11360915456 1950205648 19.228 99 33 64 2 1968356816 9271184 8879984
15:33:41 12386 8192000000 10912834288 11359260672 1963534176 19.334 100 51 102 4 1988790960 11275264 13981520
15:34:01 67544 8192000000 10875691232 11332169728 1859648800 18.500 95 26 52 0 1876567584 9966640 6952144
15:35:18 40558 8192000000 10885293824 11347345408 1903119936 18.851 97 40 80 1 1931624384 16596640 11907808
15:36:09 56634 8192000000 10891401312 11363045376 1927495088 19.047 99 24 48 0 1958966272 24333232 7137952
15:37:22 98470 8192000000 10853131360 11333767168 1768674304 17.756 91 15 30 0 1789780960 16979792 4126864
15:39:07 91478 8192000000 10888053776 11333410816 1938431632 19.134 100 27 52 3 1966693552 19761040 8500880
15:40:45 107183 8192000000 10856382736 11322146816 1871097472 18.593 96 30 58 2 1896820592 17322496 8400624
15:42:39 42938 8192000000 10844708816 11319881728 1924221600 19.021 100 24 48 1 1943363920 12196608 6945712
15:43:33 43134 8192000000 10855823152 11332980736 1944797616 19.185 100 8 16 0 1953081408 6062880 2220912
15:44:22 51288 8192000000 10863234016 11338952704 1915720064 18.953 98 5 10 0 1924612544 7337568 1554912
15:45:19 25913 8192000000 10861048544 11332128768 1918858576 18.978 98 7 14 0 1927661760 6543136 2260048
15:45:54 34630 8192000000 10856335472 11329720320 1927637296 19.048 99 17 35 0 1940279008 7782464 4859248
15:46:48 39225 8192000000 10875169808 11336265728 1924094608 19.020 99 16 32 0 1935993952 7296368 4602976
15:47:42 79449 8192000000 10856673760 11319701504 1890365760 18.749 97 18 35 2 1904217936 8510240 5341936
15:49:35 54844 8192000000 10866544688 11333414912 1909747792 18.905 98 18 36 3 1924562432 9700720 5113920
15:50:45 44332 8192000000 10856422784 11333894144 1924917040 19.026 99 23 46 0 1946496064 15091056 6487968
15:51:43 69608 8192000000 10850918560 11340185600 1917171184 18.964 99 8 16 0 1932069248 12309936 2588128
15:52:59 44945 8192000000 10858512688 11327881216 1906267152 18.877 98 16 32 0 1920121760 9693312 4161296
15:53:50 37427 8192000000 10890033840 11349913600 1951023456 19.235 100 22 44 0 1964460304 7607584 5829264
15:54:40 61098 8192000000 10849834016 11334230016 1915613904 18.952 98 14 28 0 1931223104 11570800 4038400
15:55:59 48069 8192000000 10873530880 11334623232 1908616192 18.896 98 21 41 0 1921438240 7361136 5460912
15:57:04 29154 8192000000 10891295280 11352109056 1945136416 19.188 99 38 76 0 1967787632 12149536 10501680
15:57:40 78309 8192000000 10894313872 11366608896 1965339712 19.348 100 17 34 1 1991994304 21765408 4889184
15:59:04 72927 8192000000 10913609616 11392905216 1957507056 19.286 99 19 38 2 1980214992 17465200 5242736
16:00:23 39130 8192000000 10885117536 11359051776 1915668000 18.952 97 15 30 1 1934276112 14800096 3808016
16:01:09 101733 8192000000 10871707120 11342192640 1800756352 18.020 92 14 28 3 1813837152 9774448 3306352
16:02:56 108831 8192000000 10900071200 11351035904 1894423488 18.781 97 23 46 1 1913360176 12505952 6430736
16:04:51 86274 8192000000 10909346304 11375804416 1907355744 18.885 97 23 46 0 1932093520 18550928 6186848
16:06:29 103061 8192000000 10904881520 11368968192 1972668048 19.407 100 20 39 0 1998834496 20767088 5399360
16:08:33 117561 8192000000 10908753216 11392180224 1969185312 19.379 99 17 33 1 1987554448 13018704 5350432
16:10:49 57345 8192000000 10866766128 11350441984 1905858720 18.873 96 11 22 2 1922813200 13708000 3246480
16:11:55 38398 8192000000 10870406880 11360485376 1947730608 19.208 100 5 10 1 1963840288 14540560 1569120
16:12:40 12833 8192000000 10870874928 11364925440 1951856944 19.241 100 5 10 0 1969644272 16276768 1510560
16:13:22 50007 8192000000 10881416512 11354300416 1943035264 19.171 99 16 32 1 1958802560 11308000 4459296
16:14:18 57187 8192000000 10881320768 11362893824 1943033616 19.171 99 23 46 0 1961048976 10715584 7299776
16:15:40 86055 8192000000 10882018208 11354320896 1926786176 19.041 98 11 22 1 1940495056 11002992 2705888
16:17:13 93656 8192000000 10893550384 11362115584 1928261760 19.053 98 14 28 0 1941339104 9087664 3989680
16:19:09 82016 8192000000 10899318864 11375489024 1917897648 18.970 97 13 26 0 1932468368 10858736 3711984
16:20:40 30595 8192000000 10876366512 11350331392 1910026032 18.907 97 30 60 1 1927457632 8868048 8563552
16:21:26 80501 8192000000 10893638432 11370274816 1900515440 18.830 97 18 36 2 1918402144 13204160 4682544
16:23:18 24506 8192000000 10897951760 11362938880 1943016432 19.171 99 21 42 0 1959327184 10649072 5661680
16:23:48 38656 8192000000 10901207472 11362418688 1944744224 19.185 99 25 50 2 1963348800 11955184 6649392
16:24:33 97358 8192000000 10870178848 11364225024 1885604512 18.710 96 16 32 0 1908391872 18603920 4183440
16:26:17 74095 8192000000 9535532048 9865506816 535338992 6.134 28 1 2 0 543567616 8166496 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-02-2021 16:28:16 to 14-02-2021 16:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 160 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

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

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          236122
MON$OLDEST_ACTIVE               236123
MON$OLDEST_SNAPSHOT             236123
MON$NEXT_TRANSACTION            236123
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                       2020736
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:366: 
:367: mscs-test-161.budzdorov.ru    Sun Feb 14 16:27:32 2021
:368:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:369: 
:370: 
:371: mscs-test-161.budzdorov.ru    Sun Feb 14 16:27:36 2021
:372:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:373: 
:374: 
:375: mscs-test-161.budzdorov.ru    Sun Feb 14 16:27:36 2021
:376:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:377: 
--- end of diff output ---

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

14.02.21 16:28:51. 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-14 16:28:53 No severe PSQL-related problems occured
14.02.21 16:28:54. End of report.