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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-12 01:27:11
DTS_END                         2021-01-12 01:27:11.0650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41736
TRN_ID                          243967
ATT_ID                          679
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: 8997.11 21376 1079653
customer order: creation 175.92 351 21110
customer order: refuse 14.16 339 1699
order to supplier: creation 47.12 1341 5654
order to supplier: removal 3.40 95580 408
invoice (draft): creation 46.66 3546 5599
invoice (draft): removal 49.99 775 5999
invoice accept: apply 42.33 19007 5079
invoice accept: cancel 45.03 827 5404
customer reserve: creation 3849.85 192 461982
customer reserve: removal 4422.37 58 530684
realization accept: apply 85.05 175 10206
realization accept: cancel 82.13 113 9855
payment from customer: creation 60.83 108 7299
payment from customer: removal 5.49 86 659
payment to supplier: creation 51.01 128 6121
payment to supplier: removal 3.38 88 405
service: total inventory turnovers 4.42 1070 530
service: total monetary turnovers 7.20 37 864
service: aggregate perf. data 0.77 22133 92
service: refresh index statistics 0.03 281562 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9252
TEST_TIME 2 6933
TEST_TIME 3 7160
TEST_TIME 4 6908
TEST_TIME 5 7052
TEST_TIME 6 7215
TEST_TIME 7 6918
TEST_TIME 8 6798
TEST_TIME 9 6887
TEST_TIME 10 6784
TEST_TIME 11 6758
TEST_TIME 12 6797
TEST_TIME 13 7111
TEST_TIME 14 7245
TEST_TIME 15 7191
TEST_TIME 16 7348
TEST_TIME 17 8091
TEST_TIME 18 8404
TEST_TIME 19 8262
TEST_TIME 20 8609
TEST_TIME 21 9193
TEST_TIME 22 9426
TEST_TIME 23 9527
TEST_TIME 24 9660
TEST_TIME 25 10009
TEST_TIME 26 10067
TEST_TIME 27 10142
TEST_TIME 28 10790
TEST_TIME 29 10545
TEST_TIME 30 10534
TEST_TIME 31 10393
TEST_TIME 32 10309
TEST_TIME 33 10204
TEST_TIME 34 10072
TEST_TIME 35 9994
TEST_TIME 36 9827
TEST_TIME 37 9849
TEST_TIME 38 9859
TEST_TIME 39 9727
TEST_TIME 40 9560
TEST_TIME 41 9501
TEST_TIME 42 9493
TEST_TIME 43 9473
TEST_TIME 44 9669
TEST_TIME 45 9560
TEST_TIME 46 9507
TEST_TIME 47 9358
TEST_TIME 48 9414
TEST_TIME 49 9390
TEST_TIME 50 9402
TEST_TIME 51 9316
TEST_TIME 52 9260
TEST_TIME 53 9296
TEST_TIME 54 9517
TEST_TIME 55 9488
TEST_TIME 56 9428
TEST_TIME 57 9330
TEST_TIME 58 9416
TEST_TIME 59 9482
TEST_TIME 60 9444
TEST_TIME 61 9441
TEST_TIME 62 9596
TEST_TIME 63 9515
TEST_TIME 64 9419
TEST_TIME 65 9372
TEST_TIME 66 9308
TEST_TIME 67 9262
TEST_TIME 68 9246
TEST_TIME 69 9227
TEST_TIME 70 9159
TEST_TIME 71 9109
TEST_TIME 72 9106
TEST_TIME 73 9141
TEST_TIME 74 9141
TEST_TIME 75 9137
TEST_TIME 76 9141
TEST_TIME 77 9136
TEST_TIME 78 9101
TEST_TIME 79 9142
TEST_TIME 80 9198
TEST_TIME 81 9180
TEST_TIME 82 9211
TEST_TIME 83 9211
TEST_TIME 84 9282
TEST_TIME 85 9288
TEST_TIME 86 9224
TEST_TIME 87 9199
TEST_TIME 88 9155
TEST_TIME 89 9124
TEST_TIME 90 9128
TEST_TIME 91 9078
TEST_TIME 92 9030
TEST_TIME 93 9047
TEST_TIME 94 9102
TEST_TIME 95 9106
TEST_TIME 96 9072
TEST_TIME 97 9066
TEST_TIME 98 9151
TEST_TIME 99 9148
TEST_TIME 100 9109
TEST_TIME 101 9078
TEST_TIME 102 9141
TEST_TIME 103 9128
TEST_TIME 104 9196
TEST_TIME 105 9188
TEST_TIME 106 9172
TEST_TIME 107 9209
TEST_TIME 108 9170
TEST_TIME 109 9176
TEST_TIME 110 9109
TEST_TIME 111 9091
TEST_TIME 112 9083
TEST_TIME 113 9042
TEST_TIME 114 9021
TEST_TIME 115 9038
TEST_TIME 116 9000
TEST_TIME 117 9083
TEST_TIME 118 9061
TEST_TIME 119 9074
TEST_TIME 120 9005

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 12-01-2021 01:28:29 to 12-01-2021 01:28:33.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1505734 1505734 0 0.00 0 30121 7 0 0
doc_list_biud 1505734 1505734 0 0.00 0 28768 26 0 0
sp_add_invoice_to_stock 5195 5079 116 2.23 25 190475 19007 0 116
sp_cancel_adding_invoice 5404 5404 0 0.00 5 69206 827 0 0
sp_cancel_client_order 1699 1699 0 0.00 4 11201 339 0 0
sp_cancel_customer_reserve 530684 530684 0 0.00 1 22332 59 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 3 10855 86 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 3130 88 0 0
sp_cancel_supplier_invoice 6006 5999 7 0.11 1 21461 775 0 7
sp_cancel_supplier_order 408 408 0 0.00 5 968616 95581 0 0
sp_cancel_write_off 9855 9855 0 0.00 1 28868 114 0 0
sp_client_order 21110 21110 0 0.00 3 24932 351 0 0
sp_customer_reserve 461982 461982 0 0.00 0 45360 193 0 0
sp_fill_shopping_cart 32351 32351 0 0.00 1 20067 45 0 0
sp_fill_shopping_cart_clo_res 461970 461970 0 0.00 0 17412 15 0 0
sp_get_clo_for_invoice 5067 5067 0 0.00 0 38672 299 0 0
sp_kill_cost_storno 16323 16323 0 0.00 0 8514 55 0 0
sp_kill_qstorno_ret_qs2qd 1077630 1077630 0 0.00 0 28767 32 0 0
sp_kill_qty_storno 569322 569322 0 0.00 0 28768 69 0 0
sp_lock_selected_doc 21067 21067 0 0.00 0 9918 5 0 0
sp_make_cost_storno 28693 28693 0 0.00 0 22929 52 0 0
sp_multiply_rows_for_pdistr 28693 28693 0 0.00 0 8365 27 0 0
sp_multiply_rows_for_qdistr 21110 21110 0 0.00 0 17877 153 0 0
sp_pay_from_customer 7299 7299 0 0.00 4 39585 108 0 0
sp_pay_to_supplier 6121 6121 0 0.00 4 22945 129 0 0
sp_payment_common 13420 13420 0 0.00 1 39573 32 0 0
sp_qd_handle_on_cancel_clo 1699 1699 0 0.00 0 11194 311 0 0
sp_qd_handle_on_invoice_upd_sts 10471 10471 0 0.00 0 17664 312 0 0
sp_qd_handle_on_reserve_upd_sts 10206 10206 0 0.00 0 10832 62 0 0
sp_reserve_write_off 10206 10206 0 0.00 6 14667 176 0 0
sp_supplier_invoice 5599 5599 0 0.00 6 88013 3547 0 0
sp_supplier_order 5654 5654 0 0.00 5 28548 1342 0 0
srv_aggregate_perf_data 92 92 0 0.00 3208 414575 22134 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1602 129738 32689 0 0
srv_find_qd_qs_mism 1030298 1030298 0 0.00 0 30119 6 0 0
srv_make_invnt_saldo 530 530 0 0.00 41 31071 1070 0 0
srv_make_money_saldo 864 864 0 0.00 1 10641 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 199262 427813 281562 0 0
t$perf-abend:sp_add_invoice_to_stock 116 116 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5079 5079 0 0.00 0 12617 175 0 0
t$perf-norm:sp_cancel_adding_invoice 436 436 0 0.00 0 22980 147 0 0
t$perf-norm:sp_cancel_client_order 1699 1699 0 0.00 0 3965 16 0 0
t$perf-norm:sp_cancel_customer_reserve 709 709 0 0.00 0 6084 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 1968 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 358 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 443 443 0 0.00 0 3038 20 0 0
t$perf-norm:sp_cancel_supplier_order 408 408 0 0.00 0 18981 1348 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 2196 8 0 0
t$perf-norm:sp_client_order 21110 21110 0 0.00 0 12709 17 0 0
t$perf-norm:sp_customer_reserve 1038 1038 0 0.00 0 2776 7 0 0
t$perf-norm:sp_pay_from_customer 7299 7299 0 0.00 0 2526 7 0 0
t$perf-norm:sp_pay_to_supplier 6121 6121 0 0.00 0 7632 12 0 0
t$perf-norm:sp_reserve_write_off 10206 10206 0 0.00 0 7621 11 0 0
t$perf-norm:sp_supplier_invoice 5599 5599 0 0.00 0 9050 20 0 0
t$perf-norm:sp_supplier_order 5654 5654 0 0.00 0 5074 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 295 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 5285 44 0 0
t$perf-norm:srv_make_invnt_saldo 530 530 0 0.00 0 1707 26 0 0
t$perf-norm:srv_make_money_saldo 864 864 0 0.00 0 5883 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 10366 10134 232 2.23 0 2562 15 0 232
v_all_customers 38622 38622 0 0.00 0 78 1 0 0
v_all_suppliers 31154 31154 0 0.00 0 30 1 0 0
v_all_wares 42220 42220 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 872 872 0 0.00 0 1956 11 0 0
v_cancel_client_order 3398 3398 0 0.00 0 5082 5 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 860 4 0 0
v_cancel_customer_reserve 1418 1418 0 0.00 0 5307 9 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 3107 14 0 0
v_cancel_supplier_invoice 900 886 14 1.55 0 1373 15 0 14
v_cancel_supplier_order 816 816 0 0.00 0 641 5 0 0
v_cancel_write_off 2070 2070 0 0.00 0 6177 16 0 0
v_max_id_clo_ord 5652 5652 0 0.00 0 4543 2 0 0
v_max_id_clo_res 1038 1038 0 0.00 0 2731 16 0 0
v_max_id_ord_sup 5589 5589 0 0.00 0 4472 4 0 0
v_max_non_paid_invoice 1785 1785 0 0.00 0 3536 7 0 0
v_max_non_paid_realizn 3852 3852 0 0.00 0 3967 4 0 0
v_min_id_clo_ord 5652 5652 0 0.00 0 4338 7 0 0
v_min_id_clo_res 1038 1038 0 0.00 0 8321 19 0 0
v_min_id_ord_sup 5589 5589 0 0.00 0 11089 15 0 0
v_min_non_paid_invoice 6121 6121 0 0.00 0 6733 19 0 0
v_min_non_paid_realizn 7299 7299 0 0.00 0 7332 16 0 0
v_our_firm 10492 10492 0 0.00 0 14 1 0 0
v_reserve_write_off 20412 20412 0 0.00 0 4802 5 0 0
x_lock_depdocs_on_canc_invoice 10960 10960 0 0.00 0 39328 117 0 0
x_lock_depdocs_on_canc_sup_ord 408 408 0 0.00 0 5808 322 0 0
x_make_qstorno_1000_1200 5654 5654 0 0.00 2 28541 1258 0 0
x_make_qstorno_1200_2000 5599 5599 0 0.00 2 87994 3374 0 0
x_make_qstorno_2100_3300 461982 461982 0 0.00 0 45358 175 0 0

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

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:14 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 17030 8192000000 10251848000 10555760640 1023341232 11.104 79 63 128 0 1046488688 2574672 20572784
22:57:48 20751 8192000000 10331304032 10644951040 1374225152 14.365 100 88 176 0 1407407568 4774480 28407936
22:58:29 29754 8192000000 10388176288 10711793664 1434436816 14.901 100 87 174 0 1469701744 6798176 28466752
22:59:08 26063 8192000000 10408627792 10734714880 1464899296 15.169 100 90 180 0 1501954912 8160448 28895168
22:59:42 20208 8192000000 10422091936 10752417792 1479638832 15.298 100 95 190 1 1519497552 8659856 31198864
23:00:13 20687 8192000000 10430878048 10763984896 1488620144 15.377 100 86 172 1 1525250528 8993680 27636704
23:00:49 27570 8192000000 10464621648 10801754112 1517301744 15.627 100 90 180 0 1555521504 9874048 28345712
23:01:25 18594 8192000000 10488031040 10830274560 1538364304 15.809 100 78 156 2 1573203440 10424352 24414784
23:01:59 14464 8192000000 10534651472 10885177344 1581517968 16.181 100 80 161 1 1616057776 10229024 24310784
23:02:24 11649 8192000000 10547054608 10901684224 1606252704 16.393 100 75 150 1 1639704528 10273184 23178640
23:02:43 9874 8192000000 10578254896 10932498432 1624453856 16.548 100 79 158 2 1659162800 10731568 23977376
23:03:03 12977 8192000000 10580128480 10940977152 1643562208 16.710 100 86 172 0 1680754112 11403680 25788224
23:03:25 10672 8192000000 10594561888 10960056320 1659191424 16.842 100 73 145 0 1691581472 11153280 21236768
23:03:43 11158 8192000000 10618084496 10983845888 1674148208 16.968 100 71 142 0 1706118496 11177600 20792688
23:04:02 6711 8192000000 10631494256 10999791616 1688953248 17.093 100 77 154 0 1723386304 11761648 22671408
23:04:16 6159 8192000000 10650007776 11018842112 1706842544 17.242 100 80 160 2 1741861168 12337808 22680816
23:04:30 5852 8192000000 10658915392 11029807104 1721265344 17.363 100 80 158 1 1756482384 12570320 22646720
23:04:44 5984 8192000000 10682137040 11050053632 1733868768 17.468 100 84 168 0 1771216512 13856048 23491696
23:04:57 5698 8192000000 10673724272 11048914944 1739168880 17.512 100 82 163 0 1776059616 13842032 23048704
23:05:10 3900 8192000000 10687660448 11060948992 1751307792 17.612 100 88 176 1 1790358160 14945712 24104656
23:05:20 5491 8192000000 10703604256 11079475200 1763750992 17.715 100 84 168 1 1800605856 13819376 23035488
23:05:34 4376 8192000000 10715846048 11091472384 1772720080 17.789 100 84 168 1 1810157312 13914704 23522528
23:05:45 3183 8192000000 10722251952 11099111424 1784505472 17.887 100 89 178 1 1823450736 13879280 25065984
23:05:55 3276 8192000000 10730488240 11106369536 1790242432 17.934 100 94 186 1 1830147488 13842192 26062864
23:06:05 3189 8192000000 10733663936 11110707200 1796402368 17.984 100 90 180 0 1836549504 14633584 25513552
23:06:14 4184 8192000000 10741867472 11123392512 1797216896 17.991 100 84 168 0 1835348080 14342640 23788544
23:06:25 2334 8192000000 10749036272 11129389056 1813825696 18.127 100 89 179 2 1852052960 13018976 25208288
23:06:34 3712 8192000000 10755663968 11137884160 1814399488 18.132 100 85 168 1 1851492912 13765936 23327488
23:06:44 2354 8192000000 10761489184 11142389760 1817004528 18.153 100 88 176 0 1856964000 15185952 24773520
23:06:54 5515 8192000000 10761376784 11145162752 1820960384 18.186 100 84 166 2 1858759936 15007088 22792464
23:07:06 6057 8192000000 10768307856 11153776640 1831478176 18.271 100 86 171 4 1869959520 14708752 23772592
23:07:20 1988 8192000000 10793588256 11179020288 1848272864 18.408 100 92 187 0 1888836848 14894032 25669952
23:07:29 2407 8192000000 10799737872 11186409472 1850468336 18.426 100 86 170 1 1889652320 13984976 25199008
23:07:37 2055 8192000000 10792113552 11178844160 1856612800 18.476 100 92 184 1 1896589728 12608480 27368448
23:07:46 2367 8192000000 10807135424 11197657088 1864150144 18.537 100 92 184 4 1907134816 16550480 26434192
23:07:55 2455 8192000000 10806918448 11198205952 1865791920 18.550 100 90 181 0 1902657216 11524864 25340432
23:08:03 2134 8192000000 10818468128 11204771840 1870526992 18.589 100 93 186 2 1910355152 13025168 26802992
23:08:11 2184 8192000000 10819929824 11206397952 1875781824 18.631 100 89 179 1 1913721232 12587200 25352208
23:08:20 3180 8192000000 10821474416 11216478208 1879018544 18.657 100 91 182 0 1918279936 13309248 25952144
23:08:29 1679 8192000000 10826048400 11216699392 1880522304 18.669 100 89 179 3 1919262336 13739440 25000592
23:08:38 5885 8192000000 10796646288 11211464704 1876190624 18.634 100 63 126 0 1905759680 12120176 17448880
23:09:05 14705 8192000000 10817952176 11220623360 1881523088 18.677 100 75 149 2 1910928800 7973264 21432448
23:09:26 4069 8192000000 10819994768 11220692992 1881015296 18.673 100 68 136 1 1911714592 10075280 20624016
23:09:37 9276 8192000000 10775945008 11215396864 1874774912 18.623 100 37 74 0 1899282128 14525824 9981392
23:09:54 5046 8192000000 10797113168 11215220736 1877896544 18.648 100 37 74 0 1896182048 7601408 10684096
23:10:05 10061 8192000000 10799340544 11218731008 1880698080 18.671 100 34 69 2 1897122736 5684992 10739664
23:10:22 4081 8192000000 10793364112 11222081536 1885661968 18.711 100 35 70 1 1902295552 6770432 9863152
23:10:35 5108 8192000000 10793731840 11225403392 1888065792 18.730 100 38 77 1 1907701728 7930768 11705168
23:10:46 5049 8192000000 10799923888 11229167616 1892376864 18.765 100 33 65 2 1908987632 6393616 10217152
23:10:58 6753 8192000000 10807822720 11233091584 1895651840 18.791 100 40 80 1 1914287600 7338304 11297456
23:11:12 6058 8192000000 10803145680 11231928320 1891836016 18.761 100 20 40 0 1907430784 9879712 5715056
23:11:25 9555 8192000000 10805306160 11233562624 1894696400 18.784 100 25 50 1 1908666368 6119296 7850672
23:11:45 9685 8192000000 10798945840 11234291712 1894452768 18.782 100 17 34 1 1905063200 5964336 4646096
23:12:03 5632 8192000000 10812613520 11240112128 1896881712 18.801 100 22 44 2 1909593328 6751104 5960512
23:12:15 9695 8192000000 10810323088 11238965248 1896273264 18.796 100 20 39 3 1907428368 5741056 5414048
23:12:31 10454 8192000000 10804328016 11240652800 1899157536 18.820 100 19 37 2 1910982480 5666704 6158240
23:12:50 13122 8192000000 10816221664 11246374912 1901717152 18.840 100 20 40 0 1913175808 5457344 6001312
23:13:09 7031 8192000000 10819199008 11249434624 1908074384 18.891 100 39 76 0 1925190784 6253280 10863120
23:13:27 65780 8192000000 10809461840 11255062528 1910050208 18.907 100 22 44 1 1921840592 5512560 6277824
23:14:39 8330 8192000000 10836676304 11259363328 1892719712 18.768 99 28 52 2 1905948848 6122992 7106144
23:14:57 7104 8192000000 10834591072 11263381504 1913624416 18.936 100 32 64 3 1929973568 7417168 8931984
23:15:11 8040 8192000000 10823982336 11259998208 1895344112 18.789 99 19 38 0 1906656752 6170960 5141680
23:15:27 7192 8192000000 10835404912 11264622592 1914124976 18.940 100 28 56 2 1928139280 5923360 8090944
23:15:43 7616 8192000000 10816563808 11254480896 1894313376 18.781 99 21 41 2 1907056000 6458976 6283648
23:15:58 9382 8192000000 10812897792 11247927296 1886530832 18.718 99 26 52 2 1908177152 14573184 7073136
23:16:14 9048 8192000000 10807136416 11245105152 1884207312 18.699 99 21 42 0 1895534784 5275536 6051936
23:16:33 6336 8192000000 10790066880 11221684224 1878834880 18.656 100 19 38 0 1890072672 5796880 5440912
23:16:46 7554 8192000000 10789771776 11222818816 1853848368 18.453 98 20 40 4 1865202272 5301744 6052160
23:17:02 9324 8192000000 10795032336 11223719936 1864091552 18.536 99 18 35 0 1874880512 6417936 4371024
23:17:22 14438 8192000000 10782605264 11213475840 1849313232 18.417 98 11 22 0 1858600048 5728704 3558112
23:17:44 9379 8192000000 10762513264 11180449792 1817978576 18.161 97 18 36 1 1828411952 5787600 4645776
23:18:02 17815 8192000000 10722417040 11143020544 1762655456 17.706 94 28 56 2 1776794416 5826576 8312384
23:18:26 52143 8192000000 10767621696 11163889664 1799235392 18.008 97 47 95 3 1819144432 4431296 15477744
23:19:26 22782 8192000000 10729290000 11150778368 1725006944 17.394 94 21 42 3 1736592976 6236704 5349328
23:19:57 8525 8192000000 10716524000 11129638912 1756839808 17.658 96 37 72 1 1773883232 6825792 10217632
23:20:11 8139 8192000000 10705480592 11116986368 1712352640 17.288 95 27 53 3 1725617296 5981472 7283184
23:20:27 6154 8192000000 10716404784 11133849600 1793696752 17.962 100 23 46 1 1810171920 10082608 6392560
23:20:41 6905 8192000000 10724759040 11143196672 1779916240 17.849 98 26 52 2 1793292640 5984000 7392400
23:20:55 7117 8192000000 10732185344 11148226560 1813494576 18.124 100 30 61 1 1828059200 5860928 8703696
23:21:16 7729 8192000000 10718511696 11137880064 1793159104 17.958 99 36 74 1 1810312384 5840768 11312512
23:21:30 9364 8192000000 10703880064 11122159616 1730625840 17.441 96 21 42 0 1742868448 4873232 7369376
23:21:46 10511 8192000000 10712448416 11130265600 1737104384 17.495 96 23 46 0 1749513472 5306992 7102096
23:22:03 8348 8192000000 10727672336 11146248192 1797860448 17.996 99 36 70 0 1813814352 5459424 10494480
23:22:18 9893 8192000000 10724525152 11140419584 1789292432 17.926 98 28 56 4 1802553504 5080272 8180800
23:22:34 11230 8192000000 10730146480 11153526784 1806266304 18.065 99 18 36 0 1817402720 5714416 5422000
23:22:58 11148 8192000000 10733778816 11163602944 1812383152 18.115 99 17 32 2 1822668816 5296000 4989664
23:23:15 17799 8192000000 10753197024 11176521728 1836173808 18.310 100 21 41 0 1851184320 9612656 5397856
23:23:40 65752 8192000000 10763507216 11192483840 1844472736 18.377 100 29 57 2 1863609936 9955040 9182160
23:24:53 10004 8192000000 10768953696 11197427712 1855270752 18.465 100 23 46 0 1868162768 6241168 6650848
23:25:09 8565 8192000000 10774146176 11206586368 1864231616 18.538 100 30 60 1 1883285712 10896336 8157760
23:25:23 5792 8192000000 10781155248 11204366336 1862345264 18.522 100 30 60 1 1877375808 6512976 8517568
23:25:36 5255 8192000000 10785042368 11210076160 1866635536 18.557 100 34 68 1 1882986304 6483328 9867440
23:25:48 6337 8192000000 10792207712 11211550720 1867874800 18.567 100 39 78 1 1886088944 6685120 11529024
23:26:02 10810 8192000000 10780633024 11212759040 1869691408 18.582 100 24 48 3 1882503600 5397040 7415152
23:26:20 7120 8192000000 10775662992 11211657216 1868312304 18.571 100 9 18 0 1876318496 5239152 2767040
23:26:34 9387 8192000000 10794428384 11221037056 1875201568 18.626 100 29 58 2 1889836256 5400816 9233872
23:26:54 12814 8192000000 10805796272 11226968064 1875884016 18.632 100 17 34 1 1885845696 5454592 4507088
23:27:18 17387 8192000000 10826897760 11247157248 1900236640 18.828 100 30 59 1 1914014320 5290368 8487312
23:27:42 17235 8192000000 10849925008 11266560000 1911615808 18.920 100 51 101 3 1934099136 8537632 13945696
23:28:07 22562 8192000000 10856824048 11276034048 1921230144 18.997 100 54 108 0 1947649312 10936160 15483008
23:28:36 15323 8192000000 10858438688 11278344192 1927471232 19.047 100 47 94 0 1950740224 9819360 13449632
23:29:01 81037 8192000000 10869391344 11295748096 1915880208 18.954 99 47 92 2 1942862720 12167328 14815184
23:30:35 14404 8192000000 10862493200 11293589504 1929830976 19.066 100 34 66 2 1951808112 12172592 9804544
23:30:59 4255 8192000000 10876647936 11299745792 1940404608 19.150 100 57 114 4 1965549376 9873104 15271664
23:31:11 4227 8192000000 10886596656 11311083520 1952518288 19.247 100 60 120 0 1981733008 11439280 17775440
23:31:23 18037 8192000000 10872162112 11303682048 1943232160 19.173 100 50 96 1 1968211888 11650560 13329168
23:31:48 2112 8192000000 10894794592 11308085248 1946750656 19.201 100 77 155 3 1981477520 12323104 22403760
23:32:00 2318 8192000000 10895566080 11307909120 1948620368 19.215 100 62 122 1 1978756176 12231728 17904080
23:32:09 3462 8192000000 10898881728 11318398976 1958524528 19.294 100 60 114 0 1986560720 12388528 15647664
23:32:22 8808 8192000000 10905051280 11330260992 1962143808 19.323 100 49 97 1 1990119248 13994400 13981040
23:32:39 4580 8192000000 10895667776 11324645376 1945907776 19.194 99 50 101 1 1974701696 14315008 14478912
23:32:50 19801 8192000000 10902598752 11329675264 1968762592 19.376 100 65 129 1 2002130816 14594560 18773664
23:33:32 9433 8192000000 10914544448 11339968512 1968045872 19.370 100 57 114 1 2000211856 16076064 16089920
23:33:48 2628 8192000000 10935530032 11348951040 1984088128 19.497 100 70 140 1 2020068272 16308656 19671488
23:33:57 6036 8192000000 10931278128 11354202112 1985235408 19.506 100 72 144 1 2023345584 17818512 20291664
23:34:11 8790 8192000000 10915391360 11336511488 1944913936 19.186 98 70 140 1 1982841456 17448160 20479360
23:34:32 23800 8192000000 10914696208 11346137088 1969995904 19.385 100 47 94 2 2000943680 17545952 13401824
23:35:05 11229 8192000000 10909960528 11344756736 1975349152 19.428 100 45 89 1 2006993600 18622336 13022112
23:35:24 6334 8192000000 10911081216 11337416704 1959204656 19.300 99 55 109 1 1993043200 18186480 15652064
23:35:42 4310 8192000000 10913860768 11330117632 1960639888 19.311 99 75 150 0 2003422112 20616608 22165616
23:35:55 4320 8192000000 10916122768 11337687040 1953510752 19.254 99 67 130 1 1993088544 21006432 18571360
23:36:05 3007 8192000000 10910017856 11337482240 1966230208 19.356 100 65 130 2 2005513568 20302576 18980784
23:36:16 6636 8192000000 10920911152 11345412096 1971916112 19.401 100 63 123 3 2009854240 20035088 17903040
23:36:31 8905 8192000000 10915012896 11343372288 1969097136 19.378 100 53 106 2 2003565504 19130000 15338368
23:36:48 3173 8192000000 10934546736 11357020160 1983783056 19.495 100 64 127 0 2022976256 20511072 18682128
23:36:59 7565 8192000000 10915824816 11339354112 1958182848 19.292 99 69 138 1 2000583072 21678400 20721824
23:37:20 5447 8192000000 10926789600 11351175168 1973273808 19.411 100 55 110 0 2011690720 21947888 16469024
23:37:33 6688 8192000000 10917881760 11341271040 1963183184 19.331 99 72 142 1 2006133328 21416528 21533616
23:37:52 5971 8192000000 10935993184 11355156480 1978596144 19.454 100 63 125 2 2020451008 23166912 18687952
23:38:05 3937 8192000000 10937249392 11356798976 1978112368 19.450 100 72 144 1 2024417312 24795168 21509776
23:38:17 9699 8192000000 10942826560 11365785600 1985072032 19.505 100 68 135 5 2031305424 25975280 20258112
23:38:39 9396 8192000000 10920190080 11344437248 1967973952 19.369 100 61 122 1 2012867744 26800320 18093472
23:38:58 3573 8192000000 10930524208 11354624000 1973043008 19.410 100 62 121 2 2018888256 27447680 18397568
23:39:10 4617 8192000000 10927088816 11343228928 1961385776 19.317 99 75 147 1 2010966704 27825168 21755760
23:39:22 4249 8192000000 10938460128 11352047616 1958910576 19.297 99 72 145 3 2007987360 28194160 20882624
23:39:33 3028 8192000000 10952547600 11362557952 1981145056 19.474 100 88 172 0 2035256704 29012448 25099200
23:39:43 12827 8192000000 10925183616 11346546688 1953698016 19.256 99 74 147 1 2005957760 29410992 22848752
23:40:10 7606 8192000000 10951427616 11374768128 1982311248 19.483 100 65 129 1 2035909456 33424512 20173696
23:40:25 1889 8192000000 10928057184 11343491072 1947816784 19.209 98 75 150 1 2002721984 32324624 22580576
23:40:34 2326 8192000000 10947713440 11359105024 1975933008 19.432 100 82 163 2 2031468128 30601632 24933488
23:40:43 3678 8192000000 10933013008 11352104960 1970263872 19.388 100 78 157 1 2024300560 30317328 23719360
23:40:56 5965 8192000000 10938779792 11352248320 1953552272 19.255 99 73 145 1 2006952144 31686384 21713488
23:41:08 1601 8192000000 10918317392 11327217664 1949612112 19.223 100 78 154 2 2005987120 32178992 24196016
23:41:17 4614 8192000000 10916199248 11327057920 1952460096 19.246 100 82 164 2 2008665840 30523936 25681808
23:41:28 2829 8192000000 10916276224 11324792832 1942621280 19.168 100 89 179 0 2003103344 32347248 28134816
23:41:38 3514 8192000000 10915694112 11323305984 1943723552 19.176 100 78 154 0 1998465552 31411808 23330192
23:41:49 2208 8192000000 10910877440 11316224000 1936690032 19.120 100 84 167 2 1993813776 32011248 25112496
23:42:00 3948 8192000000 10919074960 11325341696 1943181872 19.172 100 84 166 3 2001714080 32891872 25640336
23:42:11 4907 8192000000 10915891664 11327201280 1943482864 19.175 100 75 150 1 2000603984 33890464 23230656
23:42:23 9089 8192000000 10925804752 11334107136 1949493728 19.222 100 77 154 0 2009075792 35402208 24179856
23:42:41 8026 8192000000 10921602448 11344113664 1953387984 19.253 100 62 124 0 2010762000 37378016 19996000
23:42:59 12330 8192000000 10934111264 11356532736 1962114336 19.323 100 62 122 4 2022069872 40383984 19571552
23:43:23 3068 8192000000 10940504048 11347116032 1952785360 19.249 100 67 134 2 2016434816 42168720 21480736
23:43:33 4792 8192000000 10937942544 11355938816 1961916736 19.321 100 72 145 0 2027073632 41737360 23419536
23:43:48 9118 8192000000 10944674928 11366072320 1968885840 19.377 100 62 122 1 2030201392 41428352 19887200
23:44:07 4291 8192000000 10946072192 11369037824 1967568288 19.366 100 63 127 2 2030100112 40824768 21707056
23:44:19 2009 8192000000 10950110800 11357761536 1953281296 19.253 99 85 171 1 2015860368 36223568 26355504
23:44:29 1960 8192000000 10939614560 11346567168 1948018896 19.211 99 82 164 1 2009417856 36711360 24687600
23:44:37 5044 8192000000 10931023008 11361284096 1962669520 19.327 100 54 108 0 2017159088 37406560 17083008
23:44:52 9625 8192000000 10923653728 11358609408 1944333216 19.181 99 40 80 3 1994513984 35968432 14212336
23:45:09 3992 8192000000 10934761456 11351212032 1962303712 19.324 100 67 134 1 2014806928 31135376 21367840
23:45:20 11289 8192000000 10913637856 11334234112 1931420240 19.078 99 53 105 0 1981441952 33309760 16711952
23:45:45 10631 8192000000 10922180960 11348742144 1956635440 19.279 100 50 100 0 2008731504 35923360 16172704
23:46:05 10872 8192000000 10915726352 11351072768 1959861168 19.305 100 45 90 1 2010510704 35632192 15017344
23:46:29 6004 8192000000 10917226416 11335933952 1924212816 19.021 98 60 120 0 1983290336 39177168 19900352
23:46:42 6979 8192000000 10924774464 11343163392 1947995520 19.211 100 65 127 3 2010532976 42259504 20277952
23:46:59 9048 8192000000 10932191792 11358896128 1950844816 19.233 100 50 100 1 2008643040 41158336 16639888
23:47:15 7643 8192000000 10922055264 11345420288 1944942560 19.186 100 58 116 1 2005452224 41806944 18702720
23:47:32 14132 8192000000 10898393856 11335790592 1918063024 18.971 99 49 98 1 1980372240 45377808 16931408
23:48:01 12049 8192000000 10893994464 11330138112 1928947056 19.058 100 34 68 0 1984547808 43895632 11705120
23:48:30 17433 8192000000 10874594896 11319738368 1893725744 18.776 98 24 48 0 1939893408 37664352 8503312
23:48:58 15583 8192000000 10842527008 11283206144 1863817808 18.534 97 24 48 1 1902666592 30396880 8451904
23:49:25 12351 8192000000 10884427872 11300347904 1919586416 18.984 100 55 108 2 1961803616 25803424 16413776
23:49:44 10640 8192000000 10861767920 11307180032 1914877520 18.946 100 26 52 3 1953816720 30056704 8882496
23:50:01 8026 8192000000 10883995344 11317673984 1921948160 19.002 100 35 68 0 1962003568 28915872 11139536
23:50:17 24959 8192000000 10867988032 11317682176 1902264512 18.845 99 23 46 2 1943144384 33212704 7667168
23:50:49 28024 8192000000 10895153008 11338199040 1938079088 19.131 100 36 67 3 1983749552 34407056 11263408
23:51:24 25067 8192000000 10883827488 11327647744 1899073744 18.819 98 24 48 3 1938337712 31351184 7912784
23:52:22 38291 8192000000 10884669312 11337011200 1900720400 18.832 98 27 54 1 1940705360 30993520 8991440
23:53:13 22491 8192000000 10891604784 11338760192 1939255216 19.141 100 21 42 0 1977582496 31135024 7192256
23:53:50 17901 8192000000 10890973344 11327102976 1934938768 19.106 100 33 65 1 1973021040 27601568 10480704
23:54:25 47648 8192000000 10856286048 11310014464 1891448224 18.757 98 27 54 0 1928056224 27115216 9492784
23:55:54 21874 8192000000 10846488848 11316891648 1915364848 18.950 100 7 14 0 1931731152 14319376 2046928
23:56:23 70205 8192000000 10847051216 11312041984 1910636400 18.912 99 13 26 0 1923919856 9730608 3552848
23:57:39 88131 8192000000 10866791008 11317374976 1899275104 18.820 98 17 34 0 1910902224 6511408 5115712
23:59:15 53659 8192000000 10877117264 11336937472 1935273504 19.109 99 22 44 0 1955165904 13302208 6590192
00:01:09 57931 8192000000 10877285472 11318779904 1896998000 18.802 97 37 74 1 1915992320 8465856 10528464
00:02:18 42221 8192000000 10872981136 11331735552 1931608848 19.080 99 41 81 1 1955760096 12766640 11384608
00:03:08 62290 8192000000 10884969232 11340095488 1954290704 19.261 100 38 76 0 1977435152 12431008 10713440
00:04:20 72785 8192000000 10897714624 11349958656 1961911424 19.321 100 23 46 1 1977178080 8887376 6379280
00:05:43 65613 8192000000 10888957168 11353776128 1951057200 19.235 99 11 22 0 1961658064 7643024 2957840
00:08:20 45756 8192000000 10919555472 11375022080 1984622976 19.501 100 29 57 0 2006264992 13154192 8487824
00:09:16 43882 8192000000 10929104528 11383463936 1987347216 19.523 100 24 49 1 2007744416 13324768 7072432
00:10:09 54390 8192000000 10911733152 11377115136 1990232928 19.546 100 20 40 0 2009281712 12831520 6217264
00:11:12 21189 8192000000 10919505024 11392696320 1986647856 19.517 100 24 46 1 2015694752 22002544 7044352
00:11:45 40243 8192000000 10906000528 11384549376 1988644592 19.533 100 15 30 0 2005558768 12649792 4264384
00:12:33 42927 8192000000 10896985232 11368972288 1969290272 19.380 99 6 12 0 1981309328 10256016 1763040
00:13:22 41012 8192000000 10890190128 11354615808 1959632736 19.303 99 10 20 0 1976069456 13140448 3296272
00:14:14 34447 8192000000 10891526352 11368644608 1971391296 19.396 100 7 14 0 1983223440 9887232 1944912
00:14:55 59562 8192000000 10881188624 11366002688 1959271312 19.300 99 19 38 1 1977746064 13400144 5074608
00:16:02 65741 8192000000 10885116656 11355758592 1938096080 19.132 98 19 37 1 1954348400 10962720 5289600
00:17:16 104030 8192000000 10897416528 11364294656 1924811936 19.025 97 28 56 1 1945681536 12896576 7973024
00:19:07 34410 8192000000 10895643328 11357437952 1914765808 18.945 97 16 32 0 1934789552 15172928 4850816
00:19:52 85726 8192000000 10897001664 11364769792 1931935968 19.082 98 23 46 2 1955117952 15934208 7247776
00:21:48 46543 8192000000 10890554496 11357569024 1948693120 19.216 99 9 16 1 1962214112 11429792 2091200
00:22:49 41978 8192000000 10904773008 11368906752 1939058336 19.139 98 17 34 0 1955562224 12172560 4331328
00:23:48 61371 8192000000 10920240736 11376173056 1959824656 19.305 99 30 59 2 1985243600 16783952 8634992
00:24:59 29427 8192000000 10902616112 11363205120 1950384448 19.230 99 29 58 0 1971417280 13505392 7527440
00:25:40 18747 8192000000 10913611200 11366678528 1971662928 19.399 100 33 67 0 1991716080 11002272 9050880
00:26:05 70808 8192000000 10884820192 11359436800 1902861952 18.849 96 27 54 1 1923382432 12982752 7537728
00:27:22 61569 8192000000 10913974720 11372724224 1931827744 19.081 98 29 57 1 1953802576 13727216 8247616
00:28:31 39776 8192000000 10879793712 11347476480 1907822976 18.889 97 15 30 1 1926913712 14820960 4269776
00:29:17 99298 8192000000 10890817152 11361243136 1890896544 18.753 96 8 15 1 1910050464 17189568 1964352
00:31:02 129738 8192000000 10894853424 11346714624 1865141136 18.545 95 35 70 1 1884834800 9664768 10028896
00:33:21 47576 8192000000 10866690288 11320897536 1909418480 18.902 98 35 70 0 1931645536 12191488 10035568
00:34:15 28794 8192000000 10850783568 11285901312 1820474704 18.182 94 36 72 1 1840834032 10291488 10067840
00:35:04 61675 8192000000 10802036704 11262623744 1797958640 17.997 94 15 30 0 1812569024 10346048 4264336
00:36:12 37288 8192000000 10802751824 11270901760 1865199968 18.545 99 4 8 0 1880756576 14432720 1123888
00:37:09 31641 8192000000 10804981216 11267330048 1847756480 18.404 98 8 16 0 1865030128 14961328 2312320
00:37:47 37090 8192000000 10814159024 11266895872 1840801168 18.347 97 18 35 3 1861301104 15206128 5293808
00:38:39 65746 8192000000 10792622944 11263029248 1826176256 18.228 97 12 24 0 1847362512 17611488 3574768
00:40:10 45333 8192000000 10797296880 11268276224 1823221408 18.204 97 10 20 0 1843310912 17157616 2931888
00:41:04 53294 8192000000 10810309184 11277770752 1874274112 18.619 99 16 32 1 1889256688 9069392 5913184
00:42:08 51994 8192000000 10833151504 11281022976 1851021968 18.430 97 23 45 1 1867251552 9668864 6560720
00:43:09 42859 8192000000 10837591792 11299840000 1899598064 18.823 99 34 66 3 1918165472 8727104 9840304
00:43:58 50776 8192000000 10873288240 11333201920 1905222320 18.868 99 30 60 0 1930460592 17180432 8057840
00:45:04 27402 8192000000 10881801808 11335618560 1940638256 19.152 100 26 52 0 1962850992 15254144 6958592
00:45:41 44861 8192000000 10867473040 11323146240 1898867904 18.817 98 23 46 1 1922985136 16994432 7122800
00:47:13 37504 8192000000 10880694128 11343331328 1938418528 19.134 100 26 52 0 1959542928 14176256 6948144
00:47:59 28423 8192000000 10898525264 11337334784 1930533392 19.071 99 39 78 0 1955380528 13103472 11743664
00:48:35 61963 8192000000 10875592608 11343679488 1929881232 19.066 99 27 54 0 1952500064 15198224 7420608
00:49:43 101254 8192000000 10865912800 11333955584 1872150640 18.602 96 23 46 2 1895651888 16974336 6526912
00:51:33 46867 8192000000 10870446864 11325243392 1897019824 18.802 98 19 38 0 1913049008 10533152 5496032
00:52:26 56824 8192000000 10894112576 11336208384 1938191648 19.132 100 45 90 0 1967855168 17732704 11930816
00:53:30 122143 8192000000 10868909360 11333156864 1946231504 19.196 100 34 69 1 1964390288 8865008 9293776
00:55:38 51957 8192000000 10884419296 11349557248 1942857232 19.170 99 33 66 1 1963764544 11621552 9285760
00:56:43 20689 8192000000 10893465232 11354497024 1962381232 19.325 100 35 67 1 1983199792 10778432 10040128
00:57:10 33921 8192000000 10893836800 11357077504 1967656288 19.367 100 15 30 0 1978759488 7140304 3962896
00:57:54 40051 8192000000 10890408400 11360686080 1959651984 19.303 99 23 46 1 1979236928 13535776 6049168
00:58:52 48819 8192000000 10890312832 11355295744 1960075696 19.307 99 14 28 0 1977667088 13566752 4024640
00:59:51 72684 8192000000 10885421696 11367886848 1955770000 19.272 99 13 26 0 1974521936 15273856 3478080
01:01:16 64989 8192000000 10904920464 11377078272 1975368128 19.428 100 8 16 0 1991035952 13653712 2014112
01:02:28 40568 8192000000 10906673424 11369541632 1972070784 19.402 99 14 27 1 1987883712 12069936 3742992
01:03:15 43741 8192000000 10896806544 11358740480 1927222128 19.045 97 23 46 1 1942569264 8992736 6354400
01:04:11 87141 8192000000 10878557328 11355017216 1907838496 18.889 97 20 39 0 1923650688 10362528 5449664
01:06:02 94828 8192000000 10875538848 11337080832 1865099056 18.545 95 17 34 0 1882417392 12785168 4533168
01:07:43 32833 8192000000 10871838224 11320721408 1913325968 18.933 98 45 90 1 1937007344 10767760 12913616
01:08:26 49694 8192000000 10879530528 11350589440 1941536512 19.159 99 39 78 0 1967184592 14481680 11166400
01:09:25 64352 8192000000 10893523776 11350331392 1938766144 19.137 99 13 26 0 1953702576 11242832 3693600
01:10:37 58912 8192000000 10891066768 11357700096 1923748480 19.017 98 20 40 2 1942800400 13555216 5496704
01:11:46 117530 8192000000 10882693040 11336568832 1837074208 18.317 94 6 11 1 1851676432 13401792 1200432
01:13:52 83314 8192000000 10897760288 11355389952 1937647104 19.128 99 10 20 0 1951487328 11316672 2523552
01:15:25 44023 8192000000 10912889312 11370196992 1952246320 19.244 99 23 46 1 1969641696 10655712 6739664
01:16:16 90391 8192000000 10893991424 11356053504 1911570992 18.919 97 33 66 0 1940875168 19787248 9516928
01:17:53 88481 8192000000 10903292944 11362312192 1965743584 19.352 100 20 40 0 1984141392 12427184 5970624
01:19:27 19821 8192000000 10858710944 11325837312 1902921264 18.850 97 19 38 0 1920578592 12479296 5178032
01:20:05 35297 8192000000 10859838976 11328278528 1932278704 19.085 99 17 34 3 1949117696 11938464 4900528
01:20:47 61067 8192000000 10868037216 11344269312 1918293408 18.973 98 14 28 0 1934721728 12292736 4135584
01:21:56 41892 8192000000 10867946544 11346030592 1925608592 19.032 99 8 16 1 1940943568 13198112 2136864
01:22:49 54704 8192000000 10862536864 11329466368 1883807408 18.696 97 11 21 1 1901574480 15291392 2475680
01:23:59 87849 8192000000 10870065712 11350302720 1909836000 18.905 98 9 18 1 1926765920 14190768 2739152
01:25:45 88717 8192000000 9865549488 10227040256 980471552 10.689 51 7 14 0 992474384 10312096 1690736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 12-01-2021 01:28:39 to 12-01-2021 01:29:11.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 116 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          242163
MON$OLDEST_ACTIVE               244262
MON$OLDEST_SNAPSHOT             244262
MON$NEXT_TRANSACTION            244262
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                       2011712
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:761: 
:762: mscs-test-161.budzdorov.ru    Tue Jan 12 01:27:17 2021
:763:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:764: 
--- end of diff output ---

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

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