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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17286496 kB
MemAvailable 31320044 kB
Buffers 0 kB
Cached 14384444 kB
SwapCached 4864 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-16 01:27:12
DTS_END                         2021-01-16 01:27:12.8860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42312
TRN_ID                          237791
ATT_ID                          626
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: 9021.33 23946 1082560
customer order: creation 174.66 379 20959
customer order: refuse 15.52 352 1862
order to supplier: creation 46.54 1333 5585
order to supplier: removal 3.53 100434 424
invoice (draft): creation 45.96 3616 5515
invoice (draft): removal 50.86 842 6103
invoice accept: apply 41.89 19444 5027
invoice accept: cancel 45.69 826 5483
customer reserve: creation 3834.26 194 460111
customer reserve: removal 4472.05 62 536646
realization accept: apply 83.28 181 9993
realization accept: cancel 79.50 106 9540
payment from customer: creation 57.84 106 6941
payment from customer: removal 5.58 68 669
payment to supplier: creation 48.93 131 5872
payment to supplier: removal 3.36 56 403
service: total inventory turnovers 4.78 1311 574
service: total monetary turnovers 6.37 25 764
service: aggregate perf. data 0.71 25394 85
service: refresh index statistics 0.03 324069 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-01-2021 01:28:07 to 16-01-2021 01:28:09.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4326
TEST_TIME 2 6433
TEST_TIME 3 6704
TEST_TIME 4 6070
TEST_TIME 5 6705
TEST_TIME 6 7205
TEST_TIME 7 7337
TEST_TIME 8 7079
TEST_TIME 9 7040
TEST_TIME 10 7399
TEST_TIME 11 7668
TEST_TIME 12 7831
TEST_TIME 13 8146
TEST_TIME 14 8030
TEST_TIME 15 7895
TEST_TIME 16 7821
TEST_TIME 17 8345
TEST_TIME 18 8369
TEST_TIME 19 8452
TEST_TIME 20 8525
TEST_TIME 21 8973
TEST_TIME 22 9258
TEST_TIME 23 9414
TEST_TIME 24 9512
TEST_TIME 25 9766
TEST_TIME 26 9750
TEST_TIME 27 9839
TEST_TIME 28 10007
TEST_TIME 29 10349
TEST_TIME 30 10192
TEST_TIME 31 10439
TEST_TIME 32 10806
TEST_TIME 33 10924
TEST_TIME 34 10717
TEST_TIME 35 10578
TEST_TIME 36 10502
TEST_TIME 37 10266
TEST_TIME 38 10331
TEST_TIME 39 10228
TEST_TIME 40 10040
TEST_TIME 41 9916
TEST_TIME 42 9849
TEST_TIME 43 9686
TEST_TIME 44 9776
TEST_TIME 45 9728
TEST_TIME 46 9970
TEST_TIME 47 9797
TEST_TIME 48 9781
TEST_TIME 49 9692
TEST_TIME 50 9631
TEST_TIME 51 9522
TEST_TIME 52 9451
TEST_TIME 53 9444
TEST_TIME 54 9379
TEST_TIME 55 9303
TEST_TIME 56 9256
TEST_TIME 57 9177
TEST_TIME 58 9092
TEST_TIME 59 9111
TEST_TIME 60 9098
TEST_TIME 61 8999
TEST_TIME 62 9175
TEST_TIME 63 9267
TEST_TIME 64 9224
TEST_TIME 65 9242
TEST_TIME 66 9214
TEST_TIME 67 9347
TEST_TIME 68 9345
TEST_TIME 69 9253
TEST_TIME 70 9292
TEST_TIME 71 9277
TEST_TIME 72 9229
TEST_TIME 73 9279
TEST_TIME 74 9305
TEST_TIME 75 9285
TEST_TIME 76 9332
TEST_TIME 77 9235
TEST_TIME 78 9150
TEST_TIME 79 9173
TEST_TIME 80 9102
TEST_TIME 81 9142
TEST_TIME 82 9092
TEST_TIME 83 9116
TEST_TIME 84 9092
TEST_TIME 85 9035
TEST_TIME 86 9026
TEST_TIME 87 9029
TEST_TIME 88 9080
TEST_TIME 89 9088
TEST_TIME 90 9136
TEST_TIME 91 9142
TEST_TIME 92 9143
TEST_TIME 93 9141
TEST_TIME 94 9216
TEST_TIME 95 9175
TEST_TIME 96 9177
TEST_TIME 97 9184
TEST_TIME 98 9223
TEST_TIME 99 9256
TEST_TIME 100 9270
TEST_TIME 101 9233
TEST_TIME 102 9171
TEST_TIME 103 9150
TEST_TIME 104 9144
TEST_TIME 105 9090
TEST_TIME 106 9120
TEST_TIME 107 9093
TEST_TIME 108 9061
TEST_TIME 109 9047
TEST_TIME 110 9042
TEST_TIME 111 9009
TEST_TIME 112 9008
TEST_TIME 113 8981
TEST_TIME 114 9098
TEST_TIME 115 9083
TEST_TIME 116 9114
TEST_TIME 117 9080
TEST_TIME 118 9113
TEST_TIME 119 9087
TEST_TIME 120 9023

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-01-2021 01:28:10 to 16-01-2021 01:28:14.

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 1509082 1509082 0 0.00 0 20169 7 0 0
doc_list_biud 1509079 1509079 0 0.00 0 62636 28 0 0
sp_add_invoice_to_stock 5115 5027 88 1.72 54 188143 19445 0 88
sp_cancel_adding_invoice 5483 5483 0 0.00 5 53766 826 0 0
sp_cancel_client_order 1862 1862 0 0.00 5 12463 353 0 0
sp_cancel_customer_reserve 536646 536646 0 0.00 1 62644 63 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 1631 68 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 2 738 56 0 0
sp_cancel_supplier_invoice 6108 6103 5 0.08 2 20024 842 0 5
sp_cancel_supplier_order 424 424 0 0.00 6 834901 100434 0 0
sp_cancel_write_off 9540 9540 0 0.00 1 12348 106 0 0
sp_client_order 20959 20959 0 0.00 4 40528 379 0 0
sp_customer_reserve 460111 460111 0 0.00 0 87932 194 0 0
sp_fill_shopping_cart 32037 32037 0 0.00 1 14996 41 0 0
sp_fill_shopping_cart_clo_res 460095 460095 0 0.00 0 17751 14 0 0
sp_get_clo_for_invoice 5011 5011 0 0.00 0 41301 369 0 0
sp_kill_cost_storno 16095 16095 0 0.00 0 8964 60 0 0
sp_kill_qstorno_ret_qs2qd 1089359 1089359 0 0.00 0 62616 34 0 0
sp_kill_qty_storno 575062 575062 0 0.00 0 62635 73 0 0
sp_lock_selected_doc 20932 20932 0 0.00 0 6122 4 0 0
sp_make_cost_storno 27817 27817 0 0.00 0 20164 55 0 0
sp_multiply_rows_for_pdistr 27817 27817 0 0.00 0 5752 27 0 0
sp_multiply_rows_for_qdistr 20956 20956 0 0.00 0 40512 171 0 0
sp_pay_from_customer 6941 6941 0 0.00 4 22923 106 0 0
sp_pay_to_supplier 5872 5872 0 0.00 5 20174 131 0 0
sp_payment_common 12813 12813 0 0.00 1 22917 35 0 0
sp_qd_handle_on_cancel_clo 1862 1862 0 0.00 0 12455 324 0 0
sp_qd_handle_on_invoice_upd_sts 10494 10494 0 0.00 0 20683 331 0 0
sp_qd_handle_on_reserve_upd_sts 9993 9993 0 0.00 0 14664 61 0 0
sp_reserve_write_off 9993 9993 0 0.00 6 14682 181 0 0
sp_supplier_invoice 5515 5515 0 0.00 6 64849 3617 0 0
sp_supplier_order 5585 5585 0 0.00 5 28777 1333 0 0
srv_aggregate_perf_data 85 85 0 0.00 2866 497984 25394 0 0
srv_fill_mon_cache_memory 175 175 0 0.00 1264 143070 29082 0 0
srv_find_qd_qs_mism 1035143 1035143 0 0.00 0 16311 6 0 0
srv_make_invnt_saldo 574 574 0 0.00 39 109421 1312 0 0
srv_make_money_saldo 764 764 0 0.00 1 360 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 142555 535449 324069 0 0
t$perf-abend:sp_add_invoice_to_stock 88 88 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5027 5027 0 0.00 0 8444 168 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 1 5859 128 0 0
t$perf-norm:sp_cancel_client_order 1862 1862 0 0.00 0 3713 19 0 0
t$perf-norm:sp_cancel_customer_reserve 737 737 0 0.00 0 5718 22 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 956 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 4456 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 425 425 0 0.00 0 1318 21 0 0
t$perf-norm:sp_cancel_supplier_order 424 424 0 0.00 0 21202 1661 0 0
t$perf-norm:sp_cancel_write_off 962 962 0 0.00 0 5756 15 0 0
t$perf-norm:sp_client_order 20959 20959 0 0.00 0 14839 19 0 0
t$perf-norm:sp_customer_reserve 1029 1029 0 0.00 0 2775 10 0 0
t$perf-norm:sp_pay_from_customer 6941 6941 0 0.00 0 4835 10 0 0
t$perf-norm:sp_pay_to_supplier 5872 5872 0 0.00 0 4758 11 0 0
t$perf-norm:sp_reserve_write_off 9993 9993 0 0.00 0 7346 12 0 0
t$perf-norm:sp_supplier_invoice 5515 5515 0 0.00 0 3656 14 0 0
t$perf-norm:sp_supplier_order 5585 5585 0 0.00 0 5643 19 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 407 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 175 175 0 0.00 0 1467 13 0 0
t$perf-norm:srv_make_invnt_saldo 574 574 0 0.00 0 1045 24 0 0
t$perf-norm:srv_make_money_saldo 764 764 0 0.00 0 1958 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10198 10022 176 1.72 0 8597 19 0 176
v_all_customers 37568 37568 0 0.00 0 19 1 0 0
v_all_suppliers 30566 30566 0 0.00 0 18 1 0 0
v_all_wares 41904 41904 0 0.00 0 70 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 1628 10 0 0
v_cancel_client_order 3724 3724 0 0.00 0 5497 8 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 1611 7 0 0
v_cancel_customer_reserve 1474 1474 0 0.00 0 3789 11 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 702 5 0 0
v_cancel_supplier_invoice 860 850 10 1.16 0 2363 20 0 10
v_cancel_supplier_order 848 848 0 0.00 0 5425 13 0 0
v_cancel_write_off 1924 1924 0 0.00 0 1782 14 0 0
v_max_id_clo_ord 5585 5585 0 0.00 0 715 1 0 0
v_max_id_clo_res 1029 1029 0 0.00 0 2764 17 0 0
v_max_id_ord_sup 5500 5500 0 0.00 0 3382 3 0 0
v_max_non_paid_invoice 1674 1674 0 0.00 0 1137 3 0 0
v_max_non_paid_realizn 3887 3887 0 0.00 0 4991 6 0 0
v_min_id_clo_ord 5585 5585 0 0.00 0 5326 7 0 0
v_min_id_clo_res 1029 1029 0 0.00 0 7802 21 0 0
v_min_id_ord_sup 5500 5500 0 0.00 0 5697 8 0 0
v_min_non_paid_invoice 5872 5872 0 0.00 0 9067 22 0 0
v_min_non_paid_realizn 6941 6941 0 0.00 0 22409 19 0 0
v_our_firm 10444 10444 0 0.00 0 15 1 0 0
v_reserve_write_off 19986 19986 0 0.00 0 4986 6 0 0
x_lock_depdocs_on_canc_invoice 11161 11161 0 0.00 0 11887 132 0 0
x_lock_depdocs_on_canc_sup_ord 424 424 0 0.00 0 3643 336 0 0
x_make_qstorno_1000_1200 5585 5585 0 0.00 2 28684 1242 0 0
x_make_qstorno_1200_2000 5515 5515 0 0.00 3 64264 3472 0 0
x_make_qstorno_2100_3300 460111 460111 0 0.00 0 87931 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-01-2021 01:28:15 to 16-01-2021 01:28:19.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:22 20933 8192000000 10246104720 10549927936 819701264 9.095 64 50 99 0 838989280 2507072 16780944
22:57:51 21682 8192000000 10336247136 10649714688 1379756144 14.414 100 90 179 0 1414124976 4750256 29618576
22:58:27 21304 8192000000 10377645840 10696900608 1425782640 14.824 100 89 177 0 1461408624 6424528 29201456
22:58:58 28095 8192000000 10410165296 10739269632 1455306384 15.085 100 87 174 0 1491051360 7431008 28313968
22:59:35 24396 8192000000 10443188384 10775863296 1489624704 15.386 100 83 166 0 1523628096 7515488 26487904
23:00:10 24481 8192000000 10466964128 10805174272 1522802352 15.675 100 86 173 1 1558922208 8385216 27734640
23:00:44 14298 8192000000 10490079824 10830905344 1537850912 15.805 100 83 166 1 1573013456 8856576 26305968
23:01:07 15248 8192000000 10494841216 10843099136 1558666336 15.985 100 87 174 1 1595879392 9362960 27850096
23:01:33 18669 8192000000 10517233584 10869714944 1577794720 16.149 100 84 168 0 1613616416 9614064 26207632
23:02:05 10854 8192000000 10554406560 10910126080 1611617824 16.439 100 81 162 0 1646169312 10138112 24413376
23:02:25 14364 8192000000 10584797712 10943610880 1637861056 16.662 100 84 168 0 1673856096 11087632 24907408
23:02:47 12281 8192000000 10599848608 10961170432 1646810736 16.737 100 81 162 0 1682207360 11530944 23865680
23:03:14 11199 8192000000 10609999232 10975313920 1670945200 16.941 100 79 158 1 1706326704 12562128 22819376
23:03:34 10045 8192000000 10639335584 11003506688 1691583904 17.115 100 82 164 2 1727872528 12682336 23606288
23:03:54 6257 8192000000 10641115536 11014950912 1707257776 17.246 100 76 152 1 1741549008 12602896 21688336
23:04:08 8791 8192000000 10674115456 11046862848 1725786128 17.400 100 82 164 1 1763103568 13796128 23521312
23:04:24 9093 8192000000 10680162544 11052249088 1742406304 17.539 100 88 175 3 1781838080 14436128 24995648
23:04:42 7959 8192000000 10692965360 11066535936 1751863824 17.617 100 88 175 2 1790948512 14513264 24571424
23:04:58 5110 8192000000 10690978080 11070853120 1758286320 17.670 100 78 156 1 1794565200 13956720 22322160
23:05:10 5287 8192000000 10715205056 11089014784 1769566480 17.763 100 86 171 0 1807905600 13949456 24389664
23:05:24 4600 8192000000 10710209040 11090153472 1775026496 17.808 100 87 170 4 1812127344 13422032 23678816
23:05:35 4955 8192000000 10720373536 11099860992 1784350096 17.885 100 88 174 0 1822312528 13808880 24153552
23:05:48 4426 8192000000 10726637408 11108888576 1788088720 17.916 100 84 165 1 1824822928 13056544 23677664
23:05:59 3882 8192000000 10733407616 11113218048 1795079360 17.974 100 84 168 1 1831273392 12366288 23827744
23:06:10 3361 8192000000 10751343616 11131826176 1804495216 18.051 100 85 168 0 1840919664 12491808 23932640
23:06:19 10258 8192000000 10740811440 11132493824 1810908480 18.103 100 79 158 1 1846580976 13821344 21851152
23:06:39 8070 8192000000 10758239456 11145883648 1816228912 18.147 100 84 168 4 1858252128 18357776 23665440
23:06:54 2564 8192000000 10773610768 11160383488 1831465168 18.271 100 82 162 3 1866697424 12929984 22302272
23:07:04 2427 8192000000 10788174208 11172634624 1836896576 18.316 100 83 165 0 1873146704 13639168 22610960
23:07:13 2132 8192000000 10787108912 11172814848 1843041312 18.366 100 89 178 1 1880773120 13289456 24442352
23:07:21 1399 8192000000 10787631040 11174055936 1844895152 18.381 100 88 175 0 1881623248 12414384 24313712
23:07:29 2531 8192000000 10787848896 11178680320 1849928704 18.422 100 91 178 5 1886739296 12136048 24674544
23:07:38 2848 8192000000 10798823600 11183415296 1851172128 18.432 100 91 180 1 1889948752 12551856 26224768
23:07:47 1974 8192000000 10806303248 11191869440 1859430256 18.499 100 91 181 2 1897142384 12195632 25516496
23:07:57 2464 8192000000 10800988400 11192852480 1861904448 18.519 100 88 174 2 1899612160 12714320 24993392
23:08:07 2421 8192000000 10813579872 11203383296 1872468000 18.604 100 85 170 0 1907945536 11935360 23542176
23:08:16 2721 8192000000 10822842048 11209486336 1874247632 18.619 100 95 191 0 1914538768 13503600 26787536
23:08:25 3358 8192000000 10816165184 11204964352 1871847808 18.599 100 90 178 2 1911956352 14317312 25791232
23:08:35 1315 8192000000 10819832240 11209048064 1876826304 18.639 100 93 182 0 1915704512 12857392 26020816
23:08:43 1793 8192000000 10827090800 11217985536 1879955504 18.665 100 97 194 0 1921967152 14048736 27962912
23:08:51 1598 8192000000 10830365440 11219517440 1883255248 18.691 100 95 191 0 1924609712 14175248 27179216
23:08:59 1737 8192000000 10824545616 11218518016 1882765632 18.687 100 90 180 3 1921077856 13267424 25044800
23:09:07 2300 8192000000 10809614896 11213242368 1878552784 18.653 100 76 152 0 1912842416 12938624 21351008
23:09:16 26590 8192000000 10819937088 11216146432 1879327216 18.660 100 62 124 1 1906078512 8713024 18038272
23:09:51 2170 8192000000 10821675056 11222175744 1889719632 18.744 100 91 180 0 1927772608 11335728 26717248
23:10:00 13024 8192000000 10824397568 11226533888 1886174736 18.715 100 63 124 3 1914881984 11344336 17362912
23:10:20 1284 8192000000 10846524720 11238125568 1893678432 18.775 100 95 191 1 1933778016 13430528 26669056
23:10:27 9982 8192000000 10811343936 11228672000 1885899264 18.713 100 53 106 0 1912669536 12015344 14754928
23:10:50 4209 8192000000 10793978144 11222568960 1888885232 18.737 100 50 101 1 1910736240 7094032 14756976
23:11:01 6803 8192000000 10807578160 11227394048 1887020800 18.722 100 34 67 0 1901491808 5162080 9308928
23:11:15 8270 8192000000 10795543904 11229732864 1889240560 18.740 100 21 42 2 1901886800 6915200 5731040
23:11:31 2817 8192000000 10802430336 11232821248 1892691456 18.767 100 38 76 2 1910849680 6804448 11353776
23:11:45 10876 8192000000 10790793648 11227983872 1890982144 18.754 100 23 45 3 1903788688 6606944 6199600
23:12:03 6314 8192000000 10804349888 11232378880 1893096320 18.771 100 20 40 0 1905227824 6288944 5842560
23:12:18 7209 8192000000 10805124640 11235467264 1895733456 18.792 100 27 54 0 1909981936 6682352 7566128
23:12:31 8678 8192000000 10804639072 11241488384 1898277088 18.812 100 22 44 0 1914913952 10380992 6255872
23:12:53 11058 8192000000 10800093904 11237949440 1898416864 18.814 100 13 24 1 1907254432 5415600 3421968
23:13:14 8369 8192000000 10805250384 11241844736 1901399984 18.838 100 27 52 3 1915166576 6474496 7292096
23:13:29 9561 8192000000 10812753552 11244064768 1905068992 18.867 100 32 64 0 1920854752 7341408 8444352
23:13:47 6712 8192000000 10809257776 11243048960 1901398480 18.838 100 24 48 0 1914263936 6216064 6649392
23:14:04 6259 8192000000 10818746848 11252269056 1901059904 18.835 100 22 44 2 1913915568 6804496 6051168
23:14:20 40741 8192000000 10832198224 11254312960 1905205888 18.868 100 24 48 0 1918099424 5379392 7514144
23:15:09 26756 8192000000 10869066000 11269783552 1917631088 18.968 100 95 193 2 1951746096 6000960 28114048
23:15:42 12784 8192000000 10829071280 11263680512 1906937120 18.882 100 28 56 2 1925289552 11033680 7318752
23:16:01 7625 8192000000 10829789584 11264081920 1910837984 18.913 100 26 52 1 1925216128 5896992 8481152
23:16:15 4619 8192000000 10829400704 11267112960 1912691680 18.928 100 35 72 1 1928387456 5508368 10187408
23:16:27 5594 8192000000 10834722752 11267870720 1914331664 18.941 100 34 68 3 1931748000 7440224 9976112
23:16:40 4477 8192000000 10823977536 11264172032 1913469568 18.934 100 30 60 0 1928220656 5778592 8972496
23:16:57 5305 8192000000 10815179952 11250483200 1887295280 18.724 99 32 64 2 1902798928 6431712 9071936
23:17:10 7377 8192000000 10812918112 11242344448 1863887712 18.535 98 31 62 1 1879821408 6458016 9475680
23:17:27 6384 8192000000 10794600448 11235377152 1857451152 18.483 98 25 50 2 1869923216 5685360 6786704
23:17:42 8022 8192000000 10776731584 11201986560 1803552832 18.043 96 17 34 3 1812894768 4846320 4495616
23:17:58 13401 8192000000 10760997760 11192807424 1803402736 18.042 97 10 20 0 1811521008 5399360 2718912
23:18:18 6946 8192000000 10724247584 11140472832 1762817136 17.708 95 31 61 0 1781219792 9037200 9365456
23:18:33 6941 8192000000 10748616272 11161686016 1811731344 18.110 98 34 68 2 1827787504 5579888 10476272
23:18:47 53837 8192000000 10752202672 11153924096 1755259456 17.645 95 72 144 2 1783442560 5823312 22359792
23:19:47 6337 8192000000 10745261616 11165794304 1820666432 18.183 100 39 78 1 1840709184 9239408 10803344
23:20:02 5198 8192000000 10735685504 11149795328 1786776192 17.905 98 39 78 0 1807781744 9483984 11521568
23:20:17 5487 8192000000 10730306880 11154616320 1777132592 17.826 97 31 62 1 1792177712 6723808 8321312
23:20:29 8509 8192000000 10705823600 11117264896 1755298256 17.645 97 33 66 2 1774739088 10448992 8991840
23:20:48 4518 8192000000 10701863888 11122135040 1777138720 17.826 99 31 62 1 1792494016 7156832 8198464
23:21:03 4910 8192000000 10687866176 11084288000 1713422256 17.297 97 33 66 1 1729137200 5412400 10302544
23:21:16 6450 8192000000 10709249760 11120893952 1782983984 17.874 100 31 62 3 1796784192 4812144 8988064
23:21:31 8522 8192000000 10717134704 11132895232 1800017680 18.014 100 30 60 1 1815023888 6384384 8621824
23:21:50 9454 8192000000 10732281616 11153731584 1815968912 18.145 100 26 53 3 1829249424 5819712 7460800
23:22:06 9010 8192000000 10717496176 11136245760 1764985984 17.726 97 19 38 1 1776102080 5599376 5516720
23:22:52 27082 8192000000 10724111280 11153367040 1817756192 18.159 100 12 25 0 1827417984 5616832 4044960
23:23:27 8581 8192000000 10750094544 11173986304 1835823040 18.307 100 28 56 1 1849992064 6272272 7896752
23:23:43 7496 8192000000 10737111904 11160838144 1814839872 18.135 99 28 56 2 1830148624 6369600 8939152
23:23:59 6073 8192000000 10743213888 11161939968 1810991504 18.104 99 34 68 3 1827090944 6178656 9920784
23:24:11 6426 8192000000 10738829696 11162447872 1826461264 18.230 100 21 42 1 1838618256 5908592 6248400
23:24:24 8937 8192000000 10759150832 11177152512 1834430544 18.295 100 28 56 2 1848048976 5425152 8193280
23:24:42 7187 8192000000 10759564048 11180732416 1842706608 18.363 100 33 66 0 1858740112 6717632 9315872
23:24:55 9500 8192000000 10756755680 11186905088 1843933376 18.373 100 17 34 0 1854918544 6415952 4569216
23:25:13 8634 8192000000 10741165104 11166822400 1793956544 17.964 97 22 41 3 1805776256 6309408 5510304
23:25:30 8569 8192000000 10761742592 11184553984 1847594720 18.403 100 25 50 2 1860634464 6220960 6818784
23:25:45 8180 8192000000 10772640400 11197714432 1852120752 18.439 100 21 42 0 1863422128 5436000 5865376
23:25:59 6810 8192000000 10784526192 11202019328 1858473296 18.491 100 19 36 1 1869384800 4937152 5974352
23:26:12 10478 8192000000 10776106848 11200843776 1861512000 18.516 100 17 34 1 1871222064 4685344 5024720
23:26:32 50639 8192000000 10804298720 11214360576 1867661840 18.565 100 29 58 1 1881227968 5305696 8260432
23:27:40 14659 8192000000 10819109984 11235459072 1893922656 18.777 100 47 93 0 1914288048 7022592 13342800
23:28:04 16130 8192000000 10840412112 11255398400 1902450784 18.846 100 53 106 1 1926492064 9503600 14537680
23:28:30 19945 8192000000 10843734608 11261976576 1911955024 18.922 100 62 124 2 1940195552 11053776 17186752
23:29:02 5510 8192000000 10864448160 11273572352 1921188752 18.996 100 66 129 1 1950241024 11037376 18014896
23:29:17 8195 8192000000 10863127136 11279015936 1921999936 19.003 100 50 98 0 1949612320 14156912 13455472
23:29:33 17193 8192000000 10866627152 11288502272 1932100832 19.084 100 53 106 1 1958437552 10451248 15885472
23:29:59 12425 8192000000 10863799664 11293896704 1935940208 19.114 100 47 93 0 1958999776 9705632 13353936
23:30:22 15332 8192000000 10880921840 11303215104 1941278992 19.157 100 50 100 1 1965598976 9811728 14508256
23:30:45 5919 8192000000 10882572256 11308167168 1946632800 19.200 100 54 108 1 1976987264 15617024 14737440
23:31:00 9017 8192000000 10880702096 11309502464 1950323200 19.229 100 53 104 0 1975378000 10727648 14327152
23:31:24 20221 8192000000 10887430256 11316604928 1954858288 19.265 100 56 111 0 1982136320 11852048 15425984
23:31:57 5155 8192000000 10904395456 11329916928 1965422944 19.349 100 60 118 2 1997120496 13842528 17855024
23:32:09 30696 8192000000 10892874192 11335749632 1963060768 19.330 100 32 64 2 1987541136 15022224 9458144
23:33:02 10566 8192000000 10906276048 11342761984 1969791456 19.384 100 35 70 1 1994997360 13931824 11274080
23:33:22 8504 8192000000 10910541584 11346251776 1978801440 19.455 100 49 97 0 2006026400 12817072 14407888
23:33:42 5793 8192000000 10914942368 11346976768 1979455456 19.460 100 54 106 0 2007006736 12293888 15257392
23:33:59 12601 8192000000 10917185504 11355389952 1983556576 19.493 100 53 106 2 2013063232 14012656 15494000
23:34:24 17716 8192000000 10921638608 11353722880 1983980848 19.496 100 47 92 3 2009972592 12592592 13399152
23:34:48 10868 8192000000 10918777872 11359870976 1982745840 19.486 100 37 73 2 2005505808 12514624 10245344
23:35:06 6896 8192000000 10920896128 11349790720 1969524448 19.382 99 65 128 2 2000346832 12136096 18686288
23:35:22 11801 8192000000 10916639360 11347685376 1966319984 19.356 99 62 123 2 1997458400 14100208 17038208
23:35:43 4039 8192000000 10927814304 11359195136 1986018624 19.512 100 59 116 2 2018197440 15966448 16212368
23:35:56 18054 8192000000 10941425664 11367297024 1990660128 19.549 100 64 128 1 2026327648 17755904 17911616
23:36:20 4626 8192000000 10945548336 11372474368 1996594496 19.596 100 58 116 1 2031072368 18265648 16212224
23:36:36 2370 8192000000 10954233888 11380117504 2004104880 19.655 100 70 140 0 2041526592 17892096 19529616
23:36:55 3349 8192000000 10954300464 11388125184 2007502864 19.682 100 64 128 1 2046054208 20052416 18498928
23:37:05 1263 8192000000 10972815536 11395047424 2010556016 19.706 100 80 156 1 2053078016 20147040 22374960
23:37:13 1992 8192000000 10981427888 11400302592 2016083792 19.749 100 87 174 3 2062974192 21652608 25237792
23:37:21 2908 8192000000 10964155104 11384102912 2002687552 19.644 100 86 172 0 2050420000 22480448 25252000
23:37:33 1449 8192000000 10962333312 11374673920 1984744144 19.502 99 87 170 1 2033075680 22504992 25826544
23:37:43 5052 8192000000 10959064160 11382095872 1997995184 19.607 100 75 149 0 2042611568 23144608 21471776
23:37:55 2431 8192000000 10945098624 11371511808 1978925248 19.456 99 66 131 0 2021778128 22780160 20072720
23:38:06 5582 8192000000 10941102096 11375665152 1994269536 19.578 100 58 116 0 2035158256 23440752 17447968
23:38:19 2895 8192000000 10940963808 11365535744 1972235328 19.403 99 74 147 0 2016727456 23154144 21337984
23:38:30 5397 8192000000 10923162080 11349413888 1968376608 19.373 100 64 122 3 2010131616 23634000 18121008
23:38:45 2030 8192000000 10945896736 11358781440 1980301216 19.467 100 83 166 2 2028256048 23293840 24660992
23:38:55 2462 8192000000 10925528304 11343208448 1956128320 19.275 99 68 136 1 1999716096 22887040 20700736
23:39:05 6276 8192000000 10932634624 11349749760 1972959168 19.409 100 85 168 2 2019383328 22035808 24388352
23:39:19 2352 8192000000 10941074560 11360927744 1979805120 19.463 100 77 155 1 2028308096 25023504 23479472
23:39:30 2557 8192000000 10924370224 11336896512 1954317824 19.261 99 87 174 2 2007164880 26632256 26214800
23:39:39 3753 8192000000 10943477232 11365433344 1978514592 19.453 100 77 155 2 2028466944 26771152 23181200
23:39:54 7166 8192000000 10943351216 11369426944 1981016576 19.473 100 77 150 2 2029379024 25383392 22979056
23:40:10 6486 8192000000 10919998112 11344424960 1960544016 19.310 99 60 119 0 2004776368 26548272 17684080
23:40:25 5742 8192000000 10921537392 11347267584 1964391840 19.341 99 68 135 2 2012694688 26539152 21763696
23:40:43 3311 8192000000 10915340272 11336790016 1956619312 19.279 100 59 117 2 1999553488 25540448 17393728
23:40:54 8845 8192000000 10920703904 11344986112 1962520624 19.326 100 66 133 0 2008970432 26423280 20026528
23:41:10 7407 8192000000 10927800608 11352248320 1950209824 19.228 99 68 134 1 1998195232 27522480 20462928
23:41:25 8327 8192000000 10925171200 11345379328 1949608048 19.223 99 70 134 2 1996423648 27954448 18861152
23:41:39 4351 8192000000 10926074736 11344650240 1958505568 19.294 100 76 152 0 2009735840 27456016 23774256
23:41:51 7638 8192000000 10918324112 11330023424 1944625168 19.184 99 67 131 1 1991403136 27074304 19703664
23:42:07 10679 8192000000 10920956208 11348115456 1965317296 19.348 100 65 130 1 2013751856 28894352 19540208
23:42:24 11105 8192000000 10930624720 11349909504 1948121072 19.212 99 59 117 3 1994913936 28445520 18347344
23:42:44 3981 8192000000 10948577072 11359305728 1972893648 19.408 100 70 137 1 2022631312 29284528 20453136
23:42:56 1320 8192000000 10947578896 11357519872 1970961664 19.393 100 87 173 2 2027834144 30745280 26127200
23:43:05 4456 8192000000 10935309808 11346300928 1952108560 19.243 99 73 145 1 2005215536 30815584 22291392
23:43:16 3077 8192000000 10935873696 11347378176 1958468016 19.294 100 85 171 0 2017611392 32772064 26371312
23:43:27 2875 8192000000 10942392496 11352268800 1963414576 19.333 100 87 173 3 2023449824 33952128 26083120
23:43:38 4715 8192000000 10948110400 11355205632 1950202112 19.228 99 91 182 0 2012495920 34248752 28045056
23:43:57 5328 8192000000 10940352192 11360546816 1965786352 19.352 100 67 132 1 2021865504 35568784 20510368
23:44:10 3173 8192000000 10945316160 11364048896 1962164512 19.323 99 75 149 0 2020791664 34674688 23952464
23:44:19 2470 8192000000 10947200112 11353821184 1968001664 19.370 100 91 181 0 2024195984 28423712 27770608
23:44:28 7175 8192000000 10947577952 11355684864 1972504832 19.405 100 79 155 1 2025942032 29667856 23769344
23:44:42 2456 8192000000 10946974608 11357179904 1974270240 19.419 100 86 172 0 2030438864 29763744 26404880
23:44:52 4970 8192000000 10958281024 11367092224 1980520272 19.469 100 85 167 1 2035480384 30081840 24878272
23:45:04 2253 8192000000 10917810720 11337220096 1950557616 19.231 100 64 128 1 2001203184 30640128 20005440
23:45:24 22148 8192000000 10878613184 11306786816 1906257712 18.877 98 48 96 0 1950871200 29383472 15230016
23:46:12 4721 8192000000 10887930352 11311108096 1910480512 18.911 99 46 92 2 1961725216 35797328 15447376
23:46:29 1516 8192000000 10901783952 11322634240 1930105168 19.068 100 60 119 1 1983185424 34535920 18544336
23:46:38 3260 8192000000 10903165136 11328950272 1940483072 19.151 100 51 102 1 1989734704 32651120 16600512
23:46:48 20244 8192000000 10895681920 11323416576 1921056560 18.995 99 44 88 0 1969670848 33921872 14692416
23:47:16 1297 8192000000 10914595744 11330105344 1940160128 19.148 100 71 140 1 1998913760 34873248 23880384
23:47:24 1927 8192000000 10927040720 11338735616 1945725376 19.192 100 84 167 2 2009244320 37889744 25629200
23:47:35 7007 8192000000 10924194160 11340349440 1941735024 19.161 100 79 156 2 2008401616 40748544 25918048
23:47:50 15022 8192000000 10923996016 11344781312 1947338768 19.205 100 58 116 0 2004510368 38563280 18608320
23:48:14 2299 8192000000 10926526336 11351789568 1952510816 19.246 100 59 119 1 2007662544 36337904 18813824
23:48:24 2356 8192000000 10910807088 11335884800 1947088784 19.203 100 59 118 0 1995752240 30365664 18297792
23:48:34 6532 8192000000 10914832656 11338371072 1947696816 19.208 100 47 95 0 1993009568 30374144 14938608
23:48:48 9364 8192000000 10924302208 11352797184 1953414352 19.254 100 47 93 2 1999906976 31517520 14975104
23:49:05 3909 8192000000 10926272944 11349893120 1960346928 19.309 100 62 124 1 2014102976 33739744 20016304
23:49:25 7257 8192000000 10912575920 11345403904 1946896608 19.202 100 59 118 1 2000660352 35097648 18666096
23:49:46 2593 8192000000 10918229616 11351470080 1960288608 19.308 100 58 116 1 2013388080 33667088 19432384
23:50:01 23291 8192000000 10911461264 11354378240 1959307760 19.301 100 28 54 1 1999082624 30683040 9091824
23:50:33 3623 8192000000 10925503088 11358646272 1965744560 19.352 100 43 86 2 2005342160 25769952 13827648
23:50:49 3187 8192000000 10928887856 11359662080 1963567248 19.334 100 53 106 1 2010793488 29539472 17686768
23:50:59 5862 8192000000 10935832608 11364970496 1968298064 19.372 100 54 108 2 2018359152 32800240 17260848
23:51:11 14963 8192000000 10925154816 11368755200 1963159824 19.331 100 35 70 1 2006185072 31241504 11783744
23:51:42 9973 8192000000 10916797072 11361017856 1944341104 19.181 99 24 48 1 1984775968 32144272 8290592
23:51:58 7858 8192000000 10913639744 11345547264 1943966064 19.178 99 47 89 0 1988707312 29518960 15222288
23:52:15 5947 8192000000 10925167792 11362406400 1962622416 19.327 100 46 92 0 2011360736 33423888 15314432
23:52:35 10470 8192000000 10912906560 11358396416 1954580880 19.263 100 30 60 0 1997253856 32342880 10330096
23:52:51 8996 8192000000 10911295424 11357818880 1955575520 19.271 100 26 52 1 1996680928 32065232 9040176
23:53:07 26384 8192000000 10885260928 11332792320 1905112352 18.867 98 23 46 1 1941419696 28361776 7945568
23:53:42 2989 8192000000 10900361296 11344900096 1939500096 19.143 100 33 64 1 1983594432 32948336 11146000
23:54:04 10994 8192000000 10905439424 11349057536 1942732272 19.169 100 28 56 1 1982731696 30149312 9850112
23:54:25 9845 8192000000 10895122640 11333980160 1928686064 19.056 99 30 59 2 1969763744 31409504 9668176
23:54:57 23235 8192000000 10896660688 11352133632 1942729472 19.169 100 25 50 3 1981035264 29902432 8403360
23:55:30 25574 8192000000 10909617456 11356725248 1946381072 19.198 100 25 50 0 1989054688 34095728 8577888
23:56:28 23443 8192000000 10902798720 11365892096 1928354304 19.054 99 19 38 0 1967814304 33586320 5873680
23:57:07 19322 8192000000 10911730384 11368251392 1946100736 19.195 100 22 44 1 1996580304 42964160 7515408
23:57:40 9788 8192000000 10921409152 11367833600 1952135280 19.243 100 26 52 0 2005557200 44746336 8675584
23:58:42 22000 8192000000 10912193984 11366469632 1943179008 19.172 99 29 58 2 1988832800 37245760 8408032
23:59:12 26897 8192000000 10886976032 11362881536 1937698736 19.128 99 11 20 0 1966508608 26109760 2700112
23:59:45 53451 8192000000 10895829392 11344859136 1915454304 18.950 98 15 32 1 1939898336 20434176 4009856
00:00:56 73372 8192000000 10888296368 11346137088 1916336224 18.957 98 16 31 3 1928538640 8388320 3814096
00:02:18 61106 8192000000 10887691440 11355312128 1957223072 19.284 100 14 28 0 1978144272 17105536 3815664
00:03:31 92619 8192000000 10896793184 11351609344 1944161712 19.180 99 24 48 1 1966377024 15657312 6558000
00:05:40 101132 8192000000 10917204256 11369644032 1946975136 19.202 99 13 26 0 1959981472 9709920 3296416
00:07:29 21927 8192000000 10927457184 11375525888 1986052592 19.513 100 52 104 1 2015180848 15183232 13945024
00:07:58 31412 8192000000 10946864640 11389255680 1995533664 19.587 100 48 94 2 2025514768 16203600 13777504
00:08:37 47455 8192000000 10949334400 11394736128 1999029680 19.615 100 33 65 1 2021815600 12978160 9807760
00:09:42 64653 8192000000 10919594016 11375124480 1960580480 19.311 98 30 60 0 1985372656 15739856 9052320
00:11:31 44043 8192000000 10928153264 11384107008 1980888144 19.472 100 41 82 3 2010868448 17324912 12655392
00:12:27 59604 8192000000 10925839872 11401560064 1985516432 19.508 100 18 37 1 2015096752 24142576 5437744
00:14:11 46735 8192000000 10892832848 11370622976 1946395488 19.198 98 4 8 0 1965395040 17231280 1768272
00:15:09 42709 8192000000 10906031232 11377676288 1963160144 19.331 99 11 23 0 1980641616 14044432 3437040
00:16:06 88761 8192000000 10895682400 11372781568 1975167568 19.426 100 13 27 0 1988904368 10210864 3525936
00:17:56 52115 8192000000 10896469504 11354288128 1946861712 19.201 98 43 85 1 1966234960 6408064 12965184
00:19:03 61072 8192000000 10929217728 11378937856 1969399616 19.381 99 31 62 0 1989340320 10849456 9091248
00:20:10 82693 8192000000 10911479424 11383648256 1971207296 19.395 99 25 50 1 1987692688 9507008 6978384
00:21:53 41161 8192000000 10912726432 11387957248 1995353792 19.586 100 13 26 2 2008145424 8809680 3981952
00:22:49 16909 8192000000 10933245232 11394465792 1983390160 19.492 99 28 56 0 2001057616 9847392 7820064
00:23:14 39057 8192000000 10912577904 11384938496 1978123552 19.450 99 19 37 0 1996800784 13009648 5667584
00:24:05 48975 8192000000 10914038752 11390578688 1973224800 19.411 99 14 28 2 1994979056 17257024 4497232
00:25:01 76517 8192000000 10928999056 11399360512 1973154208 19.410 99 12 24 0 1995256144 18645344 3456592
00:27:08 75026 8192000000 10920079920 11401658368 1978071872 19.449 99 13 26 2 2001444352 19758080 3614400
00:29:15 88604 8192000000 10899967328 11386490880 1910790848 18.913 96 8 16 0 1934084368 21091872 2201648
00:32:07 83343 8192000000 10900834944 11351609344 1844074432 18.374 93 21 42 0 1858811520 9551824 5185264
00:33:40 86519 8192000000 10874423680 11365466112 1905113264 18.867 97 12 24 0 1925482656 16900736 3468656
00:35:15 53033 8192000000 10861427856 11320279040 1834910880 18.299 94 13 26 1 1852460960 13947584 3602496
00:36:16 17403 8192000000 10884716736 11313098752 1900740640 18.832 98 67 135 0 1929479984 8659728 20079616
00:36:42 10196 8192000000 10894046928 11326345216 1941043296 19.155 100 67 132 1 1970638224 10384672 19210256
00:36:58 18632 8192000000 10874655968 11326652416 1919740176 18.985 99 51 102 1 1947455248 13205616 14509456
00:37:24 36251 8192000000 10849617296 11313565696 1873260064 18.611 97 39 79 0 1897316496 13023520 11032912
00:38:18 48457 8192000000 10825238944 11275399168 1828518656 18.247 95 19 38 3 1841671152 8437376 4715120
00:39:17 34518 8192000000 10852660256 11304439808 1879323120 18.660 98 28 56 1 1895770224 7827280 8619824
00:40:10 143070 8192000000 10845957648 11299078144 1808070352 18.080 94 24 48 1 1832415488 17615328 6729808
00:42:40 24264 8192000000 10848893952 11308736512 1901692032 18.840 99 19 38 0 1915214880 8393440 5129408
00:43:16 118022 8192000000 10830115248 11292540928 1867362048 18.563 97 17 34 1 1885919472 13565344 4992080
00:45:37 83644 8192000000 10861568800 11320446976 1891443184 18.757 98 31 60 1 1911551872 12145312 7963376
00:47:07 57033 8192000000 10859449296 11308822528 1867466672 18.564 96 29 57 0 1886394128 10176304 8751152
00:48:11 49517 8192000000 10858347808 11330691072 1915119536 18.948 99 24 47 0 1931218944 9188816 6910592
00:49:06 38177 8192000000 10863404864 11332300800 1942998720 19.171 100 11 23 0 1955820208 9539952 3281536
00:49:54 42512 8192000000 10874155728 11350028288 1944084112 19.179 100 9 18 0 1956148464 9515680 2548672
00:50:56 56775 8192000000 10858589600 11325853696 1909783808 18.905 98 16 32 0 1924011296 9298640 4928848
00:52:00 73800 8192000000 10860577504 11332182016 1940152736 19.148 100 15 30 1 1956076080 11561840 4361504
00:53:25 56204 8192000000 10862414704 11338280960 1892714576 18.768 97 19 37 3 1913437952 14951920 5771456
00:54:28 61010 8192000000 10865213872 11329658880 1900609216 18.831 98 17 34 0 1921105904 15036816 5459872
00:55:48 70660 8192000000 10860906800 11329019904 1877463648 18.645 97 20 40 2 1891851376 9433664 4954064
00:57:20 96122 8192000000 10865467856 11326705664 1874995728 18.625 96 18 36 2 1892279520 11942896 5340896
00:59:03 33561 8192000000 10900867984 11346448384 1956551504 19.279 100 45 91 0 1979928544 10474304 12902736
00:59:48 17867 8192000000 10895068096 11340726272 1951656880 19.240 100 38 76 1 1971812928 9505136 10650912
01:00:14 22947 8192000000 10875944176 11319701504 1894121552 18.779 97 39 78 1 1915854928 11330608 10402768
01:00:44 32202 8192000000 10883573760 11334467584 1927277552 19.045 99 37 74 0 1947683696 10545264 9860880
01:01:23 57583 8192000000 10871427952 11336429568 1940924256 19.154 100 15 30 0 1956170912 11437408 3809248
01:02:26 28350 8192000000 10888737072 11341262848 1949142912 19.220 100 26 52 2 1963897296 7077280 7677104
01:03:01 52987 8192000000 10906574944 11362664448 1945311072 19.189 99 29 58 0 1963705616 10575104 7819440
01:04:05 39499 8192000000 10914242976 11365105664 1965212032 19.347 100 45 88 1 1987775008 10852112 11710864
01:04:56 96913 8192000000 10908455328 11378049024 1969939552 19.385 100 17 34 1 1986886912 11734576 5212784
01:07:44 65288 8192000000 10904882016 11361112064 1943037696 19.171 98 21 42 0 1958081744 9223408 5820640
01:08:56 95528 8192000000 10937406528 11382505472 1988210400 19.530 100 42 85 2 2008191168 7527552 12453216
01:10:45 107778 8192000000 10914397120 11390201856 1969960816 19.385 99 18 36 1 1987289440 12429056 4899568
01:12:39 43280 8192000000 10912769440 11392544768 1992299744 19.562 100 8 16 1 2007698000 11974480 3423776
01:13:33 74114 8192000000 10865307504 11342270464 1861489248 18.515 94 16 32 0 1879685056 13956032 4239776
01:14:53 51901 8192000000 10881607504 11356766208 1965388832 19.349 100 22 44 0 1982024448 10259424 6376192
01:16:20 81279 8192000000 10871527920 11354447872 1948559568 19.215 99 14 28 0 1963230624 10420224 4250832
01:17:48 39969 8192000000 10886394784 11365191680 1945360240 19.190 99 10 20 1 1955734320 7416560 2957520
01:18:34 47489 8192000000 10876127712 11339489280 1907182672 18.884 97 27 54 0 1931054352 16563888 7307792
01:19:35 63024 8192000000 10882783760 11346616320 1888431616 18.733 96 23 46 1 1910246496 14690512 7124368
01:20:44 69008 8192000000 10871925392 11347161088 1890365376 18.749 97 12 24 2 1907553792 13459376 3729040
01:21:59 61674 8192000000 10869672832 11327959040 1854355312 18.457 95 24 49 0 1868923616 7910896 6657408
01:23:11 75773 8192000000 10880954976 11338031104 1893544736 18.774 97 22 44 2 1908930784 9019344 6366704
01:24:39 51026 8192000000 10868737808 11328987136 1913143584 18.932 98 27 54 1 1932293552 11098192 8051776
01:25:47 68254 8192000000 10880269344 11340140544 1915231760 18.949 98 27 53 1 1935778368 12644288 7902320
01:27:11 9247 8192000000 9186054688 9427787776 344533664 4.035 18 2 4 0 349461024 4512800 414560

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 16-01-2021 01:28:21 to 16-01-2021 01:28:54.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 88 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-01-2021 01:28:54 to 16-01-2021 01:28:56.

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          238076
MON$OLDEST_ACTIVE               238077
MON$OLDEST_SNAPSHOT             238077
MON$NEXT_TRANSACTION            238077
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                       2021440
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
--- end of diff output ---

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

16.01.21 01:28:57. 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-16 01:29:00 No severe PSQL-related problems occured
16.01.21 01:29:01. End of report.