Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.03.2021 22: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 17421524 kB
MemAvailable 31645956 kB
Buffers 0 kB
Cached 14285276 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-03-08 22:27:20
DTS_END                         2021-03-08 22:27:20.3410
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/40854
TRN_ID                          247885
ATT_ID                          736
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: 9431.77 22234 1131812
customer order: creation 175.81 336 21097
customer order: refuse 15.06 380 1807
order to supplier: creation 47.67 1265 5720
order to supplier: removal 3.48 99942 417
invoice (draft): creation 47.09 3298 5651
invoice (draft): removal 53.29 725 6395
invoice accept: apply 42.87 18622 5144
invoice accept: cancel 48.19 736 5783
customer reserve: creation 3967.26 184 476071
customer reserve: removal 4723.76 58 566851
realization accept: apply 86.70 160 10404
realization accept: cancel 87.38 111 10486
payment from customer: creation 60.38 119 7246
payment from customer: removal 5.97 83 716
payment to supplier: creation 50.53 110 6063
payment to supplier: removal 3.42 94 410
service: total inventory turnovers 5.11 1062 613
service: total monetary turnovers 6.97 26 836
service: aggregate perf. data 0.82 22736 98
service: refresh index statistics 0.03 294629 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-03-2021 22:28:46 to 08-03-2021 22:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3742
TEST_TIME 2 4997
TEST_TIME 3 4745
TEST_TIME 4 5788
TEST_TIME 5 5888
TEST_TIME 6 5470
TEST_TIME 7 5887
TEST_TIME 8 6199
TEST_TIME 9 6193
TEST_TIME 10 6250
TEST_TIME 11 6396
TEST_TIME 12 6769
TEST_TIME 13 6649
TEST_TIME 14 6597
TEST_TIME 15 6608
TEST_TIME 16 6865
TEST_TIME 17 7093
TEST_TIME 18 7021
TEST_TIME 19 7152
TEST_TIME 20 7656
TEST_TIME 21 7847
TEST_TIME 22 8181
TEST_TIME 23 8828
TEST_TIME 24 8625
TEST_TIME 25 8740
TEST_TIME 26 9033
TEST_TIME 27 9292
TEST_TIME 28 9267
TEST_TIME 29 9867
TEST_TIME 30 10702
TEST_TIME 31 10501
TEST_TIME 32 10408
TEST_TIME 33 10624
TEST_TIME 34 10856
TEST_TIME 35 10848
TEST_TIME 36 10704
TEST_TIME 37 10443
TEST_TIME 38 10396
TEST_TIME 39 10334
TEST_TIME 40 10122
TEST_TIME 41 10171
TEST_TIME 42 10149
TEST_TIME 43 10084
TEST_TIME 44 10032
TEST_TIME 45 10134
TEST_TIME 46 10031
TEST_TIME 47 9904
TEST_TIME 48 9934
TEST_TIME 49 9850
TEST_TIME 50 9780
TEST_TIME 51 9676
TEST_TIME 52 9649
TEST_TIME 53 9558
TEST_TIME 54 9706
TEST_TIME 55 9686
TEST_TIME 56 9697
TEST_TIME 57 9739
TEST_TIME 58 9703
TEST_TIME 59 9713
TEST_TIME 60 9842
TEST_TIME 61 9786
TEST_TIME 62 9845
TEST_TIME 63 9921
TEST_TIME 64 9956
TEST_TIME 65 9974
TEST_TIME 66 10050
TEST_TIME 67 9956
TEST_TIME 68 9856
TEST_TIME 69 9814
TEST_TIME 70 9763
TEST_TIME 71 9778
TEST_TIME 72 9712
TEST_TIME 73 9655
TEST_TIME 74 9648
TEST_TIME 75 9559
TEST_TIME 76 9520
TEST_TIME 77 9544
TEST_TIME 78 9534
TEST_TIME 79 9494
TEST_TIME 80 9552
TEST_TIME 81 9608
TEST_TIME 82 9649
TEST_TIME 83 9666
TEST_TIME 84 9703
TEST_TIME 85 9659
TEST_TIME 86 9707
TEST_TIME 87 9681
TEST_TIME 88 9734
TEST_TIME 89 9778
TEST_TIME 90 9740
TEST_TIME 91 9682
TEST_TIME 92 9670
TEST_TIME 93 9630
TEST_TIME 94 9585
TEST_TIME 95 9560
TEST_TIME 96 9508
TEST_TIME 97 9569
TEST_TIME 98 9526
TEST_TIME 99 9529
TEST_TIME 100 9516
TEST_TIME 101 9582
TEST_TIME 102 9591
TEST_TIME 103 9577
TEST_TIME 104 9593
TEST_TIME 105 9637
TEST_TIME 106 9641
TEST_TIME 107 9642
TEST_TIME 108 9732
TEST_TIME 109 9733
TEST_TIME 110 9660
TEST_TIME 111 9618
TEST_TIME 112 9583
TEST_TIME 113 9556
TEST_TIME 114 9575
TEST_TIME 115 9519
TEST_TIME 116 9547
TEST_TIME 117 9511
TEST_TIME 118 9495
TEST_TIME 119 9480
TEST_TIME 120 9433

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-03-2021 22:28:49 to 08-03-2021 22:28:53.

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 1572083 1572083 0 0.00 0 18257 6 0 0
doc_list_biud 1572083 1572083 0 0.00 0 42851 26 0 0
sp_add_invoice_to_stock 5219 5144 75 1.43 17 225674 18622 0 75
sp_cancel_adding_invoice 5783 5783 0 0.00 3 82934 736 0 0
sp_cancel_client_order 1807 1807 0 0.00 4 21256 380 0 0
sp_cancel_customer_reserve 566851 566851 0 0.00 1 31715 58 0 0
sp_cancel_pay_from_customer 716 716 0 0.00 2 10309 83 0 0
sp_cancel_pay_to_supplier 410 410 0 0.00 2 6434 95 0 0
sp_cancel_supplier_invoice 6398 6395 3 0.04 1 13001 725 0 3
sp_cancel_supplier_order 417 417 0 0.00 4 1009810 99942 0 0
sp_cancel_write_off 10486 10486 0 0.00 1 10588 112 0 0
sp_client_order 21097 21097 0 0.00 3 20148 336 0 0
sp_customer_reserve 476071 476071 0 0.00 0 68424 185 0 0
sp_fill_shopping_cart 32461 32461 0 0.00 1 14963 37 0 0
sp_fill_shopping_cart_clo_res 476067 476067 0 0.00 0 16843 13 0 0
sp_get_clo_for_invoice 5140 5140 0 0.00 0 29757 301 0 0
sp_kill_cost_storno 17395 17395 0 0.00 0 13744 57 0 0
sp_kill_qstorno_ret_qs2qd 1151000 1151000 0 0.00 0 31707 31 0 0
sp_kill_qty_storno 607282 607282 0 0.00 0 42846 67 0 0
sp_lock_selected_doc 21408 21408 0 0.00 0 7754 5 0 0
sp_make_cost_storno 28852 28852 0 0.00 0 14859 46 0 0
sp_multiply_rows_for_pdistr 28852 28852 0 0.00 0 8493 30 0 0
sp_multiply_rows_for_qdistr 21097 21097 0 0.00 0 11392 147 0 0
sp_pay_from_customer 7246 7246 0 0.00 4 10521 119 0 0
sp_pay_to_supplier 6063 6063 0 0.00 4 11886 111 0 0
sp_payment_common 13309 13309 0 0.00 1 7717 23 0 0
sp_qd_handle_on_cancel_clo 1807 1807 0 0.00 0 21222 346 0 0
sp_qd_handle_on_invoice_upd_sts 10922 10922 0 0.00 0 42839 312 0 0
sp_qd_handle_on_reserve_upd_sts 10404 10404 0 0.00 0 10737 49 0 0
sp_reserve_write_off 10404 10404 0 0.00 6 11490 160 0 0
sp_supplier_invoice 5651 5651 0 0.00 6 86489 3298 0 0
sp_supplier_order 5720 5720 0 0.00 5 61351 1266 0 0
srv_aggregate_perf_data 98 98 0 0.00 3272 402227 22736 0 0
srv_fill_mon_cache_memory 166 166 0 0.00 1177 149299 31570 0 0
srv_find_qd_qs_mism 1082470 1082470 0 0.00 0 18257 5 0 0
srv_make_invnt_saldo 613 613 0 0.00 41 50679 1063 0 0
srv_make_money_saldo 836 836 0 0.00 1 1991 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 142904 417723 294630 0 0
t$perf-abend:sp_add_invoice_to_stock 75 75 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 3 3 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5144 5144 0 0.00 0 12682 152 0 0
t$perf-norm:sp_cancel_adding_invoice 418 418 0 0.00 0 5414 97 0 0
t$perf-norm:sp_cancel_client_order 1807 1807 0 0.00 0 3575 16 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 3345 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 716 716 0 0.00 0 3657 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 410 410 0 0.00 0 3355 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 440 440 0 0.00 0 2175 23 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 24978 1491 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 2276 10 0 0
t$perf-norm:sp_client_order 21097 21097 0 0.00 0 10184 16 0 0
t$perf-norm:sp_customer_reserve 1043 1043 0 0.00 0 7925 20 0 0
t$perf-norm:sp_pay_from_customer 7246 7246 0 0.00 0 11857 13 0 0
t$perf-norm:sp_pay_to_supplier 6063 6063 0 0.00 0 3064 9 0 0
t$perf-norm:sp_reserve_write_off 10404 10404 0 0.00 0 9384 11 0 0
t$perf-norm:sp_supplier_invoice 5651 5651 0 0.00 0 7453 18 0 0
t$perf-norm:sp_supplier_order 5720 5720 0 0.00 0 7548 17 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 1077 23 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 1092 12 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 762 19 0 0
t$perf-norm:srv_make_money_saldo 836 836 0 0.00 0 2754 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 5 0 0
v_add_invoice_to_stock 10428 10278 150 1.43 0 7586 16 0 150
v_all_customers 38146 38146 0 0.00 0 16 1 0 0
v_all_suppliers 31730 31730 0 0.00 0 17 1 0 0
v_all_wares 42194 42194 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 836 836 0 0.00 0 4052 13 0 0
v_cancel_client_order 3614 3614 0 0.00 0 11560 8 0 0
v_cancel_customer_prepayment 1432 1432 0 0.00 0 3877 11 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 1143 6 0 0
v_cancel_payment_to_supplier 820 820 0 0.00 0 4995 12 0 0
v_cancel_supplier_invoice 886 880 6 0.67 0 5547 20 0 6
v_cancel_supplier_order 834 834 0 0.00 0 812 6 0 0
v_cancel_write_off 2002 2002 0 0.00 0 5010 16 0 0
v_max_id_clo_ord 5720 5720 0 0.00 0 4024 2 0 0
v_max_id_clo_res 1043 1043 0 0.00 0 2455 19 0 0
v_max_id_ord_sup 5644 5644 0 0.00 0 5645 6 0 0
v_max_non_paid_invoice 1562 1562 0 0.00 0 511 3 0 0
v_max_non_paid_realizn 4014 4014 0 0.00 0 2865 5 0 0
v_min_id_clo_ord 5720 5720 0 0.00 0 2628 5 0 0
v_min_id_clo_res 1043 1043 0 0.00 0 3909 17 0 0
v_min_id_ord_sup 5644 5644 0 0.00 0 5707 6 0 0
v_min_non_paid_invoice 6063 6063 0 0.00 0 5841 14 0 0
v_min_non_paid_realizn 7246 7246 0 0.00 0 6253 13 0 0
v_our_firm 10512 10512 0 0.00 0 16 1 0 0
v_reserve_write_off 20808 20808 0 0.00 0 9449 7 0 0
x_lock_depdocs_on_canc_invoice 11738 11738 0 0.00 0 27051 124 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 6380 335 0 0
x_make_qstorno_1000_1200 5720 5720 0 0.00 2 59315 1178 0 0
x_make_qstorno_1200_2000 5651 5651 0 0.00 3 86473 3171 0 0
x_make_qstorno_2100_3300 476071 476071 0 0.00 0 68423 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-03-2021 22:28:54 to 08-03-2021 22:28:58.

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:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:30 10609 8192000000 10219911056 10525827072 905477312 9.953 71 47 94 0 923470080 2455312 15537456
19:57:51 21733 8192000000 10344018816 10663489536 1369077840 14.319 100 79 159 0 1398857840 4119376 25660624
19:58:24 29945 8192000000 10378931088 10703249408 1433924240 14.896 100 84 168 0 1466837296 6007216 26905840
19:59:10 23801 8192000000 10412747232 10740969472 1468895872 15.204 100 87 173 0 1503995632 7339632 27760128
19:59:56 21301 8192000000 10440182256 10775203840 1497392224 15.453 100 82 164 0 1530711504 7672544 25646736
20:00:34 17214 8192000000 10462953264 10797588480 1518897616 15.641 100 89 179 0 1555182848 8445232 27840000
20:01:03 12521 8192000000 10471464960 10812346368 1534231472 15.774 100 84 168 0 1568699296 8438432 26029392
20:01:24 17002 8192000000 10497751904 10841137152 1550935776 15.918 100 79 158 1 1584169408 8937376 24296256
20:01:51 20767 8192000000 10529068480 10875932672 1575025248 16.125 100 77 154 0 1607952560 9775008 23152304
20:02:22 18472 8192000000 10540440336 10898067456 1603104752 16.366 100 71 142 2 1634269440 10530512 20634176
20:02:50 14822 8192000000 10565696640 10922967040 1620753568 16.516 100 78 156 1 1654638496 10620224 23264704
20:03:15 12210 8192000000 10593216624 10956902400 1651456224 16.777 100 78 156 1 1686619776 11483136 23680416
20:03:34 11928 8192000000 10620334432 10986094592 1682479360 17.038 100 84 168 0 1719990592 12589504 24921728
20:03:55 9623 8192000000 10645542480 11012632576 1705122096 17.228 100 89 175 3 1743512048 12746368 25643584
20:04:14 9341 8192000000 10660040768 11036360704 1719723536 17.350 100 81 162 2 1756144160 13196544 23224080
20:04:32 9166 8192000000 10678781920 11050426368 1737137776 17.495 100 88 176 1 1776319328 13863840 25317712
20:04:48 8666 8192000000 10681457728 11060482048 1740213248 17.520 100 70 140 1 1772263008 12611504 19438256
20:05:04 5955 8192000000 10703270272 11083104256 1765160208 17.727 100 83 163 1 1800721824 12297952 23263664
20:05:18 5086 8192000000 10716555056 11094872064 1777101632 17.826 100 91 180 0 1815864400 12868576 25894192
20:05:31 5655 8192000000 10716475568 11094560768 1778428416 17.837 100 85 170 0 1815395376 13450944 23516016
20:05:43 3337 8192000000 10722973344 11109310464 1786734096 17.905 100 77 153 1 1821725120 13620048 21370976
20:05:54 3850 8192000000 10732350160 11114201088 1793732208 17.962 100 80 159 0 1830434560 14433968 22268384
20:06:04 3502 8192000000 10743595056 11127066624 1799907824 18.013 100 75 150 0 1832312224 11485728 20918672
20:06:15 2654 8192000000 10748240624 11135447040 1810117392 18.097 100 91 181 0 1847637664 12177728 25342544
20:06:24 9503 8192000000 10753885952 11140526080 1812350304 18.115 100 78 156 0 1847367296 12898336 22118656
20:06:40 6246 8192000000 10771290288 11155136512 1821760128 18.192 100 89 179 2 1860151824 13356960 25034736
20:06:53 3527 8192000000 10774414480 11164798976 1833771360 18.290 100 79 158 1 1869739264 13609808 22358096
20:07:03 2213 8192000000 10785212608 11175051264 1849403648 18.417 100 91 182 2 1887283360 12185568 25694144
20:07:12 1945 8192000000 10803615168 11189493760 1855431760 18.466 100 88 178 1 1892731584 12399504 24900320
20:07:21 1787 8192000000 10800952560 11187548160 1859493152 18.499 100 84 168 2 1894888432 12123312 23271968
20:07:29 1148 8192000000 10801767760 11192856576 1861917888 18.519 100 90 181 0 1900128752 12974512 25236352
20:07:37 1052 8192000000 10812487248 11199008768 1867614064 18.565 100 95 189 1 1907966928 13125840 27227024
20:07:45 1573 8192000000 10817696832 11205459968 1869754176 18.582 100 93 187 0 1908987184 13136208 26096800
20:07:53 1813 8192000000 10808963264 11201122304 1872424752 18.604 100 89 169 3 1908159504 12211184 23523568
20:08:02 1653 8192000000 10822631888 11212791808 1877728704 18.647 100 90 179 2 1915242496 13144688 24369104
20:08:10 1455 8192000000 10828841120 11217547264 1880296160 18.667 100 93 186 0 1920722800 13976448 26450192
20:08:18 1331 8192000000 10824052960 11215020032 1881994480 18.681 100 90 181 0 1922323440 14740576 25588384
20:08:26 1280 8192000000 10824001312 11221258240 1886151536 18.715 100 88 175 0 1925113008 13563760 25397712
20:08:34 14359 8192000000 10786788272 11216515072 1883463456 18.693 100 59 116 1 1911611120 11076576 17071088
20:09:13 14140 8192000000 10787136736 11213754368 1875595952 18.630 100 29 56 1 1893816160 10829584 7390624
20:09:34 5313 8192000000 10808617952 11220291584 1882600704 18.686 100 36 73 2 1900283424 6670352 11012368
20:09:47 6081 8192000000 10786593568 11217260544 1880839856 18.672 100 30 59 1 1896514912 7645024 8030032
20:09:59 9440 8192000000 10793336800 11223822336 1879492128 18.661 100 21 42 0 1892631936 7696416 5443392
20:10:15 6741 8192000000 10799753536 11225079808 1883975328 18.697 100 13 26 0 1892772768 5621440 3176000
20:10:28 7216 8192000000 10800157184 11224498176 1885605584 18.710 100 23 46 0 1898033536 6187232 6240720
20:10:43 5410 8192000000 10794770736 11226615808 1887041728 18.722 100 18 36 0 1899042688 6438480 5562480
20:10:55 5561 8192000000 10802410368 11230134272 1890731248 18.752 100 26 52 1 1905802016 7036848 8033920
20:11:07 10191 8192000000 10796663600 11232649216 1890661280 18.751 100 20 40 0 1903069904 6939008 5469616
20:11:26 8072 8192000000 10797771280 11232276480 1894681776 18.783 100 24 45 3 1907454624 6599744 6173104
20:11:40 13901 8192000000 10794694592 11232796672 1891606432 18.759 100 18 36 1 1902977824 6366224 5005168
20:12:04 10693 8192000000 10812431776 11242000384 1898288544 18.813 100 18 36 1 1908809520 5421920 5099056
20:12:22 58306 8192000000 10844610352 11255455744 1907049632 18.883 100 34 70 1 1922958992 6150208 9759152
20:13:35 25493 8192000000 10822442608 11258257408 1904849616 18.865 100 15 30 2 1914835504 5958256 4027632
20:14:06 5579 8192000000 10830494544 11258535936 1910691344 18.912 100 32 64 2 1926501760 6627072 9183344
20:14:21 6653 8192000000 10824768576 11258597376 1909936400 18.906 100 29 59 1 1924514896 5642096 8936400
20:14:36 5746 8192000000 10828199088 11260608512 1910687872 18.912 100 26 52 1 1924440976 6890336 6862768
20:14:49 4359 8192000000 10824790192 11261366272 1910409408 18.910 100 22 44 2 1922399296 5782528 6207360
20:15:00 9637 8192000000 10826486864 11261059072 1909672288 18.904 100 17 34 0 1920414848 5677440 5065120
20:15:16 6488 8192000000 10822762688 11261808640 1915290704 18.949 100 33 66 1 1931472224 6745040 9436480
20:15:33 5973 8192000000 10837236016 11265617920 1914968864 18.947 100 28 55 4 1928955008 5563360 8422784
20:15:48 6067 8192000000 10833250928 11269644288 1918416736 18.974 100 22 45 2 1930333008 5228336 6687936
20:16:01 9007 8192000000 10822088768 11256721408 1893961520 18.778 99 30 60 3 1908695360 5831520 8902320
20:16:18 9078 8192000000 10802761616 11239346176 1865717920 18.550 98 18 36 1 1876868224 6480848 4669456
20:16:36 5956 8192000000 10788943936 11216748544 1824616512 18.215 96 19 39 0 1835798496 5988512 5193472
20:16:52 10706 8192000000 10759308336 11193270272 1808329776 18.082 96 14 28 2 1817698480 5280304 4088400
20:17:09 47605 8192000000 10761823152 11184275456 1769110768 17.760 94 26 51 1 1782029616 4972032 7946816
20:18:11 24443 8192000000 10740663920 11168088064 1722160704 17.370 92 29 59 3 1735632464 5949792 7521968
20:18:41 6579 8192000000 10758015296 11182919680 1829247376 18.253 99 30 58 2 1844936208 6084704 9604128
20:18:54 8662 8192000000 10735641744 11151597568 1754214272 17.637 95 27 54 3 1768124768 6449184 7461312
20:19:10 5897 8192000000 10695086448 11111202816 1750550720 17.606 97 28 56 1 1764350960 6071664 7728576
20:19:22 11456 8192000000 10720175520 11135193088 1735992624 17.485 95 30 57 1 1749977744 5563184 8421936
20:19:39 5553 8192000000 10708828944 11117432832 1745001648 17.560 96 40 80 1 1762705904 5681792 12022464
20:19:52 7413 8192000000 10684642640 11105234944 1738008368 17.502 97 27 53 0 1751738800 5949728 7780704
20:20:07 8110 8192000000 10721587840 11140575232 1802929472 18.038 100 21 42 1 1818988352 9666784 6392096
20:20:26 10762 8192000000 10718399504 11132997632 1770238016 17.769 98 30 59 3 1788500320 9642384 8619920
20:20:43 8056 8192000000 10712550080 11121131520 1713826272 17.301 95 19 38 0 1724839936 5293120 5720544
20:21:02 5544 8192000000 10737561856 11148967936 1796282624 17.983 99 34 68 1 1812838320 6281040 10274656
20:21:17 12328 8192000000 10740911712 11157643264 1808201664 18.081 99 29 58 1 1822661648 5043216 9416768
20:21:38 8730 8192000000 10740993632 11169030144 1813807584 18.127 99 22 44 0 1825874816 6246144 5821088
20:21:53 62913 8192000000 10774135904 11192856576 1844735472 18.379 100 40 80 1 1861937792 5668160 11534160
20:23:03 19271 8192000000 10762797168 11191197696 1830749024 18.265 99 19 38 2 1841936096 5552352 5634720
20:23:28 8735 8192000000 10754023184 11186380800 1849029808 18.414 100 31 63 3 1863706992 6108016 8569168
20:23:43 6036 8192000000 10769004064 11196100608 1851500512 18.434 100 24 46 0 1863722112 5268656 6952944
20:23:56 5562 8192000000 10771807008 11197341696 1853410656 18.450 100 28 56 0 1867584464 5679264 8494544
20:24:08 12316 8192000000 10777533920 11196198912 1849835648 18.421 100 20 40 2 1861122528 5466064 5820816
20:24:30 6768 8192000000 10775196400 11197947904 1855016000 18.463 100 20 39 3 1867297040 6153264 6127776
20:24:43 7315 8192000000 10767397792 11198889984 1856668880 18.476 100 16 32 1 1866498416 5031024 4798512
20:24:56 11333 8192000000 10777932624 11209715712 1862170208 18.521 100 23 46 1 1873587600 4825600 6591792
20:25:14 10732 8192000000 10775349744 11210649600 1865086032 18.544 100 19 38 5 1875463632 5215504 5162096
20:25:34 11495 8192000000 10780266672 11213910016 1869199632 18.578 100 21 42 5 1880533744 5614624 5719488
20:25:51 14442 8192000000 10780349056 11217883136 1868719152 18.574 100 15 28 2 1878389344 5272672 4397520
20:26:12 10917 8192000000 10790698192 11220443136 1868794352 18.575 100 13 26 0 1877961680 5448880 3718448
20:26:37 11625 8192000000 10786330048 11217649664 1869181808 18.578 100 12 24 0 1878365440 5547792 3635840
20:26:55 82713 8192000000 10806523488 11225788416 1861870352 18.518 99 23 46 1 1874209696 5052384 7286960
20:28:24 2302 8192000000 10840709856 11258486784 1909498368 18.903 100 63 125 1 1935468384 7842240 18127776
20:28:34 3627 8192000000 10856976304 11269152768 1916052928 18.955 100 60 119 1 1941466224 9030960 16382336
20:28:47 24646 8192000000 10858989648 11278917632 1918807920 18.977 100 48 96 0 1941656688 9715760 13133008
20:29:28 6907 8192000000 10865092576 11280138240 1910133856 18.908 99 60 120 1 1940178320 12585632 17458832
20:29:42 8331 8192000000 10871751952 11289169920 1929352976 19.062 100 67 134 1 1962160896 13902352 18905568
20:29:58 24435 8192000000 10864275648 11291308032 1932551344 19.087 100 58 116 0 1962635344 13545248 16538752
20:30:43 15349 8192000000 10872476768 11302047744 1939289568 19.141 100 57 114 0 1971395616 14556032 17550016
20:31:07 8568 8192000000 10878481424 11304849408 1943371776 19.174 100 58 115 4 1971678800 12286688 16020336
20:31:41 13049 8192000000 10882483424 11308843008 1943590400 19.175 100 52 104 1 1969549904 11357072 14602432
20:32:01 6924 8192000000 10890252528 11317407744 1953834496 19.257 100 62 124 1 1984219152 12823216 17561440
20:32:23 22762 8192000000 10874828448 11303428096 1935175344 19.108 99 48 95 3 1960544320 12058848 13310128
20:32:54 17758 8192000000 10882581296 11313729536 1937226048 19.125 99 52 104 0 1965497392 12624448 15646896
20:33:37 12833 8192000000 10897002336 11326533632 1954809072 19.265 100 52 103 2 1986448288 16882768 14756448
20:34:04 11688 8192000000 10904384656 11335274496 1964244720 19.340 100 54 106 2 1996710912 16328144 16138048
20:34:31 5019 8192000000 10894845824 11328237568 1959818544 19.305 100 55 110 4 1991215360 15261600 16135216
20:34:44 4251 8192000000 10916147792 11337277440 1966825216 19.360 100 71 140 3 2004272416 17621168 19826032
20:34:56 4901 8192000000 10902970720 11325358080 1951500320 19.238 99 68 133 1 1990497760 18914736 20082704
20:35:09 9984 8192000000 10900144064 11312545792 1944397616 19.182 99 66 131 0 1980909392 18079120 18432656
20:35:26 10654 8192000000 10915559872 11335348224 1969159152 19.379 100 74 147 2 2009385392 19299200 20927040
20:35:46 8630 8192000000 10908993152 11339300864 1968589296 19.374 100 60 120 2 2006002576 19914352 17498928
20:36:05 11051 8192000000 10909952208 11347243008 1970312224 19.388 100 47 94 1 2002490432 18299424 13878784
20:36:24 28498 8192000000 10914668592 11340480512 1952388960 19.245 99 54 108 1 1986396272 17912624 16094688
20:37:01 4384 8192000000 10927066672 11351916544 1973911472 19.416 100 60 118 1 2012440192 21483952 17044768
20:37:13 1970 8192000000 10929376080 11336118272 1945649936 19.192 98 77 154 3 1991370864 22002208 23718720
20:37:24 1170 8192000000 10946030432 11353366528 1976421024 19.436 100 82 167 0 2023910560 23517440 23972096
20:37:34 3642 8192000000 10938315328 11352289280 1973612400 19.414 100 77 154 0 2020074736 24333600 22128736
20:37:44 7755 8192000000 10908460944 11328266240 1930881792 19.074 98 71 141 2 1977598144 25129120 21587232
20:38:00 4145 8192000000 10915826064 11328335872 1924189248 19.020 98 71 142 0 1971704736 26007328 21508160
20:38:12 13664 8192000000 10893147600 11309449216 1934749120 19.105 99 73 146 0 1983758624 26734208 22275296
20:38:33 20131 8192000000 10906217344 11338321920 1958554048 19.295 100 73 146 2 2007883472 26656896 22672528
20:39:06 11214 8192000000 10902771472 11335102464 1939125664 19.140 99 53 106 1 1982430096 26743760 16560672
20:39:26 10344 8192000000 10896720736 11324219392 1926360848 19.038 99 53 106 2 1972417728 29063296 16993584
20:39:45 5769 8192000000 10906453376 11334303744 1952240720 19.244 100 62 124 0 1994755680 23421520 19093440
20:40:07 25900 8192000000 10883820336 11308204032 1914674880 18.944 98 35 70 1 1946346112 21000288 10670944
20:40:45 9175 8192000000 10870518592 11287273472 1910222880 18.908 99 52 102 1 1951909376 26330912 15355584
20:41:04 1638 8192000000 10886062160 11300589568 1924325136 19.021 100 78 153 0 1972252736 24481968 23445632
20:41:14 3037 8192000000 10872361744 11284127744 1895722864 18.792 98 76 149 3 1944206784 25648224 22835696
20:41:26 3823 8192000000 10889962048 11302973440 1913280480 18.933 99 64 126 0 1958716304 25830048 19605776
20:41:41 11746 8192000000 10865461920 11285143552 1899180704 18.820 99 63 124 3 1945406416 27218720 19006992
20:42:00 4437 8192000000 10884252320 11292114944 1902350016 18.845 99 67 132 0 1951284848 29158192 19776640
20:42:13 15346 8192000000 10893265520 11316154368 1929719552 19.065 100 56 112 3 1979740976 32770352 17251072
20:42:46 6299 8192000000 10918906560 11340050432 1948050944 19.211 100 60 120 1 2003761520 36328368 19382208
20:42:58 2064 8192000000 10914103280 11318550528 1932937664 19.090 99 75 145 1 1990158448 35139728 22081056
20:43:08 2258 8192000000 10911575408 11326472192 1927027584 19.043 99 70 140 3 1985980992 36553856 22399552
20:43:18 3356 8192000000 10923177216 11332968448 1945714352 19.192 100 84 167 1 2009148560 38096640 25337568
20:43:28 3516 8192000000 10928804832 11337854976 1952486128 19.246 100 79 158 0 2012739840 36081536 24172176
20:43:39 3858 8192000000 10925184752 11329699840 1930496384 19.071 99 73 146 0 1990402880 36863888 23042608
20:43:50 2762 8192000000 10910315920 11318546432 1931496864 19.079 99 78 155 2 1992452048 36952608 24002576
20:44:00 1529 8192000000 10936108208 11343921152 1941860048 19.162 99 83 163 3 2004649648 37741392 25048208
20:44:09 1936 8192000000 10940684704 11354222592 1962363744 19.325 100 80 161 0 2023200336 34989888 25846704
20:44:18 4115 8192000000 10916030400 11328106496 1918851968 18.978 98 80 156 1 1976144048 33110400 24181680
20:44:33 2676 8192000000 10937338768 11346640896 1959975232 19.306 100 80 160 0 2019290784 34613312 24702240
20:44:44 3348 8192000000 10941790912 11348328448 1947744496 19.209 99 85 170 1 2009624704 35368016 26512192
20:44:54 3933 8192000000 10928081248 11331383296 1918004720 18.971 98 78 154 3 1978401264 36158240 24238304
20:45:08 3908 8192000000 10932206672 11346587648 1951408736 19.238 100 75 149 2 2013180592 38736128 23035728
20:45:22 8160 8192000000 10928030016 11343822848 1935479344 19.111 99 75 148 0 1999270384 39941088 23849952
20:45:37 1873 8192000000 10933699744 11350220800 1953173520 19.252 100 67 134 2 2016131072 40747808 22209744
20:45:47 13032 8192000000 10936373056 11352350720 1956855776 19.281 100 65 129 0 2018230640 41163248 20211616
20:46:07 2898 8192000000 10960536416 11373932544 1968898064 19.377 100 76 152 1 2039196272 46837248 23460960
20:46:16 2491 8192000000 10968461952 11378769920 1971236256 19.395 100 85 168 0 2046539440 49486496 25816688
20:46:26 1740 8192000000 10957429072 11360919552 1950278368 19.229 99 93 186 2 2030307616 51235376 28793872
20:46:36 2550 8192000000 10938752240 11349102592 1949066960 19.219 100 85 170 5 2024101344 47942144 27092240
20:46:45 3741 8192000000 10952745024 11366117376 1962064512 19.322 100 80 161 1 2036717856 48848304 25805040
20:46:57 5754 8192000000 10953899584 11371757568 1964581488 19.342 100 73 146 0 2038338848 49919696 23837664
20:47:10 2002 8192000000 10962599728 11373039616 1975196912 19.427 100 84 167 2 2050082912 48192672 26693328
20:47:19 3325 8192000000 10965831024 11373723648 1975038944 19.425 100 92 184 2 2051033504 47901728 28092832
20:47:33 1510 8192000000 10954250240 11355856896 1949849088 19.225 99 86 171 1 2025170832 48887424 26434320
20:47:43 2357 8192000000 10958320592 11365953536 1950808304 19.233 99 85 170 0 2024519824 47181872 26529648
20:47:52 1985 8192000000 10961191776 11363536896 1964620656 19.343 100 92 183 2 2041760384 48382544 28757184
20:48:01 4959 8192000000 10947251120 11371040768 1962633696 19.327 100 72 143 3 2033198656 48269984 22294976
20:48:16 7095 8192000000 10935534480 11360051200 1954817264 19.265 100 60 121 0 2021662064 47620464 19224336
20:48:30 9960 8192000000 10929349152 11359113216 1950447856 19.230 100 46 90 2 2012760560 47331072 14981632
20:48:51 5486 8192000000 10929285680 11358035968 1942192192 19.164 99 49 98 1 2008561984 49736128 16633664
20:49:05 8444 8192000000 10943460944 11367403520 1956580544 19.279 100 44 88 1 2018371872 46887904 14903424
20:49:23 3831 8192000000 10962529856 11372290048 1965207744 19.347 100 78 156 0 2039605120 49422560 24974816
20:49:36 1343 8192000000 10961340288 11371880448 1959289248 19.300 100 82 164 3 2038541264 53499488 25752528
20:49:47 10814 8192000000 10935500288 11373473792 1957682832 19.288 100 50 100 1 2024427552 50589104 16155616
20:50:14 5701 8192000000 10942150912 11380936704 1962318768 19.324 100 45 90 1 2029057744 51654656 15084320
20:50:29 16354 8192000000 10937317040 11378081792 1965663472 19.351 100 30 60 2 2021607648 45323248 10620928
20:50:51 13432 8192000000 10927879408 11363381248 1946556000 19.199 99 29 58 0 1997093296 39697680 10839616
20:51:19 41396 8192000000 10926709328 11357700096 1936304336 19.117 99 39 78 0 1987573872 38868736 12400800
20:52:09 18428 8192000000 10924300640 11368906752 1954328144 19.261 100 34 68 0 2010657616 44658752 11670720
20:52:50 14391 8192000000 10917953664 11366801408 1946585008 19.199 100 30 60 1 2001538528 44815776 10137744
20:53:16 12434 8192000000 10929269584 11375357952 1952333584 19.245 100 33 67 1 2015096976 51836656 10926736
20:53:46 21234 8192000000 10904781184 11360178176 1924596128 19.024 99 21 42 1 1983321968 50959488 7766352
20:54:24 25268 8192000000 10911962256 11372855296 1939351664 19.142 100 22 44 1 1998662448 51550224 7760560
20:54:56 21498 8192000000 10904545472 11348500480 1934471488 19.103 100 23 46 2 1989076560 46974928 7630144
20:55:40 17093 8192000000 10904804448 11361316864 1929522576 19.063 100 17 34 1 1992583840 56517936 6543328
20:56:14 28391 8192000000 10899495712 11353964544 1905685216 18.872 99 12 24 2 1958463136 48022784 4755136
20:57:23 57188 8192000000 10904999120 11341402112 1951945632 19.242 100 18 35 0 1968002432 11353200 4703600
20:58:28 26880 8192000000 10906591648 11351445504 1968461280 19.373 100 40 78 2 1988999632 9621424 10916928
20:59:06 53630 8192000000 10909781952 11363979264 1932676720 19.088 98 10 20 2 1951063408 15813168 2573520
21:00:17 149299 8192000000 10893297296 11353636864 1887645472 18.727 96 4 8 0 1901497776 13285360 566944
21:02:52 95808 8192000000 10907007120 11369406464 1969396512 19.381 100 11 22 0 1983075984 10784864 2894608
21:05:07 95108 8192000000 10920391008 11372290048 1969114896 19.378 99 31 60 3 1994616000 16923360 8577744
21:06:54 67600 8192000000 10921763808 11376791552 1991059408 19.552 100 54 109 0 2017925920 11520784 15345728
21:08:27 7121 8192000000 10976131952 11401519104 1999203600 19.616 100 85 170 0 2042749984 18300768 25245616
21:08:41 20423 8192000000 10940087648 11393363968 1999605344 19.620 100 49 98 0 2030219296 16587888 14026064
21:09:14 38913 8192000000 10913052336 11384119296 1975725632 19.431 99 19 38 1 1990748304 10010432 5012240
21:09:59 34654 8192000000 10914031424 11376738304 1954555456 19.263 98 16 32 1 1972334256 12469376 5309424
21:10:42 60132 8192000000 10923767712 11367653376 1943002352 19.171 98 25 51 2 1962429200 11938352 7488496
21:11:49 20349 8192000000 10894618944 11377106944 1977598672 19.446 100 40 80 0 2004023360 15123056 11301632
21:12:24 35319 8192000000 10887128416 11368853504 1955062928 19.267 99 2 4 0 1964701808 9245856 393024
21:13:05 9063 8192000000 10886722336 11358441472 1957126928 19.283 99 6 12 0 1965753520 7037664 1588928
21:13:21 28627 8192000000 10895242928 11370921984 1977294992 19.443 100 13 26 0 1989158368 8294160 3569216
21:13:55 34835 8192000000 10905950528 11368419328 1961266896 19.316 99 19 36 4 1974178064 7673072 5238096
21:14:37 40886 8192000000 10904358144 11376148480 1981986720 19.480 100 16 32 1 1997703376 11004288 4712368
21:15:24 30771 8192000000 10911250880 11381084160 1982592912 19.485 100 13 26 0 1994868016 8498256 3776848
21:17:23 87740 8192000000 10893403200 11377086464 1955191456 19.268 99 27 54 2 1979802608 17146160 7464992
21:18:57 40723 8192000000 10889768416 11368030208 1944533024 19.183 99 10 20 1 1960444240 13097408 2813808
21:19:57 36615 8192000000 10900567088 11369377792 1957185696 19.284 99 31 62 2 1981221728 14971536 9064496
21:20:57 85017 8192000000 10876283104 11371683840 1932857552 19.090 98 9 16 1 1950122368 14800560 2464256
21:22:36 35226 8192000000 10870345792 11328086016 1883316704 18.692 96 29 58 2 1900398800 9269024 7813072
21:23:24 35118 8192000000 10883821312 11350126592 1923421984 19.014 98 27 54 2 1940803504 9770560 7610960
21:24:21 53274 8192000000 10894878912 11349381120 1935501744 19.111 99 30 60 0 1951755232 7433488 8820000
21:25:23 26947 8192000000 10883323184 11343450112 1922773600 19.009 98 30 60 3 1940713920 10002576 7937744
21:25:56 26139 8192000000 10869663792 11332911104 1896903440 18.801 97 18 34 2 1910772736 8663616 5205680
21:26:29 68772 8192000000 10872327984 11349995520 1853474608 18.450 95 12 24 0 1870876464 14318976 3082880
21:27:46 56553 8192000000 10877815216 11340840960 1868978272 18.576 96 10 20 0 1891592640 20061424 2552944
21:28:49 109391 8192000000 10859730672 11327803392 1877906560 18.648 96 9 19 0 1895237664 15168304 2162800
21:30:45 69832 8192000000 10847249024 11327832064 1839078192 18.333 94 17 34 0 1859470032 15250496 5141344
21:32:28 22105 8192000000 10874499584 11325644800 1902491616 18.846 98 30 60 1 1919735968 9075184 8169168
21:33:25 60646 8192000000 10865901312 11325673472 1883776256 18.696 97 26 52 0 1905020240 13989440 7254544
21:34:43 131537 8192000000 10856275568 11315630080 1860870272 18.510 96 22 44 1 1874737856 7590016 6277568
21:37:05 42645 8192000000 10835333728 11286241280 1888119952 18.731 98 33 66 2 1907439312 9662464 9656896
21:37:54 20840 8192000000 10872047824 11310788608 1922678592 19.008 100 33 67 2 1941640576 10052992 8908992
21:38:29 26501 8192000000 10823734784 11301236736 1896998800 18.802 99 20 37 2 1913799312 9612144 7188368
21:39:01 33981 8192000000 10811304128 11290722304 1896178448 18.796 99 13 26 0 1910364192 10783760 3401984
21:39:41 88677 8192000000 10828800192 11298992128 1881301136 18.676 98 13 26 0 1892221872 7102432 3818304
21:41:30 83185 8192000000 10854117344 11331604480 1920645136 18.992 99 19 38 0 1940786592 15010736 5130720
21:43:35 77779 8192000000 10847458832 11318484992 1886837680 18.720 98 11 22 0 1903640032 13201776 3600576
21:45:01 41270 8192000000 10860865600 11336269824 1929184320 19.060 100 15 30 3 1941914512 8315232 4414960
21:45:52 55457 8192000000 10894030736 11354198016 1931997408 19.083 99 24 48 0 1949905008 11333136 6574464
21:47:04 70382 8192000000 10886345552 11371384832 1958604848 19.295 100 24 48 0 1978763008 12948800 7209360
21:48:22 59043 8192000000 10880304640 11356295168 1949783024 19.225 99 19 38 1 1969142400 13456208 5903168
21:49:28 21558 8192000000 10904205776 11350364160 1931583120 19.080 98 33 66 4 1949684208 7183120 10917968
21:50:00 34934 8192000000 10883485616 11349872640 1924050160 19.019 98 34 68 1 1946827456 13053776 9723520
21:50:41 90097 8192000000 10895339056 11353776128 1922001920 19.003 98 28 56 1 1939159776 9072464 8085392
21:52:18 23521 8192000000 10902392832 11368194048 1970296672 19.388 100 36 72 4 1990713232 10201936 10214624
21:53:03 95079 8192000000 10906262240 11366518784 1897507392 18.806 96 26 52 0 1913254128 9017280 6729456
21:54:44 15022 8192000000 10902141360 11364687872 1953986320 19.258 99 35 68 1 1972017600 8423584 9607696
21:55:12 19126 8192000000 10911457840 11378880512 1975627088 19.430 100 32 64 0 1994953568 10364336 8962144
21:55:39 111272 8192000000 10919455264 11390021632 1938965344 19.138 98 12 24 1 1953930112 11835936 3128832
21:57:37 132101 8192000000 10892923088 11376476160 1963955216 19.337 99 16 32 0 1977417072 8783936 4677920
22:00:29 41054 8192000000 10926367424 11399749632 1998053968 19.607 100 24 48 0 2015605392 10447248 7104176
22:01:21 81222 8192000000 10899449888 11390615552 1945378304 19.190 97 10 20 0 1956188096 8081680 2728112
22:03:08 74742 8192000000 10911140672 11394699264 1933059152 19.091 97 11 22 0 1947567936 11611104 2897680
22:04:30 69143 8192000000 10929255360 11381223424 1919247712 18.981 96 14 28 0 1934419648 11107856 4064080
22:05:49 70048 8192000000 10871760896 11347628032 1869577200 18.581 94 29 58 1 1891036592 12946384 8513008
22:07:07 47040 8192000000 10886402832 11368783872 1915925296 18.954 97 21 42 2 1935428288 13544880 5958112
22:08:06 49544 8192000000 10888884672 11363778560 1938444576 19.134 99 6 12 0 1953753296 13591440 1717280
22:09:05 95865 8192000000 10868619008 11346808832 1837790768 18.323 93 13 26 1 1857347616 16154544 3402304
22:10:47 78833 8192000000 10863390096 11345862656 1853149008 18.448 96 15 30 2 1874077184 16862304 4065872
22:13:14 56221 8192000000 10855100608 11326746624 1862438288 18.523 96 21 42 0 1880568896 12671504 5459104
22:14:18 32620 8192000000 10864636080 11327873024 1897966448 18.810 98 17 34 1 1914412560 11429072 5017040
22:15:02 109501 8192000000 10854105936 11331436544 1874742720 18.623 97 10 20 1 1893150928 15717152 2691056
22:16:58 91267 8192000000 10842759648 11303620608 1856724992 18.477 96 18 36 1 1868541664 6680480 5136192
22:18:42 57712 8192000000 10846663232 11321643008 1894987648 18.786 98 20 41 0 1908579024 7880768 5710608
22:19:46 32879 8192000000 10859312224 11323940864 1911949648 18.922 99 26 52 2 1934120528 14994336 7176544
22:20:26 47568 8192000000 10852407040 11330859008 1912403824 18.926 99 21 40 3 1930788544 12825680 5559040
22:21:20 71686 8192000000 10825971200 11311038464 1855827072 18.469 96 10 20 0 1869678256 11091728 2759456
22:22:58 85242 8192000000 10840695280 11321745408 1878692352 18.655 98 15 30 0 1900863376 17658480 4512544
22:24:29 81549 8192000000 10826009792 11318009856 1908427744 18.894 99 8 16 0 1920179968 9058192 2694032
22:25:57 57329 8192000000 10843420848 11325067264 1875710912 18.630 97 15 30 0 1888645056 8411696 4522448
22:27:02 24029 8192000000 9026026512 9234444288 200670288 2.391 11 3 6 0 205329408 3845968 813152

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 08-03-2021 22:28:59 to 08-03-2021 22:29:31.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-03-2021 22:29:32 to 08-03-2021 22:29:34.

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          248379
MON$OLDEST_ACTIVE               248380
MON$OLDEST_SNAPSHOT             248380
MON$NEXT_TRANSACTION            248380
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                       2042400
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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.03.21 22:29:35. 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-03-08 22:29:37 No severe PSQL-related problems occured
08.03.21 22:29:38. End of report.