Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 01.11.2020 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 17575812 kB
MemAvailable 31466488 kB
Buffers 0 kB
Cached 14093516 kB
SwapCached 2888 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.7
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-01 22:27:00
DTS_END                         2020-11-01 22:27:00.2330
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/46862
TRN_ID                          248555
ATT_ID                          686
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: 9161.60 24274 1099392
customer order: creation 182.22 337 21866
customer order: refuse 15.36 344 1843
order to supplier: creation 48.68 1152 5842
order to supplier: removal 3.43 106730 411
invoice (draft): creation 48.54 3129 5825
invoice (draft): removal 49.81 837 5977
invoice accept: apply 45.18 18080 5421
invoice accept: cancel 44.87 886 5384
customer reserve: creation 4035.28 185 484233
customer reserve: removal 4387.14 66 526457
realization accept: apply 90.78 163 10893
realization accept: cancel 72.40 117 8688
payment from customer: creation 63.31 106 7597
payment from customer: removal 5.93 70 711
payment to supplier: creation 52.33 130 6279
payment to supplier: removal 3.52 57 422
service: total inventory turnovers 4.98 1004 598
service: total monetary turnovers 7.00 46 840
service: aggregate perf. data 0.84 22034 101
service: refresh index statistics 0.03 329997 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 01-11-2020 22:27:45 to 01-11-2020 22:27:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7777
TEST_TIME 2 6921
TEST_TIME 3 6390
TEST_TIME 4 7464
TEST_TIME 5 7493
TEST_TIME 6 7193
TEST_TIME 7 7803
TEST_TIME 8 7852
TEST_TIME 9 7860
TEST_TIME 10 8023
TEST_TIME 11 7727
TEST_TIME 12 7574
TEST_TIME 13 7454
TEST_TIME 14 7339
TEST_TIME 15 7518
TEST_TIME 16 8072
TEST_TIME 17 8144
TEST_TIME 18 8022
TEST_TIME 19 8266
TEST_TIME 20 8455
TEST_TIME 21 8864
TEST_TIME 22 9009
TEST_TIME 23 8923
TEST_TIME 24 9080
TEST_TIME 25 9167
TEST_TIME 26 9530
TEST_TIME 27 10323
TEST_TIME 28 10926
TEST_TIME 29 10792
TEST_TIME 30 10768
TEST_TIME 31 10504
TEST_TIME 32 10291
TEST_TIME 33 10152
TEST_TIME 34 10137
TEST_TIME 35 10109
TEST_TIME 36 10004
TEST_TIME 37 9878
TEST_TIME 38 9878
TEST_TIME 39 9742
TEST_TIME 40 9653
TEST_TIME 41 9723
TEST_TIME 42 9643
TEST_TIME 43 9576
TEST_TIME 44 9395
TEST_TIME 45 9286
TEST_TIME 46 9251
TEST_TIME 47 9228
TEST_TIME 48 9161
TEST_TIME 49 9249
TEST_TIME 50 9200
TEST_TIME 51 9117
TEST_TIME 52 9136
TEST_TIME 53 9181
TEST_TIME 54 9132
TEST_TIME 55 9337
TEST_TIME 56 9475
TEST_TIME 57 9514
TEST_TIME 58 9616
TEST_TIME 59 9577
TEST_TIME 60 9547
TEST_TIME 61 9451
TEST_TIME 62 9410
TEST_TIME 63 9425
TEST_TIME 64 9436
TEST_TIME 65 9355
TEST_TIME 66 9294
TEST_TIME 67 9262
TEST_TIME 68 9276
TEST_TIME 69 9283
TEST_TIME 70 9247
TEST_TIME 71 9406
TEST_TIME 72 9377
TEST_TIME 73 9369
TEST_TIME 74 9355
TEST_TIME 75 9358
TEST_TIME 76 9428
TEST_TIME 77 9395
TEST_TIME 78 9451
TEST_TIME 79 9428
TEST_TIME 80 9373
TEST_TIME 81 9310
TEST_TIME 82 9304
TEST_TIME 83 9242
TEST_TIME 84 9234
TEST_TIME 85 9172
TEST_TIME 86 9165
TEST_TIME 87 9147
TEST_TIME 88 9181
TEST_TIME 89 9145
TEST_TIME 90 9157
TEST_TIME 91 9206
TEST_TIME 92 9199
TEST_TIME 93 9212
TEST_TIME 94 9250
TEST_TIME 95 9289
TEST_TIME 96 9270
TEST_TIME 97 9322
TEST_TIME 98 9327
TEST_TIME 99 9359
TEST_TIME 100 9379
TEST_TIME 101 9318
TEST_TIME 102 9278
TEST_TIME 103 9291
TEST_TIME 104 9278
TEST_TIME 105 9271
TEST_TIME 106 9272
TEST_TIME 107 9232
TEST_TIME 108 9198
TEST_TIME 109 9211
TEST_TIME 110 9209
TEST_TIME 111 9188
TEST_TIME 112 9147
TEST_TIME 113 9132
TEST_TIME 114 9143
TEST_TIME 115 9219
TEST_TIME 116 9205
TEST_TIME 117 9235
TEST_TIME 118 9274
TEST_TIME 119 9242
TEST_TIME 120 9166

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 01-11-2020 22:27:48 to 01-11-2020 22:27:52.

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 1547534 1547534 0 0.00 0 16386 6 0 0
doc_list_biud 1547534 1547534 0 0.00 0 62460 28 0 0
sp_add_invoice_to_stock 5569 5421 148 2.65 40 242693 18080 0 148
sp_cancel_adding_invoice 5384 5384 0 0.00 5 50815 886 0 0
sp_cancel_client_order 1843 1843 0 0.00 4 11308 344 0 0
sp_cancel_customer_reserve 526457 526457 0 0.00 1 32447 67 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 2 4571 71 0 0
sp_cancel_pay_to_supplier 422 422 0 0.00 3 3538 58 0 0
sp_cancel_supplier_invoice 5992 5977 15 0.25 2 62519 837 0 15
sp_cancel_supplier_order 411 411 0 0.00 7 957600 106730 0 0
sp_cancel_write_off 8688 8688 0 0.00 1 9926 117 0 0
sp_client_order 21866 21866 0 0.00 3 20463 337 0 0
sp_customer_reserve 484233 484233 0 0.00 0 132893 185 0 0
sp_fill_shopping_cart 33528 33528 0 0.00 1 17893 41 0 0
sp_fill_shopping_cart_clo_res 484229 484229 0 0.00 0 11470 14 0 0
sp_get_clo_for_invoice 5409 5409 0 0.00 0 23290 310 0 0
sp_kill_cost_storno 15205 15205 0 0.00 0 6206 59 0 0
sp_kill_qstorno_ret_qs2qd 1067990 1067990 0 0.00 0 62460 36 0 0
sp_kill_qty_storno 565054 565054 0 0.00 0 62460 77 0 0
sp_lock_selected_doc 22324 22324 0 0.00 0 8546 6 0 0
sp_make_cost_storno 30170 30170 0 0.00 0 16372 45 0 0
sp_multiply_rows_for_pdistr 30170 30170 0 0.00 0 16371 27 0 0
sp_multiply_rows_for_qdistr 21866 21866 0 0.00 0 20451 158 0 0
sp_pay_from_customer 7597 7597 0 0.00 4 19326 106 0 0
sp_pay_to_supplier 6279 6279 0 0.00 5 16389 131 0 0
sp_payment_common 13876 13876 0 0.00 1 19289 26 0 0
sp_qd_handle_on_cancel_clo 1843 1843 0 0.00 0 11297 313 0 0
sp_qd_handle_on_invoice_upd_sts 10785 10785 0 0.00 0 20453 325 0 0
sp_qd_handle_on_reserve_upd_sts 10893 10893 0 0.00 0 16992 55 0 0
sp_reserve_write_off 10893 10893 0 0.00 6 17007 164 0 0
sp_supplier_invoice 5825 5825 0 0.00 6 70155 3130 0 0
sp_supplier_order 5842 5842 0 0.00 5 22364 1153 0 0
srv_aggregate_perf_data 101 101 0 0.00 2996 254119 22035 0 0
srv_fill_mon_cache_memory 174 174 0 0.00 1749 167135 29736 0 0
srv_find_qd_qs_mism 1048793 1048793 0 0.00 0 8015 6 0 0
srv_make_invnt_saldo 598 598 0 0.00 41 33693 1005 0 0
srv_make_money_saldo 840 840 0 0.00 1 13252 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 177948 466865 329998 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5421 5421 0 0.00 0 10202 159 0 0
t$perf-norm:sp_cancel_adding_invoice 428 428 0 0.00 1 5882 89 0 0
t$perf-norm:sp_cancel_client_order 1843 1843 0 0.00 0 3103 14 0 0
t$perf-norm:sp_cancel_customer_reserve 734 734 0 0.00 0 3870 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 2105 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 422 422 0 0.00 0 383 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 1102 20 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 23070 1702 0 0
t$perf-norm:sp_cancel_write_off 1077 1077 0 0.00 0 3683 11 0 0
t$perf-norm:sp_client_order 21866 21866 0 0.00 0 6971 18 0 0
t$perf-norm:sp_customer_reserve 1088 1088 0 0.00 0 4292 14 0 0
t$perf-norm:sp_pay_from_customer 7597 7597 0 0.00 0 4555 9 0 0
t$perf-norm:sp_pay_to_supplier 6279 6279 0 0.00 0 7060 10 0 0
t$perf-norm:sp_reserve_write_off 10893 10893 0 0.00 0 6174 11 0 0
t$perf-norm:sp_supplier_invoice 5825 5825 0 0.00 0 4699 17 0 0
t$perf-norm:sp_supplier_order 5842 5842 0 0.00 0 2886 14 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 784 11 0 0
t$perf-norm:srv_fill_mon_cache_memory 174 174 0 0.00 0 334 6 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 2239 26 0 0
t$perf-norm:srv_make_money_saldo 840 840 0 0.00 0 14955 42 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 8 4 0 0
v_add_invoice_to_stock 11098 10802 296 2.66 0 5428 18 0 296
v_all_customers 39966 39966 0 0.00 0 15 1 0 0
v_all_suppliers 32194 32194 0 0.00 0 22 1 0 0
v_all_wares 43730 43730 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 856 856 0 0.00 0 816 6 0 0
v_cancel_client_order 3686 3686 0 0.00 0 1668 4 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 4558 8 0 0
v_cancel_customer_reserve 1468 1468 0 0.00 0 969 4 0 0
v_cancel_payment_to_supplier 844 844 0 0.00 0 3500 8 0 0
v_cancel_supplier_invoice 838 808 30 3.57 0 148 11 0 30
v_cancel_supplier_order 822 822 0 0.00 0 1441 7 0 0
v_cancel_write_off 2154 2154 0 0.00 0 8262 20 0 0
v_max_id_clo_ord 5839 5839 0 0.00 0 1185 1 0 0
v_max_id_clo_res 1088 1088 0 0.00 0 4009 17 0 0
v_max_id_ord_sup 5824 5824 0 0.00 0 8695 6 0 0
v_max_non_paid_invoice 1845 1845 0 0.00 0 349 2 0 0
v_max_non_paid_realizn 4042 4042 0 0.00 0 403 3 0 0
v_min_id_clo_ord 5839 5839 0 0.00 0 2873 7 0 0
v_min_id_clo_res 1088 1088 0 0.00 0 4168 12 0 0
v_min_id_ord_sup 5824 5824 0 0.00 0 5414 11 0 0
v_min_non_paid_invoice 6279 6279 0 0.00 0 8167 14 0 0
v_min_non_paid_realizn 7597 7597 0 0.00 0 14587 18 0 0
v_our_firm 10874 10874 0 0.00 0 15 1 0 0
v_reserve_write_off 21784 21784 0 0.00 0 9143 6 0 0
x_lock_depdocs_on_canc_invoice 10957 10957 0 0.00 0 26146 127 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 14946 403 0 0
x_make_qstorno_1000_1200 5842 5842 0 0.00 1 22352 1067 0 0
x_make_qstorno_1200_2000 5825 5825 0 0.00 3 70145 2978 0 0
x_make_qstorno_2100_3300 484233 484233 0 0.00 0 132891 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 01-11-2020 22:27:53 to 01-11-2020 22:27:57.

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:04 2 8192000000 8798422528 8808923136 5084624 0.062 1 1 2 0 5202672 55488 62560
19:57:10 7255 8192000000 10173077296 10464931840 793260224 8.828 64 48 96 0 811656880 2240400 16156256
19:57:26 21281 8192000000 10313251120 10625298432 1356385616 14.205 100 85 170 0 1388678368 4234016 28058736
19:58:02 34506 8192000000 10370067360 10690310144 1419229744 14.766 100 85 170 0 1453190880 6102048 27859088
19:58:48 14342 8192000000 10388651920 10715070464 1447284848 15.014 100 90 180 1 1484200368 7151664 29763856
19:59:14 19143 8192000000 10425726352 10756808704 1477974896 15.284 100 85 169 1 1512363856 7511280 26877680
19:59:44 20209 8192000000 10443242048 10774687744 1501258032 15.487 100 90 180 0 1538696800 8943200 28495568
20:00:14 17551 8192000000 10451427680 10787491840 1506827760 15.536 100 87 174 1 1543875840 9636080 27412000
20:00:50 20879 8192000000 10485180528 10828054528 1540096480 15.824 100 82 164 0 1575326240 10130016 25099744
20:01:21 12649 8192000000 10499984576 10847416320 1556985088 15.970 100 82 165 0 1592752720 10277536 25490096
20:01:45 17665 8192000000 10530461536 10884452352 1592034720 16.271 100 83 166 1 1628038576 10939072 25064784
20:02:12 14877 8192000000 10560405696 10916986880 1621168496 16.520 100 80 160 3 1655793392 11074256 23550640
20:02:34 11985 8192000000 10575737744 10936041472 1637139952 16.655 100 76 152 1 1671058544 11475312 22443280
20:02:54 10048 8192000000 10597498384 10958798848 1654787968 16.805 100 74 150 2 1688441504 11548384 22105152
20:03:13 10725 8192000000 10611650608 10976759808 1671933360 16.949 100 73 146 1 1704661040 11390496 21337184
20:03:32 11754 8192000000 10620525168 10993561600 1685205904 17.061 100 71 140 1 1716787968 10719936 20862128
20:03:52 7400 8192000000 10631306944 11005763584 1696014240 17.152 100 67 134 3 1726104256 10393616 19696400
20:04:06 7854 8192000000 10661581680 11038416896 1721472448 17.364 100 70 138 1 1752764928 10952192 20340288
20:04:21 7716 8192000000 10663106944 11041013760 1732630656 17.457 100 68 136 3 1762242576 10592816 19019104
20:04:37 4947 8192000000 10686376336 11064057856 1749156816 17.595 100 78 156 2 1782929808 11506464 22266528
20:04:50 4974 8192000000 10697567776 11076681728 1760045920 17.685 100 76 152 2 1795364288 12948928 22369440
20:05:02 5132 8192000000 10706534464 11088203776 1769945040 17.767 100 77 154 1 1804293888 12705776 21643072
20:05:15 11205 8192000000 10695252992 11087081472 1773531776 17.796 100 76 150 3 1807036688 12070576 21434336
20:05:36 3625 8192000000 10718782384 11104624640 1785165008 17.892 100 71 141 0 1818703872 13549184 19989680
20:05:47 2611 8192000000 10734488000 11116064768 1794845552 17.972 100 79 159 0 1829419056 12696016 21877488
20:05:57 3184 8192000000 10745958656 11126808576 1802940624 18.038 100 81 162 2 1838268576 13012368 22315584
20:06:07 3384 8192000000 10758225056 11142569984 1813836576 18.127 100 85 169 2 1850553440 12340064 24376800
20:06:17 3360 8192000000 10758923408 11150561280 1823340256 18.205 100 83 166 1 1859169264 12460688 23368320
20:06:27 2802 8192000000 10767847808 11152052224 1832007376 18.276 100 87 175 1 1870437152 13348880 25080896
20:06:36 2484 8192000000 10782546848 11166310400 1836273312 18.310 100 84 167 1 1873160576 13156256 23731008
20:06:45 2690 8192000000 10785358864 11173072896 1844562960 18.378 100 87 174 0 1882662192 12982464 25116768
20:06:55 2795 8192000000 10789166336 11174129664 1850750336 18.428 100 90 181 0 1889775520 13378528 25646656
20:07:04 2672 8192000000 10799195664 11183878144 1853578096 18.451 100 90 179 0 1891348000 13309408 24460496
20:07:14 2178 8192000000 10802458112 11187863552 1857226000 18.481 100 95 190 2 1898972176 14928512 26817664
20:07:23 2327 8192000000 10804571104 11192291328 1859234912 18.497 100 85 168 1 1895679488 13655728 22788848
20:07:32 3047 8192000000 10805333184 11193987072 1859294800 18.498 100 92 183 3 1899432160 15030736 25106624
20:07:41 1802 8192000000 10803578976 11192303616 1862543264 18.524 100 95 191 0 1903785280 15244256 25997760
20:07:49 2004 8192000000 10807064128 11190386688 1859599040 18.500 100 87 174 1 1898478176 14272240 24606896
20:07:58 1310 8192000000 10805736224 11196514304 1862569616 18.524 100 90 181 1 1901495664 13561968 25364080
20:08:07 8248 8192000000 10805970048 11192647680 1863534528 18.532 100 83 167 1 1899353184 12563696 23254960
20:08:22 1873 8192000000 10812646464 11202519040 1864940960 18.543 100 93 189 1 1903817696 12292864 26583872
20:08:30 2207 8192000000 10801299376 11196522496 1865599936 18.549 100 77 152 0 1899921632 12217120 22104576
20:08:39 14275 8192000000 10806246944 11199197184 1869356496 18.579 100 71 143 0 1900297696 10692336 20248864
20:09:00 1529 8192000000 10802522016 11202727936 1871401728 18.596 100 74 149 0 1903485152 10702288 21381136
20:09:14 6826 8192000000 10803788016 11209162752 1868674288 18.574 100 53 102 0 1892005264 8728448 14602528
20:09:28 4840 8192000000 10777314752 11196596224 1867531904 18.564 100 39 78 4 1887213520 7623664 12057952
20:09:41 2707 8192000000 10797428336 11204923392 1872784944 18.607 100 57 114 0 1897906768 8223392 16898432
20:09:52 4891 8192000000 10782939792 11203964928 1870099056 18.585 100 41 82 1 1889624064 7627232 11897776
20:10:03 3457 8192000000 10784987264 11203596288 1869584656 18.581 100 33 67 1 1887420464 8286192 9549616
20:10:13 5199 8192000000 10793712816 11205505024 1873041136 18.609 100 49 100 0 1895017312 8142784 13833392
20:10:26 5563 8192000000 10799712224 11207938048 1875622000 18.630 100 41 83 0 1895557280 7750160 12185120
20:10:38 6607 8192000000 10787410320 11210051584 1874354832 18.619 100 33 66 0 1891866352 8381120 9130400
20:10:53 9491 8192000000 10784610160 11207372800 1874705584 18.622 100 26 54 1 1887836160 5664400 7466176
20:11:09 9118 8192000000 10791804944 11214688256 1878853632 18.656 100 22 45 0 1891412864 6786720 5772512
20:11:26 7971 8192000000 10787626768 11217354752 1880372224 18.668 100 17 34 1 1890736864 5751664 4612976
20:11:46 8484 8192000000 10793141232 11224576000 1887198848 18.723 100 21 42 2 1898357536 5870576 5288112
20:12:00 9463 8192000000 10795773264 11227656192 1890064928 18.746 100 18 36 1 1900697744 5715904 4916912
20:12:16 12431 8192000000 10814157152 11239370752 1890329824 18.748 100 12 24 1 1907860208 14637232 2893152
20:12:35 55508 8192000000 10838305632 11246710784 1901608128 18.839 100 54 108 0 1923071008 6295648 15167232
20:13:37 4698 8192000000 10826422688 11251068928 1902139856 18.844 100 45 89 3 1923059760 9432624 11487280
20:13:48 5812 8192000000 10820289808 11250212864 1899855584 18.825 100 32 64 0 1916256416 7697792 8703040
20:14:04 6354 8192000000 10815933936 11249205248 1903600048 18.855 100 30 60 2 1919141232 7429776 8111408
20:14:17 2155 8192000000 10853290112 11264430080 1911629312 18.920 100 71 142 1 1941514512 9569696 20315504
20:14:25 3867 8192000000 10828116048 11256463360 1906255824 18.877 100 44 88 1 1927503408 9062800 12184784
20:14:36 4503 8192000000 10836493456 11255402496 1908992368 18.899 100 47 95 1 1930836400 6311136 15532896
20:14:48 5569 8192000000 10828607232 11250393088 1904699344 18.864 100 28 56 0 1919563888 6772544 8092000
20:14:59 9197 8192000000 10811452160 11242885120 1885211552 18.707 99 19 38 1 1900632288 9961008 5459728
20:15:17 9889 8192000000 10807563744 11247886336 1904480672 18.862 100 27 54 2 1918585120 5738864 8365584
20:15:33 10579 8192000000 10806100176 11252219904 1904271584 18.861 100 24 49 1 1917125968 5819584 7034800
20:15:53 8998 8192000000 10803554288 11239632896 1879564336 18.662 99 22 42 0 1891546336 5924144 6057856
20:16:08 9045 8192000000 10800932784 11237666816 1878050288 18.649 99 17 34 0 1889143408 5893632 5199488
20:16:25 11428 8192000000 10806573136 11230523392 1872638400 18.606 99 18 36 1 1883504128 5838320 5027408
20:16:42 14197 8192000000 10783377568 11214155776 1839880912 18.340 97 25 51 0 1852472240 4562912 8028416
20:17:04 46698 8192000000 10825767072 11225415680 1853376208 18.450 98 68 136 3 1878833584 5551616 19905760
20:17:57 7430 8192000000 10766467088 11205906432 1852322560 18.441 99 20 40 1 1865056704 7302480 5431664
20:18:11 10340 8192000000 10758112720 11183235072 1790002304 17.932 96 17 34 1 1800675568 5279696 5393568
20:18:28 7336 8192000000 10779577088 11202596864 1845128112 18.383 99 28 56 1 1859889904 6795584 7966208
20:18:44 6603 8192000000 10750354752 11151540224 1724085040 17.386 93 39 78 2 1741093584 6581008 10427536
20:18:58 5555 8192000000 10748452288 11166437376 1829801120 18.258 100 33 66 1 1845365712 6130096 9434496
20:19:10 6196 8192000000 10714640384 11139772416 1794708896 17.970 99 26 49 2 1807687840 5864064 7114880
20:19:23 7470 8192000000 10669915184 11078000640 1714583616 17.307 96 33 66 4 1730726064 6994192 9148256
20:19:40 9536 8192000000 10716284928 11132997632 1773397840 17.795 98 29 58 0 1788661808 6812896 8451072
20:19:55 6990 8192000000 10696091808 11106254848 1768140752 17.752 98 27 55 3 1781635520 5317936 8176832
20:20:11 9270 8192000000 10687163936 11097608192 1701741904 17.200 95 33 65 1 1716622944 4918336 9962704
20:20:31 6587 8192000000 10707277552 11110801408 1765438720 17.729 99 27 55 2 1780399392 5403136 9557536
20:20:44 12779 8192000000 10711702432 11128725504 1764842032 17.724 98 24 48 3 1777711472 6056448 6812992
20:21:03 11719 8192000000 10714032624 11130204160 1782884912 17.873 99 38 76 1 1800660976 5476048 12300016
20:21:22 53453 8192000000 10708992608 11121385472 1758484816 17.672 97 38 76 2 1775664688 6462448 10717424
20:22:25 8290 8192000000 10734868720 11154051072 1819411072 18.173 100 32 64 0 1834502912 5820208 9271632
20:22:41 9026 8192000000 10723818432 11143012352 1769600496 17.764 97 24 48 1 1782573008 5536448 7436064
20:22:57 8795 8192000000 10742628672 11158712320 1805593568 18.060 99 45 90 1 1830399392 12536080 12269744
20:23:12 6315 8192000000 10743418176 11156885504 1805394480 18.058 99 35 69 1 1822084816 7369152 9321184
20:23:26 4366 8192000000 10753846880 11167227904 1831244240 18.269 100 49 98 1 1855451488 10236784 13970464
20:23:39 6422 8192000000 10746937392 11166498816 1828064048 18.244 100 24 48 3 1840538272 4978160 7496064
20:23:53 10205 8192000000 10747069104 11172818944 1834407344 18.295 100 17 33 1 1844869984 5443024 5019616
20:24:13 9282 8192000000 10746431872 11177574400 1842713696 18.363 100 27 54 0 1856810656 5924688 8172272
20:24:29 9960 8192000000 10768204864 11186892800 1846538416 18.394 100 24 48 1 1860105184 6138912 7427856
20:24:46 7267 8192000000 10765013136 11190603776 1848330592 18.409 100 29 55 1 1862503840 6071280 8101968
20:25:00 9765 8192000000 10767624160 11189391360 1850903856 18.429 100 19 38 1 1862150880 5510560 5736464
20:25:18 7479 8192000000 10766358000 11197767680 1855738000 18.469 100 15 30 0 1865882512 5329696 4814816
20:25:33 12960 8192000000 10767994704 11201323008 1860565392 18.508 100 18 36 3 1870944912 5464560 4914960
20:25:52 56247 8192000000 10803333200 11214073856 1869037088 18.576 100 28 56 0 1882928880 5020048 8871744
20:26:58 25663 8192000000 10813383200 11232997376 1880076576 18.666 100 45 87 2 1899405152 6479184 12849392
20:27:31 17319 8192000000 10820071696 11243184128 1896437952 18.798 100 45 90 0 1918082592 7436688 14207952
20:27:56 16145 8192000000 10830365616 11253731328 1904308624 18.861 100 43 86 0 1925009296 8668592 12032080
20:28:20 14083 8192000000 10843962944 11260952576 1915740800 18.953 100 55 110 0 1941071344 9841328 15489216
20:28:45 18863 8192000000 10837963840 11268296704 1914720288 18.945 100 38 74 0 1933849536 9019952 10109296
20:29:26 17561 8192000000 10860649856 11289780224 1928612352 19.056 100 45 91 4 1957589872 16321328 12656192
20:29:59 10611 8192000000 10871239312 11299704832 1940925296 19.154 100 55 110 1 1968986768 11768064 16293408
20:30:26 7234 8192000000 10889704928 11312742400 1946615280 19.200 100 55 110 2 1974886384 12556176 15714928
20:30:40 15811 8192000000 10887353392 11312726016 1947700080 19.208 100 50 100 0 1976271360 14395008 14176272
20:31:05 3021 8192000000 10892316608 11312521216 1935875280 19.114 99 62 124 2 1966465296 12574512 18015504
20:31:16 5587 8192000000 10899401648 11319517184 1956915472 19.282 100 65 130 2 1990025568 14140160 18969936
20:31:28 2911 8192000000 10897321552 11313274880 1953357952 19.253 100 67 135 1 1987014464 14606096 19050416
20:31:44 5046 8192000000 10905444672 11319627776 1943244256 19.173 99 70 139 0 1977416784 14598032 19574496
20:31:56 4407 8192000000 10908968880 11316396032 1954569424 19.263 100 84 166 0 1993206064 15379664 23256976
20:32:12 3847 8192000000 10901882800 11324174336 1957181728 19.284 100 62 123 1 1989547392 15167120 17198544
20:32:24 7105 8192000000 10905336912 11323457536 1960033792 19.306 100 54 108 1 1990630496 14909232 15687472
20:32:41 5598 8192000000 10908523728 11329794048 1966145840 19.355 100 70 140 2 2000650208 15229344 19275024
20:32:56 8408 8192000000 10898902784 11318521856 1952207072 19.244 99 65 127 0 1985757984 15729792 17821120
20:33:12 4856 8192000000 10919385280 11341860864 1970455056 19.389 100 77 154 1 2013156800 20953920 21747824
20:33:27 9604 8192000000 10910299616 11335356416 1972623360 19.406 100 66 132 1 2007795696 16761264 18411072
20:33:43 8562 8192000000 10922229536 11346837504 1976904560 19.440 100 57 114 0 2013168864 19065984 17198320
20:34:03 11467 8192000000 10921577456 11351793664 1978571792 19.453 100 59 118 0 2014887744 18346928 17969024
20:34:25 7496 8192000000 10931596640 11357835264 1986094064 19.513 100 63 126 2 2022242208 17587712 18560432
20:34:40 6075 8192000000 10925908288 11359596544 1985364672 19.507 100 53 106 1 2018970560 18423424 15182464
20:34:54 3437 8192000000 10935439360 11360313344 1988928304 19.535 100 61 118 3 2025113680 17883408 18301968
20:35:08 6984 8192000000 10938404896 11366035456 1991930480 19.559 100 68 134 1 2029751488 17208928 20612080
20:35:22 2541 8192000000 10954947424 11367387136 1994907216 19.583 100 83 162 3 2037040784 17607936 24525632
20:35:31 13398 8192000000 10935545552 11367247872 1979055264 19.457 99 61 122 0 2016325120 19308672 17961184
20:35:58 13956 8192000000 10934460384 11362435072 1986263408 19.514 100 61 121 1 2023537488 18999216 18274864
20:36:21 9291 8192000000 10945482272 11377532928 1994996416 19.583 100 55 110 0 2032854176 21548848 16308912
20:36:41 10105 8192000000 10958301504 11391459328 2007043296 19.678 100 64 126 1 2050902080 24486848 19371936
20:36:59 3882 8192000000 10958063264 11393548288 2011446032 19.713 100 69 138 0 2056859600 24504672 20908896
20:37:10 5092 8192000000 10934817680 11369242624 1978942272 19.456 99 60 119 0 2018074896 21394304 17738320
20:37:22 12174 8192000000 10933967648 11364507648 1969541984 19.382 99 49 98 1 2005829232 21654752 14632496
20:37:43 7805 8192000000 10920472928 11344285696 1947020560 19.203 98 60 120 2 1984798624 20200576 17577488
20:37:59 5772 8192000000 10943484832 11369521152 1987242960 19.522 100 60 120 0 2026439840 20945792 18251088
20:38:14 17292 8192000000 10926216096 11358867456 1950536160 19.231 98 58 111 0 1989507808 22243728 16727920
20:38:40 10988 8192000000 10917271984 11341111296 1915990864 18.955 96 68 133 1 1960402400 24559088 19852448
20:39:06 3062 8192000000 10933653104 11348250624 1956520448 19.278 99 75 151 0 2006820000 27464816 22834736
20:39:18 3651 8192000000 10943476000 11365408768 1980720688 19.470 100 71 139 0 2029953024 28064640 21167696
20:39:30 5551 8192000000 10944805136 11367546880 1968327664 19.372 99 73 144 1 2018389840 28211264 21850912
20:39:46 5228 8192000000 10927554432 11354038272 1958013008 19.290 99 60 118 0 2003861040 27511216 18336816
20:40:05 7923 8192000000 10935766176 11365408768 1981888400 19.480 100 71 137 1 2031146720 28148416 21109904
20:40:22 6273 8192000000 10964165584 11380477952 1993410592 19.571 100 71 140 0 2049828144 35491600 20925952
20:40:37 2605 8192000000 10963527728 11386851328 1999160336 19.616 100 70 140 0 2053676288 32934128 21581824
20:40:48 5288 8192000000 10966584880 11384565760 1993781264 19.574 100 77 155 0 2051684336 32963104 24939968
20:41:02 5063 8192000000 10949196144 11372797952 1970503568 19.389 99 67 134 1 2025782352 34108880 21169904
20:41:15 5346 8192000000 10969224672 11389612032 1993937280 19.575 100 81 158 5 2056284560 37394224 24953056
20:41:27 3430 8192000000 10966828400 11382280192 1974822000 19.424 99 79 155 3 2038495472 39138688 24534784
20:41:42 5299 8192000000 10934848224 11353915392 1935506800 19.111 98 73 144 1 1998440112 40389712 22543600
20:41:54 8214 8192000000 10939509024 11362127872 1951393504 19.238 99 68 134 2 2013405968 40923248 21089216
20:42:11 1994 8192000000 10946141744 11359555584 1965664592 19.351 100 82 160 0 2032839856 41245184 25930080
20:42:20 3099 8192000000 10944580320 11366965248 1970078256 19.386 100 65 129 1 2030317024 40081152 20157616
20:42:31 1825 8192000000 10960957648 11372011520 1979634800 19.462 100 77 152 2 2045078496 40907568 24536128
20:42:41 3425 8192000000 10955776112 11372011520 1964227360 19.340 99 75 150 1 2030394672 42183312 23984000
20:42:54 2833 8192000000 10975260768 11383705600 1988321040 19.531 100 87 171 1 2056733520 41945808 26466672
20:43:04 2498 8192000000 10975726160 11393478656 1996473312 19.595 100 80 159 1 2065350432 42986928 25890192
20:43:14 3660 8192000000 10974499392 11391213568 1985773808 19.510 100 76 150 0 2053855440 44246544 23835088
20:43:27 2754 8192000000 10972368496 11386003456 1986298304 19.515 100 86 169 3 2056933952 44181120 26454528
20:43:37 2551 8192000000 10969288128 11375177728 1973779936 19.415 100 87 173 1 2047306368 46184032 27342400
20:43:48 2027 8192000000 10956495600 11371773952 1970294304 19.388 100 84 164 2 2043139728 46321088 26524336
20:43:57 4561 8192000000 10954091728 11367235584 1974629904 19.422 100 78 156 0 2037136464 37967344 24539216
20:44:10 1758 8192000000 10969963952 11377942528 1981394880 19.476 100 89 176 1 2046580880 38348848 26837152
20:44:20 1923 8192000000 10964202784 11372568576 1978441680 19.452 100 94 187 2 2047498432 40263824 28792928
20:44:30 3524 8192000000 10969746816 11378323456 1978890368 19.456 100 82 161 2 2045447312 41501280 25055664
20:44:41 3679 8192000000 10979510112 11387858944 1986347904 19.515 100 88 177 3 2056039168 41872192 27819072
20:44:51 7599 8192000000 10964386208 11383451648 1983688288 19.494 100 73 145 0 2047665872 40927856 23049728
20:45:08 4629 8192000000 10956932864 11383963648 1983983584 19.496 100 67 133 1 2046762544 41428336 21350624
20:45:24 1944 8192000000 10964925680 11383676928 1980143616 19.466 100 71 137 2 2044553072 43062944 21346512
20:45:33 3344 8192000000 10964333136 11377885184 1973748752 19.415 100 85 169 5 2044879728 44488784 26642192
20:45:43 7722 8192000000 10948645808 11367587840 1969121872 19.378 100 73 146 2 2038565312 46120368 23323072
20:46:01 6232 8192000000 10957787936 11376766976 1967669712 19.367 100 74 148 1 2038917136 47381856 23865568
20:46:13 2140 8192000000 10957237264 11368988672 1953662000 19.256 99 80 157 1 2026505648 48641680 24201968
20:46:26 16823 8192000000 10959895504 11388055552 1974260448 19.419 100 65 129 1 2039725920 44960656 20504816
20:46:50 13008 8192000000 10957268496 11386654720 1979727856 19.463 100 61 122 0 2043785056 44574944 19482256
20:47:30 11851 8192000000 10965729920 11402846208 1989958048 19.543 100 54 106 1 2053780112 46623440 17198624
20:47:51 10377 8192000000 10946398544 11374116864 1960290624 19.308 99 62 124 0 2019341456 38904704 20146128
20:48:15 1747 8192000000 10979514640 11393404928 1994933520 19.583 100 84 167 0 2065767168 42241408 28592240
20:48:23 1846 8192000000 10980739776 11396870144 1993652912 19.573 100 83 166 0 2061655120 42028672 25973536
20:48:33 2974 8192000000 11000944240 11411718144 2000003040 19.623 100 81 159 2 2069133392 43933152 25197200
20:48:42 3066 8192000000 11004588400 11413893120 2010451968 19.705 100 83 165 4 2080056352 42534528 27069856
20:48:53 6658 8192000000 10958208688 11393945600 1977493392 19.445 99 52 104 2 2033312096 38634000 17184704
20:49:10 4870 8192000000 10956059040 11397410816 1992149728 19.561 100 46 93 1 2043017920 35897856 14970336
20:49:28 7420 8192000000 10951734288 11390353408 1956487760 19.278 98 46 92 2 2007515376 36392416 14635200
20:49:52 12519 8192000000 10940620400 11384578048 1959013888 19.298 99 35 70 3 2011760672 40937952 11808832
20:50:21 8197 8192000000 10944300832 11387224064 1974980480 19.425 100 48 95 3 2033637360 42086720 16570160
20:50:37 9466 8192000000 10944952944 11389952000 1973764304 19.415 100 37 74 2 2028013168 41879712 12369152
20:50:53 14624 8192000000 10944759664 11382693888 1952772992 19.249 99 36 72 1 2010671792 44563296 13335504
20:51:16 4486 8192000000 10958056320 11387457536 1972795232 19.408 100 58 117 0 2039565024 46225808 20543984
20:51:29 15954 8192000000 10921733408 11364900864 1937677808 19.128 99 37 74 0 2000297280 49591200 13028272
20:52:04 21108 8192000000 10936320752 11368980480 1952031664 19.243 100 33 66 0 2008652496 45017568 11603264
20:52:33 22811 8192000000 10933094704 11382734848 1955159008 19.268 100 32 62 0 2018223328 51562976 11501344
20:53:24 30507 8192000000 10926670752 11379851264 1958795216 19.296 100 32 64 4 2020465040 49739984 11929840
20:54:55 36762 8192000000 10881621776 11345637376 1923714368 19.017 99 15 30 1 1955533312 26827472 4991472
20:56:11 13655 8192000000 10910533648 11340275712 1945426496 19.190 100 65 129 4 1978608896 13937344 19245056
20:56:32 81045 8192000000 10869567744 11329429504 1908391504 18.894 98 40 79 1 1928267264 8724256 11151504
20:58:02 84876 8192000000 10889891984 11355062272 1958123040 19.291 100 20 40 1 1976723776 12273472 6327264
20:59:35 23861 8192000000 10909884800 11349561344 1949915744 19.226 99 29 58 0 1967049216 9152336 7981136
21:00:08 30824 8192000000 10871157376 11328552960 1906292848 18.877 97 26 52 2 1920043104 7154672 6595584
21:00:46 42163 8192000000 10893218944 11356618752 1962780928 19.328 100 41 80 0 1981716816 8395744 10540144
21:01:38 97165 8192000000 10855620080 11314671616 1868970160 18.576 95 10 20 1 1882085392 10380560 2734672
21:03:22 91343 8192000000 10883930128 11349110784 1938769440 19.137 99 14 28 0 1956200768 13867344 3563984
21:05:37 93850 8192000000 10891585200 11351932928 1940527968 19.151 99 12 24 0 1957228592 13437280 3263344
21:07:18 114474 8192000000 10891821616 11373039616 1951690592 19.240 99 13 26 0 1976266656 20705120 3870944
21:10:56 79754 8192000000 10889148144 11353837568 1954409568 19.262 99 16 31 1 1965282880 6530448 4342864
21:12:44 58287 8192000000 10877200752 11363037184 1965043792 19.346 100 14 28 1 1981840448 12858032 3938624
21:13:51 46131 8192000000 10893257344 11373232128 1971429488 19.397 100 9 18 1 1988915968 15236000 2250480
21:14:58 46776 8192000000 10900240336 11386155008 1963888992 19.337 99 5 10 0 1977929552 12924800 1115760
21:15:51 56384 8192000000 10904373872 11389276160 1964027888 19.338 99 8 16 0 1980520912 14095056 2397968
21:17:05 34108 8192000000 10906318192 11381538816 1974372080 19.420 99 13 26 2 1985028848 7123344 3533424
21:17:46 26820 8192000000 10871272512 11334369280 1864515200 18.540 94 15 30 2 1875553104 6888048 4149856
21:18:19 22315 8192000000 10909224464 11366248448 1971843504 19.400 100 53 105 1 2000524064 13538352 15142208
21:18:47 26530 8192000000 10899165040 11368808448 1962023008 19.322 99 25 50 0 1985648976 16420496 7205472
21:19:30 31146 8192000000 10923668112 11391033344 1989020464 19.536 100 27 54 4 2016765904 18931616 8813824
21:20:07 50964 8192000000 10936200192 11409256448 1996040160 19.591 100 19 38 2 2021981392 19753760 6187472
21:21:05 56998 8192000000 10919888768 11385352192 1971194192 19.395 99 20 40 2 2003771248 25921552 6655504
21:22:08 70928 8192000000 10903868784 11392479232 1947723360 19.208 98 13 26 1 1972004208 20066336 4214512
21:23:32 69901 8192000000 10932801408 11402883072 1967000000 19.362 99 19 37 0 1989893920 17257024 5636896
21:24:55 73631 8192000000 10898653456 11351142400 1868164656 18.569 94 14 28 2 1885967280 13579136 4223488
21:26:15 16970 8192000000 10894461872 11356884992 1947951360 19.210 99 35 70 1 1968649872 10885296 9813216
21:26:42 47528 8192000000 10887043632 11330633728 1888747952 18.736 96 30 60 2 1908904752 11917008 8239792
21:27:36 44359 8192000000 10890144720 11340324864 1948450256 19.214 99 65 130 2 1976442400 10461392 17530752
21:28:51 98429 8192000000 10897861584 11363938304 1950387472 19.230 99 24 48 0 1974165488 17273664 6504352
21:31:03 44738 8192000000 10873833184 11348987904 1928623760 19.056 98 14 28 0 1944593632 11620288 4349584
21:31:54 47005 8192000000 10830326400 11300352000 1873666656 18.614 96 4 8 0 1881927472 7169776 1091040
21:32:47 54610 8192000000 10839414528 11310055424 1883312208 18.692 97 10 20 1 1895945568 9909056 2724304
21:34:07 56673 8192000000 10857975136 11320840192 1867807840 18.567 96 23 46 1 1887406992 13142784 6456368
21:35:14 68315 8192000000 10846463376 11313577984 1782819184 17.873 92 14 28 2 1795514688 8402528 4292976
21:36:55 52515 8192000000 10885323648 11325321216 1919489808 18.983 99 43 87 2 1945467968 13631072 12347088
21:37:54 71428 8192000000 10855909216 11331670016 1896644192 18.799 98 14 28 2 1913590112 13775600 3170320
21:39:15 76914 8192000000 10861318992 11329396736 1889781952 18.744 98 9 18 0 1905504832 13436192 2286688
21:40:42 77372 8192000000 10885839104 11324051456 1862229280 18.521 96 10 20 0 1876921504 12083936 2608288
21:42:10 29905 8192000000 10893879936 11344384000 1950185648 19.228 100 39 78 0 1974463184 13418848 10858688
21:42:47 56124 8192000000 10869763616 11344252928 1926414848 19.038 99 20 40 0 1947293712 15440544 5438320
21:43:57 12695 8192000000 10855040704 11306352640 1883421280 18.693 97 45 91 0 1902314704 5728368 13165056
21:44:21 12263 8192000000 10890623424 11330146304 1942578624 19.167 100 50 98 1 1966448896 10400880 13469392
21:44:44 17295 8192000000 10899676432 11344285696 1926913488 19.042 99 49 96 0 1954535088 14016720 13604880
21:45:12 70884 8192000000 10861653296 11331596288 1886172736 18.715 97 18 36 2 1905344224 14386992 4784496
21:46:37 137625 8192000000 10854516416 11323662336 1900138176 18.827 98 19 38 1 1918947744 13645936 5163632
21:49:02 18931 8192000000 10846662400 11315257344 1909847664 18.905 99 13 26 0 1925558624 12224384 3486576
21:49:27 30115 8192000000 10852637072 11319017472 1930927888 19.074 100 14 28 0 1943946832 9291824 3727120
21:50:07 60343 8192000000 10854359712 11322232832 1922957344 19.011 99 15 30 0 1934864624 7754608 4152672
21:51:19 39300 8192000000 10849054736 11327037440 1923379072 19.014 99 9 18 0 1937338544 11207680 2751792
21:52:05 30553 8192000000 10840654208 11305107456 1898342704 18.813 98 11 22 0 1910792304 9537872 2911728
21:52:43 69710 8192000000 10833407056 11305762816 1902064352 18.843 99 7 14 0 1911528864 7364032 2100480
21:54:00 46022 8192000000 10873183808 11331260416 1902449008 18.846 98 10 20 0 1917466576 12422576 2594992
21:55:01 52879 8192000000 10855373488 11327848448 1901566896 18.839 98 13 26 3 1919020304 13622816 3830592
21:56:05 38789 8192000000 10869281360 11330064384 1929377920 19.062 99 22 44 0 1943941360 8389008 6174432
21:57:15 50250 8192000000 10836300048 11283595264 1873163728 18.610 96 40 80 2 1893784624 9779952 10840944
21:58:16 38675 8192000000 10869424192 11327631360 1910028832 18.907 98 30 59 1 1925839808 8129120 7681856
21:59:03 76878 8192000000 10896009296 11354411008 1941365552 19.158 99 17 34 0 1960798000 15212832 4219616
22:00:26 69552 8192000000 10868125600 11335950336 1921563888 18.999 98 9 18 0 1937040496 12944752 2531856
22:01:42 90530 8192000000 10865960288 11338956800 1889535024 18.742 97 12 25 0 1902720720 9838032 3347664
22:03:35 36716 8192000000 10894113008 11344371712 1929882144 19.066 98 43 87 1 1950301648 8578720 11840784
22:04:21 45329 8192000000 10866687728 11334946816 1907613184 18.887 98 26 52 0 1926377056 11539792 7224080
22:05:12 51058 8192000000 10869119328 11338457088 1925883248 19.034 99 13 26 0 1939565184 9665504 4016432
22:06:09 108436 8192000000 10869888416 11338854400 1878852016 18.656 96 8 16 0 1891394976 10551584 1991376
22:08:04 167134 8192000000 10879136656 11340177408 1866904816 18.559 95 17 34 1 1881354912 10082384 4367712
22:11:01 60321 8192000000 10872522528 11340988416 1885707968 18.711 96 22 44 2 1903858880 12610192 5540720
22:12:25 10509 8192000000 10859882352 11327737856 1927275088 19.045 99 22 44 0 1948683056 14769088 6638880
22:12:42 12326 8192000000 10844096784 11316604928 1891599216 18.759 98 8 16 0 1907681904 13824896 2257792
22:13:00 33104 8192000000 10853108528 11320614912 1915858720 18.954 99 28 57 2 1930644720 6453520 8332480
22:13:55 64546 8192000000 10860910288 11328798720 1908071904 18.891 98 21 42 1 1924987776 10868608 6047264
22:15:19 73067 8192000000 10867465552 11341082624 1895500576 18.790 97 12 24 1 1914356960 15677872 3178512
22:16:43 62074 8192000000 10835727984 11312316416 1827395792 18.238 94 6 11 2 1838554240 8705056 2453392
22:17:55 76725 8192000000 10873870800 11337306112 1880848720 18.672 97 11 22 0 1891899392 7534816 3515856
22:19:18 52615 8192000000 10886008208 11331461120 1905769792 18.873 98 23 46 2 1927466512 15168608 6528112
22:20:26 41308 8192000000 10856184208 11320176640 1909692464 18.904 99 31 62 3 1943706496 24901680 9112352
22:21:24 64268 8192000000 10834413600 11302719488 1831412928 18.271 95 13 26 0 1854490176 19008080 4069168
22:22:37 35238 8192000000 10866811696 11305971712 1867358112 18.563 97 32 64 1 1885680592 9316912 9005568
22:23:21 58479 8192000000 10830708096 11289079808 1870595440 18.589 97 23 46 0 1890609760 13682288 6332032
22:24:26 101982 8192000000 10830163376 11303874560 1829053168 18.252 95 12 24 2 1851803664 19882304 2868192
22:26:16 18631 8192000000 10888182080 11313557504 1898330000 18.813 98 52 104 0 1923788256 10264704 15193552
22:26:43 10235 8192000000 10883581216 11328786432 1938828368 19.137 100 48 96 0 1961188048 9630064 12729616

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 01-11-2020 22:27:59 to 01-11-2020 22:28:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 148 v_add_invoice_to_stock 335544517
user_exc 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 01-11-2020 22:28:32 to 01-11-2020 22:28:34.

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          247119
MON$OLDEST_ACTIVE               249529
MON$OLDEST_SNAPSHOT             249529
MON$NEXT_TRANSACTION            249529
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                       2010432
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33383 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33383 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33383 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33383 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 ---
:166: 
:167: mscs-test-161.budzdorov.ru    Sun Nov  1 22:27:01 2020
:168:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:169: 
:170: 
:171: mscs-test-161.budzdorov.ru    Sun Nov  1 22:27:01 2020
:172:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:173: 
:174: 
:175: mscs-test-161.budzdorov.ru    Sun Nov  1 22:27:03 2020
:176:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:177: 
:178: 
:179: mscs-test-161.budzdorov.ru    Sun Nov  1 22:27:04 2020
:180:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:181: 
:182: 
:183: mscs-test-161.budzdorov.ru    Sun Nov  1 22:27:07 2020
:184:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:185: 
--- end of diff output ---

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

01.11.20 22:28:35. 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-01 22:28:38 No severe PSQL-related problems occured
01.11.20 22:28:39. End of report.