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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17371460 kB
MemAvailable 31435400 kB
Buffers 0 kB
Cached 14287320 kB
SwapCached 2824 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.7
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-06 22:26:59
DTS_END                         2020-11-06 22:26:59.8180
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/40386
TRN_ID                          238890
ATT_ID                          697
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: 9470.98 24245 1136518
customer order: creation 169.13 346 20295
customer order: refuse 14.81 342 1777
order to supplier: creation 46.47 1276 5576
order to supplier: removal 3.79 87542 455
invoice (draft): creation 46.11 3207 5533
invoice (draft): removal 54.98 737 6597
invoice accept: apply 42.01 17689 5041
invoice accept: cancel 49.38 763 5925
customer reserve: creation 3877.07 175 465248
customer reserve: removal 4869.27 53 584312
realization accept: apply 82.23 176 9867
realization accept: cancel 85.39 105 10247
payment from customer: creation 60.14 107 7217
payment from customer: removal 5.58 70 669
payment to supplier: creation 48.94 115 5873
payment to supplier: removal 3.59 92 431
service: total inventory turnovers 4.53 1278 544
service: total monetary turnovers 6.68 53 802
service: aggregate perf. data 0.88 18228 105
service: refresh index statistics 0.03 352541 4

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2154
TEST_TIME 2 2574
TEST_TIME 3 2924
TEST_TIME 4 3359
TEST_TIME 5 2880
TEST_TIME 6 3345
TEST_TIME 7 4275
TEST_TIME 8 4209
TEST_TIME 9 5345
TEST_TIME 10 5975
TEST_TIME 11 5976
TEST_TIME 12 6192
TEST_TIME 13 6780
TEST_TIME 14 6767
TEST_TIME 15 6945
TEST_TIME 16 7246
TEST_TIME 17 7606
TEST_TIME 18 8183
TEST_TIME 19 8288
TEST_TIME 20 8728
TEST_TIME 21 8850
TEST_TIME 22 9215
TEST_TIME 23 9304
TEST_TIME 24 9936
TEST_TIME 25 10273
TEST_TIME 26 10408
TEST_TIME 27 10786
TEST_TIME 28 10720
TEST_TIME 29 10405
TEST_TIME 30 10311
TEST_TIME 31 10453
TEST_TIME 32 10231
TEST_TIME 33 10361
TEST_TIME 34 10252
TEST_TIME 35 10278
TEST_TIME 36 10202
TEST_TIME 37 10303
TEST_TIME 38 10202
TEST_TIME 39 10065
TEST_TIME 40 10046
TEST_TIME 41 10152
TEST_TIME 42 10201
TEST_TIME 43 10126
TEST_TIME 44 10275
TEST_TIME 45 10167
TEST_TIME 46 10005
TEST_TIME 47 9893
TEST_TIME 48 9907
TEST_TIME 49 9822
TEST_TIME 50 9709
TEST_TIME 51 9670
TEST_TIME 52 9545
TEST_TIME 53 9698
TEST_TIME 54 9773
TEST_TIME 55 9673
TEST_TIME 56 9603
TEST_TIME 57 9539
TEST_TIME 58 9468
TEST_TIME 59 9426
TEST_TIME 60 9370
TEST_TIME 61 9317
TEST_TIME 62 9226
TEST_TIME 63 9209
TEST_TIME 64 9218
TEST_TIME 65 9283
TEST_TIME 66 9255
TEST_TIME 67 9222
TEST_TIME 68 9336
TEST_TIME 69 9342
TEST_TIME 70 9413
TEST_TIME 71 9519
TEST_TIME 72 9524
TEST_TIME 73 9530
TEST_TIME 74 9573
TEST_TIME 75 9645
TEST_TIME 76 9653
TEST_TIME 77 9637
TEST_TIME 78 9544
TEST_TIME 79 9489
TEST_TIME 80 9506
TEST_TIME 81 9486
TEST_TIME 82 9413
TEST_TIME 83 9377
TEST_TIME 84 9360
TEST_TIME 85 9349
TEST_TIME 86 9350
TEST_TIME 87 9307
TEST_TIME 88 9324
TEST_TIME 89 9338
TEST_TIME 90 9349
TEST_TIME 91 9352
TEST_TIME 92 9360
TEST_TIME 93 9428
TEST_TIME 94 9438
TEST_TIME 95 9518
TEST_TIME 96 9559
TEST_TIME 97 9534
TEST_TIME 98 9521
TEST_TIME 99 9540
TEST_TIME 100 9566
TEST_TIME 101 9482
TEST_TIME 102 9454
TEST_TIME 103 9410
TEST_TIME 104 9427
TEST_TIME 105 9376
TEST_TIME 106 9324
TEST_TIME 107 9355
TEST_TIME 108 9353
TEST_TIME 109 9376
TEST_TIME 110 9342
TEST_TIME 111 9397
TEST_TIME 112 9377
TEST_TIME 113 9385
TEST_TIME 114 9405
TEST_TIME 115 9375
TEST_TIME 116 9425
TEST_TIME 117 9434
TEST_TIME 118 9501
TEST_TIME 119 9493
TEST_TIME 120 9475

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-11-2020 22:28:00 to 06-11-2020 22: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 1568339 1568339 0 0.00 0 19807 5 0 0
doc_list_biud 1568338 1568338 0 0.00 0 63561 26 0 0
sp_add_invoice_to_stock 5143 5041 102 1.98 48 207501 17690 0 102
sp_cancel_adding_invoice 5925 5925 0 0.00 4 59680 764 0 0
sp_cancel_client_order 1777 1777 0 0.00 4 17567 343 0 0
sp_cancel_customer_reserve 584312 584312 0 0.00 1 29417 53 0 0
sp_cancel_pay_from_customer 669 669 0 0.00 3 6588 70 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 3 4911 92 0 0
sp_cancel_supplier_invoice 6603 6597 6 0.09 2 63632 738 0 6
sp_cancel_supplier_order 455 455 0 0.00 6 902847 87542 0 0
sp_cancel_write_off 10247 10247 0 0.00 1 11911 105 0 0
sp_client_order 20295 20295 0 0.00 3 21345 346 0 0
sp_customer_reserve 465248 465248 0 0.00 0 102546 175 0 0
sp_fill_shopping_cart 31396 31396 0 0.00 1 11436 38 0 0
sp_fill_shopping_cart_clo_res 465243 465243 0 0.00 0 19120 15 0 0
sp_get_clo_for_invoice 5036 5036 0 0.00 0 20756 291 0 0
sp_kill_cost_storno 17272 17272 0 0.00 0 5396 52 0 0
sp_kill_qstorno_ret_qs2qd 1185923 1185923 0 0.00 0 63559 29 0 0
sp_kill_qty_storno 624215 624215 0 0.00 0 63560 63 0 0
sp_lock_selected_doc 20731 20731 0 0.00 0 8585 5 0 0
sp_make_cost_storno 27993 27993 0 0.00 0 19798 53 0 0
sp_multiply_rows_for_pdistr 27993 27993 0 0.00 0 11017 29 0 0
sp_multiply_rows_for_qdistr 20295 20295 0 0.00 0 21232 160 0 0
sp_pay_from_customer 7217 7217 0 0.00 4 7683 108 0 0
sp_pay_to_supplier 5873 5873 0 0.00 4 7942 116 0 0
sp_payment_common 13090 13090 0 0.00 1 7788 20 0 0
sp_qd_handle_on_cancel_clo 1777 1777 0 0.00 0 17562 318 0 0
sp_qd_handle_on_invoice_upd_sts 10961 10961 0 0.00 0 28518 339 0 0
sp_qd_handle_on_reserve_upd_sts 9866 9866 0 0.00 0 19801 58 0 0
sp_reserve_write_off 9867 9867 0 0.00 6 19876 177 0 0
sp_supplier_invoice 5533 5533 0 0.00 5 108626 3208 0 0
sp_supplier_order 5576 5576 0 0.00 5 36221 1277 0 0
srv_aggregate_perf_data 105 105 0 0.00 2623 220709 18229 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 986 144830 35125 0 0
srv_find_qd_qs_mism 1089187 1089187 0 0.00 0 17364 4 0 0
srv_make_invnt_saldo 544 544 0 0.00 19 64653 1279 0 0
srv_make_money_saldo 802 802 0 0.00 0 19552 53 0 0
srv_recalc_idx_stat 4 4 0 0.00 213846 432696 352541 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5042 5042 0 0.00 0 29266 159 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 1 3571 93 0 0
t$perf-norm:sp_cancel_client_order 1777 1777 0 0.00 0 4223 12 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 676 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 669 669 0 0.00 0 782 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 28635 70 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 2833 27 0 0
t$perf-norm:sp_cancel_supplier_order 455 455 0 0.00 0 42264 1426 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 2909 15 0 0
t$perf-norm:sp_client_order 20295 20295 0 0.00 0 29238 20 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 595 5 0 0
t$perf-norm:sp_pay_from_customer 7217 7217 0 0.00 0 5995 9 0 0
t$perf-norm:sp_pay_to_supplier 5873 5873 0 0.00 0 5016 10 0 0
t$perf-norm:sp_reserve_write_off 9867 9867 0 0.00 0 29203 15 0 0
t$perf-norm:sp_supplier_invoice 5533 5533 0 0.00 0 5334 21 0 0
t$perf-norm:sp_supplier_order 5576 5576 0 0.00 0 3389 14 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 359 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 58 1 0 0
t$perf-norm:srv_make_invnt_saldo 544 544 0 0.00 0 29206 83 0 0
t$perf-norm:srv_make_money_saldo 802 802 0 0.00 0 2039 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 55 18 0 0
v_add_invoice_to_stock 10276 10072 204 1.98 0 6439 19 0 204
v_all_customers 37588 37588 0 0.00 0 48 1 0 0
v_all_suppliers 30800 30800 0 0.00 0 98 1 0 0
v_all_wares 40588 40588 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 1556 9 0 0
v_cancel_client_order 3554 3554 0 0.00 0 1191 3 0 0
v_cancel_customer_prepayment 1338 1338 0 0.00 0 2318 5 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 2746 8 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 2610 10 0 0
v_cancel_supplier_invoice 820 808 12 1.46 0 409 13 0 12
v_cancel_supplier_order 910 910 0 0.00 0 2301 6 0 0
v_cancel_write_off 2000 2000 0 0.00 0 3669 18 0 0
v_max_id_clo_ord 5576 5576 0 0.00 0 5384 2 0 0
v_max_id_clo_res 995 995 0 0.00 0 1176 8 0 0
v_max_id_ord_sup 5526 5526 0 0.00 0 4219 4 0 0
v_max_non_paid_invoice 1575 1575 0 0.00 0 214 2 0 0
v_max_non_paid_realizn 3701 3701 0 0.00 0 3696 6 0 0
v_min_id_clo_ord 5576 5576 0 0.00 0 11392 10 0 0
v_min_id_clo_res 995 995 0 0.00 0 3074 9 0 0
v_min_id_ord_sup 5526 5526 0 0.00 0 8475 11 0 0
v_min_non_paid_invoice 5873 5873 0 0.00 0 7785 9 0 0
v_min_non_paid_realizn 7216 7216 0 0.00 0 5629 11 0 0
v_our_firm 10030 10030 0 0.00 0 16 1 0 0
v_reserve_write_off 19732 19732 0 0.00 0 6604 7 0 0
x_lock_depdocs_on_canc_invoice 12118 12118 0 0.00 0 20733 101 0 0
x_lock_depdocs_on_canc_sup_ord 455 455 0 0.00 0 6531 284 0 0
x_make_qstorno_1000_1200 5576 5576 0 0.00 1 36215 1194 0 0
x_make_qstorno_1200_2000 5533 5533 0 0.00 2 107848 3082 0 0
x_make_qstorno_2100_3300 465248 465248 0 0.00 0 102545 158 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-11-2020 22:28:04 to 06-11-2020 22: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
19:57:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:10 8771 8192000000 10191282800 10488434688 786472480 8.759 62 47 98 0 803613904 2046352 15095072
19:57:28 19808 8192000000 10313654608 10626740224 1358766304 14.226 100 85 171 0 1391387408 4313104 28308000
19:57:57 30969 8192000000 10372185968 10692128768 1417510992 14.751 100 87 174 0 1452516928 5998032 29007904
19:58:37 18473 8192000000 10408024352 10732318720 1450310992 15.041 100 87 173 1 1485552576 7047424 28194160
19:59:05 23448 8192000000 10417466368 10746880000 1474331152 15.252 100 89 178 0 1511139184 7885792 28922240
19:59:38 17662 8192000000 10432976288 10766700544 1485236688 15.347 100 86 172 0 1521279872 8229536 27813648
20:00:12 32574 8192000000 10465018768 10799493120 1512929360 15.589 100 88 177 0 1549751056 8669216 28152480
20:00:59 16034 8192000000 10478060304 10817638400 1534564032 15.777 100 87 174 0 1571803792 9368528 27871232
20:01:25 17817 8192000000 10508572208 10849722368 1555257072 15.955 100 81 162 1 1589163744 9289904 24616768
20:01:56 26276 8192000000 10540709920 10895368192 1593173728 16.281 100 84 168 1 1628893664 10086784 25633152
20:02:33 14663 8192000000 10568640880 10925338624 1624234480 16.546 100 75 150 0 1657556320 10719456 22602384
20:02:56 12770 8192000000 10595325040 10955735040 1647760720 16.745 100 79 158 1 1682541840 11848032 22933088
20:03:17 13276 8192000000 10606603280 10971967488 1667937968 16.916 100 81 162 0 1704028400 12806304 23284128
20:03:37 13102 8192000000 10626788400 10987003904 1682274352 17.036 100 86 172 0 1720581232 13723456 24583424
20:03:59 11305 8192000000 10633444688 11003097088 1696504832 17.156 100 90 180 2 1736633856 13729008 26400016
20:04:19 9773 8192000000 10659308880 11027972096 1709897440 17.268 100 82 165 4 1746626208 13111920 23616848
20:04:36 7302 8192000000 10669819984 11042336768 1730132016 17.437 100 83 166 1 1767964640 14032976 23799648
20:04:53 6674 8192000000 10685646064 11056099328 1736708608 17.491 100 84 167 0 1773507632 13066336 23732688
20:05:07 6743 8192000000 10696258912 11071868928 1748627472 17.590 100 79 157 0 1784066928 13261136 22178320
20:05:20 5395 8192000000 10701835504 11080556544 1758649728 17.673 100 82 160 1 1799581008 18163136 22768144
20:05:33 3482 8192000000 10713071328 11089575936 1766828128 17.741 100 81 158 1 1803043488 13743296 22472064
20:05:44 3303 8192000000 10713380016 11094872064 1773398176 17.795 100 77 154 2 1808849744 12302992 23148576
20:05:55 3060 8192000000 10724624320 11105542144 1785837072 17.898 100 84 166 4 1821903808 12944000 23122736
20:06:05 2927 8192000000 10736463600 11116417024 1790492880 17.936 100 89 179 0 1829851552 14134464 25224208
20:06:15 3069 8192000000 10733869856 11119058944 1796897408 17.988 100 86 171 0 1834947424 13966064 24083952
20:06:25 2601 8192000000 10733400128 11120877568 1801178800 18.024 100 79 156 2 1835233600 12430016 21624784
20:06:33 2372 8192000000 10753464768 11135143936 1805917968 18.062 100 87 174 2 1843354288 13163728 24272592
20:06:42 7125 8192000000 10746114448 11135172608 1810200368 18.098 100 76 152 2 1844203600 13333952 20669280
20:06:57 4695 8192000000 10754700352 11141832704 1815965456 18.145 100 76 151 1 1849527952 12914560 20647936
20:07:08 2993 8192000000 10778839248 11165843456 1829485760 18.255 100 88 176 1 1868221200 13491840 25243600
20:07:17 2150 8192000000 10781708400 11169198080 1836057200 18.309 100 86 172 2 1874302608 14151984 24093424
20:07:26 1767 8192000000 10782863424 11173347328 1842244144 18.359 100 93 186 0 1882488016 14249440 25994432
20:07:34 2156 8192000000 10794640208 11182309376 1852686400 18.444 100 96 190 3 1893757152 14010176 27060576
20:07:42 2789 8192000000 10803607344 11189518336 1857638352 18.484 100 97 192 2 1898855152 14623504 26593296
20:07:52 1982 8192000000 10800046704 11189673984 1857510656 18.483 100 90 178 4 1896315232 14152992 24651584
20:08:00 1900 8192000000 10802742224 11192164352 1858258880 18.489 100 90 178 1 1898401488 14403824 25738784
20:08:09 2008 8192000000 10809683472 11197202432 1863990416 18.536 100 91 181 0 1904552688 14136144 26426128
20:08:17 1413 8192000000 10812977824 11202834432 1867441632 18.564 100 93 184 0 1906953264 13265600 26246032
20:08:24 1522 8192000000 10806573456 11196366848 1868891568 18.575 100 89 179 1 1906584128 13532624 24159936
20:08:33 1900 8192000000 10816255824 11204755456 1872842624 18.607 100 91 182 1 1911621712 13953440 24825648
20:08:41 1818 8192000000 10823397184 11209605120 1876062672 18.633 100 90 179 2 1915944816 14083184 25798960
20:08:49 4544 8192000000 10813950960 11209797632 1874439008 18.620 100 66 133 2 1905538336 13051264 18048064
20:09:11 4620 8192000000 10804955232 11213635584 1882263712 18.683 100 81 161 0 1918445200 13204000 22977488
20:09:22 28735 8192000000 10790857712 11212853248 1876665216 18.638 100 48 95 1 1897833984 7598048 13570720
20:10:00 7842 8192000000 10796170864 11219177472 1879207792 18.659 100 35 73 1 1899218528 10156016 9854720
20:10:14 5888 8192000000 10799566112 11223814144 1887213504 18.723 100 43 86 0 1906786672 7499680 12073488
20:10:27 9329 8192000000 10784157264 11218911232 1880615008 18.670 100 16 32 1 1890894560 5606496 4673056
20:10:42 5151 8192000000 10788299312 11223838720 1885642880 18.711 100 27 54 1 1900206496 6835392 7728224
20:10:56 8085 8192000000 10788241968 11221946368 1883814896 18.696 100 18 34 2 1898660304 10304352 4541056
20:11:10 8590 8192000000 10785127424 11224387584 1883984928 18.697 100 10 20 1 1892244640 5561488 2698224
20:11:25 16435 8192000000 10798183744 11229691904 1887433008 18.725 100 10 20 0 1895963712 5493952 3036752
20:11:52 12207 8192000000 10796445056 11231768576 1891734960 18.760 100 12 25 1 1900758112 5626720 3396432
20:12:13 11785 8192000000 10804067392 11240894464 1896306912 18.797 100 21 41 3 1908657136 6746176 5604048
20:12:31 7972 8192000000 10805968752 11238862848 1897215424 18.804 100 17 34 1 1909119264 6548576 5355264
20:12:48 14175 8192000000 10813709136 11245662208 1901411536 18.838 100 20 40 2 1913575200 5957968 6205696
20:13:18 9611 8192000000 10824819712 11250618368 1907961232 18.890 100 25 50 1 1921743888 5859264 7923392
20:13:36 14942 8192000000 10805957840 11252772864 1908440624 18.894 100 24 47 0 1922119952 5572672 8106656
20:13:57 58350 8192000000 10844652224 11263795200 1912321152 18.925 100 47 92 2 1931202048 5578560 13302336
20:15:01 4681 8192000000 10837384752 11267854336 1915829168 18.953 100 48 97 1 1938516176 9861968 12825040
20:15:13 6129 8192000000 10838620032 11262828544 1894960928 18.786 99 42 84 1 1914010544 8099120 10950496
20:15:27 4404 8192000000 10833346896 11262963712 1911223200 18.916 100 35 70 0 1927851216 6765440 9862576
20:15:38 8134 8192000000 10812399072 11249549312 1875987264 18.633 98 37 74 3 1894336032 7861216 10487552
20:15:53 9304 8192000000 10831617264 11262111744 1907958224 18.890 100 34 68 0 1924403872 6808688 9636960
20:16:14 6792 8192000000 10804867232 11248189440 1900843056 18.833 100 27 54 1 1915179888 6413056 7923776
20:16:27 7702 8192000000 10809666960 11242004480 1882432208 18.685 99 22 43 1 1894897056 6143728 6321120
20:16:41 7780 8192000000 10803647392 11244081152 1882151888 18.682 99 21 42 1 1894744576 6435680 6157008
20:17:00 4561 8192000000 10801342576 11236896768 1889894864 18.745 100 30 59 1 1904822880 6248608 8679408
20:17:11 5670 8192000000 10799317936 11233128448 1869950256 18.584 99 26 51 2 1882882208 5652480 7279472
20:17:24 16472 8192000000 10766687072 11203473408 1800469952 18.018 96 14 28 0 1810208320 5998144 3740224
20:17:47 6731 8192000000 10758953952 11190685696 1822541280 18.198 98 20 41 0 1833312000 5294608 5476112
20:18:01 13527 8192000000 10775587008 11203067904 1824118896 18.211 98 17 33 2 1834726480 5776128 4831456
20:18:20 56033 8192000000 10754790496 11181154304 1741337152 17.530 93 31 60 1 1754757536 4721344 8699040
20:19:25 23328 8192000000 10724813248 11141201920 1677265056 16.994 91 30 60 2 1695441520 9813728 8362736
20:19:57 10758 8192000000 10731527376 11147943936 1769179392 17.760 97 29 58 0 1783872544 6944096 7749056
20:20:14 6365 8192000000 10711222256 11123224576 1776240416 17.818 99 32 64 0 1792366928 7049216 9077296
20:20:29 8126 8192000000 10695030480 11111288832 1744348384 17.555 97 32 64 1 1760441456 6805696 9287376
20:20:45 5305 8192000000 10701985008 11115782144 1772886096 17.791 99 26 52 1 1786903424 6495648 7521680
20:20:56 4884 8192000000 10721245712 11124375552 1767553376 17.747 98 26 52 1 1780589680 5153584 7882720
20:21:08 6055 8192000000 10684025776 11105005568 1730583040 17.440 97 22 44 1 1742821328 5881872 6356416
20:21:20 9487 8192000000 10679688880 11092623360 1713746880 17.300 96 13 25 2 1722314048 5012288 3554880
20:21:38 6295 8192000000 10697428656 11112005632 1770514128 17.771 99 30 60 2 1784759408 5270256 8975024
20:21:53 12517 8192000000 10701948848 11124318208 1755120768 17.644 97 11 22 2 1763557360 5086208 3350384
20:22:14 8264 8192000000 10729410336 11147776000 1806846160 18.070 100 15 30 0 1818177056 6510192 4820704
20:22:29 13914 8192000000 10725616784 11151368192 1799386752 18.009 99 15 30 1 1810143328 5551488 5205088
20:22:50 9277 8192000000 10742659248 11161149440 1810235904 18.098 99 19 37 3 1820602816 4867488 5499424
20:23:05 11078 8192000000 10742010880 11169644544 1814193600 18.130 99 16 32 1 1828571072 9978512 4398960
20:23:24 13868 8192000000 10765106160 11176071168 1823415680 18.206 99 38 75 2 1839990400 5060000 11514720
20:23:45 72411 8192000000 10764165536 11186880512 1827635488 18.240 99 27 54 0 1841497760 5732928 8129344
20:25:13 10373 8192000000 10774043376 11193675776 1852097152 18.439 100 24 48 0 1862949568 4387392 6465024
20:25:32 9637 8192000000 10788527040 11208069120 1859583344 18.500 100 30 60 0 1874737008 6640304 8513360
20:25:50 7409 8192000000 10792561792 11213914112 1866036096 18.552 100 35 70 2 1882594832 5948672 10610064
20:26:04 9278 8192000000 10790163888 11216269312 1870432144 18.588 100 29 58 3 1884618160 6150976 8035040
20:26:23 8156 8192000000 10784655200 11217063936 1871826240 18.599 100 26 52 0 1885400672 6298128 7276304
20:26:37 5097 8192000000 10787644400 11220742144 1876073840 18.633 100 30 59 1 1889818832 5405152 8339840
20:26:49 12579 8192000000 10790692944 11226398720 1878959200 18.657 100 23 46 0 1895920496 10089360 6871936
20:27:10 38383 8192000000 10821475872 11249909760 1899045104 18.819 100 41 82 2 1917006288 6224752 11736432
20:28:11 22746 8192000000 10854902704 11279089664 1914185616 18.940 100 38 74 0 1933127296 8747184 10194496
20:28:41 25698 8192000000 10872428032 11294298112 1932444112 19.086 100 39 78 0 1954360096 10567760 11348224
20:29:22 12983 8192000000 10890530320 11309150208 1947270224 19.205 100 42 84 2 1973042800 14305792 11466784
20:29:57 16567 8192000000 10896661600 11318280192 1957233552 19.284 100 47 94 2 1986876752 15897104 13746096
20:30:26 2724 8192000000 10907350272 11326504960 1962746624 19.328 100 57 112 0 1995807312 16615872 16444816
20:30:37 42634 8192000000 10908061760 11336720384 1965813680 19.352 100 57 112 5 2001255280 18378400 17063200
20:31:52 74536 8192000000 10890481696 11339214848 1962629760 19.327 100 39 78 0 1997870864 23450928 11790176
20:33:15 49894 8192000000 10903428784 11340705792 1956113424 19.275 100 25 50 0 1987935328 23835456 7986448
20:34:15 17468 8192000000 10918567392 11352543232 1965596992 19.351 100 42 84 1 2003419008 25145040 12676976
20:34:40 36044 8192000000 10933790736 11361857536 1976696480 19.439 100 52 102 0 2020412256 28077232 15638544
20:35:27 25746 8192000000 10952062448 11382513664 1990767552 19.550 100 45 90 0 2031967216 27880000 13319664
20:36:00 7790 8192000000 10942192784 11385020416 1993444896 19.571 100 40 80 0 2034807712 28629680 12733136
20:36:15 7476 8192000000 10968493248 11397943296 2000643792 19.628 100 61 121 0 2049778416 31188432 17946192
20:36:31 5427 8192000000 10979551856 11408150528 2011665344 19.715 100 76 151 3 2065240048 31614160 21960544
20:36:45 4287 8192000000 10984188128 11408982016 2016411984 19.752 100 70 140 1 2070173984 33326032 20435968
20:36:58 5106 8192000000 10972352336 11404197888 2013190224 19.727 100 61 120 0 2058018144 27645600 17182320
20:37:11 6886 8192000000 10980715088 11406176256 2016841984 19.755 100 67 134 1 2064476160 28016432 19617744
20:37:27 5875 8192000000 10967396160 11392737280 1999461536 19.618 99 65 130 0 2049170672 30054960 19654176
20:37:44 6939 8192000000 10981337568 11410173952 2017714688 19.762 100 73 143 1 2070097776 31346640 21036448
20:38:10 1989 8192000000 10986297392 11414249472 2020976752 19.788 100 74 147 0 2077151472 33456800 22717920
20:38:20 3697 8192000000 10988640640 11419119616 2019252704 19.774 100 65 130 4 2072663312 33075344 20335264
20:38:32 7949 8192000000 10980341152 11412717568 1999555008 19.619 99 56 112 1 2050693280 33691200 17447072
20:38:48 3415 8192000000 10979641760 11398709248 2001235744 19.632 99 70 140 0 2057670192 35033776 21400672
20:38:59 1986 8192000000 10978011488 11406569472 1994979024 19.583 99 65 125 2 2050763600 35425120 20359456
20:39:08 1807 8192000000 10997712432 11418472448 2017222944 19.758 100 86 168 1 2080028496 36895440 25910112
20:39:18 1619 8192000000 10991196944 11415097344 2011565280 19.714 100 76 151 2 2071898304 37051744 23281280
20:39:28 5853 8192000000 11001934064 11417518080 2016846496 19.755 100 74 148 2 2077556848 37100864 23609488
20:39:41 6915 8192000000 10996221648 11423084544 2022892896 19.803 100 70 140 0 2079820016 36325024 20602096
20:39:55 3680 8192000000 10989710288 11415396352 2019536816 19.777 100 79 157 1 2073908096 30686288 23684992
20:40:10 2065 8192000000 10993029024 11419394048 2024687568 19.817 100 77 153 1 2078330656 31077296 22565792
20:40:19 6661 8192000000 10993132816 11419054080 2020724864 19.786 100 77 152 2 2074692816 30665088 23302864
20:40:35 5747 8192000000 11000943744 11429949440 2029009072 19.851 100 72 144 0 2083224848 31930896 22284880
20:40:48 1483 8192000000 11010240640 11433336832 2032911136 19.881 100 74 147 0 2087654336 31892144 22851056
20:40:57 2645 8192000000 11012819920 11433291776 2031767696 19.872 100 84 168 0 2091461808 33659072 26035040
20:41:08 3659 8192000000 11004984064 11424587776 2024632560 19.817 100 85 170 0 2085237760 35293712 25311488
20:41:20 3223 8192000000 10998824464 11416899584 2013165664 19.726 100 90 180 2 2076410912 35379584 27865664
20:41:32 12217 8192000000 10990853056 11415343104 1999850480 19.622 99 77 153 2 2061252624 37702400 23699744
20:41:59 2506 8192000000 10983849952 11418312704 2014124704 19.734 100 64 128 0 2070857328 36946192 19786432
20:42:10 3315 8192000000 10974287872 11403124736 1998145696 19.608 99 63 126 2 2054555488 36975712 19434080
20:42:22 6334 8192000000 10970487968 11395031040 1991056672 19.552 100 74 146 3 2052515392 38494624 22964096
20:42:35 6756 8192000000 10985813376 11404918784 1998631312 19.612 100 87 174 0 2066770928 41581248 26558368
20:42:51 1433 8192000000 10989522880 11411972096 2005008304 19.662 100 77 154 1 2070677520 41957568 23711648
20:42:59 3633 8192000000 10995149040 11415670784 2005496096 19.666 100 83 166 0 2071962656 40858400 25608160
20:43:11 2613 8192000000 10981793040 11395981312 1984174992 19.498 99 93 186 0 2050450704 38894304 27381408
20:43:21 4744 8192000000 10988215408 11401347072 1978037120 19.449 99 85 170 4 2043471920 38990544 26444256
20:43:32 2470 8192000000 10993220048 11402014720 1995839104 19.590 100 94 187 3 2066604432 42426448 28338880
20:43:41 1819 8192000000 10993509920 11408121856 2002866672 19.645 100 92 182 2 2074592160 43410736 28314752
20:43:50 2890 8192000000 10996332016 11409444864 1998178784 19.608 100 86 172 1 2069953584 44676272 27098528
20:44:02 4304 8192000000 10976559616 11393007616 1985215952 19.506 100 78 156 0 2054530944 44440320 24874672
20:44:14 984 8192000000 10995055568 11409039360 1999960480 19.622 100 87 172 3 2069833088 43727312 26145296
20:44:22 2414 8192000000 10983959904 11400003584 1982481120 19.484 99 89 178 1 2055293888 46182496 26630272
20:44:31 4534 8192000000 10970940816 11400720384 1989711200 19.542 100 64 124 1 2053820112 45108656 19000256
20:44:44 14480 8192000000 10955525536 11405869056 1989362864 19.539 100 29 58 1 2046274384 46977456 9934064
20:45:06 11954 8192000000 10973015664 11404509184 1961606496 19.319 98 53 106 1 2019492096 40360000 17525600
20:45:24 4975 8192000000 10990691280 11414827008 2000520560 19.627 100 78 156 2 2067460880 42700448 24239872
20:45:38 3211 8192000000 10980379840 11406331904 1985216832 19.506 99 80 161 1 2054172544 44877936 24077776
20:45:49 5982 8192000000 10967079872 11406520320 1973430384 19.413 99 64 128 2 2042241056 48321328 20489344
20:46:05 7790 8192000000 10952503248 11405787136 1983730672 19.494 100 42 84 0 2040402880 43192080 13480128
20:46:25 10434 8192000000 10912079376 11360387072 1925617904 19.032 98 41 79 4 1979019360 40108016 13293440
20:46:50 15208 8192000000 10935645184 11374088192 1960285392 19.308 100 30 60 2 2012518784 41557088 10676304
20:47:15 6016 8192000000 10941108656 11368525824 1955590272 19.271 100 53 106 2 2016497456 43242464 17664720
20:47:32 3209 8192000000 10946252720 11356635136 1942258032 19.165 99 76 151 1 2014102800 47587280 24257488
20:47:42 2971 8192000000 10950036896 11367378944 1956008176 19.274 100 82 164 1 2030320272 47388656 26923440
20:47:52 11850 8192000000 10936586720 11379245056 1958851296 19.297 100 48 96 1 2025912576 51737360 15323920
20:48:17 10080 8192000000 10960099568 11401150464 1975821888 19.432 100 37 74 1 2043442432 54826928 12793616
20:48:33 13751 8192000000 10913794752 11362422784 1901721984 18.840 97 37 73 2 1964069248 49970736 12376528
20:49:00 14340 8192000000 10917336160 11355803648 1929011664 19.059 99 34 69 1 1988435952 47791232 11633056
20:49:39 27525 8192000000 10912913504 11356573696 1906007776 18.875 98 26 52 2 1967613584 52691376 8914432
20:50:17 32863 8192000000 10891870672 11347841024 1914881296 18.946 99 21 42 1 1968335520 45938608 7515616
20:51:06 35417 8192000000 10897162848 11363819520 1919845824 18.986 99 21 42 0 1970622752 43605520 7171408
20:52:02 42825 8192000000 10889312368 11336384512 1908868176 18.898 99 16 32 3 1957421520 42641904 5911440
20:52:58 26471 8192000000 10897448720 11332587520 1904772080 18.865 98 50 100 0 1950393504 30954960 14666464
20:53:31 25121 8192000000 10862438064 11309133824 1914135568 18.940 100 37 74 0 1948845904 24015472 10694864
20:54:04 19255 8192000000 10851754400 11315027968 1923008368 19.011 100 23 46 3 1946874720 16631632 7234720
20:54:44 59887 8192000000 10843317408 11295916032 1880107120 18.666 98 11 22 2 1902827216 19251392 3468704
20:55:52 38946 8192000000 10875187008 11319091200 1908340080 18.893 100 23 46 1 1940660272 25689232 6630960
20:56:39 28040 8192000000 10858063760 11323117568 1914688960 18.944 100 17 34 1 1947123280 27497504 4936816
20:57:21 67703 8192000000 10871253200 11328237568 1920986480 18.995 100 16 33 0 1935946624 11120448 3839696
20:58:51 98651 8192000000 10844578624 11296358400 1802758608 18.037 93 27 51 1 1821041632 11636624 6646400
21:00:37 71486 8192000000 10823320432 11281489920 1844339808 18.376 96 7 14 0 1856146912 10021312 1785792
21:01:55 85901 8192000000 10848649920 11308154880 1912633328 18.928 99 10 20 1 1926086000 10725216 2727456
21:03:27 77487 8192000000 10869429936 11324350464 1866548848 18.556 96 6 12 0 1879974688 11507472 1918368
21:04:51 40163 8192000000 10894164032 11338317824 1949984256 19.226 100 24 45 3 1963069264 6491152 6593856
21:05:39 15085 8192000000 10909195568 11335184384 1942380128 19.166 99 67 136 1 1969345760 7562224 19403408
21:06:06 39775 8192000000 10889312848 11337097216 1926225792 19.037 99 24 48 2 1945291664 12392400 6673472
21:07:13 103950 8192000000 10881720992 11349151744 1911312784 18.917 98 6 12 0 1933336432 20610640 1413008
21:09:22 144829 8192000000 10898298720 11371294720 1943982560 19.179 99 7 14 1 1958924400 13282448 1659392
21:12:04 30976 8192000000 10894069312 11346718720 1965048416 19.346 100 32 64 3 1984162912 10039264 9075232
21:12:41 104565 8192000000 10887808416 11338752000 1948346384 19.213 99 27 54 2 1964664544 9048688 7269472
21:14:40 24131 8192000000 10923495152 11364376576 1971427056 19.397 100 44 88 1 1993846912 9547616 12872240
21:15:14 9590 8192000000 10920328736 11370958848 1979722960 19.463 100 67 135 1 2010416096 11348112 19345024
21:15:41 84768 8192000000 10948709936 11379601408 1979474848 19.461 99 68 132 4 2009009584 10126080 19408656
21:17:12 70580 8192000000 10930005648 11393773568 1973934576 19.417 99 31 62 0 1996291392 12781744 9575072
21:18:29 54350 8192000000 10933703248 11395710976 1974380128 19.420 99 35 70 1 2001829376 16594976 10854272
21:19:56 60460 8192000000 10914784064 11403739136 1974049888 19.418 100 16 31 0 2002758192 24070384 4637920
21:21:03 100072 8192000000 10895869328 11386916864 1940072448 19.147 98 6 12 0 1963342016 21632976 1636592
21:22:54 57740 8192000000 10886917392 11364126720 1954792112 19.265 99 13 26 0 1968513984 10189360 3532512
21:24:12 64441 8192000000 10893310624 11378364416 1957260352 19.284 99 25 50 1 1977911936 12469072 8182512
21:25:39 30750 8192000000 10899830400 11374211072 1962554688 19.326 99 18 36 2 1975096144 7413136 5128320
21:26:19 96072 8192000000 10886619008 11370717184 1942237392 19.165 98 20 40 1 1960801264 12698320 5865552
21:28:12 34256 8192000000 10884247776 11353624576 1937938320 19.130 98 30 61 3 1951636944 6057968 7640656
21:28:54 84081 8192000000 10884464624 11373019136 1950835248 19.233 99 10 20 0 1965981632 12550336 2596048
21:30:27 83904 8192000000 10873126400 11355447296 1868767552 18.574 95 14 26 2 1880729456 8682736 3279168
21:32:05 24136 8192000000 10905255280 11370086400 1958610096 19.295 100 22 44 1 1978468576 13387968 6470512
21:32:39 55261 8192000000 10918000848 11382128640 1939025200 19.139 98 15 30 1 1957976896 14368272 4583424
21:33:40 54460 8192000000 10883218336 11352371200 1863681056 18.533 94 15 30 0 1888257408 20010928 4565424
21:34:46 67821 8192000000 10901336128 11368218624 1912818496 18.929 97 21 42 1 1934429728 15186272 6424960
21:36:03 37191 8192000000 10898017424 11359391744 1928303152 19.053 98 22 44 1 1953451664 18432096 6716416
21:36:55 43692 8192000000 10898630528 11374018560 1946921328 19.202 99 26 52 2 1970876272 15914144 8040800
21:37:51 43481 8192000000 10887305312 11347668992 1884840448 18.704 96 12 24 0 1896746272 8705952 3199872
21:38:43 31689 8192000000 10898586912 11355426816 1944997312 19.187 99 45 91 1 1967747472 9528320 13221840
21:39:29 46736 8192000000 10879439712 11340066816 1909239648 18.901 97 37 74 1 1932519488 12774704 10505136
21:40:39 74955 8192000000 10854120400 11326447616 1852402208 18.442 95 17 34 1 1874569744 17362672 4804864
21:42:02 82122 8192000000 10880582976 11336511488 1894652784 18.783 98 21 42 0 1913355536 12847552 5855200
21:43:38 23814 8192000000 10886808944 11317055488 1887528816 18.726 97 55 109 0 1916902704 14102096 15271792
21:44:09 85173 8192000000 10875930240 11328212992 1932715936 19.089 100 60 120 0 1964987600 15614272 16657392
21:47:09 43656 8192000000 10830842128 11301232640 1868978688 18.576 97 21 42 1 1882034224 7217680 5837856
21:47:59 62784 8192000000 10835798080 11294568448 1888572672 18.734 98 15 30 0 1901178624 8377744 4228208
21:49:10 28677 8192000000 10820049904 11292061696 1880665072 18.670 98 7 14 0 1890109200 7574416 1869712
21:49:47 28252 8192000000 10819873408 11285131264 1865754528 18.550 98 8 16 0 1878180720 10013184 2413008
21:50:23 67719 8192000000 10839678464 11317477376 1915410576 18.950 100 11 22 0 1931776912 13305056 3061280
21:51:38 88961 8192000000 10852003152 11325693952 1898893920 18.817 99 14 28 0 1914363632 11740304 3729408
21:53:16 30586 8192000000 10861930320 11329974272 1935564784 19.111 100 29 58 0 1955307968 11494432 8248752
21:53:53 54160 8192000000 10845228736 11320147968 1894538784 18.782 98 19 38 0 1910424608 10869168 5016656
21:54:53 68152 8192000000 10849731456 11325227008 1881602416 18.678 97 15 30 2 1895525760 9788816 4134528
21:56:08 67466 8192000000 10864813984 11323023360 1856752192 18.477 96 16 32 0 1872771040 11268864 4749984
21:57:21 68678 8192000000 10866777264 11344965632 1892298464 18.764 97 15 29 1 1910532912 14150544 4083904
21:58:36 113276 8192000000 10875168736 11347849216 1882414432 18.685 96 8 16 1 1903527232 19359632 1753168
22:00:36 66994 8192000000 10894756496 11379970048 1961935856 19.321 100 14 28 0 1978281648 12583280 3762512
22:01:51 70133 8192000000 10898864880 11373846528 1957109952 19.283 99 8 16 0 1973235872 14341728 1784192
22:03:13 31800 8192000000 10912702400 11374399488 1963625728 19.335 99 20 40 0 1978295488 9407440 5262320
22:03:51 18198 8192000000 10934014256 11381268480 1981959696 19.480 100 32 64 1 1999172288 7736320 9476272
22:04:17 11632 8192000000 10928139984 11377627136 1984818432 19.503 100 60 120 0 2012425312 11587920 16018960
22:04:39 51154 8192000000 10904407008 11381972992 1963612048 19.335 99 34 69 0 1983886704 11047680 9226976
22:05:38 100206 8192000000 10891345296 11368030208 1904537552 18.863 96 17 34 0 1918207936 9087792 4582592
22:07:57 71691 8192000000 10884182928 11353702400 1940063072 19.147 98 24 48 2 1953072112 6579840 6429200
22:09:20 38139 8192000000 10924275712 11380125696 1985802464 19.511 100 36 71 2 2003608192 8265408 9540320
22:10:18 48974 8192000000 10920259056 11398799360 1991416832 19.555 100 27 54 1 2010110416 11489376 7204208
22:11:14 59010 8192000000 10919177920 11407331328 1991617536 19.557 100 10 20 1 2011790640 17358464 2814640
22:12:19 27036 8192000000 10923701072 11412844544 1994237648 19.577 100 7 14 0 2018564368 22362704 1964016
22:12:52 35837 8192000000 10925028976 11407568896 1975107216 19.426 99 9 18 0 1997844000 20278816 2457968
22:13:34 50503 8192000000 10912541440 11383353344 1937896912 19.130 97 23 46 0 1960851632 16013264 6941456
22:14:44 81292 8192000000 10914391968 11404357632 1987160128 19.521 100 15 30 0 2007333056 15547216 4625712
22:16:35 22421 8192000000 10890099712 11356672000 1936883584 19.122 97 28 55 1 1955974240 11104128 7986528
22:17:09 57065 8192000000 10881838976 11368271872 1912170016 18.924 97 17 33 1 1927420064 10332192 4917856
22:18:16 49766 8192000000 10899317424 11373752320 1935131056 19.108 98 25 50 1 1952114176 9119792 7863328
22:20:20 52561 8192000000 10890964448 11358724096 1943905296 19.178 99 24 48 0 1958454320 7907920 6641104
22:21:19 58055 8192000000 10894558736 11357523968 1869573360 18.581 95 18 36 1 1887790848 13367088 4850400
22:22:53 90644 8192000000 10871679600 11344543744 1834655744 18.297 94 15 30 0 1859825344 20048784 5120816
22:24:51 63641 8192000000 10873410944 11323314176 1822263232 18.196 94 19 38 1 1840968400 13869504 4835664
22:26:03 60615 8192000000 10417528992 10840662016 1473915968 15.248 76 9 18 1 1491825936 15433568 2476400

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 06-11-2020 22:28:10 to 06-11-2020 22:28:40.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-11-2020 22:28:41 to 06-11-2020 22:28:43.

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          237593
MON$OLDEST_ACTIVE               239492
MON$OLDEST_SNAPSHOT             239492
MON$NEXT_TRANSACTION            239492
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                       2029280
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33387 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33387 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33387 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33387 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 ---
:136: 
:137: mscs-test-161.budzdorov.ru    Fri Nov  6 22:27:23 2020
:138:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:139: 
--- end of diff output ---

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

06.11.20 22:28:44. 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-06 22:28:47 No severe PSQL-related problems occured
06.11.20 22:28:48. End of report.