Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.03.2021 22:27
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17433088 kB
MemAvailable 31540340 kB
Buffers 0 kB
Cached 14219416 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-16 22:27:23
DTS_END                         2021-03-16 22:27:23.4510
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52388
TRN_ID                          242372
ATT_ID                          654
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: 9437.15 23094 1132458
customer order: creation 175.74 403 21089
customer order: refuse 15.12 377 1814
order to supplier: creation 46.52 1388 5582
order to supplier: removal 3.38 103236 406
invoice (draft): creation 47.20 3275 5664
invoice (draft): removal 53.94 784 6473
invoice accept: apply 42.57 18596 5108
invoice accept: cancel 49.10 784 5892
customer reserve: creation 3909.43 185 469132
customer reserve: removal 4782.43 57 573891
realization accept: apply 85.97 179 10316
realization accept: cancel 93.64 109 11237
payment from customer: creation 60.17 108 7220
payment from customer: removal 5.89 90 707
payment to supplier: creation 50.26 111 6031
payment to supplier: removal 3.45 84 414
service: total inventory turnovers 4.60 1065 552
service: total monetary turnovers 6.88 22 825
service: aggregate perf. data 0.84 21244 101
service: refresh index statistics 0.03 309786 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-03-2021 22:28:15 to 16-03-2021 22:28:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2985
TEST_TIME 2 3752
TEST_TIME 3 4217
TEST_TIME 4 4072
TEST_TIME 5 4357
TEST_TIME 6 4204
TEST_TIME 7 4458
TEST_TIME 8 4501
TEST_TIME 9 4704
TEST_TIME 10 5284
TEST_TIME 11 5676
TEST_TIME 12 5774
TEST_TIME 13 6225
TEST_TIME 14 6400
TEST_TIME 15 6839
TEST_TIME 16 6840
TEST_TIME 17 7204
TEST_TIME 18 7232
TEST_TIME 19 7741
TEST_TIME 20 7900
TEST_TIME 21 8263
TEST_TIME 22 8687
TEST_TIME 23 8889
TEST_TIME 24 9057
TEST_TIME 25 9546
TEST_TIME 26 9784
TEST_TIME 27 10257
TEST_TIME 28 10717
TEST_TIME 29 10822
TEST_TIME 30 10659
TEST_TIME 31 10470
TEST_TIME 32 10325
TEST_TIME 33 10126
TEST_TIME 34 10113
TEST_TIME 35 10094
TEST_TIME 36 9884
TEST_TIME 37 9900
TEST_TIME 38 9885
TEST_TIME 39 9699
TEST_TIME 40 10040
TEST_TIME 41 9931
TEST_TIME 42 9797
TEST_TIME 43 9672
TEST_TIME 44 9564
TEST_TIME 45 9812
TEST_TIME 46 9780
TEST_TIME 47 9725
TEST_TIME 48 9692
TEST_TIME 49 9853
TEST_TIME 50 9822
TEST_TIME 51 9853
TEST_TIME 52 9848
TEST_TIME 53 9873
TEST_TIME 54 9838
TEST_TIME 55 10060
TEST_TIME 56 9998
TEST_TIME 57 10024
TEST_TIME 58 9898
TEST_TIME 59 9769
TEST_TIME 60 9742
TEST_TIME 61 9837
TEST_TIME 62 9731
TEST_TIME 63 9690
TEST_TIME 64 9629
TEST_TIME 65 9531
TEST_TIME 66 9578
TEST_TIME 67 9656
TEST_TIME 68 9695
TEST_TIME 69 9667
TEST_TIME 70 9645
TEST_TIME 71 9660
TEST_TIME 72 9705
TEST_TIME 73 9683
TEST_TIME 74 9723
TEST_TIME 75 9739
TEST_TIME 76 9759
TEST_TIME 77 9835
TEST_TIME 78 9800
TEST_TIME 79 9764
TEST_TIME 80 9679
TEST_TIME 81 9664
TEST_TIME 82 9600
TEST_TIME 83 9578
TEST_TIME 84 9629
TEST_TIME 85 9606
TEST_TIME 86 9568
TEST_TIME 87 9529
TEST_TIME 88 9494
TEST_TIME 89 9502
TEST_TIME 90 9552
TEST_TIME 91 9544
TEST_TIME 92 9576
TEST_TIME 93 9616
TEST_TIME 94 9657
TEST_TIME 95 9642
TEST_TIME 96 9658
TEST_TIME 97 9729
TEST_TIME 98 9718
TEST_TIME 99 9706
TEST_TIME 100 9753
TEST_TIME 101 9752
TEST_TIME 102 9729
TEST_TIME 103 9670
TEST_TIME 104 9658
TEST_TIME 105 9595
TEST_TIME 106 9574
TEST_TIME 107 9529
TEST_TIME 108 9484
TEST_TIME 109 9471
TEST_TIME 110 9406
TEST_TIME 111 9415
TEST_TIME 112 9444
TEST_TIME 113 9427
TEST_TIME 114 9403
TEST_TIME 115 9444
TEST_TIME 116 9460
TEST_TIME 117 9476
TEST_TIME 118 9450
TEST_TIME 119 9462
TEST_TIME 120 9437

