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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-30 01:27:07
DTS_END                         2020-12-30 01:27:07.3500
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/36114
TRN_ID                          245045
ATT_ID                          645
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: 9478.71 22325 1137445
customer order: creation 173.42 322 20810
customer order: refuse 14.49 340 1739
order to supplier: creation 47.90 1185 5748
order to supplier: removal 3.52 93715 422
invoice (draft): creation 46.08 3139 5530
invoice (draft): removal 54.71 736 6565
invoice accept: apply 43.08 18676 5169
invoice accept: cancel 49.78 736 5973
customer reserve: creation 3926.08 188 471129
customer reserve: removal 4807.21 54 576865
realization accept: apply 86.53 160 10384
realization accept: cancel 94.12 97 11294
payment from customer: creation 59.95 116 7194
payment from customer: removal 6.16 76 739
payment to supplier: creation 49.86 122 5983
payment to supplier: removal 3.58 91 429
service: total inventory turnovers 4.86 1112 583
service: total monetary turnovers 6.63 33 796
service: aggregate perf. data 0.74 24928 89
service: refresh index statistics 0.03 300671 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-12-2020 01:28:40 to 30-12-2020 01:28:42.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3342
TEST_TIME 2 4621
TEST_TIME 3 4556
TEST_TIME 4 5580
TEST_TIME 5 5557
TEST_TIME 6 5632
TEST_TIME 7 5946
TEST_TIME 8 5814
TEST_TIME 9 6109
TEST_TIME 10 6124
TEST_TIME 11 6342
TEST_TIME 12 6934
TEST_TIME 13 7073
TEST_TIME 14 7345
TEST_TIME 15 7921
TEST_TIME 16 8142
TEST_TIME 17 8259
TEST_TIME 18 8692
TEST_TIME 19 8920
TEST_TIME 20 8810
TEST_TIME 21 9195
TEST_TIME 22 9189
TEST_TIME 23 9762
TEST_TIME 24 10100
TEST_TIME 25 10360
TEST_TIME 26 10556
TEST_TIME 27 11104
TEST_TIME 28 11345
TEST_TIME 29 11184
TEST_TIME 30 11274
TEST_TIME 31 11199
TEST_TIME 32 11142
TEST_TIME 33 11024
TEST_TIME 34 11185
TEST_TIME 35 11011
TEST_TIME 36 10883
TEST_TIME 37 10655
TEST_TIME 38 10628
TEST_TIME 39 10481
TEST_TIME 40 10412
TEST_TIME 41 10340
TEST_TIME 42 10313
TEST_TIME 43 10210
TEST_TIME 44 10180
TEST_TIME 45 10095
TEST_TIME 46 10047
TEST_TIME 47 9947
TEST_TIME 48 10067
TEST_TIME 49 9900
TEST_TIME 50 9813
TEST_TIME 51 9817
TEST_TIME 52 9802
TEST_TIME 53 9752
TEST_TIME 54 9728
TEST_TIME 55 9691
TEST_TIME 56 9676
TEST_TIME 57 9640
TEST_TIME 58 9660
TEST_TIME 59 9738
TEST_TIME 60 9733
TEST_TIME 61 9698
TEST_TIME 62 9746
TEST_TIME 63 9810
TEST_TIME 64 9953
TEST_TIME 65 9927
TEST_TIME 66 9942
TEST_TIME 67 9902
TEST_TIME 68 9935
TEST_TIME 69 9933
TEST_TIME 70 9980
TEST_TIME 71 9891
TEST_TIME 72 9812
TEST_TIME 73 9763
TEST_TIME 74 9730
TEST_TIME 75 9743
TEST_TIME 76 9722
TEST_TIME 77 9770
TEST_TIME 78 9729
TEST_TIME 79 9678
TEST_TIME 80 9658
TEST_TIME 81 9574
TEST_TIME 82 9613
TEST_TIME 83 9547
TEST_TIME 84 9527
TEST_TIME 85 9550
TEST_TIME 86 9526
TEST_TIME 87 9537
TEST_TIME 88 9577
TEST_TIME 89 9608
TEST_TIME 90 9628
TEST_TIME 91 9614
TEST_TIME 92 9729
TEST_TIME 93 9704
TEST_TIME 94 9675
TEST_TIME 95 9731
TEST_TIME 96 9705
TEST_TIME 97 9623
TEST_TIME 98 9599
TEST_TIME 99 9560
TEST_TIME 100 9560
TEST_TIME 101 9517
TEST_TIME 102 9458
TEST_TIME 103 9415
TEST_TIME 104 9455
TEST_TIME 105 9426
TEST_TIME 106 9443
TEST_TIME 107 9473
TEST_TIME 108 9461
TEST_TIME 109 9510
TEST_TIME 110 9490
TEST_TIME 111 9521
TEST_TIME 112 9521
TEST_TIME 113 9555
TEST_TIME 114 9567
TEST_TIME 115 9625
TEST_TIME 116 9599
TEST_TIME 117 9634
TEST_TIME 118 9604
TEST_TIME 119 9554
TEST_TIME 120 9479

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-12-2020 01:28:43 to 30-12-2020 01: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 1574339 1574339 0 0.00 0 20225 6 0 0
doc_list_biud 1574338 1574338 0 0.00 0 55137 25 0 0
sp_add_invoice_to_stock 5324 5169 155 2.91 62 187648 18677 0 155
sp_cancel_adding_invoice 5973 5973 0 0.00 5 50474 736 0 0
sp_cancel_client_order 1739 1739 0 0.00 4 11476 340 0 0
sp_cancel_customer_reserve 576865 576865 0 0.00 1 29598 54 0 0
sp_cancel_pay_from_customer 739 739 0 0.00 3 7418 77 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 7256 91 0 0
sp_cancel_supplier_invoice 6576 6565 11 0.16 1 55146 737 0 11
sp_cancel_supplier_order 422 422 0 0.00 9 988051 93716 0 0
sp_cancel_write_off 11294 11294 0 0.00 1 7350 98 0 0
sp_client_order 20810 20810 0 0.00 3 20521 323 0 0
sp_customer_reserve 471129 471129 0 0.00 0 49436 189 0 0
sp_fill_shopping_cart 32082 32082 0 0.00 1 11721 36 0 0
sp_fill_shopping_cart_clo_res 471126 471126 0 0.00 0 25368 12 0 0
sp_get_clo_for_invoice 5166 5166 0 0.00 0 25062 258 0 0
sp_kill_cost_storno 18435 18435 0 0.00 0 7486 49 0 0
sp_kill_qstorno_ret_qs2qd 1172011 1172011 0 0.00 0 55132 29 0 0
sp_kill_qty_storno 618404 618404 0 0.00 0 55134 63 0 0
sp_lock_selected_doc 21383 21383 0 0.00 0 6781 6 0 0
sp_make_cost_storno 28724 28724 0 0.00 0 20222 54 0 0
sp_multiply_rows_for_pdistr 28723 28723 0 0.00 0 7877 28 0 0
sp_multiply_rows_for_qdistr 20810 20810 0 0.00 0 20512 147 0 0
sp_pay_from_customer 7194 7194 0 0.00 4 13020 117 0 0
sp_pay_to_supplier 5983 5983 0 0.00 5 12187 123 0 0
sp_payment_common 13177 13177 0 0.00 1 6550 25 0 0
sp_qd_handle_on_cancel_clo 1739 1739 0 0.00 0 11432 302 0 0
sp_qd_handle_on_invoice_upd_sts 11136 11136 0 0.00 0 16586 296 0 0
sp_qd_handle_on_reserve_upd_sts 10383 10383 0 0.00 0 9654 51 0 0
sp_reserve_write_off 10384 10384 0 0.00 6 20238 160 0 0
sp_supplier_invoice 5530 5530 0 0.00 7 96122 3139 0 0
sp_supplier_order 5748 5748 0 0.00 6 33757 1185 0 0
srv_aggregate_perf_data 89 89 0 0.00 2145 372303 24929 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 665 133020 31154 0 0
srv_find_qd_qs_mism 1089201 1089201 0 0.00 0 12246 6 0 0
srv_make_invnt_saldo 583 583 0 0.00 43 62239 1112 0 0
srv_make_money_saldo 796 796 0 0.00 1 3257 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 193380 557120 300671 0 0
t$perf-abend:sp_add_invoice_to_stock 155 155 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5169 5169 0 0.00 0 11397 142 0 0
t$perf-norm:sp_cancel_adding_invoice 397 397 0 0.00 0 4595 108 0 0
t$perf-norm:sp_cancel_client_order 1739 1739 0 0.00 0 2715 15 0 0
t$perf-norm:sp_cancel_customer_reserve 667 667 0 0.00 0 692 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 739 739 0 0.00 0 5454 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 801 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 941 16 0 0
t$perf-norm:sp_cancel_supplier_order 422 422 0 0.00 0 31198 1521 0 0
t$perf-norm:sp_cancel_write_off 1053 1053 0 0.00 0 2225 9 0 0
t$perf-norm:sp_client_order 20810 20810 0 0.00 0 7375 17 0 0
t$perf-norm:sp_customer_reserve 1048 1048 0 0.00 0 1230 5 0 0
t$perf-norm:sp_pay_from_customer 7194 7194 0 0.00 0 5120 9 0 0
t$perf-norm:sp_pay_to_supplier 5983 5983 0 0.00 0 9031 11 0 0
t$perf-norm:sp_reserve_write_off 10384 10384 0 0.00 0 6713 10 0 0
t$perf-norm:sp_supplier_invoice 5530 5530 0 0.00 0 4182 16 0 0
t$perf-norm:sp_supplier_order 5748 5748 0 0.00 0 5866 17 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 47 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 4210 27 0 0
t$perf-norm:srv_make_invnt_saldo 583 583 0 0.00 0 3937 28 0 0
t$perf-norm:srv_make_money_saldo 796 796 0 0.00 0 1550 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10636 10326 310 2.91 0 3548 18 0 310
v_all_customers 37840 37840 0 0.00 0 18 1 0 0
v_all_suppliers 31028 31028 0 0.00 0 20 1 0 0
v_all_wares 41620 41620 0 0.00 0 45 1 0 0
v_cancel_adding_invoice 794 794 0 0.00 0 760 6 0 0
v_cancel_client_order 3478 3478 0 0.00 0 6433 7 0 0
v_cancel_customer_prepayment 1478 1478 0 0.00 0 1487 5 0 0
v_cancel_customer_reserve 1334 1334 0 0.00 0 355 3 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 302 3 0 0
v_cancel_supplier_invoice 804 782 22 2.73 0 5264 26 0 22
v_cancel_supplier_order 844 844 0 0.00 0 1463 5 0 0
v_cancel_write_off 2106 2106 0 0.00 0 591 12 0 0
v_max_id_clo_ord 5747 5747 0 0.00 0 2219 2 0 0
v_max_id_clo_res 1048 1048 0 0.00 0 2007 11 0 0
v_max_id_ord_sup 5525 5525 0 0.00 0 3312 7 0 0
v_max_non_paid_invoice 1741 1741 0 0.00 0 1078 3 0 0
v_max_non_paid_realizn 3851 3851 0 0.00 0 4454 4 0 0
v_min_id_clo_ord 5747 5747 0 0.00 0 3452 6 0 0
v_min_id_clo_res 1048 1048 0 0.00 0 986 5 0 0
v_min_id_ord_sup 5525 5525 0 0.00 0 7586 8 0 0
v_min_non_paid_invoice 5983 5983 0 0.00 0 4037 15 0 0
v_min_non_paid_realizn 7194 7194 0 0.00 0 6546 17 0 0
v_our_firm 10466 10466 0 0.00 0 13 1 0 0
v_reserve_write_off 20766 20766 0 0.00 0 7614 5 0 0
x_lock_depdocs_on_canc_invoice 12147 12147 0 0.00 0 15455 110 0 0
x_lock_depdocs_on_canc_sup_ord 422 422 0 0.00 0 4910 281 0 0
x_make_qstorno_1000_1200 5748 5748 0 0.00 2 33678 1108 0 0
x_make_qstorno_1200_2000 5530 5530 0 0.00 3 96100 3012 0 0
x_make_qstorno_2100_3300 471129 471129 0 0.00 0 42752 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-12-2020 01:28:48 to 30-12-2020 01: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
22:57:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:17 26293 8192000000 10299346528 10611896320 1109911456 11.932 84 64 128 0 1134493008 3356688 21224864
22:57:53 29116 8192000000 10354424144 10676391936 1405836192 14.647 100 84 168 0 1438134912 5480032 26818688
22:58:30 21688 8192000000 10403059936 10732302336 1450328176 15.041 100 82 165 0 1483221296 6397040 26496080
22:59:00 22841 8192000000 10425509056 10758889472 1474595392 15.254 100 87 173 1 1510263632 7556080 28112160
22:59:31 23640 8192000000 10456633504 10789777408 1499332832 15.470 100 90 180 0 1536863472 8565440 28965200
23:00:10 26829 8192000000 10464128944 10799312896 1516923840 15.624 100 91 182 0 1555594272 9126928 29543504
23:00:43 19943 8192000000 10480895008 10819928064 1533557056 15.768 100 91 182 1 1572264928 9741296 28966576
23:01:28 18389 8192000000 10500102368 10847494144 1559910400 15.995 100 88 175 0 1597371728 10147888 27313440
23:02:08 11044 8192000000 10520498816 10875002880 1581114048 16.178 100 76 152 0 1615251952 10563808 23574096
23:02:31 15941 8192000000 10557856288 10914435072 1605528800 16.387 100 74 148 2 1638689312 11034240 22126272
23:03:00 15786 8192000000 10590783328 10952527872 1639023984 16.671 100 78 156 0 1673519360 11917920 22577456
23:03:26 11864 8192000000 10610511040 10975154176 1666055792 16.900 100 79 157 1 1700725888 12210224 22459872
23:03:47 9668 8192000000 10618574672 10987126784 1678527152 17.005 100 79 158 2 1714182256 12597216 23057888
23:04:04 12974 8192000000 10641778304 11010228224 1693749296 17.133 100 76 152 1 1728103264 12515936 21838032
23:04:24 10842 8192000000 10664465936 11034542080 1718712528 17.341 100 83 167 2 1756163696 13345280 24105888
23:04:42 6780 8192000000 10667678080 11044380672 1734174880 17.470 100 81 162 1 1768783760 11965264 22643616
23:04:56 7058 8192000000 10686823376 11063934976 1747810880 17.583 100 84 166 2 1783017632 12007184 23199568
23:05:11 6052 8192000000 10691459536 11074121728 1758595312 17.673 100 85 168 1 1795108544 12735824 23777408
23:05:25 4121 8192000000 10706885232 11085234176 1767852944 17.749 100 83 166 0 1803769696 12865840 23050912
23:05:35 4093 8192000000 10713797152 11096776704 1779235152 17.843 100 87 170 2 1816156656 13299696 23621808
23:05:47 3973 8192000000 10737947408 11114713088 1793180848 17.958 100 86 171 5 1830100016 12700560 24218608
23:05:58 4046 8192000000 10743969264 11124514816 1800206176 18.016 100 86 173 3 1837982320 13705184 24070960
23:06:08 2370 8192000000 10746182720 11124314112 1802014784 18.030 100 83 166 1 1839136640 14180192 22941664
23:06:17 2529 8192000000 10747071520 11130777600 1806038304 18.063 100 86 172 0 1844792080 14643808 24109968
23:06:26 2985 8192000000 10751589936 11137105920 1812404208 18.116 100 92 185 0 1853290304 15385408 25500688
23:06:36 2776 8192000000 10751928672 11133927424 1811230912 18.106 100 90 180 0 1851128048 14268048 25629088
23:06:45 8487 8192000000 10747223168 11138191360 1814608192 18.134 100 77 153 3 1847922480 12302048 21012240
23:07:00 3731 8192000000 10755453008 11145936896 1824806032 18.217 100 82 161 0 1859979920 12755552 22418336
23:07:11 2177 8192000000 10783649824 11172831232 1846384672 18.393 100 93 184 1 1884579968 12085072 26110224
23:07:19 1749 8192000000 10789901328 11181735936 1849290784 18.416 100 84 166 0 1885221792 12132544 23798464
23:07:27 1898 8192000000 10799322688 11185504256 1855498944 18.467 100 95 190 1 1895132912 13138576 26495392
23:07:36 1785 8192000000 10800858256 11189252096 1856042272 18.471 100 91 180 4 1894163072 12420336 25700464
23:07:44 1928 8192000000 10805625136 11194294272 1863436992 18.531 100 92 183 2 1902309760 13807536 25065232
23:07:52 1205 8192000000 10802945792 11190231040 1865567760 18.548 100 93 189 1 1905770304 13046928 27155616
23:07:59 1393 8192000000 10804236000 11196661760 1864826256 18.542 100 86 171 2 1900622832 11680528 24116048
23:08:07 10992 8192000000 10801549072 11197992960 1863318016 18.530 100 68 131 1 1892582976 11267632 17997328
23:08:24 12948 8192000000 10807830064 11202822144 1867628016 18.565 100 68 133 1 1896669248 10930352 18110880
23:08:43 29947 8192000000 10775587168 11203604480 1867979056 18.568 100 40 80 2 1887630384 8013536 11637792
23:09:23 5637 8192000000 10794859536 11215003648 1878612704 18.654 100 40 80 2 1897687952 8067296 11007952
23:09:35 3254 8192000000 10805062544 11221770240 1884092064 18.698 100 57 114 1 1909193280 8832928 16268288
23:09:46 4681 8192000000 10798400432 11218690048 1881450064 18.677 100 42 84 1 1902029872 8478512 12101296
23:10:01 8267 8192000000 10802891136 11220746240 1881997184 18.681 100 37 74 6 1900171792 7668480 10506128
23:10:18 6390 8192000000 10783244240 11216433152 1879522160 18.661 100 23 46 0 1893262064 7478752 6261152
23:10:31 6788 8192000000 10795891584 11221512192 1883839904 18.696 100 30 60 1 1898274224 5906032 8528288
23:10:45 5443 8192000000 10797916016 11224555520 1884683840 18.703 100 24 48 1 1898117952 6959120 6474992
23:10:59 5511 8192000000 10807560336 11228880896 1885772992 18.712 100 23 46 2 1898400576 6487840 6139744
23:11:12 8590 8192000000 10801656848 11231207424 1887214432 18.723 100 23 47 1 1900276064 6269744 6791888
23:11:32 8970 8192000000 10795295232 11232169984 1891317328 18.756 100 26 52 1 1904641008 6256208 7067472
23:11:48 5577 8192000000 10812535104 11238883328 1895409184 18.789 100 40 79 1 1917940000 11905760 10625056
23:12:01 8361 8192000000 10800488272 11238166528 1896466192 18.798 100 27 53 0 1910906240 6879824 7560224
23:12:17 8814 8192000000 10806438224 11241635840 1896343680 18.797 100 23 46 1 1909670304 7029744 6296880
23:12:34 8901 8192000000 10808303936 11243065344 1901435072 18.838 100 37 74 1 1917756336 5310048 11011216
23:12:49 67841 8192000000 10827907808 11254362112 1900443600 18.830 100 22 44 2 1912455008 4880832 7130576
23:14:04 3238 8192000000 10821584064 11254722560 1906814736 18.881 100 46 92 1 1928886224 8818624 13252864
23:14:16 4140 8192000000 10824349008 11255934976 1904784944 18.865 100 22 43 2 1917092624 5963936 6343744
23:14:26 6386 8192000000 10823183024 11258179584 1909246224 18.901 100 31 62 4 1924883504 6390448 9246832
23:14:40 4269 8192000000 10853270720 11269877760 1916233264 18.957 100 61 122 1 1942324688 8580384 17511040
23:14:50 3565 8192000000 10829220176 11259461632 1912101360 18.924 100 29 56 1 1926011440 6094912 7815168
23:15:02 7124 8192000000 10823114528 11259363328 1890893104 18.753 99 32 63 1 1906531344 6883392 8754848
23:15:16 6370 8192000000 10819106144 11256627200 1887216160 18.723 99 34 69 0 1904874112 8346768 9311184
23:15:34 4552 8192000000 10805323664 11242954752 1886401872 18.717 99 32 64 1 1901403408 5659072 9342464
23:15:45 6262 8192000000 10803110320 11245031424 1899007488 18.818 100 25 50 1 1911968384 5846720 7114176
23:16:00 9554 8192000000 10814339808 11250868224 1887030384 18.722 99 22 44 1 1899600784 6765248 5805152
23:16:17 5780 8192000000 10799417072 11236716544 1874656512 18.622 99 24 49 1 1887504400 5594624 7253264
23:16:32 10229 8192000000 10795071584 11235000320 1872368736 18.603 99 20 40 0 1885016896 6716240 5931920
23:16:49 12662 8192000000 10808535872 11231969280 1854136384 18.456 98 31 60 4 1868052912 5228896 8687632
23:17:08 11227 8192000000 10761533888 11177406464 1772420336 17.787 94 21 42 0 1783606928 5015296 6171296
23:17:27 49488 8192000000 10752577600 11183063040 1792938832 17.956 96 31 61 1 1807981488 6290160 8752496
23:18:24 19864 8192000000 10742616496 11163574272 1670654016 16.939 90 19 38 0 1681367088 5293600 5419472
23:18:50 5342 8192000000 10754070112 11173285888 1818947024 18.169 99 40 80 1 1838350944 7791440 11612480
23:19:03 5104 8192000000 10748640928 11169378304 1789583552 17.928 97 33 66 0 1805627200 6753216 9290432
23:19:19 7593 8192000000 10726806912 11149848576 1783746432 17.880 97 24 49 2 1795919712 5552368 6620912
23:19:33 5200 8192000000 10741425184 11165564928 1815673056 18.142 99 36 72 1 1832368064 6481504 10213504
23:19:47 4273 8192000000 10736037920 11147931648 1786345120 17.902 98 34 69 1 1802850592 6368560 10136912
23:19:58 6365 8192000000 10711442080 11124953088 1791577824 17.945 99 34 68 1 1808431616 6896496 9957296
23:20:14 4920 8192000000 10729885424 11157225472 1808609424 18.084 99 24 48 1 1822707648 6497312 7600912
23:20:25 6396 8192000000 10726769584 11151650816 1812557248 18.117 99 31 62 1 1828329776 7035104 8737424
23:20:38 6067 8192000000 10714022768 11129131008 1750637200 17.607 96 27 54 2 1764251376 4904624 8709552
23:20:53 6514 8192000000 10701236896 11124944896 1765787040 17.732 98 21 42 2 1777837120 6004080 6046000
23:21:05 7340 8192000000 10718885664 11140923392 1808401904 18.083 100 19 37 1 1820056432 6128288 5526240
23:21:21 8499 8192000000 10723766000 11134894080 1756704208 17.657 97 25 50 2 1769082832 5186320 7192304
23:21:38 11394 8192000000 10689287168 11111350272 1735564608 17.482 96 17 34 0 1745960816 5389888 5006320
23:21:55 8624 8192000000 10741801520 11154071552 1825708336 18.224 100 44 88 1 1845349712 5995984 13645392
23:22:11 75160 8192000000 10727221504 11150110720 1759478528 17.680 96 27 54 1 1773538128 6431088 7628512
23:23:34 7115 8192000000 10752917200 11173359616 1837484064 18.320 100 43 83 1 1856796912 7277216 12035632
23:23:49 7953 8192000000 10761955280 11179511808 1841756112 18.355 100 40 80 2 1860803344 7984320 11062912
23:24:05 5249 8192000000 10769463888 11187793920 1850787200 18.429 100 41 80 1 1870785536 6757664 13240672
23:24:17 5612 8192000000 10772983872 11191410688 1852260288 18.440 100 43 86 2 1870920064 5595488 13064288
23:24:31 5676 8192000000 10772947776 11191988224 1852391168 18.442 100 31 62 2 1867365520 5956288 9018064
23:24:44 6665 8192000000 10768400432 11192754176 1854579296 18.459 100 26 51 4 1867427968 6034208 6814464
23:24:57 7210 8192000000 10766367888 11200380928 1857479216 18.483 100 21 42 3 1870715600 6549216 6687168
23:25:12 11601 8192000000 10783530336 11207065600 1861828544 18.518 100 19 38 2 1872477840 5494736 5154560
23:25:30 6764 8192000000 10788688496 11212738560 1864429520 18.539 100 23 46 1 1877258000 5569104 7259376
23:25:44 10622 8192000000 10793423872 11214667776 1866213760 18.554 100 19 38 1 1877261888 5578768 5469360
23:26:01 11878 8192000000 10786739104 11218243584 1873292880 18.611 100 16 32 0 1883315296 5531952 4490464
23:26:19 11496 8192000000 10782184576 11218845696 1875755536 18.631 100 23 45 0 1887211360 4672320 6783504
23:26:37 18681 8192000000 10793911728 11223257088 1877199056 18.642 100 19 37 2 1888012336 5229808 5583472
23:27:01 78208 8192000000 10834780816 11256836096 1897672144 18.808 100 38 76 0 1914671536 6146272 10853120
23:28:27 19823 8192000000 10857923104 11277438976 1920515312 18.991 100 54 107 0 1949282832 13671040 15096480
23:28:56 29171 8192000000 10855608880 11277967360 1921906464 19.002 100 53 106 0 1951137136 15068544 14162128
23:29:32 9561 8192000000 10865101824 11286740992 1928107552 19.052 100 55 110 2 1956023584 13135824 14780208
23:29:52 6648 8192000000 10871181808 11292188672 1933095568 19.092 100 54 107 2 1960909872 11892688 15921616
23:30:05 21684 8192000000 10880338416 11304910848 1940145712 19.148 100 50 100 1 1970809904 16982992 13681200
23:30:38 17036 8192000000 10888901360 11310362624 1950124352 19.227 100 54 108 2 1978875104 13325616 15425136
23:31:04 15634 8192000000 10889840960 11316760576 1953845840 19.257 100 52 104 1 1983554320 14890304 14818176
23:31:56 8154 8192000000 10907396336 11333885952 1967868352 19.369 100 57 110 2 1998772512 15380960 15523200
23:32:17 12329 8192000000 10913574352 11342381056 1973471072 19.413 100 52 98 1 2006262016 18334272 14456672
23:32:43 5047 8192000000 10917346736 11348852736 1977717744 19.447 100 49 98 1 2010675856 18643872 14314240
23:32:57 13210 8192000000 10929740080 11356811264 1982940384 19.488 100 69 140 0 2023165456 20361168 19863904
23:33:26 6062 8192000000 10927266432 11357622272 1981744640 19.479 100 53 106 2 2018358048 21144960 15468448
23:33:42 8974 8192000000 10935251168 11359973376 1984391248 19.499 100 61 120 2 2028011808 26696480 16924080
23:34:05 2806 8192000000 10926254416 11357421568 1979135808 19.458 100 53 106 2 2019320320 24726704 15457808
23:34:16 7002 8192000000 10931423408 11362938880 1986626672 19.517 100 57 112 1 2028309616 24874224 16808720
23:34:31 24515 8192000000 10943118192 11377381376 1990539696 19.548 100 46 87 2 2026142960 22565680 13037584
23:35:10 5640 8192000000 10933437696 11364548608 1986370496 19.515 100 53 105 1 2023678224 21811504 15496224
23:35:29 5362 8192000000 10954207440 11370168320 1992626000 19.565 100 63 120 3 2032350992 22680464 17044528
23:35:44 6755 8192000000 10944165440 11373260800 1989905968 19.543 100 61 119 2 2032136544 24746752 17483824
23:35:58 7072 8192000000 10948657360 11376549888 1992379520 19.563 100 61 120 0 2036180000 25666864 18133616
23:36:12 5374 8192000000 10952362464 11381039104 1997492080 19.603 100 60 118 1 2041652464 26049216 18111168
23:36:35 2537 8192000000 10957376192 11388444672 1997187248 19.601 100 52 104 0 2040720832 27473280 16060304
23:36:45 7873 8192000000 10963379520 11394330624 2003018976 19.647 100 53 106 2 2047157904 28540112 15598816
23:37:01 3676 8192000000 10963914256 11394768896 2002287040 19.641 100 61 120 0 2049609232 29292592 18029600
23:37:14 6971 8192000000 10943846864 11371835392 1980388640 19.468 99 60 120 0 2029080272 30723040 17968592
23:37:28 9867 8192000000 10950254464 11379101696 1994328800 19.578 100 61 122 1 2048256208 35197760 18729648
23:37:46 2680 8192000000 10946718128 11371196416 1981749584 19.479 100 66 132 1 2033343008 30864912 20728512
23:37:57 1977 8192000000 10960972608 11380232192 1993320288 19.570 100 77 155 3 2047749808 31326528 23102992
23:38:11 7416 8192000000 10938460528 11371851776 1967879200 19.369 99 59 119 0 2017411632 31837136 17695296
23:38:28 2317 8192000000 10938701600 11348267008 1954524336 19.262 99 79 155 1 2010799776 32519616 23755824
23:38:37 7327 8192000000 10945265552 11366834176 1975515904 19.429 100 77 148 3 2031987952 33684448 22787600
23:38:51 4767 8192000000 10952053008 11380031488 1987783376 19.526 100 75 148 0 2043837024 34139184 21914464
23:39:04 1874 8192000000 10954130320 11369582592 1966936928 19.361 99 77 152 2 2022726464 33156944 22632592
23:39:14 1880 8192000000 10935675584 11343814656 1940638144 19.152 98 89 176 3 2001460512 34338896 26483472
23:39:23 3475 8192000000 10962615680 11376791552 1983278352 19.491 100 82 163 0 2044785168 36360592 25146224
23:39:34 2315 8192000000 10956189136 11372089344 1980659168 19.470 100 77 150 0 2041350400 37356368 23334864
23:39:44 1861 8192000000 10968880880 11388772352 1993172016 19.569 100 79 157 0 2054217920 37204704 23841200
23:39:53 3058 8192000000 10939362208 11343347712 1953058784 19.251 98 79 158 1 2011368944 34715216 23594944
23:40:03 1336 8192000000 10941910480 11353436160 1947345488 19.205 98 82 160 1 2005786384 33622896 24818000
23:40:12 4916 8192000000 10936279392 11347271680 1953940160 19.258 99 79 158 1 2014557296 36533248 24083888
23:40:23 2133 8192000000 10924060208 11335860224 1945922896 19.194 100 78 156 2 2006845440 36485760 24436784
23:40:32 3636 8192000000 10933908784 11347701760 1956414384 19.278 100 81 161 0 2019536080 37924608 25197088
23:40:45 4731 8192000000 10932552192 11346808832 1958132560 19.291 100 78 156 2 2020926192 38951120 23842512
23:40:58 4043 8192000000 10946534176 11363827712 1964790448 19.344 100 80 158 0 2031007280 41291280 24925552
23:41:14 6094 8192000000 10950774496 11376214016 1975098160 19.426 100 61 122 0 2036456928 41689280 19669488
23:41:30 5767 8192000000 10923411120 11346337792 1941312096 19.157 99 72 144 1 2006500928 42331424 22857408
23:41:46 3307 8192000000 10914010752 11332603904 1934066352 19.099 99 66 132 1 1994236224 39568672 20601200
23:42:05 3591 8192000000 10929850768 11341340672 1947669968 19.208 100 71 142 1 2009965472 40576176 21719328
23:42:15 2550 8192000000 10939268880 11359309824 1958226960 19.292 100 75 150 2 2026241328 43768208 24246160
23:42:26 4934 8192000000 10949734064 11371053056 1961963056 19.322 100 70 140 1 2034424464 50038528 22422880
23:42:39 4585 8192000000 10948447216 11368181760 1967529760 19.366 100 69 138 1 2032500896 43552992 21418144
23:42:51 2756 8192000000 10947748288 11373252608 1972396416 19.404 100 72 144 1 2034970608 39913120 22661072
23:43:00 1662 8192000000 10952131696 11369570304 1955901760 19.273 99 76 151 1 2018378672 39233984 23242928
23:43:11 2357 8192000000 10973297312 11383582720 1979544752 19.461 100 88 174 0 2046642944 40612864 26485328
23:43:21 1991 8192000000 10965401808 11375824896 1978989584 19.457 100 90 181 1 2048012208 40752992 28269632
23:43:30 1959 8192000000 10964634416 11374194688 1974837424 19.424 100 83 167 3 2040583024 40620240 25125360
23:43:41 2848 8192000000 10950923584 11372556288 1956449136 19.278 99 64 122 2 2014884016 40229904 18204976
23:43:52 10533 8192000000 10952702192 11381633024 1979893184 19.464 100 68 136 1 2044243296 44042736 20307376
23:44:13 3105 8192000000 10949564944 11368620032 1964621728 19.343 100 77 151 0 2032729008 44653344 23453936
23:44:23 8142 8192000000 10963932496 11381948416 1961743504 19.320 99 76 151 3 2031945776 46383552 23818720
23:44:39 6155 8192000000 10976031312 11385319424 1974083152 19.418 100 78 154 1 2044267584 45931232 24253200
23:44:54 2109 8192000000 10986247216 11406286848 1991250144 19.554 100 81 162 1 2066177376 49885424 25041808
23:45:05 6028 8192000000 10977483008 11402027008 1991790592 19.558 100 77 152 0 2064192080 48885840 23515648
23:45:17 2333 8192000000 10973646784 11383377920 1955176352 19.268 98 84 168 2 2031504432 49744880 26583200
23:45:26 1832 8192000000 10983120672 11397812224 1991850240 19.558 100 91 181 1 2063453744 44458912 27144592
23:45:35 2100 8192000000 10992806640 11408269312 1997518432 19.603 100 88 173 2 2071370576 47395952 26456192
23:45:45 2618 8192000000 10984591152 11409334272 1999271120 19.617 100 79 156 0 2070558304 47518800 23768384
23:45:54 9496 8192000000 10969195920 11400347648 1974594080 19.422 99 65 129 0 2040822240 46619824 19608336
23:46:10 9974 8192000000 10938730544 11380031488 1964153760 19.339 99 39 78 1 2024061408 47307728 12599920
23:46:27 9593 8192000000 10934902304 11378073600 1961367680 19.317 100 29 58 1 2015126160 44036592 9721888
23:46:43 17585 8192000000 10910003104 11349774336 1903489904 18.854 97 41 82 0 1961458304 44103920 13864480
23:47:10 14117 8192000000 10929544432 11363647488 1939288672 19.141 99 33 66 0 1995717888 44766000 11663216
23:47:35 5771 8192000000 10968339104 11383152640 1973359824 19.412 100 65 128 5 2038827920 45612048 19856048
23:47:50 1858 8192000000 10990941328 11406405632 1986960784 19.520 100 86 172 1 2066950800 53101920 26888096
23:47:58 6654 8192000000 10961120144 11405074432 1981782672 19.479 100 52 104 0 2053411776 55108032 16521072
23:48:17 12269 8192000000 10952040352 11388203008 1974652560 19.422 100 35 70 1 2029251168 42656832 11941776
23:48:42 11664 8192000000 10943615296 11384963072 1956699552 19.280 99 33 67 1 2012853008 44758912 11394544
23:49:09 8019 8192000000 10939920160 11379437568 1956480048 19.278 99 44 88 0 2020563744 48589648 15494048
23:49:32 6937 8192000000 10955925840 11387953152 1972328928 19.404 100 55 108 0 2039652096 49767952 17555216
23:49:50 11936 8192000000 10959373136 11397734400 1970150432 19.387 100 55 111 0 2041991808 53292432 18548944
23:50:08 7805 8192000000 10962118896 11404926976 1974615888 19.422 100 48 96 3 2048649888 57993040 16040960
23:50:26 22614 8192000000 10928176432 11383963648 1956488272 19.278 99 23 46 1 2021586064 56983264 8114528
23:50:56 30541 8192000000 10940482928 11399913472 1974951616 19.425 100 32 64 1 2037054176 50613312 11489248
23:51:56 20706 8192000000 10929231136 11392434176 1974329600 19.420 100 29 58 0 2026908720 43219264 9359856
23:52:30 34616 8192000000 10937323840 11407339520 1975333888 19.428 100 24 48 1 2019690672 36656336 7700448
23:53:11 39746 8192000000 10929642048 11405606912 1969590832 19.382 100 17 34 1 2017763600 41945168 6227600
23:53:58 23600 8192000000 10933177136 11419254784 1969184288 19.379 100 19 38 0 2025635616 49888240 6563088
23:54:43 37248 8192000000 10881334496 11356221440 1911720224 18.920 98 8 16 0 1941657232 27378448 2558560
23:55:31 52386 8192000000 10863858224 11308949504 1855976704 18.471 95 16 31 1 1874914576 14782384 4155488
23:56:38 57068 8192000000 10887220688 11335516160 1936073984 19.115 100 25 50 5 1958411840 15076096 7261760
23:57:42 78386 8192000000 10879932000 11336237056 1906234800 18.876 98 8 15 0 1924583440 16222688 2125952
23:59:07 82865 8192000000 10892882704 11343507456 1904678144 18.864 98 21 42 2 1923085392 13197088 5210160
00:00:44 58720 8192000000 10894200192 11363733504 1955955872 19.274 100 18 36 0 1976324720 14593296 5775552
00:02:26 51859 8192000000 10896202896 11347324928 1905894224 18.874 97 17 33 0 1921767904 11290880 4582800
00:03:27 133019 8192000000 10887308720 11340337152 1942983456 19.171 99 16 33 0 1969824000 22036912 4803632
00:05:53 51870 8192000000 10892840400 11340869632 1947325712 19.205 99 31 60 2 1963462704 7474736 8662256
00:06:59 13644 8192000000 10933451056 11365150720 1976434240 19.436 100 75 150 0 2010655472 12542560 21678672
00:07:20 27813 8192000000 10901658000 11366043648 1975092512 19.426 100 51 102 0 2003552496 14373536 14086448
00:07:54 26082 8192000000 10926239456 11371098112 1958102272 19.291 99 36 72 2 1976762464 9060080 9600112
00:08:36 16246 8192000000 10897457616 11363438592 1960939888 19.314 99 46 91 1 1985171424 11063088 13168448
00:09:09 51686 8192000000 10912760208 11360841728 1939457840 19.142 98 34 66 1 1955478928 6754064 9267024
00:10:10 89122 8192000000 10900691440 11375353856 1954647088 19.263 99 19 38 2 1973178832 13358832 5172912
00:11:55 56531 8192000000 10881156496 11346448384 1917117200 18.964 97 22 44 3 1932005712 8380896 6507616
00:13:06 61181 8192000000 10893819184 11366076416 1955054816 19.267 99 17 34 0 1971282736 11586416 4641504
00:14:16 81340 8192000000 10908802656 11391148032 1980086576 19.465 100 14 28 0 1997365040 13119136 4159328
00:17:08 85504 8192000000 10890197824 11384815616 1966885520 19.361 99 19 38 1 1984697296 12291488 5520288
00:18:40 24151 8192000000 10894667552 11384770560 1974520352 19.421 100 8 16 0 1987771632 10888704 2362576
00:19:11 664 8192000000 10898250752 11386667008 1977399072 19.444 100 16 32 0 1992721744 10477536 4845136
00:19:18 23456 8192000000 10930108592 11396956160 1991188592 19.553 100 24 48 0 2010867984 12901168 6778224
00:19:53 70631 8192000000 10905367664 11388125184 1955444272 19.270 98 13 26 0 1976236016 17359104 3432640
00:21:10 61098 8192000000 10896219024 11383660544 1960025360 19.306 99 4 8 0 1975161024 13808224 1327440
00:22:17 62166 8192000000 10882405968 11356790784 1903818160 18.857 96 14 28 0 1915483008 7831200 3833648
00:23:25 42800 8192000000 10869401104 11336638464 1867872624 18.567 95 24 49 1 1883415360 9031264 6511472
00:24:17 24334 8192000000 10884343456 11342180352 1935260592 19.109 99 36 72 1 1964054640 18523328 10270720
00:24:54 34726 8192000000 10876453248 11322445824 1866318000 18.554 96 36 72 0 1889215456 12338048 10559408
00:25:42 68142 8192000000 10843303680 11312791552 1861630688 18.516 96 26 52 1 1883360096 14398320 7331088
00:26:57 54767 8192000000 10838939632 11301986304 1851885440 18.437 96 19 38 0 1865212608 8484272 4842896
00:27:58 18787 8192000000 10883439232 11320229888 1918203440 18.972 99 49 95 3 1938124688 7515344 12405904
00:28:24 13906 8192000000 10893284896 11336380416 1946243024 19.197 100 55 108 0 1971260032 10302896 14714112
00:28:45 53132 8192000000 10883386656 11351801856 1920348432 18.990 98 31 62 0 1944320656 15183008 8789216
00:29:45 59647 8192000000 10865939616 11339194368 1852015712 18.438 95 14 28 2 1877289344 21362016 3911616
00:31:02 44786 8192000000 10870895248 11348549632 1934081648 19.100 100 9 18 1 1952125392 15093328 2950416
00:32:06 72005 8192000000 10875946992 11346214912 1861150592 18.513 95 15 30 0 1879479408 14060240 4268576
00:33:54 26648 8192000000 10891022672 11340034048 1914875424 18.946 98 26 52 1 1929733568 7725664 7132480
00:34:29 72599 8192000000 10867439456 11332853760 1879139760 18.658 96 35 70 2 1902265952 13666080 9460112
00:35:55 15031 8192000000 10896710096 11349331968 1943286416 19.173 100 29 58 2 1960881792 9461456 8133920
00:36:18 77828 8192000000 10898548048 11362967552 1933127904 19.092 99 26 52 0 1957771872 17849056 6794912
00:37:43 121505 8192000000 10848048112 11301814272 1892302768 18.764 97 29 58 1 1911978768 11358704 8317296
00:39:55 24828 8192000000 10866512080 11312992256 1870487920 18.588 96 42 84 0 1890672576 9002416 11182240
00:40:29 32214 8192000000 10860995056 11312316416 1877380976 18.644 97 45 88 2 1903416912 14028352 12007584
00:41:08 22906 8192000000 10855533808 11311734784 1919880176 18.986 100 34 68 2 1943285904 13980640 9425088
00:41:40 2172 8192000000 10855739104 11310718976 1907228672 18.884 99 32 64 0 1929478128 12644064 9605392
00:41:54 39847 8192000000 10854584512 11313397760 1897231568 18.804 98 32 64 1 1920508384 14204656 9072160
00:42:55 63999 8192000000 10844452224 11325771776 1884148944 18.699 98 12 24 1 1909838064 22224832 3464288
00:44:05 22945 8192000000 10844385888 11334520832 1906869040 18.882 100 7 14 0 1936635568 28056560 1709968
00:44:35 11365 8192000000 10852702064 11336646656 1921723408 19.001 100 10 20 2 1945181984 20818704 2639872
00:44:53 20655 8192000000 10851939680 11335467008 1928510704 19.055 100 4 8 1 1948719952 19363584 845664
00:45:41 97041 8192000000 10857540912 11333660672 1921655568 19.000 99 20 40 0 1935579072 8205872 5717632
00:47:29 67080 8192000000 10867607808 11338452992 1903167312 18.852 98 12 24 0 1919509760 13013872 3328576
00:48:53 64045 8192000000 10855713584 11347472384 1934449632 19.102 100 16 32 1 1951529360 11853088 5226640
00:50:07 45932 8192000000 10850850688 11321581568 1880974048 18.673 97 14 28 1 1894981200 10615888 3391264
00:51:00 102829 8192000000 10850137264 11323518976 1900741648 18.832 98 18 36 1 1917232576 11956944 4533984
00:52:58 36616 8192000000 10856068480 11323965440 1922992144 19.011 99 16 31 1 1938796208 11077808 4726256
00:53:41 48250 8192000000 10893059520 11356102656 1942364416 19.166 99 32 64 4 1967030160 14996128 9669616
00:55:08 79183 8192000000 10865662496 11347660800 1892244704 18.764 97 16 32 0 1914724144 18022768 4456672
00:56:34 77622 8192000000 10889627744 11348013056 1898975776 18.818 97 26 52 1 1925093376 18541328 7576272
00:58:00 75284 8192000000 10894184032 11362865152 1922982464 19.011 98 19 38 0 1941062544 12859584 5220496
00:59:33 105245 8192000000 10908173024 11368013824 1913173760 18.932 97 21 40 1 1941398176 23019680 5204736
01:01:26 11336 8192000000 10897528368 11337740288 1918158832 18.972 97 51 102 0 1943215408 9879936 15176640
01:01:49 58926 8192000000 10883757424 11357147136 1910942848 18.914 98 25 47 1 1930471936 12717712 6811376
01:02:54 59321 8192000000 10891550640 11345223680 1903515968 18.855 97 25 50 0 1921078448 10670592 6891888
01:04:00 121291 8192000000 10886764688 11351343104 1907141712 18.884 97 39 78 0 1926628144 8754288 10732144
01:06:13 49326 8192000000 10881939968 11351240704 1944447360 19.182 99 27 53 4 1962624064 10590880 7585824
01:08:30 42135 8192000000 10880236336 11356962816 1957980784 19.290 100 7 14 1 1970085072 10100704 2003584
01:09:18 61013 8192000000 10885637552 11362250752 1950067696 19.227 99 13 26 1 1965234512 11295520 3871296
01:10:27 42538 8192000000 10887385088 11352932352 1940040048 19.147 99 18 36 3 1957851952 12294400 5517504
01:11:30 86685 8192000000 10879135600 11369349120 1921313888 18.997 98 10 20 0 1940799392 16315312 3170192
01:13:12 71888 8192000000 10887394416 11355373568 1922320016 19.005 98 10 20 1 1939228464 13930320 2978128
01:14:38 63091 8192000000 10889844208 11358269440 1923736752 19.017 98 11 22 0 1942597296 16076704 2783840
01:15:47 39942 8192000000 10886427072 11354820608 1907972832 18.890 97 35 70 0 1934142096 15715536 10453728
01:16:42 67820 8192000000 10877092464 11338682368 1873214240 18.610 96 27 53 1 1895838608 14909952 7714416
01:17:56 57822 8192000000 10877680912 11322171392 1839642320 18.338 95 27 54 0 1859700384 12678544 7379520
01:19:03 40090 8192000000 10847771440 11309506560 1858930976 18.495 96 35 70 3 1881455696 12484944 10039776
01:19:54 93305 8192000000 10869412048 11331227648 1867392864 18.563 97 14 28 0 1886858112 15644256 3820992
01:21:41 87271 8192000000 10861535696 11343646720 1916560912 18.959 99 9 18 1 1943055456 23894272 2600272
01:23:15 62334 8192000000 10879067584 11341611008 1905791696 18.873 98 17 34 1 1919788960 9104736 4892528
01:24:24 102714 8192000000 10857611120 11341430784 1884541200 18.702 97 14 28 1 1903169056 14694160 3933696
01:26:29 47098 8192000000 9385992752 9674731520 510640512 5.867 27 3 6 0 518846928 7460544 745872

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 30-12-2020 01:28:54 to 30-12-2020 01:29:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 155 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 30-12-2020 01:29:27 to 30-12-2020 01:29:28.

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          245317
MON$OLDEST_ACTIVE               245318
MON$OLDEST_SNAPSHOT             245318
MON$NEXT_TRANSACTION            245318
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                       2042720
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 ---
:93: 
:94: mscs-test-161.budzdorov.ru    Wed Dec 30 01:27:23 2020
:95:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:96: 
:97: 
:98: mscs-test-161.budzdorov.ru    Wed Dec 30 01:27:24 2020
:99:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:100: 
:101: 
:102: mscs-test-161.budzdorov.ru    Wed Dec 30 01:27:24 2020
:103:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:104: 
--- end of diff output ---

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

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