Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.11.2020 19: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 17275908 kB
MemAvailable 31403464 kB
Buffers 0 kB
Cached 14394724 kB
SwapCached 3836 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-16 19:27:03
DTS_END                         2020-11-16 19:27:03.1470
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54368
TRN_ID                          243862
ATT_ID                          712
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: 9379.44 24874 1125533
customer order: creation 168.23 366 20187
customer order: refuse 14.33 323 1720
order to supplier: creation 45.30 1246 5436
order to supplier: removal 3.68 88893 441
invoice (draft): creation 45.13 3235 5416
invoice (draft): removal 54.17 786 6500
invoice accept: apply 40.75 18798 4890
invoice accept: cancel 49.12 791 5894
customer reserve: creation 3803.57 185 456428
customer reserve: removal 4866.51 52 583981
realization accept: apply 83.68 196 10042
realization accept: cancel 75.28 107 9034
payment from customer: creation 59.30 138 7116
payment from customer: removal 5.88 83 706
payment to supplier: creation 49.49 133 5939
payment to supplier: removal 3.43 73 411
service: total inventory turnovers 4.78 1038 573
service: total monetary turnovers 6.03 24 724
service: aggregate perf. data 0.76 23972 91
service: refresh index statistics 0.03 357039 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 16-11-2020 19:27:56 to 16-11-2020 19:27:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6163
TEST_TIME 2 4111
TEST_TIME 3 4857
TEST_TIME 4 5288
TEST_TIME 5 5055
TEST_TIME 6 5317
TEST_TIME 7 5202
TEST_TIME 8 5504
TEST_TIME 9 5465
TEST_TIME 10 5847
TEST_TIME 11 5992
TEST_TIME 12 6471
TEST_TIME 13 6690
TEST_TIME 14 7001
TEST_TIME 15 7295
TEST_TIME 16 7289
TEST_TIME 17 7415
TEST_TIME 18 7731
TEST_TIME 19 8130
TEST_TIME 20 7975
TEST_TIME 21 8267
TEST_TIME 22 8825
TEST_TIME 23 9654
TEST_TIME 24 9648
TEST_TIME 25 9916
TEST_TIME 26 10201
TEST_TIME 27 10053
TEST_TIME 28 10271
TEST_TIME 29 10127
TEST_TIME 30 10465
TEST_TIME 31 10540
TEST_TIME 32 10586
TEST_TIME 33 10462
TEST_TIME 34 10405
TEST_TIME 35 10639
TEST_TIME 36 10690
TEST_TIME 37 10743
TEST_TIME 38 10674
TEST_TIME 39 10450
TEST_TIME 40 10289
TEST_TIME 41 10275
TEST_TIME 42 10176
TEST_TIME 43 10049
TEST_TIME 44 10080
TEST_TIME 45 9964
TEST_TIME 46 9864
TEST_TIME 47 10064
TEST_TIME 48 9990
TEST_TIME 49 9893
TEST_TIME 50 9820
TEST_TIME 51 9819
TEST_TIME 52 9704
TEST_TIME 53 9609
TEST_TIME 54 9683
TEST_TIME 55 9649
TEST_TIME 56 9546
TEST_TIME 57 9494
TEST_TIME 58 9469
TEST_TIME 59 9471
TEST_TIME 60 9497
TEST_TIME 61 9497
TEST_TIME 62 9534
TEST_TIME 63 9570
TEST_TIME 64 9662
TEST_TIME 65 9656
TEST_TIME 66 9617
TEST_TIME 67 9640
TEST_TIME 68 9671
TEST_TIME 69 9718
TEST_TIME 70 9761
TEST_TIME 71 9746
TEST_TIME 72 9797
TEST_TIME 73 9750
TEST_TIME 74 9711
TEST_TIME 75 9604
TEST_TIME 76 9673
TEST_TIME 77 9632
TEST_TIME 78 9592
TEST_TIME 79 9590
TEST_TIME 80 9547
TEST_TIME 81 9538
TEST_TIME 82 9592
TEST_TIME 83 9517
TEST_TIME 84 9486
TEST_TIME 85 9492
TEST_TIME 86 9489
TEST_TIME 87 9478
TEST_TIME 88 9508
TEST_TIME 89 9504
TEST_TIME 90 9535
TEST_TIME 91 9490
TEST_TIME 92 9660
TEST_TIME 93 9630
TEST_TIME 94 9659
TEST_TIME 95 9656
TEST_TIME 96 9614
TEST_TIME 97 9698
TEST_TIME 98 9720
TEST_TIME 99 9693
TEST_TIME 100 9679
TEST_TIME 101 9620
TEST_TIME 102 9584
TEST_TIME 103 9573
TEST_TIME 104 9576
TEST_TIME 105 9540
TEST_TIME 106 9535
TEST_TIME 107 9488
TEST_TIME 108 9429
TEST_TIME 109 9448
TEST_TIME 110 9380
TEST_TIME 111 9401
TEST_TIME 112 9451
TEST_TIME 113 9439
TEST_TIME 114 9424
TEST_TIME 115 9390
TEST_TIME 116 9415
TEST_TIME 117 9465
TEST_TIME 118 9454
TEST_TIME 119 9457
TEST_TIME 120 9384

