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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17118092 kB
MemAvailable 31416272 kB
Buffers 0 kB
Cached 14552912 kB
SwapCached 3484 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-11-14 16:27:04
DTS_END                         2020-11-14 16:27:04.8310
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/49348
TRN_ID                          247298
ATT_ID                          694
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: 9783.88 17556 1174066
customer order: creation 183.65 341 22038
customer order: refuse 15.36 364 1843
order to supplier: creation 48.78 1249 5853
order to supplier: removal 3.54 93943 425
invoice (draft): creation 47.90 3372 5748
invoice (draft): removal 55.73 774 6688
invoice accept: apply 43.44 16939 5213
invoice accept: cancel 49.45 753 5934
customer reserve: creation 4130.89 163 495707
customer reserve: removal 4892.38 52 587085
realization accept: apply 88.98 193 10677
realization accept: cancel 87.56 100 10507
payment from customer: creation 62.73 140 7527
payment from customer: removal 6.16 87 739
payment to supplier: creation 51.47 147 6176
payment to supplier: removal 3.53 117 423
service: total inventory turnovers 4.61 1229 553
service: total monetary turnovers 6.82 33 818
service: aggregate perf. data 0.90 17595 108
service: refresh index statistics 0.03 213521 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 14-11-2020 16:28:11 to 14-11-2020 16:28:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6291
TEST_TIME 2 6246
TEST_TIME 3 5910
TEST_TIME 4 5837
TEST_TIME 5 5845
TEST_TIME 6 5637
TEST_TIME 7 5678
TEST_TIME 8 5490
TEST_TIME 9 5402
TEST_TIME 10 5807
TEST_TIME 11 6395
TEST_TIME 12 6680
TEST_TIME 13 6793
TEST_TIME 14 7352
TEST_TIME 15 7505
TEST_TIME 16 7840
TEST_TIME 17 8278
TEST_TIME 18 8652
TEST_TIME 19 8649
TEST_TIME 20 8907
TEST_TIME 21 9083
TEST_TIME 22 9507
TEST_TIME 23 9461
TEST_TIME 24 9514
TEST_TIME 25 10034
TEST_TIME 26 10684
TEST_TIME 27 10838
TEST_TIME 28 10979
TEST_TIME 29 10862
TEST_TIME 30 10712
TEST_TIME 31 10621
TEST_TIME 32 10658
TEST_TIME 33 10722
TEST_TIME 34 10655
TEST_TIME 35 10619
TEST_TIME 36 10700
TEST_TIME 37 10653
TEST_TIME 38 10629
TEST_TIME 39 10766
TEST_TIME 40 10631
TEST_TIME 41 10454
TEST_TIME 42 10431
TEST_TIME 43 10347
TEST_TIME 44 10258
TEST_TIME 45 10251
TEST_TIME 46 10167
TEST_TIME 47 10158
TEST_TIME 48 10151
TEST_TIME 49 10155
TEST_TIME 50 10155
TEST_TIME 51 10115
TEST_TIME 52 10359
TEST_TIME 53 10252
TEST_TIME 54 10224
TEST_TIME 55 10138
TEST_TIME 56 10158
TEST_TIME 57 10089
TEST_TIME 58 10217
TEST_TIME 59 10200
TEST_TIME 60 10223
TEST_TIME 61 10182
TEST_TIME 62 10272
TEST_TIME 63 10307
TEST_TIME 64 10228
TEST_TIME 65 10341
TEST_TIME 66 10306
TEST_TIME 67 10245
TEST_TIME 68 10318
TEST_TIME 69 10359
TEST_TIME 70 10395
TEST_TIME 71 10338
TEST_TIME 72 10224
TEST_TIME 73 10152
TEST_TIME 74 10080
TEST_TIME 75 10100
TEST_TIME 76 10114
TEST_TIME 77 10098
TEST_TIME 78 10067
TEST_TIME 79 10024
TEST_TIME 80 9956
TEST_TIME 81 9998
TEST_TIME 82 9964
TEST_TIME 83 9894
TEST_TIME 84 9876
TEST_TIME 85 9859
TEST_TIME 86 9842
TEST_TIME 87 9820
TEST_TIME 88 9857
TEST_TIME 89 9824
TEST_TIME 90 9863
TEST_TIME 91 9840
TEST_TIME 92 9874
TEST_TIME 93 9937
TEST_TIME 94 9920
TEST_TIME 95 9986
TEST_TIME 96 9960
TEST_TIME 97 10025
TEST_TIME 98 9999
TEST_TIME 99 10056
TEST_TIME 100 10092
TEST_TIME 101 10139
TEST_TIME 102 10051
TEST_TIME 103 10001
TEST_TIME 104 9989
TEST_TIME 105 9935
TEST_TIME 106 9943
TEST_TIME 107 9922
TEST_TIME 108 9882
TEST_TIME 109 9855
TEST_TIME 110 9793
TEST_TIME 111 9775
TEST_TIME 112 9744
TEST_TIME 113 9811
TEST_TIME 114 9811
TEST_TIME 115 9847
TEST_TIME 116 9868
TEST_TIME 117 9855
TEST_TIME 118 9852
TEST_TIME 119 9847
TEST_TIME 120 9789

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-11-2020 16:28:14 to 14-11-2020 16:28:17.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1632321 1632321 0 0.00 0 27940 6 0 0
doc_list_biud 1632320 1632320 0 0.00 0 28990 25 0 0
sp_add_invoice_to_stock 5305 5213 92 1.73 29 180188 16939 0 92
sp_cancel_adding_invoice 5934 5934 0 0.00 5 59405 753 0 0
sp_cancel_client_order 1843 1843 0 0.00 4 9702 365 0 0
sp_cancel_customer_reserve 587085 587085 0 0.00 1 28992 53 0 0
sp_cancel_pay_from_customer 739 739 0 0.00 2 6335 87 0 0
sp_cancel_pay_to_supplier 423 423 0 0.00 2 15537 118 0 0
sp_cancel_supplier_invoice 6695 6688 7 0.10 1 16150 775 0 7
sp_cancel_supplier_order 425 425 0 0.00 6 975961 93944 0 0
sp_cancel_write_off 10507 10507 0 0.00 1 17075 100 0 0
sp_client_order 22038 22038 0 0.00 3 49603 342 0 0
sp_customer_reserve 495707 495707 0 0.00 0 143999 163 0 0
sp_fill_shopping_cart 33634 33634 0 0.00 1 14805 38 0 0
sp_fill_shopping_cart_clo_res 495702 495702 0 0.00 0 16042 12 0 0
sp_get_clo_for_invoice 5205 5205 0 0.00 0 25735 253 0 0
sp_kill_cost_storno 17603 17603 0 0.00 0 8914 56 0 0
sp_kill_qstorno_ret_qs2qd 1191790 1191790 0 0.00 0 21665 29 0 0
sp_kill_qty_storno 628364 628364 0 0.00 0 28990 63 0 0
sp_lock_selected_doc 21964 21964 0 0.00 0 11373 7 0 0
sp_make_cost_storno 29585 29585 0 0.00 0 27935 60 0 0
sp_multiply_rows_for_pdistr 29585 29585 0 0.00 0 11050 33 0 0
sp_multiply_rows_for_qdistr 22038 22038 0 0.00 0 48679 156 0 0
sp_pay_from_customer 7527 7527 0 0.00 4 19388 140 0 0
sp_pay_to_supplier 6176 6176 0 0.00 4 25011 147 0 0
sp_payment_common 13703 13703 0 0.00 1 24985 39 0 0
sp_qd_handle_on_cancel_clo 1843 1843 0 0.00 0 8694 326 0 0
sp_qd_handle_on_invoice_upd_sts 11139 11139 0 0.00 0 22019 319 0 0
sp_qd_handle_on_reserve_upd_sts 10677 10677 0 0.00 0 21407 63 0 0
sp_reserve_write_off 10677 10677 0 0.00 6 27952 194 0 0
sp_supplier_invoice 5748 5748 0 0.00 6 80267 3373 0 0
sp_supplier_order 5853 5853 0 0.00 5 66537 1249 0 0
srv_aggregate_perf_data 109 108 1 0.91 2707 145970 17596 0 1
srv_fill_mon_cache_memory 162 162 0 0.00 890 171293 31291 0 0
srv_find_qd_qs_mism 1122913 1122913 0 0.00 0 18124 5 0 0
srv_make_invnt_saldo 553 553 0 0.00 35 88653 1229 0 0
srv_make_money_saldo 818 818 0 0.00 1 9106 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 146491 361357 213521 0 0
t$perf-abend:sp_add_invoice_to_stock 92 92 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 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 5213 5213 0 0.00 0 13525 168 0 0
t$perf-norm:sp_cancel_adding_invoice 415 415 0 0.00 0 4630 84 0 0
t$perf-norm:sp_cancel_client_order 1843 1843 0 0.00 0 5672 16 0 0
t$perf-norm:sp_cancel_customer_reserve 742 742 0 0.00 0 2382 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 739 739 0 0.00 0 4875 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 423 423 0 0.00 0 738 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 445 445 0 0.00 0 570 10 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 18365 1394 0 0
t$perf-norm:sp_cancel_write_off 1050 1050 0 0.00 0 564 3 0 0
t$perf-norm:sp_client_order 22038 22038 0 0.00 0 6651 17 0 0
t$perf-norm:sp_customer_reserve 1065 1065 0 0.00 0 3107 8 0 0
t$perf-norm:sp_pay_from_customer 7527 7527 0 0.00 0 6475 8 0 0
t$perf-norm:sp_pay_to_supplier 6176 6176 0 0.00 0 4830 8 0 0
t$perf-norm:sp_reserve_write_off 10677 10677 0 0.00 0 6714 12 0 0
t$perf-norm:sp_supplier_invoice 5748 5748 0 0.00 0 4546 16 0 0
t$perf-norm:sp_supplier_order 5853 5853 0 0.00 0 5109 19 0 0
t$perf-norm:srv_aggregate_perf_data 108 108 0 0.00 0 210 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 162 162 0 0.00 0 937 16 0 0
t$perf-norm:srv_make_invnt_saldo 553 553 0 0.00 0 739 16 0 0
t$perf-norm:srv_make_money_saldo 818 818 0 0.00 0 1668 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 2 0 0
v_add_invoice_to_stock 10594 10410 184 1.73 0 6882 16 0 184
v_all_customers 39908 39908 0 0.00 0 37 1 0 0
v_all_suppliers 32404 32404 0 0.00 0 37 1 0 0
v_all_wares 44076 44076 0 0.00 0 102 1 0 0
v_cancel_adding_invoice 830 830 0 0.00 0 7192 18 0 0
v_cancel_client_order 3686 3686 0 0.00 0 5876 8 0 0
v_cancel_customer_prepayment 1478 1478 0 0.00 0 3229 10 0 0
v_cancel_customer_reserve 1484 1484 0 0.00 0 3613 7 0 0
v_cancel_payment_to_supplier 846 846 0 0.00 0 845 6 0 0
v_cancel_supplier_invoice 904 890 14 1.54 0 1782 19 0 14
v_cancel_supplier_order 850 850 0 0.00 0 1236 10 0 0
v_cancel_write_off 2100 2100 0 0.00 0 1680 14 0 0
v_max_id_clo_ord 5853 5853 0 0.00 0 558 1 0 0
v_max_id_clo_res 1065 1065 0 0.00 0 3457 20 0 0
v_max_id_ord_sup 5743 5743 0 0.00 0 2677 4 0 0
v_max_non_paid_invoice 1570 1570 0 0.00 0 922 3 0 0
v_max_non_paid_realizn 4151 4151 0 0.00 0 3453 4 0 0
v_min_id_clo_ord 5853 5853 0 0.00 0 5452 6 0 0
v_min_id_clo_res 1065 1065 0 0.00 0 8555 13 0 0
v_min_id_ord_sup 5743 5743 0 0.00 0 4915 7 0 0
v_min_non_paid_invoice 6176 6176 0 0.00 0 9613 23 0 0
v_min_non_paid_realizn 7527 7527 0 0.00 0 19342 28 0 0
v_our_firm 10920 10920 0 0.00 0 144 1 0 0
v_reserve_write_off 21354 21354 0 0.00 0 4432 7 0 0
x_lock_depdocs_on_canc_invoice 12177 12177 0 0.00 0 16179 102 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 4197 288 0 0
x_make_qstorno_1000_1200 5853 5853 0 0.00 2 66511 1167 0 0
x_make_qstorno_1200_2000 5748 5748 0 0.00 3 79801 3235 0 0
x_make_qstorno_2100_3300 495707 495707 0 0.00 0 143996 149 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2020 16:28:19 to 14-11-2020 16:28:23.

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:08 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:14 9939 8192000000 10182661568 10487934976 831814400 9.217 67 49 103 1 850668688 2381536 16472752
13:57:34 18576 8192000000 10289691920 10601701376 1348611984 14.135 100 82 164 0 1380133904 4249616 27272304
13:58:04 24551 8192000000 10329875296 10649583616 1387778864 14.486 100 86 172 0 1421480608 5628128 28073616
13:58:48 16403 8192000000 10383399440 10705563648 1430192832 14.863 100 84 168 0 1464239840 6440128 27606880
13:59:15 23027 8192000000 10402160896 10732220416 1455238448 15.084 100 89 178 0 1491482208 7690224 28553536
13:59:47 27714 8192000000 10442596208 10777731072 1495814720 15.440 100 85 170 1 1530979408 8217344 26947344
14:00:25 25983 8192000000 10471379120 10809327616 1523136400 15.677 100 87 174 0 1559533712 9154896 27242416
14:01:02 26750 8192000000 10499923712 10845974528 1547829232 15.891 100 84 168 0 1584322032 10015360 26477440
14:01:39 9905 8192000000 10520315936 10867023872 1569814176 16.081 100 78 156 0 1603978816 10043760 24120880
14:02:06 9378 8192000000 10535617024 10891972608 1599557376 16.336 100 79 158 0 1633608352 10565296 23485680
14:02:24 12826 8192000000 10565904464 10921304064 1616049488 16.476 100 81 162 1 1651640192 10913312 24677392
14:02:46 6937 8192000000 10568944304 10933633024 1633823920 16.627 100 75 150 0 1667561200 11203376 22533904
14:02:59 13015 8192000000 10603126272 10964127744 1655141856 16.808 100 83 165 0 1691684256 12016832 24525568
14:03:23 9632 8192000000 10631112944 10997403648 1681941360 17.034 100 81 162 1 1718047376 12255776 23850240
14:03:42 10870 8192000000 10646145232 11015548928 1706031792 17.236 100 80 160 1 1741420064 12058208 23330064
14:04:00 6434 8192000000 10658581296 11031482368 1718347472 17.338 100 71 142 0 1750560640 11975872 20237296
14:04:14 7719 8192000000 10669781744 11045343232 1732255232 17.454 100 83 166 2 1769240944 13321744 23663968
14:04:30 6480 8192000000 10683761488 11058741248 1744582224 17.557 100 85 170 3 1782625120 14083920 23958976
14:04:46 5687 8192000000 10695567392 11068088320 1750528736 17.606 100 82 165 4 1786896576 13421344 22946496
14:04:59 3395 8192000000 10702680432 11075313664 1758121136 17.669 100 88 174 2 1797050960 14515120 24414704
14:05:10 4139 8192000000 10706529280 11083329536 1766097024 17.735 100 87 174 1 1804974160 14464704 24412432
14:05:21 2943 8192000000 10707315728 11081351168 1769569184 17.763 100 88 174 0 1809128224 15342896 24216144
14:05:32 3398 8192000000 10715650304 11096776704 1774278512 17.802 100 82 165 2 1812188896 13994368 23916016
14:05:42 3346 8192000000 10716062944 11101589504 1784438064 17.886 100 83 164 0 1820667136 13434816 22794256
14:05:52 9109 8192000000 10726294096 11112165376 1787665024 17.913 100 73 146 0 1821149184 13037968 20446192
14:06:08 5342 8192000000 10750002128 11129384960 1801137104 18.023 100 81 163 2 1836200032 12773520 22289408
14:06:20 2513 8192000000 10762698048 11142946816 1818121984 18.162 100 88 174 2 1856243792 12441008 25680800
14:06:29 2872 8192000000 10765558752 11149586432 1822962096 18.202 100 79 159 0 1856728304 11099520 22666688
14:06:38 1898 8192000000 10769509872 11155615744 1827591664 18.240 100 84 168 0 1862644320 11281648 23771008
14:06:46 1987 8192000000 10781881680 11165310976 1839668960 18.338 100 97 192 2 1879624272 12873664 27081648
14:06:54 2780 8192000000 10784215264 11171618816 1844288800 18.376 100 90 180 2 1882243392 11662144 26292448
14:07:03 1363 8192000000 10792968784 11175161856 1848062912 18.406 100 97 193 0 1888831520 13558992 27209616
14:07:11 1439 8192000000 10797503616 11183255552 1851557904 18.435 100 95 191 1 1892731760 14156048 27017808
14:07:19 2360 8192000000 10788873856 11178545152 1852218912 18.440 100 84 168 0 1889249824 13406352 23624560
14:07:28 1445 8192000000 10800861440 11187601408 1857811888 18.486 100 93 185 3 1897101888 13539968 25750032
14:07:36 1386 8192000000 10806302848 11193970688 1862860480 18.526 100 90 180 1 1901023664 12511168 25652016
14:07:44 3252 8192000000 10808575344 11199451136 1865953664 18.552 100 80 161 2 1901045024 12379408 22711952
14:07:53 4372 8192000000 10810418256 11199291392 1867522432 18.564 100 83 162 0 1901516160 11612368 22381360
14:08:04 10794 8192000000 10800368592 11200757760 1864996384 18.544 100 68 136 1 1897420048 13491840 18931824
14:08:25 1934 8192000000 10784060288 11192299520 1863169088 18.529 100 50 103 1 1887056688 9783744 14103856
14:08:33 5436 8192000000 10769434048 11188076544 1860852720 18.510 100 31 61 1 1877276944 8169792 8254432
14:08:45 6319 8192000000 10788156192 11197280256 1865027392 18.544 100 46 92 1 1887262848 9188960 13046496
14:09:00 6174 8192000000 10782315840 11194986496 1864085776 18.536 100 28 54 2 1878821280 7295968 7439536
14:09:14 4956 8192000000 10776092848 11198054400 1865746032 18.550 100 34 69 1 1883935952 8810608 9379312
14:09:25 7763 8192000000 10767414288 11197304832 1865418256 18.547 100 15 30 1 1875827472 6400992 4008224
14:09:39 9257 8192000000 10778749024 11204407296 1870443936 18.588 100 25 50 0 1884130144 6503328 7182880
14:09:55 10509 8192000000 10782791664 11212038144 1872778320 18.607 100 14 28 1 1882600720 6245008 3577392
14:10:13 8949 8192000000 10792623392 11214393344 1877752000 18.647 100 19 38 1 1888865328 6166336 4946992
14:10:34 21240 8192000000 10777297968 11213369344 1884288208 18.700 100 28 56 2 1898849952 5972224 8589520
14:11:02 46612 8192000000 10799740304 11224551424 1884633568 18.703 100 32 62 2 1900457312 6567392 9256352
14:11:55 20836 8192000000 10793830560 11230429184 1885752704 18.712 100 29 58 0 1899817472 5593152 8471616
14:12:22 7591 8192000000 10798795872 11231211520 1884080544 18.698 100 22 45 1 1896460352 5656064 6723744
14:12:42 4348 8192000000 10809621280 11238969344 1890497456 18.750 100 31 61 3 1906354896 7008064 8849376
14:12:55 5603 8192000000 10805691456 11240005632 1891046848 18.754 100 29 57 1 1905229680 5699152 8483680
14:13:08 3385 8192000000 10809814912 11242430464 1896999136 18.802 100 37 73 1 1914675856 7642384 10034336
14:13:18 5988 8192000000 10807922304 11243962368 1894397952 18.781 100 17 34 0 1904758896 5392032 4968912
14:13:30 10433 8192000000 10813256640 11246600192 1901430368 18.838 100 29 58 2 1916287520 6322848 8534304
14:13:51 13231 8192000000 10807841104 11246641152 1898334272 18.813 100 16 32 2 1908461744 5241984 4885488
14:14:10 6161 8192000000 10828044000 11257098240 1903078656 18.851 100 28 54 1 1916210416 5639248 7492512
14:14:28 8469 8192000000 10819475168 11256090624 1904964288 18.866 100 14 28 0 1914514944 5657264 3893392
14:14:44 11566 8192000000 10821827744 11259535360 1910140560 18.908 100 20 40 1 1921585984 5486368 5959056
14:15:02 6671 8192000000 10816239984 11259179008 1911912848 18.922 100 21 42 1 1923978944 5592368 6473728
14:15:17 7064 8192000000 10822899024 11259801600 1907262432 18.885 100 19 36 1 1918354752 5258992 5833328
14:15:31 49558 8192000000 10821652112 11244654592 1871107424 18.593 98 26 52 3 1883814704 4937648 7769632
14:16:33 19519 8192000000 10802990672 11234615296 1864618080 18.541 98 38 76 0 1882546640 7113568 10814992
14:17:00 7001 8192000000 10785151648 11218350080 1843662192 18.371 98 35 70 1 1860349312 6794704 9892416
14:17:14 7016 8192000000 10777412688 11210137600 1841066336 18.349 98 17 34 2 1852060656 5984960 5009360
14:17:29 6351 8192000000 10774615232 11201994752 1804016256 18.047 96 30 59 3 1819001120 6716944 8267920
14:17:42 6869 8192000000 10767116736 11192913920 1823296384 18.205 98 22 44 1 1835290160 5809408 6184368
14:17:55 5715 8192000000 10749602336 11168792576 1772658432 17.789 95 34 68 2 1788450736 5705408 10086896
14:18:09 6530 8192000000 10737056128 11156586496 1801585568 18.027 98 23 45 3 1813319792 5611056 6123168
14:18:23 7942 8192000000 10697341552 11113058304 1710576368 17.274 94 16 32 0 1719998336 4920448 4501520
14:18:38 8472 8192000000 10710414016 11127676928 1750505984 17.606 96 21 41 1 1762140016 5541936 6092096
14:18:55 4268 8192000000 10702164736 11120218112 1770496384 17.771 98 27 54 2 1784029568 5148640 8384544
14:19:07 4666 8192000000 10715564112 11139477504 1792020160 17.948 99 25 51 1 1805742960 6799488 6923312
14:19:21 3521 8192000000 10686982416 11102085120 1771006560 17.775 98 18 36 2 1781884736 5293568 5584608
14:19:34 8536 8192000000 10692682016 11103092736 1689381888 17.096 94 21 42 1 1705011712 10029552 5600272
14:19:51 8456 8192000000 10661258272 11065049088 1657408784 16.827 93 27 53 1 1671964912 5366640 9189488
14:20:06 20043 8192000000 10688890720 11095093248 1718430288 17.339 97 29 58 1 1731921872 5661264 7830320
14:20:32 62544 8192000000 10702371472 11128414208 1778247552 17.835 99 37 74 0 1794580864 5917264 10416048
14:21:44 9359 8192000000 10726020400 11149799424 1799423600 18.009 99 22 44 1 1812611856 6781008 6407248
14:22:04 8239 8192000000 10733454784 11145797632 1769730240 17.765 97 37 75 0 1786288000 6026992 10530768
14:22:19 6805 8192000000 10746467792 11154837504 1819065952 18.170 100 32 65 1 1834095888 5263280 9766656
14:22:33 5086 8192000000 10735130160 11153158144 1819401104 18.173 100 34 68 0 1836063616 6823824 9838688
14:22:46 6709 8192000000 10752130880 11173400576 1831863776 18.275 100 30 60 3 1846770448 6008656 8898016
14:23:01 3705 8192000000 10753983632 11168428032 1815580800 18.142 99 22 44 2 1827534096 5785648 6167648
14:23:11 8750 8192000000 10750605408 11176538112 1835546992 18.305 100 19 38 1 1846509008 5300048 5661968
14:23:27 6564 8192000000 10763729200 11189002240 1850456832 18.426 100 25 50 1 1864280016 6182304 7640880
14:23:40 10086 8192000000 10769235696 11197554688 1854743968 18.461 100 31 62 0 1869166096 5709776 8712352
14:23:57 10958 8192000000 10774027728 11196137472 1841652352 18.354 99 24 48 1 1854316944 5691856 6972736
14:24:14 9438 8192000000 10775489152 11200790528 1859452448 18.499 100 19 39 1 1870387328 5549760 5385120
14:24:31 6419 8192000000 10784080768 11211718656 1866049232 18.552 100 20 40 0 1877990816 6043280 5898304
14:24:44 10273 8192000000 10786286816 11218690048 1869732768 18.582 100 17 34 0 1885313680 10248352 5332560
14:25:01 6170 8192000000 10798049344 11220037632 1879244736 18.659 100 34 68 4 1895029136 5665904 10118496
14:25:18 64411 8192000000 10782611680 11222626304 1878725312 18.655 100 27 54 0 1891686576 5036048 7925216
14:26:31 7592 8192000000 10800598704 11231674368 1884860144 18.704 100 21 42 1 1896397536 5054096 6483296
14:26:45 4872 8192000000 10811410640 11237584896 1887245248 18.724 100 26 52 1 1901032912 7048576 6739088
14:26:58 4956 8192000000 10812283312 11239010304 1892002704 18.762 100 37 74 2 1908810496 6319376 10488416
14:27:23 6984 8192000000 10851215936 11268313088 1916042848 18.955 100 44 88 1 1934401184 6315392 12042944
14:27:38 17624 8192000000 10867263024 11276832768 1926171088 19.036 100 54 107 2 1950245152 8450080 15623984
14:28:03 8396 8192000000 10877824560 11289202688 1934840544 19.106 100 57 113 0 1960164224 9239888 16083792
14:28:36 26442 8192000000 10871881472 11295739904 1939947152 19.146 100 53 106 1 1965668096 10303712 15417232
14:29:15 18322 8192000000 10873110384 11301552128 1944834608 19.185 100 43 84 3 1965662032 9007376 11820048
14:29:40 13561 8192000000 10883489648 11309481984 1951569200 19.239 100 49 96 4 1975654896 10263664 13822032
14:30:21 8105 8192000000 10896386256 11323412480 1961455424 19.318 100 50 97 3 1985132192 10151728 13525040
14:30:36 9434 8192000000 10898110416 11327168512 1965206880 19.347 100 60 120 1 1993463904 11474560 16782464
14:30:54 5912 8192000000 10901005824 11329417216 1967623120 19.367 100 56 109 0 1994336080 11482064 15230896
14:31:12 11297 8192000000 10899596048 11333713920 1967659456 19.367 100 47 91 0 1992187792 11631120 12897216
14:31:34 23882 8192000000 10903911488 11341193216 1972695456 19.407 100 39 78 1 1997471424 13541744 11234224
14:32:05 22625 8192000000 10924761568 11357421568 1981902128 19.480 100 42 84 1 2009968992 15200704 12866160
14:32:35 20080 8192000000 10927853440 11364737024 1989388352 19.539 100 55 110 1 2022700960 16292112 17020496
14:33:21 33648 8192000000 10922293888 11368128512 1989556656 19.540 100 38 76 1 2017500496 16845488 11098352
14:34:02 13351 8192000000 10926414480 11365502976 1989395600 19.539 100 55 108 4 2022532528 16552896 16584032
14:34:40 16234 8192000000 10933050848 11378507776 1997379072 19.602 100 43 86 0 2030354592 19761920 13213600
14:35:06 11346 8192000000 10929048176 11376959488 1998607136 19.612 100 42 81 1 2027963088 17185008 12170944
14:35:24 4989 8192000000 10950853440 11379793920 1999011632 19.615 100 41 82 2 2028048016 16914752 12121632
14:35:39 4913 8192000000 10951247264 11384270848 2004830720 19.661 100 59 117 0 2039971536 17664144 17476672
14:35:52 8772 8192000000 10937867264 11369127936 1991732192 19.557 100 55 110 2 2027965808 19804864 16428752
14:36:10 19941 8192000000 10958719152 11387293696 2000554880 19.627 100 67 132 0 2041648928 21235280 19858768
14:36:44 5783 8192000000 10963696640 11394777088 2009333328 19.696 100 59 118 0 2052785808 25157072 18295408
14:36:58 5404 8192000000 10939651184 11368660992 1983901152 19.496 99 58 116 0 2026497280 24306528 18289600
14:37:14 2590 8192000000 10964158368 11385790464 2002571424 19.643 100 60 118 1 2045188672 24626032 17991216
14:37:23 7602 8192000000 10971949248 11396620288 2008750672 19.692 100 70 138 2 2054722368 25904816 20066880
14:37:38 2741 8192000000 10975930016 11403812864 2015751568 19.747 100 74 148 0 2064457968 26689888 22016512
14:37:48 4504 8192000000 10979621504 11411165184 2016630704 19.754 100 66 132 3 2066118496 29374192 20113600
14:38:01 3557 8192000000 10977980080 11413102592 2019866544 19.779 100 60 120 0 2067472336 29475520 18130272
14:38:12 1928 8192000000 10989773008 11410268160 2026607760 19.832 100 69 134 1 2073964272 25252512 22104000
14:38:22 2435 8192000000 10991085136 11416604672 2028434256 19.846 100 78 154 1 2078517248 26721376 23361616
14:38:36 2993 8192000000 10983189968 11414683648 2024666704 19.817 100 63 125 1 2069071248 25458224 18946320
14:38:48 4191 8192000000 10990198656 11416236032 2028376960 19.846 100 76 151 0 2077883472 26782880 22723632
14:38:59 1678 8192000000 10985220512 11408617472 2002317744 19.641 99 70 137 1 2050337632 26999952 21019936
14:39:09 3967 8192000000 10995925584 11421773824 2024814144 19.818 100 77 154 1 2074316864 26243568 23259152
14:39:19 2591 8192000000 10955278656 11377737728 1976924592 19.440 98 75 151 0 2025248464 25289680 23034192
14:39:29 4448 8192000000 10951372944 11369013248 1978300592 19.451 99 80 160 0 2029431504 26782960 24347952
14:39:40 3056 8192000000 10946738560 11373584384 1982813360 19.487 100 70 140 1 2031110496 27381696 20915440
14:39:52 5742 8192000000 10951877504 11378823168 1990527136 19.548 100 74 150 2 2040286208 27369216 22389856
14:40:05 4530 8192000000 10942358736 11370823680 1974054816 19.418 100 59 118 0 2020800576 28911840 17833920
14:40:16 3438 8192000000 10939998400 11358220288 1958996160 19.298 99 78 155 0 2011926304 29392832 23537312
14:40:28 3662 8192000000 10933111632 11349102592 1950322800 19.229 99 76 150 1 2004729712 30557264 23849648
14:40:44 2536 8192000000 10955088864 11370795008 1976357616 19.436 100 87 174 0 2036567904 33693968 26516320
14:40:53 889 8192000000 10968870864 11378819072 1985118480 19.505 100 92 184 0 2048717808 35345104 28254224
14:41:01 3410 8192000000 10969435472 11383713792 1989030336 19.536 100 86 171 0 2052141424 36916000 26195088
14:41:13 6750 8192000000 10954234512 11375464448 1979898880 19.464 100 79 155 0 2041005712 36973056 24133776
14:41:27 3105 8192000000 10956965120 11379597312 1985512720 19.508 100 82 164 0 2046985120 36437776 25034624
14:41:38 3574 8192000000 10965635696 11382718464 1986781824 19.518 100 88 177 1 2050265760 36759168 26724768
14:41:51 5489 8192000000 10954693888 11371700224 1976342944 19.436 100 77 152 1 2034248272 34080960 23824368
14:42:05 2074 8192000000 10944055920 11352481792 1961259280 19.316 99 81 157 4 2019753472 34038576 24455616
14:42:14 1909 8192000000 10947291888 11366502400 1974163456 19.418 100 71 141 0 2028849696 33529920 21156320
14:42:23 4085 8192000000 10950776736 11370717184 1975595088 19.430 100 78 154 2 2038525376 39508656 23421632
14:42:34 12452 8192000000 10963201456 11387785216 1967061760 19.362 99 74 149 2 2029753616 39080784 23611072
14:42:54 8337 8192000000 10962818448 11378757632 1965313136 19.348 99 76 151 3 2026957440 38163280 23481024
14:43:09 3859 8192000000 10959740384 11366670336 1963973312 19.338 100 83 164 0 2029926336 40595456 25357568
14:43:21 2381 8192000000 10944687024 11354845184 1960733792 19.312 100 81 162 1 2024912496 39139600 25039104
14:43:32 5899 8192000000 10952157520 11360215040 1964627216 19.343 100 83 163 3 2029206944 38789008 25790720
14:43:46 2773 8192000000 10926538176 11344175104 1949235984 19.220 99 74 146 2 2010787344 39183616 22367744
14:43:56 1502 8192000000 10954214480 11371540480 1970297904 19.388 100 80 160 2 2036005696 40969584 24738208
14:44:08 3798 8192000000 10916651936 11335798784 1940325312 19.149 99 60 119 1 1998095328 38857856 18912160
14:44:19 3558 8192000000 10935388944 11363201024 1964012032 19.338 100 66 132 0 2024724416 39080432 21631952
14:44:30 4742 8192000000 10921804624 11362070528 1959172784 19.299 100 58 116 0 2018983952 41831904 17979264
14:44:48 7339 8192000000 10923072688 11356893184 1945639648 19.192 99 47 93 3 1994418032 33411632 15366752
14:45:07 5705 8192000000 10935783920 11369996288 1966165280 19.355 100 36 72 0 2009580896 31704064 11711552
14:45:22 3624 8192000000 10931116016 11346366464 1923617728 19.016 98 77 150 0 1981202592 33796304 23788560
14:45:33 1635 8192000000 10923701584 11343888384 1949009728 19.219 100 72 140 1 2005488096 34685744 21792624
14:45:51 3566 8192000000 10872348176 11295952896 1905396544 18.870 98 46 91 1 1954436512 34555136 14484832
14:46:05 11072 8192000000 10848043440 11283431424 1855558144 18.467 96 44 88 1 1905971440 36862464 13550832
14:46:24 17350 8192000000 10875938032 11313819648 1915076784 18.947 100 31 62 3 1962278080 37182208 10019088
14:46:54 6262 8192000000 10913802864 11342016512 1944356928 19.182 100 52 102 3 1996929744 35196032 17376784
14:47:13 18124 8192000000 10891265856 11332988928 1933403648 19.094 100 34 67 0 1983534144 38297808 11832688
14:47:40 2248 8192000000 10923808704 11344166912 1943155104 19.172 100 68 133 0 2005228304 38788816 23284384
14:47:49 3043 8192000000 10924067056 11338457088 1938135728 19.132 100 78 154 1 2003659408 41458048 24065632
14:48:02 8419 8192000000 10898063984 11334754304 1932324560 19.085 100 45 90 2 1986065456 39338240 14402656
14:48:17 9346 8192000000 10878629680 11311624192 1893306720 18.772 98 45 88 2 1947851856 40435056 14110080
14:48:39 6988 8192000000 10877181248 11315699712 1914879968 18.946 100 25 49 4 1960587152 37403024 8304160
14:48:55 4956 8192000000 10889074336 11314950144 1917464640 18.967 100 41 82 1 1966947888 35462480 14020768
14:49:09 5581 8192000000 10880323392 11303497728 1882748304 18.687 98 51 101 1 1937012080 38153728 16110048
14:49:21 6160 8192000000 10920956304 11331567616 1928015216 19.051 100 69 137 2 1990291712 40552768 21723728
14:49:36 8301 8192000000 10898776768 11330035712 1931239184 19.077 100 41 81 1 1980288800 36176144 12873472
14:49:59 20601 8192000000 10883930992 11319316480 1895888096 18.793 98 39 79 1 1942659312 33798224 12972992
14:50:27 6003 8192000000 10891091184 11326771200 1931965664 19.083 100 42 84 1 1975523840 30612976 12945200
14:50:49 22523 8192000000 10879845488 11319132160 1907317200 18.885 99 26 52 1 1950070656 33541696 9211760
14:51:19 20491 8192000000 10890411760 11327795200 1925497600 19.031 100 34 68 3 1971473440 34417184 11558656
14:52:12 26205 8192000000 10883726496 11326939136 1918586432 18.976 100 24 48 1 1966397248 39281824 8528992
14:52:51 31862 8192000000 10865821072 11321409536 1898519840 18.814 99 20 40 1 1936099664 30710464 6869360
14:53:32 28005 8192000000 10846048816 11311783936 1889831888 18.744 99 10 20 0 1921704224 28408944 3463392
14:54:06 22626 8192000000 10849013904 11306995712 1870190848 18.586 98 8 16 0 1897248960 24834800 2223312
14:54:36 29012 8192000000 10851151200 11288199168 1850563552 18.427 97 24 48 3 1879816272 21901856 7350864
14:55:11 49910 8192000000 10853137648 11319463936 1908993424 18.899 100 14 28 2 1932261760 19466032 3802304
14:56:07 55654 8192000000 10839895792 11284459520 1877772880 18.647 98 24 48 2 1895352400 10035536 7543984
14:57:39 92665 8192000000 10888183392 11338096640 1946866816 19.202 100 30 61 0 1967404112 12265840 8271456
14:59:19 66218 8192000000 10885776496 11318509568 1883043248 18.690 97 17 34 0 1909550176 21811376 4695552
15:00:32 63571 8192000000 10872758928 11327610880 1941545328 19.159 100 19 38 1 1954017664 7658000 4814336
15:01:43 52831 8192000000 10898111840 11356004352 1953905776 19.258 100 8 16 0 1967527200 11581952 2039472
15:02:57 94312 8192000000 10898610832 11357376512 1915595776 18.952 98 8 16 1 1935595712 17253376 2746560
15:04:39 82938 8192000000 10908264560 11367940096 1940293840 19.149 99 16 32 1 1961470016 16214928 4961248
15:06:11 59055 8192000000 10897545664 11352223744 1945999568 19.195 99 15 30 1 1964128592 14074960 4054064
15:07:18 96960 8192000000 10923758224 11362037760 1964296304 19.340 100 31 62 2 1980500208 6608096 9595808
15:09:03 34713 8192000000 10914594336 11367358464 1979267488 19.459 100 41 82 1 1998284256 7466720 11550048
15:09:46 18592 8192000000 10950918512 11385409536 1986301520 19.515 100 54 104 4 2010017520 8580000 15136000
15:10:16 171293 8192000000 10940940944 11399647232 1935943776 19.114 97 32 64 0 1960742672 15871840 8927056
15:13:14 19448 8192000000 10930504528 11389317120 1992801136 19.566 100 29 58 0 2017456144 15974368 8680640
15:13:40 28101 8192000000 10953277360 11406270464 1992326896 19.562 100 42 83 3 2023032864 18250832 12455136
15:14:20 15896 8192000000 10966277696 11410112512 2005476816 19.666 100 63 129 3 2048154240 23363904 19313520
15:14:42 25123 8192000000 10949998832 11401076736 1981813728 19.479 99 39 78 2 2012954048 19510560 11629760
15:15:37 50567 8192000000 10929430736 11411046400 1980298800 19.467 99 18 36 1 2007472304 21210336 5963168
15:16:38 62995 8192000000 10929542320 11412058112 1993332064 19.570 100 20 40 0 2023440832 23634208 6474560
15:18:12 65029 8192000000 10942983616 11406856192 1976642224 19.438 99 24 48 1 2007775472 23541584 7591664
15:19:26 40947 8192000000 10903446832 11411685376 1963405488 19.333 99 11 22 0 1990291744 22955744 3930512
15:20:37 47999 8192000000 10903603040 11377197056 1944759520 19.185 98 23 46 1 1960279296 8874816 6644960
15:21:42 30070 8192000000 10878476448 11350355968 1914017744 18.939 97 16 32 2 1925936064 7244736 4673584
15:22:24 63955 8192000000 10884969600 11367518208 1932621440 19.088 98 11 22 0 1943420640 7982288 2816912
15:23:34 36708 8192000000 10884781360 11337662464 1874174416 18.618 95 15 30 1 1887990592 9864464 3951712
15:24:29 43859 8192000000 10863452912 11325059072 1892721136 18.768 97 24 48 1 1912557392 13125840 6710416
15:25:27 25623 8192000000 10868635600 11334115328 1905459600 18.870 98 21 42 0 1926731344 14939168 6332576
15:26:16 67360 8192000000 10879398880 11330523136 1862322688 18.522 96 10 20 0 1882572224 17244112 3005424
15:27:30 75740 8192000000 10866128752 11324481536 1848409616 18.409 95 18 36 0 1867561584 14645904 4506064
15:29:01 57597 8192000000 10855718448 11331452928 1853651248 18.452 95 34 68 2 1877126944 14155104 9320592
15:30:15 84406 8192000000 10875178736 11325943808 1852696144 18.444 96 21 42 0 1871537104 12818192 6022768
15:31:46 42607 8192000000 10881511072 11343818752 1935266368 19.109 100 41 82 0 1960695824 13901040 11528416
15:33:24 43689 8192000000 10872077184 11330023424 1875654848 18.630 96 41 82 0 1896960240 8731616 12573776
15:34:17 23457 8192000000 10870961232 11310419968 1843321360 18.368 95 36 72 2 1862324960 9230944 9772656
15:34:46 23126 8192000000 10878355856 11323379712 1899744032 18.824 99 39 78 0 1925015376 14602560 10668784
15:35:18 47820 8192000000 10877490448 11347726336 1927130592 19.044 100 13 25 0 1944309168 13577296 3601280
15:37:23 60622 8192000000 10855125680 11331403776 1880525680 18.669 97 16 32 0 1900262608 15688688 4048240
15:38:48 118564 8192000000 10901779552 11336294400 1921806384 19.001 99 27 53 3 1941900960 12200272 7894304
15:41:00 87793 8192000000 10872904400 11344326656 1914421472 18.942 98 25 50 0 1935341472 13892384 7027616
15:42:35 21152 8192000000 10871652720 11343159296 1928278000 19.053 99 17 34 0 1945956208 12413376 5264832
15:43:04 7553 8192000000 10880203968 11342438400 1942945216 19.170 100 26 52 2 1962163872 12203936 7014720
15:43:19 34450 8192000000 10845632576 11328045056 1913632080 18.936 99 49 91 2 1936771184 8340064 14799040
15:44:02 69280 8192000000 10857141424 11332116480 1887204832 18.723 97 20 39 0 1901981104 9494368 5281904
15:45:18 55711 8192000000 10846410336 11311796224 1840501440 18.345 95 10 20 1 1849029664 6325696 2202528
15:46:46 98756 8192000000 10872495920 11350720512 1947203184 19.204 100 9 18 0 1961063680 10892224 2968272
15:48:45 17273 8192000000 10867505968 11351404544 1944342096 19.181 100 4 9 0 1954270992 8755440 1173456
15:49:20 67065 8192000000 10875670112 11360415744 1960272448 19.308 100 32 64 0 1977497552 8349840 8875264
15:51:01 54063 8192000000 10900484144 11369996288 1942162080 19.164 99 23 46 0 1966805168 17665056 6978032
15:54:15 43141 8192000000 10901410608 11387052032 1979461968 19.460 100 20 40 1 1994618192 9668304 5487920
15:55:34 53277 8192000000 10926983408 11386302464 1952072448 19.243 98 24 48 3 1966359024 7616384 6670192
15:56:37 39566 8192000000 10915917056 11393810432 1971098592 19.394 99 26 52 2 1989039152 10506000 7434560
15:57:24 63253 8192000000 10933392304 11407966208 1979392112 19.460 99 16 32 1 1993443248 9847408 4203728
15:58:34 92928 8192000000 10943065296 11419103232 1949082336 19.219 97 12 24 2 1967384352 14963536 3338480
16:00:15 91709 8192000000 10921242880 11393761280 1954734560 19.264 98 8 16 1 1972213584 15614384 1864640
16:01:58 59266 8192000000 10935072240 11415564288 1977191984 19.442 99 21 42 1 1997615552 14601488 5822080
16:03:07 36100 8192000000 10917320432 11377684480 1937636240 19.128 97 30 59 0 1956726176 10789280 8300656
16:03:49 71338 8192000000 10929597888 11408703488 1994594208 19.580 100 17 34 1 2014970480 15370144 5006128
16:05:09 69275 8192000000 10945615728 11417116672 1968248464 19.372 98 18 36 0 1986520576 12970960 5301152
16:06:42 74473 8192000000 10935345632 11415658496 1958197824 19.292 98 5 10 1 1972844240 13165840 1480576
16:08:09 49845 8192000000 10890358640 11377074176 1896119776 18.795 95 17 34 1 1912607584 10913696 5574112
16:09:12 104880 8192000000 10861033568 11335303168 1893106240 18.771 96 24 48 0 1907699024 7171328 7421456
16:11:03 76619 8192000000 10887068656 11355574272 1917285376 18.965 98 27 54 0 1932922304 8423120 7213808
16:12:38 16653 8192000000 10903810672 11349856256 1948974224 19.218 99 37 74 1 1968134400 9344208 9815968
16:13:01 19683 8192000000 10902286560 11357122560 1947980672 19.210 99 55 110 2 1974445312 11056352 15408288
16:13:28 40276 8192000000 10877117232 11358068736 1943662672 19.176 99 30 60 1 1967503232 15168048 8672512
16:15:32 73307 8192000000 10881024352 11352662016 1923240416 19.013 98 16 32 0 1939045136 11056960 4747760
16:16:51 103667 8192000000 10861534944 11337113600 1868482624 18.572 95 12 24 0 1887036304 14843712 3709968
16:18:44 63670 8192000000 10862851792 11341451264 1879584752 18.662 97 21 42 0 1902900608 16952896 6362960
16:19:54 49504 8192000000 10876244288 11357962240 1917004832 18.963 99 20 39 0 1947298960 24173552 6120576
16:21:03 52612 8192000000 10862996144 11342835712 1882827920 18.688 97 17 34 1 1900497920 12714272 4955728
16:22:13 103257 8192000000 10841832528 11333632000 1807097152 18.072 93 15 30 2 1820964624 9548096 4319376
16:24:05 83565 8192000000 10854798976 11334647808 1865754864 18.550 96 34 68 1 1898328704 23284960 9288880
16:25:35 32864 8192000000 10852536848 11308118016 1886674672 18.719 98 25 50 3 1902867216 9004352 7188192
16:26:16 48193 8192000000 10850693888 11306823680 1879697280 18.663 97 41 82 1 1906561808 15487328 11377200

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 14-11-2020 16:28:24 to 14-11-2020 16:28:56.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 92 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-11-2020 16:28:57 to 14-11-2020 16:28:59.

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          248769
MON$OLDEST_ACTIVE               248770
MON$OLDEST_SNAPSHOT             248770
MON$NEXT_TRANSACTION            248770
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                       2055008
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.33390 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33390 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33390 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33390 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'

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