Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.02.2021 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 16636064 kB
MemAvailable 31129532 kB
Buffers 0 kB
Cached 15018048 kB
SwapCached 4112 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-17 16:27:18
DTS_END                         2021-02-17 16:27:18.7400
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/37880
TRN_ID                          244689
ATT_ID                          714
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: 9722.03 21605 1166644
customer order: creation 172.60 350 20712
customer order: refuse 15.03 385 1804
order to supplier: creation 47.54 1317 5705
order to supplier: removal 3.63 105645 435
invoice (draft): creation 46.96 3498 5635
invoice (draft): removal 56.47 782 6776
invoice accept: apply 42.33 18173 5080
invoice accept: cancel 52.07 806 6248
customer reserve: creation 3862.13 180 463455
customer reserve: removal 5118.59 58 614231
realization accept: apply 83.68 221 10041
realization accept: cancel 88.38 114 10605
payment from customer: creation 60.50 164 7260
payment from customer: removal 5.84 93 701
payment to supplier: creation 50.68 165 6081
payment to supplier: removal 3.48 96 417
service: total inventory turnovers 4.68 1278 561
service: total monetary turnovers 6.61 44 793
service: aggregate perf. data 0.83 25081 100
service: refresh index statistics 0.03 273640 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 17-02-2021 16:27:57 to 17-02-2021 16:28:00.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5900
TEST_TIME 2 4279
TEST_TIME 3 3635
TEST_TIME 4 4411
TEST_TIME 5 5038
TEST_TIME 6 5460
TEST_TIME 7 5602
TEST_TIME 8 6033
TEST_TIME 9 6112
TEST_TIME 10 6325
TEST_TIME 11 6201
TEST_TIME 12 6318
TEST_TIME 13 6340
TEST_TIME 14 6283
TEST_TIME 15 6633
TEST_TIME 16 6756
TEST_TIME 17 6755
TEST_TIME 18 7024
TEST_TIME 19 7276
TEST_TIME 20 7341
TEST_TIME 21 7465
TEST_TIME 22 7484
TEST_TIME 23 8580
TEST_TIME 24 9003
TEST_TIME 25 9574
TEST_TIME 26 9592
TEST_TIME 27 9823
TEST_TIME 28 9929
TEST_TIME 29 9729
TEST_TIME 30 10299
TEST_TIME 31 11196
TEST_TIME 32 11189
TEST_TIME 33 11020
TEST_TIME 34 11009
TEST_TIME 35 11107
TEST_TIME 36 10999
TEST_TIME 37 10766
TEST_TIME 38 10691
TEST_TIME 39 10504
TEST_TIME 40 10491
TEST_TIME 41 10505
TEST_TIME 42 10596
TEST_TIME 43 10506
TEST_TIME 44 10502
TEST_TIME 45 10326
TEST_TIME 46 10335
TEST_TIME 47 10350
TEST_TIME 48 10362
TEST_TIME 49 10442
TEST_TIME 50 10352
TEST_TIME 51 10266
TEST_TIME 52 10169
TEST_TIME 53 10112
TEST_TIME 54 10086
TEST_TIME 55 9987
TEST_TIME 56 10134
TEST_TIME 57 10058
TEST_TIME 58 10068
TEST_TIME 59 10092
TEST_TIME 60 10071
TEST_TIME 61 10085
TEST_TIME 62 10115
TEST_TIME 63 10140
TEST_TIME 64 10164
TEST_TIME 65 10125
TEST_TIME 66 10170
TEST_TIME 67 10206
TEST_TIME 68 10252
TEST_TIME 69 10247
TEST_TIME 70 10292
TEST_TIME 71 10348
TEST_TIME 72 10272
TEST_TIME 73 10159
TEST_TIME 74 10183
TEST_TIME 75 10098
TEST_TIME 76 10112
TEST_TIME 77 10062
TEST_TIME 78 10030
TEST_TIME 79 9987
TEST_TIME 80 9922
TEST_TIME 81 9870
TEST_TIME 82 9849
TEST_TIME 83 9799
TEST_TIME 84 9764
TEST_TIME 85 9753
TEST_TIME 86 9845
TEST_TIME 87 9837
TEST_TIME 88 9857
TEST_TIME 89 9875
TEST_TIME 90 9875
TEST_TIME 91 9922
TEST_TIME 92 9914
TEST_TIME 93 9972
TEST_TIME 94 9989
TEST_TIME 95 10026
TEST_TIME 96 10001
TEST_TIME 97 10080
TEST_TIME 98 10040
TEST_TIME 99 9954
TEST_TIME 100 9977
TEST_TIME 101 9933
TEST_TIME 102 9940
TEST_TIME 103 9905
TEST_TIME 104 9875
TEST_TIME 105 9869
TEST_TIME 106 9826
TEST_TIME 107 9825
TEST_TIME 108 9757
TEST_TIME 109 9796
TEST_TIME 110 9769
TEST_TIME 111 9733
TEST_TIME 112 9726
TEST_TIME 113 9727
TEST_TIME 114 9704
TEST_TIME 115 9732
TEST_TIME 116 9740
TEST_TIME 117 9726
TEST_TIME 118 9730
TEST_TIME 119 9794
TEST_TIME 120 9725

