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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17281616 kB
MemAvailable 31478380 kB
Buffers 0 kB
Cached 14376284 kB
SwapCached 3696 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-19 16:27:08
DTS_END                         2020-12-19 16:27:08.0700
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/41140
TRN_ID                          255908
ATT_ID                          755
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: 9882.46 20688 1185895
customer order: creation 181.88 304 21826
customer order: refuse 15.74 250 1889
order to supplier: creation 49.55 1063 5946
order to supplier: removal 3.84 78999 461
invoice (draft): creation 48.93 2739 5871
invoice (draft): removal 56.54 664 6785
invoice accept: apply 44.85 14905 5382
invoice accept: cancel 51.57 649 6188
customer reserve: creation 4097.37 149 491684
customer reserve: removal 5013.56 46 601627
realization accept: apply 89.23 132 10707
realization accept: cancel 89.49 92 10739
payment from customer: creation 63.64 89 7637
payment from customer: removal 6.18 51 742
payment to supplier: creation 53.28 95 6394
payment to supplier: removal 4.13 54 496
service: total inventory turnovers 4.98 1057 598
service: total monetary turnovers 6.62 30 794
service: aggregate perf. data 1.04 16169 125
service: refresh index statistics 0.03 296213 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-12-2020 16:28:00 to 19-12-2020 16:28:02.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4894
TEST_TIME 2 5783
TEST_TIME 3 5712
TEST_TIME 4 5366
TEST_TIME 5 6099
TEST_TIME 6 6021
TEST_TIME 7 5941
TEST_TIME 8 6305
TEST_TIME 9 7549
TEST_TIME 10 8073
TEST_TIME 11 8327
TEST_TIME 12 8554
TEST_TIME 13 8608
TEST_TIME 14 9041
TEST_TIME 15 9355
TEST_TIME 16 9692
TEST_TIME 17 9472
TEST_TIME 18 9783
TEST_TIME 19 9989
TEST_TIME 20 11224
TEST_TIME 21 11680
TEST_TIME 22 12528
TEST_TIME 23 12622
TEST_TIME 24 12451
TEST_TIME 25 12445
TEST_TIME 26 12258
TEST_TIME 27 12148
TEST_TIME 28 11947
TEST_TIME 29 12069
TEST_TIME 30 12084
TEST_TIME 31 12094
TEST_TIME 32 11749
TEST_TIME 33 11442
TEST_TIME 34 11312
TEST_TIME 35 11423
TEST_TIME 36 11215
TEST_TIME 37 11325
TEST_TIME 38 11346
TEST_TIME 39 11206
TEST_TIME 40 11146
TEST_TIME 41 11071
TEST_TIME 42 10922
TEST_TIME 43 10760
TEST_TIME 44 10657
TEST_TIME 45 10825
TEST_TIME 46 10697
TEST_TIME 47 10567
TEST_TIME 48 10557
TEST_TIME 49 10487
TEST_TIME 50 10541
TEST_TIME 51 10562
TEST_TIME 52 10554
TEST_TIME 53 10570
TEST_TIME 54 10622
TEST_TIME 55 10619
TEST_TIME 56 10578
TEST_TIME 57 10645
TEST_TIME 58 10643
TEST_TIME 59 10616
TEST_TIME 60 10725
TEST_TIME 61 10639
TEST_TIME 62 10521
TEST_TIME 63 10496
TEST_TIME 64 10451
TEST_TIME 65 10419
TEST_TIME 66 10343
TEST_TIME 67 10285
TEST_TIME 68 10209
TEST_TIME 69 10216
TEST_TIME 70 10161
TEST_TIME 71 10149
TEST_TIME 72 10200
TEST_TIME 73 10198
TEST_TIME 74 10173
TEST_TIME 75 10208
TEST_TIME 76 10194
TEST_TIME 77 10307
TEST_TIME 78 10292
TEST_TIME 79 10365
TEST_TIME 80 10417
TEST_TIME 81 10381
TEST_TIME 82 10272
TEST_TIME 83 10254
TEST_TIME 84 10223
TEST_TIME 85 10147
TEST_TIME 86 10121
TEST_TIME 87 10088
TEST_TIME 88 10069
TEST_TIME 89 10067
TEST_TIME 90 10109
TEST_TIME 91 10118
TEST_TIME 92 10125
TEST_TIME 93 10098
TEST_TIME 94 10164
TEST_TIME 95 10198
TEST_TIME 96 10163
TEST_TIME 97 10170
TEST_TIME 98 10125
TEST_TIME 99 10126
TEST_TIME 100 10282
TEST_TIME 101 10250
TEST_TIME 102 10159
TEST_TIME 103 10110
TEST_TIME 104 10070
TEST_TIME 105 10017
TEST_TIME 106 9991
TEST_TIME 107 10001
TEST_TIME 108 9965
TEST_TIME 109 9925
TEST_TIME 110 9956
TEST_TIME 111 9930
TEST_TIME 112 9949
TEST_TIME 113 9915
TEST_TIME 114 9973
TEST_TIME 115 9944
TEST_TIME 116 9925
TEST_TIME 117 9939
TEST_TIME 118 9936
TEST_TIME 119 9963
TEST_TIME 120 9886

