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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-15 22:27:09
DTS_END                         2021-01-15 22:27:09.0040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40562
TRN_ID                          239689
ATT_ID                          675
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: 9220.60 25613 1106472
customer order: creation 170.70 391 20484
customer order: refuse 15.03 360 1803
order to supplier: creation 45.07 1262 5408
order to supplier: removal 3.49 122056 419
invoice (draft): creation 45.83 3377 5500
invoice (draft): removal 54.45 949 6534
invoice accept: apply 40.28 19635 4834
invoice accept: cancel 48.67 857 5840
customer reserve: creation 3757.69 192 450923
customer reserve: removal 4745.15 70 569418
realization accept: apply 82.34 193 9881
realization accept: cancel 83.08 127 9969
payment from customer: creation 58.14 150 6977
payment from customer: removal 5.85 87 702
payment to supplier: creation 48.68 156 5841
payment to supplier: removal 3.46 105 415
service: total inventory turnovers 4.84 1142 581
service: total monetary turnovers 6.93 36 831
service: aggregate perf. data 0.90 15665 108
service: refresh index statistics 0.03 345441 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-01-2021 22:28:40 to 15-01-2021 22:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5647
TEST_TIME 2 3221
TEST_TIME 3 2769
TEST_TIME 4 4136
TEST_TIME 5 4294
TEST_TIME 6 4789
TEST_TIME 7 4833
TEST_TIME 8 5186
TEST_TIME 9 5370
TEST_TIME 10 5276
TEST_TIME 11 5474
TEST_TIME 12 5532
TEST_TIME 13 5924
TEST_TIME 14 6088
TEST_TIME 15 6144
TEST_TIME 16 6550
TEST_TIME 17 6695
TEST_TIME 18 6800
TEST_TIME 19 6991
TEST_TIME 20 7121
TEST_TIME 21 8044
TEST_TIME 22 8374
TEST_TIME 23 8537
TEST_TIME 24 8554
TEST_TIME 25 8702
TEST_TIME 26 8983
TEST_TIME 27 9437
TEST_TIME 28 11295
TEST_TIME 29 11245
TEST_TIME 30 11084
TEST_TIME 31 11048
TEST_TIME 32 11162
TEST_TIME 33 10907
TEST_TIME 34 10876
TEST_TIME 35 10856
TEST_TIME 36 10835
TEST_TIME 37 10634
TEST_TIME 38 10633
TEST_TIME 39 10612
TEST_TIME 40 10444
TEST_TIME 41 10432
TEST_TIME 42 10348
TEST_TIME 43 10364
TEST_TIME 44 10567
TEST_TIME 45 10437
TEST_TIME 46 10342
TEST_TIME 47 10219
TEST_TIME 48 10149
TEST_TIME 49 10065
TEST_TIME 50 10022
TEST_TIME 51 9943
TEST_TIME 52 9892
TEST_TIME 53 9808
TEST_TIME 54 9783
TEST_TIME 55 9748
TEST_TIME 56 9742
TEST_TIME 57 9696
TEST_TIME 58 9686
TEST_TIME 59 9824
TEST_TIME 60 9793
TEST_TIME 61 9772
TEST_TIME 62 9866
TEST_TIME 63 9836
TEST_TIME 64 9810
TEST_TIME 65 9883
TEST_TIME 66 9836
TEST_TIME 67 9813
TEST_TIME 68 10000
TEST_TIME 69 9940
TEST_TIME 70 9812
TEST_TIME 71 9772
TEST_TIME 72 9715
TEST_TIME 73 9668
TEST_TIME 74 9612
TEST_TIME 75 9586
TEST_TIME 76 9509
TEST_TIME 77 9521
TEST_TIME 78 9543
TEST_TIME 79 9632
TEST_TIME 80 9622
TEST_TIME 81 9619
TEST_TIME 82 9650
TEST_TIME 83 9712
TEST_TIME 84 9684
TEST_TIME 85 9693
TEST_TIME 86 9674
TEST_TIME 87 9659
TEST_TIME 88 9644
TEST_TIME 89 9693
TEST_TIME 90 9633
TEST_TIME 91 9565
TEST_TIME 92 9560
TEST_TIME 93 9487
TEST_TIME 94 9459
TEST_TIME 95 9455
TEST_TIME 96 9417
TEST_TIME 97 9471
TEST_TIME 98 9447
TEST_TIME 99 9533
TEST_TIME 100 9511
TEST_TIME 101 9504
TEST_TIME 102 9492
TEST_TIME 103 9502
TEST_TIME 104 9491
TEST_TIME 105 9480
TEST_TIME 106 9484
TEST_TIME 107 9536
TEST_TIME 108 9539
TEST_TIME 109 9556
TEST_TIME 110 9521
TEST_TIME 111 9457
TEST_TIME 112 9407
TEST_TIME 113 9409
TEST_TIME 114 9379
TEST_TIME 115 9353
TEST_TIME 116 9299
TEST_TIME 117 9271
TEST_TIME 118 9285
TEST_TIME 119 9293
TEST_TIME 120 9222

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 15-01-2021 22:28:44 to 15-01-2021 22:28:47.

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 1524424 1524424 0 0.00 0 29180 7 0 0
doc_list_biud 1524423 1524423 0 0.00 0 34071 33 0 0
sp_add_invoice_to_stock 5025 4834 191 3.80 37 200955 19636 0 191
sp_cancel_adding_invoice 5840 5840 0 0.00 4 77719 857 0 0
sp_cancel_client_order 1803 1803 0 0.00 4 26076 360 0 0
sp_cancel_customer_reserve 569418 569418 0 0.00 1 29856 70 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 3 10716 87 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 2 9043 105 0 0
sp_cancel_supplier_invoice 6543 6534 9 0.13 2 28247 950 0 9
sp_cancel_supplier_order 419 419 0 0.00 5 1208056 122056 0 0
sp_cancel_write_off 9969 9969 0 0.00 1 34128 128 0 0
sp_client_order 20484 20484 0 0.00 4 35939 391 0 0
sp_customer_reserve 450923 450923 0 0.00 0 165058 192 0 0
sp_fill_shopping_cart 31380 31380 0 0.00 1 10524 36 0 0
sp_fill_shopping_cart_clo_res 450919 450919 0 0.00 0 24654 15 0 0
sp_get_clo_for_invoice 4829 4829 0 0.00 0 29080 330 0 0
sp_kill_cost_storno 16926 16926 0 0.00 0 26942 67 0 0
sp_kill_qstorno_ret_qs2qd 1155758 1155758 0 0.00 0 34070 38 0 0
sp_kill_qty_storno 608692 608692 0 0.00 0 34071 81 0 0
sp_lock_selected_doc 20578 20578 0 0.00 0 13140 5 0 0
sp_make_cost_storno 27527 27527 0 0.00 0 26181 67 0 0
sp_multiply_rows_for_pdistr 27527 27527 0 0.00 0 7798 30 0 0
sp_multiply_rows_for_qdistr 20484 20484 0 0.00 0 20516 192 0 0
sp_pay_from_customer 6977 6977 0 0.00 4 36167 150 0 0
sp_pay_to_supplier 5841 5841 0 0.00 5 25515 157 0 0
sp_payment_common 12818 12818 0 0.00 1 11079 26 0 0
sp_qd_handle_on_cancel_clo 1803 1803 0 0.00 0 26070 325 0 0
sp_qd_handle_on_invoice_upd_sts 10668 10668 0 0.00 0 24009 356 0 0
sp_qd_handle_on_reserve_upd_sts 9881 9881 0 0.00 0 15954 57 0 0
sp_reserve_write_off 9881 9881 0 0.00 6 24696 194 0 0
sp_supplier_invoice 5500 5500 0 0.00 6 122277 3377 0 0
sp_supplier_order 5408 5408 0 0.00 5 39447 1263 0 0
srv_aggregate_perf_data 108 108 0 0.00 2530 167308 15665 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1310 206333 29499 0 0
srv_find_qd_qs_mism 1059598 1059598 0 0.00 0 29179 6 0 0
srv_make_invnt_saldo 581 581 0 0.00 46 75635 1142 0 0
srv_make_money_saldo 831 831 0 0.00 1 5047 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 200702 498722 345442 0 0
t$perf-abend:sp_add_invoice_to_stock 191 191 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4834 4834 0 0.00 0 34798 167 0 0
t$perf-norm:sp_cancel_adding_invoice 401 401 0 0.00 0 4330 110 0 0
t$perf-norm:sp_cancel_client_order 1803 1803 0 0.00 0 8802 26 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 1800 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 2420 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1162 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 406 406 0 0.00 0 1321 17 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 24366 1620 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 1405 10 0 0
t$perf-norm:sp_client_order 20484 20484 0 0.00 0 8956 18 0 0
t$perf-norm:sp_customer_reserve 971 971 0 0.00 0 680 5 0 0
t$perf-norm:sp_pay_from_customer 6977 6977 0 0.00 0 4191 8 0 0
t$perf-norm:sp_pay_to_supplier 5841 5841 0 0.00 0 5881 9 0 0
t$perf-norm:sp_reserve_write_off 9881 9881 0 0.00 0 5594 11 0 0
t$perf-norm:sp_supplier_invoice 5500 5500 0 0.00 0 8322 18 0 0
t$perf-norm:sp_supplier_order 5408 5408 0 0.00 0 3918 15 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 495 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 4202 55 0 0
t$perf-norm:srv_make_invnt_saldo 581 581 0 0.00 0 859 24 0 0
t$perf-norm:srv_make_money_saldo 831 831 0 0.00 0 3870 22 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 14 5 0 0
v_add_invoice_to_stock 10038 9656 382 3.80 0 28024 24 0 382
v_all_customers 37656 37656 0 0.00 0 38 1 0 0
v_all_suppliers 30442 30442 0 0.00 0 96 1 0 0
v_all_wares 40968 40968 0 0.00 0 295 1 0 0
v_cancel_adding_invoice 802 802 0 0.00 0 2107 9 0 0
v_cancel_client_order 3606 3606 0 0.00 0 4988 7 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 10628 14 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 2962 10 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 6262 19 0 0
v_cancel_supplier_invoice 830 812 18 2.16 0 2332 20 0 18
v_cancel_supplier_order 838 838 0 0.00 0 3359 13 0 0
v_cancel_write_off 2048 2048 0 0.00 0 1626 12 0 0
v_max_id_clo_ord 5407 5407 0 0.00 0 185 1 0 0
v_max_id_clo_res 971 971 0 0.00 0 4991 15 0 0
v_max_id_ord_sup 5488 5488 0 0.00 0 7095 6 0 0
v_max_non_paid_invoice 1515 1515 0 0.00 0 5327 10 0 0
v_max_non_paid_realizn 3616 3616 0 0.00 0 2588 4 0 0
v_min_id_clo_ord 5407 5407 0 0.00 0 1346 5 0 0
v_min_id_clo_res 971 971 0 0.00 0 6165 19 0 0
v_min_id_ord_sup 5488 5488 0 0.00 0 5296 5 0 0
v_min_non_paid_invoice 5841 5841 0 0.00 0 5346 15 0 0
v_min_non_paid_realizn 6977 6977 0 0.00 0 5762 12 0 0
v_our_firm 10034 10034 0 0.00 0 15 1 0 0
v_reserve_write_off 19762 19762 0 0.00 0 24294 10 0 0
x_lock_depdocs_on_canc_invoice 11968 11968 0 0.00 0 19917 138 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 4630 363 0 0
x_make_qstorno_1000_1200 5408 5408 0 0.00 2 39436 1185 0 0
x_make_qstorno_1200_2000 5500 5500 0 0.00 3 122257 3250 0 0
x_make_qstorno_2100_3300 450923 450923 0 0.00 0 165056 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-01-2021 22:28:48 to 15-01-2021 22:28:52.

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:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:18 18265 8192000000 10250710928 10555330560 850295264 9.403 68 49 98 1 868926976 2296912 16334800
19:57:47 24489 8192000000 10326001808 10640609280 1379527024 14.412 100 91 181 0 1414143808 5006096 29610688
19:58:23 29193 8192000000 10354264272 10673324032 1405525088 14.644 100 87 174 0 1441137840 6515136 29097616
19:58:59 20014 8192000000 10366602048 10692083712 1423537872 14.804 100 89 178 0 1460849936 7136928 30175136
19:59:28 26524 8192000000 10396165552 10724552704 1450039952 15.038 100 86 172 0 1486180192 7626720 28513520
20:00:03 19551 8192000000 10414564720 10747195392 1472567008 15.236 100 86 172 0 1509034144 8219776 28247360
20:00:31 22083 8192000000 10434781056 10765873152 1483187216 15.329 100 84 168 1 1519476608 8876736 27412656
20:01:03 19087 8192000000 10442886528 10780827648 1499382384 15.471 100 83 166 0 1535662208 9232672 27047152
20:01:38 21026 8192000000 10500144384 10842542080 1543803776 15.856 100 85 170 0 1579994544 9510080 26680688
20:02:07 14436 8192000000 10517228048 10869522432 1573039088 16.108 100 81 160 2 1607856048 10237696 24579264
20:02:28 12700 8192000000 10540596656 10897063936 1604796656 16.380 100 81 160 1 1640186416 11001472 24388288
20:02:48 11547 8192000000 10559021840 10918088704 1623460480 16.539 100 81 162 0 1659002944 11146880 24395584
20:03:14 8374 8192000000 10580357792 10945499136 1642730688 16.703 100 78 155 1 1681345056 16143552 22470816
20:03:39 8184 8192000000 10622625376 10989236224 1680841648 17.024 100 84 167 2 1717878608 12188864 24848096
20:03:59 8957 8192000000 10633963920 11005317120 1692348384 17.121 100 76 152 3 1727693968 13018496 22327088
20:04:18 8295 8192000000 10663533184 11034222592 1715808144 17.317 100 80 159 3 1755970576 16875536 23286896
20:04:35 6020 8192000000 10665150944 11042213888 1735565232 17.482 100 82 163 2 1771216016 12460800 23189984
20:04:49 5512 8192000000 10683812880 11062099968 1745453200 17.564 100 83 167 2 1781896240 12759424 23683616
20:05:01 5173 8192000000 10696821264 11073929216 1758314640 17.670 100 85 169 1 1800693328 18113776 24264912
20:05:14 5411 8192000000 10711448704 11088506880 1769020224 17.759 100 85 168 1 1807163760 13967296 24176240
20:05:27 4140 8192000000 10711645840 11095142400 1776726032 17.822 100 81 162 0 1813694336 14116016 22852288
20:05:37 2948 8192000000 10724506080 11107667968 1784379552 17.886 100 80 160 1 1821072144 13852288 22840304
20:05:47 4123 8192000000 10726538064 11108823040 1794372912 17.968 100 85 170 0 1831484800 13128672 23983216
20:05:57 3447 8192000000 10744687424 11124965376 1800861488 18.021 100 83 166 0 1837930752 13389872 23679392
20:06:08 1785 8192000000 10740291584 11123691520 1805236128 18.057 100 87 171 0 1842028080 12467328 24324624
20:06:17 3846 8192000000 10752310880 11133435904 1809435872 18.091 100 83 163 3 1844975680 12269680 23270128
20:06:33 5944 8192000000 10750817664 11140304896 1812538240 18.117 100 81 162 1 1847853872 12999728 22315904
20:06:45 3359 8192000000 10772347712 11161862144 1833158128 18.285 100 89 175 0 1872516832 14147952 25210752
20:06:55 2541 8192000000 10776566320 11165757440 1836725168 18.314 100 82 162 2 1873669952 14061696 22883088
20:07:05 1957 8192000000 10792073952 11174342656 1842622656 18.362 100 94 190 2 1883105520 14134960 26347904
20:07:13 2374 8192000000 10793740384 11181682688 1850495376 18.426 100 92 182 0 1890074160 13709728 25869056
20:07:22 2565 8192000000 10803958416 11188310016 1859260448 18.497 100 93 186 0 1900660624 15111280 26288896
20:07:31 2386 8192000000 10804309040 11196915712 1861616640 18.516 100 90 181 0 1901393696 14014272 25762784
20:07:40 1745 8192000000 10812995168 11201564672 1870619520 18.589 100 90 183 1 1907672576 11515648 25537408
20:07:48 2450 8192000000 10818903232 11204403200 1872838016 18.607 100 89 181 0 1910400192 11796064 25766112
20:07:56 2265 8192000000 10818723152 11210162176 1878799184 18.655 100 96 191 2 1919422928 13375392 27248352
20:08:05 2146 8192000000 10821661888 11209826304 1874572928 18.621 100 88 174 1 1912769216 13263552 24932736
20:08:14 1631 8192000000 10822605808 11212750848 1880815312 18.672 100 94 188 0 1920248608 13130480 26302816
20:08:21 1808 8192000000 10826499856 11214483456 1883398144 18.693 100 96 187 2 1922699328 11987376 27313808
20:08:29 47564 8192000000 10801937920 11202310144 1870993264 18.592 100 53 107 2 1894079152 8634320 14451568
20:09:24 1309 8192000000 10826684288 11217506304 1883252320 18.691 100 89 176 1 1919250880 10260704 25737856
20:09:31 1521 8192000000 10821008656 11218235392 1881331008 18.676 100 82 162 1 1916547696 11321504 23895184
20:09:40 1727 8192000000 10823317008 11221991424 1884385328 18.701 100 86 172 0 1919830160 11640176 23804656
20:09:48 5751 8192000000 10799371312 11215151104 1881339776 18.676 100 58 114 1 1909527424 12765712 15421936
20:10:01 7572 8192000000 10786050864 11210588160 1875020736 18.625 100 37 74 1 1893051216 8342784 9687696
20:10:18 2722 8192000000 10811244544 11224182784 1880472208 18.669 100 49 98 4 1903440640 9754080 13214352
20:10:27 5313 8192000000 10796039776 11215683584 1880467952 18.669 100 49 98 2 1904221968 9771872 13982144
20:10:40 4003 8192000000 10802273792 11219304448 1885769152 18.712 100 52 105 3 1911982128 11400944 14812032
20:10:53 4603 8192000000 10814835552 11226505216 1884476816 18.701 100 39 77 1 1903029776 7937904 10615056
20:11:07 4880 8192000000 10781741024 11218145280 1882534400 18.686 100 30 58 2 1898247840 7235024 8478416
20:11:18 5711 8192000000 10811949152 11224993792 1886907424 18.721 100 37 76 2 1902934912 5256752 10770736
20:11:30 4703 8192000000 10791820176 11219628032 1884042464 18.698 100 20 40 2 1895923600 6248272 5632864
20:11:43 7583 8192000000 10804308912 11230318592 1887261040 18.724 100 27 56 1 1906941440 11429824 8250576
20:11:58 6018 8192000000 10796184752 11224068096 1885936848 18.713 100 22 42 2 1898242944 6159904 6146192
20:12:11 12019 8192000000 10803146928 11228827648 1885979024 18.713 100 21 42 1 1898817296 6863424 5974848
20:12:30 7752 8192000000 10800824768 11231248384 1888568560 18.734 100 29 58 0 1903817312 7399600 7849152
20:12:45 5797 8192000000 10801200832 11229933568 1889844848 18.745 100 29 56 6 1904235536 6445008 7945680
20:12:56 13866 8192000000 10801056736 11233230848 1891712048 18.760 100 17 35 0 1906016368 9626640 4677680
20:13:18 11788 8192000000 10803466272 11229540352 1892106288 18.763 100 36 70 3 1907895504 5622800 10166416
20:13:36 44969 8192000000 10811489728 11238506496 1889586768 18.742 100 18 34 2 1899550976 4799136 5165072
20:14:39 12176 8192000000 10816676080 11242819584 1895520432 18.790 100 22 44 0 1908338656 6457040 6361184
20:14:57 7825 8192000000 10812172256 11241537536 1883122416 18.690 99 35 70 0 1900618912 6915216 10581280
20:15:12 3318 8192000000 10817738080 11246768128 1899587648 18.823 100 40 80 3 1918432128 7577376 11267104
20:15:21 3891 8192000000 10814866432 11244617728 1897453888 18.806 100 33 66 1 1913127712 6330736 9343088
20:15:32 6420 8192000000 10800048448 11225821184 1879052624 18.657 99 22 44 0 1891503328 6007600 6443104
20:15:45 8481 8192000000 10810444736 11243196416 1893793968 18.776 100 25 50 1 1907120512 5844096 7482448
20:16:02 10151 8192000000 10806236016 11240435712 1880198768 18.667 99 23 45 3 1892452192 5213600 7039824
20:16:21 6834 8192000000 10802369456 11236532224 1877539264 18.645 99 22 44 1 1889364800 5375200 6450336
20:16:35 5288 8192000000 10792176144 11227860992 1882188000 18.683 100 17 34 2 1893194336 5606576 5399760
20:16:46 5600 8192000000 10790718704 11222409216 1881685968 18.679 100 31 62 0 1896381456 5902064 8793424
20:16:59 5868 8192000000 10799723216 11223232512 1866854384 18.559 99 39 79 4 1884620384 6801888 10964112
20:17:15 7435 8192000000 10784698016 11214737408 1857994896 18.487 99 27 54 2 1872531344 6503168 8033280
20:17:29 14693 8192000000 10783565952 11209396224 1819976848 18.177 97 24 47 0 1832482944 5443680 7062416
20:17:50 16091 8192000000 10797089888 11216728064 1844455920 18.377 98 18 36 0 1854483936 5142688 4885328
20:18:12 51593 8192000000 10778980144 11192426496 1823773248 18.209 98 31 62 0 1838428944 5318448 9337248
20:19:11 26217 8192000000 10736047488 11166584832 1771992752 17.783 95 20 40 1 1783807424 5562848 6251824
20:19:47 6925 8192000000 10729741360 11151290368 1796628032 17.986 98 27 54 2 1811162112 5790352 8743728
20:20:01 6148 8192000000 10723526448 11139440640 1803669568 18.044 99 33 66 3 1820601136 7610672 9320896
20:20:14 9048 8192000000 10731421472 11130691584 1744405312 17.555 96 23 46 1 1756018240 5440816 6172112
20:20:31 9010 8192000000 10731748144 11148550144 1802616352 18.035 99 28 56 2 1816776000 6234080 7925568
20:20:52 7971 8192000000 10680174800 11091435520 1660952320 16.857 92 26 52 1 1674193632 5995680 7245632
20:21:08 7694 8192000000 10690022512 11110785024 1758715824 17.674 99 24 49 1 1771632640 5953552 6963264
20:21:23 15801 8192000000 10687435712 11094618112 1692862656 17.125 95 20 40 0 1704056400 5422816 5770928
20:21:47 7757 8192000000 10674967456 11089530880 1732036864 17.452 97 27 54 4 1746496080 5671136 8788080
20:22:01 8144 8192000000 10696633808 11113816064 1758842096 17.675 98 22 44 0 1770351072 4901424 6607552
20:22:15 7567 8192000000 10708558048 11129987072 1785836800 17.898 99 19 38 0 1796825040 5854304 5133936
20:22:29 6847 8192000000 10740132448 11154804736 1812345600 18.115 100 31 62 1 1827003104 5598944 9058560
20:22:42 10416 8192000000 10737512496 11163607040 1824120976 18.211 100 11 21 2 1832588096 5457216 3009904
20:23:04 21072 8192000000 10752769696 11180785664 1842780128 18.363 100 26 52 1 1856362144 6270704 7311312
20:23:55 27698 8192000000 10769669984 11191087104 1845439008 18.385 100 28 56 0 1862943136 9750336 7753792
20:24:31 4233 8192000000 10775322976 11191816192 1850023280 18.422 100 33 66 2 1865428608 6739888 8665440
20:24:47 6657 8192000000 10781626096 11194212352 1854406528 18.458 100 30 60 1 1868606160 5343328 8856304
20:25:00 7342 8192000000 10784762064 11200548864 1858708896 18.493 100 26 51 3 1873323824 6918000 7696928
20:25:18 7582 8192000000 10783690624 11205758976 1870004272 18.584 100 27 54 2 1883727296 5772848 7950176
20:25:34 5373 8192000000 10774791360 11207237632 1873511424 18.613 100 29 57 1 1888157056 5203344 9442288
20:25:46 6495 8192000000 10784362288 11213258752 1872855280 18.607 100 29 58 0 1887588864 6565344 8168240
20:25:59 7825 8192000000 10777901856 11208990720 1871626128 18.597 100 21 42 0 1883313520 5472864 6214528
20:26:13 7009 8192000000 10790564368 11218182144 1875316512 18.627 100 22 44 3 1886489184 5261744 5910928
20:26:31 11326 8192000000 10791034912 11221323776 1877166640 18.642 100 16 32 0 1887088624 5418528 4503456
20:26:51 8075 8192000000 10796794640 11221184512 1879518400 18.661 100 18 36 1 1890631456 5452864 5660192
20:27:08 4206 8192000000 10838400624 11248214016 1900352272 18.829 100 45 88 1 1918961712 4681456 13927984
20:27:22 27729 8192000000 10844752736 11258007552 1910460976 18.910 100 58 114 1 1933678848 6218640 16999232
20:28:03 10470 8192000000 10847137312 11265101824 1918760864 18.977 100 42 82 0 1938187280 7005680 12420736
20:28:21 37483 8192000000 10859754096 11277688832 1929494320 19.063 100 64 128 2 1956557264 9034432 18028512
20:29:50 92001 8192000000 10869308912 11306287104 1946560144 19.199 100 43 86 1 1977834560 18772304 12502112
20:31:32 14659 8192000000 10872565520 11308212224 1950054048 19.227 100 25 50 0 1971550048 13856720 7639280
20:31:55 13829 8192000000 10892465520 11322073088 1959163056 19.299 100 50 96 1 1986169600 13394944 13611600
20:32:18 11533 8192000000 10895982208 11320926208 1951562448 19.239 100 49 97 0 1980717024 15531840 13622736
20:32:43 6730 8192000000 10891943968 11324018688 1956874368 19.281 100 46 92 1 1988226240 17984048 13367824
20:33:00 15056 8192000000 10893705680 11331747840 1968126192 19.371 100 47 92 0 1998924256 17103792 13694272
20:33:22 27365 8192000000 10911633328 11345588224 1970715904 19.391 100 40 79 0 2000612544 17841152 12055488
20:34:01 16295 8192000000 10915070144 11349741568 1980421920 19.468 100 46 88 0 2012495616 18910384 13163312
20:34:27 11548 8192000000 10920338624 11354943488 1963670048 19.335 99 42 84 1 1997221376 20639584 12911744
20:34:59 18116 8192000000 10927805888 11372027904 1986365168 19.515 100 33 66 0 2020380704 23802256 10213280
20:35:27 15713 8192000000 10935908544 11369902080 1972578464 19.406 99 43 86 0 2011017456 24401392 14037600
20:35:50 6932 8192000000 10933422272 11370770432 1990015488 19.544 100 39 78 0 2030731712 28316512 12399712
20:36:09 11415 8192000000 10954901888 11380789248 1990930160 19.551 100 40 79 2 2028321424 24607072 12784192
20:36:31 5898 8192000000 10939918032 11380842496 1992533680 19.564 100 39 77 0 2031733216 27048112 12151424
20:36:48 9836 8192000000 10941646848 11373215744 1990938384 19.551 100 59 118 0 2035572720 26549936 18084400
20:37:05 12120 8192000000 10938073568 11376058368 1973653856 19.414 99 43 86 0 2016126720 29548688 12924176
20:37:30 3988 8192000000 10953650096 11386589184 1998651536 19.612 100 63 123 0 2048216720 30495296 19069888
20:37:41 15096 8192000000 10975404096 11401932800 2009112912 19.695 100 77 154 1 2064676544 32307840 23255792
20:38:11 6771 8192000000 10964256688 11396751360 2001313824 19.633 100 60 120 0 2054946688 35350864 18282000
20:38:31 7382 8192000000 10984249616 11410931712 2010320992 19.704 100 65 130 1 2065555984 36666928 18568064
20:38:45 1942 8192000000 10984807504 11408957440 2015494480 19.745 100 78 154 1 2076535648 38012672 23028496
20:38:55 4698 8192000000 10948790736 11367890944 1975877264 19.432 98 74 146 2 2035163840 37949392 21337184
20:39:09 2587 8192000000 10972197376 11389210624 1994645024 19.580 100 71 141 1 2055250080 39318640 21286416
20:39:20 4646 8192000000 10962499088 11385069568 1985116880 19.505 99 74 143 2 2047712912 39628928 22967104
20:39:32 2727 8192000000 10987790720 11406839808 2004710544 19.660 100 81 159 3 2068800160 39605872 24483744
20:39:42 1470 8192000000 10998983424 11412123648 2011297744 19.712 100 92 183 1 2089252896 50188080 27767072
20:39:53 8732 8192000000 10989531968 11408326656 1996740208 19.597 99 77 154 1 2063194224 43045904 23408112
20:40:12 2591 8192000000 10998471920 11416981504 2009702992 19.699 100 75 151 0 2079226208 47320272 22202944
20:40:22 2733 8192000000 11003028000 11425849344 2020301088 19.783 100 78 156 1 2088980496 45175232 23504176
20:40:36 2035 8192000000 11004727648 11422588928 2016665248 19.754 100 86 171 1 2086832400 43949520 26217632
20:40:44 1328 8192000000 11011126048 11433172992 2028775712 19.849 100 90 178 3 2099481232 44634960 26070560
20:40:52 3448 8192000000 11023112768 11435061248 2027373744 19.838 100 82 162 0 2097170064 45078000 24718320
20:41:05 1919 8192000000 11014108736 11435102208 2030195712 19.860 100 87 173 0 2103132688 46672448 26264528
20:41:15 2583 8192000000 11008270400 11425755136 2012481760 19.721 99 73 146 0 2081468128 46905664 22080704
20:41:24 1338 8192000000 11026537392 11440410624 2031740240 19.872 100 85 170 1 2104392720 47393216 25259264
20:41:33 1811 8192000000 11019766768 11442044928 2029455408 19.854 100 81 163 2 2104341440 50035888 24850144
20:41:41 3749 8192000000 10998098496 11419693056 1985876704 19.511 98 84 168 2 2062141088 50310816 25953568
20:41:54 2651 8192000000 10993729152 11414511616 2001030528 19.631 100 70 138 3 2072431616 49542608 21858480
20:42:07 5628 8192000000 10987509552 11412066304 1998490688 19.611 100 73 144 3 2071788544 50854608 22443248
20:42:19 2525 8192000000 10997572560 11414515712 1988340032 19.531 99 76 152 1 2064153952 52190144 23623776
20:42:30 2244 8192000000 11012218384 11428175872 2015652848 19.746 100 85 170 1 2094972944 52608256 26711840
20:42:39 2176 8192000000 11004726784 11420549120 2001867920 19.637 99 87 175 3 2082801968 53800592 27133456
20:42:49 1756 8192000000 11016669760 11429068800 2012629104 19.722 100 89 179 3 2095675632 55661792 27384736
20:43:00 1839 8192000000 11022791440 11438718976 2017516656 19.761 100 87 175 2 2100847424 56389632 26941136
20:43:10 1999 8192000000 11026698048 11442503680 2023483344 19.808 100 89 178 2 2110664752 59420048 27761360
20:43:19 1308 8192000000 11032518000 11445915648 2026454016 19.831 100 89 178 0 2112604768 58569408 27581344
20:43:26 1679 8192000000 11009043152 11424694272 2009519104 19.698 99 93 186 1 2094507392 56482496 28505792
20:43:36 2420 8192000000 11026872064 11440807936 2021459424 19.792 100 84 167 0 2103578576 56561648 25557504
20:43:46 2332 8192000000 11027507792 11441410048 2019484240 19.776 100 93 185 0 2109698016 61160320 29053456
20:43:57 3780 8192000000 11027896320 11450093568 2024371712 19.814 100 83 166 4 2111772752 61753536 25647504
20:44:08 1485 8192000000 11042105008 11451019264 2024594096 19.816 100 91 182 1 2112075728 58763888 28717744
20:44:16 1769 8192000000 11011202256 11435266048 1993275408 19.570 99 83 165 0 2085994528 67478448 25240672
20:44:26 2768 8192000000 10985708256 11404185600 1985172656 19.506 100 67 134 0 2067188448 60377392 21638400
20:44:40 5408 8192000000 10980196880 11399958528 1964106688 19.339 99 69 136 0 2048170080 61464064 22599328
20:44:56 3166 8192000000 10983179568 11389886464 1966370208 19.357 99 84 167 1 2057274368 63354144 27550016
20:45:08 3636 8192000000 10988004944 11402964992 1979917712 19.464 100 80 159 1 2070657632 65143024 25596896
20:45:19 3891 8192000000 10984444512 11395895296 1967325744 19.364 99 85 169 2 2061382608 66546480 27510384
20:45:30 3037 8192000000 10992104672 11406962688 1981275968 19.475 100 81 161 3 2075811136 68298320 26236848
20:45:43 3439 8192000000 10986917488 11403100160 1971010176 19.393 99 76 151 1 2063184448 67948416 24225856
20:45:58 1467 8192000000 10975111072 11387011072 1964515808 19.342 99 81 161 2 2058698864 67131632 27051424
20:46:06 3592 8192000000 10985321136 11400380416 1977868064 19.448 100 78 156 2 2067741280 63838032 26035184
20:46:19 3806 8192000000 10990005520 11406954496 1982542768 19.485 100 66 131 0 2069585184 65219120 21823296
20:46:30 1809 8192000000 10994038944 11413164032 1987915584 19.527 100 82 163 1 2081984112 66177888 27890640
20:46:39 3264 8192000000 11000054176 11417616384 1987617408 19.525 100 88 176 2 2087503168 70945552 28940208
20:46:52 2892 8192000000 11005501648 11421159424 1985954256 19.512 100 87 175 2 2086317632 71861536 28501840
20:47:02 1883 8192000000 10991072400 11394818048 1964313520 19.340 99 85 168 1 2064621424 73200896 27107008
20:47:11 10623 8192000000 10990179264 11403857920 1977512208 19.445 100 81 161 2 2074882992 71849392 25521392
20:47:31 3893 8192000000 11000419744 11409100800 1981063280 19.473 100 82 165 0 2079835872 71979488 26793104
20:47:42 1362 8192000000 11007364576 11411525632 1970246384 19.387 99 90 175 3 2072977344 74357344 28373616
20:47:51 4788 8192000000 11006279536 11429720064 1990052336 19.544 100 76 150 0 2090725040 75208736 25463968
20:48:04 2858 8192000000 11024138816 11430797312 1997645552 19.604 100 93 186 2 2100402256 72909168 29847536
20:48:13 1694 8192000000 11020299696 11432865792 1994320432 19.578 100 86 172 2 2097043136 74822048 27900656
20:48:22 2707 8192000000 11016277344 11432996864 1994967152 19.583 100 74 148 4 2096036336 76716576 24352608
20:48:38 12748 8192000000 11002013568 11440889856 1994104528 19.576 100 49 98 2 2087706032 76920512 16680992
20:48:58 6299 8192000000 10994076848 11431383040 1993701424 19.573 100 54 108 0 2082489280 70755296 18032560
20:49:13 16735 8192000000 10994538432 11438632960 1999985120 19.623 100 41 82 1 2081307456 67249488 14072848
20:49:40 15835 8192000000 10992602304 11431882752 1997390096 19.602 100 41 82 0 2073768976 62567712 13811168
20:50:12 16788 8192000000 10989124160 11426557952 1997257024 19.601 100 48 96 1 2073253168 59800032 16196112
20:50:47 14950 8192000000 10957208864 11404161024 1971497360 19.397 99 38 76 0 2044231280 58936720 13797200
20:51:09 7002 8192000000 10964221216 11400282112 1980256928 19.467 100 42 84 0 2050196096 55817200 14121968
20:51:39 9547 8192000000 10973281312 11418013696 1983294272 19.491 100 45 90 0 2057815456 59142576 15378608
20:51:57 20510 8192000000 10978256816 11425628160 1985756032 19.510 100 40 80 2 2062954864 63054784 14144048
20:52:53 28191 8192000000 10966732752 11419398144 1965568704 19.350 100 32 64 1 2048885120 71012592 12303824
20:53:51 34987 8192000000 10941042864 11405996032 1905397760 18.870 98 23 46 1 1996058784 80867984 9793040
20:54:33 20484 8192000000 10936698384 11403501568 1935860112 19.114 100 24 47 0 2023679424 78415040 9404272
20:55:27 60930 8192000000 10862654752 11331481600 1861797584 18.518 96 10 20 1 1895528752 30660624 3070544
20:56:50 20518 8192000000 10890772880 11311124480 1922896608 19.010 99 56 110 1 1950105568 12008240 15200720
20:57:18 23486 8192000000 10894073488 11335143424 1935306560 19.109 99 51 101 0 1966699760 16700976 14692224
20:58:41 39516 8192000000 10911215360 11356393472 1940620944 19.152 99 43 86 1 1980444464 26804896 13018624
20:59:41 91601 8192000000 10893497008 11367280640 1958660512 19.295 100 17 34 1 1978564720 15096272 4807936
21:01:46 75042 8192000000 10875636288 11335962624 1868007440 18.568 95 21 42 1 1884529104 11218912 5302752
21:03:22 96125 8192000000 10916148800 11366739968 1927713568 19.049 98 20 40 1 1953648672 20307504 5627600
21:05:08 206333 8192000000 10910407376 11373617152 1893603744 18.775 96 27 54 1 1913341936 11773744 7964448
21:08:46 38170 8192000000 10920869328 11375468544 1955895856 19.273 99 28 56 0 1985040320 20285696 8858768
21:09:32 21801 8192000000 10920167888 11371163648 1961487024 19.318 99 50 101 2 1992381536 15499232 15395280
21:10:18 47734 8192000000 10901000672 11368124416 1956836064 19.281 100 34 68 2 1989885360 23120480 9928816
21:11:30 36078 8192000000 10864124032 11359416320 1891555136 18.758 97 1 2 0 1909831056 18213792 62128
21:12:13 5751 8192000000 10861309616 11347861504 1921526736 18.999 99 1 2 0 1939050528 17461664 62128
21:12:30 24419 8192000000 10874047872 11350269952 1949724032 19.224 100 14 28 0 1965925568 12187872 4013664
21:13:01 29963 8192000000 10899240816 11357413376 1963433456 19.333 100 25 49 0 1977471264 6799056 7238752
21:13:46 39601 8192000000 10881455056 11352469504 1946822640 19.201 99 9 17 0 1956490544 7106704 2561200
21:15:20 88429 8192000000 10899058192 11379384320 1975928528 19.432 100 22 44 2 1993617312 11136672 6552112
21:17:01 58696 8192000000 10881253360 11358539776 1934374880 19.102 98 8 16 1 1948554688 11713296 2466512
21:18:13 33836 8192000000 10884959024 11353436160 1944828608 19.185 99 33 65 1 1966489824 12934896 8726320
21:18:53 36122 8192000000 10867527088 11346128896 1953595616 19.255 100 14 28 0 1968777088 11315536 3865936
21:19:38 68863 8192000000 10869573616 11345645568 1931609904 19.080 99 11 22 0 1945851904 11304400 2937600
21:21:03 70108 8192000000 10873004096 11361370112 1936246400 19.117 99 8 16 0 1953733584 15456752 2030432
21:22:19 19409 8192000000 10885099888 11358785536 1933888800 19.098 99 16 31 1 1950635760 11774080 4972880
21:22:48 52362 8192000000 10896120192 11360362496 1945627568 19.192 99 21 42 1 1966030480 13824320 6578592
21:24:19 53677 8192000000 10894577616 11367071744 1946995056 19.203 99 19 38 2 1967304544 13885648 6423840
21:25:20 61367 8192000000 10897223456 11367571456 1930282592 19.069 98 19 38 0 1954409568 18306848 5820128
21:26:27 71127 8192000000 10902387264 11376537600 1940013216 19.147 98 19 38 1 1955688464 10209360 5465888
21:27:46 19638 8192000000 10903026240 11362246656 1945501232 19.191 98 39 76 0 1962238464 6086112 10651120
21:28:19 30284 8192000000 10907287920 11364126720 1933873776 19.098 98 34 68 3 1952984608 9793360 9317472
21:29:00 80282 8192000000 10875693232 11346366464 1833995536 18.292 93 20 40 1 1853207072 14019856 5191680
21:30:28 39839 8192000000 10883111936 11346219008 1868714720 18.574 95 27 54 1 1885134512 9308032 7111760
21:31:17 30198 8192000000 10902994832 11361464320 1960249840 19.308 100 27 54 1 1977894752 10107344 7537568
21:31:54 33480 8192000000 10891138640 11349348352 1925597712 19.032 98 33 66 1 1946949600 12214064 9137824
21:32:39 64304 8192000000 10915356176 11360698368 1944931520 19.186 99 26 52 1 1962422032 10658400 6832112
21:33:51 14316 8192000000 10925919776 11373043712 1970214864 19.387 100 33 66 1 1989341376 9941376 9185136
21:34:14 29475 8192000000 10941576976 11390337024 1969495312 19.381 99 50 100 0 2004094976 20881072 13718592
21:35:31 56447 8192000000 10881283664 11337306112 1851977920 18.438 94 11 22 2 1868440640 13623216 2839504
21:36:39 84138 8192000000 10913807072 11350605824 1942243120 19.165 99 42 84 1 1962597008 8193648 12160240
21:38:24 71885 8192000000 10909093072 11368845312 1965104448 19.347 100 38 76 0 1988726240 13633296 9988496
21:39:43 24174 8192000000 10878432896 11348373504 1922269984 19.005 98 11 22 1 1939906736 14282624 3354128
21:40:16 78857 8192000000 10864261472 11337375744 1913839312 18.937 98 12 24 0 1929523760 12410800 3273648
21:41:43 61915 8192000000 10862113824 11333541888 1885331264 18.708 97 15 31 0 1907871056 18104720 4435072
21:42:54 62356 8192000000 10882328080 11363573760 1947574544 19.207 100 14 28 0 1971547664 19283280 4689840
21:44:42 55403 8192000000 10853027808 11324493824 1905005600 18.867 98 16 32 0 1927168880 17230064 4933216
21:45:46 61940 8192000000 10844975456 11324567552 1854685120 18.460 96 10 21 0 1872804912 15183744 2936048
21:46:56 73337 8192000000 10861737744 11323899904 1876845424 18.640 97 14 28 0 1893690784 12572064 4273296
21:48:28 47045 8192000000 10876800960 11339214848 1932595488 19.088 100 19 38 2 1951012992 12749856 5667648
21:49:29 44027 8192000000 10867181920 11337383936 1921839264 19.002 99 13 26 2 1941302752 15056832 4406656
21:50:19 55375 8192000000 10869284576 11340759040 1920091584 18.988 99 15 30 0 1938000480 13754880 4154016
21:51:27 27901 8192000000 10887505568 11339124736 1932938752 19.090 99 44 89 0 1954272640 8518736 12815152
21:52:17 60644 8192000000 10899324272 11352817664 1954303168 19.261 100 29 58 2 1972997008 10306800 8387040
21:53:29 10703 8192000000 10894766560 11340259328 1931388912 19.078 99 38 76 1 1952758224 11122656 10246656
21:53:46 24253 8192000000 10887417280 11329703936 1929342640 19.062 99 41 83 0 1951471680 10678928 11450112
21:54:19 9635 8192000000 10870384688 11313991680 1905746384 18.872 98 49 98 2 1930163168 10747328 13669456
21:54:38 23924 8192000000 10874261952 11315208192 1883356880 18.692 97 45 90 0 1911301136 15885408 12058848
21:55:10 7381 8192000000 10873743328 11317047296 1930073200 19.067 100 41 82 1 1952280144 10942736 11264208
21:55:24 18811 8192000000 10888013504 11315556352 1905116960 18.867 99 44 89 0 1927755376 9929696 12708720
21:55:49 9790 8192000000 10882693088 11323039744 1932651472 19.088 100 43 86 1 1957156832 12515456 11989904
21:56:09 116826 8192000000 10853193760 11317764096 1912702448 18.928 99 38 76 1 1937904192 14710816 10490928
21:58:26 22036 8192000000 10886424016 11338412032 1952893760 19.250 100 42 84 1 1975959728 10516944 12549024
21:58:59 49502 8192000000 10886920800 11357962240 1963518288 19.334 100 29 58 1 1983444976 11731504 8195184
22:01:54 93769 8192000000 10891150144 11360464896 1935786160 19.113 98 14 28 0 1956786112 17525232 3474720
22:03:34 40744 8192000000 10899428464 11364941824 1932682144 19.088 98 26 51 2 1953637872 13969232 6986496
22:04:21 52443 8192000000 10866607280 11335380992 1906858784 18.881 97 20 38 2 1925191904 12689936 5643184
22:05:21 72124 8192000000 10881914384 11351224320 1897724208 18.808 97 19 38 0 1916751184 12714208 6312768
22:06:46 51498 8192000000 10875252256 11336605696 1917877168 18.970 98 13 26 0 1930086256 8476640 3732448
22:07:47 72621 8192000000 10885278608 11344990208 1919735488 18.985 98 11 22 2 1932934080 10211760 2986832
22:09:12 37576 8192000000 10917458240 11358920704 1959183856 19.300 100 32 64 0 1977475232 9228752 9062624
22:09:59 37713 8192000000 10896595488 11363819520 1968423552 19.373 100 38 76 1 1992373728 13325664 10624512
22:10:48 43362 8192000000 10909631728 11372105728 1978241904 19.451 100 24 48 1 1993960240 9357600 6360736
22:11:39 91980 8192000000 10905322352 11358314496 1881084416 18.674 95 30 59 0 1900247216 11158528 8004272
22:13:21 77635 8192000000 10881225760 11361349632 1906968672 18.882 97 18 36 0 1924784368 12674928 5140768
22:14:59 128275 8192000000 10877426224 11348643840 1823920336 18.210 93 13 26 1 1844589728 17423968 3245424
22:17:13 148688 8192000000 10857099744 11325583360 1894528048 18.782 97 11 22 2 1907986848 10251744 3207056
22:20:19 39774 8192000000 10845951408 11324461056 1920942768 18.994 99 14 28 0 1933731616 8429936 4358912
22:23:04 74211 8192000000 10859925808 11328475136 1874270496 18.619 96 8 16 0 1884964256 8136208 2557552
22:24:24 32719 8192000000 10872644512 11338199040 1943150032 19.172 100 16 32 0 1956850544 8633600 5066912
22:25:03 61819 8192000000 10867581008 11347496960 1934808704 19.105 99 12 24 0 1949957904 11404240 3744960
22:26:13 63267 8192000000 9298034448 9567391744 442453904 5.124 23 6 11 0 447099504 2871376 1774224

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 15-01-2021 22:28:54 to 15-01-2021 22:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 191 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-01-2021 22:29:27 to 15-01-2021 22:29:29.

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          240040
MON$OLDEST_ACTIVE               240041
MON$OLDEST_SNAPSHOT             240041
MON$NEXT_TRANSACTION            240041
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                       2034592
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:960: 
:961: mscs-test-161.budzdorov.ru    Fri Jan 15 22:27:28 2021
:962:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:963: 
--- end of diff output ---

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

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