Performance per minute, chart


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

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 1596712 1596712 0 0.00 0 35506 7 0 0
doc_list_biud 1596712 1596712 0 0.00 0 31964 28 0 0
sp_add_invoice_to_stock 5181 5080 101 1.94 45 149989 18173 0 101
sp_cancel_adding_invoice 6248 6248 0 0.00 5 78312 806 0 0
sp_cancel_client_order 1804 1804 0 0.00 4 13769 386 0 0
sp_cancel_customer_reserve 614231 614231 0 0.00 1 26732 59 0 0
sp_cancel_pay_from_customer 701 701 0 0.00 3 8869 93 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 3 4207 96 0 0
sp_cancel_supplier_invoice 6785 6776 9 0.13 2 12151 782 0 9
sp_cancel_supplier_order 435 435 0 0.00 5 1302836 105645 0 0
sp_cancel_write_off 10605 10605 0 0.00 1 11687 115 0 0
sp_client_order 20712 20712 0 0.00 3 18667 350 0 0
sp_customer_reserve 463455 463455 0 0.00 0 102290 180 0 0
sp_fill_shopping_cart 32050 32050 0 0.00 1 13437 43 0 0
sp_fill_shopping_cart_clo_res 463445 463445 0 0.00 0 15469 14 0 0
sp_get_clo_for_invoice 5069 5069 0 0.00 0 36717 294 0 0
sp_kill_cost_storno 17971 17971 0 0.00 0 7362 58 0 0
sp_kill_qstorno_ret_qs2qd 1246278 1246278 0 0.00 0 26715 31 0 0
sp_kill_qty_storno 655209 655209 0 0.00 0 31959 68 0 0
sp_lock_selected_doc 21061 21061 0 0.00 0 8460 6 0 0
sp_make_cost_storno 28451 28451 0 0.00 0 35392 87 0 0
sp_multiply_rows_for_pdistr 28451 28451 0 0.00 0 23486 37 0 0
sp_multiply_rows_for_qdistr 20712 20712 0 0.00 0 18656 165 0 0
sp_pay_from_customer 7260 7260 0 0.00 4 35505 164 0 0
sp_pay_to_supplier 6081 6081 0 0.00 5 35510 165 0 0
sp_payment_common 13341 13341 0 0.00 1 14032 45 0 0
sp_qd_handle_on_cancel_clo 1804 1804 0 0.00 0 13761 345 0 0
sp_qd_handle_on_invoice_upd_sts 11317 11317 0 0.00 0 31955 350 0 0
sp_qd_handle_on_reserve_upd_sts 10041 10041 0 0.00 0 12545 56 0 0
sp_reserve_write_off 10041 10041 0 0.00 7 35404 222 0 0
sp_supplier_invoice 5635 5635 0 0.00 7 109546 3498 0 0
sp_supplier_order 5705 5705 0 0.00 6 32297 1318 0 0
srv_aggregate_perf_data 101 100 1 0.99 2440 300531 25081 0 1
srv_fill_mon_cache_memory 173 173 0 0.00 1163 143896 30036 0 0
srv_find_qd_qs_mism 1118734 1118734 0 0.00 0 12193 5 0 0
srv_make_invnt_saldo 561 561 0 0.00 66 93185 1278 0 0
srv_make_money_saldo 793 793 0 0.00 1 12747 44 0 0
srv_recalc_idx_stat 4 4 0 0.00 148422 372771 273640 0 0
t$perf-abend:sp_add_invoice_to_stock 101 101 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5080 5080 0 0.00 0 12446 182 0 0
t$perf-norm:sp_cancel_adding_invoice 469 469 0 0.00 0 13146 143 0 0
t$perf-norm:sp_cancel_client_order 1804 1804 0 0.00 0 4486 14 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 589 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 701 701 0 0.00 0 733 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 1154 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 1923 20 0 0
t$perf-norm:sp_cancel_supplier_order 435 435 0 0.00 0 33826 1907 0 0
t$perf-norm:sp_cancel_write_off 1000 1000 0 0.00 0 1736 7 0 0
t$perf-norm:sp_client_order 20712 20712 0 0.00 0 13222 19 0 0
t$perf-norm:sp_customer_reserve 977 977 0 0.00 0 3812 13 0 0
t$perf-norm:sp_pay_from_customer 7260 7260 0 0.00 0 3771 8 0 0
t$perf-norm:sp_pay_to_supplier 6081 6081 0 0.00 0 3828 11 0 0
t$perf-norm:sp_reserve_write_off 10041 10041 0 0.00 0 5274 13 0 0
t$perf-norm:sp_supplier_invoice 5635 5635 0 0.00 0 10988 22 0 0
t$perf-norm:sp_supplier_order 5705 5705 0 0.00 0 14446 20 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 287 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 6828 66 0 0
t$perf-norm:srv_make_invnt_saldo 561 561 0 0.00 0 5982 42 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 3132 24 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 10340 10138 202 1.95 0 6931 25 0 202
v_all_customers 38350 38350 0 0.00 0 22 1 0 0
v_all_suppliers 31500 31500 0 0.00 0 145 1 0 0
v_all_wares 41424 41424 0 0.00 0 94 1 0 0
v_cancel_adding_invoice 938 938 0 0.00 0 2789 12 0 0
v_cancel_client_order 3608 3608 0 0.00 0 2393 7 0 0
v_cancel_customer_prepayment 1402 1402 0 0.00 0 4034 8 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 9998 12 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 2609 12 0 0
v_cancel_supplier_invoice 784 766 18 2.29 0 1914 16 0 18
v_cancel_supplier_order 870 870 0 0.00 0 792 5 0 0
v_cancel_write_off 2000 2000 0 0.00 0 4077 18 0 0
v_max_id_clo_ord 5704 5704 0 0.00 0 3205 2 0 0
v_max_id_clo_res 977 977 0 0.00 0 1243 13 0 0
v_max_id_ord_sup 5634 5634 0 0.00 0 9370 7 0 0
v_max_non_paid_invoice 1669 1669 0 0.00 0 259 3 0 0
v_max_non_paid_realizn 3696 3696 0 0.00 0 2227 4 0 0
v_min_id_clo_ord 5704 5704 0 0.00 0 3720 7 0 0
v_min_id_clo_res 977 977 0 0.00 0 3232 9 0 0
v_min_id_ord_sup 5634 5634 0 0.00 0 5716 11 0 0
v_min_non_paid_invoice 6081 6081 0 0.00 0 11541 25 0 0
v_min_non_paid_realizn 7260 7260 0 0.00 0 14021 32 0 0
v_our_firm 10202 10202 0 0.00 0 33 1 0 0
v_reserve_write_off 20082 20082 0 0.00 0 6689 7 0 0
x_lock_depdocs_on_canc_invoice 12641 12641 0 0.00 0 33414 122 0 0
x_lock_depdocs_on_canc_sup_ord 435 435 0 0.00 0 8994 363 0 0
x_make_qstorno_1000_1200 5705 5705 0 0.00 1 32291 1230 0 0
x_make_qstorno_1200_2000 5635 5635 0 0.00 3 109200 3345 0 0
x_make_qstorno_2100_3300 463455 463455 0 0.00 0 102288 164 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 17-02-2021 16:28:05 to 17-02-2021 16:28:10.

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:22 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:29 16730 8192000000 10250346064 10556317696 971128400 10.598 77 57 115 1 993363616 3059600 19175616
13:57:53 19530 8192000000 10320182336 10636505088 1374533936 14.368 100 86 171 0 1406501856 4248480 27719440
13:58:28 34798 8192000000 10381235904 10701905920 1431103600 14.871 100 85 171 1 1465738240 6554400 28080240
13:59:13 13272 8192000000 10399958368 10725064704 1453686624 15.070 100 89 178 0 1489896496 7421440 28788432
13:59:39 26125 8192000000 10416035184 10746626048 1472871728 15.239 100 88 176 0 1510038160 8310464 28855968
14:00:19 20895 8192000000 10443066080 10777133056 1500200624 15.478 100 88 174 1 1537187536 9108272 27878640
14:00:56 12526 8192000000 10453051312 10791424000 1514000752 15.598 100 84 168 0 1550086144 9492064 26593328
14:01:21 15830 8192000000 10475401872 10815053824 1529845904 15.736 100 87 174 0 1567504816 9934128 27724784
14:01:49 14188 8192000000 10499598064 10843136000 1544587728 15.863 100 81 162 0 1580077728 10404112 25085888
14:02:16 18669 8192000000 10522997216 10870468608 1575673168 16.131 100 87 174 0 1613280528 11149392 26457968
14:02:45 14945 8192000000 10530443680 10886410240 1590473936 16.258 100 79 158 0 1625485568 11288528 23723104
14:03:11 8813 8192000000 10546373392 10906927104 1612567136 16.447 100 76 152 1 1647091312 11733904 22790272
14:03:29 10371 8192000000 10566092304 10923618304 1628112464 16.579 100 84 168 0 1664908640 12295184 24500992
14:03:49 9327 8192000000 10589875776 10953420800 1651057792 16.773 100 77 154 0 1685374432 11713024 22603616
14:04:07 10187 8192000000 10612350448 10981576704 1676060048 16.984 100 78 156 1 1710540224 12226784 22253392
14:04:28 6164 8192000000 10631755280 11000299520 1693904128 17.134 100 80 161 2 1729141648 12531152 22706368
14:04:42 5417 8192000000 10656721776 11024023552 1710474896 17.273 100 87 170 1 1746722256 12528528 23718832
14:04:57 6504 8192000000 10665718448 11036635136 1726145280 17.403 100 86 173 0 1762658032 12480608 24032144
14:05:10 5433 8192000000 10689345296 11057754112 1741337872 17.530 100 78 155 0 1775545232 12339648 21867712
14:05:22 4920 8192000000 10680410960 11059515392 1751401376 17.613 100 82 165 0 1787171536 11979616 23790544
14:05:34 3539 8192000000 10700751008 11075125248 1759924768 17.684 100 79 158 0 1794968736 12515424 22528544
14:05:45 4027 8192000000 10712048016 11086753792 1770323008 17.770 100 87 174 0 1807805216 13153568 24328640
14:05:56 4117 8192000000 10727907616 11104219136 1780366464 17.852 100 84 166 1 1815752208 12326272 23059472
14:06:08 2985 8192000000 10726342960 11102703616 1784060912 17.883 100 83 165 1 1821053696 14328928 22663856
14:06:18 2979 8192000000 10735947680 11111587840 1793178560 17.958 100 86 172 0 1831811328 15060512 23572256
14:06:27 2677 8192000000 10741016112 11120406528 1798824048 18.004 100 90 178 1 1838730304 14481488 25424768
14:06:36 4092 8192000000 10746886304 11125305344 1805046736 18.055 100 90 181 0 1845233872 15061744 25125392
14:06:47 2769 8192000000 10755516304 11131441152 1807749888 18.077 100 85 170 1 1845607520 13936016 23921616
14:06:57 6668 8192000000 10756142960 11135504384 1811186656 18.106 100 85 168 2 1849315744 14279088 23850000
14:07:11 4354 8192000000 10758024928 11145768960 1816400400 18.148 100 83 163 1 1852743104 13957248 22385456
14:07:21 2708 8192000000 10777674688 11162255360 1838009040 18.325 100 90 181 2 1877058640 13459920 25589680
14:07:30 1146 8192000000 10786879840 11170078720 1841228336 18.351 100 89 178 1 1879423264 13697040 24497888
14:07:38 1882 8192000000 10792917616 11179450368 1848955856 18.414 100 91 182 0 1888249040 13425056 25868128
14:07:46 1979 8192000000 10787390608 11179454464 1850447232 18.426 100 86 168 1 1887952224 13637344 23867648
14:07:54 1449 8192000000 10803500112 11187343360 1855927056 18.470 100 96 193 1 1897428912 14407504 27094352
14:08:02 1987 8192000000 10803700560 11190538240 1860969984 18.511 100 91 182 0 1899507536 12396448 26141104
14:08:11 1446 8192000000 10806515360 11193176064 1862960800 18.527 100 90 181 1 1900565584 12263296 25341488
14:08:18 2428 8192000000 10805212768 11194044416 1864262880 18.538 100 94 188 1 1905415552 14093472 27059200
14:08:27 2142 8192000000 10813263888 11202215936 1866272080 18.554 100 91 180 1 1906727632 13772704 26682848
14:08:36 2015 8192000000 10814275152 11203428352 1867843648 18.567 100 87 174 1 1907118656 14470304 24804704
14:08:44 47227 8192000000 10803889888 11200933888 1865356384 18.547 100 63 126 1 1891994448 8086032 18552032
14:09:38 1652 8192000000 10816110368 11211038720 1875254624 18.627 100 74 148 2 1907119280 10069584 21795072
14:09:45 7082 8192000000 10802581280 11208142848 1875928960 18.632 100 63 125 3 1902826080 9769856 17127264
14:09:59 3909 8192000000 10798303184 11211780096 1872347808 18.603 100 47 94 0 1895250176 9742224 13160144
14:10:11 5100 8192000000 10786750592 11206959104 1872559328 18.605 100 35 70 0 1890813312 8226240 10027744
14:10:24 5900 8192000000 10795894128 11211739136 1873033968 18.609 100 37 73 1 1890799856 7993072 9772816
14:10:37 2892 8192000000 10797451824 11216613376 1874619600 18.622 100 44 85 1 1899660160 12367280 12673280
14:10:50 3101 8192000000 10791906176 11214049280 1875420784 18.628 100 37 74 0 1894633680 9258256 9954640
14:11:00 5879 8192000000 10794383344 11215491072 1874243776 18.619 100 32 62 2 1889932176 7487504 8200896
14:11:12 5668 8192000000 10792899056 11212656640 1871547616 18.597 100 18 34 2 1882289088 5833696 4907776
14:11:25 6146 8192000000 10797780352 11217346560 1878895264 18.656 100 40 80 3 1898619280 8551024 11172992
14:11:39 10150 8192000000 10785211728 11216338944 1877497760 18.645 100 19 38 2 1888647984 5983200 5167024
14:11:56 6469 8192000000 10792134512 11220328448 1885789184 18.712 100 32 61 3 1899973904 5022560 9162160
14:12:12 12079 8192000000 10801036864 11229872128 1887739136 18.728 100 33 67 3 1904978192 7730608 9508448
14:12:34 15235 8192000000 10791576960 11226337280 1889831648 18.744 100 18 36 2 1900368944 5607520 4929776
14:12:56 7993 8192000000 10801857248 11232907264 1889792864 18.744 100 27 54 3 1905543712 8078096 7672752
14:13:10 5487 8192000000 10794412496 11229581312 1889709984 18.743 100 19 38 1 1901128832 6142160 5276688
14:13:25 58866 8192000000 10821318464 11247718400 1897000000 18.802 100 38 77 0 1914179728 5616720 11563008
14:14:42 5163 8192000000 10814066160 11246174208 1899609456 18.823 100 28 56 0 1914881728 6891152 8381120
14:14:58 4318 8192000000 10834602224 11256623104 1909996016 18.907 100 36 70 0 1927833072 7487824 10349232
14:15:09 4554 8192000000 10830072880 11258499072 1910715264 18.912 100 38 76 2 1929231744 7532768 10983712
14:15:22 6472 8192000000 10820356224 11258462208 1911641136 18.920 100 28 56 0 1926160688 6421904 8097648
14:15:36 6098 8192000000 10830833456 11264094208 1912752912 18.929 100 26 52 0 1927696976 7714800 7229264
14:15:51 8288 8192000000 10823670352 11259924480 1912528720 18.927 100 20 40 1 1923280656 5094736 5657200
14:16:07 7489 8192000000 10819187168 11260796928 1909100272 18.899 100 20 40 0 1920510752 6174256 5236224
14:16:23 6248 8192000000 10814167664 11249135616 1901103440 18.835 100 24 48 0 1913348016 5542896 6701680
14:16:39 4647 8192000000 10824228272 11256762368 1908114656 18.892 100 25 49 0 1921021168 6092640 6813872
14:16:50 8354 8192000000 10820714464 11249979392 1900000560 18.826 100 20 40 0 1915423008 9725280 5697168
14:17:07 8887 8192000000 10807502112 11242168320 1895879712 18.793 100 17 32 2 1910509760 9748832 4881216
14:17:23 7484 8192000000 10805373360 11241295872 1876866160 18.640 99 8 16 2 1884707184 5715904 2125120
14:17:43 11034 8192000000 10805816864 11224494080 1849434896 18.418 98 26 52 1 1863401600 5797504 8169200
14:18:01 59837 8192000000 10778731264 11216506880 1778100560 17.834 94 29 58 1 1791427136 5072336 8254240
14:19:10 7786 8192000000 10750670288 11170807808 1749617792 17.598 94 27 53 1 1762949952 5571600 7760560
14:19:24 9216 8192000000 10712803072 11133685760 1709653296 17.266 93 16 32 0 1719672448 5048448 4970704
14:19:40 7066 8192000000 10717732208 11127160832 1729184416 17.429 96 30 60 2 1751526864 13780368 8562080
14:19:53 7841 8192000000 10683182704 11100954624 1734341120 17.472 97 27 53 0 1747832880 5580624 7911136
14:20:09 6794 8192000000 10677575392 11095003136 1727410880 17.414 96 27 54 4 1741587472 6089776 8086816
14:20:23 5600 8192000000 10700452368 11111899136 1752117328 17.619 98 23 46 1 1764824672 6144688 6562656
14:20:35 6497 8192000000 10700534224 11112501248 1753352432 17.629 98 29 57 1 1768475920 7002384 8121104
14:20:47 6229 8192000000 10726439072 11133751296 1779808208 17.848 99 24 48 0 1792179504 4600896 7770400
14:21:01 6638 8192000000 10732526000 11148861440 1798120464 17.998 99 29 58 0 1812856304 5937648 8798192
14:21:14 5035 8192000000 10710616864 11122184192 1773010528 17.792 98 23 47 1 1784836976 5244208 6582240
14:21:28 8671 8192000000 10720703776 11136827392 1777943600 17.833 98 35 68 1 1794751216 5588208 11219408
14:21:43 11501 8192000000 10716411136 11142643712 1782038624 17.866 98 21 42 0 1793395008 5205120 6151264
14:22:01 14519 8192000000 10742703648 11162783744 1808734128 18.086 99 24 48 1 1821696400 6239232 6723040
14:22:22 27188 8192000000 10729629600 11160104960 1778361760 17.836 97 26 53 1 1792477136 5181984 8933392
14:23:31 24704 8192000000 10753736480 11176558592 1833940400 18.291 100 24 48 0 1846284592 6193840 6150352
14:24:03 9083 8192000000 10744685856 11172823040 1789417328 17.927 97 28 56 0 1804684192 7201440 8065424
14:24:22 8262 8192000000 10751686688 11182845952 1841457088 18.353 100 25 51 2 1854853376 6769840 6626448
14:24:37 4978 8192000000 10762408320 11195555840 1855635824 18.468 100 26 51 1 1868324912 5770480 6918608
14:24:50 8386 8192000000 10777424784 11200413696 1860377120 18.506 100 39 78 0 1878704048 6191424 12135504
14:25:06 6454 8192000000 10784295376 11204395008 1862524368 18.524 100 27 54 1 1875524320 5492016 7507936
14:25:19 13459 8192000000 10776917376 11206365184 1864457872 18.539 100 15 30 1 1873885824 4820752 4607200
14:25:42 6599 8192000000 10788399200 11212496896 1866834608 18.559 100 21 42 1 1878540800 5795024 5911168
14:25:59 8241 8192000000 10785774112 11213783040 1870957008 18.592 100 34 66 3 1887785536 6673072 10155456
14:26:16 11471 8192000000 10778750112 11212963840 1870898704 18.592 100 27 54 2 1884618784 5176144 8543936
14:26:35 14614 8192000000 10785444368 11213549568 1870603024 18.589 100 16 32 1 1880584272 5450176 4531072
14:26:56 8782 8192000000 10783915248 11217063936 1872575488 18.605 100 10 18 1 1880375216 4756016 3043712
14:27:12 20307 8192000000 10820593984 11239092224 1888829168 18.736 100 14 28 0 1897457840 5040960 3587712
14:27:42 59827 8192000000 10840276432 11265839104 1911133264 18.916 100 40 79 0 1928386896 5319264 11934368
14:28:53 72772 8192000000 10871774656 11292819456 1933073008 19.091 100 54 109 0 1958447936 9246192 16128736
14:30:13 18141 8192000000 10876774128 11298254848 1937589696 19.128 100 49 97 0 1963124080 11340192 14194192
14:30:48 7691 8192000000 10888023984 11311898624 1948189152 19.212 100 55 110 4 1978573648 15123904 15260592
14:31:06 11643 8192000000 10889959568 11315933184 1952890304 19.249 100 58 115 1 1985432432 16429904 16112224
14:31:37 7363 8192000000 10890894656 11320659968 1953397792 19.254 100 49 98 1 1985079168 17223520 14457856
14:31:52 8674 8192000000 10889404736 11321257984 1956408080 19.277 100 53 105 0 1988486160 17012048 15066032
14:32:11 4665 8192000000 10902576352 11327827968 1960468800 19.310 100 56 112 2 1990669824 14377072 15823952
14:32:24 9189 8192000000 10904282016 11325218816 1958427008 19.294 100 53 106 1 1989679952 15877040 15375904
14:32:42 13223 8192000000 10905878384 11329372160 1960452096 19.310 100 59 118 1 1993153376 16163216 16538064
14:33:06 7512 8192000000 10906768288 11331391488 1964464464 19.342 100 66 132 0 2000311248 16632848 19213936
14:33:28 3987 8192000000 10917313856 11340206080 1971761584 19.399 100 74 144 2 2008340720 16103248 20475888
14:33:41 8520 8192000000 10917621888 11349221376 1976529920 19.437 100 61 121 1 2011744480 17960336 17254224
14:33:58 13643 8192000000 10922188128 11351212032 1975675360 19.430 100 47 90 1 2003348672 15519312 12154000
14:34:22 5006 8192000000 10930875328 11361411072 1984868608 19.503 100 53 106 2 2018726944 18144848 15713488
14:34:34 9460 8192000000 10931890912 11363835904 1986805552 19.519 100 53 106 2 2021165840 18947888 15412400
14:34:50 7006 8192000000 10917877824 11354066944 1967071488 19.362 99 59 117 3 2007479072 22201184 18206400
14:35:09 19644 8192000000 10929240640 11366797312 1984589872 19.501 100 51 100 2 2021409984 22614800 14205312
14:35:46 14523 8192000000 10933766592 11370725376 1987556144 19.524 100 53 106 1 2024511936 21951840 15003952
14:36:09 4111 8192000000 10945587504 11375767552 1997968560 19.607 100 60 120 1 2037190080 22119344 17102176
14:36:21 1528 8192000000 10963820544 11378520064 1995621296 19.588 100 81 161 0 2042515680 22536640 24357744
14:36:30 2019 8192000000 10955603360 11372961792 1997978272 19.607 100 81 162 2 2044724576 22708560 24037744
14:36:39 4777 8192000000 10944453408 11374624768 1985177424 19.506 99 64 128 1 2026646912 22997776 18471712
14:36:52 5581 8192000000 10936451728 11364982784 1973917472 19.417 99 63 126 0 2015851248 23684432 18249344
14:37:06 1783 8192000000 10954852848 11375104000 1995106992 19.584 100 78 156 1 2041197120 23599072 22491056
14:37:14 2885 8192000000 10961200000 11386638336 2002892640 19.646 100 80 162 1 2050109216 24313408 22903168
14:37:25 3471 8192000000 10965014976 11388571648 2005597504 19.667 100 72 140 3 2050894208 24940592 20356112
14:37:35 8979 8192000000 10962181072 11393622016 2007435472 19.681 100 58 116 1 2051446992 26856784 17154736
14:37:52 9342 8192000000 10955233488 11386155008 2000626608 19.628 100 61 122 0 2045805456 27120000 18058848
14:38:10 24609 8192000000 10951338224 11383009280 1985351968 19.507 99 57 112 2 2032937344 30796736 16788640
14:38:45 3397 8192000000 10956283520 11384426496 1992179648 19.561 100 58 112 1 2042596800 33331920 17085232
14:38:56 10249 8192000000 10960265792 11400806400 1980360608 19.468 99 49 98 1 2027330720 32206752 14763360
14:39:13 9028 8192000000 10946528592 11390447616 1996660448 19.596 100 44 88 1 2043385472 32892544 13832480
14:39:39 8898 8192000000 10945986080 11376123904 1983942592 19.496 100 66 131 0 2036034912 32206448 19885872
14:40:03 6072 8192000000 10945652080 11371675648 1967183920 19.363 99 71 142 0 2023991168 34275552 22531696
14:40:19 5142 8192000000 10930271728 11358052352 1953831664 19.257 99 64 129 1 2006737056 32812592 20092800
14:40:36 15650 8192000000 10935595296 11366453248 1960891840 19.313 99 54 108 0 2011498832 33749248 16857744
14:40:59 11714 8192000000 10967946096 11398897664 1994409696 19.579 100 57 114 1 2048826384 36667456 17749232
14:41:18 3112 8192000000 10978087760 11408175104 2005560608 19.667 100 57 114 2 2060305600 37416736 17328256
14:41:29 4720 8192000000 10976088000 11402399744 1986404176 19.515 99 68 136 0 2046504176 38701120 21398880
14:41:41 2847 8192000000 10993111664 11406544896 2006026304 19.670 100 87 173 2 2073706736 40306368 27374064
14:41:52 6989 8192000000 10986547872 11415048192 2012262272 19.719 100 78 156 0 2077681584 41209088 24210224
14:42:07 4359 8192000000 10972458864 11394064384 1995957312 19.591 100 78 154 1 2061393936 41994864 23441760
14:42:18 4066 8192000000 10969448912 11392425984 1994401824 19.579 100 73 147 3 2052511120 36715120 21394176
14:42:31 2632 8192000000 10980653328 11400658944 2000425216 19.626 100 77 152 2 2061979264 38300304 23253744
14:42:41 9288 8192000000 10981287008 11402690560 1988320272 19.531 99 73 145 1 2048951280 38671072 21959936
14:42:59 3804 8192000000 10995467472 11418013696 2008356208 19.689 100 74 147 0 2072493136 42038672 22098256
14:43:11 3504 8192000000 10975595616 11395309568 1989249280 19.538 99 67 132 0 2051855968 42568336 20038352
14:43:24 8273 8192000000 10978249264 11407953920 2005734112 19.668 100 66 130 1 2067751776 41873328 20144336
14:43:49 2717 8192000000 10994994528 11419787264 2014902032 19.740 100 70 141 2 2081108832 43692800 22514000
14:44:00 6525 8192000000 11000852192 11424002048 2016492128 19.753 100 82 160 2 2084706768 44176016 24038624
14:44:16 1274 8192000000 11002749200 11424710656 2013312832 19.728 100 81 160 1 2084605936 47359216 23933888
14:44:24 5485 8192000000 10995917696 11411800064 1992862720 19.566 99 74 147 1 2061139472 45504832 22771920
14:44:39 3823 8192000000 10955178512 11376820224 1969846960 19.384 99 77 154 1 2040551072 46522512 24181600
14:44:51 2857 8192000000 10969339824 11389972480 1966138400 19.355 99 78 154 0 2037199504 47516880 23544224
14:45:02 1959 8192000000 10983205104 11392892928 1983289904 19.491 100 95 190 1 2061059248 47941040 29828304
14:45:11 1715 8192000000 10979226112 11390418944 1969801856 19.384 99 91 181 1 2046339840 48756224 27781760
14:45:20 1816 8192000000 10974508192 11392405504 1984409072 19.500 100 87 175 0 2062242928 50742080 27091776
14:45:34 6052 8192000000 10970127312 11396120576 1985347696 19.507 100 65 130 1 2056974144 50600576 21025872
14:45:48 3109 8192000000 10989698896 11407183872 1993284144 19.570 100 83 167 1 2071283232 51888272 26110816
14:45:59 4871 8192000000 10984652064 11408732160 1995881504 19.590 100 76 151 2 2069609584 49153568 24574512
14:46:11 3543 8192000000 11013431744 11425366016 2010479760 19.705 100 85 173 3 2089836912 52673824 26683328
14:46:23 2035 8192000000 10990064096 11405017088 1971729456 19.399 98 90 178 1 2054058096 53677808 28650832
14:46:34 1163 8192000000 10999554128 11417620480 1999821984 19.621 100 91 179 1 2079214656 51472432 27920240
14:46:44 1253 8192000000 10973075136 11384717312 1974982928 19.425 99 90 178 1 2053732288 50420832 28328528
14:46:53 1356 8192000000 10988047776 11401916416 1978203664 19.450 99 95 191 2 2059036336 51274528 29558144
14:47:01 6966 8192000000 10977375712 11391287296 1976496704 19.437 100 82 162 2 2054987984 52919408 25571872
14:47:16 7341 8192000000 10991064048 11409264640 1995178128 19.585 100 83 166 1 2074478048 53624528 25675392
14:47:30 1774 8192000000 11005772064 11416973312 1994352576 19.578 100 93 186 0 2081557776 57587552 29617648
14:47:39 2244 8192000000 10997963776 11417321472 1994916576 19.583 100 77 155 1 2079400560 59432688 25051296
14:47:49 1915 8192000000 10999926560 11413860352 1991289872 19.554 100 80 158 2 2076012880 59256128 25466880
14:47:57 3072 8192000000 10992049808 11402252288 1968089008 19.370 99 92 183 0 2060010304 62300144 29621152
14:48:08 3797 8192000000 10985253280 11409268736 1980371952 19.468 100 70 140 1 2066879424 63399792 23107680
14:48:19 14089 8192000000 10965728592 11404972032 1976914896 19.440 100 44 88 0 2055589408 63145792 15528720
14:48:48 21564 8192000000 10975643200 11410436096 1954677776 19.264 99 53 106 0 2039472640 66721440 18073424
14:49:20 3062 8192000000 10975804320 11396337664 1955618496 19.271 99 60 119 2 2049326544 73420464 20287584
14:49:31 1899 8192000000 10989676000 11412201472 1958710288 19.296 99 78 157 3 2060762080 75204928 26846864
14:49:40 2772 8192000000 11008601664 11425026048 1979315376 19.459 100 89 174 2 2082704448 74885568 28503504
14:49:50 4399 8192000000 10993494672 11418431488 1975491408 19.429 100 66 132 0 2074976400 77183600 22301392
14:50:04 4790 8192000000 10983355072 11422908416 1967226656 19.363 100 47 94 0 2065027968 81090656 16710656
14:50:25 14476 8192000000 10941377952 11387199488 1923126976 19.012 98 41 82 1 2008955072 70795888 15032208
14:50:48 9204 8192000000 10957377856 11388309504 1958017936 19.290 100 53 106 3 2039764736 63435456 18311344
14:51:06 4357 8192000000 10943672208 11368873984 1930578576 19.072 99 66 130 3 2017244176 66255392 20410208
14:51:19 9423 8192000000 10922760208 11365564416 1939319104 19.141 100 32 64 1 2009595216 59449008 10827104
14:51:46 12378 8192000000 10935829824 11385835520 1954828512 19.265 100 49 97 4 2028567024 57605184 16133328
14:52:16 4056 8192000000 10930273328 11378610176 1936298064 19.117 99 36 72 0 1995610256 46837312 12474880
14:52:28 30248 8192000000 10926794288 11378733056 1951777504 19.241 100 20 40 1 2003496112 45011024 6707584
14:53:08 18682 8192000000 10928578624 11370459136 1933115936 19.092 99 30 60 2 1990403024 46908480 10378608
14:53:33 19969 8192000000 10891161984 11335782400 1898597776 18.815 98 25 50 1 1948295840 41184640 8513424
14:54:00 17085 8192000000 10917166848 11367321600 1942494656 19.167 100 37 74 0 2008290256 53703424 12092176
14:54:24 21496 8192000000 10907934656 11363921920 1946186720 19.196 100 20 40 1 1992236096 39342848 6706528
14:54:59 48786 8192000000 10907532320 11362643968 1908551600 18.895 98 19 38 1 1954093968 39364144 6178224
14:56:05 44263 8192000000 10918169648 11372339200 1941026480 19.155 100 14 28 0 1996483840 49853424 5603936
14:56:58 15147 8192000000 10909731696 11372224512 1929530416 19.063 99 18 36 1 1988260400 52991664 5738320
14:57:19 20428 8192000000 10925035920 11370573824 1940643200 19.152 100 17 34 0 1995824944 48983808 6197936
14:57:46 22249 8192000000 10927692064 11387125760 1954433840 19.262 100 23 46 1 2010580880 48841904 7305136
14:58:14 16901 8192000000 10880601056 11355013120 1920108320 18.988 99 15 30 2 1967132064 42145760 4877984
14:58:38 38137 8192000000 10869020912 11336228864 1894384848 18.781 98 4 8 0 1916329440 20597280 1347312
14:59:29 128496 8192000000 10904789968 11373744128 1926799984 19.041 99 6 12 1 1947394864 19480944 1113936
15:01:43 136386 8192000000 10906598848 11370487808 1912457648 18.926 97 9 18 0 1926953344 11919616 2576080
15:04:18 42884 8192000000 10939215712 11380002816 1986268064 19.514 100 40 78 3 2007808304 11253072 10287168
15:05:09 140634 8192000000 10914070640 11370315776 1954888112 19.265 98 39 79 2 1977317392 10759872 11669408
15:07:42 51883 8192000000 10926638832 11399442432 1970385920 19.389 99 28 56 4 1991776272 13272112 8118240
15:08:41 51300 8192000000 10917549536 11386052608 1970499200 19.389 99 37 74 1 1995474384 14566368 10408816
15:10:07 29372 8192000000 10927127264 11384311808 1977261072 19.443 99 49 97 0 2000268976 8483264 14524640
15:10:55 53009 8192000000 10926008368 11401846784 1993051824 19.568 100 22 44 2 2013753968 14364672 6337472
15:11:56 32376 8192000000 10919261216 11397885952 1984358944 19.499 100 11 22 0 2006707968 19270464 3078560
15:12:43 8745 8192000000 10901746432 11364253696 1972803888 19.408 100 16 32 2 1989204800 11682960 4717952
15:12:59 19083 8192000000 10928681136 11387486208 1988185360 19.529 100 56 110 0 2015832272 11011440 16635472
15:13:25 29298 8192000000 10912769184 11384086528 1983585584 19.493 100 16 32 1 1999507328 10740800 5180944
15:14:18 36628 8192000000 10932260992 11386097664 1981246384 19.475 100 25 50 1 1997584864 9226256 7112224
15:15:00 13422 8192000000 10940388128 11389788160 1995043696 19.584 100 64 128 3 2022705040 9276400 18384944
15:15:22 39573 8192000000 10901344384 11357540352 1954856864 19.265 98 26 52 0 1974635792 12245536 7533392
15:18:03 105573 8192000000 10901816656 11375570944 1869147056 18.577 94 10 20 0 1881924352 9905408 2871888
15:19:55 38493 8192000000 10896109312 11362967552 1921525584 18.999 97 21 44 1 1943108096 15940816 5641696
15:20:40 66297 8192000000 10884955136 11360436224 1937825040 19.129 98 22 44 0 1958186256 13499328 6861888
15:22:29 70151 8192000000 10884785968 11373772800 1940349312 19.150 99 15 30 0 1966951072 21158512 5443248
15:23:59 46910 8192000000 10895585312 11377958912 1937015968 19.123 98 19 38 1 1959381568 16948224 5417376
15:24:52 49926 8192000000 10890669296 11357491200 1900582496 18.831 97 10 20 0 1920683072 16890960 3209616
15:26:02 51422 8192000000 10873301728 11355561984 1913724400 18.937 98 12 24 1 1925006560 8041888 3240272
15:27:15 33035 8192000000 10904462288 11340595200 1886234704 18.715 96 33 64 1 1904567088 9556080 8776304
15:28:00 59886 8192000000 10892771920 11368554496 1930908624 19.074 98 21 42 0 1949541040 12814224 5818192
15:29:06 68983 8192000000 10885696176 11354128384 1853015872 18.447 94 11 22 0 1868296096 12123568 3156656
15:30:22 55923 8192000000 10883882768 11359227904 1918786128 18.977 98 10 20 0 1932791328 11392880 2612320
15:31:26 38404 8192000000 10874221920 11323318272 1863684416 18.533 95 44 86 2 1881544768 6430816 11429536
15:32:11 5858 8192000000 10882490944 11318185984 1891809888 18.760 97 61 120 2 1917082288 8663312 16609088
15:32:29 21979 8192000000 10907311232 11348697088 1932183840 19.084 100 53 107 0 1964028480 16400896 15443744
15:33:02 90022 8192000000 10874304656 11338522624 1880240928 18.667 97 19 38 0 1899515424 14042768 5231728
15:34:41 96418 8192000000 10888150976 11359588352 1944766272 19.185 100 24 48 1 1969198544 17692368 6739904
15:36:24 46923 8192000000 10881810768 11347468288 1911403632 18.918 98 16 32 3 1930812288 15036896 4371760
15:37:23 33156 8192000000 10903742528 11363639296 1931050896 19.075 99 35 70 1 1958742272 17835264 9856112
15:38:08 49643 8192000000 10891270864 11354898432 1916744368 18.961 98 9 18 1 1934219408 15021824 2453216
15:39:03 88296 8192000000 10901344848 11352891392 1939561152 19.143 99 23 46 0 1956644640 10260400 6823088
15:40:47 143896 8192000000 10862344208 11329564672 1864939504 18.543 95 19 38 1 1877925760 8276992 4709264
15:43:30 19901 8192000000 10852793520 11339825152 1939804784 19.145 100 21 42 0 1960194432 14429664 5959984
15:43:59 6432 8192000000 10869551728 11348582400 1939794768 19.145 100 17 33 0 1956394576 11483456 5116352
15:44:11 10689 8192000000 10868090064 11318841344 1912228432 18.925 99 7 13 0 1921329232 7413536 1687264
15:44:30 65186 8192000000 10865093952 11345682432 1934179280 19.100 99 17 34 0 1948803792 9859376 4765136
15:46:24 42843 8192000000 10863736896 11335815168 1907941488 18.890 98 18 34 1 1922712416 9459904 5311024
15:47:14 68798 8192000000 10862732752 11340197888 1909455680 18.902 98 15 30 2 1924521664 10399136 4666848
15:48:29 44610 8192000000 10834031952 11319373824 1879295456 18.659 97 10 20 0 1897361936 14858928 3207552
15:49:21 79346 8192000000 10866914992 11332624384 1913103504 18.932 99 31 62 0 1933787744 11075568 9608672
15:50:48 52931 8192000000 10859123136 11345743872 1938036080 19.131 100 15 30 1 1958194016 15791200 4366736
15:51:51 76950 8192000000 10875873520 11365928960 1921624288 19.000 99 8 16 0 1938627168 14577776 2425104
15:53:23 31309 8192000000 10845476240 11313741824 1870501728 18.588 97 20 40 1 1884454464 8124752 5827984
15:54:06 55788 8192000000 10860538992 11338096640 1918427168 18.974 99 36 71 2 1941588288 12194416 10966704
15:55:08 58339 8192000000 10876054096 11356336128 1948200640 19.212 100 21 42 1 1966581168 12497856 5882672
15:56:17 62403 8192000000 10888577632 11357818880 1906983440 18.882 97 23 46 4 1932334880 18411440 6940000
15:57:29 100757 8192000000 10892222032 11386732544 1938654096 19.136 99 17 34 0 1969436576 26432896 4349584
15:59:36 71516 8192000000 10916148144 11384631296 1960383216 19.309 99 29 57 1 1978960720 11318832 7258672
16:00:55 26922 8192000000 10909381872 11376103424 1960316608 19.309 99 27 54 0 1982767584 15161056 7289920
16:01:32 43960 8192000000 10920989040 11396182016 1961414720 19.317 99 30 60 2 1989952032 20492864 8044448
16:02:24 72817 8192000000 10906660672 11372716032 1875925616 18.632 95 20 40 2 1895993168 14949728 5117824
16:03:43 36169 8192000000 10894523808 11387994112 1967205056 19.363 100 11 22 1 1989437728 19041872 3190800
16:05:36 106188 8192000000 10899565472 11374968832 1944239232 19.181 98 39 77 1 1967737056 11945536 11552288
16:07:37 81180 8192000000 10887769440 11366633472 1914478016 18.943 97 24 49 0 1934150496 12960848 6711632
16:09:06 1760 8192000000 10892306512 11367456768 1959561760 19.303 100 34 68 0 1984017312 14927152 9528400
16:09:19 45732 8192000000 10878456656 11360432128 1918956400 18.978 98 13 26 3 1937852864 15541312 3355152
16:10:24 78615 8192000000 10865186304 11348754432 1913214080 18.932 98 12 24 1 1930845488 13897296 3734112
16:11:55 65880 8192000000 10854092784 11335184384 1881581040 18.678 96 13 26 1 1902096272 16485008 4030224
16:13:13 68557 8192000000 10877086400 11360280576 1936147680 19.116 99 16 31 0 1954918576 14269088 4501808
16:14:35 57318 8192000000 10872260736 11349737472 1930487696 19.071 99 15 30 0 1951470960 16615712 4367552
16:15:40 79413 8192000000 10864234080 11355930624 1908922928 18.898 98 19 39 0 1928256352 13631056 5702368
16:17:07 25474 8192000000 10868873712 11354447872 1939612368 19.144 100 12 24 2 1954832720 11714432 3505920
16:17:38 26125 8192000000 10862899376 11352023040 1927767840 19.049 99 9 18 1 1942274624 12037840 2468944
16:18:22 34807 8192000000 10867988640 11343900672 1926969232 19.043 99 10 18 1 1941295168 11718784 2607152
16:19:12 70738 8192000000 10889997744 11362914304 1942310176 19.165 99 14 28 2 1954085760 8066208 3709376
16:20:36 41378 8192000000 10886895904 11369963520 1927386736 19.046 98 19 38 1 1943454576 11179808 4888032
16:21:39 79912 8192000000 10883739600 11361456128 1928547280 19.055 98 16 32 1 1949173056 15595168 5030608
16:23:14 28873 8192000000 10884104896 11348250624 1919355088 18.982 98 26 52 0 1936015888 9352432 7308368
16:23:53 87145 8192000000 10877170736 11352358912 1854145088 18.456 95 25 50 2 1870834144 9640928 7048128
16:25:42 100963 8192000000 9386475424 9698410496 202417248 2.411 11 1 2 0 205882128 3388976 75904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 17-02-2021 16:28:11 to 17-02-2021 16:28:44.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-02-2021 16:28:45 to 17-02-2021 16:28:47.

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          245247
MON$OLDEST_ACTIVE               245248
MON$OLDEST_SNAPSHOT             245248
MON$NEXT_TRANSACTION            245248
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                       2072800
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33416 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33416 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33416 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

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