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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-14 16:27:23
DTS_END                         2021-03-14 16:27:23.9060
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45814
TRN_ID                          243274
ATT_ID                          712
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9221.30 18832 1106556
customer order: creation 175.21 360 21025
customer order: refuse 14.71 330 1765
order to supplier: creation 46.49 1344 5579
order to supplier: removal 3.50 87558 420
invoice (draft): creation 46.71 3644 5605
invoice (draft): removal 52.90 651 6348
invoice accept: apply 41.68 18347 5001
invoice accept: cancel 47.73 802 5727
customer reserve: creation 3832.46 183 459895
customer reserve: removal 4661.30 51 559356
realization accept: apply 84.27 183 10112
realization accept: cancel 83.50 104 10020
payment from customer: creation 59.58 115 7149
payment from customer: removal 6.14 86 737
payment to supplier: creation 49.22 124 5906
payment to supplier: removal 3.43 109 412
service: total inventory turnovers 4.79 1104 575
service: total monetary turnovers 6.83 31 819
service: aggregate perf. data 0.84 24031 101
service: refresh index statistics 0.03 237481 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-03-2021 16:28:39 to 14-03-2021 16:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4126
TEST_TIME 2 5300
TEST_TIME 3 5551
TEST_TIME 4 5381
TEST_TIME 5 5229
TEST_TIME 6 5082
TEST_TIME 7 5025
TEST_TIME 8 5176
TEST_TIME 9 5475
TEST_TIME 10 5543
TEST_TIME 11 5980
TEST_TIME 12 6030
TEST_TIME 13 6223
TEST_TIME 14 6203
TEST_TIME 15 6387
TEST_TIME 16 6750
TEST_TIME 17 6849
TEST_TIME 18 7331
TEST_TIME 19 7847
TEST_TIME 20 8174
TEST_TIME 21 8468
TEST_TIME 22 9060
TEST_TIME 23 8896
TEST_TIME 24 9267
TEST_TIME 25 9421
TEST_TIME 26 9489
TEST_TIME 27 9695
TEST_TIME 28 9812
TEST_TIME 29 9876
TEST_TIME 30 10334
TEST_TIME 31 10212
TEST_TIME 32 10007
TEST_TIME 33 10086
TEST_TIME 34 9865
TEST_TIME 35 9959
TEST_TIME 36 9909
TEST_TIME 37 10091
TEST_TIME 38 9862
TEST_TIME 39 9784
TEST_TIME 40 9699
TEST_TIME 41 9667
TEST_TIME 42 9737
TEST_TIME 43 9705
TEST_TIME 44 9571
TEST_TIME 45 9471
TEST_TIME 46 9409
TEST_TIME 47 9353
TEST_TIME 48 9503
TEST_TIME 49 9504
TEST_TIME 50 9486
TEST_TIME 51 9569
TEST_TIME 52 9639
TEST_TIME 53 9562
TEST_TIME 54 9722
TEST_TIME 55 9662
TEST_TIME 56 9619
TEST_TIME 57 9645
TEST_TIME 58 9790
TEST_TIME 59 9841
TEST_TIME 60 9870
TEST_TIME 61 9725
TEST_TIME 62 9634
TEST_TIME 63 9583
TEST_TIME 64 9530
TEST_TIME 65 9506
TEST_TIME 66 9411
TEST_TIME 67 9365
TEST_TIME 68 9348
TEST_TIME 69 9316
TEST_TIME 70 9264
TEST_TIME 71 9260
TEST_TIME 72 9258
TEST_TIME 73 9341
TEST_TIME 74 9356
TEST_TIME 75 9369
TEST_TIME 76 9380
TEST_TIME 77 9353
TEST_TIME 78 9323
TEST_TIME 79 9374
TEST_TIME 80 9409
TEST_TIME 81 9455
TEST_TIME 82 9482
TEST_TIME 83 9507
TEST_TIME 84 9509
TEST_TIME 85 9490
TEST_TIME 86 9387
TEST_TIME 87 9353
TEST_TIME 88 9361
TEST_TIME 89 9388
TEST_TIME 90 9348
TEST_TIME 91 9302
TEST_TIME 92 9261
TEST_TIME 93 9249
TEST_TIME 94 9214
TEST_TIME 95 9205
TEST_TIME 96 9294
TEST_TIME 97 9261
TEST_TIME 98 9239
TEST_TIME 99 9269
TEST_TIME 100 9287
TEST_TIME 101 9288
TEST_TIME 102 9354
TEST_TIME 103 9364
TEST_TIME 104 9347
TEST_TIME 105 9416
TEST_TIME 106 9435
TEST_TIME 107 9468
TEST_TIME 108 9413
TEST_TIME 109 9338
TEST_TIME 110 9301
TEST_TIME 111 9354
TEST_TIME 112 9307
TEST_TIME 113 9267
TEST_TIME 114 9247
TEST_TIME 115 9199
TEST_TIME 116 9242
TEST_TIME 117 9274
TEST_TIME 118 9249
TEST_TIME 119 9280
TEST_TIME 120 9222

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-03-2021 16:28:43 to 14-03-2021 16:28:46.

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 1532929 1532929 0 0.00 0 19437 6 0 0
doc_list_biud 1532918 1532918 0 0.00 0 26319 24 0 0
sp_add_invoice_to_stock 5102 5001 101 1.97 29 236571 18348 0 101
sp_cancel_adding_invoice 5727 5727 0 0.00 6 65231 803 0 0
sp_cancel_client_order 1765 1765 0 0.00 4 8372 330 0 0
sp_cancel_customer_reserve 559356 559356 0 0.00 1 24510 52 0 0
sp_cancel_pay_from_customer 737 737 0 0.00 2 5716 86 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 10375 109 0 0
sp_cancel_supplier_invoice 6355 6348 7 0.11 1 20520 652 0 7
sp_cancel_supplier_order 420 420 0 0.00 6 947481 87559 0 0
sp_cancel_write_off 10020 10020 0 0.00 1 11686 104 0 0
sp_client_order 21025 21025 0 0.00 3 23391 360 0 0
sp_customer_reserve 459895 459895 0 0.00 0 78509 183 0 0
sp_fill_shopping_cart 32207 32207 0 0.00 1 20092 40 0 0
sp_fill_shopping_cart_clo_res 459893 459893 0 0.00 0 19689 15 0 0
sp_get_clo_for_invoice 4999 4999 0 0.00 0 36904 301 0 0
sp_kill_cost_storno 16896 16896 0 0.00 0 7329 53 0 0
sp_kill_qstorno_ret_qs2qd 1135500 1135500 0 0.00 0 24497 28 0 0
sp_kill_qty_storno 598738 598738 0 0.00 0 26319 61 0 0
sp_lock_selected_doc 20941 20941 0 0.00 0 7722 7 0 0
sp_make_cost_storno 28165 28165 0 0.00 0 15278 58 0 0
sp_multiply_rows_for_pdistr 28157 28157 0 0.00 0 6152 26 0 0
sp_multiply_rows_for_qdistr 21025 21025 0 0.00 0 23288 173 0 0
sp_pay_from_customer 7149 7149 0 0.00 4 11764 116 0 0
sp_pay_to_supplier 5906 5906 0 0.00 4 12739 124 0 0
sp_payment_common 13053 13053 0 0.00 2 7983 30 0 0
sp_qd_handle_on_cancel_clo 1765 1765 0 0.00 0 8346 298 0 0
sp_qd_handle_on_invoice_upd_sts 10718 10718 0 0.00 0 21406 331 0 0
sp_qd_handle_on_reserve_upd_sts 10111 10111 0 0.00 0 26318 61 0 0
sp_reserve_write_off 10112 10112 0 0.00 6 34086 183 0 0
sp_supplier_invoice 5605 5605 0 0.00 6 88192 3645 0 0
sp_supplier_order 5579 5579 0 0.00 4 37665 1345 0 0
srv_aggregate_perf_data 101 101 0 0.00 2802 825823 24032 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1378 136606 32687 0 0
srv_find_qd_qs_mism 1058728 1058728 0 0.00 0 12525 5 0 0
srv_make_invnt_saldo 575 575 0 0.00 45 129899 1104 0 0
srv_make_money_saldo 819 819 0 0.00 1 6307 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 149973 371731 237482 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5001 5001 0 0.00 0 7258 143 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 5404 100 0 0
t$perf-norm:sp_cancel_client_order 1765 1765 0 0.00 0 9220 22 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 4382 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 737 737 0 0.00 0 7170 25 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 1013 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1357 18 0 0
t$perf-norm:sp_cancel_supplier_order 420 420 0 0.00 0 21743 1755 0 0
t$perf-norm:sp_cancel_write_off 1005 1005 0 0.00 0 5113 14 0 0
t$perf-norm:sp_client_order 21025 21025 0 0.00 0 9218 18 0 0
t$perf-norm:sp_customer_reserve 995 995 0 0.00 0 984 4 0 0
t$perf-norm:sp_pay_from_customer 7149 7149 0 0.00 0 3104 7 0 0
t$perf-norm:sp_pay_to_supplier 5906 5906 0 0.00 0 2758 8 0 0
t$perf-norm:sp_reserve_write_off 10112 10112 0 0.00 0 9191 11 0 0
t$perf-norm:sp_supplier_invoice 5605 5605 0 0.00 0 7477 18 0 0
t$perf-norm:sp_supplier_order 5579 5579 0 0.00 0 9728 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 122 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 79 1 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 922 21 0 0
t$perf-norm:srv_make_money_saldo 819 819 0 0.00 0 1977 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10184 9982 202 1.98 0 9072 20 0 202
v_all_customers 37736 37736 0 0.00 0 113 1 0 0
v_all_suppliers 30776 30776 0 0.00 0 22 1 0 0
v_all_wares 42050 42050 0 0.00 0 117 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 1284 8 0 0
v_cancel_client_order 3530 3530 0 0.00 0 2809 5 0 0
v_cancel_customer_prepayment 1474 1474 0 0.00 0 2812 10 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 2793 6 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 7273 16 0 0
v_cancel_supplier_invoice 810 796 14 1.72 0 1214 14 0 14
v_cancel_supplier_order 840 840 0 0.00 0 4196 13 0 0
v_cancel_write_off 2010 2010 0 0.00 0 2533 13 0 0
v_max_id_clo_ord 5579 5579 0 0.00 0 268 1 0 0
v_max_id_clo_res 995 995 0 0.00 0 6263 16 0 0
v_max_id_ord_sup 5602 5602 0 0.00 0 3319 3 0 0
v_max_non_paid_invoice 1698 1698 0 0.00 0 1523 3 0 0
v_max_non_paid_realizn 4077 4077 0 0.00 0 3177 4 0 0
v_min_id_clo_ord 5579 5579 0 0.00 0 20086 10 0 0
v_min_id_clo_res 995 995 0 0.00 0 4879 8 0 0
v_min_id_ord_sup 5602 5602 0 0.00 0 5729 5 0 0
v_min_non_paid_invoice 5905 5905 0 0.00 0 7560 18 0 0
v_min_non_paid_realizn 7147 7147 0 0.00 0 5360 19 0 0
v_our_firm 10454 10454 0 0.00 0 113 1 0 0
v_reserve_write_off 20220 20220 0 0.00 0 9602 9 0 0
x_lock_depdocs_on_canc_invoice 11677 11677 0 0.00 0 18897 118 0 0
x_lock_depdocs_on_canc_sup_ord 420 420 0 0.00 0 11732 342 0 0
x_make_qstorno_1000_1200 5579 5579 0 0.00 2 37645 1259 0 0
x_make_qstorno_1200_2000 5605 5605 0 0.00 3 88160 3502 0 0
x_make_qstorno_2100_3300 459894 459894 0 0.00 0 78508 165 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-03-2021 16:28:47 to 14-03-2021 16:28:51.

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:27 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:34 21227 8192000000 10274545168 10583547904 947171072 10.363 74 50 102 0 965456544 2540560 15744912
13:58:07 29465 8192000000 10340236384 10660835328 1391396608 14.518 100 85 169 0 1424409472 5554768 27458096
13:58:45 29896 8192000000 10384323408 10709868544 1433645552 14.894 100 81 162 0 1466896272 6778432 26472288
13:59:32 19270 8192000000 10420123568 10751262720 1474254400 15.251 100 82 164 0 1507784944 7465408 26065136
14:00:03 16321 8192000000 10431735280 10767269888 1497010544 15.450 100 87 174 0 1532659632 8410272 27238816
14:00:31 22702 8192000000 10468720096 10806181888 1523793600 15.683 100 84 168 0 1559111440 9245648 26072192
14:01:03 21116 8192000000 10485750768 10827816960 1539617520 15.820 100 83 166 0 1575186528 9587648 25981360
14:01:32 22262 8192000000 10506001488 10851438592 1553536416 15.941 100 84 168 0 1589768112 10130112 26101584
14:02:02 11310 8192000000 10516523408 10863894528 1573377472 16.111 100 89 178 1 1611824128 11065792 27380864
14:02:22 13032 8192000000 10534228016 10889482240 1588714448 16.243 100 78 155 1 1622930208 10515408 23700352
14:02:42 13096 8192000000 10556717296 10915684352 1618253376 16.495 100 73 147 0 1651355696 11103952 21998368
14:03:03 9760 8192000000 10586163440 10943660032 1637843568 16.661 100 75 150 1 1671769472 11251936 22673968
14:03:20 12042 8192000000 10603747280 10964271104 1665536848 16.896 100 84 168 2 1702966464 12288816 25140800
14:03:40 8111 8192000000 10622164704 10988154880 1675770288 16.982 100 78 156 0 1710963520 12085904 23107328
14:03:55 10358 8192000000 10651115792 11015983104 1698886544 17.176 100 80 158 0 1733827696 11940608 23000544
14:04:13 8796 8192000000 10653574000 11025145856 1713326832 17.297 100 84 167 1 1750426064 12499952 24599280
14:04:28 5369 8192000000 10665247280 11033247744 1718897536 17.343 100 78 154 1 1753393472 12306304 22189632
14:04:43 6589 8192000000 10679443504 11050954752 1738821392 17.509 100 81 164 1 1774875312 13296784 22757136
14:04:57 5655 8192000000 10693952880 11066515456 1752725728 17.624 100 87 174 1 1791227776 13675152 24826896
14:05:10 6058 8192000000 10700717808 11073921024 1761313600 17.695 100 84 167 2 1798336432 13368896 23653936
14:05:24 4534 8192000000 10698745936 11079036928 1764723984 17.723 100 80 160 0 1801452400 14273504 22454912
14:05:35 4571 8192000000 10718206832 11093037056 1774412608 17.803 100 84 168 0 1811812432 14066080 23333744
14:05:47 4616 8192000000 10729303696 11103182848 1786315136 17.901 100 80 162 0 1821587520 13525088 21747296
14:05:58 3065 8192000000 10729001792 11104964608 1791678080 17.946 100 89 175 3 1829376448 14293648 23404720
14:06:08 2971 8192000000 10739714720 11119349760 1796199344 17.983 100 88 171 1 1833733392 14008144 23525904
14:06:17 3538 8192000000 10744289088 11123675136 1800606208 18.019 100 82 166 1 1837604656 14018816 22979632
14:06:27 2173 8192000000 10754633968 11132174336 1808857984 18.087 100 87 175 1 1846793264 13404384 24530896
14:06:36 3540 8192000000 10746421040 11126910976 1810817728 18.103 100 80 159 1 1845187840 12067840 22302272
14:06:46 3846 8192000000 10752690016 11135455232 1815400912 18.140 100 75 150 1 1848647200 12784064 20462224
14:06:57 5760 8192000000 10751343616 11140571136 1817773840 18.159 100 79 153 0 1851512144 12777696 20960608
14:07:10 2016 8192000000 10773169696 11157311488 1832354224 18.279 100 94 188 3 1872578240 13980080 26243936
14:07:19 1626 8192000000 10780937408 11164446720 1835286128 18.302 100 87 175 0 1874051328 14096784 24668416
14:07:27 1919 8192000000 10783254960 11172405248 1839774464 18.339 100 90 180 1 1878236816 12967776 25494576
14:07:36 2214 8192000000 10781954016 11165216768 1845113424 18.382 100 88 176 0 1883749776 13227696 25408656
14:07:44 2511 8192000000 10791878272 11176751104 1847648704 18.403 100 88 176 1 1885637904 12678720 25310480
14:07:53 2207 8192000000 10793338496 11180417024 1848399776 18.409 100 90 181 1 1887026160 13487808 25138576
14:08:02 2346 8192000000 10795910112 11179626496 1852184848 18.440 100 91 182 1 1892642704 15331184 25126672
14:08:11 1437 8192000000 10798179264 11182870528 1852317248 18.441 100 92 184 1 1893316992 15223904 25775840
14:08:19 2252 8192000000 10802314464 11186171904 1854656112 18.460 100 99 196 2 1896377984 13493408 28228464
14:08:28 2498 8192000000 10800775872 11184074752 1856736048 18.477 100 93 187 2 1896081808 13237056 26108704
14:08:36 1870 8192000000 10808503232 11192631296 1858856560 18.494 100 97 195 0 1901444448 15047216 27540672
14:08:45 2091 8192000000 10803986448 11190554624 1858162304 18.488 100 92 183 2 1897529728 13479728 25887696
14:08:53 2204 8192000000 10805654256 11195052032 1865099232 18.545 100 94 188 3 1906988416 14878096 27011088
14:09:02 15432 8192000000 10808464416 11195527168 1863391984 18.531 100 84 168 1 1900078496 13263696 23422816
14:09:24 2273 8192000000 10816284224 11205439488 1870356512 18.587 100 90 176 0 1908921920 13415840 25149568
14:09:33 20010 8192000000 10768099376 11186851840 1859659872 18.501 100 41 82 2 1880707072 9319264 11727936
14:10:00 7271 8192000000 10776871648 11192389632 1860509744 18.507 100 33 67 0 1875963024 5688464 9764816
14:10:14 9361 8192000000 10776801568 11204141056 1864981008 18.544 100 26 52 0 1879897792 7844368 7072416
14:10:31 5893 8192000000 10780997408 11205545984 1868585056 18.573 100 33 65 3 1889053856 11366640 9102160
14:10:43 5949 8192000000 10767036304 11197919232 1866322928 18.555 100 31 62 0 1881755040 6551440 8880672
14:10:55 6828 8192000000 10783810176 11202150400 1869387600 18.579 100 28 56 1 1884157568 5935184 8834784
14:11:09 7766 8192000000 10773456608 11200651264 1869661408 18.582 100 20 41 1 1881731664 5767088 6303168
14:11:27 3875 8192000000 10782548608 11211464704 1873383312 18.612 100 24 49 1 1890538544 10622432 6532800
14:11:40 7147 8192000000 10775891136 11205861376 1871919504 18.600 100 14 27 0 1880811056 5307920 3583632
14:11:54 10666 8192000000 10780586288 11209609216 1874478384 18.620 100 28 56 3 1888775424 6197824 8099216
14:12:14 10546 8192000000 10786461952 11219554304 1879130496 18.658 100 24 48 2 1891941424 6390256 6420672
14:12:39 8158 8192000000 10793157440 11229302784 1886741616 18.720 100 23 46 1 1899294016 6609728 5942672
14:12:53 14927 8192000000 10801389856 11225174016 1890880336 18.753 100 28 56 0 1904555248 5840208 7834704
14:13:15 64681 8192000000 10845938144 11249176576 1898736848 18.816 100 48 98 1 1918428400 5682656 14008896
14:14:26 2250 8192000000 10828018400 11249115136 1901561024 18.839 100 64 131 0 1930107056 10271728 18274304
14:14:35 5199 8192000000 10812438480 11242151936 1897801296 18.809 100 28 56 1 1913589744 6936304 8852144
14:14:47 8010 8192000000 10815778688 11243208704 1887237344 18.724 99 29 58 1 1901475376 6187968 8050064
14:15:02 23261 8192000000 10827761552 11240947712 1895890048 18.793 100 45 88 2 1915288608 6446624 12951936
14:15:31 11044 8192000000 10810345216 11243634688 1895226480 18.788 100 33 66 2 1915829984 11280512 9322992
14:15:51 5793 8192000000 10814407376 11250245632 1903030864 18.851 100 30 60 1 1919272096 7385168 8856064
14:16:03 8291 8192000000 10810584096 11240902656 1866287104 18.554 98 27 53 2 1880444480 5471392 8685984
14:16:21 5747 8192000000 10799192576 11225731072 1869248288 18.578 99 26 53 1 1882101104 5285216 7567600
14:16:34 4451 8192000000 10807972480 11232260096 1883074336 18.690 100 28 55 0 1897080928 5920560 8086032
14:16:46 7654 8192000000 10796908624 11230793728 1882253632 18.683 100 27 54 0 1900893424 11029312 7610480
14:17:01 7484 8192000000 10803322912 11230023680 1886566256 18.718 100 25 50 0 1899960304 6534656 6859392
14:17:15 12108 8192000000 10777691696 11213963264 1833960944 18.292 97 27 52 3 1846924048 4781872 8181232
14:17:34 7878 8192000000 10775968176 11204833280 1829376480 18.254 98 27 55 2 1842613872 5573200 7664192
14:17:50 50842 8192000000 10793442912 11205758976 1814583776 18.133 97 34 68 2 1830376128 5721104 10071248
14:18:47 16726 8192000000 10735775808 11152949248 1695694336 17.149 91 18 36 1 1706621520 6164544 4762640
14:19:13 7128 8192000000 10759250512 11177639936 1822160640 18.195 99 40 78 1 1840740272 8096096 10483536
14:19:31 8900 8192000000 10748988112 11166896128 1817210528 18.155 99 34 68 1 1832859408 6498608 9150272
14:19:47 6822 8192000000 10752053328 11171209216 1835511056 18.304 100 37 74 1 1852559984 6189744 10859184
14:20:00 5142 8192000000 10715617696 11131256832 1762043792 17.701 96 25 48 0 1775066032 5287296 7734944
14:20:12 5484 8192000000 10737480672 11155193856 1805870944 18.062 99 32 64 1 1821195936 6260144 9064848
14:20:26 6139 8192000000 10712053392 11121147904 1782830272 17.873 99 26 52 1 1796606048 5128832 8646944
14:20:43 4887 8192000000 10689115712 11089096704 1762314064 17.704 98 27 54 5 1775801488 5556320 7931104
14:20:56 6340 8192000000 10703266016 11115474944 1757888864 17.667 98 27 54 2 1771332480 5514496 7929120
14:21:12 7150 8192000000 10685838672 11100524544 1764950928 17.725 98 20 40 0 1776317824 5039200 6327696
14:21:27 10381 8192000000 10706637712 11128897536 1758816016 17.675 97 18 36 2 1769567168 5944752 4806400
14:21:46 10507 8192000000 10734189984 11152297984 1816187504 18.147 100 30 60 1 1831511088 6105904 9217680
14:22:03 14126 8192000000 10752976800 11158212608 1797192064 17.991 98 26 51 2 1809133104 4764080 7176960
14:22:26 59117 8192000000 10727405616 11156824064 1775985552 17.816 97 25 49 0 1788014928 5020336 7009040
14:23:33 11181 8192000000 10746516080 11148587008 1797003584 17.989 98 26 52 0 1809087632 5203968 6880080
14:23:50 5019 8192000000 10741248160 11166535680 1831285536 18.270 100 38 77 1 1847785888 5188256 11312096
14:24:02 12769 8192000000 10771097920 11190169600 1844283920 18.376 100 39 78 1 1862644848 7505728 10855200
14:24:24 10549 8192000000 10779789264 11198119936 1855355472 18.466 100 21 42 1 1866172432 4962368 5854592
14:24:41 7515 8192000000 10791866160 11208269824 1865351584 18.547 100 42 83 1 1885559824 8765888 11442352
14:24:56 7969 8192000000 10783376464 11205476352 1865595920 18.549 100 42 84 1 1883499904 6177456 11726528
14:25:11 10326 8192000000 10783296304 11209900032 1866623648 18.557 100 32 64 1 1882191264 5868656 9698960
14:25:28 5364 8192000000 10775335440 11209150464 1868818000 18.575 100 34 69 1 1885396864 6340880 10237984
14:25:44 15845 8192000000 10791386544 11219742720 1875052800 18.625 100 32 64 1 1890369952 5055424 10261728
14:26:06 13618 8192000000 10789227616 11224748032 1878922128 18.656 100 17 34 1 1894229616 9502704 5804784
14:26:26 8226 8192000000 10788745488 11224031232 1876654320 18.638 100 15 30 2 1886163008 5331040 4177648
14:26:41 7472 8192000000 10788297264 11227013120 1881882176 18.680 100 27 54 1 1896328896 6302512 8144208
14:26:59 18568 8192000000 10813049216 11244027904 1895310256 18.789 100 22 43 1 1906477328 5419584 5747488
14:27:24 18907 8192000000 10849985216 11265773568 1911298368 18.917 100 36 72 1 1928514336 5817616 11398352
14:27:51 92165 8192000000 10835441088 11264335872 1884851152 18.704 98 51 102 1 1907170592 7508752 14810688
14:29:30 2726 8192000000 10853785536 11282898944 1927323376 19.045 100 57 115 0 1952089456 8300288 16465792
14:29:41 9710 8192000000 10850901200 11276062720 1906150672 18.876 99 42 82 2 1926155808 8540592 11464544
14:29:58 3717 8192000000 10870661600 11292987392 1932898736 19.090 100 63 124 2 1961008320 10429344 17680240
14:30:15 2346 8192000000 10865030400 11286286336 1929450768 19.062 100 55 109 1 1955607632 10695744 15461120
14:30:32 6011 8192000000 10879569648 11301707776 1938759440 19.137 100 57 114 2 1968830496 13560880 16510176
14:30:48 25371 8192000000 10878891344 11304341504 1946817696 19.201 100 51 102 0 1973640480 12462912 14359872
14:31:21 5494 8192000000 10882913216 11312934912 1949395616 19.222 100 46 92 0 1974194064 11995168 12803280
14:31:36 26310 8192000000 10900181248 11330052096 1962816528 19.328 100 54 108 0 1991331296 12680496 15834272
14:32:12 5704 8192000000 10906186320 11335639040 1970453744 19.389 100 58 114 0 1999675520 12492912 16728864
14:32:34 2738 8192000000 10922014864 11342249984 1976235824 19.435 100 56 107 1 2003971744 12612368 15123552
14:32:47 9603 8192000000 10915601168 11345776640 1982405472 19.484 100 65 130 1 2015412144 14289024 18717648
14:33:22 24428 8192000000 10919382032 11355848704 1981486032 19.476 100 41 82 1 2007327440 13836656 12004752
14:33:56 11523 8192000000 10925410608 11360026624 1988613200 19.533 100 57 114 0 2022316384 16966480 16736704
14:34:19 11819 8192000000 10925475632 11364102144 1990282816 19.546 100 45 90 1 2021762176 17832112 13647248
14:34:41 16742 8192000000 10927822464 11370090496 1992351472 19.562 100 46 92 2 2023523104 17598912 13572720
14:35:07 15322 8192000000 10927793504 11362324480 1970605056 19.390 99 45 90 0 2004036048 20285744 13145248
14:35:46 11296 8192000000 10942140432 11376205824 1987982912 19.528 100 42 84 2 2025458832 24675056 12800864
14:36:07 29205 8192000000 10940448208 11382722560 1993915344 19.575 100 49 98 1 2032714400 22947680 15851376
14:36:50 14271 8192000000 10937079648 11380137984 1982599696 19.485 99 38 74 1 2017350032 22869648 11880688
14:37:13 15977 8192000000 10939964656 11377184768 1988504288 19.532 100 47 93 1 2024094352 21498192 14091872
14:37:42 6161 8192000000 10944198032 11377070080 1990556912 19.548 100 59 117 0 2034133312 25283728 18292672
14:37:56 7999 8192000000 10955434352 11386023936 1997953872 19.607 100 64 128 2 2045422752 27316256 20152624
14:38:12 4291 8192000000 10969557632 11393380352 1999898640 19.622 100 62 121 2 2045217072 27249488 18068944
14:38:24 4938 8192000000 10974650144 11402899456 2007714752 19.684 100 69 136 0 2057756576 28852976 21188848
14:38:37 9079 8192000000 10942399216 11364728832 1968281040 19.372 98 66 131 2 2016965280 29277520 19406720
14:38:54 5959 8192000000 10939823328 11369422848 1981481312 19.476 100 58 114 2 2025088304 26386416 17220576
14:39:12 18995 8192000000 10912453184 11348762624 1944149200 19.180 98 49 98 0 1986799344 27116720 15533424
14:39:42 17447 8192000000 10899415696 11336970240 1935850784 19.114 98 45 88 1 1976204080 26638160 13715136
14:40:10 2936 8192000000 10934820352 11361239040 1972940512 19.409 100 68 136 2 2022138864 28771424 20426928
14:40:21 4534 8192000000 10910384736 11340656640 1954090704 19.259 100 67 134 1 2002606912 28238384 20277824
14:40:39 8639 8192000000 10920921536 11351613440 1962289680 19.324 100 55 110 1 2006906416 27451472 17165264
14:40:55 5927 8192000000 10917126704 11348881408 1959898064 19.305 100 63 126 2 2008802784 28031408 20873312
14:41:21 9384 8192000000 10923946864 11362332672 1970775216 19.392 100 43 85 2 2009964400 25624160 13565024
14:41:41 10614 8192000000 10941320192 11368087552 1961273312 19.316 99 54 106 0 2004284048 26608704 16402032
14:42:05 3552 8192000000 10947524448 11368128512 1960221920 19.308 99 75 145 0 2012748832 31102832 21424080
14:42:16 4493 8192000000 10957303072 11374120960 1980239232 19.467 100 79 158 1 2036821840 32948912 23633696
14:42:28 4962 8192000000 10941109264 11368779776 1966485792 19.358 99 68 135 1 2021194192 33925408 20782992
14:42:40 1884 8192000000 10956357920 11371651072 1964433792 19.341 99 90 180 0 2024908528 34122304 26352432
14:42:48 8847 8192000000 10961682544 11384569856 1989944720 19.543 100 83 164 1 2047954384 33619456 24390208
14:43:04 3279 8192000000 10952086688 11365326848 1970058064 19.386 99 85 171 1 2029299088 32421888 26819136
14:43:13 2765 8192000000 10968510304 11384967168 1988057600 19.528 100 84 168 2 2049143888 34204720 26881568
14:43:23 4074 8192000000 10973523696 11390062592 1991170592 19.553 100 82 162 2 2050972640 34944880 24857168
14:43:36 2633 8192000000 10966626288 11384344576 1987452800 19.524 100 89 175 3 2049033008 35835712 25744496
14:43:46 3903 8192000000 10947630240 11368914944 1973038480 19.410 100 73 145 0 2031235600 35834288 22362832
14:43:58 3695 8192000000 10943318976 11360575488 1967415776 19.365 100 78 155 1 2028377776 37133184 23828816
14:44:09 4506 8192000000 10953234560 11375935488 1976175184 19.434 100 78 155 3 2037404912 36758656 24471072
14:44:26 2622 8192000000 10956250304 11375128576 1974550288 19.422 100 72 143 1 2035679232 38694848 22434096
14:44:38 7000 8192000000 10951717680 11374133248 1974890048 19.424 100 73 146 0 2035537168 37850512 22796608
14:45:00 4121 8192000000 10961588256 11372175360 1971715680 19.399 100 83 165 1 2036910640 39653040 25541920
14:45:12 3238 8192000000 10935171776 11345281024 1943489616 19.175 99 81 161 1 2007775920 38781264 25505040
14:45:26 3915 8192000000 10957262160 11377696768 1979012512 19.457 100 76 152 0 2039547728 36747840 23787376
14:45:39 9164 8192000000 10951708656 11373940736 1970828400 19.392 100 67 134 0 2029332544 37785696 20718448
14:45:55 2596 8192000000 10965775424 11381014528 1983250848 19.490 100 87 173 3 2046513328 37102272 26160208
14:46:05 1377 8192000000 10977297984 11395407872 1989396288 19.539 100 84 168 2 2054217472 39025072 25796112
14:46:13 4475 8192000000 10957038432 11386920960 1983343232 19.491 100 73 145 1 2044954208 39299408 22311568
14:46:26 6134 8192000000 10944813552 11387392000 1977375248 19.444 100 43 84 1 2030450592 38813904 14261440
14:46:45 14563 8192000000 10923602096 11375091712 1964036880 19.338 100 32 64 2 2010775056 36336320 10401856
14:47:06 17688 8192000000 10915875360 11370520576 1944236704 19.181 99 25 50 0 1992570240 39814000 8519536
14:47:40 24004 8192000000 10915649200 11351056384 1918005664 18.971 98 33 66 0 1963074864 34237232 10831968
14:48:12 3412 8192000000 10922489312 11346165760 1939978656 19.147 100 71 142 2 1996855248 35361664 21514928
14:48:23 3618 8192000000 10924065600 11347886080 1925758640 19.033 99 70 136 1 1990107568 43023424 21325504
14:48:34 1822 8192000000 10916842864 11334594560 1930103232 19.068 100 77 154 1 1996283200 42191056 23988912
14:48:43 4274 8192000000 10915374448 11338948608 1938783088 19.137 100 70 139 1 1996831792 35702608 22346096
14:48:56 10193 8192000000 10895757856 11338768384 1921390048 18.998 99 27 54 1 1967323808 36312000 9621760
14:49:18 6730 8192000000 10895034768 11335229440 1930529728 19.071 100 25 50 2 1969424992 30466880 8428384
14:49:32 15127 8192000000 10885699792 11336605696 1934702688 19.104 100 33 62 2 1979279776 34469664 10107424
14:50:00 24169 8192000000 10881764992 11324567552 1915671328 18.952 99 38 76 1 1952642976 25502800 11468848
14:50:43 14965 8192000000 10876171136 11324497920 1913299840 18.933 99 31 61 1 1954591648 31546432 9745376
14:51:12 14960 8192000000 10873179584 11316068352 1889536720 18.742 98 26 52 1 1926939744 29283136 8119888
14:51:40 31034 8192000000 10868947088 11321630720 1925716224 19.033 100 21 42 0 1957232656 25095712 6420720
14:52:46 35119 8192000000 10849608880 11293057024 1839078912 18.333 96 21 40 1 1874558656 28964352 6515392
14:53:29 10269 8192000000 10858935632 11304275968 1897891664 18.809 99 43 86 0 1937813760 27077600 12844496
14:53:52 27080 8192000000 10865995120 11313881088 1928573072 19.055 100 22 44 1 1964993888 29483728 6937088
14:54:27 34965 8192000000 10871483200 11331256320 1916226944 18.957 99 21 42 0 1943088896 20395728 6466224
14:55:13 39527 8192000000 10878575184 11327008768 1916647184 18.960 99 17 34 1 1940711280 18886960 5177136
14:56:49 69183 8192000000 10884970128 11354697728 1930897520 19.074 100 6 11 1 1956791168 24450400 1443248
14:58:05 56409 8192000000 10914449184 11351818240 1963714192 19.336 100 25 51 2 1979674192 9941104 6018896
14:59:11 29863 8192000000 10934595632 11365629952 1978876496 19.456 100 60 118 3 2007556320 11794800 16885024
14:59:48 51347 8192000000 10916332608 11360903168 1953048608 19.251 99 24 48 0 1975823104 15716016 7058480
15:00:46 80604 8192000000 10903246560 11347914752 1960408800 19.309 100 15 30 1 1982934240 17783840 4741600
15:02:18 96575 8192000000 10906820352 11367055360 1953255472 19.252 99 24 48 2 1972368928 12741568 6371888
15:04:00 101232 8192000000 10896180592 11373461504 1969376336 19.380 100 19 38 2 1995957104 21089584 5491184
15:06:03 20027 8192000000 10892990912 11354202112 1954264528 19.260 99 21 42 0 1971667184 11190304 6212352
15:06:29 11380 8192000000 10896737456 11353341952 1967683776 19.367 100 25 50 0 1984831984 10093504 7054704
15:06:48 6000 8192000000 10920107184 11363291136 1979966128 19.464 100 63 129 4 2009825952 10373936 19485888
15:07:03 26092 8192000000 10897270048 11349434368 1936204816 19.116 98 25 50 4 1955164368 12022672 6936880
15:07:39 36922 8192000000 10925375808 11369299968 1978134160 19.450 100 46 90 0 2004008656 12180736 13693760
15:08:23 4224 8192000000 10944664384 11362426880 1970588752 19.390 99 83 164 1 2007471104 12626160 24256192
15:08:35 24456 8192000000 10909830448 11367104512 1975994992 19.433 100 37 74 1 2000743664 13292464 11456208
15:09:10 21302 8192000000 10901913408 11369537536 1977472944 19.445 100 18 37 0 1995312896 12453440 5386512
15:09:45 27500 8192000000 10899049488 11375341568 1979498160 19.461 100 22 44 2 1998827888 12858672 6471056
15:10:20 29246 8192000000 10889422272 11357782016 1955552224 19.271 99 4 8 0 1968069472 11620752 896496
15:10:56 35103 8192000000 10892284288 11361259520 1973385440 19.412 100 6 12 0 1984335264 9211328 1738496
15:11:37 126530 8192000000 10909880960 11384328192 1989208080 19.538 100 19 39 0 2007613520 12788000 5617440
15:13:52 34583 8192000000 10933323040 11385421824 1991447008 19.555 100 41 82 0 2015564528 12326672 11790848
15:14:38 41337 8192000000 10903812880 11385442304 1971244032 19.395 99 19 38 0 1991819632 15028928 5546672
15:15:29 56950 8192000000 10911594672 11378704384 1969312736 19.380 99 16 32 1 1986024864 12197104 4515024
15:16:34 32632 8192000000 10925897024 11387265024 1995870288 19.590 100 34 68 1 2019359840 13668736 9820816
15:17:17 39272 8192000000 10878051888 11337945088 1873179520 18.610 94 32 62 1 1891441136 9026960 9234656
15:18:33 81946 8192000000 10902976368 11375665152 1939593136 19.144 98 12 24 0 1954835696 11722416 3520144
15:20:09 75568 8192000000 10917414368 11393970176 1955135104 19.267 98 12 24 2 1972082256 13580224 3366928
15:21:35 48919 8192000000 10895261168 11370131456 1944006224 19.179 98 6 12 1 1958423216 12827248 1589744
15:22:39 49113 8192000000 10889184704 11339460608 1849632992 18.419 93 45 89 0 1875786576 14327264 11826320
15:23:35 51848 8192000000 10881667968 11346092032 1922810144 19.009 98 31 61 1 1946127152 14832304 8484704
15:24:33 81962 8192000000 10857506240 11332923392 1827198896 18.236 94 8 16 1 1844043872 14720672 2124304
15:26:01 92607 8192000000 10883237760 11351400448 1885316640 18.708 97 3 6 0 1898018608 12192464 509504
15:28:54 64895 8192000000 10897333872 11353935872 1914449840 18.942 97 31 62 1 1929522128 6608240 8464048
15:30:07 57800 8192000000 10898820944 11368849408 1969561008 19.382 100 28 56 2 1989139648 11862432 7716208
15:31:14 5167 8192000000 10903482976 11374166016 1979374752 19.460 100 24 48 0 1998045680 11938224 6732704
15:31:26 12408 8192000000 10864452496 11335786496 1897961200 18.810 96 17 32 1 1909388736 6379936 5047600
15:31:48 27676 8192000000 10879486224 11349626880 1960501632 19.310 100 24 48 1 1976925024 8669936 7753456
15:34:04 86695 8192000000 10891636112 11365711872 1920332720 18.990 97 19 38 3 1937573072 11407616 5832736
15:36:01 64482 8192000000 10891374448 11354247168 1912878960 18.930 97 14 28 1 1938090880 21205280 4006640
15:37:15 80709 8192000000 10889751184 11355631616 1902402384 18.846 97 24 48 0 1930020064 20415024 7202656
15:38:43 50388 8192000000 10871783376 11338014720 1928309600 19.053 99 15 30 0 1951932720 19290208 4332912
15:39:40 50798 8192000000 10885144304 11363819520 1941079840 19.155 99 13 25 3 1967028304 21291504 4656960
15:40:41 28883 8192000000 10848077872 11327287296 1913022192 18.931 98 10 20 0 1927364720 11701312 2641216
15:41:16 95656 8192000000 10835922624 11311792128 1770162448 17.768 91 11 22 0 1783830272 10796160 2871664
15:42:57 37931 8192000000 10853458752 11297857536 1870144528 18.585 97 39 78 2 1892864080 11032000 11687552
15:43:47 31173 8192000000 10841097808 11290697728 1847386736 18.401 96 40 80 2 1871757056 13943024 10427296
15:44:26 17468 8192000000 10837956304 11287621632 1890107216 18.747 99 47 94 0 1913513072 10120976 13284880
15:44:50 25349 8192000000 10849706864 11301634048 1892161856 18.763 99 43 86 2 1920328544 15936464 12230224
15:45:26 19158 8192000000 10868410496 11315769344 1919983056 18.987 100 39 78 0 1945271632 14309200 10979376
15:45:53 23878 8192000000 10860787040 11316060160 1901609920 18.839 99 47 93 3 1929800576 15669952 12520704
15:46:25 44216 8192000000 10851664208 11314757632 1898163248 18.812 99 27 54 0 1919749792 14286480 7300064
15:47:21 55254 8192000000 10842265728 11310485504 1888459488 18.733 98 27 54 1 1910255728 13870400 7925840
15:48:22 51540 8192000000 10851193856 11327971328 1915612640 18.952 100 8 16 0 1934432976 16654816 2165520
15:49:23 47416 8192000000 10858071424 11342045184 1911185136 18.916 99 21 42 1 1934918688 17238560 6494992
15:50:36 107425 8192000000 10861351120 11340107776 1888292144 18.732 97 26 52 2 1908015232 12447040 7276048
15:52:30 63469 8192000000 10886124320 11345330176 1930487632 19.071 99 22 44 0 1944399520 7653776 6258112
15:54:03 83470 8192000000 10882155584 11368255488 1959259120 19.300 100 21 42 1 1977049216 12110944 5679152
15:55:47 10617 8192000000 10880175280 11370008576 1956113440 19.275 100 11 22 1 1974648704 15218832 3316432
15:56:26 44512 8192000000 10889533616 11361173504 1943541344 19.175 99 23 42 2 1955772320 6434736 5796240
15:57:40 46615 8192000000 10867011040 11354185728 1951443360 19.238 100 6 12 0 1963599504 10603008 1553136
15:58:33 41849 8192000000 10868694624 11351203840 1939871024 19.146 99 5 10 0 1949943696 9032416 1040256
15:59:21 84500 8192000000 10882001488 11363049472 1938861584 19.138 99 14 28 1 1948563696 5673392 4028720
16:00:57 60246 8192000000 10897718784 11366490112 1931949536 19.082 98 15 30 0 1945083088 9490000 3643552
16:02:09 39268 8192000000 10898726096 11380146176 1980147072 19.466 100 25 50 0 1997720768 10765568 6808128
16:02:55 58976 8192000000 10895361232 11380334592 1963063584 19.330 99 22 42 0 1981592768 12369056 6160128
16:04:00 50793 8192000000 10910470352 11379523584 1955926928 19.274 98 23 45 0 1971242048 8486992 6828128
16:04:57 56116 8192000000 10909923264 11377352704 1945264768 19.189 98 31 62 0 1969507792 14618128 9624896
16:06:01 57358 8192000000 10887795504 11362230272 1937786144 19.129 98 27 54 0 1964807440 18530624 8490672
16:07:29 68520 8192000000 10906155424 11380846592 1951613072 19.239 99 15 30 0 1973444432 17534000 4297360
16:08:50 54262 8192000000 10898102736 11383701504 1941188544 19.156 98 32 64 4 1964945344 14495696 9261104
16:09:55 23970 8192000000 10885713392 11344961536 1916129904 18.956 97 26 52 3 1935098720 11707024 7261792
16:10:27 37650 8192000000 10908168784 11374002176 1954898544 19.265 99 45 90 2 1978698512 11543232 12256736
16:11:12 50527 8192000000 10882328464 11345432576 1891103776 18.755 96 27 54 2 1912336048 13772176 7460096
16:12:19 47050 8192000000 10888771968 11372904448 1956613872 19.279 100 19 38 0 1977381120 15292880 5474368
16:13:20 56262 8192000000 10898981808 11378388992 1968008000 19.370 100 18 36 1 1989031952 15594848 5429104
16:14:24 77213 8192000000 10914496640 11362922496 1922299392 19.005 97 23 46 1 1946186144 15904320 7982432
16:15:58 136606 8192000000 10895122240 11365519360 1933539824 19.095 98 36 72 0 1962476480 18588224 10348432
16:18:55 61638 8192000000 10880015744 11373551616 1931622208 19.080 98 14 28 0 1950021376 14481904 3917264
16:20:04 52624 8192000000 10889578896 11373961216 1969231744 19.379 100 16 32 1 1984988768 11580560 4176464
16:21:11 85787 8192000000 10865562016 11339264000 1837993792 18.324 93 12 24 0 1857727248 16416368 3317088
16:22:43 111479 8192000000 10885196688 11364331520 1933307360 19.093 99 9 18 1 1954755520 18708976 2739184
16:24:41 61526 8192000000 10893934592 11365224448 1940984032 19.155 99 13 26 1 1958445280 13909648 3551600
16:26:06 42024 8192000000 10863700016 11346255872 1894634704 18.783 97 23 45 0 1911974832 10644768 6695360

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 14-03-2021 16:28:53 to 14-03-2021 16:29:24.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 101 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-03-2021 16:29:25 to 14-03-2021 16:29:27.

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          242162
MON$OLDEST_ACTIVE               243605
MON$OLDEST_SNAPSHOT             243605
MON$NEXT_TRANSACTION            243605
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                       2031584
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:50: 
:51: mscs-test-161.budzdorov.ru    Sun Mar 14 16:27:31 2021
:52:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:53: 
:54: 
:55: mscs-test-161.budzdorov.ru    Sun Mar 14 16:27:32 2021
:56:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:57: 
:58: 
:59: mscs-test-161.budzdorov.ru    Sun Mar 14 16:27:34 2021
:60:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:61: 
:62: 
:63: mscs-test-161.budzdorov.ru    Sun Mar 14 16:27:36 2021
:64:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:65: 
:66: 
:67: mscs-test-161.budzdorov.ru    Sun Mar 14 16:27:37 2021
:68:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:69: 
--- end of diff output ---

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

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