Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.02.2021 16:32
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 17353708 kB
MemAvailable 31218008 kB
Buffers 0 kB
Cached 14333680 kB
SwapCached 4876 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-02-04 16:32:15
DTS_END                         2021-02-04 16:32:15.8650
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/33614
TRN_ID                          233391
ATT_ID                          639
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: 9108.14 21961 1092977
customer order: creation 175.79 375 21095
customer order: refuse 14.48 336 1737
order to supplier: creation 45.60 1344 5472
order to supplier: removal 3.28 119437 393
invoice (draft): creation 46.98 3304 5637
invoice (draft): removal 51.05 828 6126
invoice accept: apply 41.96 18558 5035
invoice accept: cancel 46.46 832 5575
customer reserve: creation 3870.12 183 464414
customer reserve: removal 4516.92 68 542030
realization accept: apply 83.23 175 9987
realization accept: cancel 81.62 111 9794
payment from customer: creation 59.65 117 7158
payment from customer: removal 6.02 64 722
payment to supplier: creation 49.27 120 5912
payment to supplier: removal 3.63 81 435
service: total inventory turnovers 4.78 967 573
service: total monetary turnovers 6.39 24 767
service: aggregate perf. data 0.93 18975 111
service: refresh index statistics 0.03 273313 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-02-2021 16:33:03 to 04-02-2021 16:33:05.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2272
TEST_TIME 2 3241
TEST_TIME 3 3678
TEST_TIME 4 4204
TEST_TIME 5 4076
TEST_TIME 6 3900
TEST_TIME 7 4156
TEST_TIME 8 4326
TEST_TIME 9 4196
TEST_TIME 10 4543
TEST_TIME 11 4541
TEST_TIME 12 4574
TEST_TIME 13 5056
TEST_TIME 14 5379
TEST_TIME 15 5560
TEST_TIME 16 5763
TEST_TIME 17 5843
TEST_TIME 18 6278
TEST_TIME 19 7063
TEST_TIME 20 7015
TEST_TIME 21 7016
TEST_TIME 22 7841
TEST_TIME 23 8358
TEST_TIME 24 8561
TEST_TIME 25 9138
TEST_TIME 26 9385
TEST_TIME 27 9714
TEST_TIME 28 10430
TEST_TIME 29 10469
TEST_TIME 30 10486
TEST_TIME 31 10283
TEST_TIME 32 10210
TEST_TIME 33 10264
TEST_TIME 34 10027
TEST_TIME 35 9995
TEST_TIME 36 9902
TEST_TIME 37 9809
TEST_TIME 38 9764
TEST_TIME 39 9669
TEST_TIME 40 9661
TEST_TIME 41 9506
TEST_TIME 42 9470
TEST_TIME 43 9480
TEST_TIME 44 9437
TEST_TIME 45 9486
TEST_TIME 46 9562
TEST_TIME 47 9614
TEST_TIME 48 9829
TEST_TIME 49 9725
TEST_TIME 50 9716
TEST_TIME 51 9707
TEST_TIME 52 9665
TEST_TIME 53 9720
TEST_TIME 54 9814
TEST_TIME 55 9893
TEST_TIME 56 9838
TEST_TIME 57 9772
TEST_TIME 58 9788
TEST_TIME 59 9691
TEST_TIME 60 9619
TEST_TIME 61 9576
TEST_TIME 62 9523
TEST_TIME 63 9464
TEST_TIME 64 9432
TEST_TIME 65 9488
TEST_TIME 66 9430
TEST_TIME 67 9458
TEST_TIME 68 9520
TEST_TIME 69 9454
TEST_TIME 70 9498
TEST_TIME 71 9461
TEST_TIME 72 9450
TEST_TIME 73 9408
TEST_TIME 74 9494
TEST_TIME 75 9471
TEST_TIME 76 9505
TEST_TIME 77 9517
TEST_TIME 78 9494
TEST_TIME 79 9486
TEST_TIME 80 9391
TEST_TIME 81 9414
TEST_TIME 82 9335
TEST_TIME 83 9302
TEST_TIME 84 9290
TEST_TIME 85 9267
TEST_TIME 86 9261
TEST_TIME 87 9226
TEST_TIME 88 9213
TEST_TIME 89 9172
TEST_TIME 90 9236
TEST_TIME 91 9215
TEST_TIME 92 9230
TEST_TIME 93 9226
TEST_TIME 94 9251
TEST_TIME 95 9281
TEST_TIME 96 9368
TEST_TIME 97 9319
TEST_TIME 98 9312
TEST_TIME 99 9349
TEST_TIME 100 9365
TEST_TIME 101 9345
TEST_TIME 102 9400
TEST_TIME 103 9364
TEST_TIME 104 9312
TEST_TIME 105 9277
TEST_TIME 106 9246
TEST_TIME 107 9265
TEST_TIME 108 9230
TEST_TIME 109 9185
TEST_TIME 110 9152
TEST_TIME 111 9135
TEST_TIME 112 9120
TEST_TIME 113 9124
TEST_TIME 114 9096
TEST_TIME 115 9131
TEST_TIME 116 9132
TEST_TIME 117 9171
TEST_TIME 118 9149
TEST_TIME 119 9173
TEST_TIME 120 9111

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-02-2021 16:33:06 to 04-02-2021 16:33:10.

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 1522322 1522322 0 0.00 0 24353 6 0 0
doc_list_biud 1522322 1522322 0 0.00 0 30937 30 0 0
sp_add_invoice_to_stock 5138 5035 103 2.00 22 183858 18558 0 103
sp_cancel_adding_invoice 5575 5575 0 0.00 3 60497 832 0 0
sp_cancel_client_order 1737 1737 0 0.00 4 10876 337 0 0
sp_cancel_customer_reserve 542030 542030 0 0.00 1 30941 68 0 0
sp_cancel_pay_from_customer 722 722 0 0.00 2 4554 65 0 0
sp_cancel_pay_to_supplier 435 435 0 0.00 3 4261 81 0 0
sp_cancel_supplier_invoice 6140 6126 14 0.22 2 22377 828 0 14
sp_cancel_supplier_order 393 393 0 0.00 9 1411335 119438 0 0
sp_cancel_write_off 9794 9794 0 0.00 1 11769 112 0 0
sp_client_order 21095 21095 0 0.00 3 24637 375 0 0
sp_customer_reserve 464414 464414 0 0.00 0 60863 184 0 0
sp_fill_shopping_cart 32195 32195 0 0.00 1 9208 36 0 0
sp_fill_shopping_cart_clo_res 464403 464403 0 0.00 0 14233 15 0 0
sp_get_clo_for_invoice 5024 5024 0 0.00 0 25649 330 0 0
sp_kill_cost_storno 16526 16526 0 0.00 0 8295 57 0 0
sp_kill_qstorno_ret_qs2qd 1100373 1100373 0 0.00 0 30933 37 0 0
sp_kill_qty_storno 580666 580666 0 0.00 0 30937 78 0 0
sp_lock_selected_doc 20817 20817 0 0.00 0 6854 6 0 0
sp_make_cost_storno 28081 28081 0 0.00 0 24312 51 0 0
sp_multiply_rows_for_pdistr 28081 28081 0 0.00 0 7809 30 0 0
sp_multiply_rows_for_qdistr 21095 21095 0 0.00 0 23119 176 0 0
sp_pay_from_customer 7158 7158 0 0.00 4 11928 117 0 0
sp_pay_to_supplier 5912 5912 0 0.00 4 14270 121 0 0
sp_payment_common 13070 13070 0 0.00 1 8301 28 0 0
sp_qd_handle_on_cancel_clo 1737 1737 0 0.00 0 8891 302 0 0
sp_qd_handle_on_invoice_upd_sts 10599 10599 0 0.00 0 25098 353 0 0
sp_qd_handle_on_reserve_upd_sts 9987 9987 0 0.00 0 21602 58 0 0
sp_reserve_write_off 9987 9987 0 0.00 6 21826 176 0 0
sp_supplier_invoice 5637 5637 0 0.00 7 75688 3304 0 0
sp_supplier_order 5472 5472 0 0.00 5 66825 1345 0 0
srv_aggregate_perf_data 111 111 0 0.00 2201 207625 18975 0 0
srv_fill_mon_cache_memory 172 172 0 0.00 1198 128797 30388 0 0
srv_find_qd_qs_mism 1044387 1044387 0 0.00 0 15427 6 0 0
srv_make_invnt_saldo 573 573 0 0.00 26 56904 968 0 0
srv_make_money_saldo 767 767 0 0.00 1 928 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 193678 403130 273314 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 14 14 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5035 5035 0 0.00 0 23826 201 0 0
t$perf-norm:sp_cancel_adding_invoice 420 420 0 0.00 0 12821 122 0 0
t$perf-norm:sp_cancel_client_order 1737 1737 0 0.00 0 6127 15 0 0
t$perf-norm:sp_cancel_customer_reserve 693 693 0 0.00 0 7704 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 722 722 0 0.00 0 3156 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 435 435 0 0.00 0 408 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 413 413 0 0.00 0 1941 18 0 0
t$perf-norm:sp_cancel_supplier_order 393 393 0 0.00 0 31523 1652 0 0
t$perf-norm:sp_cancel_write_off 994 994 0 0.00 0 3419 10 0 0
t$perf-norm:sp_client_order 21095 21095 0 0.00 0 18641 24 0 0
t$perf-norm:sp_customer_reserve 994 994 0 0.00 0 1014 7 0 0
t$perf-norm:sp_pay_from_customer 7158 7158 0 0.00 0 10376 14 0 0
t$perf-norm:sp_pay_to_supplier 5912 5912 0 0.00 0 14771 17 0 0
t$perf-norm:sp_reserve_write_off 9987 9987 0 0.00 0 13842 14 0 0
t$perf-norm:sp_supplier_invoice 5637 5637 0 0.00 0 4739 16 0 0
t$perf-norm:sp_supplier_order 5472 5472 0 0.00 0 7378 17 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 155 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 377 3 0 0
t$perf-norm:srv_make_invnt_saldo 573 573 0 0.00 0 686 18 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 1048 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 9 5 0 0
v_add_invoice_to_stock 10252 10046 206 2.00 0 4423 16 0 206
v_all_customers 38232 38232 0 0.00 0 154 1 0 0
v_all_suppliers 30814 30814 0 0.00 0 151 1 0 0
v_all_wares 42186 42186 0 0.00 0 150 1 0 0
v_cancel_adding_invoice 840 840 0 0.00 0 1076 7 0 0
v_cancel_client_order 3474 3474 0 0.00 0 2955 7 0 0
v_cancel_customer_prepayment 1444 1444 0 0.00 0 2766 6 0 0
v_cancel_customer_reserve 1386 1386 0 0.00 0 1973 5 0 0
v_cancel_payment_to_supplier 870 870 0 0.00 0 2943 11 0 0
v_cancel_supplier_invoice 854 826 28 3.27 0 3352 20 0 28
v_cancel_supplier_order 786 786 0 0.00 0 2948 10 0 0
v_cancel_write_off 1988 1988 0 0.00 0 3194 15 0 0
v_max_id_clo_ord 5472 5472 0 0.00 0 3528 2 0 0
v_max_id_clo_res 994 994 0 0.00 0 3622 13 0 0
v_max_id_ord_sup 5630 5630 0 0.00 0 4830 5 0 0
v_max_non_paid_invoice 1607 1607 0 0.00 0 2736 5 0 0
v_max_non_paid_realizn 3841 3841 0 0.00 0 2736 3 0 0
v_min_id_clo_ord 5472 5472 0 0.00 0 3409 6 0 0
v_min_id_clo_res 994 994 0 0.00 0 5348 19 0 0
v_min_id_ord_sup 5630 5630 0 0.00 0 6086 5 0 0
v_min_non_paid_invoice 5912 5912 0 0.00 0 7019 17 0 0
v_min_non_paid_realizn 7158 7158 0 0.00 0 5846 18 0 0
v_our_firm 10588 10588 0 0.00 0 152 1 0 0
v_reserve_write_off 19974 19974 0 0.00 0 3630 7 0 0
x_lock_depdocs_on_canc_invoice 11288 11288 0 0.00 0 28708 159 0 0
x_lock_depdocs_on_canc_sup_ord 393 393 0 0.00 0 6179 361 0 0
x_make_qstorno_1000_1200 5472 5472 0 0.00 2 66651 1270 0 0
x_make_qstorno_1200_2000 5637 5637 0 0.00 3 75409 3178 0 0
x_make_qstorno_2100_3300 464414 464414 0 0.00 0 60622 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-02-2021 16:33:11 to 04-02-2021 16:33:15.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:02:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:25 27411 8192000000 10260419424 10569744384 891268768 9.812 70 48 99 0 909360320 2624368 15467184
14:03:00 26257 8192000000 10352171072 10668044288 1400555808 14.600 100 87 174 0 1433728496 4718960 28453728
14:03:38 28372 8192000000 10381608960 10704072704 1432287792 14.882 100 83 166 0 1465631184 6474864 26868528
14:04:19 29119 8192000000 10418538352 10744037376 1467168976 15.189 100 89 178 0 1503090352 7396704 28524672
14:05:02 16802 8192000000 10431475888 10759979008 1483123568 15.329 100 89 178 0 1519799072 8250944 28424560
14:05:31 28519 8192000000 10450719536 10784563200 1502699056 15.500 100 88 176 0 1539763360 9176112 27888192
14:06:10 21105 8192000000 10470050656 10809266176 1524982736 15.693 100 87 174 1 1561793280 9645808 27164736
14:06:48 19280 8192000000 10490800672 10838577152 1551273248 15.921 100 79 158 3 1585539632 10121232 24145152
14:07:16 16415 8192000000 10520357552 10868129792 1576098768 16.135 100 82 164 1 1611484352 10289824 25095760
14:07:41 11135 8192000000 10527452464 10882404352 1592654976 16.277 100 79 159 0 1626391440 9921296 23815168
14:08:01 23676 8192000000 10568706400 10925780992 1617109296 16.485 100 79 158 2 1651377888 10762080 23506512
14:08:42 9239 8192000000 10589556992 10951700480 1643835552 16.712 100 71 140 2 1675766704 11279760 20651392
14:09:01 11872 8192000000 10600759376 10964365312 1661178976 16.859 100 76 152 2 1694687376 11317168 22191232
14:09:21 8156 8192000000 10620348128 10987057152 1676927664 16.991 100 78 156 2 1711930688 12318272 22684752
14:09:36 10597 8192000000 10627669440 10995486720 1689905504 17.101 100 84 168 0 1726635024 12207264 24522256
14:09:56 7612 8192000000 10641366656 11009458176 1697014528 17.160 100 73 146 2 1730881712 13253664 20613520
14:10:12 6025 8192000000 10644150704 11023642624 1713681680 17.299 100 75 151 0 1748159872 13050928 21427264
14:10:30 6804 8192000000 10667921184 11046658048 1737819760 17.501 100 77 154 2 1772614720 12652000 22142960
14:10:46 6522 8192000000 10677820944 11056951296 1744313216 17.554 100 72 144 1 1776841728 12195472 20333040
14:11:00 6065 8192000000 10690044288 11072806912 1758102512 17.669 100 81 159 0 1793037424 12004032 22930880
14:11:15 6488 8192000000 10707976800 11087212544 1760798496 17.691 100 72 147 1 1793548896 12804544 19945856
14:11:29 4765 8192000000 10708496880 11088543744 1775565440 17.813 100 80 160 1 1811208432 13150800 22492192
14:11:46 8215 8192000000 10707541664 11096117248 1777027472 17.825 100 62 124 0 1806570896 11950640 17592784
14:12:02 3111 8192000000 10737705408 11120504832 1799524656 18.010 100 82 164 1 1834147936 11230864 23392416
14:12:13 3748 8192000000 10752909328 11133280256 1805409584 18.058 100 85 166 0 1841154656 12301568 23443504
14:12:23 3424 8192000000 10752476192 11135512576 1813878368 18.128 100 89 178 2 1853126032 14249840 24997824
14:12:33 3190 8192000000 10757621840 11141033984 1820456576 18.181 100 84 168 0 1856735408 12935168 23343664
14:12:43 1318 8192000000 10761059744 11147268096 1825885088 18.226 100 91 183 5 1864256240 13101856 25269296
14:12:51 3017 8192000000 10763181648 11155189760 1831313776 18.270 100 81 162 0 1866173504 11760000 23099728
14:13:00 2838 8192000000 10773201232 11160510464 1835955376 18.308 100 88 172 1 1873330224 12777232 24597616
14:13:09 3036 8192000000 10766972288 11163181056 1840971232 18.349 100 81 160 1 1874908288 11468880 22468176
14:13:19 1952 8192000000 10783681664 11171426304 1841851280 18.356 100 88 177 1 1879120224 12977728 24291216
14:13:27 2574 8192000000 10788396768 11171233792 1844457216 18.377 100 85 170 1 1881122944 13153120 23512608
14:13:38 1194 8192000000 10792590064 11179036672 1849310880 18.417 100 89 179 2 1888982640 13734368 25937392
14:13:45 2851 8192000000 10790702256 11176919040 1852151552 18.440 100 93 186 0 1893282128 14628672 26501904
14:13:55 2160 8192000000 10800770016 11185967104 1851691520 18.436 100 95 189 1 1893523392 14816512 27015360
14:14:03 9777 8192000000 10800413152 11185152000 1853927856 18.454 100 88 172 0 1890118624 11916736 24274032
14:14:19 2469 8192000000 10806735472 11195138048 1860819664 18.510 100 90 179 1 1898722048 12561600 25340784
14:14:28 22418 8192000000 10803938208 11192168448 1862401824 18.523 100 69 138 0 1892833360 10911504 19520032
14:14:57 17669 8192000000 10785055872 11191234560 1859994512 18.503 100 47 93 0 1881962784 7956720 14011552
14:15:21 4904 8192000000 10765203760 11185389568 1857470768 18.483 100 25 50 1 1872446592 7626336 7349488
14:15:35 5209 8192000000 10773658464 11194449920 1863446736 18.531 100 33 63 0 1880327888 7966224 8914928
14:15:47 6275 8192000000 10774648208 11194089472 1865149984 18.545 100 31 61 0 1881302912 6928016 9224912
14:16:01 7583 8192000000 10774608592 11199942656 1866657696 18.557 100 27 51 1 1880146288 6316528 7172064
14:16:17 7200 8192000000 10774142704 11200090112 1871162704 18.594 100 29 58 2 1885665504 6465168 8037632
14:16:33 10635 8192000000 10777189040 11201896448 1872772112 18.607 100 21 41 1 1885387760 6754240 5861408
14:16:53 5282 8192000000 10774730528 11205611520 1874363376 18.620 100 29 58 1 1889467760 7312992 7791392
14:17:06 6257 8192000000 10777613392 11207872512 1875682896 18.630 100 21 42 1 1887828704 5650560 6495248
14:17:22 7834 8192000000 10771730784 11208744960 1876600976 18.638 100 23 46 0 1890184720 6984720 6599024
14:17:36 8530 8192000000 10776319328 11208232960 1879315968 18.660 100 21 42 1 1891486832 6664272 5506592
14:17:53 9262 8192000000 10786542368 11219460096 1879922176 18.664 100 24 48 2 1892946608 6671200 6353232
14:18:09 10108 8192000000 10796440064 11223625728 1886009824 18.714 100 32 65 0 1901494304 6766656 8717824
14:18:26 11061 8192000000 10811218848 11226345472 1887199808 18.723 100 31 62 5 1901628368 5698368 8730192
14:18:47 24432 8192000000 10795076816 11233148928 1889873200 18.745 100 37 73 0 1906411248 5446144 11091904
14:19:25 53279 8192000000 10824274288 11238281216 1895738464 18.792 100 47 94 3 1914241856 5211392 13292000
14:20:25 1449 8192000000 10858151984 11255558144 1907380080 18.886 100 99 201 0 1947416208 11604016 28432112
14:20:33 5589 8192000000 10813563488 11242766336 1896913824 18.801 100 28 56 1 1913059696 8784944 7360928
14:20:47 4828 8192000000 10821127952 11248361472 1901322512 18.837 100 38 76 1 1924689856 13077936 10289408
14:20:58 6400 8192000000 10810746064 11244965888 1904884384 18.866 100 25 50 0 1918577728 7018288 6675056
14:21:11 4418 8192000000 10827762240 11252895744 1905445344 18.870 100 31 60 1 1921140960 6224608 9471008
14:21:22 6860 8192000000 10833082944 11253628928 1906510640 18.879 100 25 45 4 1918576592 5841408 6224544
14:21:36 40022 8192000000 10826743392 11257614336 1907367280 18.886 100 28 55 2 1922374048 6289248 8717520
14:22:25 6664 8192000000 10820170480 11253420032 1908467248 18.894 100 20 40 1 1920641856 6346784 5827824
14:22:38 9312 8192000000 10833715872 11259666432 1907954112 18.890 100 25 46 2 1919873344 5864912 6054320
14:22:55 6627 8192000000 10823724400 11248660480 1887465104 18.725 99 34 66 2 1902561040 6075360 9020576
14:23:08 3440 8192000000 10824880368 11255103488 1906537104 18.879 100 30 60 0 1922789984 6911936 9340944
14:23:19 6139 8192000000 10829139888 11245449216 1882868768 18.688 99 52 105 1 1906506352 9042384 14595200
14:23:35 5755 8192000000 10800066848 11233615872 1888711696 18.735 100 24 49 0 1901585904 5873072 7001136
14:23:47 6785 8192000000 10775307184 11204808704 1849312304 18.417 98 23 46 1 1863705712 6968016 7425392
14:24:01 7958 8192000000 10763072480 11195785216 1843551440 18.370 98 23 47 1 1855896080 5691552 6653088
14:24:17 4836 8192000000 10774590400 11196035072 1819189152 18.171 97 28 54 5 1832143776 5239584 7715040
14:24:28 10179 8192000000 10736686720 11160502272 1744327040 17.555 94 23 46 4 1755843552 5316832 6199680
14:24:47 5609 8192000000 10738953984 11162968064 1810701760 18.102 99 26 52 0 1828511248 9890128 7919360
14:24:59 7187 8192000000 10732598256 11156668416 1777591536 17.830 97 17 33 2 1788406672 4955312 5859824
14:25:12 12176 8192000000 10738998800 11135897600 1688453088 17.088 92 43 86 2 1704231600 4493280 11285232
14:25:32 68448 8192000000 10726061808 11152715776 1747544048 17.581 96 25 49 2 1764602208 9949808 7108352
14:26:47 22354 8192000000 10596256224 10987724800 1613375616 16.453 89 23 47 4 1624611872 5198032 6038224
14:27:16 4232 8192000000 10668015072 11085074432 1737398672 17.497 98 32 63 1 1752524816 6503328 8622816
14:27:27 5544 8192000000 10683129872 11107176448 1764430976 17.721 99 25 50 0 1778129056 6350096 7347984
14:27:43 8903 8192000000 10673757008 11086233600 1712978480 17.294 96 24 49 1 1726171232 6560592 6632160
14:28:02 9152 8192000000 10707807808 11125858304 1777084368 17.825 99 33 66 3 1796176192 9936624 9155200
14:28:20 7278 8192000000 10719772864 11137593344 1772651872 17.789 98 27 54 0 1790184720 9932848 7600000
14:28:34 9786 8192000000 10721710192 11147005952 1795616208 17.978 99 15 30 0 1804987648 5385248 3986192
14:28:53 15568 8192000000 10746179568 11163127808 1821596992 18.191 100 19 38 2 1832910816 5766704 5547120
14:29:15 14121 8192000000 10746750672 11172007936 1833644560 18.289 100 24 48 2 1850382800 9463104 7275136
14:29:36 9215 8192000000 10757758272 11174383616 1838906496 18.332 100 33 66 3 1854314064 5626960 9780608
14:29:51 16553 8192000000 10757888624 11179487232 1839640400 18.338 100 28 56 1 1853242400 5016400 8585600
14:30:14 8304 8192000000 10745330304 11173490688 1841873296 18.356 100 20 40 0 1853570432 5850624 5846512
14:30:29 50494 8192000000 10786895184 11196710912 1854789600 18.461 100 26 52 0 1867779008 5158416 7830992
14:31:27 30741 8192000000 10766858864 11203260416 1858779632 18.493 100 24 48 1 1875222784 9526416 6916736
14:32:04 10419 8192000000 10785900832 11212931072 1870906656 18.592 100 21 42 1 1881674864 5127264 5640944
14:32:22 56550 8192000000 10812353680 11233746944 1888868272 18.737 100 37 74 2 1908051184 8241312 10941600
14:33:29 11710 8192000000 10840027632 11255500800 1907153024 18.884 100 54 107 1 1933530704 11423120 14954560
14:33:50 28684 8192000000 10848511120 11273523200 1916016688 18.955 100 57 114 3 1946545760 14775072 15754000
14:34:28 15524 8192000000 10866282224 11289481216 1923552576 19.015 100 42 84 0 1955339696 19800944 11986176
14:34:54 19407 8192000000 10865572272 11294281728 1925792080 19.033 100 41 82 0 1957500080 20064224 11643776
14:35:26 15254 8192000000 10881528336 11307671552 1941037312 19.155 100 47 94 0 1975461296 21136048 13287936
14:35:50 29108 8192000000 10882597360 11314724864 1943913984 19.178 100 49 96 3 1982077888 23439904 14724000
14:36:35 15020 8192000000 10883958336 11317211136 1945356848 19.189 100 41 81 1 1979380192 22006208 12017136
14:37:00 28097 8192000000 10897056544 11320893440 1949305776 19.221 100 41 82 2 1983973920 22555296 12112848
14:37:42 14284 8192000000 10891145040 11325272064 1952150752 19.244 100 42 82 2 1987488160 23062112 12275296
14:38:05 15906 8192000000 10895175472 11331706880 1959043712 19.298 100 39 78 1 1993917728 22772320 12101696
14:38:30 15331 8192000000 10915147680 11349700608 1968175184 19.371 100 42 86 0 2004669456 23826096 12668176
14:38:52 10888 8192000000 10928716272 11357528064 1983401888 19.492 100 60 121 0 2027631040 26288864 17940288
14:39:11 42745 8192000000 10936616656 11376525312 1982060784 19.481 100 49 97 3 2026927440 30390128 14476528
14:40:26 32696 8192000000 10940339376 11382796288 1991331264 19.554 100 35 66 1 2031101888 28791088 10979536
14:41:16 3700 8192000000 10949520832 11386142720 1999745776 19.621 100 52 104 1 2043893360 28050656 16096928
14:41:26 4355 8192000000 10960821984 11388833792 2003632176 19.651 100 59 115 2 2050705328 29629408 17443744
14:41:38 6258 8192000000 10969289504 11399737344 2007840544 19.685 100 66 132 3 2062489680 35715808 18933328
14:41:54 17575 8192000000 10970153488 11399782400 2010073744 19.702 100 67 134 0 2062404240 32294912 20035584
14:42:26 6972 8192000000 10980315776 11411058688 2013929536 19.732 100 65 130 4 2069908208 37035104 18943568
14:42:46 7916 8192000000 10979865248 11416195072 2015721056 19.747 100 52 104 0 2069016320 37246336 16048928
14:43:01 4954 8192000000 10989560672 11416514560 2018767024 19.770 100 66 128 2 2075336320 36191840 20377456
14:43:16 2548 8192000000 10989742736 11418292224 2022378448 19.799 100 67 131 1 2078398752 35494496 20525808
14:43:27 6362 8192000000 11004624160 11424829440 2026654448 19.832 100 82 164 1 2089181536 38057168 24469920
14:43:43 13505 8192000000 10994389424 11424735232 2023848384 19.810 100 63 127 0 2082773040 39601376 19323280
14:44:05 4667 8192000000 10993283232 11427184640 2029843200 19.857 100 75 149 1 2092212880 39666736 22702944
14:44:19 4070 8192000000 11000121440 11426697216 2023914464 19.811 100 71 138 0 2085477424 40105456 21457504
14:44:32 13514 8192000000 10994249216 11418832896 2018338208 19.767 100 75 149 0 2083662016 42817744 22506064
14:45:00 2944 8192000000 11008436704 11429408768 2022470832 19.800 100 69 137 0 2091267568 46808976 21987760
14:45:13 4513 8192000000 11016552624 11435806720 2029591376 19.855 100 84 168 0 2101679488 46365520 25722592
14:45:25 6192 8192000000 11016260736 11447320576 2032733984 19.880 100 70 140 0 2103100464 48359568 22006912
14:45:40 5602 8192000000 11019637264 11451367424 2035476752 19.902 100 66 132 0 2105624256 49522256 20625248
14:46:03 7016 8192000000 11015675760 11453509632 2041633760 19.950 100 72 141 3 2109692576 46173504 21885312
14:46:19 2117 8192000000 11044150928 11462709248 2048394992 20.003 100 91 180 6 2124242096 48475696 27371408
14:46:28 2181 8192000000 11019424768 11442323456 2029613296 19.856 100 88 174 4 2102891248 47304896 25973056
14:46:37 2232 8192000000 11015423712 11445133312 2033608304 19.887 100 75 150 1 2104651504 47639664 23403536
14:46:49 1746 8192000000 11001929408 11423440896 2008126800 19.687 99 69 136 0 2078074912 48832960 21115152
14:46:59 3231 8192000000 11021980816 11443081216 2029407152 19.854 100 81 161 3 2104239568 50036288 24796128
14:47:09 5463 8192000000 11017960576 11448532992 2027984880 19.843 100 68 136 2 2100625456 50803072 21837504
14:47:27 8477 8192000000 11026774816 11456933888 2036002256 19.906 100 77 148 4 2113366944 53383264 23981424
14:47:45 6003 8192000000 11029633872 11461246976 2038719072 19.927 100 64 128 1 2112932784 53122288 21091424
14:48:01 4032 8192000000 11025226240 11464081408 2042993968 19.960 100 65 130 1 2118622640 53400464 22228208
14:48:16 1900 8192000000 11024629008 11454189568 2023183776 19.805 99 73 143 3 2097217184 51619136 22414272
14:48:27 3873 8192000000 11025001136 11458531328 2037055072 19.914 100 64 126 1 2109993408 53125024 19813312
14:48:38 5354 8192000000 11027358656 11455250432 2034311792 19.892 100 80 159 1 2113322112 54597392 24412928
14:48:54 1649 8192000000 11043413824 11459948544 2036414912 19.909 100 94 187 0 2124323328 58391440 29516976
14:49:03 3159 8192000000 11021445696 11441672192 2016677568 19.754 100 82 162 0 2102602528 60032336 25892624
14:49:15 4042 8192000000 11012378000 11435999232 2003932272 19.654 99 78 154 0 2088736112 60820752 23983088
14:49:26 1436 8192000000 11035971744 11453693952 2027553344 19.839 100 93 185 1 2117815696 61736880 28525472
14:49:38 3233 8192000000 11034484608 11460698112 2028792992 19.849 100 79 158 0 2120989120 67229008 24967120
14:49:53 2593 8192000000 11034107424 11456532480 2026686320 19.833 100 81 163 1 2115856128 63296208 25873600
14:50:05 1915 8192000000 11044555296 11463528448 2033725424 19.888 100 90 179 1 2127168640 65219808 28223408
14:50:14 2562 8192000000 11043492592 11466088448 2036180960 19.907 100 79 158 1 2126293520 65817424 24295136
14:50:23 3715 8192000000 11025976816 11452436480 2008893552 19.693 99 75 150 0 2098548816 66430224 23225040
14:50:33 1521 8192000000 11044497696 11459366912 2028462224 19.847 100 95 191 0 2121196752 63865264 28869264
14:50:42 2836 8192000000 11008897056 11430240256 2008598528 19.690 99 82 162 1 2097622864 63712144 25312192
14:50:54 4622 8192000000 11022927008 11443896320 2012610304 19.722 100 77 155 0 2102328064 65235312 24482448
14:51:06 3284 8192000000 11014973792 11435016192 2010425872 19.705 100 76 151 1 2093998704 60010624 23562208
14:51:15 1207 8192000000 11020351248 11442683904 2018960928 19.772 100 82 164 1 2105666912 60658128 26047856
14:51:26 2467 8192000000 11006811504 11431170048 2002589504 19.643 100 82 163 1 2093355664 64590400 26175760
14:51:34 6582 8192000000 10999237664 11428102144 1998726880 19.613 100 66 132 1 2081094384 61079872 21287632
14:51:48 7707 8192000000 10966146048 11410817024 1954444080 19.262 98 50 100 2 2034818640 64036848 16337712
14:52:03 7621 8192000000 10966902528 11411918848 1979846976 19.463 100 39 78 0 2053428048 60165552 13415520
14:52:31 15532 8192000000 10987968608 11422736384 1975030992 19.425 99 55 110 0 2056357904 62830352 18496560
14:52:56 6517 8192000000 10989512992 11428999168 1992238128 19.561 100 56 111 0 2076540784 65613328 18689328
14:53:11 1978 8192000000 10963414336 11380105216 1945501904 19.191 98 75 149 0 2037121728 66890160 24729664
14:53:20 3404 8192000000 10997105184 11421966336 1984550560 19.501 100 76 152 2 2079048608 69296464 25201584
14:53:32 3630 8192000000 11008053856 11432460288 1991312112 19.554 100 76 152 2 2087145264 71712944 24120208
14:53:45 2457 8192000000 11028165936 11445600256 2005736736 19.668 100 88 171 1 2106289312 73246064 27306512
14:53:54 1198 8192000000 11035179600 11454861312 2011134576 19.710 100 90 180 0 2115599040 76027264 28437200
14:54:02 3340 8192000000 11027181360 11459223552 2012191120 19.719 100 73 146 1 2110246672 74890256 23165296
14:54:18 12271 8192000000 10998525840 11451584512 2004096832 19.655 100 45 89 4 2086171664 67062384 15012448
14:54:42 17784 8192000000 10994456688 11446341632 2000052816 19.623 100 42 84 3 2080282208 65209888 15019504
14:55:09 6705 8192000000 10977207504 11431862272 1977382560 19.444 99 41 82 0 2055375056 63586736 14405760
14:55:22 7484 8192000000 10985675840 11429154816 1983051296 19.489 100 38 76 1 2059190864 63416448 12723120
14:55:39 20608 8192000000 10954950304 11419537408 1936558752 19.119 97 41 82 0 2014827280 63514304 14754224
14:56:10 11533 8192000000 10961043040 11401818112 1965832592 19.352 100 37 74 1 2042999248 64539952 12626704
14:56:28 21951 8192000000 10933681984 11383709696 1924407200 19.022 98 29 58 1 1995877360 61588448 9881712
14:56:57 27755 8192000000 10921277648 11381100544 1909401360 18.902 98 28 55 1 1977114960 58002320 9711280
14:58:00 25925 8192000000 10885351440 11351736320 1902376656 18.845 99 18 36 2 1962359488 53747808 6235024
14:58:32 14211 8192000000 10888349824 11361771520 1919021360 18.979 100 13 26 0 1978158096 54493600 4643136
14:58:54 11478 8192000000 10892049296 11342225408 1899110720 18.819 99 26 52 0 1956240160 48698304 8431136
14:59:13 28252 8192000000 10886382896 11353280512 1909700800 18.904 100 17 34 0 1969882256 54355040 5826416
14:59:48 31282 8192000000 10856624896 11331989504 1888498448 18.734 99 13 26 0 1937195760 44042176 4655136
15:00:27 12832 8192000000 10873630256 11323195392 1897842064 18.809 99 23 46 0 1929068416 24109200 7117152
15:00:53 13091 8192000000 10857336624 11311874048 1897674032 18.808 98 22 44 4 1920024224 15407344 6942848
15:01:14 51340 8192000000 10842826272 11307569152 1901457696 18.838 99 21 43 1 1920232352 12638128 6136528
15:02:13 80366 8192000000 10836591920 11291656192 1853496928 18.451 97 17 32 1 1867339200 9318544 4523728
15:03:48 45714 8192000000 10823628160 11275042816 1801831184 18.029 94 17 33 0 1813304352 6878576 4594592
15:04:57 75622 8192000000 10837962256 11303194624 1882961920 18.689 98 28 56 0 1900505920 10200896 7343104
15:06:40 32179 8192000000 10872381984 11319595008 1896152256 18.795 98 29 58 0 1911104880 7010304 7942320
15:07:22 34067 8192000000 10870808368 11336351744 1942960080 19.170 100 33 64 1 1961983424 10065392 8957952
15:08:05 19815 8192000000 10905246928 11345928192 1958820144 19.297 100 53 104 1 1982143792 7969440 15354208
15:08:35 10025 8192000000 10894465536 11338555392 1946298848 19.197 99 63 126 1 1973158400 7976976 18882576
15:08:55 39771 8192000000 10884792688 11330359296 1933437632 19.094 99 62 124 0 1961015184 9186160 18391392
15:09:41 3101 8192000000 10908700880 11342491648 1957286832 19.284 100 61 120 2 1985713536 10945840 17480864
15:09:50 29103 8192000000 10885650048 11343560704 1936722928 19.121 99 26 51 1 1955422992 11694464 7005600
15:10:30 28070 8192000000 10889294000 11350626304 1952958656 19.250 100 20 40 3 1973015888 14311600 5745632
15:11:05 50208 8192000000 10873005648 11341582336 1921442464 18.998 98 26 52 0 1944591424 15517600 7631360
15:12:02 22143 8192000000 10874146960 11346448384 1949182688 19.220 100 7 14 0 1967833792 16480288 2170816
15:12:31 32659 8192000000 10880145488 11352367104 1945390336 19.190 100 11 22 0 1963182384 14619472 3172576
15:13:50 56464 8192000000 10877346272 11339866112 1943083408 19.171 100 18 37 0 1967210656 18817936 5309312
15:15:16 89071 8192000000 10912825200 11376386048 1957262928 19.284 100 22 43 0 1985993376 22016240 6714208
15:17:57 55787 8192000000 10884100112 11340910592 1908457792 18.894 98 16 32 0 1927904544 14830912 4615840
15:19:03 50472 8192000000 10880055280 11363651584 1954712592 19.264 100 17 34 1 1978376560 18667264 4996704
15:20:00 69769 8192000000 10880958768 11349823488 1928060112 19.051 99 11 21 3 1957666912 25908608 3698192
15:21:17 39086 8192000000 10898311232 11345649664 1941421472 19.158 99 36 73 1 1960234544 9130112 9682960
15:22:09 50742 8192000000 10887437872 11356508160 1955169504 19.268 100 23 46 0 1974389488 12840080 6379904
15:23:08 73625 8192000000 10895735248 11361820672 1946402352 19.198 99 22 44 1 1970566528 17201632 6962544
15:24:29 55657 8192000000 10905038688 11381518336 1976038400 19.433 100 36 70 3 2003588144 17080560 10469184
15:25:36 73917 8192000000 10902684864 11379191808 1953230352 19.252 99 9 18 0 1972794240 16951344 2612544
15:27:07 32885 8192000000 10898984736 11360329728 1951414000 19.238 99 17 34 2 1966254128 10366736 4473392
15:27:47 77678 8192000000 10876264864 11320561664 1813895056 18.128 92 20 40 0 1828366208 9222864 5248288
15:29:13 27833 8192000000 10896121552 11346882560 1952741584 19.248 100 37 74 0 1972350896 9482592 10126720
15:29:47 11278 8192000000 10910824464 11351212032 1961434496 19.317 100 44 88 0 1983130160 8939760 12755904
15:30:08 14949 8192000000 10909319328 11354615808 1948439328 19.214 99 43 86 3 1970123376 9274176 12409872
15:30:35 15772 8192000000 10893614448 11350540288 1940947312 19.154 99 34 68 2 1962142128 12123488 9071328
15:30:59 117924 8192000000 10872517280 11336892416 1918593984 18.976 98 29 58 1 1938456208 11451584 8410640
15:33:04 68782 8192000000 10877489984 11355787264 1954077824 19.259 100 13 26 0 1968921248 11249744 3593680
15:34:19 6633 8192000000 10871734176 11359014912 1956809664 19.281 100 2 4 0 1968530704 11596416 124624
15:34:32 2619 8192000000 10874836976 11359453184 1959942464 19.306 100 4 8 0 1969542240 9076144 523632
15:34:41 2981 8192000000 10915780752 11359854592 1971602112 19.398 100 63 125 2 1996249376 6311376 18335888
15:34:52 40681 8192000000 10913900448 11369775104 1979860928 19.464 100 41 82 1 2003472512 12392016 11219568
15:37:29 31010 8192000000 10882965408 11364921344 1948759504 19.217 99 8 16 0 1962019632 11213712 2046416
15:38:06 25730 8192000000 10885068976 11367927808 1948833632 19.217 99 9 18 1 1961742464 10064176 2844656
15:38:38 49250 8192000000 10902569360 11387617280 1967676432 19.367 100 14 28 2 1984405840 12593792 4135616
15:39:33 69234 8192000000 10898855856 11368349696 1919370128 18.982 97 14 28 2 1937625728 13876224 4379376
15:40:49 33670 8192000000 10888991616 11342696448 1898259360 18.812 96 19 38 1 1911117904 7693776 5164768
15:41:29 62688 8192000000 10875709744 11348496384 1923508816 19.015 98 42 84 0 1945970912 10142992 12319104
15:42:46 36446 8192000000 10871330080 11326365696 1882442304 18.685 96 26 52 1 1896355264 5901696 8011264
15:43:31 27133 8192000000 10883023392 11347611648 1937682544 19.128 99 36 71 2 1954938432 7434688 9821200
15:44:05 45693 8192000000 10896066432 11343540224 1898704480 18.816 97 38 76 4 1920191872 9765904 11721488
15:45:00 47606 8192000000 10884183936 11334832128 1899252560 18.820 97 32 65 0 1918187104 10099200 8835344
15:45:57 40479 8192000000 10875302144 11341664256 1914146752 18.940 98 32 64 0 1936180416 13313456 8720208
15:46:52 63630 8192000000 10897049152 11360727040 1936932544 19.122 99 16 32 0 1951226320 10112704 4181072
15:48:08 75233 8192000000 10856803616 11316166656 1848963712 18.414 94 28 56 0 1868408480 11736752 7708016
15:49:34 77505 8192000000 10854715744 11304091648 1812523536 18.117 93 27 54 2 1831020000 11003024 7493440
15:51:04 128797 8192000000 10856262656 11323322368 1878016448 18.649 97 21 42 0 1892198576 8279776 5902352
15:53:25 56615 8192000000 10861761824 11341000704 1912810688 18.929 98 19 38 0 1931908256 13707008 5390560
15:54:39 15827 8192000000 10858694496 11326623744 1883316928 18.692 97 17 34 0 1900985632 12999920 4668784
15:55:01 40127 8192000000 10853661152 11312627712 1860642160 18.508 96 31 62 0 1886546576 16715104 9189312
15:55:50 51110 8192000000 10852508832 11331727360 1936065040 19.115 100 15 30 0 1954643984 13712768 4866176
15:56:48 63488 8192000000 10870995216 11355541504 1936584000 19.119 100 10 20 0 1953160848 13943408 2633440
15:57:58 70185 8192000000 10865459296 11346280448 1930490816 19.071 99 16 32 0 1947987088 12637296 4858976
15:59:39 66012 8192000000 10880409152 11360239616 1932474544 19.087 99 9 18 0 1943134896 8083616 2576736
16:00:51 45578 8192000000 10892783184 11357073408 1943421968 19.174 99 28 56 3 1963221584 10864496 8935120
16:01:57 69599 8192000000 10892676048 11370237952 1950669456 19.232 99 12 24 0 1964156848 10548240 2939152
16:03:29 29156 8192000000 10888828912 11350245376 1904890480 18.866 96 34 67 0 1922032768 7846288 9296000
16:04:46 51935 8192000000 10902817280 11349168128 1893567472 18.775 96 15 30 0 1907970128 10351088 4051568
16:05:44 87678 8192000000 10901867648 11385446400 1914846368 18.946 97 14 27 0 1929828832 11418640 3563824
16:07:29 75235 8192000000 10892478208 11384352768 1957062032 19.283 99 12 24 0 1975479856 15296352 3121472
16:08:50 65861 8192000000 10926193440 11386691584 1982600240 19.485 100 22 43 1 2002012896 13505280 5907376
16:10:04 32987 8192000000 10933757600 11384909824 1973873952 19.416 99 27 54 1 1991645184 10309984 7461248
16:10:56 43312 8192000000 10919507584 11393511424 1970812432 19.392 99 21 42 0 1985748192 9224096 5711664
16:11:50 75840 8192000000 10905012880 11377102848 1974280208 19.419 99 19 38 1 1989641872 9934320 5427344
16:13:12 60021 8192000000 10927471168 11408683008 1983410304 19.492 99 26 52 0 2008766256 18470816 6885136
16:14:19 89311 8192000000 10927518304 11406311424 1960773328 19.312 98 12 24 0 1975497904 11798064 2926512
16:15:59 67954 8192000000 10905141952 11383848960 1967907168 19.369 99 14 28 0 1982665616 10944976 3813472
16:17:40 64455 8192000000 10920891008 11387674624 1971497984 19.397 99 30 60 2 1991581264 9841248 10242032
16:18:51 43305 8192000000 10887073936 11368972288 1927121088 19.044 97 15 30 1 1944328464 13407488 3799888
16:19:45 34218 8192000000 10898793568 11375607808 1935649520 19.112 98 15 30 0 1948780240 9181648 3949072
16:20:25 65997 8192000000 10902247888 11376726016 1958157152 19.291 99 11 22 0 1968866880 7825968 2883760
16:21:44 76482 8192000000 10895217008 11365556224 1918004288 18.971 97 17 34 1 1933870384 10551280 5314816
16:23:07 61534 8192000000 10899543184 11386494976 1978667648 19.454 100 7 14 0 1991248704 10384800 2196256
16:24:14 95370 8192000000 10914737232 11409625088 1969307712 19.380 99 13 26 0 1986451008 13220160 3923136
16:25:56 48733 8192000000 10893263264 11368378368 1908456096 18.894 96 10 20 0 1925451104 13815232 3179776
16:26:51 38625 8192000000 10901488288 11382984704 1979387952 19.460 100 26 52 0 2002986208 15098416 8499840
16:27:37 41876 8192000000 10928686416 11386929152 1942321424 19.165 98 29 57 3 1958518832 8045872 8151536
16:28:25 53610 8192000000 10892608880 11366080512 1926751776 19.041 97 31 62 1 1946591232 10919184 8920272
16:29:25 70708 8192000000 10880735040 11354185728 1906488208 18.878 97 25 50 1 1923784704 9939440 7357056
16:30:42 67148 8192000000 10861941184 11325394944 1860600288 18.508 95 19 38 2 1875121984 9419024 5102672
16:32:00 19814 8192000000 9153585472 9387143168 316930016 3.724 16 8 16 0 323246512 4172224 2144272

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-02-2021 16:33:17 to 04-02-2021 16:33:48.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 103 v_add_invoice_to_stock 335544517
except 14 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 04-02-2021 16:33:49 to 04-02-2021 16:33:51.

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          234059
MON$OLDEST_ACTIVE               234060
MON$OLDEST_SNAPSHOT             234060
MON$NEXT_TRANSACTION            234060
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                       2000960
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.33413 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33413 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33413 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33413 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

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

Database validation

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

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

--- start of diff output ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Feb  4 16:32:22 2021
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
:10: 
:11: mscs-test-161.budzdorov.ru    Thu Feb  4 16:32:22 2021
:12:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:13: 
--- end of diff output ---

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

04.02.21 16:33:52. 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-02-04 16:33:54 No severe PSQL-related problems occured
04.02.21 16:33:56. End of report.