Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 30.01.2021 22: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 17215612 kB
MemAvailable 31231364 kB
Buffers 0 kB
Cached 14457048 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-30 22:27:15
DTS_END                         2021-01-30 22:27:15.2840
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/44724
TRN_ID                          240493
ATT_ID                          710
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: 8971.66 24623 1076599
customer order: creation 170.74 365 20489
customer order: refuse 14.73 360 1768
order to supplier: creation 46.18 1380 5541
order to supplier: removal 3.47 100835 416
invoice (draft): creation 44.56 3713 5347
invoice (draft): removal 51.25 799 6150
invoice accept: apply 41.28 18990 4953
invoice accept: cancel 45.92 849 5510
customer reserve: creation 3715.42 191 445850
customer reserve: removal 4543.45 60 545214
realization accept: apply 83.58 221 10029
realization accept: cancel 81.26 108 9751
payment from customer: creation 60.56 159 7267
payment from customer: removal 5.38 95 646
payment to supplier: creation 48.44 173 5813
payment to supplier: removal 3.31 77 397
service: total inventory turnovers 4.63 1308 555
service: total monetary turnovers 6.68 45 801
service: aggregate perf. data 0.82 23180 98
service: refresh index statistics 0.03 339559 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 30-01-2021 22:28:18 to 30-01-2021 22:28:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4888
TEST_TIME 2 3269
TEST_TIME 3 3923
TEST_TIME 4 4864
TEST_TIME 5 4591
TEST_TIME 6 4513
TEST_TIME 7 4923
TEST_TIME 8 5093
TEST_TIME 9 5313
TEST_TIME 10 5600
TEST_TIME 11 6314
TEST_TIME 12 6844
TEST_TIME 13 6981
TEST_TIME 14 7689
TEST_TIME 15 7832
TEST_TIME 16 8114
TEST_TIME 17 8241
TEST_TIME 18 8235
TEST_TIME 19 8346
TEST_TIME 20 8546
TEST_TIME 21 8973
TEST_TIME 22 9318
TEST_TIME 23 9188
TEST_TIME 24 9535
TEST_TIME 25 9702
TEST_TIME 26 9944
TEST_TIME 27 10390
TEST_TIME 28 10192
TEST_TIME 29 11116
TEST_TIME 30 11032
TEST_TIME 31 10842
TEST_TIME 32 10825
TEST_TIME 33 10658
TEST_TIME 34 10515
TEST_TIME 35 10344
TEST_TIME 36 10152
TEST_TIME 37 10083
TEST_TIME 38 9901
TEST_TIME 39 10054
TEST_TIME 40 9964
TEST_TIME 41 9834
TEST_TIME 42 9760
TEST_TIME 43 9741
TEST_TIME 44 9665
TEST_TIME 45 9620
TEST_TIME 46 9480
TEST_TIME 47 9496
TEST_TIME 48 9361
TEST_TIME 49 9294
TEST_TIME 50 9149
TEST_TIME 51 9109
TEST_TIME 52 9127
TEST_TIME 53 9002
TEST_TIME 54 8983
TEST_TIME 55 8974
TEST_TIME 56 9046
TEST_TIME 57 9074
TEST_TIME 58 9037
TEST_TIME 59 9024
TEST_TIME 60 9146
TEST_TIME 61 9106
TEST_TIME 62 9124
TEST_TIME 63 9159
TEST_TIME 64 9217
TEST_TIME 65 9242
TEST_TIME 66 9226
TEST_TIME 67 9247
TEST_TIME 68 9302
TEST_TIME 69 9394
TEST_TIME 70 9386
TEST_TIME 71 9301
TEST_TIME 72 9265
TEST_TIME 73 9268
TEST_TIME 74 9202
TEST_TIME 75 9146
TEST_TIME 76 9106
TEST_TIME 77 9088
TEST_TIME 78 9033
TEST_TIME 79 8949
TEST_TIME 80 9009
TEST_TIME 81 9122
TEST_TIME 82 9108
TEST_TIME 83 9110
TEST_TIME 84 9083
TEST_TIME 85 9162
TEST_TIME 86 9232
TEST_TIME 87 9195
TEST_TIME 88 9168
TEST_TIME 89 9241
TEST_TIME 90 9229
TEST_TIME 91 9274
TEST_TIME 92 9310
TEST_TIME 93 9331
TEST_TIME 94 9279
TEST_TIME 95 9225
TEST_TIME 96 9181
TEST_TIME 97 9203
TEST_TIME 98 9167
TEST_TIME 99 9125
TEST_TIME 100 9093
TEST_TIME 101 9097
TEST_TIME 102 9035
TEST_TIME 103 8998
TEST_TIME 104 9025
TEST_TIME 105 9027
TEST_TIME 106 8999
TEST_TIME 107 8986
TEST_TIME 108 8972
TEST_TIME 109 8954
TEST_TIME 110 8962
TEST_TIME 111 8958
TEST_TIME 112 8968
TEST_TIME 113 8955
TEST_TIME 114 8937
TEST_TIME 115 8920
TEST_TIME 116 8917
TEST_TIME 117 8956
TEST_TIME 118 8976
TEST_TIME 119 9022
TEST_TIME 120 8975

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 30-01-2021 22:28:21 to 30-01-2021 22:28:25.

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 1491259 1491259 0 0.00 0 21608 7 0 0
doc_list_biud 1491257 1491257 0 0.00 0 61746 28 0 0
sp_add_invoice_to_stock 5079 4953 126 2.48 17 200981 18990 0 126
sp_cancel_adding_invoice 5510 5510 0 0.00 5 62411 849 0 0
sp_cancel_client_order 1768 1768 0 0.00 4 8740 361 0 0
sp_cancel_customer_reserve 545214 545214 0 0.00 1 61749 60 0 0
sp_cancel_pay_from_customer 646 646 0 0.00 2 10705 96 0 0
sp_cancel_pay_to_supplier 397 397 0 0.00 3 1785 78 0 0
sp_cancel_supplier_invoice 6159 6150 9 0.14 1 27991 799 0 9
sp_cancel_supplier_order 416 416 0 0.00 8 1028066 100836 0 0
sp_cancel_write_off 9751 9751 0 0.00 1 9108 108 0 0
sp_client_order 20489 20489 0 0.00 4 28114 366 0 0
sp_customer_reserve 445850 445850 0 0.00 0 136476 191 0 0
sp_fill_shopping_cart 31373 31373 0 0.00 1 13759 45 0 0
sp_fill_shopping_cart_clo_res 445841 445841 0 0.00 0 15560 14 0 0
sp_get_clo_for_invoice 4944 4944 0 0.00 0 23942 392 0 0
sp_kill_cost_storno 16304 16304 0 0.00 0 12323 62 0 0
sp_kill_qstorno_ret_qs2qd 1106745 1106745 0 0.00 0 61466 32 0 0
sp_kill_qty_storno 583782 583782 0 0.00 0 61746 71 0 0
sp_lock_selected_doc 20755 20755 0 0.00 0 6500 3 0 0
sp_make_cost_storno 28053 28053 0 0.00 0 21566 79 0 0
sp_multiply_rows_for_pdistr 28052 28052 0 0.00 0 7290 31 0 0
sp_multiply_rows_for_qdistr 20489 20489 0 0.00 0 26258 137 0 0
sp_pay_from_customer 7267 7267 0 0.00 4 19527 160 0 0
sp_pay_to_supplier 5813 5813 0 0.00 5 24192 173 0 0
sp_payment_common 13079 13079 0 0.00 1 24117 45 0 0
sp_qd_handle_on_cancel_clo 1768 1768 0 0.00 0 8728 332 0 0
sp_qd_handle_on_invoice_upd_sts 10454 10454 0 0.00 0 44457 361 0 0
sp_qd_handle_on_reserve_upd_sts 10029 10029 0 0.00 0 9532 62 0 0
sp_reserve_write_off 10029 10029 0 0.00 7 14099 222 0 0
sp_supplier_invoice 5347 5347 0 0.00 7 75636 3714 0 0
sp_supplier_order 5541 5541 0 0.00 5 49034 1381 0 0
srv_aggregate_perf_data 98 98 0 0.00 2544 306892 23181 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1304 177041 32120 0 0
srv_find_qd_qs_mism 1030463 1030463 0 0.00 0 9994 5 0 0
srv_make_invnt_saldo 555 555 0 0.00 31 117370 1309 0 0
srv_make_money_saldo 801 801 0 0.00 1 9971 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 243537 451373 339560 0 0
t$perf-abend:sp_add_invoice_to_stock 126 126 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4953 4953 0 0.00 0 9111 165 0 0
t$perf-norm:sp_cancel_adding_invoice 379 379 0 0.00 1 12312 156 0 0
t$perf-norm:sp_cancel_client_order 1768 1768 0 0.00 0 3458 17 0 0
t$perf-norm:sp_cancel_customer_reserve 719 719 0 0.00 0 433 6 0 0
t$perf-norm:sp_cancel_pay_from_customer 646 646 0 0.00 0 326 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 397 397 0 0.00 0 3920 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 7743 39 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 25460 1664 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 6648 19 0 0
t$perf-norm:sp_client_order 20489 20489 0 0.00 0 16385 20 0 0
t$perf-norm:sp_customer_reserve 1014 1014 0 0.00 0 7614 21 0 0
t$perf-norm:sp_pay_from_customer 7267 7267 0 0.00 0 18032 14 0 0
t$perf-norm:sp_pay_to_supplier 5813 5813 0 0.00 0 8925 10 0 0
t$perf-norm:sp_reserve_write_off 10029 10029 0 0.00 0 12841 15 0 0
t$perf-norm:sp_supplier_invoice 5347 5347 0 0.00 0 15906 20 0 0
t$perf-norm:sp_supplier_order 5541 5541 0 0.00 0 8579 18 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 3945 46 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 767 15 0 0
t$perf-norm:srv_make_invnt_saldo 555 555 0 0.00 0 4659 31 0 0
t$perf-norm:srv_make_money_saldo 801 801 0 0.00 0 1293 20 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 10134 9882 252 2.48 0 12846 26 0 252
v_all_customers 37560 37560 0 0.00 0 58 1 0 0
v_all_suppliers 30080 30080 0 0.00 0 25 1 0 0
v_all_wares 40976 40976 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 758 758 0 0.00 0 12671 26 0 0
v_cancel_client_order 3536 3536 0 0.00 0 2670 6 0 0
v_cancel_customer_prepayment 1292 1292 0 0.00 0 10685 17 0 0
v_cancel_customer_reserve 1438 1438 0 0.00 0 3378 6 0 0
v_cancel_payment_to_supplier 794 794 0 0.00 0 1511 7 0 0
v_cancel_supplier_invoice 828 810 18 2.17 0 1980 22 0 18
v_cancel_supplier_order 832 832 0 0.00 0 11457 32 0 0
v_cancel_write_off 2110 2110 0 0.00 0 1935 18 0 0
v_max_id_clo_ord 5539 5539 0 0.00 0 2559 2 0 0
v_max_id_clo_res 1014 1014 0 0.00 0 3667 16 0 0
v_max_id_ord_sup 5345 5345 0 0.00 0 5237 4 0 0
v_max_non_paid_invoice 1657 1657 0 0.00 0 444 3 0 0
v_max_non_paid_realizn 3873 3873 0 0.00 0 1507 3 0 0
v_min_id_clo_ord 5539 5539 0 0.00 0 12400 14 0 0
v_min_id_clo_res 1014 1014 0 0.00 0 3953 12 0 0
v_min_id_ord_sup 5345 5345 0 0.00 0 4663 8 0 0
v_min_non_paid_invoice 5813 5813 0 0.00 0 24112 32 0 0
v_min_non_paid_realizn 7266 7266 0 0.00 0 8635 25 0 0
v_our_firm 10202 10202 0 0.00 0 22 1 0 0
v_reserve_write_off 20058 20058 0 0.00 0 12313 13 0 0
x_lock_depdocs_on_canc_invoice 11255 11255 0 0.00 0 14955 131 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 8572 379 0 0
x_make_qstorno_1000_1200 5541 5541 0 0.00 2 49016 1281 0 0
x_make_qstorno_1200_2000 5347 5347 0 0.00 3 74615 3561 0 0
x_make_qstorno_2100_3300 445850 445850 0 0.00 0 136475 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 30-01-2021 22:28:26 to 30-01-2021 22:28:30.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:19 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:25 9214 8192000000 10140953264 10450505728 884696144 9.746 72 56 113 0 905793632 2471744 18625744
19:57:45 27061 8192000000 10314970096 10625392640 1350339728 14.151 100 81 162 0 1382480752 4479840 27661184
19:58:26 7103 8192000000 10342401504 10661666816 1405299216 14.642 100 92 184 1 1441745920 5679648 30767056
19:58:46 22681 8192000000 10391766976 10715185152 1443858704 14.984 100 85 170 1 1478260672 6447536 27954432
19:59:20 17432 8192000000 10412370656 10743029760 1471154128 15.224 100 89 178 0 1507524944 7374672 28996144
19:59:50 20895 8192000000 10433756768 10766598144 1489550352 15.385 100 85 170 0 1525135056 7995088 27589616
20:00:24 28129 8192000000 10472134272 10808086528 1520513728 15.655 100 90 180 0 1558044736 8900528 28630480
20:01:01 16201 8192000000 10476318992 10820046848 1533295408 15.766 100 81 162 1 1568142048 9294112 25552528
20:01:25 18541 8192000000 10500851104 10848526336 1560343424 15.999 100 84 168 1 1596121712 9708576 26069712
20:01:53 17199 8192000000 10536254976 10889826304 1587106288 16.229 100 76 152 0 1619501216 9722928 22672000
20:02:23 14194 8192000000 10570602464 10926391296 1628195168 16.580 100 89 178 0 1665845120 10346656 27303296
20:02:48 6344 8192000000 10576256528 10935279616 1638092976 16.664 100 83 167 0 1673394320 10801328 24500016
20:03:02 13332 8192000000 10597558528 10957176832 1653294880 16.792 100 83 166 1 1688819968 10849408 24675680
20:03:25 11271 8192000000 10606244816 10969890816 1666287584 16.902 100 75 150 0 1699938640 11669200 21981856
20:03:47 12951 8192000000 10620235712 10987745280 1684667088 17.057 100 76 150 1 1718860832 11660208 22533536
20:04:08 8128 8192000000 10632484512 11006382080 1697880512 17.167 100 75 148 2 1731588352 11986816 21721024
20:04:25 10011 8192000000 10651282000 11024621568 1712947712 17.293 100 81 161 1 1748664128 11996496 23719920
20:04:42 6965 8192000000 10659101280 11035279360 1723969088 17.385 100 76 151 1 1758054720 12008560 22077072
20:04:57 7150 8192000000 10672882656 11049496576 1737688064 17.499 100 86 167 0 1773719856 12243776 23788016
20:05:13 7062 8192000000 10694652112 11074543616 1756934256 17.659 100 87 170 0 1793403504 13051232 23418016
20:05:27 5753 8192000000 10696238960 11074564096 1760106080 17.685 100 82 165 1 1797522160 14025088 23390992
20:05:40 5422 8192000000 10707787888 11086741504 1768424896 17.754 100 80 158 1 1803600704 13240528 21935280
20:05:52 4926 8192000000 10716450640 11097686016 1777556304 17.829 100 88 177 0 1816003376 13672960 24774112
20:06:04 5994 8192000000 10729451616 11110801408 1788285152 17.918 100 72 144 1 1820567408 12785168 19497088
20:06:16 3559 8192000000 10736833600 11118157824 1794381248 17.968 100 86 173 2 1831745744 13908832 23455664
20:06:27 5004 8192000000 10732982672 11113750528 1797279376 17.992 100 83 166 2 1835166656 14560432 23326848
20:06:38 2624 8192000000 10754085120 11132043264 1805364480 18.058 100 91 178 1 1845374032 14848208 25161344
20:06:48 2255 8192000000 10756682480 11141013504 1813462896 18.124 100 91 181 1 1852625536 13975680 25186960
20:07:02 1883 8192000000 10757945680 11140472832 1818342000 18.164 100 82 164 1 1854732496 14025808 22364688
20:07:11 1641 8192000000 10770689264 11157598208 1821788096 18.192 100 80 155 2 1855796240 12715552 21292592
20:07:20 2139 8192000000 10781393008 11165372416 1841406480 18.352 100 92 185 2 1880419824 12692560 26320784
20:07:28 2382 8192000000 10783451648 11171672064 1845135712 18.383 100 90 180 1 1883394400 12581680 25677008
20:07:37 1514 8192000000 10798541168 11184193536 1852892512 18.446 100 93 181 2 1890282848 12013568 25376768
20:07:45 2046 8192000000 10790124704 11183955968 1861008032 18.511 100 90 182 0 1899608992 12496368 26104592
20:07:53 2324 8192000000 10807857360 11196235776 1858049792 18.487 100 91 182 1 1897326432 14050672 25225968
20:08:02 1606 8192000000 10803213424 11195891712 1862289216 18.522 100 94 186 3 1901634464 13858208 25487040
20:08:10 1406 8192000000 10807645088 11193589760 1864207920 18.537 100 90 181 0 1901453552 12423216 24822416
20:08:18 1895 8192000000 10814153488 11201519616 1869516464 18.580 100 94 187 4 1909459600 13243552 26699584
20:08:26 1468 8192000000 10808430000 11200593920 1868124720 18.569 100 94 188 1 1907822976 12882368 26815888
20:08:34 29948 8192000000 10781575728 11195080704 1861464752 18.515 100 47 94 0 1885425040 10155584 13804704
20:09:10 13835 8192000000 10811210288 11208425472 1869512880 18.580 100 72 143 2 1896654864 7478480 19663504
20:09:31 1559 8192000000 10822936000 11215233024 1880203248 18.667 100 90 178 2 1917590912 11401296 25986368
20:09:39 7130 8192000000 10818806416 11212431360 1874569936 18.621 100 80 160 4 1910194544 12561264 23063344
20:09:52 20892 8192000000 10778834576 11200057344 1866515984 18.556 100 40 80 0 1886232176 8343072 11373120
20:10:23 4637 8192000000 10785432768 11207012352 1869390128 18.579 100 33 66 3 1884794976 6296320 9108528
20:10:34 8937 8192000000 10775889600 11204952064 1866385888 18.555 100 18 36 1 1877421776 6224976 4810912
20:10:51 4140 8192000000 10792284720 11209838592 1870503232 18.588 100 29 58 2 1885767840 7371824 7892784
20:11:06 4284 8192000000 10787613232 11212898304 1874591184 18.621 100 41 80 1 1895342864 8077968 12673712
20:11:19 9272 8192000000 10786022864 11210059776 1873819744 18.615 100 30 59 1 1887265456 5991200 7454512
20:11:34 6540 8192000000 10791216400 11214389248 1873965728 18.616 100 26 51 0 1887879312 6756320 7157264
20:11:48 11779 8192000000 10791357472 11220156416 1876340096 18.636 100 16 32 0 1887166576 5990640 4835840
20:12:08 14199 8192000000 10787646080 11220049920 1879578016 18.662 100 20 40 1 1895178560 10316816 5283728
20:12:28 9685 8192000000 10787367488 11219968000 1881250128 18.675 100 14 28 0 1891172944 5981216 3941600
20:12:44 11629 8192000000 10794079344 11224162304 1882381056 18.684 100 13 26 1 1891446496 5581424 3484016
20:13:06 10397 8192000000 10807216592 11236245504 1888265616 18.732 100 25 50 4 1909897504 14671808 6960080
20:13:23 8258 8192000000 10794414400 11229245440 1888016016 18.730 100 19 38 2 1899332960 5614448 5702496
20:13:40 17764 8192000000 10816212592 11235467264 1892648992 18.767 100 33 66 2 1908452480 6441392 9362096
20:14:04 61094 8192000000 10823967536 11241705472 1892129792 18.763 100 42 86 2 1909366560 5229216 12007552
20:15:12 5622 8192000000 10805520416 11242971136 1893588016 18.775 100 32 63 3 1910011376 7566336 8857024
20:15:27 6468 8192000000 10805206240 11235995648 1892686368 18.767 100 26 49 1 1906376592 6275136 7415088
20:15:41 6634 8192000000 10815059392 11245907968 1899503616 18.822 100 41 82 1 1918454160 7038128 11912416
20:15:54 1222 8192000000 10823921728 11239350272 1894920608 18.785 100 43 85 1 1915088272 7773248 12394416
20:16:03 6298 8192000000 10819835024 11238965248 1890653136 18.751 100 40 79 3 1910704896 7710624 12341136
20:16:19 5774 8192000000 10827590352 11248459776 1895878064 18.793 100 26 52 1 1913724112 9591248 8254800
20:16:33 6209 8192000000 10803531040 11240714240 1896581728 18.799 100 25 50 1 1909019840 5476592 6961520
20:16:46 7881 8192000000 10788705632 11222093824 1841403296 18.352 97 29 58 2 1854920496 5205424 8311776
20:16:59 5623 8192000000 10802054576 11232710656 1886982592 18.721 100 28 56 0 1900238224 5344976 7910656
20:17:12 7734 8192000000 10789363088 11225296896 1862039408 18.520 99 18 36 1 1872581344 5398848 5143088
20:17:29 10330 8192000000 10784227104 11210743808 1844667296 18.379 98 28 57 0 1858252512 4978912 8606304
20:17:47 10490 8192000000 10774264416 11201298432 1813601248 18.125 97 21 42 1 1824641168 5254736 5785184
20:18:03 7604 8192000000 10774602896 11203158016 1843168672 18.367 99 19 37 1 1854129216 5879680 5080864
20:18:18 8914 8192000000 10764369600 11181371392 1785366912 17.894 96 15 31 2 1794317952 5020224 3930816
20:18:33 56743 8192000000 10738743456 11146829824 1744101680 17.553 94 43 86 1 1763155872 7528368 11525824
20:19:38 13483 8192000000 10691802528 11108102144 1703106928 17.211 93 18 36 1 1713430160 4728672 5594560
20:19:58 4212 8192000000 10686861360 11106488320 1726208288 17.404 96 32 64 1 1741682416 5698816 9775312
20:20:09 5682 8192000000 10702333792 11113897984 1758871024 17.675 98 36 72 0 1775335216 6793840 9670352
20:20:23 5054 8192000000 10691987904 11091873792 1714799680 17.309 96 45 90 2 1735272288 7734192 12738416
20:20:37 5780 8192000000 10700615888 11107090432 1737331760 17.496 97 41 82 2 1756446528 6916848 12197920
20:20:49 4125 8192000000 10713656256 11121381376 1783035936 17.874 100 34 68 3 1799424512 6613792 9774784
20:21:00 4499 8192000000 10715802448 11118825472 1757015168 17.660 98 38 76 4 1775392368 6320640 12056560
20:21:10 7303 8192000000 10709961104 11130261504 1786861296 17.906 99 22 44 0 1799015024 6004720 6149008
20:21:26 7372 8192000000 10721412752 11134091264 1778418656 17.836 98 31 61 3 1792355312 5294320 8642336
20:21:41 6886 8192000000 10724942064 11145551872 1814544528 18.133 100 24 46 3 1826405056 5817088 6043440
20:21:55 7303 8192000000 10727644416 11141079040 1783932544 17.882 98 32 64 4 1799938800 5683520 10322736
20:22:12 6389 8192000000 10711269616 11122597888 1781926032 17.865 99 26 52 2 1795906576 6330688 7649856
20:22:27 7252 8192000000 10719983088 11139555328 1808447504 18.083 100 33 65 2 1828349264 10070384 9831376
20:22:41 9744 8192000000 10744960352 11165696000 1824056560 18.211 100 26 52 3 1840889712 9417696 7415456
20:22:57 49226 8192000000 10763589712 11183169536 1820441344 18.181 99 28 54 2 1833190480 4682480 8066656
20:24:02 27435 8192000000 10759099408 11187306496 1833574912 18.288 99 20 39 0 1848686752 9961376 5150464
20:24:36 7455 8192000000 10765570656 11191660544 1856170384 18.472 100 29 58 1 1871076288 6765504 8140400
20:24:51 5223 8192000000 10768220512 11196211200 1857817488 18.486 100 32 64 0 1874169968 6512592 9839888
20:25:04 6169 8192000000 10784315472 11205267456 1859610400 18.500 100 25 50 2 1876033216 9930896 6491920
20:25:19 6683 8192000000 10779163056 11202695168 1867022512 18.560 100 30 60 2 1881726688 6054880 8649296
20:25:33 6430 8192000000 10781036032 11207925760 1864322032 18.538 100 26 52 1 1877742384 6182128 7238224
20:25:45 5291 8192000000 10779853712 11205414912 1864517328 18.540 100 20 40 1 1875913376 5313712 6082336
20:25:58 7669 8192000000 10783179104 11210846208 1867657440 18.565 100 26 52 0 1880895088 5630448 7607200
20:26:12 8214 8192000000 10795046320 11214999552 1869078528 18.577 100 23 46 1 1881040272 5578656 6383088
20:26:26 14509 8192000000 10784283232 11214368768 1871382272 18.595 100 18 36 1 1882280608 5425856 5472480
20:26:51 10034 8192000000 10789038640 11219496960 1876028048 18.633 100 13 27 1 1885331440 5641616 3661776
20:27:09 7473 8192000000 10810712528 11240538112 1892940544 18.769 100 15 30 1 1902106480 5187936 3978000
20:27:25 39566 8192000000 10839703776 11256725504 1912832240 18.929 100 40 79 3 1930161264 6192608 11136416
20:28:14 10049 8192000000 10860920064 11272462336 1920990080 18.995 100 55 108 0 1946343424 9624800 15728544
20:28:34 25480 8192000000 10854739552 11275812864 1926198768 19.036 100 59 118 1 1954358912 10644864 17515280
20:29:17 73890 8192000000 10861107184 11289108480 1933602960 19.096 100 44 86 0 1961682192 15248896 12830336
20:30:39 31816 8192000000 10862902000 11299274752 1937123840 19.124 100 38 76 0 1962373840 14495200 10754800
20:31:21 43549 8192000000 10861790640 11308429312 1946735824 19.200 100 30 60 1 1968707600 12830992 9140784
20:32:11 8976 8192000000 10883330928 11315109888 1955603120 19.271 100 44 88 0 1982569808 13414704 13551984
20:32:30 5243 8192000000 10907816880 11326615552 1961778144 19.320 100 55 108 1 1992668320 14445664 16444512
20:32:42 8654 8192000000 10899687568 11328229376 1965490768 19.350 100 57 114 1 1998968816 16649408 16828640
20:33:06 3805 8192000000 10912271184 11332685824 1969918160 19.385 100 61 121 1 2008449696 21609568 16921968
20:33:27 12246 8192000000 10918371376 11345731584 1974367728 19.420 100 56 112 1 2008205744 17650288 16187728
20:33:46 6729 8192000000 10917248784 11345014784 1976474848 19.437 100 54 108 2 2010093344 18160240 15458256
20:34:04 11604 8192000000 10922859744 11349262336 1978247808 19.451 100 50 98 2 2011594576 18062496 15284272
20:34:25 16419 8192000000 10912604864 11343470592 1973375440 19.412 100 49 96 2 2006628048 18950112 14302496
20:34:48 6301 8192000000 10925662288 11349868544 1979408576 19.460 100 54 108 2 2012504208 17616944 15478688
20:35:05 3280 8192000000 10935165584 11354206208 1987520336 19.524 100 71 140 3 2027275024 18243456 21511232
20:35:17 3002 8192000000 10933681312 11357511680 1988353600 19.531 100 71 142 2 2026433792 17589456 20490736
20:35:29 10103 8192000000 10939506960 11365269504 1988765568 19.534 100 59 118 1 2025477136 19166128 17545440
20:35:50 5160 8192000000 10939016864 11363528704 1993075120 19.568 100 59 118 0 2029193744 19627184 16491440
20:36:06 19158 8192000000 10942728832 11376279552 1996091072 19.592 100 52 104 3 2033806512 22546848 15168592
20:36:33 2840 8192000000 10941565712 11369402368 1992475904 19.563 100 70 139 2 2038192912 24656944 21060064
20:36:43 12850 8192000000 10926356240 11356438528 1952280304 19.245 98 55 108 1 1994870752 25974672 16615776
20:37:05 16297 8192000000 10935650640 11369148416 1975320688 19.428 100 46 92 2 2021329968 31855296 14153984
20:37:30 4734 8192000000 10956149264 11380592640 1996096384 19.592 100 83 166 3 2052660224 30587664 25976176
20:37:44 9527 8192000000 10964297248 11390488576 2000999120 19.631 100 70 139 1 2054742240 32362496 21380624
20:38:04 5615 8192000000 10968645312 11390164992 1997918208 19.606 100 74 148 2 2052956096 32823744 22214144
20:38:21 5967 8192000000 10959855824 11383316480 1991531968 19.556 100 73 147 1 2048667504 34943952 22191584
20:38:36 2573 8192000000 10951114544 11376439296 1981963312 19.480 100 72 138 2 2039244224 35341328 21939584
20:38:47 3708 8192000000 10963262864 11387154432 1990401328 19.547 100 71 140 2 2050761760 38806704 21553728
20:38:59 6753 8192000000 10951061904 11374641152 1988739472 19.534 100 80 158 1 2045914016 33271872 23902672
20:39:14 1926 8192000000 10964308560 11376529408 1985414016 19.508 100 84 162 1 2045113152 35451520 24247616
20:39:23 2967 8192000000 10965718416 11384848384 1989044416 19.536 100 80 158 0 2049252176 35882144 24325616
20:39:32 3776 8192000000 10963771888 11390279680 1995143936 19.584 100 78 154 2 2053320928 34060512 24116480
20:39:43 6681 8192000000 10957907184 11386515456 1990346144 19.547 100 65 129 2 2042002896 31974240 19682512
20:39:57 2988 8192000000 10949894304 11368570880 1982352656 19.483 100 72 143 0 2036644832 32977136 21315040
20:40:09 5347 8192000000 10955267008 11374415872 1980268128 19.467 100 81 161 1 2040163680 35716448 24179104
20:40:22 2325 8192000000 10962116512 11382042624 1984564320 19.501 100 74 147 0 2045550944 38766896 22219728
20:40:32 2352 8192000000 10969082448 11386470400 1974206272 19.419 99 82 163 2 2038994896 39808480 24980144
20:40:42 2050 8192000000 10962961952 11372527616 1974981104 19.425 100 85 169 2 2042041824 41562976 25497744
20:40:50 1668 8192000000 10956703840 11364020224 1960020368 19.306 99 90 180 0 2028975872 41799264 27156240
20:40:58 2974 8192000000 10951240608 11368558592 1968586112 19.374 100 81 162 1 2037680480 44294032 24800336
20:41:09 3086 8192000000 10945386368 11358257152 1946675904 19.200 99 84 167 0 2015338384 43642192 25020288
20:41:19 1739 8192000000 10958430816 11374444544 1978721120 19.455 100 86 172 1 2044031664 39845360 25465184
20:41:29 4579 8192000000 10943697824 11354996736 1956357808 19.277 100 85 170 1 2023348464 40741408 26249248
20:41:43 9264 8192000000 10937319984 11355774976 1965709296 19.351 100 73 146 1 2024032960 36212832 22110832
20:41:59 2207 8192000000 10932976512 11342479360 1942298656 19.165 99 82 162 2 2000704992 33762288 24644048
20:42:10 3052 8192000000 10929061584 11347668992 1959602592 19.303 100 66 132 0 2012773264 31552752 21617920
20:42:26 3300 8192000000 10926107248 11346292736 1944986080 19.187 99 71 140 3 1999459536 33457312 21016144
20:42:40 1826 8192000000 10930397920 11344723968 1945014720 19.187 99 78 156 1 2001187136 32077424 24094992
20:42:49 4683 8192000000 10932871312 11354001408 1959667552 19.303 100 65 130 1 2013687072 34122960 19896560
20:43:02 3440 8192000000 10925186544 11337838592 1932912832 19.090 99 77 152 2 1992210800 36060752 23237216
20:43:15 3761 8192000000 10918367360 11324997632 1932709104 19.089 99 80 160 0 1992804080 35634160 24460816
20:43:27 3698 8192000000 10931296304 11341529088 1957239648 19.284 100 88 177 2 2018372480 34139680 26993152
20:43:37 11505 8192000000 10919231424 11340304384 1950646144 19.232 100 68 136 1 2006943744 36466976 19830624
20:43:58 3306 8192000000 10944994096 11362172928 1966972768 19.361 100 67 135 2 2025546240 38883872 19689600
20:44:09 2209 8192000000 10952350896 11360202752 1966847200 19.360 100 90 179 1 2032071088 38371168 26852720
20:44:18 5846 8192000000 10925030496 11343011840 1944415968 19.182 99 67 133 2 2003704128 39246288 20041872
20:44:34 5364 8192000000 10922808928 11338653696 1923012496 19.011 98 68 136 2 1981427280 38787968 19626816
20:44:48 3268 8192000000 10939233024 11348443136 1950174032 19.228 100 84 168 1 2015122912 39983664 24965216
20:45:01 4358 8192000000 10935146640 11348123648 1954653008 19.264 100 80 161 0 2018992672 40748528 23591136
20:45:13 3901 8192000000 10936766096 11348873216 1954760720 19.264 100 82 163 1 2019746960 40283840 24702400
20:45:25 4098 8192000000 10944743552 11357032448 1940565616 19.151 99 72 144 1 2004561392 41442800 22552976
20:45:38 3932 8192000000 10944137200 11358842880 1960157840 19.307 100 76 152 0 2028373168 44316432 23898896
20:45:49 2412 8192000000 10911266272 11331559424 1920154992 18.988 98 68 134 4 1984909248 44008096 20746160
20:45:59 2959 8192000000 10948653200 11360141312 1957611488 19.287 100 87 171 2 2028795296 44821520 26362288
20:46:09 2487 8192000000 10948168240 11364474880 1963229040 19.332 100 83 167 1 2034606272 45603296 25773936
20:46:19 1300 8192000000 10958133184 11363553280 1965112976 19.347 100 92 184 2 2037526976 44345840 28068160
20:46:27 5903 8192000000 10967306016 11373387776 1972546112 19.406 100 79 157 2 2041639744 45577408 23516224
20:46:43 1721 8192000000 10934572032 11337285632 1941340384 19.157 99 88 172 0 2015242464 47315840 26586240
20:46:54 1607 8192000000 10962265856 11367231488 1962471616 19.326 100 87 171 0 2038415024 49703088 26240320
20:47:02 3741 8192000000 10970086560 11386671104 1973945600 19.417 100 73 146 0 2050067712 53469632 22652480
20:47:14 3711 8192000000 10965025232 11379814400 1962354208 19.325 99 74 148 1 2038489840 51895200 24240432
20:47:25 3937 8192000000 10948951040 11363000320 1955576192 19.271 100 69 136 1 2027817824 50404912 21836720
20:47:37 7247 8192000000 10954803680 11378728960 1965765008 19.352 100 59 118 3 2040735984 55273776 19697200
20:47:54 4987 8192000000 10953676736 11369926656 1949557312 19.223 99 62 123 1 2021086976 51040880 20488784
20:48:09 3964 8192000000 10965170608 11378573312 1970810160 19.392 100 73 142 1 2044600512 50496128 23294224
20:48:20 3707 8192000000 10956963744 11373363200 1967037008 19.362 100 66 132 2 2038462608 50195232 21230368
20:48:30 7719 8192000000 10942539728 11382247424 1970394272 19.389 100 61 123 0 2043317520 53233008 19690240
20:48:45 17990 8192000000 10943671104 11381473280 1955613440 19.271 99 40 78 1 2016256160 47158800 13483920
20:49:14 7409 8192000000 10961349872 11390304256 1960980240 19.314 99 52 104 0 2029528448 51826304 16721904
20:49:30 4969 8192000000 10953572400 11372769280 1965115440 19.347 99 65 126 0 2034226352 49955616 19155296
20:49:41 5120 8192000000 10942989728 11374321664 1952008768 19.242 99 49 98 2 2013375936 45642192 15724976
20:49:55 10075 8192000000 10918255584 11351334912 1941407024 19.158 99 36 72 3 1995237904 42735584 11095296
20:50:13 6566 8192000000 10931429216 11364085760 1960959504 19.314 100 50 100 2 2019722592 42632656 16130432
20:50:26 10060 8192000000 10939718448 11375575040 1964195664 19.339 100 39 78 0 2021434272 44525328 12713280
20:50:44 3550 8192000000 10959673792 11386093568 1976281728 19.435 100 56 112 1 2044575824 49819760 18474336
20:50:55 5155 8192000000 10963814192 11388465152 1975273712 19.427 100 62 124 0 2041809744 45168240 21367792
20:51:12 18301 8192000000 10949648896 11387285504 1966495104 19.358 100 40 80 1 2028194144 47813232 13885808
20:51:39 19617 8192000000 10946663728 11394392064 1966222592 19.355 100 28 56 4 2034022688 57492752 10307344
20:52:11 12494 8192000000 10931781408 11390074880 1967824304 19.368 100 28 56 0 2021019312 43568240 9626768
20:52:31 14699 8192000000 10925043888 11382026240 1963580960 19.334 100 24 46 2 2011057616 39368080 8108576
20:52:59 13513 8192000000 10942876384 11390488576 1968648576 19.375 100 28 56 0 2026036272 47175216 10212480
20:53:21 23758 8192000000 10923407072 11384258560 1960697216 19.312 100 28 56 2 2019497792 49246480 9554096
20:54:09 15848 8192000000 10919154592 11379908608 1960287136 19.308 100 24 48 1 2012408464 43960128 8161200
20:54:43 59351 8192000000 10927943968 11381673984 1963534032 19.334 100 25 50 0 2007584480 35002528 9047920
20:55:49 6904 8192000000 10931915248 11381342208 1967325232 19.364 100 40 80 1 2019067360 38696224 13045904
20:56:26 15666 8192000000 10897634848 11365945344 1946439808 19.198 100 22 44 0 1991426496 37891920 7094768
20:56:48 20028 8192000000 10874214448 11336654848 1933799952 19.097 99 12 24 2 1960704496 23914720 2989824
20:58:08 128861 8192000000 10874247728 11346325504 1901760256 18.840 97 11 23 0 1911932816 8000752 2171808
21:00:24 82791 8192000000 10875843120 11328856064 1883678528 18.695 96 12 25 0 1898983328 12716576 2588224
21:01:59 30877 8192000000 10873344176 11328262144 1917818208 18.969 98 24 48 1 1932150752 7271952 7060592
21:02:43 90908 8192000000 10911558432 11355774976 1963209536 19.332 100 31 63 0 1987352256 15266976 8875744
21:04:21 53729 8192000000 10883443040 11336749056 1905952320 18.874 97 28 56 0 1924849120 11220688 7676112
21:05:23 63282 8192000000 10910579648 11369304064 1963645072 19.335 100 25 50 1 1988764592 18264224 6855296
21:06:37 92964 8192000000 10899576816 11359768576 1955212896 19.268 99 25 50 1 1976704512 14836240 6655376
21:08:17 59761 8192000000 10911004448 11367563264 1975823600 19.432 100 32 64 1 1996518160 11078816 9615744
21:09:33 58631 8192000000 10885515968 11355860992 1939366224 19.142 98 18 36 0 1957932224 13341392 5224608
21:11:07 26054 8192000000 10921873120 11373096960 1978914192 19.456 100 39 79 3 1999467888 9463136 11090560
21:11:57 34376 8192000000 10881255936 11353624576 1938444192 19.134 98 18 36 1 1952534176 8999088 5090896
21:12:38 177041 8192000000 10897544880 11379249152 1975573136 19.430 100 12 24 1 1987831648 9228528 3029984
21:15:41 42310 8192000000 10906033408 11377963008 1981065200 19.473 100 11 23 0 2000511248 16019568 3426480
21:16:31 56400 8192000000 10906300992 11386486784 1984361712 19.499 100 11 22 0 1997912704 10395104 3155888
21:17:34 99465 8192000000 10903475984 11391651840 1970493392 19.389 99 27 54 0 1988952672 10327200 8132080
21:19:20 58996 8192000000 10898156960 11378049024 1945039664 19.187 98 14 28 1 1960985072 12055856 3889552
21:20:25 56522 8192000000 10910358864 11386007552 1969521104 19.382 99 20 40 3 1986870192 11535408 5813680
21:21:28 58076 8192000000 10918865520 11406086144 1991220960 19.553 100 11 22 0 2014752880 20239136 3292784
21:22:33 82677 8192000000 10919575504 11422666752 1972586928 19.406 99 9 18 1 1999494976 24342128 2565920
21:24:22 18472 8192000000 10888263360 11360428032 1924131008 19.020 97 21 39 0 1940858592 11670320 5057264
21:24:50 32700 8192000000 10859667056 11325300736 1868533104 18.572 95 21 41 0 1880648992 6701280 5414608
21:25:31 13352 8192000000 10863372480 11316727808 1895690768 18.792 97 47 94 2 1917978224 9298544 12988912
21:25:56 30874 8192000000 10878864208 11339067392 1928548144 19.055 99 37 74 1 1952408160 13361760 10498256
21:26:36 28977 8192000000 10893515616 11349696512 1945641152 19.192 100 22 42 1 1962193616 10758144 5794320
21:27:13 68811 8192000000 10875697376 11357024256 1899881536 18.825 97 17 34 0 1915916720 11750048 4285136
21:28:29 94950 8192000000 10859433408 11330879488 1790013872 17.932 91 14 28 1 1812039328 18110512 3914944
21:30:12 98989 8192000000 10868038672 11335426048 1813443728 18.124 93 18 36 0 1830708016 12246944 5017344
21:31:57 63763 8192000000 10851470480 11326480384 1903035808 18.851 98 19 38 1 1920016176 11486512 5493856
21:33:42 90990 8192000000 10877248640 11344592896 1929703568 19.065 99 13 26 0 1950647968 17220752 3723648
21:35:19 68472 8192000000 10870779616 11351015424 1885701360 18.711 97 9 18 1 1911180608 22605872 2873376
21:36:38 45128 8192000000 10865026896 11321929728 1846627840 18.395 95 21 42 1 1862169072 9779936 5761296
21:37:30 33859 8192000000 10859612976 11319889920 1915533696 18.951 99 34 67 2 1935760080 10740480 9485904
21:39:00 105526 8192000000 10875556128 11339251712 1922763984 19.009 99 32 63 1 1942152608 11303552 8085072
21:40:55 47505 8192000000 10879122720 11342057472 1923961664 19.019 99 27 54 0 1944583392 13658416 6963312
21:41:49 5549 8192000000 10854243136 11305730048 1919786096 18.985 99 37 74 1 1942410336 12687536 9936704
21:42:03 41786 8192000000 10890446368 11344056320 1927642752 19.048 99 38 76 1 1950231088 12280256 10308080
21:42:52 105970 8192000000 10898882240 11365187584 1931049232 19.075 98 15 30 3 1950512032 14878016 4584784
21:44:45 72904 8192000000 10905395920 11378765824 1965912448 19.353 100 16 32 0 1990804800 19835360 5056992
21:46:04 66420 8192000000 10913581424 11380895744 1976118320 19.434 100 13 26 0 2000404144 20249936 4035888
21:47:37 75894 8192000000 10875233648 11357458432 1902185680 18.844 97 11 22 1 1933235344 27802736 3246928
21:49:01 36725 8192000000 10883201008 11347349504 1939289296 19.141 99 18 36 1 1950368544 5998096 5081152
21:49:46 53533 8192000000 10899482352 11363651584 1947576656 19.207 99 22 42 2 1960524544 7165072 5782816
21:50:47 40870 8192000000 10901540832 11353022464 1960686240 19.311 99 35 70 1 1982286400 11494112 10106048
21:51:42 119273 8192000000 10881130528 11362390016 1891011984 18.754 96 19 38 1 1913978256 17766368 5199904
21:53:57 49654 8192000000 10878555760 11334909952 1874532784 18.621 96 12 24 0 1890125568 12347392 3245392
21:54:53 64271 8192000000 10897966400 11354173440 1920144528 18.988 98 32 64 2 1942955104 13277088 9533488
21:56:03 123400 8192000000 10886634384 11353993216 1854372064 18.458 94 13 26 1 1873492016 15733088 3386864
21:58:14 94859 8192000000 10924681760 11399524352 1977198160 19.443 100 10 20 0 1994319152 15076560 2044432
21:59:57 65901 8192000000 10924890640 11383611392 1966505552 19.358 99 12 24 1 1979196784 9845664 2845568
22:02:04 73611 8192000000 10925888352 11387326464 1980370496 19.468 99 37 69 0 2000840912 10640672 9829744
22:03:27 69376 8192000000 10924984576 11405832192 2004378608 19.657 100 31 62 0 2027750624 14625280 8746736
22:04:48 68724 8192000000 10913739520 11407011840 1976598480 19.438 99 4 9 0 1991919456 14504336 816640
22:06:03 39764 8192000000 10904936992 11369971712 1971952352 19.401 99 7 13 0 1986140640 12438736 1749552
22:06:53 45355 8192000000 10896676544 11366248448 1972498096 19.405 99 12 24 1 1985298608 9427296 3373216
22:07:48 78774 8192000000 10915749472 11391819776 1977745984 19.447 99 13 26 1 1994387280 12474400 4166896
22:09:21 62148 8192000000 10920739376 11387359232 1969438368 19.381 98 30 59 0 1984169424 6787392 7943664
22:10:29 48552 8192000000 10909863440 11386281984 1959142288 19.299 98 32 64 1 1978743664 10554624 9046752
22:11:28 68911 8192000000 10869312176 11341856768 1892678192 18.767 95 16 31 0 1911933936 15002352 4253392
22:12:43 36494 8192000000 10886497216 11352924160 1930564368 19.071 98 19 39 0 1945944096 8984576 6395152
22:13:27 22726 8192000000 10901459264 11351957504 1947382816 19.206 99 36 71 1 1967534144 9968960 10182368
22:14:00 48602 8192000000 10895273232 11358117888 1934357904 19.102 98 28 56 1 1952143040 9945072 7840064
22:14:59 92733 8192000000 10868861696 11340615680 1887871648 18.729 96 17 34 1 1904253440 11194128 5187664
22:16:37 57080 8192000000 10888201568 11343720448 1917021616 18.963 98 22 44 1 1933533664 10540144 5971904
22:17:41 103182 8192000000 10896619488 11372486656 1959426512 19.301 100 12 24 0 1974692832 11771456 3494864
22:19:37 72239 8192000000 10883160576 11351797760 1921425392 18.998 98 7 12 2 1934902864 11598144 1879328
22:21:12 55970 8192000000 10885210192 11345104896 1891200720 18.755 96 16 32 1 1902724224 7100912 4422592
22:22:15 58299 8192000000 10898777040 11336380416 1853442512 18.450 95 29 58 1 1878461232 17382160 7636560
22:23:21 40478 8192000000 10885269824 11342974976 1943126128 19.172 100 33 66 1 1965334416 13147776 9060512
22:24:08 106259 8192000000 10819797936 11289296896 1759490656 17.680 91 21 42 0 1783059616 17723264 5845696
22:26:19 66317 8192000000 9286156336 9552916480 438631808 5.082 23 3 6 0 444616320 5503648 480864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 30-01-2021 22:29:05 to 30-01-2021 22: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          241098
MON$OLDEST_ACTIVE               241099
MON$OLDEST_SNAPSHOT             241099
MON$NEXT_TRANSACTION            241099
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                       2022528
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.33407 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33407 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33407 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33407 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 ---
--- end of diff output ---

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

30.01.21 22: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-30 22:29:10 No severe PSQL-related problems occured
30.01.21 22:29:12. End of report.