Performance per minute, chart


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

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 1641802 1641802 0 0.00 0 17350 5 0 0
doc_list_biud 1641801 1641801 0 0.00 0 25002 22 0 0
sp_add_invoice_to_stock 5553 5382 171 3.07 41 176838 14905 0 171
sp_cancel_adding_invoice 6188 6188 0 0.00 3 65219 650 0 0
sp_cancel_client_order 1889 1889 0 0.00 4 12835 250 0 0
sp_cancel_customer_reserve 601627 601627 0 0.00 1 18173 47 0 0
sp_cancel_pay_from_customer 742 742 0 0.00 3 3774 52 0 0
sp_cancel_pay_to_supplier 496 496 0 0.00 2 2584 55 0 0
sp_cancel_supplier_invoice 6800 6785 15 0.22 2 25018 664 0 15
sp_cancel_supplier_order 461 461 0 0.00 7 771847 79000 0 0
sp_cancel_write_off 10739 10739 0 0.00 1 15650 93 0 0
sp_client_order 21826 21826 0 0.00 3 25765 305 0 0
sp_customer_reserve 491684 491684 0 0.00 0 79041 150 0 0
sp_fill_shopping_cart 33641 33641 0 0.00 1 17488 33 0 0
sp_fill_shopping_cart_clo_res 491682 491682 0 0.00 0 21426 12 0 0
sp_get_clo_for_invoice 5380 5380 0 0.00 0 28231 238 0 0
sp_kill_cost_storno 18165 18165 0 0.00 0 17342 44 0 0
sp_kill_qstorno_ret_qs2qd 1221239 1221239 0 0.00 0 24989 26 0 0
sp_kill_qty_storno 643775 643775 0 0.00 0 24996 55 0 0
sp_lock_selected_doc 22336 22336 0 0.00 0 4822 4 0 0
sp_make_cost_storno 30118 30118 0 0.00 0 12689 40 0 0
sp_multiply_rows_for_pdistr 30117 30117 0 0.00 0 6651 20 0 0
sp_multiply_rows_for_qdistr 21826 21826 0 0.00 0 11007 150 0 0
sp_pay_from_customer 7637 7637 0 0.00 4 9577 90 0 0
sp_pay_to_supplier 6394 6394 0 0.00 4 19669 96 0 0
sp_payment_common 14031 14031 0 0.00 1 19657 25 0 0
sp_qd_handle_on_cancel_clo 1889 1889 0 0.00 0 12825 231 0 0
sp_qd_handle_on_invoice_upd_sts 11567 11567 0 0.00 0 22468 263 0 0
sp_qd_handle_on_reserve_upd_sts 10707 10707 0 0.00 0 16648 47 0 0
sp_reserve_write_off 10707 10707 0 0.00 6 16705 132 0 0
sp_supplier_invoice 5871 5871 0 0.00 6 73892 2740 0 0
sp_supplier_order 5946 5946 0 0.00 4 30323 1064 0 0
srv_aggregate_perf_data 125 125 0 0.00 2058 125011 16169 0 0
srv_fill_mon_cache_memory 152 152 0 0.00 1277 131809 36201 0 0
srv_find_qd_qs_mism 1135155 1135155 0 0.00 0 11461 4 0 0
srv_make_invnt_saldo 598 598 0 0.00 34 69637 1057 0 0
srv_make_money_saldo 794 794 0 0.00 1 7794 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 159390 405985 296213 0 0
t$perf-abend:sp_add_invoice_to_stock 171 171 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5384 5384 0 0.00 0 9500 128 0 0
t$perf-norm:sp_cancel_adding_invoice 479 479 0 0.00 0 3428 71 0 0
t$perf-norm:sp_cancel_client_order 1889 1889 0 0.00 0 4448 14 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 1990 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 742 742 0 0.00 0 7950 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 496 496 0 0.00 0 808 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 379 379 0 0.00 0 488 10 0 0
t$perf-norm:sp_cancel_supplier_order 461 461 0 0.00 0 30360 1557 0 0
t$perf-norm:sp_cancel_write_off 1073 1073 0 0.00 0 17295 25 0 0
t$perf-norm:sp_client_order 21826 21826 0 0.00 0 10769 15 0 0
t$perf-norm:sp_customer_reserve 1083 1083 0 0.00 0 1120 7 0 0
t$perf-norm:sp_pay_from_customer 7637 7637 0 0.00 0 8628 8 0 0
t$perf-norm:sp_pay_to_supplier 6394 6394 0 0.00 0 5988 11 0 0
t$perf-norm:sp_reserve_write_off 10707 10707 0 0.00 0 7287 12 0 0
t$perf-norm:sp_supplier_invoice 5871 5871 0 0.00 0 6203 16 0 0
t$perf-norm:sp_supplier_order 5946 5946 0 0.00 0 3049 11 0 0
t$perf-norm:srv_aggregate_perf_data 125 125 0 0.00 0 809 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 65 1 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 1709 16 0 0
t$perf-norm:srv_make_money_saldo 794 794 0 0.00 0 1546 10 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 11100 10758 342 3.08 0 5395 17 0 342
v_all_customers 39730 39730 0 0.00 0 15 0 0 0
v_all_suppliers 32776 32776 0 0.00 0 27 1 0 0
v_all_wares 43650 43650 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 958 958 0 0.00 0 6882 15 0 0
v_cancel_client_order 3778 3778 0 0.00 0 3106 4 0 0
v_cancel_customer_prepayment 1484 1484 0 0.00 0 3741 8 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 238 2 0 0
v_cancel_payment_to_supplier 992 992 0 0.00 0 1348 7 0 0
v_cancel_supplier_invoice 788 758 30 3.80 0 1097 15 0 30
v_cancel_supplier_order 922 922 0 0.00 0 7013 15 0 0
v_cancel_write_off 2146 2146 0 0.00 0 1766 11 0 0
v_max_id_clo_ord 5946 5946 0 0.00 0 1695 1 0 0
v_max_id_clo_res 1083 1083 0 0.00 0 3573 10 0 0
v_max_id_ord_sup 5870 5870 0 0.00 0 4738 3 0 0
v_max_non_paid_invoice 1822 1822 0 0.00 0 823 3 0 0
v_max_non_paid_realizn 4124 4124 0 0.00 0 932 3 0 0
v_min_id_clo_ord 5946 5946 0 0.00 0 4539 5 0 0
v_min_id_clo_res 1083 1083 0 0.00 0 3610 10 0 0
v_min_id_ord_sup 5870 5870 0 0.00 0 6066 6 0 0
v_min_non_paid_invoice 6394 6394 0 0.00 0 19653 19 0 0
v_min_non_paid_realizn 7637 7637 0 0.00 0 6903 15 0 0
v_our_firm 10946 10946 0 0.00 0 14 1 0 0
v_reserve_write_off 21414 21414 0 0.00 0 6554 4 0 0
x_lock_depdocs_on_canc_invoice 12594 12594 0 0.00 0 15873 98 0 0
x_lock_depdocs_on_canc_sup_ord 461 461 0 0.00 0 14197 313 0 0
x_make_qstorno_1000_1200 5946 5946 0 0.00 1 30312 997 0 0
x_make_qstorno_1200_2000 5871 5871 0 0.00 3 73879 2625 0 0
x_make_qstorno_2100_3300 491684 491684 0 0.00 0 79037 136 0 0

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

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
13:57:11 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:18 19360 8192000000 10255475360 10560462848 1017616416 11.049 79 61 122 1 1040620416 3010352 19993648
13:57:45 16869 8192000000 10329176736 10645303296 1382138368 14.436 100 87 174 0 1415128992 4752160 28238464
13:58:12 23655 8192000000 10368844000 10687410176 1408616432 14.672 100 86 172 0 1442502720 6073408 27812880
13:58:46 24937 8192000000 10388043040 10713006080 1441254064 14.961 100 88 176 0 1477186832 6989664 28943104
13:59:21 28958 8192000000 10424970704 10753114112 1469364944 15.208 100 91 182 0 1506144384 7681568 29097872
13:59:59 25254 8192000000 10450174752 10783211520 1497371040 15.453 100 91 182 0 1535097328 8744176 28982112
14:00:33 11487 8192000000 10470191104 10803961856 1516585008 15.621 100 92 184 1 1554783216 8999104 29199104
14:00:55 25985 8192000000 10499196016 10841501696 1535363088 15.783 100 89 178 1 1573385072 9475472 28546512
14:01:30 9411 8192000000 10499737808 10847662080 1557853616 15.978 100 79 158 0 1592380288 10271616 24255056
14:01:52 9737 8192000000 10521356064 10876956672 1585592528 16.216 100 78 156 0 1619173120 10135472 23445120
14:02:14 16658 8192000000 10581311744 10937987072 1629347488 16.589 100 82 165 0 1664615792 10930000 24338304
14:02:40 7654 8192000000 10591880176 10953080832 1649266448 16.758 100 80 160 0 1684785328 11886832 23632048
14:02:56 11684 8192000000 10620004848 10983788544 1669016784 16.925 100 85 170 2 1706724096 12887520 24819792
14:03:14 8447 8192000000 10627499328 10994196480 1684346800 17.054 100 78 156 5 1720236960 13161056 22729104
14:03:31 11624 8192000000 10645768720 11018158080 1708507344 17.256 100 81 162 0 1745919440 13541360 23870736
14:03:50 8412 8192000000 10658581584 11036262400 1718286064 17.338 100 78 156 1 1754163792 13378000 22499728
14:04:06 6103 8192000000 10663316240 11039346688 1728147904 17.420 100 78 156 2 1763996032 13347312 22500816
14:04:20 5015 8192000000 10665491456 11047931904 1734856288 17.476 100 77 152 1 1770574592 13502992 22215312
14:04:33 4990 8192000000 10686848304 11064205312 1747599232 17.582 100 76 152 1 1782922032 13751328 21571472
14:04:44 3001 8192000000 10685849280 11068624896 1757079280 17.660 100 72 144 1 1790236544 13164272 19992992
14:04:54 3884 8192000000 10712434528 11094028288 1771135536 17.776 100 74 148 1 1804896688 12842544 20918608
14:05:05 9387 8192000000 10709497968 11095490560 1780010672 17.850 100 78 156 0 1815370720 13895984 21464064
14:05:21 3819 8192000000 10735818864 11121229824 1793705600 17.962 100 83 166 2 1829549872 13057536 22786736
14:05:32 2803 8192000000 10742323088 11130667008 1801856576 18.029 100 82 164 1 1839071824 13817424 23397824
14:05:41 3384 8192000000 10755041936 11143548928 1815679904 18.142 100 85 170 1 1851971184 12577568 23713712
14:05:52 2460 8192000000 10766005168 11155722240 1826185088 18.228 100 80 158 2 1860384032 12340096 21858848
14:06:01 2393 8192000000 10769566128 11159330816 1835538224 18.304 100 88 179 0 1872775712 11748352 25489136
14:06:10 2276 8192000000 10782281200 11169341440 1844746448 18.379 100 88 178 3 1881075824 11899040 24430336
14:06:19 2096 8192000000 10787774736 11175903232 1847794112 18.404 100 93 186 0 1887316800 13667120 25855568
14:06:27 1578 8192000000 10791556240 11178975232 1850422352 18.426 100 86 170 1 1886978144 12664592 23891200
14:06:35 1942 8192000000 10800245360 11188006912 1855634736 18.468 100 91 182 1 1895301280 14058144 25608400
14:06:44 1635 8192000000 10803599232 11191463936 1861257632 18.513 100 97 194 0 1903146240 14432304 27456304
14:06:52 1436 8192000000 10809907360 11196600320 1866073824 18.552 100 93 188 1 1905714480 13604512 26036144
14:07:00 1974 8192000000 10812799840 11202371584 1864520848 18.540 100 92 181 1 1902990512 13184352 25285312
14:07:08 1352 8192000000 10813384176 11202461696 1870743216 18.590 100 95 193 0 1911189584 13511904 26934464
14:07:16 4888 8192000000 10817018608 11202662400 1867054512 18.560 100 84 169 0 1902416944 12309168 23053264
14:07:27 5436 8192000000 10777712480 11189858304 1859974688 18.503 100 45 90 0 1883776576 11735440 12066448
14:07:40 3076 8192000000 10798032416 11202809856 1868515632 18.572 100 59 119 0 1895328416 10241072 16571712
14:07:50 3624 8192000000 10793193104 11197726720 1864659344 18.541 100 41 83 1 1885645344 9596016 11389984
14:08:00 5536 8192000000 10777423584 11195863040 1864593088 18.541 100 35 70 2 1883496048 8941424 9961536
14:08:15 5468 8192000000 10780906656 11197030400 1864681904 18.541 100 28 56 1 1879746752 7267568 7797280
14:08:27 5769 8192000000 10771718880 11197288448 1866022144 18.552 100 35 66 3 1884250272 8575024 9653104
14:08:41 8125 8192000000 10770289856 11198988288 1866108544 18.553 100 20 40 1 1878394016 6957600 5327872
14:08:59 13809 8192000000 10778591840 11204513792 1871153744 18.594 100 15 30 4 1880706688 5239648 4313296
14:09:21 23651 8192000000 10784414560 11214614528 1878696576 18.655 100 24 48 1 1891017120 5102304 7218240
14:09:50 66146 8192000000 10789238864 11219447808 1880621840 18.670 100 38 76 2 1897376624 5493872 11260912
14:11:04 7592 8192000000 10790457792 11220692992 1876322752 18.635 100 25 51 1 1889140224 6033840 6783632
14:11:22 6055 8192000000 10786814256 11225845760 1883680208 18.695 100 27 53 1 1897560368 6184224 7695936
14:11:34 6468 8192000000 10808186304 11233542144 1886112608 18.714 100 24 48 3 1899273776 6772976 6388192
14:11:47 7074 8192000000 10799932144 11231625216 1886980240 18.721 100 22 44 1 1899359008 5814896 6563872
14:12:00 15713 8192000000 10808994496 11238137856 1888980704 18.738 100 18 36 0 1903706944 9520992 5205248
14:12:24 7650 8192000000 10804371168 11238793216 1888480752 18.734 100 8 16 0 1896121312 5304496 2336064
14:12:37 5280 8192000000 10801449680 11239944192 1894220048 18.780 100 17 34 2 1904940912 6012576 4708288
14:12:49 6956 8192000000 10808104112 11244048384 1897785792 18.808 100 24 48 2 1911229584 6946848 6496944
14:13:02 6326 8192000000 10817876928 11246952448 1898829744 18.817 100 27 54 0 1913153888 6040608 8283536
14:13:14 9941 8192000000 10807150032 11243442176 1898205680 18.812 100 16 33 1 1908396768 5342224 4848864
14:13:30 18160 8192000000 10803698672 11241582592 1878729232 18.655 99 10 20 0 1887101296 5811296 2560768
14:13:58 9589 8192000000 10819017856 11253678080 1901124800 18.835 100 18 36 1 1911460752 5295552 5040400
14:14:16 15212 8192000000 10806924736 11225530368 1870393376 18.587 98 28 56 0 1883575152 4776464 8405312
14:14:42 65139 8192000000 10799197024 11236642816 1880648544 18.670 99 26 52 0 1893854080 5221344 7984192
14:15:55 8198 8192000000 10799908288 11235135488 1875298352 18.627 99 18 36 0 1886541520 5704864 5538304
14:16:11 7007 8192000000 10784039200 11210346496 1848918128 18.413 98 26 52 0 1861850000 5630544 7301328
14:16:25 4711 8192000000 10804316048 11225489408 1880253184 18.667 100 36 73 2 1897376272 6450464 10672624
14:16:36 6637 8192000000 10787042336 11213447168 1832510096 18.280 97 34 68 2 1848379952 6349920 9519936
14:16:49 6461 8192000000 10783421008 11208278016 1836703360 18.314 98 31 60 1 1851253584 5738576 8811648
14:17:05 11525 8192000000 10737384336 11163033600 1769598496 17.764 95 20 40 1 1780905136 5486176 5820464
14:17:23 12803 8192000000 10748593360 11169447936 1772972672 17.792 96 30 59 4 1786310112 5154432 8183008
14:17:44 6137 8192000000 10744062688 11168219136 1805399472 18.058 98 19 38 0 1816915824 6084432 5431920
14:18:00 13298 8192000000 10731286640 11156070400 1747813760 17.583 95 18 35 5 1758466336 5212288 5440288
14:18:21 11029 8192000000 10701227248 11116548096 1676161040 16.985 92 17 34 2 1685953952 4547472 5245440
14:18:40 6928 8192000000 10691629824 11105021952 1720388912 17.355 96 29 58 2 1734682592 5469984 8823696
14:18:57 10593 8192000000 10707697104 11130179584 1766046896 17.734 98 18 35 2 1784791984 13587952 5157136
14:19:13 8174 8192000000 10706102624 11122974720 1748271024 17.587 97 20 40 2 1759176576 4941424 5964128
14:19:28 70012 8192000000 10702951440 11106119680 1659945744 16.848 92 30 60 2 1672861152 4470992 8444416
14:20:44 8290 8192000000 10719784848 11136253952 1785817344 17.897 99 27 54 3 1800234976 6032816 8384816
14:21:00 13449 8192000000 10721355632 11138318336 1740542704 17.523 96 36 72 0 1757361632 6960464 9858464
14:21:20 5076 8192000000 10741504464 11153784832 1812943440 18.120 100 28 56 2 1826995472 6171760 7880272
14:21:32 9073 8192000000 10746734352 11161841664 1812786336 18.119 99 44 89 2 1832718656 7592608 12339712
14:21:49 8080 8192000000 10757605616 11175661568 1835909232 18.307 100 33 66 1 1851438656 5787776 9741648
14:22:07 6673 8192000000 10749107344 11179163648 1837014800 18.317 100 17 34 0 1848088720 5797952 5275968
14:22:25 9340 8192000000 10759951536 11179696128 1840405872 18.344 100 25 49 2 1853818976 6182032 7231072
14:22:44 7198 8192000000 10772156528 11189743616 1849476640 18.418 100 37 74 1 1866604464 6036256 11091568
14:22:57 11847 8192000000 10769128960 11195854848 1850377104 18.425 100 27 53 5 1863988336 5615872 7995360
14:23:15 8570 8192000000 10771282944 11201171456 1859600672 18.500 100 31 61 1 1875337360 5528560 10208128
14:23:30 10506 8192000000 10767773968 11198537728 1860646560 18.509 100 23 46 0 1872849088 5500384 6702144
14:23:52 10011 8192000000 10785869232 11212038144 1866263728 18.554 100 21 42 0 1887010752 14605232 6141792
14:24:12 17660 8192000000 10794321104 11216756736 1871400000 18.596 100 24 44 3 1882745104 4603328 6741776
14:24:39 72997 8192000000 10789288496 11227598848 1879942448 18.665 100 23 46 3 1896096096 9871824 6281824
14:25:58 12350 8192000000 10810306192 11236438016 1886885200 18.721 100 36 72 3 1902481344 6197184 9398960
14:26:16 9632 8192000000 10811678976 11236188160 1891241872 18.756 100 31 62 2 1905714288 5923968 8548448
14:26:33 9455 8192000000 10811487760 11245948928 1895033632 18.786 100 24 48 2 1908462496 6732080 6696784
14:26:49 8416 8192000000 10814661280 11247091712 1897166128 18.803 100 29 58 2 1911180272 5841920 8172224
14:27:14 30833 8192000000 10855491696 11274035200 1920339504 18.990 100 33 64 2 1935122464 4834736 9948224
14:27:58 14295 8192000000 10862616288 11289919488 1935081280 19.107 100 42 83 0 1953527600 6860160 11586160
14:28:19 39105 8192000000 10887484016 11310977024 1946014576 19.195 100 42 83 1 1965974880 8356336 11603968
14:29:08 11549 8192000000 10888316336 11315793920 1959506080 19.302 100 51 99 3 1983871168 10048960 14316128
14:29:30 6521 8192000000 10896186288 11324919808 1962959936 19.330 100 48 97 0 1986596016 9997120 13638960
14:29:44 6955 8192000000 10900294752 11323428864 1947618608 19.208 99 56 111 0 1974337184 10336224 16382352
14:30:07 25366 8192000000 10888451024 11329880064 1963024736 19.330 100 39 78 2 1986303136 11426576 11851824
14:31:01 8209 8192000000 10917446624 11348344832 1979235008 19.459 100 47 94 1 2008805920 15604544 13966368
14:31:18 41121 8192000000 10923809520 11353890816 1987365392 19.523 100 54 108 0 2016764800 13575120 15824288
14:32:17 32593 8192000000 10911608432 11357356032 1985108832 19.505 100 28 56 1 2008959024 15079328 8770864
14:32:59 15904 8192000000 10922963392 11360980992 1989585936 19.541 100 33 63 1 2012081984 13239104 9256944
14:33:23 15728 8192000000 10902275552 11339894784 1911004128 18.915 96 44 88 0 1937809968 13936960 12868880
14:33:48 8687 8192000000 10914300960 11349803008 1979545680 19.461 100 48 95 1 2009901152 15375120 14980352
14:34:05 1902 8192000000 10927502272 11355443200 1983725280 19.494 100 49 98 0 2012515552 14187888 14602384
14:34:16 4605 8192000000 10926308672 11351949312 1967379408 19.365 99 60 120 0 2001427424 16654000 17394016
14:34:28 17212 8192000000 10926304112 11361267712 1986260080 19.514 100 51 102 1 2019570384 18028688 15281616
14:34:52 15333 8192000000 10940171536 11373674496 1994605728 19.580 100 60 119 3 2034473760 20972160 18895872
14:35:16 14859 8192000000 10930741136 11363328000 1980400720 19.468 99 62 124 1 2021265776 21241184 19623872
14:35:38 7491 8192000000 10951640464 11382591488 1999160000 19.616 100 51 101 2 2038383776 22889296 16334480
14:35:52 1737 8192000000 10949570816 11369771008 1984699584 19.502 99 68 135 0 2029479968 24058784 20721600
14:36:01 4040 8192000000 10955035408 11383296000 1986164656 19.513 99 72 144 1 2035968224 27034208 22769360
14:36:14 4926 8192000000 10964442800 11390296064 2001744864 19.636 100 68 132 3 2048145808 26162464 20238480
14:36:25 8091 8192000000 10925705648 11352354816 1954629744 19.263 98 65 130 0 2000994464 26237600 20127120
14:36:41 2899 8192000000 10947821392 11369984000 1990775744 19.550 100 72 144 0 2034807696 22684544 21347408
14:36:54 8830 8192000000 10957862384 11381710848 1994958688 19.583 100 64 128 0 2035270752 21057504 19254560
14:37:18 1667 8192000000 10965717264 11380686848 2001529472 19.635 100 80 160 3 2047374400 22703792 23141136
14:37:27 2095 8192000000 10959831456 11385532416 2003826448 19.653 100 69 138 1 2048169104 22835760 21506896
14:37:36 1979 8192000000 10965733904 11387383808 2011959392 19.717 100 89 176 2 2062196784 24874784 25362608
14:37:47 4190 8192000000 10968585664 11396866048 2009981872 19.701 100 65 130 0 2056108224 26504144 19622208
14:37:59 2461 8192000000 10934215520 11354841088 1976002048 19.433 99 81 159 0 2026944928 26997568 23945312
14:38:08 1692 8192000000 10971531104 11385733120 2002257968 19.641 100 84 168 1 2054416592 27543152 24615472
14:38:17 5884 8192000000 10952795392 11372638208 1982345856 19.483 99 75 150 0 2032231504 27418864 22466784
14:38:31 1275 8192000000 10978780608 11389042688 2004828080 19.661 100 88 176 0 2058408272 27775440 25804752
14:38:39 8030 8192000000 10963517296 11379654656 1994690032 19.581 100 81 160 1 2047478064 29070576 23717456
14:38:57 3879 8192000000 10973813696 11391373312 1999588384 19.619 100 68 134 0 2051308000 30937088 20782528
14:39:08 9914 8192000000 10952030160 11380740096 1992781808 19.566 100 58 116 0 2046937488 36041008 18114672
14:39:25 2417 8192000000 10966971824 11382300672 1993837664 19.574 100 82 163 0 2049893888 31054352 25001872
14:39:34 1341 8192000000 10960815824 11379658752 1990289648 19.546 100 82 163 0 2047488224 32566784 24631792
14:39:42 6219 8192000000 10973897792 11397148672 2000126160 19.624 100 66 129 2 2053443024 32590560 20726304
14:39:58 2376 8192000000 10980831280 11396448256 1997866400 19.606 100 84 170 4 2056475104 33055440 25553264
14:40:08 4332 8192000000 10961257840 11371876352 1978780256 19.455 99 79 156 1 2038069616 34945968 24343392
14:40:20 4637 8192000000 10968377744 11383930880 1986563072 19.517 100 79 158 0 2047073120 36433264 24076784
14:40:35 6575 8192000000 10972329744 11392851968 1991968176 19.559 100 73 144 1 2052323456 37741552 22613728
14:40:51 3529 8192000000 10966816160 11385733120 1986009344 19.512 99 77 154 0 2048180848 38334416 23837088
14:41:05 2278 8192000000 10971590736 11387158528 1987060464 19.521 99 80 160 2 2052596784 39383376 26152944
14:41:14 2712 8192000000 10948878672 11374899200 1977077056 19.442 100 70 140 1 2037161504 36790912 23293536
14:41:24 2672 8192000000 10973139312 11388551168 1991803200 19.558 100 83 166 0 2056541008 38620816 26116992
14:41:35 6619 8192000000 10973668144 11398574080 1996113808 19.592 100 63 123 3 2056140368 39497008 20529552
14:41:49 3355 8192000000 10985299680 11402117120 1996828400 19.598 100 78 156 1 2061600752 39314000 25458352
14:41:59 1847 8192000000 10969497712 11385430016 1974040224 19.417 99 82 164 0 2041190944 41070384 26080336
14:42:08 9105 8192000000 10949317184 11387469824 1969398880 19.381 99 48 96 1 2025707360 40461200 15847280
14:42:24 4357 8192000000 10946608576 11381243904 1977194944 19.442 100 39 78 2 2028393776 38136352 13062480
14:42:35 7621 8192000000 10951338944 11383226368 1979125248 19.458 100 49 99 0 2034882560 39469040 16288272
14:42:51 7053 8192000000 10932870640 11365638144 1966236816 19.356 100 47 94 1 2021236112 39923648 15075648
14:43:09 6877 8192000000 10930738048 11354791936 1946592592 19.199 99 48 95 0 2005024976 42032128 16400256
14:43:25 10572 8192000000 10939800208 11371298816 1968690752 19.375 100 46 92 0 2027096144 42719776 15685616
14:43:42 9675 8192000000 10951315472 11385401344 1959772432 19.304 99 40 80 1 2015747264 42666272 13308560
14:43:59 14974 8192000000 10950175792 11389558784 1980637984 19.470 100 35 70 1 2034493824 42031344 11824496
14:44:24 10508 8192000000 10957913280 11396751360 1980905152 19.472 100 40 80 1 2041707168 47210848 13591168
14:44:47 9493 8192000000 10936196192 11375964160 1938283280 19.133 98 36 72 2 2001395440 50310096 12802064
14:45:03 7987 8192000000 10941531568 11374120960 1938354176 19.134 99 49 96 3 2005321472 50257376 16709920
14:45:18 6407 8192000000 10931753520 11362467840 1940583280 19.151 99 38 76 1 2001244160 47224208 13436672
14:45:35 13794 8192000000 10925611984 11358846976 1944434448 19.182 100 44 88 1 2011232416 51570000 15227968
14:46:08 15589 8192000000 10932972768 11375378432 1944654544 19.184 100 35 70 0 2012832016 55543616 12633856
14:46:35 15150 8192000000 10930345152 11369967616 1928256944 19.053 99 39 77 0 2005592384 63195488 14139952
14:47:05 20812 8192000000 10923156640 11373002752 1929024448 19.059 99 34 66 2 1997597328 56437312 12135568
14:47:35 34572 8192000000 10881069312 11349012480 1931252512 19.077 100 19 38 3 1988316112 50393760 6669840
14:48:16 13655 8192000000 10872147360 11337289728 1902037168 18.843 99 15 30 1 1946830256 39863376 4929712
14:48:36 24908 8192000000 10872073200 11343564800 1913454800 18.934 100 11 20 1 1953834816 36753488 3626528
14:49:21 23167 8192000000 10877690368 11339759616 1918909680 18.978 99 14 28 1 1943121872 20074368 4137824
14:49:51 45618 8192000000 10867641056 11328143360 1901253840 18.836 98 10 20 0 1920772720 16441312 3077568
14:50:42 103008 8192000000 10860951040 11315933184 1805572528 18.060 93 13 26 2 1822696976 13603392 3521056
14:52:51 50190 8192000000 10865999440 11312918528 1890156592 18.747 98 29 58 1 1906212176 7193456 8862128
14:53:51 49319 8192000000 10852371360 11303555072 1892447824 18.766 98 13 24 1 1902075168 5994672 3632672
14:54:49 54878 8192000000 10897183008 11348209664 1939159648 19.140 100 10 20 1 1951296384 8911936 3224800
14:55:56 40256 8192000000 10890805088 11350949888 1934130992 19.100 99 18 36 1 1953752912 14112240 5509680
14:57:12 106410 8192000000 10922194352 11399634944 1973544960 19.414 100 8 16 0 1993101952 17391136 2165856
14:59:07 85697 8192000000 10938835248 11390554112 1978330544 19.451 99 24 48 1 2003043120 18206160 6506416
15:00:50 27006 8192000000 10949959824 11402637312 1999156560 19.616 100 41 82 1 2027638880 16295376 12186944
15:01:32 117257 8192000000 10955436384 11409813504 1976375904 19.436 99 23 46 2 1999462992 16400880 6686208
15:03:42 76258 8192000000 10935716816 11417489408 2004049664 19.655 100 40 79 3 2032609056 17003088 11556304
15:05:06 92340 8192000000 10937875232 11419328512 1980653488 19.470 99 8 16 0 1996497392 13781600 2062304
15:06:44 52160 8192000000 10941524128 11418017792 2013262352 19.727 100 15 30 0 2034799472 17234288 4302832
15:07:44 24361 8192000000 10933192176 11420647424 2014113568 19.734 100 12 24 2 2031011072 13517136 3380368
15:08:17 52994 8192000000 10937517376 11414675456 1993431040 19.571 99 16 32 0 2007661024 10012352 4217632
15:09:25 32875 8192000000 10940452944 11418726400 2014151776 19.734 100 12 25 0 2029088736 11636784 3300176
15:10:20 70493 8192000000 10950322288 11431202816 2011851408 19.716 100 16 32 2 2036825200 20211472 4762320
15:11:38 38589 8192000000 10933526800 11437182976 2008113136 19.687 100 3 6 0 2032111264 23107216 890912
15:12:23 40772 8192000000 10912210832 11390799872 1969279856 19.380 98 17 34 1 1982464752 8347696 4837200
15:13:22 84359 8192000000 10921433568 11413655552 2000753888 19.629 100 11 22 1 2012464080 8829008 2881184
15:14:57 38382 8192000000 10929176848 11410972672 1985964016 19.512 99 7 14 2 1999268640 11927344 1377280
15:15:42 35522 8192000000 10917206864 11397726208 1942323648 19.165 97 13 26 1 1953488208 8906592 2257968
15:16:37 91278 8192000000 10916752112 11389800448 1953608864 19.255 98 8 16 1 1967611744 11733856 2269024
15:18:14 39013 8192000000 10904152448 11371073536 1952028240 19.243 98 18 36 2 1970669776 13715232 4926304
15:19:12 32077 8192000000 10916191328 11389460480 1987632176 19.525 100 20 40 2 2001149552 8013280 5504096
15:19:51 16531 8192000000 10927659936 11378388992 1965570704 19.350 99 27 53 2 1980836112 7931584 7333824
15:20:14 62956 8192000000 10912874032 11381088256 1977332064 19.444 100 14 28 0 1990479680 9014416 4133200
15:21:26 39277 8192000000 10913828704 11385245696 1970238848 19.387 99 15 30 1 1985720336 11152560 4328928
15:22:13 95092 8192000000 10897684912 11350233088 1891176144 18.755 95 22 44 0 1914171136 16895104 6099888
15:23:56 20328 8192000000 10931012960 11384508416 1968421008 19.373 99 45 90 1 1992617120 11342736 12853376
15:24:27 48401 8192000000 10857241344 11340812288 1852833920 18.445 94 25 50 1 1874154752 14518320 6802512
15:25:26 27864 8192000000 10887515792 11324841984 1917389712 18.966 98 36 71 0 1936974064 9095616 10488736
15:26:01 27230 8192000000 10876082768 11325341696 1863914112 18.535 95 44 87 1 1884902880 9140160 11848608
15:26:35 60998 8192000000 10838220848 11311128576 1836457792 18.312 95 12 24 2 1851310192 11717312 3135088
15:27:42 44956 8192000000 10873087984 11323613184 1830070992 18.260 95 21 42 0 1842347264 7310992 4965280
15:28:34 102641 8192000000 10856263472 11315007488 1896543808 18.798 98 35 70 0 1921360208 14231056 10585344
15:30:50 47663 8192000000 10828244016 11288178688 1825147744 18.220 95 17 34 0 1840958080 10931696 4878640
15:31:45 35536 8192000000 10819326816 11283120128 1835010832 18.300 96 17 33 0 1846323104 6885744 4426528
15:33:06 75518 8192000000 10806748592 11275694080 1858322832 18.490 97 16 31 1 1869622336 6957824 4341680
15:34:29 64627 8192000000 10835949728 11314483200 1916835712 18.961 100 5 10 0 1929077984 10941216 1301056
15:35:40 66002 8192000000 10831792720 11319066624 1890911488 18.753 98 23 46 1 1915852368 17942800 6998080
15:37:20 47496 8192000000 10866475952 11334971392 1913923488 18.938 99 17 34 0 1928759216 10195520 4640208
15:38:13 68639 8192000000 10856197136 11325947904 1909184752 18.900 98 28 54 2 1926037472 8894416 7958304
15:39:28 57100 8192000000 10861265152 11330056192 1891249296 18.756 98 15 30 0 1915059120 19824128 3985696
15:40:32 100814 8192000000 10883785344 11341832192 1913503216 18.935 98 27 54 3 1934468576 13051840 7913520
15:42:22 63929 8192000000 10876341616 11355148288 1926710096 19.041 99 19 38 0 1946397952 14043072 5644784
15:43:47 59829 8192000000 10881297904 11362275328 1937965248 19.131 99 10 20 0 1965924896 24522208 3437440
15:44:53 50505 8192000000 10880348976 11362455552 1935581376 19.111 99 13 26 0 1950227264 11030960 3614928
15:45:51 58974 8192000000 10884116768 11355783168 1928168416 19.052 98 10 20 0 1945119568 13633632 3317520
15:46:58 10332 8192000000 10932421600 11375673344 1978732688 19.455 100 57 111 3 2001235760 6193104 16309968
15:47:16 20368 8192000000 10924488736 11383148544 1961308288 19.316 99 39 78 1 1984902928 12970928 10623712
15:47:45 69504 8192000000 10916901344 11362213888 1899139856 18.819 96 23 44 0 1918108080 12884160 6084064
15:49:02 29015 8192000000 10941797120 11388329984 1990996864 19.552 100 55 110 2 2019443248 12464000 15982384
15:49:41 101436 8192000000 10904192160 11386970112 1983042304 19.489 100 40 78 3 2007509184 12884672 11582208
15:51:34 57835 8192000000 10896443456 11380236288 1966762256 19.360 99 19 38 2 1984377264 11502208 6112800
15:52:53 68369 8192000000 10888082384 11376889856 1958315984 19.293 99 2 4 0 1964542672 5926272 300416
15:54:08 50406 8192000000 10905640528 11389562880 1978440496 19.452 100 8 16 0 1987762240 7147776 2173968
15:55:06 47679 8192000000 10905701872 11387121664 1967409184 19.365 99 19 34 1 1979292832 7037216 4846432
15:56:01 61555 8192000000 10886382272 11364945920 1932747792 19.089 97 17 34 1 1947262304 9710896 4803616
15:57:09 33875 8192000000 10913127904 11385085952 1957140848 19.283 98 31 62 0 1976559920 10989568 8429504
15:58:04 69189 8192000000 10896941664 11375853568 1928826048 19.057 97 18 37 0 1947031312 13720880 4484384
15:59:27 43407 8192000000 10901466160 11375415296 1945207584 19.188 98 18 37 1 1958333488 8153008 4972896
16:00:16 55984 8192000000 10902279072 11382849536 1927738560 19.049 97 15 30 0 1940960192 8998720 4222912
16:01:19 124295 8192000000 10892590432 11373850624 1846969280 18.397 93 13 26 0 1861217792 11332448 2916064
16:03:29 21211 8192000000 10929183856 11376680960 1958686320 19.296 99 22 44 1 1971536080 7488528 5361232
16:03:57 22109 8192000000 10924438640 11386126336 1950398000 19.230 98 35 70 1 1969298160 9110592 9789568
16:04:25 41422 8192000000 10920347296 11383255040 1945250864 19.189 98 34 68 0 1965804320 11237408 9316048
16:05:13 27369 8192000000 10906540368 11354435584 1918905104 18.978 97 25 48 2 1934171904 8821792 6445008
16:05:47 41126 8192000000 10931544992 11385827328 1960110304 19.307 99 41 82 0 1986585088 14793168 11681616
16:06:36 47636 8192000000 10902965392 11381084160 1958821120 19.297 99 35 70 0 1987909856 19258000 9830736
16:07:38 125108 8192000000 10876149120 11349823488 1891950800 18.761 96 9 18 0 1910500448 16076304 2473344
16:09:49 95550 8192000000 10892505504 11382792192 1970097600 19.386 100 21 42 0 1986503376 10648304 5757472
16:11:33 48189 8192000000 10906469184 11370455040 1939974128 19.147 98 8 16 0 1953792032 10947520 2870384
16:13:53 131808 8192000000 10882226064 11363971072 1870229840 18.586 96 10 20 1 1883684672 10164048 3290784
16:16:10 62449 8192000000 10889060080 11370414080 1947415872 19.206 99 22 44 0 1966108208 12550928 6141408
16:17:19 58998 8192000000 10853357552 11316469760 1822558256 18.199 93 21 42 2 1842976128 14681344 5736528
16:18:54 34873 8192000000 10864647856 11330072576 1906936256 18.882 99 38 76 2 1932260880 14577184 10747440
16:20:16 70419 8192000000 10820836944 11288600576 1842566640 18.362 96 24 48 0 1861998736 12692800 6739296
16:21:38 54544 8192000000 10842365344 11305549824 1869707152 18.582 97 25 50 0 1887302096 10897248 6697696
16:22:40 93606 8192000000 10838216128 11317448704 1871621824 18.597 97 27 54 2 1891032896 11712768 7698304
16:24:23 32921 8192000000 10876347120 11334979584 1936780896 19.121 100 27 54 1 1954415696 10029840 7604960
16:25:09 116781 8192000000 10847669088 11319984128 1799417808 18.009 93 14 28 0 1815485744 12336560 3731376

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 19-12-2020 16:28:14 to 19-12-2020 16:28:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 171 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-12-2020 16:28:45 to 19-12-2020 16:28:47.

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          256438
MON$OLDEST_ACTIVE               256439
MON$OLDEST_SNAPSHOT             256439
MON$NEXT_TRANSACTION            256439
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                       2038752
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:94: 
:95: mscs-test-161.budzdorov.ru    Sat Dec 19 16:27:22 2020
:96:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:97: 
:98: 
:99: mscs-test-161.budzdorov.ru    Sat Dec 19 16:27:22 2020
:100:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:101: 
--- end of diff output ---

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

19.12.20 16:28:48. 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-19 16:28:50 No severe PSQL-related problems occured
19.12.20 16:28:51. End of report.