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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-23 01:27:10
DTS_END                         2021-01-23 01:27:10.4640
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/39134
TRN_ID                          239063
ATT_ID                          712
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: 9150.33 28966 1098039
customer order: creation 167.37 364 20084
customer order: refuse 14.51 393 1741
order to supplier: creation 44.79 1204 5375
order to supplier: removal 3.23 108561 387
invoice (draft): creation 45.22 3256 5426
invoice (draft): removal 52.34 900 6281
invoice accept: apply 41.72 17424 5006
invoice accept: cancel 47.80 772 5736
customer reserve: creation 3802.85 172 456342
customer reserve: removal 4637.16 57 556459
realization accept: apply 82.87 192 9944
realization accept: cancel 81.50 109 9780
payment from customer: creation 57.55 118 6906
payment from customer: removal 5.71 103 685
payment to supplier: creation 50.41 125 6049
payment to supplier: removal 3.38 141 405
service: total inventory turnovers 4.68 1232 561
service: total monetary turnovers 6.50 27 780
service: aggregate perf. data 0.73 22209 88
service: refresh index statistics 0.03 421962 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-01-2021 01:28:19 to 23-01-2021 01:28:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1288
TEST_TIME 2 2678
TEST_TIME 3 3928
TEST_TIME 4 4409
TEST_TIME 5 4843
TEST_TIME 6 4937
TEST_TIME 7 5109
TEST_TIME 8 5144
TEST_TIME 9 5764
TEST_TIME 10 5960
TEST_TIME 11 6198
TEST_TIME 12 6300
TEST_TIME 13 6535
TEST_TIME 14 6602
TEST_TIME 15 6898
TEST_TIME 16 6907
TEST_TIME 17 7036
TEST_TIME 18 7505
TEST_TIME 19 7508
TEST_TIME 20 8065
TEST_TIME 21 8154
TEST_TIME 22 8075
TEST_TIME 23 8534
TEST_TIME 24 9544
TEST_TIME 25 10766
TEST_TIME 26 11191
TEST_TIME 27 11171
TEST_TIME 28 11068
TEST_TIME 29 10874
TEST_TIME 30 10818
TEST_TIME 31 10871
TEST_TIME 32 10658
TEST_TIME 33 10538
TEST_TIME 34 10464
TEST_TIME 35 10347
TEST_TIME 36 10131
TEST_TIME 37 10038
TEST_TIME 38 9803
TEST_TIME 39 9786
TEST_TIME 40 9916
TEST_TIME 41 9762
TEST_TIME 42 9696
TEST_TIME 43 9883
TEST_TIME 44 9743
TEST_TIME 45 9725
TEST_TIME 46 9910
TEST_TIME 47 9921
TEST_TIME 48 9867
TEST_TIME 49 9867
TEST_TIME 50 9783
TEST_TIME 51 9836
TEST_TIME 52 9885
TEST_TIME 53 9832
TEST_TIME 54 9664
TEST_TIME 55 9612
TEST_TIME 56 9579
TEST_TIME 57 9470
TEST_TIME 58 9600
TEST_TIME 59 9519
TEST_TIME 60 9436
TEST_TIME 61 9357
TEST_TIME 62 9303
TEST_TIME 63 9290
TEST_TIME 64 9385
TEST_TIME 65 9384
TEST_TIME 66 9463
TEST_TIME 67 9464
TEST_TIME 68 9444
TEST_TIME 69 9467
TEST_TIME 70 9433
TEST_TIME 71 9443
TEST_TIME 72 9543
TEST_TIME 73 9635
TEST_TIME 74 9672
TEST_TIME 75 9689
TEST_TIME 76 9657
TEST_TIME 77 9738
TEST_TIME 78 9630
TEST_TIME 79 9572
TEST_TIME 80 9503
TEST_TIME 81 9475
TEST_TIME 82 9455
TEST_TIME 83 9382
TEST_TIME 84 9375
TEST_TIME 85 9383
TEST_TIME 86 9363
TEST_TIME 87 9301
TEST_TIME 88 9305
TEST_TIME 89 9279
TEST_TIME 90 9247
TEST_TIME 91 9296
TEST_TIME 92 9314
TEST_TIME 93 9302
TEST_TIME 94 9296
TEST_TIME 95 9392
TEST_TIME 96 9400
TEST_TIME 97 9361
TEST_TIME 98 9419
TEST_TIME 99 9405
TEST_TIME 100 9464
TEST_TIME 101 9431
TEST_TIME 102 9441
TEST_TIME 103 9452
TEST_TIME 104 9425
TEST_TIME 105 9354
TEST_TIME 106 9403
TEST_TIME 107 9336
TEST_TIME 108 9334
TEST_TIME 109 9309
TEST_TIME 110 9268
TEST_TIME 111 9270
TEST_TIME 112 9235
TEST_TIME 113 9204
TEST_TIME 114 9164
TEST_TIME 115 9159
TEST_TIME 116 9178
TEST_TIME 117 9207
TEST_TIME 118 9205
TEST_TIME 119 9217
TEST_TIME 120 9151

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-01-2021 01:28:22 to 23-01-2021 01:28:26.

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 1519448 1519448 0 0.00 0 52885 6 0 0
doc_list_biud 1519447 1519447 0 0.00 0 44556 27 0 0
sp_add_invoice_to_stock 5153 5006 147 2.85 29 183486 17425 0 147
sp_cancel_adding_invoice 5736 5736 0 0.00 4 45767 772 0 0
sp_cancel_client_order 1741 1741 0 0.00 4 21327 394 0 0
sp_cancel_customer_reserve 556459 556459 0 0.00 1 44557 57 0 0
sp_cancel_pay_from_customer 685 685 0 0.00 3 3639 104 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 2 14470 141 0 0
sp_cancel_supplier_invoice 6289 6281 8 0.12 1 42797 900 0 8
sp_cancel_supplier_order 387 387 0 0.00 7 1199803 108562 0 0
sp_cancel_write_off 9780 9780 0 0.00 1 36727 109 0 0
sp_client_order 20084 20084 0 0.00 4 43797 364 0 0
sp_customer_reserve 456342 456342 0 0.00 0 42416 173 0 0
sp_fill_shopping_cart 30881 30881 0 0.00 1 11603 41 0 0
sp_fill_shopping_cart_clo_res 456337 456337 0 0.00 0 15336 13 0 0
sp_get_clo_for_invoice 4998 4998 0 0.00 0 30871 349 0 0
sp_kill_cost_storno 16606 16606 0 0.00 0 12984 60 0 0
sp_kill_qstorno_ret_qs2qd 1129366 1129366 0 0.00 0 44554 32 0 0
sp_kill_qty_storno 595318 595318 0 0.00 0 44555 69 0 0
sp_lock_selected_doc 20661 20661 0 0.00 0 7885 6 0 0
sp_make_cost_storno 27890 27890 0 0.00 0 52200 56 0 0
sp_multiply_rows_for_pdistr 27889 27889 0 0.00 0 6534 31 0 0
sp_multiply_rows_for_qdistr 20084 20084 0 0.00 0 14560 142 0 0
sp_pay_from_customer 6906 6906 0 0.00 4 10915 119 0 0
sp_pay_to_supplier 6049 6049 0 0.00 5 10527 126 0 0
sp_payment_common 12955 12955 0 0.00 1 7857 28 0 0
sp_qd_handle_on_cancel_clo 1741 1741 0 0.00 0 21321 360 0 0
sp_qd_handle_on_invoice_upd_sts 10727 10727 0 0.00 0 34456 343 0 0
sp_qd_handle_on_reserve_upd_sts 9943 9943 0 0.00 0 40533 65 0 0
sp_reserve_write_off 9944 9944 0 0.00 5 40574 192 0 0
sp_supplier_invoice 5426 5426 0 0.00 5 92793 3257 0 0
sp_supplier_order 5375 5375 0 0.00 4 39337 1205 0 0
srv_aggregate_perf_data 88 88 0 0.00 3001 265119 22209 0 0
srv_fill_mon_cache_memory 168 168 0 0.00 1009 181242 32081 0 0
srv_find_qd_qs_mism 1050364 1050364 0 0.00 0 17127 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 41 157065 1233 0 0
srv_make_money_saldo 780 780 0 0.00 0 824 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 268265 623653 421962 0 0
t$perf-abend:sp_add_invoice_to_stock 147 147 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5006 5006 0 0.00 0 19766 228 0 0
t$perf-norm:sp_cancel_adding_invoice 391 391 0 0.00 0 8276 163 0 0
t$perf-norm:sp_cancel_client_order 1741 1741 0 0.00 0 10572 30 0 0
t$perf-norm:sp_cancel_customer_reserve 718 718 0 0.00 0 37179 80 0 0
t$perf-norm:sp_cancel_pay_from_customer 685 685 0 0.00 0 3450 17 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 1070 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 928 10 0 0
t$perf-norm:sp_cancel_supplier_order 387 387 0 0.00 0 41975 1926 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 1984 7 0 0
t$perf-norm:sp_client_order 20084 20084 0 0.00 0 24182 26 0 0
t$perf-norm:sp_customer_reserve 1023 1023 0 0.00 0 511 4 0 0
t$perf-norm:sp_pay_from_customer 6906 6906 0 0.00 0 10152 16 0 0
t$perf-norm:sp_pay_to_supplier 6049 6049 0 0.00 0 10499 21 0 0
t$perf-norm:sp_reserve_write_off 9944 9944 0 0.00 0 37874 19 0 0
t$perf-norm:sp_supplier_invoice 5426 5426 0 0.00 0 7033 25 0 0
t$perf-norm:sp_supplier_order 5375 5375 0 0.00 0 10467 22 0 0
t$perf-norm:srv_aggregate_perf_data 88 88 0 0.00 0 142 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 2498 29 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 4100 38 0 0
t$perf-norm:srv_make_money_saldo 780 780 0 0.00 0 644 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 7 3 0 0
v_add_invoice_to_stock 10276 9982 294 2.86 0 5359 20 0 294
v_all_customers 36254 36254 0 0.00 0 20 1 0 0
v_all_suppliers 30266 30266 0 0.00 0 16 1 0 0
v_all_wares 40168 40168 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 782 782 0 0.00 0 1570 9 0 0
v_cancel_client_order 3482 3482 0 0.00 0 3240 8 0 0
v_cancel_customer_prepayment 1370 1370 0 0.00 0 3618 9 0 0
v_cancel_customer_reserve 1436 1436 0 0.00 0 1869 10 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 4853 16 0 0
v_cancel_supplier_invoice 832 816 16 1.92 0 1424 18 0 16
v_cancel_supplier_order 774 774 0 0.00 0 6128 17 0 0
v_cancel_write_off 1984 1984 0 0.00 0 2022 15 0 0
v_max_id_clo_ord 5375 5375 0 0.00 0 2705 2 0 0
v_max_id_clo_res 1023 1023 0 0.00 0 937 8 0 0
v_max_id_ord_sup 5422 5422 0 0.00 0 5919 7 0 0
v_max_non_paid_invoice 1713 1713 0 0.00 0 424 3 0 0
v_max_non_paid_realizn 3826 3826 0 0.00 0 5986 5 0 0
v_min_id_clo_ord 5375 5375 0 0.00 0 2599 7 0 0
v_min_id_clo_res 1023 1023 0 0.00 0 7020 24 0 0
v_min_id_ord_sup 5422 5422 0 0.00 0 4960 7 0 0
v_min_non_paid_invoice 6049 6049 0 0.00 0 7854 17 0 0
v_min_non_paid_realizn 6906 6906 0 0.00 0 5697 15 0 0
v_our_firm 10074 10074 0 0.00 0 16 1 0 0
v_reserve_write_off 19886 19886 0 0.00 0 4952 8 0 0
x_lock_depdocs_on_canc_invoice 11609 11609 0 0.00 0 20740 127 0 0
x_lock_depdocs_on_canc_sup_ord 387 387 0 0.00 0 4085 382 0 0
x_make_qstorno_1000_1200 5375 5375 0 0.00 1 39325 1122 0 0
x_make_qstorno_1200_2000 5426 5426 0 0.00 2 92778 3107 0 0
x_make_qstorno_2100_3300 456342 456342 0 0.00 0 42414 157 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-01-2021 01:28:27 to 23-01-2021 01:28:31.

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:14 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 16784 8192000000 10239755504 10554052608 790552144 8.800 61 43 86 0 805845408 2088800 13204464
22:57:46 44311 8192000000 10366816320 10689527808 1405366544 14.643 100 88 176 0 1438975216 5162224 28446448
22:58:39 30844 8192000000 10396424032 10723631104 1445826240 15.001 100 88 176 0 1481808768 7005584 28976944
22:59:19 17247 8192000000 10411819408 10740027392 1462287168 15.146 100 90 180 0 1499874672 7946480 29641024
22:59:49 21957 8192000000 10424659024 10755948544 1479859056 15.300 100 91 182 0 1518433312 8527168 30047088
23:00:23 14702 8192000000 10438630960 10773594112 1492588704 15.411 100 88 176 0 1530183328 8710720 28883904
23:00:47 28470 8192000000 10458781200 10797854720 1509430784 15.558 100 88 176 1 1547385792 9527552 28427456
23:01:26 11913 8192000000 10470905072 10817331200 1528281344 15.722 100 82 161 2 1563792208 9214176 26296688
23:01:55 20108 8192000000 10508614640 10857181184 1558058624 15.979 100 82 164 0 1594289440 10508304 25722512
23:02:25 9047 8192000000 10516268752 10875170816 1584531088 16.207 100 69 138 0 1615394400 9972464 20890848
23:02:42 17949 8192000000 10553205424 10915819520 1616618752 16.481 100 83 166 0 1652372768 10535344 25218672
23:03:07 10085 8192000000 10577874016 10944016384 1640874688 16.687 100 77 154 1 1674847360 11210848 22761824
23:03:29 13252 8192000000 10609472672 10979975168 1667937920 16.916 100 74 147 0 1700693440 11585424 21170096
23:03:54 10070 8192000000 10636344416 11009085440 1695539856 17.148 100 78 156 0 1730189872 12384912 22265104
23:04:12 8029 8192000000 10642857392 11018321920 1705140336 17.228 100 77 154 1 1741045488 13497104 22408048
23:04:31 8976 8192000000 10680166128 11050917888 1730823008 17.442 100 85 169 0 1768055056 13853152 23378896
23:04:48 7145 8192000000 10681618720 11056984064 1739388736 17.514 100 80 160 2 1776049184 14025184 22635264
23:05:02 4367 8192000000 10681910176 11060457472 1746128928 17.569 100 84 166 1 1783371216 14133344 23108944
23:05:15 4166 8192000000 10692020336 11072585728 1752807504 17.625 100 76 150 2 1787750944 13601648 21341792
23:05:26 3316 8192000000 10704255216 11081822208 1765291696 17.728 100 76 151 2 1799086496 12167168 21627632
23:05:37 5639 8192000000 10720397184 11104878592 1779052112 17.842 100 80 160 0 1814728640 12664720 23011808
23:05:50 4841 8192000000 10726731232 11110096896 1791164432 17.941 100 77 154 0 1824860784 12590064 21106288
23:06:01 2561 8192000000 10733202960 11117789184 1795854288 17.980 100 76 152 0 1830125952 12754480 21517184
23:06:11 4249 8192000000 10745425456 11131559936 1802658560 18.036 100 84 167 0 1840015776 13436656 23920560
23:06:22 7630 8192000000 10746714512 11137728512 1809327024 18.090 100 76 152 0 1843956208 13221664 21407520
23:06:38 3707 8192000000 10759143104 11147722752 1825013616 18.219 100 71 140 0 1855230656 10506464 19710576
23:06:48 3267 8192000000 10767636256 11163983872 1832345280 18.278 100 78 155 2 1866926080 12422304 22158496
23:06:59 3058 8192000000 10771036480 11161948160 1838447520 18.328 100 82 165 1 1874665216 12654464 23563232
23:07:08 2732 8192000000 10788099920 11177058304 1842792048 18.364 100 90 175 3 1880305216 12689488 24823680
23:07:18 1777 8192000000 10789518224 11176026112 1848423136 18.409 100 89 177 2 1885962832 12720992 24818704
23:07:26 2150 8192000000 10793123616 11182448640 1854138336 18.456 100 91 182 4 1892766160 13056704 25571120
23:07:35 1850 8192000000 10801114672 11188170752 1854962928 18.462 100 86 171 2 1891329984 12939856 23427200
23:07:43 1738 8192000000 10798942416 11190317056 1862360304 18.522 100 91 184 4 1903239440 13968528 26910608
23:07:51 1594 8192000000 10806821712 11195977728 1862670000 18.525 100 89 177 3 1901207136 13407792 25129344
23:07:59 1456 8192000000 10814723744 11202338816 1873179104 18.610 100 98 197 1 1914772832 13687520 27906208
23:08:07 2372 8192000000 10812759296 11206279168 1869006160 18.576 100 84 170 1 1905230096 12280624 23943312
23:08:16 1462 8192000000 10805774544 11199451136 1870359760 18.587 100 87 174 1 1908012336 13074672 24577904
23:08:24 6700 8192000000 10803796016 11203162112 1871410832 18.596 100 69 133 5 1901357504 10259200 19687472
23:08:38 8217 8192000000 10808596608 11205791744 1875273584 18.627 100 74 148 4 1906239008 10319584 20645840
23:08:53 2213 8192000000 10816672032 11212636160 1881572000 18.678 100 86 172 0 1917520928 11770720 24178208
23:09:01 19803 8192000000 10798183520 11213049856 1878530192 18.653 100 61 122 4 1905330512 10150864 16649456
23:09:28 3429 8192000000 10787889552 11209195520 1877981856 18.649 100 50 101 2 1899972432 7808224 14182352
23:09:41 3841 8192000000 10804182960 11217244160 1880379520 18.668 100 46 90 0 1901818912 8923920 12515472
23:09:55 4581 8192000000 10805171552 11218120704 1884928112 18.705 100 56 113 3 1910338288 9513856 15896320
23:10:08 7392 8192000000 10791384688 11219918848 1880902576 18.672 100 35 70 2 1899300048 9148912 9248560
23:10:21 5416 8192000000 10791005856 11220021248 1885126368 18.706 100 33 66 2 1902046592 7202432 9717792
23:10:33 5140 8192000000 10793761488 11221311488 1885133680 18.707 100 25 51 1 1898328912 6420848 6774384
23:10:45 5762 8192000000 10801432784 11226120192 1884777840 18.704 100 21 43 1 1896617376 5813888 6025648
23:11:03 4553 8192000000 10800946784 11228336128 1890044912 18.746 100 24 48 2 1902976256 5923856 7007488
23:11:16 6790 8192000000 10810816192 11233320960 1893861728 18.777 100 27 54 0 1908140272 6669632 7608912
23:11:29 9716 8192000000 10798371088 11230920704 1891126480 18.755 100 12 23 2 1900052880 6006416 2919984
23:11:46 11991 8192000000 10796034208 11235180544 1897255200 18.804 100 15 29 2 1907621904 5897504 4469200
23:12:04 11953 8192000000 10826126560 11243560960 1903842880 18.857 100 21 42 3 1916062512 6106416 6113216
23:12:23 77227 8192000000 10819941328 11256799232 1905989136 18.874 100 19 38 0 1917067360 5167248 5910976
23:13:48 6233 8192000000 10816760240 11255361536 1907433088 18.886 100 25 49 2 1921090928 6690640 6967200
23:14:00 4439 8192000000 10818561168 11257085952 1909822768 18.905 100 37 74 3 1927840416 6991952 11025696
23:14:11 7406 8192000000 10823191088 11257532416 1907688864 18.888 100 26 52 1 1926262288 11233952 7339472
23:14:25 8882 8192000000 10818346416 11257487360 1909313632 18.901 100 33 67 1 1925749952 6881968 9554352
23:14:42 9144 8192000000 10830138128 11263078400 1908305760 18.893 100 21 41 1 1919861616 5596640 5959216
23:14:59 11246 8192000000 10823772704 11260911616 1908975280 18.898 100 17 34 1 1920041728 5851456 5214992
23:15:19 6718 8192000000 10819178544 11261759488 1913247376 18.933 100 31 62 1 1929924432 7005120 9671936
23:15:32 12451 8192000000 10821284736 11266572288 1913764944 18.937 100 27 54 1 1927951808 6964736 7222128
23:15:51 9023 8192000000 10818090288 11263246336 1897930304 18.810 99 27 55 0 1916501392 10613376 7957712
23:16:06 10988 8192000000 10829506992 11266236416 1914862544 18.946 100 26 52 0 1928087408 5405232 7819632
23:16:26 14310 8192000000 10810374576 11256295424 1875239488 18.627 98 9 18 1 1882996096 5494464 2262144
23:16:47 10765 8192000000 10802277792 11238916096 1862716048 18.525 98 19 38 1 1873997616 5800736 5480832
23:17:06 65112 8192000000 10795927552 11244625920 1884906000 18.705 99 35 71 1 1900720768 5411856 10402912
23:18:18 7797 8192000000 10788625872 11222556672 1832587360 18.280 97 28 56 0 1847378320 6470912 8320048
23:18:36 11434 8192000000 10750221904 11180797952 1773587216 17.797 95 15 30 0 1782176016 4530016 4058784
23:18:55 5618 8192000000 10722071504 11135954944 1743049568 17.544 95 25 49 0 1755923376 5838944 7034864
23:19:07 7641 8192000000 10704705648 11124084736 1753631312 17.632 97 34 68 0 1770237536 6950224 9656000
23:19:26 10274 8192000000 10692635712 11098013696 1705793696 17.234 95 22 45 0 1717778960 5634240 6351024
23:19:44 8920 8192000000 10718117056 11141509120 1781467008 17.862 99 16 32 1 1792610304 5965600 5177696
23:20:03 8835 8192000000 10694634944 11115642880 1742621200 17.540 97 29 58 3 1757091040 6024608 8445232
23:20:20 8324 8192000000 10705267936 11119157248 1755405424 17.646 97 24 46 3 1768851648 6210160 7236064
23:20:37 4491 8192000000 10699481664 11112935424 1743295344 17.546 97 37 75 2 1760599936 6516992 10787600
23:20:50 6773 8192000000 10702623680 11109617664 1756700064 17.657 97 27 54 0 1770721168 5295728 8725376
23:21:05 11960 8192000000 10708207152 11123040256 1739976736 17.518 96 25 50 0 1752542336 5285936 7279664
23:21:25 10317 8192000000 10719002576 11139633152 1802159104 18.032 100 18 34 2 1812594992 5026528 5409360
23:21:41 16619 8192000000 10721532016 11137675264 1806194144 18.065 100 20 37 0 1817193424 5813264 5186016
23:22:04 70786 8192000000 10711037280 11133825024 1747544576 17.581 96 32 64 2 1762701568 5147696 10009296
23:23:23 6243 8192000000 10731163328 11149103104 1817852448 18.160 100 43 87 2 1836468496 6692608 11923440
23:23:36 7038 8192000000 10742720000 11163992064 1827486176 18.239 100 21 42 1 1839982848 6644096 5852576
23:23:52 5194 8192000000 10752953680 11177046016 1841386736 18.352 100 48 98 0 1863353744 7845280 14121728
23:24:06 6148 8192000000 10753163536 11175251968 1840151632 18.342 100 28 56 1 1854076160 5901584 8022944
23:24:19 5679 8192000000 10748561632 11171938304 1833979424 18.292 100 24 48 1 1846236160 5559280 6697456
23:24:31 3848 8192000000 10760275232 11179192320 1824311968 18.213 99 26 50 1 1837161648 5985840 6863840
23:24:43 10336 8192000000 10767836064 11190620160 1845034704 18.382 100 25 49 1 1857945712 5848048 7062960
23:25:01 8651 8192000000 10762896544 11186987008 1850199920 18.424 100 25 49 4 1862270352 5052128 7018304
23:25:17 9144 8192000000 10769390656 11192803328 1848617936 18.411 100 19 38 1 1860342032 5748864 5975232
23:25:32 11158 8192000000 10769360672 11196039168 1853742800 18.453 100 23 45 3 1866098640 5355200 7000640
23:25:49 7802 8192000000 10772539504 11199053824 1857974512 18.487 100 30 60 1 1872720640 5470576 9275552
23:26:03 8552 8192000000 10774111744 11202764800 1859428672 18.499 100 29 58 0 1873945616 6096816 8420128
23:26:21 10155 8192000000 10775423424 11206979584 1866059936 18.552 100 28 56 1 1880458208 5776720 8621552
23:26:38 17724 8192000000 10782563872 11209674752 1864420064 18.539 100 16 32 3 1873950800 4830192 4700544
23:27:01 106259 8192000000 10839676528 11250364416 1890969744 18.754 100 41 81 0 1912535024 10846064 10719216
23:29:00 25556 8192000000 10841752672 11262767104 1907055104 18.883 100 45 89 2 1931124656 11608240 12461312
23:29:48 14336 8192000000 10847896912 11270955008 1921722656 19.001 100 47 92 3 1945953648 11509904 12721088
23:30:09 11085 8192000000 10861045760 11281657856 1926198400 19.036 100 53 104 3 1952880864 11665456 15017008
23:30:26 18941 8192000000 10873486768 11294752768 1933562608 19.095 100 59 117 0 1964100432 14077248 16460576
23:30:54 22323 8192000000 10876711440 11305152512 1941645728 19.160 100 53 106 5 1974521168 17887840 14987600
23:31:25 18985 8192000000 10877836368 11306577920 1945955536 19.194 100 46 91 1 1971651584 12103056 13592992
23:31:52 35001 8192000000 10886928432 11326767104 1952934400 19.250 100 37 74 0 1982648928 18196208 11518320
23:32:49 22541 8192000000 10906425904 11332542464 1964284672 19.340 100 42 84 0 1996932528 20186512 12461344
23:33:21 14420 8192000000 10905337296 11342811136 1967297824 19.364 100 43 86 1 2000902736 20669216 12935696
23:33:45 5009 8192000000 10926747936 11352580096 1975913408 19.432 100 60 116 1 2013450368 20765792 16771168
23:33:58 27765 8192000000 10923392000 11357597696 1977566144 19.445 100 49 96 0 2012200736 21290720 13343872
23:34:33 5408 8192000000 10932834640 11361521664 1981878416 19.480 100 48 96 1 2019246368 23868240 13499712
23:34:48 9358 8192000000 10930635936 11367804928 1986727760 19.518 100 52 104 1 2029338112 27222752 15387600
23:35:06 13706 8192000000 10940589472 11374555136 1992732768 19.565 100 50 100 2 2030571152 23772160 14066224
23:35:28 3952 8192000000 10952162736 11384152064 1998793056 19.613 100 57 114 2 2045078288 29521120 16764112
23:35:42 2220 8192000000 10965240000 11389112320 2001169056 19.632 100 65 131 2 2049606896 29789872 18647968
23:35:51 4656 8192000000 10971241360 11390750720 2004691280 19.660 100 71 142 1 2057409968 32132736 20585952
23:36:05 5951 8192000000 10981731584 11401007104 2008602384 19.691 100 80 159 1 2066442048 34612832 23226832
23:36:17 4983 8192000000 10983827488 11402338304 2012445504 19.721 100 88 175 0 2073420960 35661408 25314048
23:36:29 2183 8192000000 10977974704 11395858432 2008100720 19.687 100 86 172 1 2068923232 35925184 24897328
23:36:43 3939 8192000000 10978566976 11387928576 1998368288 19.610 100 88 175 2 2057922224 34369840 25184096
23:36:53 2778 8192000000 10962908352 11385753600 1995832656 19.590 100 71 140 1 2050396720 33338032 21226032
23:37:07 4791 8192000000 10967441648 11392077824 2004354464 19.657 100 72 143 2 2059702992 33134928 22213600
23:37:22 2965 8192000000 10976364768 11395407872 1989025152 19.536 99 80 161 2 2047554704 34881248 23648304
23:37:32 8266 8192000000 10970764832 11395690496 2001812352 19.637 100 67 133 2 2056407456 35044176 19550928
23:37:53 5015 8192000000 10978953696 11409444864 2013112032 19.726 100 61 120 1 2067782304 37229552 17440720
23:38:05 6617 8192000000 10971511776 11402559488 1998411312 19.610 99 70 139 2 2054591184 35477200 20702672
23:38:23 6166 8192000000 10982490992 11403853824 2008024816 19.686 100 65 130 0 2063910240 35912880 19972544
23:38:37 8013 8192000000 10968720352 11389833216 1984446096 19.500 99 76 149 2 2041752368 34576512 22729760
23:38:52 5602 8192000000 10966486240 11383017472 1985770624 19.510 99 76 150 1 2043036160 34649184 22616352
23:39:05 2625 8192000000 10983620992 11405172736 2006294336 19.672 100 72 141 2 2064948448 37699840 20954272
23:39:15 3643 8192000000 10995881920 11413839872 2015260160 19.743 100 78 157 1 2077719504 39002528 23456816
23:39:27 3521 8192000000 11001873712 11420577792 2020067696 19.781 100 76 149 0 2081996704 38778032 23150976
23:39:39 4106 8192000000 11005035296 11420921856 2023425872 19.807 100 81 161 0 2086634336 39857456 23351008
23:39:52 2176 8192000000 10998154976 11410911232 2009818048 19.700 99 87 172 1 2075936480 40128448 25989984
23:40:02 4370 8192000000 11006677248 11418836992 2019726512 19.778 100 84 168 0 2087063552 41416064 25920976
23:40:15 4586 8192000000 10991298240 11408379904 2011990320 19.717 100 91 180 2 2081667808 42199568 27477920
23:40:26 2974 8192000000 11008074000 11417018368 2014699616 19.738 100 89 178 1 2084418000 42674528 27043856
23:40:37 6092 8192000000 10993086320 11413766144 2015456944 19.744 100 74 148 0 2080618192 42518928 22642320
23:40:50 3528 8192000000 10999674960 11423342592 2019766288 19.778 100 79 158 0 2085815392 42170832 23878272
23:41:04 1630 8192000000 10995655968 11407417344 2005400608 19.665 100 87 174 2 2074413024 43017280 25995136
23:41:12 3616 8192000000 10991063568 11408404480 1998246304 19.609 100 78 156 2 2069445248 47575760 23623184
23:41:23 2566 8192000000 10994031952 11412004864 2003934544 19.654 100 77 152 2 2071034704 42762192 24337968
23:41:34 1971 8192000000 11002795296 11421159424 2014369456 19.736 100 80 160 1 2088112720 48665664 25077600
23:41:45 2362 8192000000 11007809856 11425099776 2019279456 19.774 100 83 166 1 2090147840 45205744 25662640
23:41:55 1858 8192000000 10955222016 11368611840 1918988096 18.979 95 86 172 0 1992594528 45883440 27722992
23:42:04 4330 8192000000 10991606000 11402731520 1994808368 19.582 100 88 176 1 2070454432 48220384 27425680
23:42:16 3757 8192000000 10985328576 11397685248 1977501328 19.445 99 83 164 1 2052409680 48917168 25991184
23:42:27 4355 8192000000 10977697536 11396259840 1989015056 19.536 100 81 158 2 2062793472 48794864 24983552
23:42:41 3661 8192000000 10989109184 11409108992 1993591888 19.572 100 66 132 2 2062708048 48583904 20532256
23:42:51 3623 8192000000 10985910416 11403444224 1997029200 19.599 100 68 134 0 2064501056 46475200 20996656
23:43:02 5373 8192000000 10947114496 11362656256 1941546176 19.159 98 71 140 1 2010330448 46686752 22097520
23:43:16 3868 8192000000 10970675072 11386884096 1979528976 19.461 100 75 151 1 2054958784 50750208 24679600
23:43:31 4880 8192000000 10994642432 11406577664 1994504992 19.579 100 79 157 3 2072912144 52931248 25475904
23:43:45 2645 8192000000 10986701968 11395911680 1974376608 19.420 99 86 170 0 2054151424 53432064 26342752
23:43:56 3983 8192000000 10981776288 11397820416 1987476544 19.524 100 75 150 0 2065595168 53956064 24162560
23:44:09 2005 8192000000 10989899712 11401314304 1990859872 19.551 100 85 170 1 2071801472 54967792 25973808
23:44:19 1262 8192000000 10978237712 11390689280 1977353120 19.444 99 82 164 1 2060050272 56194016 26503136
23:44:29 1742 8192000000 10975875808 11378630656 1968660688 19.375 99 85 171 2 2050922096 56437072 25824336
23:44:37 4314 8192000000 10993140976 11407106048 1990486080 19.548 100 82 161 0 2074548256 57933008 26129168
23:44:48 5251 8192000000 11003867392 11417038848 2001025248 19.631 100 85 170 1 2087239952 59379520 26835184
23:45:03 1269 8192000000 10985135056 11395076096 1980669120 19.470 99 87 175 0 2061814976 54026160 27119696
23:45:13 3239 8192000000 11000315088 11414171648 1994084976 19.576 100 79 159 0 2073369584 54795488 24489120
23:45:23 2703 8192000000 11012755872 11420426240 2006133552 19.671 100 90 179 2 2089950544 55382416 28434576
23:45:35 1102 8192000000 11010034704 11419131904 2001952944 19.638 100 92 184 2 2080688448 50479728 28255776
23:45:45 1459 8192000000 10994715360 11400503296 1967159072 19.363 98 95 190 5 2044885920 48449296 29277552
23:45:55 1668 8192000000 10991979952 11405500416 1995198576 19.585 100 91 181 1 2072073408 48972240 27902592
23:46:04 1624 8192000000 10987394144 11395330048 1984074272 19.497 100 90 180 1 2061877712 49779920 28023520
23:46:12 1600 8192000000 10992343712 11403194368 1994597584 19.580 100 89 178 1 2074081296 51796144 27687568
23:46:21 7896 8192000000 10981768528 11395084288 1982134048 19.482 100 80 158 0 2061833504 55195856 24503600
23:46:36 2430 8192000000 10993262736 11403538432 1988241024 19.530 100 88 176 1 2073059312 57012608 27805680
23:46:47 2805 8192000000 10960863392 11369791488 1954077904 19.259 98 78 154 1 2032418656 53744656 24596096
23:46:59 2787 8192000000 10985066496 11391983616 1981059168 19.473 100 91 181 2 2063801264 54552416 28189680
23:47:10 1067 8192000000 10993599520 11400458240 1987703776 19.526 100 89 179 0 2072279104 56332688 28242640
23:47:18 1008 8192000000 10997346176 11406045184 1988047696 19.528 100 87 172 1 2072296704 57374656 26874352
23:47:27 4244 8192000000 11000169200 11407990784 1990448224 19.547 100 81 163 1 2071977792 54946768 26582800
23:47:38 12148 8192000000 10953714880 11394723840 1962628992 19.327 99 43 86 2 2029278112 51937232 14711888
23:48:04 18416 8192000000 10948218272 11390283776 1974770256 19.423 100 40 80 2 2038600736 50474528 13355952
23:48:37 16017 8192000000 10958478256 11395424256 1969201456 19.379 100 37 74 2 2038236816 55516832 13518528
23:49:00 7544 8192000000 10957358160 11393703936 1954327760 19.261 99 50 97 2 2027358768 55557520 17473488
23:49:16 9159 8192000000 10948675952 11386540032 1945264720 19.189 99 39 77 3 2021151168 60925792 14960656
23:49:47 11367 8192000000 10953256032 11383578624 1930179840 19.068 99 46 92 1 2017581664 70454096 16947728
23:50:06 18452 8192000000 10949530032 11389845504 1946564560 19.199 100 43 86 1 2029651808 67049392 16037856
23:50:33 13617 8192000000 10962394768 11404652544 1956959520 19.282 100 40 80 0 2045870944 73805728 15105696
23:50:55 5856 8192000000 10972685536 11409301504 1962463152 19.326 100 59 117 0 2052363664 69509120 20391392
23:51:24 23700 8192000000 10930956880 11399221248 1938981792 19.139 99 28 55 3 2013469968 63466096 11022080
23:51:59 25912 8192000000 10924076528 11385307136 1938632176 19.136 99 27 54 1 1993664144 45567344 9464624
23:52:37 25118 8192000000 10890044176 11362516992 1952466960 19.246 100 23 45 0 1997515456 37185728 7862768
23:53:10 26506 8192000000 10886210800 11354865664 1931884816 19.082 99 17 34 1 1964999856 27032736 6082304
23:53:45 78261 8192000000 10879761088 11335446528 1913350752 18.934 98 18 32 2 1930161696 12249200 4561744
23:55:11 2337 8192000000 10890304480 11337867264 1951883856 19.241 100 57 112 1 1976774848 8043200 16847792
23:55:19 9963 8192000000 10896930192 11343679488 1954513760 19.262 100 45 85 1 1976680896 10259344 11907792
23:55:48 51092 8192000000 10881509248 11342499840 1928298624 19.053 99 25 50 1 1946237552 10757312 7181616
23:56:46 103049 8192000000 10874746832 11336994816 1886134160 18.715 96 20 38 0 1908617344 16078816 6404368
23:58:42 28904 8192000000 10866744720 11335610368 1924449376 19.022 99 16 31 0 1937141136 8836272 3855488
23:59:19 28253 8192000000 10860478112 11326722048 1925782096 19.033 99 12 24 4 1937404112 9027136 2594880
00:00:09 46196 8192000000 10841606128 11301814272 1885980496 18.713 97 9 18 0 1895175040 7404080 1790464
00:01:01 41158 8192000000 10864335408 11326902272 1932314240 19.085 100 16 32 0 1945849424 9152576 4382608
00:02:02 18462 8192000000 10853203616 11319930880 1923293872 19.013 99 9 16 1 1934379968 8895696 2190400
00:02:30 23237 8192000000 10863252352 11330465792 1941895584 19.162 100 13 26 0 1952107232 7205504 3006144
00:02:59 67004 8192000000 10890139408 11351867392 1956524752 19.278 100 28 56 0 1972694848 7583840 8586256
00:05:10 53991 8192000000 10898256112 11357466624 1961985248 19.322 100 30 60 2 1977143424 6887440 8270736
00:06:11 66793 8192000000 10870084144 11347513344 1924345424 19.022 98 8 16 0 1934306112 8035568 1925120
00:07:24 60572 8192000000 10888462928 11344994304 1897252032 18.804 97 7 14 0 1910873664 11820480 1801152
00:08:32 49403 8192000000 10913360368 11362897920 1961699760 19.320 100 37 74 2 1983045008 10633584 10711664
00:09:29 37512 8192000000 10886306768 11346440192 1935840848 19.114 98 49 98 4 1965273680 14052896 15379936
00:10:30 69396 8192000000 10900161104 11368669184 1935510016 19.111 99 11 22 1 1957932672 19399472 3023184
00:11:45 70601 8192000000 10908934928 11376955392 1935678976 19.112 98 25 49 0 1956122512 13810704 6632832
00:13:05 70292 8192000000 10898736048 11377426432 1944733376 19.185 99 14 28 0 1967758272 18942192 4082704
00:14:27 66367 8192000000 10921206576 11354669056 1893653184 18.775 96 27 55 0 1909562528 7827472 8081872
00:15:41 80066 8192000000 10889434592 11351318528 1927559440 19.047 98 24 48 0 1946411856 11949936 6902480
00:17:12 38409 8192000000 10914623136 11372871680 1973439744 19.413 100 19 38 1 1989346128 10720336 5186048
00:18:03 57083 8192000000 10901965296 11369861120 1947408240 19.206 99 23 46 1 1970901616 16821008 6672368
00:19:16 107419 8192000000 10898918800 11366445056 1908933792 18.898 97 11 22 0 1934874560 23494336 2446432
00:21:21 117243 8192000000 10874230176 11340632064 1925268832 19.029 98 39 78 1 1950843952 13856016 11719104
00:23:24 63145 8192000000 10881827888 11347714048 1921710784 19.001 98 24 46 1 1947524816 19526144 6287888
00:24:33 45842 8192000000 10879480704 11354169344 1958314720 19.293 100 31 62 3 1993443280 26038512 9090048
00:25:31 63352 8192000000 10836492416 11313041408 1831297456 18.270 94 10 19 0 1843623440 9888720 2437264
00:26:41 39185 8192000000 10850234016 11330285568 1926590848 19.040 100 8 16 1 1941416240 12578512 2246880
00:27:26 8181 8192000000 10826469904 11292663808 1895648240 18.791 98 6 12 0 1910077792 13253024 1176528
00:27:40 59793 8192000000 10866210944 11329978368 1920562592 18.991 99 13 26 0 1936084080 12250864 3270624
00:28:49 70253 8192000000 10845055840 11316592640 1879864064 18.664 97 18 34 2 1899963520 15171920 4927536
00:30:06 13900 8192000000 10856652160 11328876544 1929691408 19.064 100 17 34 0 1949727312 15404928 4630976
00:30:27 14564 8192000000 10855338976 11339309056 1932641232 19.088 100 8 16 0 1952831616 18054528 2135856
00:30:50 16364 8192000000 10866741376 11344891904 1933818768 19.097 100 8 16 0 1954690080 18849728 2021584
00:31:12 81962 8192000000 10839342112 11300855808 1865373184 18.547 96 14 28 1 1881902480 12897856 3631440
00:32:41 54951 8192000000 10849689888 11322327040 1879478032 18.661 97 14 28 0 1895907920 12509552 3920336
00:33:50 84552 8192000000 10849413536 11318665216 1875640208 18.630 97 13 26 0 1888983984 10120656 3223120
00:35:31 16756 8192000000 10839849616 11271475200 1862597984 18.524 97 49 98 1 1883276112 6360320 14317808
00:35:57 24205 8192000000 10831168240 11288031232 1845458848 18.385 96 29 58 2 1864465808 10384544 8622416
00:36:28 76763 8192000000 10884938432 11332804608 1907546240 18.887 99 29 58 3 1933258144 17971104 7740800
00:37:53 17767 8192000000 10879354656 11326181376 1938493984 19.135 100 61 122 1 1968460160 12244144 17722032
00:38:17 44734 8192000000 10884133200 11343495168 1930822224 19.073 99 35 70 2 1960601184 19888384 9890576
00:39:08 91774 8192000000 10871951568 11352334336 1903342592 18.853 98 9 18 0 1929692256 23720464 2629200
00:40:46 116757 8192000000 10881647760 11355873280 1888661728 18.735 97 8 16 0 1909290256 18054416 2574112
00:42:49 181242 8192000000 10886747104 11358228480 1880590336 18.670 96 14 28 0 1904634496 20043344 4000816
00:46:22 79117 8192000000 10851905248 11308113920 1837032912 18.317 94 25 50 3 1855578240 12173904 6371424
00:47:47 23809 8192000000 10872609328 11325431808 1937395120 19.126 100 33 66 1 1955148288 8553504 9199664
00:48:35 45329 8192000000 10846523904 11319058432 1898941392 18.818 98 13 26 0 1911212704 8764288 3507024
00:50:02 67484 8192000000 10890560672 11355086848 1955304144 19.269 100 14 28 0 1968453808 9225696 3923968
00:51:35 69906 8192000000 10869182784 11351408640 1935550000 19.111 99 13 26 1 1948351392 9412368 3389024
00:52:54 30191 8192000000 10853909168 11333124096 1934147024 19.100 99 7 14 0 1945655392 9471504 2036864
00:53:33 75930 8192000000 10864600032 11341320192 1918859040 18.978 98 12 24 0 1932835536 10676608 3299888
00:55:36 56681 8192000000 10882671664 11356008448 1939724032 19.145 99 15 30 1 1952440192 8718672 3997488
00:56:44 64203 8192000000 10890114288 11357323264 1912072816 18.923 97 15 30 0 1924306528 8439152 3794560
00:58:48 66222 8192000000 10894742192 11369373696 1937624032 19.128 98 15 30 0 1951996256 10484832 3887392
01:00:07 84681 8192000000 10914442768 11377758208 1925425888 19.030 97 20 38 2 1941759408 11361952 4971568
01:01:38 63676 8192000000 10911684224 11397775360 1970079792 19.386 99 26 52 1 1990482496 12747664 7655040
01:02:51 92044 8192000000 10928178096 11392421888 1952934352 19.250 98 15 30 0 1969004704 12115280 3955072
01:04:29 20711 8192000000 10932516912 11390263296 1979984208 19.465 99 38 76 0 1999509808 9271424 10254176
01:05:00 64335 8192000000 10891274384 11363139584 1924940144 19.026 97 26 52 0 1944784288 12736304 7107840
01:06:16 52860 8192000000 10889306128 11360944128 1893878240 18.777 96 30 60 0 1915637296 13072128 8686928
01:07:26 164882 8192000000 10900352720 11366780928 1792190928 17.950 91 8 16 0 1807195072 12946080 2058064
01:10:22 81021 8192000000 10892692928 11373191168 1947389280 19.206 99 13 26 2 1967391040 16377824 3623936
01:11:50 76829 8192000000 10889487872 11360325632 1931207984 19.077 98 23 46 0 1950681168 12571088 6902096
01:13:15 77836 8192000000 10890104768 11380752384 1965311600 19.348 100 7 14 2 1984634624 17177904 2145120
01:14:42 33397 8192000000 10903143984 11361984512 1954369872 19.261 99 21 42 0 1970972640 10416208 6186560
01:15:33 66149 8192000000 10876794400 11359383552 1933125296 19.092 98 16 32 1 1946008864 8224128 4659440
01:16:52 69457 8192000000 10858866704 11344011264 1903113856 18.851 97 8 16 0 1915548960 10004752 2430352
01:18:10 49859 8192000000 10867465488 11335065600 1911605312 18.920 98 10 19 1 1921946944 7810336 2531296
01:19:19 52852 8192000000 10852556416 11325652992 1903772064 18.857 97 16 33 0 1918086528 9714464 4600000
01:20:37 58182 8192000000 10870521584 11339489280 1930163184 19.068 99 19 38 1 1943479328 7928288 5387856
01:21:45 66489 8192000000 10866555968 11346407424 1905851776 18.873 98 14 28 1 1920167696 9994320 4321600
01:23:01 90341 8192000000 10845650208 11323215872 1813470400 18.124 93 10 20 0 1829646112 13046576 3129136
01:24:47 57162 8192000000 10850365552 11323842560 1886234592 18.715 97 16 33 3 1900068176 8126880 5706704
01:25:55 25443 8192000000 10865970912 11334610944 1921375184 18.998 99 25 50 0 1938910384 10113808 7421392
01:26:35 46928 8192000000 9357434592 9634693120 513139408 5.894 27 7 14 1 518921872 3833232 1949232

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 23-01-2021 01:28:33 to 23-01-2021 01:29:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 147 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-01-2021 01:29:05 to 23-01-2021 01:29:07.

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          237980
MON$OLDEST_ACTIVE               239387
MON$OLDEST_SNAPSHOT             239387
MON$NEXT_TRANSACTION            239387
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                       2018240
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.33403 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33403 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33403 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33403 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 ---
:285: 
:286: mscs-test-161.budzdorov.ru    Sat Jan 23 01:27:27 2021
:287:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:288: 
--- end of diff output ---

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

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