Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.06.2021 19:29
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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 17039264 kB
MemAvailable 31417836 kB
Buffers 0 kB
Cached 14654864 kB
SwapCached 2440 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-06-18 19:27:39
DTS_END                         2021-06-18 19:27:39.9570
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/52498
TRN_ID                          244328
ATT_ID                          667
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: 9681.72 16986 1161806
customer order: creation 179.68 334 21562
customer order: refuse 14.78 323 1774
order to supplier: creation 47.97 1270 5756
order to supplier: removal 3.72 92181 446
invoice (draft): creation 47.61 3271 5713
invoice (draft): removal 55.35 745 6642
invoice accept: apply 43.29 17255 5195
invoice accept: cancel 49.74 796 5969
customer reserve: creation 4024.88 170 482986
customer reserve: removal 4910.26 55 589231
realization accept: apply 85.93 184 10311
realization accept: cancel 84.31 106 10117
payment from customer: creation 61.11 119 7333
payment from customer: removal 5.79 59 695
payment to supplier: creation 51.15 118 6138
payment to supplier: removal 3.66 104 439
service: total inventory turnovers 4.80 954 576
service: total monetary turnovers 6.79 42 815
service: aggregate perf. data 0.87 19597 104
service: refresh index statistics 0.03 202043 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-06-2021 19:29:36 to 18-06-2021 19:29:38.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5178
TEST_TIME 2 6124
TEST_TIME 3 5863
TEST_TIME 4 5533
TEST_TIME 5 5672
TEST_TIME 6 5197
TEST_TIME 7 5259
TEST_TIME 8 5728
TEST_TIME 9 6029
TEST_TIME 10 6104
TEST_TIME 11 6103
TEST_TIME 12 6322
TEST_TIME 13 6628
TEST_TIME 14 6588
TEST_TIME 15 6802
TEST_TIME 16 6924
TEST_TIME 17 7303
TEST_TIME 18 7542
TEST_TIME 19 7840
TEST_TIME 20 8049
TEST_TIME 21 8291
TEST_TIME 22 8718
TEST_TIME 23 8643
TEST_TIME 24 9086
TEST_TIME 25 10011
TEST_TIME 26 9943
TEST_TIME 27 10426
TEST_TIME 28 10860
TEST_TIME 29 10879
TEST_TIME 30 10803
TEST_TIME 31 10920
TEST_TIME 32 10822
TEST_TIME 33 10838
TEST_TIME 34 10881
TEST_TIME 35 10819
TEST_TIME 36 10699
TEST_TIME 37 10710
TEST_TIME 38 10602
TEST_TIME 39 10383
TEST_TIME 40 10318
TEST_TIME 41 10372
TEST_TIME 42 10171
TEST_TIME 43 10237
TEST_TIME 44 10140
TEST_TIME 45 10156
TEST_TIME 46 10176
TEST_TIME 47 10293
TEST_TIME 48 10169
TEST_TIME 49 10098
TEST_TIME 50 9992
TEST_TIME 51 9877
TEST_TIME 52 10010
TEST_TIME 53 10003
TEST_TIME 54 10000
TEST_TIME 55 10061
TEST_TIME 56 10023
TEST_TIME 57 10091
TEST_TIME 58 10090
TEST_TIME 59 10071
TEST_TIME 60 10202
TEST_TIME 61 10174
TEST_TIME 62 10158
TEST_TIME 63 10255
TEST_TIME 64 10240
TEST_TIME 65 10328
TEST_TIME 66 10259
TEST_TIME 67 10248
TEST_TIME 68 10099
TEST_TIME 69 10158
TEST_TIME 70 10164
TEST_TIME 71 10062
TEST_TIME 72 10125
TEST_TIME 73 10053
TEST_TIME 74 9987
TEST_TIME 75 9937
TEST_TIME 76 9929
TEST_TIME 77 9867
TEST_TIME 78 9838
TEST_TIME 79 9794
TEST_TIME 80 9711
TEST_TIME 81 9738
TEST_TIME 82 9732
TEST_TIME 83 9817
TEST_TIME 84 9834
TEST_TIME 85 9846
TEST_TIME 86 9829
TEST_TIME 87 9890
TEST_TIME 88 9905
TEST_TIME 89 9877
TEST_TIME 90 9872
TEST_TIME 91 9853
TEST_TIME 92 9919
TEST_TIME 93 9949
TEST_TIME 94 9988
TEST_TIME 95 9903
TEST_TIME 96 9901
TEST_TIME 97 9857
TEST_TIME 98 9814
TEST_TIME 99 9821
TEST_TIME 100 9782
TEST_TIME 101 9751
TEST_TIME 102 9739
TEST_TIME 103 9705
TEST_TIME 104 9689
TEST_TIME 105 9679
TEST_TIME 106 9685
TEST_TIME 107 9647
TEST_TIME 108 9681
TEST_TIME 109 9687
TEST_TIME 110 9708
TEST_TIME 111 9695
TEST_TIME 112 9660
TEST_TIME 113 9722
TEST_TIME 114 9721
TEST_TIME 115 9740
TEST_TIME 116 9740
TEST_TIME 117 9849
TEST_TIME 118 9778
TEST_TIME 119 9747
TEST_TIME 120 9686

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 18-06-2021 19:29:39 to 18-06-2021 19:29:43.

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 1608706 1608706 0 0.00 0 13976 6 0 0
doc_list_biud 1608703 1608703 0 0.00 0 40032 26 0 0
sp_add_invoice_to_stock 5333 5195 138 2.58 33 174522 17255 0 138
sp_cancel_adding_invoice 5969 5969 0 0.00 5 91386 796 0 0
sp_cancel_client_order 1774 1774 0 0.00 4 15175 324 0 0
sp_cancel_customer_reserve 589231 589231 0 0.00 1 40034 55 0 0
sp_cancel_pay_from_customer 695 695 0 0.00 3 2373 60 0 0
sp_cancel_pay_to_supplier 439 439 0 0.00 3 7850 105 0 0
sp_cancel_supplier_invoice 6648 6642 6 0.09 2 31439 745 0 6
sp_cancel_supplier_order 446 446 0 0.00 4 1113924 92182 0 0
sp_cancel_write_off 10117 10117 0 0.00 1 8894 106 0 0
sp_client_order 21562 21562 0 0.00 3 16317 335 0 0
sp_customer_reserve 482986 482986 0 0.00 0 133277 171 0 0
sp_fill_shopping_cart 33010 33010 0 0.00 1 13326 34 0 0
sp_fill_shopping_cart_clo_res 482977 482977 0 0.00 0 17221 12 0 0
sp_get_clo_for_invoice 5186 5186 0 0.00 0 26237 265 0 0
sp_kill_cost_storno 17220 17220 0 0.00 0 8045 54 0 0
sp_kill_qstorno_ret_qs2qd 1195667 1195667 0 0.00 0 40025 30 0 0
sp_kill_qty_storno 629674 629674 0 0.00 0 40032 65 0 0
sp_lock_selected_doc 21501 21501 0 0.00 0 8410 4 0 0
sp_make_cost_storno 28968 28968 0 0.00 0 13974 51 0 0
sp_multiply_rows_for_pdistr 28965 28965 0 0.00 0 9945 28 0 0
sp_multiply_rows_for_qdistr 21562 21562 0 0.00 0 15780 146 0 0
sp_pay_from_customer 7333 7333 0 0.00 4 15586 120 0 0
sp_pay_to_supplier 6138 6138 0 0.00 4 13882 118 0 0
sp_payment_common 13470 13470 0 0.00 1 15579 28 0 0
sp_qd_handle_on_cancel_clo 1774 1774 0 0.00 0 15164 288 0 0
sp_qd_handle_on_invoice_upd_sts 11155 11155 0 0.00 0 21662 310 0 0
sp_qd_handle_on_reserve_upd_sts 10309 10309 0 0.00 0 13010 59 0 0
sp_reserve_write_off 10311 10311 0 0.00 6 13572 184 0 0
sp_supplier_invoice 5713 5713 0 0.00 6 95519 3272 0 0
sp_supplier_order 5756 5756 0 0.00 5 39117 1270 0 0
srv_aggregate_perf_data 104 104 0 0.00 2754 163055 19598 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1460 204745 32610 0 0
srv_find_qd_qs_mism 1111894 1111894 0 0.00 0 9865 5 0 0
srv_make_invnt_saldo 576 576 0 0.00 25 22317 955 0 0
srv_make_money_saldo 815 815 0 0.00 1 8528 43 0 0
srv_recalc_idx_stat 4 4 0 0.00 137471 292378 202043 0 0
t$perf-abend:sp_add_invoice_to_stock 138 138 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 6 6 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5195 5195 0 0.00 0 13919 150 0 0
t$perf-norm:sp_cancel_adding_invoice 423 423 0 0.00 0 2590 85 0 0
t$perf-norm:sp_cancel_client_order 1774 1774 0 0.00 0 6913 16 0 0
t$perf-norm:sp_cancel_customer_reserve 744 744 0 0.00 0 424 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 695 695 0 0.00 0 2020 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 439 439 0 0.00 0 1084 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 422 422 0 0.00 0 746 22 0 0
t$perf-norm:sp_cancel_supplier_order 446 446 0 0.00 0 20352 1593 0 0
t$perf-norm:sp_cancel_write_off 1063 1063 0 0.00 0 2339 8 0 0
t$perf-norm:sp_client_order 21562 21562 0 0.00 0 11915 18 0 0
t$perf-norm:sp_customer_reserve 1075 1075 0 0.00 0 3771 12 0 0
t$perf-norm:sp_pay_from_customer 7333 7333 0 0.00 0 3923 10 0 0
t$perf-norm:sp_pay_to_supplier 6138 6138 0 0.00 0 3578 10 0 0
t$perf-norm:sp_reserve_write_off 10311 10311 0 0.00 0 8961 13 0 0
t$perf-norm:sp_supplier_invoice 5713 5713 0 0.00 0 7926 17 0 0
t$perf-norm:sp_supplier_order 5756 5756 0 0.00 0 10292 18 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 233 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 4244 40 0 0
t$perf-norm:srv_make_invnt_saldo 576 576 0 0.00 0 3939 37 0 0
t$perf-norm:srv_make_money_saldo 815 815 0 0.00 0 7923 36 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10648 10372 276 2.59 0 10921 23 0 276
v_all_customers 39304 39304 0 0.00 0 201 1 0 0
v_all_suppliers 32202 32202 0 0.00 0 201 1 0 0
v_all_wares 43124 43124 0 0.00 0 213 1 0 0
v_cancel_adding_invoice 846 846 0 0.00 0 1707 8 0 0
v_cancel_client_order 3548 3548 0 0.00 0 8333 9 0 0
v_cancel_customer_prepayment 1390 1390 0 0.00 0 1898 7 0 0
v_cancel_customer_reserve 1488 1488 0 0.00 0 2833 7 0 0
v_cancel_payment_to_supplier 878 878 0 0.00 0 5650 17 0 0
v_cancel_supplier_invoice 856 844 12 1.40 0 8291 23 0 12
v_cancel_supplier_order 892 892 0 0.00 0 2574 8 0 0
v_cancel_write_off 2126 2126 0 0.00 0 5653 16 0 0
v_max_id_clo_ord 5756 5756 0 0.00 0 634 1 0 0
v_max_id_clo_res 1075 1075 0 0.00 0 1287 9 0 0
v_max_id_ord_sup 5692 5692 0 0.00 0 3587 3 0 0
v_max_non_paid_invoice 1485 1485 0 0.00 0 867 3 0 0
v_max_non_paid_realizn 3846 3846 0 0.00 0 582 3 0 0
v_min_id_clo_ord 5756 5756 0 0.00 0 2740 8 0 0
v_min_id_clo_res 1075 1075 0 0.00 0 10743 21 0 0
v_min_id_ord_sup 5692 5692 0 0.00 0 6337 8 0 0
v_min_non_paid_invoice 6138 6138 0 0.00 0 12377 18 0 0
v_min_non_paid_realizn 7332 7332 0 0.00 0 11571 19 0 0
v_our_firm 10792 10792 0 0.00 0 197 1 0 0
v_reserve_write_off 20618 20618 0 0.00 0 8369 12 0 0
x_lock_depdocs_on_canc_invoice 12189 12189 0 0.00 0 14598 119 0 0
x_lock_depdocs_on_canc_sup_ord 446 446 0 0.00 0 6169 326 0 0
x_make_qstorno_1000_1200 5756 5756 0 0.00 2 39111 1192 0 0
x_make_qstorno_1200_2000 5713 5713 0 0.00 3 92378 3151 0 0
x_make_qstorno_2100_3300 482986 482986 0 0.00 0 133275 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-06-2021 19:29:44 to 18-06-2021 19:29:48.

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
16:57:43 1 8192000000 8798422640 8808923136 5084736 0.062 1 1 2 0 5202784 55488 62560
16:57:50 15472 8192000000 10223904128 10528305152 768087072 8.572 62 48 98 0 786166672 2029856 16049744
16:58:13 18323 8192000000 10308676624 10620792832 1361981600 14.255 100 88 175 0 1394846480 4468288 28396592
16:58:44 22992 8192000000 10343294240 10659147776 1396512416 14.564 100 88 175 0 1431037648 6177824 28347408
16:59:15 20415 8192000000 10360654624 10681126912 1414879808 14.727 100 88 176 0 1450799344 7091136 28828400
16:59:55 19631 8192000000 10395659232 10720395264 1448991952 15.029 100 86 172 0 1484037712 7406112 27639648
17:00:25 20417 8192000000 10413273248 10744004608 1475013552 15.258 100 87 174 0 1511248160 8224192 28010416
17:01:00 12773 8192000000 10437122032 10768162816 1493305040 15.418 100 89 178 0 1530464208 8895136 28264032
17:01:26 21931 8192000000 10457251456 10793361408 1504652176 15.517 100 85 171 0 1541091408 9514464 26924768
17:01:59 16570 8192000000 10473107184 10814869504 1531466384 15.750 100 84 168 0 1567592992 10337392 25789216
17:02:23 20231 8192000000 10493147616 10843488256 1546361968 15.879 100 77 154 1 1580126848 10304352 23460528
17:02:52 12118 8192000000 10513714784 10870616064 1573226736 16.110 100 73 146 0 1605581936 10423056 21932144
17:03:13 11250 8192000000 10561900272 10917380096 1615768832 16.474 100 82 163 0 1652291824 11627328 24895664
17:03:37 8217 8192000000 10587946272 10948313088 1646020800 16.731 100 81 162 3 1681877280 12439504 23416976
17:03:51 12879 8192000000 10605464320 10970345472 1666493184 16.904 100 83 166 0 1703405024 12662432 24249408
17:04:12 8659 8192000000 10622534432 10991067136 1684081536 17.052 100 81 161 0 1720683856 13359664 23242656
17:04:29 8609 8192000000 10649727696 11015131136 1699759648 17.183 100 79 159 2 1735040656 12747248 22533760
17:04:45 8267 8192000000 10651124128 11026022400 1714746144 17.308 100 79 158 2 1749611648 11949632 22915872
17:05:00 6804 8192000000 10663770336 11038650368 1722977008 17.377 100 73 146 0 1756079040 12313136 20788896
17:05:16 5959 8192000000 10679021264 11056013312 1740251056 17.521 100 85 170 3 1776680848 12467504 23962288
17:05:29 5611 8192000000 10688583136 11065245696 1747050464 17.577 100 75 150 2 1781246304 12525888 21669952
17:05:41 5317 8192000000 10691424464 11072450560 1761366944 17.696 100 82 164 0 1797654096 12593504 23693648
17:05:55 4870 8192000000 10711651056 11094380544 1772384448 17.787 100 81 162 4 1807765376 12975488 22405440
17:06:07 4252 8192000000 10716619888 11101175808 1787083936 17.908 100 85 171 1 1824225264 13177840 23963488
17:06:18 4451 8192000000 10735114096 11117801472 1793920144 17.964 100 83 165 0 1830383744 14033360 22430240
17:06:30 8162 8192000000 10728394112 11114622976 1795909296 17.980 100 82 164 2 1832842672 14394672 22538704
17:06:44 3064 8192000000 10750138704 11133173760 1807693840 18.077 100 83 166 2 1844777952 13674208 23409904
17:06:54 4149 8192000000 10747770272 11131183104 1815126112 18.138 100 88 176 5 1852640528 13684816 23829600
17:07:06 2514 8192000000 10754367056 11144450048 1817675328 18.159 100 86 170 2 1855947408 13696464 24575616
17:07:15 3355 8192000000 10765806128 11150069760 1822291632 18.196 100 86 172 1 1860809456 13867280 24650544
17:07:24 2439 8192000000 10775284736 11159605248 1829251696 18.253 100 82 165 0 1866640064 14707424 22680944
17:07:33 2714 8192000000 10783674976 11166765056 1838383088 18.328 100 92 184 1 1878835328 14849984 25602256
17:07:42 1759 8192000000 10785504320 11166896128 1839739936 18.339 100 96 194 2 1881188000 14520800 26927264
17:07:51 2773 8192000000 10783394400 11172806656 1840427808 18.344 100 86 173 1 1878533824 13549120 24556896
17:08:00 1867 8192000000 10781640752 11172839424 1846173472 18.391 100 88 175 2 1884121008 12853840 25093696
17:08:08 2698 8192000000 10798382352 11190452224 1850894192 18.429 100 86 171 1 1889598096 15852816 22851088
17:08:17 1667 8192000000 10798858832 11185528832 1859816016 18.502 100 90 179 1 1896869776 12198928 24854832
17:08:25 2055 8192000000 10811018592 11197251584 1861989968 18.519 100 91 182 1 1900929888 13056272 25883648
17:08:33 1858 8192000000 10815376448 11199877120 1868817824 18.575 100 95 185 1 1907573632 13319984 25435824
17:08:42 1757 8192000000 10808993664 11204288512 1869121312 18.577 100 95 191 5 1910301232 13572960 27606960
17:08:50 1992 8192000000 10814513664 11205013504 1869463904 18.580 100 91 183 0 1908194816 13864160 24866752
17:08:59 1458 8192000000 10819039536 11206955008 1875717424 18.631 100 87 175 0 1913125984 13033248 24375312
17:09:07 2377 8192000000 10818983440 11211698176 1877208336 18.643 100 88 175 1 1914958640 13237504 24512800
17:09:16 35422 8192000000 10812432128 11214966784 1873492656 18.613 100 64 129 0 1902940208 11188400 18259152
17:09:58 2021 8192000000 10819718800 11219644416 1883698224 18.695 100 81 161 0 1917095712 9924224 23473264
17:10:07 4617 8192000000 10816653312 11217215488 1880962256 18.673 100 76 152 2 1913521024 10409008 22149760
17:10:19 7007 8192000000 10799372544 11212910592 1876996288 18.641 100 47 95 0 1900839616 10504880 13338448
17:10:33 4120 8192000000 10802182832 11216470016 1877736560 18.647 100 42 84 0 1902391040 12893184 11761296
17:10:43 4737 8192000000 10800325952 11216465920 1879450848 18.661 100 45 91 1 1901270400 9191712 12627840
17:10:55 3630 8192000000 10794376048 11217588224 1882039888 18.682 100 45 90 1 1903821136 9423616 12357632
17:11:05 6178 8192000000 10802804976 11224555520 1884845616 18.704 100 41 83 2 1907248416 10724256 11678544
17:11:18 3687 8192000000 10796298448 11219283968 1886034592 18.714 100 39 79 1 1904567952 7332496 11200864
17:11:32 3383 8192000000 10815316640 11227111424 1892228576 18.764 100 49 98 0 1912838688 6981328 13628784
17:11:44 7089 8192000000 10800568880 11228217344 1889033984 18.738 100 29 60 1 1904345424 6816320 8495120
17:11:58 4720 8192000000 10799075232 11227910144 1893311728 18.772 100 33 67 1 1909988720 7086160 9590832
17:12:10 3967 8192000000 10813246720 11234361344 1895881248 18.793 100 35 70 3 1912532560 5825696 10825616
17:12:21 9588 8192000000 10808396160 11236589568 1895195152 18.788 100 24 46 2 1911751072 10302640 6253280
17:12:40 11415 8192000000 10803734592 11234893824 1903897344 18.858 100 22 44 2 1916535840 6473440 6165056
17:12:57 10173 8192000000 10807581296 11242643456 1902962160 18.850 100 25 50 0 1920852064 10638304 7251600
17:13:19 10885 8192000000 10823562640 11249680384 1906597920 18.879 100 22 44 3 1918506304 5489648 6418736
17:13:37 10174 8192000000 10809410192 11245821952 1909430624 18.902 100 23 46 1 1922449840 7003648 6015568
17:13:54 8204 8192000000 10835485104 11258880000 1912630624 18.928 100 31 62 2 1928383216 5885024 9867568
17:14:08 7234 8192000000 10831257280 11267379200 1920804864 18.993 100 41 83 2 1940418704 7089376 12524464
17:14:57 26238 8192000000 10862477952 11279642624 1930469936 19.071 100 68 137 2 1955944320 6179136 19295248
17:15:30 1360 8192000000 10888858736 11289751552 1936073824 19.115 100 96 192 4 1975564496 11189008 28301664
17:15:40 3717 8192000000 10855804976 11273400320 1921598240 19.000 100 52 104 1 1946484496 9565200 15321056
17:15:49 5110 8192000000 10828645280 11267657728 1918231408 18.973 100 32 64 1 1934481360 7284272 8965680
17:16:01 3673 8192000000 10851854992 11272130560 1923236208 19.013 100 41 83 2 1942509648 7248976 12024464
17:16:11 5246 8192000000 10850212272 11280424960 1925972208 19.035 100 40 78 1 1950071216 13421872 10677136
17:16:23 7699 8192000000 10848793872 11275501568 1907803680 18.889 99 33 64 0 1923097216 5089488 10204048
17:16:38 5941 8192000000 10832359440 11265863680 1911732384 18.921 100 29 57 0 1930911856 11082912 8096560
17:16:52 16255 8192000000 10822602816 11255095296 1905103952 18.867 100 20 40 3 1916780112 5987136 5689024
17:17:16 40624 8192000000 10791792528 11208376320 1850012768 18.422 97 38 74 3 1866152976 4703872 11436336
17:18:04 14179 8192000000 10784443296 11218788352 1847271696 18.400 98 26 52 0 1861006544 6203552 7531296
17:18:26 5803 8192000000 10794426160 11227348992 1858431008 18.491 98 34 67 2 1873422656 6353552 8638096
17:18:39 5969 8192000000 10776866288 11209900032 1852248352 18.440 99 37 76 2 1869565856 5825664 11491840
17:18:53 4410 8192000000 10786962656 11209158656 1839334736 18.335 98 37 72 2 1861098960 11529600 10234624
17:19:06 4100 8192000000 10777196656 11194580992 1828104032 18.244 98 28 55 3 1842514480 5127728 9282720
17:19:20 5867 8192000000 10701226192 11110445056 1695063952 17.144 92 23 47 1 1706998608 4703056 7231600
17:19:34 3144 8192000000 10737006560 11145891840 1794690752 17.970 99 44 89 0 1813395952 5588688 13116512
17:19:45 5479 8192000000 10726237184 11151945728 1813404288 18.124 100 34 68 0 1829868976 5358400 11106288
17:19:57 7779 8192000000 10708671552 11126374400 1763395552 17.712 97 20 40 1 1774600736 5635184 5570000
17:20:14 7166 8192000000 10730942112 11152601088 1800650416 18.019 99 22 45 0 1812927008 6055920 6220672
17:20:31 12136 8192000000 10704717984 11116720128 1719652384 17.349 95 22 45 1 1731037152 4966256 6418512
17:20:51 6802 8192000000 10685879808 11093229568 1720818096 17.359 97 29 58 1 1735350400 5807328 8724976
17:21:10 8480 8192000000 10708463872 11130228736 1794811264 17.971 100 30 60 4 1809832944 5534704 9486976
17:21:28 12463 8192000000 10699645312 11103936512 1748119136 17.586 97 35 68 2 1764706784 5842416 10745232
17:21:48 68070 8192000000 10729869792 11148980224 1754534832 17.639 96 49 99 4 1773993840 4790240 14668768
17:23:07 8358 8192000000 10735330464 11160694784 1805588880 18.060 99 31 62 0 1820755008 6790752 8375376
17:23:22 5023 8192000000 10742451504 11164008448 1827280336 18.237 100 36 72 2 1844958432 7786112 9891984
17:23:33 7075 8192000000 10770391696 11179331584 1842525248 18.361 100 43 87 5 1861272080 7201008 11545824
17:23:47 10892 8192000000 10766027888 11183919104 1824659296 18.216 99 35 70 0 1840310592 5815040 9836256
17:24:04 8723 8192000000 10754670848 11181289472 1843527520 18.370 100 35 68 2 1858306992 5006800 9772672
17:24:20 12738 8192000000 10757640496 11188822016 1847617440 18.403 100 18 36 1 1858206416 5041392 5547584
17:24:39 12948 8192000000 10773805584 11200274432 1851602176 18.435 100 22 45 1 1863804320 5452112 6750032
17:24:58 6932 8192000000 10774048048 11202310144 1857936912 18.487 100 21 42 1 1873983504 10323152 5723440
17:25:11 14120 8192000000 10785823280 11210784768 1863617008 18.533 100 22 44 3 1876446080 5977360 6851712
17:25:36 3636 8192000000 10786883920 11210452992 1866419472 18.555 100 28 56 1 1880949520 6550560 7979488
17:25:47 8467 8192000000 10781904592 11212390400 1866030800 18.552 100 12 24 0 1874685392 5589248 3065344
17:26:02 11093 8192000000 10783606592 11217494016 1868627904 18.573 100 20 40 0 1884274096 9940848 5705344
17:26:19 10606 8192000000 10780852928 11214397440 1868689712 18.574 100 13 24 0 1877959600 5245760 4024128
17:26:36 49162 8192000000 10795667888 11217793024 1872774048 18.607 100 18 34 2 1883346864 4848352 5724464
17:27:49 35927 8192000000 10839320160 11261575168 1911311824 18.917 100 42 82 2 1929201024 6737136 11152064
17:28:35 5017 8192000000 10855876464 11272462336 1920879136 18.994 100 58 116 2 1946253200 9373664 16000400
17:28:49 16234 8192000000 10864219808 11286376448 1927532512 19.047 100 53 104 0 1952474960 9704832 15237616
17:29:17 8976 8192000000 10856835280 11288731648 1932553472 19.087 100 48 93 0 1954223488 8854288 12815728
17:29:40 31994 8192000000 10881929552 11309174784 1943211840 19.172 100 50 100 2 1966531488 8736352 14583296
17:30:19 4786 8192000000 10881293456 11311841280 1950847088 19.233 100 57 114 3 1977527136 10347328 16332720
17:30:37 25328 8192000000 10882266240 11316449280 1955697216 19.272 100 48 96 0 1980149344 10690288 13761840
17:31:14 31484 8192000000 10900853328 11331973120 1962041712 19.322 100 38 76 0 1985860032 12776736 11041584
17:32:05 22114 8192000000 10893234224 11330412544 1929183904 19.060 98 31 60 4 1950332336 12671440 8476992
17:32:34 37484 8192000000 10895441264 11341971456 1964409856 19.341 100 29 58 0 1987033152 13386176 9237120
17:33:23 49363 8192000000 10911228352 11352612864 1978073120 19.449 100 38 76 1 2009394208 19218032 12103056
17:34:44 10533 8192000000 10928231728 11361943552 1984803312 19.503 100 42 84 1 2017904304 20548448 12552544
17:35:02 8911 8192000000 10933407136 11367038976 1984502528 19.500 100 53 106 1 2023462288 21757232 17202528
17:35:18 9878 8192000000 10934196528 11368501248 1988115024 19.529 100 54 105 1 2024781376 20917216 15749136
17:35:39 10564 8192000000 10943817920 11383689216 1991702384 19.557 100 54 107 4 2032639248 24643312 16293552
17:35:57 13191 8192000000 10939786960 11381018624 1997875552 19.606 100 52 104 2 2035964480 22674752 15414176
17:36:19 26631 8192000000 10947899600 11388637184 1999584384 19.619 100 48 96 0 2039224464 25625968 14014112
17:36:56 10264 8192000000 10944903024 11383869440 1994914656 19.583 100 44 87 0 2033645712 25594112 13136944
17:37:16 7632 8192000000 10955220400 11392540672 2000317696 19.625 100 53 106 0 2042318256 26449760 15550800
17:37:30 8611 8192000000 10958352704 11393609728 2006751968 19.676 100 58 115 2 2050008128 26188240 17067920
17:37:46 3023 8192000000 10964116240 11393605632 2003316400 19.649 100 62 124 1 2048362480 26803504 18242576
17:37:59 8921 8192000000 10967769040 11397476352 2004810448 19.661 100 69 137 2 2050617520 25964816 19842256
17:38:26 8591 8192000000 10943275952 11380486144 1985239520 19.506 99 49 98 1 2028133248 27946432 14947296
17:38:43 13201 8192000000 10967469696 11398635520 2007516608 19.682 100 61 120 3 2054742640 28865280 18360752
17:39:07 3769 8192000000 10974404208 11407572992 2010175296 19.703 100 63 127 2 2064507920 35027056 19305568
17:39:19 1807 8192000000 10998706032 11417387008 2019819456 19.779 100 73 144 0 2075569136 34942448 20807232
17:39:27 7117 8192000000 10976284944 11409293312 2010527408 19.706 100 66 132 0 2067681696 36928144 20226144
17:39:43 3649 8192000000 10989093280 11415654400 2016784336 19.755 100 65 128 2 2070595472 33839920 19971216
17:39:55 12803 8192000000 10981021664 11415842816 2018629264 19.769 100 64 126 0 2070758032 32962560 19166208
17:40:14 3832 8192000000 10967942912 11392167936 1993111408 19.568 99 76 152 2 2049971200 33408576 23451216
17:40:25 4639 8192000000 10976402640 11407572992 2013359600 19.728 100 73 144 1 2071130192 34779376 22991216
17:40:38 2361 8192000000 10977326224 11395420160 1993998864 19.575 99 70 140 1 2051984752 36235872 21750016
17:40:47 3289 8192000000 10982929840 11411468288 2012164128 19.719 100 74 148 1 2072858336 37639552 23054656
17:41:00 4986 8192000000 10963182032 11385470976 1977109440 19.442 98 72 139 1 2033287632 35107328 21070864
17:41:27 2670 8192000000 10980672832 11405086720 2005783296 19.668 100 66 131 1 2062270256 36858864 19628096
17:41:38 8028 8192000000 10963759408 11390451712 1970067024 19.386 98 66 131 2 2027811760 37437600 20307136
17:41:53 2714 8192000000 10973149104 11408076800 2002423232 19.642 100 66 131 0 2064616480 42068288 20124960
17:42:03 2211 8192000000 11004740240 11426242560 2018275776 19.767 100 93 183 1 2088003856 41818480 27909600
17:42:14 1458 8192000000 11011063440 11430760448 2000302944 19.625 99 78 156 0 2068486416 43651840 24531632
17:42:22 2466 8192000000 10985925840 11402735616 1984330192 19.499 99 83 166 2 2055284720 45060864 25893664
17:42:32 2424 8192000000 10963206448 11386445824 1966317376 19.356 99 81 158 0 2036100560 44696416 25086768
17:42:43 2057 8192000000 10967407136 11383222272 1979844256 19.463 100 80 159 2 2049866784 45110624 24911904
17:42:54 4113 8192000000 10972113440 11384745984 1979146544 19.458 100 81 162 1 2051343408 46191792 26005072
17:43:05 2754 8192000000 10973623072 11391365120 1985423792 19.508 100 73 145 0 2053088464 45201120 22463552
17:43:17 2422 8192000000 10957411440 11374514176 1962890960 19.329 99 78 154 0 2032773040 46001360 23880720
17:43:27 2874 8192000000 10967475088 11384557568 1978283264 19.451 100 73 143 0 2046652224 46307328 22061632
17:43:37 1973 8192000000 10981581584 11395166208 1986614832 19.517 100 88 176 1 2061371408 47878960 26877616
17:43:47 1916 8192000000 10965970864 11374641152 1964450048 19.341 99 87 173 0 2040206816 48708688 27048080
17:43:56 1637 8192000000 10976520144 11386925056 1978481136 19.453 100 89 178 3 2056146288 50453648 27211504
17:44:04 2605 8192000000 10944462080 11358355456 1946361904 19.197 99 85 168 0 2022247120 49829280 26055936
17:44:13 4444 8192000000 10967240784 11386032128 1975489552 19.429 100 85 170 2 2053292608 51858656 25944400
17:44:28 6814 8192000000 10958171520 11375394816 1969053440 19.378 100 78 157 2 2038660192 46014976 23591776
17:44:42 1608 8192000000 10971034736 11380809728 1971885616 19.400 100 93 183 0 2051405536 50402768 29117152
17:44:50 1933 8192000000 10963111152 11378335744 1968681856 19.375 100 84 168 0 2045363584 50856000 25825728
17:44:59 4065 8192000000 10964909568 11377397760 1967706320 19.367 100 79 158 1 2043572656 51324560 24541776
17:45:12 2986 8192000000 10961791920 11377815552 1958150160 19.291 99 78 156 0 2033673216 51157088 24365968
17:45:25 1521 8192000000 10974816912 11393085440 1980129984 19.466 100 81 163 1 2058186624 52955376 25101264
17:45:35 3250 8192000000 10970887936 11385647104 1976808512 19.439 100 94 188 1 2060054896 53749488 29496896
17:45:45 3455 8192000000 10970283184 11384897536 1969749760 19.383 100 74 147 3 2044679872 51832496 23097616
17:45:56 3945 8192000000 10951401760 11374678016 1946128208 19.196 99 61 122 1 2018472736 52739312 19605216
17:46:13 1692 8192000000 10959124816 11381448704 1966883200 19.361 100 69 135 2 2042316608 53700544 21732864
17:46:22 2332 8192000000 10990750912 11404615680 1990131760 19.545 100 90 179 0 2075016112 56809040 28075312
17:46:32 2086 8192000000 10980845456 11410092032 1988497568 19.532 100 66 132 1 2067939888 58772624 20669696
17:46:48 10415 8192000000 10969189088 11410038784 1986631776 19.517 100 44 85 2 2059341136 57916544 14792816
17:47:21 14370 8192000000 10945802560 11396276224 1944916464 19.186 98 38 76 1 2016752272 58697120 13138688
17:47:42 4963 8192000000 10949728368 11387641856 1966186720 19.355 100 50 98 0 2037256416 54311344 16758352
17:47:54 7472 8192000000 10959756848 11387805696 1964780192 19.344 100 54 108 1 2041854032 60001728 17072112
17:48:10 10802 8192000000 10943639264 11388903424 1951301552 19.237 99 44 88 0 2022689440 55833472 15554416
17:48:33 11110 8192000000 10956167888 11397562368 1971922096 19.401 100 41 81 2 2041912096 55787632 14202368
17:48:51 3168 8192000000 10969521968 11403100160 1978807840 19.455 100 57 107 1 2053299392 56514912 17976640
17:49:01 4759 8192000000 10983913888 11415547904 1983210944 19.490 100 51 102 0 2057741424 57614304 16916176
17:49:13 7892 8192000000 10959094720 11392827392 1939174416 19.140 98 53 106 1 2011165856 55306144 16685296
17:49:27 11392 8192000000 10943402080 11398852608 1964687456 19.343 100 38 76 1 2034279808 56373520 13218832
17:49:52 18596 8192000000 10938911104 11382751232 1946495888 19.199 99 36 72 1 2012538752 52942720 13100144
17:50:29 7688 8192000000 10922749808 11371982848 1941082240 19.155 100 31 62 1 2009168960 57160480 10926240
17:50:54 2516 8192000000 10962002000 11386982400 1958261344 19.292 100 56 107 3 2035417888 59195056 17961488
17:51:03 1627 8192000000 10973681440 11395153920 1968340656 19.372 100 78 155 1 2052204784 58862816 25001312
17:51:16 6499 8192000000 10966242000 11403313152 1967442656 19.365 100 48 96 1 2046445696 62746320 16256720
17:51:32 16312 8192000000 10957601280 11413368832 1973228640 19.411 100 35 70 1 2041831184 56615152 11987392
17:52:00 37007 8192000000 10938126656 11394363392 1972938496 19.409 100 28 56 1 2037891456 55013488 9939472
17:53:17 38810 8192000000 10930824240 11387994112 1973035264 19.410 100 27 53 1 2021530864 40087088 8408512
17:54:14 29043 8192000000 10919847936 11385528320 1961924320 19.321 100 11 22 0 1996958896 30768544 4266032
17:54:50 18566 8192000000 10905730144 11362279424 1945949696 19.194 99 15 30 0 1981878672 30266288 5662688
17:55:17 34335 8192000000 10886220480 11360993280 1941193936 19.156 99 12 23 1 1966849344 21753904 3901504
17:55:58 84236 8192000000 10904482816 11352514560 1865895968 18.551 95 27 54 0 1887708768 14097328 7715472
17:57:31 20711 8192000000 10874239104 11324993536 1922247808 19.005 99 32 61 1 1941490512 10849328 8393376
17:58:08 78535 8192000000 10888060160 11342159872 1923293968 19.013 99 12 23 1 1940483616 14318112 2871536
17:59:33 204745 8192000000 10880571056 11345989632 1755432528 17.647 90 9 18 2 1770490800 13137248 1921024
18:03:04 24315 8192000000 10914067056 11348504576 1961884624 19.321 100 39 80 1 1979074544 6754064 10435856
18:03:35 6979 8192000000 10894587504 11344691200 1959612192 19.303 100 34 68 0 1976945136 8174288 9158656
18:03:58 52864 8192000000 10914295248 11377704960 1967343184 19.364 100 12 24 0 1989336144 19107056 2885904
18:05:49 100559 8192000000 10921148112 11368144896 1957125200 19.283 99 46 93 2 1980667696 10231616 13310880
18:07:37 49295 8192000000 10898396464 11356057600 1935072848 19.107 98 40 80 2 1957784192 11387008 11324336
18:08:33 66980 8192000000 10885799504 11355787264 1953121504 19.251 99 18 36 0 1967756320 9606656 5028160
18:10:19 45875 8192000000 10917023712 11373686784 1948395200 19.214 98 36 72 2 1967879856 9154032 10330624
18:11:15 13563 8192000000 10912773376 11373121536 1973871072 19.416 99 29 57 1 1991178656 9100656 8206928
18:11:38 14707 8192000000 10933565472 11384610816 1992382752 19.563 100 39 78 3 2014892880 10684432 11825696
18:12:16 57951 8192000000 10931960128 11403927552 2000795680 19.629 100 35 70 1 2024282144 13268624 10217840
18:13:39 19112 8192000000 10928296992 11402612736 1998355696 19.610 100 29 58 0 2022442960 15459808 8627456
18:14:07 6698 8192000000 10934980704 11404980224 1994469936 19.579 100 23 46 1 2020654400 19163712 7020752
18:14:21 168948 8192000000 10931269760 11407712256 1960585568 19.311 98 18 36 0 1986420864 20477648 5357648
18:17:20 63207 8192000000 10936732720 11397341184 1980808912 19.471 99 12 24 0 2001512416 16728464 3975040
18:19:33 69684 8192000000 10918023840 11407835136 1998150176 19.608 100 16 32 1 2015937024 12079504 5707344
18:20:58 80003 8192000000 10924381376 11418857472 2002485200 19.642 100 14 28 0 2024966016 18036608 4444208
18:22:31 41722 8192000000 10944451264 11409240064 1983667264 19.494 99 26 50 2 1999802464 9539248 6595952
18:23:23 18761 8192000000 10948297824 11408908288 1990948192 19.551 99 51 102 0 2016530384 11436192 14146000
18:23:48 40932 8192000000 10925857744 11418447872 2006583440 19.675 100 44 88 1 2033778784 14009376 13185968
18:24:37 56096 8192000000 10919893488 11407966208 1978731104 19.455 99 15 30 0 1996478240 13216864 4530272
18:25:42 83729 8192000000 10857071632 11321577472 1813986560 18.129 91 12 24 0 1832593744 15584400 3022784
18:27:15 48684 8192000000 10889569920 11325992960 1872299888 18.603 96 31 57 3 1888285088 7760400 8224800
18:28:10 20244 8192000000 10884515680 11331235840 1889656304 18.743 97 31 62 0 1905549936 7658592 8235040
18:28:43 56655 8192000000 10894010256 11350102016 1912540848 18.927 98 40 80 0 1935590320 12091952 10957520
18:29:50 98383 8192000000 10885329120 11359313920 1884882112 18.705 96 15 30 0 1911621664 22703744 4035808
18:31:35 61584 8192000000 10876215840 11345813504 1872591376 18.605 96 9 18 1 1889891536 14013392 3286768
18:32:42 69741 8192000000 10862331824 11320279040 1851020944 18.430 95 16 32 2 1867891264 12569856 4300464
18:33:59 55826 8192000000 10836707376 11304488960 1843263712 18.367 96 23 46 1 1864445696 14462064 6719920
18:35:05 104569 8192000000 10839973088 11312648192 1901204960 18.836 99 28 56 2 1929255232 18973728 9076544
18:37:19 59730 8192000000 10856035424 11333902336 1907041616 18.883 99 11 23 0 1922283760 11870528 3371616
18:38:37 67084 8192000000 10844615104 11325505536 1914492848 18.943 99 17 32 1 1928399328 9025792 4880688
18:41:23 79255 8192000000 10872436656 11346866176 1947966592 19.210 100 15 30 0 1962748256 10690400 4091264
18:43:29 42139 8192000000 10857224960 11340046336 1922287936 19.005 99 10 20 0 1939517328 14353152 2876240
18:44:52 58978 8192000000 10857632912 11324383232 1906451120 18.878 98 18 36 1 1923808688 12358496 4999072
18:46:03 34917 8192000000 10877106480 11341942784 1929320128 19.061 99 19 37 0 1948000128 13352176 5327824
18:46:45 82022 8192000000 10883882464 11359666176 1917947440 18.970 98 15 30 1 1936308144 13483232 4877472
18:48:13 64185 8192000000 10876977456 11359289344 1911353872 18.918 98 10 20 0 1935629456 21521808 2753776
18:49:24 66920 8192000000 10869341968 11361378304 1909236528 18.901 98 16 32 1 1941312528 26610512 5465488
18:50:38 52028 8192000000 10866789520 11333451776 1864868176 18.543 96 16 32 1 1886893584 17149632 4875776
18:51:36 48922 8192000000 10885047440 11344035840 1905655168 18.872 98 32 64 1 1930830064 16183728 8991168
18:52:35 79038 8192000000 10873592624 11351773184 1921200800 18.996 99 14 28 0 1942530080 17329872 3999408
18:54:16 48553 8192000000 10879318432 11358093312 1929465360 19.063 99 18 36 0 1947019360 12570048 4983952
18:55:23 47029 8192000000 10879696240 11340865536 1931091664 19.076 99 16 31 3 1943245488 7742208 4411616
18:56:16 28291 8192000000 10869851120 11316346880 1910053088 18.907 98 31 62 1 1930905392 12327488 8524816
18:56:59 51494 8192000000 10898735568 11354906624 1936169888 19.116 99 45 91 1 1959806640 11477920 12158832
18:57:57 15274 8192000000 10913089056 11360866304 1966065616 19.354 100 42 84 0 1986607952 8893840 11648496
18:58:20 20217 8192000000 10915802768 11366449152 1970368704 19.388 100 44 88 0 1996892576 14768384 11755488
18:58:47 17394 8192000000 10919081856 11364941824 1956051040 19.275 99 43 86 0 1978429024 10946704 11431280
18:59:11 30750 8192000000 10890571856 11374731264 1949142832 19.220 99 32 64 0 1976364016 18697248 8523936
18:59:49 110091 8192000000 10884964912 11345354752 1803041792 18.039 92 8 16 1 1815682624 10489280 2151552
19:01:46 101671 8192000000 10886300832 11350089728 1954752896 19.264 100 24 48 1 1976756560 15039424 6964240
19:03:36 104459 8192000000 10900249824 11384795136 1973540064 19.414 100 21 42 0 1997412832 18522400 5350368
19:05:27 14269 8192000000 10917563920 11391336448 1983928480 19.496 100 17 33 3 2006273456 17882064 4462912
19:05:54 39629 8192000000 10920846560 11391881216 1989423856 19.539 100 38 77 1 2009686880 9773568 10489456
19:06:40 81321 8192000000 10913323968 11397754880 1990667296 19.549 100 16 32 0 2004441792 9064704 4709792
19:08:07 73461 8192000000 10904016640 11393114112 1979420288 19.460 99 9 18 0 1992539312 10440256 2678768
19:09:45 63526 8192000000 10915288144 11401994240 1991772080 19.558 100 11 22 0 2004573040 9818832 2982128
19:11:19 43594 8192000000 10894855808 11379609600 1929376944 19.062 97 16 32 1 1944078832 9964176 4737712
19:12:20 32800 8192000000 10906813424 11380805632 1968507552 19.374 99 32 64 4 1985677280 7724256 9445472
19:12:59 54491 8192000000 10903128144 11376648192 1920977328 18.995 97 18 36 2 1934601872 8875600 4748944
19:14:00 45870 8192000000 10896570896 11371798528 1959753824 19.304 99 19 38 1 1974579280 9691568 5133888
19:14:52 51101 8192000000 10860522112 11323981824 1833539408 18.288 93 20 40 0 1846568048 7133408 5895232
19:15:52 23101 8192000000 10890128496 11354599424 1954972464 19.266 100 35 70 0 1974229360 9945888 9311008
19:16:28 26965 8192000000 10847587872 11318841344 1872528000 18.605 96 24 48 2 1891707792 11669424 7510368
19:17:04 57990 8192000000 10862044992 11334524928 1894774896 18.784 98 19 38 1 1908864336 8996608 5092832
19:18:13 34771 8192000000 10807695888 11269857280 1795519264 17.977 94 19 38 1 1813414176 12450816 5444096
19:18:59 43112 8192000000 10862792080 11317141504 1885551056 18.710 99 33 66 1 1907858880 13235424 9072400
19:19:49 65091 8192000000 10856084704 11327590400 1883996480 18.697 98 26 52 2 1905180816 14216912 6967424
19:21:02 120598 8192000000 10855063600 11324780544 1819113024 18.170 94 15 30 1 1838126896 14908128 4105744
19:23:11 70565 8192000000 10875717536 11359059968 1891494032 18.758 98 22 44 0 1914251344 16710480 6046832
19:25:45 107523 8192000000 10853149632 11330318336 1888041376 18.730 98 16 32 1 1911731552 19210736 4479440

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 18-06-2021 19:29:50 to 18-06-2021 19:30:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 138 v_add_invoice_to_stock 335544517
except 6 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-06-2021 19:30:22 to 18-06-2021 19:30:24.

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          244239
MON$OLDEST_ACTIVE               245323
MON$OLDEST_SNAPSHOT             245323
MON$NEXT_TRANSACTION            245323
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                       2051680
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.33475 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33475 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33475 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33475 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 ---
:19: 
:20: mscs-test-161.budzdorov.ru    Fri Jun 18 19:27:44 2021
:21:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:22: 
:23: 
:24: mscs-test-161.budzdorov.ru    Fri Jun 18 19:27:55 2021
:25:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:26: 
:27: 
:28: mscs-test-161.budzdorov.ru    Fri Jun 18 19:27:55 2021
:29:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:30: 
:31: 
:32: mscs-test-161.budzdorov.ru    Fri Jun 18 19:27:55 2021
:33:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:34: 
:35: 
:36: mscs-test-161.budzdorov.ru    Fri Jun 18 19:27:55 2021
:37:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:38: 
--- end of diff output ---

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

18.06.21 19:30:25. 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-06-18 19:30:27 No severe PSQL-related problems occured
18.06.21 19:30:29. End of report.