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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17571592 kB
MemAvailable 31494872 kB
Buffers 0 kB
Cached 14125912 kB
SwapCached 3240 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-22 16:27:03
DTS_END                         2020-11-22 16:27:03.9030
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/34970
TRN_ID                          242495
ATT_ID                          674
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: 9061.80 23096 1087416
customer order: creation 171.17 392 20540
customer order: refuse 14.71 317 1765
order to supplier: creation 46.35 1378 5562
order to supplier: removal 3.49 97490 419
invoice (draft): creation 46.23 3902 5547
invoice (draft): removal 51.78 789 6214
invoice accept: apply 41.88 19607 5026
invoice accept: cancel 46.98 814 5637
customer reserve: creation 3795.08 199 455409
customer reserve: removal 4543.00 58 545160
realization accept: apply 83.93 186 10071
realization accept: cancel 87.23 115 10467
payment from customer: creation 60.08 136 7210
payment from customer: removal 5.23 83 627
payment to supplier: creation 48.95 156 5874
payment to supplier: removal 3.43 79 412
service: total inventory turnovers 4.60 1236 552
service: total monetary turnovers 6.75 34 810
service: aggregate perf. data 0.92 16370 110
service: refresh index statistics 0.03 318587 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 22-11-2020 16:28:44 to 22-11-2020 16:28:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5937
TEST_TIME 2 4889
TEST_TIME 3 5028
TEST_TIME 4 4982
TEST_TIME 5 4945
TEST_TIME 6 4902
TEST_TIME 7 5317
TEST_TIME 8 5330
TEST_TIME 9 6147
TEST_TIME 10 6592
TEST_TIME 11 6872
TEST_TIME 12 7117
TEST_TIME 13 7124
TEST_TIME 14 7590
TEST_TIME 15 7824
TEST_TIME 16 7779
TEST_TIME 17 8279
TEST_TIME 18 8667
TEST_TIME 19 8504
TEST_TIME 20 8383
TEST_TIME 21 8368
TEST_TIME 22 8964
TEST_TIME 23 9139
TEST_TIME 24 9308
TEST_TIME 25 9558
TEST_TIME 26 9715
TEST_TIME 27 9978
TEST_TIME 28 10709
TEST_TIME 29 10438
TEST_TIME 30 10371
TEST_TIME 31 10108
TEST_TIME 32 9833
TEST_TIME 33 9926
TEST_TIME 34 10314
TEST_TIME 35 10519
TEST_TIME 36 10453
TEST_TIME 37 10370
TEST_TIME 38 10205
TEST_TIME 39 10101
TEST_TIME 40 10009
TEST_TIME 41 10023
TEST_TIME 42 9859
TEST_TIME 43 9717
TEST_TIME 44 9679
TEST_TIME 45 9727
TEST_TIME 46 9583
TEST_TIME 47 9445
TEST_TIME 48 9498
TEST_TIME 49 9451
TEST_TIME 50 9393
TEST_TIME 51 9402
TEST_TIME 52 9286
TEST_TIME 53 9210
TEST_TIME 54 9185
TEST_TIME 55 9156
TEST_TIME 56 9055
TEST_TIME 57 9006
TEST_TIME 58 8918
TEST_TIME 59 8921
TEST_TIME 60 8885
TEST_TIME 61 8927
TEST_TIME 62 8993
TEST_TIME 63 9038
TEST_TIME 64 8985
TEST_TIME 65 9071
TEST_TIME 66 9072
TEST_TIME 67 9039
TEST_TIME 68 9217
TEST_TIME 69 9191
TEST_TIME 70 9210
TEST_TIME 71 9263
TEST_TIME 72 9294
TEST_TIME 73 9315
TEST_TIME 74 9315
TEST_TIME 75 9222
TEST_TIME 76 9157
TEST_TIME 77 9147
TEST_TIME 78 9139
TEST_TIME 79 9166
TEST_TIME 80 9116
TEST_TIME 81 9050
TEST_TIME 82 9072
TEST_TIME 83 9007
TEST_TIME 84 9079
TEST_TIME 85 9080
TEST_TIME 86 9061
TEST_TIME 87 9078
TEST_TIME 88 9096
TEST_TIME 89 9075
TEST_TIME 90 9145
TEST_TIME 91 9162
TEST_TIME 92 9136
TEST_TIME 93 9145
TEST_TIME 94 9255
TEST_TIME 95 9257
TEST_TIME 96 9233
TEST_TIME 97 9313
TEST_TIME 98 9259
TEST_TIME 99 9191
TEST_TIME 100 9162
TEST_TIME 101 9121
TEST_TIME 102 9070
TEST_TIME 103 9037
TEST_TIME 104 8992
TEST_TIME 105 8997
TEST_TIME 106 9094
TEST_TIME 107 9085
TEST_TIME 108 9072
TEST_TIME 109 9056
TEST_TIME 110 9066
TEST_TIME 111 9070
TEST_TIME 112 9091
TEST_TIME 113 9069
TEST_TIME 114 9094
TEST_TIME 115 9097
TEST_TIME 116 9072
TEST_TIME 117 9072
TEST_TIME 118 9116
TEST_TIME 119 9138
TEST_TIME 120 9062

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 22-11-2020 16:28:48 to 22-11-2020 16:28:51.

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 1509276 1509276 0 0.00 0 25870 7 0 0
doc_list_biud 1509275 1509275 0 0.00 0 58401 27 0 0
sp_add_invoice_to_stock 5150 5026 124 2.40 32 184255 19608 0 124
sp_cancel_adding_invoice 5637 5637 0 0.00 5 66951 814 0 0
sp_cancel_client_order 1765 1765 0 0.00 4 7280 317 0 0
sp_cancel_customer_reserve 545160 545160 0 0.00 1 32420 59 0 0
sp_cancel_pay_from_customer 627 627 0 0.00 3 6068 84 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 3874 80 0 0
sp_cancel_supplier_invoice 6226 6214 12 0.19 2 58409 789 0 12
sp_cancel_supplier_order 419 419 0 0.00 6 962624 97490 0 0
sp_cancel_write_off 10467 10467 0 0.00 1 9547 116 0 0
sp_client_order 20540 20540 0 0.00 3 21134 393 0 0
sp_customer_reserve 455409 455409 0 0.00 0 129353 199 0 0
sp_fill_shopping_cart 31649 31649 0 0.00 1 18779 41 0 0
sp_fill_shopping_cart_clo_res 455409 455409 0 0.00 0 17342 15 0 0
sp_get_clo_for_invoice 5026 5026 0 0.00 0 37471 306 0 0
sp_kill_cost_storno 17143 17143 0 0.00 0 15464 58 0 0
sp_kill_qstorno_ret_qs2qd 1107420 1107420 0 0.00 0 58398 32 0 0
sp_kill_qty_storno 584758 584758 0 0.00 0 58400 69 0 0
sp_lock_selected_doc 20813 20813 0 0.00 0 7836 4 0 0
sp_make_cost_storno 28181 28181 0 0.00 0 25863 56 0 0
sp_multiply_rows_for_pdistr 28180 28180 0 0.00 0 16227 32 0 0
sp_multiply_rows_for_qdistr 20540 20540 0 0.00 0 11639 163 0 0
sp_pay_from_customer 7210 7210 0 0.00 4 15646 136 0 0
sp_pay_to_supplier 5874 5874 0 0.00 5 17320 157 0 0
sp_payment_common 13084 13084 0 0.00 2 17301 38 0 0
sp_qd_handle_on_cancel_clo 1765 1765 0 0.00 0 7275 289 0 0
sp_qd_handle_on_invoice_upd_sts 10662 10662 0 0.00 0 35830 355 0 0
sp_qd_handle_on_reserve_upd_sts 10071 10071 0 0.00 0 17200 61 0 0
sp_reserve_write_off 10071 10071 0 0.00 6 18377 187 0 0
sp_supplier_invoice 5547 5547 0 0.00 6 97436 3902 0 0
sp_supplier_order 5562 5562 0 0.00 5 51996 1379 0 0
srv_aggregate_perf_data 110 110 0 0.00 2567 97305 16370 0 0
srv_fill_mon_cache_memory 158 158 0 0.00 1536 146481 31994 0 0
srv_find_qd_qs_mism 1039955 1039955 0 0.00 0 11116 6 0 0
srv_make_invnt_saldo 552 552 0 0.00 47 85486 1236 0 0
srv_make_money_saldo 810 810 0 0.00 0 6490 35 0 0
srv_recalc_idx_stat 4 4 0 0.00 214743 512459 318588 0 0
t$perf-abend:sp_add_invoice_to_stock 124 124 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5026 5026 0 0.00 0 33093 181 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 2639 76 0 0
t$perf-norm:sp_cancel_client_order 1765 1765 0 0.00 0 1691 11 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 1524 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 627 627 0 0.00 0 309 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 131 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 361 361 0 0.00 0 618 13 0 0
t$perf-norm:sp_cancel_supplier_order 419 419 0 0.00 0 24417 1491 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 2816 12 0 0
t$perf-norm:sp_client_order 20540 20540 0 0.00 0 7689 18 0 0
t$perf-norm:sp_customer_reserve 957 957 0 0.00 0 2078 4 0 0
t$perf-norm:sp_pay_from_customer 7210 7210 0 0.00 0 5186 10 0 0
t$perf-norm:sp_pay_to_supplier 5874 5874 0 0.00 0 12794 11 0 0
t$perf-norm:sp_reserve_write_off 10071 10071 0 0.00 0 8474 13 0 0
t$perf-norm:sp_supplier_invoice 5547 5547 0 0.00 0 4004 18 0 0
t$perf-norm:sp_supplier_order 5562 5562 0 0.00 0 6009 16 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 348 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 158 158 0 0.00 0 1758 14 0 0
t$perf-norm:srv_make_invnt_saldo 552 552 0 0.00 0 1560 23 0 0
t$perf-norm:srv_make_money_saldo 810 810 0 0.00 0 856 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 20 10 0 0
v_add_invoice_to_stock 10298 10050 248 2.40 0 5806 22 0 248
v_all_customers 37532 37532 0 0.00 0 20 1 0 0
v_all_suppliers 30600 30600 0 0.00 0 85 1 0 0
v_all_wares 41080 41080 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 3300 12 0 0
v_cancel_client_order 3530 3530 0 0.00 0 3128 7 0 0
v_cancel_customer_prepayment 1254 1254 0 0.00 0 5535 11 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 2370 7 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 3813 10 0 0
v_cancel_supplier_invoice 746 722 24 3.21 0 4626 23 0 24
v_cancel_supplier_order 838 838 0 0.00 0 4156 9 0 0
v_cancel_write_off 2040 2040 0 0.00 0 7608 16 0 0
v_max_id_clo_ord 5562 5562 0 0.00 0 1181 2 0 0
v_max_id_clo_res 957 957 0 0.00 0 3675 24 0 0
v_max_id_ord_sup 5547 5547 0 0.00 0 5280 6 0 0
v_max_non_paid_invoice 1683 1683 0 0.00 0 5430 8 0 0
v_max_non_paid_realizn 3685 3685 0 0.00 0 2911 4 0 0
v_min_id_clo_ord 5562 5562 0 0.00 0 2437 6 0 0
v_min_id_clo_res 957 957 0 0.00 0 2250 9 0 0
v_min_id_ord_sup 5547 5547 0 0.00 0 7489 9 0 0
v_min_non_paid_invoice 5874 5874 0 0.00 0 17298 26 0 0
v_min_non_paid_realizn 7210 7210 0 0.00 0 14794 27 0 0
v_our_firm 10598 10598 0 0.00 0 17 1 0 0
v_reserve_write_off 20142 20142 0 0.00 0 9983 8 0 0
x_lock_depdocs_on_canc_invoice 11490 11490 0 0.00 0 27800 124 0 0
x_lock_depdocs_on_canc_sup_ord 419 419 0 0.00 0 3129 291 0 0
x_make_qstorno_1000_1200 5562 5562 0 0.00 2 51803 1296 0 0
x_make_qstorno_1200_2000 5547 5547 0 0.00 3 97430 3756 0 0
x_make_qstorno_2100_3300 455409 455409 0 0.00 0 129352 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 22-11-2020 16:28:52 to 22-11-2020 16:28:56.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:07 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:14 9918 8192000000 10201852704 10508763136 861365184 9.514 68 42 84 0 876771504 2233200 13173120
13:57:32 26932 8192000000 10337596176 10656100352 1372735328 14.352 100 78 156 0 1402533184 4546992 25250864
13:58:09 24494 8192000000 10379070144 10699333632 1437587952 14.928 100 90 181 0 1472788272 6510304 28690016
13:58:48 14978 8192000000 10396829840 10725191680 1462511232 15.148 100 95 190 1 1500746448 7508400 30726816
13:59:11 15243 8192000000 10422373088 10752364544 1468468816 15.200 100 88 176 1 1505476016 7997456 29009744
13:59:36 6376 8192000000 10431146000 10762784768 1487596848 15.368 100 92 185 1 1525959024 8388240 29973936
13:59:51 14848 8192000000 10446799104 10777088000 1499216112 15.469 100 93 186 0 1537741088 8866928 29658048
14:00:17 26779 8192000000 10456010560 10792701952 1507067728 15.538 100 87 174 2 1544145152 9336048 27741376
14:01:00 6345 8192000000 10475232288 10811621376 1531848672 15.753 100 90 180 2 1569237408 9542160 27846576
14:01:22 20070 8192000000 10484876096 10832023552 1544786352 15.865 100 84 168 0 1580932720 9727632 26418736
14:01:51 19108 8192000000 10529015184 10881282048 1566246752 16.050 100 75 148 0 1598796704 9365168 23184784
14:02:22 12336 8192000000 10549199888 10906861568 1602468640 16.360 100 79 158 1 1637179760 10327600 24383520
14:02:42 15123 8192000000 10564651696 10926452736 1630186400 16.596 100 77 154 1 1664113728 11250224 22677104
14:03:10 8471 8192000000 10587670576 10951086080 1649987952 16.764 100 77 152 0 1684799200 12092960 22718288
14:03:27 10458 8192000000 10604163824 10970632192 1665250272 16.893 100 76 152 1 1700427440 12710640 22466528
14:03:49 7553 8192000000 10618766192 10986958848 1678862560 17.008 100 81 160 0 1715689744 13378128 23449056
14:04:04 8784 8192000000 10629189712 11000934400 1697696400 17.166 100 82 164 1 1735176608 13461296 24018912
14:04:21 6754 8192000000 10649769024 11022520320 1714366352 17.305 100 79 158 0 1750227408 13402768 22458288
14:04:36 7113 8192000000 10663954496 11036856320 1725841504 17.401 100 83 166 1 1763424016 14226240 23356272
14:04:52 5446 8192000000 10671468544 11045941248 1736399984 17.489 100 86 172 2 1776039120 15037872 24601264
14:05:04 5750 8192000000 10690391344 11062595584 1748854320 17.592 100 79 157 2 1785095024 14240384 22000320
14:05:16 5124 8192000000 10700681040 11074412544 1755501936 17.647 100 84 168 0 1794324016 14764544 24057536
14:05:29 4737 8192000000 10694520144 11074719744 1761192208 17.694 100 86 172 4 1803867936 18617984 24057744
14:05:41 2678 8192000000 10700196960 11085594624 1769985440 17.767 100 79 158 2 1806152944 14197472 21970032
14:05:51 9253 8192000000 10709438528 11094814720 1773942320 17.800 100 67 133 1 1806572176 13140544 19489312
14:06:12 3357 8192000000 10746441568 11126939648 1800458144 18.018 100 82 164 0 1834925280 11742608 22724528
14:06:21 3401 8192000000 10751898304 11136921600 1807084896 18.072 100 87 174 1 1844767888 13636784 24046208
14:06:31 2510 8192000000 10754281024 11140079616 1815794224 18.143 100 93 186 0 1857376288 15043968 26538096
14:06:41 2382 8192000000 10765881280 11145740288 1823136944 18.203 100 83 164 2 1859519392 13194784 23187664
14:06:50 2772 8192000000 10767688864 11151659008 1828892864 18.250 100 81 164 2 1863782416 12297296 22592256
14:07:00 2563 8192000000 10763340896 11158020096 1829723296 18.257 100 74 149 0 1863353888 11877216 21753376
14:07:09 2102 8192000000 10782849376 11168747520 1838892864 18.332 100 90 178 1 1877570608 13416352 25261392
14:07:18 2438 8192000000 10787410880 11173568512 1851256544 18.432 100 89 179 0 1888625568 13146512 24222512
14:07:27 1982 8192000000 10793346176 11176947712 1844494368 18.377 100 88 176 1 1882622624 12971744 25156512
14:07:35 1486 8192000000 10795865312 11179343872 1847312160 18.400 100 90 179 1 1886481392 13510144 25659088
14:07:43 1316 8192000000 10789457248 11176718336 1850610192 18.427 100 82 163 0 1885839792 12859280 22370320
14:07:51 3298 8192000000 10800939056 11188580352 1858888400 18.494 100 85 171 2 1895693584 12602544 24202640
14:08:00 1699 8192000000 10807029200 11191803904 1859506368 18.499 100 91 184 1 1898291712 12684496 26100848
14:08:08 2194 8192000000 10806822608 11196547072 1864688208 18.541 100 90 179 1 1903218064 12940080 25589776
14:08:18 5283 8192000000 10803113712 11199565824 1865269328 18.546 100 81 163 0 1901666480 13267680 23129472
14:08:29 2030 8192000000 10798951008 11200446464 1866623760 18.557 100 81 162 1 1902251584 12755104 22872720
14:08:38 1804 8192000000 10789405952 11197845504 1863544816 18.532 100 60 120 0 1892669056 12095856 17028384
14:08:48 4825 8192000000 10787167200 11201957888 1864435472 18.539 100 44 87 2 1886508688 9777200 12296016
14:08:59 2548 8192000000 10791928608 11202785280 1868547264 18.573 100 53 106 1 1892548432 9402400 14598768
14:09:09 34098 8192000000 10802535376 11205582848 1868454496 18.572 100 45 90 0 1889109520 6590592 14064432
14:09:50 2397 8192000000 10819113184 11221102592 1880158192 18.666 100 83 166 0 1914033504 9969936 23905376
14:10:00 4073 8192000000 10804153680 11217932288 1879754960 18.663 100 54 108 2 1902823392 8757872 14310560
14:10:12 5886 8192000000 10781652880 11211489280 1873870992 18.616 100 25 49 1 1888711520 7932720 6907808
14:10:29 5465 8192000000 10793304848 11214090240 1874056416 18.617 100 24 48 1 1891103936 9885568 7161952
14:10:42 6922 8192000000 10790042720 11216490496 1884474304 18.701 100 42 86 2 1904667040 7566480 12626256
14:10:56 11907 8192000000 10789825936 11220070400 1880372048 18.668 100 16 32 2 1890681696 6007600 4302048
14:11:14 5397 8192000000 10787356128 11219767296 1882244112 18.683 100 18 36 1 1893727408 5740496 5742800
14:11:25 9618 8192000000 10788887088 11220250624 1884652272 18.703 100 23 47 0 1897130976 6265472 6213232
14:11:42 7736 8192000000 10799848592 11231707136 1887661280 18.727 100 28 54 2 1906374400 10959440 7753680
14:11:56 9030 8192000000 10806481536 11231322112 1886949408 18.721 100 21 41 2 1898394992 5524640 5920944
14:12:14 13877 8192000000 10790907088 11225735168 1889084912 18.738 100 24 48 1 1902941584 7063184 6793488
14:12:37 8922 8192000000 10798671424 11230355456 1890562064 18.750 100 24 48 2 1903479568 5729376 7188128
14:12:52 11268 8192000000 10796468016 11229237248 1893359968 18.773 100 21 42 2 1904515376 5088304 6067104
14:13:12 15388 8192000000 10801482656 11236319232 1893806208 18.776 100 24 48 3 1906621712 5616672 7198832
14:13:37 69278 8192000000 10805599024 11253051392 1899805312 18.825 100 29 56 4 1916987408 9048432 8133664
14:14:53 9558 8192000000 10816015328 11254468608 1886850416 18.720 99 20 38 3 1898258928 5308912 6099600
14:15:10 7553 8192000000 10818847232 11255578624 1902446448 18.846 100 20 39 1 1913677760 6087056 5144256
14:15:24 7197 8192000000 10823521600 11256639488 1906527024 18.879 100 19 39 2 1917525568 5333616 5664928
14:15:42 7163 8192000000 10805895968 11246342144 1891024624 18.754 99 30 60 1 1906325872 6447312 8853936
14:15:55 8070 8192000000 10823426112 11262320640 1903928256 18.858 100 25 50 2 1916468416 5551024 6989136
14:16:10 5579 8192000000 10823482000 11257696256 1892751552 18.768 99 33 67 3 1909026688 6672320 9602816
14:16:22 7518 8192000000 10816750352 11247919104 1897432448 18.806 100 21 40 3 1908589680 6069008 5088224
14:16:36 10183 8192000000 10806648928 11234775040 1859196880 18.497 98 21 42 2 1871169392 6134160 5838352
14:16:52 8630 8192000000 10797595248 11227369472 1868182096 18.570 99 25 51 1 1882162976 5905072 8075808
14:17:08 9862 8192000000 10794598000 11225092096 1862880784 18.527 99 16 32 0 1872758784 5137472 4740528
14:17:26 10759 8192000000 10764139072 11197104128 1813508432 18.125 97 19 37 2 1824403648 5206240 5688976
14:17:45 16565 8192000000 10767146992 11194732544 1793060032 17.957 96 16 32 2 1803437616 5932768 4444816
14:18:12 20382 8192000000 10751681584 11165982720 1776456240 17.820 96 27 54 0 1790281824 5865552 7960032
14:19:10 22507 8192000000 10696331184 11117453312 1710746784 17.275 93 40 78 0 1728087168 6502016 10838368
14:19:40 9771 8192000000 10710167936 11120447488 1720122848 17.353 95 19 38 1 1730980512 5560496 5297168
14:19:56 6302 8192000000 10716362752 11132133376 1756720368 17.657 97 37 74 1 1774473376 7767536 9985472
14:20:11 5454 8192000000 10718090896 11137384448 1803037088 18.039 100 28 55 1 1817418576 6683120 7698368
14:20:24 5557 8192000000 10719226320 11140968448 1800710048 18.020 100 19 38 2 1812006864 6055152 5241664
14:20:36 7247 8192000000 10722003584 11139887104 1779138592 17.842 98 26 53 1 1792575504 6223136 7213776
14:20:51 8557 8192000000 10714568256 11133349888 1772629296 17.789 98 24 48 2 1785160512 6209040 6322176
14:21:07 6408 8192000000 10699724384 11114180608 1760165456 17.686 98 30 61 0 1774735648 5930800 8639392
14:21:20 8584 8192000000 10692500208 11109433344 1741076992 17.528 97 31 64 0 1755544384 5239072 9228320
14:21:35 10975 8192000000 10729147120 11142283264 1782934048 17.874 99 16 32 1 1796653584 9327280 4392256
14:21:56 8448 8192000000 10735177168 11158409216 1820968608 18.186 100 32 63 2 1836888272 6339552 9580112
14:22:13 9245 8192000000 10721914032 11146588160 1784224672 17.884 98 21 42 1 1795283680 4793952 6265056
14:22:31 12653 8192000000 10735487984 11162918912 1828800032 18.250 100 30 60 0 1843633792 5756240 9077520
14:22:51 10206 8192000000 10752055600 11180109824 1842824128 18.364 100 26 51 3 1855264112 5401696 7038288
14:23:09 20180 8192000000 10750029664 11164532736 1791892496 17.947 97 28 56 0 1804677280 5185696 7599088
14:23:35 59945 8192000000 10775493600 11188703232 1846026400 18.390 100 32 63 2 1861609952 5293312 10290240
14:24:43 7411 8192000000 10762610016 11190317056 1849454352 18.418 100 26 51 1 1863209344 6260384 7494608
14:24:56 7844 8192000000 10759598112 11190149120 1853364912 18.449 100 21 42 1 1865240800 6077536 5798352
14:25:11 9592 8192000000 10770147968 11199516672 1857050688 18.479 100 15 30 1 1866671584 5340448 4280448
14:25:29 6615 8192000000 10786674320 11205804032 1862586336 18.524 100 25 50 1 1875703040 5743856 7372848
14:25:42 8091 8192000000 10776266672 11205943296 1866246656 18.554 100 23 46 1 1879401440 5357856 7796928
14:25:58 7653 8192000000 10781079072 11209019392 1866318256 18.554 100 20 39 3 1877376464 5036704 6021504
14:26:16 7310 8192000000 10790355552 11219951616 1873559648 18.613 100 25 50 1 1886437536 5797184 7080704
14:26:31 9397 8192000000 10795242048 11222675456 1877097088 18.642 100 21 43 2 1888862480 5866640 5898752
14:26:47 8052 8192000000 10783912832 11220254720 1879836784 18.664 100 20 40 2 1891746160 5668496 6240880
14:27:03 20998 8192000000 10826760928 11242934272 1894898416 18.785 100 30 58 1 1908782400 5078768 8805216
14:27:32 8563 8192000000 10845557968 11260215296 1908399248 18.894 100 55 106 3 1931850304 6895312 16555744
14:28:05 54501 8192000000 10850890224 11279409152 1922254944 19.005 100 36 73 1 1940069600 7676160 10138496
14:29:06 14961 8192000000 10870934576 11292798976 1935300816 19.109 100 51 101 2 1958972624 8726512 14945296
14:29:30 71514 8192000000 10882778720 11313692672 1942789968 19.169 100 45 90 2 1969702416 13672336 13240112
14:31:02 9746 8192000000 10890725744 11319205888 1956144464 19.275 100 55 106 2 1984103328 12979888 14978976
14:31:22 6003 8192000000 10896792288 11326873600 1958581504 19.295 100 53 104 1 1985064544 12001248 14481792
14:31:45 19107 8192000000 10896949520 11323404288 1946115280 19.196 99 53 104 3 1972802768 12757744 13929744
14:32:21 4649 8192000000 10919221136 11339464704 1969139536 19.379 100 73 146 1 2007836960 17086688 21610736
14:32:34 7699 8192000000 10903530784 11332423680 1969773088 19.384 100 60 120 1 2003634656 16758576 17102992
14:33:02 11182 8192000000 10922353968 11344297984 1953710624 19.256 99 54 108 2 1987872848 18174608 15987616
14:33:27 11157 8192000000 10917188800 11349082112 1974764736 19.423 100 55 110 0 2009737168 19038672 15933760
14:33:48 5771 8192000000 10921750448 11344412672 1971024080 19.394 100 59 117 1 2007889040 19306080 17558880
14:34:00 12066 8192000000 10925317872 11351908352 1976839776 19.440 100 60 120 0 2015661008 21641616 17179616
14:34:22 15349 8192000000 10917752512 11353407488 1975550144 19.429 100 49 99 0 2012369856 22092176 14727536
14:34:44 6763 8192000000 10923535024 11358478336 1978186416 19.450 100 44 87 0 2009887312 18954096 12746800
14:35:06 7134 8192000000 10933124928 11365609472 1985995872 19.512 100 54 108 2 2024359424 21760864 16602688
14:35:21 9574 8192000000 10944023536 11369189376 1989905776 19.543 100 58 114 2 2031099552 22840688 18353088
14:35:38 16754 8192000000 10934473984 11369680896 1987376320 19.523 100 40 80 3 2023324560 23859424 12088816
14:36:05 6360 8192000000 10941426496 11364413440 1966686368 19.359 99 67 134 0 2012367472 25300752 20380352
14:36:21 8697 8192000000 10925925184 11356090368 1976975856 19.441 100 60 120 1 2019616448 25343696 17296896
14:36:37 3074 8192000000 10936313328 11363799040 1982208992 19.482 100 64 128 1 2023442192 23265664 17967536
14:36:48 1608 8192000000 10942035872 11364442112 1970354560 19.388 99 76 153 2 2016557168 23094880 23107728
14:36:58 2236 8192000000 10945016944 11356184576 1976265568 19.435 100 81 157 2 2023305888 24047072 22993248
14:37:08 5770 8192000000 10916012272 11334688768 1943131584 19.172 99 70 141 4 1985360432 21962720 20266128
14:37:21 6695 8192000000 10906452800 11319648256 1929438272 19.062 98 73 146 3 1973197328 22899584 20859472
14:37:35 19877 8192000000 10915417328 11339304960 1962394240 19.325 100 79 155 2 2007938320 22409808 23134272
14:38:03 5958 8192000000 10928090896 11347308544 1963700208 19.335 100 65 128 2 2008508448 25177712 19630528
14:38:17 3670 8192000000 10938036016 11360055296 1977425552 19.444 100 77 154 0 2027359440 28340112 21593776
14:38:31 2095 8192000000 10934843328 11344723968 1959386928 19.301 99 86 170 1 2014791872 30419376 24985568
14:38:40 11655 8192000000 10923407728 11347517440 1966139504 19.355 100 70 138 1 2019321408 31677408 21504496
14:39:00 6884 8192000000 10878912960 11303870464 1919597840 18.984 98 59 116 4 1966854896 29189328 18067728
14:39:15 2819 8192000000 10939167168 11356848128 1963501392 19.334 100 79 154 3 2016799696 30106064 23192240
14:39:26 8787 8192000000 10929705984 11347738624 1947787904 19.209 99 70 139 0 1996310672 27746880 20775888
14:39:44 4261 8192000000 10925803568 11348467712 1962929264 19.329 100 69 139 2 2013063936 30361872 19772800
14:40:00 6311 8192000000 10924269872 11344326656 1956535840 19.278 100 76 152 0 2010430416 31463824 22430752
14:40:19 2591 8192000000 10915465280 11332743168 1922915680 19.010 98 78 155 2 1978850544 32299152 23635712
14:40:32 3598 8192000000 10900179312 11309273088 1915232976 18.949 98 82 165 3 1971838304 32003936 24601392
14:40:45 4955 8192000000 10924571712 11340283904 1951347808 19.237 100 83 165 2 2011032704 33940256 25744640
14:40:58 4567 8192000000 10931678608 11345752064 1953239088 19.252 100 78 156 1 2013468240 35828128 24401024
14:41:11 7389 8192000000 10923820800 11336933376 1944740096 19.185 100 78 156 1 2005338896 36683040 23915760
14:41:26 2805 8192000000 10901522048 11315761152 1920708144 18.993 99 80 162 0 1981168768 35040896 25419728
14:41:37 2080 8192000000 10921144096 11339194368 1949679072 19.224 100 77 152 2 2008137888 36049520 22409296
14:41:45 2111 8192000000 10928874976 11343790080 1951085888 19.235 100 78 156 0 2011567280 36714224 23767168
14:41:59 4767 8192000000 10935708304 11351191552 1961806800 19.320 100 80 158 1 2020370896 34801040 23763056
14:42:12 3782 8192000000 10911985216 11328475136 1940011968 19.147 99 71 142 1 1991221152 29871808 21337376
14:42:25 4950 8192000000 10940261376 11357048832 1968174784 19.371 100 76 152 5 2022915536 31800352 22940400
14:42:40 2245 8192000000 10938540928 11354570752 1964227232 19.340 100 71 140 2 2017908704 32576192 21105280
14:42:52 5301 8192000000 10923936128 11344809984 1953492320 19.254 100 68 134 0 2008304000 34246128 20565552
14:43:10 7810 8192000000 10933645904 11353817088 1960590496 19.311 100 72 137 2 2015255296 32315312 22349488
14:43:28 8203 8192000000 10920230480 11346141184 1940748400 19.153 99 62 124 2 1997795280 38326720 18720160
14:43:44 6125 8192000000 10947237264 11369148416 1971565952 19.398 100 72 144 1 2033584592 39891312 22127328
14:43:59 6916 8192000000 10937503488 11363274752 1963174688 19.331 100 62 123 1 2023342192 41140224 19027280
14:44:21 3578 8192000000 10947267136 11366445056 1950223520 19.228 99 74 145 0 2015160400 42319856 22617024
14:44:32 5056 8192000000 10937989056 11363364864 1959394864 19.301 100 64 126 0 2022557152 43466896 19695392
14:44:50 4256 8192000000 10920567632 11327995904 1919496448 18.983 98 67 133 1 1979184528 39871344 19816736
14:45:01 1809 8192000000 10935296128 11346800640 1958531264 19.294 100 90 180 1 2022640032 35832624 28276144
14:45:12 1535 8192000000 10924794016 11328712704 1936547856 19.119 99 90 180 0 1999304384 34793296 27963232
14:45:21 3321 8192000000 10916826576 11339362304 1943338912 19.173 100 63 126 1 1998937328 35447440 20150976
14:45:40 18241 8192000000 10897931936 11336450048 1937481504 19.127 100 40 79 1 1987997728 37770176 12746048
14:46:07 8503 8192000000 10890764864 11330838528 1934159952 19.100 100 32 64 1 1979934240 34969872 10804416
14:46:28 8575 8192000000 10927805024 11350925312 1934729648 19.105 99 41 82 2 1982782640 34938336 13114656
14:46:44 2130 8192000000 10943756768 11348303872 1958849776 19.297 100 85 169 0 2021638976 37754320 25034880
14:46:54 3262 8192000000 10928738176 11349598208 1957657872 19.287 100 87 174 1 2024006896 39963072 26385952
14:47:08 6772 8192000000 10926590112 11352563712 1953959408 19.258 100 55 110 0 2011680864 40192080 17529376
14:47:23 6997 8192000000 10918080656 11348447232 1955238656 19.268 100 47 94 2 2010859056 40399824 15220576
14:47:41 4603 8192000000 10914535184 11336732672 1930420288 19.070 99 50 100 3 1989546480 42388400 16737792
14:47:56 2032 8192000000 10938774800 11355889664 1951179200 19.236 100 63 124 1 2014652192 44308864 19164128
14:48:05 6329 8192000000 10934648128 11356819456 1935186048 19.108 99 64 128 1 2002749008 47099712 20463248
14:48:25 14712 8192000000 10910942336 11341357056 1908706928 18.896 98 38 76 0 1968479328 46609392 13163008
14:48:47 6430 8192000000 10926370016 11354845184 1943641024 19.176 100 55 110 2 2010726352 48943936 18141392
14:49:01 3609 8192000000 10946627472 11360731136 1951982192 19.242 100 75 150 0 2020633920 44841856 23809872
14:49:12 10858 8192000000 10916499616 11353919488 1932980704 19.091 99 46 92 1 1992406048 44512176 14913168
14:49:35 12344 8192000000 10909898352 11351842816 1947832704 19.209 100 29 58 0 1994111328 36212272 10066352
14:49:58 13870 8192000000 10920261424 11358142464 1953977440 19.258 100 35 70 0 2002873104 37564624 11331040
14:50:21 17780 8192000000 10915361920 11353694208 1931408864 19.078 99 27 54 0 1980353488 39540320 9404304
14:50:51 19329 8192000000 10913750368 11355402240 1949516128 19.223 100 28 56 3 1997122256 37951136 9654992
14:51:17 18097 8192000000 10899516544 11356700672 1909924224 18.906 98 17 34 1 1949094688 32955104 6215360
14:51:42 5219 8192000000 10896264560 11341254656 1938305296 19.133 100 34 69 2 1984694624 35852624 10536704
14:52:01 38356 8192000000 10895639840 11347283968 1920415328 18.990 99 25 50 0 1968609984 39571376 8623280
14:52:50 17874 8192000000 10890846864 11349577728 1939107200 19.140 100 21 41 1 1983128608 36863280 7158128
14:53:28 41925 8192000000 10883327456 11342213120 1911121312 18.916 99 15 30 1 1952714432 35863184 5729936
14:54:40 28617 8192000000 10909755328 11362439168 1939196256 19.140 100 22 44 1 1986311328 39628032 7487040
14:55:44 17744 8192000000 10884620416 11336437760 1906128640 18.876 98 13 26 0 1931485440 21461584 3895216
14:56:09 20566 8192000000 10921100272 11356307456 1951869184 19.241 100 43 86 1 1987775552 23448816 12457552
14:56:40 25056 8192000000 10936179264 11373494272 1970159520 19.387 100 42 84 3 2012617200 30375264 12082416
14:57:15 10949 8192000000 10933166320 11381641216 1976549792 19.437 100 33 66 0 2016123136 29781920 9791424
14:57:33 20685 8192000000 10922858320 11379228672 1957592016 19.287 99 25 50 3 1997006000 31836352 7577632
14:58:13 95992 8192000000 10938699952 11378769920 1958476272 19.294 99 34 67 2 2004427664 35742704 10208688
15:00:17 59741 8192000000 10913662928 11371888640 1947299728 19.205 99 20 41 2 1989642752 36160672 6182352
15:01:55 75311 8192000000 10871095296 11343773696 1918100528 18.972 98 17 34 1 1952453872 29978576 4374768
15:03:17 49887 8192000000 10882943696 11351371776 1940383344 19.150 99 21 43 0 1961272304 14901040 5987920
15:04:20 74854 8192000000 10863905872 11322667008 1883692912 18.695 96 10 21 0 1893096688 6739760 2664016
15:05:57 102314 8192000000 10886171968 11349073920 1942478832 19.167 99 16 31 0 1956284000 9016400 4788768
15:07:46 9545 8192000000 10893455616 11353006080 1969650368 19.383 100 25 51 1 1985942880 9164832 7127680
15:08:53 100587 8192000000 10916312048 11368132608 1957719072 19.288 99 23 46 0 1971624016 7412672 6492272
15:10:43 53742 8192000000 10924833680 11382206464 1987511600 19.524 100 38 77 0 2009847168 11503696 10831872
15:11:43 50737 8192000000 10905027568 11377266688 1972346048 19.404 99 24 49 2 1994216544 14779872 7090624
15:12:41 55200 8192000000 10916187296 11393740800 1985502016 19.508 100 13 26 0 2007512912 18507632 3503264
15:13:43 34665 8192000000 10924495744 11388514304 1996803600 19.598 100 14 28 0 2013357456 12630272 3923584
15:14:29 41880 8192000000 10923047184 11383799808 1981406256 19.476 99 43 82 3 2005800528 12509840 11884432
15:15:17 52525 8192000000 10913726512 11387805696 1973434128 19.413 99 22 43 1 1997427104 17073408 6919568
15:16:20 36697 8192000000 10943032928 11393282048 1997387136 19.602 100 41 82 1 2016538464 7920944 11230384
15:17:03 53999 8192000000 10925939616 11390988288 1999116448 19.616 100 33 65 1 2021179776 13333616 8729712
15:18:08 100910 8192000000 10912303056 11392098304 1982397792 19.484 99 9 18 1 1995138976 9970992 2770192
15:19:55 67493 8192000000 10927791408 11397906432 2003079104 19.647 100 28 57 2 2021123920 9558880 8485936
15:21:09 63141 8192000000 10939786576 11398135808 2005032096 19.662 100 23 46 0 2021365440 9370032 6963312
15:22:18 42692 8192000000 10912471232 11378221056 1964061440 19.338 98 24 47 0 1978096336 7124240 6910656
15:23:11 17244 8192000000 10933535152 11389386752 2001350912 19.633 100 48 92 1 2023854608 8383504 14120192
15:23:35 31628 8192000000 10924266080 11387195392 1983431328 19.492 99 54 108 1 2011383616 11573856 16378432
15:24:16 61979 8192000000 10907349264 11389333504 1989019888 19.536 100 10 20 1 2005295104 13547072 2728144
15:26:58 51528 8192000000 10906498832 11368865792 1922313792 19.005 96 14 28 0 1935016320 9010016 3692512
15:27:56 56558 8192000000 10856006640 11325370368 1876026272 18.633 95 15 30 0 1888413552 8413696 3973584
15:29:10 73478 8192000000 10879638880 11352866816 1925868608 19.034 98 24 46 1 1942320032 10039200 6412224
15:30:35 47041 8192000000 10858115808 11322146816 1860171120 18.505 95 28 56 0 1877176448 9411600 7593728
15:31:32 29125 8192000000 10872195824 11326631936 1895651392 18.791 97 35 70 0 1916087952 10848768 9587792
15:32:14 45015 8192000000 10870890560 11342585856 1922395328 19.006 99 21 42 1 1942696128 14171856 6128944
15:33:28 44184 8192000000 10886998000 11326578688 1874894240 18.624 96 41 82 0 1900523120 13337792 12291088
15:34:21 24754 8192000000 10906535088 11356016640 1952644912 19.248 100 45 90 0 1982896080 17288352 12962816
15:34:55 32639 8192000000 10908613664 11371114496 1965699728 19.351 100 36 72 2 1995676832 19938032 10039072
15:35:47 94261 8192000000 10891252000 11356917760 1920308176 18.989 98 14 28 1 1940662256 16332736 4021344
15:37:31 55924 8192000000 10869025648 11316379648 1826957808 18.235 93 34 67 2 1851063456 14286784 9818864
15:39:13 126190 8192000000 10843608128 11314266112 1757143488 17.661 91 17 34 1 1780888512 19214928 4530096
15:41:27 115819 8192000000 10838961136 11291471872 1864928464 18.543 97 25 50 0 1880015792 8099664 6987664
15:43:34 21184 8192000000 10864818656 11301355520 1873474752 18.612 97 44 88 2 1896322720 9562624 13285344
15:44:05 56510 8192000000 10845336736 11295739904 1907171040 18.884 99 41 81 0 1929557344 11688112 10698192
15:45:08 39926 8192000000 10876227280 11321618432 1918352160 18.974 99 30 60 0 1936815328 9939824 8523344
15:46:02 51816 8192000000 10833273952 11301527552 1836595856 18.313 95 15 30 1 1851451056 10924656 3930544
15:47:01 57963 8192000000 10839489680 11306242048 1902547728 18.847 99 11 21 0 1914311968 8909600 2854640
15:48:07 46240 8192000000 10859900752 11318243328 1909336560 18.901 99 14 28 1 1927381760 14455280 3589920
15:48:59 88815 8192000000 10858046784 11334635520 1939519344 19.143 100 24 47 1 1960602832 13411808 7671680
15:50:56 87009 8192000000 10849342624 11342307328 1898480784 18.814 98 9 18 0 1918610880 17202208 2927888
15:52:29 50253 8192000000 10867093040 11332214784 1923281936 19.013 99 21 44 0 1938425648 8943120 6200592
15:53:30 46449 8192000000 10873185728 11338616832 1912524608 18.927 98 20 40 2 1928224144 10201184 5498352
15:54:56 47029 8192000000 10890284800 11343888384 1937052992 19.123 99 36 72 1 1962968768 14906960 11008816
15:55:49 33453 8192000000 10873073168 11337371648 1934729664 19.105 99 34 68 2 1954261104 10090032 9441408
15:56:36 75486 8192000000 10883295568 11354128384 1943819840 19.177 99 30 60 2 1965561888 12990336 8751712
15:57:58 53143 8192000000 10901565312 11353837568 1910169696 18.908 97 20 40 0 1926067344 10581264 5316384
15:59:22 49067 8192000000 10902981200 11353210880 1929456320 19.063 98 26 52 0 1949641488 12437312 7747856
16:00:18 95682 8192000000 10893190000 11373907968 1935813648 19.113 99 8 16 0 1955608336 17954240 1840448
16:01:59 103299 8192000000 10908841104 11370102784 1931704176 19.081 98 25 50 0 1949005744 10429264 6872304
16:03:58 146481 8192000000 10911400672 11362607104 1933689360 19.096 98 15 30 0 1955850864 17997440 4164064
16:09:09 53923 8192000000 10890384112 11360292864 1965189904 19.347 100 11 22 2 1980346272 11890096 3266272
16:10:09 99823 8192000000 10910850208 11373625344 1957883360 19.289 99 13 26 1 1975818784 14304672 3630752
16:12:27 52786 8192000000 10867381888 11339313152 1884860416 18.704 96 13 27 0 1905968176 17515008 3592752
16:13:31 65981 8192000000 10874968864 11349512192 1928770512 19.057 99 16 32 2 1945922736 12746992 4405232
16:14:50 50975 8192000000 10885627872 11354886144 1916845632 18.962 98 19 38 1 1934459168 12597536 5016000
16:15:56 79381 8192000000 10849187680 11323490304 1842702480 18.363 94 10 20 0 1857104496 11518144 2883872
16:17:22 22958 8192000000 10887612080 11337732096 1929368096 19.062 99 22 44 1 1945201488 10043392 5790000
16:17:59 52851 8192000000 10897107248 11357941760 1958588816 19.295 100 30 60 0 1978454128 10601216 9264096
16:19:04 62180 8192000000 10881525520 11342512128 1900431824 18.830 97 20 40 0 1914284272 8413664 5438784
16:20:18 87095 8192000000 10870385056 11324440576 1861400096 18.515 95 17 34 2 1875274816 9496512 4378208
16:22:49 28463 8192000000 10888998656 11339931648 1919874976 18.986 98 26 52 0 1935277824 8091104 7311744
16:23:31 17342 8192000000 10896248464 11334131712 1896328688 18.797 97 39 77 1 1920540496 13909856 10301952
16:23:54 14143 8192000000 10890577568 11333779456 1930744448 19.073 99 41 82 3 1954744256 11971536 12028272
16:24:18 22978 8192000000 10880373856 11320872960 1886778992 18.720 97 50 100 0 1914216144 13747808 13689344
16:25:11 72482 8192000000 10823907488 11291090944 1791394480 17.943 93 20 40 1 1811943456 15049872 5499104
16:26:29 60891 8192000000 9872795968 10237829120 981818656 10.702 53 5 10 0 993240752 10142336 1279760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 22-11-2020 16:28:58 to 22-11-2020 16:29:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 124 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 22-11-2020 16:29:30 to 22-11-2020 16:29:32.

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          242778
MON$OLDEST_ACTIVE               242779
MON$OLDEST_SNAPSHOT             242779
MON$NEXT_TRANSACTION            242779
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                       2013312
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.33393 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33393 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33393 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33393 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 ---
:78: 
:79: mscs-test-161.budzdorov.ru    Sun Nov 22 16:27:38 2020
:80:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:81: 
:82: 
:83: mscs-test-161.budzdorov.ru    Sun Nov 22 16:27:40 2020
:84:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:85: 
--- end of diff output ---

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

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