Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.01.2021 16: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 17252200 kB
MemAvailable 31458856 kB
Buffers 0 kB
Cached 14471760 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-01 16:27:12
DTS_END                         2021-01-01 16:27:12.7010
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/48914
TRN_ID                          245391
ATT_ID                          656
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: 9076.56 24576 1089187
customer order: creation 174.78 329 20973
customer order: refuse 15.04 374 1805
order to supplier: creation 46.16 1275 5539
order to supplier: removal 3.27 96758 392
invoice (draft): creation 47.72 3501 5726
invoice (draft): removal 50.79 811 6095
invoice accept: apply 42.73 16502 5127
invoice accept: cancel 45.88 819 5506
customer reserve: creation 3844.48 166 461338
customer reserve: removal 4508.32 54 540998
realization accept: apply 85.80 212 10296
realization accept: cancel 78.55 101 9426
payment from customer: creation 61.40 123 7368
payment from customer: removal 5.90 74 708
payment to supplier: creation 49.43 151 5932
payment to supplier: removal 3.28 74 393
service: total inventory turnovers 5.02 973 602
service: total monetary turnovers 7.09 33 851
service: aggregate perf. data 0.90 20437 108
service: refresh index statistics 0.03 348751 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 01-01-2021 16:29:50 to 01-01-2021 16:29:53.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8435
TEST_TIME 2 5302
TEST_TIME 3 4427
TEST_TIME 4 4734
TEST_TIME 5 5288
TEST_TIME 6 5388
TEST_TIME 7 5217
TEST_TIME 8 5389
TEST_TIME 9 5571
TEST_TIME 10 5558
TEST_TIME 11 5832
TEST_TIME 12 6641
TEST_TIME 13 6730
TEST_TIME 14 7098
TEST_TIME 15 7389
TEST_TIME 16 7213
TEST_TIME 17 7412
TEST_TIME 18 7396
TEST_TIME 19 8015
TEST_TIME 20 8433
TEST_TIME 21 8829
TEST_TIME 22 9210
TEST_TIME 23 9115
TEST_TIME 24 8993
TEST_TIME 25 9451
TEST_TIME 26 9401
TEST_TIME 27 10607
TEST_TIME 28 10483
TEST_TIME 29 10317
TEST_TIME 30 10296
TEST_TIME 31 10255
TEST_TIME 32 10108
TEST_TIME 33 10392
TEST_TIME 34 10363
TEST_TIME 35 10255
TEST_TIME 36 10009
TEST_TIME 37 9901
TEST_TIME 38 9838
TEST_TIME 39 9770
TEST_TIME 40 9670
TEST_TIME 41 9674
TEST_TIME 42 9652
TEST_TIME 43 9584
TEST_TIME 44 9457
TEST_TIME 45 9344
TEST_TIME 46 9377
TEST_TIME 47 9338
TEST_TIME 48 9317
TEST_TIME 49 9365
TEST_TIME 50 9414
TEST_TIME 51 9486
TEST_TIME 52 9514
TEST_TIME 53 9472
TEST_TIME 54 9433
TEST_TIME 55 9389
TEST_TIME 56 9442
TEST_TIME 57 9389
TEST_TIME 58 9621
TEST_TIME 59 9607
TEST_TIME 60 9646
TEST_TIME 61 9683
TEST_TIME 62 9798
TEST_TIME 63 9755
TEST_TIME 64 9722
TEST_TIME 65 9612
TEST_TIME 66 9523
TEST_TIME 67 9528
TEST_TIME 68 9468
TEST_TIME 69 9401
TEST_TIME 70 9338
TEST_TIME 71 9295
TEST_TIME 72 9253
TEST_TIME 73 9207
TEST_TIME 74 9189
TEST_TIME 75 9164
TEST_TIME 76 9135
TEST_TIME 77 9042
TEST_TIME 78 9112
TEST_TIME 79 9064
TEST_TIME 80 9090
TEST_TIME 81 9090
TEST_TIME 82 9108
TEST_TIME 83 9097
TEST_TIME 84 9075
TEST_TIME 85 9141
TEST_TIME 86 9164
TEST_TIME 87 9150
TEST_TIME 88 9150
TEST_TIME 89 9213
TEST_TIME 90 9349
TEST_TIME 91 9351
TEST_TIME 92 9288
TEST_TIME 93 9214
TEST_TIME 94 9167
TEST_TIME 95 9133
TEST_TIME 96 9154
TEST_TIME 97 9110
TEST_TIME 98 9116
TEST_TIME 99 9122
TEST_TIME 100 9208
TEST_TIME 101 9213
TEST_TIME 102 9227
TEST_TIME 103 9219
TEST_TIME 104 9252
TEST_TIME 105 9238
TEST_TIME 106 9327
TEST_TIME 107 9366
TEST_TIME 108 9354
TEST_TIME 109 9379
TEST_TIME 110 9372
TEST_TIME 111 9347
TEST_TIME 112 9272
TEST_TIME 113 9298
TEST_TIME 114 9239
TEST_TIME 115 9265
TEST_TIME 116 9243
TEST_TIME 117 9222
TEST_TIME 118 9195
TEST_TIME 119 9160
TEST_TIME 120 9086

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 01-01-2021 16:29:54 to 01-01-2021 16:29:57.

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 1516676 1516676 0 0.00 0 32373 7 0 0
doc_list_biud 1516674 1516674 0 0.00 0 50537 25 0 0
sp_add_invoice_to_stock 5246 5127 119 2.26 36 176273 16503 0 119
sp_cancel_adding_invoice 5506 5506 0 0.00 5 49962 819 0 0
sp_cancel_client_order 1805 1805 0 0.00 4 26153 374 0 0
sp_cancel_customer_reserve 540998 540998 0 0.00 1 50539 54 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 3 3488 74 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 2 5356 75 0 0
sp_cancel_supplier_invoice 6109 6095 14 0.22 2 14903 812 0 14
sp_cancel_supplier_order 392 392 0 0.00 11 943381 96759 0 0
sp_cancel_write_off 9426 9426 0 0.00 1 5569 102 0 0
sp_client_order 20973 20973 0 0.00 3 48093 329 0 0
sp_customer_reserve 461338 461338 0 0.00 0 76279 166 0 0
sp_fill_shopping_cart 32231 32231 0 0.00 1 17797 40 0 0
sp_fill_shopping_cart_clo_res 461321 461321 0 0.00 0 15042 13 0 0
sp_get_clo_for_invoice 5110 5110 0 0.00 0 23961 289 0 0
sp_kill_cost_storno 16033 16033 0 0.00 0 9066 56 0 0
sp_kill_qstorno_ret_qs2qd 1097909 1097909 0 0.00 0 50529 30 0 0
sp_kill_qty_storno 579626 579626 0 0.00 0 50535 65 0 0
sp_lock_selected_doc 21172 21172 0 0.00 0 8421 6 0 0
sp_make_cost_storno 28706 28706 0 0.00 0 31651 73 0 0
sp_multiply_rows_for_pdistr 28704 28704 0 0.00 0 8107 31 0 0
sp_multiply_rows_for_qdistr 20973 20973 0 0.00 0 48083 142 0 0
sp_pay_from_customer 7368 7368 0 0.00 4 28356 124 0 0
sp_pay_to_supplier 5932 5932 0 0.00 4 29132 151 0 0
sp_payment_common 13300 13300 0 0.00 1 25283 30 0 0
sp_qd_handle_on_cancel_clo 1805 1805 0 0.00 0 26146 334 0 0
sp_qd_handle_on_invoice_upd_sts 10614 10614 0 0.00 0 47474 341 0 0
sp_qd_handle_on_reserve_upd_sts 10296 10296 0 0.00 0 23067 59 0 0
sp_reserve_write_off 10296 10296 0 0.00 7 32391 212 0 0
sp_supplier_invoice 5726 5726 0 0.00 7 93393 3501 0 0
sp_supplier_order 5539 5539 0 0.00 5 28045 1276 0 0
srv_aggregate_perf_data 108 108 0 0.00 2985 221971 20437 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 1279 177800 35787 0 0
srv_find_qd_qs_mism 1040953 1040953 0 0.00 0 16036 5 0 0
srv_make_invnt_saldo 602 602 0 0.00 40 37893 973 0 0
srv_make_money_saldo 851 851 0 0.00 0 3985 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 168346 425761 348751 0 0
t$perf-abend:sp_add_invoice_to_stock 119 119 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5127 5127 0 0.00 0 47985 186 0 0
t$perf-norm:sp_cancel_adding_invoice 426 426 0 0.00 0 3253 87 0 0
t$perf-norm:sp_cancel_client_order 1805 1805 0 0.00 0 1686 12 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 358 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 9129 20 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 3923 26 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 363 11 0 0
t$perf-norm:sp_cancel_supplier_order 392 392 0 0.00 0 18971 1582 0 0
t$perf-norm:sp_cancel_write_off 974 974 0 0.00 0 2351 10 0 0
t$perf-norm:sp_client_order 20973 20973 0 0.00 0 14939 22 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 1985 5 0 0
t$perf-norm:sp_pay_from_customer 7368 7368 0 0.00 0 8751 16 0 0
t$perf-norm:sp_pay_to_supplier 5932 5932 0 0.00 0 12204 12 0 0
t$perf-norm:sp_reserve_write_off 10296 10296 0 0.00 0 12025 13 0 0
t$perf-norm:sp_supplier_invoice 5726 5726 0 0.00 0 12118 18 0 0
t$perf-norm:sp_supplier_order 5539 5539 0 0.00 0 10594 19 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 211 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 582 6 0 0
t$perf-norm:srv_make_invnt_saldo 602 602 0 0.00 0 2590 25 0 0
t$perf-norm:srv_make_money_saldo 851 851 0 0.00 0 788 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10454 10216 238 2.27 0 8139 19 0 238
v_all_customers 38132 38132 0 0.00 0 273 1 0 0
v_all_suppliers 30944 30944 0 0.00 0 18 1 0 0
v_all_wares 41944 41944 0 0.00 0 273 1 0 0
v_cancel_adding_invoice 852 852 0 0.00 0 2678 10 0 0
v_cancel_client_order 3610 3610 0 0.00 0 964 3 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 2590 7 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 667 4 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 312 3 0 0
v_cancel_supplier_invoice 822 794 28 3.40 0 1308 16 0 28
v_cancel_supplier_order 784 784 0 0.00 0 373 3 0 0
v_cancel_write_off 1948 1948 0 0.00 0 2648 13 0 0
v_max_id_clo_ord 5535 5535 0 0.00 0 2402 2 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 2301 19 0 0
v_max_id_ord_sup 5724 5724 0 0.00 0 2587 2 0 0
v_max_non_paid_invoice 1719 1719 0 0.00 0 3841 6 0 0
v_max_non_paid_realizn 4035 4035 0 0.00 0 3959 6 0 0
v_min_id_clo_ord 5535 5535 0 0.00 0 5656 10 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 8773 17 0 0
v_min_id_ord_sup 5724 5724 0 0.00 0 4024 6 0 0
v_min_non_paid_invoice 5932 5932 0 0.00 0 4733 18 0 0
v_min_non_paid_realizn 7368 7368 0 0.00 0 6069 17 0 0
v_our_firm 10478 10478 0 0.00 0 20 1 0 0
v_reserve_write_off 20592 20592 0 0.00 0 2571 4 0 0
x_lock_depdocs_on_canc_invoice 11204 11204 0 0.00 0 17371 122 0 0
x_lock_depdocs_on_canc_sup_ord 392 392 0 0.00 0 8087 366 0 0
x_make_qstorno_1000_1200 5539 5539 0 0.00 2 28038 1187 0 0
x_make_qstorno_1200_2000 5726 5726 0 0.00 3 93354 3363 0 0
x_make_qstorno_2100_3300 461338 461338 0 0.00 0 76277 150 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-01-2021 16:29:58 to 01-01-2021 16:30:02.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:16 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:22 20994 8192000000 10273527024 10583420928 959419664 10.483 73 55 110 0 980081856 2632640 18029552
13:57:51 24833 8192000000 10338470336 10658279424 1388777440 14.495 100 83 167 0 1420131168 4716896 26636832
13:58:28 24769 8192000000 10368434560 10696749056 1423095184 14.800 100 81 162 1 1456088096 6122480 26870432
13:59:05 20813 8192000000 10402791424 10729693184 1458634528 15.114 100 90 182 0 1494760720 6580272 29545920
13:59:32 20156 8192000000 10419990976 10749308928 1472715968 15.238 100 96 192 0 1510471744 7113312 30642464
14:00:04 20956 8192000000 10448263984 10781986816 1504035648 15.511 100 92 185 0 1541118032 7898064 29184320
14:00:36 22121 8192000000 10462729520 10803556352 1522707632 15.674 100 89 177 1 1559016368 8529088 27779648
14:01:08 18651 8192000000 10481295856 10823618560 1531570512 15.751 100 86 172 1 1567574048 8682096 27321440
14:01:36 20234 8192000000 10501380112 10848030720 1553208784 15.938 100 76 152 0 1586377760 9014000 24154976
14:02:05 14307 8192000000 10526008512 10876194816 1583573360 16.199 100 80 160 0 1617246128 9754432 23918336
14:02:30 14886 8192000000 10553168992 10911834112 1607749648 16.406 100 73 142 1 1639363824 10223696 21390480
14:02:53 14093 8192000000 10574893776 10935189504 1633533376 16.625 100 81 162 1 1669085584 11035840 24516368
14:03:17 8130 8192000000 10590171216 10950361088 1650337232 16.767 100 87 174 1 1688449184 12555312 25556640
14:03:34 10467 8192000000 10609809552 10977812480 1664623184 16.888 100 71 142 0 1696562096 11513280 20425632
14:03:51 11083 8192000000 10628796368 10998845440 1688571152 17.089 100 80 159 0 1724107088 12395968 23139968
14:04:11 10425 8192000000 10649432784 11022495744 1709360288 17.263 100 82 164 4 1745238128 12651264 23226576
14:04:31 6959 8192000000 10654140592 11033182208 1721013680 17.361 100 74 148 2 1755756800 13486240 21256880
14:04:45 5160 8192000000 10678346176 11055824896 1738731696 17.508 100 76 152 3 1773380528 12349472 22299360
14:04:59 5445 8192000000 10688683968 11069087744 1748182816 17.587 100 72 145 0 1781830784 12933376 20714592
14:05:15 4455 8192000000 10701098608 11079856128 1762904944 17.708 100 81 162 0 1798919408 13146192 22868272
14:05:26 5196 8192000000 10711556656 11094306816 1768127744 17.752 100 72 145 0 1801100208 12985632 19986832
14:05:38 5462 8192000000 10705355552 11092201472 1773557136 17.796 100 74 146 2 1807917488 13521984 20838368
14:05:50 5437 8192000000 10728038640 11114405888 1782781088 17.872 100 78 157 4 1816086688 11487200 21818400
14:06:02 3777 8192000000 10733322496 11123855360 1799377120 18.009 100 68 137 2 1831163552 12009104 19777328
14:06:12 4516 8192000000 10747583088 11136421888 1810002272 18.096 100 79 158 0 1845240176 12716144 22521760
14:06:24 3348 8192000000 10758138208 11142660096 1819925600 18.177 100 87 172 1 1857868944 13873424 24069920
14:06:34 3606 8192000000 10762893712 11150299136 1826528160 18.231 100 82 164 2 1863748816 14627280 22593376
14:06:45 3554 8192000000 10761259840 11152523264 1827294192 18.237 100 84 164 3 1864350064 12322528 24733344
14:06:55 2951 8192000000 10778063920 11163480064 1830945904 18.267 100 74 145 0 1862845616 12138992 19760720
14:07:05 1874 8192000000 10781350992 11171065856 1838239264 18.326 100 83 166 0 1874952128 13095440 23617424
14:07:13 2484 8192000000 10784095808 11168669696 1845686704 18.387 100 89 177 1 1883392304 13301952 24403648
14:07:22 1661 8192000000 10793277568 11180470272 1848490464 18.410 100 91 184 0 1888493616 13519536 26483616
14:07:30 1762 8192000000 10794236032 11182915584 1848162560 18.407 100 90 180 0 1886439504 12958064 25318880
14:07:38 1787 8192000000 10790487648 11176644608 1850202096 18.424 100 88 176 0 1887612656 13140896 24269664
14:07:47 2246 8192000000 10794688816 11183595520 1852302208 18.441 100 88 177 0 1890561504 13372512 24886784
14:07:56 1345 8192000000 10799172016 11185061888 1856340112 18.474 100 89 175 1 1895184448 13929696 24914640
14:08:03 1772 8192000000 10793579360 11185381376 1858437184 18.491 100 94 189 0 1897924096 12972672 26514240
14:08:11 1241 8192000000 10808097280 11194531840 1860527664 18.508 100 95 191 2 1900094224 12274384 27292176
14:08:19 1646 8192000000 10805462816 11192115200 1860471328 18.507 100 90 178 0 1900372032 13479504 26421200
14:08:27 1113 8192000000 10809628976 11196366848 1863199776 18.529 100 89 180 1 1902625312 13967440 25458096
14:08:34 51014 8192000000 10792335536 11194503168 1858562544 18.492 100 52 106 2 1881532288 7800352 15169392
14:09:33 1367 8192000000 10818838720 11210248192 1874900512 18.624 100 87 178 5 1909383792 8711616 25771664
14:09:41 10052 8192000000 10818018336 11213066240 1872821024 18.607 100 69 138 1 1903105376 10583600 19700752
14:09:57 2326 8192000000 10798142512 11208859648 1870413696 18.588 100 66 132 0 1900843664 11654192 18775776
14:10:06 6118 8192000000 10785595408 11204149248 1864920928 18.543 100 35 70 0 1883749296 9210816 9617552
14:10:19 4153 8192000000 10777770496 11203731456 1867795936 18.566 100 43 86 1 1887605200 8144192 11665072
14:10:30 3530 8192000000 10801773104 11208458240 1870721568 18.590 100 43 85 1 1889971472 7227616 12022288
14:10:42 6217 8192000000 10783256480 11208773632 1871742272 18.598 100 36 72 4 1890505360 8357472 10405616
14:10:56 5773 8192000000 10777046752 11204558848 1869965440 18.584 100 24 48 2 1883860336 6364528 7530368
14:11:09 8661 8192000000 10784160320 11210223616 1871815168 18.599 100 26 51 1 1885305872 5911312 7579392
14:11:25 10464 8192000000 10794670832 11220520960 1876340176 18.636 100 28 55 0 1890263616 6672336 7251104
14:11:51 9667 8192000000 10791593584 11223457792 1884007472 18.697 100 24 48 0 1897507648 6933840 6566336
14:12:12 9271 8192000000 10802156768 11227627520 1884531920 18.702 100 18 35 1 1895761936 5716128 5513888
14:12:27 5548 8192000000 10795099056 11226181632 1886533536 18.718 100 21 42 2 1899362192 6421040 6407616
14:12:40 10194 8192000000 10786594896 11226755072 1888799504 18.736 100 20 40 2 1900926112 6694464 5432144
14:12:56 6160 8192000000 10826988560 11237720064 1898617152 18.815 100 58 119 3 1921624656 5983520 17023984
14:13:10 23004 8192000000 10807929872 11236773888 1893857280 18.777 100 31 62 3 1909050288 6162208 9030800
14:13:39 49781 8192000000 10820921712 11238830080 1896523536 18.798 100 47 94 2 1915608688 5004048 14081104
14:14:35 8744 8192000000 10808039648 11240558592 1890951248 18.753 100 15 30 0 1901449152 6570032 3927872
14:14:51 4992 8192000000 10812250784 11243466752 1895624720 18.791 100 30 59 0 1912761856 7958208 9178928
14:15:02 4378 8192000000 10824519760 11251916800 1898422160 18.814 100 41 83 3 1920293808 10481344 11390304
14:15:13 2973 8192000000 10818803392 11246776320 1899698240 18.824 100 32 63 0 1916293104 7803008 8791856
14:15:25 4428 8192000000 10815212160 11245723648 1894627584 18.783 100 35 70 2 1911542064 7385488 9528992
14:15:35 3728 8192000000 10817536080 11243810816 1893155600 18.771 100 47 93 1 1918634640 12402800 13076240
14:15:48 5670 8192000000 10803249296 11235770368 1892932096 18.769 100 36 73 3 1908248928 5367472 9949360
14:16:02 2849 8192000000 10818448208 11242250240 1894177184 18.779 100 34 68 4 1910056608 6786032 9093392
14:16:14 3642 8192000000 10810003968 11245064192 1899247536 18.820 100 27 54 1 1913739760 6064704 8427520
14:16:26 7867 8192000000 10808868256 11243851776 1896965840 18.802 100 20 40 0 1908692864 6127328 5599696
14:16:43 8899 8192000000 10811433552 11248082944 1898247504 18.812 100 18 36 0 1909130352 5696384 5186464
14:16:58 10606 8192000000 10801201200 11237543936 1880569776 18.670 99 18 36 2 1891161712 5656288 4935648
14:17:15 9257 8192000000 10778663072 11204534272 1828139008 18.244 97 23 45 4 1839595584 5055424 6401152
14:17:37 4164 8192000000 10750449808 11169411072 1799717616 18.012 98 18 37 0 1814559968 9912176 4930176
14:17:47 13271 8192000000 10755740416 11164426240 1775734512 17.814 96 27 54 2 1789636416 5720736 8181168
14:18:07 49091 8192000000 10728334768 11145375744 1726104384 17.403 94 24 47 1 1738466128 5465408 6896336
14:19:18 20053 8192000000 10721692992 11142664192 1705212208 17.229 93 20 40 0 1717251312 6069888 5969216
14:19:46 3952 8192000000 10738029744 11153342464 1803343872 18.041 99 41 82 0 1822984800 7112224 12528704
14:19:57 5694 8192000000 10727706336 11149041664 1777765424 17.831 97 39 78 0 1797831136 8249824 11815888
14:20:09 3357 8192000000 10730478544 11149185024 1818098752 18.162 100 45 89 0 1839768240 7983840 13685648
14:20:22 3955 8192000000 10738921584 11150237696 1813650400 18.126 100 40 80 1 1833025376 8149408 11225568
14:20:35 5733 8192000000 10714600752 11128217600 1774750192 17.806 98 37 75 0 1792190128 6739024 10700912
14:20:50 5839 8192000000 10703550112 11121262592 1755878768 17.650 97 36 72 2 1771505312 5544400 10082144
14:21:04 7727 8192000000 10698406192 11122102272 1762243056 17.703 98 25 49 1 1775833392 5184832 8405504
14:21:18 6163 8192000000 10694863040 11108667392 1761573616 17.697 97 28 57 0 1779687904 9800128 8314160
14:21:30 8070 8192000000 10722857920 11143090176 1807593520 18.076 100 26 52 0 1820726384 5586064 7546800
14:21:47 7502 8192000000 10727244688 11137019904 1766292080 17.736 97 15 30 2 1776350352 5546672 4511600
14:22:01 10686 8192000000 10754020000 11164172288 1805305040 18.057 99 21 42 2 1816310080 4910224 6094816
14:22:18 6569 8192000000 10754398672 11170717696 1829450416 18.255 100 35 70 2 1846331504 5614576 11266512
14:22:31 7181 8192000000 10753473360 11174002688 1813698144 18.126 99 19 38 1 1824006304 5078528 5229632
14:22:45 66079 8192000000 10737168976 11163578368 1766832416 17.741 96 41 78 1 1783240944 4701952 11706576
14:24:05 6616 8192000000 10757787392 11184812032 1844216560 18.375 100 24 49 1 1857228320 5839936 7171824
14:24:22 5132 8192000000 10776465296 11194306560 1851791840 18.437 100 35 69 0 1868050800 7238416 9020544
14:24:36 5049 8192000000 10767813776 11194580992 1857353920 18.482 100 40 80 1 1875774224 7491744 10928560
14:24:48 3550 8192000000 10784276800 11204132864 1860025520 18.503 100 37 73 2 1878662016 8784640 9851856
14:24:58 4645 8192000000 10789294720 11207135232 1864124064 18.537 100 35 67 1 1878932704 5642592 9166048
14:25:11 6232 8192000000 10771058368 11205992448 1859564048 18.500 100 22 44 0 1876362528 10168384 6630096
14:25:24 6250 8192000000 10771242864 11203428352 1865259408 18.546 100 33 66 2 1881710512 6271600 10179504
14:25:37 8281 8192000000 10776218176 11206422528 1866285840 18.554 100 23 46 1 1878656224 5389072 6981312
14:25:54 8360 8192000000 10772944912 11208761344 1863532896 18.532 100 18 36 1 1873908384 5382176 4993312
14:26:10 9261 8192000000 10778015984 11213283328 1867736016 18.566 100 15 29 1 1881788704 9920928 4131760
14:26:26 10849 8192000000 10771738768 11210772480 1870547840 18.589 100 22 44 5 1882343440 5876192 5919408
14:26:43 19440 8192000000 10787232080 11219357696 1871744976 18.598 100 14 28 0 1885538192 9418832 4374384
14:27:12 5578 8192000000 10819753808 11236794368 1894912800 18.785 100 27 55 2 1908294304 5596720 7784784
14:27:30 2404 8192000000 10837226544 11250200576 1909167552 18.900 100 52 99 3 1929871488 5994144 14709792
14:27:42 7408 8192000000 10831327040 11248828416 1897493616 18.806 99 61 122 2 1922760464 7817216 17449632
14:27:57 40209 8192000000 10860699360 11274620928 1918605088 18.976 100 48 96 0 1941533600 9662960 13265552
14:28:49 126748 8192000000 10873952688 11306860544 1934042160 19.099 100 45 90 0 1956995552 9989296 12964096
14:31:03 20335 8192000000 10873739056 11306930176 1927000800 19.043 99 24 48 2 1950598992 17127696 6470496
14:31:30 43252 8192000000 10895180016 11318812672 1953144384 19.252 100 52 104 1 1983000288 14671952 15183952
14:32:20 11655 8192000000 10884307952 11322150912 1961591360 19.319 100 41 82 1 1986927712 12636224 12700128
14:32:41 11113 8192000000 10904026640 11329486848 1965092208 19.346 100 44 89 0 1991003584 13013648 12897728
14:33:00 36822 8192000000 10907262736 11337498624 1970540800 19.390 100 44 88 1 1999078128 15583088 12954240
14:33:45 3018 8192000000 10920952720 11349532672 1976013152 19.433 100 59 118 0 2014938688 20223840 18701696
14:34:01 8276 8192000000 10908945152 11342778368 1977432784 19.444 100 50 99 1 2006186688 14537632 14216272
14:34:23 19937 8192000000 10919351408 11343101952 1969762560 19.384 100 60 120 0 2003565216 16216384 17586272
14:35:15 20369 8192000000 10926285280 11360690176 1984486688 19.500 100 48 96 0 2020331072 21568944 14275440
14:35:48 12367 8192000000 10927327632 11363291136 1990343600 19.547 100 63 126 3 2027678512 17917040 19417872
14:36:10 15750 8192000000 10938988240 11366572032 1986492496 19.516 100 47 94 0 2018908976 18041472 14375008
14:36:34 5204 8192000000 10954551776 11379105792 2000938960 19.630 100 64 127 0 2042298448 22132864 19226624
14:36:48 8014 8192000000 10948271984 11384131584 2002884480 19.645 100 52 104 1 2041653248 22830160 15938608
14:37:05 6891 8192000000 10958115616 11389280256 2008724032 19.691 100 58 112 1 2048007600 22087840 17195728
14:37:19 15125 8192000000 10965547008 11397214208 2012047808 19.718 100 61 119 1 2054819392 24610832 18160752
14:37:44 9797 8192000000 10957913152 11397623808 2010504256 19.705 100 57 113 1 2053461440 25365296 17591888
14:38:03 6491 8192000000 10967628160 11401891840 2011657728 19.715 100 61 118 3 2055722224 25696544 18367952
14:38:18 13587 8192000000 10966238528 11401797632 2013117440 19.726 100 58 115 1 2055220640 24366720 17736480
14:38:41 7900 8192000000 10974949616 11407302656 2015390752 19.744 100 57 113 3 2058441504 25656496 17394256
14:38:58 5538 8192000000 10953895984 11388116992 1974532000 19.421 98 68 137 1 2022516640 26894480 21090160
14:39:11 10722 8192000000 10953962384 11388465152 2003270768 19.649 100 58 116 3 2045062288 24044640 17746880
14:39:40 4884 8192000000 10950208256 11374247936 1981276976 19.475 99 65 128 0 2023667936 23271728 19119232
14:39:54 3678 8192000000 10927312400 11347406848 1950475296 19.230 98 69 138 0 1993524160 21916768 21132096
14:40:05 6708 8192000000 10931588528 11357712384 1972944416 19.409 100 64 128 0 2015477568 22717712 19815440
14:40:20 2152 8192000000 10954393504 11367153664 1983770368 19.495 100 66 132 1 2026113024 22813568 19529088
14:40:29 4977 8192000000 10946047088 11368595456 1986240448 19.514 100 71 141 3 2031352464 23031696 22080320
14:40:44 2214 8192000000 10954480976 11373752320 1989422544 19.539 100 72 143 0 2034960576 23889744 21648288
14:40:55 4271 8192000000 10975066672 11388297216 1999610576 19.620 100 86 172 1 2053755920 27781984 26363360
14:41:06 4010 8192000000 10957702688 11388735488 1998436400 19.610 100 66 130 1 2046594112 27778320 20379392
14:41:19 3745 8192000000 10952064480 11373862912 1982647312 19.486 99 77 152 1 2035696720 29749536 23299872
14:41:33 2301 8192000000 10929182112 11342266368 1961454864 19.318 99 81 161 2 2014211920 28530064 24226992
14:41:43 4652 8192000000 10958907760 11377139712 1985358976 19.507 100 75 148 3 2036557616 28246032 22952608
14:41:58 3213 8192000000 10918415696 11330838528 1937865392 19.130 98 67 134 1 1986075728 27032272 21178064
14:42:08 1615 8192000000 10946575536 11359739904 1977805744 19.447 100 82 160 2 2031138128 28295104 25037280
14:42:18 4523 8192000000 10937589904 11352047616 1940644656 19.152 98 82 164 1 1996922448 31058784 25219008
14:42:32 10890 8192000000 10933133584 11356434432 1966213488 19.355 100 60 120 1 2013872896 29407712 18251696
14:42:50 2626 8192000000 10930468944 11356921856 1954172928 19.260 99 58 116 0 2000027888 27456928 18398032
14:43:00 3382 8192000000 10933769776 11354292224 1966266624 19.356 100 72 143 0 2015456752 26892000 22298128
14:43:11 6284 8192000000 10931327440 11357417472 1971115072 19.394 100 56 110 0 2016448768 28149408 17184288
14:43:31 5837 8192000000 10950312096 11364896768 1973472816 19.413 100 78 156 0 2028535936 30918304 24144816
14:43:43 2647 8192000000 10953870160 11368665088 1974946256 19.425 100 89 170 1 2033373520 32470096 25957168
14:43:55 7123 8192000000 10948009424 11366649856 1973993456 19.417 100 73 146 1 2031206016 34106576 23105984
14:44:09 4304 8192000000 10951521040 11373957120 1974560976 19.422 100 69 138 0 2031229600 35478848 21189776
14:44:22 1956 8192000000 10948402128 11363172352 1965838880 19.352 100 87 174 1 2035578800 42594080 27145840
14:44:31 3017 8192000000 10941614576 11356782592 1951288896 19.237 99 77 154 2 2013785536 37851152 24645488
14:44:43 3748 8192000000 10948076960 11367399424 1969961552 19.385 100 68 136 1 2028364544 36444320 21958672
14:44:55 9182 8192000000 10941182320 11364642816 1970956800 19.393 100 74 148 2 2032098944 36842368 24299776
14:45:12 5943 8192000000 10945792304 11362394112 1962375648 19.325 99 68 134 0 2024382640 40417248 21589744
14:45:25 2674 8192000000 10955924512 11377790976 1961676176 19.319 99 70 140 1 2025956560 41762704 22517680
14:45:38 3219 8192000000 10973278528 11394060288 1987015760 19.520 100 82 163 1 2057746592 44574720 26156112
14:45:48 1787 8192000000 10984722048 11397087232 1992263440 19.562 100 94 190 2 2066869152 44682176 29923536
14:45:56 3556 8192000000 10982584608 11400052736 1995635888 19.588 100 80 159 0 2066437488 46224128 24577472
14:46:07 2946 8192000000 10986095696 11394322432 1984015520 19.496 100 94 188 1 2061491120 47925280 29550320
14:46:17 1979 8192000000 10967614208 11383353344 1974077360 19.418 100 92 184 1 2051550224 48040592 29432272
14:46:26 1278 8192000000 10964234672 11384713216 1979652992 19.462 100 87 176 0 2049161840 42744736 26764112
14:46:37 12020 8192000000 10953338096 11391500288 1976845344 19.440 100 49 98 2 2035356768 42184480 16326944
14:46:59 12757 8192000000 10933834448 11380310016 1962152160 19.323 99 49 98 1 2020238736 42367072 15719504
14:47:41 8265 8192000000 10939762288 11382571008 1969902128 19.385 100 42 84 3 2022330000 38936768 13491104
14:47:59 2314 8192000000 10941511696 11382120448 1969946928 19.385 100 50 98 2 2024222192 38272336 16002928
14:48:13 6182 8192000000 10948224672 11387154432 1979219872 19.459 100 51 102 1 2031168928 36032992 15916064
14:48:31 7713 8192000000 10945127776 11389083648 1979804768 19.463 100 43 87 0 2032302208 38918608 13578832
14:48:48 26808 8192000000 10913707344 11361284096 1929295872 19.061 98 29 58 0 1974132992 35265984 9571136
14:49:25 10114 8192000000 10896664256 11334508544 1921793184 19.001 98 34 68 1 1960984608 28629872 10561552
14:49:44 10275 8192000000 10905363504 11352064000 1949885152 19.226 100 33 66 0 1988057232 28259344 9912736
14:50:10 22099 8192000000 10888306656 11335958528 1879263664 18.659 96 22 44 2 1920321280 34403968 6653648
14:50:52 25309 8192000000 10900334032 11336814592 1908654960 18.896 98 29 58 0 1950007392 31529088 9823344
14:51:24 9244 8192000000 10903240576 11347537920 1941915696 19.162 100 36 68 2 1988054176 34156224 11982256
14:51:48 6712 8192000000 10899344544 11343654912 1941973504 19.163 100 42 85 2 1990917792 35624848 13319440
14:52:04 11225 8192000000 10908278992 11353870336 1947852704 19.209 100 39 77 2 1992810768 32122432 12835632
14:52:22 7167 8192000000 10913061968 11352432640 1933700848 19.096 99 49 99 2 1984589424 35610240 15278336
14:52:37 25770 8192000000 10894411904 11348471808 1903440832 18.854 98 25 50 0 1953283120 40831536 9010752
14:53:10 32765 8192000000 10885788688 11338207232 1914634624 18.944 99 19 38 3 1957819520 35584992 7599904
14:53:56 29258 8192000000 10877019552 11333697536 1914470112 18.943 100 25 50 3 1969073872 45860832 8742928
14:54:33 24382 8192000000 10849502192 11327340544 1894954000 18.786 99 10 20 2 1928412544 29820304 3638240
14:55:05 21364 8192000000 10850757920 11295571968 1887823408 18.728 98 20 40 1 1904231264 10525248 5882608
14:55:39 35095 8192000000 10850049552 11298000896 1887348896 18.724 98 14 28 1 1902625520 11340432 3936192
14:56:21 54680 8192000000 10875101456 11330609152 1907571440 18.887 99 18 36 1 1922732496 10974544 4186512
14:57:25 65729 8192000000 10899069728 11350147072 1937671728 19.128 99 17 33 1 1957389264 15334464 4383072
14:58:37 101141 8192000000 10920330832 11375001600 1956168592 19.276 99 13 26 0 1978648208 18623968 3855648
15:00:28 68547 8192000000 10876922928 11348439040 1891547856 18.758 96 16 32 1 1911671904 16096896 4027152
15:01:42 65214 8192000000 10881784304 11334615040 1925296128 19.029 98 12 24 0 1934806256 6293568 3216560
15:03:01 89893 8192000000 10917384064 11358507008 1948729840 19.216 99 28 56 0 1965458352 9137680 7590832
15:04:48 101989 8192000000 10893706400 11357540352 1960585024 19.311 100 25 50 1 1980539648 12728144 7226480
15:06:37 43518 8192000000 10907665984 11364081664 1977616560 19.446 100 39 80 2 1996777488 7088384 12072544
15:07:33 21382 8192000000 10918344128 11362861056 1957677856 19.288 99 56 109 2 1983400992 10435744 15287392
15:08:10 29314 8192000000 10901655392 11368452096 1974366816 19.420 100 30 60 1 1991554992 9095248 8092928
15:10:27 29974 8192000000 10905706144 11378552832 1964890480 19.345 99 14 26 1 1976784432 7669968 4223984
15:11:08 83173 8192000000 10923281216 11393175552 1990590800 19.548 100 18 36 0 2010743888 14838896 5314192
15:12:37 53310 8192000000 10928895200 11402534912 1992068112 19.560 100 15 30 0 2012484704 15857280 4559312
15:13:49 33757 8192000000 10944484112 11413241856 1999556848 19.619 100 13 25 2 2026623376 22941856 4124672
15:14:29 49797 8192000000 10942295888 11420459008 2012001568 19.717 100 21 41 2 2041773696 23294928 6477200
15:16:12 59990 8192000000 10907939024 11389476864 1950746384 19.232 98 21 42 0 1976864416 19421744 6696288
15:17:54 53534 8192000000 10905405056 11384475648 1952502384 19.246 98 16 32 1 1975400464 17827824 5070256
15:19:08 90880 8192000000 10901587664 11384963072 1927550160 19.047 97 4 8 0 1942007168 13457296 999712
15:20:45 25853 8192000000 10909358528 11365425152 1928169824 19.052 97 26 52 0 1945435744 10308096 6957824
15:21:20 9975 8192000000 10940176336 11385675776 1972412000 19.405 99 59 118 0 2000402224 11433360 16556864
15:21:48 71344 8192000000 10906302720 11370905600 1941517520 19.159 98 32 64 1 1966573008 16059808 8995680
15:23:07 43719 8192000000 10897128256 11360124928 1913353680 18.934 97 16 32 1 1933395056 15583792 4457584
15:23:58 69518 8192000000 10876164560 11351695360 1850685216 18.428 94 32 64 0 1876380720 15744272 9951232
15:25:20 97942 8192000000 10890637312 11362263040 1938757776 19.137 99 12 24 1 1957165904 15004640 3403488
15:27:06 48363 8192000000 10861848608 11327057920 1867971776 18.568 95 12 24 0 1881391696 10333680 3086240
15:28:02 88094 8192000000 10874136784 11344740352 1897404640 18.805 97 11 22 0 1912340800 12096752 2839408
15:29:36 177799 8192000000 10870649120 11325792256 1839994848 18.341 94 12 24 0 1854601968 11404704 3202416
15:32:49 66379 8192000000 10836437984 11284680704 1799306016 18.008 93 19 38 0 1811464720 7049552 5109152
15:34:02 49579 8192000000 10823645040 11306438656 1891329120 18.756 99 22 42 1 1905585520 8205296 6051104
15:35:00 71673 8192000000 10826049472 11303559168 1879908592 18.664 98 18 36 1 1892714608 8239744 4566272
15:36:18 75288 8192000000 10859381456 11327815680 1919535280 18.983 99 19 38 1 1936622336 11707216 5379840
15:37:44 70504 8192000000 10842591632 11319816192 1905814464 18.873 98 17 34 2 1918434784 8159664 4460656
15:39:31 70883 8192000000 10851352736 11323494400 1900159216 18.828 98 16 32 0 1915804912 10974384 4671312
15:40:49 37217 8192000000 10871827744 11336564736 1946746000 19.201 100 24 49 0 1966680832 12933744 7001088
15:41:33 13706 8192000000 10864157712 11336400896 1925269600 19.029 99 14 28 1 1943720464 15027280 3423584
15:41:59 47875 8192000000 10860687232 11334479872 1926720608 19.041 99 20 40 2 1939414160 7483072 5210480
15:42:53 62889 8192000000 10862341616 11339022336 1915432640 18.950 98 17 34 2 1927447952 7469248 4546064
15:44:09 87794 8192000000 10873094432 11355971584 1957206512 19.284 100 21 42 2 1974488544 10792272 6489760
15:45:43 64784 8192000000 10888929552 11367395328 1965459392 19.349 100 10 20 1 1981591984 13506304 2626288
15:47:12 56584 8192000000 10884863104 11356188672 1928726784 19.057 98 14 28 0 1941445264 9047584 3670896
15:48:15 27966 8192000000 10885955856 11345436672 1903306656 18.853 97 33 65 4 1921332064 8075936 9949472
15:48:49 15892 8192000000 10883625488 11335409664 1918221056 18.973 98 49 98 1 1941096016 8443104 14431856
15:49:14 18862 8192000000 10852631584 11309645824 1861481760 18.515 96 36 72 1 1881703472 10195616 10026096
15:49:39 62688 8192000000 10883560640 11334578176 1909226688 18.900 99 19 38 0 1923707200 9225056 5255456
15:50:52 29678 8192000000 10890133888 11343486976 1913807904 18.937 98 36 72 0 1935564480 12013904 9742672
15:51:33 63740 8192000000 10883269888 11355717632 1933497568 19.095 99 28 56 3 1956847632 16026848 7323216
15:52:47 35091 8192000000 10890560592 11356426240 1957576960 19.287 100 29 58 2 1977170032 10733152 8859920
15:53:31 55915 8192000000 10909396048 11365408768 1933770784 19.097 98 39 78 1 1954813328 9587120 11455424
15:54:38 47617 8192000000 10896315760 11360358400 1951818784 19.241 99 23 46 2 1970438368 11371056 7248528
15:55:37 68200 8192000000 10904686128 11373015040 1958697904 19.296 100 14 28 1 1978501904 15746864 4057136
15:57:06 124427 8192000000 10900461104 11368329216 1916550128 18.959 97 10 20 0 1939260928 19759072 2951728
15:59:17 114015 8192000000 10912629984 11373342720 1947543264 19.207 98 33 64 3 1963987040 7440608 9003168
16:01:23 19723 8192000000 10915424384 11370037248 1965394928 19.349 99 32 64 0 1985350400 10848832 9106640
16:01:49 45904 8192000000 10906196608 11382853632 1985896608 19.511 100 17 34 0 2002939136 12309536 4732992
16:02:55 67230 8192000000 10905008896 11394555904 1969655280 19.383 99 11 22 0 1986017456 13401984 2960192
16:04:17 37177 8192000000 10916667408 11392057344 1972134576 19.402 99 17 34 0 1987925552 10680624 5110352
16:05:00 98506 8192000000 10914578656 11377283072 1940978544 19.155 97 34 68 3 1968279344 16519088 10781712
16:06:47 55317 8192000000 10920485776 11397320704 1975434528 19.429 99 37 73 3 2000595792 14470816 10690448
16:07:53 77899 8192000000 10909145440 11379073024 1925327616 19.030 97 12 24 1 1940682064 11863696 3490752
16:09:27 96774 8192000000 10883687872 11348369408 1823737472 18.208 92 11 23 0 1838437248 11333808 3365968
16:11:19 59811 8192000000 10904205296 11378860032 1945497824 19.191 99 11 21 0 1967529456 18368272 3663360
16:12:26 79211 8192000000 10917118288 11400929280 1973368688 19.412 100 11 22 0 1994869744 18152384 3348672
16:13:51 107609 8192000000 10903710576 11368513536 1856152640 18.472 94 12 24 0 1878756608 19332208 3271760
16:15:48 105578 8192000000 10897908016 11351506944 1874966032 18.624 95 22 45 2 1894848832 13117728 6765072
16:17:45 82080 8192000000 10859571168 11337281536 1897089152 18.803 97 16 32 0 1913305456 10919088 5297216
16:19:34 117693 8192000000 10878500800 11348631552 1878500720 18.653 96 16 32 0 1894045776 11445184 4099872
16:21:43 9898 8192000000 10876659408 11343441920 1945530912 19.191 100 26 50 0 1965876960 12945264 7400784
16:22:00 50435 8192000000 10872677776 11347206144 1935417024 19.110 99 26 52 1 1951180144 8643008 7120112
16:22:57 92056 8192000000 10868803920 11347902464 1918951552 18.978 98 13 25 0 1930701040 8745776 3003712
16:24:35 29186 8192000000 10869229440 11346911232 1921563536 18.999 98 20 40 0 1938202368 11275792 5363040
16:25:18 69462 8192000000 10862794288 11332599808 1909595424 18.903 98 13 26 0 1928102688 15135488 3371776
16:26:37 47448 8192000000 10259150080 10676133888 1375000832 14.372 71 9 18 0 1391883792 14078800 2804160

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 01-01-2021 16:30:04 to 01-01-2021 16:30:35.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-01-2021 16:30:36 to 01-01-2021 16:30:38.

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          245253
MON$OLDEST_ACTIVE               245589
MON$OLDEST_SNAPSHOT             245589
MON$NEXT_TRANSACTION            245589
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                       2043232
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 ---
:194: 
:195: mscs-test-161.budzdorov.ru    Fri Jan  1 16:28:00 2021
:196:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:197: 
--- end of diff output ---

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

01.01.21 16:30:39. 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-01 16:30:41 No severe PSQL-related problems occured
01.01.21 16:30:42. End of report.