Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.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 17210388 kB
MemAvailable 31410520 kB
Buffers 0 kB
Cached 14437676 kB
SwapCached 4820 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-28 22:27:06
DTS_END                         2020-12-28 22:27:06.8620
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/46780
TRN_ID                          230020
ATT_ID                          593
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: 9412.06 26033 1129447
customer order: creation 160.89 369 19307
customer order: refuse 13.65 362 1638
order to supplier: creation 42.98 1350 5157
order to supplier: removal 3.37 111336 404
invoice (draft): creation 43.48 3318 5218
invoice (draft): removal 55.90 746 6708
invoice accept: apply 40.49 18586 4859
invoice accept: cancel 50.63 772 6076
customer reserve: creation 3715.87 184 445904
customer reserve: removal 4992.18 58 599061
realization accept: apply 77.63 177 9316
realization accept: cancel 93.44 113 11213
payment from customer: creation 55.28 118 6634
payment from customer: removal 5.09 80 611
payment to supplier: creation 46.71 137 5605
payment to supplier: removal 3.02 108 362
service: total inventory turnovers 4.69 1049 563
service: total monetary turnovers 5.90 34 708
service: aggregate perf. data 0.83 18282 99
service: refresh index statistics 0.03 363482 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 28-12-2020 22:27:59 to 28-12-2020 22:28:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3717
TEST_TIME 2 4088
TEST_TIME 3 5105
TEST_TIME 4 4811
TEST_TIME 5 4707
TEST_TIME 6 4643
TEST_TIME 7 5107
TEST_TIME 8 6370
TEST_TIME 9 6999
TEST_TIME 10 7107
TEST_TIME 11 7232
TEST_TIME 12 7217
TEST_TIME 13 7095
TEST_TIME 14 7061
TEST_TIME 15 7090
TEST_TIME 16 7211
TEST_TIME 17 7215
TEST_TIME 18 7289
TEST_TIME 19 7960
TEST_TIME 20 8163
TEST_TIME 21 8208
TEST_TIME 22 8565
TEST_TIME 23 9147
TEST_TIME 24 9396
TEST_TIME 25 9431
TEST_TIME 26 9486
TEST_TIME 27 9769
TEST_TIME 28 9959
TEST_TIME 29 10524
TEST_TIME 30 11310
TEST_TIME 31 11208
TEST_TIME 32 11143
TEST_TIME 33 11313
TEST_TIME 34 11089
TEST_TIME 35 10811
TEST_TIME 36 10703
TEST_TIME 37 10593
TEST_TIME 38 10509
TEST_TIME 39 10476
TEST_TIME 40 10499
TEST_TIME 41 10330
TEST_TIME 42 10297
TEST_TIME 43 10155
TEST_TIME 44 10097
TEST_TIME 45 10097
TEST_TIME 46 10080
TEST_TIME 47 9994
TEST_TIME 48 9826
TEST_TIME 49 9710
TEST_TIME 50 9719
TEST_TIME 51 9705
TEST_TIME 52 9700
TEST_TIME 53 9680
TEST_TIME 54 9587
TEST_TIME 55 9558
TEST_TIME 56 9439
TEST_TIME 57 9536
TEST_TIME 58 9514
TEST_TIME 59 9572
TEST_TIME 60 9503
TEST_TIME 61 9577
TEST_TIME 62 9599
TEST_TIME 63 9614
TEST_TIME 64 9663
TEST_TIME 65 9665
TEST_TIME 66 9742
TEST_TIME 67 9830
TEST_TIME 68 9763
TEST_TIME 69 9780
TEST_TIME 70 9855
TEST_TIME 71 9976
TEST_TIME 72 9905
TEST_TIME 73 9825
TEST_TIME 74 9739
TEST_TIME 75 9707
TEST_TIME 76 9739
TEST_TIME 77 9684
TEST_TIME 78 9645
TEST_TIME 79 9617
TEST_TIME 80 9625
TEST_TIME 81 9635
TEST_TIME 82 9592
TEST_TIME 83 9591
TEST_TIME 84 9500
TEST_TIME 85 9488
TEST_TIME 86 9515
TEST_TIME 87 9503
TEST_TIME 88 9498
TEST_TIME 89 9527
TEST_TIME 90 9542
TEST_TIME 91 9548
TEST_TIME 92 9582
TEST_TIME 93 9558
TEST_TIME 94 9672
TEST_TIME 95 9743
TEST_TIME 96 9723
TEST_TIME 97 9724
TEST_TIME 98 9726
TEST_TIME 99 9750
TEST_TIME 100 9680
TEST_TIME 101 9637
TEST_TIME 102 9619
TEST_TIME 103 9588
TEST_TIME 104 9557
TEST_TIME 105 9561
TEST_TIME 106 9553
TEST_TIME 107 9505
TEST_TIME 108 9513
TEST_TIME 109 9453
TEST_TIME 110 9439
TEST_TIME 111 9435
TEST_TIME 112 9393
TEST_TIME 113 9370
TEST_TIME 114 9382
TEST_TIME 115 9378
TEST_TIME 116 9386
TEST_TIME 117 9393
TEST_TIME 118 9406
TEST_TIME 119 9489
TEST_TIME 120 9415

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-12-2020 22:28:03 to 28-12-2020 22:28:06.

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 1544459 1544459 0 0.00 0 16243 6 0 0
doc_list_biud 1544458 1544458 0 0.00 0 39163 28 0 0
sp_add_invoice_to_stock 4963 4859 104 2.09 38 239813 18587 0 104
sp_cancel_adding_invoice 6076 6076 0 0.00 5 62725 773 0 0
sp_cancel_client_order 1638 1638 0 0.00 4 12267 363 0 0
sp_cancel_customer_reserve 599061 599061 0 0.00 1 22271 58 0 0
sp_cancel_pay_from_customer 611 611 0 0.00 2 6051 80 0 0
sp_cancel_pay_to_supplier 362 362 0 0.00 3 9060 108 0 0
sp_cancel_supplier_invoice 6722 6708 14 0.20 2 39189 747 0 14
sp_cancel_supplier_order 404 404 0 0.00 8 957635 111337 0 0
sp_cancel_write_off 11213 11213 0 0.00 1 21482 114 0 0
sp_client_order 19307 19307 0 0.00 4 19615 369 0 0
sp_customer_reserve 445904 445904 0 0.00 0 43906 185 0 0
sp_fill_shopping_cart 29669 29669 0 0.00 1 18018 41 0 0
sp_fill_shopping_cart_clo_res 445898 445898 0 0.00 0 17840 13 0 0
sp_get_clo_for_invoice 4853 4853 0 0.00 0 19653 294 0 0
sp_kill_cost_storno 18262 18262 0 0.00 0 11442 59 0 0
sp_kill_qstorno_ret_qs2qd 1216447 1216447 0 0.00 0 39157 31 0 0
sp_kill_qty_storno 639269 639269 0 0.00 0 39160 68 0 0
sp_lock_selected_doc 19573 19573 0 0.00 0 6086 4 0 0
sp_make_cost_storno 26408 26408 0 0.00 0 16238 58 0 0
sp_multiply_rows_for_pdistr 26408 26408 0 0.00 0 6686 31 0 0
sp_multiply_rows_for_qdistr 19307 19307 0 0.00 0 11498 146 0 0
sp_pay_from_customer 6634 6634 0 0.00 4 9603 119 0 0
sp_pay_to_supplier 5605 5605 0 0.00 5 11184 138 0 0
sp_payment_common 12239 12239 0 0.00 1 10530 30 0 0
sp_qd_handle_on_cancel_clo 1638 1638 0 0.00 0 12260 337 0 0
sp_qd_handle_on_invoice_upd_sts 10929 10929 0 0.00 0 19578 364 0 0
sp_qd_handle_on_reserve_upd_sts 9316 9316 0 0.00 0 14166 48 0 0
sp_reserve_write_off 9316 9316 0 0.00 6 14185 178 0 0
sp_supplier_invoice 5218 5218 0 0.00 6 79577 3318 0 0
sp_supplier_order 5157 5157 0 0.00 4 35524 1351 0 0
srv_aggregate_perf_data 99 99 0 0.00 2979 142510 18282 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1059 120591 33151 0 0
srv_find_qd_qs_mism 1085267 1085267 0 0.00 0 16131 5 0 0
srv_make_invnt_saldo 563 563 0 0.00 48 57663 1049 0 0
srv_make_money_saldo 708 708 0 0.00 1 2336 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 191952 565683 363483 0 0
t$perf-abend:sp_add_invoice_to_stock 104 104 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4859 4859 0 0.00 0 18406 182 0 0
t$perf-norm:sp_cancel_adding_invoice 375 375 0 0.00 0 4313 105 0 0
t$perf-norm:sp_cancel_client_order 1638 1638 0 0.00 0 3235 18 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 1941 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 611 611 0 0.00 0 2072 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 362 362 0 0.00 0 3813 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 4688 34 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 25323 1791 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 1499 6 0 0
t$perf-norm:sp_client_order 19307 19307 0 0.00 0 10340 18 0 0
t$perf-norm:sp_customer_reserve 960 960 0 0.00 0 1888 7 0 0
t$perf-norm:sp_pay_from_customer 6634 6634 0 0.00 0 6409 9 0 0
t$perf-norm:sp_pay_to_supplier 5605 5605 0 0.00 0 11786 10 0 0
t$perf-norm:sp_reserve_write_off 9316 9316 0 0.00 0 5909 13 0 0
t$perf-norm:sp_supplier_invoice 5218 5218 0 0.00 0 11572 26 0 0
t$perf-norm:sp_supplier_order 5157 5157 0 0.00 0 4771 16 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 478 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 134 2 0 0
t$perf-norm:srv_make_invnt_saldo 563 563 0 0.00 0 4308 33 0 0
t$perf-norm:srv_make_money_saldo 708 708 0 0.00 0 2334 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 387 99 0 0
v_add_invoice_to_stock 9914 9706 208 2.09 0 4001 16 0 208
v_all_customers 35968 35968 0 0.00 0 16 1 0 0
v_all_suppliers 29166 29166 0 0.00 0 27 1 0 0
v_all_wares 38612 38612 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 750 750 0 0.00 0 2236 10 0 0
v_cancel_client_order 3276 3276 0 0.00 0 2989 6 0 0
v_cancel_customer_prepayment 1222 1222 0 0.00 0 2865 6 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 888 3 0 0
v_cancel_payment_to_supplier 724 724 0 0.00 0 2305 14 0 0
v_cancel_supplier_invoice 800 772 28 3.50 0 4345 22 0 28
v_cancel_supplier_order 808 808 0 0.00 0 309 4 0 0
v_cancel_write_off 2012 2012 0 0.00 0 2320 15 0 0
v_max_id_clo_ord 5149 5149 0 0.00 0 3985 2 0 0
v_max_id_clo_res 960 960 0 0.00 0 7316 18 0 0
v_max_id_ord_sup 5213 5213 0 0.00 0 4688 6 0 0
v_max_non_paid_invoice 1384 1384 0 0.00 0 3154 4 0 0
v_max_non_paid_realizn 3105 3105 0 0.00 0 4181 5 0 0
v_min_id_clo_ord 5149 5149 0 0.00 0 4733 6 0 0
v_min_id_clo_res 960 960 0 0.00 0 8045 19 0 0
v_min_id_ord_sup 5213 5213 0 0.00 0 18009 13 0 0
v_min_non_paid_invoice 5605 5605 0 0.00 0 10526 20 0 0
v_min_non_paid_realizn 6634 6634 0 0.00 0 8855 21 0 0
v_our_firm 9702 9702 0 0.00 0 15 1 0 0
v_reserve_write_off 18632 18632 0 0.00 0 3759 6 0 0
x_lock_depdocs_on_canc_invoice 12398 12398 0 0.00 0 16099 131 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 7101 421 0 0
x_make_qstorno_1000_1200 5157 5157 0 0.00 1 35520 1263 0 0
x_make_qstorno_1200_2000 5218 5218 0 0.00 3 79501 3176 0 0
x_make_qstorno_2100_3300 445904 445904 0 0.00 0 43905 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-12-2020 22:28:07 to 28-12-2020 22:28:11.

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 34758 8192000000 10311218192 10626633728 1101406768 11.851 83 69 138 0 1127157008 3232112 22518128
19:58:01 35459 8192000000 10377397968 10701012992 1425716608 14.823 100 87 173 0 1459493920 5897888 27879424
19:58:48 14735 8192000000 10394793392 10720210944 1453985040 15.073 100 88 176 0 1489871056 7465600 28420416
19:59:15 18795 8192000000 10414699232 10745958400 1468638096 15.202 100 85 170 0 1504909408 8473248 27798064
19:59:42 10489 8192000000 10425391760 10755526656 1482843408 15.326 100 89 178 1 1519910848 8598944 28468496
20:00:03 22482 8192000000 10437427280 10768736256 1491944400 15.406 100 89 178 1 1529925728 9507680 28473648
20:00:37 20609 8192000000 10457064064 10795843584 1513087376 15.590 100 88 176 0 1550206688 9479616 27639696
20:01:05 15895 8192000000 10460525840 10801893376 1521229488 15.661 100 83 166 1 1557540144 9935968 26374688
20:01:31 14700 8192000000 10491403920 10832674816 1537093952 15.798 100 80 160 1 1572088688 9936224 25058512
20:02:05 9176 8192000000 10507321168 10856960000 1571484048 16.095 100 82 162 1 1606755328 10436240 24835040
20:02:22 13270 8192000000 10544984832 10901532672 1593457568 16.283 100 68 136 0 1623942816 10057072 20428176
20:02:45 13184 8192000000 10567009072 10924875776 1625401008 16.556 100 86 172 1 1661957840 10867024 25689808
20:03:07 13006 8192000000 10592543888 10957602816 1650926512 16.772 100 85 172 0 1688146784 12035024 25185248
20:03:27 12415 8192000000 10615104080 10980139008 1675298032 16.978 100 79 158 1 1709488704 11499408 22691264
20:03:47 8710 8192000000 10624675248 10996981760 1687144320 17.077 100 72 144 0 1720002784 12073184 20785280
20:04:06 9041 8192000000 10655832624 11024912384 1707168128 17.245 100 80 160 0 1743141008 12800896 23171984
20:04:22 5740 8192000000 10661543664 11040141312 1725317232 17.397 100 80 159 1 1761426176 12888848 23220096
20:04:35 4896 8192000000 10675247280 11050356736 1735712832 17.483 100 82 159 2 1771918224 13099712 23105680
20:04:49 6241 8192000000 10683490016 11062628352 1747839904 17.584 100 82 164 2 1784928704 13651744 23437056
20:05:03 4077 8192000000 10696734480 11068870656 1753041952 17.627 100 84 167 1 1791735264 14869120 23824192
20:05:14 4052 8192000000 10697658016 11079147520 1762179200 17.702 100 84 166 2 1799741856 14365840 23196816
20:05:25 3940 8192000000 10727711440 11101945856 1777547008 17.829 100 85 168 1 1813985520 12710864 23727648
20:05:35 3955 8192000000 10721830208 11101515776 1787035456 17.907 100 89 176 1 1825503328 13166464 25301408
20:05:46 4559 8192000000 10725437040 11111698432 1788741248 17.921 100 85 170 1 1826526256 13799280 23985728
20:05:58 3190 8192000000 10741427296 11120402432 1798977888 18.006 100 88 178 3 1836444272 12885520 24580864
20:06:08 3101 8192000000 10739963520 11124293632 1802941952 18.038 100 84 168 0 1840476512 13789008 23745552
20:06:18 3994 8192000000 10751742960 11133759488 1806328912 18.066 100 84 165 1 1842815920 13368608 23118400
20:06:35 6591 8192000000 10745155920 11134435328 1809482576 18.092 100 76 149 1 1842392640 12460464 20449600
20:06:48 2303 8192000000 10769678800 11153424384 1827489280 18.239 100 92 185 0 1866666592 13428768 25748544
20:06:57 1970 8192000000 10777036304 11159437312 1830291408 18.262 100 89 178 0 1870305392 14050224 25963760
20:07:06 2565 8192000000 10773677808 11160158208 1833477504 18.288 100 85 171 0 1870238400 13334304 23426592
20:07:15 2353 8192000000 10787801280 11171295232 1840873648 18.348 100 95 188 0 1881462080 14061040 26527392
20:07:24 2406 8192000000 10783989584 11172286464 1845325056 18.384 100 90 179 0 1883801120 12799008 25677056
20:07:33 2006 8192000000 10801229568 11185557504 1854152032 18.456 100 85 170 0 1890424656 11308608 24964016
20:07:41 1628 8192000000 10800433088 11187834880 1856641744 18.476 100 95 190 1 1896838864 12884896 27312224
20:07:49 1670 8192000000 10801748224 11188678656 1857907264 18.486 100 91 184 2 1898131552 13952432 26271856
20:07:58 1607 8192000000 10803485824 11191787520 1858212704 18.489 100 97 196 2 1898474192 12532080 27729408
20:08:06 1731 8192000000 10808268208 11194904576 1862830208 18.526 100 91 182 3 1901045008 12655920 25558880
20:08:14 1481 8192000000 10805307008 11193974784 1862542080 18.524 100 92 184 0 1899731936 11552848 25637008
20:08:22 1389 8192000000 10805152032 11196567552 1863850832 18.534 100 90 180 1 1901916096 12264256 25801008
20:08:32 1873 8192000000 10809556992 11201097728 1866004896 18.552 100 89 179 1 1903933952 12955824 24973232
20:08:42 13008 8192000000 10812240016 11201347584 1867196704 18.562 100 85 173 1 1903994640 12920080 23877856
20:09:01 24220 8192000000 10788746320 11204534272 1867588320 18.565 100 54 108 1 1899002096 16574528 14839248
20:09:32 10501 8192000000 10790489952 11206701056 1871472384 18.596 100 40 80 2 1891285168 8975776 10837008
20:09:53 8880 8192000000 10783810848 11208884224 1870439856 18.588 100 25 49 1 1883943248 6332160 7171232
20:10:10 5559 8192000000 10781653472 11210317824 1876775776 18.639 100 37 75 0 1893513264 6168176 10569312
20:10:28 9372 8192000000 10780625232 11211735040 1878660320 18.654 100 24 48 2 1892952448 5871376 8420752
20:10:49 6132 8192000000 10807219072 11221872640 1880966064 18.673 100 23 46 0 1893043120 5530064 6546992
20:11:02 6477 8192000000 10795083248 11222339584 1883172352 18.691 100 33 66 0 1900111008 7752176 9186480
20:11:18 16272 8192000000 10791739312 11224162304 1882493808 18.685 100 14 28 1 1892361872 5495056 4373008
20:11:42 9930 8192000000 10786663856 11223871488 1885460480 18.709 100 13 26 1 1894946224 6023200 3462544
20:11:58 10018 8192000000 10796639344 11229097984 1885914832 18.713 100 15 30 0 1895216624 5368256 3933536
20:12:19 12232 8192000000 10789488048 11226988544 1886810720 18.720 100 18 36 0 1897602096 5818368 4973008
20:12:41 16632 8192000000 10817326656 11226677248 1887433232 18.725 100 21 42 1 1899728736 6666576 5628928
20:13:07 47943 8192000000 10805810416 11238060032 1887912384 18.729 100 24 48 2 1900055200 5273184 6869632
20:14:08 20701 8192000000 10800433136 11242110976 1890999568 18.754 100 24 48 1 1904654768 6792256 6862944
20:14:35 7672 8192000000 10820366896 11248697344 1893548368 18.774 100 24 48 0 1906838944 6493680 6796896
20:14:49 5235 8192000000 10812395120 11243094016 1890447024 18.749 100 29 57 1 1905654496 7406864 7800608
20:15:01 4484 8192000000 10813855056 11243786240 1892970448 18.770 100 26 53 2 1907402400 6968704 7463248
20:15:12 7920 8192000000 10824406320 11252371456 1897261456 18.804 100 29 59 0 1912354736 7023696 8069584
20:15:26 8115 8192000000 10824949328 11255726080 1898978768 18.818 100 31 62 3 1914474160 6934288 8561104
20:15:40 6532 8192000000 10814140000 11253780480 1899994592 18.826 100 23 46 0 1913211888 6114288 7103008
20:15:54 8585 8192000000 10823579120 11255193600 1882081584 18.682 99 12 24 1 1890673024 5411792 3179648
20:16:08 8561 8192000000 10819929200 11252744192 1899870288 18.825 100 21 41 1 1911444256 5871536 5702432
20:16:23 11225 8192000000 10815381360 11250118656 1881782256 18.679 99 19 38 1 1892765440 5986816 4996368
20:16:41 10410 8192000000 10799666576 11231977472 1859187008 18.497 98 15 30 0 1872581296 9222528 4171760
20:17:00 9668 8192000000 10804804272 11237490688 1870327104 18.587 99 21 42 2 1882459808 6067200 6065504
20:17:16 11517 8192000000 10797416128 11231600640 1868910896 18.575 99 22 44 1 1881314896 6457360 5946640
20:17:35 6802 8192000000 10779758448 11214831616 1864840608 18.543 100 22 44 0 1877132832 5942448 6349776
20:17:48 11376 8192000000 10763461808 11198431232 1814342992 18.131 97 16 32 0 1823920528 5151680 4425856
20:18:09 77299 8192000000 10736514944 11161165824 1732065008 17.453 93 31 62 0 1746025920 4709680 9251232
20:19:34 7975 8192000000 10763164992 11187974144 1828280800 18.245 99 25 50 2 1844832464 9559648 6992016
20:19:50 8403 8192000000 10725986048 11139469312 1692525968 17.122 92 27 54 0 1705880000 5526544 7827488
20:20:05 8693 8192000000 10689540720 11094786048 1664672176 16.888 92 34 68 1 1679241280 5186016 9383088
20:20:21 7064 8192000000 10682884592 11100794880 1745482512 17.564 98 22 44 1 1757343136 5583152 6277472
20:20:34 5108 8192000000 10700799760 11115098112 1780887472 17.857 100 30 60 1 1796110512 6301760 8921280
20:20:46 5004 8192000000 10683395216 11100835840 1743243264 17.546 98 31 62 2 1762869728 10782384 8844080
20:20:59 9307 8192000000 10707048032 11118116864 1747471072 17.581 97 20 40 3 1758875232 5781648 5622512
20:21:16 7076 8192000000 10710945616 11132149760 1795919936 17.980 100 21 40 4 1807333888 5653104 5760848
20:21:30 10881 8192000000 10713132448 11127574528 1762234048 17.703 97 23 46 1 1774567024 5439408 6893568
20:21:47 11825 8192000000 10731337520 11152932864 1813982320 18.128 100 27 54 1 1828935408 7209952 7743136
20:22:08 16283 8192000000 10708325488 11122814976 1708381344 17.255 94 24 46 3 1719964400 4504832 7078224
20:22:31 8556 8192000000 10715298304 11130957824 1789802976 17.930 99 30 60 1 1804664912 5338960 9522976
20:22:48 47141 8192000000 10735810384 11163754496 1824052560 18.211 100 18 36 0 1835038080 5089792 5895728
20:23:51 23279 8192000000 10743739600 11174588416 1814294624 18.131 99 30 58 0 1829795488 6975776 8525088
20:24:22 7364 8192000000 10753434976 11178233856 1833304144 18.286 100 16 31 0 1844071776 5602096 5165536
20:24:37 4581 8192000000 10763592224 11178283008 1835522704 18.304 100 26 52 2 1849730848 5963792 8244352
20:24:50 7471 8192000000 10761855952 11182145536 1839485744 18.337 100 30 61 1 1854366368 6216688 8663936
20:25:03 7430 8192000000 10762998496 11185684480 1840684000 18.346 100 21 42 0 1851970496 5124144 6162352
20:25:19 5840 8192000000 10750482640 11179978752 1843031824 18.365 100 28 56 1 1857248656 6058032 8158800
20:25:33 14679 8192000000 10768293888 11188224000 1848657136 18.411 100 20 40 2 1859845472 5722400 5465936
20:25:54 8605 8192000000 10763848496 11193008128 1847869376 18.405 100 21 41 5 1859150032 5410464 5870192
20:26:10 9025 8192000000 10769352592 11199090688 1852589920 18.443 100 16 32 0 1862730832 5354832 4786080
20:26:25 7704 8192000000 10770750768 11197239296 1854833552 18.461 100 22 43 0 1866907520 5815280 6258688
20:26:39 14669 8192000000 10774824224 11203112960 1855379472 18.466 100 15 31 0 1864491408 4908464 4203472
20:27:03 32122 8192000000 10807872656 11225096192 1875203616 18.626 100 25 49 0 1887605872 5701728 6700528
20:28:00 27483 8192000000 10835626672 11253112832 1899432960 18.822 100 52 102 1 1922132352 8277696 14421696
20:28:40 17013 8192000000 10850293200 11260616704 1910225312 18.908 100 60 120 0 1936149328 9667872 16256144
20:29:08 18548 8192000000 10843412256 11262545920 1914886864 18.946 100 51 100 1 1939279808 10501216 13891728
20:29:41 65180 8192000000 10842456208 11279962112 1917804480 18.969 100 40 80 0 1940056720 10979968 11272272
20:30:55 46500 8192000000 10857730352 11293503488 1928238336 19.053 100 31 62 2 1947839888 10328928 9272624
20:32:28 49854 8192000000 10876139760 11310813184 1945454720 19.190 100 40 80 5 1970122384 13245312 11422352
20:33:25 10957 8192000000 10890256096 11317936128 1949913152 19.226 100 41 82 2 1976289312 14201680 12174480
20:33:52 12982 8192000000 10897777040 11324248064 1958137200 19.291 100 53 106 3 1991746256 17091360 16517696
20:34:14 31133 8192000000 10901815616 11331149824 1957744880 19.288 100 44 85 4 1987137168 16125552 13266736
20:34:52 2906 8192000000 10917981504 11334594560 1965572080 19.350 100 64 130 2 2002368384 17779600 19016704
20:35:02 4554 8192000000 10921327232 11345305600 1971624384 19.398 100 71 142 2 2012465392 19860480 20980528
20:35:16 2943 8192000000 10931141712 11349655552 1973416784 19.413 100 78 155 0 2018861408 21853360 23591264
20:35:26 2636 8192000000 10931023552 11347447808 1975086576 19.426 100 76 152 1 2022414800 23955984 23372240
20:35:37 4928 8192000000 10926449456 11349250048 1973785264 19.415 100 64 129 1 2014135840 20992864 19357712
20:35:49 3155 8192000000 10936529376 11348844544 1974619312 19.422 100 76 152 3 2016721072 19912400 22189360
20:36:00 13975 8192000000 10935702080 11354136576 1977195904 19.442 100 71 142 1 2019953776 22329792 20428080
20:36:21 13335 8192000000 10938568496 11360694272 1980269696 19.467 100 64 125 1 2017162688 18150880 18742112
20:36:42 5931 8192000000 10929330384 11356721152 1980785888 19.471 100 57 113 2 2015844400 18546176 16512336
20:36:57 6489 8192000000 10918909664 11340746752 1961740336 19.320 99 62 120 0 1997563216 18199232 17623648
20:37:14 11170 8192000000 10926844560 11361783808 1979501728 19.461 100 63 127 3 2017873136 19539344 18832064
20:37:32 5223 8192000000 10949779456 11372556288 1988558144 19.532 100 68 136 1 2030656224 22040352 20057728
20:37:47 3732 8192000000 10955017184 11378950144 1992119056 19.561 100 69 133 1 2036149600 23928416 20102128
20:38:01 18133 8192000000 10942683536 11379421184 1992816528 19.566 100 54 108 0 2030922464 22021328 16084608
20:38:26 5775 8192000000 10945114816 11379720192 1997934208 19.606 100 54 106 0 2035545840 22317200 15294432
20:38:42 4818 8192000000 10957621904 11383554048 2003823440 19.653 100 69 138 1 2047670800 23207024 20640336
20:38:54 5842 8192000000 10958509808 11379105792 1998046880 19.607 100 72 143 0 2041930064 22621536 21261648
20:39:08 9255 8192000000 10958138768 11387994112 2003231792 19.648 100 54 108 0 2042997184 23719264 16046128
20:39:30 9337 8192000000 10948752160 11380076544 1989435936 19.539 99 53 105 1 2029621568 24116832 16068800
20:39:54 5696 8192000000 10949874416 11377258496 1995841104 19.590 99 62 124 1 2038187088 23929312 18416672
20:40:11 9857 8192000000 10961097552 11391197184 1994213504 19.577 99 56 110 1 2035582928 24278912 17090512
20:40:28 8627 8192000000 10966447360 11401928704 2013397760 19.728 100 51 100 2 2053167568 24579472 15190336
20:40:44 5017 8192000000 10968726352 11396870144 1997302880 19.601 99 55 111 0 2038729040 25211232 16214928
20:41:04 8559 8192000000 10959260672 11398107136 1998247136 19.609 99 57 113 2 2040658880 24878624 17533120
20:41:20 1813 8192000000 10983289312 11405688832 2019650832 19.777 100 73 146 1 2065556768 24161680 21744256
20:41:29 3404 8192000000 10967824496 11397435392 2007642896 19.683 100 65 130 0 2053268224 26147360 19477968
20:41:40 4352 8192000000 10974622016 11394416640 2005778288 19.668 100 80 158 2 2056243248 26702192 23762768
20:41:55 3339 8192000000 10964842512 11387801600 1992657024 19.565 99 73 142 1 2046720400 32419744 21643632
20:42:07 4665 8192000000 10984482352 11404509184 2009425872 19.697 100 74 145 3 2065275120 34241232 21608016
20:42:19 3177 8192000000 10987251856 11400818688 2009441728 19.697 100 80 160 0 2065401536 31904144 24055664
20:42:30 4053 8192000000 10991466288 11402657792 2011517072 19.713 100 85 169 0 2069351504 32150944 25683488
20:42:40 3299 8192000000 10992602448 11406901248 2012431600 19.721 100 86 172 2 2070702880 31430896 26840384
20:42:51 5990 8192000000 10988587648 11411017728 2013311648 19.728 100 72 144 1 2067673984 32104080 22258256
20:43:04 8623 8192000000 10981367152 11402240000 1991619776 19.557 99 72 143 1 2049698736 36722192 21356768
20:43:25 2172 8192000000 10959917568 11378540544 1988338448 19.531 100 71 141 2 2039515216 29051952 22124816
20:43:35 2300 8192000000 10968389680 11384569856 1991012480 19.552 100 76 153 2 2048915984 34212320 23691184
20:43:45 4456 8192000000 10948607216 11362439168 1962238944 19.324 99 75 148 0 2014951520 30639408 22073168
20:43:56 3899 8192000000 10952118848 11367628800 1976174800 19.434 100 85 171 2 2035338240 32627200 26536240
20:44:08 3613 8192000000 10947269648 11355074560 1967044384 19.362 99 80 157 2 2025739296 34672976 24021936
20:44:19 6147 8192000000 10941804768 11355906048 1963029760 19.330 99 85 167 0 2024076896 35060048 25987088
20:44:34 6852 8192000000 10970736800 11389034496 1993905328 19.575 100 85 171 2 2057152656 37302432 25944896
20:44:48 7860 8192000000 10974042512 11386892288 1976462704 19.437 99 78 156 1 2041299984 40626272 24211008
20:45:03 2451 8192000000 10963855472 11380191232 1980262832 19.467 100 73 142 2 2044983968 42085168 22635968
20:45:14 1742 8192000000 10969264992 11380486144 1970330560 19.388 99 85 169 2 2039834192 43086512 26417120
20:45:23 5914 8192000000 10970588960 11389644800 1986337216 19.515 100 79 159 0 2056095664 45001680 24756768
20:45:38 10762 8192000000 10992693440 11404840960 1998043936 19.607 100 75 150 0 2068259088 46846464 23368688
20:45:55 2951 8192000000 10967182368 11376279552 1964816176 19.344 99 85 170 0 2040804048 48751664 27236208
20:46:08 1802 8192000000 10992990512 11406233600 1994128016 19.576 100 81 162 1 2070500496 49966640 26405840
20:46:17 1706 8192000000 10993426848 11410759680 1996826976 19.598 100 85 167 3 2073240960 49292464 27121520
20:46:27 2541 8192000000 10991415504 11410403328 1997890480 19.606 100 78 156 0 2071446080 48151472 25404128
20:46:41 2723 8192000000 10996579552 11407716352 2006687456 19.675 100 84 168 1 2072037424 38567568 26782400
20:46:51 3170 8192000000 10979188896 11387805696 1975105440 19.426 99 69 134 0 2035911984 39341104 21465440
20:47:01 2208 8192000000 10984071712 11395825664 1989656240 19.541 100 82 164 1 2059272336 42966176 26649920
20:47:11 1844 8192000000 10947783984 11353534464 1936473072 19.119 98 91 182 0 2010212720 44553744 29185904
20:47:19 1850 8192000000 10977372864 11385806848 1981775104 19.479 100 87 170 2 2052507264 43706208 27025952
20:47:28 3099 8192000000 10945459168 11359477760 1958938112 19.298 100 78 156 1 2028780528 45092016 24750400
20:47:39 2024 8192000000 10954065648 11365228544 1960890064 19.313 100 83 165 0 2031088816 43566976 26631776
20:47:50 2087 8192000000 10954497008 11359064064 1956080960 19.275 100 85 167 2 2030344368 47535584 26727824
20:48:01 3601 8192000000 10942677632 11350892544 1944372144 19.182 99 81 162 0 2017920032 46943328 26604560
20:48:11 1055 8192000000 10970342928 11377090560 1969707120 19.383 100 93 186 2 2049639792 50389648 29543024
20:48:19 2397 8192000000 10974319936 11380105216 1968536160 19.374 100 90 180 1 2049186384 52673776 27976448
20:48:29 2674 8192000000 10976489424 11389403136 1974777792 19.423 100 84 167 1 2058450784 56781392 26891600
20:48:41 5416 8192000000 10970766816 11385425920 1956805680 19.281 99 75 148 1 2037045440 56286752 23953008
20:48:56 3785 8192000000 10976391936 11386765312 1950244400 19.228 99 86 172 0 2034771248 55984736 28542112
20:49:07 3579 8192000000 10974022224 11389599744 1968097936 19.370 100 74 143 2 2050164096 57697920 24368240
20:49:18 9755 8192000000 10952990992 11390558208 1967621664 19.367 100 50 100 0 2039246672 54878976 16746032
20:49:38 8097 8192000000 10958936480 11394748416 1970592448 19.390 100 44 88 2 2043638480 57026576 16019456
20:49:55 6566 8192000000 10968233360 11399843840 1972339728 19.404 100 55 110 2 2049640304 58172848 19127728
20:50:09 3775 8192000000 10969414192 11398176768 1970171920 19.387 100 51 102 0 2047312544 59359552 17781072
20:50:23 10035 8192000000 10960750832 11396722688 1975560000 19.430 100 44 87 0 2047463040 56797520 15105520
20:50:41 13143 8192000000 10948552288 11400740864 1977770464 19.447 100 33 66 1 2042253248 53022032 11460752
20:51:04 15490 8192000000 10957888512 11397124096 1964271104 19.340 99 41 82 0 2026997696 49114336 13612256
20:51:42 12813 8192000000 10942938736 11392286720 1969730560 19.383 100 30 60 1 2027441024 47555808 10154656
20:52:10 15218 8192000000 10921317744 11359744000 1939638096 19.144 99 29 58 1 1997100976 47058336 10404544
20:52:34 8898 8192000000 10924662608 11371884544 1949362560 19.221 100 28 56 2 2007160912 48250864 9547488
20:52:51 17967 8192000000 10944793104 11395350528 1958943136 19.298 100 30 60 0 2019317808 50837552 9537120
20:53:55 14293 8192000000 10948561072 11403452416 1949854784 19.225 100 26 52 0 2019004624 60233504 8916336
20:54:18 22817 8192000000 10932185296 11396284416 1947777808 19.209 100 26 52 1 2015734080 58625728 9330544
20:54:55 23204 8192000000 10915678848 11377524736 1918861072 18.978 99 19 38 0 1982780464 56451568 7467824
20:55:50 42012 8192000000 10888624032 11356176384 1879009536 18.657 98 15 30 1 1939197456 54605104 5582816
20:56:59 42651 8192000000 10868600752 11333967872 1887655952 18.727 98 10 20 2 1917972208 27222160 3094096
20:57:49 65254 8192000000 10886430880 11332468736 1897759824 18.808 98 21 42 1 1924806928 20711424 6335680
20:59:04 46608 8192000000 10892973840 11349762048 1911604032 18.920 98 28 56 0 1941019152 21413376 8001744
21:00:13 75983 8192000000 10905904672 11362463744 1923301024 19.013 98 12 24 1 1939659552 13452512 2906016
21:01:47 83079 8192000000 10903969328 11352571904 1954955184 19.266 99 21 41 1 1970519072 10049888 5514000
21:03:18 26583 8192000000 10919429696 11374923776 1977819232 19.447 100 36 70 4 2001641296 13617936 10204128
21:03:55 13414 8192000000 10919964352 11381698560 1983615296 19.493 100 23 46 1 2004767904 14384928 6767680
21:04:17 87658 8192000000 10898502800 11372339200 1946407360 19.198 98 17 33 0 1965051328 14186656 4457312
21:07:48 65502 8192000000 10912268048 11374837760 1982638592 19.486 100 32 64 1 1999216416 7765056 8812768
21:09:08 55262 8192000000 10895778096 11372683264 1972582240 19.406 100 5 10 0 1982413856 8532176 1299440
21:10:10 42609 8192000000 10898835264 11371507712 1961999728 19.322 99 13 26 0 1974292032 8882832 3409472
21:11:00 65359 8192000000 10915225360 11379822592 1963398736 19.333 99 29 58 0 1980290896 8285472 8606688
21:12:17 90537 8192000000 10891495984 11379150848 1947312560 19.205 98 11 22 0 1960917456 10470672 3134224
21:14:16 67921 8192000000 10902760176 11373219840 1981412480 19.476 100 15 30 0 1993479024 7566208 4500336
21:15:35 66937 8192000000 10923803120 11391512576 1971704320 19.399 99 28 56 1 1988116000 7637152 8774528
21:16:48 72772 8192000000 10918738704 11401850880 1989881920 19.543 100 23 47 1 2011979824 14732016 7365888
21:18:45 37420 8192000000 10931813712 11393216512 1995728224 19.589 100 34 68 1 2014824784 9480496 9616064
21:19:32 57961 8192000000 10917599824 11393101824 1956041328 19.275 98 21 42 0 1975785760 12986320 6758112
21:20:51 91705 8192000000 10935021328 11395035136 1958855088 19.297 98 24 47 1 1975859024 9767136 7236800
21:22:31 58946 8192000000 10915288160 11388858368 1988539488 19.532 100 19 38 0 2006264752 12140208 5585056
21:23:49 42633 8192000000 10905525520 11397636096 1985152304 19.505 100 10 20 0 1998213040 9723152 3337584
21:24:52 54227 8192000000 10914779536 11403812864 1995316512 19.586 100 7 14 1 2008687680 11291488 2079680
21:25:53 55702 8192000000 10919563728 11407818752 2000527568 19.627 100 24 48 3 2019785520 11513632 7744320
21:27:04 47935 8192000000 10914198640 11378827264 1951583920 19.239 97 36 72 0 1971032048 9383200 10064928
21:27:58 82680 8192000000 10913080832 11393900544 1976511744 19.437 99 16 33 0 1991047824 10224880 4311200
21:29:28 63965 8192000000 10925709776 11392802816 1957726128 19.288 98 21 42 0 1972373792 8837248 5810416
21:30:42 85011 8192000000 10905502944 11381899264 1891913424 18.761 95 7 14 0 1911454224 17367776 2173024
21:32:15 53578 8192000000 10922208032 11393425408 1960157440 19.307 99 26 52 0 1979884320 12502320 7224560
21:33:15 105384 8192000000 10915688416 11404611584 1971705392 19.399 99 10 20 1 1989945136 15729568 2510176
21:35:11 77806 8192000000 10929164544 11398889472 1940926032 19.154 97 31 62 0 1960696864 11272192 8498640
21:36:38 61581 8192000000 10907896784 11388088320 1945041360 19.187 98 14 28 2 1969776208 20905360 3829488
21:37:45 86754 8192000000 10899780064 11388207104 1899006848 18.818 96 5 10 0 1922785088 22349248 1428992
21:39:36 104817 8192000000 10887908816 11343335424 1836801248 18.315 93 31 63 0 1858004560 12246832 8956480
21:41:36 46194 8192000000 10865442016 11339350016 1913262352 18.933 98 23 46 1 1929144688 9381120 6501216
21:42:32 120591 8192000000 10872469456 11346862080 1902945888 18.850 97 25 50 0 1920292656 10225472 7121296
21:44:40 23827 8192000000 10856971472 11317936128 1901585440 18.839 98 27 53 2 1918771200 9517504 7668256
21:45:15 38099 8192000000 10814114592 11276046336 1861488528 18.515 97 24 47 1 1876951712 8374448 7088736
21:46:42 50952 8192000000 10817593840 11278721024 1869391456 18.579 98 17 34 1 1885630768 10939056 5300256
21:47:41 59617 8192000000 10807657552 11274608640 1829682464 18.257 96 16 32 1 1845153872 9796336 5675072
21:49:12 49704 8192000000 10809241008 11285446656 1892092592 18.763 100 14 28 1 1905107744 8728512 4286640
21:50:34 51456 8192000000 10845978960 11303542784 1876552656 18.637 98 9 18 2 1886510320 7487584 2470080
21:52:33 63445 8192000000 10829591136 11311300608 1864612400 18.541 97 11 22 0 1879557200 11840096 3104704
21:53:46 73202 8192000000 10848990304 11324858368 1883479440 18.693 98 10 20 0 1898337904 11881248 2977216
21:55:08 66085 8192000000 10835833440 11301986304 1829068528 18.252 95 15 30 1 1842005088 8567152 4369408
21:57:12 88811 8192000000 10869510816 11348819968 1893033024 18.770 98 15 30 0 1917310688 19934464 4343200
21:58:46 96554 8192000000 10879552112 11345862656 1888073648 18.730 97 14 28 0 1905547296 13929472 3544176
22:00:29 81402 8192000000 10868722432 11353858048 1914855584 18.946 98 8 16 0 1935627088 18640464 2131040
22:02:26 105946 8192000000 10888113984 11341701120 1890544480 18.750 97 12 24 0 1910874128 17124272 3205376
22:04:20 60124 8192000000 10901412512 11369259008 1957849344 19.289 100 38 76 2 1983165440 14707472 10608624
22:05:30 59845 8192000000 10906498448 11372978176 1945007936 19.187 99 25 51 0 1966658400 14635392 7015072
22:06:36 112648 8192000000 10923361696 11373944832 1973770032 19.415 100 37 74 0 1999948848 16269552 9909264
22:08:52 84419 8192000000 10890646464 11376439296 1957129264 19.283 99 23 46 1 1974988624 11847888 6011472
22:10:31 39413 8192000000 10891121280 11360075776 1952021648 19.243 99 18 36 1 1966983040 10044080 4917312
22:11:16 60848 8192000000 10869414128 11350614016 1925260432 19.029 98 12 24 0 1940375984 11559360 3556192
22:12:27 78710 8192000000 10861376432 11342331904 1896186304 18.796 97 8 16 0 1908742912 10407664 2148944
22:13:55 78708 8192000000 10880617440 11361656832 1959845856 19.305 100 14 28 4 1976235136 12213408 4175872
22:15:25 46484 8192000000 10893405888 11374112768 1972029568 19.402 100 19 38 2 1987642880 9831712 5781600
22:16:18 78186 8192000000 10899154096 11362967552 1939820816 19.145 98 28 56 0 1953554400 5441056 8292528
22:17:44 68118 8192000000 10882067840 11358375936 1919372448 18.982 97 28 56 1 1936747904 9594304 7781152
22:19:01 62987 8192000000 10880633152 11365601280 1969937712 19.385 100 12 22 1 1982844480 9371840 3534928
22:20:12 84964 8192000000 10886844400 11385806848 1949932656 19.226 99 8 16 0 1961313152 9209808 2170688
22:21:44 58424 8192000000 10894686992 11376013312 1940555344 19.151 98 19 38 1 1954851104 8988880 5306880
22:22:57 65214 8192000000 10902991760 11386589184 1978032816 19.449 100 22 44 1 1997557056 12506960 7017280
22:24:10 43341 8192000000 10909041824 11385663488 1966282720 19.356 99 19 38 2 1987538304 15110272 6145312
22:25:05 36737 8192000000 10909435760 11377565696 1944275200 19.181 98 25 50 2 1964903968 13249552 7379216
22:25:51 49579 8192000000 10888677376 11364749312 1935634128 19.112 98 24 47 2 1956248640 13655424 6959088
22:26:51 24486 8192000000 9199059520 9448194048 362659472 4.239 19 1 2 0 364839472 2083472 96528

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 28-12-2020 22:28:13 to 28-12-2020 22:28:44.

Exceptions occured during test was in run

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

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

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          230446
MON$OLDEST_ACTIVE               230447
MON$OLDEST_SNAPSHOT             230447
MON$NEXT_TRANSACTION            230447
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                       2043744
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:24: 
:25: mscs-test-161.budzdorov.ru    Mon Dec 28 22:27:16 2020
:26:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:27: 
--- end of diff output ---

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

28.12.20 22:28:48. 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-28 22:28:50 No severe PSQL-related problems occured
28.12.20 22:28:51. End of report.