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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17149780 kB
MemAvailable 31134184 kB
Buffers 0 kB
Cached 14525072 kB
SwapCached 4112 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-17 22:27:19
DTS_END                         2021-02-17 22:27:19.0740
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/41460
TRN_ID                          233798
ATT_ID                          650
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: 8844.44 20845 1061333
customer order: creation 163.96 381 19675
customer order: refuse 14.28 339 1713
order to supplier: creation 43.24 1311 5189
order to supplier: removal 3.32 95849 398
invoice (draft): creation 43.78 3757 5253
invoice (draft): removal 50.25 749 6030
invoice accept: apply 39.57 18963 4748
invoice accept: cancel 45.69 828 5483
customer reserve: creation 3659.68 186 439161
customer reserve: removal 4503.11 55 540373
realization accept: apply 80.07 177 9608
realization accept: cancel 74.06 119 8887
payment from customer: creation 55.81 117 6697
payment from customer: removal 5.90 67 708
payment to supplier: creation 46.97 135 5636
payment to supplier: removal 3.26 65 391
service: total inventory turnovers 4.68 1075 561
service: total monetary turnovers 6.02 23 722
service: aggregate perf. data 0.80 18551 96
service: refresh index statistics 0.03 274149 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-02-2021 22:28:29 to 17-02-2021 22:28:31.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1986
TEST_TIME 2 2954
TEST_TIME 3 3992
TEST_TIME 4 3790
TEST_TIME 5 3844
TEST_TIME 6 4174
TEST_TIME 7 4236
TEST_TIME 8 4603
TEST_TIME 9 4750
TEST_TIME 10 5604
TEST_TIME 11 6048
TEST_TIME 12 6124
TEST_TIME 13 6151
TEST_TIME 14 6605
TEST_TIME 15 6677
TEST_TIME 16 6807
TEST_TIME 17 7018
TEST_TIME 18 7145
TEST_TIME 19 8015
TEST_TIME 20 8922
TEST_TIME 21 9022
TEST_TIME 22 9710
TEST_TIME 23 10056
TEST_TIME 24 9785
TEST_TIME 25 9938
TEST_TIME 26 10967
TEST_TIME 27 10696
TEST_TIME 28 10820
TEST_TIME 29 10537
TEST_TIME 30 10478
TEST_TIME 31 10232
TEST_TIME 32 10294
TEST_TIME 33 10156
TEST_TIME 34 10056
TEST_TIME 35 9948
TEST_TIME 36 9799
TEST_TIME 37 9721
TEST_TIME 38 9560
TEST_TIME 39 9592
TEST_TIME 40 9484
TEST_TIME 41 9521
TEST_TIME 42 9366
TEST_TIME 43 9290
TEST_TIME 44 9225
TEST_TIME 45 9103
TEST_TIME 46 9118
TEST_TIME 47 9148
TEST_TIME 48 9059
TEST_TIME 49 9047
TEST_TIME 50 9092
TEST_TIME 51 8979
TEST_TIME 52 9073
TEST_TIME 53 9165
TEST_TIME 54 9118
TEST_TIME 55 9150
TEST_TIME 56 9292
TEST_TIME 57 9261
TEST_TIME 58 9332
TEST_TIME 59 9325
TEST_TIME 60 9376
TEST_TIME 61 9529
TEST_TIME 62 9524
TEST_TIME 63 9381
TEST_TIME 64 9301
TEST_TIME 65 9245
TEST_TIME 66 9177
TEST_TIME 67 9124
TEST_TIME 68 9093
TEST_TIME 69 9025
TEST_TIME 70 9003
TEST_TIME 71 8992
TEST_TIME 72 8984
TEST_TIME 73 8957
TEST_TIME 74 8931
TEST_TIME 75 8978
TEST_TIME 76 8972
TEST_TIME 77 8981
TEST_TIME 78 8945
TEST_TIME 79 9049
TEST_TIME 80 9012
TEST_TIME 81 9090
TEST_TIME 82 9070
TEST_TIME 83 9074
TEST_TIME 84 9188
TEST_TIME 85 9203
TEST_TIME 86 9224
TEST_TIME 87 9121
TEST_TIME 88 9089
TEST_TIME 89 9084
TEST_TIME 90 9009
TEST_TIME 91 8987
TEST_TIME 92 8934
TEST_TIME 93 8905
TEST_TIME 94 8913
TEST_TIME 95 8903
TEST_TIME 96 8934
TEST_TIME 97 8974
TEST_TIME 98 8945
TEST_TIME 99 8912
TEST_TIME 100 8915
TEST_TIME 101 8955
TEST_TIME 102 9021
TEST_TIME 103 8989
TEST_TIME 104 8989
TEST_TIME 105 9001
TEST_TIME 106 9030
TEST_TIME 107 9069
TEST_TIME 108 9051
TEST_TIME 109 8986
TEST_TIME 110 8941
TEST_TIME 111 8917
TEST_TIME 112 8924
TEST_TIME 113 8891
TEST_TIME 114 8908
TEST_TIME 115 8890
TEST_TIME 116 8889
TEST_TIME 117 8894
TEST_TIME 118 8922
TEST_TIME 119 8908
TEST_TIME 120 8847

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 17-02-2021 22:28:32 to 17-02-2021 22:28:36.

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 1467714 1467714 0 0.00 0 23003 6 0 0
doc_list_biud 1467714 1467714 0 0.00 0 60239 26 0 0
sp_add_invoice_to_stock 4842 4748 94 1.94 27 185631 18964 0 94
sp_cancel_adding_invoice 5483 5483 0 0.00 4 85255 829 0 0
sp_cancel_client_order 1713 1713 0 0.00 5 12238 339 0 0
sp_cancel_customer_reserve 540373 540373 0 0.00 1 60240 56 0 0
sp_cancel_pay_from_customer 708 708 0 0.00 2 4513 68 0 0
sp_cancel_pay_to_supplier 391 391 0 0.00 3 3313 65 0 0
sp_cancel_supplier_invoice 6037 6030 7 0.11 1 18757 750 0 7
sp_cancel_supplier_order 398 398 0 0.00 8 1049218 95850 0 0
sp_cancel_write_off 8887 8887 0 0.00 1 22246 119 0 0
sp_client_order 19675 19675 0 0.00 3 53884 382 0 0
sp_customer_reserve 439161 439161 0 0.00 0 127413 187 0 0
sp_fill_shopping_cart 30109 30109 0 0.00 1 22248 44 0 0
sp_fill_shopping_cart_clo_res 439158 439158 0 0.00 0 18464 16 0 0
sp_get_clo_for_invoice 4741 4741 0 0.00 0 37744 423 0 0
sp_kill_cost_storno 15469 15469 0 0.00 0 15603 62 0 0
sp_kill_qstorno_ret_qs2qd 1096061 1096061 0 0.00 0 57151 30 0 0
sp_kill_qty_storno 577227 577227 0 0.00 0 60237 66 0 0
sp_lock_selected_doc 19985 19985 0 0.00 0 7221 4 0 0
sp_make_cost_storno 26676 26676 0 0.00 0 16131 57 0 0
sp_multiply_rows_for_pdistr 26676 26676 0 0.00 0 9975 27 0 0
sp_multiply_rows_for_qdistr 19675 19675 0 0.00 0 53876 181 0 0
sp_pay_from_customer 6697 6697 0 0.00 4 13303 118 0 0
sp_pay_to_supplier 5636 5636 0 0.00 5 12302 136 0 0
sp_payment_common 12333 12333 0 0.00 1 10107 28 0 0
sp_qd_handle_on_cancel_clo 1713 1713 0 0.00 0 7542 302 0 0
sp_qd_handle_on_invoice_upd_sts 10218 10218 0 0.00 0 23642 340 0 0
sp_qd_handle_on_reserve_upd_sts 9608 9608 0 0.00 0 10382 55 0 0
sp_reserve_write_off 9608 9608 0 0.00 6 16141 178 0 0
sp_supplier_invoice 5253 5253 0 0.00 5 88351 3757 0 0
sp_supplier_order 5189 5189 0 0.00 5 37413 1311 0 0
srv_aggregate_perf_data 97 96 1 1.03 2591 125310 18551 0 1
srv_fill_mon_cache_memory 156 156 0 0.00 1449 167525 34129 0 0
srv_find_qd_qs_mism 1015760 1015760 0 0.00 0 23002 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 29 26582 1075 0 0
srv_make_money_saldo 722 722 0 0.00 1 763 24 0 0
srv_recalc_idx_stat 4 4 0 0.00 161983 362074 274149 0 0
t$perf-abend:sp_add_invoice_to_stock 94 94 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-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4748 4748 0 0.00 0 12011 172 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 1 3599 109 0 0
t$perf-norm:sp_cancel_client_order 1713 1713 0 0.00 0 2223 15 0 0
t$perf-norm:sp_cancel_customer_reserve 674 674 0 0.00 0 2323 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 708 708 0 0.00 0 7569 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 391 391 0 0.00 0 2488 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 388 388 0 0.00 0 1311 21 0 0
t$perf-norm:sp_cancel_supplier_order 398 398 0 0.00 0 23953 1445 0 0
t$perf-norm:sp_cancel_write_off 974 974 0 0.00 0 3869 9 0 0
t$perf-norm:sp_client_order 19675 19675 0 0.00 0 6672 17 0 0
t$perf-norm:sp_customer_reserve 989 989 0 0.00 0 1420 5 0 0
t$perf-norm:sp_pay_from_customer 6697 6697 0 0.00 0 7269 10 0 0
t$perf-norm:sp_pay_to_supplier 5636 5636 0 0.00 0 4822 11 0 0
t$perf-norm:sp_reserve_write_off 9608 9608 0 0.00 0 7763 13 0 0
t$perf-norm:sp_supplier_invoice 5253 5253 0 0.00 0 6486 20 0 0
t$perf-norm:sp_supplier_order 5189 5189 0 0.00 0 3951 17 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 30 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 3001 25 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 1307 22 0 0
t$perf-norm:srv_make_money_saldo 722 722 0 0.00 0 2450 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 9658 9470 188 1.94 0 14968 24 0 188
v_all_customers 35822 35822 0 0.00 0 21 1 0 0
v_all_suppliers 28990 28990 0 0.00 0 92 1 0 0
v_all_wares 39348 39348 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 2390 10 0 0
v_cancel_client_order 3426 3426 0 0.00 0 12173 11 0 0
v_cancel_customer_prepayment 1416 1416 0 0.00 0 4499 9 0 0
v_cancel_customer_reserve 1348 1348 0 0.00 0 2864 7 0 0
v_cancel_payment_to_supplier 782 782 0 0.00 0 3303 7 0 0
v_cancel_supplier_invoice 790 776 14 1.77 0 3444 17 0 14
v_cancel_supplier_order 796 796 0 0.00 0 711 4 0 0
v_cancel_write_off 1948 1948 0 0.00 0 5743 19 0 0
v_max_id_clo_ord 5189 5189 0 0.00 0 396 1 0 0
v_max_id_clo_res 989 989 0 0.00 0 1587 10 0 0
v_max_id_ord_sup 5246 5246 0 0.00 0 7873 8 0 0
v_max_non_paid_invoice 1575 1575 0 0.00 0 338 2 0 0
v_max_non_paid_realizn 3606 3606 0 0.00 0 4159 7 0 0
v_min_id_clo_ord 5189 5189 0 0.00 0 3260 8 0 0
v_min_id_clo_res 989 989 0 0.00 0 5679 23 0 0
v_min_id_ord_sup 5245 5245 0 0.00 0 7910 5 0 0
v_min_non_paid_invoice 5636 5636 0 0.00 0 10091 16 0 0
v_min_non_paid_realizn 6697 6697 0 0.00 0 8238 19 0 0
v_our_firm 9708 9708 0 0.00 0 11 1 0 0
v_reserve_write_off 19216 19216 0 0.00 0 9825 8 0 0
x_lock_depdocs_on_canc_invoice 11125 11125 0 0.00 0 16458 110 0 0
x_lock_depdocs_on_canc_sup_ord 398 398 0 0.00 0 7040 386 0 0
x_make_qstorno_1000_1200 5189 5189 0 0.00 1 37396 1220 0 0
x_make_qstorno_1200_2000 5253 5253 0 0.00 2 88342 3599 0 0
x_make_qstorno_2100_3300 439161 439161 0 0.00 0 127412 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-02-2021 22:28:37 to 17-02-2021 22:28:41.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:22 10 8192000000 8800800080 8812068864 6918096 0.084 2 1 2 0 7037472 56816 62560
19:57:29 17968 8192000000 10249021296 10554744832 929837856 10.193 74 59 114 1 951769792 2485856 19446080
19:57:54 28654 8192000000 10336927696 10649690112 1381845600 14.433 100 86 170 1 1414018176 4752608 27419968
19:58:32 14706 8192000000 10365719744 10684944384 1418793648 14.762 100 92 184 0 1455973296 6374160 30805488
19:59:00 30962 8192000000 10396098704 10719080448 1444922304 14.993 100 84 168 0 1479566192 7222448 27421440
19:59:41 24108 8192000000 10424077936 10750349312 1473641536 15.246 100 91 182 0 1511001040 7660496 29699008
20:00:14 25763 8192000000 10445573296 10778308608 1500209264 15.478 100 88 176 0 1536418560 8306752 27902544
20:00:49 1878 8192000000 10453147200 10788093952 1512866640 15.588 100 84 168 0 1548504672 8856192 26781840
20:01:03 34409 8192000000 10481024992 10819837952 1528700304 15.726 100 80 160 1 1562966208 8854960 25410944
20:01:52 17019 8192000000 10509766080 10855460864 1567047312 16.057 100 83 166 0 1602656080 9973072 25635696
20:02:16 18369 8192000000 10549464240 10897006592 1602757232 16.363 100 84 168 0 1638426848 10441680 25227936
20:02:44 14595 8192000000 10552780016 10912788480 1608821344 16.415 100 74 147 2 1641589104 10693952 22073808
20:03:07 16304 8192000000 10575663840 10934808576 1636469328 16.650 100 84 169 1 1673450992 11298064 25683600
20:03:38 13428 8192000000 10605589536 10967187456 1664834016 16.890 100 80 159 0 1700295632 11819328 23642288
20:04:07 10529 8192000000 10625855024 10992877568 1688276992 17.087 100 82 164 2 1725709296 13488640 23943664
20:04:26 7462 8192000000 10634606032 11007275008 1702778880 17.208 100 77 153 1 1737110544 12471184 21860480
20:04:41 7955 8192000000 10650032000 11021209600 1716658032 17.324 100 79 158 2 1751951952 12654880 22639040
20:04:57 5776 8192000000 10664409568 11038117888 1727591632 17.415 100 78 155 0 1762661792 12700304 22369856
20:05:09 6091 8192000000 10679567600 11053555712 1737728048 17.500 100 67 134 1 1769128048 11936432 19463568
20:05:23 4805 8192000000 10681379184 11060129792 1749454544 17.597 100 77 153 0 1782889136 12151952 21282640
20:05:35 4305 8192000000 10706119248 11084206080 1760642400 17.690 100 72 144 1 1793207280 12464400 20100480
20:05:47 4075 8192000000 10705325808 11086368768 1771916816 17.783 100 75 150 1 1804735200 12494352 20324032
20:05:58 3602 8192000000 10718202624 11100774400 1788363424 17.918 100 77 155 1 1822164080 12717168 21083488
20:06:08 10268 8192000000 10718132928 11106017280 1789904016 17.931 100 75 150 0 1824790832 13812160 21074656
20:06:28 2971 8192000000 10745975312 11135053824 1809282704 18.090 100 80 160 0 1844628208 12312880 23032624
20:06:38 3648 8192000000 10757574208 11142316032 1817875936 18.160 100 80 160 4 1852610368 11386688 23347744
20:06:48 3102 8192000000 10758780704 11145342976 1825118624 18.219 100 79 158 2 1859491648 12151840 22221184
20:06:58 4022 8192000000 10768890992 11156074496 1831673248 18.273 100 80 158 2 1867570944 13086240 22811456
20:07:09 3938 8192000000 10784110704 11171569664 1843098032 18.366 100 83 166 0 1879617760 13061504 23458224
20:07:19 2769 8192000000 10794400304 11180343296 1848030224 18.406 100 89 176 2 1886954448 14229120 24695104
20:07:28 2552 8192000000 10799448992 11185291264 1854662736 18.460 100 89 178 2 1893848368 15087904 24097728
20:07:37 2008 8192000000 10806031920 11191177216 1859609120 18.500 100 91 182 1 1899657280 14480048 25568112
20:07:46 1658 8192000000 10805424528 11193827328 1861659120 18.517 100 92 184 2 1902471984 14431616 26381248
20:07:54 1762 8192000000 10804844976 11191148544 1866298320 18.554 100 89 179 0 1904578848 13910432 24370096
20:08:02 2006 8192000000 10804364272 11192254464 1865117984 18.545 100 91 179 2 1902333728 12373664 24842080
20:08:11 2239 8192000000 10818923808 11204726784 1868132928 18.569 100 91 183 1 1906482304 12157408 26191968
20:08:19 1550 8192000000 10821822864 11208093696 1875670432 18.630 100 98 196 2 1917195440 13092240 28432768
20:08:27 1449 8192000000 10823223824 11209052160 1874009072 18.617 100 94 188 1 1912753264 12331120 26413072
20:08:35 39215 8192000000 10788797952 11204780032 1867872688 18.567 100 47 93 1 1890404976 9281792 13250496
20:09:21 5534 8192000000 10783400336 11202904064 1868431840 18.572 100 36 72 2 1886246608 7675536 10139232
20:09:35 3461 8192000000 10789154512 11207245824 1872806064 18.607 100 47 95 2 1894591472 7878016 13907392
20:09:46 5829 8192000000 10793670496 11208581120 1875454224 18.628 100 32 64 2 1890860992 6891136 8515632
20:09:59 5634 8192000000 10800880752 11217301504 1876769072 18.639 100 38 76 2 1896143728 8828704 10545952
20:10:12 5288 8192000000 10804869792 11219099648 1877311264 18.643 100 37 76 1 1895326000 6750880 11263856
20:10:25 3682 8192000000 10792671104 11216642048 1877680480 18.646 100 32 63 1 1893916384 7754272 8481632
20:10:41 11311 8192000000 10786332800 11215212544 1877446800 18.644 100 22 45 2 1889770736 6637072 5686864
20:10:59 6383 8192000000 10790938912 11219742720 1883559760 18.694 100 30 60 0 1898963744 7480592 7923392
20:11:17 7774 8192000000 10798779424 11226431488 1888617344 18.735 100 30 61 0 1903706048 6624240 8464464
20:11:34 6575 8192000000 10796569120 11228303360 1890118208 18.747 100 27 54 0 1904326272 6481728 7726336
20:11:47 7921 8192000000 10807990864 11235463168 1894697568 18.784 100 29 58 2 1910423856 6970032 8756256
20:12:01 8601 8192000000 10809327152 11236638720 1895485504 18.790 100 20 39 1 1906712176 5732576 5494096
20:12:17 10961 8192000000 10807201680 11239768064 1899409040 18.822 100 41 82 1 1918593328 7056000 12128288
20:12:35 66749 8192000000 10814073104 11245985792 1899102672 18.819 100 28 56 0 1912637984 5207024 8328288
20:13:48 8297 8192000000 10810098944 11249393664 1901022864 18.835 100 19 37 1 1912066848 6289424 4754560
20:14:08 5768 8192000000 10822028864 11253223424 1905228384 18.868 100 27 54 1 1918201328 6113408 6859536
20:14:22 6443 8192000000 10817552576 11252764672 1907405712 18.886 100 20 38 1 1917832992 4982144 5445136
20:14:35 4547 8192000000 10828913184 11257696256 1912051408 18.923 100 32 62 2 1926611296 5593424 8966464
20:14:45 5348 8192000000 10833003232 11259592704 1913498368 18.935 100 31 62 1 1928141440 6031280 8611792
20:14:57 8133 8192000000 10829760368 11263307776 1913457472 18.934 100 27 54 0 1928092736 7330160 7305104
20:15:12 11858 8192000000 10830048112 11264585728 1912640272 18.928 100 22 44 1 1925047408 5320112 7087024
20:15:32 11433 8192000000 10835838208 11274469376 1917825408 18.969 100 15 31 1 1927099984 5186560 4088016
20:15:50 6731 8192000000 10832669696 11270057984 1923028848 19.011 100 22 44 3 1935782480 5889008 6864624
20:16:03 8515 8192000000 10835487008 11275276288 1922094832 19.004 100 20 40 1 1934110288 6322544 5692912
20:16:19 10815 8192000000 10820212000 11255160832 1882591456 18.686 98 26 52 2 1896779744 6945200 7243088
20:16:36 17891 8192000000 10821965984 11265732608 1917198224 18.964 100 18 33 2 1927188704 5300816 4689664
20:17:00 7557 8192000000 10799906384 11232571392 1854401088 18.458 97 17 32 2 1864919072 5670128 4847856
20:17:14 19475 8192000000 10804008400 11226693632 1811537008 18.108 95 22 44 0 1827367664 9259200 6571456
20:17:40 53980 8192000000 10760416928 11194421248 1835055728 18.301 97 23 45 1 1847275072 5223584 6995760
20:18:45 7439 8192000000 10783559808 11205033984 1804630368 18.052 96 20 40 2 1814893600 5012320 5250912
20:19:00 9523 8192000000 10744162576 11167625216 1753235488 17.628 94 35 70 4 1769926944 6842480 9848976
20:19:18 6459 8192000000 10747093936 11162021888 1753228416 17.628 95 37 74 2 1771621952 7414160 10979376
20:19:31 9160 8192000000 10724164928 11143036928 1752125344 17.619 96 30 61 1 1771038240 10180368 8732528
20:19:47 7783 8192000000 10659716112 11069374464 1661936848 16.865 91 30 60 1 1681728512 11167200 8624464
20:20:01 8890 8192000000 10661639344 11072475136 1672052960 16.950 95 23 46 3 1684156016 4980048 7123008
20:20:17 8600 8192000000 10669984480 11089182720 1733619872 17.466 98 31 62 1 1750305600 7492224 9193504
20:20:34 9418 8192000000 10667698240 11081465856 1727056944 17.411 97 31 62 1 1741533248 4719856 9756448
20:20:52 11174 8192000000 10688029392 11103236096 1698688832 17.174 95 26 54 1 1715735056 9317904 7728320
20:21:14 5890 8192000000 10737602256 11147005952 1817454800 18.157 100 41 84 2 1835110560 5089040 12566720
20:21:26 6217 8192000000 10701437872 11126865920 1782940448 17.874 99 23 46 0 1795458864 5697728 6820688
20:21:39 14179 8192000000 10735379056 11154325504 1783989856 17.882 98 21 42 2 1800184912 9920512 6274544
20:22:01 13472 8192000000 10728945552 11153559552 1808802176 18.086 99 26 51 3 1821712624 5414304 7496144
20:22:22 73808 8192000000 10733733536 11169087488 1820619744 18.183 99 32 63 1 1835880464 5550960 9709760
20:23:41 10372 8192000000 10770012304 11186212864 1841195136 18.351 100 33 61 1 1856308976 6845888 8267952
20:24:04 4383 8192000000 10784805120 11198324736 1855167568 18.464 100 42 84 3 1873012560 6183280 11661712
20:24:14 6844 8192000000 10782381536 11193942016 1840608784 18.346 99 33 66 2 1855318560 5625872 9083904
20:24:29 8306 8192000000 10772842096 11200069632 1860427536 18.507 100 31 60 1 1875086480 5873072 8785872
20:24:45 5171 8192000000 10796204416 11212517376 1866427008 18.555 100 41 81 1 1885054608 6019760 12607840
20:25:02 7600 8192000000 10778310272 11213127680 1871065648 18.593 100 34 68 2 1887112608 5645072 10401888
20:25:15 7624 8192000000 10779612544 11212812288 1870721280 18.590 100 17 34 0 1881030416 5414368 4894768
20:25:30 7364 8192000000 10784422128 11218763776 1875134544 18.626 100 26 52 1 1888171984 5685680 7351760
20:25:44 7724 8192000000 10783669408 11222876160 1875861968 18.632 100 19 38 0 1887064144 5286000 5916176
20:25:58 7664 8192000000 10800622896 11233361920 1883550816 18.694 100 28 56 2 1901883504 9178176 9154512
20:26:16 13452 8192000000 10798081760 11236777984 1887818480 18.728 100 36 72 3 1908972400 10019472 11134448
20:26:38 13264 8192000000 10794424464 11231838208 1885097440 18.706 100 13 25 1 1894188208 5658080 3432688
20:27:00 54377 8192000000 10832974864 11251970048 1896816608 18.801 100 31 62 3 1916016288 10043440 9156240
20:28:02 57038 8192000000 10860897056 11277737984 1922238480 19.005 100 54 108 0 1946168128 7973792 15955856
20:29:14 6460 8192000000 10876791568 11290185728 1932324192 19.085 100 63 126 1 1959936960 9749440 17863328
20:29:55 34000 8192000000 10875054672 11304685568 1943508432 19.175 100 48 96 2 1970656624 13897760 13250432
20:30:44 20257 8192000000 10886865552 11316523008 1950837568 19.233 100 30 60 0 1969502128 10221328 8443232
20:31:14 23966 8192000000 10898529808 11335835648 1962981376 19.330 100 36 72 2 1992746416 18537408 11227632
20:31:47 35779 8192000000 10917149264 11349827584 1974091216 19.418 100 37 75 2 2004814192 19419168 11303808
20:32:34 31480 8192000000 10930932704 11362344960 1980918512 19.472 100 53 106 1 2018043024 21119232 16005280
20:33:24 22094 8192000000 10933773152 11377307648 1988673584 19.533 100 34 68 0 2024825648 25978064 10174000
20:33:53 6227 8192000000 10950685472 11379220480 1993094768 19.568 100 41 82 1 2031313952 25724512 12494672
20:34:11 9531 8192000000 10935683568 11369000960 1973424048 19.413 99 53 106 1 2016971744 27740608 15807088
20:34:30 5817 8192000000 10950373440 11379769344 1994524672 19.580 100 63 125 1 2042190544 28593040 19072832
20:34:51 3864 8192000000 10950114448 11380518912 1999625888 19.620 100 59 118 1 2047163856 29477152 18060816
20:35:03 9265 8192000000 10949253344 11384504320 1998417424 19.610 100 55 110 1 2045423904 29869328 17137152
20:35:22 6253 8192000000 10955984224 11390910464 2003139152 19.647 100 53 106 1 2049296720 29941920 16215648
20:35:36 8762 8192000000 10955909408 11393167360 2005451232 19.666 100 57 111 1 2050308320 28420816 16436272
20:35:53 7376 8192000000 10970910912 11406512128 2012490768 19.721 100 53 106 1 2066127376 38179744 15456864
20:36:18 5913 8192000000 10983901040 11412246528 2014647936 19.738 100 66 131 1 2067786368 33811296 19327136
20:36:35 4991 8192000000 10992784736 11419766784 2019294704 19.775 100 67 134 0 2079448080 40269376 19884000
20:36:49 1793 8192000000 11001962368 11419041792 2024217328 19.813 100 83 162 0 2085148832 36945760 23985744
20:36:59 2681 8192000000 10998152176 11420397568 2025426032 19.823 100 77 152 1 2086170800 38190272 22554496
20:37:08 3297 8192000000 11004143552 11428569088 2025440432 19.823 100 76 154 0 2087725568 38768800 23516336
20:37:18 5258 8192000000 10995522928 11422851072 2023316352 19.806 100 72 143 0 2083364832 38041936 22006544
20:37:32 1446 8192000000 10997355792 11414511616 2016540944 19.753 100 93 191 0 2078198576 33466224 28191408
20:37:42 3364 8192000000 10993813648 11419344896 2018724960 19.770 100 78 154 3 2076866960 35341328 22800672
20:37:54 10934 8192000000 10984001952 11418800128 2019263680 19.774 100 63 124 2 2074149696 36517712 18368304
20:38:14 5782 8192000000 10998581696 11429019648 2025221264 19.821 100 69 137 0 2081953568 36090352 20641952
20:38:27 10302 8192000000 10996711040 11424804864 2026141120 19.828 100 67 132 1 2080864592 34969776 19753696
20:38:48 3366 8192000000 10994868912 11419607040 2002675216 19.644 99 68 134 2 2059256160 36596032 19984912
20:38:59 4441 8192000000 10981953024 11413745664 2003591232 19.651 99 76 149 0 2064075632 37606928 22877472
20:39:17 4825 8192000000 10995336912 11416805376 2016023072 19.749 100 78 156 2 2078685232 38589712 24072448
20:39:29 6302 8192000000 10987142768 11409952768 2014177008 19.734 100 72 144 1 2073518032 37809888 21531136
20:39:47 9009 8192000000 10954308832 11384803328 1983617264 19.493 99 62 124 1 2044599504 42723392 18258848
20:40:03 3353 8192000000 10978423968 11407396864 1992714848 19.565 99 75 150 4 2052380560 37556688 22109024
20:40:14 2660 8192000000 10989976880 11415883776 2013954768 19.733 100 76 153 2 2077163072 38916400 24291904
20:40:23 3617 8192000000 10975786144 11394387968 1973836864 19.416 98 87 171 0 2038677952 39700608 25140480
20:40:35 2584 8192000000 10973464896 11395444736 1978410496 19.452 99 76 151 1 2042322528 40679344 23232688
20:40:46 6916 8192000000 10989491872 11412402176 2003318608 19.649 100 74 148 2 2068141920 42139600 22683712
20:41:00 5100 8192000000 10991510304 11412877312 2007874784 19.685 100 76 150 1 2073176064 42506928 22794352
20:41:15 7622 8192000000 10995166720 11426258944 2014879296 19.740 100 73 144 2 2081943776 44446016 22618464
20:41:30 2843 8192000000 10983322688 11399229440 1992173248 19.561 99 88 174 3 2063805520 44836832 26795440
20:41:46 2662 8192000000 10980326928 11412062208 2003158960 19.648 100 74 148 2 2072176592 46295248 22722384
20:41:57 2489 8192000000 10978880128 11393101824 1978500512 19.453 99 90 179 0 2047276784 42029600 26746672
20:42:06 5413 8192000000 10954480864 11366604800 1959552704 19.302 99 80 160 1 2027654352 43331696 24769952
20:42:19 6699 8192000000 10958884896 11380760576 1975582288 19.430 100 68 137 0 2039502784 43085712 20834784
20:42:37 3173 8192000000 10974532608 11399680000 1988200048 19.530 100 69 138 1 2053998160 44183248 21614864
20:42:54 1598 8192000000 10945007504 11367194624 1957454448 19.286 99 70 140 3 2026226592 47200016 21572128
20:43:06 3676 8192000000 10982848080 11397898240 1987103280 19.521 100 86 172 1 2062129008 48101184 26924544
20:43:16 2902 8192000000 10953153728 11372580864 1948604368 19.215 98 81 162 2 2022526576 48849376 25072832
20:43:25 1544 8192000000 10978800416 11390566400 1978136016 19.450 100 91 182 0 2057569712 50471168 28962528
20:43:35 1717 8192000000 10950877520 11356090368 1951079328 19.235 99 78 156 1 2026764288 50815776 24869184
20:43:43 3137 8192000000 10949955104 11359383552 1953754864 19.256 100 87 174 2 2031185952 50319184 27111904
20:43:57 4951 8192000000 10948305936 11365183488 1943776704 19.177 99 69 138 1 2017308864 51813792 21718368
20:44:10 3826 8192000000 10960026656 11375267840 1965709280 19.351 100 77 154 0 2042524496 51477456 25337760
20:44:22 2437 8192000000 10974118928 11384688640 1971786576 19.400 100 83 167 0 2050291520 51723120 26781824
20:44:33 4212 8192000000 10956647088 11379257344 1965090000 19.346 100 79 156 1 2042291184 52698672 24502512
20:44:47 5467 8192000000 10954645552 11367923712 1939771216 19.145 99 82 164 0 2020181072 54205696 26204160
20:45:00 2465 8192000000 10960295984 11371462656 1940638832 19.152 99 90 181 2 2023410336 54146992 28624512
20:45:09 4138 8192000000 10950242416 11364282368 1951189280 19.236 100 80 160 1 2033133984 56416384 25528320
20:45:21 1476 8192000000 10973859712 11383091200 1967362656 19.365 100 88 178 2 2051778784 56766448 27649680
20:45:31 3248 8192000000 10967875920 11370520576 1954112144 19.259 100 88 177 3 2041508352 58960960 28435248
20:45:41 5148 8192000000 10950329136 11367866368 1949887936 19.226 100 76 150 1 2033765312 59965456 23911920
20:45:53 2786 8192000000 10957466080 11369824256 1954263840 19.260 100 73 146 2 2039836816 61764496 23808480
20:46:06 3009 8192000000 10959348592 11374166016 1952918416 19.250 100 77 155 2 2041599712 63120560 25560736
20:46:15 13342 8192000000 10933819504 11368886272 1949199456 19.220 100 58 116 1 2032918512 64352128 19366928
20:46:35 21597 8192000000 10910719616 11355971584 1914105856 18.940 98 45 90 1 1984624160 55109312 15408992
20:47:10 17811 8192000000 10904223056 11345199104 1907737120 18.888 98 40 79 0 1971737712 50721808 13278784
20:47:38 13459 8192000000 10866186464 11308421120 1870849168 18.591 97 29 58 0 1918639952 38033184 9757600
20:48:03 16730 8192000000 10886389840 11325423616 1920816704 18.993 100 45 90 0 1968037360 31658144 15562512
20:48:40 7113 8192000000 10885702896 11318820864 1919618896 18.984 100 47 94 0 1971020656 35899696 15502064
20:49:04 32376 8192000000 10873935776 11328438272 1918962448 18.979 100 19 38 1 1961808768 35974512 6871808
20:49:56 20809 8192000000 10870825824 11323817984 1913722320 18.937 100 21 42 0 1951046448 30606272 6717856
20:50:27 10870 8192000000 10871156064 11326521344 1905245552 18.868 99 25 50 3 1948111008 34397440 8468016
20:50:45 34845 8192000000 10867028480 11318247424 1902116256 18.843 99 16 32 1 1933815200 27058896 4640048
20:51:53 41232 8192000000 10880485184 11332911104 1903464384 18.854 99 21 41 2 1946683216 35595568 7623264
20:53:17 46856 8192000000 10837270960 11304169472 1838550752 18.329 96 16 32 0 1873434304 29649376 5234176
20:54:35 35089 8192000000 10859090880 11299508224 1897884736 18.809 99 35 68 3 1921287984 13390352 10012896
20:55:17 66471 8192000000 10850629664 11295825920 1876120048 18.634 98 21 42 1 1895432000 13580240 5731712
20:56:58 19279 8192000000 10878091408 11307048960 1924517136 19.023 100 51 100 0 1949319600 10800736 14001728
20:57:25 26767 8192000000 10876542336 11319324672 1930761712 19.073 100 32 64 0 1948847824 9362416 8723696
20:57:58 34605 8192000000 10908044560 11334742016 1949530016 19.223 100 57 116 0 1975624672 9978352 16116304
20:58:41 26625 8192000000 10869231568 11316260864 1927894112 19.050 99 45 89 1 1952468160 12697808 11876240
20:59:22 51620 8192000000 10862481360 11332792320 1941973472 19.163 100 11 20 1 1954669008 10019024 2676512
21:00:24 164620 8192000000 10852977248 11316514816 1891157712 18.755 97 8 17 0 1900750240 7535664 2056864
21:03:16 25053 8192000000 10862828720 11324747776 1940882208 19.154 100 12 24 0 1951215936 6917504 3416224
21:03:47 49769 8192000000 10879592608 11342098432 1939616272 19.144 99 18 35 0 1955467216 10987808 4863136
21:04:43 82238 8192000000 10881035376 11351040000 1952524736 19.247 100 14 28 1 1970677872 13666944 4486192
21:06:56 89108 8192000000 10866845488 11328401408 1932698832 19.088 98 47 93 1 1955156016 9047440 13409744
21:08:31 68386 8192000000 10881282848 11349540864 1964843648 19.345 100 17 33 1 1977468352 7792784 4831920
21:10:02 23276 8192000000 10898331504 11354140672 1952105104 19.243 99 23 47 0 1968477872 9686496 6686272
21:10:32 3634 8192000000 10904888016 11353935872 1966772560 19.360 100 36 72 0 1985792832 9285216 9735056
21:10:44 7158 8192000000 10900298720 11365232640 1970128544 19.386 100 25 50 1 1992796336 15433920 7233872
21:11:14 61292 8192000000 10875148208 11348385792 1933040160 19.091 98 14 28 0 1950270816 12852720 4377936
21:12:22 50507 8192000000 10895523168 11347546112 1962332704 19.325 100 9 18 0 1977508192 12515664 2659824
21:13:22 62634 8192000000 10899283760 11347091456 1924893104 19.026 98 21 42 0 1949636368 17561296 7181968
21:14:39 34845 8192000000 10885615344 11344523264 1941501424 19.159 99 36 72 0 1960551280 8589584 10460272
21:15:21 48438 8192000000 10888464784 11352162304 1962557904 19.326 100 14 28 0 1976833696 10177440 4098352
21:16:17 50592 8192000000 10882147824 11351875584 1951484784 19.238 99 26 52 0 1967420464 8221328 7714352
21:17:14 107031 8192000000 10911751840 11371233280 1953827632 19.257 99 24 48 1 1972912832 12584592 6500608
21:19:08 56633 8192000000 10893326960 11363536896 1936627936 19.120 98 21 42 1 1955370832 12994432 5748464
21:20:19 46578 8192000000 10893623888 11363557376 1956338672 19.277 100 23 46 2 1970633056 8073712 6220672
21:21:20 45205 8192000000 10923923984 11385503744 1965469120 19.349 99 24 48 1 1987096288 14626992 7000176
21:22:22 81699 8192000000 10895898496 11383803904 1961889136 19.321 99 10 20 2 1983486848 18794064 2803648
21:23:51 17701 8192000000 10908123376 11362050048 1956664016 19.280 99 35 67 0 1974107200 6471888 10971296
21:24:19 11254 8192000000 10906214928 11355242496 1954910352 19.266 99 44 88 1 1976377312 9143024 12323936
21:24:40 11810 8192000000 10918840912 11366526976 1974285232 19.419 100 44 88 2 1997864560 11467680 12111648
21:25:00 37108 8192000000 10896594608 11359444992 1949818512 19.225 99 29 58 0 1970208688 12474784 7915392
21:27:06 103067 8192000000 10909161600 11379646464 1917333344 18.965 97 17 34 2 1934636448 12929040 4374064
21:28:55 76868 8192000000 10855580064 11322630144 1867772960 18.566 95 8 16 0 1893062480 23331824 1957696
21:30:55 45120 8192000000 10884917056 11332915200 1933892688 19.098 100 42 86 3 1957021344 11340384 11788272
21:31:50 37330 8192000000 10833814416 11310202880 1897393632 18.805 98 14 28 1 1912468416 11467696 3607088
21:32:34 22703 8192000000 10833726272 11303682048 1885614208 18.710 98 6 12 1 1893194400 6094432 1485760
21:33:09 35756 8192000000 10846622208 11315638272 1904850256 18.865 99 10 20 1 1914258800 6774848 2633696
21:33:56 53989 8192000000 10869188416 11342315520 1952076368 19.243 100 16 32 0 1965262288 8713824 4472096
21:35:11 85540 8192000000 10854611072 11333529600 1897446480 18.806 97 9 18 1 1908199872 7925728 2827664
21:36:51 45452 8192000000 10843765056 11320135680 1896843296 18.801 97 26 51 0 1911103408 6982480 7277632
21:37:47 60228 8192000000 10853856368 11332771840 1915568800 18.951 99 14 28 1 1934072096 14969984 3533312
21:38:56 33815 8192000000 10865106896 11346395136 1943024992 19.171 100 10 20 0 1960976128 15571968 2379168
21:39:36 54218 8192000000 10860745600 11329740800 1848139776 18.407 95 14 28 1 1863107152 11106336 3861040
21:40:37 53826 8192000000 10857531296 11304435712 1828127968 18.244 94 21 42 3 1843639648 9561360 5950320
21:41:40 42443 8192000000 10838389248 11302977536 1875337056 18.627 97 20 40 1 1891702448 10742512 5622880
21:42:31 73857 8192000000 10840326384 11293077504 1820804192 18.184 95 10 19 1 1833757536 10280144 2673200
21:43:52 15617 8192000000 10831365184 11287212032 1873648816 18.614 98 55 110 0 1897542656 8239664 15654176
21:44:18 22369 8192000000 10864190448 11314917376 1900658080 18.832 99 44 88 0 1925033584 12206256 12169248
21:44:49 39486 8192000000 10855914480 11324366848 1906600560 18.879 99 41 82 1 1934930336 16982448 11347328
21:45:53 88164 8192000000 10857126944 11321647104 1909636752 18.904 99 19 38 1 1930023872 14744128 5642992
21:47:28 54903 8192000000 10854235904 11327127552 1899253728 18.820 98 34 66 2 1925045664 16125440 9666496
21:48:32 64181 8192000000 10860736768 11323346944 1874608304 18.622 97 22 42 1 1892896608 12321312 5966992
21:49:48 73596 8192000000 10875883600 11352670208 1918307216 18.973 99 13 26 0 1947940848 25665520 3968112
21:51:09 87438 8192000000 10884440048 11369508864 1893872512 18.777 98 13 22 1 1914515840 17158352 3484976
21:52:47 90899 8192000000 10861698240 11348733952 1898416048 18.814 98 5 10 0 1919023296 18932768 1674480
21:54:30 90068 8192000000 10858206576 11343261696 1947923616 19.210 100 29 58 1 1966783632 10434944 8425072
21:56:18 74395 8192000000 10863729056 11352387584 1947631328 19.208 100 8 16 2 1957616048 8494960 1489760
21:57:39 16126 8192000000 10863425456 11349913600 1948499888 19.215 100 7 14 1 1960563024 10414032 1649104
21:58:02 11452 8192000000 10865768128 11352596480 1951393200 19.238 100 10 21 0 1964962368 10934544 2634624
21:58:21 13367 8192000000 10855879168 11335610368 1934761824 19.105 99 9 17 1 1953262992 15927712 2573456
21:58:43 54425 8192000000 10849881168 11333439488 1899908096 18.826 98 3 6 0 1915180784 15003440 269248
21:59:50 80422 8192000000 10882999296 11359117312 1950879600 19.233 100 15 30 1 1961516192 6644608 3991984
22:01:20 79092 8192000000 10904491216 11381260288 1969435808 19.381 100 19 38 1 1986636368 11798368 5402192
22:02:47 97617 8192000000 10898009072 11377762304 1934556192 19.103 98 5 10 0 1948510784 12613152 1341440
22:04:40 84662 8192000000 10911852928 11382611968 1962633664 19.327 99 15 30 0 1976364256 9414992 4315600
22:06:12 42889 8192000000 10908177344 11373031424 1962161792 19.323 99 19 38 0 1978681648 11012096 5507760
22:07:05 49836 8192000000 10922391952 11389558784 1987207456 19.522 100 33 66 2 2010224816 13459712 9557648
22:08:10 119561 8192000000 10898636928 11384872960 1920602512 18.992 97 8 16 2 1938656736 15958384 2095840
22:10:21 27761 8192000000 10915781456 11379736576 1965293120 19.348 99 25 50 1 1979111136 6778384 7039632
22:11:08 74260 8192000000 10908075120 11367997440 1923441360 19.014 97 38 74 2 1944383696 11169296 9773040
22:12:29 27834 8192000000 10905867536 11364159488 1951078576 19.235 99 34 68 2 1971042112 11148432 8815104
22:13:06 41100 8192000000 10899735136 11355324416 1911166560 18.916 97 43 87 1 1935091792 12048640 11876592
22:13:56 94818 8192000000 10890147328 11379793920 1928540000 19.055 98 23 46 1 1947554304 12738016 6276288
22:15:37 167525 8192000000 10896257920 11367665664 1885297568 18.708 95 24 50 1 1904821664 12537280 6986816
22:18:31 107157 8192000000 10887731264 11391152128 1965449648 19.349 100 8 16 1 1988281040 20074192 2757200
22:20:41 61416 8192000000 10875156784 11353497600 1926736560 19.041 98 11 23 1 1944131872 14555952 2839360
22:22:14 35768 8192000000 10868276432 11346403328 1938520944 19.135 99 20 40 0 1950951952 6631408 5799600
22:22:58 51735 8192000000 10893354384 11365445632 1930213264 19.069 98 16 32 2 1941773984 7375264 4185456
22:24:10 69778 8192000000 10861066464 11328884736 1915171056 18.948 98 12 24 0 1934731984 16311168 3249760
22:25:28 76797 8192000000 10856707696 11331678208 1873514496 18.613 96 11 22 0 1891009408 14422976 3071936

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:30, from 17-02-2021 22:28:43 to 17-02-2021 22:29:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 94 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 17-02-2021 22:29:14 to 17-02-2021 22:29:16.

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          234101
MON$OLDEST_ACTIVE               234102
MON$OLDEST_SNAPSHOT             234102
MON$NEXT_TRANSACTION            234102
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                       2015872
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.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 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 ---
:76: 
:77: mscs-test-161.budzdorov.ru    Wed Feb 17 22:27:39 2021
:78:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:79: 
--- end of diff output ---

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

17.02.21 22:29:17. 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-17 22:29:19 No severe PSQL-related problems occured
17.02.21 22:29:21. End of report.