Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.12.2020 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 17259004 kB
MemAvailable 31484068 kB
Buffers 0 kB
Cached 14403580 kB
SwapCached 3696 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-19 01:27:03
DTS_END                         2020-12-19 01:27:03.9370
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/59336
TRN_ID                          250642
ATT_ID                          681
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: 9863.21 22768 1183585
customer order: creation 174.18 352 20902
customer order: refuse 14.91 278 1789
order to supplier: creation 46.78 1165 5613
order to supplier: removal 3.72 85200 446
invoice (draft): creation 47.45 2930 5694
invoice (draft): removal 57.59 630 6911
invoice accept: apply 43.05 15942 5166
invoice accept: cancel 52.15 707 6258
customer reserve: creation 3961.53 159 475384
customer reserve: removal 5151.44 48 618173
realization accept: apply 85.12 202 10214
realization accept: cancel 93.27 106 11192
payment from customer: creation 61.35 133 7362
payment from customer: removal 5.54 60 665
payment to supplier: creation 49.93 157 5991
payment to supplier: removal 3.43 82 412
service: total inventory turnovers 4.64 941 557
service: total monetary turnovers 6.28 32 753
service: aggregate perf. data 0.83 21139 99
service: refresh index statistics 0.03 325092 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-12-2020 01:28:06 to 19-12-2020 01:28:08.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7178
TEST_TIME 2 3773
TEST_TIME 3 3449
TEST_TIME 4 4072
TEST_TIME 5 4563
TEST_TIME 6 5430
TEST_TIME 7 5707
TEST_TIME 8 6096
TEST_TIME 9 6743
TEST_TIME 10 6876
TEST_TIME 11 7142
TEST_TIME 12 7107
TEST_TIME 13 7299
TEST_TIME 14 7596
TEST_TIME 15 8255
TEST_TIME 16 8680
TEST_TIME 17 9413
TEST_TIME 18 9713
TEST_TIME 19 9854
TEST_TIME 20 10325
TEST_TIME 21 10182
TEST_TIME 22 10353
TEST_TIME 23 12046
TEST_TIME 24 11759
TEST_TIME 25 11625
TEST_TIME 26 11688
TEST_TIME 27 11663
TEST_TIME 28 11817
TEST_TIME 29 11745
TEST_TIME 30 11535
TEST_TIME 31 11319
TEST_TIME 32 11448
TEST_TIME 33 11532
TEST_TIME 34 11321
TEST_TIME 35 11155
TEST_TIME 36 11212
TEST_TIME 37 11228
TEST_TIME 38 11070
TEST_TIME 39 10897
TEST_TIME 40 10804
TEST_TIME 41 10879
TEST_TIME 42 10741
TEST_TIME 43 10699
TEST_TIME 44 10620
TEST_TIME 45 10584
TEST_TIME 46 10555
TEST_TIME 47 10613
TEST_TIME 48 10629
TEST_TIME 49 10538
TEST_TIME 50 10506
TEST_TIME 51 10626
TEST_TIME 52 10631
TEST_TIME 53 10626
TEST_TIME 54 10661
TEST_TIME 55 10602
TEST_TIME 56 10664
TEST_TIME 57 10689
TEST_TIME 58 10654
TEST_TIME 59 10502
TEST_TIME 60 10461
TEST_TIME 61 10372
TEST_TIME 62 10424
TEST_TIME 63 10334
TEST_TIME 64 10324
TEST_TIME 65 10274
TEST_TIME 66 10314
TEST_TIME 67 10251
TEST_TIME 68 10297
TEST_TIME 69 10398
TEST_TIME 70 10401
TEST_TIME 71 10404
TEST_TIME 72 10327
TEST_TIME 73 10384
TEST_TIME 74 10394
TEST_TIME 75 10419
TEST_TIME 76 10493
TEST_TIME 77 10452
TEST_TIME 78 10519
TEST_TIME 79 10419
TEST_TIME 80 10381
TEST_TIME 81 10335
TEST_TIME 82 10296
TEST_TIME 83 10203
TEST_TIME 84 10181
TEST_TIME 85 10165
TEST_TIME 86 10190
TEST_TIME 87 10125
TEST_TIME 88 10115
TEST_TIME 89 10121
TEST_TIME 90 10096
TEST_TIME 91 10075
TEST_TIME 92 10144
TEST_TIME 93 10118
TEST_TIME 94 10160
TEST_TIME 95 10164
TEST_TIME 96 10158
TEST_TIME 97 10144
TEST_TIME 98 10154
TEST_TIME 99 10129
TEST_TIME 100 10115
TEST_TIME 101 10132
TEST_TIME 102 10184
TEST_TIME 103 10191
TEST_TIME 104 10108
TEST_TIME 105 10100
TEST_TIME 106 10065
TEST_TIME 107 10053
TEST_TIME 108 10039
TEST_TIME 109 10009
TEST_TIME 110 9970
TEST_TIME 111 9969
TEST_TIME 112 9890
TEST_TIME 113 9857
TEST_TIME 114 9842
TEST_TIME 115 9890
TEST_TIME 116 9909
TEST_TIME 117 9927
TEST_TIME 118 9916
TEST_TIME 119 9944
TEST_TIME 120 9864

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 19-12-2020 01:28:09 to 19-12-2020 01:28:13.

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 1624895 1624895 0 0.00 0 42712 6 0 0
doc_list_biud 1624895 1624895 0 0.00 0 54341 23 0 0
sp_add_invoice_to_stock 5277 5166 111 2.10 23 156008 15943 0 111
sp_cancel_adding_invoice 6258 6258 0 0.00 6 81422 707 0 0
sp_cancel_client_order 1789 1789 0 0.00 4 13450 279 0 0
sp_cancel_customer_reserve 618173 618173 0 0.00 1 54345 49 0 0
sp_cancel_pay_from_customer 665 665 0 0.00 3 4243 61 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 8540 82 0 0
sp_cancel_supplier_invoice 6920 6911 9 0.13 2 19461 631 0 9
sp_cancel_supplier_order 446 446 0 0.00 7 848392 85201 0 0
sp_cancel_write_off 11192 11192 0 0.00 1 15171 107 0 0
sp_client_order 20902 20902 0 0.00 3 17972 353 0 0
sp_customer_reserve 475384 475384 0 0.00 0 49086 159 0 0
sp_fill_shopping_cart 32207 32207 0 0.00 1 17180 37 0 0
sp_fill_shopping_cart_clo_res 475383 475383 0 0.00 0 23681 13 0 0
sp_get_clo_for_invoice 5165 5165 0 0.00 0 27184 296 0 0
sp_kill_cost_storno 18527 18527 0 0.00 0 6611 47 0 0
sp_kill_qstorno_ret_qs2qd 1254895 1254895 0 0.00 0 54326 26 0 0
sp_kill_qty_storno 660148 660148 0 0.00 0 54340 57 0 0
sp_lock_selected_doc 21229 21229 0 0.00 0 9621 7 0 0
sp_make_cost_storno 28732 28732 0 0.00 0 42701 91 0 0
sp_multiply_rows_for_pdistr 28732 28732 0 0.00 0 6044 22 0 0
sp_multiply_rows_for_qdistr 20902 20902 0 0.00 0 15276 178 0 0
sp_pay_from_customer 7362 7362 0 0.00 4 42721 133 0 0
sp_pay_to_supplier 5991 5991 0 0.00 5 42799 157 0 0
sp_payment_common 13353 13353 0 0.00 1 21604 30 0 0
sp_qd_handle_on_cancel_clo 1789 1789 0 0.00 0 13445 248 0 0
sp_qd_handle_on_invoice_upd_sts 11423 11423 0 0.00 0 27049 281 0 0
sp_qd_handle_on_reserve_upd_sts 10214 10214 0 0.00 0 15634 52 0 0
sp_reserve_write_off 10214 10214 0 0.00 6 42740 202 0 0
sp_supplier_invoice 5694 5694 0 0.00 7 89585 2931 0 0
sp_supplier_order 5613 5613 0 0.00 5 41889 1165 0 0
srv_aggregate_perf_data 99 99 0 0.00 2817 182112 21140 0 0
srv_fill_mon_cache_memory 151 151 0 0.00 1329 134380 35582 0 0
srv_find_qd_qs_mism 1135308 1135308 0 0.00 0 25890 5 0 0
srv_make_invnt_saldo 557 557 0 0.00 48 15981 941 0 0
srv_make_money_saldo 753 753 0 0.00 1 9407 33 0 0
srv_recalc_idx_stat 4 4 0 0.00 188383 506474 325093 0 0
t$perf-abend:sp_add_invoice_to_stock 111 111 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5167 5167 0 0.00 0 10379 137 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 6010 96 0 0
t$perf-norm:sp_cancel_client_order 1789 1789 0 0.00 0 3958 10 0 0
t$perf-norm:sp_cancel_customer_reserve 712 712 0 0.00 0 3110 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 665 665 0 0.00 0 702 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 645 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 2390 17 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 21878 1453 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 518 3 0 0
t$perf-norm:sp_client_order 20902 20902 0 0.00 0 7029 14 0 0
t$perf-norm:sp_customer_reserve 1031 1031 0 0.00 0 1080 5 0 0
t$perf-norm:sp_pay_from_customer 7362 7362 0 0.00 0 8372 10 0 0
t$perf-norm:sp_pay_to_supplier 5991 5991 0 0.00 0 4989 8 0 0
t$perf-norm:sp_reserve_write_off 10214 10214 0 0.00 0 5531 10 0 0
t$perf-norm:sp_supplier_invoice 5694 5694 0 0.00 0 5150 13 0 0
t$perf-norm:sp_supplier_order 5613 5613 0 0.00 0 7399 13 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 95 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 151 151 0 0.00 0 74 1 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 1086 16 0 0
t$perf-norm:srv_make_money_saldo 753 753 0 0.00 0 707 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 4 0 0
v_add_invoice_to_stock 10552 10330 222 2.10 0 4759 14 0 222
v_all_customers 38792 38792 0 0.00 0 71 0 0 0
v_all_suppliers 31000 31000 0 0.00 0 16 1 0 0
v_all_wares 41804 41804 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 164 5 0 0
v_cancel_client_order 3578 3578 0 0.00 0 3684 5 0 0
v_cancel_customer_prepayment 1330 1330 0 0.00 0 1742 5 0 0
v_cancel_customer_reserve 1424 1424 0 0.00 0 4336 8 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 1737 5 0 0
v_cancel_supplier_invoice 830 812 18 2.16 0 5279 21 0 18
v_cancel_supplier_order 892 892 0 0.00 0 488 3 0 0
v_cancel_write_off 2032 2032 0 0.00 0 2891 12 0 0
v_max_id_clo_ord 5612 5612 0 0.00 0 2151 2 0 0
v_max_id_clo_res 1031 1031 0 0.00 0 1258 10 0 0
v_max_id_ord_sup 5693 5693 0 0.00 0 2887 3 0 0
v_max_non_paid_invoice 1796 1796 0 0.00 0 4075 6 0 0
v_max_non_paid_realizn 3586 3586 0 0.00 0 2412 4 0 0
v_min_id_clo_ord 5612 5612 0 0.00 0 11830 22 0 0
v_min_id_clo_res 1031 1031 0 0.00 0 7202 22 0 0
v_min_id_ord_sup 5693 5693 0 0.00 0 6501 8 0 0
v_min_non_paid_invoice 5991 5991 0 0.00 0 5571 13 0 0
v_min_non_paid_realizn 7362 7362 0 0.00 0 8444 19 0 0
v_our_firm 10564 10564 0 0.00 0 16 1 0 0
v_reserve_write_off 20428 20428 0 0.00 0 4899 5 0 0
x_lock_depdocs_on_canc_invoice 12763 12763 0 0.00 0 14718 101 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 9157 375 0 0
x_make_qstorno_1000_1200 5613 5613 0 0.00 1 41748 1080 0 0
x_make_qstorno_1200_2000 5694 5694 0 0.00 3 89579 2814 0 0
x_make_qstorno_2100_3300 475384 475384 0 0.00 0 49077 144 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-12-2020 01:28:14 to 19-12-2020 01:28:18.

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:07 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 8052 8192000000 10141850032 10438561792 825465472 9.154 67 45 93 0 843213232 2459200 15288560
22:57:31 18162 8192000000 10286183536 10596405248 1322659344 13.901 100 82 165 0 1354673248 4120048 27893856
22:58:01 26650 8192000000 10349696784 10665496576 1396158848 14.561 100 88 176 0 1430067360 5058496 28850016
22:58:35 6385 8192000000 10362586880 10682359808 1423848688 14.807 100 90 180 1 1459567056 6332608 29385760
22:58:50 15050 8192000000 10373649232 10696564736 1435426128 14.909 100 89 177 1 1471046576 6804048 28816400
22:59:16 14124 8192000000 10401745472 10726113280 1459141712 15.118 100 90 180 0 1496176544 7488688 29546144
22:59:40 20726 8192000000 10431106768 10759675904 1473890400 15.248 100 87 174 0 1509792144 7733216 28168528
23:00:08 19338 8192000000 10442981824 10776449024 1494731328 15.430 100 83 166 0 1529768832 8480896 26556608
23:00:41 27535 8192000000 10469855264 10807922688 1514109648 15.599 100 83 165 1 1552484976 13036320 25339008
23:01:19 12637 8192000000 10488302928 10833846272 1542634000 15.846 100 79 158 0 1576607952 9380096 24593856
23:01:42 10447 8192000000 10522000256 10871054336 1579591968 16.165 100 82 164 0 1614303312 10169568 24541776
23:02:09 9649 8192000000 10547438576 10901102592 1601238208 16.350 100 84 169 1 1638302208 11199872 25864128
23:02:31 9786 8192000000 10573953936 10928918528 1623801376 16.542 100 80 160 0 1659653104 12235120 23616608
23:02:50 12655 8192000000 10598142032 10956693504 1656338656 16.818 100 80 160 0 1692886512 13038832 23509024
23:03:11 10915 8192000000 10620593856 10984390656 1675928816 16.983 100 86 172 1 1715666432 13971856 25765760
23:03:30 8225 8192000000 10626442096 10991861760 1683989328 17.051 100 80 161 0 1721069328 13835696 23244304
23:03:46 8065 8192000000 10632499504 11008012288 1702737840 17.208 100 79 158 2 1737976128 12655408 22582880
23:04:03 9140 8192000000 10653769360 11031728128 1715164736 17.312 100 74 146 0 1747480864 11705888 20610240
23:04:21 4140 8192000000 10682264704 11056766976 1737978688 17.502 100 77 152 3 1771511600 11733696 21799216
23:04:32 5133 8192000000 10693128848 11068030976 1752251040 17.620 100 84 168 1 1788168416 12375312 23542064
23:04:45 4857 8192000000 10694212384 11072290816 1765098208 17.727 100 75 148 1 1797103568 11295152 20710208
23:04:57 7769 8192000000 10704117840 11091972096 1773161104 17.793 100 67 131 2 1801297280 10404736 17731440
23:05:13 5819 8192000000 10720741344 11103133696 1780025120 17.850 100 79 156 3 1814183264 11769552 22388592
23:05:25 2464 8192000000 10731180288 11118071808 1799713120 18.012 100 74 147 2 1832670976 11912768 21045088
23:05:35 3154 8192000000 10741295920 11128868864 1803046464 18.039 100 73 146 0 1836514640 12889664 20578512
23:05:45 2705 8192000000 10755443152 11138068480 1812846928 18.119 100 87 172 1 1851289408 13796000 24646480
23:05:54 2627 8192000000 10762742880 11144654848 1820415744 18.181 100 91 179 3 1860198704 15000320 24782640
23:06:03 2381 8192000000 10757490928 11143561216 1819889952 18.177 100 83 166 1 1857949456 14744992 23314512
23:06:12 2112 8192000000 10767626944 11155058688 1831495232 18.272 100 86 171 2 1869749968 14098064 24156672
23:06:21 1578 8192000000 10777070128 11165106176 1837891488 18.324 100 83 166 0 1873648432 12877936 22879008
23:06:29 2064 8192000000 10780420448 11169464320 1840275200 18.343 100 84 168 0 1877653072 13527056 23850816
23:06:38 2490 8192000000 10795019264 11182919680 1848445392 18.409 100 93 186 0 1889453264 14901056 26106816
23:06:47 2169 8192000000 10795590624 11186249728 1850795984 18.429 100 91 181 2 1891155008 14510640 25848384
23:06:55 1735 8192000000 10801944160 11190878208 1859504400 18.499 100 94 188 1 1897820432 13424832 24891200
23:07:04 1552 8192000000 10814393744 11199741952 1861561136 18.516 100 92 184 2 1901315984 14548304 25206544
23:07:12 2032 8192000000 10812461312 11202514944 1866062480 18.552 100 96 189 2 1908138928 14554688 27521760
23:07:21 2284 8192000000 10810110592 11203186688 1866769616 18.558 100 89 178 1 1907012880 14932528 25310736
23:07:29 1112 8192000000 10813943792 11202809856 1870258160 18.586 100 92 187 2 1908684512 12946112 25480240
23:07:37 4561 8192000000 10792079312 11197919232 1869269488 18.578 100 61 122 0 1898125488 11991280 16864720
23:07:49 3116 8192000000 10795547648 11205148672 1868760000 18.574 100 48 97 0 1893208432 11132352 13316080
23:08:00 5254 8192000000 10794547984 11205435392 1870032864 18.585 100 42 84 2 1890579872 9153888 11393120
23:08:12 8943 8192000000 10772339632 11199664128 1870474288 18.588 100 27 54 0 1886081344 7393840 8213216
23:08:27 5496 8192000000 10797936224 11207876608 1873475312 18.612 100 27 53 2 1890913664 9799968 7638384
23:08:40 10880 8192000000 10805217936 11217674240 1887722016 18.727 100 52 104 2 1909103472 6306848 15074608
23:08:59 64338 8192000000 10819424816 11226697728 1879409024 18.660 100 38 73 2 1895571168 5180000 10982144
23:10:10 1928 8192000000 10833738080 11240706048 1895032304 18.786 100 87 178 2 1931443008 10768128 25642576
23:10:20 10947 8192000000 10803267056 11234914304 1886943712 18.721 100 26 52 0 1900841968 6269584 7628672
23:10:40 5844 8192000000 10811547328 11243020288 1892020848 18.762 100 35 66 1 1912483216 11076560 9385808
23:10:54 4172 8192000000 10810025888 11239874560 1895272688 18.788 100 27 53 1 1909508720 6672928 7563104
23:11:05 5021 8192000000 10808415264 11244331008 1895189072 18.788 100 19 38 2 1911465600 11130032 5146496
23:11:16 5260 8192000000 10817795392 11246379008 1897736368 18.808 100 32 64 1 1918068016 10836832 9494816
23:11:30 6020 8192000000 10809806512 11242856448 1899601680 18.823 100 32 65 0 1914597840 5644336 9351824
23:11:44 15703 8192000000 10808331840 11246735360 1898142448 18.811 100 22 44 2 1911070928 6526480 6402000
23:12:06 9363 8192000000 10822569568 11252383744 1905321264 18.869 100 38 76 3 1928096784 10789216 11986304
23:12:25 8109 8192000000 10809867600 11249672192 1903779968 18.857 100 10 20 0 1912444224 5426544 3237712
23:12:42 57886 8192000000 10826227008 11257245696 1906063568 18.875 100 24 49 0 1922202384 9321248 6817568
23:13:52 9975 8192000000 10816322720 11257667584 1909837616 18.905 100 21 42 1 1921301520 5980848 5483056
23:14:08 8913 8192000000 10812497008 11259301888 1912323872 18.925 100 19 38 1 1923429168 5109696 5995600
23:14:25 4947 8192000000 10836069072 11270393856 1916813984 18.961 100 21 42 0 1928973536 6596256 5563296
23:14:39 5024 8192000000 10830590032 11268280320 1921735072 19.001 100 33 65 7 1937911008 7073648 9102288
23:14:51 6861 8192000000 10814473216 11256078336 1895695664 18.792 99 20 40 2 1907703840 6471872 5536304
23:15:04 6924 8192000000 10834529312 11265740800 1898743904 18.816 99 35 70 0 1916073712 7486976 9842832
23:15:18 9767 8192000000 10819049232 11259633664 1896879408 18.801 99 25 49 2 1914406064 10799456 6727200
23:15:34 9815 8192000000 10828264672 11257511936 1908423248 18.894 100 26 52 1 1921687040 5640464 7623328
23:15:53 8455 8192000000 10803172880 11240017920 1855547120 18.467 97 21 42 1 1867530752 6305312 5678320
23:16:07 10996 8192000000 10784808992 11215630336 1815717808 18.143 96 22 42 1 1827259024 5709888 5831328
23:16:24 8733 8192000000 10768474304 11192242176 1817246176 18.155 96 13 26 1 1826099168 5382752 3470240
23:16:40 4391 8192000000 10765780640 11189604352 1837278000 18.319 98 21 42 1 1849212128 5714016 6220112
23:16:50 13970 8192000000 10762728976 11182329856 1740794608 17.525 93 19 38 3 1752448512 5695184 5958720
23:17:12 23301 8192000000 10725602704 11154460672 1779428944 17.845 96 34 65 3 1793936624 4381856 10125824
23:18:02 29324 8192000000 10717789280 11143450624 1665439504 16.895 90 25 50 1 1682399744 9921312 7038928
23:18:39 11288 8192000000 10733988800 11148242944 1734447424 17.472 95 27 54 1 1747965760 6306192 7212144
23:18:57 6224 8192000000 10685173568 11091357696 1709162224 17.262 95 33 67 0 1725309008 6408224 9738560
23:19:09 5915 8192000000 10703516032 11121639424 1730145904 17.437 96 28 56 1 1743808528 5800976 7861648
23:19:26 6234 8192000000 10706227568 11121266688 1774764912 17.806 99 24 48 1 1787641024 5969696 6906416
23:19:39 7471 8192000000 10683795392 11096489984 1743493456 17.548 98 30 60 2 1758540864 6324672 8722736
23:19:56 7537 8192000000 10698279360 11115147264 1745960416 17.568 97 26 52 0 1763833712 10719264 7154032
23:20:10 5838 8192000000 10688535904 11106066432 1781047920 17.858 99 33 66 2 1796619072 5752640 9818512
23:20:22 6479 8192000000 10726340096 11133313024 1773870672 17.799 98 22 44 1 1785154928 4758512 6525744
23:20:36 11673 8192000000 10728923744 11148623872 1779862064 17.848 98 31 61 1 1800202816 10815904 9524848
23:20:58 9500 8192000000 10735276672 11155193856 1807215408 18.073 99 17 34 2 1818107760 5193552 5698800
23:21:16 6695 8192000000 10738162592 11162161152 1824999504 18.219 100 30 60 0 1841252192 7304240 8948448
23:21:30 7810 8192000000 10749642272 11171966976 1829182320 18.253 100 18 36 1 1840035232 5309104 5543808
23:21:46 10495 8192000000 10756215920 11181801472 1843725376 18.371 100 20 39 2 1855384832 5623024 6036432
23:22:03 68087 8192000000 10774547248 11191738368 1851116864 18.431 100 24 48 1 1863918128 5142960 7658304
23:23:17 15404 8192000000 10748435712 11188002816 1849006032 18.414 100 19 38 0 1860888976 6400032 5482912
23:23:41 7112 8192000000 10771347312 11198574592 1856644320 18.476 100 31 62 1 1872053296 6871184 8537792
23:23:58 11578 8192000000 10760556432 11191410688 1849338320 18.417 100 19 38 0 1860266480 5419808 5508352
23:24:15 4566 8192000000 10778452144 11198103552 1859590528 18.500 100 38 77 1 1877685280 7841248 10253504
23:24:26 9092 8192000000 10762862064 11196198912 1857634048 18.484 100 29 57 1 1871634304 5560016 8440240
23:24:41 7912 8192000000 10777328368 11202183168 1860159312 18.505 100 26 51 4 1874045312 5933120 7952880
23:25:01 12199 8192000000 10767209168 11201757184 1858216592 18.489 100 9 18 1 1865846704 5208016 2422096
23:25:20 6998 8192000000 10778365152 11208826880 1863505040 18.532 100 22 44 2 1875971568 5572688 6893840
23:25:36 9972 8192000000 10771401504 11211276288 1866192384 18.553 100 21 42 0 1882516464 9902400 6421680
23:25:55 13353 8192000000 10795848944 11221680128 1873695168 18.614 100 20 40 2 1884805280 5447328 5662784
23:26:18 13976 8192000000 10783045936 11219443712 1873529536 18.613 100 11 21 3 1881632992 5125888 2977568
23:26:40 9985 8192000000 10795199600 11224735744 1879779456 18.663 100 19 38 1 1890216016 5023360 5413200
23:26:57 16103 8192000000 10838293600 11241562112 1885864912 18.712 100 21 42 3 1896564544 5381440 5318192
23:27:21 61131 8192000000 10843563728 11265142784 1919466352 18.983 100 31 61 1 1935265008 5225760 10572896
23:28:31 73504 8192000000 10861655264 11287613440 1936663280 19.120 100 34 67 2 1955958528 9132176 10163072
23:30:19 45873 8192000000 10854067520 11290685440 1933825488 19.097 100 29 57 1 1954659824 12765808 8068528
23:31:14 27533 8192000000 10865349104 11301437440 1941737664 19.161 100 25 50 0 1959829888 10801504 7290720
23:31:50 5653 8192000000 10868070976 11303129088 1941613504 19.160 100 42 82 3 1966734176 13440864 11679808
23:32:02 29493 8192000000 10877009584 11308539904 1927576528 19.047 99 36 73 1 1953861280 16113536 10171216
23:32:40 18069 8192000000 10878469472 11318079488 1950807280 19.233 100 36 72 1 1978754864 17394416 10553168
23:33:05 10400 8192000000 10891973904 11321950208 1956870256 19.281 100 40 81 1 1985049888 16565552 11614080
23:33:24 6966 8192000000 10905070176 11333251072 1963952432 19.337 100 48 96 0 1996713312 18365760 14395120
23:33:40 8135 8192000000 10915853008 11343192064 1974406976 19.420 100 58 114 1 2005142688 14969536 15766176
23:33:56 12049 8192000000 10909719680 11343712256 1968266320 19.372 100 48 95 1 1998113472 15990304 13856848
23:34:17 7403 8192000000 10909911056 11335102464 1966532496 19.358 100 52 104 1 1998503408 17116608 14854304
23:34:34 4423 8192000000 10913980272 11338895360 1967475328 19.365 100 68 134 1 2005590672 18578064 19537280
23:34:50 1328 8192000000 10934568944 11353100288 1980613024 19.470 100 71 142 1 2022234384 20409456 21211904
23:34:58 7978 8192000000 10932154304 11356286976 1979711296 19.462 100 54 108 0 2015656832 20191344 15754192
23:35:15 8370 8192000000 10930181440 11352576000 1977651856 19.446 100 67 133 1 2019726720 21993552 20081312
23:35:31 3840 8192000000 10924860160 11347243008 1974159024 19.418 100 66 132 1 2014856976 20903600 19794352
23:35:42 2048 8192000000 10901676464 11320061952 1954856064 19.265 99 66 131 1 1994955744 20014896 20084784
23:35:51 2965 8192000000 10933308416 11345207296 1972648144 19.406 100 77 153 2 2016741456 21681456 22411856
23:36:01 10032 8192000000 10914748736 11335573504 1963898192 19.337 100 65 129 2 2005855568 23285472 18671904
23:36:18 6063 8192000000 10893801760 11316133888 1925713680 19.033 98 57 112 3 1964828080 22785744 16328656
23:36:32 1760 8192000000 10921746480 11324661760 1940955264 19.154 99 86 171 3 1990189328 23848176 25385888
23:36:43 5234 8192000000 10923324912 11346034688 1970102160 19.386 100 77 154 1 2018894016 26059312 22732544
23:36:56 1328 8192000000 10928153200 11337228288 1961995872 19.322 100 77 153 3 2007680176 23097136 22587168
23:37:04 4876 8192000000 10921052896 11339321344 1962728608 19.328 100 73 145 0 2010058704 25676976 21653120
23:37:19 10239 8192000000 10914406896 11340025856 1926161152 19.036 98 62 124 0 1973134944 28782112 18191680
23:37:37 3270 8192000000 10908821088 11327582208 1945593504 19.191 99 66 132 1 1994021728 28810256 19617968
23:37:48 5973 8192000000 10912852480 11327873024 1948574368 19.215 100 76 151 0 2004155824 33152784 22428672
23:38:02 2256 8192000000 10924733344 11338711040 1961333264 19.317 100 73 147 2 2012701312 29858720 21509328
23:38:12 7183 8192000000 10935279248 11358568448 1973234560 19.411 100 61 122 0 2021826240 30083072 18508608
23:38:28 3082 8192000000 10938191696 11356041216 1962924688 19.329 99 65 130 1 2011769136 28954576 19889872
23:38:39 5642 8192000000 10927702016 11349209088 1958029840 19.290 99 63 124 1 2005967488 28179168 19758480
23:38:53 4402 8192000000 10939404640 11360706560 1972726960 19.407 100 58 116 1 2019205360 28715664 17762736
23:39:06 6232 8192000000 10924708384 11341160448 1954902512 19.266 100 65 129 2 2004766416 30674304 19189600
23:39:22 5807 8192000000 10908752576 11323781120 1945393232 19.190 99 70 140 1 1999136080 31907520 21835328
23:39:36 1854 8192000000 10956129680 11360677888 1976865104 19.440 100 89 176 2 2038550784 34561808 27123872
23:39:45 2199 8192000000 10939202608 11345154048 1960814448 19.313 99 88 173 1 2022877344 35959168 26103728
23:39:54 2894 8192000000 10928689408 11338108928 1942051344 19.163 99 77 154 2 2003725360 37764656 23909360
23:40:04 2519 8192000000 10933521248 11345248256 1944673168 19.184 99 78 155 5 2007967168 39771440 23522560
23:40:15 2805 8192000000 10924387456 11325108224 1928460944 19.055 98 83 165 1 1992795536 39232992 25101600
23:40:27 2596 8192000000 10939811552 11354218496 1955283104 19.269 100 83 166 3 2021134512 40067968 25783440
23:40:37 6080 8192000000 10958588544 11368665088 1975134368 19.426 100 73 146 1 2042308048 43845040 23328640
23:40:54 4560 8192000000 10950809792 11373432832 1975903952 19.432 100 65 130 0 2042911664 45697968 21309744
23:41:05 3144 8192000000 10956423696 11372568576 1972260416 19.403 100 64 128 1 2037411568 44442832 20708320
23:41:17 2550 8192000000 10953172928 11368452096 1972746416 19.407 100 76 152 2 2043446640 46559280 24140944
23:41:27 2214 8192000000 10961443616 11367018496 1965568560 19.350 100 84 165 1 2041057520 48994544 26494416
23:41:37 3575 8192000000 10978906064 11389554688 1975234016 19.427 100 83 166 1 2057419584 56112512 26073056
23:41:47 1524 8192000000 10957308480 11363131392 1961347008 19.317 99 84 168 1 2040494336 52027792 27119536
23:41:56 2367 8192000000 10943630224 11358707712 1953180496 19.252 100 78 154 1 2029338656 51465024 24693136
23:42:05 3859 8192000000 10953911136 11364093952 1962941120 19.329 100 77 152 2 2037745744 50728928 24075696
23:42:15 5271 8192000000 10923089216 11339804672 1929669072 19.064 99 67 133 0 1997921776 47204032 21048672
23:42:28 12522 8192000000 10896194240 11330088960 1903797200 18.857 98 43 86 1 1967466208 48854112 14814896
23:42:52 8233 8192000000 10895936560 11324833792 1910715872 18.912 99 45 90 0 1976411600 50446048 15249680
23:43:18 10176 8192000000 10902151056 11340685312 1934122736 19.100 100 46 92 2 1996506368 46851712 15531920
23:43:35 12267 8192000000 10907891376 11338993664 1932047040 19.083 100 43 86 0 1991822224 45502656 14272528
23:43:56 4272 8192000000 10919739840 11349807104 1947910544 19.210 100 55 109 0 2014235168 48247504 18077120
23:44:19 24053 8192000000 10913749136 11358441472 1954401088 19.262 100 30 60 2 2005825728 40803104 10621536
23:44:54 19315 8192000000 10918836032 11364884480 1954334304 19.261 100 31 62 1 2006244656 41533056 10377296
23:45:25 30957 8192000000 10901910144 11340922880 1887630512 18.727 96 37 74 2 1940600224 40960944 12008768
23:46:05 21603 8192000000 10900589520 11338600448 1885009136 18.706 97 30 60 2 1934570736 39126944 10434656
23:46:34 14592 8192000000 10878914512 11318554624 1905514640 18.871 99 30 60 2 1957024096 41755408 9754048
23:46:56 23811 8192000000 10873969920 11322351616 1888205920 18.731 98 30 58 3 1940873952 42136368 10531664
23:47:28 22482 8192000000 10886801296 11329908736 1906951680 18.882 99 29 57 1 1955208144 37812928 10443536
23:48:08 16607 8192000000 10880456096 11325935616 1909980800 18.906 99 25 49 2 1956341488 37849488 8511200
23:48:42 25811 8192000000 10879216768 11319967744 1912294960 18.925 100 21 42 0 1961645392 41677616 7672816
23:49:15 12812 8192000000 10877649152 11321143296 1891605744 18.759 99 23 46 3 1948586672 47814016 9166912
23:49:34 21122 8192000000 10877792928 11325440000 1898644976 18.815 100 23 46 0 1960059008 52437408 8976624
23:50:07 32416 8192000000 10858380576 11313463296 1860630128 18.508 98 11 22 1 1908526832 43799696 4097008
23:50:52 28941 8192000000 10865088992 11328798720 1915611280 18.952 100 9 18 0 1934080480 16164336 2304864
23:51:27 34974 8192000000 10860177136 11317542912 1909387520 18.902 99 11 22 0 1936118352 22876000 3854832
23:52:08 37069 8192000000 10870058416 11303350272 1873711040 18.614 97 38 76 0 1905629856 20434144 11484672
23:53:03 50713 8192000000 10856833808 11295596544 1882190912 18.683 98 21 41 0 1906265568 17689488 6385168
23:54:04 28594 8192000000 10874347104 11313934336 1928429280 19.054 100 32 62 4 1952123984 14454320 9240384
23:54:41 27523 8192000000 10885084128 11321540608 1932558352 19.087 100 39 78 2 1957575472 13815536 11201584
23:55:19 48188 8192000000 10881965360 11316658176 1933111280 19.092 100 14 28 2 1949531376 10967328 5452768
23:56:17 114129 8192000000 10893346160 11344498688 1930056352 19.067 99 17 34 3 1952229440 16927600 5245488
23:58:34 77256 8192000000 10909360704 11367411712 1962860816 19.329 100 39 78 0 1998439200 24091792 11486592
00:00:04 90509 8192000000 10884725568 11350708224 1927719088 19.049 98 9 18 0 1939780512 9872336 2189088
00:01:46 11375 8192000000 10897592048 11358117888 1972765184 19.407 100 22 43 0 1986908528 7917392 6225952
00:03:00 40069 8192000000 10929891616 11378565120 1987255504 19.522 100 36 69 1 2007330160 9564160 10510496
00:03:55 40270 8192000000 10912398160 11384188928 1988743568 19.534 100 37 73 3 2010571920 10401040 11427312
00:04:42 32199 8192000000 10918788320 11399487488 1990043536 19.544 100 9 18 1 1999671408 7254864 2373008
00:06:09 75157 8192000000 10928379440 11401437184 2003430464 19.650 100 9 18 0 2018771008 12662320 2678224
00:08:16 38207 8192000000 10902288704 11392602112 1973491968 19.413 99 5 9 1 1989008160 14033616 1482576
00:09:01 41956 8192000000 10933812064 11398610944 1993803664 19.574 100 19 38 1 2010735664 11867184 5064816
00:09:52 40173 8192000000 10914228832 11394093056 1978362272 19.452 99 25 50 0 1998798048 13030160 7405616
00:10:47 79890 8192000000 10905291664 11387015168 1950970592 19.234 98 18 36 0 1970175120 13840256 5364272
00:12:23 95461 8192000000 10905154752 11387633664 1949988816 19.226 98 4 8 1 1962742752 11629952 1123984
00:14:21 69297 8192000000 10928571904 11384082432 1964092304 19.339 99 20 40 0 1981518320 11894064 5531952
00:15:52 45302 8192000000 10907727344 11373068288 1943963376 19.178 98 16 31 1 1960665920 12450480 4252064
00:16:51 54519 8192000000 10895905920 11352645632 1858328544 18.490 94 17 34 1 1878523312 15469248 4725520
00:18:01 49673 8192000000 10887092032 11366350848 1921580192 18.999 98 15 30 2 1944400832 18501328 4319312
00:19:04 39523 8192000000 10860609088 11322462208 1875106976 18.626 96 13 26 0 1889320784 10711712 3502096
00:19:50 12075 8192000000 10871458128 11324653568 1929992896 19.067 99 35 70 1 1946510352 7177600 9339856
00:20:12 49564 8192000000 10885833600 11352125440 1944019824 19.179 100 23 46 1 1959921184 9607568 6293792
00:21:08 51277 8192000000 10894628000 11356196864 1940945056 19.154 99 22 44 2 1956926128 10134176 5846896
00:22:25 32353 8192000000 10915309776 11356712960 1911835440 18.921 97 48 96 1 1935408976 10059840 13513696
00:23:06 23107 8192000000 10889897376 11349901312 1947063536 19.203 100 44 88 0 1973878272 14396176 12418560
00:23:40 72087 8192000000 10885007840 11354087424 1896284320 18.796 97 22 44 0 1915106272 12820784 6001168
00:25:09 82262 8192000000 10880039328 11356139520 1950169584 19.228 100 16 33 1 1967596000 12878688 4547728
00:26:53 76677 8192000000 10856386272 11326509056 1880709712 18.671 96 13 26 1 1896443024 12159088 3574224
00:28:15 14537 8192000000 10866806544 11337969664 1942028400 19.163 100 10 16 2 1957465024 13274752 2161872
00:28:36 1663 8192000000 10861829888 11334410240 1938325632 19.133 100 7 14 0 1954872096 14540528 2005936
00:28:55 27466 8192000000 10855708896 11341189120 1926410400 19.038 99 12 24 0 1949076816 19256768 3409648
00:29:50 35015 8192000000 10864216192 11351040000 1946351776 19.197 100 5 10 0 1959782896 12241952 1189168
00:30:31 32123 8192000000 10865069744 11341578240 1952455808 19.246 100 9 18 0 1965630944 11010512 2164624
00:31:14 68002 8192000000 10856609680 11314905088 1839634352 18.338 94 10 20 1 1848470848 6488928 2347568
00:32:29 65154 8192000000 10872023504 11348602880 1921490688 18.999 98 19 38 0 1937495680 10596976 5408016
00:33:40 57599 8192000000 10890531888 11353837568 1910710272 18.912 97 20 38 3 1926484992 10739248 5035472
00:34:46 57051 8192000000 10895710800 11366117376 1933498160 19.095 98 22 45 2 1952119200 12503840 6117200
00:36:14 51171 8192000000 10877265632 11357061120 1931797776 19.081 98 14 28 1 1946938288 10825952 4314560
00:37:14 41949 8192000000 10909637184 11363168256 1932469696 19.087 98 19 38 1 1946330160 8295648 5564816
00:38:13 66318 8192000000 10897767632 11354816512 1913433168 18.934 97 21 42 2 1928925536 9830160 5662208
00:39:28 18776 8192000000 10911658000 11348783104 1945796384 19.193 99 56 111 0 1972850544 12017760 15036400
00:39:53 18795 8192000000 10905228688 11348619264 1926181856 19.036 98 59 120 2 1956441616 14156544 16103216
00:41:07 84811 8192000000 10868947840 11333709824 1867861936 18.567 96 11 22 2 1884564240 13895344 2806960
00:42:41 49467 8192000000 10857647792 11330351104 1885748128 18.711 97 17 34 1 1902257600 11833008 4676464
00:43:37 85522 8192000000 10899063056 11345989632 1874994464 18.625 96 31 61 1 1896966352 13308544 8663344
00:45:10 68977 8192000000 10866885984 11345772544 1905431968 18.870 98 11 22 1 1924286000 16134384 2719648
00:46:30 134380 8192000000 10871941264 11348295680 1903608656 18.855 98 20 40 0 1921867952 12457152 5802144
00:48:58 60438 8192000000 10878825312 11354312704 1941196240 19.156 99 27 54 2 1959857008 10790944 7869824
00:50:20 106800 8192000000 10895219552 11365404672 1941029232 19.155 99 9 16 1 1955748896 12294928 2424736
00:52:53 90326 8192000000 10887168112 11372535808 1954776992 19.265 99 17 34 0 1977817040 17412672 5627376
00:54:34 80193 8192000000 10901569920 11374665728 1954069424 19.259 99 18 36 1 1969939408 10849552 5020432
00:56:01 85388 8192000000 10919594816 11392020480 1974493136 19.421 100 10 20 0 1986844544 9033856 3317552
00:57:44 53354 8192000000 10928409584 11404836864 1979770832 19.463 99 24 48 0 2000752368 14656976 6324560
00:58:44 66025 8192000000 10918155232 11400716288 1961085664 19.315 98 19 38 1 1977323856 11447216 4790976
00:59:58 40739 8192000000 10929153360 11387744256 1948053904 19.211 98 25 50 0 1965638064 11068176 6515984
01:00:48 47189 8192000000 10929024512 11393396736 1970766560 19.392 99 29 56 2 1991500224 13212384 7521280
01:01:45 52116 8192000000 10904068976 11367141376 1934650960 19.104 97 26 52 0 1953057776 11047392 7359424
01:02:50 117587 8192000000 10920823200 11383201792 1912735968 18.929 96 19 38 0 1931077936 12466544 5875424
01:04:53 61492 8192000000 10908790784 11377389568 1933526400 19.095 97 29 58 1 1952980000 11035856 8417744
01:06:01 34772 8192000000 10923616288 11378237440 1982004656 19.481 100 36 72 3 2002223584 10290000 9928928
01:06:48 68902 8192000000 10902337232 11363500032 1864977952 18.544 94 29 58 1 1883097120 9783632 8335536
01:08:04 105084 8192000000 10886876032 11372785664 1881448256 18.677 96 19 37 1 1901467744 14753488 5266000
01:09:55 76471 8192000000 10880741824 11353911296 1909707296 18.904 97 20 40 0 1924290576 9082432 5500848
01:11:26 111110 8192000000 10894239376 11356426240 1926011168 19.035 98 22 44 1 1938896656 6784128 6101360
01:13:23 45180 8192000000 10886855424 11350482944 1950891024 19.234 99 29 58 2 1970811392 12229712 7690656
01:14:20 3318 8192000000 10905901632 11362516992 1971155376 19.395 100 45 90 5 1993529024 9176576 13197072
01:14:39 49611 8192000000 10877050656 11364990976 1937173120 19.124 98 21 42 1 1953388192 9766944 6448128
01:15:35 42372 8192000000 10885590800 11361312768 1948733424 19.216 99 3 6 0 1957050688 7643152 674112
01:16:36 51640 8192000000 10874992656 11353546752 1928670160 19.056 98 10 20 0 1939309072 7887856 2751056
01:17:38 55182 8192000000 10875080864 11362308096 1931474960 19.079 98 15 30 1 1946050640 9877296 4698384
01:18:46 67185 8192000000 10877261056 11341348864 1901710704 18.840 97 20 41 0 1919556080 12211360 5634016
01:20:05 58625 8192000000 10847895360 11320385536 1867689072 18.566 96 18 36 1 1884489344 11695712 5104560
01:21:23 69644 8192000000 10855488816 11320037376 1886383120 18.717 97 15 30 0 1906944336 16278512 4282704
01:23:03 60380 8192000000 10858447792 11317469184 1846874480 18.397 96 19 38 0 1869800960 17034976 5891504
01:24:10 70989 8192000000 10835898352 11294121984 1831508592 18.272 95 23 46 1 1849894384 11674304 6711488
01:25:36 36523 8192000000 10855470352 11309854720 1882433856 18.685 98 40 78 2 1908824272 14387728 12002688
01:26:24 35198 8192000000 10880043392 11335335936 1928508768 19.055 100 28 56 1 1950659408 14352048 7798592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

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

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          248834
MON$OLDEST_ACTIVE               250811
MON$OLDEST_SNAPSHOT             250811
MON$NEXT_TRANSACTION            250811
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                       2041312
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:69: 
:70: mscs-test-161.budzdorov.ru    Sat Dec 19 01:27:05 2020
:71:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:72: 
:73: 
:74: mscs-test-161.budzdorov.ru    Sat Dec 19 01:27:06 2020
:75:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:76: 
:77: 
:78: mscs-test-161.budzdorov.ru    Sat Dec 19 01:27:07 2020
:79:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:80: 
:81: 
:82: mscs-test-161.budzdorov.ru    Sat Dec 19 01:27:08 2020
:83:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:84: 
:85: 
:86: mscs-test-161.budzdorov.ru    Sat Dec 19 01:27:10 2020
:87:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:88: 
--- end of diff output ---

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

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