Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.12.2020 16:27
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 17064612 kB
MemAvailable 31430712 kB
Buffers 0 kB
Cached 14591636 kB
SwapCached 4820 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-27 16:27:09
DTS_END                         2020-12-27 16:27:09.5520
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/55502
TRN_ID                          246969
ATT_ID                          664
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: 9701.48 19597 1164177
customer order: creation 176.68 348 21202
customer order: refuse 15.53 352 1864
order to supplier: creation 45.38 1257 5446
order to supplier: removal 3.58 92242 429
invoice (draft): creation 45.69 3256 5483
invoice (draft): removal 56.25 705 6750
invoice accept: apply 42.23 18584 5068
invoice accept: cancel 51.67 756 6200
customer reserve: creation 3909.93 184 469191
customer reserve: removal 5044.13 51 605296
realization accept: apply 84.75 189 10170
realization accept: cancel 93.59 107 11231
payment from customer: creation 60.53 117 7264
payment from customer: removal 5.77 61 692
payment to supplier: creation 49.83 123 5979
payment to supplier: removal 3.58 87 429
service: total inventory turnovers 4.44 1244 533
service: total monetary turnovers 6.99 36 839
service: aggregate perf. data 0.89 19566 107
service: refresh index statistics 0.03 252669 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 27-12-2020 16:28:01 to 27-12-2020 16:28:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2913
TEST_TIME 2 3293
TEST_TIME 3 3890
TEST_TIME 4 3964
TEST_TIME 5 4661
TEST_TIME 6 4912
TEST_TIME 7 5680
TEST_TIME 8 5476
TEST_TIME 9 5458
TEST_TIME 10 5596
TEST_TIME 11 5732
TEST_TIME 12 6245
TEST_TIME 13 6512
TEST_TIME 14 6567
TEST_TIME 15 6813
TEST_TIME 16 7119
TEST_TIME 17 7261
TEST_TIME 18 7460
TEST_TIME 19 7900
TEST_TIME 20 8202
TEST_TIME 21 8284
TEST_TIME 22 8665
TEST_TIME 23 8806
TEST_TIME 24 9234
TEST_TIME 25 9370
TEST_TIME 26 9441
TEST_TIME 27 9749
TEST_TIME 28 9906
TEST_TIME 29 10407
TEST_TIME 30 10844
TEST_TIME 31 10693
TEST_TIME 32 10506
TEST_TIME 33 10805
TEST_TIME 34 10645
TEST_TIME 35 10664
TEST_TIME 36 10536
TEST_TIME 37 10486
TEST_TIME 38 10233
TEST_TIME 39 10085
TEST_TIME 40 10240
TEST_TIME 41 10161
TEST_TIME 42 10156
TEST_TIME 43 10060
TEST_TIME 44 10019
TEST_TIME 45 10120
TEST_TIME 46 10160
TEST_TIME 47 10060
TEST_TIME 48 10109
TEST_TIME 49 10081
TEST_TIME 50 9989
TEST_TIME 51 9958
TEST_TIME 52 9837
TEST_TIME 53 9767
TEST_TIME 54 9738
TEST_TIME 55 9676
TEST_TIME 56 9744
TEST_TIME 57 9705
TEST_TIME 58 9652
TEST_TIME 59 9694
TEST_TIME 60 9577
TEST_TIME 61 9822
TEST_TIME 62 9995
TEST_TIME 63 9945
TEST_TIME 64 10065
TEST_TIME 65 10035
TEST_TIME 66 10030
TEST_TIME 67 10054
TEST_TIME 68 10090
TEST_TIME 69 10208
TEST_TIME 70 10228
TEST_TIME 71 10316
TEST_TIME 72 10193
TEST_TIME 73 10086
TEST_TIME 74 10073
TEST_TIME 75 10070
TEST_TIME 76 10085
TEST_TIME 77 10049
TEST_TIME 78 10024
TEST_TIME 79 9951
TEST_TIME 80 9946
TEST_TIME 81 9876
TEST_TIME 82 9858
TEST_TIME 83 9867
TEST_TIME 84 9868
TEST_TIME 85 9779
TEST_TIME 86 9718
TEST_TIME 87 9699
TEST_TIME 88 9813
TEST_TIME 89 9794
TEST_TIME 90 9758
TEST_TIME 91 9779
TEST_TIME 92 9841
TEST_TIME 93 9816
TEST_TIME 94 9920
TEST_TIME 95 9906
TEST_TIME 96 9906
TEST_TIME 97 9871
TEST_TIME 98 9887
TEST_TIME 99 9880
TEST_TIME 100 9940
TEST_TIME 101 9901
TEST_TIME 102 9973
TEST_TIME 103 9965
TEST_TIME 104 9900
TEST_TIME 105 9860
TEST_TIME 106 9831
TEST_TIME 107 9847
TEST_TIME 108 9805
TEST_TIME 109 9763
TEST_TIME 110 9763
TEST_TIME 111 9720
TEST_TIME 112 9699
TEST_TIME 113 9676
TEST_TIME 114 9748
TEST_TIME 115 9730
TEST_TIME 116 9737
TEST_TIME 117 9719
TEST_TIME 118 9676
TEST_TIME 119 9782
TEST_TIME 120 9708

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 27-12-2020 16:28:05 to 27-12-2020 16:28: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 1600026 1600026 0 0.00 0 26600 6 0 0
doc_list_biud 1600017 1600017 0 0.00 0 55971 25 0 0
sp_add_invoice_to_stock 5231 5068 163 3.11 37 209149 18584 0 163
sp_cancel_adding_invoice 6200 6200 0 0.00 4 62512 757 0 0
sp_cancel_client_order 1864 1864 0 0.00 4 12401 352 0 0
sp_cancel_customer_reserve 605296 605296 0 0.00 1 30601 51 0 0
sp_cancel_pay_from_customer 692 692 0 0.00 2 2336 62 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 2 4754 87 0 0
sp_cancel_supplier_invoice 6763 6750 13 0.19 2 55977 706 0 13
sp_cancel_supplier_order 429 429 0 0.00 6 1052104 92243 0 0
sp_cancel_write_off 11231 11231 0 0.00 1 26409 107 0 0
sp_client_order 21202 21202 0 0.00 4 26680 349 0 0
sp_customer_reserve 469191 469191 0 0.00 0 47393 185 0 0
sp_fill_shopping_cart 32129 32129 0 0.00 1 18256 37 0 0
sp_fill_shopping_cart_clo_res 469190 469190 0 0.00 0 12752 12 0 0
sp_get_clo_for_invoice 5058 5058 0 0.00 0 15298 261 0 0
sp_kill_cost_storno 18552 18552 0 0.00 0 10935 53 0 0
sp_kill_qstorno_ret_qs2qd 1229002 1229002 0 0.00 0 55968 28 0 0
sp_kill_qty_storno 646994 646994 0 0.00 0 55970 61 0 0
sp_lock_selected_doc 21225 21225 0 0.00 0 8189 6 0 0
sp_make_cost_storno 28471 28471 0 0.00 0 12355 48 0 0
sp_multiply_rows_for_pdistr 28463 28463 0 0.00 0 6266 30 0 0
sp_multiply_rows_for_qdistr 21202 21202 0 0.00 0 14857 156 0 0
sp_pay_from_customer 7264 7264 0 0.00 4 10351 117 0 0
sp_pay_to_supplier 5979 5979 0 0.00 4 35077 123 0 0
sp_payment_common 13238 13238 0 0.00 1 34934 32 0 0
sp_qd_handle_on_cancel_clo 1864 1864 0 0.00 0 12394 325 0 0
sp_qd_handle_on_invoice_upd_sts 11257 11257 0 0.00 0 33948 326 0 0
sp_qd_handle_on_reserve_upd_sts 10167 10167 0 0.00 0 26700 78 0 0
sp_reserve_write_off 10170 10170 0 0.00 6 26720 189 0 0
sp_supplier_invoice 5483 5483 0 0.00 7 91457 3257 0 0
sp_supplier_order 5446 5446 0 0.00 5 33264 1257 0 0
srv_aggregate_perf_data 108 107 1 0.92 2905 124764 19567 0 1
srv_fill_mon_cache_memory 167 167 0 0.00 1543 172095 31807 0 0
srv_find_qd_qs_mism 1116327 1116327 0 0.00 0 26600 6 0 0
srv_make_invnt_saldo 533 533 0 0.00 47 99908 1245 0 0
srv_make_money_saldo 839 839 0 0.00 1 3613 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 223686 325238 252670 0 0
t$perf-abend:sp_add_invoice_to_stock 163 163 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 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 5068 5068 0 0.00 0 15098 207 0 0
t$perf-norm:sp_cancel_adding_invoice 446 446 0 0.00 1 5790 97 0 0
t$perf-norm:sp_cancel_client_order 1864 1864 0 0.00 0 14685 25 0 0
t$perf-norm:sp_cancel_customer_reserve 713 713 0 0.00 0 527 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 692 692 0 0.00 0 6472 23 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 12871 69 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 3245 20 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 25759 1705 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 12807 16 0 0
t$perf-norm:sp_client_order 21202 21202 0 0.00 0 14648 20 0 0
t$perf-norm:sp_customer_reserve 1067 1067 0 0.00 0 1659 6 0 0
t$perf-norm:sp_pay_from_customer 7264 7264 0 0.00 0 8175 15 0 0
t$perf-norm:sp_pay_to_supplier 5979 5979 0 0.00 0 5178 10 0 0
t$perf-norm:sp_reserve_write_off 10170 10170 0 0.00 0 9345 12 0 0
t$perf-norm:sp_supplier_invoice 5483 5483 0 0.00 0 18324 26 0 0
t$perf-norm:sp_supplier_order 5446 5446 0 0.00 0 7205 17 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 201 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 948 11 0 0
t$perf-norm:srv_make_invnt_saldo 533 533 0 0.00 0 23536 69 0 0
t$perf-norm:srv_make_money_saldo 839 839 0 0.00 0 6619 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10434 10108 326 3.12 0 9760 19 0 326
v_all_customers 38452 38452 0 0.00 0 16 1 0 0
v_all_suppliers 30582 30582 0 0.00 0 26 1 0 0
v_all_wares 42404 42404 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 892 892 0 0.00 0 1369 10 0 0
v_cancel_client_order 3728 3728 0 0.00 0 3821 6 0 0
v_cancel_customer_prepayment 1384 1384 0 0.00 0 809 4 0 0
v_cancel_customer_reserve 1426 1426 0 0.00 0 2359 5 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 4687 13 0 0
v_cancel_supplier_invoice 806 780 26 3.22 0 4531 19 0 26
v_cancel_supplier_order 858 858 0 0.00 0 732 5 0 0
v_cancel_write_off 2076 2076 0 0.00 0 3909 17 0 0
v_max_id_clo_ord 5446 5446 0 0.00 0 2406 2 0 0
v_max_id_clo_res 1067 1067 0 0.00 0 2729 15 0 0
v_max_id_ord_sup 5481 5481 0 0.00 0 5669 5 0 0
v_max_non_paid_invoice 1608 1608 0 0.00 0 1460 4 0 0
v_max_non_paid_realizn 3892 3892 0 0.00 0 2344 4 0 0
v_min_id_clo_ord 5446 5446 0 0.00 0 12764 11 0 0
v_min_id_clo_res 1067 1067 0 0.00 0 2740 6 0 0
v_min_id_ord_sup 5481 5481 0 0.00 0 7175 9 0 0
v_min_non_paid_invoice 5972 5972 0 0.00 0 34930 24 0 0
v_min_non_paid_realizn 7264 7264 0 0.00 0 10337 17 0 0
v_our_firm 10696 10696 0 0.00 0 13 1 0 0
v_reserve_write_off 20330 20330 0 0.00 0 4708 6 0 0
x_lock_depdocs_on_canc_invoice 12560 12560 0 0.00 0 14901 103 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 10611 334 0 0
x_make_qstorno_1000_1200 5446 5446 0 0.00 1 32519 1174 0 0
x_make_qstorno_1200_2000 5483 5483 0 0.00 3 91425 3128 0 0
x_make_qstorno_2100_3300 469191 469191 0 0.00 0 47392 170 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 27-12-2020 16:28:09 to 27-12-2020 16:28:14.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:13 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:19 8896 8192000000 10210526048 10508566528 1004813104 10.925 79 63 132 0 1028225344 2712272 20699968
13:57:36 18942 8192000000 10301834256 10617860096 1358655040 14.225 100 79 158 0 1388893440 4206768 26031632
13:58:02 25908 8192000000 10369645616 10693238784 1419825872 14.771 100 87 174 0 1453816688 5786320 28204496
13:58:38 24507 8192000000 10395518432 10723958784 1450285712 15.040 100 92 184 0 1487961968 7143136 30533120
13:59:18 5230 8192000000 10419574464 10747858944 1475040480 15.258 100 91 182 0 1512448432 7757008 29650944
13:59:32 26304 8192000000 10434931888 10770370560 1488371600 15.375 100 86 172 1 1524405056 8044208 27989248
14:00:13 20414 8192000000 10469659488 10805714944 1512902400 15.589 100 84 168 0 1548034272 8514800 26617072
14:01:02 26395 8192000000 10501203200 10845470720 1549725280 15.908 100 86 172 1 1586597472 9272000 27600192
14:01:40 20369 8192000000 10523442496 10876387328 1586104624 16.220 100 83 166 1 1621591312 10052320 25434368
14:02:13 8432 8192000000 10560086048 10915639296 1617083072 16.485 100 88 175 0 1654140832 10931648 26126112
14:02:33 9077 8192000000 10573176464 10934718464 1633463936 16.624 100 81 164 0 1668597968 10952592 24181440
14:02:51 9170 8192000000 10590643440 10953097216 1650867520 16.772 100 77 154 0 1684995904 11768736 22359648
14:03:08 13064 8192000000 10612826752 10975940608 1670090160 16.934 100 83 167 0 1707548288 13113328 24344800
14:03:29 10493 8192000000 10630643520 10993766400 1686115504 17.069 100 86 171 0 1724913808 14102608 24695696
14:03:48 8291 8192000000 10637964736 11008901120 1694583968 17.140 100 79 157 1 1731203520 13419136 23200416
14:04:03 7262 8192000000 10660767152 11029299200 1712343232 17.288 100 78 156 3 1747358864 13113344 21902288
14:04:17 5781 8192000000 10664868512 11034648576 1720211712 17.354 100 79 159 1 1756563120 13059328 23292080
14:04:31 6784 8192000000 10675076400 11049934848 1731714704 17.450 100 86 170 3 1769699632 13448048 24536880
14:04:45 6033 8192000000 10685736320 11062931456 1742884912 17.543 100 81 161 2 1779425456 14062144 22478400
14:04:58 4678 8192000000 10696977040 11071266816 1757412640 17.663 100 87 174 0 1795873200 13798544 24662016
14:05:10 5229 8192000000 10703476704 11081277440 1766101008 17.735 100 84 169 0 1803016112 13301024 23614080
14:05:22 3242 8192000000 10715853520 11097231360 1775539376 17.813 100 83 160 4 1811035680 12918272 22578032
14:05:32 3827 8192000000 10722640800 11098525696 1782448816 17.870 100 85 168 0 1819543424 12843312 24251296
14:05:43 3249 8192000000 10731489776 11106549760 1786299616 17.901 100 90 181 3 1825512752 13556048 25657088
14:05:52 2964 8192000000 10726494080 11110739968 1794451808 17.968 100 78 156 2 1828650400 11663920 22534672
14:06:02 8366 8192000000 10740858272 11123036160 1802236640 18.032 100 78 156 0 1836490144 12941088 21312416
14:06:17 4996 8192000000 10750979008 11140927488 1810792016 18.102 100 85 171 0 1848044448 13655040 23597392
14:06:28 2377 8192000000 10769906272 11154952192 1826409696 18.230 100 85 170 1 1864148048 14292512 23445840
14:06:37 1571 8192000000 10773880352 11158884352 1831351760 18.270 100 90 180 0 1870360736 14085568 24923408
14:06:45 1631 8192000000 10777764272 11159605248 1838123120 18.326 100 95 189 0 1880334800 15358032 26853648
14:06:53 2106 8192000000 10780698016 11164737536 1843282400 18.368 100 96 192 0 1885839456 15072400 27484656
14:07:02 1852 8192000000 10799127680 11182587904 1848861552 18.413 100 93 187 0 1889556288 14335168 26359568
14:07:10 2126 8192000000 10799828128 11187032064 1855871312 18.470 100 96 192 3 1896905536 14499216 26535008
14:07:18 2486 8192000000 10796655184 11185381376 1856437152 18.474 100 88 177 0 1894876688 13710512 24729024
14:07:27 1604 8192000000 10794449584 11191238656 1861363344 18.514 100 88 176 0 1899471072 12122864 25984864
14:07:35 2106 8192000000 10814856112 11201089536 1868878000 18.575 100 89 178 0 1905999808 12201232 24920576
14:07:43 1015 8192000000 10820825664 11208937472 1873903696 18.616 100 90 180 1 1912992352 13515472 25573184
14:07:51 1539 8192000000 10819114288 11207749632 1877072272 18.641 100 87 174 0 1915366800 13821664 24472864
14:07:59 1731 8192000000 10825289488 11215810560 1880676624 18.671 100 91 183 1 1920934704 14833568 25424512
14:08:07 22240 8192000000 10805716960 11212214272 1875303360 18.627 100 51 101 0 1898525424 8666128 14555936
14:08:49 1560 8192000000 10823113104 11217203200 1883924832 18.697 100 84 167 1 1918190672 10259216 24006624
14:08:57 16452 8192000000 10789967984 11216588800 1882999568 18.689 100 56 113 1 1910077952 11635584 15442800
14:09:21 2604 8192000000 10793122880 11215802368 1882397440 18.684 100 38 76 0 1901534000 8504928 10631632
14:09:32 4630 8192000000 10789008640 11216322560 1880697792 18.671 100 24 49 0 1893996608 6685104 6613712
14:09:43 4263 8192000000 10804422176 11226513408 1888843824 18.736 100 33 62 4 1904135280 6084608 9206848
14:09:54 10340 8192000000 10791785408 11221950464 1886786912 18.720 100 24 45 3 1899129168 6168144 6174112
14:10:14 5680 8192000000 10807739872 11226054656 1889995264 18.746 100 35 70 2 1906619712 6201856 10422592
14:10:26 3605 8192000000 10814681632 11234934784 1896215376 18.796 100 44 89 0 1917036368 8389920 12431072
14:10:38 2468 8192000000 10815697872 11241611264 1899948416 18.826 100 52 104 1 1924225856 9266240 15011200
14:10:46 8691 8192000000 10803316720 11233374208 1893552736 18.774 100 28 54 0 1907305712 6398240 7354736
14:11:01 7802 8192000000 10798193776 11230007296 1893365568 18.773 100 20 39 0 1904349904 5743360 5240976
14:11:17 9616 8192000000 10802569408 11239604224 1899659824 18.824 100 30 59 1 1915021504 7032656 8329024
14:11:33 18858 8192000000 10797703296 11242074112 1898747712 18.816 100 14 29 1 1908473424 6048544 3677168
14:12:01 8976 8192000000 10804610096 11245522944 1902705616 18.848 100 25 50 2 1917096656 7677008 6714032
14:12:17 6830 8192000000 10808471520 11242770432 1904695472 18.864 100 24 49 1 1916986800 5653024 6638304
14:12:30 11565 8192000000 10807707408 11245150208 1906371856 18.878 100 31 63 2 1925862352 10265104 9225392
14:12:51 58162 8192000000 10845905728 11262164992 1909396048 18.902 100 45 91 1 1928146416 4662912 14087456
14:14:01 7802 8192000000 10818324496 11253383168 1907107104 18.883 100 24 48 3 1919529104 5446320 6975680
14:14:15 6762 8192000000 10831697536 11257671680 1908555504 18.895 100 27 49 2 1922799216 6167136 8076576
14:14:28 7161 8192000000 10823125184 11258740736 1910698720 18.912 100 21 40 1 1922114112 5884688 5530704
14:14:43 6935 8192000000 10827586576 11258867712 1895877184 18.793 99 42 84 2 1914129712 5851008 12401520
14:14:58 8471 8192000000 10825089056 11260092416 1908517248 18.895 100 24 46 1 1922145120 6532784 7095088
14:15:12 8154 8192000000 10817530368 11258097664 1909227696 18.900 100 19 38 1 1920184624 5077680 5879248
14:15:31 5233 8192000000 10823041440 11257892864 1908765632 18.897 100 23 45 3 1921660768 5999056 6896080
14:15:45 8888 8192000000 10825895792 11259035648 1908250128 18.893 100 10 20 1 1916042016 5035024 2756864
14:16:01 8468 8192000000 10817624240 11255730176 1903773888 18.857 100 19 38 2 1915629088 5992768 5862432
14:16:17 7372 8192000000 10817443760 11247472640 1873979744 18.616 98 30 59 2 1887861408 5346224 8535440
14:16:30 7244 8192000000 10810132672 11233349632 1849800544 18.421 97 27 55 1 1862725280 4879584 8045152
14:16:45 12432 8192000000 10754233200 11193384960 1786818800 17.906 95 26 52 6 1800404416 6621456 6964160
14:17:04 12520 8192000000 10766302448 11188498432 1832563920 18.280 99 19 37 3 1843665920 5908208 5193792
14:17:23 62870 8192000000 10772344528 11189891072 1777321696 17.827 95 33 66 2 1792209168 4894160 9993312
14:18:38 12443 8192000000 10757634032 11174662144 1765059616 17.726 95 23 46 0 1776375488 4954720 6361152
14:18:57 6256 8192000000 10728509584 11140087808 1749327728 17.596 96 25 50 0 1762795648 6273888 7194032
14:19:10 5393 8192000000 10735526384 11153883136 1791980576 17.948 98 37 74 1 1810435600 7875936 10579088
14:19:22 6915 8192000000 10723161184 11138994176 1764799760 17.724 97 34 69 1 1781457056 6334464 10322832
14:19:38 6725 8192000000 10716407376 11120283648 1753712560 17.632 97 35 67 2 1769763344 5746880 10303904
14:19:51 8673 8192000000 10717564880 11138990080 1760250944 17.686 97 24 46 1 1772337888 5500768 6586176
14:20:08 6848 8192000000 10723150256 11137593344 1780212720 17.851 98 32 64 1 1795805392 5707712 9884960
14:20:21 6766 8192000000 10705805168 11120488448 1737833056 17.501 96 29 58 1 1752004144 6147456 8023632
14:20:34 7894 8192000000 10715216512 11132321792 1779476624 17.845 99 32 63 2 1795663744 6593040 9594080
14:20:49 8753 8192000000 10683655824 11087724544 1713434064 17.297 95 23 44 2 1725037728 5071664 6532000
14:21:05 12124 8192000000 10686495840 11104739328 1725374928 17.397 96 30 60 2 1739952848 5352592 9225328
14:21:28 10379 8192000000 10711132912 11133460480 1798595984 18.002 100 16 32 2 1809184976 6031296 4557696
14:21:44 6924 8192000000 10742196272 11143901184 1791330528 17.943 99 35 67 2 1811136400 9363488 10442384
14:22:00 5995 8192000000 10735145552 11155607552 1813944336 18.128 100 22 44 2 1830785328 10936400 5904592
14:22:12 63294 8192000000 10722921632 11150172160 1809024192 18.088 99 31 61 1 1827872032 10248864 8598976
14:23:22 7895 8192000000 10747129728 11171516416 1835957312 18.308 100 23 46 1 1848339024 5859264 6522448
14:23:37 9720 8192000000 10751173152 11182915584 1845854240 18.388 100 28 56 1 1860182416 6574448 7753728
14:23:53 11462 8192000000 10767356656 11190325248 1850594736 18.427 100 23 46 0 1862386288 5530656 6260896
14:24:12 7524 8192000000 10783206640 11204464640 1859047824 18.496 100 29 58 2 1874028880 6534320 8446736
14:24:28 8645 8192000000 10783333504 11207958528 1862808544 18.526 100 29 56 2 1876846544 5126128 8911872
14:24:43 11482 8192000000 10785548752 11212951552 1864716736 18.542 100 21 41 1 1879935312 9129040 6089536
14:25:01 10223 8192000000 10779460784 11213234176 1868836240 18.575 100 22 44 3 1881890704 6088384 6966080
14:25:18 11483 8192000000 10798458368 11222433792 1873642896 18.614 100 16 32 1 1888237824 9602528 4992400
14:25:42 11829 8192000000 10796245312 11222130688 1874969488 18.624 100 26 52 0 1888345584 5468176 7907920
14:26:00 11281 8192000000 10779096320 11219259392 1875512816 18.629 100 19 38 4 1886051744 4540016 5998912
14:26:17 7499 8192000000 10785184080 11219996672 1878374704 18.652 100 25 50 2 1895567264 9771600 7420960
14:26:34 13563 8192000000 10789406400 11227570176 1878321536 18.652 100 17 34 0 1893584336 10596464 4666336
14:26:54 15380 8192000000 10811725456 11234979840 1888533088 18.734 100 21 43 1 1903151392 9411504 5206800
14:27:17 13760 8192000000 10838313696 11252789248 1908942592 18.898 100 45 90 2 1927450672 6162720 12345360
14:27:38 172095 8192000000 10863544192 11289571328 1924148416 19.020 100 44 88 1 1944774272 8118272 12507584
14:30:38 19784 8192000000 10871857152 11292925952 1936898064 19.122 100 40 80 0 1958647744 10796224 10953456
14:31:05 37044 8192000000 10869644208 11305619456 1939094624 19.140 100 44 88 2 1965121936 12555264 13472048
14:32:04 63670 8192000000 10895325696 11321339904 1954062288 19.259 100 27 52 3 1977183936 15734000 7387648
14:33:14 17006 8192000000 10906137904 11335098368 1964460256 19.341 100 41 82 0 1991505056 14720368 12324432
14:33:38 6734 8192000000 10915982896 11343360000 1972482512 19.405 100 59 118 0 2008641664 17987040 18172112
14:33:55 5686 8192000000 10918963712 11343912960 1973843568 19.416 100 55 109 4 2008212736 18116608 16252560
14:34:08 8776 8192000000 10924827936 11349139456 1977451200 19.445 100 55 109 1 2011138528 17294048 16393280
14:34:24 13416 8192000000 10918004688 11352768512 1980605696 19.469 100 45 90 1 2011918976 18408368 12904912
14:34:49 13825 8192000000 10936838896 11363266560 1987942464 19.528 100 56 112 2 2020565536 15726416 16896656
14:35:10 11289 8192000000 10931745520 11363586048 1990247136 19.546 100 50 100 0 2023926464 19308848 14370480
14:36:01 6913 8192000000 10929080800 11364544512 1988680112 19.533 100 51 100 2 2023083600 19817920 14585568
14:36:18 7173 8192000000 10924050352 11363459072 1970764784 19.392 99 36 72 1 2002025344 20410544 10850016
14:36:43 5244 8192000000 10925963824 11353591808 1965649216 19.351 99 54 107 1 2002469776 20712960 16107600
14:36:59 12540 8192000000 10933896208 11369459712 1989446320 19.539 100 54 107 1 2026920480 22002544 15471616
14:37:18 7107 8192000000 10949618688 11376525312 1997605440 19.604 100 55 110 3 2037666656 23400064 16661152
14:37:33 8654 8192000000 10925212480 11351023616 1971201632 19.395 99 56 112 1 2011954688 23973024 16780032
14:37:49 7683 8192000000 10926768912 11359600640 1980566160 19.469 100 47 94 2 2018482336 23953408 13962768
14:38:10 6357 8192000000 10944242080 11372027904 1988879184 19.535 100 59 116 2 2033430704 27061280 17490240
14:38:22 4420 8192000000 10950198992 11366850560 1977093856 19.442 99 80 160 2 2029849776 28610560 24145360
14:38:35 5402 8192000000 10943481536 11363094528 1982167824 19.482 100 66 132 0 2031078368 29470880 19439664
14:38:49 7349 8192000000 10934653552 11356172288 1955126656 19.267 98 69 139 1 2005232208 29583680 20521872
14:39:03 2423 8192000000 10911678000 11319767040 1933489200 19.095 99 74 149 2 1986437024 31001072 21946752
14:39:13 5106 8192000000 10919948160 11336372224 1958951296 19.298 100 79 158 1 2014273440 30674736 24647408
14:39:27 11633 8192000000 10922299424 11341680640 1961856208 19.321 100 61 122 0 2009869456 29842416 18170832
14:39:46 2955 8192000000 10950283984 11362054144 1973326784 19.412 100 85 170 3 2032667872 34054048 25287040
14:39:56 3948 8192000000 10970247744 11385790464 1991668400 19.557 100 85 168 0 2053122768 36826816 24627552
14:40:07 2148 8192000000 10975088096 11388977152 2001805520 19.637 100 92 181 2 2061767664 33385936 26576208
14:40:17 2708 8192000000 10961739360 11374239744 1975115504 19.426 99 73 145 1 2034440992 38405712 20919776
14:40:26 3479 8192000000 10956760704 11375820800 1970653360 19.391 99 79 158 0 2028851520 34638720 23559440
14:40:37 7571 8192000000 10937825904 11359719424 1945992208 19.195 98 64 127 2 1999819856 34468672 19358976
14:40:56 10607 8192000000 10926763040 11348025344 1962524368 19.326 100 70 138 3 2018656000 34841088 21290544
14:41:14 2961 8192000000 10943140928 11366137856 1971723728 19.399 100 69 137 0 2031886848 39721040 20442080
14:41:24 7060 8192000000 10931303568 11359670272 1953681488 19.256 99 56 112 2 2005861296 34958672 17221136
14:41:40 2664 8192000000 10940461360 11356176384 1969464080 19.381 100 76 148 1 2028774752 35925184 23385488
14:41:50 8433 8192000000 10928575280 11357802496 1965871792 19.353 100 55 110 1 2020391120 36382736 18136592
14:42:10 1915 8192000000 10927428384 11343880192 1951757392 19.240 99 79 155 1 2013454016 37063952 24632672
14:42:19 2260 8192000000 10928641712 11346739200 1941773008 19.161 99 70 140 0 2003938560 39320144 22845408
14:42:29 3338 8192000000 10896886720 11295510528 1906377376 18.878 98 86 172 1 1974977120 40936400 27663344
14:42:39 4113 8192000000 10919160208 11334778880 1941161152 19.156 100 80 160 2 2006970912 40684304 25125456
14:42:51 4080 8192000000 10933779024 11340632064 1947504304 19.207 100 83 164 1 2014114096 41360208 25249584
14:43:03 2368 8192000000 10922923136 11331854336 1938594240 19.136 99 83 165 3 2002499120 38146848 25758032
14:43:14 2134 8192000000 10945896448 11355389952 1962572112 19.326 100 84 166 4 2028407872 39565040 26270720
14:43:23 1542 8192000000 10944813232 11353014272 1954288096 19.261 99 89 180 1 2023863792 41401648 28174048
14:43:34 3281 8192000000 10939682784 11356205056 1963831408 19.336 100 76 151 2 2025389232 39060768 22497056
14:43:52 2139 8192000000 10913756032 11325202432 1926738848 19.041 99 77 151 0 1991065008 40843536 23482624
14:44:05 6191 8192000000 10912396288 11329515520 1909019248 18.899 98 73 145 4 1972148544 40626000 22503296
14:44:18 12066 8192000000 10916548352 11338293248 1939681168 19.144 100 72 143 1 2003044096 41570048 21792880
14:44:38 2493 8192000000 10930065584 11350880256 1948383152 19.214 100 65 129 2 2014117376 45158288 20575936
14:44:53 6439 8192000000 10934735392 11359895552 1954926368 19.266 100 64 128 1 2021671792 46933616 19811808
14:45:12 1999 8192000000 10938765840 11345158144 1940770672 19.153 100 80 159 0 2014538976 48079328 25688976
14:45:23 3674 8192000000 10944474592 11358134272 1954434192 19.262 100 80 160 1 2029303792 49540480 25329120
14:45:33 5961 8192000000 10952363568 11371061248 1960244528 19.308 100 73 146 1 2032451744 49228688 22978528
14:45:49 3086 8192000000 10952972544 11360456704 1956668368 19.280 100 80 158 1 2029124576 47570416 24885792
14:46:01 2332 8192000000 10952332928 11362947072 1956166352 19.276 100 88 176 1 2032506128 49672976 26666800
14:46:11 5213 8192000000 10957086304 11371143168 1963899248 19.337 100 83 165 3 2037787760 48817888 25070624
14:46:26 2246 8192000000 10946756336 11370991616 1963141200 19.331 100 73 144 1 2034385904 48858912 22385792
14:46:37 2474 8192000000 10968560160 11386822656 1973081120 19.410 100 89 176 2 2049474544 49234160 27159264
14:46:47 3918 8192000000 10943515312 11356467200 1940050608 19.147 99 82 161 1 2014506480 50474560 23981312
14:46:59 2710 8192000000 10945343248 11360608256 1954298176 19.261 100 83 165 3 2025663536 45561120 25804240
14:47:08 4433 8192000000 10949428432 11363475456 1958631440 19.295 100 72 144 0 2023653552 43436368 21585744
14:47:21 3493 8192000000 10910186128 11342856192 1938210512 19.132 99 50 100 1 1995455120 41936976 15307632
14:47:36 6142 8192000000 10906243888 11349512192 1945631664 19.192 100 33 66 0 1997799504 41030240 11137600
14:47:50 11349 8192000000 10920564736 11357835264 1931951440 19.082 99 37 74 2 1996027584 52115232 11960912
14:48:09 7700 8192000000 10911293376 11340173312 1928681904 19.056 99 50 100 1 1988586096 44067088 15837104
14:48:26 4157 8192000000 10926900624 11350781952 1945709136 19.192 100 68 134 3 2010262352 43767264 20785952
14:48:44 1751 8192000000 10952135872 11365822464 1956247648 19.276 100 86 167 2 2031473888 48842368 26383872
14:48:53 2388 8192000000 10945043984 11362410496 1956301968 19.277 100 83 164 3 2030783072 49587728 24893376
14:49:03 11343 8192000000 10925613728 11370934272 1950406576 19.230 100 41 82 1 2017365152 54126448 12832128
14:49:23 13985 8192000000 10905726144 11344154624 1934766864 19.105 100 26 52 2 1986393648 42337824 9288960
14:49:44 7773 8192000000 10903911312 11336159232 1931036720 19.075 100 35 68 2 1984618368 42630272 10951376
14:49:59 10023 8192000000 10903923456 11340865536 1932200176 19.084 100 33 64 2 1986898336 44407248 10290912
14:50:16 14208 8192000000 10912267904 11348840448 1935680192 19.112 100 38 73 1 1996227824 48273984 12273648
14:50:39 5987 8192000000 10918434000 11353604096 1940401088 19.150 100 40 80 2 2001892784 48022144 13469552
14:51:01 10943 8192000000 10929047728 11364773888 1943631648 19.176 100 38 76 2 2005095584 49171184 12292752
14:51:21 4833 8192000000 10927623472 11366989824 1949054624 19.219 100 34 68 0 2008644256 47981088 11608544
14:51:33 12771 8192000000 10912789056 11354173440 1928752320 19.057 99 32 64 0 1978799600 39787568 10259712
14:51:54 23332 8192000000 10914008096 11364347904 1951272912 19.237 100 29 58 1 1998179872 37654832 9252128
14:52:28 33340 8192000000 10895345344 11334549504 1874934976 18.624 96 24 48 1 1916637504 33728784 7973744
14:53:08 24555 8192000000 10881696720 11334066176 1913459680 18.934 99 25 50 3 1953342080 31733488 8148912
14:53:41 18353 8192000000 10896489200 11345690624 1935019120 19.107 100 23 46 0 1979403888 36474048 7910720
14:54:40 27891 8192000000 10892522960 11353096192 1940974512 19.155 100 17 34 0 1983526656 36712896 5839248
14:55:21 11693 8192000000 10905053808 11364790272 1944140544 19.180 100 17 34 1 1988100624 38134960 5825120
14:55:58 18245 8192000000 10879649680 11350355968 1926762944 19.041 99 18 36 2 1957805728 25402880 5639904
14:56:27 50717 8192000000 10893581264 11362111488 1952651392 19.248 100 17 34 2 1978414896 20736944 5026560
14:57:24 96473 8192000000 10921474016 11362791424 1927808032 19.049 98 12 24 0 1942956480 12567792 2580656
14:59:21 43450 8192000000 10910176976 11370065920 1960020368 19.306 99 35 70 1 1988587696 19365488 9201840
15:00:13 82821 8192000000 10901841792 11363328000 1951069600 19.235 99 8 16 0 1969118528 16342256 1706672
15:01:52 57463 8192000000 10905055552 11349610496 1940802256 19.153 99 8 16 1 1958041424 15425744 1813424
15:03:01 57993 8192000000 10930166384 11378327552 1974224576 19.419 100 28 56 5 1991255168 9395088 7635504
15:04:16 32833 8192000000 10929763024 11385122816 1990207200 19.545 100 38 76 2 2017040480 16302128 10531152
15:04:59 97502 8192000000 10899465632 11353600000 1923692608 19.016 98 30 58 2 1946602544 13345520 9564416
15:06:58 37528 8192000000 10926039936 11382882304 1969923264 19.385 100 49 99 0 2006146848 20665168 15558416
15:07:51 74231 8192000000 10904400992 11384737792 1972510368 19.405 100 19 38 2 1997738384 19225360 6002656
15:09:14 10372 8192000000 10912671184 11388514304 1972976672 19.409 100 13 26 3 1994370144 17708112 3685360
15:10:19 21748 8192000000 10937686224 11390976000 1989753920 19.542 100 26 53 0 2009275632 11565248 7956464
15:10:55 14278 8192000000 10907589648 11373547520 1959076464 19.299 99 19 38 3 1979644752 14919504 5648784
15:11:18 26125 8192000000 10928166704 11369193472 1943680368 19.176 98 40 80 0 1968964960 13481920 11802672
15:11:52 34235 8192000000 10922043632 11381587968 1968492560 19.373 99 64 126 2 2004618240 16202368 19923312
15:12:41 62888 8192000000 10888293504 11366584320 1938966608 19.139 99 11 22 0 1960641328 17977008 3697712
15:13:50 25350 8192000000 10888112400 11371540480 1962098480 19.323 100 13 26 0 1980364880 14442384 3824016
15:14:21 30192 8192000000 10871489952 11349065728 1925461824 19.031 98 7 14 0 1938491984 10687504 2342656
15:14:57 21981 8192000000 10884575024 11360219136 1958231360 19.292 100 8 16 0 1970008864 9459648 2317856
15:15:25 20231 8192000000 10880568192 11352313856 1935835360 19.114 99 21 44 0 1952750128 10767568 6147200
15:15:57 63120 8192000000 10861180704 11340402688 1912982048 18.931 98 10 20 1 1924938160 9548608 2407504
15:18:07 55874 8192000000 10842665648 11321237504 1911578832 18.919 98 22 44 1 1925469184 7705440 6184912
15:19:10 49423 8192000000 10888722768 11356844032 1949900128 19.226 100 11 22 0 1961416608 9142464 2374016
15:20:06 58726 8192000000 10881634576 11353915392 1938190768 19.132 99 30 58 1 1958295472 11678736 8425968
15:21:14 50052 8192000000 10873121072 11351109632 1924108880 19.020 98 15 30 0 1940521552 12076992 4335680
15:22:21 69110 8192000000 10870893328 11366846464 1947282336 19.205 100 10 20 2 1968218352 17353152 3582864
15:23:40 56775 8192000000 10888325312 11362930688 1904931120 18.866 97 14 28 1 1917863920 8989888 3942912
15:24:45 21664 8192000000 10910498144 11368538112 1947956336 19.210 99 29 58 0 1962193520 6370448 7866736
15:25:15 26152 8192000000 10898265280 11360321536 1925219472 19.029 98 34 68 1 1948830432 14046144 9564816
15:25:47 26542 8192000000 10906060624 11370213376 1924431872 19.022 98 24 48 1 1952184672 21230144 6522656
15:26:20 92361 8192000000 10905935728 11378397184 1899329024 18.821 97 17 34 1 1933180672 29132784 4718864
15:28:04 44627 8192000000 10847130528 11302608896 1792305424 17.951 92 13 26 1 1815349024 19445792 3597808
15:28:55 38909 8192000000 10851827408 11331219456 1903526992 18.855 99 27 54 0 1926576624 14896928 8152704
15:29:41 43488 8192000000 10885831808 11346657280 1921310096 18.997 99 12 23 1 1934905024 10626416 2968512
15:30:31 61777 8192000000 10905912720 11374190592 1959408944 19.301 100 14 28 1 1977149328 14092608 3647776
15:31:50 96428 8192000000 10883637984 11332091904 1804351168 18.050 92 29 58 1 1822435680 9328656 8755856
15:33:33 27793 8192000000 10897204416 11349540864 1948467696 19.214 100 48 96 2 1972628208 10660384 13500128
15:34:09 47137 8192000000 10891273984 11349852160 1890213952 18.748 97 24 48 1 1913616336 16280880 7121504
15:35:03 84125 8192000000 10868420592 11341025280 1828392816 18.246 94 17 34 2 1850714608 17102656 5219136
15:36:38 82550 8192000000 10886556880 11352743936 1864692976 18.541 96 14 28 1 1885775024 17023808 4058240
15:38:19 130987 8192000000 10869568400 11320467456 1877024800 18.641 97 21 43 1 1896777664 14074784 5678080
15:40:36 99167 8192000000 10892173184 11350331392 1911380944 18.918 98 33 66 0 1933656080 13066032 9209104
15:42:31 39075 8192000000 10883624064 11352981504 1926095168 19.036 99 21 42 0 1948764544 17029040 5640336
15:43:16 56484 8192000000 10861432016 11340488704 1935804480 19.113 100 20 39 1 1956303376 14326240 6172656
15:44:21 73348 8192000000 10879763136 11355787264 1931601520 19.080 99 10 20 0 1943445536 9122240 2721776
15:45:50 24286 8192000000 10886291184 11356004352 1955126816 19.267 100 19 38 1 1971943136 11592752 5223568
15:46:53 50674 8192000000 10858606048 11334803456 1910716928 18.912 98 10 19 1 1926156048 12403440 3035680
15:47:52 55058 8192000000 10866694640 11336310784 1912177552 18.924 98 14 28 0 1929275936 12895376 4203008
15:48:54 27224 8192000000 10872939152 11346132992 1944825504 19.185 100 9 18 2 1963961824 16168080 2968240
15:50:15 33456 8192000000 10889904864 11355795456 1947564000 19.207 100 18 36 0 1962051824 9753568 4734256
15:50:59 55284 8192000000 10870771280 11355746304 1940237600 19.149 99 12 24 0 1952196608 8874048 3084960
15:52:03 79823 8192000000 10900783040 11375206400 1962388912 19.325 100 10 20 0 1973558096 8514848 2654336
15:53:34 74426 8192000000 10904683728 11390414848 1967804080 19.368 100 19 38 1 1991914784 18747936 5362768
15:54:56 49409 8192000000 10877429680 11373228032 1944377904 19.182 99 8 16 0 1968781488 21645968 2757616
15:56:01 66433 8192000000 10886736112 11362963456 1905622736 18.871 97 9 17 2 1924882672 16566176 2693760
15:57:14 47919 8192000000 10918497488 11383152640 1973991952 19.417 100 21 42 2 1988633456 8689712 5951792
15:58:17 68743 8192000000 10915370176 11395227648 1973841856 19.416 99 20 40 0 1989488256 10596288 5050112
15:59:33 60310 8192000000 10909452336 11372945408 1887434320 18.725 95 11 22 0 1897773312 7859040 2479952
16:00:39 27199 8192000000 10936575680 11391074304 1982782256 19.487 100 37 73 4 2002219984 8420480 11017248
16:01:13 64389 8192000000 10923623664 11413569536 1978436576 19.452 99 39 79 1 2003354928 13852336 11066016
16:02:48 37259 8192000000 10954043552 11414261760 1979261264 19.459 99 26 48 0 1998413152 13089968 6061920
16:03:49 33676 8192000000 10930806336 11393765376 1961119792 19.315 98 30 60 0 1980350384 11109680 8120912
16:04:30 47760 8192000000 10946431888 11410305024 1996623008 19.596 100 43 86 2 2020223824 11526256 12074560
16:05:30 75178 8192000000 10952543696 11413078016 1982458464 19.484 99 34 68 0 2008106800 16462192 9186144
16:06:56 78780 8192000000 10933944512 11396071424 1941701984 19.160 97 25 51 0 1960383984 11481408 7200592
16:08:22 29554 8192000000 10916659936 11380461568 1934725696 19.105 97 31 62 3 1953881168 10722592 8432880
16:09:01 70360 8192000000 10918742032 11396677632 1958733456 19.296 99 19 38 1 1977015168 13096176 5185536
16:10:25 109744 8192000000 10882301312 11354959872 1909467280 18.902 97 14 28 1 1927751968 14397328 3887360
16:12:37 47568 8192000000 10888763888 11336204288 1851340112 18.433 94 32 64 0 1869716064 9890448 8485504
16:13:31 62792 8192000000 10852101360 11324796928 1886347472 18.716 97 34 68 0 1911973248 16056464 9569312
16:14:40 16129 8192000000 10851207440 11333615616 1912497984 18.927 99 10 19 1 1933963216 18387312 3077920
16:15:04 14340 8192000000 10852410720 11334680576 1927810992 19.049 100 4 8 1 1942851648 13880144 1160512
16:15:29 33265 8192000000 10848814080 11321229312 1884056064 18.698 97 20 39 0 1896309696 7081408 5172224
16:16:12 74367 8192000000 10867736736 11332960256 1888411344 18.733 97 20 40 1 1902220736 8174816 5634576
16:17:56 95016 8192000000 10846771504 11315122176 1873517312 18.613 97 14 28 0 1888059168 10214320 4327536
16:20:08 52383 8192000000 10855859872 11332272128 1909612832 18.904 99 16 32 1 1927342944 13519168 4210944
16:21:20 85821 8192000000 10836947712 11306242048 1818072784 18.162 94 15 30 2 1836911552 14667504 4171264
16:22:54 56085 8192000000 10830258576 11302113280 1863742912 18.534 97 14 28 2 1876124800 8385312 3996576
16:23:59 62746 8192000000 10869554048 11342667776 1921641712 19.000 99 18 36 0 1939867600 12610560 5615328
16:25:08 54309 8192000000 10868732784 11334742016 1882864288 18.688 97 13 26 2 1900425856 13677456 3884112
16:26:11 66098 8192000000 9122778720 9356730368 284218576 3.353 15 3 6 1 286873424 2052928 601920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 27-12-2020 16:28:15 to 27-12-2020 16:28:47.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 163 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 27-12-2020 16:28:48 to 27-12-2020 16:28:50.

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          247294
MON$OLDEST_ACTIVE               247295
MON$OLDEST_SNAPSHOT             247295
MON$NEXT_TRANSACTION            247295
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                       2059424
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 ---
--- end of diff output ---

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

27.12.20 16:28:51. 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-27 16:28:54 No severe PSQL-related problems occured
27.12.20 16:28:55. End of report.