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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17233708 kB
MemAvailable 31197760 kB
Buffers 0 kB
Cached 14446416 kB
SwapCached 4876 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-02-07 16:27:19
DTS_END                         2021-02-07 16:27:19.2450
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/52510
TRN_ID                          233925
ATT_ID                          676
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: 9082.65 23653 1089918
customer order: creation 165.55 390 19866
customer order: refuse 14.18 346 1701
order to supplier: creation 42.43 1398 5092
order to supplier: removal 3.21 119243 385
invoice (draft): creation 44.73 3359 5368
invoice (draft): removal 51.49 821 6179
invoice accept: apply 40.62 19268 4874
invoice accept: cancel 46.58 831 5589
customer reserve: creation 3741.54 192 448985
customer reserve: removal 4646.02 66 557522
realization accept: apply 80.35 168 9642
realization accept: cancel 81.87 100 9824
payment from customer: creation 56.59 111 6791
payment from customer: removal 5.35 68 642
payment to supplier: creation 47.31 129 5677
payment to supplier: removal 3.37 80 404
service: total inventory turnovers 4.35 994 522
service: total monetary turnovers 6.28 24 754
service: aggregate perf. data 0.81 23200 97
service: refresh index statistics 0.03 302278 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-02-2021 16:28:05 to 07-02-2021 16:28:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7628
TEST_TIME 2 6578
TEST_TIME 3 6161
TEST_TIME 4 6629
TEST_TIME 5 5967
TEST_TIME 6 6335
TEST_TIME 7 6389
TEST_TIME 8 6265
TEST_TIME 9 6005
TEST_TIME 10 6016
TEST_TIME 11 6144
TEST_TIME 12 6234
TEST_TIME 13 6283
TEST_TIME 14 6308
TEST_TIME 15 6568
TEST_TIME 16 6754
TEST_TIME 17 7076
TEST_TIME 18 7191
TEST_TIME 19 7276
TEST_TIME 20 8113
TEST_TIME 21 7915
TEST_TIME 22 8123
TEST_TIME 23 8537
TEST_TIME 24 8965
TEST_TIME 25 9436
TEST_TIME 26 9716
TEST_TIME 27 10358
TEST_TIME 28 10784
TEST_TIME 29 10512
TEST_TIME 30 10450
TEST_TIME 31 10293
TEST_TIME 32 10127
TEST_TIME 33 9977
TEST_TIME 34 9928
TEST_TIME 35 9891
TEST_TIME 36 9753
TEST_TIME 37 9629
TEST_TIME 38 9647
TEST_TIME 39 9577
TEST_TIME 40 9388
TEST_TIME 41 9384
TEST_TIME 42 9331
TEST_TIME 43 9335
TEST_TIME 44 9382
TEST_TIME 45 9436
TEST_TIME 46 9465
TEST_TIME 47 9420
TEST_TIME 48 9417
TEST_TIME 49 9348
TEST_TIME 50 9404
TEST_TIME 51 9471
TEST_TIME 52 9469
TEST_TIME 53 9470
TEST_TIME 54 9506
TEST_TIME 55 9509
TEST_TIME 56 9512
TEST_TIME 57 9544
TEST_TIME 58 9520
TEST_TIME 59 9468
TEST_TIME 60 9471
TEST_TIME 61 9333
TEST_TIME 62 9283
TEST_TIME 63 9238
TEST_TIME 64 9200
TEST_TIME 65 9270
TEST_TIME 66 9196
TEST_TIME 67 9139
TEST_TIME 68 9114
TEST_TIME 69 9093
TEST_TIME 70 9218
TEST_TIME 71 9209
TEST_TIME 72 9319
TEST_TIME 73 9262
TEST_TIME 74 9283
TEST_TIME 75 9291
TEST_TIME 76 9246
TEST_TIME 77 9306
TEST_TIME 78 9460
TEST_TIME 79 9426
TEST_TIME 80 9504
TEST_TIME 81 9455
TEST_TIME 82 9401
TEST_TIME 83 9399
TEST_TIME 84 9394
TEST_TIME 85 9396
TEST_TIME 86 9347
TEST_TIME 87 9339
TEST_TIME 88 9302
TEST_TIME 89 9257
TEST_TIME 90 9224
TEST_TIME 91 9248
TEST_TIME 92 9234
TEST_TIME 93 9230
TEST_TIME 94 9206
TEST_TIME 95 9186
TEST_TIME 96 9260
TEST_TIME 97 9303
TEST_TIME 98 9337
TEST_TIME 99 9391
TEST_TIME 100 9390
TEST_TIME 101 9416
TEST_TIME 102 9373
TEST_TIME 103 9409
TEST_TIME 104 9397
TEST_TIME 105 9315
TEST_TIME 106 9262
TEST_TIME 107 9248
TEST_TIME 108 9213
TEST_TIME 109 9170
TEST_TIME 110 9131
TEST_TIME 111 9108
TEST_TIME 112 9175
TEST_TIME 113 9138
TEST_TIME 114 9136
TEST_TIME 115 9107
TEST_TIME 116 9134
TEST_TIME 117 9125
TEST_TIME 118 9117
TEST_TIME 119 9144
TEST_TIME 120 9091

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-02-2021 16:28:09 to 07-02-2021 16:28:12.

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 1506917 1506917 0 0.00 0 23437 6 0 0
doc_list_biud 1506917 1506917 0 0.00 0 58481 30 0 0
sp_add_invoice_to_stock 4963 4874 89 1.79 29 221097 19269 0 89
sp_cancel_adding_invoice 5589 5589 0 0.00 3 63794 831 0 0
sp_cancel_client_order 1701 1701 0 0.00 4 8594 346 0 0
sp_cancel_customer_reserve 557522 557522 0 0.00 1 58484 67 0 0
sp_cancel_pay_from_customer 642 642 0 0.00 3 4790 69 0 0
sp_cancel_pay_to_supplier 404 404 0 0.00 3 3202 81 0 0
sp_cancel_supplier_invoice 6185 6179 6 0.09 2 16618 821 0 6
sp_cancel_supplier_order 385 385 0 0.00 12 1170510 119243 0 0
sp_cancel_write_off 9824 9824 0 0.00 1 13978 100 0 0
sp_client_order 19866 19866 0 0.00 3 23967 390 0 0
sp_customer_reserve 448985 448985 0 0.00 0 51921 192 0 0
sp_fill_shopping_cart 30322 30322 0 0.00 1 13046 38 0 0
sp_fill_shopping_cart_clo_res 448976 448976 0 0.00 0 16115 14 0 0
sp_get_clo_for_invoice 4857 4857 0 0.00 0 33091 307 0 0
sp_kill_cost_storno 16459 16459 0 0.00 0 7406 56 0 0
sp_kill_qstorno_ret_qs2qd 1131432 1131432 0 0.00 0 58476 36 0 0
sp_kill_qty_storno 595698 595698 0 0.00 0 58481 76 0 0
sp_lock_selected_doc 20095 20095 0 0.00 0 8007 4 0 0
sp_make_cost_storno 26966 26966 0 0.00 0 11489 52 0 0
sp_multiply_rows_for_pdistr 26966 26966 0 0.00 0 5710 31 0 0
sp_multiply_rows_for_qdistr 19866 19866 0 0.00 0 12916 188 0 0
sp_pay_from_customer 6791 6791 0 0.00 4 10318 111 0 0
sp_pay_to_supplier 5677 5677 0 0.00 5 12659 129 0 0
sp_payment_common 12468 12468 0 0.00 1 9542 33 0 0
sp_qd_handle_on_cancel_clo 1701 1701 0 0.00 0 8588 319 0 0
sp_qd_handle_on_invoice_upd_sts 10445 10445 0 0.00 0 25086 327 0 0
sp_qd_handle_on_reserve_upd_sts 9642 9642 0 0.00 0 23295 54 0 0
sp_reserve_write_off 9642 9642 0 0.00 7 23409 168 0 0
sp_supplier_invoice 5368 5368 0 0.00 6 96568 3359 0 0
sp_supplier_order 5092 5092 0 0.00 5 35429 1398 0 0
srv_aggregate_perf_data 97 97 0 0.00 2696 374752 23200 0 0
srv_fill_mon_cache_memory 161 161 0 0.00 1079 136956 31849 0 0
srv_find_qd_qs_mism 1044554 1044554 0 0.00 0 23435 6 0 0
srv_make_invnt_saldo 522 522 0 0.00 34 64253 994 0 0
srv_make_money_saldo 754 754 0 0.00 0 2419 25 0 0
srv_recalc_idx_stat 4 4 0 0.00 87670 391181 302278 0 0
t$perf-abend:sp_add_invoice_to_stock 89 89 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 4876 4876 0 0.00 0 20371 178 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 3635 102 0 0
t$perf-norm:sp_cancel_client_order 1701 1701 0 0.00 0 8345 24 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 3874 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 642 642 0 0.00 0 990 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 404 404 0 0.00 0 1479 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 763 15 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 31654 1829 0 0
t$perf-norm:sp_cancel_write_off 961 961 0 0.00 0 837 5 0 0
t$perf-norm:sp_client_order 19866 19866 0 0.00 0 16575 20 0 0
t$perf-norm:sp_customer_reserve 1004 1004 0 0.00 0 4305 14 0 0
t$perf-norm:sp_pay_from_customer 6791 6791 0 0.00 0 10387 13 0 0
t$perf-norm:sp_pay_to_supplier 5677 5677 0 0.00 0 17751 20 0 0
t$perf-norm:sp_reserve_write_off 9642 9642 0 0.00 0 13576 18 0 0
t$perf-norm:sp_supplier_invoice 5368 5368 0 0.00 0 16417 38 0 0
t$perf-norm:sp_supplier_order 5092 5092 0 0.00 0 5022 14 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 474 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 161 161 0 0.00 0 154 3 0 0
t$perf-norm:srv_make_invnt_saldo 522 522 0 0.00 0 3112 27 0 0
t$perf-norm:srv_make_money_saldo 754 754 0 0.00 0 4112 26 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 9890 9712 178 1.79 0 6549 17 0 178
v_all_customers 36204 36204 0 0.00 0 17 1 0 0
v_all_suppliers 29190 29190 0 0.00 0 17 1 0 0
v_all_wares 39732 39732 0 0.00 0 115 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 276 6 0 0
v_cancel_client_order 3402 3402 0 0.00 0 4324 6 0 0
v_cancel_customer_prepayment 1284 1284 0 0.00 0 1993 5 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 1487 5 0 0
v_cancel_payment_to_supplier 808 808 0 0.00 0 3178 12 0 0
v_cancel_supplier_invoice 864 852 12 1.38 0 4465 21 0 12
v_cancel_supplier_order 770 770 0 0.00 0 3211 14 0 0
v_cancel_write_off 1922 1922 0 0.00 0 2893 16 0 0
v_max_id_clo_ord 5092 5092 0 0.00 0 7022 4 0 0
v_max_id_clo_res 1004 1004 0 0.00 0 1664 11 0 0
v_max_id_ord_sup 5364 5364 0 0.00 0 4235 5 0 0
v_max_non_paid_invoice 1538 1538 0 0.00 0 4127 8 0 0
v_max_non_paid_realizn 3544 3544 0 0.00 0 4299 5 0 0
v_min_id_clo_ord 5092 5092 0 0.00 0 6031 8 0 0
v_min_id_clo_res 1004 1004 0 0.00 0 3799 8 0 0
v_min_id_ord_sup 5364 5364 0 0.00 0 5282 8 0 0
v_min_non_paid_invoice 5677 5677 0 0.00 0 9536 25 0 0
v_min_non_paid_realizn 6790 6790 0 0.00 0 8172 18 0 0
v_our_firm 10020 10020 0 0.00 0 12 1 0 0
v_reserve_write_off 19284 19284 0 0.00 0 4075 5 0 0
x_lock_depdocs_on_canc_invoice 11342 11342 0 0.00 0 32609 126 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 8197 393 0 0
x_make_qstorno_1000_1200 5092 5092 0 0.00 2 35419 1314 0 0
x_make_qstorno_1200_2000 5368 5368 0 0.00 3 91408 3231 0 0
x_make_qstorno_2100_3300 448985 448985 0 0.00 0 51920 175 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-02-2021 16:28:13 to 07-02-2021 16:28:17.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:22 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 17512 8192000000 10247208512 10553851904 826219856 9.161 67 51 104 0 846107408 2289664 17597888
13:57:54 19027 8192000000 10322881536 10640543744 1375244960 14.374 100 82 164 1 1407301872 4877008 27179904
13:58:23 22197 8192000000 10371870208 10690633728 1422671824 14.796 100 90 180 0 1458631264 5806576 30152864
13:58:53 25794 8192000000 10386366800 10709655552 1443020144 14.976 100 86 172 0 1478019904 6792272 28207488
13:59:30 10925 8192000000 10408892688 10732679168 1457502736 15.104 100 87 174 0 1493393792 7273904 28617152
13:59:51 18904 8192000000 10418460928 10748432384 1474648240 15.255 100 88 176 0 1510690160 7520864 28521056
14:00:20 19376 8192000000 10444336304 10777088000 1500486640 15.480 100 82 164 1 1535050144 8080368 26483136
14:00:48 20515 8192000000 10472765504 10809982976 1519116912 15.643 100 82 164 0 1553814912 8398720 26299280
14:01:20 10382 8192000000 10489882112 10833661952 1551747984 15.925 100 88 176 0 1588529056 9339488 27441584
14:01:39 17263 8192000000 10507233072 10854924288 1565611392 16.045 100 77 154 0 1598437616 9362592 23463632
14:02:05 11138 8192000000 10519157392 10875072512 1581037872 16.177 100 65 130 1 1610109232 9356704 19714656
14:02:27 12676 8192000000 10560256624 10915483648 1611948752 16.441 100 78 154 1 1645307584 9739392 23619440
14:02:48 13615 8192000000 10585456496 10945564672 1645934448 16.730 100 72 144 0 1677167552 10464192 20768912
14:03:09 15045 8192000000 10596372688 10959806464 1656338928 16.818 100 73 146 2 1688906304 11037344 21530032
14:03:32 7564 8192000000 10606935872 10973851648 1668275888 16.919 100 76 152 0 1701521760 11435680 21810192
14:03:50 10954 8192000000 10616664512 10983665664 1678910416 17.008 100 77 154 2 1713893280 12432080 22550784
14:04:09 10129 8192000000 10626416224 11000098816 1690482304 17.105 100 75 150 1 1724124448 12187552 21454592
14:04:30 9946 8192000000 10643243072 11019579392 1715704192 17.316 100 71 139 2 1747207552 11519136 19984224
14:04:48 7826 8192000000 10675648704 11049574400 1739018976 17.510 100 78 155 1 1772738576 11783248 21936352
14:05:04 6723 8192000000 10685569376 11063689216 1744312272 17.554 100 75 150 1 1778162928 12634224 21216432
14:05:19 5047 8192000000 10691533616 11072225280 1757317424 17.662 100 78 156 1 1793023456 14060704 21645328
14:05:31 5212 8192000000 10702862448 11081125888 1759359200 17.679 100 80 160 0 1796143120 13825728 22958192
14:05:43 10488 8192000000 10713096272 11094024192 1769870752 17.766 100 77 154 1 1804698944 13553456 21274736
14:06:03 4694 8192000000 10720604160 11104034816 1778164912 17.834 100 75 148 4 1812085808 13600800 20320096
14:06:14 4380 8192000000 10740712544 11125403648 1798262816 18.000 100 72 144 0 1831367632 13080288 20024528
14:06:25 3701 8192000000 10751663520 11135893504 1815703136 18.143 100 88 174 3 1853552288 12995024 24854128
14:06:36 3442 8192000000 10756507680 11148673024 1817857568 18.160 100 84 168 0 1855663296 13651120 24154608
14:06:46 3293 8192000000 10766368352 11151269888 1826186352 18.228 100 83 168 1 1864034928 13920400 23928176
14:06:56 2602 8192000000 10775574816 11163635712 1833704032 18.290 100 82 157 1 1869616144 13660912 22251200
14:07:05 2377 8192000000 10787841920 11175145472 1841235008 18.351 100 90 180 0 1879839456 13617232 24987216
14:07:14 1942 8192000000 10780855152 11174572032 1845346544 18.384 100 88 176 2 1883129152 13791328 23991280
14:07:22 1485 8192000000 10795831488 11178926080 1847908752 18.405 100 92 185 2 1887942608 14116448 25917408
14:07:30 1852 8192000000 10799780896 11187638272 1854344176 18.457 100 89 179 2 1894099792 14884128 24871488
14:07:39 1261 8192000000 10801067248 11187339264 1857621536 18.484 100 96 194 0 1897744432 13576160 26546736
14:07:46 1401 8192000000 10805738112 11193274368 1862225280 18.521 100 98 196 0 1903809872 14403104 27181488
14:07:54 1468 8192000000 10812452848 11198132224 1867883376 18.567 100 91 184 2 1907706048 13399952 26422720
14:08:01 1326 8192000000 10814670400 11202674688 1869778640 18.582 100 93 186 1 1909810304 13725120 26306544
14:08:09 32218 8192000000 10786602560 11199057920 1861944352 18.519 100 62 124 3 1891015984 11624816 17446816
14:08:48 2155 8192000000 10796822704 11199770624 1865784416 18.550 100 68 129 1 1895408144 9945904 19677824
14:08:57 2732 8192000000 10806288320 11206189056 1868811872 18.575 100 62 124 1 1894963744 9556080 16595792
14:09:06 3813 8192000000 10787291248 11205267456 1870301504 18.587 100 46 92 2 1893397664 10548320 12547840
14:09:18 4694 8192000000 10797153968 11211120640 1874486784 18.621 100 40 79 0 1893335696 8466464 10382448
14:09:30 6441 8192000000 10795688736 11214794752 1876526400 18.637 100 43 85 6 1896255232 7989728 11739104
14:09:44 5479 8192000000 10795123392 11213561856 1878445488 18.653 100 32 63 2 1895470480 7984048 9040944
14:09:57 9252 8192000000 10787300816 11216650240 1877854112 18.648 100 17 34 0 1889130688 6804416 4472160
14:10:13 10108 8192000000 10781587472 11218370560 1882682752 18.687 100 28 56 1 1897533872 6680864 8170256
14:10:32 8528 8192000000 10788887392 11220668416 1883059712 18.690 100 18 36 2 1893223904 5558496 4605696
14:10:48 10674 8192000000 10786860064 11221536768 1881241776 18.675 100 11 22 1 1890629200 6140624 3246800
14:11:11 9988 8192000000 10794956080 11231985664 1889795136 18.744 100 24 48 0 1903419184 5945696 7678352
14:11:30 15091 8192000000 10813524400 11234516992 1898637792 18.815 100 47 97 1 1919013024 5701728 14673504
14:11:51 66664 8192000000 10812291392 11244679168 1895628880 18.791 100 28 56 0 1909809584 6234320 7946384
14:13:05 7382 8192000000 10810510864 11249352704 1896641104 18.799 100 16 30 3 1911285184 10117056 4527024
14:13:22 8255 8192000000 10814070784 11250155520 1902486432 18.846 100 22 44 2 1913866464 5555040 5824992
14:13:37 4718 8192000000 10827109920 11254796288 1907372640 18.886 100 40 81 1 1926765568 8318608 11074320
14:13:48 4635 8192000000 10827804608 11252748288 1905386176 18.870 100 40 81 0 1923843824 7089440 11368208
14:14:01 8185 8192000000 10823408176 11256623104 1903565712 18.855 100 30 58 0 1919657696 8040800 8051184
14:14:18 11437 8192000000 10823892992 11260231680 1906218368 18.876 100 22 43 1 1918687344 5894320 6574656
14:14:38 9733 8192000000 10833527376 11263602688 1913386208 18.934 100 23 45 1 1924720496 5401264 5933024
14:14:55 12012 8192000000 10821837040 11260887040 1911026512 18.915 100 19 38 3 1921694368 5437632 5230224
14:15:14 7081 8192000000 10832355872 11264069632 1915171104 18.948 100 27 55 2 1927916400 5140288 7605008
14:15:27 4896 8192000000 10819843168 11264888832 1916229056 18.957 100 24 49 0 1929802112 5744352 7828704
14:15:40 8902 8192000000 10828946128 11263361024 1897924544 18.810 99 29 57 2 1913417248 6507280 8985424
14:15:55 10362 8192000000 10823533072 11257110528 1874459376 18.620 98 16 31 0 1884659504 5899456 4300672
14:16:18 57114 8192000000 10823790448 11255508992 1896733408 18.800 99 43 87 2 1915098944 6147360 12218176
14:17:23 10616 8192000000 10828587520 11262550016 1907243840 18.885 100 19 38 1 1918105600 5337744 5524016
14:17:43 8584 8192000000 10792746544 11231010816 1868584160 18.573 99 13 26 0 1877207504 4805712 3817632
14:17:58 6492 8192000000 10806954336 11234603008 1884490592 18.701 100 35 70 1 1902177728 7527376 10159760
14:18:14 5402 8192000000 10800732848 11228438528 1872235552 18.602 99 32 64 1 1887985968 6713568 9036848
14:18:27 8272 8192000000 10762495648 11184418816 1758776240 17.674 94 22 43 1 1770368368 5448784 6143344
14:18:43 4996 8192000000 10745718944 11165675520 1806306048 18.066 98 29 60 1 1820378688 5931104 8141536
14:18:59 8927 8192000000 10749037072 11171414016 1835056160 18.301 100 23 46 2 1847694256 6682656 5955440
14:19:15 8356 8192000000 10731414656 11149348864 1762254432 17.703 96 21 42 1 1773204288 5290272 5659584
14:19:31 10264 8192000000 10708702592 11130441728 1707573824 17.248 94 22 44 3 1719244688 5534176 6136688
14:19:51 13099 8192000000 10687870112 11113005056 1706546112 17.240 95 27 53 3 1719935024 6064640 7324272
14:20:10 3999 8192000000 10707305760 11126431744 1794724928 17.971 100 24 48 0 1807445376 6138112 6582336
14:20:21 12582 8192000000 10709553488 11131686912 1750181200 17.603 97 32 63 1 1764485232 5751008 8553024
14:20:40 68240 8192000000 10710044160 11125727232 1718019616 17.336 95 46 92 1 1737465776 4952096 14494064
14:21:57 8429 8192000000 10687425840 11101810688 1733195680 17.462 97 22 44 0 1749035776 9831120 6008976
14:22:12 8088 8192000000 10715553152 11121881088 1776021328 17.817 99 34 68 1 1792555248 7340864 9193056
14:22:27 3024 8192000000 10723867120 11131768832 1802655136 18.036 100 43 85 1 1823230992 8573376 12002480
14:22:37 3558 8192000000 10715931424 11139366912 1805191120 18.056 100 30 60 0 1820639920 6207600 9241200
14:22:47 5822 8192000000 10727511840 11142770688 1795532752 17.977 99 26 50 3 1809478256 5968032 7977472
14:22:59 6715 8192000000 10739007056 11146231808 1794758080 17.971 99 30 60 0 1813792544 10594000 8440464
14:23:15 5541 8192000000 10744367872 11162824704 1819929168 18.177 100 28 56 1 1838729744 11427824 7372752
14:23:30 6211 8192000000 10753562128 11171721216 1833996736 18.292 100 24 44 2 1846783728 5528016 7258976
14:23:45 13377 8192000000 10752658784 11176730624 1839290336 18.335 100 15 30 0 1849382720 5471312 4621072
14:24:06 10751 8192000000 10762164032 11188281344 1847428368 18.401 100 18 36 1 1858188848 5801616 4958864
14:24:27 6395 8192000000 10784466832 11195764736 1852850576 18.445 100 40 80 0 1869798992 5093392 11855024
14:24:40 5877 8192000000 10769159344 11190583296 1852994144 18.446 100 27 54 2 1866647200 5676768 7976288
14:24:52 10248 8192000000 10774334192 11200921600 1849340640 18.417 100 14 28 1 1862984304 9666464 3977200
14:25:08 13518 8192000000 10767919360 11192504320 1854017456 18.455 100 27 54 2 1868204176 5331904 8854816
14:25:28 69339 8192000000 10762409712 11195342848 1856599712 18.476 100 35 66 2 1872247296 5440816 10206768
14:26:44 11780 8192000000 10769572352 11196747776 1858506288 18.491 100 23 46 0 1870778928 5254368 7018272
14:27:02 9905 8192000000 10779993904 11207258112 1866763072 18.558 100 24 48 2 1878578304 5648384 6166848
14:27:20 9969 8192000000 10810127728 11221340160 1883174400 18.691 100 38 76 2 1899425696 6363328 9887968
14:27:38 12460 8192000000 10830599040 11244314624 1893352608 18.773 100 51 102 1 1916052368 7784176 14915584
14:28:01 9432 8192000000 10844273840 11253956608 1901912400 18.842 100 58 116 1 1927135024 9013360 16209264
14:28:18 3178 8192000000 10849691216 11257192448 1907631056 18.888 100 58 116 2 1934508992 10572416 16305520
14:28:29 24097 8192000000 10850167152 11265581056 1908752432 18.897 100 55 110 0 1938583456 14414304 15416720
14:29:03 10059 8192000000 10864931504 11274760192 1917372640 18.966 100 54 106 1 1941847312 8792736 15681936
14:29:20 20840 8192000000 10863647600 11282837504 1926437072 19.038 100 55 110 0 1954823472 12928096 15458304
14:29:48 13712 8192000000 10858865680 11281006592 1928668240 19.056 100 51 103 1 1952878128 9309984 14899904
14:30:19 29601 8192000000 10857967920 11288293376 1932792832 19.089 100 43 86 0 1956010816 10685248 12532736
14:30:56 14495 8192000000 10853141792 11294527488 1934118528 19.100 100 32 64 1 1956368160 12720208 9529424
14:31:58 7243 8192000000 10879352288 11300380672 1942403424 19.166 100 57 109 2 1967573424 9836208 15333792
14:32:32 17025 8192000000 10883781104 11312533504 1948652112 19.216 100 50 99 2 1974972624 12298608 14021904
14:32:58 9914 8192000000 10886473600 11320537088 1955469264 19.270 100 49 95 1 1983407392 14051936 13886192
14:33:19 14293 8192000000 10894507696 11324682240 1959392480 19.301 100 50 95 1 1987054096 14126640 13534976
14:33:47 13108 8192000000 10903302960 11335249920 1964808208 19.344 100 43 86 0 1989959360 12481392 12669760
14:34:08 10372 8192000000 10921202976 11346051072 1975502448 19.429 100 59 118 0 2009146880 15407792 18236640
14:34:27 6984 8192000000 10893334576 11313594368 1946474224 19.198 99 69 138 1 1983048416 16377520 20196672
14:34:45 14876 8192000000 10901094000 11334598656 1963684144 19.335 100 48 95 0 1994592864 17417248 13491472
14:35:19 6549 8192000000 10909856352 11342671872 1970022800 19.386 100 52 104 1 2003485408 18134992 15327616
14:35:36 18432 8192000000 10921754240 11351764992 1979706976 19.462 100 47 94 0 2011827968 18172224 13948768
14:36:21 8503 8192000000 10927829936 11359432704 1980442864 19.468 100 48 96 3 2016225184 21469296 14313024
14:36:37 28994 8192000000 10935849120 11370180608 1986458096 19.516 100 41 81 1 2021122416 21980128 12684192
14:37:23 6254 8192000000 10954666176 11379367936 1994414000 19.579 100 63 126 1 2038558112 26193472 17950640
14:37:38 11100 8192000000 10954696848 11378216960 1988660448 19.533 100 65 130 1 2034997360 27556704 18780208
14:38:15 4584 8192000000 10958055632 11386753024 1998750048 19.613 100 63 126 0 2047069344 29591792 18727504
14:38:41 7582 8192000000 10957547488 11394023424 1999383056 19.618 100 51 102 1 2047202672 31856336 15963280
14:38:58 4259 8192000000 10972837568 11399467008 2009333152 19.696 100 76 151 2 2062395376 30746080 22316144
14:39:10 6664 8192000000 10951887136 11378728960 1992492928 19.563 99 78 155 1 2046944080 31743552 22707600
14:39:24 5755 8192000000 10972062720 11394215936 2005996304 19.670 100 59 118 1 2055562448 32106192 17459952
14:39:38 2862 8192000000 10978374128 11403616256 2012056688 19.718 100 61 121 0 2061794048 31466624 18270736
14:39:54 6892 8192000000 10965959248 11398680576 1992029280 19.560 99 58 116 2 2041870800 32379088 17462432
14:40:09 5286 8192000000 10959523216 11385339904 1993748192 19.573 100 62 124 2 2043048832 30614144 18686496
14:40:21 4845 8192000000 10949712352 11381563392 1990625392 19.549 100 63 125 0 2041538592 31548448 19364752
14:40:32 6133 8192000000 10965030192 11393511424 2002858192 19.645 100 63 122 2 2053838864 31840848 19139824
14:40:46 9342 8192000000 10963635056 11390554112 1987491392 19.524 99 59 117 0 2037109440 31397616 18220432
14:41:02 1078 8192000000 10966848016 11384569856 1981035216 19.473 99 77 147 4 2035676736 32665408 21976112
14:41:10 5100 8192000000 10969690576 11394416640 2003984896 19.654 100 69 138 1 2058117776 33568336 20564544
14:41:24 3669 8192000000 10955915952 11383717888 1979036832 19.457 99 63 124 1 2031537824 32979440 19521552
14:41:34 2317 8192000000 10973728480 11388882944 1998203760 19.609 100 82 164 0 2056663840 34032736 24427344
14:41:44 1949 8192000000 10975944304 11395739648 1999575472 19.619 100 79 158 0 2059788064 35288352 24924240
14:41:53 3303 8192000000 10976153792 11396816896 2000227456 19.625 100 80 160 1 2063375568 37917520 25230592
14:42:04 5290 8192000000 10976144848 11396055040 2000666544 19.628 100 74 147 0 2062275664 38580688 23028432
14:42:19 5113 8192000000 10963012064 11393052672 1998302592 19.609 100 69 138 3 2057557952 37288752 21966608
14:42:34 8783 8192000000 10953991552 11386568704 1990716128 19.549 100 67 130 0 2051606992 39920624 20970240
14:42:51 6329 8192000000 10962278528 11396358144 1992933200 19.567 100 59 118 3 2049074208 36880960 19260048
14:43:06 2735 8192000000 10990828224 11405533184 2006798400 19.676 100 78 156 0 2067976080 36604496 24573184
14:43:15 5559 8192000000 10990575728 11410620416 1995622128 19.588 99 85 170 0 2061472352 39158848 26691376
14:43:29 4021 8192000000 10979735776 11406876672 2002170960 19.640 100 70 138 2 2064291616 40020832 22099824
14:43:49 2317 8192000000 10972105760 11384635392 1986192192 19.514 99 74 145 1 2047649232 38344816 23112224
14:44:00 6061 8192000000 10973767712 11401117696 2000469824 19.626 100 68 135 1 2062159664 40434224 21255616
14:44:17 4798 8192000000 10953989776 11389112320 1971336304 19.396 99 45 89 0 2025209392 38989616 14883472
14:44:29 1838 8192000000 10963682608 11391348736 1987996864 19.528 100 81 159 1 2052010592 39308224 24705504
14:44:39 3260 8192000000 10956960064 11376910336 1980076784 19.465 100 73 144 1 2044137504 41072592 22988128
14:44:49 4366 8192000000 10948014192 11371335680 1948109328 19.211 98 69 138 1 2007629312 37693888 21826096
14:45:09 3095 8192000000 10929068080 11339886592 1945975088 19.194 100 80 160 1 2011359216 39920384 25463744
14:45:20 1338 8192000000 10933777264 11344248832 1953007808 19.250 100 87 173 0 2020942544 40700496 27234240
14:45:28 1899 8192000000 10953174880 11368071168 1965767632 19.352 100 77 154 1 2035695376 43971168 25956576
14:45:37 3718 8192000000 10945977840 11362250752 1960432928 19.309 100 73 146 1 2028715344 44798752 23483664
14:45:48 6367 8192000000 10946036128 11364028416 1965062208 19.346 100 73 145 0 2031934544 43612640 23259696
14:46:03 3273 8192000000 10974286336 11386548224 1983112864 19.489 100 88 176 0 2053268448 43143520 27012064
14:46:16 2506 8192000000 10958087920 11371720704 1968974720 19.377 100 75 149 1 2041203824 48416496 23812608
14:46:25 3341 8192000000 10958778528 11369824256 1967798160 19.368 100 82 164 3 2038705184 45458144 25448880
14:46:35 2642 8192000000 10957943536 11363176448 1964582960 19.342 100 92 184 1 2040467104 47064400 28819744
14:46:45 2997 8192000000 10940399552 11350355968 1938949664 19.138 99 88 176 0 2015740016 49157808 27632544
14:46:55 5626 8192000000 10943378560 11367583744 1960663904 19.311 100 66 132 3 2032398016 50346480 21387632
14:47:15 6331 8192000000 10949282976 11367346176 1955072896 19.267 99 67 135 6 2025974752 49410944 21490912
14:47:28 3737 8192000000 10967242416 11389992960 1982804304 19.487 100 74 148 0 2055729728 48863152 24062272
14:47:40 10094 8192000000 10934805440 11385012224 1974444144 19.421 100 42 84 0 2033107600 44553760 14109696
14:47:58 8309 8192000000 10937837968 11369885696 1953620288 19.255 99 38 76 0 2002958448 37066464 12271696
14:48:16 6755 8192000000 10959297280 11381927936 1980969168 19.472 100 76 152 0 2041048224 36662432 23416624
14:48:30 3697 8192000000 10966917296 11379003392 1978121216 19.450 100 84 164 1 2043681808 39447408 26113184
14:48:40 1743 8192000000 10972176880 11382706176 1962331248 19.325 99 88 175 5 2033513168 43513600 27668320
14:48:48 1379 8192000000 10984215328 11395497984 1985555408 19.509 100 78 156 0 2055492912 45435072 24502432
14:48:59 8770 8192000000 10960974224 11388510208 1967868208 19.369 99 70 140 1 2037974528 46994864 23111456
14:49:29 8104 8192000000 10954349216 11393605632 1980550944 19.469 100 52 104 0 2045694832 47411200 17732688
14:49:54 11537 8192000000 10955157008 11402133504 1979286432 19.459 100 49 97 4 2048336848 51873920 17176496
14:50:14 7916 8192000000 10961320208 11405099008 1984462544 19.500 100 43 86 3 2048843952 50090272 14291136
14:50:51 8704 8192000000 10946445408 11385327616 1968613728 19.374 100 37 74 1 2027208864 45627312 12967824
14:51:09 7558 8192000000 10938856176 11377012736 1961904784 19.321 100 48 96 2 2026380448 47900576 16575088
14:51:29 8032 8192000000 10943578640 11382583296 1960411104 19.309 100 42 84 3 2025965856 51323696 14231056
14:51:44 21612 8192000000 10920712560 11375927296 1932338976 19.086 99 37 74 2 2000982016 55425536 13217504
14:52:13 20147 8192000000 10889244464 11340677120 1925283280 19.029 100 34 68 0 1983773376 46379648 12110448
14:52:43 19318 8192000000 10879024896 11336949760 1921491072 18.999 100 25 50 0 1970723360 40204336 9027952
14:53:09 14804 8192000000 10879464880 11336081408 1920410512 18.990 100 19 38 5 1962575072 35431536 6733024
14:53:30 26122 8192000000 10864273632 11325480960 1880994912 18.673 98 17 34 1 1928541568 41220880 6325776
14:54:03 52638 8192000000 10857920448 11321556992 1855451968 18.466 97 18 36 1 1908185664 45915936 6817760
14:55:05 31954 8192000000 10854794656 11289526272 1868009376 18.568 98 10 18 0 1879861424 9483376 2368672
14:55:43 17010 8192000000 10862999552 11303600128 1918464560 18.975 100 27 54 0 1935297728 9053312 7779856
14:56:18 20938 8192000000 10875799152 11308318720 1928570256 19.055 100 50 102 1 1951995744 9461664 13963824
14:56:49 33906 8192000000 10874266768 11324215296 1936538656 19.119 100 57 115 0 1964989856 12471440 15979760
14:57:40 58286 8192000000 10870697632 11331567616 1941469168 19.158 100 24 44 2 1959575232 11903616 6202448
14:58:47 31262 8192000000 10885243376 11337302016 1951276960 19.237 100 39 75 2 1970453904 8836880 10340064
14:59:26 60353 8192000000 10874725696 11341828096 1942798656 19.169 99 13 26 2 1959930816 13649856 3482304
15:00:36 13378 8192000000 10870340048 11334893568 1927668976 19.048 99 6 12 0 1946689424 17652512 1367936
15:00:55 7376 8192000000 10867691376 11339833344 1944612128 19.184 100 6 11 1 1965383456 18791504 1979824
15:01:11 56327 8192000000 10856233136 11303010304 1867786384 18.566 96 10 21 0 1882197664 11914080 2497200
15:03:01 69173 8192000000 10875716768 11337940992 1942449248 19.166 100 11 22 2 1961204288 15933984 2821056
15:04:18 117145 8192000000 10878464624 11338354688 1920011328 18.987 98 25 50 0 1938487088 11189024 7286736
15:06:36 66831 8192000000 10870295200 11330740224 1918678208 18.976 98 24 49 1 1937455232 11453056 7323968
15:07:49 30695 8192000000 10897790688 11356438528 1967046768 19.362 100 31 62 1 1989284352 12864464 9373120
15:08:35 52255 8192000000 10901051664 11365347328 1970883504 19.392 100 33 67 1 1993121696 12088448 10149744
15:09:38 31744 8192000000 10910405168 11368370176 1973992912 19.417 100 30 61 0 1998771808 15351904 9426992
15:10:16 58541 8192000000 10923907968 11389403136 1978662304 19.454 100 31 60 1 2010290640 21738256 9890080
15:12:48 74925 8192000000 10898240784 11390492672 1969554816 19.382 100 6 12 0 2001571504 29338560 2678128
15:14:10 30385 8192000000 10881359856 11360538624 1945878304 19.194 99 11 22 1 1963559520 14603792 3077424
15:14:53 112135 8192000000 10917868448 11379855360 1959871664 19.305 99 14 28 0 1973060592 9548896 3640032
15:16:52 20837 8192000000 10938423488 11386818560 1996015568 19.591 100 48 95 1 2018523680 9768544 12739568
15:18:14 86412 8192000000 10911814176 11384651776 1972462448 19.405 99 11 22 0 1985284400 9852464 2969488
15:19:47 38535 8192000000 10925968000 11392487424 1981825616 19.479 99 38 76 3 2006549920 12935712 11788592
15:20:32 87598 8192000000 10923300048 11402973184 1972846000 19.408 99 5 10 0 1987604048 13684624 1073424
15:22:06 136956 8192000000 10919866224 11397517312 1941618672 19.160 97 11 22 1 1954938832 10350864 2969296
15:24:30 93374 8192000000 10912912720 11365801984 1919493728 18.983 96 23 47 1 1938040352 11762064 6784560
15:26:11 26256 8192000000 10922875952 11375136768 1963787408 19.336 99 29 58 0 1979470016 7969328 7713280
15:26:44 20675 8192000000 10937069904 11390271488 1988891072 19.535 100 48 94 0 2013796080 11516944 13388064
15:27:17 109572 8192000000 10911043152 11363475456 1929044736 19.059 97 36 70 1 1947980816 9124800 9811280
15:29:21 90679 8192000000 10890567104 11366248448 1927209824 19.045 97 21 40 3 1941970224 8524304 6236096
15:30:58 1334 8192000000 10875137600 11327696896 1940552608 19.151 99 35 69 1 1956828064 7039184 9236272
15:31:06 18586 8192000000 10878017376 11335700480 1934301632 19.101 99 30 60 0 1951768576 9147584 8319360
15:31:32 66954 8192000000 10861620560 11341316096 1934591984 19.104 99 17 34 2 1952137616 12343088 5202544
15:33:21 69310 8192000000 10879090480 11341717504 1922620976 19.008 98 20 40 0 1942927072 14806880 5499216
15:34:37 61368 8192000000 10886024240 11356852224 1940501552 19.151 99 15 30 0 1958780112 14173888 4104672
15:35:44 71647 8192000000 10871987488 11346960384 1891488272 18.758 96 14 26 1 1911110000 15802016 3819712
15:37:05 55587 8192000000 10866145504 11342053376 1861945776 18.519 95 22 44 0 1888081328 18696944 7438608
15:38:10 48486 8192000000 10882397536 11343720448 1895986832 18.794 97 18 36 1 1913822928 12571920 5264176
15:39:15 61795 8192000000 10844401744 11301769216 1820771440 18.184 94 20 40 1 1833841968 7696480 5374048
15:40:24 67849 8192000000 10835953584 11296497664 1830861440 18.266 95 34 67 1 1850170816 9284288 10025088
15:41:50 75214 8192000000 10870144448 11319705600 1835640544 18.305 95 33 66 1 1856821072 12404560 8775968
15:43:14 38280 8192000000 10880972544 11331649536 1927224528 19.045 100 41 82 0 1960226384 21372400 11629456
15:44:29 77888 8192000000 10863749728 11339558912 1909129040 18.900 99 13 26 1 1936946480 24145760 3671680
15:46:12 79761 8192000000 10872292704 11344310272 1919066576 18.979 99 17 34 2 1937853632 14183328 4603728
15:47:38 56193 8192000000 10877346192 11332370432 1906330592 18.877 98 25 50 0 1929236800 15495456 7410752
15:48:42 50040 8192000000 10885734864 11343847424 1949903424 19.226 100 43 86 0 1973543648 11981376 11658848
15:49:39 104047 8192000000 10872829488 11351584768 1915853200 18.954 98 25 50 0 1939684368 16611856 7219312
15:53:10 51406 8192000000 10864888512 11344097280 1945406384 19.190 100 10 20 0 1960357696 12195440 2755872
15:54:11 48170 8192000000 10861509280 11341881344 1927784128 19.049 99 10 20 0 1945113872 14172384 3157360
15:55:39 59178 8192000000 10859719888 11334635520 1910294240 18.909 98 14 30 1 1926447968 12201712 3952016
15:56:57 56360 8192000000 10829194432 11309694976 1868565136 18.573 97 7 14 1 1886252000 15604048 2082816
15:58:06 53022 8192000000 10833436752 11313074176 1865424224 18.547 97 9 18 2 1878642864 11017680 2200960
15:59:09 39369 8192000000 10841035168 11312373760 1907989552 18.891 99 12 22 1 1922534496 11417376 3127568
15:59:57 91089 8192000000 10878938000 11351703552 1938633504 19.136 99 16 32 0 1955464496 12418944 4412048
16:01:57 46554 8192000000 10885695504 11348230144 1923860896 19.018 98 17 34 0 1943409520 14929744 4618880
16:02:54 53211 8192000000 10889243744 11361013760 1937299472 19.125 99 20 40 0 1959176992 16220560 5656960
16:03:59 65732 8192000000 10896627584 11369390080 1940314848 19.149 99 17 33 0 1964122848 18841216 4966784
16:05:12 68077 8192000000 10901349456 11374768128 1939764528 19.145 99 31 62 0 1969354528 21082624 8507376
16:06:30 52296 8192000000 10899961328 11372802048 1947635488 19.208 99 24 48 2 1968501760 14226384 6639888
16:07:28 32232 8192000000 10916804320 11372920832 1974400080 19.420 100 25 50 2 1989514672 8159584 6955008
16:08:06 76199 8192000000 10925881248 11385012224 1965300256 19.348 99 27 52 4 1982638192 10353216 6984720
16:09:32 23670 8192000000 10941202384 11397468160 1992740080 19.565 100 34 68 1 2012215408 10222912 9252416
16:10:05 123477 8192000000 10931124512 11409911808 1956858976 19.281 98 31 62 0 1990264416 25216560 8188880
16:12:55 66518 8192000000 10909942112 11392520192 1992394784 19.563 100 25 50 1 2006810096 7708928 6706384
16:14:08 33138 8192000000 10913959552 11394715648 1995138608 19.584 100 22 44 0 2010453296 8609936 6704752
16:15:01 43195 8192000000 10895530176 11383341056 1970655056 19.391 99 9 18 0 1981747344 8756544 2335744
16:15:54 79415 8192000000 10908484512 11394785280 1975170880 19.426 99 15 30 0 1988392528 8948128 4273520
16:17:35 39459 8192000000 10915412080 11402526720 1997831440 19.606 100 15 30 0 2014504784 12014912 4658432
16:18:22 136311 8192000000 10893248656 11370754048 1916566800 18.959 96 12 24 0 1935103504 14998320 3538384
16:20:53 43083 8192000000 10901917984 11371610112 1958821456 19.297 99 22 44 0 1972043968 7385984 5836528
16:21:49 75136 8192000000 10872785120 11341271040 1885105008 18.706 95 22 44 1 1903445648 12489248 5851392
16:23:11 88101 8192000000 10841241552 11315286016 1783907216 17.882 91 10 20 0 1798448240 11794896 2746128
16:24:52 43896 8192000000 10876429888 11330605056 1885319248 18.708 97 28 57 1 1900600224 7316048 7964928
16:25:44 18610 8192000000 10839672032 11293683712 1876788928 18.639 98 44 88 1 1898980560 10456160 11735472
16:26:12 73003 8192000000 9594866032 9921560576 691834752 7.787 37 13 26 0 701354560 5789632 3730176

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 07-02-2021 16:28:19 to 07-02-2021 16:28:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 89 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 07-02-2021 16:28:51 to 07-02-2021 16:28:53.

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          233282
MON$OLDEST_ACTIVE               234270
MON$OLDEST_SNAPSHOT             234270
MON$NEXT_TRANSACTION            234270
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                       2016064
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
--- end of diff output ---

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

07.02.21 16:28:54. 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-02-07 16:28:56 No severe PSQL-related problems occured
07.02.21 16:28:58. End of report.