Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 18.12.2020 19:29
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 17315808 kB
MemAvailable 31539744 kB
Buffers 0 kB
Cached 14403196 kB
SwapCached 3700 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-18 19:27:05
DTS_END                         2020-12-18 19:27:05.1940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55130
TRN_ID                          252398
ATT_ID                          673
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: 9928.22 19223 1191386
customer order: creation 179.82 367 21578
customer order: refuse 14.83 287 1779
order to supplier: creation 48.66 1196 5839
order to supplier: removal 3.76 80022 451
invoice (draft): creation 49.10 2677 5892
invoice (draft): removal 59.23 633 7108
invoice accept: apply 43.38 15681 5205
invoice accept: cancel 53.10 550 6372
customer reserve: creation 4024.95 156 482994
customer reserve: removal 5139.63 46 616756
realization accept: apply 88.48 161 10617
realization accept: cancel 90.25 92 10830
payment from customer: creation 60.60 115 7272
payment from customer: removal 6.19 65 743
payment to supplier: creation 50.13 134 6016
payment to supplier: removal 3.84 71 461
service: total inventory turnovers 4.79 1041 575
service: total monetary turnovers 6.63 20 796
service: aggregate perf. data 0.82 22281 98
service: refresh index statistics 0.03 258860 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 18-12-2020 19:30:01 to 18-12-2020 19:30:03.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6138
TEST_TIME 2 3688
TEST_TIME 3 3831
TEST_TIME 4 4234
TEST_TIME 5 4520
TEST_TIME 6 4756
TEST_TIME 7 5118
TEST_TIME 8 5172
TEST_TIME 9 5222
TEST_TIME 10 5943
TEST_TIME 11 5992
TEST_TIME 12 6987
TEST_TIME 13 7323
TEST_TIME 14 7650
TEST_TIME 15 8408
TEST_TIME 16 8540
TEST_TIME 17 8698
TEST_TIME 18 8957
TEST_TIME 19 9662
TEST_TIME 20 10048
TEST_TIME 21 10958
TEST_TIME 22 11435
TEST_TIME 23 11629
TEST_TIME 24 12048
TEST_TIME 25 11970
TEST_TIME 26 11882
TEST_TIME 27 11846
TEST_TIME 28 11720
TEST_TIME 29 11569
TEST_TIME 30 11341
TEST_TIME 31 11191
TEST_TIME 32 11160
TEST_TIME 33 11058
TEST_TIME 34 10932
TEST_TIME 35 10927
TEST_TIME 36 11001
TEST_TIME 37 10976
TEST_TIME 38 10813
TEST_TIME 39 10692
TEST_TIME 40 10676
TEST_TIME 41 10685
TEST_TIME 42 10588
TEST_TIME 43 10452
TEST_TIME 44 10472
TEST_TIME 45 10497
TEST_TIME 46 10519
TEST_TIME 47 10531
TEST_TIME 48 10402
TEST_TIME 49 10547
TEST_TIME 50 10583
TEST_TIME 51 10699
TEST_TIME 52 10756
TEST_TIME 53 10773
TEST_TIME 54 10677
TEST_TIME 55 10765
TEST_TIME 56 10712
TEST_TIME 57 10558
TEST_TIME 58 10501
TEST_TIME 59 10432
TEST_TIME 60 10381
TEST_TIME 61 10351
TEST_TIME 62 10294
TEST_TIME 63 10253
TEST_TIME 64 10159
TEST_TIME 65 10143
TEST_TIME 66 10196
TEST_TIME 67 10153
TEST_TIME 68 10208
TEST_TIME 69 10245
TEST_TIME 70 10288
TEST_TIME 71 10261
TEST_TIME 72 10290
TEST_TIME 73 10340
TEST_TIME 74 10291
TEST_TIME 75 10327
TEST_TIME 76 10314
TEST_TIME 77 10360
TEST_TIME 78 10283
TEST_TIME 79 10253
TEST_TIME 80 10196
TEST_TIME 81 10161
TEST_TIME 82 10112
TEST_TIME 83 10081
TEST_TIME 84 10019
TEST_TIME 85 10001
TEST_TIME 86 10025
TEST_TIME 87 10108
TEST_TIME 88 10084
TEST_TIME 89 10051
TEST_TIME 90 10079
TEST_TIME 91 10085
TEST_TIME 92 10108
TEST_TIME 93 10190
TEST_TIME 94 10185
TEST_TIME 95 10204
TEST_TIME 96 10156
TEST_TIME 97 10178
TEST_TIME 98 10086
TEST_TIME 99 10077
TEST_TIME 100 10049
TEST_TIME 101 10037
TEST_TIME 102 10003
TEST_TIME 103 9952
TEST_TIME 104 9967
TEST_TIME 105 9934
TEST_TIME 106 9903
TEST_TIME 107 9892
TEST_TIME 108 9880
TEST_TIME 109 9932
TEST_TIME 110 9919
TEST_TIME 111 9956
TEST_TIME 112 9949
TEST_TIME 113 9983
TEST_TIME 114 9955
TEST_TIME 115 9931
TEST_TIME 116 9980
TEST_TIME 117 9985
TEST_TIME 118 9974
TEST_TIME 119 10010
TEST_TIME 120 9932

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 18-12-2020 19:30:05 to 18-12-2020 19:30:08.

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 1639311 1639311 0 0.00 0 31353 5 0 0
doc_list_biud 1639309 1639309 0 0.00 0 30483 22 0 0
sp_add_invoice_to_stock 5344 5205 139 2.60 49 148374 15682 0 139
sp_cancel_adding_invoice 6372 6372 0 0.00 3 52146 551 0 0
sp_cancel_client_order 1779 1779 0 0.00 4 11923 288 0 0
sp_cancel_customer_reserve 616756 616756 0 0.00 1 19099 46 0 0
sp_cancel_pay_from_customer 743 743 0 0.00 2 7054 65 0 0
sp_cancel_pay_to_supplier 461 461 0 0.00 3 5650 71 0 0
sp_cancel_supplier_invoice 7119 7108 11 0.15 2 18301 633 0 11
sp_cancel_supplier_order 451 451 0 0.00 7 936357 80022 0 0
sp_cancel_write_off 10830 10830 0 0.00 1 10933 92 0 0
sp_client_order 21578 21578 0 0.00 3 34322 368 0 0
sp_customer_reserve 482994 482994 0 0.00 0 71506 156 0 0
sp_fill_shopping_cart 33309 33309 0 0.00 1 10400 33 0 0
sp_fill_shopping_cart_clo_res 482991 482991 0 0.00 0 19640 14 0 0
sp_get_clo_for_invoice 5202 5202 0 0.00 0 31092 307 0 0
sp_kill_cost_storno 18406 18406 0 0.00 0 10843 43 0 0
sp_kill_qstorno_ret_qs2qd 1251901 1251901 0 0.00 0 19095 25 0 0
sp_kill_qty_storno 659114 659114 0 0.00 0 30483 54 0 0
sp_lock_selected_doc 21914 21914 0 0.00 0 10714 6 0 0
sp_make_cost_storno 29107 29107 0 0.00 0 15428 56 0 0
sp_multiply_rows_for_pdistr 29107 29107 0 0.00 0 15422 26 0 0
sp_multiply_rows_for_qdistr 21578 21578 0 0.00 0 13780 171 0 0
sp_pay_from_customer 7272 7272 0 0.00 4 15831 116 0 0
sp_pay_to_supplier 6016 6016 0 0.00 5 16709 135 0 0
sp_payment_common 13287 13287 0 0.00 1 15450 40 0 0
sp_qd_handle_on_cancel_clo 1779 1779 0 0.00 0 11913 262 0 0
sp_qd_handle_on_invoice_upd_sts 11573 11573 0 0.00 0 30482 236 0 0
sp_qd_handle_on_reserve_upd_sts 10617 10617 0 0.00 0 13667 45 0 0
sp_reserve_write_off 10617 10617 0 0.00 6 17095 161 0 0
sp_supplier_invoice 5892 5892 0 0.00 7 79079 2677 0 0
sp_supplier_order 5839 5839 0 0.00 5 73033 1197 0 0
srv_aggregate_perf_data 99 98 1 1.01 2502 490557 22281 0 1
srv_fill_mon_cache_memory 135 135 0 0.00 1672 144143 40197 0 0
srv_find_qd_qs_mism 1141967 1141967 0 0.00 0 31353 4 0 0
srv_make_invnt_saldo 575 575 0 0.00 38 96636 1042 0 0
srv_make_money_saldo 796 796 0 0.00 1 2368 20 0 0
srv_recalc_idx_stat 4 4 0 0.00 247294 271157 258860 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 11 11 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 5205 5205 0 0.00 0 15805 131 0 0
t$perf-norm:sp_cancel_adding_invoice 434 434 0 0.00 0 4198 76 0 0
t$perf-norm:sp_cancel_client_order 1779 1779 0 0.00 0 3105 10 0 0
t$perf-norm:sp_cancel_customer_reserve 670 670 0 0.00 0 5052 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 743 743 0 0.00 0 400 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 461 461 0 0.00 0 3401 21 0 0
t$perf-norm:sp_cancel_supplier_invoice 453 453 0 0.00 0 6411 31 0 0
t$perf-norm:sp_cancel_supplier_order 451 451 0 0.00 0 19050 1295 0 0
t$perf-norm:sp_cancel_write_off 1106 1106 0 0.00 0 590 3 0 0
t$perf-norm:sp_client_order 21578 21578 0 0.00 0 5645 13 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 10279 22 0 0
t$perf-norm:sp_pay_from_customer 7272 7272 0 0.00 0 15045 11 0 0
t$perf-norm:sp_pay_to_supplier 6016 6016 0 0.00 0 5721 9 0 0
t$perf-norm:sp_reserve_write_off 10617 10617 0 0.00 0 11148 12 0 0
t$perf-norm:sp_supplier_invoice 5892 5892 0 0.00 0 9739 14 0 0
t$perf-norm:sp_supplier_order 5839 5839 0 0.00 0 11071 12 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 2112 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 135 135 0 0.00 0 1516 17 0 0
t$perf-norm:srv_make_invnt_saldo 575 575 0 0.00 0 2242 18 0 0
t$perf-norm:srv_make_money_saldo 796 796 0 0.00 0 1380 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 23 7 0 0
v_add_invoice_to_stock 10678 10400 278 2.60 0 7570 21 0 278
v_all_customers 38720 38720 0 0.00 0 21 0 0 0
v_all_suppliers 32560 32560 0 0.00 0 19 0 0 0
v_all_wares 43156 43156 0 0.00 0 74 1 0 0
v_cancel_adding_invoice 868 868 0 0.00 0 2720 8 0 0
v_cancel_client_order 3558 3558 0 0.00 0 1575 4 0 0
v_cancel_customer_prepayment 1486 1486 0 0.00 0 6999 11 0 0
v_cancel_customer_reserve 1340 1340 0 0.00 0 382 3 0 0
v_cancel_payment_to_supplier 922 922 0 0.00 0 2870 6 0 0
v_cancel_supplier_invoice 928 906 22 2.37 0 6883 28 0 22
v_cancel_supplier_order 902 902 0 0.00 0 450 2 0 0
v_cancel_write_off 2212 2212 0 0.00 0 7466 18 0 0
v_max_id_clo_ord 5839 5839 0 0.00 0 4369 2 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 2918 18 0 0
v_max_id_ord_sup 5892 5892 0 0.00 0 7286 6 0 0
v_max_non_paid_invoice 1467 1467 0 0.00 0 1759 4 0 0
v_max_non_paid_realizn 4016 4016 0 0.00 0 3294 7 0 0
v_min_id_clo_ord 5839 5839 0 0.00 0 4656 9 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 2783 10 0 0
v_min_id_ord_sup 5892 5892 0 0.00 0 4619 6 0 0
v_min_non_paid_invoice 6016 6016 0 0.00 0 15419 28 0 0
v_min_non_paid_realizn 7271 7271 0 0.00 0 11044 31 0 0
v_our_firm 10946 10946 0 0.00 0 13 0 0 0
v_reserve_write_off 21234 21234 0 0.00 0 7547 7 0 0
x_lock_depdocs_on_canc_invoice 13027 13027 0 0.00 0 18339 90 0 0
x_lock_depdocs_on_canc_sup_ord 451 451 0 0.00 0 13755 287 0 0
x_make_qstorno_1000_1200 5839 5839 0 0.00 2 73008 1130 0 0
x_make_qstorno_1200_2000 5892 5892 0 0.00 2 79070 2564 0 0
x_make_qstorno_2100_3300 482994 482994 0 0.00 0 71504 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 18-12-2020 19:30:09 to 18-12-2020 19:30:13.

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
16:57:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:15 12701 8192000000 10205951888 10510000128 856298304 9.463 68 52 106 0 875746832 2352320 17096208
16:57:39 29778 8192000000 10317066688 10628083712 1359132688 14.230 100 84 168 1 1392866528 4764128 28969712
16:58:15 17729 8192000000 10337979824 10656481280 1393207184 14.534 100 82 164 1 1426309792 5677392 27425216
16:58:42 25253 8192000000 10380477312 10703863808 1426286848 14.828 100 87 174 0 1461521936 6108528 29126560
16:59:16 19204 8192000000 10407319200 10733559808 1463872816 15.160 100 91 182 0 1504530352 11368656 29288880
16:59:45 16819 8192000000 10425490160 10751070208 1477222752 15.277 100 90 180 1 1514015536 7616944 29175840
17:00:13 13977 8192000000 10439272320 10773827584 1492899168 15.414 100 89 178 1 1529385008 8208640 28277200
17:00:50 15880 8192000000 10466745008 10810658816 1529930352 15.736 100 81 162 1 1563090608 8022080 25138176
17:01:19 13518 8192000000 10504846944 10851246080 1560675392 16.002 100 80 161 0 1593447440 8671904 24100144
17:01:42 15133 8192000000 10527583456 10878795776 1586640400 16.225 100 87 173 1 1622692432 9629408 26422624
17:02:09 14372 8192000000 10544596096 10902528000 1609243840 16.418 100 73 145 0 1641932736 10225520 22463376
17:02:32 8874 8192000000 10567141008 10928611328 1627076336 16.570 100 74 148 0 1659701216 10568528 22056352
17:02:52 13385 8192000000 10602418320 10965032960 1659778400 16.847 100 76 152 1 1692796704 11207008 21811296
17:03:13 9864 8192000000 10624345232 10991661056 1683986736 17.051 100 85 169 0 1720398912 12023984 24388192
17:03:34 9495 8192000000 10652360384 11023020032 1702548672 17.206 100 77 154 1 1736409504 11695264 22165568
17:03:51 8411 8192000000 10662557792 11033341952 1721786432 17.367 100 82 164 0 1757594896 12448640 23359824
17:04:07 7268 8192000000 10673361232 11052150784 1739588288 17.515 100 80 160 1 1774969760 12635424 22746048
17:04:23 6485 8192000000 10692331392 11067998208 1755101248 17.644 100 75 145 1 1787639744 11942944 20595552
17:04:36 4849 8192000000 10704766192 11081654272 1765583296 17.731 100 75 149 0 1799104560 12543232 20978032
17:04:49 4369 8192000000 10708535696 11086176256 1772984784 17.792 100 82 164 1 1808100112 12104864 23010464
17:05:01 3799 8192000000 10711569856 11094384640 1778769152 17.839 100 71 142 1 1811273872 12998576 19506144
17:05:12 3460 8192000000 10723466752 11101372416 1782935056 17.874 100 86 171 2 1820311808 13749296 23627456
17:05:22 3443 8192000000 10726467360 11107434496 1788000992 17.915 100 86 172 0 1826604912 14272368 24331552
17:05:32 2763 8192000000 10740522000 11119591424 1794349728 17.968 100 89 177 2 1833141200 14829392 23962080
17:05:41 2363 8192000000 10743109072 11122597888 1802091920 18.031 100 92 184 1 1844020192 15752112 26176160
17:05:50 5704 8192000000 10740842240 11123433472 1804769744 18.053 100 83 166 2 1843542064 15066576 23705744
17:06:02 5660 8192000000 10752784864 11136184320 1804540240 18.051 100 78 157 2 1841146384 15064800 21541344
17:06:14 2184 8192000000 10767101712 11150446592 1825653344 18.224 100 89 179 2 1864936304 14589664 24693296
17:06:23 2241 8192000000 10769122064 11150970880 1823673936 18.208 100 89 174 2 1864097040 14268528 26154576
17:06:31 1911 8192000000 10770580384 11152875520 1830347504 18.262 100 94 189 1 1870779856 14528304 25904048
17:06:40 1844 8192000000 10776147744 11158982656 1830242336 18.261 100 91 184 0 1870202208 14476064 25483808
17:06:48 1507 8192000000 10790081904 11170557952 1833843392 18.291 100 91 180 1 1873029104 13922672 25263040
17:06:56 2324 8192000000 10778325088 11167195136 1838236192 18.326 100 94 188 0 1877941728 13129616 26575920
17:07:04 1700 8192000000 10784127728 11170082816 1842122464 18.358 100 91 182 0 1880263472 12886496 25254512
17:07:12 1446 8192000000 10797920992 11179966464 1847100912 18.399 100 97 195 1 1889690816 14237808 28352096
17:07:20 1131 8192000000 10794325072 11181342720 1847460640 18.401 100 94 188 1 1888596912 14545280 26590992
17:07:27 1745 8192000000 10791477168 11180535808 1851842464 18.437 100 96 193 0 1895630368 17815904 25972000
17:07:35 34594 8192000000 10773607456 11180027904 1849629776 18.419 100 65 129 1 1877947120 9290192 19027152
17:08:16 13821 8192000000 10795554912 11187109888 1857460896 18.483 100 67 137 1 1883891040 7144192 19285952
17:08:36 15196 8192000000 10760534512 11183292416 1853018544 18.447 100 41 83 0 1873205312 8624752 11562016
17:08:57 8556 8192000000 10756627920 11184140288 1851704720 18.436 100 25 50 1 1865249424 6075328 7469376
17:09:14 10667 8192000000 10772525312 11193827328 1859551856 18.500 100 30 60 3 1873177888 5733120 7892912
17:09:30 2697 8192000000 10794896928 11204009984 1862664576 18.525 100 41 82 0 1883196480 9566112 10965792
17:09:41 10273 8192000000 10766513488 11194699776 1860876448 18.510 100 18 36 1 1872224032 6445984 4901600
17:10:04 8210 8192000000 10781908864 11206668288 1869595136 18.581 100 31 62 1 1885731808 7888480 8248192
17:10:20 10077 8192000000 10772804560 11203825664 1867469744 18.564 100 13 26 0 1876742688 5602672 3670272
17:10:36 9493 8192000000 10779636608 11206754304 1872116160 18.601 100 28 56 0 1885597360 5863888 7617312
17:10:53 5277 8192000000 10782000480 11211145216 1875258336 18.627 100 30 60 0 1889358576 5274640 8825600
17:11:05 9767 8192000000 10782018064 11212836864 1875668784 18.630 100 17 34 1 1886790128 6450400 4670944
17:11:21 8365 8192000000 10792431936 11218198528 1881900096 18.680 100 27 54 1 1895254144 5676240 7677808
17:11:36 12133 8192000000 10788443088 11220922368 1880461840 18.669 100 11 22 1 1889465168 6066096 2937232
17:11:54 9891 8192000000 10792223584 11224825856 1886517936 18.718 100 20 40 1 1899604848 6897136 6189776
17:12:15 15099 8192000000 10826240480 11242438656 1888091840 18.730 100 28 56 3 1907387312 9979632 9315840
17:13:22 28950 8192000000 10801140800 11232309248 1886808800 18.720 100 23 46 0 1898648096 5681280 6158016
17:13:57 6278 8192000000 10804543696 11239194624 1890302384 18.748 100 33 64 3 1906598608 7621072 8675152
17:14:10 4797 8192000000 10812877888 11247255552 1891080688 18.754 100 29 59 0 1914186096 15056560 8048848
17:14:21 5475 8192000000 10805565600 11237183488 1894762592 18.784 100 34 68 2 1911078400 6280496 10035312
17:14:35 9042 8192000000 10808530912 11238842368 1889065808 18.738 100 21 42 3 1900167552 5821040 5280704
17:14:52 6392 8192000000 10806071488 11241103360 1894915920 18.785 100 25 48 0 1908544656 5863824 7764912
17:15:07 8520 8192000000 10802232848 11237994496 1881764592 18.679 99 24 47 2 1894862672 6468992 6629088
17:15:22 6652 8192000000 10796996224 11234791424 1889709360 18.743 100 29 58 1 1904791776 6575280 8507136
17:15:35 6163 8192000000 10806949360 11239075840 1891282960 18.756 100 24 48 1 1904316320 6215216 6818144
17:15:50 10783 8192000000 10794016256 11224989696 1868077344 18.569 99 22 44 1 1880003008 5508496 6417168
17:16:07 6267 8192000000 10786094320 11217321984 1874580672 18.621 100 17 34 2 1885662480 6171344 4910464
17:16:19 10255 8192000000 10790426976 11223171072 1857624848 18.484 99 11 22 0 1870052880 9674192 2753840
17:16:36 9751 8192000000 10771587968 11198935040 1803983296 18.047 96 19 37 1 1815097232 5911760 5202176
17:16:56 66126 8192000000 10720589200 11143905280 1703796624 17.217 92 20 40 0 1714720352 4575920 6347808
17:18:12 9055 8192000000 10715233456 11133804544 1725728064 17.400 95 19 36 0 1736232368 4939728 5564576
17:18:27 6680 8192000000 10687658448 11098247168 1723307120 17.380 96 40 79 4 1741105088 6310256 11487712
17:18:42 7140 8192000000 10659807904 11069992960 1704184192 17.220 95 27 53 2 1718368704 6355744 7828768
17:18:55 10533 8192000000 10691724896 11114258432 1744220736 17.554 97 31 62 1 1759505936 5999088 9286112
17:19:13 6272 8192000000 10680531328 11089797120 1731456928 17.448 98 29 57 0 1746331216 6387680 8486608
17:19:27 8876 8192000000 10702504640 11116371968 1766249936 17.736 99 24 47 1 1778745936 5206640 7289360
17:19:42 8036 8192000000 10711458368 11129757696 1798421760 18.001 100 25 50 2 1811470256 6275216 6773280
17:19:57 8732 8192000000 10714927584 11133743104 1788896048 17.923 99 27 54 0 1802784320 4984720 8903552
17:20:12 10130 8192000000 10715440080 11130609664 1759485840 17.680 97 25 49 2 1772042864 5039200 7517824
17:20:30 8548 8192000000 10733121168 11148427264 1797271024 17.992 99 32 64 1 1812514176 5744208 9498944
17:20:44 11052 8192000000 10749211152 11165925376 1814962928 18.137 100 28 56 0 1828937024 5740240 8233856
17:21:01 16185 8192000000 10727745632 11151937536 1767331072 17.745 97 16 32 0 1776209040 4869536 4008432
17:21:25 10905 8192000000 10737052112 11166121984 1806502368 18.067 99 12 24 0 1815412928 5925008 2985552
17:21:42 19840 8192000000 10748288832 11175669760 1836372144 18.311 100 24 47 0 1848831424 5534976 6924304
17:22:48 36380 8192000000 10759974752 11185496064 1829388304 18.254 99 23 46 4 1841345856 5407408 6550144
17:23:31 6607 8192000000 10765635200 11189583872 1847903168 18.405 100 21 42 0 1859429744 5063152 6463424
17:23:46 8874 8192000000 10770568512 11196207104 1852542048 18.443 100 20 40 1 1863752336 5628816 5581472
17:24:02 7839 8192000000 10777714976 11199057920 1860340608 18.506 100 30 58 2 1874208752 5104240 8763904
17:24:15 6738 8192000000 10773548992 11199590400 1859880592 18.502 100 33 66 0 1875646096 5909408 9856096
17:24:31 7751 8192000000 10781181680 11205775360 1863102528 18.528 100 28 56 0 1877260624 6521968 7636128
17:24:47 6167 8192000000 10773374576 11204370432 1863945088 18.535 100 26 51 1 1877634304 5659536 8029680
17:25:01 7380 8192000000 10780380992 11211464704 1865046176 18.544 100 20 40 1 1877139472 6536064 5557232
17:25:16 12232 8192000000 10783724448 11212103680 1866667168 18.557 100 21 42 0 1878142768 5330688 6144912
17:25:39 14592 8192000000 10788317904 11216093184 1873026672 18.609 100 25 50 1 1886086512 5595536 7464304
17:26:00 14526 8192000000 10792248848 11223289856 1872905200 18.608 100 10 20 0 1880542640 5336576 2300864
17:26:21 13808 8192000000 10787488368 11225784320 1877860080 18.648 100 13 26 1 1886848896 5133824 3854992
17:26:41 19665 8192000000 10797331744 11227181056 1878056960 18.649 100 7 14 0 1884974784 5147472 1770352
17:27:08 45270 8192000000 10831688016 11248590848 1906358512 18.877 100 42 82 1 1923588400 5355344 11874544
17:28:07 40788 8192000000 10849956448 11275653120 1921304016 18.997 100 46 90 3 1941057536 6950992 12802528
17:29:00 72653 8192000000 10866077216 11294482432 1934739536 19.105 100 47 93 2 1958217968 9954928 13523504
17:30:24 28527 8192000000 10862754912 11291160576 1927826496 19.049 99 38 76 1 1954578416 16080112 10671808
17:31:04 26794 8192000000 10877194576 11305766912 1929227440 19.061 99 38 76 0 1957242048 16915472 11099136
17:31:39 14991 8192000000 10879636896 11314450432 1951054720 19.235 100 46 91 3 1981577760 17176528 13346512
17:32:02 14440 8192000000 10896960208 11326300160 1955281856 19.269 100 43 86 0 1988923088 21848400 11792832
17:32:25 21536 8192000000 10913564400 11332038656 1960973632 19.314 100 64 127 0 2000025984 20234192 18818160
17:32:53 14216 8192000000 10922036528 11343728640 1968380080 19.373 100 55 109 0 2005187808 21399888 15407840
17:33:20 7226 8192000000 10921986336 11354427392 1976388704 19.436 100 48 94 0 2011310304 21148256 13773344
17:33:34 9179 8192000000 10917383008 11347345408 1974792576 19.423 100 56 112 2 2012883104 21404096 16686432
17:33:53 23733 8192000000 10917320048 11354980352 1978811104 19.455 100 39 78 2 2013456848 22615664 12030080
17:34:25 7872 8192000000 10926297776 11355357184 1977594032 19.446 100 46 92 3 2015213584 23846000 13773552
17:34:42 5087 8192000000 10926065440 11353579520 1963411232 19.333 99 51 102 0 2001297968 22888640 14998096
17:34:57 5341 8192000000 10939817600 11365400576 1986346240 19.515 100 66 131 2 2030512144 24737904 19428000
17:35:15 9626 8192000000 10937987408 11367067648 1988388128 19.531 100 53 106 4 2029337968 25030496 15919344
17:35:36 5724 8192000000 10952413424 11382026240 1992102848 19.560 100 50 98 1 2035604992 27977840 15524304
17:36:04 13842 8192000000 10950782016 11383308288 1992962336 19.567 100 49 98 2 2039831168 31775712 15093120
17:36:28 12736 8192000000 10927134800 11360153600 1929283200 19.061 97 46 92 2 1975578656 31979312 14316144
17:36:49 12256 8192000000 10943953792 11376259072 1982269856 19.483 100 57 113 0 2034040944 33694368 18076720
17:37:08 8055 8192000000 10947886224 11384602624 1984140560 19.497 100 50 97 4 2036828432 36792256 15895616
17:37:35 7033 8192000000 10944485328 11380072448 1971120784 19.394 99 49 99 2 2024455168 37918752 15415632
17:37:50 2474 8192000000 10972518448 11392892928 1996740912 19.597 100 65 131 4 2054489616 37312544 20436160
17:38:00 5571 8192000000 10976273056 11398418432 2000860704 19.630 100 73 144 0 2061550384 38073664 22616016
17:38:13 4554 8192000000 10978197104 11398578176 1986800448 19.519 99 74 148 0 2050745792 41078608 22866736
17:38:33 12178 8192000000 10972442992 11398766592 1999558112 19.619 100 69 138 1 2065828928 45187616 21083200
17:38:58 11166 8192000000 10943506704 11381940224 1976337648 19.436 100 56 111 1 2041091872 47072384 17681840
17:39:22 5826 8192000000 10949910944 11382702080 1977315344 19.443 99 61 121 1 2045484032 47748128 20420560
17:39:35 2795 8192000000 10960351376 11384827904 1971437088 19.397 99 77 152 1 2038908336 43068336 24402912
17:39:45 3592 8192000000 10956423520 11381272576 1968106832 19.370 99 71 142 1 2031752112 42222320 21422960
17:39:57 4963 8192000000 10942982288 11365965824 1948109664 19.211 98 75 151 1 2011977712 41269456 22598592
17:40:10 8423 8192000000 10966106672 11386032128 1983223920 19.490 100 77 154 0 2050504384 45042464 22238000
17:40:25 6030 8192000000 10964267424 11386421248 1971361952 19.396 99 67 132 1 2040390864 48444336 20584576
17:40:38 1669 8192000000 10982225568 11403694080 1991516928 19.556 100 74 147 1 2062701184 48708240 22476016
17:40:48 5236 8192000000 10957187280 11379601408 1975485696 19.429 100 76 150 1 2045462080 47262528 22713856
17:41:00 3899 8192000000 10943129664 11366899712 1956537232 19.279 100 65 130 0 2027738240 50911440 20289568
17:41:18 3522 8192000000 10931873872 11347644416 1937861888 19.130 99 69 137 0 2012135664 51796144 22477632
17:41:39 6443 8192000000 10930244096 11357683712 1934905216 19.106 99 61 122 1 2007811248 53842224 19063808
17:41:57 4948 8192000000 10957807520 11376316416 1958789536 19.296 100 62 121 2 2033606112 54878800 19937776
17:42:11 11452 8192000000 10941370672 11381039104 1964972304 19.346 100 50 100 0 2038876720 56967808 16936608
17:42:48 17510 8192000000 10905201520 11346341888 1909542368 18.903 98 41 82 2 1974189424 50798848 13848208
17:43:14 8678 8192000000 10900333760 11337072640 1916912928 18.962 99 33 65 0 1973305456 45573008 10819520
17:43:30 15708 8192000000 10887239888 11326054400 1892117920 18.763 98 31 62 3 1950166848 47771168 10277760
17:43:52 13787 8192000000 10900707040 11336278016 1905449856 18.870 99 36 72 0 1969162464 52315104 11397504
17:44:12 9012 8192000000 10907260672 11343581184 1931053264 19.075 100 30 60 0 1989086384 48310816 9722304
17:44:30 26451 8192000000 10929063088 11359588352 1922370496 19.006 99 32 63 2 1983699184 50641088 10687600
17:45:07 13406 8192000000 10909907216 11351429120 1912718240 18.928 99 37 73 2 1982282000 56695200 12868560
17:45:31 21156 8192000000 10906969280 11358384128 1911074576 18.915 99 28 56 1 1980024864 58412320 10537968
17:46:07 29627 8192000000 10897743040 11352858624 1906891792 18.882 99 24 48 2 1974903920 59091024 8921104
17:46:44 28510 8192000000 10907047968 11360276480 1938954032 19.138 100 29 58 1 1999803760 51071760 9777968
17:47:39 12193 8192000000 10869888032 11311296512 1855283232 18.465 97 27 54 0 1910363104 45384736 9695136
17:48:03 13301 8192000000 10876458672 11328462848 1907922704 18.890 100 28 56 1 1964310832 47072880 9315248
17:48:23 29770 8192000000 10882719712 11343855616 1917818512 18.969 100 20 40 1 1964347792 40001280 6528000
17:49:38 39589 8192000000 10845844960 11313647616 1844334080 18.376 96 13 26 2 1888080784 38607632 5139072
17:51:04 57689 8192000000 10846819248 11319144448 1872316784 18.603 98 14 28 3 1904557792 27574832 4666176
17:52:26 51456 8192000000 10850020480 11308748800 1887376512 18.725 98 20 41 2 1903058304 10173920 5507872
17:53:24 144142 8192000000 10866316288 11321081856 1856958896 18.479 96 19 38 0 1873816800 12296448 4561456
17:56:57 58458 8192000000 10852928848 11291017216 1856748784 18.477 96 37 72 1 1876314848 8461632 11104432
17:58:02 56280 8192000000 10878003792 11318382592 1879878656 18.664 97 41 82 1 1900879216 10400224 10600336
17:59:05 50870 8192000000 10889028592 11336208384 1950188576 19.228 100 33 66 1 1972063904 12677600 9197728
18:00:05 87467 8192000000 10891994944 11336867840 1913783184 18.937 98 21 42 0 1927120048 7604016 5732848
18:01:39 25186 8192000000 10931486800 11369852928 1971847328 19.400 100 37 74 2 1998397968 15986448 10564192
18:02:25 74330 8192000000 10888257744 11365675008 1937527728 19.127 98 31 62 0 1963276096 17021648 8726720
18:04:16 43425 8192000000 10893695344 11370762240 1971251568 19.395 100 18 37 0 1989138160 12260656 5625936
18:05:11 65612 8192000000 10921309024 11384537088 1965440480 19.349 99 21 42 1 1984523104 13064560 6018064
18:06:28 59149 8192000000 10907098432 11380682752 1984189600 19.498 100 18 36 0 2004123600 14869504 5064496
18:08:22 47906 8192000000 10904833488 11382325248 1981514224 19.477 100 11 22 0 1994663984 10170528 2979232
18:09:24 30134 8192000000 10915958304 11386179584 1987290640 19.522 100 17 34 0 2007843536 15264672 5288224
18:10:05 65718 8192000000 10910656208 11392892928 1968670016 19.375 99 9 18 2 1984434656 13189008 2575632
18:11:20 43734 8192000000 10912759184 11379818496 1967644960 19.367 99 17 31 1 1982317328 10527968 4144400
18:12:11 47382 8192000000 10928342032 11392880640 1994260608 19.577 100 31 62 0 2013839776 10639056 8940112
18:13:14 45082 8192000000 10929287376 11402530816 1986187104 19.514 99 31 61 2 2006209168 11174272 8847792
18:14:13 47954 8192000000 10933514688 11414601728 2001501664 19.635 100 12 24 0 2020680784 16205760 2973360
18:15:26 76553 8192000000 10944632752 11424493568 1974860960 19.424 98 15 30 0 1999941760 20553904 4526896
18:17:07 66741 8192000000 10936912640 11407986688 1966626112 19.359 98 11 22 1 1984021856 13853424 3542320
18:18:31 68261 8192000000 10914728912 11391729664 1923270528 19.013 96 14 28 1 1943404032 16067824 4065680
18:19:46 57015 8192000000 10895201520 11371769856 1875130832 18.626 95 11 22 0 1891638832 13754400 2753600
18:21:11 12037 8192000000 10932118656 11365163008 1957529376 19.286 99 41 79 1 1976930384 7318928 12082080
18:21:31 28223 8192000000 10906128224 11355869184 1932343840 19.086 98 43 86 1 1953938672 8868240 12726592
18:22:08 32686 8192000000 10898443344 11361288192 1930656176 19.072 98 38 76 0 1953719472 12504848 10558448
18:22:50 47047 8192000000 10905103024 11356782592 1925372688 19.030 98 26 52 1 1944924704 12025616 7526400
18:23:46 84611 8192000000 10889179648 11343843328 1930344640 19.070 98 51 103 3 1954130464 9226496 14559328
18:25:18 39589 8192000000 10852696912 11309400064 1828279136 18.245 94 21 42 0 1839957504 5522080 6156288
18:26:04 60778 8192000000 10864585120 11323793408 1902825904 18.849 98 35 68 0 1922638272 10267296 9545072
18:27:11 21362 8192000000 10875651280 11322314752 1918267328 18.973 99 43 86 2 1943020448 11619136 13133984
18:27:39 30842 8192000000 10836718368 11302330368 1866656048 18.557 97 19 38 1 1881082592 9402016 5024528
18:28:31 28539 8192000000 10867840400 11320860672 1884529184 18.702 97 27 53 1 1897283888 5878064 6876640
18:29:12 62789 8192000000 10812844272 11286925312 1862609200 18.524 97 7 14 0 1872718384 8637856 1471328
18:31:29 83381 8192000000 10844341232 11301023744 1835217088 18.302 95 13 26 1 1852566848 13314752 4035008
18:33:08 56327 8192000000 10849373248 11324784640 1907038720 18.883 99 28 56 1 1928101248 12324896 8737632
18:34:15 29183 8192000000 10902819152 11338735616 1924226384 19.021 99 49 98 3 1949638736 11366896 14045456
18:34:52 54358 8192000000 10868842256 11337719808 1888090272 18.730 97 23 47 0 1912160336 17134864 6935200
18:36:05 44744 8192000000 10873900720 11336699904 1905776304 18.873 98 26 52 1 1932249824 18918656 7554864
18:36:59 61993 8192000000 10878813392 11347439616 1923836016 19.018 99 4 8 0 1936102336 11018400 1247920
18:38:15 29603 8192000000 10904692448 11349057536 1938491600 19.135 99 47 94 0 1961788064 9921200 13375264
18:38:58 41463 8192000000 10882570416 11339153408 1889838960 18.744 97 34 68 2 1910213600 10255872 10118768
18:39:57 91746 8192000000 10880553456 11340386304 1871540832 18.597 96 16 32 0 1889994448 13724304 4729312
18:41:36 99852 8192000000 10869139568 11341271040 1861111328 18.512 96 21 42 0 1880840640 13941232 5788080
18:43:23 71987 8192000000 10885311344 11360694272 1928271344 19.053 99 14 28 1 1949273024 17196432 3805248
18:44:43 106122 8192000000 10879871024 11339546624 1916021568 18.955 98 34 68 0 1943261664 17469984 9770112
18:46:52 69800 8192000000 10863166864 11343544320 1912100944 18.924 98 29 56 2 1931586720 11555664 7930112
18:48:19 85592 8192000000 10868339632 11352805376 1924594064 19.024 99 9 18 0 1943229040 16207488 2427488
18:49:51 40963 8192000000 10867730848 11358482432 1941528416 19.159 100 7 14 0 1963682352 20365472 1788464
18:50:40 15437 8192000000 10868728656 11359973376 1940371088 19.150 100 7 14 0 1962336320 20196704 1768528
18:51:12 32874 8192000000 10879870800 11345956864 1927062208 19.043 99 10 20 0 1946887904 17121392 2704304
18:51:53 64308 8192000000 10883635472 11357507584 1914631232 18.944 98 20 40 0 1932920336 12841488 5447616
18:53:35 76218 8192000000 10898491232 11381940224 1963369280 19.333 100 10 19 0 1984619408 17949056 3301072
18:55:00 56133 8192000000 10892731728 11374112768 1947906704 19.210 99 13 26 0 1966153120 14629824 3616592
18:56:07 52076 8192000000 10903206816 11373932544 1942041728 19.163 98 24 48 3 1957491552 8748960 6700864
18:57:08 51480 8192000000 10936625632 11392487424 1981502304 19.477 100 21 42 1 1998495616 11229776 5763536
18:58:08 26903 8192000000 10961237776 11413233664 2008134752 19.687 100 57 110 2 2034573184 11616640 14821792
18:58:41 48206 8192000000 10921764032 11398168576 1970840560 19.392 98 30 60 3 1992338016 13150192 8347264
18:59:48 107825 8192000000 10910468192 11383226368 1914313552 18.941 96 6 12 0 1931565248 15463824 1787872
19:01:42 104581 8192000000 10909058736 11378593792 1869985744 18.584 94 22 44 0 1896697744 20488064 6223936
19:03:37 44872 8192000000 10915031088 11384860672 1939616432 19.144 98 30 60 3 1968956352 20846240 8493680
19:04:30 119107 8192000000 10866956320 11344494592 1860975856 18.511 94 27 54 0 1876635264 8185840 7473568
19:06:40 75446 8192000000 10854924768 11332444160 1886654608 18.719 96 14 28 0 1899705664 9358560 3692496
19:08:02 52552 8192000000 10846980608 11327709184 1900811504 18.833 98 11 22 1 1914366976 10102080 3453392
19:09:13 95217 8192000000 10861656192 11340480512 1885029264 18.706 97 10 21 1 1896757488 8881760 2846464
19:10:55 88509 8192000000 10874448384 11353141248 1915436400 18.950 98 17 35 1 1930719600 10287776 4995424
19:12:34 76459 8192000000 10865213360 11347193856 1894722432 18.784 97 15 30 1 1908733696 9533216 4478048
19:14:20 77793 8192000000 10870946320 11343724544 1894014512 18.778 97 20 41 1 1914403920 14521808 5867600
19:15:44 33533 8192000000 10878837360 11353980928 1939921264 19.146 100 26 52 1 1965483136 17801680 7760192
19:16:30 34977 8192000000 10880226304 11355373568 1935297328 19.109 99 17 34 1 1950726128 10698992 4729808
19:17:12 42877 8192000000 10889870912 11366002688 1942277360 19.165 99 18 36 0 1958386256 10748416 5360480
19:18:27 77769 8192000000 10836658080 11290316800 1754213696 17.636 90 18 35 1 1768174512 8854016 5106800
19:19:52 32623 8192000000 10860644512 11308056576 1887086624 18.722 98 40 80 0 1908442560 10353568 11002368
19:20:31 25583 8192000000 10855419952 11335999488 1928817344 19.057 100 34 68 0 1952039184 13893936 9327904
19:21:04 42537 8192000000 10863925744 11316326400 1895723712 18.792 98 27 54 2 1914708176 11241536 7742928
19:21:53 20464 8192000000 10866843952 11321004032 1918037552 18.971 99 41 82 0 1937887472 8485568 11364352
19:22:22 29967 8192000000 10867588992 11315945472 1892333872 18.765 98 38 76 1 1912804768 10103264 10367632
19:23:11 64347 8192000000 10820531296 11292913664 1816859888 18.152 95 16 32 0 1831463856 10524368 4079600
19:24:22 67021 8192000000 10826494672 11278434304 1749579584 17.598 92 18 36 0 1762020512 8244912 4196016
19:25:38 52501 8192000000 10844690464 11320590336 1879259136 18.659 99 17 34 0 1896665856 12682112 4724608
19:26:37 59740 8192000000 9890063024 10265919488 1010474256 10.980 53 4 8 0 1023857312 12398352 984704

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:29, from 18-12-2020 19:30:15 to 18-12-2020 19:30:44.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 139 v_add_invoice_to_stock 335544517
except 11 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 18-12-2020 19:30:44 to 18-12-2020 19:30:46.

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          252692
MON$OLDEST_ACTIVE               252693
MON$OLDEST_SNAPSHOT             252693
MON$NEXT_TRANSACTION            252693
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                       2042400
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.33401 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33401 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33401 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33401 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 ---
:51: 
:52: mscs-test-161.budzdorov.ru    Fri Dec 18 19:27:51 2020
:53:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:54: 
--- end of diff output ---

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

18.12.20 19:30:47. 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-18 19:30:50 No severe PSQL-related problems occured
18.12.20 19:30:51. End of report.