Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.01.2021 01: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 17165660 kB
MemAvailable 31240816 kB
Buffers 0 kB
Cached 14505560 kB
SwapCached 4868 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-30 01:27:13
DTS_END                         2021-01-30 01:27:13.5350
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/60432
TRN_ID                          244182
ATT_ID                          705
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: 9423.48 21806 1130817
customer order: creation 176.18 336 21141
customer order: refuse 15.46 321 1855
order to supplier: creation 47.26 1211 5671
order to supplier: removal 3.62 94438 434
invoice (draft): creation 46.81 3265 5617
invoice (draft): removal 53.78 724 6454
invoice accept: apply 42.57 15867 5108
invoice accept: cancel 48.71 768 5845
customer reserve: creation 3899.85 158 467982
customer reserve: removal 4781.90 56 573828
realization accept: apply 84.27 185 10112
realization accept: cancel 90.41 108 10849
payment from customer: creation 61.15 124 7338
payment from customer: removal 6.05 101 726
payment to supplier: creation 49.84 135 5981
payment to supplier: removal 3.32 69 398
service: total inventory turnovers 4.76 1049 571
service: total monetary turnovers 6.54 28 785
service: aggregate perf. data 0.98 17283 118
service: refresh index statistics 0.03 299893 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-01-2021 01:28:12 to 30-01-2021 01:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3482
TEST_TIME 2 4502
TEST_TIME 3 4242
TEST_TIME 4 5195
TEST_TIME 5 4705
TEST_TIME 6 4491
TEST_TIME 7 4417
TEST_TIME 8 4747
TEST_TIME 9 5083
TEST_TIME 10 5417
TEST_TIME 11 6062
TEST_TIME 12 6399
TEST_TIME 13 6777
TEST_TIME 14 6845
TEST_TIME 15 7035
TEST_TIME 16 7516
TEST_TIME 17 7938
TEST_TIME 18 7913
TEST_TIME 19 8665
TEST_TIME 20 8825
TEST_TIME 21 8934
TEST_TIME 22 9230
TEST_TIME 23 9405
TEST_TIME 24 9366
TEST_TIME 25 9441
TEST_TIME 26 10662
TEST_TIME 27 11239
TEST_TIME 28 10965
TEST_TIME 29 11046
TEST_TIME 30 10751
TEST_TIME 31 11101
TEST_TIME 32 10945
TEST_TIME 33 10720
TEST_TIME 34 10446
TEST_TIME 35 10326
TEST_TIME 36 10316
TEST_TIME 37 10244
TEST_TIME 38 10100
TEST_TIME 39 10196
TEST_TIME 40 10181
TEST_TIME 41 10088
TEST_TIME 42 10059
TEST_TIME 43 10023
TEST_TIME 44 9823
TEST_TIME 45 9939
TEST_TIME 46 9896
TEST_TIME 47 9851
TEST_TIME 48 9860
TEST_TIME 49 9940
TEST_TIME 50 9889
TEST_TIME 51 9857
TEST_TIME 52 9876
TEST_TIME 53 9853
TEST_TIME 54 9941
TEST_TIME 55 10014
TEST_TIME 56 9953
TEST_TIME 57 10010
TEST_TIME 58 9980
TEST_TIME 59 10121
TEST_TIME 60 10128
TEST_TIME 61 10042
TEST_TIME 62 9954
TEST_TIME 63 9853
TEST_TIME 64 9852
TEST_TIME 65 9850
TEST_TIME 66 9804
TEST_TIME 67 9713
TEST_TIME 68 9702
TEST_TIME 69 9692
TEST_TIME 70 9731
TEST_TIME 71 9832
TEST_TIME 72 9774
TEST_TIME 73 9772
TEST_TIME 74 9896
TEST_TIME 75 9857
TEST_TIME 76 9886
TEST_TIME 77 9912
TEST_TIME 78 9959
TEST_TIME 79 9953
TEST_TIME 80 9849
TEST_TIME 81 9800
TEST_TIME 82 9753
TEST_TIME 83 9798
TEST_TIME 84 9748
TEST_TIME 85 9695
TEST_TIME 86 9672
TEST_TIME 87 9647
TEST_TIME 88 9656
TEST_TIME 89 9664
TEST_TIME 90 9643
TEST_TIME 91 9623
TEST_TIME 92 9653
TEST_TIME 93 9661
TEST_TIME 94 9688
TEST_TIME 95 9706
TEST_TIME 96 9754
TEST_TIME 97 9720
TEST_TIME 98 9721
TEST_TIME 99 9769
TEST_TIME 100 9745
TEST_TIME 101 9796
TEST_TIME 102 9790
TEST_TIME 103 9742
TEST_TIME 104 9687
TEST_TIME 105 9667
TEST_TIME 106 9637
TEST_TIME 107 9620
TEST_TIME 108 9582
TEST_TIME 109 9584
TEST_TIME 110 9561
TEST_TIME 111 9517
TEST_TIME 112 9465
TEST_TIME 113 9448
TEST_TIME 114 9475
TEST_TIME 115 9475
TEST_TIME 116 9483
TEST_TIME 117 9482
TEST_TIME 118 9495
TEST_TIME 119 9490
TEST_TIME 120 9424

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 30-01-2021 01:28:16 to 30-01-2021 01:28:19.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1565072 1565072 0 0.00 0 25931 6 0 0
doc_list_biud 1565071 1565071 0 0.00 0 53473 26 0 0
sp_add_invoice_to_stock 5235 5108 127 2.42 49 221078 15868 0 127
sp_cancel_adding_invoice 5845 5845 0 0.00 5 53762 769 0 0
sp_cancel_client_order 1855 1855 0 0.00 4 9411 322 0 0
sp_cancel_customer_reserve 573828 573828 0 0.00 1 42139 56 0 0
sp_cancel_pay_from_customer 726 726 0 0.00 3 9130 101 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 3719 69 0 0
sp_cancel_supplier_invoice 6462 6454 8 0.12 1 16584 724 0 8
sp_cancel_supplier_order 434 434 0 0.00 6 928377 94438 0 0
sp_cancel_write_off 10849 10849 0 0.00 1 15877 109 0 0
sp_client_order 21141 21141 0 0.00 3 27234 336 0 0
sp_customer_reserve 467982 467982 0 0.00 0 56318 159 0 0
sp_fill_shopping_cart 32419 32419 0 0.00 1 13528 34 0 0
sp_fill_shopping_cart_clo_res 467978 467978 0 0.00 0 12763 11 0 0
sp_get_clo_for_invoice 5104 5104 0 0.00 0 19741 211 0 0
sp_kill_cost_storno 17818 17818 0 0.00 0 6869 53 0 0
sp_kill_qstorno_ret_qs2qd 1165393 1165393 0 0.00 0 42136 30 0 0
sp_kill_qty_storno 614481 614481 0 0.00 0 53472 65 0 0
sp_lock_selected_doc 21239 21239 0 0.00 0 9344 7 0 0
sp_make_cost_storno 28535 28535 0 0.00 0 17489 61 0 0
sp_multiply_rows_for_pdistr 28535 28535 0 0.00 0 13285 29 0 0
sp_multiply_rows_for_qdistr 21141 21141 0 0.00 0 9297 154 0 0
sp_pay_from_customer 7338 7338 0 0.00 4 17377 125 0 0
sp_pay_to_supplier 5981 5981 0 0.00 4 25954 136 0 0
sp_payment_common 13319 13319 0 0.00 1 14790 34 0 0
sp_qd_handle_on_cancel_clo 1855 1855 0 0.00 0 8206 295 0 0
sp_qd_handle_on_invoice_upd_sts 10949 10949 0 0.00 0 53471 306 0 0
sp_qd_handle_on_reserve_upd_sts 10112 10112 0 0.00 0 19610 55 0 0
sp_reserve_write_off 10112 10112 0 0.00 6 19686 186 0 0
sp_supplier_invoice 5617 5617 0 0.00 4 103122 3266 0 0
sp_supplier_order 5671 5671 0 0.00 5 34558 1211 0 0
srv_aggregate_perf_data 118 118 0 0.00 2272 247100 17284 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1076 124536 32386 0 0
srv_find_qd_qs_mism 1082561 1082561 0 0.00 0 25893 5 0 0
srv_make_invnt_saldo 571 571 0 0.00 31 71284 1050 0 0
srv_make_money_saldo 785 785 0 0.00 1 2959 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 140445 476331 299893 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5108 5108 0 0.00 0 17592 144 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 1 3459 84 0 0
t$perf-norm:sp_cancel_client_order 1855 1855 0 0.00 0 7597 16 0 0
t$perf-norm:sp_cancel_customer_reserve 726 726 0 0.00 0 1160 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 726 726 0 0.00 0 4224 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 1046 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 645 10 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 28768 1473 0 0
t$perf-norm:sp_cancel_write_off 1058 1058 0 0.00 0 9373 21 0 0
t$perf-norm:sp_client_order 21141 21141 0 0.00 0 8594 17 0 0
t$perf-norm:sp_customer_reserve 1040 1040 0 0.00 0 8290 15 0 0
t$perf-norm:sp_pay_from_customer 7338 7338 0 0.00 0 5678 8 0 0
t$perf-norm:sp_pay_to_supplier 5981 5981 0 0.00 0 8386 12 0 0
t$perf-norm:sp_reserve_write_off 10112 10112 0 0.00 0 7881 12 0 0
t$perf-norm:sp_supplier_invoice 5617 5617 0 0.00 0 5760 15 0 0
t$perf-norm:sp_supplier_order 5671 5671 0 0.00 0 4476 12 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 1618 20 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 303 4 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 2611 20 0 0
t$perf-norm:srv_make_money_saldo 785 785 0 0.00 0 872 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10460 10206 254 2.42 0 25867 25 0 254
v_all_customers 39084 39084 0 0.00 0 57 1 0 0
v_all_suppliers 31614 31614 0 0.00 0 21 1 0 0
v_all_wares 42282 42282 0 0.00 0 78 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 1726 10 0 0
v_cancel_client_order 3710 3710 0 0.00 0 2280 5 0 0
v_cancel_customer_prepayment 1452 1452 0 0.00 0 9121 14 0 0
v_cancel_customer_reserve 1452 1452 0 0.00 0 1884 7 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 1864 7 0 0
v_cancel_supplier_invoice 802 786 16 1.99 0 2992 17 0 16
v_cancel_supplier_order 868 868 0 0.00 0 1838 5 0 0
v_cancel_write_off 2116 2116 0 0.00 0 2663 16 0 0
v_max_id_clo_ord 5669 5669 0 0.00 0 434 1 0 0
v_max_id_clo_res 1040 1040 0 0.00 0 3356 9 0 0
v_max_id_ord_sup 5607 5607 0 0.00 0 4255 4 0 0
v_max_non_paid_invoice 1450 1450 0 0.00 0 829 3 0 0
v_max_non_paid_realizn 3622 3622 0 0.00 0 3214 5 0 0
v_min_id_clo_ord 5669 5669 0 0.00 0 2739 6 0 0
v_min_id_clo_res 1040 1040 0 0.00 0 3724 15 0 0
v_min_id_ord_sup 5607 5607 0 0.00 0 4370 7 0 0
v_min_non_paid_invoice 5981 5981 0 0.00 0 6936 17 0 0
v_min_non_paid_realizn 7338 7338 0 0.00 0 12537 25 0 0
v_our_firm 10630 10630 0 0.00 0 15 1 0 0
v_reserve_write_off 20222 20222 0 0.00 0 6085 7 0 0
x_lock_depdocs_on_canc_invoice 11906 11906 0 0.00 0 34156 117 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 15736 336 0 0
x_make_qstorno_1000_1200 5671 5671 0 0.00 1 34546 1136 0 0
x_make_qstorno_1200_2000 5617 5617 0 0.00 2 103058 3148 0 0
x_make_qstorno_2100_3300 467982 467982 0 0.00 0 56313 145 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-01-2021 01:28:20 to 30-01-2021 01:28:24.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:17 11 8192000000 8805187232 8817643520 10033696 0.122 3 1 2 0 10156688 60432 62560
22:57:23 20202 8192000000 10209712976 10525925376 992654064 10.807 79 59 116 0 1015610768 2997360 19959344
22:57:52 36350 8192000000 10351516368 10666123264 1380602144 14.422 100 85 170 0 1413670320 5146208 27921968
22:58:37 17199 8192000000 10367942640 10688933888 1419612336 14.769 100 87 174 0 1455612016 6669632 29330048
22:59:09 33416 8192000000 10388465056 10716139520 1441420144 14.962 100 86 172 1 1477312128 7574080 28317904
22:59:58 29723 8192000000 10427916976 10759532544 1476359312 15.270 100 86 172 0 1512987280 8326192 28301776
23:00:44 19979 8192000000 10445895904 10780467200 1501927104 15.493 100 90 180 1 1540378320 8854384 29596832
23:01:12 20487 8192000000 10455854224 10795913216 1511889920 15.580 100 82 164 0 1547604352 8793456 26920976
23:01:43 16269 8192000000 10465553024 10813050880 1529417744 15.732 100 69 138 1 1559374544 8834192 21122608
23:02:06 14532 8192000000 10511673040 10863951872 1563737456 16.028 100 68 136 1 1593028480 8460208 20830816
23:02:29 13386 8192000000 10550405456 10908344320 1614491200 16.463 100 79 158 1 1647067712 9005248 23571264
23:02:53 12038 8192000000 10571405568 10934525952 1638637568 16.668 100 76 152 0 1672420176 10358656 23423952
23:03:13 13107 8192000000 10587657392 10952011776 1652312448 16.784 100 78 156 1 1685471344 10883104 22275792
23:03:38 12635 8192000000 10607753632 10978025472 1670454704 16.937 100 80 160 1 1706484848 12137648 23892496
23:04:01 9640 8192000000 10634651152 10999398400 1693676128 17.132 100 81 162 2 1729600272 12618448 23305696
23:04:20 9421 8192000000 10642734320 11011276800 1700492736 17.189 100 80 160 0 1735868816 12189728 23186352
23:04:40 7513 8192000000 10647861520 11017916416 1708634464 17.257 100 79 158 0 1744331312 12261056 23435792
23:04:55 6227 8192000000 10655338336 11031482368 1722510672 17.373 100 83 166 1 1759076832 12589632 23976528
23:05:09 6627 8192000000 10669225632 11047993344 1732795808 17.459 100 76 149 0 1769672816 15972432 20904576
23:05:23 7517 8192000000 10691335888 11067060224 1748535856 17.589 100 81 162 0 1783953312 12403552 23013904
23:05:38 6637 8192000000 10692003232 11071901696 1754075552 17.635 100 70 140 0 1785947568 12414464 19457552
23:05:53 4843 8192000000 10705604320 11084406784 1767472640 17.746 100 77 154 2 1800615616 11602592 21540384
23:06:05 4074 8192000000 10717866192 11098718208 1782045664 17.866 100 85 170 1 1818329680 12418480 23865536
23:06:15 4020 8192000000 10715830352 11103924224 1785159536 17.892 100 75 150 1 1817833376 11977376 20696464
23:06:26 4694 8192000000 10734707936 11115556864 1797266640 17.991 100 82 164 0 1831946656 12168992 22511024
23:06:38 3179 8192000000 10741114368 11124887552 1804532496 18.051 100 84 166 2 1840848704 13230288 23085920
23:06:48 2875 8192000000 10744669984 11129671680 1808251872 18.082 100 86 170 1 1846695504 13771712 24671920
23:06:57 3048 8192000000 10751341888 11133804544 1811035744 18.104 100 89 176 0 1850364432 14903216 24425472
23:07:08 5038 8192000000 10753221424 11138428928 1814341680 18.131 100 80 160 2 1851035392 14793296 21900416
23:07:21 2371 8192000000 10776881696 11161108480 1825706288 18.224 100 82 164 0 1863147920 14110080 23331552
23:07:30 2619 8192000000 10784685664 11168788480 1839275328 18.335 100 92 182 3 1878919312 13816288 25827696
23:07:39 3105 8192000000 10777052672 11160571904 1842550464 18.362 100 82 162 1 1877809712 12622048 22637200
23:07:48 2810 8192000000 10790405376 11175428096 1848421104 18.409 100 87 175 1 1885892368 13338736 24132528
23:07:57 2134 8192000000 10783675600 11175747584 1850188160 18.424 100 82 162 2 1885891824 13120016 22583648
23:08:06 1420 8192000000 10797299584 11182329856 1855924256 18.470 100 92 186 0 1896286416 14449760 25912400
23:08:13 1609 8192000000 10814263616 11197386752 1859959072 18.503 100 95 190 1 1901135744 13544832 27631840
23:08:22 1894 8192000000 10812333872 11197493248 1861588480 18.516 100 95 191 0 1901906880 13666528 26651872
23:08:30 2013 8192000000 10811615168 11198803968 1866526064 18.556 100 93 185 1 1907376112 14274272 26575776
23:08:38 1751 8192000000 10812845040 11200077824 1866312800 18.554 100 95 190 0 1908589664 14590480 27686384
23:08:46 1583 8192000000 10811265568 11199524864 1866984752 18.560 100 88 177 0 1907137728 15271424 24881552
23:08:54 1533 8192000000 10814270464 11202560000 1868339632 18.571 100 91 182 3 1908898912 14469168 26090112
23:09:02 1703 8192000000 10814660368 11202228224 1873192992 18.610 100 95 188 1 1913635120 13029136 27412992
23:09:10 1720 8192000000 10813516576 11201523712 1870965680 18.592 100 90 183 0 1908877728 11406928 26505120
23:09:18 1066 8192000000 10810271072 11205005312 1868452944 18.572 100 84 168 0 1904336896 11954544 23929408
23:09:27 34770 8192000000 10795760112 11199528960 1864789456 18.542 100 48 96 0 1886109360 7775200 13544704
23:10:09 4310 8192000000 10783934912 11206340608 1864223792 18.538 100 42 85 1 1890022144 14633632 11164720
23:10:21 7181 8192000000 10772951728 11202764800 1868496896 18.572 100 38 76 1 1887857696 8661392 10699408
23:10:35 7877 8192000000 10790096304 11203747840 1868032896 18.568 100 46 92 0 1889201056 8101376 13066784
23:10:49 8578 8192000000 10782647264 11206819840 1866520576 18.556 100 18 36 1 1878117648 6503424 5093648
23:11:05 6018 8192000000 10780352000 11207856128 1868726624 18.574 100 25 50 0 1881763904 6091968 6945312
23:11:18 10403 8192000000 10783765376 11211251712 1873926288 18.616 100 19 38 1 1885552240 6773568 4852384
23:11:37 9500 8192000000 10781819104 11217272832 1874842688 18.623 100 17 34 3 1889590416 10333712 4414016
23:11:52 6668 8192000000 10795340016 11221458944 1878215168 18.651 100 20 40 3 1890468864 6314032 5939664
23:12:10 16468 8192000000 10788069104 11220824064 1882726016 18.687 100 4 8 0 1888882080 5219584 936480
23:12:40 7626 8192000000 10792861344 11224227840 1886034064 18.714 100 22 44 3 1899153232 7201264 5917904
23:12:54 16412 8192000000 10788202736 11226677248 1888134560 18.731 100 27 54 1 1902221856 6343024 7744272
23:13:16 75663 8192000000 10814627648 11245678592 1902524192 18.847 100 39 78 0 1919781392 5185824 12071376
23:14:38 7823 8192000000 10807985568 11244171264 1898232336 18.812 100 16 32 3 1908520688 5967632 4320720
23:14:54 7872 8192000000 10813244720 11251281920 1901962272 18.842 100 27 54 2 1916504240 7111760 7430208
23:15:10 6675 8192000000 10823002304 11246714880 1888485840 18.734 99 39 78 1 1907929664 8248880 11194944
23:15:25 4147 8192000000 10823784016 11249246208 1903002064 18.850 100 37 74 1 1921913008 8018992 10891952
23:15:35 4609 8192000000 10819575296 11250700288 1901880800 18.841 100 38 76 0 1920438848 7302880 11255168
23:15:47 5878 8192000000 10818713232 11252584448 1904441008 18.862 100 27 54 1 1918405120 6599296 7364816
23:16:01 5475 8192000000 10809473040 11249410048 1884330000 18.700 99 22 45 2 1897384016 6657376 6396640
23:16:15 14294 8192000000 10811237040 11245248512 1881860288 18.680 99 20 39 1 1894011344 5663472 6487584
23:16:36 9359 8192000000 10816566768 11252981760 1904659120 18.864 100 17 33 1 1915352368 5889648 4803600
23:16:53 6747 8192000000 10806949152 11243241472 1883131728 18.690 99 15 30 0 1893343168 5635408 4576032
23:17:07 6917 8192000000 10808821856 11241197568 1881093424 18.674 99 33 67 0 1898214576 7576512 9544640
23:17:21 8662 8192000000 10793094432 11228618752 1844598672 18.378 97 21 40 1 1861142800 10282160 6261968
23:17:38 8448 8192000000 10748468256 11176747008 1798042080 17.998 96 20 42 0 1808886992 5014192 5830720
23:17:55 9216 8192000000 10766845072 11189321728 1807764128 18.078 97 15 30 0 1822578864 9751344 5063392
23:18:11 48046 8192000000 10757323792 11174154240 1773822736 17.799 96 20 40 0 1785315792 5031616 6461440
23:19:05 26117 8192000000 10759122032 11180687360 1789182496 17.925 97 33 66 0 1808098256 9956992 8958768
23:19:38 7592 8192000000 10751164288 11175415808 1807641920 18.077 98 25 50 2 1821412640 6561616 7209104
23:19:53 8024 8192000000 10735569168 11151532032 1759843728 17.683 96 29 58 2 1774014944 6304832 7866384
23:20:07 3802 8192000000 10686615360 11098771456 1729741168 17.433 95 36 72 1 1746999440 7039952 10218320
23:20:18 6960 8192000000 10732075520 11146907648 1785130848 17.892 98 36 71 4 1801784736 6879552 9774336
23:20:32 5474 8192000000 10731515008 11149000704 1796015968 17.981 99 22 44 0 1807852432 5502144 6334320
23:20:43 5792 8192000000 10714220496 11134734336 1775152304 17.810 98 24 48 3 1787170624 5027552 6990768
23:20:56 10353 8192000000 10737680176 11152166912 1791294160 17.942 98 23 45 2 1803083680 5173728 6615792
23:21:13 8542 8192000000 10728740928 11144757248 1768443952 17.754 97 20 40 2 1780253968 5674112 6135904
23:21:29 8115 8192000000 10696496432 11109838848 1763966400 17.717 97 16 32 2 1773599280 5388656 4244224
23:21:43 4921 8192000000 10706414816 11116335104 1762458928 17.705 98 40 80 2 1779906304 5486464 11960912
23:21:56 8743 8192000000 10719987152 11140448256 1808216288 18.081 100 19 38 0 1819940928 5588144 6136496
23:22:13 10177 8192000000 10723951120 11146461184 1784272576 17.885 98 18 36 1 1794662080 5151104 5238400
23:22:33 10834 8192000000 10714147936 11141046272 1801131344 18.023 99 24 48 0 1813075408 4585808 7358256
23:22:50 10891 8192000000 10723686416 11148804096 1806120640 18.064 99 29 58 1 1820735568 6002672 8612256
23:23:10 72466 8192000000 10727701616 11154149376 1766774912 17.740 96 41 82 2 1783282144 4888592 11618640
23:24:31 12197 8192000000 10757279232 11180716032 1841585888 18.354 100 22 44 2 1853010432 4795936 6628608
23:24:51 8717 8192000000 10757232160 11186868224 1850434464 18.426 100 23 46 2 1867306224 10743568 6128192
23:25:07 9115 8192000000 10777543872 11202727936 1858854816 18.494 100 26 52 2 1872095664 5756768 7484080
23:25:24 8861 8192000000 10763100496 11198574592 1859290784 18.498 100 19 38 1 1870261152 5774912 5195456
23:25:39 9642 8192000000 10781787872 11209633792 1867701584 18.566 100 29 58 2 1882186688 5019808 9465296
23:25:55 7599 8192000000 10793375520 11212910592 1874622832 18.622 100 24 48 3 1886498976 4924752 6951392
23:26:09 5827 8192000000 10806736304 11221024768 1874018256 18.617 100 31 62 1 1887620720 5391856 8210608
23:26:23 14423 8192000000 10795402272 11225210880 1873593376 18.613 100 13 26 3 1886789520 9774592 3421552
23:26:45 11595 8192000000 10792596720 11228839936 1883290672 18.692 100 21 42 2 1895033136 5863328 5879136
23:27:07 35881 8192000000 10837439520 11261005824 1905996624 18.874 100 26 49 3 1918375584 4594128 7784832
23:27:51 16204 8192000000 10855456592 11276341248 1925480224 19.031 100 43 86 1 1945131376 6685408 12965744
23:28:18 34831 8192000000 10871073344 11291189248 1931795872 19.081 100 43 86 0 1951032176 7360704 11875600
23:29:01 14637 8192000000 10885331392 11308716032 1947001536 19.203 100 45 89 2 1970117632 9825680 13290416
23:29:26 62164 8192000000 10887441744 11329245184 1957650384 19.287 100 35 69 2 1976505872 8860624 9994864
23:30:35 107186 8192000000 10909337936 11346984960 1968973440 19.377 100 33 64 3 1989898608 10781536 10143632
23:32:33 56523 8192000000 10915769648 11359596544 1966093536 19.354 99 32 64 2 1989718528 14552512 9072480
23:33:36 29782 8192000000 10918822256 11369185280 1990837664 19.550 100 35 69 3 2020051504 18500928 10712912
23:34:13 15748 8192000000 10948322000 11379007488 1999096016 19.616 100 41 82 0 2031695120 19988848 12610256
23:34:37 5562 8192000000 10949915952 11384614912 2005235520 19.664 100 52 103 1 2041910368 21158128 15516720
23:34:59 28151 8192000000 10955743072 11396014080 2012048160 19.718 100 44 89 1 2051892592 24975424 14869008
23:35:38 8850 8192000000 10958139520 11397292032 2011859264 19.716 100 48 97 0 2050211168 23211408 15140496
23:35:54 10134 8192000000 10972056896 11408158720 2013459552 19.729 100 46 92 1 2056669824 28518368 14691904
23:36:13 7676 8192000000 10964020016 11400515584 2010093952 19.702 100 53 104 2 2051362496 25445104 15823440
23:36:28 9286 8192000000 10967097552 11404263424 2014303600 19.735 100 55 107 4 2057574416 26723184 16547632
23:36:48 14927 8192000000 10945719008 11376144384 1977029264 19.441 98 63 124 1 2019220048 23279776 18911008
23:37:12 2684 8192000000 10959343840 11391344640 2008283024 19.688 100 68 137 0 2052074864 23304912 20486928
23:37:21 4981 8192000000 10959902464 11389997056 2005258112 19.664 100 65 131 0 2048651520 24071728 19321680
23:37:33 1208 8192000000 10976412464 11395776512 2009403952 19.697 100 76 148 1 2055078528 24667216 21007360
23:37:41 3672 8192000000 10949773888 11381911552 1984337472 19.499 99 72 142 0 2031520912 26189600 20993840
23:37:54 4138 8192000000 10962936032 11394523136 2006374000 19.673 100 63 125 1 2050588384 25362816 18851568
23:38:06 9462 8192000000 10974883984 11397595136 2014668384 19.738 100 85 171 2 2066644320 26996704 24979232
23:38:23 2599 8192000000 10965597536 11391369216 2003105184 19.647 100 75 148 1 2052890480 27321344 22463952
23:38:32 2929 8192000000 10963758384 11384647680 1995402000 19.586 100 78 157 0 2048694960 29073280 24219680
23:38:41 1601 8192000000 10977282464 11393835008 2003927216 19.654 100 91 182 0 2060506448 30035424 26543808
23:38:49 3129 8192000000 10970046176 11392225280 2001553792 19.635 100 81 165 1 2056510624 30508592 24448240
23:39:00 2769 8192000000 10955075856 11389157376 1998769920 19.613 100 63 125 1 2045124752 27153072 19201760
23:39:11 4353 8192000000 10944697024 11377197056 1984927504 19.504 99 57 112 2 2027712400 26152480 16632416
23:39:24 16617 8192000000 10939574352 11370250240 1970412752 19.389 99 59 117 1 2016011920 27696816 17902352
23:39:50 2038 8192000000 10951940432 11370770432 1981727248 19.478 100 81 162 3 2037960864 31256384 24977232
23:39:59 5331 8192000000 10929557728 11347759104 1931602128 19.080 98 76 151 1 1987499600 33453728 22443744
23:40:14 3967 8192000000 10944600576 11362881536 1972298928 19.404 100 73 146 1 2027491440 32870800 22321712
23:40:24 3679 8192000000 10950473120 11374055424 1979634784 19.462 100 61 122 1 2031446432 33270368 18541280
23:40:36 2091 8192000000 10963559472 11381284864 1991157680 19.553 100 83 164 0 2050252592 33231392 25863520
23:40:45 4928 8192000000 10965366288 11385376768 1989686528 19.541 100 77 153 0 2048633232 35040272 23906432
23:40:58 2322 8192000000 10966821648 11387252736 1993456240 19.571 100 71 142 2 2048397536 33429616 21511680
23:41:07 20479 8192000000 10954033408 11375308800 1977105568 19.442 99 66 132 1 2028954864 31251264 20598032
23:41:34 4380 8192000000 10971400304 11392671744 1993255488 19.570 100 73 144 0 2050307232 34203744 22848000
23:41:46 5716 8192000000 10942590448 11368730624 1955957344 19.274 98 67 135 2 2012216880 35829040 20430496
23:42:05 5675 8192000000 10928668016 11349520384 1927163600 19.044 97 67 134 1 1986518176 38800816 20553760
23:42:21 8678 8192000000 10963949264 11388862464 1988070400 19.529 100 68 133 1 2049699088 40978960 20649728
23:42:41 4185 8192000000 10965476464 11382165504 1975438960 19.429 99 78 156 1 2043407696 43375584 24593152
23:42:52 1551 8192000000 10953699584 11368677376 1969547472 19.382 99 85 169 1 2037792992 42639344 25606176
23:43:00 3050 8192000000 10973396592 11386757120 1980068256 19.465 100 85 171 1 2050861696 44895248 25898192
23:43:11 1502 8192000000 10962654224 11373821952 1968481520 19.373 99 84 167 1 2040310656 46588368 25240768
23:43:20 3927 8192000000 10983521040 11397767168 1992311344 19.562 100 84 168 1 2064607888 47020080 25276464
23:43:31 3831 8192000000 10982344640 11399790592 1994755872 19.581 100 81 158 1 2066603360 47927056 23920432
23:43:41 1535 8192000000 10991179552 11402031104 1993346128 19.570 100 85 171 1 2068671856 49207072 26118656
23:43:49 2897 8192000000 10977790912 11404177408 1992690752 19.565 100 65 129 1 2060770832 47841344 20238736
23:43:58 7115 8192000000 10971896320 11409969152 1992820544 19.566 100 46 92 0 2054646768 46963184 14863040
23:44:12 7815 8192000000 10897130944 11330207744 1885420736 18.709 95 51 98 2 1946804976 46294416 15089824
23:44:26 3547 8192000000 10932022416 11361976320 1959277712 19.300 100 62 126 0 2022308080 42910976 20119392
23:44:40 6872 8192000000 10927117392 11348684800 1922651072 19.008 98 55 110 1 1984949088 44186880 18111136
23:45:02 7945 8192000000 10933025232 11363897344 1955318784 19.269 100 48 96 0 2017791616 46698112 15774720
23:45:17 6446 8192000000 10939455776 11379523584 1968811888 19.376 100 53 104 1 2034188912 48009888 17367136
23:45:34 10157 8192000000 10941378912 11382689792 1969944304 19.385 100 37 71 1 2031584432 49295840 12344288
23:45:53 2188 8192000000 10966408944 11398041600 1980266128 19.467 100 58 114 0 2050230144 51201264 18762752
23:46:05 2567 8192000000 10972978176 11398221824 1982291136 19.483 100 72 142 1 2055517968 51003792 22223040
23:46:15 5748 8192000000 10945685136 11362177024 1924862576 19.026 97 70 136 1 2001513328 54846320 21804432
23:46:28 5582 8192000000 10931681616 11364622336 1932594288 19.088 99 50 100 0 2006363440 56646816 17122336
23:46:41 13632 8192000000 10917516448 11367399424 1948462688 19.214 100 37 74 0 2013729712 52580704 12686320
23:47:11 7837 8192000000 10927751360 11362840576 1941748544 19.161 99 48 96 1 2002941072 45333344 15859184
23:47:34 10887 8192000000 10935794112 11376885760 1952868912 19.249 100 43 86 1 2017264096 49717408 14677776
23:47:57 10782 8192000000 10945965728 11382308864 1964768864 19.344 100 47 94 1 2024647424 44434736 15443824
23:48:14 9003 8192000000 10957970832 11389435904 1973892192 19.416 100 56 112 2 2036599136 44535472 18171472
23:48:31 5565 8192000000 10965745504 11398492160 1973739424 19.415 100 60 120 2 2047164352 53696224 19728704
23:48:58 24679 8192000000 10939898304 11394551808 1977975184 19.449 100 31 62 0 2032272704 43752272 10545248
23:49:29 13462 8192000000 10945140960 11391614976 1982657184 19.486 100 33 66 1 2030218800 36451776 11109840
23:49:49 30312 8192000000 10918433232 11362574336 1927259968 19.045 98 32 64 2 1979685488 41220656 11204864
23:50:26 6589 8192000000 10933317680 11374919680 1958647072 19.295 100 35 70 3 2012266384 41892640 11726672
23:50:39 5275 8192000000 10934953952 11376537600 1960800704 19.312 100 34 68 0 2016227904 43781952 11645248
23:50:53 6548 8192000000 10930336304 11376865280 1960965456 19.314 100 36 72 4 2013715504 40395456 12354592
23:51:16 9662 8192000000 10938601904 11381284864 1966407184 19.357 100 34 68 0 2018656352 40962704 11286464
23:51:49 46131 8192000000 10911942512 11376525312 1932327904 19.085 99 30 60 1 1992997216 49434960 11234352
23:53:35 39549 8192000000 10855046720 11336859648 1912078224 18.923 100 10 20 1 1957820432 42131056 3611152
23:54:21 68040 8192000000 10858204736 11292385280 1846456080 18.393 96 13 27 0 1863998592 14214496 3328016
23:55:35 18053 8192000000 10891519776 11319635968 1929416144 19.062 100 49 100 1 1953173680 9287408 14470128
23:56:04 32257 8192000000 10843233408 11308048384 1905379264 18.870 99 21 42 1 1926399104 15037392 5982448
23:57:38 66377 8192000000 10843957232 11315343360 1860308416 18.506 96 33 66 1 1884849808 14992032 9549360
23:58:51 80276 8192000000 10804343968 11236044800 1800159552 18.015 93 19 38 0 1811377072 6936144 4281376
00:00:25 124536 8192000000 10865645376 11302961152 1898544832 18.815 99 51 102 1 1926023552 12570992 14907728
00:02:37 1071 8192000000 10911820656 11328307200 1945428064 19.190 100 87 172 1 1979221600 9309232 24484304
00:02:44 10478 8192000000 10884127712 11330322432 1941041968 19.155 100 50 99 3 1964367008 10450448 12874592
00:03:03 29348 8192000000 10883257744 11335274496 1945883776 19.194 100 23 46 1 1960160368 7547632 6728960
00:03:39 18600 8192000000 10887719632 11333165056 1930500464 19.071 99 27 52 0 1947634400 10549584 6584352
00:04:11 23551 8192000000 10884108048 11348897792 1958301856 19.293 100 22 44 0 1976867552 11833504 6732192
00:04:42 45688 8192000000 10903313056 11359227904 1943614976 19.176 99 17 34 0 1959857392 11476624 4765792
00:05:39 53739 8192000000 10906990816 11379068928 1973882816 19.416 100 21 42 0 2001016320 20981136 6152368
00:06:41 42638 8192000000 10900190272 11381555200 1970879296 19.392 100 7 14 1 1990193744 17398352 1916096
00:07:30 55427 8192000000 10913768384 11382996992 1985918272 19.512 100 19 39 0 2004652624 13446032 5288320
00:08:32 35131 8192000000 10916726032 11384631296 1967439472 19.365 99 12 24 0 1983153904 12078112 3636320
00:09:22 53686 8192000000 10914893680 11389337600 1969146512 19.379 99 16 30 2 1988446096 14827984 4471600
00:10:32 33084 8192000000 10910723088 11393093632 1985737696 19.510 100 9 17 1 2001322448 13039248 2545504
00:11:11 30830 8192000000 10925687584 11392294912 1990131424 19.545 100 20 40 1 2009020304 12990800 5898080
00:12:01 39288 8192000000 10912360112 11403005952 1989250992 19.538 100 16 32 1 2009495520 15833904 4410624
00:12:46 56865 8192000000 10920529792 11399815168 1992911376 19.567 100 15 32 0 2008053872 10822560 4319936
00:13:49 71095 8192000000 10921025136 11407536128 1990979872 19.552 100 7 14 1 2008255552 15363136 1912544
00:15:07 38020 8192000000 10938235024 11396157440 1982483568 19.484 99 31 62 2 2001707040 10346400 8877072
00:15:59 44446 8192000000 10911204688 11398078464 1979581744 19.461 99 14 28 0 1993533248 9292144 4659360
00:16:50 47785 8192000000 10941399472 11400118272 1999773824 19.621 100 23 46 0 2014537536 7966352 6797360
00:17:45 11782 8192000000 10934612576 11396390912 1985799264 19.511 99 37 75 1 2003856672 7635888 10421520
00:18:06 51345 8192000000 10941940816 11413381120 2002218672 19.640 100 20 40 1 2016690464 9178112 5293680
00:19:08 55205 8192000000 10933995808 11410776064 1988421184 19.531 99 8 16 0 2002239264 11652080 2166000
00:20:13 70509 8192000000 10892946624 11366322176 1840096080 18.342 92 12 25 0 1857579408 14192272 3291056
00:21:33 115918 8192000000 10906241728 11363983360 1864040848 18.536 94 19 37 4 1890404880 21105376 5258656
00:23:39 39801 8192000000 10912423184 11373305856 1942722352 19.168 98 28 56 0 1962034384 10915984 8396048
00:25:01 100489 8192000000 10938518352 11410931712 1988706896 19.534 100 20 40 0 2009427568 14319136 6401536
00:26:48 117927 8192000000 10870839536 11359195136 1853622768 18.452 93 13 26 2 1874892432 17880144 3389520
00:29:22 36195 8192000000 10881271328 11351732224 1943193072 19.172 99 19 38 0 1954412816 5663184 5556560
00:30:22 9207 8192000000 10882009408 11342696448 1948260896 19.213 100 25 52 1 1962602336 7524704 6816736
00:30:37 71282 8192000000 10861443520 11337314304 1853458448 18.450 94 24 48 1 1870743840 9468368 7817024
00:31:57 65547 8192000000 10868064752 11352776704 1917596528 18.968 99 8 16 0 1931859040 12237728 2024784
00:33:09 18015 8192000000 10867338000 11354877952 1944286384 19.181 100 6 12 1 1961886608 15870144 1730080
00:33:36 19725 8192000000 10854524256 11346362368 1927377680 19.046 99 9 17 1 1943589376 13775680 2436016
00:34:08 60271 8192000000 10872934512 11329376256 1891887456 18.761 97 23 46 0 1909204256 9888832 7427968
00:35:23 62935 8192000000 10884226896 11358789632 1933692224 19.096 99 21 42 1 1955992144 15631888 6668032
00:36:46 58093 8192000000 10879473840 11357155328 1914777648 18.945 98 17 34 1 1932443520 12931600 4734272
00:38:11 71858 8192000000 10898391488 11382763520 1938815200 19.137 99 14 28 0 1957820304 14989520 4015584
00:39:34 47642 8192000000 10910110240 11367018496 1936318192 19.117 98 25 50 0 1952260336 8593968 7348176
00:40:29 43003 8192000000 10898468624 11368808448 1926130704 19.036 98 41 82 0 1952283264 14333856 11818704
00:41:29 64914 8192000000 10892846064 11367219200 1944102448 19.179 100 11 22 0 1968998816 21491424 3404944
00:43:05 44038 8192000000 10878241888 11339304960 1882274992 18.683 96 23 46 0 1898527920 9954464 6298464
00:43:56 62885 8192000000 10898729280 11365765120 1927720000 19.049 99 37 74 2 1953867824 15628080 10519744
00:46:17 119545 8192000000 10821659792 11278688256 1807304176 18.074 93 25 50 1 1822690992 8483872 6902944
00:48:33 88299 8192000000 10870339200 11340759040 1918439696 18.974 99 21 42 1 1937835104 13946752 5448656
00:50:09 43738 8192000000 10851315632 11344130048 1929790208 19.065 99 45 89 0 1953772208 11070240 12911760
00:51:56 35719 8192000000 10841263376 11318104064 1900887520 18.833 98 14 28 0 1918724224 13955856 3880848
00:52:41 43553 8192000000 10854294112 11332489216 1933204736 19.092 100 20 40 2 1955063648 15944848 5914064
00:53:32 43971 8192000000 10864082336 11341467648 1938093456 19.132 100 9 18 0 1954590240 13699696 2797088
00:55:56 51377 8192000000 10843081392 11314696192 1891532960 18.758 98 10 20 0 1903540032 9593056 2414016
00:56:54 55260 8192000000 10873423728 11337875456 1890600272 18.751 98 15 31 2 1902151072 7638768 3912032
00:57:55 30348 8192000000 10885480880 11348025344 1948267232 19.213 100 16 32 0 1961051504 8122800 4661472
00:58:34 71537 8192000000 10887005824 11366871040 1937954848 19.130 99 19 38 0 1954197696 10556704 5686144
01:00:19 36625 8192000000 10897438592 11365650432 1964440896 19.341 100 23 44 4 1978781712 8319200 6021616
01:01:13 32833 8192000000 10906873168 11377426432 1976396624 19.436 100 38 74 3 1997130880 10315008 10419248
01:02:24 66632 8192000000 10913680784 11395158016 1977927696 19.448 100 15 30 0 1996291792 14430544 3933552
01:03:38 96212 8192000000 10925496288 11393355776 1972148848 19.402 99 29 58 2 1990074544 8820576 9105120
01:05:21 31326 8192000000 10930034688 11390623744 1970267696 19.388 99 28 55 4 1990532720 12233968 8031056
01:06:07 90658 8192000000 10924502384 11387367424 1913812912 18.937 96 17 34 1 1936720736 17830176 5077648
01:07:44 57320 8192000000 10923554592 11404263424 1979385184 19.460 100 21 42 1 1999694096 14618272 5690640
01:08:51 55677 8192000000 10932466160 11390087168 1958216016 19.292 98 35 70 2 1980374416 11725536 10432864
01:09:53 53378 8192000000 10897196640 11372277760 1963824208 19.336 99 19 38 0 1978120576 8895776 5400592
01:11:22 95179 8192000000 10905174080 11386351616 1970323600 19.388 99 16 32 1 1983258912 8089024 4846288
01:13:09 30037 8192000000 10887766768 11356925952 1955606240 19.271 99 21 40 1 1967544656 6639152 5299264
01:13:51 9722 8192000000 10913291040 11381022720 1979770592 19.463 100 25 50 0 1993394352 6744080 6879680
01:14:09 84244 8192000000 10887671808 11375910912 1945035680 19.187 98 16 32 0 1959650160 9843168 4771312
01:15:39 22153 8192000000 10881867856 11368370176 1965607152 19.351 100 7 14 2 1977102720 9356832 2138736
01:16:46 32977 8192000000 10888091232 11359395840 1919718048 18.985 97 16 30 1 1930561168 6732304 4110816
01:17:25 46444 8192000000 10878924512 11352850432 1896230096 18.796 96 12 24 1 1904995840 5734928 3030816
01:18:46 70675 8192000000 10868716832 11354443776 1937857536 19.130 99 11 22 0 1949987840 9152928 2977376
01:20:03 21944 8192000000 10868123648 11360182272 1938114960 19.132 99 3 6 0 1947605072 8739184 750928
01:20:44 49861 8192000000 10868661888 11345154048 1923750976 19.017 99 14 28 1 1935619440 8398432 3470032
01:21:42 56625 8192000000 10868657488 11332333568 1866861168 18.559 95 18 36 0 1879008608 7470816 4676624
01:22:45 23725 8192000000 10868685488 11327533056 1889664480 18.743 97 39 78 0 1909732288 9383312 10684496
01:23:15 33450 8192000000 10883080048 11357392896 1950607056 19.231 100 32 64 0 1969819552 10421376 8791120
01:23:59 31456 8192000000 10844295808 11315503104 1859341104 18.498 95 26 52 2 1876068432 9461568 7265760
01:24:45 53340 8192000000 10857230128 11321536512 1880973088 18.673 97 20 40 0 1895700768 9090720 5636960
01:25:48 26275 8192000000 10859397808 11320004608 1910499824 18.911 99 31 62 1 1928865248 10164704 8200720
01:26:21 22807 8192000000 10874823808 11322318848 1879170864 18.658 97 42 84 1 1902610656 11909216 11530576

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 30-01-2021 01:28:26 to 30-01-2021 01:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          241519
MON$OLDEST_ACTIVE               244297
MON$OLDEST_SNAPSHOT             244297
MON$NEXT_TRANSACTION            244297
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                       2023744
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:213: 
:214: mscs-test-161.budzdorov.ru    Sat Jan 30 01:27:14 2021
:215:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:216: 
:217: 
:218: mscs-test-161.budzdorov.ru    Sat Jan 30 01:27:16 2021
:219:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:220: 
:221: 
:222: mscs-test-161.budzdorov.ru    Sat Jan 30 01:27:18 2021
:223:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:224: 
--- end of diff output ---

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

30.01.21 01:29:01. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-01-30 01:29:04 No severe PSQL-related problems occured
30.01.21 01:29:05. End of report.