Performance per minute, chart


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

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 1548481 1548481 0 0.00 0 22644 6 0 0
doc_list_biud 1548481 1548481 0 0.00 0 33086 25 0 0
sp_add_invoice_to_stock 5002 4890 112 2.23 40 188931 18798 0 112
sp_cancel_adding_invoice 5894 5894 0 0.00 5 48235 791 0 0
sp_cancel_client_order 1720 1720 0 0.00 4 8510 324 0 0
sp_cancel_customer_reserve 583981 583981 0 0.00 1 27739 52 0 0
sp_cancel_pay_from_customer 706 706 0 0.00 3 8013 83 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 4559 73 0 0
sp_cancel_supplier_invoice 6507 6500 7 0.10 2 19890 786 0 7
sp_cancel_supplier_order 441 441 0 0.00 9 1029151 88893 0 0
sp_cancel_write_off 9034 9034 0 0.00 1 14993 107 0 0
sp_client_order 20187 20187 0 0.00 3 18582 366 0 0
sp_customer_reserve 456428 456428 0 0.00 0 53584 186 0 0
sp_fill_shopping_cart 31022 31022 0 0.00 1 14570 37 0 0
sp_fill_shopping_cart_clo_res 456421 456421 0 0.00 0 22058 13 0 0
sp_get_clo_for_invoice 4883 4883 0 0.00 0 36532 282 0 0
sp_kill_cost_storno 16045 16045 0 0.00 0 14546 53 0 0
sp_kill_qstorno_ret_qs2qd 1183937 1183937 0 0.00 0 24682 29 0 0
sp_kill_qty_storno 622495 622495 0 0.00 0 33080 63 0 0
sp_lock_selected_doc 20753 20753 0 0.00 0 7493 5 0 0
sp_make_cost_storno 27980 27980 0 0.00 0 11876 58 0 0
sp_multiply_rows_for_pdistr 27980 27980 0 0.00 0 22630 34 0 0
sp_multiply_rows_for_qdistr 20187 20187 0 0.00 0 18572 149 0 0
sp_pay_from_customer 7116 7116 0 0.00 4 22648 139 0 0
sp_pay_to_supplier 5939 5939 0 0.00 5 10414 134 0 0
sp_payment_common 13055 13055 0 0.00 1 11865 48 0 0
sp_qd_handle_on_cancel_clo 1720 1720 0 0.00 0 8500 301 0 0
sp_qd_handle_on_invoice_upd_sts 10777 10777 0 0.00 0 33072 318 0 0
sp_qd_handle_on_reserve_upd_sts 10042 10042 0 0.00 0 16021 56 0 0
sp_reserve_write_off 10042 10042 0 0.00 7 16065 197 0 0
sp_supplier_invoice 5416 5416 0 0.00 7 87946 3236 0 0
sp_supplier_order 5436 5436 0 0.00 6 27910 1246 0 0
srv_aggregate_perf_data 91 91 0 0.00 2474 420989 23973 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1025 137659 34479 0 0
srv_find_qd_qs_mism 1078412 1078412 0 0.00 0 18159 5 0 0
srv_make_invnt_saldo 573 573 0 0.00 39 40222 1039 0 0
srv_make_money_saldo 724 724 0 0.00 1 2009 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 292605 528690 357040 0 0
t$perf-abend:sp_add_invoice_to_stock 112 112 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4890 4890 0 0.00 0 13236 188 0 0
t$perf-norm:sp_cancel_adding_invoice 433 433 0 0.00 0 18408 132 0 0
t$perf-norm:sp_cancel_client_order 1720 1720 0 0.00 0 2480 10 0 0
t$perf-norm:sp_cancel_customer_reserve 672 672 0 0.00 0 1431 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 706 706 0 0.00 0 2852 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 1439 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 2810 28 0 0
t$perf-norm:sp_cancel_supplier_order 441 441 0 0.00 0 23962 1700 0 0
t$perf-norm:sp_cancel_write_off 1001 1001 0 0.00 0 2155 9 0 0
t$perf-norm:sp_client_order 20187 20187 0 0.00 0 12166 19 0 0
t$perf-norm:sp_customer_reserve 1025 1025 0 0.00 0 1430 5 0 0
t$perf-norm:sp_pay_from_customer 7116 7116 0 0.00 0 12623 9 0 0
t$perf-norm:sp_pay_to_supplier 5939 5939 0 0.00 0 6593 9 0 0
t$perf-norm:sp_reserve_write_off 10042 10042 0 0.00 0 8982 12 0 0
t$perf-norm:sp_supplier_invoice 5416 5416 0 0.00 0 12942 20 0 0
t$perf-norm:sp_supplier_order 5436 5436 0 0.00 0 12942 23 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 216 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 558 9 0 0
t$perf-norm:srv_make_invnt_saldo 573 573 0 0.00 0 672 18 0 0
t$perf-norm:srv_make_money_saldo 724 724 0 0.00 0 2098 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 3 0 0
v_add_invoice_to_stock 9986 9762 224 2.24 0 5523 17 0 224
v_all_customers 36760 36760 0 0.00 0 13 1 0 0
v_all_suppliers 30730 30730 0 0.00 0 78 1 0 0
v_all_wares 40374 40374 0 0.00 0 29 1 0 0
v_cancel_adding_invoice 866 866 0 0.00 0 602 5 0 0
v_cancel_client_order 3440 3440 0 0.00 0 2375 4 0 0
v_cancel_customer_prepayment 1412 1412 0 0.00 0 689 3 0 0
v_cancel_customer_reserve 1344 1344 0 0.00 0 2336 7 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 2696 7 0 0
v_cancel_supplier_invoice 904 890 14 1.54 0 496 14 0 14
v_cancel_supplier_order 882 882 0 0.00 0 840 4 0 0
v_cancel_write_off 2002 2002 0 0.00 0 5261 17 0 0
v_max_id_clo_ord 5432 5432 0 0.00 0 406 1 0 0
v_max_id_clo_res 1025 1025 0 0.00 0 3185 25 0 0
v_max_id_ord_sup 5402 5402 0 0.00 0 4323 5 0 0
v_max_non_paid_invoice 1408 1408 0 0.00 0 1017 4 0 0
v_max_non_paid_realizn 3879 3879 0 0.00 0 3875 6 0 0
v_min_id_clo_ord 5432 5432 0 0.00 0 11986 14 0 0
v_min_id_clo_res 1025 1025 0 0.00 0 5762 18 0 0
v_min_id_ord_sup 5402 5402 0 0.00 0 4909 6 0 0
v_min_non_paid_invoice 5939 5939 0 0.00 0 10002 35 0 0
v_min_non_paid_realizn 7116 7116 0 0.00 0 11855 38 0 0
v_our_firm 10088 10088 0 0.00 0 152 1 0 0
v_reserve_write_off 20084 20084 0 0.00 0 4736 5 0 0
x_lock_depdocs_on_canc_invoice 11949 11949 0 0.00 0 14066 113 0 0
x_lock_depdocs_on_canc_sup_ord 441 441 0 0.00 0 7773 264 0 0
x_make_qstorno_1000_1200 5436 5436 0 0.00 2 27784 1160 0 0
x_make_qstorno_1200_2000 5416 5416 0 0.00 3 87755 3110 0 0
x_make_qstorno_2100_3300 456428 456428 0 0.00 0 53583 170 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-11-2020 19:28:04 to 16-11-2020 19:28:08.

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
16:57:06 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:13 16337 8192000000 10247161424 10551435264 947527648 10.367 76 55 112 1 968627712 2701232 18398832
16:57:37 31873 8192000000 10351753440 10667147264 1382700368 14.441 100 87 174 0 1415436512 4902560 27833584
16:58:20 25106 8192000000 10382933968 10705096704 1436613888 14.920 100 87 174 0 1471418944 6701776 28103280
16:58:57 27758 8192000000 10403027920 10729414656 1460178960 15.127 100 88 176 0 1496167840 7546912 28441968
16:59:37 7082 8192000000 10418058752 10746191872 1480190176 15.303 100 90 180 0 1516998128 7880640 28927312
17:00:01 21433 8192000000 10448339568 10780114944 1491675840 15.404 100 86 172 0 1527360320 8094736 27589744
17:00:33 12893 8192000000 10458159344 10793742336 1510261760 15.566 100 81 162 1 1544808576 8746080 25800736
17:00:57 19473 8192000000 10483378336 10823933952 1537158032 15.799 100 80 160 1 1571422352 9381440 24882880
17:01:25 11930 8192000000 10508151136 10855710720 1565424848 16.043 100 86 172 1 1602132256 10140944 26566464
17:01:49 15500 8192000000 10539332160 10891563008 1594830288 16.295 100 78 157 1 1628756640 10343664 23582688
17:02:15 9026 8192000000 10558118320 10912288768 1619750304 16.508 100 86 172 0 1656541840 11299632 25491904
17:02:31 9107 8192000000 10576790160 10933456896 1627603088 16.575 100 76 152 0 1661800272 12044320 22152864
17:02:48 9729 8192000000 10597587104 10956578816 1652855120 16.789 100 86 171 2 1692163456 13509584 25798752
17:03:04 11071 8192000000 10594804912 10962997248 1659751648 16.847 100 81 161 0 1697007616 14165648 23090320
17:03:24 7888 8192000000 10608040816 10975739904 1673392320 16.962 100 85 168 1 1712144432 13619728 25132384
17:03:40 7603 8192000000 10633093744 11003289600 1686469632 17.072 100 77 154 1 1721198640 12349824 22379184
17:03:55 6644 8192000000 10639982864 11011342336 1701986384 17.202 100 68 133 2 1732619344 11467376 19165584
17:04:10 5329 8192000000 10653749504 11030650880 1724190080 17.387 100 74 146 0 1756640528 11194656 21255792
17:04:25 5037 8192000000 10662754032 11045470208 1737250512 17.496 100 73 146 1 1769548720 11047312 21250896
17:04:37 6606 8192000000 10680417232 11061862400 1742544512 17.540 100 64 128 0 1771905728 10865024 18496192
17:04:51 5272 8192000000 10703226768 11084054528 1760708352 17.690 100 77 154 3 1798037936 16567808 20761776
17:05:03 3760 8192000000 10706031776 11087380480 1770385360 17.770 100 72 142 1 1802286880 11797472 20104048
17:05:20 7299 8192000000 10723055728 11104251904 1780333168 17.852 100 72 144 2 1813252144 12736496 20182480
17:05:37 3337 8192000000 10743412848 11126853632 1807718912 18.077 100 87 172 3 1846215552 13946624 24550016
17:05:47 2892 8192000000 10757093648 11143524352 1815580736 18.142 100 83 166 4 1852380000 14132880 22666384
17:05:57 2962 8192000000 10766222304 11149795328 1821031152 18.186 100 83 164 1 1858161616 14131264 22999200
17:06:06 2692 8192000000 10766339552 11149529088 1828041184 18.243 100 83 165 1 1866076912 14642656 23393072
17:06:16 2481 8192000000 10772733808 11155558400 1831694560 18.273 100 84 168 2 1869161856 14002288 23465008
17:06:24 2104 8192000000 10772091344 11158638592 1834207424 18.294 100 85 171 0 1872253120 13885472 24160224
17:06:33 2103 8192000000 10782405392 11165642752 1837997280 18.325 100 89 179 0 1876578016 13329888 25250848
17:06:42 2073 8192000000 10785588240 11169861632 1836786192 18.315 100 85 170 0 1876124272 15003712 24334368
17:06:50 1560 8192000000 10785787472 11169611776 1846162384 18.391 100 90 181 0 1887332400 14573696 26596320
17:06:58 1448 8192000000 10781945824 11166883840 1847461168 18.401 100 83 162 0 1882695680 12509120 22725392
17:07:07 1585 8192000000 10797576496 11182919680 1850974400 18.430 100 90 180 0 1889837392 13381600 25481392
17:07:15 1258 8192000000 10802305248 11186135040 1855362304 18.466 100 93 185 1 1894853856 12525504 26966048
17:07:22 2093 8192000000 10805992880 11191676928 1858298960 18.489 100 93 186 1 1898027920 12860256 26868704
17:07:31 1545 8192000000 10803487392 11193802752 1864357120 18.539 100 89 178 1 1900213920 11251024 24605776
17:07:38 1524 8192000000 10821771008 11208556544 1873941056 18.616 100 98 196 0 1913965328 12630464 27393808
17:07:47 1904 8192000000 10817735216 11210297344 1875100736 18.626 100 85 167 3 1911511440 12655936 23754768
17:07:55 41687 8192000000 10810291936 11212316672 1876964080 18.641 100 69 139 1 1906846208 9645088 20237040
17:08:44 7793 8192000000 10791510736 11212636160 1874631536 18.622 100 44 89 1 1896504352 9740208 12132608
17:08:58 3560 8192000000 10793632016 11215433728 1878680704 18.654 100 41 82 0 1898910464 8824368 11405392
17:09:10 5549 8192000000 10813610992 11226533888 1884580352 18.702 100 56 112 2 1909810672 9794496 15435824
17:09:25 7485 8192000000 10802298320 11221295104 1884714064 18.703 100 28 54 1 1899436864 6519328 8203472
17:09:40 6258 8192000000 10806634240 11228712960 1885876928 18.713 100 36 71 1 1902583424 6446064 10260432
17:09:53 6117 8192000000 10808865872 11231318016 1889931312 18.745 100 39 78 3 1909481104 8976432 10573360
17:10:05 13670 8192000000 10787984320 11227299840 1885768864 18.712 100 15 30 2 1896045792 5964640 4312288
17:10:26 4367 8192000000 10793649296 11226988544 1886780576 18.720 100 19 38 0 1897925232 5616368 5528288
17:10:40 12144 8192000000 10796431536 11229327360 1888702416 18.735 100 27 55 0 1903502368 7255536 7544416
17:10:58 9513 8192000000 10795950768 11230072832 1887920048 18.729 100 16 32 0 1898585888 6060704 4605136
17:11:19 6385 8192000000 10810563120 11236548608 1894246576 18.780 100 30 61 0 1909391088 6031696 9112816
17:11:36 13627 8192000000 10800983984 11236028416 1892198992 18.763 100 12 24 1 1901418032 5919440 3299600
17:11:56 12354 8192000000 10806293600 11239927808 1896368592 18.797 100 19 39 2 1907814192 6175856 5269744
17:12:15 14765 8192000000 10830587984 11249070080 1902362800 18.845 100 27 52 3 1915079056 5128704 7587552
17:12:36 79601 8192000000 10810630432 11256258560 1908719696 18.896 100 41 82 5 1927335552 5398880 13216976
17:14:04 5818 8192000000 10836360768 11264425984 1912642912 18.928 100 39 78 1 1931398160 7639952 11115296
17:14:18 4917 8192000000 10833705680 11269201920 1914397824 18.942 100 34 68 0 1932200640 8496720 9306096
17:14:30 5658 8192000000 10830171504 11265953792 1913942656 18.938 100 32 62 5 1929501792 6240928 9318208
17:14:41 9133 8192000000 10829666640 11265290240 1915900080 18.954 100 27 54 0 1930413648 5855920 8657648
17:14:57 9104 8192000000 10810179408 11236642816 1857146656 18.480 97 28 57 1 1871327072 5457696 8722720
17:15:14 6000 8192000000 10814011824 11246751744 1885338448 18.708 99 31 62 1 1900585360 6811664 8435248
17:15:26 10121 8192000000 10813189344 11254960128 1878338832 18.652 99 16 32 0 1888270512 5429888 4501792
17:15:43 8411 8192000000 10811501440 11250188288 1900664576 18.832 100 17 34 2 1911213312 5762656 4786080
17:16:01 3993 8192000000 10823410752 11250692096 1897373680 18.805 100 26 50 3 1910218336 5536528 7308128
17:16:11 10395 8192000000 10813101552 11243814912 1880409456 18.668 99 17 34 1 1890666432 5413712 4843264
17:16:27 14353 8192000000 10769668128 11193896960 1775330592 17.811 94 13 26 0 1784498816 5631840 3536384
17:16:48 7716 8192000000 10766172384 11186675712 1766810528 17.741 94 30 59 3 1781364320 5492464 9061328
17:17:03 12532 8192000000 10757473616 11176505344 1749349520 17.596 94 11 21 1 1757128560 4934096 2844944
17:17:26 58258 8192000000 10779686400 11196837888 1815764464 18.143 98 29 58 2 1829935712 4547968 9623280
17:18:31 17496 8192000000 10759910688 11185983488 1833024240 18.284 98 21 42 0 1844923008 6234656 5664112
17:18:55 5993 8192000000 10733089216 11150987264 1746970688 17.576 95 27 52 2 1760396848 5859248 7566912
17:19:10 3782 8192000000 10752169264 11165237248 1811469680 18.108 99 43 86 1 1831576784 8562688 11544416
17:19:23 6346 8192000000 10725554576 11144863744 1795954320 17.981 99 27 52 0 1810110720 6314384 7842016
17:19:36 6432 8192000000 10729735024 11147845632 1797794272 17.996 99 37 74 2 1814912208 7448576 9669360
17:19:49 5290 8192000000 10711435680 11133493248 1772912976 17.791 98 28 56 2 1787268080 6451968 7903136
17:20:03 7610 8192000000 10698191840 11113730048 1754226688 17.637 98 25 50 1 1771488336 9689136 7572512
17:20:17 4186 8192000000 10717869536 11127177216 1792259296 17.950 100 36 72 0 1809483056 6547536 10676224
17:20:29 7369 8192000000 10685290528 11103723520 1747862960 17.584 97 22 44 1 1759977760 6096944 6017856
17:20:43 6460 8192000000 10715511824 11133075456 1766804800 17.741 98 26 52 2 1780523168 6580832 7137536
17:20:57 5110 8192000000 10730721312 11142590464 1791782864 17.946 99 28 56 2 1809703360 9748480 8172016
17:21:14 7810 8192000000 10720064240 11128516608 1756783840 17.658 97 26 52 0 1770777952 5425296 8568816
17:21:30 11251 8192000000 10743285104 11154886656 1783263120 17.876 98 35 69 2 1799042448 5028352 10750976
17:21:48 8536 8192000000 10722331344 11150196736 1814701712 18.134 100 11 22 1 1823575504 5547392 3326400
17:22:08 19284 8192000000 10762645840 11173130240 1832715792 18.281 100 39 77 5 1849694368 5896048 11082528
17:22:44 36490 8192000000 10793101104 11182387200 1842880624 18.364 100 62 120 4 1866832496 5308640 18643232
17:23:26 5836 8192000000 10750866944 11177783296 1843266512 18.367 100 35 71 1 1861794736 7579664 10948560
17:23:38 7380 8192000000 10757806720 11181731840 1844564704 18.378 100 27 54 1 1857568160 6033840 6969616
17:23:57 6325 8192000000 10766735264 11184005120 1843754656 18.371 100 29 54 0 1861683392 10297280 7631456
17:24:14 6775 8192000000 10763337216 11187736576 1847097072 18.399 100 23 46 2 1859319008 5990128 6231808
17:24:27 5808 8192000000 10767143072 11194810368 1855634224 18.468 100 32 64 0 1871290032 7224384 8431424
17:24:39 10167 8192000000 10762693856 11190923264 1852521088 18.443 100 12 22 1 1861660000 5386528 3752384
17:24:56 8663 8192000000 10779651120 11197894656 1854994320 18.463 100 23 46 1 1867714704 5858720 6861664
17:25:12 6028 8192000000 10769974816 11199045632 1859389328 18.498 100 35 70 1 1876063488 6326464 10347696
17:25:24 7899 8192000000 10785355952 11207639040 1861621648 18.516 100 26 52 3 1874561088 5310832 7628608
17:25:40 6470 8192000000 10778778112 11206926336 1863473088 18.531 100 25 50 2 1876541216 5506848 7561280
17:25:56 6870 8192000000 10786472096 11209928704 1866766736 18.558 100 28 56 0 1880512560 4934800 8811024
17:26:15 10930 8192000000 10780089920 11216994304 1872868512 18.607 100 15 30 2 1882531504 4980016 4682976
17:26:35 11335 8192000000 10784261760 11218976768 1873315376 18.611 100 11 22 0 1881096112 4951616 2829120
17:26:52 12859 8192000000 10802498544 11228102656 1878104112 18.650 100 26 52 1 1890739136 5710208 6924816
17:27:16 22173 8192000000 10840432464 11250352128 1898032432 18.810 100 38 74 2 1915164208 6434512 10697264
17:27:46 17282 8192000000 10845841360 11263119360 1915133680 18.948 100 52 104 1 1937588144 7775168 14679296
17:28:14 7587 8192000000 10862270272 11276677120 1920126240 18.988 100 54 108 0 1943559104 8891696 14541168
17:28:30 137659 8192000000 10855406240 11284447232 1909697248 18.904 99 48 96 1 1932299952 8536576 14066128
17:30:56 30701 8192000000 10862116752 11303907328 1938688896 19.136 100 36 72 1 1963382992 14610800 10083296
17:31:40 25442 8192000000 10891359264 11314475008 1925880240 19.034 98 58 115 2 1952039184 9858768 16300176
17:32:13 26501 8192000000 10890147280 11320950784 1951147088 19.236 100 46 92 0 1976494176 11939056 13408032
17:32:51 7970 8192000000 10899788240 11325009920 1958705552 19.296 100 52 104 2 1986844272 12481440 15657280
17:33:10 10070 8192000000 10891047840 11319177216 1943615856 19.176 99 54 107 3 1971939424 12171968 16151600
17:33:30 12038 8192000000 10906911568 11339137024 1967219408 19.363 100 55 109 1 2002185264 19297600 15668256
17:33:52 17481 8192000000 10909256160 11341303808 1971381264 19.396 100 49 98 2 2001247808 14332912 15533632
17:34:18 16895 8192000000 10914639872 11346550784 1978748576 19.455 100 54 109 4 2009238272 13968432 16521264
17:34:43 17146 8192000000 10920259744 11354501120 1964818464 19.344 99 47 94 0 1994968688 15979824 14170400
17:35:08 11633 8192000000 10922750624 11356508160 1981618528 19.478 100 55 109 2 2015783840 17641744 16523568
17:35:28 6385 8192000000 10928859456 11364552704 1988752496 19.534 100 50 100 0 2020661952 16191152 15718304
17:35:48 7781 8192000000 10934937648 11361783808 1986265632 19.514 100 58 112 0 2022278688 18583088 17429968
17:36:03 7498 8192000000 10935478384 11365224448 1987045824 19.520 100 54 108 2 2023948736 20563072 16339840
17:36:17 5285 8192000000 10936467360 11370528768 1992430512 19.563 100 58 116 0 2030617984 21005040 17182432
17:36:32 12229 8192000000 10930981984 11361357824 1985086736 19.505 100 61 119 1 2024357968 21238944 18032288
17:37:01 3604 8192000000 10942263936 11373355008 1990935632 19.551 100 52 104 0 2030228768 22546144 16746992
17:37:13 8879 8192000000 10915821120 11350151168 1973008368 19.409 100 46 90 0 2006882656 19196528 14677760
17:37:31 15665 8192000000 10920652384 11344076800 1968978624 19.377 99 62 124 1 2008695440 20382320 19334496
17:37:55 4571 8192000000 10942480288 11370369024 1993325696 19.570 100 75 149 1 2036563440 20655936 22581808
17:38:07 4390 8192000000 10960438144 11373584384 1995589696 19.588 100 69 135 4 2035892544 19783520 20519328
17:38:20 5220 8192000000 10939223328 11360497664 1955860704 19.273 98 75 150 2 1999414608 20374992 23178912
17:38:33 1425 8192000000 10952567456 11365621760 1965997440 19.354 99 84 168 0 2012101248 19892080 26211728
17:38:42 8163 8192000000 10939726736 11365752832 1983927440 19.496 100 64 128 1 2027152528 23540112 19684976
17:39:03 4464 8192000000 10953230352 11379621888 1993187600 19.569 100 58 116 1 2036887392 25806400 17893392
17:39:14 6107 8192000000 10945828880 11363291136 1972054352 19.402 99 71 141 1 2023833424 30449424 21329648
17:39:27 3415 8192000000 10939286976 11357495296 1961665424 19.319 99 76 151 2 2013006768 27868352 23472992
17:39:40 3455 8192000000 10928879664 11349045248 1946830240 19.201 98 74 148 0 1998944304 28923216 23190848
17:39:53 10145 8192000000 10933158688 11359268864 1972243904 19.403 100 58 116 1 2017695856 27260272 18191680
17:40:16 5827 8192000000 10946708768 11372572672 1985680272 19.510 100 59 118 1 2031017024 26749072 18587680
17:40:29 9387 8192000000 10926230944 11354288128 1952208400 19.244 99 63 125 3 2001167184 29083792 19874992
17:40:46 8147 8192000000 10937633744 11365425152 1972621008 19.406 100 61 120 2 2020795072 29744128 18429936
17:41:12 6658 8192000000 10951721312 11376943104 1988959712 19.536 100 58 112 2 2036104432 29300256 17844464
17:41:27 5333 8192000000 10954503344 11382390784 1989393456 19.539 100 65 130 1 2037531056 27972320 20165280
17:41:47 5580 8192000000 10952783840 11374780416 1982177504 19.482 100 67 134 2 2030744784 29017088 19550192
17:42:01 5793 8192000000 10961373584 11381444608 1990864464 19.551 100 75 150 1 2043317840 29515936 22937440
17:42:16 3149 8192000000 10964958544 11390898176 1999215824 19.617 100 70 142 0 2051231680 30525056 21490800
17:42:31 10748 8192000000 10930812368 11364167680 1961921488 19.321 99 59 118 1 2006843360 26471408 18450464
17:42:48 3015 8192000000 10925953312 11350044672 1953987680 19.258 99 63 124 2 1998765376 25468576 19309120
17:42:59 3139 8192000000 10933794080 11354849280 1966945728 19.361 100 64 127 0 2012982784 26356496 19680560
17:43:10 11453 8192000000 10948563856 11371364352 1983000256 19.488 100 68 136 1 2033373056 29155808 21216992
17:43:28 5509 8192000000 10949497344 11378434048 1986404832 19.515 100 60 117 1 2035556800 30816368 18335600
17:43:43 3380 8192000000 10954660592 11373879296 1968284912 19.372 99 67 133 0 2020836736 31158064 21393760
17:43:53 2241 8192000000 10970112560 11382009856 1986366208 19.515 100 79 159 2 2042985888 31721744 24897936
17:44:03 2026 8192000000 10967380512 11384774656 1978697568 19.454 99 75 148 1 2033374384 32528880 22147936
17:44:13 5908 8192000000 10949660944 11361161216 1970519296 19.390 99 85 169 2 2032346080 35501616 26325168
17:44:28 4049 8192000000 10950748768 11373125632 1971620240 19.398 100 72 144 0 2033361104 39708176 22032688
17:44:39 7160 8192000000 10953012784 11370864640 1977088768 19.442 100 74 144 0 2033833760 35140448 21604544
17:44:56 4166 8192000000 10935579488 11354140672 1960666848 19.311 100 74 148 1 2019672352 35564368 23441136
17:45:29 3449 8192000000 10961995888 11378196480 1977141664 19.442 100 79 159 0 2041560960 39561920 24857376
17:45:42 1402 8192000000 10962962000 11377590272 1970147888 19.387 99 93 186 0 2035830000 36724704 28957408
17:46:09 12482 8192000000 10895146208 11341094912 1926672832 19.040 99 37 72 1 1974818688 35802208 12343648
17:46:45 18540 8192000000 10901732416 11332464640 1885108016 18.706 97 28 56 1 1927248896 32807040 9333840
17:47:12 3752 8192000000 10882767712 11299135488 1899575536 18.823 98 60 120 3 1951844096 33297424 18971136
17:47:22 8178 8192000000 10893295056 11318956032 1917299312 18.965 100 47 93 1 1967288880 35170912 14818656
17:47:38 4344 8192000000 10893421920 11313229824 1921472144 18.999 100 54 106 2 1976954096 37008944 18473008
17:47:50 9689 8192000000 10912184864 11331825664 1931064800 19.075 100 57 114 1 1989483648 39273008 19145840
17:48:07 5040 8192000000 10888986464 11302047744 1903526928 18.855 99 59 118 3 1963970592 40738688 19704976
17:48:19 6048 8192000000 10919294480 11332468736 1913699504 18.936 99 64 128 0 1981300192 46044288 21556400
17:48:31 7264 8192000000 10900545632 11339153408 1926695376 19.040 100 41 82 1 1987661056 46356752 14608928
17:48:45 9612 8192000000 10877152496 11314601984 1878002400 18.649 98 30 60 2 1933949568 44648848 11298320
17:49:02 4582 8192000000 10896817120 11318620160 1911671392 18.920 100 43 86 0 1972998160 45306160 16020608
17:49:27 9166 8192000000 10866769872 11276746752 1876512464 18.637 98 40 79 1 1937056064 46343936 14199664
17:49:53 17667 8192000000 10860344592 11299368960 1895611632 18.791 99 28 56 4 1946592304 41499712 9480960
17:50:28 26445 8192000000 10848235712 11299037184 1878335104 18.652 98 17 34 1 1913896640 29712912 5848624
17:51:01 24697 8192000000 10854043856 11297824768 1904582048 18.863 100 18 35 1 1935308224 24534960 6191216
17:51:55 17750 8192000000 10874190880 11314360320 1918921344 18.978 100 31 63 2 1955169584 25919328 10328912
17:52:27 42433 8192000000 10860853328 11310342144 1915030784 18.947 100 16 32 2 1948084592 27286624 5767184
17:53:18 21365 8192000000 10846588512 11298500608 1879647840 18.662 98 18 34 1 1903336672 18254288 5434544
17:53:56 56416 8192000000 10873402000 11330850816 1919288528 18.981 100 16 32 1 1947741584 23379744 5073312
17:55:21 38708 8192000000 10882172368 11347243008 1929319536 19.061 100 13 26 3 1962935824 30124736 3491552
17:56:08 36725 8192000000 10893654928 11347861504 1938352064 19.134 100 16 29 1 1963804528 20428304 5024160
17:57:16 34481 8192000000 10866788288 11332857856 1901953360 18.842 99 15 29 3 1936045408 29603376 4488672
17:58:09 60943 8192000000 10868213600 11332419584 1911153392 18.916 99 12 25 0 1946374832 31429392 3792048
17:59:16 68040 8192000000 10874668576 11317190656 1893547744 18.774 98 16 30 1 1916387328 18352352 4487232
18:00:56 38332 8192000000 10888616192 11329720320 1939094688 19.140 100 31 60 1 1963975040 16334592 8545760
18:01:42 17131 8192000000 10872362000 11327397888 1940024960 19.147 100 21 41 1 1965140720 19439104 5676656
18:02:08 52120 8192000000 10879756368 11338895360 1939634480 19.144 100 9 18 1 1967208496 24385792 3188224
18:03:28 126940 8192000000 10869939520 11338358784 1924858224 19.026 99 7 14 0 1942077712 15732288 1487200
18:05:41 137581 8192000000 10911191728 11356487680 1961132080 19.315 100 21 42 0 1979255552 12264592 5858880
18:08:13 81440 8192000000 10916575904 11372224512 1970294080 19.388 100 34 66 1 1993781536 13871936 9615520
18:09:44 16975 8192000000 10913432864 11363762176 1978353312 19.452 100 45 90 1 2000232624 9720240 12159072
18:10:15 39194 8192000000 10919959040 11368792064 1982148656 19.482 100 45 90 1 2004886256 9883600 12854000
18:11:01 26343 8192000000 10916157360 11365486592 1980540880 19.469 100 51 100 0 2003506544 9338208 13627456
18:11:35 15309 8192000000 10898135952 11366543360 1976324304 19.436 100 14 28 2 1989272336 9347408 3600624
18:12:15 32797 8192000000 10898665040 11353972736 1962113872 19.323 100 33 66 1 1983289040 11486144 9689024
18:12:55 12166 8192000000 10916551088 11362394112 1978181072 19.450 100 65 126 5 2007766896 11549616 18036208
18:13:14 18127 8192000000 10927532608 11372666880 1983648112 19.494 100 55 106 0 2012915056 14183312 15083632
18:14:14 32689 8192000000 10902929840 11378655232 1977269888 19.443 100 33 66 3 2007651072 20622112 9759072
18:15:00 56339 8192000000 10887815008 11365806080 1957356608 19.285 99 9 18 0 1969814016 10359632 2097776
18:16:02 33688 8192000000 10890219216 11364130816 1973372320 19.412 100 9 16 1 1983773248 8022112 2378816
18:16:48 53658 8192000000 10890859136 11366674432 1961174576 19.315 99 15 30 1 1974293904 8626208 4493120
18:17:56 51144 8192000000 10894096816 11371958272 1980828928 19.471 100 16 32 0 1994492720 9280608 4383184
18:18:53 76177 8192000000 10901490048 11371999232 1960390784 19.309 99 14 28 0 1972812816 8400672 4021360
18:20:39 83335 8192000000 10894262976 11376717824 1958522432 19.294 99 11 22 0 1975740064 13741824 3475808
18:22:33 57536 8192000000 10895963792 11368771584 1957447680 19.286 99 12 24 0 1971487296 10324048 3715568
18:23:40 92875 8192000000 10885292208 11370885120 1956027712 19.274 99 17 33 0 1969391296 8476096 4887488
18:25:19 70879 8192000000 10890519568 11375124480 1933877184 19.098 98 5 10 0 1945224528 9850592 1496752
18:27:03 73307 8192000000 10900672096 11380293632 1960913264 19.313 99 7 14 1 1974909808 12472768 1523776
18:28:26 55088 8192000000 10851744992 11325841408 1819762880 18.176 92 14 28 0 1832318016 9026592 3528544
18:29:32 43988 8192000000 10894738896 11341438976 1933093920 19.092 99 34 66 0 1955997872 13688016 9215936
18:30:23 56737 8192000000 10877110112 11367268352 1920514496 18.991 98 32 64 1 1942463648 12989008 8960144
18:31:27 39588 8192000000 10853186240 11318759424 1852999104 18.446 95 9 18 1 1864936304 9741424 2195776
18:32:12 35935 8192000000 10888372736 11345395712 1900978256 18.834 97 35 70 2 1918398752 7902384 9518112
18:32:54 28130 8192000000 10897672288 11352739840 1956962832 19.282 100 32 65 0 1979225008 13136080 9126096
18:33:29 13731 8192000000 10887222720 11329363968 1886421680 18.717 96 68 133 2 1915084320 9174528 19488112
18:33:51 36533 8192000000 10863274752 11325202432 1899910048 18.826 98 35 70 0 1922646992 12839616 9897328
18:34:50 65200 8192000000 10832288560 11309264896 1818713456 18.167 94 20 41 0 1838339104 13712672 5912976
18:36:04 57623 8192000000 10864893008 11319193600 1896371472 18.797 99 16 32 0 1913011360 12532080 4107808
18:37:18 69810 8192000000 10843941968 11307196416 1841853456 18.356 95 21 42 0 1861171456 13482944 5835056
18:38:34 24947 8192000000 10863004224 11301240832 1856490304 18.475 96 29 58 0 1872597200 8543360 7563536
18:39:06 65355 8192000000 10856181152 11311443968 1862501696 18.524 97 33 66 1 1887376688 15506400 9368592
18:40:21 40126 8192000000 10869059664 11309199360 1852483216 18.442 96 33 66 1 1872686192 11175472 9027504
18:41:08 89313 8192000000 10856948704 11301466112 1871013632 18.592 97 49 98 2 1892837296 8343456 13480208
18:42:47 45133 8192000000 10870030352 11323232256 1890697312 18.751 98 42 84 3 1917823008 14977872 12147824
18:43:58 46426 8192000000 10839778544 11322331136 1917701440 18.968 100 15 30 0 1937446848 15700128 4045280
18:44:51 1024 8192000000 10851417744 11315699712 1923453216 19.014 100 29 59 0 1945592912 14379264 7760432
18:44:58 17777 8192000000 10870434592 11307356160 1907489920 18.886 99 40 79 1 1927954544 9593760 10870864
18:45:29 65902 8192000000 10875626848 11345051648 1919312880 18.981 99 18 35 2 1943435440 18848720 5273840
18:46:41 72009 8192000000 10865561520 11336114176 1923342416 19.014 99 14 28 0 1943386768 16030384 4013968
18:48:24 67779 8192000000 10838310256 11309891584 1879703360 18.663 97 16 32 0 1900423440 15933760 4786320
18:49:40 85158 8192000000 10859701904 11330359296 1919435536 18.982 99 13 26 1 1935744256 12006064 4302656
18:51:17 57820 8192000000 10853361520 11331457024 1906738816 18.880 98 3 6 0 1914639376 7134592 765968
18:52:25 85531 8192000000 10864250768 11348787200 1909842144 18.905 98 13 26 1 1926217824 12822816 3552864
18:53:57 37398 8192000000 10891363072 11348467712 1938647120 19.136 99 22 44 1 1953272448 8703360 5921968
18:55:05 45509 8192000000 10887770864 11361193984 1955980880 19.274 100 16 32 0 1975161584 14410272 4770432
18:55:57 33020 8192000000 10898143072 11368943616 1952393280 19.246 99 24 48 1 1968708400 9490624 6824496
18:56:39 107383 8192000000 10929763040 11394596864 1968606672 19.374 99 17 34 0 1987625456 14128304 4890480
18:58:40 76145 8192000000 10915697152 11409948672 1988093856 19.529 100 12 24 0 2006010960 14730352 3186752
19:00:02 55174 8192000000 10912017904 11385847808 1950685744 19.232 98 4 8 2 1961727200 10345424 696032
19:01:07 42423 8192000000 10899798704 11375972352 1950455472 19.230 98 20 40 1 1967030000 11191264 5383264
19:02:22 94989 8192000000 10955471696 11408461824 1992833552 19.566 100 19 38 0 2008722304 10536976 5351776
19:04:06 108448 8192000000 10915039120 11394658304 1919142784 18.980 96 11 22 0 1934415440 12312864 2959792
19:06:01 32254 8192000000 10933930576 11392303104 1989362160 19.539 100 34 68 0 2010259824 11413920 9483744
19:06:40 112607 8192000000 10918492160 11392479232 1965926640 19.353 98 24 48 3 1984759824 12303136 6530048
19:08:56 82552 8192000000 10922940128 11403841536 2003570928 19.651 100 19 39 0 2019162800 9966800 5625072
19:10:38 38628 8192000000 10926561680 11396395008 1987021664 19.520 99 32 64 0 2003850512 8405792 8423056
19:11:24 64929 8192000000 10933206352 11409362944 2008597168 19.690 100 16 32 1 2022829744 9337728 4894848
19:12:36 51908 8192000000 10921906144 11392573440 1983487120 19.492 99 19 37 2 1998352656 9729792 5135744
19:13:39 59874 8192000000 10910308992 11390689280 1942425488 19.166 97 15 30 0 1957904880 11182272 4297120
19:14:45 36946 8192000000 10920613568 11402358784 1985794512 19.511 99 17 34 0 2009406208 18332000 5279696
19:15:33 47835 8192000000 10919176528 11401785344 1977685280 19.446 99 25 50 2 2006033680 20644448 7703952
19:17:07 77593 8192000000 10897501888 11382173696 1942062880 19.163 97 22 44 1 1962081296 13569552 6448864
19:18:31 93555 8192000000 10840311376 11329994752 1792701184 17.954 91 5 10 0 1807124816 13125008 1298624
19:20:11 68353 8192000000 10827288304 11307585536 1817112752 18.154 94 16 32 0 1833196768 11409952 4674064
19:21:25 51562 8192000000 10858932592 11316273152 1893025920 18.770 98 16 32 0 1908167152 11099392 4041840
19:22:27 53263 8192000000 10851796176 11316727808 1872051888 18.601 96 23 46 0 1890597280 11682864 6862528
19:23:28 48105 8192000000 10834637824 11302391808 1825285264 18.221 95 14 28 1 1843535808 14061936 4188608
19:24:23 27554 8192000000 10851298000 11308212224 1882698048 18.687 98 28 54 3 1898454064 8482368 7273648
19:25:03 16318 8192000000 10859557568 11313684480 1919678064 18.984 100 36 72 0 1940366880 10882960 9805856
19:25:30 71168 8192000000 10887084000 11343712256 1922551504 19.007 99 44 88 0 1945338080 11271504 11515072
19:26:47 26394 8192000000 9455657216 9758281728 602382704 6.849 32 4 8 0 608123984 4779792 961488

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 16-11-2020 19:28:10 to 16-11-2020 19:28:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 112 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-11-2020 19:28:42 to 16-11-2020 19:28:44.

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          244361
MON$OLDEST_ACTIVE               244362
MON$OLDEST_SNAPSHOT             244362
MON$NEXT_TRANSACTION            244362
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                       2040032
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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.11.20 19:28:45. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2020-11-16 19:28:47 No severe PSQL-related problems occured
16.11.20 19:28:48. End of report.