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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
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 2021-03-04 16:07
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.26
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 17461768 kB
MemAvailable 31481776 kB
Buffers 0 kB
Cached 14183784 kB
SwapCached 0 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-03-24 19:27:26
DTS_END                         2021-03-24 19:27:26.5120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34488
TRN_ID                          234690
ATT_ID                          709
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: 8980.56 20668 1077667
customer order: creation 167.62 349 20114
customer order: refuse 14.52 326 1742
order to supplier: creation 45.14 1275 5417
order to supplier: removal 3.17 110234 380
invoice (draft): creation 46.27 3854 5552
invoice (draft): removal 50.18 741 6022
invoice accept: apply 41.31 18705 4957
invoice accept: cancel 45.23 816 5427
customer reserve: creation 3845.13 183 461415
customer reserve: removal 4434.35 62 532122
realization accept: apply 80.52 183 9662
realization accept: cancel 79.18 126 9501
payment from customer: creation 58.42 117 7010
payment from customer: removal 5.53 100 664
payment to supplier: creation 48.22 158 5786
payment to supplier: removal 3.64 136 437
service: total inventory turnovers 4.70 1226 564
service: total monetary turnovers 6.59 26 791
service: aggregate perf. data 0.83 17668 100
service: refresh index statistics 0.03 257070 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 24-03-2021 19:28:44 to 24-03-2021 19:28:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4067
TEST_TIME 2 2522
TEST_TIME 3 3273
TEST_TIME 4 4058
TEST_TIME 5 4553
TEST_TIME 6 4796
TEST_TIME 7 4825
TEST_TIME 8 5104
TEST_TIME 9 5141
TEST_TIME 10 5364
TEST_TIME 11 5735
TEST_TIME 12 6097
TEST_TIME 13 6351
TEST_TIME 14 6569
TEST_TIME 15 6448
TEST_TIME 16 6894
TEST_TIME 17 7155
TEST_TIME 18 7256
TEST_TIME 19 7537
TEST_TIME 20 8113
TEST_TIME 21 8208
TEST_TIME 22 8227
TEST_TIME 23 8406
TEST_TIME 24 8478
TEST_TIME 25 8565
TEST_TIME 26 9091
TEST_TIME 27 9358
TEST_TIME 28 9603
TEST_TIME 29 10548
TEST_TIME 30 10639
TEST_TIME 31 10424
TEST_TIME 32 10209
TEST_TIME 33 10142
TEST_TIME 34 10120
TEST_TIME 35 10000
TEST_TIME 36 9951
TEST_TIME 37 9878
TEST_TIME 38 9713
TEST_TIME 39 9583
TEST_TIME 40 9620
TEST_TIME 41 9682
TEST_TIME 42 9626
TEST_TIME 43 9464
TEST_TIME 44 9544
TEST_TIME 45 9448
TEST_TIME 46 9326
TEST_TIME 47 9321
TEST_TIME 48 9256
TEST_TIME 49 9246
TEST_TIME 50 9095
TEST_TIME 51 9001
TEST_TIME 52 8994
TEST_TIME 53 8960
TEST_TIME 54 8940
TEST_TIME 55 9071
TEST_TIME 56 9045
TEST_TIME 57 9069
TEST_TIME 58 9170
TEST_TIME 59 9106
TEST_TIME 60 9067
TEST_TIME 61 9240
TEST_TIME 62 9213
TEST_TIME 63 9326
TEST_TIME 64 9308
TEST_TIME 65 9390
TEST_TIME 66 9371
TEST_TIME 67 9272
TEST_TIME 68 9200
TEST_TIME 69 9133
TEST_TIME 70 9161
TEST_TIME 71 9062
TEST_TIME 72 9089
TEST_TIME 73 9025
TEST_TIME 74 8994
TEST_TIME 75 8996
TEST_TIME 76 8961
TEST_TIME 77 9002
TEST_TIME 78 8962
TEST_TIME 79 8961
TEST_TIME 80 9001
TEST_TIME 81 9046
TEST_TIME 82 9008
TEST_TIME 83 8985
TEST_TIME 84 9053
TEST_TIME 85 9111
TEST_TIME 86 9134
TEST_TIME 87 9234
TEST_TIME 88 9231
TEST_TIME 89 9155
TEST_TIME 90 9090
TEST_TIME 91 9054
TEST_TIME 92 9016
TEST_TIME 93 8979
TEST_TIME 94 9005
TEST_TIME 95 9114
TEST_TIME 96 9115
TEST_TIME 97 9075
TEST_TIME 98 9130
TEST_TIME 99 9152
TEST_TIME 100 9139
TEST_TIME 101 9140
TEST_TIME 102 9135
TEST_TIME 103 9235
TEST_TIME 104 9257
TEST_TIME 105 9267
TEST_TIME 106 9264
TEST_TIME 107 9265
TEST_TIME 108 9274
TEST_TIME 109 9210
TEST_TIME 110 9144
TEST_TIME 111 9134
TEST_TIME 112 9077
TEST_TIME 113 9053
TEST_TIME 114 9096
TEST_TIME 115 9060
TEST_TIME 116 9032
TEST_TIME 117 9067
TEST_TIME 118 9057
TEST_TIME 119 9044
TEST_TIME 120 8981

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 24-03-2021 19:28:47 to 24-03-2021 19:28:51.

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 1501913 1501913 0 0.00 0 29198 6 0 0
doc_list_biud 1501911 1501911 0 0.00 0 68546 28 0 0
sp_add_invoice_to_stock 5040 4957 83 1.64 38 197681 18706 0 83
sp_cancel_adding_invoice 5427 5427 0 0.00 4 113621 817 0 0
sp_cancel_client_order 1742 1742 0 0.00 4 10179 327 0 0
sp_cancel_customer_reserve 532122 532122 0 0.00 1 68548 63 0 0
sp_cancel_pay_from_customer 664 664 0 0.00 3 5618 101 0 0
sp_cancel_pay_to_supplier 437 437 0 0.00 3 13204 136 0 0
sp_cancel_supplier_invoice 6032 6022 10 0.16 1 12861 742 0 10
sp_cancel_supplier_order 380 380 0 0.00 7 1116118 110234 0 0
sp_cancel_write_off 9501 9501 0 0.00 1 28568 126 0 0
sp_client_order 20114 20114 0 0.00 4 81265 349 0 0
sp_customer_reserve 461415 461415 0 0.00 0 43615 183 0 0
sp_fill_shopping_cart 31076 31076 0 0.00 1 20463 47 0 0
sp_fill_shopping_cart_clo_res 461415 461415 0 0.00 0 24552 14 0 0
sp_get_clo_for_invoice 4957 4957 0 0.00 0 37801 353 0 0
sp_kill_cost_storno 16029 16029 0 0.00 0 14806 59 0 0
sp_kill_qstorno_ret_qs2qd 1080147 1080147 0 0.00 0 68536 34 0 0
sp_kill_qty_storno 569811 569811 0 0.00 0 68546 72 0 0
sp_lock_selected_doc 20168 20168 0 0.00 0 8004 6 0 0
sp_make_cost_storno 27415 27415 0 0.00 0 29167 52 0 0
sp_multiply_rows_for_pdistr 27414 27414 0 0.00 0 28435 35 0 0
sp_multiply_rows_for_qdistr 20114 20114 0 0.00 0 75838 154 0 0
sp_pay_from_customer 7010 7010 0 0.00 4 27826 117 0 0
sp_pay_to_supplier 5786 5786 0 0.00 5 29217 159 0 0
sp_payment_common 12796 12796 0 0.00 1 27821 39 0 0
sp_qd_handle_on_cancel_clo 1742 1742 0 0.00 0 10172 304 0 0
sp_qd_handle_on_invoice_upd_sts 10383 10383 0 0.00 0 17337 325 0 0
sp_qd_handle_on_reserve_upd_sts 9661 9661 0 0.00 0 13066 58 0 0
sp_reserve_write_off 9662 9662 0 0.00 6 15419 184 0 0
sp_supplier_invoice 5552 5552 0 0.00 6 99703 3854 0 0
sp_supplier_order 5417 5417 0 0.00 5 49544 1276 0 0
srv_aggregate_perf_data 101 100 1 0.99 2570 124862 17668 0 1
srv_fill_mon_cache_memory 166 166 0 0.00 1483 113473 32229 0 0
srv_find_qd_qs_mism 1028916 1028916 0 0.00 0 12854 6 0 0
srv_make_invnt_saldo 564 564 0 0.00 31 50869 1226 0 0
srv_make_money_saldo 791 791 0 0.00 0 2666 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 90768 387891 257071 0 0
t$perf-abend:sp_add_invoice_to_stock 83 83 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 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 4957 4957 0 0.00 0 16106 191 0 0
t$perf-norm:sp_cancel_adding_invoice 404 404 0 0.00 0 2498 74 0 0
t$perf-norm:sp_cancel_client_order 1742 1742 0 0.00 0 1737 8 0 0
t$perf-norm:sp_cancel_customer_reserve 617 617 0 0.00 0 554 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 664 664 0 0.00 0 158 2 0 0
t$perf-norm:sp_cancel_pay_to_supplier 437 437 0 0.00 0 5206 19 0 0
t$perf-norm:sp_cancel_supplier_invoice 363 363 0 0.00 0 1998 20 0 0
t$perf-norm:sp_cancel_supplier_order 380 380 0 0.00 0 19937 1433 0 0
t$perf-norm:sp_cancel_write_off 945 945 0 0.00 0 2930 10 0 0
t$perf-norm:sp_client_order 20114 20114 0 0.00 0 12705 20 0 0
t$perf-norm:sp_customer_reserve 1010 1010 0 0.00 0 1752 5 0 0
t$perf-norm:sp_pay_from_customer 7010 7010 0 0.00 0 10036 11 0 0
t$perf-norm:sp_pay_to_supplier 5786 5786 0 0.00 0 9499 10 0 0
t$perf-norm:sp_reserve_write_off 9662 9662 0 0.00 0 21892 12 0 0
t$perf-norm:sp_supplier_invoice 5552 5552 0 0.00 0 5362 17 0 0
t$perf-norm:sp_supplier_order 5417 5417 0 0.00 0 3471 17 0 0
t$perf-norm:srv_aggregate_perf_data 100 100 0 0.00 0 87 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 166 166 0 0.00 0 2761 31 0 0
t$perf-norm:srv_make_invnt_saldo 564 564 0 0.00 0 1348 29 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 1171 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 10076 9910 166 1.64 0 5600 18 0 166
v_all_customers 36690 36690 0 0.00 0 83 1 0 0
v_all_suppliers 29800 29800 0 0.00 0 84 1 0 0
v_all_wares 40228 40228 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 808 808 0 0.00 0 1519 9 0 0
v_cancel_client_order 3484 3484 0 0.00 0 3795 5 0 0
v_cancel_customer_prepayment 1328 1328 0 0.00 0 3773 13 0 0
v_cancel_customer_reserve 1234 1234 0 0.00 0 3239 8 0 0
v_cancel_payment_to_supplier 874 874 0 0.00 0 5193 21 0 0
v_cancel_supplier_invoice 746 726 20 2.68 0 4220 22 0 20
v_cancel_supplier_order 760 760 0 0.00 0 3234 12 0 0
v_cancel_write_off 1890 1890 0 0.00 0 2986 18 0 0
v_max_id_clo_ord 5416 5416 0 0.00 0 682 1 0 0
v_max_id_clo_res 1010 1010 0 0.00 0 6251 16 0 0
v_max_id_ord_sup 5545 5545 0 0.00 0 4894 6 0 0
v_max_non_paid_invoice 1847 1847 0 0.00 0 1049 3 0 0
v_max_non_paid_realizn 3771 3771 0 0.00 0 1747 4 0 0
v_min_id_clo_ord 5416 5416 0 0.00 0 3958 11 0 0
v_min_id_clo_res 1010 1010 0 0.00 0 4127 8 0 0
v_min_id_ord_sup 5545 5545 0 0.00 0 7816 8 0 0
v_min_non_paid_invoice 5786 5786 0 0.00 0 13149 28 0 0
v_min_non_paid_realizn 7010 7010 0 0.00 0 27812 27 0 0
v_our_firm 10016 10016 0 0.00 0 19 1 0 0
v_reserve_write_off 19322 19322 0 0.00 0 4303 6 0 0
x_lock_depdocs_on_canc_invoice 11086 11086 0 0.00 0 23875 139 0 0
x_lock_depdocs_on_canc_sup_ord 380 380 0 0.00 0 6491 397 0 0
x_make_qstorno_1000_1200 5417 5417 0 0.00 2 49527 1183 0 0
x_make_qstorno_1200_2000 5552 5552 0 0.00 2 99688 3685 0 0
x_make_qstorno_2100_3300 461415 461415 0 0.00 0 39330 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 24-03-2021 19:28:52 to 24-03-2021 19:28:56.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:30 8 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:36 16319 8192000000 10225343792 10527105024 845744528 9.357 68 52 107 0 865860288 2262064 17853696
16:58:04 17626 8192000000 10300253728 10615308288 1349569968 14.144 100 82 165 1 1381939008 4555920 27813120
16:58:31 30288 8192000000 10365915616 10683260928 1409781280 14.682 100 88 176 0 1444640144 5744848 29114016
16:59:17 27254 8192000000 10398774208 10724491264 1444723280 14.991 100 86 172 0 1479766480 6871856 28171344
16:59:51 19136 8192000000 10417588368 10745708544 1471971920 15.231 100 86 172 1 1507208592 7428288 27808384
17:00:21 19223 8192000000 10435712480 10767687680 1485641696 15.351 100 88 176 0 1522236304 8208288 28386320
17:00:52 14998 8192000000 10451836528 10785882112 1507413744 15.541 100 90 180 0 1544991168 8690144 28887280
17:01:17 11088 8192000000 10469753952 10809049088 1521819664 15.666 100 90 180 0 1558471088 8651072 28000352
17:01:37 19153 8192000000 10491632576 10835144704 1545708896 15.873 100 80 160 0 1580081072 9220800 25151376
17:02:11 13189 8192000000 10509614496 10859393024 1568777616 16.072 100 80 159 0 1602887200 9979792 24129792
17:02:39 16739 8192000000 10555975200 10911862784 1605854976 16.389 100 74 148 0 1638257728 10381632 22021120
17:03:06 10657 8192000000 10564247728 10926944256 1627982864 16.578 100 78 157 1 1662164880 11029600 23152416
17:03:24 9902 8192000000 10578190256 10944311296 1640098768 16.681 100 78 156 0 1675118688 11827488 23192432
17:03:43 12121 8192000000 10603871200 10969501696 1661083968 16.858 100 78 156 1 1695617984 11798416 22735600
17:04:05 7735 8192000000 10633068240 10997174272 1684777424 17.057 100 77 154 1 1719155136 12309280 22068432
17:04:21 6997 8192000000 10632291184 11006550016 1697643376 17.165 100 74 148 0 1731946800 12676208 21627216
17:04:34 8453 8192000000 10649423728 11021225984 1708561376 17.257 100 81 162 0 1744594080 12537776 23494928
17:04:50 5618 8192000000 10671015504 11042996224 1726674288 17.408 100 81 160 1 1762822240 13519040 22628912
17:05:02 5332 8192000000 10682217680 11056922624 1740090320 17.519 100 82 164 0 1776479536 13200816 23188400
17:05:14 5016 8192000000 10683446928 11064045568 1750962768 17.610 100 79 158 0 1786144720 13190896 21991056
17:05:26 3917 8192000000 10695280992 11076464640 1758298288 17.670 100 84 168 0 1795591072 13551120 23741664
17:05:36 3768 8192000000 10701793440 11082027008 1766530352 17.738 100 80 159 2 1802214976 13919456 21765168
17:05:48 4780 8192000000 10710031104 11090649088 1775994880 17.816 100 80 158 4 1811197408 13085984 22116544
17:06:01 5381 8192000000 10709224912 11092029440 1778491440 17.837 100 71 143 0 1814517440 15580624 20445376
17:06:14 10200 8192000000 10721160976 11111718912 1794121600 17.966 100 83 166 1 1829059840 11126528 23811712
17:06:33 5761 8192000000 10738501376 11130339328 1801431904 18.026 100 76 150 0 1834327904 12332656 20563344
17:06:47 2664 8192000000 10756112304 11141419008 1819846288 18.176 100 83 166 1 1861169472 17923120 23400064
17:06:56 3115 8192000000 10773800384 11163537408 1830364176 18.262 100 81 162 0 1866883328 12933056 23586096
17:07:06 1698 8192000000 10769127104 11156979712 1834053744 18.292 100 79 158 1 1868795728 11749488 22992496
17:07:15 2526 8192000000 10779672176 11165663232 1837821344 18.323 100 82 164 1 1873582320 13629952 22131024
17:07:24 1547 8192000000 10790072128 11173797888 1842391248 18.360 100 94 189 1 1883370160 14773216 26205696
17:07:33 1699 8192000000 10795783472 11178975232 1842809504 18.364 100 95 191 0 1884777488 15842656 26125328
17:07:42 2462 8192000000 10787006576 11173580800 1850712512 18.428 100 94 188 1 1890744816 13829568 26202736
17:07:50 2231 8192000000 10792380784 11180257280 1846758208 18.396 100 89 179 0 1885102784 13133184 25211392
17:07:59 2492 8192000000 10794326320 11178790912 1848063680 18.406 100 90 178 0 1886650304 13020864 25565760
17:08:07 4256 8192000000 10797369792 11182653440 1853048688 18.447 100 92 182 1 1891880464 13217520 25614256
17:08:18 1696 8192000000 10800032080 11187994624 1860680976 18.509 100 92 186 1 1900283328 13234864 26367488
17:08:26 2481 8192000000 10802524944 11192156160 1858139920 18.488 100 86 171 1 1896152768 13262016 24750832
17:08:35 2174 8192000000 10803568368 11193614336 1858666608 18.492 100 88 174 3 1896688096 12895056 25126432
17:08:43 1089 8192000000 10810154640 11199283200 1867400320 18.563 100 92 187 1 1906814736 12496432 26917984
17:08:50 2363 8192000000 10816177824 11204591616 1867129216 18.561 100 92 184 1 1905916944 12566944 26220784
17:09:00 32861 8192000000 10796008656 11203276800 1866875456 18.559 100 56 110 0 1892503264 10728576 14899232
17:09:39 5530 8192000000 10794279264 11205558272 1867437712 18.564 100 43 86 2 1888325520 9100080 11787728
17:09:51 1722 8192000000 10806724112 11214426112 1876911536 18.640 100 59 118 0 1907470288 14240736 16318016
17:09:59 6091 8192000000 10780441200 11209097216 1872918144 18.608 100 24 48 0 1886497808 6826464 6753200
17:10:13 9512 8192000000 10791302096 11212161024 1876223648 18.635 100 25 50 0 1889815776 5670288 7921840
17:10:33 6000 8192000000 10795508400 11221094400 1878742240 18.655 100 31 61 2 1898522160 11447248 8332672
17:10:45 13657 8192000000 10788977504 11216781312 1876575632 18.637 100 18 36 1 1887754096 6075616 5102848
17:11:05 9577 8192000000 10777268736 11211923456 1877415824 18.644 100 18 36 1 1888911248 6220416 5275008
17:11:22 4745 8192000000 10793540144 11217420288 1880210432 18.667 100 27 54 1 1893525456 5886000 7429024
17:11:33 11827 8192000000 10784254464 11218255872 1879571520 18.662 100 10 19 0 1887668416 5651520 2445376
17:11:53 10874 8192000000 10795424528 11228221440 1883818512 18.696 100 16 31 2 1894095488 5755296 4521680
17:12:12 14703 8192000000 10791874608 11227246592 1888953760 18.737 100 18 34 2 1900119712 5681488 5484464
17:12:34 21082 8192000000 10798287872 11229782016 1889742480 18.744 100 23 45 3 1903172400 6094656 7335264
17:13:52 32885 8192000000 10797793904 11238522880 1891827920 18.761 100 26 52 1 1904750960 5916128 7006912
17:14:36 5506 8192000000 10806850704 11240226816 1894879648 18.785 100 24 48 1 1909320128 6783360 7657120
17:14:47 6590 8192000000 10816644736 11248099328 1900127680 18.827 100 28 56 2 1914076224 5845952 8102592
17:15:04 4870 8192000000 10808577728 11241828352 1896001728 18.794 100 29 57 3 1910042816 5973952 8067136
17:15:15 4379 8192000000 10814858304 11247550464 1897685248 18.808 100 26 51 4 1910970800 5777840 7507712
17:15:28 10945 8192000000 10804075600 11243671552 1894628288 18.783 100 20 41 0 1906569952 6318160 5623504
17:15:45 9068 8192000000 10816508992 11252813824 1899599040 18.823 100 21 42 1 1911276880 5922640 5755200
17:16:00 7570 8192000000 10817613504 11253583872 1904252032 18.860 100 19 38 1 1915488048 5985216 5250800
17:16:19 9514 8192000000 10803540944 11233665024 1865126256 18.545 98 25 49 2 1878009488 5107056 7776176
17:16:38 9528 8192000000 10804640864 11229306880 1869064032 18.577 99 21 43 3 1880618320 5822976 5731312
17:16:54 12056 8192000000 10807609008 11235790848 1882503616 18.685 100 12 24 0 1891093808 5348608 3241584
17:17:15 6788 8192000000 10813380304 11244507136 1892525488 18.766 100 17 33 1 1906414560 9878592 4010480
17:17:29 11048 8192000000 10811802464 11244163072 1873724448 18.614 99 14 28 0 1887524336 9835856 3964032
17:17:47 24790 8192000000 10779565440 11219382272 1816871168 18.152 96 12 24 0 1825177200 5095152 3210880
17:18:23 42316 8192000000 10781486976 11217645568 1859479472 18.499 99 31 62 2 1874544752 5271744 9793536
17:19:14 10748 8192000000 10731574352 11153833984 1692833328 17.125 91 28 56 0 1707094816 5965696 8295792
17:19:31 8721 8192000000 10759446272 11174338560 1792930448 17.956 98 32 64 0 1813582288 11552352 9099488
17:19:46 5029 8192000000 10751425008 11170263040 1805171712 18.056 98 36 71 1 1823418896 8001920 10245264
17:20:01 6646 8192000000 10741440304 11163508736 1801265504 18.024 98 34 67 1 1817059280 6577776 9216000
17:20:14 3490 8192000000 10717445760 11136835584 1794702864 17.970 99 27 54 0 1808885936 6406032 7777040
17:20:23 10362 8192000000 10703111152 11120136192 1677509264 16.996 92 16 32 0 1686999568 4410048 5080256
17:20:41 8677 8192000000 10727907360 11149365248 1781145216 17.859 98 26 52 3 1793889968 5166176 7578576
17:20:57 7064 8192000000 10703336304 11124224000 1742989152 17.543 97 22 41 4 1757973536 9390688 5593696
17:21:10 6778 8192000000 10709789520 11129012224 1753784832 17.633 97 28 56 1 1771480480 9384240 8311408
17:21:23 8512 8192000000 10708493136 11130515456 1740305632 17.521 96 25 51 3 1753085232 5502576 7277024
17:21:41 7540 8192000000 10726917840 11149754368 1782888288 17.873 98 26 52 3 1795986000 5768224 7329488
17:21:59 10852 8192000000 10737204928 11151937536 1784086096 17.883 98 16 32 0 1793779744 4883792 4809856
17:22:17 8001 8192000000 10734319264 11148382208 1811058288 18.105 100 34 65 3 1826205664 5142720 10004656
17:22:31 11896 8192000000 10736610224 11158896640 1767235408 17.744 97 25 52 1 1779977696 5566656 7175632
17:22:53 78902 8192000000 10736241072 11167727616 1812622832 18.117 99 33 66 0 1829305456 4962320 11720304
17:24:18 8832 8192000000 10754185936 11179188224 1834742960 18.298 100 25 50 1 1848361488 6612512 7006016
17:24:40 6586 8192000000 10767705824 11188961280 1851415904 18.434 100 40 80 0 1869980048 6950768 11613376
17:24:53 11322 8192000000 10770377232 11194859520 1855719872 18.469 100 26 52 1 1869574352 7032384 6822096
17:25:11 9169 8192000000 10775197472 11196514304 1836569040 18.313 99 23 45 1 1849364848 5745216 7050592
17:25:30 8262 8192000000 10770443872 11199537152 1853919744 18.454 100 19 38 0 1865838688 5470496 6448448
17:25:46 6837 8192000000 10781585888 11204964352 1860451472 18.507 100 23 46 1 1873101424 6221328 6428624
17:25:59 13130 8192000000 10768597888 11198951424 1840116048 18.342 99 18 36 0 1854528752 9446240 4966464
17:26:18 9755 8192000000 10771600192 11203813376 1857236224 18.481 100 15 29 0 1866351088 5189024 3925840
17:26:34 13580 8192000000 10769621264 11205488640 1861955696 18.519 100 14 29 0 1871197360 5499600 3742064
17:26:54 15527 8192000000 10787583632 11218628608 1869338384 18.579 100 17 34 1 1879010224 5376880 4294960
17:27:16 8474 8192000000 10797577504 11225354240 1882503056 18.685 100 26 50 1 1895732480 5838624 7390800
17:27:46 9224 8192000000 10827601824 11243868160 1894946816 18.786 100 45 87 0 1912984112 5538192 12499104
17:28:23 53276 8192000000 10822703264 11255414784 1901407280 18.838 100 30 59 1 1915632256 5991360 8233616
17:29:23 62096 8192000000 10851500224 11282608128 1916907232 18.962 100 50 98 0 1945305152 14270048 14127872
17:30:35 59335 8192000000 10859997872 11294294016 1927057104 19.043 100 37 74 1 1949109552 11914816 10137632
17:31:42 10945 8192000000 10869428144 11298615296 1935966464 19.115 100 51 102 1 1962790480 12092288 14731728
17:32:04 5605 8192000000 10881680096 11307249664 1940566304 19.151 100 55 109 2 1968346576 12431344 15348928
17:32:17 9214 8192000000 10890643168 11313287168 1946981584 19.202 100 61 122 1 1977759760 12879472 17898704
17:32:49 14890 8192000000 10891316272 11318804480 1951771552 19.241 100 57 114 2 1982236592 14395088 16069952
17:33:12 2407 8192000000 10903107680 11327725568 1954566464 19.263 100 66 133 0 1987867296 13582000 19718832
17:33:23 10139 8192000000 10905927872 11330326528 1956863056 19.281 100 66 131 0 1990279856 14588576 18828224
17:33:57 5897 8192000000 10904273600 11335925760 1964340752 19.341 100 52 103 1 1994088896 14573232 15174912
17:34:13 6923 8192000000 10909020704 11335643136 1967280368 19.364 100 58 114 1 1999178768 14887968 17010432
17:34:27 16480 8192000000 10912447456 11343151104 1972779952 19.407 100 56 112 0 2004519488 14680432 17059104
17:34:52 13218 8192000000 10926633232 11352817664 1978015408 19.449 100 68 134 0 2014882800 17328240 19539152
17:35:19 7041 8192000000 10914582960 11353477120 1977018128 19.441 100 55 110 0 2009518944 15978304 16522512
17:35:44 8436 8192000000 10917638528 11356057600 1980055664 19.465 100 52 101 2 2010087808 15622480 14409664
17:36:00 8306 8192000000 10936145456 11363110912 1983427680 19.492 100 63 126 0 2018265248 16333696 18503872
17:36:20 14407 8192000000 10917431968 11353067520 1974927600 19.425 100 50 102 0 2008004768 17914304 15162864
17:36:44 9356 8192000000 10901865168 11337654272 1962148736 19.323 99 49 98 1 1993399104 16474528 14775840
17:37:03 14615 8192000000 10914851440 11354259456 1976848592 19.440 100 45 87 1 2007376672 16590176 13937904
17:37:25 9103 8192000000 10929613568 11362123776 1984842736 19.503 100 56 112 1 2020178768 18512528 16823504
17:37:41 2535 8192000000 10941328176 11366051840 1993042256 19.568 100 71 143 1 2033266720 18424640 21799824
17:37:52 13747 8192000000 10949478144 11374215168 1997876960 19.606 100 75 150 1 2038952480 19558608 21516912
17:38:14 4234 8192000000 10959852928 11381678080 1998231776 19.609 100 67 134 0 2041406144 23345424 19828944
17:38:26 2137 8192000000 10960262144 11384901632 2001308096 19.633 100 73 146 1 2047494336 24285280 21900960
17:38:37 2777 8192000000 10945603728 11375169536 1981033984 19.473 99 60 117 2 2019224000 20945360 17244656
17:38:46 1578 8192000000 10967354000 11383959552 2003836880 19.653 100 91 182 1 2052579952 22043520 26699552
17:38:56 4498 8192000000 10960918048 11380916224 1997239504 19.601 100 68 135 0 2040332208 23199952 19892752
17:39:07 7011 8192000000 10960408320 11382026240 1998327728 19.610 100 70 136 0 2040371840 21568128 20475984
17:39:23 3039 8192000000 10954664704 11381137408 1999587888 19.619 100 76 151 2 2044808224 22445520 22774816
17:39:32 7846 8192000000 10961308320 11388755968 2005137472 19.663 100 68 136 2 2048583904 23158064 20288368
17:39:48 9651 8192000000 10941793376 11366383616 1959981008 19.306 98 72 142 2 2004517856 23182912 21353936
17:40:04 2694 8192000000 10943708576 11369848832 1987203888 19.522 100 73 142 2 2033938592 26935696 19799008
17:40:15 7684 8192000000 10941680592 11360088064 1978122592 19.450 100 74 145 0 2023097568 23806880 21168096
17:40:29 3251 8192000000 10925218288 11335430144 1956519600 19.278 99 80 160 1 2004969056 24357248 24092208
17:40:39 4090 8192000000 10935926208 11356921856 1960589568 19.311 99 63 125 1 2003252560 24261712 18401280
17:40:52 2035 8192000000 10957233680 11376791552 1990800784 19.550 100 72 143 1 2036387648 24393216 21193648
17:41:01 2335 8192000000 10922596464 11338596352 1956620048 19.279 98 75 150 1 2002831536 22790128 23421360
17:41:11 3857 8192000000 10953975792 11369848832 1986415968 19.515 100 75 146 1 2031854576 23550560 21888048
17:41:24 1523 8192000000 10943234992 11362287616 1977571776 19.445 100 79 155 1 2024416864 23790272 23054816
17:41:32 2417 8192000000 10942354464 11363860480 1979628464 19.462 100 70 138 0 2026204080 25378320 21197296
17:41:42 2115 8192000000 10949859744 11365191680 1981859424 19.479 100 84 169 0 2033702736 25540000 26303312
17:41:51 3862 8192000000 10935237792 11344605184 1949228208 19.220 98 87 174 0 2002631200 26271296 27131696
17:42:02 2785 8192000000 10954814080 11364737024 1979673824 19.462 100 81 161 0 2030993232 26807616 24511792
17:42:14 3533 8192000000 10941510112 11357564928 1959082976 19.299 99 80 158 2 2012417744 28264000 25070768
17:42:24 12287 8192000000 10938735024 11359465472 1958933984 19.298 99 53 104 0 2003145920 27749648 16462288
17:42:49 7342 8192000000 10954700608 11376934912 1969592032 19.382 99 65 130 2 2023349728 32645360 21112336
17:43:04 5208 8192000000 10957808240 11382075392 1985205920 19.506 100 77 154 0 2045641168 35188816 25246432
17:43:22 11521 8192000000 10950344512 11382820864 1981783920 19.479 100 65 128 2 2039630976 36899760 20947296
17:43:46 2579 8192000000 10947266832 11365302272 1966188432 19.355 99 70 139 1 2023873104 35763424 21921248
17:43:59 5151 8192000000 10953699552 11385188352 1984707856 19.502 100 57 114 1 2035185232 32699296 17778080
17:44:11 2317 8192000000 10950076080 11375947776 1983519776 19.493 100 66 132 1 2037946192 33709824 20716592
17:44:20 4105 8192000000 10957751712 11371520000 1964842576 19.345 99 79 158 0 2021429296 31834848 24751872
17:44:38 1483 8192000000 10932435408 11341914112 1943974656 19.178 98 86 170 0 2004619552 33468960 27175936
17:44:47 3946 8192000000 10948974912 11364646912 1967752112 19.368 100 82 164 3 2030455040 37308848 25394080
17:45:00 7202 8192000000 10908616704 11321352192 1926975232 19.043 98 68 136 0 1985524768 37408816 21140720
17:45:18 4332 8192000000 10940131424 11356983296 1959561696 19.303 100 74 148 0 2024496800 41594544 23340560
17:45:31 3718 8192000000 10946165456 11360477184 1934950608 19.106 99 72 144 0 1998011888 40588976 22472304
17:45:43 1933 8192000000 10942684256 11351134208 1944097712 19.179 99 84 167 1 2011859472 41981408 25780352
17:45:52 2461 8192000000 10960133520 11374694400 1976992672 19.441 100 81 163 2 2047887136 44283296 26611168
17:46:02 2029 8192000000 10975656256 11389403136 1979847312 19.463 100 82 164 1 2055609168 50052512 25709344
17:46:11 2756 8192000000 10974412000 11380813824 1973217488 19.411 100 88 174 2 2048161312 46989904 27953920
17:46:20 4375 8192000000 10957749104 11376074752 1972347040 19.404 100 73 145 3 2044523760 48847888 23328832
17:46:32 8084 8192000000 10953407792 11381919744 1969790368 19.384 100 60 120 0 2037976768 48642592 19543808
17:46:48 2296 8192000000 10971608736 11392303104 1979584336 19.461 100 70 141 1 2052295696 49598048 23113312
17:47:01 2366 8192000000 10970655024 11382259712 1973782928 19.415 100 85 170 1 2049246016 48629984 26833104
17:47:10 7056 8192000000 10960200352 11380940800 1968995744 19.377 100 71 144 1 2039902224 48706080 22200400
17:47:28 5501 8192000000 10964250976 11379765248 1976817696 19.439 100 64 127 1 2040509776 44568512 19123568
17:47:41 4400 8192000000 10958972144 11385257984 1979420592 19.460 100 58 114 3 2041962720 44580944 17961184
17:47:53 5207 8192000000 10974429344 11392380928 1990447568 19.547 100 72 142 3 2058604608 45016320 23140720
17:48:12 3720 8192000000 10983163600 11396567040 1990648208 19.549 100 81 159 1 2057397344 41848960 24900176
17:48:26 1848 8192000000 10998000496 11409707008 1998108336 19.608 100 77 155 1 2067913408 45541792 24263280
17:48:35 6894 8192000000 10973683536 11411570688 1996249824 19.593 100 52 104 1 2059553872 46847424 16456624
17:48:54 11267 8192000000 10975465840 11414654976 1997072464 19.600 100 41 79 0 2057122432 46676256 13373712
17:49:23 8629 8192000000 10943761424 11381305344 1974459040 19.421 100 38 76 1 2028831152 41730496 12641616
17:49:44 14140 8192000000 10958974048 11393736704 1983986448 19.496 100 43 86 2 2040668512 42902544 13779520
17:50:07 3768 8192000000 10956615632 11376848896 1965232320 19.348 100 60 122 1 2028923520 44570064 19121136
17:50:19 6596 8192000000 10952672864 11381403648 1971107808 19.394 100 57 115 1 2035612960 46314896 18190256
17:50:32 13940 8192000000 10966414752 11393454080 1976989696 19.441 100 55 107 0 2043857600 48994336 17873568
17:51:10 12614 8192000000 10943903136 11395870720 1969659072 19.383 100 30 60 2 2029746304 49988752 10098480
17:51:34 23568 8192000000 10930333824 11386408960 1952321632 19.245 99 30 60 2 2012603824 49817680 10464512
17:52:27 16180 8192000000 10919340672 11362070528 1920125936 18.988 99 27 53 4 1985997632 55941568 9930128
17:53:01 9209 8192000000 10924209152 11364597760 1937953472 19.130 100 34 66 0 2003347008 54192864 11200672
17:53:19 30738 8192000000 10916625792 11375947776 1944234864 19.181 100 43 86 3 2018018224 59666272 14117088
17:54:02 35745 8192000000 10908866080 11359600640 1925171040 19.028 99 22 44 2 1989331792 56792864 7367888
17:54:44 23860 8192000000 10898941600 11350568960 1922787184 19.009 100 16 31 1 1982321488 53500976 6033328
17:55:15 18867 8192000000 10900052992 11350818816 1905258048 18.869 99 14 28 1 1961874560 51419152 5197360
17:56:17 65138 8192000000 10854481664 11306004480 1851006752 18.430 96 14 29 0 1866782208 12217280 3558176
17:57:42 35961 8192000000 10880336336 11321827328 1915672544 18.952 99 25 48 0 1930888768 8621712 6594512
17:58:27 91787 8192000000 10855707840 11312398336 1902800000 18.849 98 38 75 2 1926353920 12156160 11397760
18:00:08 65842 8192000000 10866966880 11319877632 1916779936 18.961 99 13 26 0 1931195648 10937376 3478336
18:01:21 45453 8192000000 10873157840 11322740736 1924330272 19.022 99 29 58 1 1942699296 9876048 8492976
18:02:16 56157 8192000000 10859969280 11312836608 1909195072 18.900 98 30 60 2 1925547616 7726592 8625952
18:03:18 93673 8192000000 10879734160 11336306688 1913517104 18.935 98 18 36 1 1932913888 14180608 5216176
18:05:01 68566 8192000000 10885533920 11336830976 1915627888 18.952 98 12 23 2 1935180624 15827712 3725024
18:06:17 93776 8192000000 10898260272 11362975744 1955797264 19.273 100 14 27 1 1977373760 17832464 3744032
18:07:57 36332 8192000000 10889585696 11364900864 1959607040 19.303 100 9 18 0 1981363872 18878272 2878560
18:08:40 13789 8192000000 10887790128 11355590656 1961976304 19.322 100 16 32 1 1983259584 16334160 4949120
18:09:01 65876 8192000000 10890170928 11351429120 1925654208 19.032 98 17 34 0 1945125664 14599760 4871696
18:10:16 98884 8192000000 10871502112 11356442624 1947385456 19.206 99 27 53 3 1972411712 16791024 8235232
18:12:03 60774 8192000000 10907947984 11358617600 1965927520 19.353 100 13 26 0 1977408320 7767456 3713344
18:13:19 2067 8192000000 10927579760 11370594304 1985985136 19.512 100 64 126 2 2012269152 8428944 17855072
18:13:28 16107 8192000000 10930894192 11368751104 1983086880 19.489 100 57 112 1 2008346224 9933552 15325792
18:13:51 5231 8192000000 10933846816 11370852352 1987795248 19.526 100 68 138 1 2016886944 10353392 18738304
18:14:06 32088 8192000000 10908610624 11367333888 1982849600 19.487 100 55 110 1 2008505920 10164224 15492096
18:14:48 49558 8192000000 10891900160 11362897920 1956443424 19.278 99 7 14 0 1966152736 8031632 1677680
18:15:44 51155 8192000000 10884489664 11371958272 1977751216 19.447 100 11 22 0 1991838528 10985648 3101664
18:16:43 82009 8192000000 10895123232 11371507712 1983450496 19.492 100 13 26 0 1995906112 8843296 3612320
18:18:11 95479 8192000000 10900904688 11386527744 1991189152 19.553 100 19 39 0 2004362816 7796224 5377440
18:20:23 62123 8192000000 10913794208 11391201280 1945711824 19.192 97 24 48 2 1967265024 14609648 6943552
18:21:32 71124 8192000000 10879965200 11362295808 1922613712 19.008 97 15 31 1 1939087600 12011968 4461920
18:22:54 30187 8192000000 10891600816 11346108416 1915228016 18.949 97 18 36 3 1929404768 8969424 5207328
18:23:32 16543 8192000000 10882019088 11344764928 1940980416 19.155 99 27 54 3 1956923536 8385312 7557808
18:23:55 19960 8192000000 10885845056 11343667200 1920428848 18.990 98 40 80 1 1941922208 9985248 11508112
18:24:22 40896 8192000000 10877899568 11342438400 1920915184 18.994 98 32 64 2 1944786432 14466880 9404368
18:25:10 54806 8192000000 10876516560 11339255808 1934388496 19.102 99 17 34 0 1954186784 14897696 4900592
18:26:11 28524 8192000000 10912715840 11367075840 1975625520 19.430 100 47 92 2 1998885168 10242432 13017216
18:26:48 17950 8192000000 10908113520 11364446208 1955966784 19.274 99 43 85 0 1981357632 13192560 12198288
18:27:14 56229 8192000000 10898097456 11375546368 1973555184 19.414 100 25 51 0 1995279472 15001600 6722688
18:28:21 111572 8192000000 10903439488 11365937152 1862944720 18.527 94 13 26 1 1879208368 13133504 3130144
18:30:22 113472 8192000000 10849354416 11318034432 1715609680 17.316 87 8 16 0 1728456352 10522400 2324272
18:32:22 89907 8192000000 10851283616 11307954176 1825008048 18.219 94 13 26 0 1842465200 13998672 3458480
18:34:10 94909 8192000000 10839498256 11285569536 1829921968 18.259 95 33 65 1 1849649424 10299296 9428160
18:35:53 100712 8192000000 10835027936 11308421120 1900642688 18.831 100 10 20 0 1916727136 13216240 2868208
18:37:40 41503 8192000000 10833146720 11316682752 1913166272 18.932 100 12 24 0 1930749584 14326576 3256736
18:38:46 58782 8192000000 10837604736 11311173632 1893380576 18.773 99 19 37 1 1915132160 16432880 5318704
18:40:06 48983 8192000000 10829642912 11294908416 1890058480 18.746 99 7 14 0 1902736496 10408544 2269472
18:41:01 40976 8192000000 10844414032 11317911552 1928472720 19.055 100 18 36 0 1942263904 8631808 5159376
18:41:49 79196 8192000000 10870981216 11342577664 1938775360 19.137 100 10 20 1 1950077808 8716576 2585872
18:43:15 71145 8192000000 10890002816 11359936512 1959536416 19.302 100 25 50 0 1974610832 8102176 6972240
18:44:34 35177 8192000000 10879275600 11343568896 1907285184 18.885 97 19 35 2 1919370192 6949968 5135040
18:45:15 51982 8192000000 10889940768 11358150656 1946022256 19.195 99 31 63 1 1968818960 13822352 8974352
18:46:22 86944 8192000000 10861769120 11330732032 1838955104 18.332 94 13 26 0 1857242288 14924704 3362480
18:48:09 63400 8192000000 10852213904 11308318720 1809865616 18.095 94 21 40 4 1827593008 12398080 5329312
18:49:23 37695 8192000000 10892428160 11348197376 1942634560 19.168 100 29 58 0 1966759456 16031936 8092960
18:50:22 51123 8192000000 10901071072 11362947072 1951811392 19.241 100 24 48 0 1976746176 18316752 6618032
18:51:39 77274 8192000000 10889171056 11361849344 1951782224 19.241 100 15 30 1 1973532608 17366064 4384320
18:54:27 51089 8192000000 10866934736 11322388480 1853540800 18.451 95 13 26 0 1869271088 12647024 3083264
18:55:40 109210 8192000000 10861738944 11327148032 1923121088 19.012 99 42 84 0 1945991760 10672672 12198000
18:57:49 84680 8192000000 10884192544 11357339648 1939814560 19.145 99 24 48 0 1956956624 10261632 6880432
18:59:32 85292 8192000000 10889005664 11374596096 1961814464 19.320 100 11 22 1 1980157264 15262640 3080160
19:01:07 86819 8192000000 10901255040 11397378048 1972205856 19.403 100 18 36 1 2000115360 22849296 5060208
19:02:44 91502 8192000000 10906004320 11370692608 1938843248 19.138 98 14 28 0 1957886688 15086992 3956448
19:04:34 84699 8192000000 10899358928 11382403072 1942781968 19.169 98 13 26 1 1959291424 12290976 4218480
19:06:05 36323 8192000000 10911121312 11379269632 1963236048 19.332 99 26 53 0 1979755872 8963936 7555888
19:06:53 61284 8192000000 10927884400 11381813248 1942027600 19.163 98 21 42 0 1957570224 10074288 5468336
19:08:02 60601 8192000000 10911487936 11383218176 1958287776 19.292 99 19 38 0 1973967824 10462464 5217584
19:09:09 39436 8192000000 10924260016 11386863616 1966739952 19.360 99 25 51 0 1984486960 10661104 7085904
19:09:56 60266 8192000000 10912604208 11403300864 1967224400 19.363 99 11 22 1 1983433952 12571792 3637760
19:11:10 67505 8192000000 10895776624 11365302272 1857843024 18.486 94 9 16 1 1872688320 12839104 2006192
19:12:36 66229 8192000000 10910868560 11368869888 1945032496 19.187 99 21 42 1 1963369504 12262272 6074736
19:13:49 65691 8192000000 10915446240 11376336896 1917766992 18.969 97 27 54 0 1936434016 10853008 7814016
19:15:10 83341 8192000000 10899366496 11373813760 1955881728 19.273 99 21 42 2 1972616512 11333968 5400816
19:16:47 71137 8192000000 10932070496 11372400640 1964732144 19.344 99 52 96 1 1985009152 6940160 13336848
19:18:05 51852 8192000000 10887888752 11373199360 1952357728 19.245 99 27 54 1 1971918080 12131888 7428464
19:19:12 52494 8192000000 10895770880 11378708480 1954360384 19.261 99 11 22 0 1973343632 15813840 3169408
19:20:12 37148 8192000000 10888084656 11373805568 1963240160 19.332 100 9 18 0 1985552480 19509424 2802896
19:20:55 12396 8192000000 10887737120 11372695552 1966117424 19.355 100 9 18 0 1984499280 15202752 3179104
19:21:16 4505 8192000000 10885716880 11375644672 1962365088 19.325 100 8 17 0 1979664208 14931328 2367792
19:21:26 3013 8192000000 10876496192 11378266112 1959225840 19.300 100 1 2 0 1969734304 10446336 62128
19:21:37 30005 8192000000 10889679744 11375071232 1947853952 19.209 99 22 44 0 1964046208 9623616 6568640
19:22:14 70733 8192000000 10888134592 11352379392 1911306592 18.917 97 17 34 1 1924053120 7622480 5124048
19:23:40 72033 8192000000 10876477008 11366907904 1943723456 19.176 99 12 24 0 1958183008 10665328 3794224
19:25:00 75406 8192000000 10869135408 11352010752 1891161280 18.755 96 12 24 0 1902455200 8145792 3148128
19:26:28 25921 8192000000 10892952368 11341565952 1913198688 18.932 98 31 60 3 1930449616 8325216 8925712
19:27:03 16837 8192000000 10925393568 11369734144 1967208256 19.363 100 64 129 1 2000156656 14662848 18285552

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 24-03-2021 19:28:58 to 24-03-2021 19:29:29.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 83 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 24-03-2021 19:29:30 to 24-03-2021 19:29:32.

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          233531
MON$OLDEST_ACTIVE               235556
MON$OLDEST_SNAPSHOT             235556
MON$NEXT_TRANSACTION            235556
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                       2020160
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.33428 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33428 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33428 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33428 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 ---
:223: 
:224: mscs-test-161.budzdorov.ru    Wed Mar 24 19:27:33 2021
:225:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:226: 
:227: 
:228: mscs-test-161.budzdorov.ru    Wed Mar 24 19:27:35 2021
:229:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:230: 
:231: 
:232: mscs-test-161.budzdorov.ru    Wed Mar 24 19:27:35 2021
:233:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:234: 
:235: 
:236: mscs-test-161.budzdorov.ru    Wed Mar 24 19:27:38 2021
:237:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:238: 
:239: 
:240: mscs-test-161.budzdorov.ru    Wed Mar 24 19:27:39 2021
:241:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:242: 
--- end of diff output ---

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

24.03.21 19:29:33. 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-03-24 19:29:35 No severe PSQL-related problems occured
24.03.21 19:29:37. End of report.