Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.02.2021 01: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 17080964 kB
MemAvailable 31118808 kB
Buffers 0 kB
Cached 14609608 kB
SwapCached 3892 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-23 01:27:16
DTS_END                         2021-02-23 01:27:16.9750
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_TO_SUPPLIER(26:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/37018
TRN_ID                          247403
ATT_ID                          715
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: 9178.89 20102 1101467
customer order: creation 182.53 349 21904
customer order: refuse 14.97 344 1796
order to supplier: creation 46.88 1372 5626
order to supplier: removal 3.46 93472 415
invoice (draft): creation 48.31 3357 5797
invoice (draft): removal 51.00 794 6120
invoice accept: apply 42.83 19142 5140
invoice accept: cancel 45.77 886 5492
customer reserve: creation 3916.14 192 469937
customer reserve: removal 4527.52 56 543303
realization accept: apply 87.89 180 10547
realization accept: cancel 75.03 109 9004
payment from customer: creation 62.57 103 7508
payment from customer: removal 6.23 75 748
payment to supplier: creation 51.11 136 6133
payment to supplier: removal 3.48 86 418
service: total inventory turnovers 5.48 917 658
service: total monetary turnovers 6.72 23 806
service: aggregate perf. data 0.93 18590 111
service: refresh index statistics 0.03 261852 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 23-02-2021 01:28:23 to 23-02-2021 01:28:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4271
TEST_TIME 2 4437
TEST_TIME 3 4798
TEST_TIME 4 5102
TEST_TIME 5 5177
TEST_TIME 6 5230
TEST_TIME 7 5379
TEST_TIME 8 5558
TEST_TIME 9 5941
TEST_TIME 10 5932
TEST_TIME 11 5997
TEST_TIME 12 6083
TEST_TIME 13 6535
TEST_TIME 14 6855
TEST_TIME 15 7106
TEST_TIME 16 7163
TEST_TIME 17 7261
TEST_TIME 18 7579
TEST_TIME 19 7805
TEST_TIME 20 8661
TEST_TIME 21 9344
TEST_TIME 22 9523
TEST_TIME 23 9701
TEST_TIME 24 9800
TEST_TIME 25 9852
TEST_TIME 26 10577
TEST_TIME 27 10543
TEST_TIME 28 10590
TEST_TIME 29 10748
TEST_TIME 30 10487
TEST_TIME 31 10489
TEST_TIME 32 10321
TEST_TIME 33 10343
TEST_TIME 34 10179
TEST_TIME 35 10034
TEST_TIME 36 10046
TEST_TIME 37 9984
TEST_TIME 38 9841
TEST_TIME 39 9918
TEST_TIME 40 10068
TEST_TIME 41 10016
TEST_TIME 42 9895
TEST_TIME 43 9814
TEST_TIME 44 9987
TEST_TIME 45 9850
TEST_TIME 46 9921
TEST_TIME 47 9973
TEST_TIME 48 9908
TEST_TIME 49 9937
TEST_TIME 50 9889
TEST_TIME 51 9829
TEST_TIME 52 9919
TEST_TIME 53 9875
TEST_TIME 54 9875
TEST_TIME 55 9813
TEST_TIME 56 9908
TEST_TIME 57 9936
TEST_TIME 58 9827
TEST_TIME 59 9716
TEST_TIME 60 9700
TEST_TIME 61 9661
TEST_TIME 62 9610
TEST_TIME 63 9646
TEST_TIME 64 9522
TEST_TIME 65 9469
TEST_TIME 66 9543
TEST_TIME 67 9520
TEST_TIME 68 9516
TEST_TIME 69 9527
TEST_TIME 70 9511
TEST_TIME 71 9530
TEST_TIME 72 9506
TEST_TIME 73 9496
TEST_TIME 74 9542
TEST_TIME 75 9507
TEST_TIME 76 9658
TEST_TIME 77 9654
TEST_TIME 78 9640
TEST_TIME 79 9679
TEST_TIME 80 9702
TEST_TIME 81 9592
TEST_TIME 82 9516
TEST_TIME 83 9500
TEST_TIME 84 9520
TEST_TIME 85 9446
TEST_TIME 86 9445
TEST_TIME 87 9398
TEST_TIME 88 9396
TEST_TIME 89 9379
TEST_TIME 90 9337
TEST_TIME 91 9391
TEST_TIME 92 9417
TEST_TIME 93 9417
TEST_TIME 94 9420
TEST_TIME 95 9442
TEST_TIME 96 9458
TEST_TIME 97 9487
TEST_TIME 98 9470
TEST_TIME 99 9448
TEST_TIME 100 9483
TEST_TIME 101 9460
TEST_TIME 102 9528
TEST_TIME 103 9502
TEST_TIME 104 9445
TEST_TIME 105 9418
TEST_TIME 106 9357
TEST_TIME 107 9350
TEST_TIME 108 9332
TEST_TIME 109 9332
TEST_TIME 110 9302
TEST_TIME 111 9274
TEST_TIME 112 9273
TEST_TIME 113 9246
TEST_TIME 114 9212
TEST_TIME 115 9234
TEST_TIME 116 9227
TEST_TIME 117 9224
TEST_TIME 118 9205
TEST_TIME 119 9219
TEST_TIME 120 9183

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 23-02-2021 01:28:26 to 23-02-2021 01:28:30.

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 1536970 1536970 0 0.00 0 14717 7 0 0
doc_list_biud 1536969 1536969 0 0.00 0 21926 26 0 0
sp_add_invoice_to_stock 5275 5140 135 2.55 51 193147 19143 0 135
sp_cancel_adding_invoice 5492 5492 0 0.00 5 61172 886 0 0
sp_cancel_client_order 1796 1796 0 0.00 5 17926 344 0 0
sp_cancel_customer_reserve 543303 543303 0 0.00 1 21803 56 0 0
sp_cancel_pay_from_customer 748 748 0 0.00 3 4979 75 0 0
sp_cancel_pay_to_supplier 418 418 0 0.00 2 5990 86 0 0
sp_cancel_supplier_invoice 6128 6120 8 0.13 2 18492 795 0 8
sp_cancel_supplier_order 415 415 0 0.00 9 1096168 93472 0 0
sp_cancel_write_off 9004 9004 0 0.00 1 9550 110 0 0
sp_client_order 21904 21904 0 0.00 3 26762 350 0 0
sp_customer_reserve 469937 469937 0 0.00 0 111110 193 0 0
sp_fill_shopping_cart 33309 33309 0 0.00 1 26875 44 0 0
sp_fill_shopping_cart_clo_res 469926 469926 0 0.00 0 11032 12 0 0
sp_get_clo_for_invoice 5129 5129 0 0.00 0 17252 257 0 0
sp_kill_cost_storno 15662 15662 0 0.00 0 9536 58 0 0
sp_kill_qstorno_ret_qs2qd 1102145 1102145 0 0.00 0 21800 30 0 0
sp_kill_qty_storno 581805 581805 0 0.00 0 21925 67 0 0
sp_lock_selected_doc 21625 21625 0 0.00 0 6726 5 0 0
sp_make_cost_storno 29317 29317 0 0.00 0 14715 55 0 0
sp_multiply_rows_for_pdistr 29317 29317 0 0.00 0 9817 27 0 0
sp_multiply_rows_for_qdistr 21904 21904 0 0.00 0 14557 152 0 0
sp_pay_from_customer 7508 7508 0 0.00 4 17463 103 0 0
sp_pay_to_supplier 6133 6133 0 0.00 5 17992 137 0 0
sp_payment_common 13641 13641 0 0.00 1 11328 28 0 0
sp_qd_handle_on_cancel_clo 1796 1796 0 0.00 0 17904 303 0 0
sp_qd_handle_on_invoice_upd_sts 10620 10620 0 0.00 0 21923 343 0 0
sp_qd_handle_on_reserve_upd_sts 10547 10547 0 0.00 0 15852 61 0 0
sp_reserve_write_off 10547 10547 0 0.00 6 20165 180 0 0
sp_supplier_invoice 5797 5797 0 0.00 6 89102 3357 0 0
sp_supplier_order 5626 5626 0 0.00 5 31827 1373 0 0
srv_aggregate_perf_data 112 111 1 0.89 2567 143935 18590 0 1
srv_fill_mon_cache_memory 168 168 0 0.00 963 108967 30694 0 0
srv_find_qd_qs_mism 1051999 1051999 0 0.00 0 14364 7 0 0
srv_make_invnt_saldo 658 658 0 0.00 26 54101 917 0 0
srv_make_money_saldo 806 806 0 0.00 1 570 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 154108 421347 261853 0 0
t$perf-abend:sp_add_invoice_to_stock 135 135 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5141 5141 0 0.00 0 8253 178 0 0
t$perf-norm:sp_cancel_adding_invoice 422 422 0 0.00 0 5483 118 0 0
t$perf-norm:sp_cancel_client_order 1796 1796 0 0.00 0 9948 23 0 0
t$perf-norm:sp_cancel_customer_reserve 684 684 0 0.00 0 781 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 748 748 0 0.00 0 493 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 418 418 0 0.00 0 762 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 420 420 0 0.00 0 935 13 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 33515 1653 0 0
t$perf-norm:sp_cancel_write_off 1047 1047 0 0.00 0 4001 11 0 0
t$perf-norm:sp_client_order 21904 21904 0 0.00 0 9754 19 0 0
t$perf-norm:sp_customer_reserve 1010 1010 0 0.00 0 9824 24 0 0
t$perf-norm:sp_pay_from_customer 7508 7508 0 0.00 0 6030 11 0 0
t$perf-norm:sp_pay_to_supplier 6133 6133 0 0.00 0 6069 8 0 0
t$perf-norm:sp_reserve_write_off 10547 10547 0 0.00 0 7326 10 0 0
t$perf-norm:sp_supplier_invoice 5797 5797 0 0.00 0 7805 20 0 0
t$perf-norm:sp_supplier_order 5626 5626 0 0.00 0 5336 18 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 6719 66 0 0
t$perf-norm:srv_fill_mon_cache_memory 168 168 0 0.00 0 4526 34 0 0
t$perf-norm:srv_make_invnt_saldo 658 658 0 0.00 0 1716 21 0 0
t$perf-norm:srv_make_money_saldo 806 806 0 0.00 0 1440 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 287 73 0 0
v_add_invoice_to_stock 10526 10256 270 2.56 0 5296 18 0 270
v_all_customers 39532 39532 0 0.00 0 110 1 0 0
v_all_suppliers 31782 31782 0 0.00 0 52 1 0 0
v_all_wares 43808 43808 0 0.00 0 87 1 0 0
v_cancel_adding_invoice 844 844 0 0.00 0 1951 14 0 0
v_cancel_client_order 3592 3592 0 0.00 0 2470 9 0 0
v_cancel_customer_prepayment 1496 1496 0 0.00 0 1273 5 0 0
v_cancel_customer_reserve 1368 1368 0 0.00 0 3156 7 0 0
v_cancel_payment_to_supplier 836 836 0 0.00 0 758 5 0 0
v_cancel_supplier_invoice 856 840 16 1.86 0 728 15 0 16
v_cancel_supplier_order 830 830 0 0.00 0 788 5 0 0
v_cancel_write_off 2094 2094 0 0.00 0 1986 15 0 0
v_max_id_clo_ord 5622 5622 0 0.00 0 7947 3 0 0
v_max_id_clo_res 1010 1010 0 0.00 0 3028 20 0 0
v_max_id_ord_sup 5783 5783 0 0.00 0 4672 5 0 0
v_max_non_paid_invoice 1647 1647 0 0.00 0 817 4 0 0
v_max_non_paid_realizn 4229 4229 0 0.00 0 2751 3 0 0
v_min_id_clo_ord 5622 5622 0 0.00 0 13938 10 0 0
v_min_id_clo_res 1010 1010 0 0.00 0 582 2 0 0
v_min_id_ord_sup 5783 5783 0 0.00 0 11646 19 0 0
v_min_non_paid_invoice 6133 6133 0 0.00 0 11324 23 0 0
v_min_non_paid_realizn 7508 7508 0 0.00 0 10699 16 0 0
v_our_firm 10834 10834 0 0.00 0 251 1 0 0
v_reserve_write_off 21094 21094 0 0.00 0 4147 5 0 0
x_lock_depdocs_on_canc_invoice 11192 11192 0 0.00 0 27070 116 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 11564 316 0 0
x_make_qstorno_1000_1200 5626 5626 0 0.00 2 31791 1282 0 0
x_make_qstorno_1200_2000 5797 5797 0 0.00 3 81184 3194 0 0
x_make_qstorno_2100_3300 469937 469937 0 0.00 0 111109 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-02-2021 01:28:31 to 23-02-2021 01:28:35.

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
22:57:20 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:27 14992 8192000000 10228014096 10532683776 971383520 10.600 77 60 119 0 994756832 2773152 20600160
22:57:50 31191 8192000000 10338946304 10653724672 1373055360 14.354 100 84 168 0 1405012256 4758112 27198784
22:58:35 16121 8192000000 10366963104 10689712128 1425966224 14.826 100 83 166 0 1458671344 6051680 26653440
22:59:05 21538 8192000000 10406209040 10732421120 1449582896 15.034 100 75 150 0 1480810704 6827392 24400416
22:59:36 21450 8192000000 10429982736 10761531392 1481220480 15.312 100 84 168 1 1515741136 7663280 26857376
23:00:06 25099 8192000000 10453493680 10785173504 1496348016 15.444 100 84 168 0 1531639200 8224784 27066400
23:00:40 20006 8192000000 10468055424 10805530624 1521825728 15.666 100 84 169 0 1557269136 9024976 26418432
23:01:28 15015 8192000000 10498020016 10840743936 1553366896 15.939 100 82 164 1 1589040752 9864880 25808976
23:01:51 17852 8192000000 10511869024 10860154880 1572304880 16.102 100 83 165 2 1607388112 10090320 24992912
23:02:22 12969 8192000000 10541820832 10896748544 1595137280 16.298 100 82 162 2 1630857728 10421648 25298800
23:02:43 18784 8192000000 10577040512 10938847232 1629334816 16.589 100 78 156 2 1663768768 11269920 23164032
23:03:11 10536 8192000000 10604722112 10970296320 1669522624 16.929 100 90 181 2 1709445184 12804048 27118512
23:03:31 9447 8192000000 10626165456 10994774016 1683223072 17.044 100 85 168 1 1721250784 12925984 25101728
23:03:48 8395 8192000000 10638416336 11007127552 1691886224 17.117 100 75 151 2 1726494720 12622608 21985888
23:04:04 5889 8192000000 10646129440 11016986624 1705245104 17.229 100 77 154 0 1740332064 12835232 22251728
23:04:17 6318 8192000000 10658172624 11031973888 1722415872 17.372 100 78 156 1 1756823184 12127264 22280048
23:04:32 8592 8192000000 10676520672 11051270144 1729503840 17.431 100 79 158 1 1765241296 13098544 22638912
23:04:49 4417 8192000000 10680995744 11056820224 1742557472 17.540 100 80 160 1 1779063232 13248736 23257024
23:05:01 6007 8192000000 10696439424 11071021056 1755923856 17.651 100 83 164 2 1793060256 14025136 23111264
23:05:14 4042 8192000000 10711885280 11091652608 1770456960 17.771 100 83 165 2 1806831920 13927024 22447936
23:05:26 4138 8192000000 10715959648 11099693056 1778741472 17.839 100 79 157 1 1813513120 12700928 22070720
23:05:38 3659 8192000000 10725614128 11108872192 1786774560 17.905 100 75 150 0 1819452752 12053056 20625136
23:05:48 3118 8192000000 10734483168 11114926080 1790539168 17.936 100 81 162 0 1826896928 13479856 22877904
23:05:58 5058 8192000000 10733957728 11117948928 1795147088 17.974 100 87 174 0 1834284800 14620960 24516752
23:06:11 3171 8192000000 10749470448 11134922752 1797796880 17.996 100 85 170 0 1836076448 14944368 23335200
23:06:21 2272 8192000000 10763877968 11145039872 1817762608 18.159 100 90 182 1 1857691712 15001872 24927232
23:06:29 2076 8192000000 10767476208 11150225408 1823715616 18.208 100 89 180 1 1862637040 14185120 24736304
23:06:38 2424 8192000000 10774436656 11156258816 1831078352 18.268 100 91 180 2 1870355440 14402000 24875088
23:06:47 2011 8192000000 10781018560 11165011968 1839212816 18.334 100 95 190 3 1881440448 15294048 26933584
23:06:55 2240 8192000000 10776260528 11165605888 1839248608 18.335 100 92 186 1 1879074176 13936976 25888592
23:07:04 1918 8192000000 10795874448 11180707840 1850197248 18.424 100 90 181 0 1888806816 13116640 25492928
23:07:13 2227 8192000000 10793728160 11176087552 1847784048 18.404 100 84 167 0 1883278240 11500768 23993424
23:07:21 2128 8192000000 10792002752 11178569728 1853566080 18.451 100 93 188 1 1892877472 12966944 26344448
23:07:30 1962 8192000000 10802710720 11191169024 1857860464 18.486 100 89 178 1 1896959760 13611984 25487312
23:07:40 1350 8192000000 10802908400 11191238656 1863073648 18.528 100 91 182 1 1902640720 12504528 27062544
23:07:47 1416 8192000000 10818867968 11205308416 1865458688 18.548 100 94 190 1 1904229440 12299168 26471584
23:07:55 1050 8192000000 10816941776 11204657152 1873318800 18.611 100 91 180 0 1912903040 13130128 26454112
23:08:02 26274 8192000000 10781917920 11192991744 1861092384 18.512 100 49 93 0 1880946304 6570016 13283904
23:08:35 10943 8192000000 10788330608 11199864832 1864705536 18.541 100 59 116 2 1888135648 7297808 16132304
23:08:52 2137 8192000000 10824082224 11220983808 1879497104 18.661 100 95 191 2 1919060368 12241024 27322240
23:09:02 8353 8192000000 10784890480 11209437184 1870127792 18.585 100 45 91 0 1892113312 9678976 12306544
23:09:19 7133 8192000000 10792434848 11212464128 1873570928 18.613 100 37 75 1 1893261904 8885600 10805376
23:09:34 3867 8192000000 10794753040 11214798848 1878398432 18.652 100 48 97 2 1900587008 8723536 13465040
23:09:45 7460 8192000000 10796113552 11212226560 1876601104 18.638 100 37 74 1 1894383840 7653648 10129088
23:10:01 8074 8192000000 10786905696 11212087296 1876166512 18.634 100 30 60 0 1892879248 7759824 8952912
23:10:16 8283 8192000000 10786766832 11214254080 1877751680 18.647 100 23 44 1 1890277872 5928048 6598144
23:10:36 6295 8192000000 10787052432 11215106048 1882263264 18.683 100 30 57 1 1896701072 6358608 8079200
23:10:49 6933 8192000000 10816290224 11224272896 1881194656 18.675 100 21 42 2 1896848000 10015056 5638288
23:11:02 60232 8192000000 10826041088 11236331520 1888354032 18.733 100 44 87 2 1910943536 8885664 13703840
23:12:09 3016 8192000000 10813439024 11238211584 1892427504 18.765 100 53 106 0 1917362576 9956832 14978240
23:12:23 10303 8192000000 10809446944 11237154816 1889814816 18.744 100 18 36 2 1905236048 10245744 5175488
23:12:40 3971 8192000000 10809099840 11238199296 1892260656 18.764 100 30 60 1 1907603984 6848128 8495200
23:12:52 6876 8192000000 10803693872 11235139584 1890652816 18.751 100 23 46 2 1902778496 5370096 6755584
23:13:08 5735 8192000000 10806792320 11237216256 1894733088 18.784 100 29 57 4 1908983888 5291680 8959120
23:13:21 7144 8192000000 10810276944 11239538688 1894821792 18.785 100 23 46 1 1907313472 5385408 7106272
23:13:37 4279 8192000000 10817589360 11246370816 1901620864 18.839 100 33 68 2 1916282736 5703328 8958544
23:13:49 5728 8192000000 10804171040 11243376640 1900528032 18.831 100 27 54 1 1914705392 6152960 8024400
23:14:03 6643 8192000000 10809709712 11244277760 1900543616 18.831 100 27 54 0 1914215312 5803584 7868112
23:14:20 8285 8192000000 10816344256 11245719552 1899537600 18.823 100 21 42 3 1915472384 9724336 6210448
23:14:35 6846 8192000000 10811331312 11245289472 1904688480 18.864 100 36 72 0 1922240656 6365216 11186960
23:14:50 7780 8192000000 10807806336 11247521792 1902011680 18.842 100 24 49 1 1915699488 5648080 8039728
23:15:07 17665 8192000000 10831256688 11258023936 1891331648 18.757 99 35 72 1 1907394416 4835424 11227344
23:15:55 33115 8192000000 10814142896 11248287744 1884845456 18.704 99 36 70 0 1900896432 5968704 10082272
23:16:35 10832 8192000000 10791321488 11230408704 1843662624 18.371 97 23 45 3 1856573040 6361936 6548480
23:16:53 4786 8192000000 10784900656 11209465856 1859589440 18.500 98 38 76 0 1877431488 6557488 11284560
23:17:06 5422 8192000000 10798224992 11222355968 1850508320 18.426 98 25 50 3 1863815216 5850272 7456624
23:17:18 4611 8192000000 10746189296 11162226688 1784684528 17.888 95 21 42 0 1795970224 5434368 5851328
23:17:29 7849 8192000000 10761725456 11174027264 1806083808 18.064 98 31 61 0 1820563152 6153632 8325712
23:17:45 4639 8192000000 10707945712 11122900992 1762882816 17.708 96 23 46 1 1775324736 5884448 6557472
23:17:56 11999 8192000000 10736456896 11157237760 1792156288 17.950 98 16 32 0 1802715648 6008752 4550608
23:18:15 5181 8192000000 10737659136 11151646720 1785757344 17.897 97 24 47 3 1799044880 6367168 6920368
23:18:27 10033 8192000000 10747476224 11162480640 1776916448 17.824 97 18 37 1 1788056896 5389808 5750640
23:18:48 8693 8192000000 10736971696 11156721664 1824292544 18.213 100 24 49 0 1836490144 5696480 6501120
23:19:03 12743 8192000000 10706954368 11126509568 1712589152 17.290 94 18 36 2 1723282736 5694528 4999056
23:19:24 10227 8192000000 10719274064 11129606144 1757372896 17.663 97 21 42 0 1768224704 5082496 5769312
23:19:45 49774 8192000000 10706134544 11109208064 1715591920 17.315 95 19 36 1 1725428336 4409824 5426592
23:20:52 19611 8192000000 10703813008 11122868224 1709546688 17.265 95 25 51 0 1726042544 9034304 7461552
23:21:18 5688 8192000000 10717420112 11138621440 1804427136 18.050 100 25 51 1 1817155312 5216848 7511328
23:21:31 5640 8192000000 10740645552 11160821760 1827696416 18.241 100 42 83 2 1845855904 5849296 12310192
23:21:44 4812 8192000000 10743334512 11156865024 1820331264 18.180 100 36 72 1 1837115456 6406240 10377952
23:21:57 6218 8192000000 10735418064 11142844416 1785523856 17.895 98 28 57 2 1799215376 5113776 8577744
23:22:11 8775 8192000000 10730964864 11150417920 1791902096 17.947 98 29 58 0 1806401664 5677200 8822368
23:22:29 7689 8192000000 10741786688 11161669632 1815518736 18.141 99 30 60 1 1829585104 6001024 8065344
23:22:43 8618 8192000000 10741310592 11167449088 1828279920 18.245 100 27 53 2 1842276752 6602944 7393888
23:22:58 5667 8192000000 10769622896 11181101056 1844836640 18.380 100 44 89 1 1863689456 5821568 13031248
23:23:14 7088 8192000000 10769105616 11191468032 1848380400 18.409 100 32 64 0 1863183344 5541456 9261488
23:23:33 10710 8192000000 10774849216 11196043264 1858926896 18.495 100 28 55 1 1873121664 5120704 9074064
23:23:50 15449 8192000000 10771250096 11204485120 1864102128 18.537 100 12 24 0 1872939600 5360112 3477360
23:24:11 13557 8192000000 10773184736 11208343552 1867461664 18.564 100 15 28 0 1877799024 5870432 4466928
23:24:34 57781 8192000000 10816927520 11226288128 1888459744 18.733 100 74 152 1 1916680032 6093200 22127088
23:25:41 6686 8192000000 10786920640 11218038784 1874829712 18.623 100 23 46 0 1887108800 6197200 6081888
23:25:56 8357 8192000000 10783094240 11219148800 1877342016 18.644 100 27 54 0 1891837120 6712736 7782368
23:26:11 10283 8192000000 10801068752 11235508224 1879483376 18.661 100 25 49 0 1891768976 5658896 6626704
23:26:32 4269 8192000000 10800883856 11230494720 1886746848 18.720 100 33 66 2 1903162144 7298656 9116640
23:26:42 8442 8192000000 10804893376 11235987456 1894993184 18.786 100 24 47 1 1906661136 5357072 6310880
23:26:59 10574 8192000000 10817682992 11249463296 1898047440 18.811 100 17 34 2 1907711408 4969344 4694624
23:27:15 8286 8192000000 10843145808 11260928000 1917077792 18.963 100 35 68 2 1932887712 5097872 10712048
23:27:31 2709 8192000000 10866509072 11273875456 1925809504 19.033 100 61 120 2 1949992880 5922176 18261200
23:27:42 18356 8192000000 10862572960 11282817024 1930679632 19.072 100 59 117 0 1955928272 8292176 16956464
23:28:25 41368 8192000000 10873426880 11294318592 1934322576 19.101 100 49 96 2 1957499968 9932736 13244656
23:29:14 13653 8192000000 10870829056 11297443840 1941803952 19.161 100 46 92 0 1966230624 11644304 12782368
23:29:38 17325 8192000000 10884946208 11309371392 1949830640 19.225 100 49 96 5 1976433136 12701232 13901264
23:30:06 11344 8192000000 10888348496 11313770496 1954185312 19.260 100 60 121 0 1986051056 14176336 17689408
23:30:32 15949 8192000000 10888454336 11318345728 1955282096 19.269 100 38 75 0 1978619040 12197392 11139552
23:31:50 7127 8192000000 10890859440 11332030464 1963267488 19.332 100 37 74 0 1993068080 17654912 12145680
23:32:07 28754 8192000000 10906064848 11336716288 1966719808 19.359 100 33 66 4 1991218640 15172912 9325920
23:32:45 7952 8192000000 10898420496 11339022336 1968070672 19.370 100 24 48 0 1989698304 14224352 7403280
23:33:00 13824 8192000000 10918966032 11352051712 1975658832 19.430 100 36 73 0 2005063296 19021344 10383120
23:33:22 2273 8192000000 10931649728 11347103744 1966897472 19.361 99 84 163 1 2006430432 16140192 23392768
23:33:30 25992 8192000000 10914415408 11348258816 1961488960 19.318 99 57 114 0 1995728000 17788544 16450496
23:34:05 4110 8192000000 10919123776 11349147648 1977440544 19.444 100 56 112 1 2011541616 17899216 16201856
23:34:16 17866 8192000000 10924730560 11359436800 1982424448 19.484 100 46 92 0 2011258928 15887904 12946576
23:34:43 14180 8192000000 10943804368 11373232128 1997881536 19.606 100 58 115 1 2033517632 19518480 16117616
23:35:03 12370 8192000000 10943527264 11373056000 1996795568 19.597 100 60 120 1 2035496880 21118512 17582800
23:35:27 5349 8192000000 10953938112 11381149696 2001376736 19.634 100 56 110 3 2038701472 20673632 16651104
23:35:40 14179 8192000000 10962658592 11389534208 2005034848 19.662 100 68 135 0 2047861104 22921968 19904288
23:36:07 12500 8192000000 10963008112 11393843200 2006700096 19.676 100 57 113 1 2047076688 23798368 16578224
23:36:43 4267 8192000000 10967087664 11395911680 2007952688 19.685 100 58 116 1 2050704320 25479744 17271888
23:37:01 11312 8192000000 10958246512 11388039168 2003644912 19.651 100 59 117 0 2042878816 22073712 17160192
23:37:20 4468 8192000000 10954654544 11380162560 1998076976 19.608 100 66 130 2 2041532016 24151056 19303984
23:37:35 6920 8192000000 10951580832 11377684480 1996239952 19.593 100 67 133 1 2041129376 25264224 19625200
23:37:52 2600 8192000000 10966491760 11381272576 1996516448 19.595 100 78 156 1 2044952848 25445504 22990896
23:38:02 4831 8192000000 10961495136 11385348096 2004556432 19.659 100 72 142 1 2052001296 26442960 21001904
23:38:17 6703 8192000000 10954168224 11384668160 1999994336 19.623 100 67 134 3 2046972592 27058848 19919408
23:38:39 3509 8192000000 10972376448 11398692864 2010949872 19.709 100 68 134 2 2059967168 28396304 20620992
23:38:51 8679 8192000000 10966690768 11392040960 1993078032 19.568 99 75 149 1 2040972464 25788400 22106032
23:39:09 4473 8192000000 10965795200 11393875968 2007060992 19.678 100 59 116 1 2050230400 25073824 18095584
23:39:20 7031 8192000000 10970808256 11392131072 2006721376 19.676 100 75 148 0 2056047808 26957952 22368480
23:39:33 5197 8192000000 10976006496 11395133440 2007551344 19.682 100 68 133 2 2055702256 27421472 20729440
23:39:48 5276 8192000000 10969132960 11391455232 2003955376 19.654 100 71 143 0 2054746832 28637088 22154368
23:40:03 2295 8192000000 10964701200 11394097152 2005542192 19.666 100 65 128 1 2053825216 27220448 21062576
23:40:14 3207 8192000000 10956701008 11378065408 1994544112 19.580 100 82 163 2 2047512624 28282608 24685904
23:40:26 2361 8192000000 10978160544 11394355200 2006473152 19.674 100 88 177 0 2059564336 26302304 26788880
23:40:38 3231 8192000000 10980360608 11396575232 2005195680 19.664 100 82 163 0 2056891264 26933792 24761792
23:40:49 2630 8192000000 10982963632 11404926976 2015084544 19.742 100 79 158 1 2068306912 28677616 24544752
23:40:59 5075 8192000000 10987696240 11403501568 2012791472 19.723 100 88 175 1 2069858096 30329184 26737440
23:41:10 3430 8192000000 10976484176 11389325312 1991973872 19.559 99 89 177 2 2049290608 30683392 26633344
23:41:24 2710 8192000000 10973338032 11389472768 1986377424 19.515 99 84 167 2 2045013168 32745120 25890624
23:41:39 2284 8192000000 10966750320 11384909824 1993426640 19.571 100 81 161 1 2050923840 32069152 25428048
23:41:48 1593 8192000000 10946691088 11357298688 1956796640 19.281 98 84 169 0 2012036064 29760432 25478992
23:41:56 4542 8192000000 10948172944 11366277120 1978112832 19.450 100 74 146 1 2030490400 30158240 22219328
23:42:08 2348 8192000000 10912226496 11326111744 1932763184 19.089 98 79 157 2 1988405968 31044512 24598272
23:42:16 4187 8192000000 10945157456 11353972736 1965002512 19.346 100 86 172 4 2022556016 31506864 26046640
23:42:29 3723 8192000000 10927364096 11340132352 1944379408 19.182 99 81 161 1 2000720064 31163008 25177648
23:42:40 3159 8192000000 10940209152 11351855104 1965735872 19.352 100 81 158 0 2019569120 29819584 24013664
23:42:53 3798 8192000000 10930367040 11337482240 1944592368 19.183 99 77 154 2 1997948080 29916336 23439376
23:43:04 3703 8192000000 10930012016 11345154048 1959156160 19.299 100 79 158 1 2015053920 31076064 24821696
23:43:18 5396 8192000000 10940203248 11356737536 1965337776 19.348 100 73 146 0 2021068624 32700816 23030032
23:43:30 4946 8192000000 10946108736 11363307520 1970280448 19.388 100 81 160 2 2029072128 34040928 24750752
23:43:49 3529 8192000000 10935629344 11355947008 1948023504 19.211 99 70 140 0 2007585072 37523200 22038368
23:44:04 3628 8192000000 10939076176 11361214464 1964476320 19.342 100 70 135 2 2021793168 35905584 21411264
23:44:14 8256 8192000000 10926470256 11344203776 1940342032 19.149 99 73 146 1 1998857984 35716816 22799136
23:44:31 2974 8192000000 10929608512 11350093824 1955818800 19.273 100 73 146 0 2015510144 37023360 22667984
23:44:41 2458 8192000000 10936035024 11344760832 1953322752 19.253 100 82 162 0 2016123584 37378160 25422672
23:44:55 2049 8192000000 10940558480 11358740480 1959347376 19.301 100 81 162 2 2024737440 40175600 25214464
23:45:04 1558 8192000000 10941465056 11352047616 1956863488 19.281 100 86 172 1 2025786096 41270224 27652384
23:45:12 3239 8192000000 10949987856 11366367232 1964741616 19.344 100 86 172 1 2034322864 42466544 27114704
23:45:26 963 8192000000 10962108224 11367927808 1969818176 19.384 100 94 189 0 2040848064 41399760 29630128
23:45:34 4520 8192000000 10951753584 11367178240 1963555632 19.334 100 80 159 2 2031951264 42982832 25412800
23:45:46 3610 8192000000 10941363520 11356348416 1953130720 19.251 100 78 155 1 2022333024 43483760 25718544
23:45:58 2253 8192000000 10948110384 11367612416 1964947280 19.345 100 73 144 0 2031656592 43404112 23305200
23:46:08 2071 8192000000 10952845152 11360964608 1962244400 19.324 100 82 164 0 2032526576 44025344 26256832
23:46:17 2085 8192000000 10947903936 11363319808 1965713248 19.351 100 85 169 1 2036293520 43640384 26939888
23:46:27 3685 8192000000 10968363232 11379957760 1973502880 19.413 100 88 176 3 2046270096 45295456 27471760
23:46:39 3019 8192000000 10962834512 11382493184 1973712928 19.415 100 80 160 1 2045936640 46745168 25478544
23:46:56 2811 8192000000 10967514448 11385520128 1976032640 19.433 100 82 163 0 2053345024 50786800 26525584
23:47:08 3542 8192000000 10955185808 11361771520 1945213584 19.188 99 88 175 1 2019099616 46201952 27684080
23:47:18 17000 8192000000 10919587088 11356655616 1950974080 19.234 100 53 106 1 2013246784 44702224 17570480
23:47:50 7728 8192000000 10923078720 11356581888 1954910896 19.266 100 48 96 0 2007061792 36418912 15731984
23:48:05 8674 8192000000 10922302064 11359657984 1954759408 19.264 100 45 90 0 2005990240 36210112 15020720
23:48:23 21633 8192000000 10900600704 11355152384 1940668400 19.152 99 30 59 4 1982713824 30734400 11311024
23:48:51 12182 8192000000 10872680256 11326406656 1913120384 18.932 98 24 48 1 1946414768 25187936 8106448
23:49:11 19706 8192000000 10882045264 11333922816 1940784352 19.153 100 21 42 2 1967797232 20377472 6635408
23:49:40 13358 8192000000 10897358336 11338801152 1949470816 19.222 100 22 44 0 1976573376 20290608 6811952
23:50:00 10806 8192000000 10867780624 11308224512 1909478224 18.902 98 42 84 0 1941654816 19715056 12461536
23:50:25 20943 8192000000 10885879024 11324776448 1903296768 18.853 98 27 55 2 1940724912 28010528 9417616
23:51:27 21278 8192000000 10890450768 11341926400 1927880752 19.050 99 21 42 2 1960655584 25344192 7430640
23:51:54 33963 8192000000 10869362560 11321597952 1913169408 18.932 99 18 36 1 1938756320 20052784 5534128
23:52:36 37389 8192000000 10882639552 11330031616 1912913072 18.930 99 20 40 0 1951912624 31741808 7257744
23:53:45 42034 8192000000 10870925744 11324227584 1903784144 18.857 98 19 38 2 1928490912 18506720 6200048
23:54:43 32735 8192000000 10904684912 11341025280 1947132800 19.204 100 36 71 3 1977821952 19595360 11093792
23:55:27 24606 8192000000 10886885536 11354464256 1946980192 19.202 100 24 48 0 1972759664 18426176 7353296
23:55:59 44272 8192000000 10895927216 11366170624 1949465696 19.222 100 7 14 0 1975621600 24308672 1847232
23:58:04 90279 8192000000 10901362256 11351298048 1918384928 18.974 97 42 82 0 1942408912 12491648 11532336
23:59:41 72564 8192000000 10930971936 11380649984 1957158144 19.283 99 23 46 1 1976419584 13266960 5994480
00:01:00 90005 8192000000 10930495680 11389579264 1974775520 19.423 99 41 82 2 1999421648 12694864 11951264
00:02:58 10928 8192000000 10921971328 11388932096 1989840800 19.543 100 46 92 4 2026131616 22582032 13708784
00:03:20 7748 8192000000 10934268576 11392225280 1997169456 19.600 100 26 50 0 2019940800 14577456 8193888
00:03:38 21330 8192000000 10941866256 11396186112 1980963392 19.472 99 29 58 0 2005439232 15736576 8739264
00:04:13 37892 8192000000 10937821728 11394588672 1962299648 19.324 98 51 102 1 1996783984 19905568 14578768
00:05:09 96602 8192000000 10924195008 11392954368 1966808400 19.360 99 19 38 1 1995533440 22855248 5869792
00:07:12 42158 8192000000 10909848096 11395153920 1965622288 19.351 99 17 34 3 1995481488 24738768 5120432
00:09:13 103815 8192000000 10910701392 11389075456 1975597008 19.430 99 22 44 1 1997210272 15464976 6148288
00:11:04 45780 8192000000 10910566432 11391627264 1965022432 19.346 99 12 25 1 1991205728 22101424 4081872
00:11:57 58519 8192000000 10918003360 11378626560 1946256704 19.197 98 8 16 0 1964209872 15662016 2291152
00:13:07 40944 8192000000 10924110400 11386695680 1989834720 19.542 100 32 61 1 2009247760 11070160 8342880
00:13:57 41341 8192000000 10905052864 11382104064 1967476320 19.365 99 13 25 1 1980111664 9003920 3631424
00:14:45 49315 8192000000 10886771120 11361144832 1906364896 18.877 96 7 14 1 1916143248 7946112 1832240
00:15:43 24721 8192000000 10904434992 11367804928 1963152656 19.331 99 40 80 1 1984163984 8823536 12187792
00:16:14 38305 8192000000 10896331408 11374587904 1961210880 19.316 99 13 26 1 1972267328 7602944 3453504
00:16:59 29653 8192000000 10918578304 11362562048 1929942672 19.066 97 47 94 4 1952218176 8031744 14243760
00:17:38 30080 8192000000 10905923424 11372109824 1976020224 19.433 100 37 74 1 1996455600 10340272 10095104
00:18:22 40755 8192000000 10919958992 11379769344 1968856416 19.376 99 33 66 2 1988295696 10311216 9128064
00:19:21 58873 8192000000 10909469776 11378454528 1964966080 19.345 99 19 37 2 1979671584 8475280 6230224
00:20:40 31485 8192000000 10922130800 11382390784 1990297344 19.546 100 27 54 1 2005003120 7348400 7357376
00:21:18 59281 8192000000 10923512352 11392135168 1955157504 19.268 98 16 32 2 1968565472 9110144 4297824
00:22:26 35670 8192000000 10933751936 11393273856 1976244720 19.435 99 40 80 3 2000541120 12491296 11805104
00:23:08 105401 8192000000 10913005536 11384107008 1914709616 18.944 96 26 52 0 1942591152 20617808 7263728
00:25:00 91817 8192000000 10923056592 11389022208 1966990320 19.362 99 6 12 0 1977542592 9362432 1189840
00:26:38 78048 8192000000 10897200496 11349209088 1848421504 18.409 93 21 42 1 1866166720 11680096 6065120
00:28:04 51022 8192000000 10839744768 11304329216 1866187168 18.553 95 21 42 0 1879560704 7468544 5904992
00:29:01 28952 8192000000 10882833216 11335966720 1918031824 18.971 99 21 41 2 1936081920 12484496 5565600
00:29:40 95163 8192000000 10845697328 11321602048 1873452896 18.612 96 16 32 0 1893282000 15344032 4485072
00:31:27 31418 8192000000 10837279712 11310522368 1895587104 18.791 98 8 16 1 1914231936 16458368 2186464
00:32:04 4562 8192000000 10839318112 11312295936 1912324080 18.925 100 7 14 1 1931582768 17269840 1988848
00:32:15 7410 8192000000 10855247424 11325767680 1913044016 18.931 100 7 14 0 1933724480 18691616 1988848
00:32:36 32508 8192000000 10835421104 11304251392 1875268112 18.627 98 15 30 2 1891099456 11346224 4485120
00:33:19 77794 8192000000 10865681312 11330043904 1865061728 18.544 96 15 29 1 1878498320 9329760 4106832
00:34:43 25455 8192000000 10902590336 11340296192 1931858656 19.082 99 36 72 0 1948700128 7459456 9382016
00:35:16 34204 8192000000 10884201456 11346894848 1937800288 19.129 99 53 106 0 1969182496 16737328 14644880
00:36:10 52085 8192000000 10844377328 11305697280 1842875360 18.364 95 18 36 2 1857140000 9524448 4740192
00:37:09 25875 8192000000 10862326720 11314675712 1912842672 18.929 99 32 64 3 1929104096 7185312 9076112
00:37:42 42900 8192000000 10848288544 11307122688 1895823568 18.793 98 28 56 1 1912619184 8761488 8034128
00:38:34 41261 8192000000 10891883904 11341877248 1936332480 19.117 100 33 65 1 1957291600 11668048 9291072
00:39:24 67373 8192000000 10880490320 11340361728 1890083776 18.746 97 25 50 1 1910558528 13235776 7238976
00:40:38 38157 8192000000 10889271808 11348631552 1935281216 19.109 99 31 60 1 1963234080 19615536 8337328
00:41:23 76139 8192000000 10895375312 11364573184 1933227360 19.093 99 13 26 1 1957139984 19828560 4084064
00:42:47 51584 8192000000 10864860784 11353706496 1902456944 18.846 98 6 12 0 1925095792 20941856 1696992
00:43:45 64589 8192000000 10867605104 11332722688 1869807712 18.583 96 13 26 1 1883816256 10382992 3625552
00:45:00 33379 8192000000 10904275568 11357859840 1949802928 19.225 100 20 40 0 1963706832 8707168 5196736
00:45:46 79601 8192000000 10918804048 11381800960 1945396896 19.190 99 19 38 1 1970940128 20544224 4999008
00:47:19 34033 8192000000 10904885984 11367079936 1950479920 19.230 99 32 64 1 1971014096 11803936 8730240
00:49:30 84545 8192000000 10904070000 11384311808 1956085712 19.275 99 16 32 0 1973724320 12465744 5172864
00:51:10 62634 8192000000 10887398544 11380572160 1970009456 19.386 100 6 12 0 1987238224 15442528 1786240
00:52:19 25466 8192000000 10892450512 11380674560 1970051600 19.386 100 6 12 1 1984635024 13017520 1565904
00:52:51 44285 8192000000 10890072368 11378892800 1955283504 19.269 99 9 18 0 1977364496 19512240 2568752
00:53:41 25055 8192000000 10881071552 11350114304 1945533536 19.191 99 7 14 0 1957729552 10312784 1883232
00:54:29 75950 8192000000 10893308096 11384229888 1974226256 19.419 100 12 24 0 1986718752 8699504 3792992
00:56:05 53891 8192000000 10894836992 11370393600 1919579120 18.983 97 15 30 1 1934588928 10457728 4552080
00:57:11 32642 8192000000 10909897808 11369644032 1945196928 19.188 98 24 47 0 1961676064 10098112 6381024
00:57:59 71263 8192000000 10893820512 11383705600 1945607984 19.191 98 21 42 1 1965706400 14148112 5950304
00:59:19 59917 8192000000 10887927424 11368120320 1918691104 18.976 97 13 26 4 1931208336 8928992 3588240
01:00:29 64312 8192000000 10893619072 11373707264 1924205520 19.021 97 32 64 4 1943620768 9576416 9838832
01:01:45 68987 8192000000 10901412736 11378245632 1931231104 19.077 98 29 58 0 1950549968 11564400 7754464
01:03:02 62002 8192000000 10886470768 11375951872 1908536720 18.895 97 6 12 0 1926892672 16724192 1631760
01:04:13 78142 8192000000 10924930560 11384139776 1968702112 19.375 100 15 28 0 1984255552 11966992 3586448
01:05:38 44903 8192000000 10931162352 11388628992 1980055888 19.465 100 36 70 0 1999509120 9190176 10263056
01:06:34 19581 8192000000 10942524752 11401195520 1994164896 19.577 100 41 81 3 2018828272 13542544 11120832
01:07:01 98196 8192000000 10927852592 11393613824 1949805056 19.225 98 20 40 0 1969352912 14121104 5426752
01:08:49 99255 8192000000 10922392160 11413790720 1954857856 19.265 98 25 50 0 1982730032 20731504 7140672
01:10:34 68040 8192000000 10899379376 11382288384 1953235136 19.252 98 30 59 3 1971254560 9344496 8674928
01:12:13 108967 8192000000 10900989888 11387174912 1930080800 19.068 97 15 30 1 1944642608 10642320 3919488
01:14:08 45948 8192000000 10892409104 11376951296 1961414048 19.317 99 17 34 0 1978019184 11199760 5405376
01:15:00 41187 8192000000 10869912432 11357958144 1910260288 18.909 97 12 24 2 1925997744 12432304 3305152
01:15:58 36063 8192000000 10881381296 11380117504 1954775920 19.264 100 4 8 1 1968326560 12607104 943536
01:17:15 55400 8192000000 10907229872 11364683776 1935891920 19.114 98 14 28 4 1946198176 6272064 4034192
01:18:20 93164 8192000000 10866461376 11356962816 1912776704 18.929 97 14 28 1 1925188912 8440928 3971280
01:20:10 81463 8192000000 10873578240 11358519296 1931894192 19.082 99 6 12 0 1941764352 8295600 1574560
01:21:38 48595 8192000000 10882564192 11354656768 1912939648 18.930 97 19 38 1 1926952848 8808976 5204224
01:22:33 62847 8192000000 10867283856 11330199552 1825214144 18.220 93 22 41 1 1838135328 7612784 5308400
01:23:47 42598 8192000000 10844179584 11304308736 1783430912 17.878 92 26 52 2 1803720064 13056704 7232448
01:24:40 23060 8192000000 10874082112 11333480448 1931838592 19.082 100 42 84 1 1954534016 10137040 12558384
01:25:10 50821 8192000000 10874319664 11340890112 1917830672 18.969 99 35 70 1 1941022512 13219488 9972352
01:26:44 38437 8192000000 10134958752 10536239104 1233207632 13.084 63 28 54 1 1252562800 11658352 7696816

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 23-02-2021 01:28:37 to 23-02-2021 01:29:09.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 135 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-02-2021 01:29:09 to 23-02-2021 01:29:11.

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          245275
MON$OLDEST_ACTIVE               247608
MON$OLDEST_SNAPSHOT             247608
MON$NEXT_TRANSACTION            247608
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                       2020480
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:165: 
:166: mscs-test-161.budzdorov.ru    Tue Feb 23 01:27:35 2021
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
:169: 
:170: mscs-test-161.budzdorov.ru    Tue Feb 23 01:27:35 2021
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:172: 
:173: 
:174: mscs-test-161.budzdorov.ru    Tue Feb 23 01:27:35 2021
:175:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:176: 
:177: 
:178: mscs-test-161.budzdorov.ru    Tue Feb 23 01:27:35 2021
:179:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:180: 
:181: 
:182: mscs-test-161.budzdorov.ru    Tue Feb 23 01:27:42 2021
:183:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:184: 
--- end of diff output ---

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

23.02.21 01:29:12. 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-23 01:29:15 No severe PSQL-related problems occured
23.02.21 01:29:16. End of report.