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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-11 22:26:59
DTS_END                         2020-11-11 22:26:59.3860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(134:18) ==> SP_CANCEL_SUPPLIER_INVOICE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34476
TRN_ID                          237054
ATT_ID                          695
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: 9001.95 23724 1080234
customer order: creation 171.73 363 20608
customer order: refuse 14.00 370 1680
order to supplier: creation 44.41 1180 5329
order to supplier: removal 3.34 90455 401
invoice (draft): creation 45.89 3490 5507
invoice (draft): removal 50.88 720 6105
invoice accept: apply 41.34 17156 4961
invoice accept: cancel 45.31 881 5437
customer reserve: creation 3820.28 168 458433
customer reserve: removal 4477.96 53 537355
realization accept: apply 82.21 203 9865
realization accept: cancel 78.69 112 9443
payment from customer: creation 56.87 127 6824
payment from customer: removal 5.38 84 646
payment to supplier: creation 48.31 144 5797
payment to supplier: removal 3.28 109 393
service: total inventory turnovers 4.93 1127 591
service: total monetary turnovers 6.38 28 765
service: aggregate perf. data 0.75 21057 90
service: refresh index statistics 0.03 336652 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-11-2020 22:28:33 to 11-11-2020 22:28:35.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1689
TEST_TIME 2 2591
TEST_TIME 3 2848
TEST_TIME 4 3475
TEST_TIME 5 3568
TEST_TIME 6 3721
TEST_TIME 7 3723
TEST_TIME 8 3782
TEST_TIME 9 4488
TEST_TIME 10 4859
TEST_TIME 11 5012
TEST_TIME 12 5455
TEST_TIME 13 5798
TEST_TIME 14 6236
TEST_TIME 15 6512
TEST_TIME 16 7102
TEST_TIME 17 7577
TEST_TIME 18 7991
TEST_TIME 19 8287
TEST_TIME 20 8279
TEST_TIME 21 8869
TEST_TIME 22 8945
TEST_TIME 23 9118
TEST_TIME 24 9328
TEST_TIME 25 9578
TEST_TIME 26 9441
TEST_TIME 27 9725
TEST_TIME 28 10168
TEST_TIME 29 9947
TEST_TIME 30 10060
TEST_TIME 31 9881
TEST_TIME 32 9736
TEST_TIME 33 9555
TEST_TIME 34 9812
TEST_TIME 35 9721
TEST_TIME 36 9609
TEST_TIME 37 9489
TEST_TIME 38 9385
TEST_TIME 39 9341
TEST_TIME 40 9448
TEST_TIME 41 9295
TEST_TIME 42 9159
TEST_TIME 43 9416
TEST_TIME 44 9314
TEST_TIME 45 9232
TEST_TIME 46 9074
TEST_TIME 47 9195
TEST_TIME 48 9089
TEST_TIME 49 8986
TEST_TIME 50 9144
TEST_TIME 51 9152
TEST_TIME 52 9160
TEST_TIME 53 9184
TEST_TIME 54 9218
TEST_TIME 55 9196
TEST_TIME 56 9168
TEST_TIME 57 9162
TEST_TIME 58 9250
TEST_TIME 59 9234
TEST_TIME 60 9251
TEST_TIME 61 9243
TEST_TIME 62 9308
TEST_TIME 63 9262
TEST_TIME 64 9152
TEST_TIME 65 9090
TEST_TIME 66 9109
TEST_TIME 67 9126
TEST_TIME 68 9097
TEST_TIME 69 9028
TEST_TIME 70 9013
TEST_TIME 71 9101
TEST_TIME 72 9106
TEST_TIME 73 9116
TEST_TIME 74 9130
TEST_TIME 75 9116
TEST_TIME 76 9071
TEST_TIME 77 9076
TEST_TIME 78 9104
TEST_TIME 79 9188
TEST_TIME 80 9175
TEST_TIME 81 9159
TEST_TIME 82 9225
TEST_TIME 83 9251
TEST_TIME 84 9283
TEST_TIME 85 9188
TEST_TIME 86 9132
TEST_TIME 87 9073
TEST_TIME 88 9056
TEST_TIME 89 9018
TEST_TIME 90 9054
TEST_TIME 91 9042
TEST_TIME 92 9011
TEST_TIME 93 8949
TEST_TIME 94 8967
TEST_TIME 95 8969
TEST_TIME 96 8979
TEST_TIME 97 9019
TEST_TIME 98 9013
TEST_TIME 99 9058
TEST_TIME 100 9039
TEST_TIME 101 9072
TEST_TIME 102 9038
TEST_TIME 103 9070
TEST_TIME 104 9156
TEST_TIME 105 9172
TEST_TIME 106 9150
TEST_TIME 107 9193
TEST_TIME 108 9231
TEST_TIME 109 9192
TEST_TIME 110 9118
TEST_TIME 111 9102
TEST_TIME 112 9067
TEST_TIME 113 9083
TEST_TIME 114 9029
TEST_TIME 115 9030
TEST_TIME 116 8984
TEST_TIME 117 8985
TEST_TIME 118 9014
TEST_TIME 119 9006
TEST_TIME 120 9002
TEST_TIME 121 8928

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-11-2020 22:28:37 to 11-11-2020 22:28:40.

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 1503884 1503884 0 0.00 0 18584 6 0 0
doc_list_biud 1503884 1503884 0 0.00 0 54795 25 0 0
sp_add_invoice_to_stock 5042 4961 81 1.60 38 173330 17157 0 81
sp_cancel_adding_invoice 5437 5437 0 0.00 5 65116 881 0 0
sp_cancel_client_order 1680 1680 0 0.00 4 11604 370 0 0
sp_cancel_customer_reserve 537355 537355 0 0.00 1 46715 53 0 0
sp_cancel_pay_from_customer 646 646 0 0.00 3 4099 84 0 0
sp_cancel_pay_to_supplier 393 393 0 0.00 3 18594 109 0 0
sp_cancel_supplier_invoice 6109 6105 4 0.06 1 24913 721 0 4
sp_cancel_supplier_order 401 401 0 0.00 11 897416 90456 0 0
sp_cancel_write_off 9443 9443 0 0.00 1 26185 113 0 0
sp_client_order 20608 20608 0 0.00 3 24053 364 0 0
sp_customer_reserve 458433 458433 0 0.00 0 46754 169 0 0
sp_fill_shopping_cart 31425 31425 0 0.00 1 28180 43 0 0
sp_fill_shopping_cart_clo_res 458432 458432 0 0.00 0 13952 14 0 0
sp_get_clo_for_invoice 4959 4959 0 0.00 0 35967 383 0 0
sp_kill_cost_storno 15919 15919 0 0.00 0 18584 57 0 0
sp_kill_qstorno_ret_qs2qd 1090659 1090659 0 0.00 0 46711 29 0 0
sp_kill_qty_storno 575244 575244 0 0.00 0 54794 64 0 0
sp_lock_selected_doc 20430 20430 0 0.00 0 9824 5 0 0
sp_make_cost_storno 27444 27444 0 0.00 0 17360 58 0 0
sp_multiply_rows_for_pdistr 27444 27444 0 0.00 0 18047 33 0 0
sp_multiply_rows_for_qdistr 20608 20608 0 0.00 0 13688 160 0 0
sp_pay_from_customer 6824 6824 0 0.00 4 17897 127 0 0
sp_pay_to_supplier 5797 5797 0 0.00 5 18940 145 0 0
sp_payment_common 12621 12621 0 0.00 1 17961 45 0 0
sp_qd_handle_on_cancel_clo 1680 1680 0 0.00 0 11595 341 0 0
sp_qd_handle_on_invoice_upd_sts 10395 10395 0 0.00 0 54790 373 0 0
sp_qd_handle_on_reserve_upd_sts 9865 9865 0 0.00 0 17143 72 0 0
sp_reserve_write_off 9865 9865 0 0.00 7 18889 203 0 0
sp_supplier_invoice 5507 5507 0 0.00 6 86424 3491 0 0
sp_supplier_order 5329 5329 0 0.00 6 53205 1180 0 0
srv_aggregate_perf_data 90 90 0 0.00 2353 185477 21058 0 0
srv_fill_mon_cache_memory 153 153 0 0.00 987 116790 34103 0 0
srv_find_qd_qs_mism 1032742 1032742 0 0.00 0 14132 5 0 0
srv_make_invnt_saldo 591 591 0 0.00 46 56115 1128 0 0
srv_make_money_saldo 765 765 0 0.00 1 2448 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 292127 380264 336652 0 0
t$perf-abend:sp_add_invoice_to_stock 81 81 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4962 4962 0 0.00 0 13332 148 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 4431 91 0 0
t$perf-norm:sp_cancel_client_order 1680 1680 0 0.00 0 2213 12 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 618 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 646 646 0 0.00 0 1464 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 393 393 0 0.00 0 983 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 447 447 0 0.00 0 1341 15 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 25496 1502 0 0
t$perf-norm:sp_cancel_write_off 973 973 0 0.00 0 1287 4 0 0
t$perf-norm:sp_client_order 20608 20608 0 0.00 0 12773 17 0 0
t$perf-norm:sp_customer_reserve 1001 1001 0 0.00 0 1632 7 0 0
t$perf-norm:sp_pay_from_customer 6824 6824 0 0.00 0 8421 9 0 0
t$perf-norm:sp_pay_to_supplier 5797 5797 0 0.00 0 6705 9 0 0
t$perf-norm:sp_reserve_write_off 9865 9865 0 0.00 0 6511 9 0 0
t$perf-norm:sp_supplier_invoice 5507 5507 0 0.00 0 8826 19 0 0
t$perf-norm:sp_supplier_order 5329 5329 0 0.00 0 2349 13 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 1044 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 153 153 0 0.00 0 2278 19 0 0
t$perf-norm:srv_make_invnt_saldo 591 591 0 0.00 0 4656 31 0 0
t$perf-norm:srv_make_money_saldo 765 765 0 0.00 0 588 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 3 0 0
v_add_invoice_to_stock 10078 9916 162 1.60 0 5938 17 0 162
v_all_customers 37136 37136 0 0.00 0 21 1 0 0
v_all_suppliers 30028 30028 0 0.00 0 34 1 0 0
v_all_wares 41212 41212 0 0.00 0 182 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 203 5 0 0
v_cancel_client_order 3360 3360 0 0.00 0 3154 5 0 0
v_cancel_customer_prepayment 1292 1292 0 0.00 0 3659 6 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 2759 5 0 0
v_cancel_payment_to_supplier 786 786 0 0.00 0 1303 7 0 0
v_cancel_supplier_invoice 902 894 8 0.88 0 5124 23 0 8
v_cancel_supplier_order 802 802 0 0.00 0 300 4 0 0
v_cancel_write_off 1946 1946 0 0.00 0 2382 13 0 0
v_max_id_clo_ord 5327 5327 0 0.00 0 760 1 0 0
v_max_id_clo_res 1001 1001 0 0.00 0 2753 17 0 0
v_max_id_ord_sup 5492 5492 0 0.00 0 5366 6 0 0
v_max_non_paid_invoice 1602 1602 0 0.00 0 3027 5 0 0
v_max_non_paid_realizn 3615 3615 0 0.00 0 1673 3 0 0
v_min_id_clo_ord 5327 5327 0 0.00 0 3086 7 0 0
v_min_id_clo_res 1001 1001 0 0.00 0 9884 52 0 0
v_min_id_ord_sup 5492 5492 0 0.00 0 5964 14 0 0
v_min_non_paid_invoice 5797 5797 0 0.00 0 17132 38 0 0
v_min_non_paid_realizn 6824 6824 0 0.00 0 16398 29 0 0
v_our_firm 10494 10494 0 0.00 0 12 1 0 0
v_reserve_write_off 19730 19730 0 0.00 0 4228 6 0 0
x_lock_depdocs_on_canc_invoice 11095 11095 0 0.00 0 13897 127 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 12087 354 0 0
x_make_qstorno_1000_1200 5329 5329 0 0.00 1 53187 1097 0 0
x_make_qstorno_1200_2000 5507 5507 0 0.00 2 86410 3333 0 0
x_make_qstorno_2100_3300 458433 458433 0 0.00 0 37133 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-11-2020 22:28:41 to 11-11-2020 22:28:45.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:03 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:09 16996 8192000000 10205797904 10510573568 935423232 10.248 76 61 126 0 959627664 2693520 21510912
19:57:34 43755 8192000000 10340752096 10655690752 1382457184 14.439 100 86 172 0 1415642976 5075696 28110096
19:58:27 13243 8192000000 10361711792 10686447616 1418169280 14.756 100 84 168 0 1452033904 6186368 27678256
19:58:49 24091 8192000000 10398836912 10726215680 1450660416 15.044 100 85 170 1 1485170752 6981904 27528432
19:59:26 9429 8192000000 10431540528 10759184384 1483307680 15.330 100 88 176 0 1519346928 7806704 28232544
19:59:49 25134 8192000000 10445336320 10779156480 1497119312 15.451 100 87 175 1 1533993440 8594816 28279312
20:00:23 22128 8192000000 10457177136 10795290624 1517578864 15.629 100 91 182 1 1555878816 9247664 29052288
20:01:08 16743 8192000000 10496842256 10840899584 1545702784 15.873 100 84 168 0 1581526176 9248752 26574640
20:01:35 16284 8192000000 10526991232 10875461632 1573842688 16.115 100 78 156 0 1607115296 9341088 23931520
20:02:14 15401 8192000000 10551980688 10909327360 1604638176 16.379 100 83 166 1 1640581392 10703776 25239440
20:02:41 11056 8192000000 10576487184 10937069568 1637328720 16.657 100 78 156 1 1671642464 10576576 23737168
20:03:00 10629 8192000000 10593518208 10959659008 1655177840 16.808 100 74 147 1 1688207200 11055568 21973792
20:03:22 12307 8192000000 10611178528 10978861056 1673626816 16.964 100 78 154 1 1707396064 10680464 23088784
20:03:47 10939 8192000000 10628781456 10998112256 1688408192 17.088 100 75 150 1 1722196016 11675376 22112448
20:04:10 7765 8192000000 10636018368 11012222976 1699210784 17.178 100 68 134 1 1729435680 11177440 19047456
20:04:31 6791 8192000000 10659190128 11035693056 1722449808 17.373 100 77 154 1 1756679184 11467792 22761584
20:04:46 8775 8192000000 10671411296 11049029632 1732209952 17.454 100 68 136 0 1763055648 11131280 19714416
20:05:05 6717 8192000000 10683022080 11064205312 1748501280 17.589 100 69 139 0 1779970320 12049456 19419584
20:05:20 6456 8192000000 10696554624 11079704576 1760735680 17.690 100 73 146 0 1794515056 13214576 20564800
20:05:34 3164 8192000000 10705332016 11087904768 1776367568 17.820 100 77 152 0 1811150176 13003232 21779376
20:05:49 7911 8192000000 10713563168 11103027200 1782290336 17.868 100 71 142 1 1815097840 13600224 19207280
20:06:04 4513 8192000000 10731436992 11119136768 1786951456 17.907 100 75 147 1 1821346320 13443376 20951488
20:06:15 4292 8192000000 10736917216 11126951936 1806157840 18.064 100 74 149 2 1838908688 11649440 21101408
20:06:27 2599 8192000000 10759526256 11146878976 1816002976 18.145 100 84 168 1 1853442000 12951600 24487424
20:06:36 2767 8192000000 10767568608 11150131200 1821369952 18.189 100 89 180 1 1860384304 13874752 25139600
20:06:46 2394 8192000000 10770274560 11154657280 1827368784 18.238 100 86 168 1 1864423488 13422592 23632112
20:06:55 2556 8192000000 10777474432 11161800704 1831387024 18.271 100 83 167 0 1868280800 13757312 23136464
20:07:04 2650 8192000000 10785195056 11168972800 1843655344 18.371 100 89 179 5 1881514048 13461488 24397216
20:07:13 1799 8192000000 10781213072 11174469632 1847160352 18.399 100 86 172 2 1883743248 12031408 24551488
20:07:22 1729 8192000000 10795848304 11185684480 1855327984 18.465 100 90 181 1 1894039328 12354992 26356352
20:07:30 3028 8192000000 10806809312 11199893504 1864537040 18.540 100 83 165 0 1900241584 12870704 22833840
20:07:39 2743 8192000000 10811587984 11198029824 1863297232 18.530 100 92 185 0 1902798736 13712208 25789296
20:07:48 2393 8192000000 10804688176 11197218816 1866569024 18.557 100 89 178 0 1905387408 13180352 25638032
20:07:57 1293 8192000000 10815762512 11205144576 1869278064 18.578 100 96 191 0 1909457072 13062832 27116176
20:08:04 1436 8192000000 10816620128 11204722688 1871802032 18.599 100 90 180 1 1910743600 13180480 25761088
20:08:12 2102 8192000000 10820158864 11210379264 1872419552 18.604 100 88 176 4 1911002544 13035984 25547008
20:08:21 3748 8192000000 10816869232 11211444224 1873635680 18.614 100 84 166 1 1911352624 14234288 23482656
20:08:58 9013 8192000000 10794342464 11207094272 1873031600 18.609 100 64 127 0 1899488048 9170608 17285840
20:09:14 10640 8192000000 10778516896 11196698624 1864684176 18.541 100 22 44 0 1876407040 4950448 6772416
20:09:31 8191 8192000000 10791979952 11204079616 1869391808 18.579 100 30 57 4 1883045968 6588336 7065824
20:09:45 5881 8192000000 10781354480 11206078464 1869520672 18.580 100 30 60 1 1884795248 7174880 8099696
20:10:00 6457 8192000000 10782320400 11209994240 1874378000 18.620 100 25 50 0 1888808960 6676800 7754160
20:10:13 9531 8192000000 10777862640 11206950912 1871268032 18.595 100 19 38 2 1883092688 6418768 5405888
20:10:29 11217 8192000000 10774062144 11210346496 1879369456 18.660 100 29 58 1 1894630048 7166048 8094544
20:10:46 7886 8192000000 10780884384 11213852672 1879345760 18.660 100 28 56 1 1894438240 7382080 7710400
20:11:02 8918 8192000000 10787446832 11219529728 1881714640 18.679 100 30 60 1 1897642000 7367328 8560032
20:11:19 11137 8192000000 10781496448 11218345984 1879747936 18.663 100 12 24 2 1889138192 6318384 3071872
20:11:39 8800 8192000000 10797635520 11224821760 1887298624 18.724 100 21 42 3 1900009232 5720080 6990528
20:11:56 10738 8192000000 10796628304 11228303360 1888360016 18.733 100 14 26 1 1897726336 5644816 3721504
20:12:14 7752 8192000000 10792552880 11232235520 1895521888 18.790 100 26 50 1 1909686736 7175776 6989072
20:12:31 7985 8192000000 10808899216 11236851712 1897982912 18.810 100 28 58 2 1912443072 6450976 8009184
20:12:45 38794 8192000000 10822522096 11249172480 1895939632 18.794 100 17 34 0 1906598064 5855088 4803344
20:13:32 23125 8192000000 10854310160 11257569280 1907396432 18.886 100 57 117 1 1930995472 5736864 17862176
20:14:01 8867 8192000000 10810052400 11250958336 1903728304 18.856 100 28 56 1 1920054432 8397936 7928192
20:14:19 5638 8192000000 10824099728 11256762368 1906672480 18.880 100 33 66 2 1924249376 8292432 9284464
20:14:32 12242 8192000000 10831728336 11258433536 1907016464 18.883 100 24 47 2 1920055120 5796528 7242128
20:14:52 2759 8192000000 10838261936 11266715648 1910804080 18.913 100 43 86 1 1932763760 9930784 12028896
20:15:05 7302 8192000000 10828466224 11258032128 1890103936 18.747 99 25 50 1 1903057856 6114208 6839712
20:15:20 3917 8192000000 10816969280 11256107008 1907176576 18.884 100 30 57 1 1922603728 6478928 8948224
20:15:30 6791 8192000000 10813784416 11256688640 1908305920 18.893 100 25 50 2 1921132560 5408896 7417744
20:15:46 6292 8192000000 10821796080 11258716160 1911014048 18.915 100 26 52 2 1923835904 5604256 7217600
20:15:58 5517 8192000000 10809606736 11245080576 1898219840 18.812 100 27 54 0 1912555600 6661664 7674096
20:16:21 8594 8192000000 10814641168 11250991104 1907107024 18.883 100 30 60 2 1921338048 5231776 8999248
20:16:36 12132 8192000000 10799573376 11233841152 1874619472 18.622 99 18 35 1 1885212736 5398976 5194288
20:16:57 10458 8192000000 10768988320 11200675840 1821246240 18.188 96 15 31 1 1830688336 5029584 4412512
20:17:17 10952 8192000000 10775994496 11202588672 1806744688 18.069 96 17 33 3 1817163504 5419232 4999584
20:17:35 60471 8192000000 10710497072 11114041344 1729120032 17.428 92 29 59 3 1743219712 5407488 8692192
20:18:42 31847 8192000000 10761255840 11181821952 1782582224 17.871 96 26 53 0 1795302368 5729280 6990864
20:19:21 9303 8192000000 10768534304 11189600256 1827404288 18.238 99 30 61 4 1842721776 6740368 8577120
20:19:38 5581 8192000000 10767541408 11180109824 1798449088 18.001 97 44 86 2 1818767248 7624032 12694128
20:19:51 3592 8192000000 10721164896 11132248064 1771995392 17.783 98 30 59 2 1786252288 6105184 8151712
20:20:03 6518 8192000000 10709636224 11127910400 1795250912 17.975 99 24 48 0 1808564384 6491808 6821664
20:20:16 5519 8192000000 10664419440 11075870720 1647109440 16.740 92 18 34 1 1657121056 4421696 5589920
20:20:29 5527 8192000000 10659675408 11074134016 1734821968 17.476 98 28 54 0 1747789536 5410912 7556656
20:20:41 8852 8192000000 10694397488 11111231488 1740076992 17.519 97 20 40 2 1752110544 6152016 5881536
20:20:59 5928 8192000000 10666670368 11076419584 1691418912 17.113 95 36 72 3 1707754592 5977984 10357696
20:21:11 13787 8192000000 10688958912 11103182848 1726116144 17.403 97 23 46 0 1737591328 5040272 6434912
20:21:32 11102 8192000000 10713928768 11134492672 1795057776 17.973 100 23 46 1 1807232704 4796320 7378608
20:21:55 10972 8192000000 10713361760 11137118208 1789313264 17.926 99 23 46 0 1802097984 6306240 6478480
20:22:12 6621 8192000000 10734697792 11158036480 1817127728 18.154 100 18 34 2 1827940688 5691600 5121360
20:22:25 10735 8192000000 10737015504 11161935872 1819751760 18.176 100 22 44 0 1836501424 10742208 6007456
20:22:45 18635 8192000000 10751706160 11173535744 1835238944 18.302 100 21 42 0 1846849168 5363152 6247072
20:23:39 37517 8192000000 10749036208 11180302336 1841677616 18.354 100 37 73 2 1859409328 7160448 10571264
20:24:23 7048 8192000000 10767349296 11187171328 1847267120 18.400 100 26 52 0 1860451904 5841520 7343264
20:24:38 6193 8192000000 10771984320 11191857152 1846660944 18.395 100 36 72 0 1867761792 11083264 10017584
20:24:51 7985 8192000000 10764101488 11187793920 1849318896 18.417 100 33 66 0 1865139344 5947216 9873232
20:25:06 5788 8192000000 10771563040 11195412480 1855840432 18.470 100 33 67 0 1872619568 6867216 9911920
20:25:18 6875 8192000000 10770507776 11200729088 1858874368 18.494 100 25 50 1 1872786704 5932192 7980144
20:25:31 7618 8192000000 10764920416 11199483904 1860258496 18.505 100 20 40 3 1871946976 5603520 6084960
20:25:50 9937 8192000000 10771233344 11203903488 1863148000 18.529 100 24 48 1 1875537696 4932256 7457440
20:26:09 5227 8192000000 10786217296 11210256384 1864523536 18.540 100 28 54 1 1878282752 5339168 8420048
20:26:20 14902 8192000000 10782836784 11210194944 1866796128 18.558 100 19 38 1 1878586112 5672304 6117680
20:26:48 9127 8192000000 10787765120 11213971456 1869685760 18.582 100 30 60 1 1883747072 5205296 8856016
20:27:12 42812 8192000000 10811430176 11232694272 1891151168 18.755 100 36 68 3 1906461328 4680096 10630064
20:28:14 28183 8192000000 10835813408 11261370368 1907669696 18.888 100 31 62 2 1923976672 6822432 9484544
20:28:50 15084 8192000000 10853877408 11274162176 1921655008 19.000 100 43 86 0 1945034240 10757072 12622160
20:29:11 94216 8192000000 10866486432 11296460800 1933370736 19.094 100 40 80 1 1958478720 13266480 11841504
20:30:52 59001 8192000000 10864766192 11302711296 1934923920 19.106 100 30 60 1 1960802464 16638896 9239648
20:32:05 38094 8192000000 10888906240 11325849600 1945939824 19.194 100 38 76 1 1973738848 16774048 11024976
20:32:52 20158 8192000000 10891282192 11324715008 1954310624 19.261 100 35 70 0 1982528224 17889776 10327824
20:33:20 23210 8192000000 10897512944 11329097728 1964207872 19.339 100 41 82 2 1995172560 18941472 12023216
20:33:57 17366 8192000000 10908651888 11334279168 1962193520 19.323 100 46 91 3 1995957456 20064976 13698960
20:34:25 18857 8192000000 10924288624 11340836864 1970139728 19.387 100 62 123 2 2008931264 21742208 17049328
20:34:53 4427 8192000000 10923501232 11347906560 1971186128 19.395 100 58 112 0 2010313472 22324992 16802352
20:35:05 6197 8192000000 10931929936 11357429760 1974460688 19.421 100 59 118 0 2020190928 28578544 17151696
20:35:25 6465 8192000000 10918464288 11347488768 1957103488 19.283 99 56 111 1 2000434064 26329072 17001504
20:35:45 7709 8192000000 10925640416 11351719936 1970974416 19.393 100 54 106 0 2009278288 22078784 16225088
20:36:04 4473 8192000000 10923430352 11354722304 1976715776 19.439 100 56 112 1 2014091392 20802016 16573600
20:36:18 4066 8192000000 10916229968 11345616896 1967211616 19.363 100 53 107 1 2004926272 21853840 15860816
20:36:30 6451 8192000000 10930874560 11357487104 1977843728 19.448 100 54 109 0 2015891968 22049824 15998416
20:36:44 9625 8192000000 10929708576 11356704768 1975158272 19.426 100 63 121 2 2019923168 25950016 18814880
20:37:11 10559 8192000000 10942819664 11369959424 1980833648 19.471 100 53 103 1 2021818640 25438368 15546624
20:37:30 7349 8192000000 10938847232 11365916672 1987965680 19.528 100 64 128 1 2029667392 22577024 19124688
20:37:49 2379 8192000000 10950195632 11371909120 1989459376 19.540 100 65 126 1 2030718576 22199520 19059680
20:37:59 5405 8192000000 10937668880 11362607104 1969441408 19.381 99 65 130 0 2014435584 25364624 19629552
20:38:11 1553 8192000000 10953556288 11374649344 1993112384 19.568 100 71 140 1 2038977408 25542592 20322432
20:38:19 7506 8192000000 10944557200 11373400064 1989376992 19.539 100 67 132 1 2036289088 27519440 19392656
20:38:35 3990 8192000000 10954019664 11375038464 1990619456 19.549 100 76 152 1 2041440960 28170112 22651392
20:38:46 4289 8192000000 10948055360 11370913792 1984688320 19.502 100 67 132 0 2032220224 28271840 19260064
20:39:01 2088 8192000000 10936072624 11353546752 1974792736 19.423 100 84 168 1 2027701264 26589600 26318928
20:39:11 985 8192000000 10944611216 11359244288 1976677568 19.438 100 86 171 0 2030399088 27703280 26018240
20:39:19 2889 8192000000 10955035968 11372298240 1986452192 19.516 100 85 170 1 2041200304 29364336 25383776
20:39:29 2002 8192000000 10954172192 11375206400 1993024576 19.568 100 83 166 1 2046181296 28746288 24410432
20:39:40 5788 8192000000 10941190448 11363508224 1965387600 19.349 99 72 144 2 2017421008 30301392 21732016
20:39:52 4214 8192000000 10963019104 11382755328 1991335840 19.554 100 77 152 2 2045836704 32137760 22363104
20:40:03 5092 8192000000 10964578256 11392618496 1997615632 19.604 100 77 153 2 2053964576 32950384 23398560
20:40:17 7016 8192000000 10970131488 11394322432 1994985184 19.583 100 75 150 2 2050789536 33497136 22307216
20:40:32 8830 8192000000 10956938512 11393822720 1981523632 19.477 99 52 104 0 2033570752 35612160 16434960
20:40:47 2179 8192000000 10973839648 11400118272 2003379008 19.649 100 74 148 0 2060224112 33780704 23064400
20:40:57 3828 8192000000 10964718656 11385700352 1975967520 19.433 99 85 169 1 2038617360 35947504 26702336
20:41:07 3103 8192000000 10978988480 11401764864 2001358368 19.633 100 85 167 1 2065009040 37721296 25929376
20:41:17 3740 8192000000 10974419920 11395715072 1993423792 19.571 100 76 150 2 2055592416 38787840 23380784
20:41:29 4998 8192000000 10971596320 11396599808 1998025088 19.607 100 70 141 0 2056729120 37439776 21264256
20:41:41 1828 8192000000 10950913200 11365195776 1970885136 19.392 100 81 162 2 2034625264 37862176 25877952
20:41:51 4831 8192000000 10956759152 11379650560 1982297040 19.483 100 75 150 1 2044701712 39032208 23372464
20:42:06 2719 8192000000 10953938512 11371294720 1972573792 19.406 100 87 174 2 2039727440 40277072 26876576
20:42:18 2962 8192000000 10953647424 11365900288 1975320880 19.428 100 91 180 2 2044771840 41844944 27606016
20:42:30 1717 8192000000 10935717648 11338539008 1922068272 19.003 98 92 182 0 1998849824 50123616 26657936
20:42:39 4418 8192000000 10929639760 11340652544 1941043184 19.155 100 85 169 1 2013021024 46695520 25282320
20:42:51 2739 8192000000 10935310272 11345018880 1930327952 19.070 99 82 162 3 2001614688 45687648 25599088
20:43:01 2675 8192000000 10934991584 11348828160 1951053984 19.235 100 80 160 0 2015239280 38721120 25464176
20:43:11 5046 8192000000 10937189888 11355439104 1956773968 19.280 100 78 156 3 2020591440 39391152 24426320
20:43:26 3143 8192000000 10935423808 11346894848 1952213472 19.244 100 83 165 2 2017133936 38569824 26350640
20:43:40 1734 8192000000 10928485264 11340361728 1949568400 19.223 100 79 154 0 2006640400 32946224 24125776
20:43:49 4850 8192000000 10894860576 11320823808 1934386272 19.102 100 65 130 0 1986899696 32004672 20508752
20:44:04 5983 8192000000 10870952832 11293863936 1875712640 18.630 97 57 114 1 1928480416 34675872 18091904
20:44:19 14816 8192000000 10877804240 11326472192 1931517680 19.079 100 34 68 1 1972881392 30697472 10666240
20:44:42 7992 8192000000 10875388528 11301158912 1904589088 18.863 99 57 114 1 1953497488 31526720 17381680
20:45:02 3534 8192000000 10880809632 11298873344 1912510064 18.927 100 51 101 0 1959820384 31322848 15987472
20:45:15 10306 8192000000 10862725376 11304865792 1912996048 18.931 100 40 80 3 1959159920 33023056 13140816
20:45:44 14563 8192000000 10860517296 11296727040 1895173904 18.787 99 35 70 1 1936924432 29726304 12024224
20:46:06 7992 8192000000 10878994112 11307069440 1914003152 18.939 100 43 84 1 1959020976 30829552 14188272
20:46:22 10824 8192000000 10868996160 11308929024 1917022176 18.963 100 37 74 2 1959734784 30516144 12196464
20:46:45 14500 8192000000 10882240816 11305627648 1906733680 18.880 99 62 121 2 1959151040 32960368 19456992
20:47:07 2153 8192000000 10900762400 11311321088 1909740704 18.905 99 87 169 3 1973372608 37785680 25846224
20:47:18 7760 8192000000 10902502544 11324481536 1928780304 19.057 100 69 136 1 1985183120 34990768 21412048
20:47:35 6953 8192000000 10890058112 11330002944 1929110464 19.060 100 49 98 0 1979401328 34408128 15882736
20:48:00 13864 8192000000 10861082608 11313537024 1907260576 18.885 99 28 55 3 1941320048 25572528 8486944
20:48:20 18353 8192000000 10865576752 11309535232 1902633888 18.847 99 23 46 0 1936177648 25873088 7670672
20:48:45 11476 8192000000 10850880080 11290689536 1898898352 18.817 100 24 48 2 1933736960 27295088 7543520
20:49:02 22464 8192000000 10841527312 11292803072 1865329952 18.546 98 27 54 0 1904353120 29709584 9313584
20:49:35 15495 8192000000 10850006368 11291107328 1884447168 18.701 99 18 36 1 1914511616 24367392 5697056
20:50:01 14634 8192000000 10849907184 11296186368 1891796048 18.760 99 29 58 1 1927839328 26710976 9332304
20:50:25 23038 8192000000 10848279344 11296718848 1902735024 18.848 99 24 48 1 1936783744 26254000 7794720
20:50:55 9159 8192000000 10854524768 11299794944 1897147792 18.803 99 23 46 1 1926120224 21333504 7638928
20:51:22 26956 8192000000 10864389536 11319398400 1920145984 18.988 100 17 34 0 1945809056 20450496 5212576
20:52:02 35733 8192000000 10867426160 11316936704 1908989664 18.899 99 16 32 0 1939758192 25664624 5103904
20:53:05 33045 8192000000 10863588304 11310284800 1844889760 18.381 96 21 42 0 1880832784 29175472 6767552
20:54:07 28316 8192000000 10845659728 11287638016 1895571808 18.791 99 12 24 0 1914143360 14955104 3616448
20:55:16 87480 8192000000 10859489200 11305189376 1908117488 18.892 99 26 52 0 1927482192 11439664 7925040
20:57:14 53419 8192000000 10870239312 11324669952 1939280464 19.141 100 27 54 1 1954802416 8695216 6826736
20:58:14 75012 8192000000 10894501328 11342266368 1934248576 19.101 99 33 66 1 1953058336 9687072 9122688
20:59:38 36911 8192000000 10900959904 11357466624 1961303648 19.316 100 33 68 2 1990717376 19294912 10118816
21:01:19 41278 8192000000 10897737408 11367452672 1973755200 19.415 100 14 28 0 1991501328 13684640 4061488
21:02:06 56873 8192000000 10847910432 11306881024 1873534208 18.613 95 8 16 1 1885708432 9881440 2292784
21:03:14 19710 8192000000 10884830112 11347226624 1957555104 19.287 100 14 28 0 1973557776 11686464 4316208
21:03:44 36253 8192000000 10902941344 11366424576 1973334400 19.412 100 18 36 1 1994688192 15708704 5645088
21:05:02 57220 8192000000 10882899984 11353292800 1937331840 19.125 98 14 29 1 1963275040 21049760 4893440
21:06:08 53742 8192000000 10892358608 11364052992 1961510288 19.318 100 12 23 2 1981716288 16631616 3574384
21:07:09 29179 8192000000 10905770912 11380170752 1973623392 19.414 100 17 34 1 1995187376 16246320 5317664
21:08:11 101918 8192000000 10910829584 11365089280 1972307440 19.404 100 22 44 1 1988173568 10432672 5433456
21:10:03 39684 8192000000 10909118640 11382288384 1991280576 19.554 100 34 68 1 2015919184 14782400 9856208
21:10:57 57212 8192000000 10914362352 11385995264 1991193248 19.553 100 24 49 1 2014793120 17347696 6252176
21:13:36 85436 8192000000 10913879184 11408879616 1966931904 19.361 99 8 16 0 1986124400 17049792 2142704
21:15:10 54929 8192000000 10911824112 11386159104 1973095968 19.410 99 36 73 0 1999437296 15299440 11041888
21:16:22 85111 8192000000 10915419072 11389960192 1986814384 19.519 100 14 26 1 1999107632 8556560 3736688
21:17:59 86154 8192000000 10919306016 11391795200 1980619504 19.470 99 11 22 0 1994906000 11513888 2772608
21:19:43 60785 8192000000 10924567520 11397095424 1990825488 19.550 100 13 26 0 2010306176 15951952 3528736
21:20:50 42926 8192000000 10933346128 11385057280 1993011600 19.568 100 18 36 2 2005672192 7862048 4798544
21:21:45 28020 8192000000 10925463152 11377356800 1973432272 19.413 99 28 56 0 1988919856 8008464 7479120
21:22:19 21876 8192000000 10920252176 11376439296 1974344352 19.420 99 44 88 3 1996230208 10065280 11820576
21:22:49 15743 8192000000 10930390432 11380142080 1975320736 19.428 99 33 66 0 1993473904 9410560 8742608
21:23:13 23397 8192000000 10929776528 11378925568 1971444640 19.397 99 45 89 4 1995321168 11309984 12566544
21:23:44 59877 8192000000 10915893568 11389358080 1985938032 19.512 100 23 46 2 2005406976 12859408 6609536
21:24:55 92278 8192000000 10875721280 11335577600 1828827056 18.250 92 25 49 1 1848410944 12915728 6668160
21:27:23 51454 8192000000 10879138864 11349061632 1896001088 18.794 96 22 44 0 1911693968 9790384 5902496
21:28:20 42744 8192000000 10883043424 11345457152 1888634864 18.735 96 20 38 2 1912280464 17674160 5971440
21:29:09 115628 8192000000 10882177152 11336957952 1921641968 19.000 98 22 44 1 1938712064 11083520 5986576
21:31:19 47260 8192000000 10859942784 11329105920 1910813008 18.913 98 19 36 2 1931455264 15714064 4928192
21:32:13 8923 8192000000 10861604832 11326877696 1926234992 19.037 99 19 36 1 1944119328 13145888 4738448
21:32:28 37137 8192000000 10859710192 11321360384 1867485728 18.564 96 18 36 0 1883418064 11235616 4696720
21:33:12 65442 8192000000 10857330544 11338534912 1931347376 19.078 99 17 34 1 1952574768 16419152 4808240
21:34:25 38145 8192000000 10877984400 11360690176 1938683040 19.136 100 13 26 1 1959183968 16724720 3776208
21:35:09 28770 8192000000 10877974064 11354292224 1951538576 19.239 100 8 16 0 1969852368 16166336 2147456
21:35:58 64208 8192000000 10885040112 11352805376 1917496656 18.967 98 15 30 0 1940129376 18069392 4563328
21:37:15 61866 8192000000 10835247808 11316031488 1808968016 18.087 93 4 8 0 1823026560 12979808 1078736
21:38:23 57235 8192000000 10821743168 11269693440 1768660256 17.756 92 20 39 0 1785856112 11775776 5420080
21:39:26 101238 8192000000 10814473520 11285020672 1807079856 18.072 95 11 22 0 1823922624 13726368 3116400
21:41:26 22277 8192000000 10837638016 11289866240 1906442976 18.878 100 26 52 0 1921618192 8053216 7122000
21:41:56 16755 8192000000 10835886624 11284078592 1859127008 18.496 97 25 50 0 1874261056 7772880 7361168
21:42:27 29414 8192000000 10862578080 11304517632 1905155392 18.868 99 56 112 1 1934579792 13041840 16382560
21:43:06 29641 8192000000 10852025456 11303243776 1902617504 18.847 99 38 76 1 1927255840 14017840 10620496
21:43:42 73735 8192000000 10858710416 11312529408 1879028496 18.657 98 33 66 2 1904057024 16003088 9025440
21:45:15 54008 8192000000 10822670480 11288301568 1819400128 18.173 95 11 22 1 1838128784 15738336 2990320
21:46:23 59149 8192000000 10815673536 11259527168 1785244656 17.893 94 11 22 0 1799646832 11638304 2763872
21:47:28 52047 8192000000 10857419136 11290181632 1894907616 18.785 100 38 76 2 1919539424 14156592 10475216
21:48:27 73946 8192000000 10846787984 11316785152 1889342032 18.740 99 18 36 1 1914158560 19579632 5236896
21:49:48 75750 8192000000 10844578896 11304808448 1894102928 18.779 99 15 30 1 1909695840 11533008 4059904
21:51:11 116789 8192000000 10856465312 11312193536 1925648608 19.032 100 16 31 0 1940608704 9944576 5015520
21:53:15 24749 8192000000 10872268096 11317522432 1938861472 19.138 100 31 60 0 1955035648 7127120 9047056
21:54:28 75268 8192000000 10849687520 11325169664 1902233104 18.844 98 15 30 1 1918578896 12350080 3995712
21:55:49 48331 8192000000 10850524144 11326902272 1895298816 18.788 98 17 35 2 1910953488 10865488 4789184
21:56:49 67343 8192000000 10867038160 11327488000 1920397712 18.990 99 12 25 1 1930235552 6194560 3643280
21:58:02 67176 8192000000 10869988144 11340865536 1942957168 19.170 99 13 26 0 1953945760 7003616 3984976
21:59:17 60734 8192000000 10865154848 11338166272 1939395216 19.142 99 12 24 0 1949229216 6773280 3060720
22:00:40 53498 8192000000 10875719968 11343433728 1955045792 19.267 100 8 16 0 1963956848 6712080 2198976
22:01:40 68260 8192000000 10861227456 11326599168 1907572416 18.887 97 12 24 0 1921510784 10446880 3491488
22:02:55 37390 8192000000 10885149744 11339718656 1920925024 18.994 98 30 61 2 1938775104 8660304 9189776
22:03:49 51117 8192000000 10909390336 11361140736 1957196816 19.284 100 19 38 0 1971425696 9297504 4931376
22:04:46 24947 8192000000 10909620832 11365031936 1977080064 19.442 100 51 102 3 2003205328 11842224 14283040
22:05:17 73524 8192000000 10892279296 11356852224 1929083888 19.060 98 19 38 2 1943691936 8982576 5625472
22:06:38 50907 8192000000 10911945536 11375878144 1970042992 19.386 100 23 44 1 1985499088 9606144 5849952
22:07:41 57117 8192000000 10927075376 11384680448 1986443888 19.516 100 23 44 2 2007283328 14560640 6278800
22:08:48 74350 8192000000 10909990720 11367337984 1922785216 19.009 97 21 42 1 1949930880 20565184 6580480
22:10:09 91853 8192000000 10875115536 11342798848 1894317328 18.781 96 11 22 1 1908343248 11438944 2586976
22:11:48 57787 8192000000 10904369920 11354370048 1906798784 18.881 97 30 60 0 1926011792 11166608 8046400
22:13:07 66121 8192000000 10887576816 11352711168 1909103952 18.899 97 24 48 1 1928070544 12444592 6522000
22:14:20 55194 8192000000 10898901232 11366936576 1958428928 19.294 100 13 24 2 1972397104 10899168 3069008
22:16:26 101435 8192000000 10909030480 11379253248 1975810256 19.432 100 23 46 0 1997464624 14759776 6894592
22:18:13 36780 8192000000 10893328880 11360890880 1964425184 19.341 100 7 14 0 1980511968 14200112 1886672
22:19:14 72289 8192000000 10875618976 11361050624 1929678480 19.064 98 12 24 0 1945683216 12596112 3408624
22:20:42 42001 8192000000 10843233696 11326689280 1897225440 18.804 97 7 14 0 1911131488 11876656 2029392
22:21:30 68672 8192000000 10873293680 11337367552 1912256400 18.925 98 15 30 1 1928812496 12048144 4507952
22:22:45 55875 8192000000 10858584896 11324829696 1884364752 18.700 96 18 36 0 1900736304 10913184 5458368
22:24:59 84092 8192000000 10849027328 11308199936 1839899392 18.340 95 8 16 0 1856780848 14429328 2452128
22:26:48 20075 8192000000 9155244336 9397309440 319244944 3.750 17 2 4 0 325670240 5903040 522256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 11-11-2020 22:28:47 to 11-11-2020 22:29:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 81 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

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

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          238317
MON$OLDEST_ACTIVE               238318
MON$OLDEST_SNAPSHOT             238318
MON$NEXT_TRANSACTION            238318
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                       2017472
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.7.33388 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.7.33388 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.7.33388 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.7.33388 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 ---
:284: 
:285: mscs-test-161.budzdorov.ru    Wed Nov 11 22:27:16 2020
:286:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:287: 
--- end of diff output ---

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

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