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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17455668 kB
MemAvailable 31454740 kB
Buffers 0 kB
Cached 14236924 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-04-05 16:27:25
DTS_END                         2021-04-05 16:27:25.7100
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/48016
TRN_ID                          236004
ATT_ID                          657
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: 8995.28 20375 1079433
customer order: creation 167.48 392 20098
customer order: refuse 14.90 356 1788
order to supplier: creation 44.46 1285 5335
order to supplier: removal 3.66 96475 439
invoice (draft): creation 44.01 3559 5281
invoice (draft): removal 51.58 816 6189
invoice accept: apply 39.66 18850 4759
invoice accept: cancel 46.11 789 5533
customer reserve: creation 3719.18 183 446302
customer reserve: removal 4585.17 60 550220
realization accept: apply 78.82 186 9458
realization accept: cancel 73.34 130 8801
payment from customer: creation 57.73 123 6927
payment from customer: removal 5.64 74 677
payment to supplier: creation 48.04 138 5765
payment to supplier: removal 3.29 92 395
service: total inventory turnovers 4.88 908 585
service: total monetary turnovers 6.41 34 769
service: aggregate perf. data 0.90 16161 108
service: refresh index statistics 0.03 266885 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1970
TEST_TIME 2 2617
TEST_TIME 3 3794
TEST_TIME 4 4305
TEST_TIME 5 4500
TEST_TIME 6 4528
TEST_TIME 7 4950
TEST_TIME 8 5444
TEST_TIME 9 5757
TEST_TIME 10 5891
TEST_TIME 11 6334
TEST_TIME 12 6353
TEST_TIME 13 6716
TEST_TIME 14 6966
TEST_TIME 15 7594
TEST_TIME 16 7587
TEST_TIME 17 7674
TEST_TIME 18 7716
TEST_TIME 19 7759
TEST_TIME 20 8411
TEST_TIME 21 8498
TEST_TIME 22 8663
TEST_TIME 23 8832
TEST_TIME 24 8802
TEST_TIME 25 9107
TEST_TIME 26 9642
TEST_TIME 27 10160
TEST_TIME 28 10507
TEST_TIME 29 10572
TEST_TIME 30 10753
TEST_TIME 31 10579
TEST_TIME 32 10418
TEST_TIME 33 10454
TEST_TIME 34 10264
TEST_TIME 35 10081
TEST_TIME 36 9925
TEST_TIME 37 9823
TEST_TIME 38 9814
TEST_TIME 39 9655
TEST_TIME 40 9790
TEST_TIME 41 9678
TEST_TIME 42 9593
TEST_TIME 43 9498
TEST_TIME 44 9573
TEST_TIME 45 9424
TEST_TIME 46 9296
TEST_TIME 47 9249
TEST_TIME 48 9170
TEST_TIME 49 9215
TEST_TIME 50 9173
TEST_TIME 51 9064
TEST_TIME 52 9036
TEST_TIME 53 8949
TEST_TIME 54 8979
TEST_TIME 55 8953
TEST_TIME 56 8947
TEST_TIME 57 8952
TEST_TIME 58 8931
TEST_TIME 59 9082
TEST_TIME 60 9071
TEST_TIME 61 9070
TEST_TIME 62 9036
TEST_TIME 63 9092
TEST_TIME 64 9136
TEST_TIME 65 9211
TEST_TIME 66 9177
TEST_TIME 67 9196
TEST_TIME 68 9304
TEST_TIME 69 9387
TEST_TIME 70 9287
TEST_TIME 71 9197
TEST_TIME 72 9164
TEST_TIME 73 9144
TEST_TIME 74 9100
TEST_TIME 75 9070
TEST_TIME 76 9136
TEST_TIME 77 9095
TEST_TIME 78 9125
TEST_TIME 79 9029
TEST_TIME 80 9003
TEST_TIME 81 8934
TEST_TIME 82 8933
TEST_TIME 83 8902
TEST_TIME 84 8948
TEST_TIME 85 8909
TEST_TIME 86 8951
TEST_TIME 87 8962
TEST_TIME 88 8947
TEST_TIME 89 8977
TEST_TIME 90 9036
TEST_TIME 91 9104
TEST_TIME 92 9092
TEST_TIME 93 9120
TEST_TIME 94 9119
TEST_TIME 95 9118
TEST_TIME 96 9182
TEST_TIME 97 9181
TEST_TIME 98 9125
TEST_TIME 99 9061
TEST_TIME 100 9025
TEST_TIME 101 9044
TEST_TIME 102 8993
TEST_TIME 103 8958
TEST_TIME 104 8927
TEST_TIME 105 8913
TEST_TIME 106 8972
TEST_TIME 107 8950
TEST_TIME 108 8935
TEST_TIME 109 8931
TEST_TIME 110 8978
TEST_TIME 111 8994
TEST_TIME 112 9066
TEST_TIME 113 9123
TEST_TIME 114 9127
TEST_TIME 115 9177
TEST_TIME 116 9145
TEST_TIME 117 9158
TEST_TIME 118 9122
TEST_TIME 119 9067
TEST_TIME 120 8996

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 05-04-2021 16:29:15 to 05-04-2021 16:29:19.

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 1492999 1492999 0 0.00 0 28220 6 0 0
doc_list_biud 1492999 1492999 0 0.00 0 29425 28 0 0
sp_add_invoice_to_stock 4894 4759 135 2.75 17 250766 18850 0 135
sp_cancel_adding_invoice 5533 5533 0 0.00 3 47093 790 0 0
sp_cancel_client_order 1788 1788 0 0.00 4 12015 356 0 0
sp_cancel_customer_reserve 550220 550220 0 0.00 1 26967 61 0 0
sp_cancel_pay_from_customer 677 677 0 0.00 2 3522 74 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 3226 92 0 0
sp_cancel_supplier_invoice 6199 6189 10 0.16 2 18949 816 0 10
sp_cancel_supplier_order 439 439 0 0.00 6 971732 96475 0 0
sp_cancel_write_off 8801 8801 0 0.00 1 16218 131 0 0
sp_client_order 20098 20098 0 0.00 3 49907 392 0 0
sp_customer_reserve 446302 446302 0 0.00 0 44915 183 0 0
sp_fill_shopping_cart 30696 30696 0 0.00 1 15849 39 0 0
sp_fill_shopping_cart_clo_res 446300 446300 0 0.00 0 25606 16 0 0
sp_get_clo_for_invoice 4755 4755 0 0.00 0 20676 372 0 0
sp_kill_cost_storno 15406 15406 0 0.00 0 16215 57 0 0
sp_kill_qstorno_ret_qs2qd 1115869 1115869 0 0.00 0 26942 33 0 0
sp_kill_qty_storno 587183 587183 0 0.00 0 29420 72 0 0
sp_lock_selected_doc 19940 19940 0 0.00 0 8619 7 0 0
sp_make_cost_storno 26905 26905 0 0.00 0 28211 57 0 0
sp_multiply_rows_for_pdistr 26905 26905 0 0.00 0 8255 27 0 0
sp_multiply_rows_for_qdistr 20098 20098 0 0.00 0 49691 169 0 0
sp_pay_from_customer 6927 6927 0 0.00 4 22382 123 0 0
sp_pay_to_supplier 5765 5765 0 0.00 5 19100 139 0 0
sp_payment_common 12692 12692 0 0.00 1 22376 35 0 0
sp_qd_handle_on_cancel_clo 1788 1788 0 0.00 0 12005 320 0 0
sp_qd_handle_on_invoice_upd_sts 10288 10288 0 0.00 0 29412 348 0 0
sp_qd_handle_on_reserve_upd_sts 9458 9458 0 0.00 0 15234 61 0 0
sp_reserve_write_off 9458 9458 0 0.00 6 22930 186 0 0
sp_supplier_invoice 5281 5281 0 0.00 6 93485 3560 0 0
sp_supplier_order 5335 5335 0 0.00 5 63758 1286 0 0
srv_aggregate_perf_data 108 108 0 0.00 2823 95736 16162 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1318 161050 32604 0 0
srv_find_qd_qs_mism 1033216 1033216 0 0.00 0 15352 5 0 0
srv_make_invnt_saldo 585 585 0 0.00 25 41520 909 0 0
srv_make_money_saldo 769 769 0 0.00 1 4368 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 122802 472109 266886 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4759 4759 0 0.00 0 30651 206 0 0
t$perf-norm:sp_cancel_adding_invoice 374 374 0 0.00 0 8224 136 0 0
t$perf-norm:sp_cancel_client_order 1788 1788 0 0.00 0 5580 13 0 0
t$perf-norm:sp_cancel_customer_reserve 649 649 0 0.00 0 2673 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 677 677 0 0.00 0 30157 60 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 377 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 2211 20 0 0
t$perf-norm:sp_cancel_supplier_order 439 439 0 0.00 0 36000 1533 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 3910 15 0 0
t$perf-norm:sp_client_order 20098 20098 0 0.00 0 32607 19 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 2528 7 0 0
t$perf-norm:sp_pay_from_customer 6927 6927 0 0.00 0 32718 19 0 0
t$perf-norm:sp_pay_to_supplier 5765 5765 0 0.00 0 7400 10 0 0
t$perf-norm:sp_reserve_write_off 9458 9458 0 0.00 0 24841 15 0 0
t$perf-norm:sp_supplier_invoice 5281 5281 0 0.00 0 3084 19 0 0
t$perf-norm:sp_supplier_order 5335 5335 0 0.00 0 5242 17 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 195 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 4707 36 0 0
t$perf-norm:srv_make_invnt_saldo 585 585 0 0.00 0 5662 29 0 0
t$perf-norm:srv_make_money_saldo 769 769 0 0.00 0 7364 31 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 8 4 0 0
v_add_invoice_to_stock 9780 9510 270 2.76 0 7018 22 0 270
v_all_customers 36610 36610 0 0.00 0 17 1 0 0
v_all_suppliers 29568 29568 0 0.00 0 31 1 0 0
v_all_wares 40196 40196 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 748 748 0 0.00 0 3249 11 0 0
v_cancel_client_order 3576 3576 0 0.00 0 3454 6 0 0
v_cancel_customer_prepayment 1354 1354 0 0.00 0 3510 10 0 0
v_cancel_customer_reserve 1298 1298 0 0.00 0 3833 8 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 3188 16 0 0
v_cancel_supplier_invoice 830 810 20 2.40 0 1396 20 0 20
v_cancel_supplier_order 878 878 0 0.00 0 4114 15 0 0
v_cancel_write_off 2000 2000 0 0.00 0 3439 14 0 0
v_max_id_clo_ord 5335 5335 0 0.00 0 2892 2 0 0
v_max_id_clo_res 995 995 0 0.00 0 9972 39 0 0
v_max_id_ord_sup 5263 5263 0 0.00 0 4183 4 0 0
v_max_non_paid_invoice 1579 1579 0 0.00 0 1238 3 0 0
v_max_non_paid_realizn 3727 3727 0 0.00 0 6141 6 0 0
v_min_id_clo_ord 5335 5335 0 0.00 0 1204 5 0 0
v_min_id_clo_res 995 995 0 0.00 0 5781 35 0 0
v_min_id_ord_sup 5263 5263 0 0.00 0 3672 4 0 0
v_min_non_paid_invoice 5765 5765 0 0.00 0 18946 25 0 0
v_min_non_paid_realizn 6927 6927 0 0.00 0 22370 25 0 0
v_our_firm 9986 9986 0 0.00 0 23 1 0 0
v_reserve_write_off 18916 18916 0 0.00 0 6867 8 0 0
x_lock_depdocs_on_canc_invoice 11317 11317 0 0.00 0 9399 115 0 0
x_lock_depdocs_on_canc_sup_ord 439 439 0 0.00 0 7540 323 0 0
x_make_qstorno_1000_1200 5335 5335 0 0.00 2 63749 1208 0 0
x_make_qstorno_1200_2000 5281 5281 0 0.00 3 93467 3414 0 0
x_make_qstorno_2100_3300 446302 446302 0 0.00 0 44871 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2021 16:29:20 to 05-04-2021 16:29:24.

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:29 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:35 10176 8192000000 10139623424 10438664192 847529072 9.375 68 46 91 1 864917856 2237632 15151152
13:57:53 26352 8192000000 10307268224 10620895232 1353164736 14.176 100 80 160 0 1383682240 4059824 26457680
13:58:29 22388 8192000000 10346810160 10665312256 1406367632 14.652 100 86 173 0 1439841952 5685360 27788960
13:59:01 30287 8192000000 10388340736 10710933504 1440012928 14.950 100 91 182 0 1476544352 6791408 29740016
13:59:39 29492 8192000000 10418926656 10748162048 1469312576 15.208 100 93 186 0 1507264080 8146704 29804800
14:00:17 17711 8192000000 10435743344 10767765504 1490276608 15.391 100 94 188 2 1529981248 9212912 30491728
14:00:44 22454 8192000000 10452654544 10787315712 1504760240 15.518 100 87 174 1 1541538400 9720560 27057600
14:01:18 11420 8192000000 10452694432 10792075264 1514349856 15.601 100 84 168 1 1550863328 10257152 26256320
14:01:46 20842 8192000000 10495960288 10843045888 1548949408 15.901 100 73 146 1 1581784768 10123648 22711712
14:02:16 18121 8192000000 10525493856 10876690432 1579720432 16.166 100 81 162 2 1615762608 10509632 25532544
14:02:41 13338 8192000000 10546383840 10898223104 1601443168 16.352 100 80 160 0 1636456800 10585648 24427984
14:03:04 11311 8192000000 10567794672 10925764608 1622141936 16.528 100 76 152 2 1656735392 11576608 23016848
14:03:32 8601 8192000000 10592468880 10952482816 1657339984 16.826 100 83 166 0 1693716528 12138752 24237792
14:03:48 7371 8192000000 10619819280 10981576704 1677654656 16.998 100 87 174 3 1715968064 12948640 25364768
14:04:02 11006 8192000000 10625377344 10991505408 1683539808 17.047 100 84 165 2 1720912944 13189408 24183728
14:04:20 8881 8192000000 10642989136 11011645440 1704371552 17.222 100 87 172 2 1742527088 13507888 24647648
14:04:37 6222 8192000000 10646969616 11020328960 1707331936 17.246 100 78 155 1 1743868832 13885936 22650960
14:04:50 7123 8192000000 10663149936 11037417472 1721152384 17.362 100 82 164 0 1758003744 13691712 23159648
14:05:05 5411 8192000000 10664425040 11041755136 1733598640 17.465 100 78 156 0 1767786944 11705920 22482384
14:05:18 3662 8192000000 10692361056 11063144448 1749171408 17.595 100 76 148 2 1782656688 12384544 21100736
14:05:28 4484 8192000000 10702804192 11080699904 1766039424 17.734 100 83 164 3 1802127328 13162384 22925520
14:05:39 4234 8192000000 10713916848 11096780800 1780277696 17.852 100 86 173 2 1817326656 12607968 24440992
14:05:50 2598 8192000000 10728323936 11108716544 1789327824 17.926 100 90 178 1 1826319216 12177264 24814128
14:06:00 2969 8192000000 10724515424 11107381248 1790985344 17.940 100 81 162 1 1827322960 13783424 22554192
14:06:09 1976 8192000000 10739410784 11117883392 1798858352 18.005 100 89 179 2 1837926400 13526096 25541952
14:06:17 2573 8192000000 10752882240 11131838464 1806569584 18.068 100 86 172 1 1843862336 13681008 23611744
14:06:26 2964 8192000000 10747779984 11132243968 1810705600 18.102 100 83 166 1 1847599984 13738448 23155936
14:06:37 4277 8192000000 10751984576 11137032192 1815485824 18.141 100 79 159 0 1850752240 13425808 21840608
14:06:47 2618 8192000000 10781438752 11166351360 1835742912 18.306 100 86 172 0 1873113504 13951440 23419152
14:06:56 1835 8192000000 10785050336 11170902016 1843025440 18.365 100 93 187 0 1882854672 13801824 26027408
14:07:04 2835 8192000000 10790942128 11179077632 1852516912 18.443 100 89 179 1 1891717408 13725024 25475472
14:07:14 1700 8192000000 10794322480 11185848320 1853284848 18.449 100 87 174 0 1890523296 13564064 23674384
14:07:22 1845 8192000000 10803618512 11191484416 1861515712 18.516 100 88 176 1 1898484720 12353504 24615504
14:07:30 2429 8192000000 10800414240 11190902784 1862031840 18.520 100 87 174 2 1898333152 12044640 24256672
14:07:40 1815 8192000000 10809403760 11197988864 1866844880 18.559 100 89 178 2 1905410624 13224016 25341728
14:07:48 1349 8192000000 10820798496 11210035200 1868679936 18.574 100 93 181 1 1912699776 17941392 26078448
14:07:56 1968 8192000000 10815729488 11206656000 1869737344 18.582 100 89 177 0 1908033104 13077648 25218112
14:08:05 6082 8192000000 10818008016 11210117120 1871809856 18.599 100 81 162 1 1907512768 13528208 22174704
14:08:18 12058 8192000000 10817082992 11208257536 1873659136 18.614 100 70 139 1 1903884416 11617728 18607552
14:08:36 34156 8192000000 10779337216 11206471680 1872443504 18.604 100 41 82 2 1893119872 9386672 11289696
14:09:18 3797 8192000000 10781623488 11205058560 1874274320 18.619 100 39 79 1 1892580864 6408624 11897920
14:09:29 4783 8192000000 10790476384 11209035776 1873888656 18.616 100 41 77 2 1891128944 6443312 10796976
14:09:44 7370 8192000000 10787863872 11210924032 1875786896 18.631 100 25 50 1 1889597520 6173712 7636912
14:09:59 7931 8192000000 10789128976 11216134144 1877278480 18.643 100 24 48 2 1890460896 6408336 6774080
14:10:13 5966 8192000000 10804948928 11222708224 1882331952 18.684 100 34 68 0 1900498336 7536352 10630032
14:10:27 7684 8192000000 10798093616 11226001408 1886055792 18.714 100 30 60 2 1902650048 8488816 8105440
14:10:42 7040 8192000000 10793717744 11229220864 1890568512 18.750 100 28 55 2 1905656144 6524848 8562784
14:10:55 10851 8192000000 10795751440 11230003200 1892005184 18.762 100 20 40 1 1903746336 6202576 5538576
14:11:14 8397 8192000000 10807871568 11235377152 1896237200 18.796 100 25 51 2 1910516784 7471264 6808320
14:11:30 5754 8192000000 10803404688 11236712448 1898309344 18.813 100 22 43 2 1911179728 6614736 6255648
14:11:43 6667 8192000000 10803729904 11243237376 1902938752 18.850 100 22 44 1 1915838512 6739952 6159808
14:11:55 8748 8192000000 10816284768 11248025600 1904229040 18.860 100 21 40 1 1916452080 6889328 5333712
14:12:12 10804 8192000000 10811959184 11245477888 1904629056 18.864 100 13 26 2 1914179616 5692960 3857600
14:12:29 4422 8192000000 10813585728 11245969408 1906624960 18.880 100 24 48 2 1920524912 6937440 6962512
14:12:40 9303 8192000000 10833499824 11254591488 1914834240 18.945 100 45 91 1 1933359264 6232144 12292880
14:12:58 50805 8192000000 10842498864 11271991296 1910570592 18.911 100 24 48 1 1927723344 10366048 6786704
14:14:08 18607 8192000000 10823582240 11262484480 1911307872 18.917 100 22 42 0 1922915904 5073120 6534912
14:14:35 5519 8192000000 10837987120 11270868992 1915644448 18.952 100 35 70 0 1932798192 7644912 9508832
14:14:50 5239 8192000000 10834590288 11268419584 1914288176 18.941 100 28 55 1 1929463728 7107520 8068032
14:15:01 3583 8192000000 10835899456 11268763648 1919168352 18.980 100 31 62 0 1933473392 5343984 8961056
14:15:11 4640 8192000000 10839003472 11268321280 1915729984 18.953 100 36 72 0 1933614480 7542112 10342384
14:15:26 8578 8192000000 10823541472 11251613696 1896743552 18.800 99 25 48 2 1910022464 6724736 6554176
14:15:43 6762 8192000000 10835167136 11265437696 1911168400 18.916 100 29 54 3 1925393152 5716560 8508192
14:15:57 3694 8192000000 10821261536 11259342848 1896087888 18.795 99 29 58 2 1910013648 5911808 8013952
14:16:07 7097 8192000000 10814583680 11247464448 1886438832 18.717 99 20 40 0 1898215888 6397264 5379792
14:16:20 5132 8192000000 10826788448 11259297792 1906684704 18.880 100 31 59 2 1921162688 5616240 8861744
14:16:35 6997 8192000000 10819492288 11250765824 1900988416 18.834 100 21 42 0 1912061264 4797392 6275456
14:16:48 9449 8192000000 10788270640 11215523840 1822250096 18.196 96 25 50 1 1835437888 6083360 7104432
14:17:04 8570 8192000000 10761923616 11189395456 1823442016 18.206 97 18 35 1 1833983696 5451712 5089968
14:17:20 11321 8192000000 10781253520 11208159232 1845938512 18.389 99 12 24 0 1855834608 5533824 4362272
14:17:42 7557 8192000000 10757805504 11187941376 1829942160 18.259 99 17 34 3 1840853056 6164048 4746848
14:17:57 64260 8192000000 10757484464 11164520448 1769255424 17.761 96 35 70 0 1784879136 5191840 10431872
14:19:08 8190 8192000000 10741787200 11176898560 1818100864 18.162 99 25 50 2 1832108272 7183184 6824224
14:19:23 10576 8192000000 10707741680 11115835392 1711600848 17.282 93 24 46 1 1724400784 5777680 7022256
14:19:41 5694 8192000000 10722286288 11133472768 1773498448 17.796 98 41 82 1 1792751520 7418752 11834320
14:19:56 6367 8192000000 10697194672 11110019072 1750042080 17.602 98 20 40 1 1762157680 6341552 5774048
14:20:10 5894 8192000000 10687640528 11094700032 1736385248 17.489 98 33 66 0 1753339616 7838144 9116224
14:20:22 5941 8192000000 10690946592 11092164608 1715713744 17.316 96 40 80 0 1734301760 6446096 12141920
14:20:34 5720 8192000000 10706924512 11122524160 1791388864 17.943 100 39 78 1 1810683824 7748592 11546368
14:20:48 6561 8192000000 10721894720 11134545920 1797469728 17.993 100 27 53 0 1810147216 5490192 7187296
14:21:03 10243 8192000000 10726244384 11133210624 1769116240 17.760 98 33 66 2 1783638464 4929712 9592512
14:21:21 6572 8192000000 10706485984 11130003456 1781315552 17.860 99 17 34 0 1791471168 4853360 5302256
14:21:35 7595 8192000000 10710731936 11125301248 1753453792 17.630 97 24 49 2 1765990976 5093216 7443968
14:21:51 50734 8192000000 10725575968 11136606208 1760766144 17.691 97 31 62 2 1775577408 5047280 9763984
14:22:52 24812 8192000000 10731700960 11159617536 1815003168 18.137 100 23 46 1 1826768176 5279952 6485056
14:23:27 9980 8192000000 10754211472 11173277696 1831627120 18.273 100 34 68 0 1847553104 6258240 9667744
14:23:43 6144 8192000000 10760083408 11181731840 1839348160 18.336 100 32 62 1 1854344448 6576960 8419328
14:23:57 5530 8192000000 10767838592 11190611968 1847547648 18.402 100 40 79 1 1866765168 8296512 10921008
14:24:09 8214 8192000000 10766885696 11186098176 1845648640 18.387 100 15 30 1 1854854496 5181616 4024240
14:24:24 10537 8192000000 10767486832 11190824960 1848824304 18.413 100 33 65 0 1864247552 6263264 9159984
14:24:44 5914 8192000000 10769580096 11191377920 1848786256 18.412 100 24 48 0 1861353696 5732800 6834640
14:24:58 6026 8192000000 10781568832 11210039296 1857221760 18.481 100 29 58 1 1875995120 10478560 8294800
14:25:10 10911 8192000000 10770367424 11203411968 1860607072 18.508 100 22 44 2 1873362816 5636160 7119584
14:25:29 10369 8192000000 10781844544 11209555968 1863106736 18.528 100 17 34 1 1873164944 5583648 4474560
14:25:47 9758 8192000000 10779636944 11214639104 1869299552 18.579 100 15 29 2 1879107360 5657696 4150112
14:26:06 6476 8192000000 10784698784 11220508672 1871185984 18.594 100 21 42 1 1882951728 6100576 5665168
14:26:24 9029 8192000000 10791141920 11224457216 1874337632 18.619 100 14 29 1 1884135648 5365920 4432096
14:26:39 12309 8192000000 10785602592 11221540864 1864548096 18.540 99 38 75 1 1884897632 10415104 9934432
14:26:58 84834 8192000000 10822478592 11244310528 1887615456 18.727 100 44 84 3 1903513664 4044800 11853408
14:28:35 14714 8192000000 10829985632 11252457472 1900217456 18.828 100 30 60 0 1915015472 6824832 7973184
14:29:02 16096 8192000000 10840346048 11262021632 1911141584 18.916 100 39 77 3 1929543200 7412288 10989328
14:29:28 15159 8192000000 10850019072 11273121792 1917524032 18.967 100 36 71 1 1935414432 8031504 9858896
14:30:03 20373 8192000000 10862941184 11291123712 1931999216 19.083 100 44 88 0 1955222112 10547920 12674976
14:30:36 16399 8192000000 10877654912 11306012672 1942942640 19.170 100 38 75 0 1965753808 12254704 10556464
14:31:01 21045 8192000000 10890586320 11313266688 1948937408 19.218 100 40 80 2 1973199104 12769808 11491888
14:31:30 28541 8192000000 10891906320 11327488000 1952862976 19.249 100 37 74 0 1979646848 15674560 11109312
14:32:05 15666 8192000000 10891081120 11333570560 1956780448 19.280 100 31 62 1 1983874656 18072672 9021536
14:32:38 15530 8192000000 10897187664 11328663552 1962234768 19.324 100 38 76 0 1988008656 13957968 11815920
14:33:04 20566 8192000000 10911796064 11337592832 1966515056 19.358 100 44 87 0 1994089840 14383856 13190928
14:33:36 11777 8192000000 10918136416 11345346560 1970598256 19.390 100 46 92 0 2000332672 15647008 14087408
14:33:58 13979 8192000000 10910696864 11344302080 1974820352 19.424 100 51 101 2 2005718000 14906992 15990656
14:34:21 3028 8192000000 10926303472 11354820608 1979802048 19.463 100 54 107 0 2014880416 19124656 15953712
14:34:37 7329 8192000000 10929608288 11360956416 1983627136 19.493 100 56 112 0 2017833312 17245264 16960912
14:34:53 4809 8192000000 10933763392 11359584256 1969073040 19.378 99 62 122 0 2004913184 18037344 17802800
14:35:13 27880 8192000000 10922872672 11365572608 1982155248 19.482 100 41 82 0 2013494480 18517664 12821568
14:35:48 4936 8192000000 10927641584 11356512256 1974820864 19.424 100 55 110 1 2012460464 21244848 16394752
14:36:05 9654 8192000000 10929173840 11362553856 1982640112 19.486 100 55 109 0 2018466704 19403360 16423232
14:36:23 10182 8192000000 10921198112 11361382400 1981754976 19.479 100 49 98 0 2014945184 18576304 14613904
14:36:42 2959 8192000000 10922450512 11355684864 1979626784 19.462 100 59 119 0 2015947312 17896688 18423840
14:36:53 15209 8192000000 10936669472 11361669120 1980111440 19.466 100 60 119 0 2020121984 22649744 17360800
14:37:16 1317 8192000000 10965284032 11377278976 1994483328 19.579 100 83 165 1 2041882288 24231696 23167264
14:37:26 2849 8192000000 10942759776 11368161280 1973017104 19.409 99 66 132 0 2019217648 26544272 19656272
14:37:38 8141 8192000000 10955675776 11382493184 1998996192 19.615 100 75 150 2 2048911440 27704480 22210768
14:37:56 3090 8192000000 10974811056 11397603328 2009051744 19.694 100 85 170 2 2061161552 27432464 24677344
14:38:05 4442 8192000000 10979573376 11402616832 2011075056 19.710 100 79 158 0 2062305584 28563376 22667152
14:38:17 2157 8192000000 10992422048 11407740928 2017536576 19.761 100 87 174 1 2074212352 30349184 26326592
14:38:26 5208 8192000000 10967960256 11399630848 2012129264 19.718 100 78 154 2 2061810576 26733552 22947760
14:38:38 6427 8192000000 10959304272 11386408960 1994789072 19.582 99 73 146 1 2045523840 29066704 21668064
14:38:52 5515 8192000000 10981933376 11406278656 2006031024 19.670 100 72 140 0 2056039824 29935536 20073264
14:39:05 3146 8192000000 10981858848 11407863808 2005933248 19.669 100 78 156 0 2059395600 30533856 22928496
14:39:16 23528 8192000000 10982706016 11414642688 2014033184 19.733 100 68 136 0 2068384784 33786352 20565248
14:39:55 3458 8192000000 10955491680 11386617856 1975810992 19.432 99 58 116 2 2030822800 36970880 18040928
14:40:08 3817 8192000000 10969348208 11404709888 1998081808 19.608 100 60 117 2 2053791232 37723792 17985632
14:40:19 3921 8192000000 10986435632 11412328448 2009425328 19.697 100 74 147 0 2070758784 38945376 22388080
14:40:32 3315 8192000000 10986980880 11407446016 2005761088 19.668 100 89 178 0 2070244640 37407440 27076112
14:40:45 10018 8192000000 10981668096 11412066304 2004774608 19.660 100 64 128 1 2064145728 40086496 19284624
14:41:02 3524 8192000000 10991613504 11416051712 2008098400 19.687 100 81 159 4 2072764720 40757088 23909232
14:41:13 1502 8192000000 10972467136 11391254528 1985649232 19.509 100 86 171 0 2054929696 42346368 26934096
14:41:24 4023 8192000000 10962252592 11385655296 1983182080 19.490 100 87 174 2 2053546544 43279168 27085296
14:41:36 6363 8192000000 10958861760 11390373888 1981824080 19.479 100 64 128 1 2045817008 43977392 20015536
14:41:52 2291 8192000000 10954491152 11385245696 1966037088 19.354 99 76 151 0 2030403920 40151008 24215824
14:42:01 4082 8192000000 10969275712 11384639488 1974120576 19.418 99 85 170 1 2045011568 44727296 26163696
14:42:12 7939 8192000000 10960119824 11384451072 1981456864 19.476 100 67 133 3 2042190048 40152112 20581072
14:42:28 1516 8192000000 10956141744 11370156032 1965925328 19.353 99 93 182 0 2034194080 40880864 27387888
14:42:38 2758 8192000000 10945230928 11361886208 1953066624 19.251 99 84 166 1 2021168672 42401152 25700896
14:42:53 4092 8192000000 10955970256 11372650496 1971980112 19.401 100 82 164 0 2035092368 37706496 25405760
14:43:04 3150 8192000000 10966075120 11381379072 1984969376 19.504 100 86 170 1 2048992960 37423648 26599936
14:43:14 3248 8192000000 10957890976 11371991040 1974041296 19.417 100 91 181 2 2039588496 38017264 27529936
14:43:24 1734 8192000000 10951762576 11367411712 1969106944 19.378 100 78 154 2 2031504944 38474112 23923888
14:43:35 3562 8192000000 10965894288 11382059008 1981601840 19.477 100 83 168 2 2047974224 40199440 26172944
14:43:45 3376 8192000000 10972261184 11391479808 1987100832 19.521 100 80 159 0 2052172640 40009840 25061968
14:43:58 3531 8192000000 10963336848 11390476288 1985092784 19.505 100 68 136 3 2046837600 40058224 21686592
14:44:10 2234 8192000000 10939501840 11360993280 1965067072 19.346 99 72 144 1 2026646656 38706496 22873088
14:44:18 2925 8192000000 10969825568 11386720256 1982274848 19.483 100 83 166 1 2047639120 39135600 26228672
14:44:29 2203 8192000000 10975831120 11391913984 1986189808 19.514 100 77 150 0 2049169328 39261632 23717888
14:44:40 2875 8192000000 10942205728 11365818368 1959381168 19.301 99 73 144 1 2021918976 40029920 22507888
14:44:53 9371 8192000000 10946676768 11366150144 1950924480 19.234 99 75 148 4 2015899200 42160832 22813888
14:45:11 2356 8192000000 10947274144 11368513536 1964283936 19.340 100 69 135 1 2030930448 45439712 21206800
14:45:23 3724 8192000000 10969179088 11384782848 1976322112 19.436 100 76 152 0 2045992560 45534416 24136032
14:45:34 5185 8192000000 10971802432 11393839104 1985489840 19.508 100 73 146 0 2053364624 45397808 22476976
14:45:48 3944 8192000000 10965931552 11385950208 1966335376 19.356 99 76 152 1 2036064656 45858112 23871168
14:45:59 2387 8192000000 10945304544 11359911936 1953899120 19.258 99 77 152 2 2023631984 45580736 24152128
14:46:10 2230 8192000000 10966154016 11380363264 1970722576 19.391 100 85 170 2 2046320672 49541568 26056528
14:46:25 8468 8192000000 10953485024 11384717312 1967248064 19.364 100 50 100 0 2034985888 50897856 16839968
14:46:46 5848 8192000000 10953130624 11379253248 1968609376 19.374 100 66 130 1 2039695472 49813936 21272160
14:47:01 2513 8192000000 10981119920 11397844992 1985739856 19.510 100 83 168 0 2062465856 50021632 26704368
14:47:10 1852 8192000000 10987276464 11404853248 1987738320 19.526 100 81 160 2 2069165056 55522144 25904592
14:47:20 4476 8192000000 10983400112 11406348288 1988034992 19.528 100 68 139 2 2065569376 56131264 21403120
14:47:35 4520 8192000000 10969104176 11405225984 1978243664 19.451 100 52 104 1 2048148336 52525920 17378752
14:47:47 20253 8192000000 10954702656 11404689408 1983039264 19.489 100 37 73 2 2043734208 48429056 12265888
14:48:43 7133 8192000000 10944707664 11390263296 1961912896 19.321 99 38 76 1 2024739520 50181824 12644800
14:49:09 7349 8192000000 10942885168 11387899904 1934525568 19.103 98 36 72 1 1996191360 49932512 11733280
14:49:32 15147 8192000000 10947161248 11388678144 1966342832 19.356 100 32 63 1 2026917920 49867840 10707248
14:49:54 17143 8192000000 10916871664 11366043648 1928874144 19.058 99 36 73 0 1993113488 52525568 11713776
14:50:20 7772 8192000000 10929161728 11367772160 1930043808 19.067 99 52 102 0 1995757232 49281264 16432160
14:50:44 10095 8192000000 10921384704 11366031360 1931506544 19.079 99 32 63 2 1993477680 51408032 10563104
14:51:01 5084 8192000000 10909126864 11339984896 1909721632 18.904 98 39 78 0 1971559424 49000512 12837280
14:51:14 5212 8192000000 10925398800 11359019008 1922988864 19.011 99 40 80 3 1991631296 55207472 13434960
14:51:44 11645 8192000000 10931445360 11365068800 1929578608 19.064 100 32 64 1 2003739520 62739488 11421424
14:52:13 22899 8192000000 10926482832 11373314048 1937362368 19.126 100 26 52 0 2009480352 62135776 9982208
14:53:07 15120 8192000000 10934448512 11375718400 1923184864 19.012 99 32 64 1 2000276864 66148752 10943248
14:53:29 22703 8192000000 10925811824 11381211136 1908361488 18.893 98 29 58 2 1992706112 74056608 10288016
14:53:59 17070 8192000000 10894385296 11338543104 1885051200 18.706 98 29 54 2 1945425744 50367776 10006768
14:54:23 9735 8192000000 10895005424 11342245888 1911542048 18.919 100 33 65 2 1976020512 52932160 11546304
14:55:16 64344 8192000000 10900188080 11341770752 1937224704 19.125 100 26 53 1 1976367808 30543488 8599616
14:56:28 36612 8192000000 10895194240 11353866240 1946801344 19.201 100 42 83 0 1977291344 17779808 12710192
14:58:04 107025 8192000000 10858614224 11326976000 1897180096 18.804 97 24 48 1 1912749088 8909552 6659440
15:00:00 97953 8192000000 10891314064 11350028288 1937181360 19.124 99 20 41 0 1956231104 14140496 4909248
15:01:44 58430 8192000000 10892423776 11354165248 1945483024 19.190 99 13 26 1 1958236672 9338896 3414752
15:02:56 57187 8192000000 10905209440 11362349056 1955155168 19.268 99 20 39 2 1973083568 12150624 5777776
15:04:03 10887 8192000000 10912670384 11366285312 1976848016 19.440 100 28 56 3 1998239344 13454640 7936688
15:04:22 5897 8192000000 10913573616 11367530496 1978976832 19.457 100 25 50 0 2000516640 14321776 7218032
15:04:56 85063 8192000000 10923960624 11373281280 1942988640 19.171 98 28 55 3 1966811232 15599216 8223376
15:06:29 58290 8192000000 10920882704 11377901568 1980013968 19.465 100 28 54 1 2006200448 17460864 8725616
15:07:40 66611 8192000000 10905525120 11377983488 1979710048 19.462 100 21 42 0 1999137296 13169344 6257904
15:08:52 54478 8192000000 10910516608 11374854144 1983461936 19.492 100 10 20 0 1995790336 9540720 2787680
15:10:01 49642 8192000000 10919840288 11376922624 1965648592 19.351 99 12 24 0 1980447696 10746832 4052272
15:10:58 33728 8192000000 10908364480 11367682048 1960208672 19.308 99 25 50 0 1982122304 14243888 7669744
15:11:56 78393 8192000000 10911657808 11378376704 1983597232 19.493 100 24 49 1 2001254160 10980384 6676544
15:13:21 85163 8192000000 10915351776 11387432960 1967611136 19.366 99 24 47 1 1984296064 9308432 7376496
15:14:54 5725 8192000000 10928711904 11386560512 1988025360 19.528 100 23 44 0 2007069104 12225536 6818208
15:15:06 28734 8192000000 10939019280 11388878848 1993938128 19.575 100 38 77 0 2017189696 12128816 11122752
15:16:04 88484 8192000000 10909433584 11392540672 1991885312 19.559 100 13 26 0 2006977120 11474304 3617504
15:17:38 50703 8192000000 10908869008 11383693312 1990234368 19.546 100 21 42 1 2008149376 12183104 5731904
15:18:53 92380 8192000000 10888666112 11370946560 1931655680 19.080 97 16 32 1 1944448128 8287920 4504528
15:20:32 79313 8192000000 10890486624 11381055488 1965179952 19.347 99 9 18 0 1978330128 10756592 2393584
15:21:58 45281 8192000000 10913354624 11392081920 1988898512 19.535 100 19 38 1 2003169072 8688912 5581648
15:22:52 56043 8192000000 10918459504 11389087744 1973407200 19.412 99 16 32 1 1987802368 9788848 4606320
15:24:01 47617 8192000000 10938930832 11407167488 1996991472 19.599 100 21 42 2 2016580816 13377920 6211424
15:24:55 78309 8192000000 10941024160 11420991488 2010267536 19.704 100 18 36 1 2031246736 15826224 5152976
15:26:19 76004 8192000000 10923642304 11399577600 1948963584 19.218 97 8 16 0 1959027616 8321952 1742080
15:28:18 56501 8192000000 10885706928 11332161536 1858116800 18.488 94 23 46 1 1872164816 7714704 6333312
15:29:23 27968 8192000000 10892540816 11350077440 1949712896 19.224 100 37 72 0 1970989152 10411376 10864880
15:30:01 83721 8192000000 10894948432 11375538176 1942482400 19.167 99 14 28 0 1963824624 17379888 3962336
15:31:34 42019 8192000000 10894810384 11364802560 1926865536 19.042 98 18 36 1 1946031200 14235408 4930256
15:32:30 112741 8192000000 10891205712 11362582528 1892705648 18.768 96 22 44 1 1909550272 10633840 6210784
15:34:34 50661 8192000000 10916601232 11371995136 1917340304 18.966 97 28 56 1 1940138896 14832304 7966288
15:35:35 139923 8192000000 10859354064 11330883584 1784226816 17.884 91 23 45 1 1807008288 16984864 5796608
15:38:29 91216 8192000000 10886220416 11351797760 1903374848 18.853 98 20 40 1 1918145584 9237792 5532944
15:40:12 45694 8192000000 10885973104 11364081664 1947326944 19.205 100 12 24 0 1965378960 14796896 3255120
15:41:10 21054 8192000000 10886023952 11343568896 1931232176 19.077 99 32 64 1 1952033296 11630736 9170384
15:41:41 31759 8192000000 10889577552 11353354240 1942690672 19.168 99 39 78 2 1966457248 13007968 10758608
15:42:22 71221 8192000000 10888005376 11363028992 1956403760 19.277 100 17 34 1 1976139408 14586192 5149456
15:43:45 86884 8192000000 10879122672 11351003136 1899989424 18.826 97 8 17 0 1919934448 17983296 1961728
15:45:18 62554 8192000000 10850402992 11332456448 1909612448 18.904 98 9 18 0 1923118480 10105952 3400080
15:47:16 68514 8192000000 10859418256 11333697536 1910997952 18.915 98 14 28 1 1921711136 7191424 3521760
15:48:33 88772 8192000000 10836669440 11320717312 1850472544 18.426 95 19 38 2 1864196912 8182176 5542192
15:50:40 57982 8192000000 10829452688 11311648768 1867099168 18.561 97 13 26 1 1881000816 10279600 3622048
15:51:59 60387 8192000000 10867077232 11329814528 1894974368 18.786 98 20 40 2 1909576144 8916848 5684928
15:53:40 66300 8192000000 10858315392 11325423616 1887681904 18.727 97 22 44 1 1903702272 9643264 6377104
15:54:56 20598 8192000000 10858233600 11310727168 1889795248 18.744 98 29 58 1 1906138256 8173792 8169216
15:55:28 17989 8192000000 10869096640 11322220544 1911932048 18.922 99 51 102 0 1939302832 13163312 14207472
15:55:57 66320 8192000000 10849861024 11317764096 1893557248 18.774 98 31 62 0 1919828144 17226176 9044720
15:57:18 95821 8192000000 10870385152 11354677248 1900044608 18.827 98 12 24 1 1922031808 18921424 3065776
15:59:00 67767 8192000000 10881796432 11345838080 1914226928 18.941 98 21 42 3 1928288528 8277584 5784016
16:00:14 57086 8192000000 10903591440 11367940096 1902374768 18.845 97 31 63 5 1927047744 16141632 8531344
16:01:20 46302 8192000000 10922611840 11365371904 1965560976 19.350 100 38 76 2 1985438464 8750480 11127008
16:02:13 21778 8192000000 10919900448 11372392448 1975651440 19.430 100 47 94 0 1998920880 10200800 13068640
16:02:41 89704 8192000000 10893868352 11378839552 1932265904 19.085 98 25 51 0 1955217504 16036672 6914928
16:04:24 161050 8192000000 10884426896 11357167616 1936917104 19.122 98 27 54 1 1956526800 12022752 7586944
16:07:20 15993 8192000000 10886435712 11352977408 1948952704 19.218 99 32 64 1 1964571344 6858432 8760208
16:07:43 25471 8192000000 10898605760 11365699584 1958011184 19.290 99 40 80 0 1979997568 10319072 11667312
16:09:48 42580 8192000000 10892059616 11368443904 1967798832 19.368 100 11 22 0 1979784608 9082304 2903472
16:11:23 89760 8192000000 10900363568 11387949056 1941955712 19.162 98 13 26 1 1956361616 11039472 3366432
16:13:12 52158 8192000000 10906421104 11377975296 1957238672 19.284 99 12 24 2 1971431424 11189104 3003648
16:14:11 46238 8192000000 10909014704 11390287872 1988142464 19.529 100 17 34 0 1999973168 6983248 4847456
16:15:07 51084 8192000000 10922375328 11397914624 1964437568 19.341 98 22 44 4 1983300976 12257104 6606304
16:16:04 72379 8192000000 10943447952 11402444800 1958227760 19.292 98 20 40 0 1979130656 14806976 6095920
16:17:23 80954 8192000000 10908889200 11391143936 1959589408 19.303 98 25 50 0 1993548800 26184864 7774528
16:19:47 84027 8192000000 10907804704 11386839040 1906731120 18.880 96 11 22 0 1927981824 18517952 2732752
16:21:17 22369 8192000000 10911070896 11380297728 1984416288 19.500 100 30 60 2 2002616816 9984256 8216272
16:21:47 58189 8192000000 10878963248 11367677952 1890577264 18.750 96 21 42 2 1913301792 16721392 6003136
16:22:51 42545 8192000000 10875916512 11329794048 1823087376 18.203 93 25 50 1 1837821072 8142144 6591552
16:23:42 32710 8192000000 10872191888 11335929856 1910384256 18.910 98 36 72 1 1929898832 8970240 10544336
16:24:21 53921 8192000000 10885011040 11327475712 1910084704 18.907 98 35 69 1 1930356800 11022656 9249440
16:25:24 104719 8192000000 10866643456 11322896384 1898519728 18.814 97 45 90 0 1921009552 9996368 12493456
16:27:19 10903 8192000000 9426998208 9729462272 584462400 6.659 31 7 13 0 589728512 3432816 1833296

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-04-2021 16:29:26 to 05-04-2021 16:29:57.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2021 16:29:58 to 05-04-2021 16:30:00.

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          236407
MON$OLDEST_ACTIVE               236408
MON$OLDEST_SNAPSHOT             236408
MON$NEXT_TRANSACTION            236408
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                       2013696
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
--- end of diff output ---

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

05.04.21 16:30:00. 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-04-05 16:30:03 No severe PSQL-related problems occured
05.04.21 16:30:04. End of report.