Performance per minute, chart


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

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 1567065 1567065 0 0.00 0 15387 6 0 0
doc_list_biud 1567065 1567065 0 0.00 0 52648 27 0 0
sp_add_invoice_to_stock 5214 5108 106 2.03 45 176950 18596 0 106
sp_cancel_adding_invoice 5892 5892 0 0.00 5 83711 785 0 0
sp_cancel_client_order 1814 1814 0 0.00 4 12404 377 0 0
sp_cancel_customer_reserve 573891 573891 0 0.00 1 52650 58 0 0
sp_cancel_pay_from_customer 707 707 0 0.00 3 6562 90 0 0
sp_cancel_pay_to_supplier 414 414 0 0.00 3 3590 85 0 0
sp_cancel_supplier_invoice 6479 6473 6 0.09 2 21725 784 0 6
sp_cancel_supplier_order 406 406 0 0.00 6 962802 103236 0 0
sp_cancel_write_off 11237 11237 0 0.00 1 12491 110 0 0
sp_client_order 21089 21089 0 0.00 3 30794 403 0 0
sp_customer_reserve 469132 469132 0 0.00 0 125612 186 0 0
sp_fill_shopping_cart 32327 32327 0 0.00 1 11755 37 0 0
sp_fill_shopping_cart_clo_res 469128 469128 0 0.00 0 18814 14 0 0
sp_get_clo_for_invoice 5103 5103 0 0.00 0 23676 296 0 0
sp_kill_cost_storno 18250 18250 0 0.00 0 9640 56 0 0
sp_kill_qstorno_ret_qs2qd 1165898 1165898 0 0.00 0 52645 31 0 0
sp_kill_qty_storno 615130 615130 0 0.00 0 52648 68 0 0
sp_lock_selected_doc 21192 21192 0 0.00 0 8828 5 0 0
sp_make_cost_storno 28668 28668 0 0.00 0 14605 49 0 0
sp_multiply_rows_for_pdistr 28668 28668 0 0.00 0 15347 28 0 0
sp_multiply_rows_for_qdistr 21089 21089 0 0.00 0 13929 193 0 0
sp_pay_from_customer 7220 7220 0 0.00 4 11678 109 0 0
sp_pay_to_supplier 6031 6031 0 0.00 5 15390 111 0 0
sp_payment_common 13251 13251 0 0.00 1 10745 22 0 0
sp_qd_handle_on_cancel_clo 1814 1814 0 0.00 0 12395 346 0 0
sp_qd_handle_on_invoice_upd_sts 10993 10993 0 0.00 0 31778 316 0 0
sp_qd_handle_on_reserve_upd_sts 10316 10316 0 0.00 0 19623 60 0 0
sp_reserve_write_off 10316 10316 0 0.00 6 19645 180 0 0
sp_supplier_invoice 5664 5664 0 0.00 7 84586 3275 0 0
sp_supplier_order 5582 5582 0 0.00 5 49791 1389 0 0
srv_aggregate_perf_data 101 101 0 0.00 2793 286401 21245 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 388 167576 32103 0 0
srv_find_qd_qs_mism 1083916 1083916 0 0.00 0 15085 5 0 0
srv_make_invnt_saldo 552 552 0 0.00 32 58021 1065 0 0
srv_make_money_saldo 825 825 0 0.00 1 801 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 233673 432637 309787 0 0
t$perf-abend:sp_add_invoice_to_stock 106 106 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5108 5108 0 0.00 0 18981 234 0 0
t$perf-norm:sp_cancel_adding_invoice 413 413 0 0.00 0 8763 165 0 0
t$perf-norm:sp_cancel_client_order 1814 1814 0 0.00 0 963 8 0 0
t$perf-norm:sp_cancel_customer_reserve 653 653 0 0.00 0 762 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 707 707 0 0.00 0 9155 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 414 414 0 0.00 0 1726 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 4789 44 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 20121 1750 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 4376 12 0 0
t$perf-norm:sp_client_order 21089 21089 0 0.00 0 10148 20 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 1343 6 0 0
t$perf-norm:sp_pay_from_customer 7220 7220 0 0.00 0 6045 10 0 0
t$perf-norm:sp_pay_to_supplier 6031 6031 0 0.00 0 9897 13 0 0
t$perf-norm:sp_reserve_write_off 10316 10316 0 0.00 0 5728 11 0 0
t$perf-norm:sp_supplier_invoice 5664 5664 0 0.00 0 12729 25 0 0
t$perf-norm:sp_supplier_order 5582 5582 0 0.00 0 8993 23 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 2918 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 5740 47 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 741 19 0 0
t$perf-norm:srv_make_money_saldo 825 825 0 0.00 0 5546 30 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10414 10202 212 2.03 0 5299 19 0 212
v_all_customers 38288 38288 0 0.00 0 20 1 0 0
v_all_suppliers 31348 31348 0 0.00 0 26 1 0 0
v_all_wares 42176 42176 0 0.00 0 15 1 0 0
v_cancel_adding_invoice 826 826 0 0.00 0 530 6 0 0
v_cancel_client_order 3628 3628 0 0.00 0 3298 5 0 0
v_cancel_customer_prepayment 1414 1414 0 0.00 0 5817 9 0 0
v_cancel_customer_reserve 1306 1306 0 0.00 0 10117 18 0 0
v_cancel_payment_to_supplier 828 828 0 0.00 0 3568 16 0 0
v_cancel_supplier_invoice 760 748 12 1.57 0 4993 25 0 12
v_cancel_supplier_order 812 812 0 0.00 0 4924 19 0 0
v_cancel_write_off 1988 1988 0 0.00 0 4026 17 0 0
v_max_id_clo_ord 5579 5579 0 0.00 0 596 1 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 2620 14 0 0
v_max_id_ord_sup 5659 5659 0 0.00 0 6890 5 0 0
v_max_non_paid_invoice 1595 1595 0 0.00 0 5772 6 0 0
v_max_non_paid_realizn 3899 3899 0 0.00 0 2023 3 0 0
v_min_id_clo_ord 5579 5579 0 0.00 0 2927 5 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 3450 7 0 0
v_min_id_ord_sup 5659 5659 0 0.00 0 6324 6 0 0
v_min_non_paid_invoice 6031 6031 0 0.00 0 8645 14 0 0
v_min_non_paid_realizn 7220 7220 0 0.00 0 4780 11 0 0
v_our_firm 10530 10530 0 0.00 0 13 1 0 0
v_reserve_write_off 20632 20632 0 0.00 0 7207 9 0 0
x_lock_depdocs_on_canc_invoice 11991 11991 0 0.00 0 21063 107 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 13026 320 0 0
x_make_qstorno_1000_1200 5582 5582 0 0.00 2 49766 1307 0 0
x_make_qstorno_1200_2000 5664 5664 0 0.00 3 83488 3146 0 0
x_make_qstorno_2100_3300 469132 469132 0 0.00 0 125596 169 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-03-2021 22:28:24 to 16-03-2021 22:28:28.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:27 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:33 17568 8192000000 10250516128 10559238144 938031120 10.274 73 51 101 1 956080880 2336480 15713280
19:58:00 31028 8192000000 10350841328 10666565632 1398060752 14.578 100 92 184 0 1432717808 5165424 29491632
19:58:41 40220 8192000000 10381272656 10705715200 1430230896 14.863 100 85 170 0 1465286240 7263488 27791856
19:59:32 18287 8192000000 10412598256 10739355648 1454954432 15.082 100 83 165 1 1490083696 8071616 27057648
19:59:59 12417 8192000000 10420622432 10749927424 1478078176 15.285 100 90 180 0 1516093584 8826096 29189312
20:00:22 24212 8192000000 10439962624 10770919424 1485112432 15.346 100 89 178 1 1523763488 9397920 29253136
20:00:54 17751 8192000000 10447211280 10782150656 1495413504 15.436 100 86 172 2 1533083552 9888080 27781968
20:01:21 15194 8192000000 10469724000 10805809152 1518268976 15.635 100 89 178 0 1556916512 10579072 28068464
20:01:48 18487 8192000000 10504838656 10851094528 1549748016 15.908 100 81 162 1 1586076400 11094864 25233520
20:02:17 23687 8192000000 10536771776 10888179712 1587825072 16.235 100 89 178 1 1626597664 11588976 27183616
20:02:50 16101 8192000000 10555203488 10910728192 1619643696 16.507 100 90 180 0 1659157344 12577056 26936592
20:03:14 6674 8192000000 10562057408 10922360832 1624716928 16.550 100 80 159 0 1661826768 13017136 24092704
20:03:32 12346 8192000000 10584455680 10948075520 1642719040 16.703 100 82 164 0 1680717888 13510192 24488656
20:03:56 12246 8192000000 10602617424 10970988544 1664763552 16.889 100 74 148 2 1699501936 13072272 21666112
20:04:17 9423 8192000000 10623660480 10995503104 1674253840 16.969 100 71 141 1 1706973616 12911424 19808352
20:04:37 7106 8192000000 10643067904 11013693440 1700738624 17.191 100 78 154 4 1735758784 12636496 22383664
20:04:51 4974 8192000000 10652017488 11027144704 1714561184 17.307 100 69 137 0 1745798592 11716352 19521056
20:05:07 5341 8192000000 10665986256 11040858112 1732029840 17.452 100 78 153 2 1767350688 13274384 22046464
20:05:21 6376 8192000000 10682229072 11052572672 1740590416 17.524 100 83 166 2 1777597888 13205344 23802128
20:05:35 4475 8192000000 10676560640 11059376128 1747643104 17.582 100 66 131 0 1778239552 12601968 17994480
20:05:47 3109 8192000000 10698033504 11073368064 1757787056 17.666 100 85 170 3 1794431248 12274928 24369264
20:05:57 11941 8192000000 10700964416 11083624448 1764270912 17.720 100 74 147 1 1796625728 11634112 20720704
20:06:20 3477 8192000000 10726209104 11104522240 1773524752 17.796 100 76 152 2 1807431344 12836624 21069968
20:06:31 5414 8192000000 10732237792 11115155456 1791198112 17.942 100 83 167 1 1828920928 13898160 23824656
20:06:43 3999 8192000000 10746883488 11130916864 1805688752 18.061 100 82 164 2 1843347568 14483776 23175040
20:06:55 2568 8192000000 10749258592 11136565248 1811155440 18.105 100 87 175 0 1849119808 13749408 24214960
20:07:04 2180 8192000000 10753052064 11135135744 1816489664 18.149 100 87 176 3 1854168800 13187824 24491312
20:07:13 2614 8192000000 10765013392 11149340672 1827191328 18.236 100 87 175 2 1865256096 14197632 23867136
20:07:22 2091 8192000000 10774762880 11156275200 1831716688 18.273 100 90 180 2 1870854784 13732320 25405776
20:07:31 2088 8192000000 10777228816 11162390528 1836881408 18.315 100 84 167 1 1873860688 13555536 23423744
20:07:40 1533 8192000000 10788572400 11173326848 1845724576 18.387 100 88 174 0 1883687440 13750032 24212832
20:07:47 2749 8192000000 10799608144 11184582656 1854473808 18.458 100 91 183 0 1893669584 14156288 25039488
20:07:57 2446 8192000000 10802774016 11188195328 1855640384 18.468 100 92 184 2 1896045776 14629696 25775696
20:08:06 1724 8192000000 10803819872 11188883456 1858217040 18.489 100 92 183 2 1898123776 13896032 26010704
20:08:14 2278 8192000000 10805337776 11191541760 1859389952 18.498 100 90 180 1 1898657504 13649392 25618160
20:08:23 2010 8192000000 10805998736 11190366208 1863713520 18.533 100 95 189 2 1904269104 13613232 26942352
20:08:31 2742 8192000000 10817525920 11205337088 1869389968 18.579 100 93 184 2 1908844752 13216400 26238384
20:08:40 1482 8192000000 10811401136 11200790528 1871741296 18.598 100 87 175 0 1908414832 12617072 24056464
20:08:48 19898 8192000000 10798593504 11202969600 1869500272 18.580 100 66 130 1 1900194848 12516096 18178480
20:09:24 7555 8192000000 10823301568 11213524992 1873789664 18.615 100 72 143 1 1904327056 10632560 19904832
20:09:38 4387 8192000000 10826720192 11216093184 1880793200 18.672 100 88 176 2 1916538032 10310464 25434368
20:09:49 4011 8192000000 10801011136 11214237696 1877855968 18.648 100 54 106 2 1903806384 11132704 14817712
20:09:59 1860 8192000000 10813319408 11218784256 1883533776 18.694 100 68 135 2 1914159072 11348864 19276432
20:10:10 6097 8192000000 10804133616 11216900096 1880586384 18.670 100 51 101 0 1904317776 10011024 13720368
20:10:23 12968 8192000000 10790130032 11213627392 1875878240 18.632 100 20 39 1 1887472976 6148944 5445792
20:10:42 9497 8192000000 10801769264 11224293376 1883142032 18.690 100 25 50 0 1900195408 10621776 6431600
20:10:59 7796 8192000000 10787853936 11221573632 1884995984 18.705 100 26 52 1 1899227392 6605664 7625744
20:11:15 12416 8192000000 10784567040 11225194496 1885477728 18.709 100 13 27 0 1894467440 5598272 3391440
20:11:35 14327 8192000000 10792479232 11227082752 1889361344 18.741 100 14 28 0 1900410272 6543920 4505008
20:11:56 11966 8192000000 10799857728 11234242560 1893882240 18.777 100 21 42 4 1905608208 5951280 5774688
20:12:14 9829 8192000000 10801499440 11230117888 1893229328 18.772 100 11 19 4 1901790320 5241216 3319776
20:12:31 62244 8192000000 10824127696 11245719552 1901393440 18.837 100 36 72 0 1917482032 5329904 10758688
20:13:39 10522 8192000000 10846399824 11254927360 1908153104 18.892 100 57 116 0 1931413808 6427520 16833184
20:13:57 5936 8192000000 10806926224 11248893952 1900921872 18.834 100 28 56 1 1916929168 8097440 7909856
20:14:10 6217 8192000000 10821868784 11247808512 1902623904 18.847 100 22 43 3 1915774112 6107888 7042320
20:14:23 6006 8192000000 10837944784 11259486208 1909316048 18.901 100 43 86 3 1929535408 7821024 12398336
20:14:36 7046 8192000000 10825619696 11260231680 1908727920 18.896 100 26 52 1 1922466336 6288576 7449840
20:14:51 8272 8192000000 10829547104 11259678720 1912366528 18.926 100 26 48 5 1925265760 5943648 6955584
20:15:06 11916 8192000000 10820221360 11255336960 1896076736 18.795 99 18 34 1 1907058800 5338464 5643600
20:15:24 8919 8192000000 10828956288 11266768896 1914407760 18.942 100 24 47 2 1931469984 10359408 6702816
20:15:40 10932 8192000000 10822293104 11260022784 1913109088 18.932 100 16 32 0 1923450000 5442752 4898160
20:15:57 4548 8192000000 10812769648 11246997504 1894967056 18.786 99 18 36 0 1905922208 5705520 5249632
20:16:09 9726 8192000000 10798990192 11225927680 1849968208 18.422 97 22 44 0 1862030928 6218816 5843904
20:16:25 9060 8192000000 10833353152 11256504320 1907502432 18.887 100 29 59 1 1921867200 5702448 8662320
20:16:43 11028 8192000000 10807026864 11240165376 1884685584 18.703 99 18 35 2 1895898608 5838864 5374160
20:17:00 10436 8192000000 10826339696 11254321152 1903574928 18.855 100 18 34 2 1914185936 5968704 4642304
20:17:17 69360 8192000000 10832666288 11253325824 1876239648 18.635 98 30 57 3 1891204176 5257680 9706848
20:18:32 10081 8192000000 10815707248 11251609600 1907319248 18.885 100 32 65 0 1927659872 11644320 8696304
20:18:50 16576 8192000000 10770578032 11201265664 1777846496 17.832 94 18 36 1 1788440752 5689456 4904800
20:19:17 6351 8192000000 10764642624 11186921472 1823265520 18.204 98 32 64 1 1838937584 6845952 8826112
20:19:33 6453 8192000000 10756466720 11175047168 1788470672 17.919 96 17 32 1 1799140400 5050800 5618928
20:19:46 6340 8192000000 10724241616 11141005312 1743535168 17.548 94 27 54 1 1757975472 5393632 9046672
20:19:58 4893 8192000000 10716825952 11135488000 1761954480 17.701 97 22 44 0 1773959888 5352064 6653344
20:20:11 10736 8192000000 10698036432 11122479104 1727082080 17.411 95 20 39 2 1737465072 5236576 5146416
20:20:28 9222 8192000000 10708027216 11128680448 1727094880 17.411 95 31 62 0 1742115824 6137728 8883216
20:20:43 12761 8192000000 10691713664 11105595392 1686366944 17.071 94 20 40 0 1698127328 5892640 5867744
20:21:02 15741 8192000000 10717538016 11136077824 1769804144 17.765 98 20 40 0 1781602400 6114336 5683920
20:21:24 9984 8192000000 10718793152 11142451200 1783085648 17.875 98 34 69 2 1799616448 5877248 10653552
20:21:40 12577 8192000000 10686199936 11102031872 1676267680 16.986 93 21 42 0 1687375440 4984720 6123040
20:21:59 10564 8192000000 10706939632 11126132736 1773885472 17.799 99 23 46 1 1786663104 6272144 6505488
20:22:19 76493 8192000000 10715391184 11145879552 1764532320 17.722 97 25 50 2 1777247872 4878464 7837088
20:23:42 12801 8192000000 10753470736 11169996800 1833351392 18.287 100 27 54 1 1846683552 5556896 7775264
20:24:05 6403 8192000000 10754304944 11171758080 1817933584 18.161 99 39 78 1 1839513424 9904064 11675776
20:24:19 7080 8192000000 10752426912 11170234368 1835129648 18.301 100 24 48 0 1847906944 5683152 7094144
20:24:35 8538 8192000000 10755366912 11175989248 1821260208 18.188 99 34 67 1 1836809968 6299952 9249808
20:24:50 10249 8192000000 10761944080 11182108672 1839981168 18.341 100 24 47 3 1852155728 5388864 6785696
20:25:09 9295 8192000000 10763106368 11185938432 1844495728 18.377 100 18 36 1 1856269760 6578064 5195968
20:25:25 8404 8192000000 10766485872 11190599680 1851827232 18.437 100 28 55 1 1866100208 5078704 9194272
20:25:40 6866 8192000000 10777429200 11199541248 1858227664 18.489 100 33 67 1 1873975472 5719856 10027952
20:25:55 13207 8192000000 10778591280 11202215936 1860089424 18.504 100 26 52 1 1873106160 5068496 7948240
20:26:17 9109 8192000000 10791557232 11208998912 1865074736 18.544 100 33 66 2 1880300624 5161824 10064064
20:26:35 10725 8192000000 10771777104 11205656576 1863611552 18.533 100 15 31 1 1872903120 4832928 4458640
20:26:53 9526 8192000000 10789873248 11211022336 1867493760 18.564 100 15 30 2 1877664656 5242896 4928000
20:27:11 43295 8192000000 10815443408 11234516992 1890156848 18.747 100 21 42 1 1900367888 4387824 5823216
20:28:13 51791 8192000000 10825386816 11257942016 1908410736 18.894 100 35 70 1 1925134112 7072624 9650752
20:29:15 38367 8192000000 10847825760 11280850944 1927987312 19.051 100 47 94 1 1949338928 8333248 13018368
20:30:06 37774 8192000000 10869020448 11297951744 1940075200 19.147 100 44 88 1 1963755440 10839920 12840320
20:30:54 5110 8192000000 10886408976 11311767552 1945694928 19.192 100 46 92 0 1970541968 10953824 13893216
20:31:06 12026 8192000000 10889467424 11312340992 1950054896 19.227 100 56 112 1 1979610384 12655984 16899504
20:31:28 38919 8192000000 10894160448 11319455744 1953968064 19.258 100 44 88 2 1981874144 14122512 13783568
20:32:15 13765 8192000000 10890790880 11323408384 1955594464 19.271 100 42 82 1 1981914928 14424368 11896096
20:32:36 31511 8192000000 10894826000 11331698688 1957379232 19.285 100 36 72 0 1984460864 15829488 11252144
20:33:21 5305 8192000000 10893842368 11329343488 1965689168 19.351 100 50 100 3 1996189056 14946784 15553104
20:33:35 14396 8192000000 10912066064 11342708736 1969904672 19.385 100 44 88 0 1998374800 15682928 12787200
20:33:58 10906 8192000000 10919264960 11348488192 1975107840 19.426 100 53 106 1 2011475616 19897744 16470032
20:34:18 15360 8192000000 10919199632 11353784320 1977582000 19.446 100 49 98 0 2013681984 21843840 14256144
20:34:42 9305 8192000000 10927369440 11354263552 1979632272 19.462 100 55 108 1 2015019136 20436336 14950528
20:35:03 3672 8192000000 10942154608 11361050624 1984621856 19.501 100 60 117 4 2022178912 20932288 16624768
20:35:16 6652 8192000000 10940212528 11366207488 1987743616 19.526 100 61 122 1 2027659872 22355760 17560496
20:35:40 7236 8192000000 10930990416 11360137216 1968453760 19.373 99 57 115 0 2011188800 26102336 16632704
20:35:54 9502 8192000000 10932651456 11360296960 1986413920 19.515 100 66 132 0 2033219104 26848784 19956400
20:36:12 10044 8192000000 10934245616 11364814848 1970352208 19.388 99 64 126 2 2016970256 27041344 19576704
20:36:30 23747 8192000000 10943745216 11376209920 1982761536 19.487 100 49 98 0 2024017440 26857472 14398432
20:37:06 4546 8192000000 10956387712 11384328192 1994540432 19.580 100 48 94 1 2037066544 27808496 14717616
20:37:19 12953 8192000000 10944688208 11368845312 1972500432 19.405 99 55 110 1 2014605552 25360976 16744144
20:37:38 4724 8192000000 10943650240 11368853504 1986929920 19.520 100 67 132 1 2033367984 26770016 19668048
20:37:50 5629 8192000000 10957007888 11379994624 1994368352 19.578 100 70 140 1 2044127904 28922320 20837232
20:38:11 8491 8192000000 10963180400 11388780544 2001717744 19.636 100 61 122 1 2053297808 32581056 18999008
20:38:26 3750 8192000000 10966060128 11396411392 2005683008 19.668 100 66 132 1 2058449888 32729920 20036960
20:38:42 2121 8192000000 10973191008 11395244032 2008134704 19.687 100 81 163 0 2065667440 33537952 23994784
20:38:53 1176 8192000000 10984792688 11394789376 2007413008 19.681 100 89 179 0 2065837632 31967056 26457568
20:39:01 8366 8192000000 10977902704 11397226496 2008141856 19.687 100 74 146 0 2063418560 33654448 21622256
20:39:19 3889 8192000000 10974064912 11398643712 2009388192 19.697 100 69 138 0 2063423680 33115152 20920336
20:39:30 5000 8192000000 10973289104 11398152192 2006812080 19.676 100 77 154 0 2064237408 34133904 23291424
20:39:44 5257 8192000000 10982272720 11406979072 2012963728 19.725 100 70 140 1 2069849136 35488176 21397232
20:39:57 4703 8192000000 10989283472 11411931136 2014879856 19.740 100 78 156 2 2074222272 35167584 24174832
20:40:10 3757 8192000000 10994492080 11415916544 2017224352 19.758 100 81 158 0 2078424128 36854880 24344896
20:40:20 1474 8192000000 10995674768 11406225408 1998182512 19.608 99 87 174 0 2062629920 38356848 26090560
20:40:29 4434 8192000000 10982782080 11411111936 2010868032 19.708 100 67 134 2 2069062896 38275104 19919760
20:40:41 5067 8192000000 10969934160 11395993600 1996799024 19.597 100 61 122 0 2054226704 38388176 19039504
20:40:53 1574 8192000000 10974404896 11396915200 1997993600 19.607 100 70 140 1 2058266896 38943712 21329584
20:41:03 3132 8192000000 10979185296 11402936320 2003096416 19.647 100 71 142 0 2062713904 37597280 22020208
20:41:13 2601 8192000000 10972083600 11394260992 1997273024 19.601 100 76 149 2 2057779712 37970544 22536144
20:41:24 3544 8192000000 10997656336 11412934656 2012159616 19.719 100 82 162 1 2075959136 38508192 25291328
20:41:37 4488 8192000000 11005950192 11425951744 2018007664 19.764 100 81 163 0 2083519680 40184416 25327600
20:41:53 10509 8192000000 11000111024 11425763328 2004455904 19.658 99 70 140 1 2065600272 40049664 21094704
20:42:12 7932 8192000000 10990443312 11414667264 2009187936 19.695 100 73 146 2 2073077856 41753872 22136048
20:42:26 1527 8192000000 11004157712 11421298688 2020822448 19.787 100 84 166 4 2085164768 39303632 25038688
20:42:35 2808 8192000000 10993234176 11411083264 2012219696 19.719 100 78 157 2 2077454224 40296368 24938160
20:42:46 3931 8192000000 11001120720 11424583680 2017374624 19.760 100 80 160 2 2081164496 39361648 24428224
20:42:58 8173 8192000000 10977338064 11398082560 1992133936 19.561 99 79 157 2 2055113792 39038000 23941856
20:43:16 3737 8192000000 10965588272 11398168576 1979150672 19.458 99 60 117 0 2036640896 39445056 18045168
20:43:34 2861 8192000000 10956337312 11377434624 1973112688 19.410 99 68 137 0 2036501776 42111712 21277376
20:43:43 3756 8192000000 10987435136 11405262848 2000404288 19.626 100 80 158 2 2068275456 43143248 24727920
20:43:55 2356 8192000000 10980639520 11403489280 1997782800 19.605 100 71 143 0 2063285696 43795776 21707120
20:44:04 3610 8192000000 10960112432 11385237504 1980406736 19.468 99 69 138 2 2047273552 45445744 21421072
20:44:15 3383 8192000000 11003100112 11419058176 2003667904 19.652 100 80 159 0 2079320528 51132560 24520064
20:44:25 2640 8192000000 10975316736 11390480384 1985342032 19.507 100 87 173 1 2057785360 45241536 27201792
20:44:35 2961 8192000000 10958818976 11371327488 1950031920 19.227 98 85 166 3 2020059232 45832176 24195136
20:44:45 7202 8192000000 10977281504 11395919872 1992726256 19.565 100 88 176 2 2062426000 42425232 27274512
20:45:02 4509 8192000000 10975288288 11399401472 1979402160 19.460 99 74 148 1 2044707872 42703984 22601728
20:45:20 4801 8192000000 10978035696 11398361088 1990614256 19.549 100 70 141 3 2056366080 43868400 21883424
20:45:33 1909 8192000000 10988638224 11405000704 1996761072 19.597 100 88 177 1 2073832192 48817440 28253680
20:45:42 2593 8192000000 10971752784 11394101248 1984486416 19.500 100 75 149 0 2056636352 48631136 23518800
20:45:51 3257 8192000000 10976369728 11388465152 1975146992 19.426 100 91 180 1 2054372768 50624256 28601520
20:46:04 1935 8192000000 10971102096 11390726144 1977045888 19.441 100 76 152 1 2052229376 51042736 24140752
20:46:13 10436 8192000000 10928713696 11372498944 1937659760 19.128 98 50 100 3 2001307872 47526944 16121168
20:46:35 10943 8192000000 10926553424 11372421120 1953964352 19.258 100 43 86 1 2016444304 48209536 14270416
20:46:57 13402 8192000000 10935140960 11374649344 1952248320 19.244 100 35 69 0 2016148928 52199936 11700672
20:47:19 13368 8192000000 10916069808 11363622912 1915983200 18.955 98 33 66 0 1979325776 51886640 11455936
20:47:39 15614 8192000000 10938809888 11384266752 1952296992 19.245 100 40 80 0 2019059856 53165984 13596880
20:48:05 3704 8192000000 10972854560 11397410816 1977111696 19.442 100 63 125 0 2049329184 51100752 21116736
20:48:16 4256 8192000000 10971624416 11405484032 1985572160 19.509 100 62 124 1 2058328464 52785008 19971296
20:48:32 10014 8192000000 10934247456 11381944320 1939951552 19.146 98 35 70 0 2002212960 50582928 11678480
20:48:53 10646 8192000000 10940631056 11384901632 1958751328 19.296 100 41 82 0 2021687232 50055760 12880144
20:49:12 4031 8192000000 10929134368 11368824832 1953509056 19.254 100 74 143 1 2022337024 46310736 22517232
20:49:27 11289 8192000000 10913991680 11359690752 1948592080 19.215 100 34 66 1 2001896880 42105824 11198976
20:49:46 17741 8192000000 10887869616 11340779520 1896950688 18.802 97 26 52 0 1950414448 43626048 9837712
20:50:27 21554 8192000000 10909105008 11356045312 1938102176 19.132 100 22 43 1 1987065504 41675792 7287536
20:51:01 11621 8192000000 10928387328 11377438720 1956081904 19.275 100 28 56 1 2012562256 47230048 9250304
20:51:23 21334 8192000000 10907457200 11351044096 1934818896 19.105 99 28 57 0 1983790528 39683424 9288208
20:51:58 9622 8192000000 10908514128 11339231232 1931807392 19.081 99 45 91 1 1987517136 41403776 14305968
20:52:18 9368 8192000000 10896662480 11359617024 1942349600 19.166 100 26 52 0 1989877168 38749632 8777936
20:52:50 22726 8192000000 10905804656 11363950592 1946859440 19.201 100 19 38 2 1987099136 33903648 6336048
20:53:32 23406 8192000000 10858617424 11314077696 1910472864 18.910 99 20 40 3 1948185328 30379584 7332880
20:54:09 50646 8192000000 10854618176 11316748288 1875465808 18.628 97 36 72 2 1927001792 39769168 11766816
20:55:06 51298 8192000000 10842383072 11319181312 1859156320 18.496 97 9 18 0 1883221216 21505952 2558944
20:56:03 60708 8192000000 10858689680 11314618368 1904336448 18.861 99 11 22 0 1922172352 14730896 3105008
20:57:10 91037 8192000000 10894669456 11344338944 1927994864 19.051 99 28 54 1 1942837088 7129584 7712640
20:58:48 30426 8192000000 10907099584 11348025344 1945367296 19.190 99 39 78 0 1965765744 9310800 11087648
20:59:33 95997 8192000000 10915843744 11351867392 1961232304 19.316 100 35 70 2 1979737440 8415952 10089184
21:01:18 29863 8192000000 10902947536 11341910016 1943176864 19.172 99 39 78 3 1961904032 7797920 10929248
21:01:54 41441 8192000000 10890152016 11344818176 1944008960 19.179 99 45 90 1 1970690720 13556896 13124864
21:02:44 91882 8192000000 10887316128 11322007552 1892069552 18.762 96 44 86 1 1916045504 11916944 12059008
21:04:22 15058 8192000000 10895919712 11343765504 1959683984 19.304 100 39 76 2 1984230928 13697712 10849232
21:04:47 29915 8192000000 10889849616 11354062848 1968382384 19.373 100 19 38 1 1985742736 11615152 5745200
21:05:30 29727 8192000000 10906059472 11359277056 1958042240 19.290 99 28 55 2 1980151104 13915888 8192976
21:06:12 58275 8192000000 10920085984 11380936704 1987249312 19.522 100 44 89 0 2015812448 15392096 13171040
21:07:24 31474 8192000000 10891371792 11372470272 1958335488 19.293 99 8 16 0 1972036576 11513664 2187424
21:08:30 58145 8192000000 10890437712 11354931200 1930083248 19.068 97 11 22 0 1942521904 9253104 3185552
21:09:37 167560 8192000000 10909903984 11386789888 1982095040 19.481 100 20 40 0 2003071648 14500336 6476272
21:12:36 32493 8192000000 10899899088 11381608448 1981704400 19.478 100 6 12 1 1993884992 10479392 1701200
21:13:14 46171 8192000000 10909413232 11390324736 1993097664 19.568 100 14 28 0 2006776096 9872688 3805744
21:14:38 30664 8192000000 10933172816 11390582784 1997649200 19.604 100 30 60 1 2017353968 10201472 9503296
21:15:15 13857 8192000000 10941371072 11395076096 2004843872 19.661 100 45 91 1 2030805392 12974672 12986848
21:15:36 45653 8192000000 10910427504 11380842496 1960107008 19.307 98 21 42 1 1981140064 14639440 6393616
21:16:29 57811 8192000000 10919702608 11379978240 1974707280 19.423 99 22 44 2 1991664656 10412896 6544480
21:17:38 64778 8192000000 10926589696 11388383232 1953557680 19.255 98 19 38 0 1967993936 9425104 5011152
21:19:28 41862 8192000000 10929282656 11406348288 2008087408 19.686 100 23 46 3 2024611136 10044640 6479088
21:20:20 101556 8192000000 10944199760 11412090880 1974428128 19.421 98 17 33 1 1995534208 16590320 4515760
21:22:14 157193 8192000000 10899300224 11376279552 1900848816 18.833 95 14 28 0 1924606080 19579104 4178160
21:24:57 79405 8192000000 10901066832 11355996160 1922403392 19.006 97 24 48 0 1936693008 7374624 6914992
21:26:41 42237 8192000000 10894991168 11364618240 1955205392 19.268 98 31 62 1 1979109152 13706688 10197072
21:27:36 73879 8192000000 10897155088 11370008576 1930469088 19.071 97 21 42 1 1956019088 19571552 5978448
21:28:56 49775 8192000000 10933305248 11385167872 1990039232 19.544 100 38 73 4 2010382288 9853888 10489168
21:29:53 15597 8192000000 10936713136 11395780608 1996887680 19.598 100 40 80 1 2022954272 14936016 11130576
21:30:15 72919 8192000000 10899913648 11373686784 1903850864 18.857 95 32 64 0 1931386368 17965376 9570128
21:31:47 47785 8192000000 10880799632 11355578368 1931837408 19.082 98 14 28 1 1955233408 19368032 4027968
21:32:41 29753 8192000000 10878035744 11347992576 1915274432 18.949 98 10 20 0 1938866592 20588528 3003632
21:33:18 54761 8192000000 10880862784 11362672640 1913319648 18.933 98 13 26 1 1937710512 20574544 3816320
21:34:58 30777 8192000000 10867407488 11329658880 1892956320 18.770 97 16 32 0 1912928336 15204096 4767920
21:35:36 30303 8192000000 10847212672 11304513536 1836137008 18.309 94 23 46 0 1853202464 10482576 6582880
21:36:17 42696 8192000000 10840512864 11296165888 1827159984 18.236 95 24 48 1 1843615056 9651776 6803296
21:37:27 42946 8192000000 10875177808 11323891712 1906477248 18.878 99 41 82 0 1934504304 16214736 11812320
21:38:21 40630 8192000000 10835030592 11293929472 1850531552 18.426 97 25 50 0 1872031408 14602192 6897664
21:39:13 36029 8192000000 10840810704 11298086912 1876085776 18.633 98 31 62 1 1898428272 13870656 8471840
21:40:00 47577 8192000000 10827654704 11284418560 1849040832 18.414 97 14 28 0 1862569344 9496240 4032272
21:40:58 56515 8192000000 10849703264 11301052416 1834046576 18.292 96 21 42 1 1852932704 13067888 5818240
21:42:04 28752 8192000000 10906602672 11325247488 1927240576 19.045 100 48 97 1 1953715200 12788960 13685664
21:42:45 32413 8192000000 10888229760 11344060416 1933575504 19.095 100 41 82 2 1959124688 14180912 11368272
21:43:26 18704 8192000000 10882101888 11331985408 1935417968 19.110 100 34 69 0 1961322144 16296832 9607344
21:43:52 80708 8192000000 10874628432 11345391616 1904466192 18.862 98 21 42 0 1924576656 14428656 5681808
21:45:19 31267 8192000000 10881489984 11325341696 1903917632 18.858 98 26 52 2 1920436240 9083232 7435376
21:45:58 35291 8192000000 10889720976 11331256320 1920247184 18.989 99 37 74 0 1945201792 14982016 9972592
21:46:43 87438 8192000000 10860896192 11324637184 1894478256 18.782 98 36 72 3 1916232192 11938400 9815536
21:48:17 62424 8192000000 10877381008 11336728576 1931020272 19.075 100 25 50 1 1947512320 9214704 7277344
21:49:28 16440 8192000000 10887770352 11342659584 1947813104 19.209 100 44 87 2 1972908192 12726608 12368480
21:49:51 34580 8192000000 10887346192 11349176320 1949922416 19.226 100 36 71 3 1975873424 16358144 9592864
21:51:04 77298 8192000000 10851490304 11350224896 1899938880 18.826 98 6 12 0 1924821184 23371968 1510336
21:52:27 7539 8192000000 10853761568 11349508096 1929950048 19.066 100 7 14 0 1950659264 19076000 1633216
21:52:42 2184 8192000000 10853341936 11349815296 1929167648 19.060 100 2 4 0 1948226000 18713856 344496
21:52:50 388 8192000000 10854233648 11350859776 1930741344 19.073 100 2 4 0 1949599392 18513552 344496
21:52:57 1517 8192000000 10856391600 11353997312 1933910576 19.098 100 6 13 0 1953779264 18377856 1490832
21:53:05 65526 8192000000 10839574416 11315712000 1881351056 18.676 97 12 25 1 1892219008 7378896 3489056
21:54:28 61305 8192000000 10846832608 11325313024 1876350896 18.636 97 8 16 0 1887142704 8629552 2162256
21:55:35 86686 8192000000 10865070864 11338387456 1898599856 18.815 98 18 36 2 1913526192 9169584 5756752
21:57:28 89404 8192000000 10892278352 11348824064 1914778752 18.945 98 23 45 0 1944934112 23709008 6446352
21:59:06 57556 8192000000 10894553424 11361812480 1917942704 18.970 98 25 50 0 1938819824 14006112 6871008
22:00:15 57223 8192000000 10900929168 11380166656 1968645936 19.375 100 20 40 1 1985909056 11480112 5783008
22:01:19 54340 8192000000 10915847392 11384045568 1975704480 19.431 100 17 34 1 1995244288 14643392 4896416
22:02:19 47554 8192000000 10907265920 11382669312 1965553936 19.350 99 22 44 2 1984043856 12705376 5784544
22:03:13 33761 8192000000 10929146704 11393798144 1980445296 19.468 100 21 42 0 2000755632 13873840 6436496
22:03:53 34066 8192000000 10916404000 11389358080 1946264240 19.197 98 25 48 2 1971689520 18699824 6725456
22:04:41 91424 8192000000 10928865344 11385372672 1942563616 19.167 98 16 32 0 1960783568 14437424 3782528
22:06:20 50413 8192000000 10911633344 11379077120 1925459136 19.031 97 37 74 1 1946156784 10041408 10656240
22:07:27 115748 8192000000 10902227904 11379761152 1914134896 18.940 97 13 26 0 1937641712 20584176 2922640
22:09:29 103673 8192000000 10913839232 11390324736 1983972672 19.496 100 22 44 0 2005291264 14780096 6538496
22:11:21 84721 8192000000 10879215888 11363561472 1946804592 19.201 98 11 22 0 1960527120 11123824 2598704
22:12:52 3180 8192000000 10893460720 11380121600 1974783616 19.423 100 1 2 0 1985206752 10361008 62128
22:13:02 9638 8192000000 10904460960 11380723712 1963926144 19.337 99 22 44 2 1981148848 10194304 7028400
22:13:20 65632 8192000000 10896939408 11379802112 1925496832 19.031 97 17 32 0 1939672608 10185760 3990016
22:14:47 95631 8192000000 10895350768 11376164864 1906726864 18.880 96 12 24 0 1918024384 7887808 3409712
22:16:28 50009 8192000000 10894516864 11374723072 1960744208 19.312 99 14 28 1 1973924432 8764512 4415712
22:17:25 55974 8192000000 10910510624 11397505024 1976897088 19.440 100 8 16 0 1993127168 13777360 2452720
22:18:40 51890 8192000000 10886758160 11376660480 1918977440 18.979 97 12 24 1 1934721072 11805584 3938048
22:19:42 68041 8192000000 10877666592 11352485888 1860907728 18.511 94 21 42 2 1879368160 11661504 6798928
22:21:06 64820 8192000000 10870301984 11346182144 1879612672 18.662 96 14 28 1 1894383536 10796480 3974384
22:22:16 48456 8192000000 10866820208 11334397952 1915718672 18.953 99 17 34 0 1938029920 17011632 5299616
22:23:12 65293 8192000000 10846156576 11317583872 1851581792 18.435 96 19 38 0 1867189024 10568960 5038272
22:24:24 55408 8192000000 10875902480 11337498624 1903362512 18.853 98 9 18 0 1913921984 8040080 2519392
22:25:30 47730 8192000000 10853859856 11319492608 1871240384 18.594 96 18 36 0 1887883312 11880192 4762736
22:26:31 53255 8192000000 10805282832 11260727296 1760107136 17.685 91 22 44 1 1781891616 15554432 6230048

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 106 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

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

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          242005
MON$OLDEST_ACTIVE               242812
MON$OLDEST_SNAPSHOT             242812
MON$NEXT_TRANSACTION            242812
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2023744
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:156: 
:157: mscs-test-161.budzdorov.ru    Tue Mar 16 22:27:29 2021
:158:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:159: 
:160: 
:161: mscs-test-161.budzdorov.ru    Tue Mar 16 22:27:40 2021
:162:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:163: 
:164: 
:165: mscs-test-161.budzdorov.ru    Tue Mar 16 22:27:40 2021
:166:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:167: 
--- end of diff output ---

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

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