Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 11.01.2021 01: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 17403892 kB
MemAvailable 31335428 kB
Buffers 0 kB
Cached 14259180 kB
SwapCached 4864 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-01-11 01:27:08
DTS_END                         2021-01-11 01:27:08.4270
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/54220
TRN_ID                          233084
ATT_ID                          624
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: 9539.16 22712 1144699
customer order: creation 165.98 357 19918
customer order: refuse 14.12 347 1694
order to supplier: creation 45.12 1350 5414
order to supplier: removal 3.47 110043 416
invoice (draft): creation 44.18 3061 5302
invoice (draft): removal 55.83 688 6700
invoice accept: apply 40.17 17569 4820
invoice accept: cancel 50.78 725 6094
customer reserve: creation 3837.50 167 460500
customer reserve: removal 4986.08 60 598330
realization accept: apply 82.33 176 9879
realization accept: cancel 88.89 105 10667
payment from customer: creation 57.23 123 6868
payment from customer: removal 5.21 90 625
payment to supplier: creation 47.22 127 5666
payment to supplier: removal 3.48 65 417
service: total inventory turnovers 4.46 1205 535
service: total monetary turnovers 6.34 22 761
service: aggregate perf. data 0.74 22871 89
service: refresh index statistics 0.03 295085 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 11-01-2021 01:28:04 to 11-01-2021 01:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2500
TEST_TIME 2 3711
TEST_TIME 3 3887
TEST_TIME 4 4472
TEST_TIME 5 4254
TEST_TIME 6 4395
TEST_TIME 7 4744
TEST_TIME 8 4716
TEST_TIME 9 4846
TEST_TIME 10 5260
TEST_TIME 11 5509
TEST_TIME 12 5949
TEST_TIME 13 5988
TEST_TIME 14 6144
TEST_TIME 15 6555
TEST_TIME 16 6454
TEST_TIME 17 6891
TEST_TIME 18 7210
TEST_TIME 19 7524
TEST_TIME 20 7997
TEST_TIME 21 8492
TEST_TIME 22 8270
TEST_TIME 23 8566
TEST_TIME 24 8987
TEST_TIME 25 9488
TEST_TIME 26 10120
TEST_TIME 27 11151
TEST_TIME 28 11098
TEST_TIME 29 10787
TEST_TIME 30 10724
TEST_TIME 31 10425
TEST_TIME 32 10237
TEST_TIME 33 10191
TEST_TIME 34 10089
TEST_TIME 35 10029
TEST_TIME 36 9893
TEST_TIME 37 9938
TEST_TIME 38 9881
TEST_TIME 39 9694
TEST_TIME 40 9702
TEST_TIME 41 9642
TEST_TIME 42 9810
TEST_TIME 43 9922
TEST_TIME 44 9801
TEST_TIME 45 9879
TEST_TIME 46 9858
TEST_TIME 47 9923
TEST_TIME 48 9948
TEST_TIME 49 9979
TEST_TIME 50 9951
TEST_TIME 51 9927
TEST_TIME 52 9968
TEST_TIME 53 9980
TEST_TIME 54 10109
TEST_TIME 55 10005
TEST_TIME 56 9845
TEST_TIME 57 9786
TEST_TIME 58 9798
TEST_TIME 59 9771
TEST_TIME 60 9859
TEST_TIME 61 9770
TEST_TIME 62 9719
TEST_TIME 63 9638
TEST_TIME 64 9584
TEST_TIME 65 9543
TEST_TIME 66 9648
TEST_TIME 67 9621
TEST_TIME 68 9678
TEST_TIME 69 9660
TEST_TIME 70 9643
TEST_TIME 71 9714
TEST_TIME 72 9707
TEST_TIME 73 9752
TEST_TIME 74 9783
TEST_TIME 75 9791
TEST_TIME 76 9830
TEST_TIME 77 9830
TEST_TIME 78 9805
TEST_TIME 79 9711
TEST_TIME 80 9740
TEST_TIME 81 9692
TEST_TIME 82 9677
TEST_TIME 83 9614
TEST_TIME 84 9589
TEST_TIME 85 9551
TEST_TIME 86 9604
TEST_TIME 87 9593
TEST_TIME 88 9579
TEST_TIME 89 9563
TEST_TIME 90 9554
TEST_TIME 91 9621
TEST_TIME 92 9598
TEST_TIME 93 9646
TEST_TIME 94 9617
TEST_TIME 95 9682
TEST_TIME 96 9725
TEST_TIME 97 9722
TEST_TIME 98 9701
TEST_TIME 99 9777
TEST_TIME 100 9782
TEST_TIME 101 9829
TEST_TIME 102 9744
TEST_TIME 103 9675
TEST_TIME 104 9668
TEST_TIME 105 9676
TEST_TIME 106 9633
TEST_TIME 107 9591
TEST_TIME 108 9570
TEST_TIME 109 9547
TEST_TIME 110 9600
TEST_TIME 111 9553
TEST_TIME 112 9614
TEST_TIME 113 9614
TEST_TIME 114 9600
TEST_TIME 115 9607
TEST_TIME 116 9619
TEST_TIME 117 9615
TEST_TIME 118 9612
TEST_TIME 119 9593
TEST_TIME 120 9540

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 11-01-2021 01:28:07 to 11-01-2021 01:28:10.

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 1570000 1570000 0 0.00 0 25187 6 0 0
doc_list_biud 1570000 1570000 0 0.00 0 25175 29 0 0
sp_add_invoice_to_stock 4959 4820 139 2.80 54 206035 17569 0 139
sp_cancel_adding_invoice 6094 6094 0 0.00 5 69548 726 0 0
sp_cancel_client_order 1694 1694 0 0.00 4 9756 348 0 0
sp_cancel_customer_reserve 598330 598330 0 0.00 1 20022 61 0 0
sp_cancel_pay_from_customer 625 625 0 0.00 3 9001 90 0 0
sp_cancel_pay_to_supplier 417 417 0 0.00 2 2264 66 0 0
sp_cancel_supplier_invoice 6709 6700 9 0.13 2 20417 688 0 9
sp_cancel_supplier_order 416 416 0 0.00 6 1083216 110044 0 0
sp_cancel_write_off 10667 10667 0 0.00 1 18728 106 0 0
sp_client_order 19918 19918 0 0.00 3 25251 358 0 0
sp_customer_reserve 460500 460500 0 0.00 0 155368 168 0 0
sp_fill_shopping_cart 30624 30624 0 0.00 1 13216 33 0 0
sp_fill_shopping_cart_clo_res 460488 460488 0 0.00 0 17515 13 0 0
sp_get_clo_for_invoice 4808 4808 0 0.00 0 16970 300 0 0
sp_kill_cost_storno 17803 17803 0 0.00 0 14640 57 0 0
sp_kill_qstorno_ret_qs2qd 1214443 1214443 0 0.00 0 20400 32 0 0
sp_kill_qty_storno 638588 638588 0 0.00 0 25173 70 0 0
sp_lock_selected_doc 20194 20194 0 0.00 0 6751 3 0 0
sp_make_cost_storno 27221 27221 0 0.00 0 18534 53 0 0
sp_multiply_rows_for_pdistr 27221 27221 0 0.00 0 9957 28 0 0
sp_multiply_rows_for_qdistr 19918 19918 0 0.00 0 23678 161 0 0
sp_pay_from_customer 6868 6868 0 0.00 4 12665 123 0 0
sp_pay_to_supplier 5666 5666 0 0.00 4 12776 128 0 0
sp_payment_common 12534 12534 0 0.00 2 12297 30 0 0
sp_qd_handle_on_cancel_clo 1694 1694 0 0.00 0 9749 317 0 0
sp_qd_handle_on_invoice_upd_sts 10902 10902 0 0.00 0 25173 340 0 0
sp_qd_handle_on_reserve_upd_sts 9879 9879 0 0.00 0 18778 62 0 0
sp_reserve_write_off 9879 9879 0 0.00 6 18847 176 0 0
sp_supplier_invoice 5302 5302 0 0.00 6 87607 3061 0 0
sp_supplier_order 5414 5414 0 0.00 5 37398 1350 0 0
srv_aggregate_perf_data 90 89 1 1.11 2535 289116 22872 0 1
srv_fill_mon_cache_memory 152 152 0 0.00 952 137828 36113 0 0
srv_find_qd_qs_mism 1097516 1097516 0 0.00 0 25178 4 0 0
srv_make_invnt_saldo 535 535 0 0.00 31 127080 1206 0 0
srv_make_money_saldo 761 761 0 0.00 0 888 22 0 0
srv_recalc_idx_stat 4 4 0 0.00 190867 396626 295085 0 0
t$perf-abend:sp_add_invoice_to_stock 139 139 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4820 4820 0 0.00 0 25697 182 0 0
t$perf-norm:sp_cancel_adding_invoice 373 373 0 0.00 0 5187 105 0 0
t$perf-norm:sp_cancel_client_order 1694 1694 0 0.00 0 1698 10 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 4827 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 625 625 0 0.00 0 5520 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 417 417 0 0.00 0 600 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 373 373 0 0.00 0 1054 13 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 19697 1612 0 0
t$perf-norm:sp_cancel_write_off 951 951 0 0.00 0 3974 9 0 0
t$perf-norm:sp_client_order 19918 19918 0 0.00 0 18009 27 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 4896 12 0 0
t$perf-norm:sp_pay_from_customer 6868 6868 0 0.00 0 17783 14 0 0
t$perf-norm:sp_pay_to_supplier 5666 5666 0 0.00 0 7624 13 0 0
t$perf-norm:sp_reserve_write_off 9879 9879 0 0.00 0 14580 18 0 0
t$perf-norm:sp_supplier_invoice 5302 5302 0 0.00 0 7524 26 0 0
t$perf-norm:sp_supplier_order 5414 5414 0 0.00 0 7682 19 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 3200 50 0 0
t$perf-norm:srv_fill_mon_cache_memory 152 152 0 0.00 0 129 2 0 0
t$perf-norm:srv_make_invnt_saldo 535 535 0 0.00 0 4235 35 0 0
t$perf-norm:srv_make_money_saldo 761 761 0 0.00 0 1813 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 28 8 0 0
v_add_invoice_to_stock 9894 9616 278 2.80 0 6878 20 0 278
v_all_customers 37012 37012 0 0.00 0 236 1 0 0
v_all_suppliers 29910 29910 0 0.00 0 19 1 0 0
v_all_wares 39836 39836 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 746 746 0 0.00 0 2685 12 0 0
v_cancel_client_order 3388 3388 0 0.00 0 4824 5 0 0
v_cancel_customer_prepayment 1250 1250 0 0.00 0 3112 7 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 2952 10 0 0
v_cancel_payment_to_supplier 834 834 0 0.00 0 1052 5 0 0
v_cancel_supplier_invoice 764 746 18 2.35 0 793 16 0 18
v_cancel_supplier_order 832 832 0 0.00 0 889 5 0 0
v_cancel_write_off 1902 1902 0 0.00 0 4486 14 0 0
v_max_id_clo_ord 5411 5411 0 0.00 0 4789 3 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 7563 23 0 0
v_max_id_ord_sup 5294 5294 0 0.00 0 6356 6 0 0
v_max_non_paid_invoice 1416 1416 0 0.00 0 1589 6 0 0
v_max_non_paid_realizn 3352 3352 0 0.00 0 5168 5 0 0
v_min_id_clo_ord 5411 5411 0 0.00 0 2670 7 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 9479 22 0 0
v_min_id_ord_sup 5294 5294 0 0.00 0 3558 3 0 0
v_min_non_paid_invoice 5666 5666 0 0.00 0 10373 21 0 0
v_min_non_paid_realizn 6868 6868 0 0.00 0 6248 17 0 0
v_our_firm 9856 9856 0 0.00 0 12 1 0 0
v_reserve_write_off 19758 19758 0 0.00 0 4824 7 0 0
x_lock_depdocs_on_canc_invoice 12421 12421 0 0.00 0 17861 127 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 6484 337 0 0
x_make_qstorno_1000_1200 5414 5414 0 0.00 2 37384 1276 0 0
x_make_qstorno_1200_2000 5302 5302 0 0.00 2 87593 2945 0 0
x_make_qstorno_2100_3300 460500 460500 0 0.00 0 155366 152 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 11-01-2021 01:28:11 to 11-01-2021 01:28:15.

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
22:57:12 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:18 21104 8192000000 10269390128 10574774272 978006832 10.665 75 61 126 0 1000776160 2573392 20195936
22:57:48 33792 8192000000 10350554784 10667147264 1386864112 14.478 100 87 173 1 1420001840 4905184 28232544
22:58:34 20052 8192000000 10378501040 10700025856 1423169360 14.801 100 87 174 0 1458456112 6629536 28657216
22:59:09 16104 8192000000 10398207600 10723504128 1454927008 15.081 100 91 182 0 1492641872 7784896 29929968
22:59:44 26550 8192000000 10420605808 10748727296 1470398896 15.217 100 90 180 0 1508523616 8681328 29443392
23:00:27 23356 8192000000 10444583504 10776518656 1496308656 15.444 100 89 178 2 1534494704 9741024 28445024
23:00:59 18668 8192000000 10452742192 10787565568 1507012384 15.537 100 86 172 0 1545161744 10113024 28036336
23:01:29 22626 8192000000 10477964128 10820296704 1528111024 15.721 100 89 178 1 1567164608 10930624 28122960
23:02:05 18241 8192000000 10508207680 10855165952 1553017248 15.936 100 67 134 0 1584381120 11031616 20332256
23:02:31 15593 8192000000 10541591760 10896363520 1585883296 16.219 100 77 154 0 1619628400 10244736 23500368
23:02:58 15847 8192000000 10565743776 10921451520 1622491456 16.531 100 80 159 2 1657681376 11022064 24167856
23:03:23 12995 8192000000 10598737424 10962563072 1650861888 16.772 100 83 166 2 1687147744 12273440 24012416
23:03:45 10115 8192000000 10613282672 10976026624 1671379232 16.945 100 78 156 1 1706762496 12571472 22811792
23:04:02 12830 8192000000 10629963280 10996035584 1689938640 17.101 100 82 164 2 1726831856 13032000 23861216
23:04:22 7375 8192000000 10639438032 11007479808 1707448800 17.247 100 86 171 2 1746017264 14074368 24494096
23:04:36 6382 8192000000 10658283728 11027632128 1715881264 17.318 100 87 173 2 1755230336 14091440 25257632
23:04:51 6439 8192000000 10660016800 11033886720 1727665136 17.416 100 79 156 2 1763051360 13071360 22314864
23:05:05 5753 8192000000 10675362560 11049459712 1738593968 17.507 100 83 163 1 1775390224 13395776 23400480
23:05:18 4735 8192000000 10694863904 11068325888 1751789168 17.616 100 88 175 3 1789739168 13688864 24261136
23:05:30 3576 8192000000 10693738608 11069669376 1759606976 17.681 100 81 161 2 1795963264 13221136 23135152
23:05:40 4009 8192000000 10708811008 11087130624 1770033728 17.767 100 78 155 1 1804043456 12880816 21128912
23:05:50 3008 8192000000 10724339312 11100327936 1779039920 17.842 100 86 172 2 1816195344 13177920 23977504
23:06:01 5182 8192000000 10729254944 11104227328 1786938096 17.907 100 87 173 2 1824706464 14216608 23551760
23:06:12 4530 8192000000 10731095376 11107700736 1787657984 17.913 100 82 161 0 1825110480 14660048 22792448
23:06:24 2922 8192000000 10736585424 11116404736 1797694080 17.995 100 88 172 1 1836522192 14781648 24046464
23:06:33 2705 8192000000 10740298720 11120971776 1801185552 18.024 100 81 160 1 1837990464 14014416 22790496
23:06:42 3067 8192000000 10747908864 11128401920 1805339472 18.058 100 95 190 1 1847058784 15386720 26332592
23:06:52 4741 8192000000 10748842560 11127205888 1802856336 18.037 100 83 166 2 1839667136 13913248 22897552
23:07:04 3243 8192000000 10757009488 11139887104 1810208016 18.098 100 83 166 0 1846691744 13035792 23447936
23:07:14 2987 8192000000 10770785616 11154550784 1827571440 18.240 100 88 177 1 1864821696 11607872 25642384
23:07:24 2802 8192000000 10770932944 11155271680 1830578512 18.264 100 91 182 1 1870047840 12997952 26471376
23:07:33 2699 8192000000 10779214928 11161075712 1834138592 18.293 100 96 192 0 1875506272 14593072 26774608
23:07:41 1703 8192000000 10781649152 11165954048 1837298800 18.319 100 93 185 2 1877438240 14592784 25546656
23:07:50 1595 8192000000 10781190208 11169693696 1845699536 18.387 100 84 166 0 1880998368 12480000 22818832
23:07:58 2522 8192000000 10789230704 11173957632 1845058240 18.382 100 90 181 3 1882847648 12824416 24964992
23:08:06 1798 8192000000 10785989664 11176579072 1847496432 18.402 100 81 160 0 1882276864 12596368 22184064
23:08:15 1915 8192000000 10799306448 11186700288 1854161984 18.456 100 84 168 1 1891880384 13773232 23945168
23:08:23 2042 8192000000 10804117872 11190202368 1857643824 18.484 100 88 173 1 1899209504 17381520 24184160
23:08:31 11907 8192000000 10780332608 11184136192 1854695024 18.460 100 70 139 1 1884799792 10815840 19288928
23:08:53 2674 8192000000 10804800768 11191894016 1858860048 18.494 100 79 157 0 1891319264 10220544 22238672
23:09:02 1874 8192000000 10804865792 11196227584 1864545360 18.540 100 93 186 1 1903154688 12207504 26401824
23:09:10 4050 8192000000 10786802336 11196104704 1862517264 18.524 100 54 108 2 1888941536 11560336 14863936
23:09:22 2734 8192000000 10799470096 11204153344 1867660592 18.565 100 59 114 2 1895430656 12178592 15591472
23:09:32 2683 8192000000 10798919328 11206643712 1872082912 18.601 100 61 120 1 1899216304 10577808 16555584
23:09:41 1068 8192000000 10805188576 11204534272 1871835200 18.599 100 66 132 2 1901583008 11964816 17782992
23:09:49 24688 8192000000 10808284112 11209621504 1872127728 18.601 100 64 129 0 1900279184 9694608 18456848
23:10:20 35879 8192000000 10772726240 11206680576 1873969552 18.616 100 30 60 2 1888839200 6171328 8698320
23:11:05 6593 8192000000 10788411504 11215888384 1879628608 18.662 100 20 40 0 1892064032 7061744 5373680
23:11:17 6849 8192000000 10788531568 11217092608 1880032816 18.665 100 21 42 0 1892872256 6454992 6384448
23:11:32 8849 8192000000 10792195888 11221843968 1883466336 18.693 100 32 64 3 1900073232 7760416 8846480
23:11:50 7284 8192000000 10786627808 11223388160 1886166464 18.715 100 22 44 2 1898593904 6182336 6245104
23:12:04 8716 8192000000 10803710352 11231821824 1890597536 18.751 100 19 38 0 1902665856 6557776 5510544
23:12:20 8984 8192000000 10801910096 11228573696 1891107072 18.755 100 24 49 0 1904222160 6284000 6831088
23:12:35 7236 8192000000 10800887936 11230994432 1893996576 18.778 100 23 46 2 1907581696 6684784 6900336
23:12:49 10547 8192000000 10795990912 11233722368 1893834688 18.777 100 16 31 1 1908384064 10136752 4412624
23:13:06 5681 8192000000 10805095008 11234123776 1898561808 18.815 100 23 46 1 1914888608 9764176 6562624
23:13:19 10221 8192000000 10799348384 11236630528 1896415792 18.797 100 15 30 2 1906545392 6137744 3991856
23:13:35 12738 8192000000 10800214736 11238973440 1899118304 18.819 100 15 30 1 1909535440 5707488 4709648
23:13:58 7256 8192000000 10817510176 11251556352 1907946320 18.890 100 25 50 1 1922345248 6622976 7775952
23:14:13 13389 8192000000 10817584384 11244584960 1907137664 18.884 100 23 45 1 1919909968 5843552 6928752
23:14:32 71808 8192000000 10864488352 11272781824 1914020032 18.939 100 57 116 0 1936627440 6058688 16548720
23:15:50 7290 8192000000 10829344448 11256545280 1908515408 18.895 100 38 76 0 1927267696 8957824 9794464
23:16:06 5310 8192000000 10827369968 11258347520 1910910384 18.914 100 28 56 2 1924897600 6525056 7462160
23:16:18 5476 8192000000 10823225264 11258900480 1911788224 18.921 100 37 74 1 1928673792 6068048 10817520
23:16:31 6279 8192000000 10825081008 11257589760 1896305616 18.797 99 37 71 3 1913118800 5868096 10945088
23:16:44 7513 8192000000 10801284608 11240947712 1886193472 18.715 99 32 64 0 1901668640 6496224 8978944
23:17:00 6362 8192000000 10806768208 11243425792 1884743184 18.703 99 31 62 0 1899123568 5022912 9357472
23:17:16 13502 8192000000 10799508448 11234594816 1824864448 18.217 96 13 26 1 1834449936 5525584 4059904
23:17:35 8813 8192000000 10801762272 11232980992 1857243552 18.481 98 16 32 1 1866928784 5272704 4412528
23:17:50 40747 8192000000 10809578448 11231985664 1872808768 18.607 99 39 79 1 1890555760 6171808 11575184
23:18:38 21035 8192000000 10789133264 11221721088 1852957136 18.446 98 27 54 0 1866800272 6074400 7768736
23:19:07 6726 8192000000 10781187152 11207802880 1851469328 18.434 99 39 77 1 1870003728 7822560 10711840
23:19:22 4658 8192000000 10755651360 11169402880 1801238800 18.024 97 38 77 1 1819881312 7131248 11511264
23:19:34 9128 8192000000 10738247920 11159339008 1784090480 17.883 97 28 56 3 1798138224 5996448 8051296
23:19:53 5149 8192000000 10743511088 11165982720 1803133504 18.040 98 31 62 2 1817629584 5482208 9013872
23:20:06 6781 8192000000 10742423520 11163320320 1794588672 17.969 98 34 68 1 1810440848 5384704 10467472
23:20:19 8604 8192000000 10716199856 11144871936 1798064896 17.998 99 30 58 1 1812194352 5701296 8428160
23:20:34 6686 8192000000 10691009648 11109171200 1714893920 17.310 94 24 48 1 1727806304 5291104 7621280
23:20:48 3640 8192000000 10716805968 11128369152 1766930144 17.742 98 41 83 1 1786583248 7390176 12262928
23:21:01 10209 8192000000 10678568784 11088306176 1678856672 17.008 94 26 52 0 1691554160 4677728 8019760
23:21:18 8064 8192000000 10701549296 11104002048 1715890928 17.318 96 28 55 0 1729475008 5102080 8482000
23:21:35 11351 8192000000 10726394896 11141988352 1772876384 17.791 98 25 50 3 1785416656 5317840 7222432
23:21:55 67669 8192000000 10694263920 11110346752 1738521472 17.506 96 33 66 1 1754206224 4864160 10820592
23:23:12 10779 8192000000 10736026704 11151900672 1812448368 18.116 100 29 58 2 1827629152 6181328 8999456
23:23:29 5226 8192000000 10752326400 11173388288 1835342832 18.303 100 38 77 2 1854268576 8260368 10665376
23:23:42 11804 8192000000 10746352192 11166007296 1813999440 18.129 99 32 63 3 1828854224 5421536 9433248
23:24:01 6365 8192000000 10723354976 11146387456 1798945456 18.005 98 28 52 3 1812429424 5954848 7529120
23:24:16 8919 8192000000 10760056320 11176103936 1838477824 18.328 100 29 56 2 1852513344 6243744 7791776
23:24:35 5315 8192000000 10756251312 11178762240 1846857360 18.397 100 30 60 0 1861368880 5565696 8945824
23:24:52 5083 8192000000 10766845040 11186384896 1851532144 18.435 100 26 53 4 1864775424 6009376 7233904
23:25:03 6823 8192000000 10752828944 11176493056 1833377024 18.287 99 23 46 1 1845742352 5950512 6414816
23:25:19 8298 8192000000 10772352720 11194032128 1853008048 18.447 100 24 49 2 1865631120 5696560 6926512
23:25:34 9172 8192000000 10772549984 11198640128 1856753920 18.477 100 20 40 1 1868119056 5545616 5819520
23:25:54 9526 8192000000 10767854768 11199660032 1860339488 18.506 100 26 52 3 1873366336 6143536 6883312
23:26:10 6960 8192000000 10787922624 11204681728 1861831552 18.518 100 19 38 2 1871984672 5068336 5084784
23:26:23 10209 8192000000 10779594336 11210379264 1869040848 18.577 100 17 32 2 1879321792 5467808 4813136
23:26:41 92741 8192000000 10816895056 11238944768 1885474464 18.709 100 44 86 3 1904919264 6673264 12771536
23:28:23 45838 8192000000 10831839152 11256655872 1903323712 18.853 100 41 79 2 1922019168 7834688 10860768
23:29:19 6664 8192000000 10843853728 11268562944 1917536240 18.967 100 43 86 0 1943412384 13258560 12617584
23:29:33 29495 8192000000 10859602704 11282132992 1923570464 19.015 100 38 76 0 1946325248 12071600 10683184
23:30:18 35835 8192000000 10881217680 11302477824 1941825232 19.161 100 44 88 0 1973320672 18279776 13215664
23:31:03 25694 8192000000 10876817344 11315277824 1946947520 19.202 100 37 74 0 1976269072 18408672 10912880
23:31:42 13842 8192000000 10887684320 11315531776 1952304336 19.245 100 37 74 5 1979887024 16634848 10947840
23:32:05 24582 8192000000 10893139936 11323785216 1959200272 19.300 100 42 84 0 1989960000 18189936 12569792
23:32:43 15161 8192000000 10904589760 11332452352 1969597888 19.382 100 57 114 2 2006697712 19434864 17664960
23:33:09 8972 8192000000 10909285104 11337543680 1969556720 19.382 100 54 108 0 2006170784 20424928 16189136
23:33:27 18526 8192000000 10919654864 11341901824 1967559648 19.366 100 42 84 1 2001142224 20885584 12696992
23:34:06 31435 8192000000 10904553728 11342405632 1951570848 19.239 99 37 74 1 1984599664 21537104 11491712
23:34:52 7565 8192000000 10903919424 11339186176 1956279616 19.276 99 50 99 2 1994307280 22352160 15675504
23:35:12 14868 8192000000 10922859952 11354312704 1975094816 19.426 100 50 100 2 2014942960 24238560 15609584
23:35:43 17780 8192000000 10934294368 11364880384 1980360496 19.468 100 48 96 2 2024522352 29637952 14523904
23:36:13 11346 8192000000 10927839120 11368386560 1986147824 19.513 100 43 86 2 2024310992 24880208 13282960
23:36:45 6865 8192000000 10943231008 11373621248 1991480400 19.555 100 55 106 2 2033267664 24536976 17250288
23:37:02 11562 8192000000 10946968384 11381280768 1994602672 19.580 100 52 102 2 2037937328 27302816 16031840
23:37:25 8191 8192000000 10959039008 11390447616 1998790304 19.613 100 54 108 0 2047241136 31974544 16476288
23:37:46 4370 8192000000 10970505536 11395063808 2005318976 19.665 100 67 133 2 2053160256 28008736 19832544
23:37:57 1247 8192000000 10989241344 11400577024 2010081840 19.702 100 87 172 0 2067278512 30939792 26256880
23:38:06 5293 8192000000 10970070080 11391995904 2000969104 19.630 100 79 157 1 2057643472 32822992 23851376
23:38:25 12592 8192000000 10963006512 11396890624 2003658608 19.652 100 64 128 1 2055171744 32125120 19388016
23:38:50 9301 8192000000 10969032624 11407478784 2011180128 19.711 100 53 106 0 2061376272 33661376 16534768
23:39:06 3829 8192000000 10985086272 11418357760 2015987248 19.749 100 63 126 1 2071344896 36307184 19050464
23:39:16 1091 8192000000 10993468272 11420000256 2020811616 19.787 100 81 164 0 2082938928 37570176 24557136
23:39:26 4951 8192000000 10987562944 11414646784 2003033600 19.647 99 75 150 0 2065118096 38783648 23300848
23:39:39 1607 8192000000 10988439600 11402792960 1998088688 19.608 99 89 175 0 2058432368 34588224 25755456
23:39:48 3378 8192000000 10996178736 11412619264 2013723088 19.731 100 82 165 1 2074578096 36151920 24703088
23:40:01 6918 8192000000 10974524240 11396300800 1998864464 19.614 100 75 149 2 2059142368 37374800 22903104
23:40:16 6454 8192000000 10984537680 11410804736 2007615136 19.683 100 69 138 1 2069152592 40636048 20901408
23:40:30 4687 8192000000 10977124752 11409289216 2008719552 19.691 100 64 127 0 2069105264 40672688 19713024
23:40:42 5422 8192000000 10971661424 11398832128 1998380640 19.610 100 61 119 1 2057682272 40647904 18653728
23:40:54 8459 8192000000 10986186288 11421978624 2016623344 19.754 100 56 112 0 2076058720 41373328 18062048
23:41:13 3467 8192000000 10996720704 11419885568 2018095984 19.765 100 83 161 1 2082062768 39872496 24094288
23:41:24 3660 8192000000 11001958096 11426893824 2019688320 19.778 100 74 148 1 2085197808 42791984 22717504
23:41:34 3931 8192000000 10995463968 11415691264 1999739296 19.621 99 80 160 0 2068613664 43839456 25034912
23:41:46 4697 8192000000 10999997872 11417513984 1994700992 19.581 99 87 174 1 2066078512 44958720 26418800
23:41:58 3115 8192000000 10995055824 11413381120 2003282912 19.649 100 89 175 1 2076824704 46577312 26964480
23:42:08 2687 8192000000 10993541904 11414507520 2003211568 19.648 100 79 158 2 2075813424 47569024 25032832
23:42:18 2501 8192000000 10987638928 11396861952 1988921024 19.535 99 86 172 1 2062590624 47973552 25696048
23:42:28 2836 8192000000 10991138880 11410530304 2001986256 19.638 100 81 161 0 2073648816 47088512 24574048
23:42:41 4752 8192000000 11004407456 11428810752 2015918592 19.748 100 88 176 2 2092100320 49005936 27175792
23:42:56 7433 8192000000 10977788736 11406868480 1974862128 19.424 98 64 127 0 2043066704 48022640 20181936
23:43:12 5043 8192000000 10962867776 11393777664 1972420784 19.405 99 68 136 0 2045673552 51330816 21921952
23:43:25 2724 8192000000 10982976320 11406581760 1989564144 19.540 100 76 153 0 2066488784 52854496 24070144
23:43:40 2741 8192000000 10988748912 11403067392 1974093872 19.418 99 82 164 3 2055692880 55920416 25678592
23:43:50 4261 8192000000 11005155184 11422507008 1998717536 19.613 100 84 168 0 2088119504 62208816 27193152
23:44:07 5716 8192000000 10997144336 11415801856 1976889312 19.440 99 80 157 1 2065557328 63563616 25104400
23:44:20 5241 8192000000 10994530848 11417407488 1978267936 19.451 99 74 146 2 2065156544 63154096 23734512
23:44:34 3068 8192000000 11008994912 11427151872 1996349360 19.594 100 78 155 2 2087298304 65372336 25576608
23:44:44 6064 8192000000 11007250688 11435823104 1998957936 19.615 100 76 151 1 2092575184 68849296 24767952
23:45:01 3187 8192000000 11012542704 11430715392 1994359472 19.578 100 76 153 0 2085486992 67449456 23678064
23:45:10 2927 8192000000 10996443136 11416973312 1993500912 19.571 100 83 165 2 2080060544 60831312 25728320
23:45:20 6253 8192000000 11000562928 11420880896 1992602528 19.564 100 85 170 2 2081526000 62369568 26553904
23:45:36 3938 8192000000 11018439088 11433656320 2002491824 19.642 100 92 183 1 2097250064 65952096 28806144
23:45:51 3395 8192000000 10987049440 11397758976 1966834688 19.360 99 79 155 1 2058977392 67352576 24790128
23:46:02 2166 8192000000 11001995328 11418075136 1986549712 19.517 100 90 180 1 2082914528 68425616 27939200
23:46:11 1477 8192000000 11013956864 11426762752 1990840048 19.550 100 85 167 1 2087066880 69242624 26984208
23:46:20 951 8192000000 11008210480 11419045888 1988120128 19.529 100 88 175 0 2084724896 67874976 28729792
23:46:28 1705 8192000000 11010262112 11425247232 1993357424 19.570 100 88 176 0 2090550592 69454208 27738960
23:46:37 2249 8192000000 11018141712 11434217472 1999946640 19.622 100 84 168 1 2098161664 71990560 26224464
23:46:48 10475 8192000000 10977362096 11417161728 1974292480 19.419 100 54 108 0 2064303360 72036208 17974672
23:47:36 13473 8192000000 10973197728 11418300416 1985598704 19.509 100 42 84 0 2064929056 64702912 14627440
23:47:56 11816 8192000000 10978524624 11414474752 1990768672 19.550 100 53 105 0 2068505712 60669312 17067728
23:48:19 8985 8192000000 10959711520 11399020544 1966213152 19.355 100 54 109 3 2048257712 64242400 17802160
23:48:37 11869 8192000000 10951775312 11394011136 1966476320 19.357 100 36 71 1 2036776080 58399728 11900032
23:49:13 11985 8192000000 10959784384 11403747328 1974399120 19.420 100 34 68 0 2046325248 60269424 11656704
23:49:32 14738 8192000000 10971430432 11411963904 1977730800 19.447 100 38 76 0 2054521472 63399888 13390784
23:50:01 13331 8192000000 10936825200 11380301824 1908365232 18.894 97 34 68 0 1984267472 63746768 12155472
23:50:24 12621 8192000000 10941202592 11394510848 1954188144 19.260 100 35 70 1 2025719072 59397552 12133376
23:51:05 27259 8192000000 10929539904 11390201856 1949053056 19.219 100 29 58 1 2015988976 57104704 9831216
23:51:51 24590 8192000000 10926786192 11393921024 1944900176 19.186 100 20 39 1 2013939120 61399840 7639104
23:52:31 15064 8192000000 10912189552 11382571008 1924219792 19.021 99 22 44 1 1995711728 62767744 8724192
23:53:21 42625 8192000000 10900611168 11353579520 1907320608 18.885 99 18 36 1 1967856640 53551552 6984480
23:54:11 26635 8192000000 10868608160 11341639680 1913953328 18.938 99 15 29 3 1948935056 29937488 5044240
23:55:10 50241 8192000000 10877091136 11345457152 1916892000 18.962 99 11 22 1 1934004768 13909888 3202880
23:56:28 80220 8192000000 10853269472 11327979520 1902794448 18.849 98 17 34 0 1922285584 14726368 4764768
23:57:55 130953 8192000000 10866987136 11309277184 1773499632 17.796 91 31 62 1 1790859312 8778592 8581088
00:00:16 40263 8192000000 10862464240 11301920768 1887231056 18.723 98 37 72 1 1908164672 10709312 10224304
00:01:05 13545 8192000000 10878650560 11312984064 1925860608 19.034 100 61 122 1 1958115328 15101440 17153280
00:01:30 40770 8192000000 10867740272 11327254528 1923207616 19.013 99 34 68 0 1950854816 18119392 9527808
00:02:18 53977 8192000000 10864314592 11325079552 1903734688 18.856 98 17 34 1 1925495232 16759632 5000912
00:03:19 101750 8192000000 10865252400 11332816896 1902430224 18.846 98 15 30 0 1927027136 19989920 4606992
00:05:36 96656 8192000000 10859184208 11317981184 1894418064 18.781 97 8 16 0 1919527248 22469376 2639808
00:07:26 123410 8192000000 10862321664 11320778752 1882493312 18.685 97 10 20 1 1902042528 16677024 2872192
00:09:40 57725 8192000000 10867751824 11345027072 1941808032 19.161 100 17 34 2 1962338592 15352032 5178528
00:10:44 77181 8192000000 10858927936 11314585600 1863248032 18.530 96 13 26 1 1879243776 11966416 4029328
00:12:13 37614 8192000000 10858055008 11324878848 1933503520 19.095 100 20 40 0 1947567248 8275872 5787856
00:13:09 46512 8192000000 10867667536 11342594048 1947859328 19.209 100 29 58 2 1966643216 10477616 8306272
00:14:04 75601 8192000000 10887999792 11368988672 1937577088 19.127 99 7 14 1 1953137392 13899872 1660432
00:15:27 91375 8192000000 10904377440 11376058368 1966169040 19.355 100 5 10 0 1983927536 16571968 1186528
00:17:05 137825 8192000000 10906840256 11381395456 1933801184 19.097 98 20 38 0 1953074000 13800000 5472816
00:19:29 59439 8192000000 10940151104 11379453952 1964216176 19.340 99 21 41 0 1983200944 13664096 5320672
00:20:44 50282 8192000000 10916637472 11398471680 1990078784 19.544 100 13 26 1 2011543648 18016880 3447984
00:21:41 80205 8192000000 10920861488 11382349824 1968576672 19.374 99 22 43 0 1987544032 12784736 6182624
00:23:54 68232 8192000000 10892069296 11358892032 1912459472 18.926 96 31 62 1 1932255040 10506688 9288880
00:25:09 77472 8192000000 10910822128 11384700928 1979399424 19.460 100 35 68 1 2005763488 15387728 10976336
00:26:33 27188 8192000000 10922863952 11389673472 1987981888 19.528 100 15 30 0 2005075952 12816432 4277632
00:27:22 46498 8192000000 10906193120 11394007040 1981654288 19.478 100 20 40 2 1999748048 11579520 6514240
00:28:17 30267 8192000000 10901745168 11391795200 1964997264 19.346 99 6 12 0 1986646032 20609136 1039632
00:28:53 3410 8192000000 10906015296 11393232896 1980356272 19.468 100 9 18 0 2002987328 20697664 1933392
00:29:11 70129 8192000000 10914458832 11388833792 1992422384 19.563 100 12 24 0 2003559104 8496832 2639888
00:30:28 98892 8192000000 10914731456 11405328384 1999081328 19.615 100 10 20 0 2013101568 11170208 2850032
00:32:13 34737 8192000000 10913868640 11385020416 1956313264 19.277 98 15 30 0 1971338912 11027552 3998096
00:32:54 42385 8192000000 10876157984 11342635008 1887125136 18.723 95 21 43 0 1899455440 6722544 5607760
00:33:47 42075 8192000000 10907517376 11365801984 1934318912 19.101 98 18 36 0 1948248032 8655136 5273984
00:34:41 26457 8192000000 10909388416 11356254208 1947944160 19.210 99 50 100 0 1972108912 9521216 14643536
00:35:17 63437 8192000000 10880685344 11353362432 1943464448 19.174 99 15 30 0 1957332288 9937536 3930304
00:36:29 73618 8192000000 10894255168 11367698432 1939447392 19.142 98 20 40 2 1955348688 10431456 5469840
00:37:52 86659 8192000000 10879731008 11338543104 1854199136 18.456 94 10 20 0 1869379264 12427936 2752192
00:39:25 46521 8192000000 10883513232 11346755584 1899637344 18.823 97 20 40 1 1913442528 8711744 5093440
00:40:18 104105 8192000000 10878585632 11344457728 1887544768 18.726 96 15 29 2 1906328560 14342672 4441120
00:42:15 96518 8192000000 10852847408 11328905216 1775387408 17.811 91 24 48 2 1793662368 12256496 6018464
00:43:57 26001 8192000000 10849945728 11301175296 1893600464 18.775 98 22 44 0 1907651936 8375744 5675728
00:44:29 53696 8192000000 10826625424 11268386816 1754428944 17.638 91 30 58 3 1776368304 14142352 7797008
00:45:32 34208 8192000000 10814449568 11267858432 1820473344 18.182 96 42 84 0 1844628528 12439312 11715872
00:46:15 92131 8192000000 10811160992 11273158656 1881658960 18.679 99 51 102 4 1907283376 10525776 15098640
00:48:10 37424 8192000000 10808825664 11277283328 1869676928 18.582 99 16 32 0 1885169680 11136240 4356512
00:49:20 68040 8192000000 10825493808 11299651584 1865727920 18.550 98 12 23 1 1879150432 9720656 3701856
00:50:55 69923 8192000000 10819483264 11295170560 1840642656 18.346 96 9 18 1 1855354736 12129952 2582128
00:52:14 58605 8192000000 10834046144 11297542144 1902978960 18.850 100 10 20 0 1918670176 12954128 2737088
00:53:29 89361 8192000000 10855420704 11318947840 1881188416 18.675 98 9 18 1 1893054032 9946240 1919376
00:55:04 69999 8192000000 10861484560 11332042752 1896734336 18.800 98 21 43 2 1910987488 7891008 6362144
00:56:21 52753 8192000000 10881356624 11340754944 1922124816 19.004 99 17 34 0 1936656848 9780640 4751392
00:57:47 70262 8192000000 10876803136 11347017728 1939204832 19.140 100 16 32 2 1957216320 13938064 4073424
00:59:04 69923 8192000000 10896379200 11369472000 1946857008 19.201 99 27 54 1 1967052320 12798640 7396672
01:00:33 51965 8192000000 10896076016 11357818880 1904756080 18.865 97 16 32 0 1928493088 19569168 4167840
01:01:38 104538 8192000000 10906764464 11363151872 1924419504 19.022 98 21 42 2 1946138448 15496560 6222384
01:03:29 80883 8192000000 10898790512 11361763328 1871665952 18.598 95 16 32 0 1885544192 9310368 4567872
01:04:59 71483 8192000000 10893515024 11356020736 1899324128 18.821 97 16 32 1 1920861616 16743392 4794096
01:06:17 76400 8192000000 10914968528 11381006336 1945994288 19.195 99 29 59 2 1970589856 15483520 9112048
01:07:40 89927 8192000000 10887070496 11370577920 1921081744 18.996 98 8 16 0 1952041664 28763056 2196864
01:09:18 93353 8192000000 10887513408 11348865024 1935038032 19.107 99 17 34 0 1955763440 16232224 4493184
01:10:59 13139 8192000000 10885829536 11341611008 1932288704 19.085 98 62 122 3 1958510192 9182320 17039168
01:11:24 44003 8192000000 10883341744 11349647360 1941788480 19.161 99 35 69 1 1960581504 9047136 9745888
01:12:26 64478 8192000000 10889053104 11375333376 1961747200 19.320 100 5 9 0 1972673456 9884880 1041376
01:13:40 28379 8192000000 10891301088 11379265536 1971103936 19.394 100 4 8 0 1986004272 13779696 1120640
01:14:17 2990 8192000000 10891499984 11379126272 1971627856 19.398 100 6 12 0 1987481056 14200560 1652640
01:14:26 68404 8192000000 10890874752 11367944192 1936897744 19.122 98 13 26 1 1962591792 21875408 3818640
01:15:59 51488 8192000000 10901298352 11382026240 1960303104 19.308 100 8 16 0 1979019616 16581568 2134944
01:16:57 87633 8192000000 10919787024 11393904640 1969010496 19.378 100 7 14 0 1985763968 14816480 1936992
01:18:31 81481 8192000000 10892884624 11368259584 1922658400 19.008 97 18 36 1 1943412736 16052656 4701680
01:20:00 57301 8192000000 10898549680 11364687872 1966639264 19.359 100 25 50 2 1991341008 17561280 7140464
01:21:10 32003 8192000000 10901739216 11365588992 1954158224 19.260 99 19 38 0 1966145232 6577056 5409952
01:21:51 33465 8192000000 10897248448 11358818304 1944461520 19.182 99 36 71 2 1962514432 8580736 9472176
01:22:32 92467 8192000000 10887615120 11365756928 1927255920 19.045 98 25 48 2 1945315888 10862544 7197424
01:24:16 39895 8192000000 10893007360 11354849280 1947723888 19.208 99 31 62 0 1964749712 8405440 8620384
01:25:02 8969 8192000000 10892545424 11339481088 1904798464 18.865 97 42 84 1 1925882000 9004464 12079072
01:25:19 33681 8192000000 10887808928 11345469440 1926954576 19.043 99 36 72 0 1947669312 10830672 9884064
01:26:05 20557 8192000000 10911657376 11354710016 1961572688 19.319 100 48 96 1 1986798768 11833360 13392720
01:26:33 29391 8192000000 10903957168 11357270016 1923231840 19.013 98 42 85 1 1950446864 15638912 11576112

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 11-01-2021 01:28:17 to 11-01-2021 01:28:48.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 11-01-2021 01:28:49 to 11-01-2021 01:28:51.

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          233388
MON$OLDEST_ACTIVE               233389
MON$OLDEST_SNAPSHOT             233389
MON$NEXT_TRANSACTION            233389
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                       2009664
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:677: 
:678: mscs-test-161.budzdorov.ru    Mon Jan 11 01:27:38 2021
:679:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:680: 
--- end of diff output ---

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

11.01.21 01:28:52. 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-01-11 01:28:54 No severe PSQL-related problems occured
11.01.21 01:28:55. End of report.