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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17204744 kB
MemAvailable 31302656 kB
Buffers 0 kB
Cached 14520056 kB
SwapCached 4868 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-01-28 16:27:12
DTS_END                         2021-01-28 16:27:12.3840
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41576
TRN_ID                          242571
ATT_ID                          708
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: 9552.87 24026 1146344
customer order: creation 176.07 349 21128
customer order: refuse 15.28 356 1834
order to supplier: creation 47.48 1276 5698
order to supplier: removal 3.43 90355 411
invoice (draft): creation 46.82 3058 5618
invoice (draft): removal 51.46 793 6175
invoice accept: apply 44.19 17069 5303
invoice accept: cancel 46.63 731 5595
customer reserve: creation 4173.60 164 500832
customer reserve: removal 4648.58 52 557829
realization accept: apply 84.38 186 10125
realization accept: cancel 82.12 96 9854
payment from customer: creation 60.58 116 7270
payment from customer: removal 5.86 96 703
payment to supplier: creation 50.80 112 6096
payment to supplier: removal 3.57 59 428
service: total inventory turnovers 4.91 1096 589
service: total monetary turnovers 6.27 61 752
service: aggregate perf. data 0.83 23124 100
service: refresh index statistics 0.03 341362 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-01-2021 16:28:56 to 28-01-2021 16:28:58.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1555
TEST_TIME 2 3070
TEST_TIME 3 4327
TEST_TIME 4 4689
TEST_TIME 5 4850
TEST_TIME 6 4966
TEST_TIME 7 5276
TEST_TIME 8 5585
TEST_TIME 9 5632
TEST_TIME 10 6023
TEST_TIME 11 6123
TEST_TIME 12 6413
TEST_TIME 13 6511
TEST_TIME 14 6838
TEST_TIME 15 7280
TEST_TIME 16 8008
TEST_TIME 17 8144
TEST_TIME 18 8522
TEST_TIME 19 8700
TEST_TIME 20 9228
TEST_TIME 21 9344
TEST_TIME 22 9895
TEST_TIME 23 10655
TEST_TIME 24 10455
TEST_TIME 25 10446
TEST_TIME 26 10950
TEST_TIME 27 10926
TEST_TIME 28 10791
TEST_TIME 29 10563
TEST_TIME 30 10822
TEST_TIME 31 10761
TEST_TIME 32 10689
TEST_TIME 33 10880
TEST_TIME 34 10772
TEST_TIME 35 10914
TEST_TIME 36 10740
TEST_TIME 37 10542
TEST_TIME 38 10344
TEST_TIME 39 10416
TEST_TIME 40 10242
TEST_TIME 41 10158
TEST_TIME 42 10109
TEST_TIME 43 10107
TEST_TIME 44 10174
TEST_TIME 45 10111
TEST_TIME 46 9962
TEST_TIME 47 9977
TEST_TIME 48 9885
TEST_TIME 49 9781
TEST_TIME 50 9747
TEST_TIME 51 9738
TEST_TIME 52 9686
TEST_TIME 53 9761
TEST_TIME 54 9687
TEST_TIME 55 9852
TEST_TIME 56 9881
TEST_TIME 57 9864
TEST_TIME 58 9814
TEST_TIME 59 9821
TEST_TIME 60 9951
TEST_TIME 61 9913
TEST_TIME 62 10006
TEST_TIME 63 9985
TEST_TIME 64 10164
TEST_TIME 65 10077
TEST_TIME 66 9984
TEST_TIME 67 9994
TEST_TIME 68 9921
TEST_TIME 69 9864
TEST_TIME 70 9876
TEST_TIME 71 9820
TEST_TIME 72 9795
TEST_TIME 73 9741
TEST_TIME 74 9663
TEST_TIME 75 9588
TEST_TIME 76 9671
TEST_TIME 77 9676
TEST_TIME 78 9661
TEST_TIME 79 9633
TEST_TIME 80 9720
TEST_TIME 81 9877
TEST_TIME 82 9828
TEST_TIME 83 9824
TEST_TIME 84 9836
TEST_TIME 85 9850
TEST_TIME 86 9863
TEST_TIME 87 9931
TEST_TIME 88 9973
TEST_TIME 89 9957
TEST_TIME 90 9859
TEST_TIME 91 9788
TEST_TIME 92 9771
TEST_TIME 93 9769
TEST_TIME 94 9753
TEST_TIME 95 9701
TEST_TIME 96 9719
TEST_TIME 97 9714
TEST_TIME 98 9712
TEST_TIME 99 9707
TEST_TIME 100 9702
TEST_TIME 101 9759
TEST_TIME 102 9814
TEST_TIME 103 9757
TEST_TIME 104 9743
TEST_TIME 105 9817
TEST_TIME 106 9787
TEST_TIME 107 9806
TEST_TIME 108 9850
TEST_TIME 109 9828
TEST_TIME 110 9806
TEST_TIME 111 9745
TEST_TIME 112 9743
TEST_TIME 113 9726
TEST_TIME 114 9717
TEST_TIME 115 9680
TEST_TIME 116 9639
TEST_TIME 117 9633
TEST_TIME 118 9621
TEST_TIME 119 9592
TEST_TIME 120 9553

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-01-2021 16:29:00 to 28-01-2021 16:29:03.

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 1606526 1606526 0 0.00 0 18896 6 0 0
doc_list_biud 1606526 1606526 0 0.00 0 56075 24 0 0
sp_add_invoice_to_stock 5465 5303 162 2.96 41 198465 17069 0 162
sp_cancel_adding_invoice 5595 5595 0 0.00 3 65618 732 0 0
sp_cancel_client_order 1834 1834 0 0.00 4 12337 356 0 0
sp_cancel_customer_reserve 557829 557829 0 0.00 1 56077 52 0 0
sp_cancel_pay_from_customer 703 703 0 0.00 3 6343 96 0 0
sp_cancel_pay_to_supplier 428 428 0 0.00 3 1572 59 0 0
sp_cancel_supplier_invoice 6182 6175 7 0.11 1 14052 794 0 7
sp_cancel_supplier_order 411 411 0 0.00 8 974450 90355 0 0
sp_cancel_write_off 9854 9854 0 0.00 1 7079 97 0 0
sp_client_order 21128 21128 0 0.00 3 21015 349 0 0
sp_customer_reserve 500832 500832 0 0.00 0 97024 164 0 0
sp_fill_shopping_cart 32432 32432 0 0.00 1 26029 39 0 0
sp_fill_shopping_cart_clo_res 500826 500826 0 0.00 0 33359 13 0 0
sp_get_clo_for_invoice 5297 5297 0 0.00 0 30149 324 0 0
sp_kill_cost_storno 16580 16580 0 0.00 0 7886 51 0 0
sp_kill_qstorno_ret_qs2qd 1132098 1132098 0 0.00 0 56067 29 0 0
sp_kill_qty_storno 597120 597120 0 0.00 0 56075 63 0 0
sp_lock_selected_doc 21402 21402 0 0.00 0 9037 9 0 0
sp_make_cost_storno 28788 28788 0 0.00 0 18884 48 0 0
sp_multiply_rows_for_pdistr 28788 28788 0 0.00 0 7066 27 0 0
sp_multiply_rows_for_qdistr 21128 21128 0 0.00 0 14201 174 0 0
sp_pay_from_customer 7270 7270 0 0.00 4 20331 117 0 0
sp_pay_to_supplier 6096 6096 0 0.00 4 11350 113 0 0
sp_payment_common 13366 13366 0 0.00 1 20325 30 0 0
sp_qd_handle_on_cancel_clo 1834 1834 0 0.00 0 12330 321 0 0
sp_qd_handle_on_invoice_upd_sts 10892 10892 0 0.00 0 40880 310 0 0
sp_qd_handle_on_reserve_upd_sts 10125 10125 0 0.00 0 18590 70 0 0
sp_reserve_write_off 10125 10125 0 0.00 6 18609 187 0 0
sp_supplier_invoice 5618 5618 0 0.00 8 91983 3059 0 0
sp_supplier_order 5698 5698 0 0.00 5 33993 1276 0 0
srv_aggregate_perf_data 100 100 0 0.00 2029 189351 23125 0 0
srv_fill_mon_cache_memory 159 159 0 0.00 1352 199955 33939 0 0
srv_find_qd_qs_mism 1094582 1094582 0 0.00 0 14638 5 0 0
srv_make_invnt_saldo 589 589 0 0.00 35 111573 1097 0 0
srv_make_money_saldo 752 752 0 0.00 1 16836 62 0 0
srv_recalc_idx_stat 4 4 0 0.00 205791 525497 341362 0 0
t$perf-abend:sp_add_invoice_to_stock 162 162 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5303 5303 0 0.00 0 9164 179 0 0
t$perf-norm:sp_cancel_adding_invoice 429 429 0 0.00 0 4554 91 0 0
t$perf-norm:sp_cancel_client_order 1834 1834 0 0.00 0 2850 17 0 0
t$perf-norm:sp_cancel_customer_reserve 711 711 0 0.00 0 279 5 0 0
t$perf-norm:sp_cancel_pay_from_customer 703 703 0 0.00 0 13810 33 0 0
t$perf-norm:sp_cancel_pay_to_supplier 428 428 0 0.00 0 2183 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 431 431 0 0.00 0 3570 28 0 0
t$perf-norm:sp_cancel_supplier_order 411 411 0 0.00 0 20206 1410 0 0
t$perf-norm:sp_cancel_write_off 1033 1033 0 0.00 0 3024 8 0 0
t$perf-norm:sp_client_order 21128 21128 0 0.00 0 6669 20 0 0
t$perf-norm:sp_customer_reserve 1003 1003 0 0.00 0 1605 8 0 0
t$perf-norm:sp_pay_from_customer 7270 7270 0 0.00 0 4991 11 0 0
t$perf-norm:sp_pay_to_supplier 6096 6096 0 0.00 0 8818 14 0 0
t$perf-norm:sp_reserve_write_off 10125 10125 0 0.00 0 6069 15 0 0
t$perf-norm:sp_supplier_invoice 5618 5618 0 0.00 0 2583 15 0 0
t$perf-norm:sp_supplier_order 5698 5698 0 0.00 0 5176 16 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 563 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 159 159 0 0.00 0 704 13 0 0
t$perf-norm:srv_make_invnt_saldo 589 589 0 0.00 0 3611 36 0 0
t$perf-norm:srv_make_money_saldo 752 752 0 0.00 0 1416 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 48 14 0 0
v_add_invoice_to_stock 10918 10594 324 2.96 0 7585 19 0 324
v_all_customers 38516 38516 0 0.00 0 39 1 0 0
v_all_suppliers 31576 31576 0 0.00 0 18 1 0 0
v_all_wares 42256 42256 0 0.00 0 14 1 0 0
v_cancel_adding_invoice 858 858 0 0.00 0 2497 11 0 0
v_cancel_client_order 3668 3668 0 0.00 0 7483 8 0 0
v_cancel_customer_prepayment 1406 1406 0 0.00 0 5023 16 0 0
v_cancel_customer_reserve 1422 1422 0 0.00 0 1525 5 0 0
v_cancel_payment_to_supplier 856 856 0 0.00 0 1402 6 0 0
v_cancel_supplier_invoice 876 862 14 1.59 0 4798 24 0 14
v_cancel_supplier_order 822 822 0 0.00 0 888 4 0 0
v_cancel_write_off 2066 2066 0 0.00 0 7039 17 0 0
v_max_id_clo_ord 5698 5698 0 0.00 0 2897 2 0 0
v_max_id_clo_res 1003 1003 0 0.00 0 1754 14 0 0
v_max_id_ord_sup 5606 5606 0 0.00 0 6047 6 0 0
v_max_non_paid_invoice 1612 1612 0 0.00 0 1425 3 0 0
v_max_non_paid_realizn 3840 3840 0 0.00 0 2721 4 0 0
v_min_id_clo_ord 5698 5698 0 0.00 0 4596 8 0 0
v_min_id_clo_res 1003 1003 0 0.00 0 8583 12 0 0
v_min_id_ord_sup 5606 5606 0 0.00 0 7812 7 0 0
v_min_non_paid_invoice 6096 6096 0 0.00 0 6328 12 0 0
v_min_non_paid_realizn 7270 7270 0 0.00 0 16418 20 0 0
v_our_firm 10600 10600 0 0.00 0 37 1 0 0
v_reserve_write_off 20250 20250 0 0.00 0 8119 10 0 0
x_lock_depdocs_on_canc_invoice 11339 11339 0 0.00 0 14021 105 0 0
x_lock_depdocs_on_canc_sup_ord 411 411 0 0.00 0 12893 268 0 0
x_make_qstorno_1000_1200 5698 5698 0 0.00 2 33970 1195 0 0
x_make_qstorno_1200_2000 5618 5618 0 0.00 3 91798 2913 0 0
x_make_qstorno_2100_3300 500832 500832 0 0.00 0 97020 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-01-2021 16:29:04 to 28-01-2021 16:29:08.

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:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:22 23305 8192000000 10248424768 10550882304 878613984 9.686 70 56 114 0 901064288 2491952 19958352
13:57:53 21385 8192000000 10320932320 10636226560 1373047344 14.354 100 84 168 0 1405113696 4750016 27316336
13:58:24 37853 8192000000 10383301568 10702831616 1420296320 14.775 100 91 182 1 1456435760 6395296 29744144
13:59:19 13676 8192000000 10386561696 10714189824 1450010720 15.038 100 88 176 1 1486431744 7852128 28568896
13:59:47 26067 8192000000 10422212672 10751799296 1471756880 15.229 100 90 180 0 1509267552 8427200 29083472
14:00:21 14643 8192000000 10443698224 10777477120 1499255840 15.470 100 84 168 1 1534222752 8672208 26294704
14:00:46 15399 8192000000 10463624016 10801147904 1519016656 15.642 100 83 166 0 1554242336 9229152 25996528
14:01:11 15743 8192000000 10476728144 10817843200 1535122848 15.781 100 82 164 0 1570570256 9652464 25794944
14:01:36 24527 8192000000 10510227872 10857549824 1563814448 16.029 100 88 176 0 1601653376 10485024 27353904
14:02:10 11220 8192000000 10531267600 10881150976 1588417744 16.240 100 85 169 3 1624723648 10739120 25566784
14:02:31 11098 8192000000 10562034960 10916691968 1613265296 16.453 100 80 160 1 1648185632 10890624 24029712
14:02:50 11761 8192000000 10569903520 10930143232 1635857584 16.645 100 77 155 1 1669952144 11258608 22835952
14:03:10 14145 8192000000 10597546816 10962886656 1655844144 16.814 100 73 146 0 1687946896 11356992 20745760
14:03:32 7620 8192000000 10614302736 10984886272 1679990192 17.017 100 76 152 0 1713364736 11583632 21790912
14:03:48 8879 8192000000 10650697344 11021668352 1707672704 17.249 100 81 163 2 1746739808 15837936 23229168
14:04:06 8413 8192000000 10658283072 11033190400 1719640960 17.349 100 77 154 0 1753461968 11891216 21929792
14:04:22 8363 8192000000 10663527920 11043057664 1733013184 17.461 100 85 170 1 1769365808 12044672 24307952
14:04:43 6799 8192000000 10692014176 11067535360 1750890960 17.609 100 78 156 0 1785309584 11396016 23022608
14:05:01 7410 8192000000 10705967824 11084529664 1761160528 17.694 100 83 161 0 1797059504 12783760 23115216
14:05:17 4572 8192000000 10719055232 11095535616 1771159168 17.777 100 88 173 0 1809022720 14134176 23729376
14:05:29 6072 8192000000 10718088800 11099299840 1779454800 17.845 100 79 157 1 1815036208 13473296 22108112
14:05:42 4099 8192000000 10722532000 11102031872 1780960720 17.857 100 83 165 2 1817857696 13695456 23201520
14:05:53 4464 8192000000 10733301248 11111600128 1787869216 17.914 100 79 158 2 1823803696 14129744 21804736
14:06:04 4204 8192000000 10728380768 11113734144 1790757120 17.938 100 79 158 0 1826319024 13371264 22190640
14:06:15 3022 8192000000 10736297328 11118776320 1797362480 17.992 100 86 170 2 1833504464 12541600 23600384
14:06:25 2804 8192000000 10737792560 11124293632 1807386944 18.074 100 93 186 0 1845345072 12129392 25828736
14:06:35 3239 8192000000 10755014640 11136667648 1816564784 18.150 100 90 175 1 1852701600 12156992 23979824
14:06:44 2718 8192000000 10756831408 11138035712 1819655568 18.175 100 85 170 0 1856143632 12735744 23752320
14:06:56 3718 8192000000 10755732000 11139444736 1817020368 18.153 100 77 153 0 1851138352 12640304 21477680
14:07:07 3518 8192000000 10764041472 11153276928 1820251024 18.180 100 90 181 1 1858885312 13777248 24857040
14:07:17 2052 8192000000 10779666032 11163660288 1834707632 18.298 100 88 176 0 1872870080 13094448 25068000
14:07:26 2548 8192000000 10776878240 11164573696 1833990768 18.292 100 86 173 1 1871898128 13416896 24490464
14:07:35 1919 8192000000 10778670080 11164319744 1840654848 18.346 100 88 174 0 1879551056 13728032 25168176
14:07:43 1534 8192000000 10786484688 11170189312 1843672896 18.371 100 92 181 2 1882418848 12527376 26218576
14:07:52 2429 8192000000 10786680112 11175845888 1847531584 18.402 100 87 173 0 1885152688 13021120 24599984
14:08:01 2168 8192000000 10791180928 11179823104 1850905312 18.429 100 89 174 0 1888824768 12483952 25435504
14:08:09 1963 8192000000 10794321008 11181572096 1854491840 18.459 100 85 169 2 1890746480 12985456 23269184
14:08:18 1705 8192000000 10798695280 11188133888 1858280256 18.489 100 92 184 0 1897730400 13782752 25667392
14:08:26 1374 8192000000 10797875216 11187441664 1857357552 18.482 100 92 183 2 1896192208 12729360 26105296
14:08:34 1780 8192000000 10803049104 11193372672 1865819648 18.550 100 91 180 1 1904396000 12972752 25603600
14:08:42 1844 8192000000 10804481136 11200225280 1865726112 18.550 100 87 176 1 1903066624 12774720 24565792
14:08:51 16002 8192000000 10803516720 11198038016 1864408960 18.539 100 72 144 0 1896864992 11950480 20505552
14:09:13 17204 8192000000 10810825088 11207303168 1871683648 18.598 100 76 153 2 1904407504 12126144 20597712
14:09:37 2099 8192000000 10818964544 11213672448 1878557488 18.653 100 94 188 4 1917035632 12527280 25950864
14:09:45 1157 8192000000 10822509088 11219124224 1879155760 18.658 100 95 191 0 1920371040 14312352 26902928
14:09:54 7874 8192000000 10815125792 11213615104 1875802016 18.631 100 65 130 1 1906678032 12791824 18084192
14:10:08 14757 8192000000 10782493520 11204751360 1872721872 18.606 100 48 96 0 1896455040 9989824 13743344
14:10:31 2955 8192000000 10804923264 11214368768 1878627520 18.654 100 58 117 2 1903279152 7615136 17036496
14:10:43 3115 8192000000 10784524384 11211759616 1874049008 18.617 100 36 72 1 1892436112 8039520 10347584
14:10:57 11014 8192000000 10772733680 11209932800 1876424720 18.636 100 19 38 0 1887681616 5829040 5427856
14:11:16 7914 8192000000 10792819680 11215966208 1877375840 18.644 100 23 46 2 1890297296 6055536 6865920
14:11:31 7913 8192000000 10787485488 11218530304 1880896864 18.672 100 24 48 2 1894212096 6792912 6522320
14:11:45 13471 8192000000 10785724624 11216437248 1879805472 18.664 100 18 37 2 1895466288 10648976 5011840
14:12:06 9422 8192000000 10787477216 11219386368 1882077248 18.682 100 21 42 1 1894376592 6643936 5655408
14:12:23 11668 8192000000 10783729168 11219496960 1884011808 18.697 100 15 30 2 1893932240 5687104 4233328
14:12:46 11711 8192000000 10788348080 11223969792 1887327088 18.724 100 16 32 0 1897370896 5375424 4668384
14:13:06 8999 8192000000 10800363760 11233918976 1891507248 18.758 100 18 36 2 1901621312 5313584 4800480
14:13:21 6394 8192000000 10803240560 11235061760 1893816848 18.777 100 21 42 2 1906629824 7196336 5616640
14:13:34 13985 8192000000 10803989856 11233742848 1893299456 18.772 100 12 23 1 1901999760 5475200 3225104
14:13:54 13098 8192000000 10802226256 11234770944 1894285056 18.780 100 17 34 1 1904458208 5402288 4770864
14:14:16 65214 8192000000 10848280160 11255754752 1904670480 18.864 100 58 117 1 1927462640 4776944 18015216
14:15:28 2166 8192000000 10841076480 11260456960 1910929568 18.914 100 76 152 0 1942531248 9396688 22204992
14:15:39 9142 8192000000 10823647744 11254579200 1902847232 18.849 100 33 66 2 1918102032 6332336 8922464
14:15:56 5504 8192000000 10806313968 11236474880 1887233008 18.723 99 33 66 2 1903733504 7752944 8747552
14:16:11 5222 8192000000 10815079536 11254345728 1901353984 18.837 100 23 45 1 1914514224 6360032 6800208
14:16:23 5331 8192000000 10819549296 11254112256 1903754256 18.856 100 22 42 3 1916490240 5945248 6790736
14:16:34 5903 8192000000 10835764128 11261267968 1906767120 18.881 100 29 58 0 1921324528 6227200 8330208
14:16:48 7371 8192000000 10810727264 11241635840 1868581920 18.573 98 33 67 1 1884843872 6941728 9320224
14:17:02 5602 8192000000 10796746832 11227729920 1858610256 18.492 98 36 72 1 1875861680 5696208 11555216
14:17:13 6533 8192000000 10805157024 11237662720 1886923216 18.721 100 19 38 1 1898205072 5484224 5797632
14:17:28 50270 8192000000 10791214784 11215011840 1836574432 18.313 97 29 55 0 1850085600 5026704 8484464
14:18:28 12569 8192000000 10771155824 11208716288 1852649072 18.444 99 18 36 1 1863214720 5548640 5017008
14:18:47 5472 8192000000 10779706016 11204603904 1844700304 18.379 99 32 59 5 1859984944 7047216 8237424
14:19:00 4527 8192000000 10785451120 11205296128 1833919984 18.291 98 39 78 0 1851638592 6988560 10730048
14:19:11 6579 8192000000 10762202944 11179696128 1800807168 18.021 97 22 45 0 1813202080 4949408 7445504
14:19:26 6312 8192000000 10748583056 11166113792 1798923312 18.005 98 30 62 4 1813882000 6042528 8916160
14:19:39 14327 8192000000 10727096656 11149656064 1722297744 17.371 94 24 48 1 1739787888 11137088 6353056
14:19:59 7657 8192000000 10686057216 11105787904 1693423488 17.130 94 16 32 0 1703215920 4915456 4876976
14:20:15 4171 8192000000 10697477024 11116187648 1745034752 17.560 97 30 60 0 1759984992 6019536 8930704
14:20:27 8777 8192000000 10694600496 11116437504 1729239728 17.429 96 21 42 2 1741394048 6362880 5791440
14:20:43 8176 8192000000 10698630304 11114512384 1769852128 17.766 99 26 51 3 1783742272 5933184 7956960
14:20:58 10894 8192000000 10671248688 11083436032 1724453088 17.389 97 18 36 1 1739192176 9259824 5479264
14:21:15 8995 8192000000 10698438336 11113189376 1765100144 17.727 99 24 48 3 1777257792 5591088 6566560
14:21:34 50499 8192000000 10711520080 11117793280 1762395616 17.704 98 30 60 0 1776982688 5818592 8768480
14:22:44 12646 8192000000 10694165104 11108974592 1748827632 17.592 97 22 44 1 1759808864 5058784 5922448
14:23:04 10970 8192000000 10729864144 11144019968 1795425472 17.976 99 32 64 0 1811150560 7078096 8646992
14:23:23 7273 8192000000 10716655328 11139239936 1797188368 17.991 99 36 72 3 1815391968 7182848 11020752
14:23:36 7365 8192000000 10727438992 11145801728 1797793456 17.996 99 31 63 1 1813890976 7161456 8936064
14:23:53 11358 8192000000 10756647616 11177795584 1826954448 18.234 100 28 56 3 1848922704 14201136 7767120
14:24:12 7849 8192000000 10755964960 11179073536 1826519312 18.231 99 24 48 0 1838968592 5284064 7165216
14:24:26 8331 8192000000 10759650800 11184742400 1845634720 18.387 100 23 46 1 1857913104 6080576 6197808
14:24:42 12870 8192000000 10760531280 11189116928 1846684784 18.395 100 23 47 2 1858839968 5664608 6490576
14:25:02 8803 8192000000 10776628048 11204071424 1856991536 18.479 100 27 54 2 1871105888 6355536 7758816
14:25:19 13037 8192000000 10764500736 11202990080 1861436032 18.515 100 18 35 2 1872778688 5210880 6131776
14:25:38 10683 8192000000 10776945232 11209871360 1864123888 18.537 100 18 36 1 1875136672 5504528 5508256
14:25:55 5998 8192000000 10791724816 11214999552 1870583424 18.589 100 23 46 0 1882824528 5473376 6767728
14:26:08 7921 8192000000 10781201920 11214946304 1868950096 18.576 100 14 27 1 1877787984 5108000 3729888
14:26:26 59950 8192000000 10802410000 11224182784 1874384624 18.620 100 26 52 1 1887960144 4906736 8668784
14:27:41 68978 8192000000 10841666592 11267473408 1903746912 18.856 100 38 76 1 1923313008 8781488 10784608
14:29:06 21539 8192000000 10863103728 11285725184 1926226992 19.037 100 44 88 0 1950214800 11720720 12267088
14:29:44 6670 8192000000 10876325040 11295928320 1940689472 19.152 100 55 110 1 1971106512 14586896 15830144
14:29:57 11713 8192000000 10877818320 11300270080 1940438960 19.150 100 54 107 0 1970789680 15030832 15319888
14:30:15 5737 8192000000 10889936944 11311738880 1949541680 19.223 100 66 132 0 1984534960 15733168 19260112
14:30:28 20921 8192000000 10894690624 11318689792 1954958576 19.266 100 62 124 2 1988664704 16249872 17456256
14:30:57 14313 8192000000 10891751744 11327012864 1957058208 19.283 100 51 102 0 1992577152 20915376 14603568
14:31:29 30407 8192000000 10897831376 11332087808 1957972112 19.290 100 40 80 1 1985113824 15416016 11725696
14:32:10 38315 8192000000 10906625376 11343712256 1975937808 19.433 100 40 80 1 2004796000 17230816 11627376
14:32:55 8287 8192000000 10915994256 11347464192 1976401056 19.436 100 48 96 1 2008392352 17730400 14260896
14:33:14 10983 8192000000 10926547328 11357470720 1982403712 19.484 100 56 111 1 2018971008 20243600 16323696
14:33:38 39627 8192000000 10928668112 11366846464 1983468160 19.492 100 49 99 2 2017356288 19159296 14728832
14:34:29 21785 8192000000 10942861136 11371257856 1991537872 19.556 100 47 93 2 2025713216 19555632 14619712
14:34:58 16387 8192000000 10953246832 11382956032 1999093296 19.616 100 52 103 3 2039672528 24465072 16114160
14:35:22 11334 8192000000 10947857360 11385114624 2002173104 19.640 100 49 95 2 2039801904 23081024 14547776
14:35:41 4256 8192000000 10950109680 11378610176 1982719072 19.486 99 65 125 1 2023028960 22577136 17732752
14:35:54 13698 8192000000 10965832336 11389280256 2001895040 19.638 100 64 128 0 2048452256 27327888 19229328
14:36:19 5384 8192000000 10977107936 11402199040 2012444432 19.721 100 79 155 2 2062408096 28076352 21887312
14:36:32 1607 8192000000 10988370832 11403415552 2018873792 19.771 100 86 171 1 2071804416 28643440 24287184
14:36:45 3646 8192000000 10989891808 11408269312 2018001808 19.764 100 82 163 3 2070810224 29520208 23288208
14:37:02 2328 8192000000 10991044432 11415523328 2021968160 19.796 100 81 159 0 2077506048 32004816 23533072
14:37:11 2684 8192000000 10997094992 11416158208 2023525264 19.808 100 81 164 1 2080973856 33237488 24211104
14:37:20 4278 8192000000 10990395344 11415560192 2021917680 19.795 100 70 136 0 2075197376 33104272 20175424
14:37:32 8905 8192000000 10980496208 11405012992 2010836544 19.708 100 74 149 1 2066104096 32499184 22768368
14:37:56 6993 8192000000 10978523536 11406860288 2010159600 19.703 100 67 134 1 2062107088 32194208 19753280
14:38:16 6857 8192000000 10966096192 11391492096 1985754752 19.510 99 61 119 1 2035400784 31509152 18136880
14:38:29 4629 8192000000 10986027072 11404353536 2009260512 19.696 100 78 155 3 2065414512 32351104 23802896
14:38:42 5469 8192000000 10989264336 11412553728 2014133008 19.734 100 75 147 0 2068730576 32592240 22005328
14:38:57 11054 8192000000 10970775040 11402682368 1997430480 19.602 99 65 130 0 2051133344 33302384 20400480
14:39:17 8549 8192000000 10978664416 11414675456 2016875584 19.756 100 59 118 1 2066196048 31081824 18238640
14:39:36 3380 8192000000 10974916544 11409793024 2010864544 19.708 100 56 113 1 2063524752 35691840 16968368
14:39:50 2038 8192000000 10986421648 11406168064 2009073056 19.694 100 82 162 1 2066555312 32216224 25266032
14:40:02 6642 8192000000 10984491248 11416088576 2016397440 19.752 100 63 125 1 2069761968 34171952 19192576
14:40:17 2726 8192000000 10970907632 11402887168 2002478784 19.642 100 57 113 1 2054338160 34369728 17489648
14:40:27 9638 8192000000 10964032576 11391049728 1996933616 19.599 100 65 128 0 2049978928 33346928 19698384
14:40:44 4377 8192000000 10962497968 11387441152 1981300352 19.475 99 73 145 2 2037719312 34170320 22248640
14:40:56 3790 8192000000 10985550432 11402440704 2003381136 19.649 100 81 162 1 2065236704 36458912 25396656
14:41:06 3501 8192000000 10984858080 11405570048 2004500096 19.658 100 72 143 0 2064591328 38174352 21916880
14:41:16 2181 8192000000 10980402544 11394310144 1967599824 19.366 98 84 168 0 2031267904 38150640 25517440
14:41:26 1350 8192000000 10977320672 11397038080 1996557056 19.596 100 83 166 1 2059659728 37466720 25635952
14:41:34 4311 8192000000 10973084016 11396517888 1996068048 19.592 100 68 137 0 2055555056 38159632 21327376
14:41:47 6376 8192000000 10973254704 11397324800 1993132560 19.569 100 71 142 0 2055423872 40101632 22189680
14:42:00 3640 8192000000 10978020944 11394715648 1988069136 19.529 100 85 170 1 2056831920 41791152 26971632
14:42:11 2962 8192000000 10972990896 11396583424 1996783808 19.597 100 77 154 3 2064611744 43115584 24712352
14:42:21 2167 8192000000 10982286672 11402256384 1995866448 19.590 100 83 166 2 2064828544 42363488 26598608
14:42:33 4387 8192000000 10973204256 11396337664 1974012160 19.417 99 75 148 2 2041737856 43113552 24612144
14:42:44 3924 8192000000 10947032480 11367493632 1964784768 19.344 99 79 160 2 2029823392 40016656 25021968
14:42:55 5768 8192000000 10952747776 11378745344 1974359504 19.420 100 68 130 1 2034234416 39799488 20075424
14:43:09 3267 8192000000 10962642592 11380170752 1979787472 19.463 100 88 176 1 2047993408 40670800 27535136
14:43:22 5621 8192000000 10968944976 11384537088 1983119440 19.489 100 86 168 1 2050132368 41551840 25461088
14:43:37 1764 8192000000 10956340320 11365883904 1966869776 19.361 99 88 174 3 2034731808 41106608 26755424
14:43:47 2369 8192000000 10983863360 11394822144 1979242448 19.459 100 86 171 2 2046234912 41376320 25616144
14:43:56 1482 8192000000 10954412272 11378716672 1978279968 19.451 100 65 129 1 2035421968 37651392 19490608
14:44:09 10431 8192000000 10923502880 11365654528 1939021664 19.139 98 47 94 0 1993567344 40185088 14360592
14:44:26 7299 8192000000 10920637408 11354103808 1938460096 19.134 99 33 66 0 1985368208 36059680 10848432
14:44:44 7062 8192000000 10914756624 11341000704 1918647792 18.976 98 58 114 2 1976121776 39671584 17802400
14:45:18 11364 8192000000 10928166640 11371098112 1947561904 19.207 99 45 90 0 2004229296 42071120 14596272
14:45:37 12023 8192000000 10927091008 11361406976 1945954960 19.194 99 43 86 0 1996980496 37053072 13972464
14:45:59 10851 8192000000 10930718256 11361542144 1927159424 19.044 98 50 100 1 1987474400 44299728 16015248
14:46:16 15012 8192000000 10912746304 11364478976 1936747328 19.121 99 31 62 0 1993378080 45792704 10838048
14:46:43 8201 8192000000 10923037408 11356131328 1960093008 19.307 100 50 100 2 2012715120 36265248 16356864
14:46:59 23384 8192000000 10910153184 11354333184 1919324192 18.981 98 36 74 1 1970183920 38753008 12106720
14:47:47 30372 8192000000 10883778928 11323961344 1909606768 18.903 98 31 62 0 1952356144 32186000 10563376
14:48:37 24355 8192000000 10903792160 11354488832 1939919328 19.146 100 23 46 3 1986926768 38647520 8359920
14:49:10 20216 8192000000 10888726768 11341316096 1885757344 18.712 97 30 60 2 1941671152 45034704 10879104
14:49:38 14799 8192000000 10910775856 11348717568 1936560512 19.119 100 34 68 1 1983669072 35002256 12106304
14:50:08 29713 8192000000 10865443120 11325853696 1887816320 18.728 97 21 42 0 1921827584 26913904 7097360
14:50:44 27188 8192000000 10880336032 11332763648 1940665648 19.152 100 17 34 2 1964971392 19003296 5302448
14:51:19 46381 8192000000 10854704736 11306131456 1846101392 18.390 95 15 30 0 1869511152 18643072 4766688
14:52:12 38813 8192000000 10867925472 11320311808 1896558960 18.799 99 16 32 2 1927419568 25192560 5668048
14:53:04 46434 8192000000 10832918752 11297271808 1829385312 18.254 95 14 28 1 1857358736 23537408 4436016
14:53:58 55557 8192000000 10834320080 11297005568 1893963872 18.778 99 16 32 0 1908543600 9591184 4988544
14:55:01 25849 8192000000 10861376144 11313799168 1919808592 18.985 100 12 24 1 1934160608 11006096 3345920
14:56:08 78037 8192000000 10871389632 11320532992 1905492176 18.870 99 15 30 0 1924213616 14921552 3799888
14:57:32 77459 8192000000 10881505472 11339370496 1918199248 18.972 99 16 32 1 1931036304 8737632 4099424
14:58:56 112336 8192000000 10886676064 11349082112 1899890848 18.825 97 13 26 0 1919852544 16059936 3901760
15:01:00 58887 8192000000 10879602576 11335413760 1896647216 18.799 97 2 4 0 1905552800 8780960 124624
15:02:14 199955 8192000000 10882725232 11336720384 1880323024 18.668 96 20 41 1 1901279936 15529120 5427792
15:05:49 18075 8192000000 10894235392 11325059072 1916513280 18.959 98 46 93 3 1936375936 7101840 12760816
15:06:16 21760 8192000000 10895828768 11333623808 1947113248 19.203 100 44 88 0 1974965472 14943984 12908240
15:06:47 101870 8192000000 10904561648 11352977408 1935539936 19.111 99 30 60 1 1951440704 7963616 7937152
15:08:36 29547 8192000000 10915707120 11372077056 1976655328 19.438 100 38 76 1 1996675456 9196720 10823408
15:09:17 11160 8192000000 10915633056 11376467968 1980361312 19.468 100 39 78 2 2003696560 12577472 10757776
15:09:42 29518 8192000000 10930204528 11384504320 1988826176 19.535 100 46 92 0 2013669744 11896496 12947072
15:10:23 38592 8192000000 10918613744 11396730880 1987889376 19.527 100 26 52 2 2013423936 18066752 7467808
15:11:09 42198 8192000000 10911121680 11395481600 1966358992 19.357 99 7 14 0 1984654400 16146336 2149072
15:11:58 26242 8192000000 10907271360 11393449984 1984890832 19.503 100 8 16 0 2002921312 15970784 2059696
15:12:31 31718 8192000000 10895237200 11369099264 1967919888 19.369 99 13 26 0 1983877472 12790512 3167072
15:13:09 18163 8192000000 10912579040 11387572224 1987862432 19.527 100 14 28 0 2009011296 17427696 3721168
15:13:33 27821 8192000000 10908778512 11385954304 1987799168 19.526 100 16 32 0 2002688880 9682144 5207568
15:14:07 10987 8192000000 10905038832 11381903360 1969287616 19.380 99 13 26 2 1982593072 9244160 4061296
15:14:25 24900 8192000000 10892726928 11375005696 1940434160 19.150 98 14 28 0 1955435552 10224032 4777360
15:14:56 8192 8192000000 10893664336 11375472640 1970161760 19.387 100 12 25 0 1982301104 8570832 3568512
15:16:58 38517 8192000000 10906661168 11373318144 1979224928 19.459 100 33 66 2 1995441152 6899488 9316736
15:17:50 14186 8192000000 10913308224 11365703680 1960332896 19.309 99 51 102 4 1983278304 8258416 14686992
15:18:11 11910 8192000000 10902097408 11372728320 1972991552 19.409 100 23 46 2 1992349520 13253088 6104880
15:18:30 25455 8192000000 10909218880 11382980608 1981658864 19.478 100 16 32 3 1994978208 8426576 4892768
15:19:02 44031 8192000000 10901776816 11382423552 1966877264 19.361 99 17 34 0 1982248768 10380192 4991312
15:19:55 61713 8192000000 10901626544 11387486208 1944074640 19.179 98 15 30 2 1957057040 8594368 4388032
15:21:09 29924 8192000000 10928747264 11398488064 1989598000 19.541 100 16 32 0 2008114256 14106608 4409648
15:21:55 51730 8192000000 10911032192 11394572288 1950059920 19.227 98 12 25 2 1974985600 21163584 3762096
15:23:19 42647 8192000000 10896578768 11372204032 1963920976 19.337 99 22 44 0 1979347488 9400240 6026272
15:24:08 43038 8192000000 10926662960 11379933184 1949485696 19.222 98 29 58 0 1966642896 8867488 8289712
15:25:03 54476 8192000000 10916674000 11378454528 1959880464 19.305 99 38 76 2 1985150368 15050000 10219904
15:26:08 47416 8192000000 10904601312 11369992192 1929172576 19.060 98 30 60 1 1950221552 12717088 8331888
15:27:04 57396 8192000000 10893598672 11350249472 1920618208 18.992 97 20 40 3 1940449872 14074752 5756912
15:28:10 41852 8192000000 10901910048 11365875712 1915283600 18.949 97 23 46 0 1931492192 9865360 6343232
15:28:58 81109 8192000000 10870329792 11339415552 1871516000 18.597 95 23 45 1 1893596976 16221184 5859792
15:30:25 117301 8192000000 10881859104 11349004288 1876470368 18.637 96 9 18 1 1894698880 15911104 2317408
15:32:37 80599 8192000000 10852609120 11317448704 1854762448 18.461 95 36 72 3 1874241072 8823664 10654960
15:34:06 59774 8192000000 10817412096 11290443776 1832463920 18.279 95 20 40 0 1848832368 10937040 5431408
15:35:13 65484 8192000000 10836618016 11283734528 1819323760 18.172 95 34 68 2 1836694848 7892752 9478336
15:36:25 50728 8192000000 10834495744 11302105088 1879711952 18.663 98 39 77 1 1899548128 9171872 10664304
15:37:22 51916 8192000000 10844399104 11323506688 1924805808 19.025 100 21 42 2 1940546640 9428352 6312480
15:38:28 15309 8192000000 10827611824 11306405888 1911283488 18.917 99 4 8 0 1920550160 8250560 1016112
15:38:50 22312 8192000000 10845871968 11321266176 1911388800 18.918 99 12 24 0 1923537280 8645520 3502960
15:39:18 17163 8192000000 10852499632 11328905216 1934297008 19.101 100 13 26 1 1945388608 7447152 3644448
15:39:42 48597 8192000000 10856468800 11323252736 1904799472 18.865 98 14 28 1 1915458336 6377600 4281264
15:40:37 56294 8192000000 10842030416 11309195264 1861147152 18.513 96 20 40 1 1877796688 10500112 6149424
15:41:47 69296 8192000000 10846816960 11314941952 1894624752 18.783 99 15 30 1 1910308368 11273824 4409792
15:43:56 38223 8192000000 10843770480 11312361472 1907659360 18.888 99 16 32 1 1923028048 10815136 4553552
15:44:43 40027 8192000000 10826827840 11296227328 1870415696 18.588 97 15 30 1 1886884592 11854208 4614688
15:45:37 46456 8192000000 10842206336 11314294784 1899758560 18.824 99 17 34 1 1916285136 11877712 4648864
15:46:30 52491 8192000000 10870523264 11333734400 1901579008 18.839 98 32 64 0 1930754576 19409072 9766496
15:47:50 67106 8192000000 10849934304 11339988992 1910519376 18.911 99 16 32 1 1933367872 18246624 4601872
15:49:05 39955 8192000000 10860932896 11318018048 1892409696 18.765 98 24 47 1 1908349632 9703616 6236320
15:49:55 46346 8192000000 10867917584 11322630144 1902208192 18.844 99 26 51 1 1919102224 9932160 6961872
15:50:50 71315 8192000000 10864163488 11322757120 1880620848 18.670 97 35 70 0 1901881536 11841488 9419200
15:52:13 59460 8192000000 10881793856 11337641984 1894199760 18.780 98 30 60 2 1912916976 10652640 8064576
15:53:23 52657 8192000000 10885421072 11357147136 1920932304 18.994 99 33 66 1 1946538848 16265536 9341008
15:55:01 81395 8192000000 10870674976 11350605824 1867436496 18.564 96 11 22 1 1890695104 20326320 2932288
15:56:28 128066 8192000000 10885159376 11352698880 1939042480 19.139 99 27 54 0 1958459312 12113008 7303824
15:58:44 33240 8192000000 10880852448 11348262912 1939639056 19.144 99 24 48 0 1954437008 7909312 6888640
15:59:28 72329 8192000000 10892652000 11373584384 1966719104 19.359 100 18 36 1 1980278528 8866336 4693088
16:00:46 59580 8192000000 10895892720 11381964800 1974391856 19.420 100 6 12 0 1987153248 11371248 1390144
16:01:58 46232 8192000000 10905506992 11379818496 1960195072 19.308 99 15 30 0 1969747664 5767680 3784912
16:02:53 63220 8192000000 10898969120 11380523008 1924359872 19.022 97 14 26 1 1938554944 10695760 3499312
16:04:09 48024 8192000000 10902334592 11376472064 1954426768 19.262 99 16 31 1 1968713904 10424432 3862704
16:05:03 47903 8192000000 10929566432 11400159232 1996137856 19.592 100 18 36 0 2010962272 9944400 4880016
16:06:17 46457 8192000000 10926338560 11396087808 1946859888 19.201 97 21 42 2 1968136416 14871104 6405424
16:07:16 54485 8192000000 10913923184 11380396032 1945231520 19.188 98 21 41 1 1965936528 14643264 6061744
16:08:18 62843 8192000000 10903053168 11373174784 1920070896 18.987 97 16 32 1 1939321696 15033744 4217056
16:09:29 59342 8192000000 10927631376 11386040320 1967922704 19.369 99 16 32 2 1991850048 19260400 4666944
16:10:35 30312 8192000000 10943921488 11395846144 1980235792 19.467 99 38 76 1 2004426688 13690400 10500496
16:11:19 81816 8192000000 10921376256 11407679488 1971540944 19.398 99 28 55 4 1995867168 16227424 8098800
16:12:48 44139 8192000000 10935634800 11393028096 1958012656 19.290 98 21 40 1 1975861120 12462304 5386160
16:13:39 15455 8192000000 10931665184 11364810752 1972463344 19.405 99 49 99 2 1995077632 8803952 13810336
16:14:01 28085 8192000000 10911979664 11377356800 1977730704 19.447 100 39 78 0 2003179216 14833760 10614752
16:14:51 82814 8192000000 10893856720 11369598976 1889907024 18.745 95 20 40 1 1907561616 12083808 5570784
16:16:20 70707 8192000000 10886705216 11355762688 1874827856 18.623 95 13 26 0 1887596512 9518304 3250352
16:17:44 68060 8192000000 10885167680 11339661312 1928337200 19.054 99 21 42 1 1943103792 8922400 5844192
16:19:01 68941 8192000000 10885304192 11347185664 1892828960 18.769 96 26 50 0 1909605872 9877200 6899712
16:20:34 17979 8192000000 10864310464 11330883584 1909462448 18.902 98 22 44 1 1926564640 11182304 5919888
16:20:59 15781 8192000000 10855012448 11326529536 1920656400 18.992 99 8 16 1 1932888848 9494720 2737728
16:21:25 47255 8192000000 10849992800 11335327744 1923047856 19.011 99 12 24 3 1935294032 7946944 4299232
16:23:19 56603 8192000000 10859690304 11334344704 1910497856 18.911 98 15 30 2 1923010752 8384800 4128096
16:24:25 85175 8192000000 10888592208 11371323392 1950010352 19.227 100 14 28 0 1966121184 11979760 4131072
16:25:57 67932 8192000000 10874844064 11342766080 1877991136 18.649 96 9 18 0 1893436080 12831040 2613904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 28-01-2021 16:29:10 to 28-01-2021 16:29:42.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-01-2021 16:29:42 to 28-01-2021 16:29:44.

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          241206
MON$OLDEST_ACTIVE               242792
MON$OLDEST_SNAPSHOT             242792
MON$NEXT_TRANSACTION            242792
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                       2027744
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.33404 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33404 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33404 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33404 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 ---
:114: 
:115: mscs-test-161.budzdorov.ru    Thu Jan 28 16:27:18 2021
:116:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:117: 
:118: 
:119: mscs-test-161.budzdorov.ru    Thu Jan 28 16:27:18 2021
:120:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:121: 
:122: 
:123: mscs-test-161.budzdorov.ru    Thu Jan 28 16:27:22 2021
:124:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:125: 
--- end of diff output ---

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

28.01.21 16:29:45. 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-01-28 16:29:48 No severe PSQL-related problems occured
28.01.21 16:29:49. End of report.