Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.01.2021 16:34
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 17316308 kB
MemAvailable 31278848 kB
Buffers 0 kB
Cached 14412380 kB
SwapCached 4852 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-31 16:31:41
DTS_END                         2021-01-31 16:31:41.5060
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55956
TRN_ID                          228076
ATT_ID                          620
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: 8819.84 21842 1058381
customer order: creation 161.23 373 19347
customer order: refuse 13.33 355 1600
order to supplier: creation 41.62 1355 4994
order to supplier: removal 3.28 109770 393
invoice (draft): creation 43.07 3876 5168
invoice (draft): removal 51.55 823 6186
invoice accept: apply 38.67 18353 4641
invoice accept: cancel 46.23 859 5548
customer reserve: creation 3607.53 178 432904
customer reserve: removal 4529.12 62 543494
realization accept: apply 76.84 195 9221
realization accept: cancel 87.78 122 10533
payment from customer: creation 54.80 148 6576
payment from customer: removal 5.03 86 604
payment to supplier: creation 45.04 181 5405
payment to supplier: removal 3.27 69 392
service: total inventory turnovers 4.53 1083 544
service: total monetary turnovers 6.14 25 737
service: aggregate perf. data 0.75 23773 90
service: refresh index statistics 0.03 275153 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-01-2021 16:34:46 to 31-01-2021 16:34:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3395
TEST_TIME 2 3470
TEST_TIME 3 4096
TEST_TIME 4 3766
TEST_TIME 5 3885
TEST_TIME 6 3730
TEST_TIME 7 3722
TEST_TIME 8 4100
TEST_TIME 9 4491
TEST_TIME 10 4789
TEST_TIME 11 5598
TEST_TIME 12 5862
TEST_TIME 13 6101
TEST_TIME 14 6155
TEST_TIME 15 6384
TEST_TIME 16 6558
TEST_TIME 17 6521
TEST_TIME 18 6954
TEST_TIME 19 7040
TEST_TIME 20 7542
TEST_TIME 21 7970
TEST_TIME 22 8495
TEST_TIME 23 8503
TEST_TIME 24 8627
TEST_TIME 25 9396
TEST_TIME 26 9407
TEST_TIME 27 10008
TEST_TIME 28 10273
TEST_TIME 29 10358
TEST_TIME 30 10220
TEST_TIME 31 10141
TEST_TIME 32 9953
TEST_TIME 33 9762
TEST_TIME 34 9548
TEST_TIME 35 9310
TEST_TIME 36 9374
TEST_TIME 37 9292
TEST_TIME 38 9143
TEST_TIME 39 9177
TEST_TIME 40 9071
TEST_TIME 41 9182
TEST_TIME 42 9172
TEST_TIME 43 9070
TEST_TIME 44 8988
TEST_TIME 45 8852
TEST_TIME 46 9060
TEST_TIME 47 8941
TEST_TIME 48 8934
TEST_TIME 49 8800
TEST_TIME 50 8789
TEST_TIME 51 8801
TEST_TIME 52 8750
TEST_TIME 53 8746
TEST_TIME 54 8879
TEST_TIME 55 8858
TEST_TIME 56 8806
TEST_TIME 57 8932
TEST_TIME 58 8883
TEST_TIME 59 8918
TEST_TIME 60 8937
TEST_TIME 61 8924
TEST_TIME 62 9047
TEST_TIME 63 9113
TEST_TIME 64 9155
TEST_TIME 65 9124
TEST_TIME 66 9004
TEST_TIME 67 8964
TEST_TIME 68 9001
TEST_TIME 69 8927
TEST_TIME 70 8851
TEST_TIME 71 8872
TEST_TIME 72 8837
TEST_TIME 73 8794
TEST_TIME 74 8797
TEST_TIME 75 8799
TEST_TIME 76 8765
TEST_TIME 77 8694
TEST_TIME 78 8611
TEST_TIME 79 8709
TEST_TIME 80 8704
TEST_TIME 81 8665
TEST_TIME 82 8714
TEST_TIME 83 8732
TEST_TIME 84 8765
TEST_TIME 85 8762
TEST_TIME 86 8739
TEST_TIME 87 8717
TEST_TIME 88 8822
TEST_TIME 89 8830
TEST_TIME 90 8824
TEST_TIME 91 9000
TEST_TIME 92 8959
TEST_TIME 93 8922
TEST_TIME 94 8845
TEST_TIME 95 8804
TEST_TIME 96 8809
TEST_TIME 97 8774
TEST_TIME 98 8783
TEST_TIME 99 8747
TEST_TIME 100 8738
TEST_TIME 101 8661
TEST_TIME 102 8731
TEST_TIME 103 8741
TEST_TIME 104 8753
TEST_TIME 105 8752
TEST_TIME 106 8763
TEST_TIME 107 8835
TEST_TIME 108 8828
TEST_TIME 109 8846
TEST_TIME 110 8843
TEST_TIME 111 8831
TEST_TIME 112 8931
TEST_TIME 113 8935
TEST_TIME 114 8899
TEST_TIME 115 8999
TEST_TIME 116 8938
TEST_TIME 117 8867
TEST_TIME 118 8853
TEST_TIME 119 8853
TEST_TIME 120 8821

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-01-2021 16:34:49 to 31-01-2021 16:34:53.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1459995 1459995 0 0.00 0 32437 6 0 0
doc_list_biud 1459993 1459993 0 0.00 0 34309 29 0 0
sp_add_invoice_to_stock 4727 4641 86 1.81 38 170960 18354 0 86
sp_cancel_adding_invoice 5548 5548 0 0.00 6 57261 859 0 0
sp_cancel_client_order 1600 1600 0 0.00 4 6804 355 0 0
sp_cancel_customer_reserve 543494 543494 0 0.00 1 32502 62 0 0
sp_cancel_pay_from_customer 604 604 0 0.00 2 2935 87 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 2 5279 70 0 0
sp_cancel_supplier_invoice 6194 6186 8 0.12 1 17638 824 0 8
sp_cancel_supplier_order 393 393 0 0.00 8 1229224 109771 0 0
sp_cancel_write_off 10533 10533 0 0.00 1 17691 122 0 0
sp_client_order 19347 19347 0 0.00 4 33115 374 0 0
sp_customer_reserve 432904 432904 0 0.00 0 42996 178 0 0
sp_fill_shopping_cart 29495 29495 0 0.00 1 10948 43 0 0
sp_fill_shopping_cart_clo_res 432901 432901 0 0.00 0 15507 17 0 0
sp_get_clo_for_invoice 4638 4638 0 0.00 0 26140 400 0 0
sp_kill_cost_storno 17077 17077 0 0.00 0 17669 64 0 0
sp_kill_qstorno_ret_qs2qd 1104100 1104100 0 0.00 0 32488 34 0 0
sp_kill_qty_storno 581612 581612 0 0.00 0 34307 72 0 0
sp_lock_selected_doc 19181 19181 0 0.00 0 8190 4 0 0
sp_make_cost_storno 25840 25840 0 0.00 0 32403 61 0 0
sp_multiply_rows_for_pdistr 25839 25839 0 0.00 0 24061 34 0 0
sp_multiply_rows_for_qdistr 19347 19347 0 0.00 0 30541 164 0 0
sp_pay_from_customer 6576 6576 0 0.00 4 32703 149 0 0
sp_pay_to_supplier 5405 5405 0 0.00 4 33561 182 0 0
sp_payment_common 11981 11981 0 0.00 1 23976 54 0 0
sp_qd_handle_on_cancel_clo 1600 1600 0 0.00 0 6795 327 0 0
sp_qd_handle_on_invoice_upd_sts 10185 10185 0 0.00 0 34301 356 0 0
sp_qd_handle_on_reserve_upd_sts 9221 9221 0 0.00 0 32605 59 0 0
sp_reserve_write_off 9221 9221 0 0.00 7 32694 196 0 0
sp_supplier_invoice 5168 5168 0 0.00 6 68760 3877 0 0
sp_supplier_order 4994 4994 0 0.00 5 45656 1356 0 0
srv_aggregate_perf_data 90 90 0 0.00 3377 270698 23774 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 944 151643 33706 0 0
srv_find_qd_qs_mism 1014322 1014322 0 0.00 0 12830 5 0 0
srv_make_invnt_saldo 544 544 0 0.00 42 27604 1083 0 0
srv_make_money_saldo 737 737 0 0.00 1 721 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 62016 450548 275153 0 0
t$perf-abend:sp_add_invoice_to_stock 86 86 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 4641 4641 0 0.00 0 9828 186 0 0
t$perf-norm:sp_cancel_adding_invoice 382 382 0 0.00 0 3777 107 0 0
t$perf-norm:sp_cancel_client_order 1600 1600 0 0.00 0 4311 19 0 0
t$perf-norm:sp_cancel_customer_reserve 647 647 0 0.00 0 7154 35 0 0
t$perf-norm:sp_cancel_pay_from_customer 604 604 0 0.00 0 1678 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 1997 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 367 367 0 0.00 0 5147 37 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 19652 1522 0 0
t$perf-norm:sp_cancel_write_off 938 938 0 0.00 0 1042 4 0 0
t$perf-norm:sp_client_order 19347 19347 0 0.00 0 11802 20 0 0
t$perf-norm:sp_customer_reserve 975 975 0 0.00 0 2325 7 0 0
t$perf-norm:sp_pay_from_customer 6576 6576 0 0.00 0 6467 14 0 0
t$perf-norm:sp_pay_to_supplier 5405 5405 0 0.00 0 8684 14 0 0
t$perf-norm:sp_reserve_write_off 9221 9221 0 0.00 0 8469 15 0 0
t$perf-norm:sp_supplier_invoice 5168 5168 0 0.00 0 11771 24 0 0
t$perf-norm:sp_supplier_order 4994 4994 0 0.00 0 9669 22 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 236 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1133 13 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 1105 29 0 0
t$perf-norm:srv_make_money_saldo 737 737 0 0.00 0 2187 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 9446 9274 172 1.82 0 6211 21 0 172
v_all_customers 35668 35668 0 0.00 0 18 1 0 0
v_all_suppliers 28360 28360 0 0.00 0 93 1 0 0
v_all_wares 38688 38688 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 764 764 0 0.00 0 1396 9 0 0
v_cancel_client_order 3200 3200 0 0.00 0 3399 8 0 0
v_cancel_customer_prepayment 1208 1208 0 0.00 0 2923 13 0 0
v_cancel_customer_reserve 1294 1294 0 0.00 0 3743 11 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 1100 4 0 0
v_cancel_supplier_invoice 750 734 16 2.13 0 2506 24 0 16
v_cancel_supplier_order 786 786 0 0.00 0 2740 8 0 0
v_cancel_write_off 1876 1876 0 0.00 0 5014 24 0 0
v_max_id_clo_ord 4994 4994 0 0.00 0 1741 2 0 0
v_max_id_clo_res 975 975 0 0.00 0 2006 11 0 0
v_max_id_ord_sup 5156 5156 0 0.00 0 9185 7 0 0
v_max_non_paid_invoice 1375 1375 0 0.00 0 3299 7 0 0
v_max_non_paid_realizn 3351 3351 0 0.00 0 3328 4 0 0
v_min_id_clo_ord 4994 4994 0 0.00 0 8319 8 0 0
v_min_id_clo_res 975 975 0 0.00 0 8702 20 0 0
v_min_id_ord_sup 5156 5156 0 0.00 0 9763 9 0 0
v_min_non_paid_invoice 5405 5405 0 0.00 0 23968 41 0 0
v_min_non_paid_realizn 6576 6576 0 0.00 0 22775 42 0 0
v_our_firm 9468 9468 0 0.00 0 16 1 0 0
v_reserve_write_off 18440 18440 0 0.00 0 6215 7 0 0
x_lock_depdocs_on_canc_invoice 11367 11367 0 0.00 0 11839 125 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 8999 439 0 0
x_make_qstorno_1000_1200 4994 4994 0 0.00 1 45586 1274 0 0
x_make_qstorno_1200_2000 5168 5168 0 0.00 3 68737 3718 0 0
x_make_qstorno_2100_3300 432904 432904 0 0.00 0 42992 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-01-2021 16:34:54 to 31-01-2021 16:34:58.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:01:45 6 8192000000 8800798240 8812068864 6918096 0.084 2 1 2 0 7037472 56816 62560
14:01:51 8146 8192000000 10181836512 10479267840 870029664 9.600 70 47 95 0 889798176 2395120 17373392
14:02:07 24021 8192000000 10326396592 10643267584 1348264544 14.132 100 85 170 0 1380029552 4165504 27599504
14:02:41 37899 8192000000 10384737344 10710384640 1428816432 14.851 100 83 166 0 1461138240 5818928 26502880
14:03:31 30721 8192000000 10429917248 10756677632 1481239344 15.312 100 92 184 1 1517123456 7042528 28841584
14:04:14 24755 8192000000 10446903968 10776895488 1497206496 15.452 100 89 178 0 1534040064 8641424 28192144
14:04:46 13969 8192000000 10465905264 10799222784 1517095984 15.625 100 89 178 0 1554307984 9301520 27910480
14:05:18 14245 8192000000 10468338880 10805608448 1525806240 15.701 100 86 173 0 1562097344 9796672 26494432
14:05:41 17945 8192000000 10484005360 10827493376 1546668480 15.881 100 89 178 1 1584176432 10277232 27230720
14:06:07 16801 8192000000 10496416736 10844037120 1561200240 16.007 100 82 165 1 1596741712 10599840 24941632
14:06:30 14541 8192000000 10510731280 10864738304 1573812768 16.115 100 79 156 0 1608010080 10912944 23284368
14:06:52 12279 8192000000 10540960368 10892853248 1597728112 16.320 100 74 148 0 1630304864 10519184 22057568
14:07:13 12610 8192000000 10566924304 10927308800 1630318608 16.598 100 78 156 1 1664855728 11463072 23074048
14:07:35 13019 8192000000 10580928752 10946080768 1645825328 16.729 100 79 158 0 1681221824 12050384 23346112
14:07:55 10450 8192000000 10612214736 10980327424 1671707440 16.948 100 81 163 2 1708012592 12355264 23949888
14:08:17 8121 8192000000 10645645600 11013738496 1698697040 17.174 100 86 172 1 1737220400 12935920 25587440
14:08:33 7800 8192000000 10647536624 11019460608 1711457488 17.281 100 78 155 1 1747724128 13489040 22777600
14:08:48 6550 8192000000 10671256288 11040735232 1727375008 17.414 100 89 176 0 1766590800 13872624 25343168
14:09:06 10285 8192000000 10681935872 11056320512 1739939648 17.518 100 83 166 0 1777682896 13472592 24270656
14:09:24 5848 8192000000 10685387424 11067355136 1747786912 17.583 100 71 143 3 1779783536 11790176 20206448
14:09:41 4977 8192000000 10703680656 11081879552 1766890160 17.741 100 78 156 1 1800023840 11329712 21803968
14:09:53 4479 8192000000 10720428224 11096297472 1777864032 17.832 100 80 159 0 1812831728 12488608 22479088
14:10:04 3900 8192000000 10725677440 11101409280 1783593296 17.879 100 85 171 1 1820795408 13085568 24116544
14:10:15 4196 8192000000 10728508672 11110277120 1789957136 17.931 100 80 156 0 1825592016 13342496 22292384
14:10:27 1719 8192000000 10739838960 11119398912 1800684896 18.020 100 91 180 1 1840173936 12885616 26603424
14:10:35 2684 8192000000 10743848720 11123388416 1802386352 18.033 100 85 170 1 1838467376 12846896 23234128
14:10:44 10182 8192000000 10735216816 11124826112 1808336832 18.082 100 75 150 2 1842085552 12713072 21035648
14:11:01 4296 8192000000 10756072880 11140493312 1817747792 18.159 100 87 174 2 1854056192 12412848 23895552
14:11:12 3472 8192000000 10777951072 11163181056 1834350048 18.295 100 90 180 1 1872577872 12715344 25512480
14:11:22 1687 8192000000 10780762208 11165941760 1840081824 18.341 100 88 178 1 1877867280 13328720 24456736
14:11:30 3466 8192000000 10778450928 11168374784 1840638704 18.346 100 89 179 1 1879108432 14084160 24385568
14:11:40 2085 8192000000 10786101888 11174248448 1844964736 18.381 100 88 176 2 1884314272 14210544 25138992
14:11:49 1778 8192000000 10794881056 11181957120 1851353712 18.433 100 89 179 0 1891099728 14647472 25098544
14:11:57 2118 8192000000 10799562928 11186937856 1854240416 18.457 100 90 180 2 1893105104 13383104 25481584
14:12:05 1543 8192000000 10799692576 11185393664 1856161648 18.472 100 92 185 1 1897405600 14261728 26982224
14:12:13 1357 8192000000 10799630496 11186847744 1857202528 18.481 100 92 184 0 1895989520 13106464 25680528
14:12:21 2240 8192000000 10800317616 11187544064 1860371440 18.506 100 88 172 0 1897711792 12935088 24405264
14:12:31 1931 8192000000 10818588656 11205931008 1871378160 18.595 100 89 179 1 1910058848 13365472 25315216
14:12:39 1846 8192000000 10814930464 11206475776 1872186096 18.602 100 84 169 1 1909243472 13118144 23939232
14:12:47 4084 8192000000 10816715776 11209277440 1877188960 18.642 100 87 174 0 1915986688 13661424 25136304
14:12:58 1149 8192000000 10817733632 11216195584 1878850368 18.656 100 84 168 2 1915401792 12303408 24248016
14:13:09 10536 8192000000 10817214992 11211149312 1879152192 18.658 100 78 157 1 1913048896 11787744 22108960
14:13:26 1282 8192000000 10827551648 11218112512 1885769024 18.712 100 93 186 4 1925204656 13434416 26001216
14:13:38 24052 8192000000 10790732192 11207553024 1875674128 18.630 100 34 68 1 1893173200 7380112 10118960
14:14:10 6601 8192000000 10802335520 11206008832 1878334320 18.652 100 25 50 1 1891886832 6541280 7011232
14:14:23 4074 8192000000 10784919232 11214888960 1878731712 18.655 100 29 58 1 1894477584 7290016 8455856
14:14:34 6274 8192000000 10785906736 11216461824 1882182976 18.683 100 18 36 0 1893795296 6835408 4776912
14:14:50 5092 8192000000 10807267664 11227799552 1891481440 18.758 100 32 64 0 1907303984 7091664 8730880
14:15:01 6544 8192000000 10806942784 11231064064 1892741776 18.768 100 33 66 0 1910067488 7762784 9562928
14:15:14 6467 8192000000 10799506352 11233431552 1893314544 18.772 100 31 62 0 1912590336 10334352 8941440
14:15:27 10169 8192000000 10806785808 11239194624 1894094752 18.779 100 25 50 0 1911227072 10251200 6881120
14:15:44 16479 8192000000 10796156176 11234635776 1896449584 18.798 100 22 44 1 1909458896 6380128 6629184
14:16:09 9842 8192000000 10810367072 11240730624 1901982304 18.842 100 20 40 1 1913817728 6392208 5443216
14:16:25 13382 8192000000 10811521040 11244072960 1899312672 18.821 100 16 32 2 1914774592 10606544 4855376
14:16:44 12272 8192000000 10804282384 11242459136 1903399440 18.854 100 14 28 0 1917942560 10078976 4464144
14:17:03 15239 8192000000 10829952272 11248615424 1905297120 18.869 100 18 36 1 1915949312 5779664 4872528
14:17:27 65077 8192000000 10827030960 11262406656 1909475920 18.902 100 26 51 2 1922884704 5845040 7563744
14:18:38 6712 8192000000 10816891312 11258933248 1910010256 18.907 100 21 41 2 1920932656 5433520 5488880
14:18:53 6329 8192000000 10830915200 11264581632 1914360048 18.942 100 35 70 3 1929868000 6472960 9034992
14:19:06 6353 8192000000 10819950976 11259867136 1916035584 18.955 100 26 50 5 1928988112 5884560 7067968
14:19:19 8109 8192000000 10834436192 11273736192 1919180256 18.980 100 29 59 1 1942944688 13685008 10079424
14:19:33 7020 8192000000 10837601696 11272732672 1919566560 18.983 100 27 54 2 1933040720 5934192 7539968
14:19:47 10426 8192000000 10833646800 11269480448 1917476528 18.967 100 18 36 1 1928219296 5672432 5070336
14:20:04 7840 8192000000 10835057584 11272355840 1919314928 18.981 100 20 40 1 1930875152 6078800 5481424
14:20:21 4817 8192000000 10829714544 11258515456 1894605936 18.783 99 29 60 4 1908870240 6262880 8001424
14:20:32 10276 8192000000 10810219728 11249287168 1873492960 18.613 98 19 37 1 1883966048 5324144 5148944
14:20:49 9997 8192000000 10798202640 11234717696 1844591376 18.378 97 18 36 2 1855727344 5425264 5710704
14:21:10 7635 8192000000 10805416880 11235934208 1869333360 18.579 99 26 52 2 1887423200 11085776 7004064
14:21:24 6442 8192000000 10809658880 11238539264 1887669584 18.727 100 20 41 1 1898325520 4656048 5999888
14:21:39 10325 8192000000 10786840736 11215577088 1815157024 18.138 96 14 28 1 1824262288 5532416 3572848
14:21:56 12934 8192000000 10775025872 11209596928 1830015552 18.259 97 19 38 0 1841710256 6540944 5153760
14:22:17 35007 8192000000 10758137120 11188678656 1768209040 17.752 94 19 38 0 1779021344 4423568 6388736
14:23:13 23906 8192000000 10752874112 11168165888 1794758304 17.971 97 54 108 2 1817936688 6599536 16578848
14:23:45 9244 8192000000 10734242176 11166666752 1802754976 18.037 98 24 48 0 1815802544 6446784 6600784
14:24:04 6658 8192000000 10729683696 11149533184 1781500256 17.862 97 23 46 1 1794893296 7228368 6164672
14:24:19 6525 8192000000 10736606624 11154063360 1809516144 18.092 99 26 52 2 1822738880 6368144 6854592
14:24:31 7324 8192000000 10712569264 11128172544 1742244928 17.537 96 31 61 2 1756386144 4758800 9382416
14:24:47 12670 8192000000 10728390064 11146113024 1780730512 17.855 98 32 64 1 1804014752 14875376 8408864
14:25:06 5998 8192000000 10695791568 11112906752 1749769376 17.600 97 21 42 0 1762017312 5999888 6248048
14:25:20 5836 8192000000 10694234480 11104808960 1748247840 17.587 97 29 59 0 1763694032 5957152 9489040
14:25:33 7355 8192000000 10707688016 11129626624 1770802512 17.774 98 28 54 2 1784498144 6178848 7516784
14:25:46 8687 8192000000 10708617776 11126431744 1764189200 17.719 98 15 30 2 1779299296 9852128 5257968
14:26:01 6636 8192000000 10689687360 11107758080 1722423344 17.372 96 19 37 1 1733640240 5420000 5796896
14:26:16 7012 8192000000 10716533904 11131490304 1781945808 17.866 99 23 46 2 1794148432 5014288 7188336
14:26:29 10352 8192000000 10719631664 11136348160 1782335728 17.869 99 24 48 1 1798960432 9860176 6764528
14:26:48 10157 8192000000 10709092496 11129757696 1793578944 17.961 100 16 32 2 1803918544 5520320 4819280
14:27:06 10710 8192000000 10732413472 11158360064 1820448752 18.181 100 20 39 1 1831671088 5561808 5660528
14:27:23 9213 8192000000 10744401552 11174981632 1831759984 18.274 100 22 44 1 1843838992 6012016 6066992
14:27:39 53556 8192000000 10770743184 11183878144 1843700752 18.371 100 30 60 1 1857673936 5617088 8356096
14:28:45 20668 8192000000 10751746304 11182292992 1829660880 18.257 99 23 46 0 1841639760 5080080 6898800
14:29:13 10430 8192000000 10764536816 11193708544 1848855056 18.413 100 24 48 1 1862202080 5966528 7380496
14:29:29 7367 8192000000 10789626528 11206381568 1854949984 18.462 100 31 62 2 1870233088 7007888 8275216
14:29:44 6264 8192000000 10769897152 11201286144 1858245168 18.489 100 38 75 3 1876738112 7835280 10657664
14:29:57 9656 8192000000 10784988304 11208253440 1857853808 18.486 100 23 46 1 1873967840 9818480 6295552
14:30:12 9023 8192000000 10770105584 11202613248 1862690800 18.525 100 28 56 2 1877521728 6519520 8311408
14:30:29 4237 8192000000 10785938736 11211599872 1864334704 18.538 100 28 56 1 1877640048 5576544 7728800
14:30:41 7799 8192000000 10792387536 11216904192 1871037680 18.593 100 22 44 0 1882471472 5219472 6214320
14:30:57 9670 8192000000 10792931456 11223982080 1872616752 18.605 100 14 28 1 1882079824 5793712 3669360
14:31:13 12233 8192000000 10809230432 11236126720 1891255248 18.756 100 13 26 0 1899503296 4634496 3613552
14:31:34 12908 8192000000 10817683472 11243368448 1897173008 18.804 100 20 38 2 1907601408 4673136 5755264
14:32:00 8813 8192000000 10857812608 11270623232 1917948752 18.970 100 63 124 0 1944328288 7899968 18479568
14:32:16 51324 8192000000 10850904640 11273154560 1923837008 19.018 100 50 100 2 1947573488 9482576 14253904
14:33:27 56082 8192000000 10866287968 11303596032 1940055440 19.147 100 45 90 4 1965404432 11737424 13611568
14:34:33 59366 8192000000 10865691824 11307114496 1945259408 19.189 100 27 54 1 1965241984 12312352 7670224
14:35:39 15917 8192000000 10882580544 11314200576 1952933600 19.250 100 33 66 0 1974343392 11753168 9656624
14:36:45 22773 8192000000 10878482528 11318394880 1942553328 19.167 99 23 46 0 1962527328 13421440 6552560
14:37:21 13524 8192000000 10906689232 11338518528 1966106032 19.355 100 36 72 0 1995177328 18515936 10555360
14:37:44 13178 8192000000 10910962640 11341025280 1970764704 19.392 100 41 82 1 1998535952 15205968 12565280
14:38:04 14771 8192000000 10903181440 11340267520 1972974512 19.409 100 48 96 1 2002726656 15793072 13959072
14:38:29 22561 8192000000 10916981664 11355480064 1983256272 19.490 100 49 97 4 2018219552 19984128 14979152
14:39:13 18737 8192000000 10914940864 11348119552 1959481408 19.302 99 42 84 0 1993717120 21155904 13079808
14:39:42 11686 8192000000 10928137120 11359694848 1980406576 19.468 100 59 118 2 2022966240 24758304 17801360
14:40:06 21497 8192000000 10919228240 11360485376 1979425680 19.460 100 45 90 2 2018128816 24071440 14631696
14:40:41 29407 8192000000 10934600928 11372597248 1984259024 19.498 100 38 72 3 2022205536 25481616 12464896
14:41:22 13005 8192000000 10936769808 11377004544 1989103072 19.537 100 34 68 1 2028649040 27785552 11760416
14:41:43 5668 8192000000 10964060944 11389616128 2003651104 19.652 100 64 123 1 2049046064 26394336 19000624
14:42:00 19939 8192000000 10961621856 11407904768 2007023600 19.678 100 52 104 1 2050935376 27728336 16183440
14:42:31 10020 8192000000 10962122784 11400400896 2010613712 19.706 100 46 92 1 2052029968 26129024 15287232
14:42:49 11029 8192000000 10969399920 11408621568 2013455360 19.729 100 49 95 2 2052612048 25240384 13916304
14:43:08 1446 8192000000 10975923680 11400105984 2010273104 19.704 100 58 114 1 2051529216 23774320 17481792
14:43:18 3239 8192000000 10937836272 11364507648 1954321568 19.261 97 68 136 3 1997458656 23232432 19904656
14:43:30 1206 8192000000 10969487824 11381944320 1993991968 19.575 100 83 166 1 2043778576 25155424 24631184
14:43:39 6276 8192000000 10961227888 11388469248 1999002688 19.615 100 69 139 0 2046020128 26403664 20613776
14:43:54 6787 8192000000 10968746432 11399380992 2007250144 19.680 100 70 140 3 2056921568 29147248 20524176
14:44:09 3601 8192000000 10965431136 11385683968 1990202496 19.545 99 76 152 1 2044183712 31443184 22538032
14:44:19 1810 8192000000 10978245312 11397394432 2002039072 19.639 100 87 169 4 2057555504 30988048 24528384
14:44:28 3705 8192000000 10977890112 11394260992 2003153456 19.648 100 80 156 1 2057150496 30243120 23753920
14:44:40 3029 8192000000 10964958480 11390042112 1985633008 19.509 99 73 144 1 2039232320 32221232 21378080
14:44:50 7893 8192000000 10971742176 11398725632 2005382816 19.665 100 74 145 1 2060339424 33057200 21899408
14:45:05 2105 8192000000 10988079392 11403612160 2011850704 19.716 100 91 180 0 2071288704 32805456 26632544
14:45:19 1510 8192000000 11002472336 11416326144 2019367488 19.775 100 88 176 0 2079454064 33756896 26329680
14:45:28 5991 8192000000 11005653904 11424907264 2020704880 19.786 100 74 145 1 2075596112 33792048 21099184
14:45:42 3946 8192000000 10997411488 11415642112 2020942016 19.788 100 89 175 1 2081489840 35146080 25401744
14:45:54 2097 8192000000 10994829312 11412717568 1998822160 19.613 99 85 170 1 2061022176 37059392 25140624
14:46:05 2048 8192000000 10998387728 11419328512 2020106336 19.781 100 89 175 0 2083034544 37014784 25913424
14:46:15 2748 8192000000 10996207456 11414732800 2015726560 19.747 100 87 174 0 2079244608 37319136 26198912
14:46:25 2239 8192000000 11008827488 11423432704 2027362896 19.838 100 92 181 1 2090143328 36687072 26093360
14:46:34 1743 8192000000 10999543360 11416485888 2018525632 19.769 100 91 181 2 2083191696 37632160 27033904
14:46:44 4095 8192000000 10984550272 11403374592 2001502960 19.635 100 76 152 1 2063414848 38092400 23819488
14:46:56 4922 8192000000 10986684064 11401154560 1998638080 19.612 100 85 168 1 2064143888 39460928 26044880
14:47:10 2592 8192000000 10990012016 11409739776 2008381280 19.689 100 84 166 0 2075049360 41102784 25565296
14:47:22 3015 8192000000 10986241552 11405508608 2004265152 19.656 100 80 159 0 2070622400 41341088 25016160
14:47:33 3457 8192000000 10980381312 11400826880 1996473568 19.595 100 76 152 1 2061805248 40962608 24369072
14:48:00 4630 8192000000 10964719632 11390255104 1985675600 19.510 100 61 122 1 2047589552 42101696 19812256
14:48:12 4546 8192000000 10986088528 11398197248 1989847552 19.543 100 81 162 3 2059631424 43850496 25933376
14:48:23 3715 8192000000 10969697216 11379232768 1975093616 19.426 100 92 181 1 2049987504 46002368 28891520
14:48:40 3551 8192000000 10984942240 11393359872 1986201840 19.514 100 87 174 1 2060746736 46808976 27735920
14:48:57 1915 8192000000 10982814880 11404455936 1997976640 19.607 100 76 151 1 2069215168 47244368 23994160
14:49:07 2367 8192000000 10997203472 11412467712 2000635360 19.628 100 91 181 1 2077996992 49616512 27745120
14:49:17 3216 8192000000 11005995616 11416850432 2002333168 19.641 100 95 188 2 2083976208 51837456 29805584
14:49:26 1976 8192000000 10990409760 11403005952 1999355728 19.618 100 92 183 1 2073876192 46924944 27595520
14:49:36 1688 8192000000 10966339296 11381751808 1950823616 19.233 98 80 161 1 2022815824 46058688 25933520
14:49:45 3762 8192000000 10976507280 11395022848 1985707408 19.510 100 85 169 1 2061246448 48566256 26972784
14:49:58 3003 8192000000 10967320240 11385520128 1974066128 19.418 100 85 170 1 2050827872 50242704 26519040
14:50:08 4062 8192000000 10970909616 11385954304 1959464336 19.302 99 89 178 0 2041100192 53102992 28532864
14:50:21 1772 8192000000 10979789664 11390111744 1973145632 19.410 100 90 178 1 2053358544 52379216 27833696
14:50:31 3456 8192000000 10974861200 11393507328 1974751600 19.423 100 79 158 1 2055336992 55345232 25240160
14:50:43 4157 8192000000 10960780224 11381981184 1968256400 19.372 100 73 144 0 2043941648 52253088 23432160
14:50:55 1911 8192000000 10975431792 11388661760 1974237920 19.419 100 81 162 0 2053719296 53345024 26136352
14:51:05 3793 8192000000 10982561520 11397304320 1976936480 19.440 100 74 148 0 2054954496 53882240 24135776
14:51:17 2563 8192000000 10980324608 11400675328 1986303728 19.515 100 78 152 1 2061226032 49549472 25372832
14:51:29 943 8192000000 10983904960 11391045632 1960658240 19.311 99 90 181 2 2041023008 51236064 29128704
14:51:37 3870 8192000000 10947559008 11355729920 1951213216 19.236 99 79 158 4 2024818256 49886416 23718624
14:51:48 2123 8192000000 10981685856 11390447616 1982541792 19.485 100 90 180 1 2060853504 50106448 28205264
14:51:57 3101 8192000000 10964717808 11385724928 1971149120 19.395 100 74 148 0 2046383488 52083376 23150992
14:52:13 5237 8192000000 10974069392 11395493888 1975242208 19.427 100 71 142 1 2053036096 55116448 22677440
14:52:32 13293 8192000000 10946422256 11390451712 1972124288 19.402 100 41 83 1 2042771856 56332768 14314800
14:53:00 16435 8192000000 10949839536 11398344704 1960347840 19.309 99 35 70 0 2025079072 52879504 11851728
14:53:22 14454 8192000000 10956771984 11387838464 1963139936 19.331 99 43 86 0 2016952176 39270032 14542208
14:53:47 27526 8192000000 10937807952 11391897600 1976119424 19.434 100 37 71 3 2028229856 39911248 12199184
14:54:22 10527 8192000000 10935136144 11381702656 1959450080 19.302 99 30 60 1 2010101728 40616544 10035104
14:54:40 11722 8192000000 10913516368 11360317440 1889835680 18.744 96 31 62 1 1943937360 43335760 10765920
14:55:17 12813 8192000000 10930802992 11376467968 1958522480 19.294 100 41 82 1 2023190304 50634224 14033600
14:55:49 9498 8192000000 10952318624 11395358720 1971590640 19.398 100 35 70 0 2032328688 48549872 12188176
14:56:05 22351 8192000000 10943628080 11404554240 1975988048 19.433 100 30 60 2 2039692512 52718592 10985872
14:56:34 28767 8192000000 10911880896 11372134400 1964504128 19.342 100 24 48 1 2015843824 43089552 8250144
14:57:10 15707 8192000000 10895674592 11355127808 1914623392 18.944 98 19 38 2 1957503120 35934624 6945104
14:57:35 12070 8192000000 10903463536 11363934208 1940855440 19.154 100 19 38 1 1990363552 42501952 7006160
14:57:53 20838 8192000000 10893637152 11355095040 1902359760 18.845 98 19 38 1 1952397280 43122656 6914864
14:58:32 30731 8192000000 10894782208 11360251904 1920402224 18.990 99 15 30 0 1958841968 33078592 5361152
14:59:15 35701 8192000000 10905240144 11330441216 1913594032 18.935 98 26 53 0 1948113296 26457088 8062176
14:59:57 61528 8192000000 10853085632 11318759424 1928547152 19.055 99 38 76 0 1951756352 10923232 12285968
15:01:05 20805 8192000000 10876749360 11331706880 1925267152 19.029 99 25 48 1 1942955312 11044496 6643664
15:01:33 52249 8192000000 10881245184 11348725760 1940677072 19.152 100 13 26 3 1958630880 14581088 3372720
15:02:32 50099 8192000000 10888914352 11353899008 1938329872 19.133 99 22 45 1 1958557968 14790624 5437472
15:04:13 151636 8192000000 10890853552 11336638464 1898378896 18.813 97 34 68 0 1917918656 9739488 9800272
15:06:52 2247 8192000000 10902157936 11327307776 1945467552 19.190 100 84 168 2 1982560352 12450816 24641984
15:07:06 28289 8192000000 10882856624 11349458944 1951826352 19.241 100 38 76 1 1986677296 23985680 10865264
15:07:53 43093 8192000000 10842191680 11304611840 1885759568 18.712 97 15 30 0 1903657872 13767424 4130880
15:09:00 31664 8192000000 10875105168 11328589824 1923362256 19.014 99 37 73 1 1948877456 14047168 11468032
15:09:40 41745 8192000000 10875607760 11334742016 1931284944 19.077 99 31 60 1 1955881968 15214416 9382608
15:10:41 58329 8192000000 10875861312 11337908224 1925401664 19.030 99 20 40 1 1946828752 15236944 6190144
15:11:53 34434 8192000000 10878142416 11337613312 1926712448 19.041 99 21 42 1 1950771584 17735120 6324016
15:12:34 35479 8192000000 10870034224 11348238336 1943649952 19.176 100 8 16 0 1961912816 15979120 2283744
15:13:18 17079 8192000000 10868924352 11346202624 1929952896 19.067 99 9 18 1 1945530608 13248832 2328880
15:14:44 50746 8192000000 10867077456 11330846720 1931812672 19.081 99 16 32 0 1949519088 12841040 4865376
15:15:47 76844 8192000000 10876728896 11343577088 1936581984 19.119 99 27 54 2 1959992912 15178304 8232624
15:17:23 47599 8192000000 10865060672 11355463680 1948735872 19.216 100 8 17 1 1969936800 18634912 2566016
15:18:48 59595 8192000000 10869480000 11350073344 1958845952 19.297 100 15 29 1 1972817520 9732224 4239344
15:19:56 46802 8192000000 10879083952 11359141888 1960637888 19.311 100 4 8 1 1970785392 8936368 1211136
15:21:36 61067 8192000000 10877667216 11352375296 1938218496 19.133 99 4 8 0 1948738448 8902624 1617328
15:22:51 22526 8192000000 10888141392 11350732800 1948191040 19.212 99 20 38 1 1962883392 8985328 5707024
15:23:20 53005 8192000000 10901549648 11369672704 1971549456 19.398 100 19 38 0 1989298576 12545152 5203968
15:24:21 69330 8192000000 10898542624 11377397760 1969986496 19.385 100 14 28 0 1991106736 17203552 3916688
15:25:42 72295 8192000000 10911561856 11377917952 1967435328 19.365 99 22 42 2 1986216784 13472448 5309008
15:27:01 54819 8192000000 10914482944 11378278400 1950953472 19.234 98 32 64 0 1970639040 10030512 9655056
15:28:06 48985 8192000000 10915214848 11390279680 1985398896 19.507 100 22 44 1 2004969088 12579760 6990432
15:29:15 43232 8192000000 10926000784 11365277696 1961470704 19.318 99 36 72 1 1980212992 8166224 10576064
15:30:09 46936 8192000000 10913100176 11377352704 1957303920 19.285 99 35 70 2 1978542112 12047824 9190368
15:31:08 144488 8192000000 10912937024 11383721984 1888513264 18.734 95 15 30 2 1903688704 11452304 3723136
15:33:39 95457 8192000000 10898408944 11365974016 1901436208 18.838 96 9 17 1 1930386752 25998768 2951776
15:35:23 65139 8192000000 10886892640 11363586048 1914196416 18.940 97 5 10 1 1929041840 13424784 1420640
15:36:55 100941 8192000000 10893535472 11349995520 1914891248 18.946 97 42 84 2 1936232112 8566592 12774272
15:38:44 50787 8192000000 10868967488 11351666688 1942884432 19.170 99 31 62 0 1963508960 11918624 8705904
15:39:44 37874 8192000000 10857393888 11335397376 1937588080 19.128 99 7 14 2 1948246992 8737424 1921488
15:40:38 24121 8192000000 10869403280 11339333632 1953426896 19.254 100 17 33 0 1966580736 7697664 5456176
15:41:27 39462 8192000000 10861773616 11331784704 1902531664 18.847 97 13 27 1 1915775776 9437152 3806960
15:42:13 74260 8192000000 10840606816 11305615360 1862417792 18.523 96 19 38 1 1877043568 8995056 5630720
15:43:34 52910 8192000000 10853671776 11313913856 1908639600 18.896 98 38 76 0 1929382720 10146496 10596624
15:44:41 63011 8192000000 10890717728 11335647232 1929845200 19.066 99 17 33 1 1945840560 11224640 4770720
15:45:55 50870 8192000000 10842682528 11320143872 1894086432 18.779 98 12 24 0 1905370256 7709328 3574496
15:47:09 73896 8192000000 10835259840 11300601856 1882688896 18.687 97 19 37 0 1895282688 7437792 5156000
15:48:41 100615 8192000000 10854491168 11333779456 1913120128 18.932 98 18 36 0 1930656368 12667072 4869168
15:50:37 67431 8192000000 10837285664 11302428672 1856156816 18.472 96 6 12 1 1869107968 11159760 1791392
15:51:51 63736 8192000000 10864529344 11325042688 1883694016 18.695 97 23 46 2 1900941888 10163360 7084512
15:53:12 64785 8192000000 10875348304 11356831744 1933470016 19.095 99 27 54 1 1954997856 13958032 7569808
15:54:33 113547 8192000000 10855717936 11326824448 1863728736 18.533 96 11 22 0 1882169344 15442128 2998480
15:56:33 32124 8192000000 10893240496 11350667264 1931656448 19.080 99 33 66 1 1951058816 9972464 9429904
15:57:16 37042 8192000000 10867539280 11329679360 1889994352 18.746 97 31 62 1 1914972448 15935984 9042112
15:58:03 70899 8192000000 10875645520 11337633792 1906918736 18.882 98 20 40 1 1928422240 15836208 5667296
15:59:27 77302 8192000000 10880595808 11340640256 1907683680 18.888 98 19 38 0 1924076032 10771136 5621216
16:00:51 65171 8192000000 10901530416 11370696704 1967202640 19.363 100 13 26 1 1986888528 15886192 3799696
16:02:04 142013 8192000000 10851323168 11325128704 1828125856 18.244 93 9 18 0 1846834944 16541520 2167568
16:04:33 98525 8192000000 10873848928 11335708672 1934735264 19.105 99 35 70 0 1955296640 9969872 10591504
16:06:17 50147 8192000000 10858171584 11317280768 1875513776 18.629 96 25 50 1 1891218672 8672336 7032560
16:07:14 30921 8192000000 10842121008 11309547520 1894192416 18.780 98 14 28 1 1906394528 8461872 3740240
16:07:54 64851 8192000000 10862469088 11339468800 1942743488 19.169 100 19 37 0 1957564112 9486000 5334624
16:09:05 35960 8192000000 10859257056 11342704640 1939409344 19.142 100 4 8 0 1950072304 9854320 808640
16:09:47 14236 8192000000 10858953840 11342659584 1935743488 19.113 100 5 10 0 1950984784 14154384 1086912
16:10:13 15551 8192000000 10858884096 11343323136 1941074144 19.155 100 5 10 1 1956596320 14337072 1185104
16:10:35 68614 8192000000 10847634496 11317895168 1882118880 18.682 97 20 40 3 1900254000 12065776 6069344
16:11:50 79117 8192000000 10857082592 11321712640 1904725856 18.864 98 15 30 0 1926388096 17286096 4376144
16:13:15 80524 8192000000 10880930112 11374981120 1945234272 19.189 100 9 17 1 1967049328 19241552 2573504
16:15:17 59877 8192000000 10853467808 11326328832 1883948768 18.697 97 11 22 1 1899123536 11966208 3208560
16:16:23 47771 8192000000 10871590016 11337281536 1903328224 18.853 98 18 36 0 1920399632 11650624 5420784
16:17:18 79376 8192000000 10857462816 11352559616 1922904032 19.010 99 21 42 0 1944004256 15288256 5811968
16:18:43 95382 8192000000 10882577616 11359080448 1933975456 19.099 99 15 30 0 1951813712 13690720 4147536
16:20:25 43913 8192000000 10894822080 11368636416 1947629168 19.208 99 25 50 2 1964043936 9759488 6655280
16:21:59 26363 8192000000 10913253584 11373137920 1976043072 19.433 100 37 74 2 1996851536 10307840 10500624
16:22:32 70197 8192000000 10904528800 11387142144 1943389488 19.174 98 23 46 1 1964595536 14630496 6575552
16:23:50 97924 8192000000 10931792928 11403788288 1978132368 19.450 100 16 32 0 1994610464 12147856 4330240
16:25:40 40813 8192000000 10914104896 11389427712 1947868288 19.209 98 26 52 2 1972032320 16987504 7176528
16:26:36 26910 8192000000 10902302816 11393134592 1933954144 19.098 98 9 18 0 1958054448 21430544 2669760
16:27:23 99871 8192000000 10902458528 11349528576 1920423232 18.990 98 30 60 1 1941822544 12864688 8534624
16:29:11 31473 8192000000 10878072256 11329990656 1903968544 18.858 97 20 40 0 1918370656 8396816 6005296
16:29:53 78465 8192000000 10852940496 11337994240 1892628704 18.767 97 18 36 2 1914582768 16926928 5027136
16:31:18 30592 8192000000 10466454688 10918760448 1563227888 16.024 81 4 8 0 1580331552 16352288 751376

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 31-01-2021 16:35:00 to 31-01-2021 16:35:31.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 86 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 31-01-2021 16:35:32 to 31-01-2021 16:35:34.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          229820
MON$OLDEST_ACTIVE               230344
MON$OLDEST_SNAPSHOT             230344
MON$NEXT_TRANSACTION            230344
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                       2016256
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.33409 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33409 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33409 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33409 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Sun Jan 31 16:32:08 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Sun Jan 31 16:32:15 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
:14: 
:15: mscs-test-161.budzdorov.ru    Sun Jan 31 16:32:16 2021
:16:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:17: 
--- end of diff output ---

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

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