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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17231412 kB
MemAvailable 31186420 kB
Buffers 0 kB
Cached 14496072 kB
SwapCached 4112 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-17 19:27:19
DTS_END                         2021-02-17 19:27:19.6380
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39382
TRN_ID                          231881
ATT_ID                          601
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: 8974.29 22570 1076915
customer order: creation 166.27 356 19952
customer order: refuse 14.22 430 1706
order to supplier: creation 44.12 1257 5294
order to supplier: removal 3.34 100080 401
invoice (draft): creation 44.61 3177 5353
invoice (draft): removal 50.83 805 6099
invoice accept: apply 40.49 17419 4859
invoice accept: cancel 46.16 864 5539
customer reserve: creation 3754.83 170 450579
customer reserve: removal 4520.62 58 542474
realization accept: apply 81.24 197 9749
realization accept: cancel 83.79 108 10055
payment from customer: creation 56.45 105 6774
payment from customer: removal 5.76 70 691
payment to supplier: creation 46.87 126 5624
payment to supplier: removal 3.23 90 387
service: total inventory turnovers 4.49 1432 539
service: total monetary turnovers 6.22 28 746
service: aggregate perf. data 0.75 24163 90
service: refresh index statistics 0.03 300467 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2021 19:29:36 to 17-02-2021 19:29:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2797
TEST_TIME 2 3241
TEST_TIME 3 4997
TEST_TIME 4 5119
TEST_TIME 5 4714
TEST_TIME 6 5362
TEST_TIME 7 5165
TEST_TIME 8 5820
TEST_TIME 9 6334
TEST_TIME 10 6374
TEST_TIME 11 6761
TEST_TIME 12 6835
TEST_TIME 13 7132
TEST_TIME 14 7980
TEST_TIME 15 8237
TEST_TIME 16 8152
TEST_TIME 17 8487
TEST_TIME 18 8593
TEST_TIME 19 8879
TEST_TIME 20 9248
TEST_TIME 21 9271
TEST_TIME 22 9418
TEST_TIME 23 9404
TEST_TIME 24 9312
TEST_TIME 25 9509
TEST_TIME 26 9634
TEST_TIME 27 10547
TEST_TIME 28 11507
TEST_TIME 29 11549
TEST_TIME 30 11286
TEST_TIME 31 11134
TEST_TIME 32 10805
TEST_TIME 33 10710
TEST_TIME 34 10466
TEST_TIME 35 10506
TEST_TIME 36 10387
TEST_TIME 37 10184
TEST_TIME 38 10400
TEST_TIME 39 10256
TEST_TIME 40 10187
TEST_TIME 41 10142
TEST_TIME 42 10056
TEST_TIME 43 9895
TEST_TIME 44 9823
TEST_TIME 45 9769
TEST_TIME 46 9618
TEST_TIME 47 9524
TEST_TIME 48 9536
TEST_TIME 49 9467
TEST_TIME 50 9358
TEST_TIME 51 9304
TEST_TIME 52 9214
TEST_TIME 53 9408
TEST_TIME 54 9375
TEST_TIME 55 9291
TEST_TIME 56 9259
TEST_TIME 57 9423
TEST_TIME 58 9382
TEST_TIME 59 9326
TEST_TIME 60 9448
TEST_TIME 61 9406
TEST_TIME 62 9497
TEST_TIME 63 9457
TEST_TIME 64 9549
TEST_TIME 65 9591
TEST_TIME 66 9583
TEST_TIME 67 9630
TEST_TIME 68 9527
TEST_TIME 69 9484
TEST_TIME 70 9447
TEST_TIME 71 9441
TEST_TIME 72 9443
TEST_TIME 73 9353
TEST_TIME 74 9318
TEST_TIME 75 9289
TEST_TIME 76 9266
TEST_TIME 77 9202
TEST_TIME 78 9197
TEST_TIME 79 9218
TEST_TIME 80 9208
TEST_TIME 81 9230
TEST_TIME 82 9205
TEST_TIME 83 9265
TEST_TIME 84 9214
TEST_TIME 85 9264
TEST_TIME 86 9232
TEST_TIME 87 9224
TEST_TIME 88 9279
TEST_TIME 89 9353
TEST_TIME 90 9405
TEST_TIME 91 9421
TEST_TIME 92 9361
TEST_TIME 93 9296
TEST_TIME 94 9245
TEST_TIME 95 9261
TEST_TIME 96 9216
TEST_TIME 97 9161
TEST_TIME 98 9180
TEST_TIME 99 9138
TEST_TIME 100 9181
TEST_TIME 101 9164
TEST_TIME 102 9165
TEST_TIME 103 9157
TEST_TIME 104 9172
TEST_TIME 105 9143
TEST_TIME 106 9192
TEST_TIME 107 9173
TEST_TIME 108 9186
TEST_TIME 109 9217
TEST_TIME 110 9226
TEST_TIME 111 9213
TEST_TIME 112 9240
TEST_TIME 113 9170
TEST_TIME 114 9201
TEST_TIME 115 9158
TEST_TIME 116 9129
TEST_TIME 117 9085
TEST_TIME 118 9065
TEST_TIME 119 9045
TEST_TIME 120 8980

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-02-2021 19:29:39 to 17-02-2021 19:29:43.

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 1494918 1494918 0 0.00 0 17859 6 0 0
doc_list_biud 1494916 1494916 0 0.00 0 85422 27 0 0
sp_add_invoice_to_stock 4936 4859 77 1.55 24 153152 17420 0 77
sp_cancel_adding_invoice 5539 5539 0 0.00 4 102598 864 0 0
sp_cancel_client_order 1706 1706 0 0.00 4 14976 431 0 0
sp_cancel_customer_reserve 542474 542474 0 0.00 1 85424 59 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 3 7290 71 0 0
sp_cancel_pay_to_supplier 387 387 0 0.00 3 7325 91 0 0
sp_cancel_supplier_invoice 6102 6099 3 0.04 2 12763 806 0 3
sp_cancel_supplier_order 401 401 0 0.00 7 876787 100081 0 0
sp_cancel_write_off 10055 10055 0 0.00 1 13072 109 0 0
sp_client_order 19952 19952 0 0.00 4 14610 357 0 0
sp_customer_reserve 450579 450579 0 0.00 0 62429 170 0 0
sp_fill_shopping_cart 30598 30598 0 0.00 1 17170 40 0 0
sp_fill_shopping_cart_clo_res 450568 450568 0 0.00 0 13564 14 0 0
sp_get_clo_for_invoice 4848 4848 0 0.00 0 19465 373 0 0
sp_kill_cost_storno 16672 16672 0 0.00 0 9196 55 0 0
sp_kill_qstorno_ret_qs2qd 1101503 1101503 0 0.00 0 85252 32 0 0
sp_kill_qty_storno 580871 580871 0 0.00 0 85422 70 0 0
sp_lock_selected_doc 20137 20137 0 0.00 0 6235 5 0 0
sp_make_cost_storno 26995 26995 0 0.00 0 14977 57 0 0
sp_multiply_rows_for_pdistr 26995 26995 0 0.00 0 8293 28 0 0
sp_multiply_rows_for_qdistr 19952 19952 0 0.00 0 14390 162 0 0
sp_pay_from_customer 6774 6774 0 0.00 4 21601 105 0 0
sp_pay_to_supplier 5624 5624 0 0.00 5 12245 126 0 0
sp_payment_common 12398 12398 0 0.00 2 21574 32 0 0
sp_qd_handle_on_cancel_clo 1706 1706 0 0.00 0 14962 404 0 0
sp_qd_handle_on_invoice_upd_sts 10387 10387 0 0.00 0 40325 343 0 0
sp_qd_handle_on_reserve_upd_sts 9749 9749 0 0.00 0 18210 74 0 0
sp_reserve_write_off 9749 9749 0 0.00 7 18341 197 0 0
sp_supplier_invoice 5353 5353 0 0.00 6 91278 3178 0 0
sp_supplier_order 5294 5294 0 0.00 5 60290 1258 0 0
srv_aggregate_perf_data 90 90 0 0.00 2930 259791 24164 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1418 208330 34649 0 0
srv_find_qd_qs_mism 1031158 1031158 0 0.00 0 17858 5 0 0
srv_make_invnt_saldo 539 539 0 0.00 26 118611 1433 0 0
srv_make_money_saldo 746 746 0 0.00 1 1955 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 181972 375042 300468 0 0
t$perf-abend:sp_add_invoice_to_stock 77 77 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4859 4859 0 0.00 0 7205 152 0 0
t$perf-norm:sp_cancel_adding_invoice 397 397 0 0.00 1 4584 97 0 0
t$perf-norm:sp_cancel_client_order 1706 1706 0 0.00 0 1655 10 0 0
t$perf-norm:sp_cancel_customer_reserve 628 628 0 0.00 0 2384 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 354 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 387 387 0 0.00 0 620 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 805 11 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 21466 1562 0 0
t$perf-norm:sp_cancel_write_off 924 924 0 0.00 0 2188 13 0 0
t$perf-norm:sp_client_order 19952 19952 0 0.00 0 6525 15 0 0
t$perf-norm:sp_customer_reserve 993 993 0 0.00 0 2966 10 0 0
t$perf-norm:sp_pay_from_customer 6774 6774 0 0.00 0 6088 12 0 0
t$perf-norm:sp_pay_to_supplier 5624 5624 0 0.00 0 6508 10 0 0
t$perf-norm:sp_reserve_write_off 9749 9749 0 0.00 0 7317 11 0 0
t$perf-norm:sp_supplier_invoice 5353 5353 0 0.00 0 4773 15 0 0
t$perf-norm:sp_supplier_order 5294 5294 0 0.00 0 6087 15 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 485 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 6362 47 0 0
t$perf-norm:srv_make_invnt_saldo 539 539 0 0.00 0 886 21 0 0
t$perf-norm:srv_make_money_saldo 746 746 0 0.00 0 2863 18 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 9850 9696 154 1.56 0 7677 19 0 154
v_all_customers 36256 36256 0 0.00 0 17 1 0 0
v_all_suppliers 29484 29484 0 0.00 0 16 1 0 0
v_all_wares 39904 39904 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 794 794 0 0.00 0 1029 8 0 0
v_cancel_client_order 3412 3412 0 0.00 0 4299 4 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 6052 11 0 0
v_cancel_customer_reserve 1256 1256 0 0.00 0 910 4 0 0
v_cancel_payment_to_supplier 774 774 0 0.00 0 4618 12 0 0
v_cancel_supplier_invoice 818 812 6 0.73 0 748 13 0 6
v_cancel_supplier_order 802 802 0 0.00 0 265 2 0 0
v_cancel_write_off 1848 1848 0 0.00 0 2192 14 0 0
v_max_id_clo_ord 5294 5294 0 0.00 0 2415 2 0 0
v_max_id_clo_res 993 993 0 0.00 0 2091 11 0 0
v_max_id_ord_sup 5352 5352 0 0.00 0 3438 4 0 0
v_max_non_paid_invoice 1528 1528 0 0.00 0 229 2 0 0
v_max_non_paid_realizn 3626 3626 0 0.00 0 2184 5 0 0
v_min_id_clo_ord 5294 5294 0 0.00 0 4611 8 0 0
v_min_id_clo_res 993 993 0 0.00 0 1031 6 0 0
v_min_id_ord_sup 5352 5352 0 0.00 0 7974 8 0 0
v_min_non_paid_invoice 5624 5624 0 0.00 0 8623 21 0 0
v_min_non_paid_realizn 6774 6774 0 0.00 0 15781 18 0 0
v_our_firm 9944 9944 0 0.00 0 14 1 0 0
v_reserve_write_off 19498 19498 0 0.00 0 5321 5 0 0
x_lock_depdocs_on_canc_invoice 11232 11232 0 0.00 0 28447 124 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 14688 383 0 0
x_make_qstorno_1000_1200 5294 5294 0 0.00 2 60279 1169 0 0
x_make_qstorno_1200_2000 5353 5353 0 0.00 3 91270 3043 0 0
x_make_qstorno_2100_3300 450579 450579 0 0.00 0 62428 154 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2021 19:29:44 to 17-02-2021 19:29:48.

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
16:57:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:29 15151 8192000000 10246291680 10554724352 1013094192 11.005 79 60 119 2 1036211840 2802736 20314912
16:57:51 32069 8192000000 10356603472 10673807360 1398587216 14.582 100 87 174 0 1431225872 4808864 27829792
16:58:33 10829 8192000000 10375042384 10699038720 1437742336 14.930 100 86 172 0 1471925632 6621152 27562144
16:59:00 25804 8192000000 10414888832 10743246848 1466892448 15.186 100 90 180 1 1503576560 7716768 28967344
16:59:40 22893 8192000000 10440031504 10772492288 1492456032 15.410 100 85 170 0 1528376368 8583920 27336416
17:00:11 25286 8192000000 10456823648 10793693184 1511330816 15.575 100 94 189 2 1550620272 9658912 29630544
17:00:48 21044 8192000000 10470514208 10811547648 1525458192 15.698 100 84 167 1 1561176560 9642976 26075392
17:01:18 14395 8192000000 10488852208 10827341824 1541671472 15.838 100 85 170 1 1577729632 9523952 26534208
17:01:45 18156 8192000000 10511625952 10860118016 1568402448 16.069 100 80 160 0 1602768432 9850080 24515904
17:02:18 14690 8192000000 10544604592 10893180928 1598541408 16.327 100 91 182 2 1637448272 11267952 27638912
17:02:46 15477 8192000000 10562503312 10918326272 1615543216 16.472 100 75 150 2 1648571408 10625248 22402944
17:03:10 15571 8192000000 10572206928 10935201792 1635881616 16.645 100 69 137 1 1667759520 11116304 20761600
17:03:33 8552 8192000000 10596788224 10961780736 1659666448 16.846 100 81 162 0 1695640912 11762512 24211952
17:03:50 7786 8192000000 10608341824 10974474240 1670798736 16.940 100 77 152 4 1704585328 11740272 22046320
17:04:04 10982 8192000000 10622411360 10990858240 1680070096 17.018 100 74 148 0 1713930896 12254720 21606080
17:04:25 7702 8192000000 10633494704 11009601536 1700537872 17.190 100 81 162 1 1737445168 12868320 24038976
17:04:41 6842 8192000000 10659513056 11038560256 1725898128 17.401 100 71 142 2 1757907792 11740944 20268720
17:04:55 7419 8192000000 10676912928 11051827200 1736645024 17.491 100 75 149 2 1770484560 11936032 21903504
17:05:14 5534 8192000000 10675947424 11056869376 1748826848 17.592 100 77 154 1 1784076016 12960080 22289088
17:05:26 5564 8192000000 10699191152 11077517312 1762966800 17.709 100 80 159 0 1798432560 12682736 22783024
17:05:39 5307 8192000000 10706299440 11086770176 1768013264 17.751 100 73 146 0 1800304288 12577824 19713200
17:05:52 5015 8192000000 10716965792 11092537344 1775067168 17.809 100 80 160 2 1811022912 13980992 21974752
17:06:03 4305 8192000000 10724094064 11102732288 1780971904 17.857 100 75 146 0 1814820240 13747904 20100432
17:06:15 11795 8192000000 10731546880 11118493696 1791558992 17.945 100 77 153 0 1825973712 13273408 21141312
17:06:33 7887 8192000000 10745697696 11133014016 1801993584 18.030 100 82 165 0 1838124784 13753296 22377904
17:06:48 2719 8192000000 10763949344 11149938688 1823797936 18.209 100 83 166 0 1860350720 13143952 23408832
17:06:58 2897 8192000000 10764951344 11147534336 1823571904 18.207 100 80 158 0 1858472992 12147552 22753536
17:07:07 3135 8192000000 10778320064 11161571328 1832745376 18.282 100 86 170 0 1869845056 12825008 24274672
17:07:17 3401 8192000000 10773554544 11160018944 1838456160 18.328 100 83 165 1 1874027760 12400048 23171552
17:07:26 2942 8192000000 10798702608 11183792128 1854770592 18.461 100 91 179 2 1892269328 12822880 24675856
17:07:36 2999 8192000000 10804568480 11191963648 1860655440 18.509 100 95 189 0 1900101776 13399584 26046752
17:07:45 2934 8192000000 10805629632 11196268544 1863478592 18.531 100 89 176 4 1900375168 13145344 23751232
17:07:55 2509 8192000000 10812206816 11202371584 1868394384 18.571 100 92 184 1 1907939024 13718400 25826240
17:08:04 1790 8192000000 10822654864 11212775424 1873353424 18.611 100 84 166 4 1910223584 13676384 23193776
17:08:12 2285 8192000000 10825231360 11215540224 1878690048 18.655 100 87 172 4 1915600768 13155904 23754816
17:08:21 1993 8192000000 10812430928 11207835648 1878791696 18.655 100 90 179 1 1916742848 12673168 25277984
17:08:31 2379 8192000000 10828623616 11220164608 1883385888 18.692 100 94 189 1 1924144576 13322784 27435904
17:08:40 13981 8192000000 10818542720 11213475840 1880856992 18.672 100 73 145 0 1911092928 10731456 19504480
17:09:01 2652 8192000000 10822148048 11220123648 1886899440 18.721 100 87 174 1 1923797216 12506448 24391328
17:09:12 7277 8192000000 10824329040 11223330816 1885659632 18.711 100 76 150 1 1918206448 11968592 20578224
17:09:27 1377 8192000000 10840469840 11231653888 1896503456 18.798 100 94 189 2 1936164048 12833296 26827296
17:09:34 3572 8192000000 10806839712 11226386432 1887424624 18.725 100 54 109 1 1914544880 12049168 15071088
17:09:44 4456 8192000000 10806859040 11228745728 1886163312 18.715 100 42 84 1 1911577888 14077408 11337168
17:09:59 1983 8192000000 10822250304 11231571968 1898104720 18.811 100 66 133 1 1925931584 9524384 18302480
17:10:09 2194 8192000000 10818072320 11229057024 1893883456 18.777 100 63 126 1 1922566912 11418896 17264560
17:10:18 1928 8192000000 10830724304 11237498880 1894944112 18.786 100 60 118 2 1922708672 11271440 16493120
17:10:26 7184 8192000000 10805688816 11230547968 1891595008 18.759 100 34 67 0 1910168288 9108032 9465248
17:10:40 9485 8192000000 10803482672 11225993216 1893080576 18.771 100 43 87 1 1911753552 6779200 11893776
17:11:01 50040 8192000000 10820940496 11238334464 1890498208 18.750 100 29 56 3 1903259744 4703104 8058432
17:11:57 6789 8192000000 10816997088 11242119168 1893039232 18.770 100 33 66 1 1913452224 11375040 9037952
17:12:10 6341 8192000000 10802114112 11236057088 1893942752 18.778 100 21 42 2 1906093744 5928192 6222800
17:12:24 6096 8192000000 10819727856 11246964736 1896763920 18.800 100 27 54 2 1915602128 10797376 8040832
17:12:37 7348 8192000000 10805355216 11238354944 1895353136 18.789 100 21 42 2 1907276816 5489456 6434224
17:12:51 6806 8192000000 10818458224 11248734208 1900174240 18.828 100 27 54 2 1914569808 6337888 8057680
17:13:05 5622 8192000000 10828223152 11251929088 1909225328 18.900 100 45 89 2 1930420208 8332160 12862720
17:13:17 11313 8192000000 10807336624 11245649920 1901795296 18.841 100 20 40 0 1913054416 6097728 5161392
17:13:35 7419 8192000000 10809131408 11249262592 1904760560 18.865 100 24 48 0 1917880208 6449520 6670128
17:13:49 7348 8192000000 10822195456 11251904512 1906418720 18.878 100 22 44 0 1919104656 5902336 6783600
17:14:03 5582 8192000000 10827592272 11262181376 1917470816 18.967 100 27 54 1 1931238720 6104336 7663568
17:14:15 3347 8192000000 10830977840 11261730816 1915586784 18.951 100 27 54 0 1929153168 5444016 8122368
17:14:26 12914 8192000000 10821373024 11262242816 1914906448 18.946 100 18 35 1 1926164032 6111600 5145984
17:14:47 12151 8192000000 10822428784 11264618496 1916957648 18.962 100 11 23 1 1926209344 5552992 3698704
17:15:07 21284 8192000000 10834838992 11271913472 1921385664 18.998 100 23 46 1 1932618528 4745056 6487808
17:15:36 62550 8192000000 10844236816 11281059840 1928081872 19.052 100 42 84 0 1946097040 5063536 12951632
17:16:45 8704 8192000000 10839078320 11279659008 1929129472 19.060 100 24 46 3 1943233280 6885008 7218800
17:17:02 8119 8192000000 10853583232 11282542592 1928276928 19.053 100 41 82 1 1947004880 8118720 10609232
17:17:16 5336 8192000000 10838821120 11265060864 1891152640 18.755 98 38 76 0 1910937488 9059504 10725344
17:17:28 6404 8192000000 10810166416 11242020864 1888546080 18.734 99 26 52 1 1903097280 7135744 7415456
17:17:42 7347 8192000000 10800997152 11229855744 1857561360 18.484 98 25 50 1 1869879536 5508592 6809584
17:17:57 7573 8192000000 10799949328 11223154688 1838759408 18.331 97 24 47 0 1850916832 5143776 7013648
17:18:14 7283 8192000000 10792637472 11217502208 1870988544 18.592 100 22 43 1 1882480528 5174656 6317328
17:18:27 6246 8192000000 10768914688 11195707392 1834582256 18.297 98 32 64 2 1849403600 5770576 9050768
17:18:40 10520 8192000000 10765452000 11180785664 1803234096 18.040 97 13 26 0 1812147280 5033696 3879488
17:18:57 9141 8192000000 10763488512 11194953728 1824416704 18.214 98 19 38 1 1835747712 5994096 5336912
17:19:12 10953 8192000000 10778062576 11193384960 1805182304 18.056 97 15 31 0 1814884784 5543056 4159424
17:19:29 12408 8192000000 10721776960 11150077952 1757760848 17.666 95 12 24 0 1766172976 5337008 3075120
17:19:48 12693 8192000000 10710615824 11132035072 1680173248 17.019 91 21 41 1 1691316944 4576288 6567408
17:20:07 68189 8192000000 10734675104 11149946880 1682833360 17.041 92 30 60 1 1696204128 4786048 8584720
17:21:24 8076 8192000000 10722138016 11146711040 1794715040 17.971 99 12 23 1 1803444944 5402320 3327584
17:21:43 11894 8192000000 10718293984 11129335808 1774878112 17.807 98 33 66 0 1792271632 7858128 9535392
17:22:01 7370 8192000000 10677992336 11085565952 1699468432 17.181 94 36 72 0 1717031728 7049488 10513808
17:22:16 9019 8192000000 10696310816 11108020224 1760918960 17.692 99 24 48 3 1773072640 5557296 6596384
17:22:32 2943 8192000000 10728227520 11129597952 1780588848 17.854 99 46 93 0 1806220896 10365632 15266416
17:22:45 10890 8192000000 10727426000 11142856704 1770319280 17.770 98 25 50 0 1787203008 9583360 7300368
17:23:02 10471 8192000000 10734732976 11142254592 1761710000 17.699 97 16 32 1 1771087120 5367088 4010032
17:23:20 7416 8192000000 10736059136 11159973888 1823915056 18.210 100 28 57 1 1838188128 5751520 8521552
17:23:36 8016 8192000000 10748316240 11174809600 1840407488 18.344 100 33 67 0 1855172912 5157152 9608272
17:23:52 8584 8192000000 10765138800 11185369088 1840430000 18.344 100 17 32 0 1850696880 5587248 4679632
17:24:08 9183 8192000000 10776252224 11191013376 1846215280 18.391 100 26 52 2 1858965040 4965824 7783936
17:24:25 10093 8192000000 10758104224 11186049024 1847430352 18.401 100 19 38 1 1858832704 5306992 6095360
17:24:43 13065 8192000000 10759709696 11193208832 1853386096 18.450 100 12 24 1 1862032944 5148576 3498272
17:25:03 61523 8192000000 10777489504 11202691072 1861030000 18.512 100 37 75 2 1878586864 6296352 11260512
17:26:12 17079 8192000000 10772602000 11202162688 1861190816 18.513 100 19 38 0 1871798416 5292624 5314976
17:26:35 8958 8192000000 10791671424 11213381632 1873973888 18.616 100 48 96 1 1895198416 8035808 13188720
17:26:52 5838 8192000000 10787701840 11208445952 1852811744 18.445 99 31 62 0 1867545152 6148608 8584800
17:27:07 6797 8192000000 10797532528 11225464832 1883675136 18.695 100 41 83 1 1904940848 9958064 11307648
17:27:22 27500 8192000000 10828501984 11244982272 1895255840 18.788 100 40 78 0 1911809248 5361632 11191776
17:28:09 25289 8192000000 10839845696 11259678720 1911263360 18.917 100 45 90 1 1934725664 10411968 13050336
17:28:48 22177 8192000000 10855588992 11272904704 1916668720 18.960 100 47 92 1 1941919744 11760560 13490464
17:29:26 35664 8192000000 10872753696 11295617024 1928748464 19.057 100 39 78 0 1953545232 13509456 11287312
17:30:09 11788 8192000000 10879268928 11301220352 1939287488 19.141 100 44 88 2 1969276336 17056224 12932624
17:30:30 17011 8192000000 10889255904 11310374912 1944402704 19.182 100 47 94 0 1977558560 19135856 14020000
17:30:56 7056 8192000000 10892727344 11310862336 1943616240 19.176 100 49 96 1 1974909152 17133824 14159088
17:31:12 22696 8192000000 10896701040 11317497856 1951340192 19.237 100 53 104 4 1984571024 18501584 14729248
17:31:43 8615 8192000000 10906192816 11327062016 1959216992 19.300 100 49 98 1 1993728832 20122432 14389408
17:31:59 59304 8192000000 10908642912 11342618624 1964203904 19.339 100 45 91 1 2001906560 23331456 14371200
17:33:32 28505 8192000000 10907920784 11354759168 1966616704 19.359 100 29 58 4 1999028352 23846512 8565136
17:34:07 10560 8192000000 10910409136 11352772608 1973689968 19.415 100 28 56 0 2005347152 23367008 8290176
17:34:26 8173 8192000000 10913986832 11354079232 1974538624 19.421 100 33 66 1 2008238528 23780272 9919632
17:34:42 2826 8192000000 10939446416 11362557952 1982279408 19.483 100 57 110 2 2022140688 23561584 16299696
17:34:52 4574 8192000000 10949516384 11374424064 1991862544 19.559 100 78 154 3 2040111264 25303280 22945440
17:35:06 3687 8192000000 10965556720 11386101760 2003863632 19.653 100 85 170 2 2055572288 27278176 24430480
17:35:17 2903 8192000000 10965453840 11385651200 2001048080 19.631 100 87 172 0 2056769712 30316432 25405200
17:35:27 2063 8192000000 10971982240 11389677568 2001238032 19.632 100 85 164 0 2056448368 31556720 23653616
17:35:36 4191 8192000000 10954385040 11378991104 1992376080 19.563 100 69 134 0 2042243696 30510576 19357040
17:35:49 4042 8192000000 10968807504 11389526016 2002448096 19.642 100 80 156 1 2056905824 31089408 23368320
17:36:01 2274 8192000000 10978336064 11392618496 2006088352 19.671 100 85 170 1 2062556864 32679296 23789216
17:36:15 14382 8192000000 10975236384 11398025216 2007174384 19.679 100 84 166 2 2066882208 35676544 24031280
17:36:40 4991 8192000000 10976819904 11402846208 2009146176 19.695 100 79 157 0 2070303552 38033120 23124256
17:36:53 2437 8192000000 10994351760 11412021248 2013579808 19.730 100 88 174 2 2077852720 37938192 26334720
17:37:07 5313 8192000000 10989066992 11409555456 2011676528 19.715 100 81 160 1 2071165920 36100144 23389248
17:37:22 5770 8192000000 10979088688 11404607488 2010625024 19.706 100 69 138 1 2067078784 36362416 20091344
17:37:36 5269 8192000000 10978695616 11410038784 2012861056 19.724 100 69 138 2 2068154800 35134336 20159408
17:37:53 2444 8192000000 10995484976 11421917184 2020052256 19.781 100 83 165 1 2081171504 36499904 24619344
17:38:03 8786 8192000000 10988651904 11419058176 2021350224 19.791 100 66 132 3 2075275376 34834384 19090768
17:38:23 3991 8192000000 10999250208 11427799040 2021130176 19.789 100 63 126 0 2075268080 35410336 18727568
17:38:42 2424 8192000000 10995826416 11417694208 2016642784 19.754 100 84 163 3 2077664752 37081712 23940256
17:38:51 2503 8192000000 10975346528 11406057472 2011013376 19.709 100 70 140 2 2069243232 36974912 21254944
17:39:05 5864 8192000000 10971777792 11400536064 1985050192 19.505 99 66 132 0 2045885904 40911392 19924320
17:39:18 4714 8192000000 10978331904 11396325376 1981842704 19.479 99 83 166 1 2048412576 41591360 24978512
17:39:32 1675 8192000000 10998536528 11414749184 2010931312 19.709 100 90 180 0 2081635152 42864880 27838960
17:39:40 4364 8192000000 10991474000 11409891328 2007192448 19.679 100 84 167 0 2077182624 43173664 26816512
17:39:51 4221 8192000000 10991813520 11413094400 2005322352 19.665 100 69 138 0 2070405376 43478432 21604592
17:40:02 3413 8192000000 10977505408 11396190208 1988593296 19.533 99 74 146 2 2054440848 42679008 23168544
17:40:13 2240 8192000000 10997171696 11414171648 2005439456 19.666 100 85 169 0 2076861760 44086096 27336208
17:40:26 6088 8192000000 10979631328 11406835712 1989512480 19.540 99 70 141 0 2055597216 44580320 21504416
17:40:40 10280 8192000000 10965266528 11405045760 1985377856 19.507 99 59 118 1 2051783680 47448224 18957600
17:40:58 6651 8192000000 10967330352 11407851520 1965074032 19.346 98 58 115 1 2032551152 48741008 18736112
17:41:13 10869 8192000000 10973827568 11415007232 1996728080 19.597 100 57 114 0 2060436784 46380880 17327824
17:41:30 3578 8192000000 10930997728 11355738112 1940752912 19.153 98 58 116 2 2006561664 47472752 18336000
17:41:40 5607 8192000000 10965613632 11402694656 1983522080 19.493 100 58 117 1 2051561088 49211248 18827760
17:41:53 2385 8192000000 10986013568 11413381120 1996239936 19.593 100 81 164 0 2072070560 50800720 25029904
17:42:05 9161 8192000000 10975397328 11406974976 1993534336 19.572 100 68 136 0 2059650944 45332560 20784048
17:42:24 10531 8192000000 10960309232 11386646528 1973541696 19.414 100 61 122 0 2041662544 48867840 19253008
17:42:42 3167 8192000000 10973350160 11400294400 1973114816 19.410 99 78 151 2 2044373808 48134240 23124752
17:42:52 5490 8192000000 10957123360 11382657024 1976895968 19.440 100 77 153 1 2048316528 47385456 24035104
17:43:05 6613 8192000000 10961779392 11389800448 1981809120 19.479 100 77 152 1 2049892816 44469792 23613904
17:43:23 3842 8192000000 10978461904 11395457024 1982891088 19.488 100 76 152 1 2056051856 50019776 23140992
17:43:34 5545 8192000000 10964536752 11394785280 1984832240 19.503 100 61 122 0 2053065600 49776992 18456368
17:43:47 7094 8192000000 10953353744 11379728384 1963267344 19.332 99 62 123 1 2032757664 49773600 19716720
17:44:01 3757 8192000000 10980862512 11404742656 1989168624 19.537 100 78 156 3 2065166032 52297680 23699728
17:44:14 7054 8192000000 10995054448 11414151168 1995176928 19.585 100 73 145 2 2070685408 53458464 22050016
17:44:29 2831 8192000000 10968322624 11393945600 1974085264 19.418 99 82 163 1 2056317680 57221152 25011264
17:44:39 5438 8192000000 10987706320 11412377600 1987047248 19.520 100 72 144 1 2064271328 55518800 21705280
17:44:51 1417 8192000000 10969085312 11390320640 1960240384 19.308 99 86 170 0 2043794848 58068000 25486464
17:45:00 3375 8192000000 10937168016 11361112064 1947996672 19.211 100 67 133 0 2023523664 55714832 19812160
17:45:26 7870 8192000000 10920814480 11356905472 1938598608 19.136 99 41 82 0 2004622528 52542832 13481088
17:45:41 9016 8192000000 10929267760 11367903232 1940039776 19.147 99 43 84 3 2006814944 52323840 14451328
17:45:57 9386 8192000000 10939892512 11377549312 1950979808 19.234 100 40 80 0 2020810528 56899920 12930800
17:46:14 7025 8192000000 10950708688 11380858880 1927680096 19.048 98 46 92 2 2000583888 57736304 15167488
17:46:27 4630 8192000000 10958940496 11393622016 1964592752 19.343 100 57 114 0 2038773232 56240032 17940448
17:46:48 8620 8192000000 10928155792 11376889856 1941994208 19.163 99 37 74 1 2011673168 56887504 12791456
17:47:05 7642 8192000000 10962629520 11390734336 1967903712 19.369 100 54 109 2 2040217488 55105616 17208160
17:47:21 3307 8192000000 10965287200 11398463488 1976554016 19.437 100 55 110 3 2048233392 54481360 17198016
17:47:44 20235 8192000000 10933992352 11383492608 1937453120 19.126 98 27 54 0 1994814976 48171344 9190512
17:48:18 7997 8192000000 10946427712 11384369152 1949831760 19.225 99 43 86 0 2013355856 49563568 13960528
17:48:34 8321 8192000000 10950759744 11392233472 1964245744 19.340 100 46 90 4 2030475600 51599040 14630816
17:48:49 8301 8192000000 10929895712 11372404736 1916637280 18.960 97 42 82 1 1979466576 49736864 13092432
17:49:04 9563 8192000000 10934206816 11370971136 1942590368 19.167 99 35 70 0 2003967392 49602224 11774800
17:49:22 11145 8192000000 10937603952 11387420672 1963759984 19.336 100 30 60 0 2021202944 47488192 9954768
17:49:41 5720 8192000000 10947006928 11386814464 1967140560 19.363 100 35 70 2 2026632032 48139184 11352288
17:49:53 4161 8192000000 10944510640 11386494976 1972854480 19.408 100 34 70 3 2030833728 47261680 10717568
17:50:07 23036 8192000000 10941869872 11379068928 1946792144 19.201 99 31 62 0 2007054896 49426800 10835952
17:50:39 14906 8192000000 10941444032 11382796288 1963593968 19.335 100 36 72 2 2024502160 49281104 11627088
17:51:02 4520 8192000000 10950924000 11384147968 1967772880 19.368 100 38 74 0 2028221440 48949248 11499312
17:51:29 19879 8192000000 10924762992 11370098688 1921105040 18.996 98 29 58 0 1984903312 54022304 9775968
17:51:57 18479 8192000000 10930302880 11379728384 1945557856 19.191 100 31 62 1 2015493184 58329136 11606192
17:52:28 15950 8192000000 10919875600 11368337408 1942733376 19.169 100 24 46 2 2007098080 55963664 8401040
17:53:03 15674 8192000000 10910959200 11348545536 1875494672 18.629 97 29 58 1 1946674944 60123184 11057088
17:53:31 18462 8192000000 10920986672 11375607808 1921542544 18.999 100 21 42 1 2000852960 70819248 8491168
17:54:39 36173 8192000000 10896231360 11351904256 1922118976 19.004 100 10 20 0 1967152000 41818704 3214320
17:55:24 47420 8192000000 10851771408 11332755456 1904182160 18.860 99 10 20 2 1933638880 25953936 3502784
17:56:25 22729 8192000000 10848198640 11320176640 1917525680 18.967 100 14 28 1 1937733248 16314496 3893072
17:56:53 39510 8192000000 10886330672 11330674688 1937404336 19.126 100 40 81 3 1956477120 7490160 11582624
17:57:41 88099 8192000000 10854515632 11308826624 1879485888 18.661 97 22 44 1 1901089680 15001808 6601984
17:59:27 95042 8192000000 10852338336 11307044864 1876849584 18.640 97 22 45 1 1895392912 12239440 6303888
18:01:09 110419 8192000000 10863092864 11314012160 1863273120 18.530 96 25 49 4 1887892944 17972480 6647344
18:03:13 108069 8192000000 10872649872 11330310144 1896801824 18.801 98 14 27 1 1915955936 15001472 4152640
18:05:19 66126 8192000000 10859214736 11315621888 1896968480 18.802 98 14 28 0 1916099232 15284800 3845952
18:06:32 58382 8192000000 10855674640 11314765824 1904755008 18.865 98 12 25 1 1919303264 11426144 3122112
18:07:38 97581 8192000000 10859608400 11324080128 1924176224 19.020 99 16 32 1 1942798864 13895280 4727360
18:09:26 68551 8192000000 10868185248 11336081408 1944026512 19.179 100 16 33 1 1954376576 6322512 4027552
18:11:03 119343 8192000000 10880850048 11354353664 1962679760 19.327 100 22 43 1 1982773792 13981040 6112992
18:13:14 53349 8192000000 10874179936 11342020608 1946571456 19.199 99 9 18 0 1957574416 8012912 2990048
18:14:14 31448 8192000000 10912857008 11360288768 1974291840 19.419 100 52 105 2 1998531696 8361520 15878336
18:15:01 61520 8192000000 10877259488 11356991488 1951696048 19.240 99 13 24 1 1964955920 10373360 2886512
18:16:09 32507 8192000000 10895978688 11369500672 1974203536 19.419 100 22 42 2 1988375472 8433984 5737952
18:16:48 50906 8192000000 10905281728 11378442240 1982443984 19.484 100 14 28 0 1999741136 13233120 4064032
18:17:46 120993 8192000000 10916370400 11391623168 1992290352 19.562 100 19 39 0 2012025168 14279472 5455344
18:19:54 38356 8192000000 10915293600 11399327744 1988998784 19.536 100 15 30 2 2010757488 17273104 4485600
18:20:46 63945 8192000000 10916486880 11396710400 1991519408 19.556 100 8 16 0 2010536080 16692160 2324512
18:21:56 47115 8192000000 10929545376 11398795264 1997549696 19.603 100 13 26 1 2010645504 9280288 3815520
18:22:49 53945 8192000000 10928679264 11405971456 1990033696 19.544 99 28 56 2 2011600976 12680960 8886320
18:23:55 83320 8192000000 10905436704 11396653056 1938830640 19.137 97 20 40 1 1958477856 14025056 5622160
18:25:25 37780 8192000000 10927687840 11393990656 1993977248 19.575 100 35 68 1 2012369472 9382448 9009776
18:26:13 21922 8192000000 10931089792 11395248128 1982802704 19.487 99 31 61 1 2006951200 15803776 8344720
18:26:49 45707 8192000000 10937610944 11395387392 1973238912 19.411 99 35 70 0 1999048032 16439344 9369776
18:27:42 98762 8192000000 10924964208 11400654848 1986131568 19.513 99 29 58 1 2007952576 13726768 8094240
18:29:27 105394 8192000000 10906199536 11364564992 1837471248 18.320 92 8 17 0 1847613760 7944384 2198128
18:31:18 101989 8192000000 10908737200 11382521856 1920168464 18.988 97 12 24 0 1940383424 16446560 3768400
18:33:06 97806 8192000000 10874828800 11359387648 1875589248 18.629 95 15 30 0 1907243008 27144304 4509456
18:35:33 29243 8192000000 10869321296 11333320704 1933274080 19.093 99 40 77 1 1951482144 7057072 11150992
18:36:26 67788 8192000000 10893813872 11357437952 1927875072 19.050 98 39 77 1 1949243104 10959456 10408576
18:37:40 14669 8192000000 10895358608 11353640960 1948656352 19.216 99 47 94 0 1970874976 9900384 12318240
18:38:02 25602 8192000000 10882551120 11336622080 1932354336 19.086 99 35 70 1 1951936784 10293728 9288720
18:38:35 49901 8192000000 10848988256 11313709056 1855155424 18.464 95 21 42 1 1869695680 8669840 5870416
18:40:13 41584 8192000000 10829784208 11294437376 1899550880 18.823 99 9 18 0 1911826944 9519952 2756112
18:41:01 32309 8192000000 10795569872 11263168512 1819245088 18.172 95 10 20 1 1834036272 11766480 3024704
18:41:44 62107 8192000000 10811938048 11285655552 1873556464 18.613 99 13 26 0 1889578384 11900560 4121360
18:43:01 94133 8192000000 10819611136 11280121856 1871289008 18.595 98 22 44 0 1886599920 8597504 6713408
18:44:42 73740 8192000000 10834200224 11309015040 1868690640 18.574 97 11 22 1 1885298752 13490272 3117840
18:46:11 106335 8192000000 10848596352 11328221184 1892290368 18.764 98 13 26 0 1910718160 14785680 3642112
18:48:05 30509 8192000000 10854120544 11321540608 1902316208 18.845 98 26 52 4 1916408192 6784400 7307584
18:48:42 23697 8192000000 10855439040 11307511808 1892711904 18.768 98 39 80 2 1910975312 7634240 10629168
18:49:18 30103 8192000000 10853816048 11310735360 1867666096 18.565 97 32 64 1 1885795552 9490032 8639424
18:49:57 45983 8192000000 10837325712 11313020928 1902250528 18.844 99 24 48 3 1922425120 12740608 7433984
18:50:57 36507 8192000000 10843969296 11300614144 1863539504 18.532 97 27 54 1 1878300960 7345184 7416272
18:51:42 68301 8192000000 10833912976 11312582656 1878457664 18.653 98 19 37 1 1894626608 11064624 5104320
18:53:14 24453 8192000000 10862463264 11314266112 1908157296 18.892 99 39 78 2 1927037632 8555616 10324720
18:53:45 20101 8192000000 10844432192 11293523968 1888338960 18.732 98 39 78 1 1908366992 9030240 10997792
18:54:12 44994 8192000000 10856286784 11309490176 1871236720 18.594 97 37 74 2 1896818560 15073344 10508496
18:55:03 56025 8192000000 10854017760 11337904128 1901540768 18.839 99 19 38 0 1927438048 20223376 5673904
18:56:38 87595 8192000000 10861215392 11332210688 1891966224 18.762 98 13 26 0 1913484064 18409328 3108512
18:58:12 122871 8192000000 10874938352 11343925248 1910232528 18.909 98 10 20 0 1927701664 15021552 2447584
19:00:34 56902 8192000000 10888660448 11355693056 1962560624 19.326 100 26 52 2 1980059952 9960192 7539136
19:01:37 20381 8192000000 10887539216 11349463040 1947002064 19.203 99 29 58 1 1966732224 12176656 7553504
19:02:04 22580 8192000000 10885056768 11360272384 1960349024 19.309 100 16 32 0 1976890144 12366096 4175024
19:02:33 27458 8192000000 10882754944 11365580800 1962029328 19.322 100 7 14 1 1977678640 13566512 2082800
19:03:10 52914 8192000000 10875072144 11355848704 1947489440 19.206 99 7 14 0 1959500848 10449744 1561664
19:04:12 86427 8192000000 10876183040 11360243712 1943095024 19.171 99 10 19 0 1955262752 9324800 2842928
19:05:50 71189 8192000000 10891182928 11358777344 1952100816 19.243 99 17 35 0 1965009408 8187312 4721280
19:07:17 95606 8192000000 10893549920 11378757632 1923563136 19.015 97 15 30 2 1941908480 13805808 4539536
19:08:59 74933 8192000000 10921517952 11392868352 1983766272 19.495 100 18 36 2 1997661696 8585248 5310176
19:10:26 77585 8192000000 10932034528 11408289792 1974683424 19.423 99 17 34 0 1994896128 15698032 4514672
19:11:55 63346 8192000000 10903645152 11371892736 1937578416 19.127 97 25 50 1 1956338640 11829488 6930736
19:13:05 59314 8192000000 10901044592 11364347904 1933627696 19.096 98 13 26 0 1947507168 10202720 3676752
19:14:14 99405 8192000000 10890395904 11360440320 1874989488 18.625 95 21 42 2 1892109024 11407664 5711872
19:16:02 75866 8192000000 10896979744 11377614848 1959687232 19.304 100 11 22 0 1974057984 11458160 2912592
19:17:33 55929 8192000000 10898832416 11374960640 1937562320 19.127 98 23 46 1 1956293200 12616272 6114608
19:18:59 208329 8192000000 10894316752 11383984128 1971740448 19.399 100 13 26 1 1990681024 15328464 3612112
19:22:39 76092 8192000000 10882354448 11357646848 1901678352 18.840 96 8 16 1 1913016848 9235232 2103264
19:24:06 71085 8192000000 10887015040 11371737088 1964456592 19.341 100 17 33 1 1978049072 8652992 4939488
19:25:33 85175 8192000000 10902033296 11377999872 1965683104 19.351 99 22 44 3 1981833648 9674864 6475680
19:27:08 20757 8192000000 9582357488 9912029184 731953072 8.202 38 4 6 1 736773536 4070080 750384

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 17-02-2021 19:29:50 to 17-02-2021 19:30:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 77 v_add_invoice_to_stock 335544517
except 3 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2021 19:30:22 to 17-02-2021 19:30:24.

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          232227
MON$OLDEST_ACTIVE               232228
MON$OLDEST_SNAPSHOT             232228
MON$NEXT_TRANSACTION            232228
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                       2014336
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:63: 
:64: mscs-test-161.budzdorov.ru    Wed Feb 17 19:27:34 2021
:65:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:66: 
:67: 
:68: mscs-test-161.budzdorov.ru    Wed Feb 17 19:27:56 2021
:69:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:70: 
--- end of diff output ---

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

17.02.21 19:30:25. 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-17 19:30:27 No severe PSQL-related problems occured
17.02.21 19:30:28. End of report.