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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-22 19:27:19
DTS_END                         2021-02-22 19:27:19.4250
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/32820
TRN_ID                          241584
ATT_ID                          671
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: 9251.04 21576 1110125
customer order: creation 176.35 344 21162
customer order: refuse 15.19 332 1823
order to supplier: creation 46.05 1295 5526
order to supplier: removal 3.33 107587 400
invoice (draft): creation 47.14 3505 5657
invoice (draft): removal 50.44 808 6053
invoice accept: apply 43.17 18881 5180
invoice accept: cancel 45.83 872 5500
customer reserve: creation 4012.93 186 481551
customer reserve: removal 4506.13 62 540735
realization accept: apply 84.28 180 10113
realization accept: cancel 87.50 108 10500
payment from customer: creation 61.33 120 7359
payment from customer: removal 5.84 83 701
payment to supplier: creation 49.98 131 5997
payment to supplier: removal 3.58 114 429
service: total inventory turnovers 4.84 1301 581
service: total monetary turnovers 6.38 37 766
service: aggregate perf. data 0.73 29285 88
service: refresh index statistics 0.03 266291 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-02-2021 19:29:56 to 22-02-2021 19:29:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7768
TEST_TIME 2 6703
TEST_TIME 3 5896
TEST_TIME 4 5049
TEST_TIME 5 5232
TEST_TIME 6 5367
TEST_TIME 7 5657
TEST_TIME 8 5725
TEST_TIME 9 5500
TEST_TIME 10 6161
TEST_TIME 11 6368
TEST_TIME 12 6387
TEST_TIME 13 6337
TEST_TIME 14 6807
TEST_TIME 15 6810
TEST_TIME 16 7158
TEST_TIME 17 7657
TEST_TIME 18 7955
TEST_TIME 19 8188
TEST_TIME 20 8037
TEST_TIME 21 8369
TEST_TIME 22 8672
TEST_TIME 23 9001
TEST_TIME 24 9055
TEST_TIME 25 9036
TEST_TIME 26 9264
TEST_TIME 27 9631
TEST_TIME 28 10784
TEST_TIME 29 10629
TEST_TIME 30 10592
TEST_TIME 31 10398
TEST_TIME 32 10452
TEST_TIME 33 10235
TEST_TIME 34 10104
TEST_TIME 35 10161
TEST_TIME 36 10080
TEST_TIME 37 10016
TEST_TIME 38 9898
TEST_TIME 39 9861
TEST_TIME 40 9775
TEST_TIME 41 9773
TEST_TIME 42 9761
TEST_TIME 43 9765
TEST_TIME 44 9738
TEST_TIME 45 9605
TEST_TIME 46 9611
TEST_TIME 47 9546
TEST_TIME 48 9638
TEST_TIME 49 9603
TEST_TIME 50 9501
TEST_TIME 51 9480
TEST_TIME 52 9416
TEST_TIME 53 9385
TEST_TIME 54 9346
TEST_TIME 55 9349
TEST_TIME 56 9378
TEST_TIME 57 9396
TEST_TIME 58 9411
TEST_TIME 59 9470
TEST_TIME 60 9543
TEST_TIME 61 9531
TEST_TIME 62 9581
TEST_TIME 63 9626
TEST_TIME 64 9623
TEST_TIME 65 9644
TEST_TIME 66 9809
TEST_TIME 67 9767
TEST_TIME 68 9694
TEST_TIME 69 9703
TEST_TIME 70 9626
TEST_TIME 71 9559
TEST_TIME 72 9560
TEST_TIME 73 9481
TEST_TIME 74 9460
TEST_TIME 75 9403
TEST_TIME 76 9341
TEST_TIME 77 9371
TEST_TIME 78 9329
TEST_TIME 79 9484
TEST_TIME 80 9477
TEST_TIME 81 9468
TEST_TIME 82 9509
TEST_TIME 83 9510
TEST_TIME 84 9510
TEST_TIME 85 9509
TEST_TIME 86 9512
TEST_TIME 87 9522
TEST_TIME 88 9571
TEST_TIME 89 9601
TEST_TIME 90 9658
TEST_TIME 91 9560
TEST_TIME 92 9515
TEST_TIME 93 9506
TEST_TIME 94 9430
TEST_TIME 95 9400
TEST_TIME 96 9340
TEST_TIME 97 9384
TEST_TIME 98 9390
TEST_TIME 99 9419
TEST_TIME 100 9484
TEST_TIME 101 9508
TEST_TIME 102 9448
TEST_TIME 103 9520
TEST_TIME 104 9485
TEST_TIME 105 9523
TEST_TIME 106 9523
TEST_TIME 107 9550
TEST_TIME 108 9507
TEST_TIME 109 9575
TEST_TIME 110 9538
TEST_TIME 111 9580
TEST_TIME 112 9515
TEST_TIME 113 9479
TEST_TIME 114 9451
TEST_TIME 115 9440
TEST_TIME 116 9443
TEST_TIME 117 9399
TEST_TIME 118 9382
TEST_TIME 119 9337
TEST_TIME 120 9262

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 22-02-2021 19:29:59 to 22-02-2021 19:30: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 1555571 1555571 0 0.00 0 44465 7 0 0
doc_list_biud 1555571 1555571 0 0.00 0 42353 27 0 0
sp_add_invoice_to_stock 5288 5180 108 2.04 81 246402 18882 0 108
sp_cancel_adding_invoice 5500 5500 0 0.00 5 78850 872 0 0
sp_cancel_client_order 1823 1823 0 0.00 4 21726 332 0 0
sp_cancel_customer_reserve 540735 540735 0 0.00 1 24530 62 0 0
sp_cancel_pay_from_customer 701 701 0 0.00 2 6347 84 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 6846 114 0 0
sp_cancel_supplier_invoice 6059 6053 6 0.09 2 16741 809 0 6
sp_cancel_supplier_order 400 400 0 0.00 9 1062958 107587 0 0
sp_cancel_write_off 10500 10500 0 0.00 1 11130 109 0 0
sp_client_order 21162 21162 0 0.00 4 16489 345 0 0
sp_customer_reserve 481551 481551 0 0.00 0 43930 186 0 0
sp_fill_shopping_cart 32336 32336 0 0.00 1 13410 37 0 0
sp_fill_shopping_cart_clo_res 481536 481536 0 0.00 0 13915 11 0 0
sp_get_clo_for_invoice 5164 5164 0 0.00 0 35702 286 0 0
sp_kill_cost_storno 17130 17130 0 0.00 0 10777 56 0 0
sp_kill_qstorno_ret_qs2qd 1098423 1098423 0 0.00 0 23035 34 0 0
sp_kill_qty_storno 580288 580288 0 0.00 0 42352 73 0 0
sp_lock_selected_doc 21171 21171 0 0.00 0 10562 7 0 0
sp_make_cost_storno 28633 28633 0 0.00 0 44456 50 0 0
sp_multiply_rows_for_pdistr 28633 28633 0 0.00 0 14296 29 0 0
sp_multiply_rows_for_qdistr 21162 21162 0 0.00 0 15148 156 0 0
sp_pay_from_customer 7359 7359 0 0.00 4 18019 120 0 0
sp_pay_to_supplier 5997 5997 0 0.00 5 44477 132 0 0
sp_payment_common 13356 13356 0 0.00 2 18013 28 0 0
sp_qd_handle_on_cancel_clo 1823 1823 0 0.00 0 21115 301 0 0
sp_qd_handle_on_invoice_upd_sts 10664 10664 0 0.00 0 42350 348 0 0
sp_qd_handle_on_reserve_upd_sts 10113 10113 0 0.00 0 18403 60 0 0
sp_reserve_write_off 10113 10113 0 0.00 6 18778 180 0 0
sp_supplier_invoice 5657 5657 0 0.00 7 119917 3506 0 0
sp_supplier_order 5526 5526 0 0.00 5 21147 1296 0 0
srv_aggregate_perf_data 88 88 0 0.00 2937 255845 29285 0 0
srv_fill_mon_cache_memory 178 178 0 0.00 250 101401 29531 0 0
srv_find_qd_qs_mism 1060693 1060693 0 0.00 0 16677 7 0 0
srv_make_invnt_saldo 581 581 0 0.00 30 93822 1302 0 0
srv_make_money_saldo 766 766 0 0.00 1 10313 38 0 0
srv_recalc_idx_stat 4 4 0 0.00 124170 533571 266291 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 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 5181 5181 0 0.00 0 11946 180 0 0
t$perf-norm:sp_cancel_adding_invoice 442 442 0 0.00 0 4802 111 0 0
t$perf-norm:sp_cancel_client_order 1823 1823 0 0.00 0 2844 12 0 0
t$perf-norm:sp_cancel_customer_reserve 689 689 0 0.00 0 2290 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 701 701 0 0.00 0 6126 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 569 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 401 401 0 0.00 0 858 15 0 0
t$perf-norm:sp_cancel_supplier_order 400 400 0 0.00 0 25250 1565 0 0
t$perf-norm:sp_cancel_write_off 1014 1014 0 0.00 0 782 4 0 0
t$perf-norm:sp_client_order 21162 21162 0 0.00 0 16592 19 0 0
t$perf-norm:sp_customer_reserve 999 999 0 0.00 0 2388 7 0 0
t$perf-norm:sp_pay_from_customer 7359 7359 0 0.00 0 7700 12 0 0
t$perf-norm:sp_pay_to_supplier 5997 5997 0 0.00 0 15816 13 0 0
t$perf-norm:sp_reserve_write_off 10113 10113 0 0.00 0 7075 11 0 0
t$perf-norm:sp_supplier_invoice 5657 5657 0 0.00 0 2774 13 0 0
t$perf-norm:sp_supplier_order 5526 5526 0 0.00 0 16517 20 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 81 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 178 178 0 0.00 0 977 7 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 666 21 0 0
t$perf-norm:srv_make_money_saldo 766 766 0 0.00 0 1750 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10534 10318 216 2.05 0 9527 21 0 216
v_all_customers 38498 38498 0 0.00 0 18 1 0 0
v_all_suppliers 30908 30908 0 0.00 0 21 1 0 0
v_all_wares 42324 42324 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 884 884 0 0.00 0 6316 19 0 0
v_cancel_client_order 3646 3646 0 0.00 0 3913 6 0 0
v_cancel_customer_prepayment 1402 1402 0 0.00 0 6329 12 0 0
v_cancel_customer_reserve 1378 1378 0 0.00 0 759 4 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 5961 19 0 0
v_cancel_supplier_invoice 814 802 12 1.47 0 3369 20 0 12
v_cancel_supplier_order 800 800 0 0.00 0 1651 6 0 0
v_cancel_write_off 2028 2028 0 0.00 0 1086 13 0 0
v_max_id_clo_ord 5525 5525 0 0.00 0 495 1 0 0
v_max_id_clo_res 999 999 0 0.00 0 2931 12 0 0
v_max_id_ord_sup 5649 5649 0 0.00 0 5349 5 0 0
v_max_non_paid_invoice 1717 1717 0 0.00 0 275 2 0 0
v_max_non_paid_realizn 3974 3974 0 0.00 0 2453 4 0 0
v_min_id_clo_ord 5525 5525 0 0.00 0 4874 6 0 0
v_min_id_clo_res 999 999 0 0.00 0 4383 7 0 0
v_min_id_ord_sup 5649 5649 0 0.00 0 4461 8 0 0
v_min_non_paid_invoice 5997 5997 0 0.00 0 4625 11 0 0
v_min_non_paid_realizn 7359 7359 0 0.00 0 11266 18 0 0
v_our_firm 10596 10596 0 0.00 0 18 1 0 0
v_reserve_write_off 20226 20226 0 0.00 0 6884 8 0 0
x_lock_depdocs_on_canc_invoice 11152 11152 0 0.00 0 15694 130 0 0
x_lock_depdocs_on_canc_sup_ord 400 400 0 0.00 0 15247 398 0 0
x_make_qstorno_1000_1200 5526 5526 0 0.00 2 21137 1215 0 0
x_make_qstorno_1200_2000 5657 5657 0 0.00 3 116677 3375 0 0
x_make_qstorno_2100_3300 481551 481551 0 0.00 0 43928 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-02-2021 19:30:04 to 22-02-2021 19:30: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:23 13 8192000000 8816330592 8831537152 19978768 0.243 4 3 4 0 20220400 79600 162032
16:57:30 10496 8192000000 10175090352 10473840640 881320000 9.713 69 60 122 0 904023552 2365328 20338224
16:57:49 16209 8192000000 10302193344 10617978880 1347461952 14.125 100 82 164 0 1378216464 4043952 26710560
16:58:16 22969 8192000000 10339653488 10658373632 1396184640 14.561 100 86 171 0 1429966896 5669200 28113056
16:58:47 3127 8192000000 10358505104 10679193600 1419115696 14.765 100 90 179 1 1455274960 6270800 29888464
16:59:03 23892 8192000000 10385988848 10706190336 1435729856 14.912 100 89 178 0 1472585216 7171936 29683424
16:59:37 12782 8192000000 10395290448 10724237312 1452782000 15.062 100 89 178 0 1490193568 7601120 29810448
17:00:09 21914 8192000000 10430023424 10761646080 1477182512 15.277 100 88 177 0 1513949424 8260944 28505968
17:00:42 16988 8192000000 10443688320 10782461952 1498721760 15.465 100 83 166 0 1533877840 8621984 26534096
17:01:09 21270 8192000000 10480303488 10819633152 1530218096 15.739 100 86 172 2 1566628000 9143952 27265952
17:01:38 14488 8192000000 10482245216 10830139392 1542308352 15.844 100 82 164 1 1577922096 9745536 25868208
17:02:00 15251 8192000000 10517561504 10867511296 1568797824 16.072 100 73 146 0 1600874224 9592640 22483760
17:02:31 14202 8192000000 10540262144 10898481152 1601833488 16.355 100 79 158 0 1636902576 10669088 24400000
17:02:53 9510 8192000000 10568232576 10926161920 1624927792 16.552 100 79 158 0 1659661792 10894384 23839616
17:03:11 9458 8192000000 10590733056 10956128256 1645901680 16.730 100 77 151 1 1679760608 11274480 22584448
17:03:27 10815 8192000000 10612614816 10976493568 1669831696 16.932 100 77 151 0 1703437312 11831664 21773952
17:03:54 8246 8192000000 10637238640 11004227584 1690317792 17.104 100 78 156 0 1725480160 12628768 22533600
17:04:09 6795 8192000000 10644519264 11016867840 1715995888 17.319 100 78 156 0 1750910400 12935024 21979488
17:04:22 7776 8192000000 10669519440 11044392960 1728294080 17.421 100 84 167 0 1765430912 13357312 23779520
17:04:37 5861 8192000000 10681903408 11055718400 1744840832 17.559 100 82 164 1 1781620736 13348528 23431376
17:04:50 5792 8192000000 10692040096 11065700352 1750436240 17.605 100 86 172 1 1789545040 14726512 24382288
17:05:06 4967 8192000000 10696227968 11072327680 1758180336 17.669 100 77 153 1 1793829760 14050448 21598976
17:05:18 4635 8192000000 10701859280 11083190272 1767853232 17.749 100 82 166 2 1805716736 14556848 23306656
17:05:29 5174 8192000000 10716272288 11095040000 1776543856 17.821 100 84 169 1 1814277904 14275824 23458224
17:05:42 3260 8192000000 10718784048 11098411008 1780691840 17.855 100 90 177 2 1820113248 15243456 24177952
17:05:53 3928 8192000000 10729334160 11110154240 1789607168 17.929 100 88 175 0 1828412256 14673552 24131536
17:06:04 3968 8192000000 10738706240 11119939584 1792738848 17.954 100 80 160 1 1829064272 14032224 22293200
17:06:15 2344 8192000000 10745703440 11126071296 1804428048 18.050 100 91 181 1 1843453344 13629968 25395328
17:06:24 6774 8192000000 10750826528 11133325312 1810187856 18.097 100 79 157 2 1845597920 13711024 21699040
17:06:38 4309 8192000000 10749051184 11141632000 1814504544 18.133 100 77 156 2 1849180896 13680896 20995456
17:06:49 2499 8192000000 10775796192 11159453696 1832956928 18.283 100 86 170 1 1869428624 12986592 23485104
17:06:59 1664 8192000000 10779862272 11166375936 1840191280 18.342 100 90 179 3 1879714384 14125488 25397616
17:07:07 1727 8192000000 10786845152 11174031360 1844997136 18.381 100 92 181 1 1884523280 13911536 25614608
17:07:15 1941 8192000000 10795179424 11179323392 1851040144 18.431 100 92 185 2 1890692896 14261728 25391024
17:07:23 2502 8192000000 10798216784 11188363264 1856074144 18.471 100 91 182 3 1895140272 14277424 24788704
17:07:32 2091 8192000000 10796413088 11190177792 1860325680 18.506 100 90 180 2 1899091616 13055584 25710352
17:07:41 1428 8192000000 10804080192 11195265024 1864949760 18.543 100 87 174 3 1901841488 12464848 24426880
17:07:49 2306 8192000000 10815862528 11206160384 1869708912 18.582 100 89 179 1 1905702592 11449872 24543808
17:07:58 1352 8192000000 10813926368 11205595136 1871422368 18.596 100 95 186 1 1910594368 12815088 26356912
17:08:06 2210 8192000000 10812137088 11207708672 1872655696 18.606 100 82 164 0 1908783392 12492096 23635600
17:08:14 8563 8192000000 10818880096 11211063296 1874688512 18.622 100 91 184 3 1914011392 12555456 26767424
17:08:29 1368 8192000000 10824813360 11213221888 1879836192 18.664 100 94 192 1 1919899888 12908704 27154992
17:08:38 13722 8192000000 10810260880 11210739712 1872320448 18.603 100 64 128 0 1901088944 11524816 17243680
17:09:06 5712 8192000000 10801607328 11210371072 1873342000 18.611 100 46 93 1 1894628208 8099552 13186656
17:09:18 8187 8192000000 10780793056 11206946816 1871374160 18.595 100 27 54 1 1886148800 7147840 7626800
17:09:33 5766 8192000000 10785485248 11213369344 1879281456 18.659 100 31 63 1 1895897120 7618208 8997456
17:09:48 13069 8192000000 10788939456 11214176256 1879302304 18.659 100 19 37 2 1890390448 6256128 4832016
17:10:08 6329 8192000000 10804325440 11222491136 1885402768 18.709 100 32 61 3 1900496656 6902880 8191008
17:10:23 7341 8192000000 10800378384 11223674880 1883995040 18.697 100 23 44 0 1896593520 6247488 6350992
17:10:38 8370 8192000000 10804281856 11224748032 1886059888 18.714 100 22 45 1 1897946272 6072112 5814272
17:10:56 14440 8192000000 10798612976 11228770304 1889277088 18.740 100 15 30 1 1899128640 5952928 3898624
17:11:16 13304 8192000000 10822616800 11246014464 1890907104 18.753 100 18 36 1 1909114080 13991472 4215504
17:11:36 13834 8192000000 10796116240 11232677888 1895494400 18.790 100 19 38 4 1907220240 6837856 4887984
17:12:05 57891 8192000000 10829292048 11253080064 1903858912 18.857 100 26 52 0 1916510848 5554816 7097120
17:13:15 14273 8192000000 10857567952 11260825600 1913017712 18.931 100 78 155 2 1942181200 7180704 21982784
17:13:36 6247 8192000000 10812634656 11251679232 1906405152 18.878 100 39 79 0 1925794752 8277360 11112240
17:13:49 8003 8192000000 10822788560 11253583872 1905161312 18.868 100 28 54 3 1919412848 6898608 7352928
17:14:06 4768 8192000000 10829600432 11262173184 1910939296 18.914 100 34 66 2 1931216800 11076608 9200896
17:14:23 11433 8192000000 10826254144 11261648896 1913188000 18.932 100 28 55 1 1926922640 6376736 7357904
17:14:42 7735 8192000000 10823901776 11262611456 1912689600 18.928 100 21 42 0 1924897872 6409392 5798880
17:14:56 10212 8192000000 10829310864 11265167360 1912801488 18.929 100 22 45 3 1924424928 5677888 5945552
17:15:13 5989 8192000000 10819693712 11262459904 1913523440 18.935 100 26 48 1 1926682848 5806336 7353072
17:15:25 6766 8192000000 10820386656 11254788096 1893696624 18.776 99 25 48 1 1906121296 5315408 7109264
17:15:40 8559 8192000000 10823376912 11262349312 1908977312 18.898 100 17 34 1 1919555264 5659584 4918368
17:16:01 63872 8192000000 10810888848 11241402368 1816322240 18.148 95 29 58 1 1830950560 5059808 9568512
17:17:13 12125 8192000000 10801262208 11222425600 1863681568 18.533 98 33 66 2 1879708912 6553392 9473952
17:17:32 7265 8192000000 10776709840 11196731392 1801796512 18.029 95 21 42 1 1813752016 5640624 6314880
17:17:46 6100 8192000000 10794109408 11223728128 1880071600 18.666 100 36 71 1 1897343264 7015040 10256624
17:17:59 5961 8192000000 10786978096 11205058560 1861727680 18.517 99 29 57 1 1876417552 6247008 8442864
17:18:15 6283 8192000000 10806445376 11225362432 1863793232 18.534 99 37 76 0 1885199648 10561696 10844720
17:18:27 5747 8192000000 10756340688 11178729472 1836257872 18.310 99 26 52 1 1849448448 6030864 7159712
17:18:41 6607 8192000000 10759074688 11187761152 1822633104 18.199 98 32 62 2 1838792240 6856128 9303008
17:18:55 4054 8192000000 10723627984 11137675264 1786046864 17.899 98 23 45 2 1798201856 5325568 6829424
17:19:05 4980 8192000000 10732613920 11152916480 1777380240 17.828 97 31 62 3 1792931648 6215504 9335904
17:19:16 9465 8192000000 10688285680 11111276544 1728391280 17.422 96 17 34 1 1739006544 5453296 5161968
17:19:32 8077 8192000000 10723620032 11149410304 1787103680 17.908 98 27 54 0 1801473552 6424016 7945856
17:19:51 8045 8192000000 10703634768 11117834240 1730609824 17.441 95 28 56 1 1744519536 5699104 8210608
17:20:05 10652 8192000000 10696485296 11112677376 1716429184 17.322 95 17 34 0 1726791776 5114864 5247728
17:20:25 63649 8192000000 10678918976 11103371264 1643249152 16.707 91 33 66 2 1658464192 4890720 10324320
17:21:35 13236 8192000000 10706738432 11122798592 1759665776 17.682 98 27 54 0 1773380704 6226096 7488832
17:21:55 5874 8192000000 10714907488 11126116352 1754053408 17.635 97 34 68 1 1773609216 10163264 9392544
17:22:07 7141 8192000000 10717607664 11138715648 1792531856 17.953 99 28 56 2 1807226400 5348624 9345920
17:22:21 6275 8192000000 10724436144 11135401984 1799026656 18.006 99 43 86 1 1817814064 7275552 11511856
17:22:37 5121 8192000000 10756468192 11169890304 1831066208 18.268 100 36 71 1 1847654608 6127152 10461248
17:22:50 7407 8192000000 10751962256 11180929024 1839797808 18.339 100 20 40 1 1851290192 5897712 5594672
17:23:04 9269 8192000000 10749294016 11182632960 1845240800 18.383 100 20 40 0 1857246288 5668112 6337376
17:23:20 6383 8192000000 10762105008 11189448704 1846903952 18.397 100 31 61 0 1862120320 5966480 9249888
17:23:36 15061 8192000000 10763426928 11197390848 1854084496 18.455 100 22 43 1 1866281248 6422880 5773872
17:24:00 11378 8192000000 10772097536 11205390336 1865873792 18.551 100 23 46 1 1877996176 5782384 6340000
17:24:18 10162 8192000000 10773866592 11212161024 1867730384 18.566 100 15 29 3 1877185136 5336112 4118640
17:24:36 5029 8192000000 10801694720 11229270016 1879677312 18.663 100 32 64 2 1898544720 10194928 8672480
17:24:51 8939 8192000000 10783735520 11223498752 1879190480 18.659 100 13 27 0 1888866112 5641696 4033936
17:25:07 15065 8192000000 10812339888 11235069952 1885179728 18.707 100 37 73 3 1901487696 5944048 10363920
17:25:28 68075 8192000000 10799017936 11235016704 1890695952 18.751 100 34 66 1 1907341584 5364784 11280848
17:26:45 10379 8192000000 10809000448 11241512960 1891841760 18.761 100 22 44 1 1903875040 6405312 5627968
17:27:06 4360 8192000000 10832567040 11260829696 1911644144 18.920 100 42 84 0 1930520272 7271600 11604528
17:27:19 7498 8192000000 10849249248 11272048640 1921442784 18.998 100 43 84 0 1939999408 6922000 11634624
17:27:40 15258 8192000000 10871845056 11290202112 1935697360 19.112 100 59 118 1 1961632336 8186048 17748928
17:28:05 29030 8192000000 10880174336 11301085184 1944369504 19.182 100 60 117 2 1971586720 10204800 17012416
17:28:52 10371 8192000000 10888473552 11311136768 1957469296 19.286 100 57 112 2 1983705328 10068304 16167728
17:29:17 8805 8192000000 10898317776 11321856000 1961421584 19.317 100 55 109 1 1988101984 10320944 16359456
17:29:35 18331 8192000000 10896074112 11330240512 1966158112 19.355 100 48 96 1 1990121344 10363840 13599392
17:30:13 36969 8192000000 10906253296 11344859136 1971702496 19.399 100 44 88 3 1997703520 12688912 13312112
17:30:59 37312 8192000000 10901614416 11343908864 1976215648 19.435 100 26 52 2 1998507088 14238064 8053376
17:31:55 42202 8192000000 10926698240 11360997376 1981160032 19.474 100 28 54 0 2010353104 20756336 8436736
17:32:48 19209 8192000000 10920695456 11360735232 1986346272 19.515 100 34 67 4 2013822304 16558928 10917104
17:33:13 27789 8192000000 10932544416 11369496576 1991700608 19.557 100 48 96 0 2025234032 18692240 14841184
17:33:49 15990 8192000000 10932649136 11375407104 1994918400 19.583 100 47 94 3 2028261328 19953296 13389632
17:34:29 12000 8192000000 10942932448 11380137984 2004719312 19.660 100 57 112 2 2038410352 16696544 16994496
17:34:50 3898 8192000000 10952099824 11383533568 2006645776 19.675 100 55 111 0 2039039936 16590992 15803168
17:35:00 3137 8192000000 10964124528 11390156800 2016273248 19.751 100 69 138 1 2055941552 18542080 21126224
17:35:12 5569 8192000000 10964426336 11389476864 2013193600 19.727 100 65 129 1 2052108240 19852112 19062528
17:35:24 2525 8192000000 10956808304 11384238080 2006242272 19.672 100 72 145 3 2047799696 19154720 22402704
17:35:38 8635 8192000000 10952827008 11379744768 1990064992 19.544 99 63 124 4 2030450064 22092208 18292864
17:35:54 3226 8192000000 10951403296 11383332864 2005363280 19.665 100 64 128 0 2046506624 22080256 19063088
17:36:05 3235 8192000000 10970741776 11392208896 2011162640 19.711 100 63 125 1 2050623664 21500976 17960048
17:36:17 4727 8192000000 10964452288 11393167360 2011885616 19.716 100 67 132 0 2053761488 22922016 18953856
17:36:33 13992 8192000000 10974269360 11405266944 2017518128 19.761 100 69 138 1 2063231088 24886160 20826800
17:36:56 6514 8192000000 10973227696 11398213632 2013305232 19.728 100 73 146 2 2061838016 26836464 21696320
17:37:17 4629 8192000000 10962652176 11387408384 1997955504 19.607 99 73 146 2 2049834592 29896048 21983040
17:37:29 3026 8192000000 10975480976 11396861952 2008973344 19.693 100 75 148 2 2057910000 26488672 22447984
17:37:40 4848 8192000000 10951688272 11378765824 1985749616 19.510 99 63 126 0 2029696992 25494144 18453232
17:37:51 9188 8192000000 10945940384 11374944256 1979309152 19.459 99 66 132 0 2025290528 26035088 19946288
17:38:10 10844 8192000000 10946854272 11372527616 1975013792 19.425 99 53 106 0 2014039536 23047760 15977984
17:38:28 27377 8192000000 10943236304 11375104000 1993117584 19.568 100 57 114 1 2030383152 20539456 16726112
17:39:04 12033 8192000000 10972564080 11395731456 2010847936 19.708 100 64 126 2 2051642400 21940064 18854400
17:39:25 10804 8192000000 10967512432 11401248768 2013699360 19.731 100 55 110 0 2054263840 24080944 16483536
17:39:53 3192 8192000000 10951944192 11385090048 1997065216 19.600 99 47 94 1 2032736256 21457616 14213424
17:40:03 1341 8192000000 10968675712 11391799296 2014482944 19.737 100 71 137 1 2057117856 21768432 20866480
17:40:13 4724 8192000000 10977085264 11403227136 2017459296 19.760 100 66 130 0 2059500336 22349248 19691792
17:40:29 9063 8192000000 10965828416 11394727936 1997889232 19.606 99 71 142 2 2043322944 24199744 21233968
17:40:45 4712 8192000000 10985221216 11408719872 2018778304 19.771 100 76 151 1 2064853184 24581040 21493840
17:40:58 2174 8192000000 10989039168 11411333120 2007390848 19.681 99 85 168 1 2059610336 26968928 25250560
17:41:08 4350 8192000000 10994106064 11414253568 2018675616 19.770 100 84 168 1 2071956848 28119904 25161328
17:41:21 3572 8192000000 10978040496 11389648896 1974672480 19.422 98 91 179 2 2029925120 28939056 26313584
17:41:34 3712 8192000000 10982389872 11399815168 2007378176 19.681 100 82 164 0 2062065248 30372816 24314256
17:41:45 5867 8192000000 10980110832 11407806464 2013360976 19.728 100 78 155 2 2066539888 30518544 22660368
17:41:57 3831 8192000000 10983783264 11407777792 2015297776 19.743 100 73 144 1 2066125712 29532016 21295920
17:42:09 5912 8192000000 10958047680 11388076032 1984627056 19.501 99 73 146 1 2036945472 30000432 22317984
17:42:23 7268 8192000000 10964790432 11390930944 1994540000 19.580 100 66 132 1 2045212240 30558672 20113568
17:42:50 1497 8192000000 10962033664 11382243328 1989587072 19.541 99 75 145 0 2044942816 33816096 21539648
17:42:59 3744 8192000000 10983330944 11402104832 2001566912 19.635 100 80 160 1 2063569776 36845376 25157488
17:43:12 3566 8192000000 10981924080 11406401536 2004598464 19.659 100 75 149 1 2066074512 38481872 22994176
17:43:23 3927 8192000000 10992228752 11413762048 2008331984 19.688 100 83 165 1 2074466720 40471744 25662992
17:43:37 2395 8192000000 10980425632 11400146944 1986771104 19.518 99 91 180 0 2056306896 41482832 28052960
17:43:48 5320 8192000000 10986272720 11406647296 2004523392 19.658 100 77 153 0 2068508496 40655248 23329856
17:44:01 4063 8192000000 10985540576 11412430848 2018615136 19.769 100 77 154 2 2079324512 37017808 23691568
17:44:13 3519 8192000000 10963598544 11384987648 1992364144 19.562 100 71 140 2 2045928624 30703408 22861072
17:44:23 2187 8192000000 10974056464 11389112320 1998767168 19.613 100 90 180 1 2057497296 32214832 26515296
17:44:33 2018 8192000000 10980281744 11389173760 1970121168 19.386 98 92 184 0 2032635216 34632368 27881680
17:44:42 2572 8192000000 10973880224 11388256256 1994632528 19.580 100 87 176 3 2056158192 34935952 26589712
17:44:51 1980 8192000000 10977282448 11387387904 1993609584 19.572 100 90 178 4 2056619904 35999616 27010704
17:45:01 2923 8192000000 10969981280 11375534080 1981014288 19.473 99 91 181 0 2047508400 37992576 28501536
17:45:11 5367 8192000000 10981042208 11397079040 1994536480 19.580 100 88 174 0 2059723776 37778032 27409264
17:45:24 2747 8192000000 11000638832 11411496960 2009937328 19.701 100 90 180 0 2077396912 39777584 27682000
17:45:34 4000 8192000000 10989252288 11412353024 2009169360 19.695 100 73 145 1 2072908240 40573296 23165584
17:45:44 2789 8192000000 10952602896 11370373120 1945574144 19.191 97 74 147 2 2009236816 40019568 23643104
17:45:54 1816 8192000000 10943964464 11365855232 1952575808 19.247 99 72 141 0 2015412800 40046528 22790464
17:46:04 6660 8192000000 10924782304 11362504704 1954174208 19.260 99 55 110 0 2009796240 38020176 17601856
17:46:24 3446 8192000000 10917188176 11324178432 1935033968 19.107 98 72 143 2 1991677152 34875616 21767568
17:46:36 4055 8192000000 10951535216 11370778624 1973198096 19.411 100 74 147 0 2033015968 37272384 22545488
17:46:49 14526 8192000000 10905350800 11342135296 1911045056 18.915 98 45 90 3 1966019760 40463616 14511088
17:47:40 5973 8192000000 10933535120 11359842304 1943328672 19.173 99 56 111 2 2005521984 42732800 19460512
17:47:53 2179 8192000000 10946558656 11351408640 1948611040 19.215 99 67 134 1 2012440208 42063424 21765744
17:48:01 3948 8192000000 10954418048 11370995712 1962858576 19.329 100 82 162 1 2030245440 42035328 25351536
17:48:12 2575 8192000000 10964774384 11386261504 1975435392 19.429 100 82 164 0 2048218464 46544816 26238256
17:48:22 5551 8192000000 10929813488 11345608704 1933855904 19.098 98 66 132 0 1993352800 37954160 21542736
17:48:36 6373 8192000000 10934989472 11366641664 1963184944 19.331 100 54 108 0 2021235696 40007392 18043360
17:49:01 10343 8192000000 10940966688 11377065984 1969949712 19.385 100 46 92 0 2027038384 41117376 15971296
17:49:22 2881 8192000000 10938792768 11361185792 1953465328 19.254 99 59 112 2 2011151872 39052112 18634432
17:49:32 4078 8192000000 10970485120 11384131584 1975214704 19.427 100 63 126 0 2037197696 41143312 20839680
17:49:46 3826 8192000000 10960117616 11388403712 1984128800 19.497 100 60 121 2 2045625760 41242448 20254512
17:49:57 6390 8192000000 10958492288 11386609664 1982485248 19.484 100 54 108 2 2041106016 41640176 16980592
17:50:12 8487 8192000000 10955594816 11390279680 1979419984 19.460 100 47 94 2 2037267504 42461488 15386032
17:50:33 12865 8192000000 10937187552 11373780992 1969878400 19.384 100 40 80 2 2021522896 37554592 14089904
17:50:58 18153 8192000000 10933765904 11377610752 1973399360 19.412 100 32 64 1 2019985168 35634032 10951776
17:51:29 17304 8192000000 10945161472 11392733184 1981160528 19.474 100 41 81 0 2032435424 38226480 13048416
17:52:25 20700 8192000000 10935312560 11385180160 1964357760 19.341 100 28 56 0 2015916832 41821024 9738048
17:52:54 34307 8192000000 10917700000 11357814784 1918327808 18.973 98 26 52 0 1974865872 46348160 10189904
17:53:50 25573 8192000000 10887828688 11351351296 1895564128 18.791 98 20 40 0 1954232496 50485664 8182704
17:54:29 44603 8192000000 10876980464 11361902592 1925865456 19.034 100 13 26 1 1978386432 47490912 5030064
17:55:20 52234 8192000000 10854119984 11304169472 1858560528 18.492 96 19 36 2 1874957072 11676976 4719568
17:56:18 60851 8192000000 10857366256 11310575616 1895507056 18.790 99 8 15 0 1911906112 14004176 2394880
17:57:37 73316 8192000000 10877364512 11322630144 1928111744 19.052 99 31 61 1 1944939808 8916384 7911680
17:58:58 48280 8192000000 10853865056 11291766784 1825058928 18.219 94 14 28 0 1836894464 8152352 3683184
17:59:53 69707 8192000000 10878620576 11317620736 1914897888 18.946 99 29 58 1 1932608176 10184544 7525744
18:01:10 79605 8192000000 10896407632 11346505728 1947610240 19.207 100 33 66 2 1974462112 17483232 9368640
18:02:53 93914 8192000000 10869503056 11333824512 1933876112 19.098 99 37 71 2 1956473472 10571360 12026000
18:04:38 77596 8192000000 10868219776 11326545920 1932809984 19.089 99 23 46 2 1948022992 8923648 6289360
18:06:02 41280 8192000000 10894101952 11347726336 1957891936 19.289 100 27 54 1 1978352128 12872256 7587936
18:06:55 27986 8192000000 10883570368 11348094976 1958878016 19.297 100 13 26 0 1976138656 13606512 3654128
18:07:30 19410 8192000000 10918162032 11352494080 1967917296 19.369 100 52 98 3 1992358064 9799456 14641312
18:07:57 20147 8192000000 10896959360 11358253056 1970737840 19.391 100 30 60 2 1990536064 10656704 9141520
18:08:24 23926 8192000000 10902584320 11365941248 1977903264 19.448 100 49 98 2 2005416528 11874912 15638352
18:08:58 58247 8192000000 10894959232 11367555072 1957786064 19.288 99 13 26 0 1973352656 11381440 4185152
18:10:03 43480 8192000000 10885118768 11357794304 1950418400 19.230 99 13 26 1 1967189968 12941264 3830304
18:11:03 26897 8192000000 10883009920 11356442624 1965413168 19.349 100 8 16 0 1975737072 8058416 2265488
18:11:36 57576 8192000000 10898026352 11373637632 1954638272 19.263 99 11 22 1 1967844800 10315312 2891216
18:12:44 74084 8192000000 10898517136 11360067584 1952747248 19.248 99 19 38 1 1969522336 10935952 5839136
18:14:04 88012 8192000000 10893593248 11367370752 1964405600 19.341 100 23 46 0 1991891040 20255488 7229952
18:15:45 75786 8192000000 10872932832 11348758528 1947060240 19.203 99 20 40 0 1962606912 10237696 5308976
18:17:32 46852 8192000000 10887733152 11356385280 1969501552 19.381 100 28 56 2 1985047744 7540976 8005216
18:18:31 56500 8192000000 10897425536 11377373184 1975701696 19.431 100 15 30 0 1992688640 13229968 3756976
18:19:38 56453 8192000000 10885031168 11365933056 1967808512 19.368 100 9 18 0 1984926320 14462912 2654896
18:20:54 56138 8192000000 10878697072 11364225024 1949398080 19.222 99 8 16 0 1961190560 9905440 1887040
18:21:56 57239 8192000000 10891980848 11351597056 1952428192 19.246 99 14 28 1 1964344400 7835856 4080352
18:23:01 23211 8192000000 10904045600 11359952896 1938020608 19.131 98 44 88 0 1961967536 11590272 12356656
18:23:32 14649 8192000000 10895514048 11351539712 1952130656 19.243 99 43 87 0 1977135152 12963264 12041232
18:23:54 32050 8192000000 10880963968 11352551424 1943458736 19.174 99 14 28 1 1956531520 9112496 3960288
18:24:32 20533 8192000000 10886320496 11344969728 1926932192 19.042 98 20 40 0 1940205664 7609344 5664128
18:25:06 64869 8192000000 10878215024 11340816384 1915152768 18.948 98 27 53 1 1932395760 9393328 7849664
18:26:22 99344 8192000000 10867588192 11337891840 1881557904 18.678 96 14 28 0 1895952192 10871376 3522912
18:28:08 49634 8192000000 10897084656 11348578304 1919862272 18.986 98 19 36 0 1935933600 11189568 4881760
18:29:04 37948 8192000000 10877891200 11344711680 1899289056 18.821 97 32 62 0 1921978240 14188352 8500832
18:29:50 32542 8192000000 10870215696 11339493376 1926470384 19.039 99 17 34 1 1938738720 7936480 4331856
18:30:33 41433 8192000000 10867530752 11334672384 1887811712 18.728 97 18 36 1 1902138944 9284000 5043232
18:31:21 57157 8192000000 10861586544 11320799232 1817922576 18.161 93 29 58 0 1838479936 12845888 7711472
18:32:36 55311 8192000000 10878439392 11350790144 1906671728 18.880 98 13 24 1 1936896112 26304672 3919712
18:33:38 71970 8192000000 10865417808 11326484480 1865025120 18.544 96 22 44 0 1891349104 19872192 6451792
18:35:00 27867 8192000000 10867185280 11314606080 1901025616 18.835 98 22 44 0 1917996432 10932464 6038352
18:35:34 95231 8192000000 10839635440 11315789824 1906607392 18.879 99 21 42 1 1924647808 11955136 6085280
18:37:16 43136 8192000000 10838121664 11297189888 1883481200 18.693 97 23 45 0 1899629728 10046912 6101616
18:38:08 20257 8192000000 10883730688 11329105920 1942426880 19.166 100 46 90 0 1961163504 6564720 12171904
18:38:35 5395 8192000000 10872239584 11315789824 1932296800 19.085 100 56 112 0 1957924352 9570976 16056576
18:38:48 30046 8192000000 10852382560 11332075520 1944785392 19.185 100 67 133 3 1973095024 10407024 17902608
18:41:24 53842 8192000000 10866743760 11328598016 1901577456 18.839 98 14 28 0 1920325904 14176144 4572304
18:42:29 101323 8192000000 10870766832 11330650112 1909293136 18.901 98 23 47 3 1929727216 13722672 6711408
18:44:30 79636 8192000000 10844289504 11313397760 1883686816 18.695 97 12 25 0 1906638032 18898608 4052608
18:45:59 46733 8192000000 10824006576 11282440192 1824337136 18.213 95 15 30 1 1842296192 13573712 4385344
18:46:54 28976 8192000000 10881064512 11319132160 1923626032 19.016 100 38 76 1 1943144112 8695440 10822640
18:47:32 35921 8192000000 10863050976 11327295488 1894528656 18.782 98 33 66 1 1918451696 15130000 8793040
18:48:16 39133 8192000000 10835397520 11296243712 1872424432 18.604 98 25 50 1 1890900272 11143152 7332688
18:49:05 39793 8192000000 10850615152 11308240896 1877054080 18.641 98 15 30 0 1894004688 12776960 4173648
18:49:53 64043 8192000000 10860291472 11314630656 1901116512 18.835 99 20 40 0 1918530912 12180096 5234304
18:51:07 79366 8192000000 10859432464 11325341696 1899637568 18.823 98 30 60 1 1923375632 15369232 8368832
18:52:41 38642 8192000000 10878921680 11330994176 1900490976 18.830 98 32 64 2 1920345488 10252480 9602032
18:53:26 27712 8192000000 10888932080 11349757952 1941527088 19.159 100 34 68 1 1962531248 12017376 8986784
18:54:05 30340 8192000000 10889068512 11349516288 1948534416 19.215 100 31 62 1 1970355936 13229680 8591840
18:54:43 35597 8192000000 10901845632 11359375360 1959815920 19.305 100 35 70 2 1982171424 12928224 9427280
18:55:30 66330 8192000000 10896330576 11374149632 1963197376 19.331 100 18 36 1 1986537296 18133696 5206224
18:56:44 101400 8192000000 10899393200 11380670464 1965920400 19.353 100 7 14 0 1986792304 19362272 1509632
18:58:32 91758 8192000000 10891684896 11371032576 1955387152 19.269 99 12 24 1 1968699920 10463248 2849520
19:00:14 37568 8192000000 10890690832 11380854784 1973762448 19.415 100 4 8 0 1985654480 11200976 691056
19:01:06 6453 8192000000 10890105680 11381837824 1975225872 19.427 100 2 4 0 1986432160 11081664 124624
19:01:19 250 8192000000 10891717600 11382239232 1976519248 19.437 100 3 6 0 1988136608 11210368 406992
19:01:26 10336 8192000000 10887646752 11376111616 1956535824 19.278 99 3 6 0 1967419296 10531936 351536
19:01:57 14963 8192000000 10893986112 11378716672 1976714560 19.439 100 6 12 0 1987579408 9414096 1450752
19:02:18 57737 8192000000 10898741856 11378589696 1943934080 19.178 98 9 17 1 1953182560 7185232 2063248
19:04:04 69839 8192000000 10894414800 11369881600 1920313968 18.989 97 15 30 0 1943675616 18799184 4562464
19:06:02 49773 8192000000 10907226768 11362181120 1922221840 19.005 97 20 41 1 1940812160 12698016 5892304
19:06:58 66855 8192000000 10899812768 11380846592 1969576192 19.382 100 15 30 0 1982735536 9074112 4085232
19:08:13 65223 8192000000 10889558336 11367751680 1921126880 18.996 97 12 24 1 1935919312 11853008 2939424
19:09:25 36507 8192000000 10940782112 11386310656 1977019520 19.441 100 40 80 1 2004849376 15859392 11970464
19:10:21 53019 8192000000 10904112016 11383664640 1944662192 19.184 98 24 49 0 1966225648 14931264 6632192
19:11:20 21578 8192000000 10910693840 11364990976 1919811056 18.985 97 40 81 0 1942996416 12187680 10997680
19:11:52 19716 8192000000 10905363824 11346542592 1928471360 19.055 98 44 88 0 1950856032 10249680 12134992
19:12:22 26014 8192000000 10906711216 11367903232 1964344544 19.341 100 45 90 2 1990055072 12801696 12908832
19:13:05 53794 8192000000 10895222160 11354644480 1924014416 19.019 98 28 56 1 1948467552 16592304 7860832
19:14:09 62940 8192000000 10877389232 11347288064 1919555520 18.983 98 16 32 0 1936830304 12962624 4312160
19:15:28 10576 8192000000 10894410608 11344265216 1937654576 19.128 99 50 98 4 1960071888 7344400 15072912
19:15:51 89764 8192000000 10892433008 11349778432 1923483120 19.015 98 15 30 0 1938166960 10524304 4159536
19:17:27 28659 8192000000 10900102416 11356094464 1931271536 19.077 98 33 66 1 1953701648 12746304 9683808
19:18:09 43683 8192000000 10895694144 11363147776 1933700064 19.096 99 31 61 1 1959709792 16887488 9122240
19:18:59 67074 8192000000 10888944352 11369877504 1958890976 19.297 100 11 23 0 1976287312 14333616 3062720
19:20:13 36857 8192000000 10866147168 11333558272 1878969808 18.657 96 12 24 1 1890880912 8338944 3572160
19:20:56 42936 8192000000 10842991120 11303702528 1834656528 18.297 94 26 50 1 1848553216 7262128 6634560
19:21:50 26291 8192000000 10827145264 11291107328 1885952528 18.713 99 26 52 1 1902014896 8861904 7200464
19:22:24 2653 8192000000 10844612576 11291693056 1876127504 18.634 98 48 95 0 1897505312 8092080 13285728
19:22:33 6980 8192000000 10838857264 11300704256 1911403120 18.918 100 28 56 0 1928190624 9076816 7710688
19:22:53 65700 8192000000 10833247488 11315654656 1918065696 18.971 100 17 34 1 1932228208 8796784 5365728
19:24:05 41457 8192000000 10847128448 11327623168 1929107264 19.060 100 8 15 1 1940399888 9376640 1915984
19:24:53 41514 8192000000 10827754256 11300204544 1835357456 18.303 95 12 24 0 1846486672 7788032 3341184
19:25:40 58339 8192000000 10832874560 11305533440 1892584448 18.767 98 13 26 2 1909470096 13116784 3768864
19:26:46 72668 8192000000 9844039984 10214117376 977712080 10.662 51 6 10 0 988664768 9330096 1622592

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 22-02-2021 19:30:09 to 22-02-2021 19:30:42.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 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 22-02-2021 19:30:43 to 22-02-2021 19:30:45.

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          243587
MON$OLDEST_ACTIVE               243588
MON$OLDEST_SNAPSHOT             243588
MON$NEXT_TRANSACTION            243588
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                       2028448
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:147: 
:148: mscs-test-161.budzdorov.ru    Mon Feb 22 19:28:13 2021
:149:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:150: 
:151: 
:152: mscs-test-161.budzdorov.ru    Mon Feb 22 19:28:20 2021
:153:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:154: 
--- end of diff output ---

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

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