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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17615520 kB
MemAvailable 31626116 kB
Buffers 0 kB
Cached 14124008 kB
SwapCached 1980 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 2020-12-07 01:27:04
DTS_END                         2020-12-07 01:27:04.7830
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(645:9) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40684
TRN_ID                          249924
ATT_ID                          699
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: 9740.53 18307 1168863
customer order: creation 181.68 364 21802
customer order: refuse 15.32 245 1838
order to supplier: creation 47.81 1095 5737
order to supplier: removal 3.57 77076 428
invoice (draft): creation 47.62 2902 5714
invoice (draft): removal 54.66 559 6559
invoice accept: apply 44.18 15885 5301
invoice accept: cancel 49.66 629 5959
customer reserve: creation 4083.78 158 490054
customer reserve: removal 4893.68 44 587242
realization accept: apply 87.20 147 10464
realization accept: cancel 94.05 94 11286
payment from customer: creation 63.19 104 7583
payment from customer: removal 6.04 61 725
payment to supplier: creation 51.13 119 6135
payment to supplier: removal 3.59 38 431
service: total inventory turnovers 5.61 762 673
service: total monetary turnovers 6.86 16 823
service: aggregate perf. data 0.88 18976 105
service: refresh index statistics 0.03 246869 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-12-2020 01:29:10 to 07-12-2020 01:29:12.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6482
TEST_TIME 2 6388
TEST_TIME 3 6056
TEST_TIME 4 6097
TEST_TIME 5 6404
TEST_TIME 6 6572
TEST_TIME 7 6834
TEST_TIME 8 7431
TEST_TIME 9 7540
TEST_TIME 10 8393
TEST_TIME 11 8395
TEST_TIME 12 8583
TEST_TIME 13 9590
TEST_TIME 14 9933
TEST_TIME 15 10236
TEST_TIME 16 10242
TEST_TIME 17 10762
TEST_TIME 18 10921
TEST_TIME 19 11127
TEST_TIME 20 11758
TEST_TIME 21 12361
TEST_TIME 22 12104
TEST_TIME 23 11748
TEST_TIME 24 11742
TEST_TIME 25 12049
TEST_TIME 26 11909
TEST_TIME 27 11950
TEST_TIME 28 11688
TEST_TIME 29 11330
TEST_TIME 30 11216
TEST_TIME 31 11201
TEST_TIME 32 11051
TEST_TIME 33 10927
TEST_TIME 34 10969
TEST_TIME 35 11148
TEST_TIME 36 10967
TEST_TIME 37 10825
TEST_TIME 38 10800
TEST_TIME 39 10755
TEST_TIME 40 10790
TEST_TIME 41 10779
TEST_TIME 42 10644
TEST_TIME 43 10801
TEST_TIME 44 10801
TEST_TIME 45 10838
TEST_TIME 46 10987
TEST_TIME 47 10869
TEST_TIME 48 10839
TEST_TIME 49 10873
TEST_TIME 50 10954
TEST_TIME 51 11001
TEST_TIME 52 10830
TEST_TIME 53 10681
TEST_TIME 54 10617
TEST_TIME 55 10572
TEST_TIME 56 10524
TEST_TIME 57 10467
TEST_TIME 58 10385
TEST_TIME 59 10269
TEST_TIME 60 10227
TEST_TIME 61 10153
TEST_TIME 62 10174
TEST_TIME 63 10157
TEST_TIME 64 10150
TEST_TIME 65 10077
TEST_TIME 66 10266
TEST_TIME 67 10510
TEST_TIME 68 10489
TEST_TIME 69 10407
TEST_TIME 70 10404
TEST_TIME 71 10513
TEST_TIME 72 10473
TEST_TIME 73 10506
TEST_TIME 74 10462
TEST_TIME 75 10384
TEST_TIME 76 10356
TEST_TIME 77 10300
TEST_TIME 78 10222
TEST_TIME 79 10186
TEST_TIME 80 10181
TEST_TIME 81 10148
TEST_TIME 82 10135
TEST_TIME 83 10126
TEST_TIME 84 10113
TEST_TIME 85 10155
TEST_TIME 86 10135
TEST_TIME 87 10168
TEST_TIME 88 10162
TEST_TIME 89 10162
TEST_TIME 90 10153
TEST_TIME 91 10192
TEST_TIME 92 10183
TEST_TIME 93 10212
TEST_TIME 94 10234
TEST_TIME 95 10135
TEST_TIME 96 10113
TEST_TIME 97 10093
TEST_TIME 98 10042
TEST_TIME 99 9985
TEST_TIME 100 9953
TEST_TIME 101 9883
TEST_TIME 102 9906
TEST_TIME 103 9929
TEST_TIME 104 9897
TEST_TIME 105 9904
TEST_TIME 106 9907
TEST_TIME 107 9915
TEST_TIME 108 9970
TEST_TIME 109 9945
TEST_TIME 110 9952
TEST_TIME 111 9923
TEST_TIME 112 10006
TEST_TIME 113 9964
TEST_TIME 114 9970
TEST_TIME 115 9927
TEST_TIME 116 9910
TEST_TIME 117 9896
TEST_TIME 118 9863
TEST_TIME 119 9822
TEST_TIME 120 9745

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-12-2020 01:29:14 to 07-12-2020 01:29:17.

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 1622306 1622306 0 0.00 0 15885 5 0 0
doc_list_biud 1622306 1622306 0 0.00 0 61832 21 0 0
sp_add_invoice_to_stock 5402 5301 101 1.86 21 198601 15885 0 101
sp_cancel_adding_invoice 5959 5959 0 0.00 4 58674 629 0 0
sp_cancel_client_order 1838 1838 0 0.00 4 8840 245 0 0
sp_cancel_customer_reserve 587242 587242 0 0.00 1 61835 45 0 0
sp_cancel_pay_from_customer 725 725 0 0.00 2 10882 61 0 0
sp_cancel_pay_to_supplier 431 431 0 0.00 2 1478 39 0 0
sp_cancel_supplier_invoice 6568 6559 9 0.13 1 16108 560 0 9
sp_cancel_supplier_order 428 428 0 0.00 8 829108 77077 0 0
sp_cancel_write_off 11286 11286 0 0.00 1 17697 94 0 0
sp_client_order 21802 21802 0 0.00 3 36696 365 0 0
sp_customer_reserve 490054 490054 0 0.00 0 33241 158 0 0
sp_fill_shopping_cart 33247 33247 0 0.00 1 14444 30 0 0
sp_fill_shopping_cart_clo_res 490044 490044 0 0.00 0 12970 13 0 0
sp_get_clo_for_invoice 5290 5290 0 0.00 0 31353 305 0 0
sp_kill_cost_storno 18401 18401 0 0.00 0 14578 43 0 0
sp_kill_qstorno_ret_qs2qd 1192757 1192757 0 0.00 0 61830 24 0 0
sp_kill_qty_storno 629066 629066 0 0.00 0 61832 52 0 0
sp_lock_selected_doc 21726 21726 0 0.00 0 8952 6 0 0
sp_make_cost_storno 29472 29472 0 0.00 0 15790 43 0 0
sp_multiply_rows_for_pdistr 29472 29472 0 0.00 0 15558 25 0 0
sp_multiply_rows_for_qdistr 21802 21802 0 0.00 0 30684 182 0 0
sp_pay_from_customer 7583 7583 0 0.00 4 24784 104 0 0
sp_pay_to_supplier 6135 6135 0 0.00 5 15104 120 0 0
sp_payment_common 13718 13718 0 0.00 1 24748 26 0 0
sp_qd_handle_on_cancel_clo 1838 1838 0 0.00 0 8835 221 0 0
sp_qd_handle_on_invoice_upd_sts 11249 11249 0 0.00 0 43276 270 0 0
sp_qd_handle_on_reserve_upd_sts 10464 10464 0 0.00 0 18939 51 0 0
sp_reserve_write_off 10464 10464 0 0.00 6 18964 148 0 0
sp_supplier_invoice 5714 5714 0 0.00 7 89122 2902 0 0
sp_supplier_order 5737 5737 0 0.00 5 25449 1095 0 0
srv_aggregate_perf_data 106 105 1 0.94 2904 215056 18976 0 1
srv_fill_mon_cache_memory 146 146 0 0.00 1296 128272 36057 0 0
srv_find_qd_qs_mism 1118257 1118257 0 0.00 0 15697 5 0 0
srv_make_invnt_saldo 673 673 0 0.00 47 19581 763 0 0
srv_make_money_saldo 823 823 0 0.00 1 587 17 0 0
srv_recalc_idx_stat 4 4 0 0.00 172583 359870 246869 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 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 5301 5301 0 0.00 0 14462 148 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 9021 111 0 0
t$perf-norm:sp_cancel_client_order 1838 1838 0 0.00 0 6890 17 0 0
t$perf-norm:sp_cancel_customer_reserve 721 721 0 0.00 0 2831 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 725 725 0 0.00 0 1438 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 431 431 0 0.00 0 323 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 693 11 0 0
t$perf-norm:sp_cancel_supplier_order 428 428 0 0.00 0 18059 1205 0 0
t$perf-norm:sp_cancel_write_off 1017 1017 0 0.00 0 2124 8 0 0
t$perf-norm:sp_client_order 21802 21802 0 0.00 0 13510 14 0 0
t$perf-norm:sp_customer_reserve 1055 1055 0 0.00 0 3486 10 0 0
t$perf-norm:sp_pay_from_customer 7583 7583 0 0.00 0 7919 8 0 0
t$perf-norm:sp_pay_to_supplier 6135 6135 0 0.00 0 7838 11 0 0
t$perf-norm:sp_reserve_write_off 10464 10464 0 0.00 0 10623 10 0 0
t$perf-norm:sp_supplier_invoice 5714 5714 0 0.00 0 21725 22 0 0
t$perf-norm:sp_supplier_order 5737 5737 0 0.00 0 8306 15 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 199 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 146 146 0 0.00 0 110 2 0 0
t$perf-norm:srv_make_invnt_saldo 673 673 0 0.00 0 1947 12 0 0
t$perf-norm:srv_make_money_saldo 823 823 0 0.00 0 989 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 4 0 0
v_add_invoice_to_stock 10778 10576 202 1.87 0 5099 18 0 202
v_all_customers 39598 39598 0 0.00 0 123 0 0 0
v_all_suppliers 31650 31650 0 0.00 0 101 1 0 0
v_all_wares 43602 43602 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 3032 11 0 0
v_cancel_client_order 3676 3676 0 0.00 0 1720 3 0 0
v_cancel_customer_prepayment 1450 1450 0 0.00 0 2124 6 0 0
v_cancel_customer_reserve 1442 1442 0 0.00 0 2439 8 0 0
v_cancel_payment_to_supplier 862 862 0 0.00 0 1463 4 0 0
v_cancel_supplier_invoice 848 830 18 2.12 0 5155 23 0 18
v_cancel_supplier_order 856 856 0 0.00 0 810 4 0 0
v_cancel_write_off 2034 2034 0 0.00 0 2853 14 0 0
v_max_id_clo_ord 5737 5737 0 0.00 0 545 1 0 0
v_max_id_clo_res 1055 1055 0 0.00 0 5092 14 0 0
v_max_id_ord_sup 5709 5709 0 0.00 0 4763 5 0 0
v_max_non_paid_invoice 1756 1756 0 0.00 0 1239 3 0 0
v_max_non_paid_realizn 4058 4058 0 0.00 0 2074 3 0 0
v_min_id_clo_ord 5737 5737 0 0.00 0 1678 4 0 0
v_min_id_clo_res 1055 1055 0 0.00 0 4875 16 0 0
v_min_id_ord_sup 5709 5709 0 0.00 0 7331 6 0 0
v_min_non_paid_invoice 6135 6135 0 0.00 0 5314 16 0 0
v_min_non_paid_realizn 7583 7583 0 0.00 0 24746 18 0 0
v_our_firm 11054 11054 0 0.00 0 31 1 0 0
v_reserve_write_off 20928 20928 0 0.00 0 3796 5 0 0
x_lock_depdocs_on_canc_invoice 12103 12103 0 0.00 0 18243 90 0 0
x_lock_depdocs_on_canc_sup_ord 428 428 0 0.00 0 6612 221 0 0
x_make_qstorno_1000_1200 5737 5737 0 0.00 2 25439 1033 0 0
x_make_qstorno_1200_2000 5714 5714 0 0.00 3 76251 2794 0 0
x_make_qstorno_2100_3300 490054 490054 0 0.00 0 33237 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-12-2020 01:29:18 to 07-12-2020 01:29:22.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
22:57:08 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:14 11882 8192000000 10200371200 10503962624 934594016 10.240 75 59 121 0 957304096 2791472 19918608
22:57:37 17770 8192000000 10314869952 10629132288 1370271696 14.329 100 84 168 1 1401710432 4251600 27187136
22:58:06 41377 8192000000 10389783248 10710671360 1426918048 14.834 100 92 185 1 1462706128 6001600 29786480
22:58:55 25413 8192000000 10410693456 10737545216 1462869792 15.151 100 90 180 0 1499201872 7337424 28994656
22:59:32 22515 8192000000 10437171792 10766413824 1486875584 15.362 100 89 178 0 1523901152 8514592 28510976
23:00:06 18060 8192000000 10447426144 10781433856 1494473744 15.428 100 87 174 1 1536023488 13528832 28020912
23:00:32 22210 8192000000 10457019008 10796605440 1514786544 15.605 100 86 172 2 1551402368 9822112 26793712
23:01:11 12043 8192000000 10488310752 10832334848 1540357392 15.827 100 80 160 1 1575350480 9970000 25023088
23:01:31 19993 8192000000 10532673744 10883444736 1583125792 16.195 100 91 182 3 1621431136 10582256 27723088
23:01:57 11248 8192000000 10559259088 10910797824 1602171712 16.358 100 78 156 0 1637093056 10623664 24297680
23:02:18 10500 8192000000 10566393840 10926002176 1629849328 16.594 100 78 157 0 1663936384 10395840 23691216
23:02:38 7389 8192000000 10581857648 10945077248 1640632304 16.685 100 74 148 0 1673496112 10784448 22079360
23:02:57 12610 8192000000 10613087776 10980110336 1667801648 16.915 100 67 134 0 1698420992 11400880 19218464
23:03:18 7269 8192000000 10644388080 11008909312 1693807072 17.133 100 82 165 0 1729160864 11485344 23868448
23:03:34 7495 8192000000 10646709552 11015798784 1703826880 17.217 100 78 156 1 1739578928 12881168 22870880
23:03:50 7038 8192000000 10645560480 11023368192 1714943024 17.310 100 67 134 1 1746371008 12208352 19219632
23:04:08 7631 8192000000 10681221728 11058225152 1736667872 17.491 100 75 150 0 1770637456 12755968 21213616
23:04:24 5838 8192000000 10678950784 11060715520 1744925472 17.560 100 72 144 1 1777221616 12301680 19994464
23:04:37 5913 8192000000 10685830288 11069558784 1752478080 17.622 100 70 140 0 1784296480 11941424 19876976
23:04:50 3016 8192000000 10700019744 11082862592 1764355472 17.720 100 78 156 2 1798836048 12195984 22284592
23:05:01 9961 8192000000 10705551520 11089637376 1768434112 17.754 100 61 122 1 1796102912 11169312 16499488
23:05:18 3504 8192000000 10734323488 11118653440 1794200128 17.966 100 77 154 1 1829646704 12113712 23332864
23:05:28 2996 8192000000 10748409344 11131707392 1806553072 18.068 100 83 168 2 1843068224 12634576 23880576
23:05:38 4499 8192000000 10751793232 11137495040 1815522960 18.141 100 83 166 2 1852609760 13646528 23440272
23:05:51 2166 8192000000 10761828784 11151679488 1817833392 18.160 100 83 164 2 1857702800 16868608 23000800
23:06:00 2529 8192000000 10767605344 11153580032 1826752816 18.233 100 85 170 2 1861902784 12044064 23105904
23:06:10 1866 8192000000 10769139472 11156013056 1831897712 18.275 100 81 162 2 1867050784 12148880 23004192
23:06:18 3089 8192000000 10789201328 11174076416 1840520368 18.345 100 90 176 1 1879134080 13194512 25419200
23:06:28 1560 8192000000 10790222096 11177570304 1851050480 18.431 100 93 187 0 1891552592 13917536 26584576
23:06:36 1088 8192000000 10797758416 11183734784 1851099488 18.431 100 93 183 2 1890930016 14194912 25635616
23:06:44 1510 8192000000 10791917328 11181424640 1849533072 18.418 100 80 162 1 1885149584 13146320 22470192
23:06:52 2705 8192000000 10796652128 11187433472 1856264736 18.473 100 88 177 0 1894556800 12603488 25688576
23:07:01 1906 8192000000 10800170144 11187249152 1860022192 18.503 100 92 184 4 1896643184 10753456 25867536
23:07:10 1676 8192000000 10812343408 11197222912 1863527136 18.532 100 98 196 3 1903010208 11958960 27524112
23:07:18 1770 8192000000 10807899680 11198357504 1869599168 18.581 100 94 186 2 1906661776 11188016 25874592
23:07:26 1757 8192000000 10807836640 11201298432 1872122768 18.601 100 92 184 2 1911832256 12526240 27183248
23:07:35 1535 8192000000 10815953648 11204509696 1872466192 18.604 100 95 190 3 1913390416 13811696 27112528
23:07:42 44725 8192000000 10803346192 11205173248 1869987312 18.584 100 61 122 1 1897307280 9429120 17890848
23:08:34 10046 8192000000 10812353536 11214852096 1876672816 18.638 100 71 140 0 1907961120 11191712 20096592
23:08:50 7517 8192000000 10779181296 11205505024 1869246608 18.578 100 35 70 0 1888639920 9630528 9762784
23:09:08 4040 8192000000 10800635296 11211464704 1872805520 18.607 100 45 90 3 1894086368 7667808 13613040
23:09:19 4207 8192000000 10784172768 11210395648 1874626704 18.622 100 34 68 2 1891791760 7813472 9351584
23:09:29 5076 8192000000 10788661648 11216150528 1875619568 18.630 100 34 66 5 1891829056 6459888 9749600
23:09:45 7846 8192000000 10801508800 11216207872 1875197072 18.626 100 23 44 1 1887643936 6246496 6200368
23:10:00 7195 8192000000 10792080352 11216891904 1879575520 18.662 100 30 57 1 1895116256 6540656 9000080
23:10:18 17363 8192000000 10788670464 11222093824 1880227488 18.667 100 20 40 0 1892394672 6247680 5919504
23:10:42 6655 8192000000 10787782400 11220025344 1881006592 18.673 100 16 32 1 1891771696 5906672 4858432
23:10:56 13512 8192000000 10809600032 11229118464 1883169792 18.691 100 17 34 0 1894772016 6040976 5561248
23:11:20 17163 8192000000 10789310112 11224399872 1883649424 18.695 100 7 14 0 1890833376 5252864 1931088
23:11:44 8367 8192000000 10793235968 11230236672 1888200032 18.731 100 17 32 1 1899001008 5756720 5044256
23:12:00 13894 8192000000 10797407776 11232993280 1889778608 18.744 100 10 21 0 1898101600 5670480 2652512
23:12:20 9166 8192000000 10802347888 11237617664 1893134016 18.771 100 21 40 2 1905194736 6395888 5664832
23:12:40 9523 8192000000 10815644864 11251339264 1900512192 18.830 100 23 46 2 1917431008 10971280 5947536
23:12:56 69371 8192000000 10863023184 11264958464 1912989296 18.931 100 53 104 1 1934158064 5791376 15377392
23:14:12 8291 8192000000 10808642496 11250315264 1904710352 18.864 100 29 58 1 1920665536 7730544 8224640
23:14:28 6347 8192000000 10819924720 11253919744 1904425536 18.862 100 28 56 0 1919176608 7171456 7579616
23:14:43 9036 8192000000 10820693424 11253116928 1903044080 18.851 100 20 40 2 1914965056 5893408 6027568
23:14:59 5235 8192000000 10811768304 11252580352 1903779344 18.857 100 24 47 0 1916526640 6178784 6568512
23:15:12 4871 8192000000 10803625648 11238051840 1862811472 18.526 98 27 54 1 1875741472 5467040 7462960
23:15:23 5863 8192000000 10815277376 11240398848 1886736368 18.719 100 18 36 0 1897665904 5932576 4996960
23:15:35 11504 8192000000 10788683248 11216027648 1820626320 18.183 96 26 52 1 1834022928 5717408 7679200
23:15:53 7332 8192000000 10775771824 11206262784 1858547216 18.492 99 18 35 2 1869535680 5808480 5179984
23:16:08 5186 8192000000 10785388832 11217625088 1876331904 18.635 100 24 48 1 1889305264 6393552 6579808
23:16:22 10437 8192000000 10769353552 11193278464 1819699296 18.175 97 25 50 4 1832244560 5243056 7302208
23:17:07 41564 8192000000 10749962048 11178684416 1743259872 17.546 93 24 48 1 1755934976 5709008 6966096
23:17:54 3981 8192000000 10756031024 11183104000 1832317120 18.278 99 26 54 1 1846518400 7273888 6927392
23:18:05 8651 8192000000 10722755408 11138830336 1693074816 17.127 92 23 46 0 1705588144 5730752 6782576
23:18:20 8213 8192000000 10700175136 11121745920 1743206336 17.545 96 22 44 1 1756404704 6566944 6631424
23:18:34 6711 8192000000 10701179616 11110379520 1670257024 16.935 92 32 61 2 1683954576 5344656 8352896
23:18:49 6250 8192000000 10692718512 11108089856 1715663616 17.316 96 20 40 2 1730767936 9687104 5417216
23:19:03 7450 8192000000 10706330624 11118891008 1742472048 17.539 97 23 45 1 1754778224 5042288 7263888
23:19:20 14510 8192000000 10714854016 11139440640 1756176480 17.653 97 14 28 2 1765633056 5535008 3921568
23:19:41 8057 8192000000 10707582064 11129712640 1737875040 17.501 96 15 30 2 1747572016 5658384 4038592
23:19:56 8632 8192000000 10701812160 11127996416 1768636464 17.756 98 19 38 1 1779171392 5418176 5116752
23:20:12 12178 8192000000 10702058192 11123712000 1763984512 17.717 98 23 46 0 1776314592 5234192 7095888
23:20:31 11687 8192000000 10702225488 11121774592 1755526832 17.647 98 17 34 0 1766001328 5405712 5068784
23:20:49 8557 8192000000 10729513200 11142561792 1804193296 18.048 100 22 43 1 1815917616 4865472 6858848
23:21:06 55819 8192000000 10752166336 11165523968 1825710432 18.224 100 66 133 1 1855922080 10389968 19821680
23:22:08 15391 8192000000 10741417584 11164266496 1786854128 17.906 98 17 33 2 1801333584 9806064 4673392
23:22:29 9978 8192000000 10767737856 11180773376 1838365968 18.328 100 37 71 2 1854423600 6683920 9373712
23:22:47 4467 8192000000 10761649408 11176988672 1825609424 18.224 99 41 82 2 1843959056 7003808 11345824
23:23:00 6434 8192000000 10748961664 11176820736 1840248624 18.343 100 16 32 2 1851091216 6116624 4725968
23:23:13 6640 8192000000 10760325936 11187306496 1852652496 18.444 100 33 66 3 1869514048 7284704 9576848
23:23:27 4176 8192000000 10768015152 11194400768 1856306240 18.473 100 36 72 1 1872628768 4676192 11646336
23:23:39 8897 8192000000 10767548480 11196907520 1857588160 18.484 100 25 48 1 1870197456 5647568 6961728
23:23:56 7731 8192000000 10773172224 11198791680 1862115712 18.520 100 23 46 1 1874371392 5180416 7075264
23:24:10 10471 8192000000 10764580640 11199197184 1859624480 18.500 100 17 33 1 1870034960 5198192 5212288
23:24:28 14704 8192000000 10773489488 11201044480 1860399696 18.507 100 19 38 3 1870950928 5191408 5359824
23:24:49 9836 8192000000 10776546640 11211411456 1871385648 18.595 100 20 40 0 1882596032 5584080 5626304
23:25:08 12939 8192000000 10777936000 11214471168 1874052944 18.617 100 18 34 2 1884069184 5714112 4302128
23:25:31 10632 8192000000 10785564832 11216363520 1875280832 18.627 100 15 29 2 1884620400 5049712 4289856
23:25:48 57503 8192000000 10805528384 11222220800 1880360720 18.668 100 29 57 0 1894095968 5405344 8329904
23:26:55 52489 8192000000 10820869120 11245465600 1890476224 18.750 100 40 78 3 1906544768 5642608 10425936
23:28:00 11310 8192000000 10845653216 11268661248 1918530080 18.975 100 48 96 0 1942522032 10060608 13931344
23:28:20 14403 8192000000 10871618144 11286437888 1929002192 19.059 100 57 114 1 1957608544 12544016 16062336
23:28:42 14536 8192000000 10872260320 11293696000 1935672800 19.112 100 50 100 1 1964582176 15209568 13699808
23:29:05 24869 8192000000 10874048096 11301089280 1935349984 19.110 100 40 80 1 1964956480 18688880 10917616
23:29:38 7157 8192000000 10874917280 11308711936 1942274528 19.165 100 36 71 1 1966842592 14076064 10492000
23:29:59 36643 8192000000 10878668176 11314712576 1947355888 19.205 100 41 82 4 1975185712 15374752 12455072
23:30:46 20393 8192000000 10898416336 11328872448 1954808976 19.265 100 36 72 1 1987715088 22030176 10875936
23:31:16 13170 8192000000 10899494336 11331506176 1958945456 19.298 100 38 75 0 1988908256 18079824 11882976
23:31:36 17933 8192000000 10915095280 11343257600 1968680048 19.375 100 54 108 0 2002925984 18483904 15762032
23:32:30 23034 8192000000 10921446048 11355570176 1976732912 19.439 100 45 91 2 2011194496 20718816 13742768
23:33:05 15928 8192000000 10923854448 11358928896 1978711376 19.454 100 52 102 0 2013258368 18777200 15769792
23:33:38 20347 8192000000 10931384496 11370442752 1983401056 19.492 100 39 78 3 2013335568 18534480 11400032
23:34:07 6544 8192000000 10942092112 11375165440 1993573712 19.572 100 56 112 0 2036874928 25469424 17831792
23:34:22 2563 8192000000 10951445936 11376328704 1996864128 19.598 100 61 123 0 2036878528 21636528 18377872
23:34:32 4887 8192000000 10948077392 11374247936 1994019296 19.576 100 68 133 3 2036216976 22425952 19771728
23:34:46 3315 8192000000 10955429472 11374833664 1994704704 19.581 100 75 149 2 2038912368 22065728 22141936
23:34:58 5314 8192000000 10946137344 11374854144 1994449408 19.579 100 54 108 2 2033924448 23277552 16197488
23:35:11 5617 8192000000 10959253888 11386769408 2001916448 19.638 100 69 138 1 2047377472 24178656 21282368
23:35:24 4881 8192000000 10951288736 11377815552 1998367344 19.610 100 67 132 2 2042360384 24124656 19868384
23:35:36 2823 8192000000 10945603152 11367206912 1989494208 19.540 100 73 144 0 2032272704 21931328 20847168
23:35:46 5556 8192000000 10931579616 11351633920 1975245216 19.427 100 78 157 3 2022692368 23422320 24024832
23:35:59 10516 8192000000 10907788992 11337580544 1958410608 19.293 99 53 106 2 1997599968 23565488 15623872
23:36:20 11115 8192000000 10925331456 11350102016 1959649984 19.303 99 57 113 0 2002443920 25199248 17594688
23:36:40 3837 8192000000 10953399200 11362758656 1982025408 19.481 100 77 155 2 2032319104 26940864 23352832
23:36:52 3844 8192000000 10928846672 11353174016 1950068672 19.227 98 68 136 0 1999524720 28798096 20657952
23:37:02 2008 8192000000 10954855904 11364122624 1980033456 19.465 100 87 171 0 2034348928 28533824 25781648
23:37:12 1296 8192000000 10935789760 11342077952 1963539568 19.334 100 91 181 0 2020046864 29896880 26610416
23:37:20 3996 8192000000 10926280464 11339186176 1955128112 19.267 99 83 166 1 2010222064 30552048 24541904
23:37:32 1826 8192000000 10948059904 11354750976 1969855392 19.384 100 88 175 1 2028926960 31455392 27616176
23:37:40 1811 8192000000 10892535920 11295481856 1917932592 18.970 97 87 174 1 1974234192 30734464 25567136
23:37:48 8355 8192000000 10923817744 11337785344 1959344512 19.301 100 80 156 1 2007426256 24910848 23170896
23:38:04 3450 8192000000 10914311648 11326451712 1943222336 19.172 99 82 163 1 1994082112 26283488 24576288
23:38:16 6221 8192000000 10911100880 11329294336 1949175968 19.220 100 76 150 0 2000016864 28589120 22251776
23:38:30 10462 8192000000 10921078960 11344199680 1959862256 19.305 100 64 128 1 2008814960 29279424 19673280
23:38:51 10041 8192000000 10925276672 11351359488 1964236256 19.340 100 62 123 1 2016101424 31957056 19908112
23:39:10 4784 8192000000 10923098240 11351072768 1960042160 19.306 100 51 102 1 2009390784 32752912 16595712
23:39:23 4664 8192000000 10944224256 11366645760 1972435536 19.405 100 62 123 1 2023827120 32204976 19186608
23:39:36 5165 8192000000 10914050976 11332800512 1929005552 19.059 98 73 145 3 1986506832 34332112 23169168
23:39:50 12296 8192000000 10914449824 11342462976 1947763840 19.209 100 63 126 3 2006457152 38157312 20536000
23:40:11 3632 8192000000 10881113888 11306872832 1909364512 18.902 98 55 110 1 1965307456 37192880 18750064
23:40:22 2958 8192000000 10902159152 11323686912 1922997952 19.011 99 68 136 1 1983531168 38379152 22154064
23:40:33 4290 8192000000 10895422704 11312390144 1906538512 18.879 99 72 144 4 1964420256 34482256 23399488
23:40:45 2598 8192000000 10899740880 11308625920 1910551872 18.911 99 78 153 1 1969741648 34748288 24441488
23:40:55 2414 8192000000 10917548384 11326791680 1937790848 19.129 100 75 150 0 1994597744 33570144 23236752
23:41:04 13436 8192000000 10897366880 11325173760 1938122016 19.132 100 52 103 1 1986163920 31524240 16517664
23:41:25 16843 8192000000 10892500224 11309875200 1901772576 18.841 98 35 70 2 1943068256 29406816 11888864
23:41:54 8018 8192000000 10898983264 11334250496 1939288848 19.141 100 40 78 3 1986242448 34259104 12694496
23:42:21 13527 8192000000 10892810464 11329687552 1931092864 19.076 99 36 73 1 1978384656 34891152 12400640
23:42:44 26031 8192000000 10870952208 11314274304 1880829088 18.672 97 33 66 4 1926364304 33899248 11635968
23:43:17 12056 8192000000 10887265488 11321376768 1911947168 18.922 99 35 68 0 1957315968 34069136 11299664
23:43:36 12755 8192000000 10890992160 11330134016 1931392208 19.078 100 30 60 1 1978380304 36380896 10607200
23:43:55 18444 8192000000 10889722384 11333832704 1935141200 19.108 100 25 50 1 1980994144 37380640 8472304
23:44:26 14376 8192000000 10873906576 11320721408 1892152256 18.763 98 27 54 1 1940121424 38219024 9750144
23:44:52 24532 8192000000 10869263232 11317313536 1891610016 18.759 98 23 46 0 1932258064 32782752 7865296
23:45:25 28230 8192000000 10872694144 11319377920 1901312736 18.837 99 18 36 4 1939674160 31928064 6433360
23:46:17 18548 8192000000 10871922816 11327045632 1924539120 19.023 100 25 50 2 1962242112 29548992 8154000
23:46:58 57670 8192000000 10853187040 11306082304 1901886464 18.841 99 19 38 0 1947419488 38532080 7000944
23:48:05 72003 8192000000 10868323808 11305373696 1857026480 18.479 96 17 34 1 1873642432 11580528 5035424
23:49:24 21001 8192000000 10863083776 11303403520 1914868752 18.946 99 49 96 3 1942530192 12554176 15107264
23:49:57 50382 8192000000 10847569776 11289292800 1876426224 18.636 98 9 18 1 1894832672 15369168 3037280
23:51:01 51045 8192000000 10858275472 11288608768 1891230768 18.756 99 36 70 4 1915932256 13984704 10716784
23:52:02 74188 8192000000 10850191200 11320791040 1892936736 18.769 99 9 18 2 1912394384 16691360 2766288
23:53:23 117595 8192000000 10863907712 11310190592 1868425184 18.572 97 11 22 3 1885650480 14381552 2843744
23:55:32 106137 8192000000 10891796208 11335495680 1940438912 19.150 100 26 51 2 1956081568 8539712 7102944
23:57:40 66102 8192000000 10899048128 11345809408 1950250720 19.228 99 35 70 0 1973028128 12611568 10165840
23:58:59 23641 8192000000 10907332480 11363987456 1967674672 19.367 100 28 56 1 1984187008 9025088 7487248
23:59:29 15538 8192000000 10903960208 11364167680 1974922912 19.424 100 19 37 0 1992721040 12900528 4897600
00:00:08 35656 8192000000 10935064304 11387039744 1996361856 19.594 100 32 64 0 2017906176 11718656 9825664
00:00:50 71755 8192000000 10930468976 11408355328 1999367600 19.618 100 18 36 3 2020817104 16505024 4944480
00:02:08 17783 8192000000 10945512000 11412086784 2003071904 19.647 100 20 40 2 2033781248 25179024 5530320
00:02:32 32653 8192000000 10916721248 11395653632 1977325248 19.444 99 13 26 0 1992377904 11400144 3652512
00:03:11 45673 8192000000 10909261024 11380043776 1975602912 19.430 99 11 22 0 1987440592 8537840 3299840
00:04:55 37919 8192000000 10907584176 11391717376 1989673664 19.541 100 8 16 0 2005063536 13184016 2205856
00:05:53 41131 8192000000 10911467696 11386880000 1975615888 19.430 99 17 34 0 1993569072 12653056 5300128
00:06:44 49347 8192000000 10912987536 11387527168 1974083664 19.418 99 14 28 1 1994837104 16423664 4329776
00:07:42 99956 8192000000 10927789584 11406823424 1951960064 19.242 98 9 18 0 1964762752 10594208 2208480
00:09:28 30202 8192000000 10950942960 11395858432 1990375872 19.547 99 41 82 2 2012730064 9686944 12667248
00:10:05 36391 8192000000 10940851312 11390324736 1983943680 19.496 99 46 91 1 2013301712 16083312 13274720
00:10:55 49324 8192000000 10928524176 11406389248 1995120384 19.584 100 13 26 0 2012213888 13252656 3840848
00:11:52 53973 8192000000 10927780464 11398123520 1956350848 19.277 98 15 30 0 1969580624 9119168 4110608
00:13:04 65194 8192000000 10911855824 11398639616 1951649296 19.240 98 8 16 0 1972707008 18627952 2429760
00:14:16 50404 8192000000 10933782832 11385974784 1968765856 19.376 99 28 56 0 1989906656 12305792 8835008
00:15:14 46671 8192000000 10931401872 11380203520 1952407312 19.246 98 40 80 1 1974276912 10131296 11738304
00:16:07 22418 8192000000 10933646880 11385688064 1971209504 19.395 99 33 66 0 1990354672 10064464 9080704
00:16:48 74529 8192000000 10908701760 11398467584 1950887680 19.234 98 16 32 0 1972068048 16866768 4313600
00:18:12 59942 8192000000 10906542912 11349655552 1886315376 18.716 95 20 38 3 1903527856 11980064 5232416
00:19:22 76002 8192000000 10901954576 11356213248 1955897056 19.273 99 45 90 0 1975910336 7064784 12948496
00:20:44 70487 8192000000 10892167136 11360079872 1892638480 18.767 96 24 48 0 1915421424 16537600 6245344
00:22:12 21156 8192000000 10865554672 11355189248 1938684656 19.136 99 12 24 1 1951912656 9914800 3313200
00:22:44 10086 8192000000 10864283760 11344879616 1933449280 19.094 99 7 14 0 1943623456 8503712 1670464
00:24:14 55127 8192000000 10852455632 11324964864 1877046256 18.641 96 10 21 0 1887428592 7423072 2959264
00:25:45 91589 8192000000 10835267728 11302060032 1865939584 18.551 96 17 33 1 1877042080 6759488 4343008
00:27:23 34158 8192000000 10847185888 11325149184 1937612432 19.128 100 13 26 0 1948661632 7934032 3115168
00:28:05 26749 8192000000 10824753360 11296178176 1861881536 18.519 96 8 16 0 1870936784 7137392 1917856
00:28:42 33782 8192000000 10850449056 11314163712 1899833104 18.825 99 11 22 3 1914357568 11685472 2838992
00:29:23 31504 8192000000 10865722528 11321339904 1886192992 18.715 98 12 24 1 1900028256 11235792 2599472
00:30:01 21829 8192000000 10874619552 11329552384 1904804208 18.865 98 40 80 1 1931601680 15679248 11118224
00:30:31 34468 8192000000 10874989936 11334483968 1908916368 18.898 98 21 42 2 1932732176 17848400 5967408
00:31:23 51546 8192000000 10867908896 11328532480 1897618640 18.807 98 29 58 0 1930333200 24237776 8476784
00:32:22 42820 8192000000 10876802144 11333173248 1870210832 18.586 96 30 60 1 1907573760 28390480 8972448
00:33:13 73261 8192000000 10856069760 11340607488 1881924064 18.681 97 23 46 0 1929366672 40157040 7285568
00:35:17 56563 8192000000 10851532320 11313778688 1865582672 18.549 97 22 44 0 1883245520 11903872 5758976
00:36:20 21074 8192000000 10867057216 11305152512 1890645920 18.751 98 46 91 2 1915726432 12112768 12967744
00:36:52 18691 8192000000 10857021600 11291619328 1873681472 18.614 98 55 110 3 1902326160 12891536 15753152
00:37:18 10711 8192000000 10866898000 11304656896 1894741088 18.784 99 48 96 0 1926300448 17862016 13697344
00:37:42 39328 8192000000 10845134496 11314610176 1895811664 18.793 99 41 82 0 1924923808 17744208 11367936
00:38:34 48182 8192000000 10863961760 11310612480 1915004592 18.947 100 35 70 2 1938153024 13748880 9399552
00:39:28 11214 8192000000 10868867632 11317813248 1930330432 19.070 100 58 116 0 1958111088 11402384 16378272
00:39:56 43647 8192000000 10894161088 11337666560 1935743136 19.113 100 30 60 0 1958094688 14028448 8323104
00:40:46 18301 8192000000 10882008400 11330809856 1911438512 18.918 98 35 70 2 1935168560 14110960 9619088
00:41:12 83891 8192000000 10872288960 11337576448 1945924592 19.194 100 36 69 2 1969721200 13796240 10000368
00:42:43 52809 8192000000 10873193792 11330801664 1905531392 18.871 98 27 55 0 1924085568 11219904 7334272
00:43:43 53924 8192000000 10847470448 11324878848 1920041392 18.987 99 24 48 1 1935211792 8365344 6805056
00:44:45 63152 8192000000 10858080160 11336835072 1925036352 19.027 99 14 28 0 1937922400 9192496 3693552
00:47:23 94236 8192000000 10901250272 11371810816 1962456000 19.326 100 19 37 2 1976568624 9031088 5081536
00:49:06 70266 8192000000 10896108960 11372670976 1954321696 19.261 99 21 43 1 1970010832 8680848 7008288
00:50:24 61229 8192000000 10880284688 11354263552 1915515712 18.951 97 23 46 0 1931791792 9121888 7154192
00:51:35 27043 8192000000 10895165616 11358474240 1950455408 19.230 99 33 66 2 1967872672 8214288 9202976
00:52:13 105712 8192000000 10897019488 11378257920 1956407424 19.277 99 21 42 1 1975818448 13296736 6114288
00:54:21 60869 8192000000 10902931680 11371143168 1942006272 19.163 98 7 14 2 1951984656 7687280 2291104
00:55:29 54406 8192000000 10906804096 11379462144 1963705792 19.335 99 20 40 1 1980119984 10734656 5679536
00:56:30 67918 8192000000 10928864544 11383857152 1932584096 19.088 97 23 45 1 1948739280 10046752 6108432
00:57:50 64343 8192000000 10908746080 11389194240 1969298096 19.380 99 23 46 0 1989421648 14022416 6101136
00:59:58 39300 8192000000 10916710608 11390251008 1915198608 18.948 96 20 40 1 1935610080 14736176 5675296
01:02:51 55904 8192000000 10884439664 11350994944 1943280384 19.173 98 23 45 1 1957891216 8220368 6390464
01:03:58 28142 8192000000 10889043072 11363196928 1940186592 19.148 98 26 52 3 1954783392 7985776 6611024
01:04:33 39076 8192000000 10909604720 11379511296 1981214144 19.474 100 23 46 2 1995254528 8080176 5960208
01:05:19 37801 8192000000 10904232432 11376267264 1980805376 19.471 100 9 18 0 1991557584 8255680 2496528
01:06:04 57558 8192000000 10897560384 11375337472 1948993120 19.218 98 8 16 0 1961461696 9554176 2914400
01:07:44 66695 8192000000 10912376832 11384725504 1983951536 19.496 100 13 26 0 1998315360 10700512 3663312
01:08:59 50874 8192000000 10901547744 11382583296 1965989728 19.354 99 14 28 0 1989434000 18951840 4492432
01:09:56 77532 8192000000 10898344032 11374465024 1938859440 19.138 98 9 18 1 1950404288 9213296 2331552
01:11:27 44615 8192000000 10875426272 11353300992 1916660464 18.960 97 14 28 2 1929803088 9074928 4067696
01:12:27 99164 8192000000 10881021360 11341557760 1864855552 18.543 95 17 34 0 1884173136 14700608 4616976
01:15:08 75624 8192000000 10881813632 11362783232 1895771600 18.792 97 17 33 0 1917642848 16870672 5000576
01:16:30 54702 8192000000 10874761344 11336200192 1890371296 18.749 97 13 26 0 1906766544 12702960 3692288
01:17:32 58137 8192000000 10867650256 11326394368 1883980096 18.697 97 19 37 2 1901430624 11227776 6222752
01:18:37 53869 8192000000 10864009424 11334553600 1904134896 18.860 98 15 30 0 1922240976 13985296 4120784
01:19:38 78785 8192000000 10852741760 11315875840 1796254640 17.983 93 12 24 0 1813577120 14260896 3061584
01:21:03 19815 8192000000 10881743728 11318579200 1907545808 18.887 99 50 100 1 1932255568 10353600 14356160
01:21:33 36932 8192000000 10877129520 11339051008 1929721312 19.065 100 32 64 4 1954656448 15648576 9286560
01:22:17 128272 8192000000 10837938800 11318255616 1896170512 18.795 98 28 56 0 1921685552 17759904 7755136
01:24:40 43707 8192000000 10831786192 11304755200 1879243440 18.659 98 7 14 0 1889126656 8004640 1878576
01:25:32 46758 8192000000 10839694736 11309813760 1921961728 19.003 100 5 10 0 1931022592 7736768 1324096
01:26:26 50528 8192000000 9937734528 10312359936 1060643136 11.463 55 1 2 0 1064226928 3521664 62128

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 07-12-2020 01:29:24 to 07-12-2020 01:29:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 101 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-12-2020 01:29:54 to 07-12-2020 01:29:56.

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          250207
MON$OLDEST_ACTIVE               250208
MON$OLDEST_SNAPSHOT             250208
MON$NEXT_TRANSACTION            250208
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                       2020800
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.33398 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33398 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33398 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33398 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 ---
:113: 
:114: mscs-test-161.budzdorov.ru    Mon Dec  7 01:27:21 2020
:115:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:116: 
:117: 
:118: mscs-test-161.budzdorov.ru    Mon Dec  7 01:27:22 2020
:119:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:120: 
:121: 
:122: mscs-test-161.budzdorov.ru    Mon Dec  7 01:27:23 2020
:123:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:124: 
--- end of diff output ---

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

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