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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17399396 kB
MemAvailable 31553484 kB
Buffers 0 kB
Cached 14270636 kB
SwapCached 1988 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 2020-12-08 22:27:06
DTS_END                         2020-12-08 22:27:06.9560
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/42492
TRN_ID                          253853
ATT_ID                          728
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: 9808.39 20561 1177007
customer order: creation 185.02 332 22202
customer order: refuse 15.47 248 1856
order to supplier: creation 49.30 1146 5916
order to supplier: removal 3.81 79929 457
invoice (draft): creation 48.64 3283 5837
invoice (draft): removal 56.00 681 6720
invoice accept: apply 43.96 15496 5275
invoice accept: cancel 50.78 662 6094
customer reserve: creation 4079.76 153 489571
customer reserve: removal 4966.73 48 596008
realization accept: apply 89.26 167 10711
realization accept: cancel 79.88 98 9585
payment from customer: creation 63.47 118 7616
payment from customer: removal 6.03 84 724
payment to supplier: creation 53.17 135 6380
payment to supplier: removal 3.96 63 475
service: total inventory turnovers 5.48 871 657
service: total monetary turnovers 6.60 18 792
service: aggregate perf. data 1.06 13432 127
service: refresh index statistics 0.03 294261 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-12-2020 22:28:07 to 08-12-2020 22:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9692
TEST_TIME 2 6700
TEST_TIME 3 6329
TEST_TIME 4 6440
TEST_TIME 5 6049
TEST_TIME 6 6468
TEST_TIME 7 6870
TEST_TIME 8 6947
TEST_TIME 9 6742
TEST_TIME 10 6832
TEST_TIME 11 6808
TEST_TIME 12 7031
TEST_TIME 13 7120
TEST_TIME 14 7319
TEST_TIME 15 8030
TEST_TIME 16 8234
TEST_TIME 17 8895
TEST_TIME 18 9418
TEST_TIME 19 10406
TEST_TIME 20 10659
TEST_TIME 21 11374
TEST_TIME 22 12176
TEST_TIME 23 12163
TEST_TIME 24 11905
TEST_TIME 25 11715
TEST_TIME 26 11999
TEST_TIME 27 11737
TEST_TIME 28 11720
TEST_TIME 29 11685
TEST_TIME 30 11353
TEST_TIME 31 11094
TEST_TIME 32 11186
TEST_TIME 33 11085
TEST_TIME 34 11006
TEST_TIME 35 10831
TEST_TIME 36 10749
TEST_TIME 37 10957
TEST_TIME 38 10832
TEST_TIME 39 10718
TEST_TIME 40 10605
TEST_TIME 41 10649
TEST_TIME 42 10553
TEST_TIME 43 10619
TEST_TIME 44 10541
TEST_TIME 45 10580
TEST_TIME 46 10601
TEST_TIME 47 10605
TEST_TIME 48 10606
TEST_TIME 49 10613
TEST_TIME 50 10593
TEST_TIME 51 10559
TEST_TIME 52 10716
TEST_TIME 53 10694
TEST_TIME 54 10695
TEST_TIME 55 10577
TEST_TIME 56 10515
TEST_TIME 57 10554
TEST_TIME 58 10446
TEST_TIME 59 10407
TEST_TIME 60 10385
TEST_TIME 61 10338
TEST_TIME 62 10222
TEST_TIME 63 10204
TEST_TIME 64 10215
TEST_TIME 65 10243
TEST_TIME 66 10291
TEST_TIME 67 10210
TEST_TIME 68 10214
TEST_TIME 69 10303
TEST_TIME 70 10387
TEST_TIME 71 10318
TEST_TIME 72 10361
TEST_TIME 73 10439
TEST_TIME 74 10397
TEST_TIME 75 10485
TEST_TIME 76 10446
TEST_TIME 77 10521
TEST_TIME 78 10411
TEST_TIME 79 10352
TEST_TIME 80 10294
TEST_TIME 81 10284
TEST_TIME 82 10287
TEST_TIME 83 10212
TEST_TIME 84 10227
TEST_TIME 85 10204
TEST_TIME 86 10143
TEST_TIME 87 10134
TEST_TIME 88 10140
TEST_TIME 89 10112
TEST_TIME 90 10065
TEST_TIME 91 10174
TEST_TIME 92 10160
TEST_TIME 93 10199
TEST_TIME 94 10203
TEST_TIME 95 10199
TEST_TIME 96 10164
TEST_TIME 97 10248
TEST_TIME 98 10236
TEST_TIME 99 10260
TEST_TIME 100 10272
TEST_TIME 101 10273
TEST_TIME 102 10212
TEST_TIME 103 10146
TEST_TIME 104 10128
TEST_TIME 105 10095
TEST_TIME 106 10069
TEST_TIME 107 10031
TEST_TIME 108 10023
TEST_TIME 109 10019
TEST_TIME 110 10005
TEST_TIME 111 9938
TEST_TIME 112 9902
TEST_TIME 113 9904
TEST_TIME 114 9890
TEST_TIME 115 9863
TEST_TIME 116 9852
TEST_TIME 117 9829
TEST_TIME 118 9887
TEST_TIME 119 9892
TEST_TIME 120 9812

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-12-2020 22:28:10 to 08-12-2020 22:28:14.

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 1631103 1631103 0 0.00 0 14086 6 0 0
doc_list_biud 1631099 1631099 0 0.00 0 54853 22 0 0
sp_add_invoice_to_stock 5480 5275 205 3.74 29 168802 15496 0 205
sp_cancel_adding_invoice 6094 6094 0 0.00 5 54781 662 0 0
sp_cancel_client_order 1856 1856 0 0.00 4 13776 248 0 0
sp_cancel_customer_reserve 596008 596008 0 0.00 1 54855 48 0 0
sp_cancel_pay_from_customer 724 724 0 0.00 3 9123 84 0 0
sp_cancel_pay_to_supplier 475 475 0 0.00 3 4459 63 0 0
sp_cancel_supplier_invoice 6729 6720 9 0.13 2 14516 682 0 9
sp_cancel_supplier_order 457 457 0 0.00 5 820920 79930 0 0
sp_cancel_write_off 9585 9585 0 0.00 1 9364 99 0 0
sp_client_order 22202 22202 0 0.00 3 27333 333 0 0
sp_customer_reserve 489571 489571 0 0.00 0 33757 154 0 0
sp_fill_shopping_cart 33952 33952 0 0.00 1 15745 36 0 0
sp_fill_shopping_cart_clo_res 489563 489563 0 0.00 0 13979 12 0 0
sp_get_clo_for_invoice 5267 5267 0 0.00 0 24375 249 0 0
sp_kill_cost_storno 16878 16878 0 0.00 0 6573 43 0 0
sp_kill_qstorno_ret_qs2qd 1208778 1208778 0 0.00 0 54850 26 0 0
sp_kill_qty_storno 636696 636696 0 0.00 0 54853 57 0 0
sp_lock_selected_doc 22235 22235 0 0.00 0 9638 8 0 0
sp_make_cost_storno 29974 29974 0 0.00 0 14055 53 0 0
sp_multiply_rows_for_pdistr 29974 29974 0 0.00 0 6588 28 0 0
sp_multiply_rows_for_qdistr 22202 22202 0 0.00 0 17226 150 0 0
sp_pay_from_customer 7616 7616 0 0.00 4 17966 118 0 0
sp_pay_to_supplier 6380 6380 0 0.00 4 13108 135 0 0
sp_payment_common 13996 13996 0 0.00 1 17963 29 0 0
sp_qd_handle_on_cancel_clo 1856 1856 0 0.00 0 13771 216 0 0
sp_qd_handle_on_invoice_upd_sts 11360 11360 0 0.00 0 21397 282 0 0
sp_qd_handle_on_reserve_upd_sts 10710 10710 0 0.00 0 16145 40 0 0
sp_reserve_write_off 10711 10711 0 0.00 6 22458 167 0 0
sp_supplier_invoice 5837 5837 0 0.00 6 77097 3284 0 0
sp_supplier_order 5916 5916 0 0.00 5 30617 1147 0 0
srv_aggregate_perf_data 127 127 0 0.00 2078 157509 13433 0 0
srv_fill_mon_cache_memory 147 147 0 0.00 1416 144849 36519 0 0
srv_find_qd_qs_mism 1126305 1126305 0 0.00 0 11874 5 0 0
srv_make_invnt_saldo 657 657 0 0.00 31 44302 872 0 0
srv_make_money_saldo 792 792 0 0.00 0 1040 19 0 0
srv_recalc_idx_stat 4 4 0 0.00 185450 436837 294261 0 0
t$perf-abend:sp_add_invoice_to_stock 205 205 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5275 5275 0 0.00 0 16298 170 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 1 4925 78 0 0
t$perf-norm:sp_cancel_client_order 1856 1856 0 0.00 0 5597 15 0 0
t$perf-norm:sp_cancel_customer_reserve 745 745 0 0.00 0 1534 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 724 724 0 0.00 0 348 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 475 475 0 0.00 0 6853 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 454 454 0 0.00 0 1380 10 0 0
t$perf-norm:sp_cancel_supplier_order 457 457 0 0.00 0 27836 1215 0 0
t$perf-norm:sp_cancel_write_off 1098 1098 0 0.00 0 3526 12 0 0
t$perf-norm:sp_client_order 22202 22202 0 0.00 0 11478 16 0 0
t$perf-norm:sp_customer_reserve 1078 1078 0 0.00 0 1355 6 0 0
t$perf-norm:sp_pay_from_customer 7616 7616 0 0.00 0 9696 10 0 0
t$perf-norm:sp_pay_to_supplier 6380 6380 0 0.00 0 8516 12 0 0
t$perf-norm:sp_reserve_write_off 10711 10711 0 0.00 0 11755 13 0 0
t$perf-norm:sp_supplier_invoice 5837 5837 0 0.00 0 9455 20 0 0
t$perf-norm:sp_supplier_order 5916 5916 0 0.00 0 8646 14 0 0
t$perf-norm:srv_aggregate_perf_data 127 127 0 0.00 0 3149 32 0 0
t$perf-norm:srv_fill_mon_cache_memory 147 147 0 0.00 0 23 1 0 0
t$perf-norm:srv_make_invnt_saldo 657 657 0 0.00 0 2455 15 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1343 11 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 10942 10532 410 3.74 0 5268 21 0 410
v_all_customers 40846 40846 0 0.00 0 18 0 0 0
v_all_suppliers 32676 32676 0 0.00 0 18 1 0 0
v_all_wares 44404 44404 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 369 5 0 0
v_cancel_client_order 3712 3712 0 0.00 0 4452 9 0 0
v_cancel_customer_prepayment 1448 1448 0 0.00 0 2236 11 0 0
v_cancel_customer_reserve 1490 1490 0 0.00 0 990 3 0 0
v_cancel_payment_to_supplier 950 950 0 0.00 0 1453 5 0 0
v_cancel_supplier_invoice 926 908 18 1.94 0 715 14 0 18
v_cancel_supplier_order 914 914 0 0.00 0 3524 10 0 0
v_cancel_write_off 2196 2196 0 0.00 0 1980 12 0 0
v_max_id_clo_ord 5916 5916 0 0.00 0 1046 1 0 0
v_max_id_clo_res 1078 1078 0 0.00 0 1273 8 0 0
v_max_id_ord_sup 5833 5833 0 0.00 0 9859 6 0 0
v_max_non_paid_invoice 1791 1791 0 0.00 0 1153 2 0 0
v_max_non_paid_realizn 3905 3905 0 0.00 0 2366 4 0 0
v_min_id_clo_ord 5916 5916 0 0.00 0 9384 13 0 0
v_min_id_clo_res 1078 1078 0 0.00 0 6588 17 0 0
v_min_id_ord_sup 5833 5833 0 0.00 0 6035 14 0 0
v_min_non_paid_invoice 6380 6380 0 0.00 0 6664 20 0 0
v_min_non_paid_realizn 7616 7616 0 0.00 0 17960 19 0 0
v_our_firm 10980 10980 0 0.00 0 12 1 0 0
v_reserve_write_off 21420 21420 0 0.00 0 6479 8 0 0
x_lock_depdocs_on_canc_invoice 12360 12360 0 0.00 0 13990 90 0 0
x_lock_depdocs_on_canc_sup_ord 457 457 0 0.00 0 7856 251 0 0
x_make_qstorno_1000_1200 5916 5916 0 0.00 1 30582 1078 0 0
x_make_qstorno_1200_2000 5837 5837 0 0.00 3 77089 3152 0 0
x_make_qstorno_2100_3300 489571 489571 0 0.00 0 32885 140 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-12-2020 22:28:15 to 08-12-2020 22:28:19.

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
19:57:10 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:17 7079 8192000000 10156771568 10459492352 930306768 10.198 75 60 121 0 953297168 2778624 20211776
19:57:32 37034 8192000000 10330769760 10645364736 1371895584 14.344 100 89 178 0 1405825600 4616320 29313696
19:58:20 11092 8192000000 10360061376 10675322880 1414788976 14.726 100 93 186 2 1452194320 6509888 30895456
19:58:39 19068 8192000000 10368121312 10691543040 1426469008 14.830 100 94 188 1 1465358816 7178768 31711040
19:59:07 20800 8192000000 10402426432 10728030208 1443753600 14.983 100 88 176 0 1480535968 7738256 29044112
19:59:37 22421 8192000000 10430064624 10757246976 1476718832 15.273 100 87 175 0 1513060928 8401648 27940448
20:00:10 19527 8192000000 10438796608 10773299200 1489193632 15.382 100 90 180 1 1527737056 9106320 29437104
20:00:40 15755 8192000000 10452392880 10789228544 1504252592 15.513 100 86 172 1 1540975952 9063008 27660352
20:01:14 17860 8192000000 10483659232 10832580608 1540636160 15.829 100 75 150 0 1573995088 9612928 23746000
20:01:39 11657 8192000000 10509729840 10863968256 1573730512 16.114 100 76 152 0 1607647984 10276480 23640992
20:02:02 14513 8192000000 10544491824 10901721088 1599124464 16.332 100 77 152 2 1631972464 10069712 22778288
20:02:25 12854 8192000000 10574143760 10931531776 1627668112 16.575 100 82 163 0 1663339568 10812192 24859264
20:02:46 12850 8192000000 10594750368 10959151104 1652012048 16.781 100 75 148 1 1686010640 11389648 22608944
20:03:06 10586 8192000000 10614723936 10981429248 1670523664 16.938 100 77 154 1 1705587088 12012784 23050640
20:03:24 4806 8192000000 10620413920 10992566272 1688841744 17.092 100 76 152 0 1723844448 12618800 22383904
20:03:36 9141 8192000000 10631693424 11006836736 1696031328 17.152 100 79 158 1 1731829200 12249296 23548576
20:03:53 6637 8192000000 10660258928 11028402176 1716620080 17.324 100 84 168 4 1754147312 12285648 25241584
20:04:08 4619 8192000000 10664486416 11038302208 1726547088 17.407 100 76 152 1 1761499936 12287584 22665264
20:04:20 4059 8192000000 10669339584 11042631680 1730800144 17.442 100 77 154 1 1766679152 13721520 22157488
20:04:32 5389 8192000000 10681525824 11061194752 1742966320 17.543 100 77 155 1 1778193680 13231696 21995664
20:04:44 4120 8192000000 10692731872 11075305472 1752964128 17.626 100 75 150 0 1788957136 14129456 21863552
20:04:56 4996 8192000000 10702705664 11083526144 1772195200 17.785 100 77 154 0 1807719056 13797536 21726320
20:05:08 3895 8192000000 10705769424 11091238912 1774862256 17.807 100 70 139 0 1805871264 11382144 19626864
20:05:19 2475 8192000000 10731380400 11110105088 1791992448 17.948 100 87 172 0 1828930480 12182064 24755968
20:05:28 9853 8192000000 10728905216 11118850048 1791774720 17.946 100 70 140 0 1823163744 11771760 19617264
20:05:46 3006 8192000000 10745669424 11135864832 1807984848 18.079 100 74 149 1 1839967712 11047184 20935680
20:05:56 2209 8192000000 10761671968 11144159232 1819551824 18.174 100 76 151 1 1853598768 11717808 22329136
20:06:04 2949 8192000000 10762848176 11152834560 1830857520 18.266 100 82 164 1 1865992400 11967520 23167360
20:06:14 2070 8192000000 10775248576 11161997312 1833511040 18.288 100 85 166 1 1868683632 12068256 23104336
20:06:22 2246 8192000000 10786135616 11173294080 1840375776 18.344 100 90 181 0 1878259088 12629408 25253904
20:06:31 2456 8192000000 10783405424 11171262464 1843574944 18.370 100 89 178 2 1882935472 13924016 25436512
20:06:40 1494 8192000000 10782992528 11177406464 1850947952 18.430 100 88 177 0 1889638192 13937168 24753072
20:06:48 2010 8192000000 10801510272 11187892224 1855106976 18.464 100 91 180 2 1895244784 14670864 25466944
20:06:56 3297 8192000000 10798540592 11188797440 1857773184 18.485 100 80 158 0 1893028960 13020672 22235104
20:07:06 1592 8192000000 10812626224 11199352832 1866990192 18.560 100 95 191 0 1906678144 13594480 26093472
20:07:14 1823 8192000000 10812884752 11199733760 1865904672 18.551 100 94 183 2 1905857632 13227456 26725504
20:07:22 1681 8192000000 10810075840 11198570496 1872793136 18.607 100 92 185 1 1912117344 13505216 25818992
20:07:30 1386 8192000000 10822256544 11208970240 1873351472 18.611 100 93 189 0 1912669120 12012272 27305376
20:07:37 3360 8192000000 10794814192 11203133440 1876192880 18.634 100 88 177 2 1914934896 13458224 25283792
20:07:47 50684 8192000000 10789250928 11201855488 1865358384 18.547 100 29 58 1 1880025040 6528624 8138032
20:08:45 27231 8192000000 10773594112 11206156288 1866948704 18.560 100 22 44 2 1879888128 6404384 6535040
20:09:19 11427 8192000000 10786824656 11210932224 1872031008 18.601 100 21 40 2 1883313264 5764960 5517296
20:09:37 8959 8192000000 10783069520 11212984320 1874408160 18.620 100 26 52 3 1888136112 6597968 7129984
20:09:55 7924 8192000000 10797520704 11217489920 1876446512 18.636 100 28 55 2 1891338688 6891088 8001088
20:10:09 6209 8192000000 10787112176 11217186816 1882805504 18.688 100 32 64 1 1899347088 7694432 8847152
20:10:24 12072 8192000000 10792141488 11219173376 1877339824 18.644 100 16 32 0 1887444560 5789520 4315216
20:10:43 7854 8192000000 10792475648 11221327872 1881427808 18.677 100 22 42 1 1894044272 5915296 6701168
20:11:00 8233 8192000000 10800193456 11232096256 1883309680 18.692 100 19 38 0 1898872672 10671408 4891584
20:11:15 8032 8192000000 10789815552 11228078080 1884723936 18.703 100 23 46 0 1898352624 7401120 6227568
20:11:31 10904 8192000000 10791874544 11227619328 1886234880 18.715 100 17 34 1 1896673120 5390464 5047776
20:11:50 8201 8192000000 10805192576 11231539200 1888283776 18.732 100 21 39 5 1899805440 5872928 5648736
20:12:07 18023 8192000000 10793740976 11230900224 1888757952 18.736 100 12 24 0 1898359696 5779280 3822464
20:12:31 14386 8192000000 10805343472 11238883328 1894410496 18.781 100 29 58 2 1908837696 6369792 8057408
20:12:53 11158 8192000000 10797178256 11236167680 1892862016 18.769 100 11 22 1 1901220976 5477872 2881088
20:13:10 16534 8192000000 10808174256 11245350912 1899283728 18.821 100 23 48 1 1910928160 5380336 6264096
20:13:36 62199 8192000000 10832411680 11254743040 1904828496 18.865 100 45 91 1 1924147040 6192512 13126032
20:14:44 18250 8192000000 10818327984 11249926144 1887190144 18.723 99 29 58 2 1902509248 7641440 7677664
20:15:11 6492 8192000000 10816355376 11247570944 1899788944 18.825 100 24 48 1 1912636736 5646912 7200880
20:15:25 8459 8192000000 10807809072 11244019712 1896748080 18.800 100 23 46 1 1909722224 6370688 6603456
20:15:41 6593 8192000000 10809415920 11244519424 1896766064 18.800 100 17 34 1 1906551744 5448128 4337552
20:15:56 7250 8192000000 10810561664 11242356736 1880828832 18.672 99 25 50 2 1894005712 5999568 7177312
20:16:09 7935 8192000000 10777449264 11217207296 1861498144 18.515 99 14 27 1 1870994240 4847920 4648176
20:16:23 6275 8192000000 10791230976 11224088576 1864607184 18.541 99 27 54 4 1878525200 6400928 7517088
20:16:42 9759 8192000000 10773325120 11204198400 1855285376 18.465 99 22 44 0 1867871808 6331856 6254576
20:16:59 8144 8192000000 10762223328 11190755328 1825002304 18.219 98 20 40 0 1836558864 5982816 5573744
20:17:15 10201 8192000000 10738524336 11150630912 1754361168 17.638 95 21 42 0 1766519536 5241008 6917360
20:17:31 9341 8192000000 10729706896 11154927616 1762946528 17.709 96 19 38 0 1774176704 5142176 6088000
20:17:50 7434 8192000000 10743302336 11159232512 1823122656 18.203 100 23 47 1 1835985120 6518400 6344064
20:18:05 11954 8192000000 10731874976 11137888256 1741497888 17.531 95 23 46 1 1753989552 6163968 6327696
20:18:24 59514 8192000000 10730857616 11159158784 1796830064 17.988 98 25 49 2 1809150352 5441200 6879088
20:19:30 13180 8192000000 10688099472 11095912448 1611558592 16.438 89 15 29 1 1620572464 5120896 3892976
20:19:53 6818 8192000000 10683533808 11097464832 1724557968 17.390 97 30 60 3 1743769776 10530352 8681456
20:20:07 8346 8192000000 10659468208 11066695680 1674032176 16.967 95 33 66 2 1690057072 5329424 10695472
20:20:23 8556 8192000000 10662769392 11077427200 1723919200 17.385 97 16 32 1 1733439504 5341520 4178784
20:20:38 6063 8192000000 10703272416 11119525888 1784878960 17.890 100 22 44 0 1798089616 5509088 7701568
20:20:53 6459 8192000000 10718998176 11134533632 1783688048 17.880 99 30 60 0 1798341168 6275488 8377632
20:21:11 6758 8192000000 10684523888 11098996736 1744289504 17.554 97 17 34 1 1754354784 5304368 4760912
20:21:24 9820 8192000000 10727546672 11145809920 1811360352 18.107 100 23 46 1 1823597520 5480848 6756320
20:21:41 9869 8192000000 10739558016 11151986688 1801601008 18.027 99 17 34 1 1811890944 5162752 5127184
20:22:02 10813 8192000000 10737059264 11159502848 1805440880 18.059 99 23 44 1 1817689888 4826496 7422512
20:22:20 4160 8192000000 10750238704 11162554368 1822520992 18.198 100 27 55 3 1835999760 6143792 7334976
20:22:32 13149 8192000000 10733690384 11160027136 1820552912 18.182 100 13 26 2 1829525184 5224096 3748176
20:22:54 75793 8192000000 10736980832 11172163584 1834151744 18.293 100 22 45 0 1846745520 5325216 7268560
20:24:19 9499 8192000000 10780587136 11192299520 1842692896 18.363 100 31 61 0 1856607856 5261568 8653392
20:24:38 9284 8192000000 10761451248 11191930880 1851204768 18.432 100 19 37 4 1862570256 5537232 5828256
20:24:57 8086 8192000000 10759354224 11193540608 1855969120 18.471 100 28 55 0 1871006512 6961184 8076208
20:25:11 7584 8192000000 10771760272 11194806272 1855111952 18.464 100 32 65 2 1871171280 6841328 9218000
20:25:25 12153 8192000000 10773193744 11200655360 1856639744 18.476 100 22 43 1 1868136608 5232064 6264800
20:25:48 9636 8192000000 10769914848 11206537216 1863026336 18.528 100 24 48 2 1875654192 6051024 6576832
20:26:04 5995 8192000000 10778173872 11207446528 1865965328 18.552 100 32 64 1 1880493392 5028736 9499328
20:26:17 10088 8192000000 10774737808 11208376320 1870690048 18.590 100 32 65 5 1885292400 5755840 8846512
20:26:37 9229 8192000000 10783812800 11210342400 1866606672 18.557 100 20 40 1 1877282496 5214896 5460928
20:26:55 7927 8192000000 10783576784 11216879616 1875440624 18.628 100 16 32 1 1888626256 9680096 3505536
20:27:09 33801 8192000000 10827929248 11244597248 1892108320 18.763 100 26 52 1 1905131328 5041280 7981728
20:27:52 10295 8192000000 10839428672 11265085440 1907165616 18.884 100 25 49 0 1926894544 11784976 7943952
20:28:10 14445 8192000000 10861916976 11275415552 1920913280 18.994 100 55 109 2 1946584832 9885808 15785744
20:28:31 18393 8192000000 10865923920 11287941120 1927054496 19.043 100 45 89 2 1950856128 11147184 12654448
20:28:58 74098 8192000000 10860795936 11291176960 1899997712 18.826 98 37 74 0 1921166960 10211104 10958144
20:30:20 19865 8192000000 10881136992 11301851136 1941497216 19.159 100 53 106 4 1967071344 10300192 15273936
20:30:47 14993 8192000000 10886334992 11313311744 1951429712 19.238 100 46 92 1 1978033296 13277984 13325600
20:31:16 9281 8192000000 10905877104 11332812800 1962255648 19.324 100 58 115 1 1995760896 16791536 16713712
20:31:34 7656 8192000000 10901474832 11332820992 1964175536 19.339 100 51 99 2 1995297824 16862768 14259520
20:31:54 16777 8192000000 10918886672 11351056384 1975659632 19.430 100 69 138 0 2014668448 18740592 20268224
20:32:18 10583 8192000000 10922463136 11350859776 1977393888 19.444 100 54 108 1 2013451088 20202480 15854720
20:32:48 35152 8192000000 10911613280 11350142976 1959548704 19.302 99 37 73 0 1993861616 22933056 11379856
20:33:37 4223 8192000000 10919240736 11352944640 1971921056 19.401 100 46 92 0 2007991488 21763968 14306464
20:33:47 5505 8192000000 10921545712 11351101440 1953508368 19.254 99 57 112 3 1993391072 22623280 17259424
20:34:03 11376 8192000000 10914471088 11343523840 1962965504 19.330 100 53 106 2 2002861328 24597488 15298336
20:34:29 11624 8192000000 10904150944 11338752000 1938235824 19.133 98 50 100 0 1975253552 21916224 15101504
20:34:56 3180 8192000000 10915191696 11347189760 1967148512 19.363 100 50 100 1 2005625632 23577648 14899472
20:35:07 10081 8192000000 10906013072 11330347008 1945704944 19.192 99 54 108 0 1986421168 24401584 16314640
20:35:24 8110 8192000000 10912510032 11342585856 1962382720 19.325 100 54 107 2 2003900624 25245840 16272064
20:35:40 3092 8192000000 10883883856 11307274240 1919106880 18.980 99 44 87 0 1959333952 26393824 13833248
20:35:51 6313 8192000000 10892912928 11310362624 1932889520 19.090 99 67 135 2 1979145648 25802944 20453184
20:36:06 19455 8192000000 10914302240 11345334272 1964145840 19.339 100 51 100 1 2006456464 27352128 14958496
20:36:34 12648 8192000000 10927439488 11357110272 1970484640 19.389 100 50 100 1 2015300208 29731712 15083856
20:36:58 4294 8192000000 10924203968 11346190336 1950472048 19.230 99 55 110 0 1997694208 29958752 17263408
20:37:11 8888 8192000000 10904815264 11325906944 1941889440 19.162 99 63 126 1 1989132480 28722624 18520416
20:37:29 5251 8192000000 10913466368 11338313728 1954188832 19.260 100 58 116 4 2000874528 29080320 17605376
20:37:52 5214 8192000000 10918101360 11340451840 1959339936 19.301 100 63 125 1 2008537232 30155616 19041680
20:38:04 5243 8192000000 10940122672 11360452608 1973592576 19.414 100 72 142 1 2028692464 33467168 21632720
20:38:17 1721 8192000000 10946546896 11353374720 1968676464 19.375 100 88 174 0 2029440272 34833056 25930752
20:38:25 5474 8192000000 10944036128 11355009024 1966491552 19.358 100 79 156 0 2026187504 35652320 24043632
20:38:38 3773 8192000000 10938682000 11362332672 1969453856 19.381 100 66 131 0 2025988672 36896736 19638080
20:38:50 3313 8192000000 10953395184 11362283520 1972969728 19.409 100 68 136 3 2030424224 36341824 21112672
20:39:01 6963 8192000000 10943566784 11357663232 1959196352 19.300 99 72 143 2 2022809840 41657184 21956304
20:39:16 4594 8192000000 10924435648 11349999616 1958415488 19.293 100 54 106 0 2010261840 35055872 16790480
20:39:28 4892 8192000000 10949400448 11365912576 1971786592 19.400 100 59 117 0 2026351808 36724480 17840736
20:39:40 3479 8192000000 10952466352 11366674432 1972676432 19.407 100 76 152 1 2033705680 37691808 23337440
20:39:52 2257 8192000000 10943506928 11353710592 1959206480 19.300 99 79 158 0 2022772320 38894160 24671680
20:40:01 4855 8192000000 10952013584 11372449792 1973298672 19.412 100 66 132 0 2033007760 39672432 20036656
20:40:13 1414 8192000000 10954905456 11374395392 1979197712 19.458 100 78 155 1 2044096464 41005648 23893104
20:40:23 2508 8192000000 10952685312 11366719488 1971840176 19.400 100 79 156 2 2037920816 41993920 24086720
20:40:32 2641 8192000000 10965766064 11376308224 1976649728 19.438 100 80 158 3 2043717376 43120016 23947632
20:40:44 2209 8192000000 10967409904 11384176640 1980226432 19.466 100 78 156 2 2048486032 43434544 24825056
20:40:54 4009 8192000000 10971546192 11381673984 1983734800 19.494 100 82 165 0 2052771248 44109200 24927248
20:41:13 2483 8192000000 10948398864 11359789056 1956766912 19.280 99 72 141 0 2032999904 54851936 21381056
20:41:23 3345 8192000000 10966071232 11377827840 1973918752 19.417 100 77 154 0 2044480832 46685792 23876288
20:41:34 3112 8192000000 10941587936 11351187456 1945928848 19.194 99 72 141 2 2016157056 47542480 22685728
20:41:45 3601 8192000000 10940918160 11363377152 1958325024 19.293 100 58 116 0 2026570752 49419120 18826608
20:41:56 2625 8192000000 10951309296 11371073536 1961765728 19.320 100 61 120 2 2032014832 49848608 20400496
20:42:08 2683 8192000000 10923435024 11345461248 1940850944 19.154 99 57 114 1 2009762528 49484864 19426720
20:42:22 3284 8192000000 10948896784 11367792640 1957661120 19.287 100 63 126 0 2030090992 51911168 20518704
20:42:35 6541 8192000000 10946407152 11367706624 1954677552 19.264 100 62 124 0 2028270944 52957504 20635888
20:42:51 3927 8192000000 10945077392 11372789760 1962402704 19.325 100 55 110 0 2031934768 51276160 18255904
20:43:03 8810 8192000000 10936729040 11374903296 1961810768 19.320 100 43 86 0 2025830384 49301008 14718608
20:43:20 4308 8192000000 10948369680 11372634112 1936951216 19.122 98 66 132 1 2011020560 52338752 21730592
20:43:34 6985 8192000000 10949414256 11377012736 1960174560 19.307 100 43 86 1 2029377760 54354704 14848496
20:43:48 10130 8192000000 10932027504 11364532224 1943111488 19.172 99 49 99 3 2018362336 57726416 17524432
20:44:10 9306 8192000000 10925612400 11364253696 1946268544 19.197 100 40 80 2 2012897504 51961488 14667472
20:44:30 16028 8192000000 10931189920 11366793216 1954961280 19.266 100 44 88 2 2015314912 45161424 15192208
20:44:53 22882 8192000000 10922613792 11366588416 1949524688 19.223 100 38 76 0 2014550512 51281792 13744032
20:45:23 11412 8192000000 10929574576 11367976960 1927248720 19.045 99 37 74 2 1994507872 53240512 14018640
20:45:41 14991 8192000000 10934141792 11377270784 1957219952 19.284 100 44 88 1 2031740848 58497152 16023744
20:46:13 23412 8192000000 10907055216 11358588928 1909358512 18.901 98 30 60 0 1971874336 51307424 11208400
20:47:11 27268 8192000000 10889376304 11327844352 1909423984 18.902 99 37 74 3 1958207712 36326592 12457136
20:48:11 38382 8192000000 10867074368 11335290880 1928629776 19.056 100 16 32 0 1964078896 29931488 5517632
20:49:00 41035 8192000000 10847100560 11317145600 1897790176 18.809 99 13 26 1 1926933264 24467520 4675568
20:49:48 124605 8192000000 10857312864 11305857024 1812182896 18.114 94 15 31 0 1831515920 14874480 4458544
20:51:59 103623 8192000000 10858346128 11324243968 1860211216 18.505 96 17 34 1 1890715888 25794096 4710576
20:53:54 51877 8192000000 10895079296 11320229888 1921784544 19.001 99 29 59 1 1941791424 11380944 8625936
20:54:55 35813 8192000000 10882768080 11332366336 1949707392 19.224 100 33 64 2 1966898240 7510272 9680576
20:55:49 50737 8192000000 10857875104 11316228096 1879718160 18.663 97 10 20 1 1895402976 12637376 3047440
20:56:46 90680 8192000000 10893351552 11333087232 1944678624 19.184 100 46 88 1 1964937040 6182672 14075744
20:58:27 49582 8192000000 10903709712 11355201536 1931590304 19.080 98 37 72 0 1950082304 8399104 10092896
20:59:27 52469 8192000000 10913104000 11374432256 1967762256 19.368 100 21 42 0 1988269408 14719152 5788000
21:01:19 19818 8192000000 10925803376 11381530624 1992368880 19.563 100 33 65 2 2012988512 11313824 9305808
21:01:45 35392 8192000000 10932953136 11381280768 1958080112 19.291 98 27 54 1 1978340720 12026464 8234144
21:02:33 62161 8192000000 10922202768 11391864832 1984646496 19.501 100 26 52 1 2006610096 14187792 7775808
21:03:41 45621 8192000000 10912875440 11395182592 1969383664 19.381 99 14 28 0 2000553632 26698928 4471040
21:04:42 56593 8192000000 10911154064 11386904576 1987334816 19.523 100 9 18 0 2005604288 15413904 2855568
21:06:59 54687 8192000000 10911603792 11383595008 1986699856 19.518 100 11 22 1 2003620688 13927760 2993072
21:08:21 47965 8192000000 10923925408 11395973120 1989893200 19.543 100 13 26 0 2006427984 12644432 3890352
21:09:16 77494 8192000000 10892141712 11376771072 1913482528 18.935 96 21 42 2 1930204592 10518304 6203760
21:10:39 43585 8192000000 10929688400 11382210560 1989590928 19.541 100 39 78 2 2008219552 6493200 12135424
21:11:29 47394 8192000000 10924663984 11388268544 1973627616 19.414 99 26 52 0 1992153136 11008224 7517296
21:12:23 27307 8192000000 10914290288 11390074880 1992880704 19.567 100 27 54 1 2008632144 8045200 7706240
21:13:03 32763 8192000000 10916376960 11387699200 1976471536 19.437 99 7 14 0 1985662816 7557984 1633296
21:13:45 37426 8192000000 10912632832 11394240512 1972849616 19.408 99 29 56 2 1994317008 13874928 7592464
21:14:29 84341 8192000000 10903349472 11376930816 1927510912 19.047 97 13 26 1 1946789600 15900512 3378176
21:16:08 57075 8192000000 10920320512 11390320640 1974975680 19.425 100 24 48 0 1994214352 12088016 7150656
21:17:15 85796 8192000000 10938139664 11403202560 1968538400 19.374 99 9 16 0 1979480864 8592256 2350208
21:18:54 76502 8192000000 10881385200 11343278080 1883836432 18.696 95 12 24 2 1900870032 13652512 3381088
21:20:17 57799 8192000000 10890244448 11359481856 1890964320 18.754 96 22 44 0 1911865264 14527344 6373600
21:21:27 144848 8192000000 10888226704 11349618688 1911776416 18.921 97 23 46 1 1927734304 9975200 5982688
21:23:58 40963 8192000000 10897944336 11355664384 1921474272 18.999 98 48 93 3 1951964240 17268336 13221632
21:24:48 26781 8192000000 10831053840 11299205120 1850014768 18.422 95 11 21 2 1863898640 10890080 2993792
21:25:22 31581 8192000000 10868364800 11327733760 1916262512 18.957 99 23 46 1 1932702272 9746368 6693392
21:26:13 53100 8192000000 10848174608 11321225216 1901946768 18.842 98 15 31 0 1915382368 9192528 4243072
21:27:20 55211 8192000000 10853600336 11323658240 1903586432 18.855 98 14 28 0 1915423408 8648112 3188864
21:28:31 47022 8192000000 10856074368 11330351104 1941783328 19.161 100 10 20 0 1949993152 5922848 2286976
21:29:25 36691 8192000000 10853757120 11319717888 1906792592 18.881 98 16 32 1 1916599424 5730400 4076432
21:30:26 76729 8192000000 10842733600 11322155008 1884982944 18.705 97 10 20 0 1897111552 9416272 2712336
21:32:12 50964 8192000000 10857319600 11318534144 1888321552 18.732 97 13 26 0 1900245600 8413840 3510208
21:33:12 29229 8192000000 10866585520 11332509696 1913436160 18.934 98 24 48 0 1927789440 7648592 6704688
21:33:52 22186 8192000000 10874227504 11338366976 1927231312 19.045 99 18 36 3 1944304576 12420240 4653024
21:34:20 38319 8192000000 10881111264 11329691648 1873290096 18.611 96 34 68 0 1891390224 8277008 9823120
21:35:26 90629 8192000000 10859463168 11330027520 1866340128 18.555 96 12 24 1 1881738224 11595040 3803056
21:37:03 52412 8192000000 10832813904 11300585472 1846423408 18.393 96 15 30 0 1869276624 18238688 4614528
21:38:01 50451 8192000000 10861613296 11311775744 1873194016 18.610 97 36 72 0 1892142208 8246944 10701248
21:39:00 54230 8192000000 10890507024 11344195584 1916376944 18.958 99 37 74 0 1943177360 16724592 10075824
21:40:21 45893 8192000000 10847311552 11329044480 1888755728 18.736 97 24 48 2 1907133840 11907168 6470944
21:41:15 26394 8192000000 10890938320 11334385664 1907798144 18.889 98 34 68 1 1924968928 7500608 9670176
21:41:49 24038 8192000000 10889395520 11350220800 1957011744 19.282 100 53 106 1 1983270992 11099968 15159280
21:42:23 90620 8192000000 10884640688 11335155712 1853214768 18.448 95 20 40 0 1869827296 10854096 5758432
21:44:26 113590 8192000000 10873212944 11324375040 1884966384 18.705 97 16 32 0 1901802128 12012352 4823392
21:46:34 54002 8192000000 10894492112 11352870912 1928639952 19.056 99 19 38 1 1946589104 12506512 5442640
21:49:07 90798 8192000000 10885071408 11361193984 1947974784 19.210 99 13 26 1 1965596912 14045568 3576560
21:50:45 68552 8192000000 10876869296 11357794304 1955862032 19.273 100 8 16 0 1969316192 11144800 2309360
21:52:01 52072 8192000000 10889022848 11366936576 1964222448 19.340 100 13 25 3 1980442384 11726976 4492960
21:53:17 69475 8192000000 10892844384 11375489024 1973749472 19.415 100 17 34 1 1993801360 14762080 5289808
21:54:33 44354 8192000000 10903116208 11377426432 1973219296 19.411 100 21 42 1 1993243712 13974800 6049616
21:55:23 42462 8192000000 10913651056 11388760064 1983515696 19.493 100 15 31 1 1999530976 11414448 4600832
21:56:12 71144 8192000000 10908790720 11384320000 1932855056 19.090 97 16 32 1 1949013824 11665920 4492848
21:57:50 87742 8192000000 10888224352 11365494784 1905337040 18.869 96 16 34 0 1930313888 20857232 4119616
21:59:24 52285 8192000000 10920443824 11380580352 1976115344 19.434 100 22 44 0 1990039520 7960208 5963968
22:00:23 45828 8192000000 10890949280 11365900288 1936157376 19.116 98 22 44 0 1952212736 10076192 5979168
22:01:20 63744 8192000000 10872544976 11335958528 1891095760 18.755 96 24 47 0 1907973136 9844032 7033344
22:02:31 35357 8192000000 10893088640 11353726976 1948860672 19.217 99 27 54 0 1965981024 9592992 7527360
22:03:20 12698 8192000000 10935372352 11373293568 1979689664 19.462 100 58 115 1 2005016432 8939840 16386928
22:03:39 31441 8192000000 10925727520 11382284288 1968067600 19.370 99 56 112 1 1998607056 14287248 16252208
22:04:20 71139 8192000000 10891817696 11374854144 1932633616 19.088 98 17 34 1 1951206592 13904608 4668368
22:05:38 59231 8192000000 10892385456 11358695424 1919950160 18.986 97 17 34 1 1939846160 15551344 4344656
22:06:43 58215 8192000000 10888342176 11356966912 1932640336 19.088 98 22 44 1 1952076688 13386896 6049456
22:07:47 116565 8192000000 10883376864 11346300928 1869286912 18.579 95 19 38 1 1887561712 12503424 5771376
22:09:51 73939 8192000000 10864995552 11338280960 1943525472 19.175 99 31 62 0 1961343856 8063328 9755056
22:11:16 46750 8192000000 10839836144 11311288320 1859739840 18.501 96 22 44 1 1876539504 9996688 6802976
22:13:08 78967 8192000000 10833239520 11310202880 1891169968 18.755 98 15 30 0 1902851152 7874720 3806464
22:14:34 65780 8192000000 10834473184 11304370176 1855563344 18.467 96 12 24 0 1870251360 11448096 3239920
22:15:46 50924 8192000000 10842052608 11309117440 1872884912 18.608 97 18 36 1 1892503040 14372272 5245856
22:16:44 51606 8192000000 10833140320 11309879296 1892496720 18.766 99 10 20 0 1909991056 14479952 3014384
22:17:42 82576 8192000000 10817117648 11276091392 1847485760 18.402 96 11 22 0 1857914320 7518784 2909776
22:19:11 58984 8192000000 10800267904 11268763648 1832268992 18.278 95 26 52 0 1851202464 12067392 6866080
22:20:28 53884 8192000000 10810855104 11297591296 1892140208 18.763 100 7 14 0 1908940416 14824640 1975568
22:21:57 45897 8192000000 10835469280 11305050112 1870121744 18.585 98 10 20 0 1881277296 8094320 3061232
22:22:54 41271 8192000000 10839607680 11307110400 1883743344 18.695 98 15 30 0 1896374976 8130656 4500976
22:23:44 49514 8192000000 10858712736 11317665792 1889232208 18.740 98 29 58 1 1906249264 9228208 7788848
22:24:49 47774 8192000000 10860209104 11330105344 1915903984 18.954 99 30 60 0 1936628896 12166704 8558208
22:25:45 54276 8192000000 10858645424 11328970752 1854501616 18.459 96 25 49 1 1871545408 10229840 6813952
22:27:00 17508 8192000000 8937141488 9295769600 24857904 0.302 2 2 2 1 25524048 244720 421424

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 08-12-2020 22:28:20 to 08-12-2020 22:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 205 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-12-2020 22:28:51 to 08-12-2020 22:28:53.

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          255072
MON$OLDEST_ACTIVE               255073
MON$OLDEST_SNAPSHOT             255073
MON$NEXT_TRANSACTION            255073
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                       2035488
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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'

08.12.20 22:28:54. 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
2020-12-08 22:28:56 No severe PSQL-related problems occured
08.12.20 22:28:57. End of report.