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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2020-12-03 16:32:29
DTS_END                         2020-12-03 16:32:29.1290
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(76:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/44088
TRN_ID                          248411
ATT_ID                          697
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: 9520.84 19580 1142501
customer order: creation 176.67 375 21200
customer order: refuse 15.15 367 1818
order to supplier: creation 47.77 1265 5732
order to supplier: removal 3.53 105794 423
invoice (draft): creation 46.95 3533 5634
invoice (draft): removal 54.80 740 6576
invoice accept: apply 43.20 18696 5184
invoice accept: cancel 49.75 772 5970
customer reserve: creation 3917.31 188 470077
customer reserve: removal 4852.79 59 582335
realization accept: apply 84.70 183 10164
realization accept: cancel 96.17 121 11540
payment from customer: creation 60.23 110 7228
payment from customer: removal 5.85 89 702
payment to supplier: creation 49.60 130 5952
payment to supplier: removal 3.62 93 434
service: total inventory turnovers 4.90 1255 588
service: total monetary turnovers 6.85 31 822
service: aggregate perf. data 0.98 18261 118
service: refresh index statistics 0.03 239533 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 03-12-2020 16:33:16 to 03-12-2020 16:33:19.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2479
TEST_TIME 2 4887
TEST_TIME 3 6052
TEST_TIME 4 6174
TEST_TIME 5 5498
TEST_TIME 6 5914
TEST_TIME 7 6361
TEST_TIME 8 6600
TEST_TIME 9 6423
TEST_TIME 10 6884
TEST_TIME 11 6827
TEST_TIME 12 6788
TEST_TIME 13 6884
TEST_TIME 14 7300
TEST_TIME 15 7376
TEST_TIME 16 7532
TEST_TIME 17 7681
TEST_TIME 18 7617
TEST_TIME 19 7602
TEST_TIME 20 8214
TEST_TIME 21 8477
TEST_TIME 22 8524
TEST_TIME 23 8781
TEST_TIME 24 9102
TEST_TIME 25 8977
TEST_TIME 26 9420
TEST_TIME 27 9361
TEST_TIME 28 9685
TEST_TIME 29 9690
TEST_TIME 30 11178
TEST_TIME 31 10958
TEST_TIME 32 10778
TEST_TIME 33 10917
TEST_TIME 34 10925
TEST_TIME 35 10897
TEST_TIME 36 10833
TEST_TIME 37 10804
TEST_TIME 38 10662
TEST_TIME 39 10523
TEST_TIME 40 10309
TEST_TIME 41 10183
TEST_TIME 42 10267
TEST_TIME 43 10223
TEST_TIME 44 10098
TEST_TIME 45 10038
TEST_TIME 46 9976
TEST_TIME 47 10026
TEST_TIME 48 10012
TEST_TIME 49 10065
TEST_TIME 50 9980
TEST_TIME 51 9895
TEST_TIME 52 9887
TEST_TIME 53 9765
TEST_TIME 54 9834
TEST_TIME 55 9797
TEST_TIME 56 9800
TEST_TIME 57 9776
TEST_TIME 58 9768
TEST_TIME 59 9822
TEST_TIME 60 9808
TEST_TIME 61 9781
TEST_TIME 62 9846
TEST_TIME 63 9911
TEST_TIME 64 9886
TEST_TIME 65 9950
TEST_TIME 66 9953
TEST_TIME 67 9928
TEST_TIME 68 9919
TEST_TIME 69 9985
TEST_TIME 70 9957
TEST_TIME 71 9840
TEST_TIME 72 9826
TEST_TIME 73 9796
TEST_TIME 74 9791
TEST_TIME 75 9741
TEST_TIME 76 9724
TEST_TIME 77 9749
TEST_TIME 78 9679
TEST_TIME 79 9621
TEST_TIME 80 9687
TEST_TIME 81 9620
TEST_TIME 82 9625
TEST_TIME 83 9625
TEST_TIME 84 9662
TEST_TIME 85 9649
TEST_TIME 86 9637
TEST_TIME 87 9648
TEST_TIME 88 9649
TEST_TIME 89 9670
TEST_TIME 90 9655
TEST_TIME 91 9716
TEST_TIME 92 9761
TEST_TIME 93 9757
TEST_TIME 94 9730
TEST_TIME 95 9721
TEST_TIME 96 9757
TEST_TIME 97 9702
TEST_TIME 98 9613
TEST_TIME 99 9592
TEST_TIME 100 9596
TEST_TIME 101 9602
TEST_TIME 102 9557
TEST_TIME 103 9533
TEST_TIME 104 9489
TEST_TIME 105 9440
TEST_TIME 106 9396
TEST_TIME 107 9411
TEST_TIME 108 9403
TEST_TIME 109 9355
TEST_TIME 110 9368
TEST_TIME 111 9397
TEST_TIME 112 9387
TEST_TIME 113 9423
TEST_TIME 114 9454
TEST_TIME 115 9432
TEST_TIME 116 9488
TEST_TIME 117 9482
TEST_TIME 118 9439
TEST_TIME 119 9547
TEST_TIME 120 9525

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 03-12-2020 16:33:20 to 03-12-2020 16:33:23.

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 1579101 1579101 0 0.00 0 20708 7 0 0
doc_list_biud 1579092 1579092 0 0.00 0 50511 28 0 0
sp_add_invoice_to_stock 5266 5184 82 1.55 40 168415 18696 0 82
sp_cancel_adding_invoice 5970 5970 0 0.00 4 70785 772 0 0
sp_cancel_client_order 1818 1818 0 0.00 4 16499 367 0 0
sp_cancel_customer_reserve 582335 582335 0 0.00 1 50512 60 0 0
sp_cancel_pay_from_customer 702 702 0 0.00 3 8265 90 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 3 3792 93 0 0
sp_cancel_supplier_invoice 6585 6576 9 0.13 2 20766 741 0 9
sp_cancel_supplier_order 423 423 0 0.00 9 1065732 105794 0 0
sp_cancel_write_off 11540 11540 0 0.00 1 21955 121 0 0
sp_client_order 21200 21200 0 0.00 4 27563 375 0 0
sp_customer_reserve 470077 470077 0 0.00 0 46558 188 0 0
sp_fill_shopping_cart 32565 32565 0 0.00 1 24349 37 0 0
sp_fill_shopping_cart_clo_res 470072 470072 0 0.00 0 17819 13 0 0
sp_get_clo_for_invoice 5179 5179 0 0.00 0 20692 278 0 0
sp_kill_cost_storno 18646 18646 0 0.00 0 20692 60 0 0
sp_kill_qstorno_ret_qs2qd 1183209 1183209 0 0.00 0 50509 32 0 0
sp_kill_qty_storno 624000 624000 0 0.00 0 50511 70 0 0
sp_lock_selected_doc 21238 21238 0 0.00 0 8432 6 0 0
sp_make_cost_storno 28523 28523 0 0.00 0 17745 53 0 0
sp_multiply_rows_for_pdistr 28514 28514 0 0.00 0 8501 28 0 0
sp_multiply_rows_for_qdistr 21200 21200 0 0.00 0 22972 161 0 0
sp_pay_from_customer 7228 7228 0 0.00 4 11861 111 0 0
sp_pay_to_supplier 5952 5952 0 0.00 4 17751 130 0 0
sp_payment_common 13176 13176 0 0.00 2 11855 30 0 0
sp_qd_handle_on_cancel_clo 1818 1818 0 0.00 0 16494 339 0 0
sp_qd_handle_on_invoice_upd_sts 11146 11146 0 0.00 0 24690 353 0 0
sp_qd_handle_on_reserve_upd_sts 10162 10162 0 0.00 0 21418 62 0 0
sp_reserve_write_off 10164 10164 0 0.00 6 21459 183 0 0
sp_supplier_invoice 5634 5634 0 0.00 6 95821 3534 0 0
sp_supplier_order 5732 5732 0 0.00 5 28825 1265 0 0
srv_aggregate_perf_data 119 118 1 0.84 2355 220162 18262 0 1
srv_fill_mon_cache_memory 172 172 0 0.00 1600 157629 30379 0 0
srv_find_qd_qs_mism 1094392 1094392 0 0.00 0 12232 6 0 0
srv_make_invnt_saldo 588 588 0 0.00 32 52322 1255 0 0
srv_make_money_saldo 822 822 0 0.00 1 2125 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 151957 362816 239534 0 0
t$perf-abend:sp_add_invoice_to_stock 82 82 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 5184 5184 0 0.00 0 26103 188 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 2410 91 0 0
t$perf-norm:sp_cancel_client_order 1818 1818 0 0.00 0 2654 18 0 0
t$perf-norm:sp_cancel_customer_reserve 690 690 0 0.00 0 1866 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 702 702 0 0.00 0 934 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 322 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 403 403 0 0.00 0 1986 21 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 19793 1609 0 0
t$perf-norm:sp_cancel_write_off 1024 1024 0 0.00 0 507 4 0 0
t$perf-norm:sp_client_order 21200 21200 0 0.00 0 8887 18 0 0
t$perf-norm:sp_customer_reserve 1022 1022 0 0.00 0 1571 7 0 0
t$perf-norm:sp_pay_from_customer 7228 7228 0 0.00 0 5337 11 0 0
t$perf-norm:sp_pay_to_supplier 5952 5952 0 0.00 0 3658 8 0 0
t$perf-norm:sp_reserve_write_off 10164 10164 0 0.00 0 12689 12 0 0
t$perf-norm:sp_supplier_invoice 5634 5634 0 0.00 0 15391 21 0 0
t$perf-norm:sp_supplier_order 5732 5732 0 0.00 0 12483 21 0 0
t$perf-norm:srv_aggregate_perf_data 118 118 0 0.00 0 375 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 172 172 0 0.00 0 309 2 0 0
t$perf-norm:srv_make_invnt_saldo 588 588 0 0.00 0 807 22 0 0
t$perf-norm:srv_make_money_saldo 822 822 0 0.00 0 1063 17 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10516 10352 164 1.55 0 9906 20 0 164
v_all_customers 38586 38586 0 0.00 0 93 1 0 0
v_all_suppliers 31056 31056 0 0.00 0 19 1 0 0
v_all_wares 42400 42400 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 1767 11 0 0
v_cancel_client_order 3636 3636 0 0.00 0 1738 5 0 0
v_cancel_customer_prepayment 1404 1404 0 0.00 0 2370 9 0 0
v_cancel_customer_reserve 1380 1380 0 0.00 0 2202 5 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 1765 7 0 0
v_cancel_supplier_invoice 824 806 18 2.18 0 1611 17 0 18
v_cancel_supplier_order 846 846 0 0.00 0 1157 7 0 0
v_cancel_write_off 2048 2048 0 0.00 0 2638 16 0 0
v_max_id_clo_ord 5731 5731 0 0.00 0 606 1 0 0
v_max_id_clo_res 1022 1022 0 0.00 0 6885 17 0 0
v_max_id_ord_sup 5633 5633 0 0.00 0 5195 5 0 0
v_max_non_paid_invoice 1784 1784 0 0.00 0 688 3 0 0
v_max_non_paid_realizn 3861 3861 0 0.00 0 5033 6 0 0
v_min_id_clo_ord 5731 5731 0 0.00 0 7702 7 0 0
v_min_id_clo_res 1022 1022 0 0.00 0 6290 18 0 0
v_min_id_ord_sup 5633 5633 0 0.00 0 2740 3 0 0
v_min_non_paid_invoice 5948 5948 0 0.00 0 7454 19 0 0
v_min_non_paid_realizn 7226 7226 0 0.00 0 11850 17 0 0
v_our_firm 10544 10544 0 0.00 0 18 1 0 0
v_reserve_write_off 20324 20324 0 0.00 0 2621 6 0 0
x_lock_depdocs_on_canc_invoice 12143 12143 0 0.00 0 18366 125 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 19383 380 0 0
x_make_qstorno_1000_1200 5732 5732 0 0.00 1 28772 1180 0 0
x_make_qstorno_1200_2000 5634 5634 0 0.00 3 94834 3402 0 0
x_make_qstorno_2100_3300 470077 470077 0 0.00 0 46556 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 03-12-2020 16:33:24 to 03-12-2020 16:33:28.

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
14:02:32 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
14:02:38 16177 8192000000 10225255904 10528829440 935615904 10.250 73 60 121 0 958879520 2615440 20648176
14:03:06 38779 8192000000 10356433520 10672992256 1388380752 14.491 100 83 165 1 1418663584 4374768 25908064
14:03:52 15653 8192000000 10374737312 10695004160 1425575088 14.822 100 90 180 0 1461118528 6340688 29202752
14:04:19 20030 8192000000 10396903904 10723647488 1450809440 15.045 100 85 171 1 1485079264 7276544 26993280
14:04:49 18553 8192000000 10419388592 10751590400 1477202416 15.277 100 86 170 1 1512653680 8334752 27116512
14:05:30 14439 8192000000 10439678480 10772865024 1497279600 15.452 100 88 176 0 1533951440 8790992 27880848
14:05:54 14343 8192000000 10460172816 10795110400 1513565424 15.594 100 85 170 0 1549728640 9432944 26730272
14:06:23 26694 8192000000 10496900880 10838679552 1540719056 15.830 100 81 162 0 1575902112 10055216 25127840
14:06:58 15892 8192000000 10508093632 10856902656 1568813584 16.072 100 82 163 1 1604510320 11084608 24612128
14:07:25 13953 8192000000 10538899440 10892763136 1599083376 16.332 100 88 176 0 1636703568 11180896 26439296
14:07:47 6221 8192000000 10546131776 10902761472 1610796384 16.432 100 78 156 1 1645778944 11606512 23376048
14:08:02 13428 8192000000 10569483248 10927783936 1632008720 16.612 100 85 170 0 1668741616 11421552 25311344
14:08:33 11746 8192000000 10588355216 10950967296 1652469392 16.785 100 71 142 0 1684484416 11516320 20498704
14:08:54 13163 8192000000 10601161008 10967420928 1663348144 16.877 100 79 158 3 1698180720 11238064 23594512
14:09:18 11487 8192000000 10612297984 10982088704 1674172560 16.968 100 62 124 2 1702637376 10636624 17828192
14:09:36 7686 8192000000 10643221856 11012079616 1707695792 17.249 100 82 165 1 1743152816 11442432 24014592
14:09:54 6726 8192000000 10664303088 11034046464 1719387360 17.347 100 84 168 1 1755978336 13194784 23396192
14:10:08 6189 8192000000 10684881056 11056386048 1739836992 17.517 100 84 168 0 1777600832 14031120 23732720
14:10:22 7082 8192000000 10689626448 11064827904 1751513824 17.614 100 86 173 3 1789638240 14387600 23736816
14:10:36 6220 8192000000 10689759504 11069435904 1755671216 17.649 100 78 156 1 1791470880 14003888 21795776
14:10:49 4666 8192000000 10705200880 11079921664 1760936272 17.692 100 83 166 2 1798318192 14379216 23002704
14:11:01 4559 8192000000 10713272592 11090571264 1773107312 17.793 100 87 173 1 1811773728 14404128 24262288
14:11:13 3133 8192000000 10720663776 11096600576 1780406192 17.853 100 90 179 1 1819720432 13885872 25428368
14:11:22 3251 8192000000 10729331216 11109195776 1796698544 17.987 100 91 182 1 1835526816 13892144 24936128
14:11:32 3190 8192000000 10740342192 11120734208 1805944192 18.063 100 90 179 1 1844171808 13277232 24950384
14:11:41 2783 8192000000 10743459376 11126956032 1806995280 18.071 100 90 176 0 1844775632 13040880 24739472
14:11:51 10249 8192000000 10737892672 11126812672 1813108128 18.121 100 84 169 1 1850205392 14065856 23031408
14:12:08 3662 8192000000 10763846480 11146493952 1819094512 18.170 100 86 170 1 1854801008 12251408 23455088
14:12:19 1198 8192000000 10776855776 11159945216 1836178112 18.310 100 93 184 1 1873634048 12254688 25201248
14:12:26 2985 8192000000 10784336256 11172421632 1840352096 18.344 100 86 171 1 1877398496 12653744 24392656
14:12:36 1903 8192000000 10787360480 11174408192 1845704080 18.387 100 90 179 1 1884124112 13474688 24945344
14:12:44 1358 8192000000 10800198768 11183968256 1857462512 18.483 100 90 178 0 1897414096 14663984 25287600
14:12:53 1637 8192000000 10810728976 11195437056 1860031296 18.504 100 94 186 1 1899744192 13870768 25842128
14:13:01 1343 8192000000 10807489312 11194613760 1861039504 18.512 100 90 180 1 1900001936 13377168 25585264
14:13:09 1593 8192000000 10813106832 11199496192 1867667888 18.565 100 89 179 0 1906120480 13429056 25023536
14:13:17 4177 8192000000 10814309184 11200573440 1867483440 18.564 100 92 185 1 1906513088 12518912 26510736
14:13:27 1263 8192000000 10815696880 11206057984 1870958624 18.592 100 81 162 0 1907091296 13009472 23123200
14:13:35 1451 8192000000 10810341808 11207737344 1871464080 18.596 100 81 162 1 1906911248 12683872 22763296
14:13:43 13012 8192000000 10771370080 11199537152 1863715136 18.533 100 37 74 3 1882072592 8431776 9925680
14:14:02 29588 8192000000 10801867984 11205836800 1872703424 18.606 100 66 132 2 1898558944 5847856 20007664
14:14:38 9249 8192000000 10797972992 11210084352 1872083184 18.601 100 51 102 0 1896559600 10566592 13909824
14:14:54 4409 8192000000 10783709520 11209097216 1870440432 18.588 100 33 66 3 1887839152 8239488 9159232
14:15:04 4154 8192000000 10791840576 11213324288 1877395104 18.644 100 42 84 0 1896844912 7403040 12046768
14:15:17 9200 8192000000 10795521424 11217793024 1877646624 18.646 100 33 66 0 1894202512 6935728 9620160
14:15:36 7903 8192000000 10784924592 11218661376 1881656272 18.678 100 19 38 0 1893041968 6132672 5253024
14:15:50 9896 8192000000 10783355280 11219607552 1881452256 18.677 100 19 38 1 1892777216 6257552 5067408
14:16:08 7314 8192000000 10796057200 11225239552 1886950800 18.721 100 19 38 2 1897803360 5167712 5684848
14:16:26 13287 8192000000 10799610560 11233669120 1891414736 18.757 100 18 36 1 1901761792 5742944 4604112
14:16:51 7902 8192000000 10814605120 11241005056 1894049808 18.778 100 25 50 2 1911239696 10169488 7020400
14:17:10 11259 8192000000 10802536944 11241410560 1897319104 18.805 100 20 40 0 1909058112 5989056 5749952
14:17:27 6517 8192000000 10816827712 11250925568 1904191936 18.860 100 28 56 2 1922737552 10726768 7818848
14:17:40 10606 8192000000 10815755664 11246632960 1905308912 18.869 100 20 40 0 1917772304 6971328 5492064
14:17:57 14071 8192000000 10811618144 11245568000 1904983632 18.866 100 25 50 1 1918454784 5808512 7662640
14:18:20 10310 8192000000 10838559600 11257577472 1910218176 18.908 100 30 60 1 1925094144 4975664 9900304
14:18:36 65928 8192000000 10813297536 11257982976 1913548560 18.935 100 37 76 0 1928691616 4768336 10374720
14:19:48 6791 8192000000 10819581872 11262881792 1911066816 18.915 100 26 51 2 1924341120 6693248 6581056
14:20:02 7647 8192000000 10840138512 11268354048 1897910816 18.809 99 44 88 3 1917602240 7672480 12018944
14:20:16 5317 8192000000 10834915856 11269558272 1914234304 18.941 100 44 88 0 1935270400 8651632 12384464
14:20:28 6946 8192000000 10831526192 11263586304 1904218096 18.860 100 21 42 1 1919968160 10259232 5490832
14:20:42 9985 8192000000 10832682064 11264442368 1910065392 18.907 100 31 63 0 1925665296 6536912 9062992
14:21:00 5600 8192000000 10826250976 11254349824 1888898208 18.737 99 36 72 2 1905933888 6028352 11007328
14:21:13 6187 8192000000 10814223520 11255193600 1907207232 18.884 100 33 64 1 1924000608 6787632 10005744
14:21:27 5592 8192000000 10804124512 11239112704 1880181856 18.667 99 32 64 2 1895445136 5525152 9738128
14:21:39 7955 8192000000 10823036000 11258585088 1905405552 18.870 100 25 49 1 1917803488 5319856 7078080
14:21:54 8693 8192000000 10833284832 11264077824 1908014512 18.891 100 14 27 0 1916538704 5098384 3425808
14:22:09 9200 8192000000 10806101488 11235459072 1852321312 18.441 97 21 42 1 1863995648 6042880 5631456
14:22:26 10226 8192000000 10791835312 11214471168 1838374128 18.328 97 25 50 1 1850688512 5009376 7305008
14:22:43 8060 8192000000 10753660800 11179851776 1795510096 17.977 96 22 44 2 1808170560 6332208 6328256
14:22:58 53902 8192000000 10758255360 11159916544 1736258304 17.488 93 38 76 1 1752048528 4483536 11306688
14:24:04 10449 8192000000 10740078352 11159187456 1787527792 17.911 97 25 50 1 1801639200 7179632 6931776
14:24:22 10995 8192000000 10703595424 11124310016 1703444512 17.214 94 18 36 0 1713813968 4941072 5428384
14:24:40 4230 8192000000 10716101920 11127660544 1762551664 17.705 98 26 47 2 1774588768 5553984 6483120
14:24:52 8368 8192000000 10705076992 11123208192 1742170224 17.537 97 22 42 4 1754080848 5920704 5989920
14:25:07 6165 8192000000 10693800224 11105460224 1732972880 17.460 97 29 58 1 1747174608 5977184 8224544
14:25:22 3487 8192000000 10684848784 11090894848 1754598528 17.640 99 36 72 2 1771423744 6028608 10796608
14:25:31 3574 8192000000 10704984896 11114414080 1786299568 17.901 100 38 74 3 1803777136 6496480 10981088
14:25:41 6936 8192000000 10698805392 11104862208 1779220880 17.843 99 35 71 1 1794695808 5440256 10034672
14:25:56 7042 8192000000 10699251104 11111051264 1742621904 17.540 97 29 58 0 1757719152 6032704 9064544
14:26:09 7035 8192000000 10722895296 11135762432 1800764640 18.020 100 28 57 2 1815575504 6111776 8699088
14:26:24 8600 8192000000 10734221104 11151773696 1815906032 18.144 100 26 52 2 1832764928 9424944 7433952
14:26:40 7458 8192000000 10721694288 11136667648 1775839168 17.815 98 23 45 2 1788455152 5691040 6924944
14:26:54 6195 8192000000 10749328736 11158433792 1820776128 18.184 100 32 64 2 1836037744 5869232 9392384
14:27:09 12350 8192000000 10744453504 11177598976 1837035168 18.317 100 19 38 1 1848624624 6009536 5579920
14:27:27 70321 8192000000 10752667376 11180797952 1829872016 18.258 99 29 58 1 1843028256 4851136 8305104
14:28:50 6783 8192000000 10767454112 11190284288 1852638128 18.444 100 24 48 2 1865732928 6224288 6870512
14:29:04 9674 8192000000 10770734480 11203661824 1862606960 18.524 100 22 44 1 1875386528 6365712 6413856
14:29:21 8908 8192000000 10787088992 11209756672 1867599760 18.565 100 23 45 3 1880086032 5110784 7375488
14:29:40 6181 8192000000 10785085888 11212296192 1867749072 18.566 100 25 50 0 1881199120 6299408 7150640
14:29:57 8518 8192000000 10785303968 11215040512 1870106752 18.585 100 26 52 1 1883462656 5442544 7913360
14:30:11 9497 8192000000 10791992976 11218661376 1871504896 18.596 100 30 60 0 1886919280 6171232 9243152
14:30:31 4713 8192000000 10782602208 11219668992 1873062016 18.609 100 24 48 1 1890746352 10403664 7280672
14:30:43 9249 8192000000 10793949280 11221557248 1875796528 18.631 100 13 26 1 1885051104 5366336 3888240
14:30:59 7536 8192000000 10800155056 11228729344 1882584736 18.686 100 43 86 3 1901386960 5500592 13301632
14:31:13 6811 8192000000 10798777472 11227643904 1880595360 18.670 100 24 48 2 1893462672 6160176 6707136
14:31:26 6333 8192000000 10801990576 11228291072 1882953312 18.689 100 35 68 1 1900473584 7279024 10241248
14:31:38 9432 8192000000 10797370880 11230056448 1880600640 18.670 100 16 32 1 1890962816 5991744 4370432
14:31:54 7370 8192000000 10796326128 11226058752 1886030736 18.714 100 19 38 1 1897012416 5470384 5511296
14:32:08 7020 8192000000 10808186688 11243458560 1902422560 18.846 100 29 58 1 1915735280 5897760 7414960
14:32:23 72045 8192000000 10845075376 11268345856 1911767136 18.921 100 32 64 1 1927652240 5494624 10390480
14:33:44 29562 8192000000 10867237008 11287392256 1931814624 19.081 100 50 100 0 1955684176 8787168 15082384
14:34:21 11627 8192000000 10859411040 11284250624 1929986848 19.067 100 51 101 3 1954332944 10396032 13950064
14:34:39 6435 8192000000 10879085120 11298377728 1935026432 19.107 100 51 101 2 1961962720 11987568 14948720
14:34:55 2165 8192000000 10879507024 11295895552 1924269888 19.021 99 75 151 0 1959322304 13244736 21807680
14:35:05 10607 8192000000 10876706000 11299463168 1939003328 19.139 100 52 102 1 1966409616 13265104 14141184
14:35:44 8503 8192000000 10885361744 11314069504 1950298064 19.229 100 57 114 0 1979601616 12680528 16623024
14:36:00 18651 8192000000 10889486768 11323060224 1952796816 19.249 100 46 92 2 1977108128 11829456 12481856
14:36:37 21815 8192000000 10889404000 11323285504 1942740864 19.169 99 48 96 0 1968186848 12210352 13235632
14:37:06 15657 8192000000 10890878720 11328167936 1963981664 19.338 100 50 100 1 1990098672 11713424 14403584
14:37:35 21955 8192000000 10897846336 11330330624 1949722544 19.224 99 51 102 2 1977433056 13167680 14542832
14:38:15 6238 8192000000 10887795424 11314667520 1941771312 19.161 99 64 128 3 1974899344 13695584 19432448
14:38:35 7960 8192000000 10892831632 11326193664 1956435104 19.278 100 54 107 1 1987361792 15843536 15083152
14:38:54 7140 8192000000 10912290416 11339894784 1969415920 19.381 100 57 114 1 2004091952 18115456 16560576
14:39:09 1824 8192000000 10925543856 11350278144 1978049472 19.449 100 60 117 2 2013248656 17879488 17319696
14:39:19 6985 8192000000 10933547824 11358978048 1987777120 19.526 100 59 112 1 2023687216 20293616 15616480
14:39:36 6383 8192000000 10937898240 11369918464 1992051584 19.560 100 51 101 4 2026952144 20452672 14447888
14:39:49 4279 8192000000 10938329040 11365285888 1988904432 19.535 100 64 128 2 2028757456 21387040 18465984
14:40:02 4884 8192000000 10936092816 11365765120 1988227344 19.530 100 52 104 0 2024369552 21454064 14688144
14:40:15 1858 8192000000 10956270464 11377766400 1996902256 19.598 100 82 162 0 2043234912 22609664 23722992
14:40:34 5473 8192000000 10961370160 11385143296 2003047168 19.647 100 78 152 1 2047668288 23239072 21382048
14:40:51 4715 8192000000 10964578496 11390005248 2009424976 19.697 100 75 150 0 2055795680 24119344 22251360
14:41:03 7690 8192000000 10953712672 11382493184 1988620448 19.533 99 69 136 1 2033904816 24684608 20599760
14:41:18 3213 8192000000 10961122656 11375362048 1993178912 19.569 100 79 159 3 2043208544 26461472 23568160
14:41:27 3008 8192000000 10958455312 11381133312 1997637344 19.604 100 76 152 0 2047862752 27375248 22850160
14:41:39 7642 8192000000 10939116784 11362996224 1971412064 19.397 99 70 137 1 2018611984 27551328 19648592
14:42:20 8758 8192000000 10905334016 11332800512 1954874896 19.265 99 58 116 1 1996119808 23367744 17877168
14:43:10 18620 8192000000 10916416848 11356082176 1970298528 19.388 100 40 80 0 2006770112 24498704 11972880
14:43:38 8873 8192000000 10926390384 11366207488 1969020576 19.378 99 53 106 2 2009206928 23905920 16280432
14:43:55 3279 8192000000 10941778368 11376963584 1994674128 19.581 100 59 118 3 2036957072 24178160 18104784
14:44:05 2936 8192000000 10935841328 11356549120 1951789776 19.241 98 72 140 1 1997926912 25481760 20655376
14:44:15 8159 8192000000 10939324800 11371991040 1985126656 19.505 100 59 116 1 2028544368 26272208 17145504
14:44:33 5876 8192000000 10927640880 11366723584 1976798992 19.439 100 51 98 2 2021231744 28373328 16059424
14:44:51 1676 8192000000 10921580432 11334344704 1911796464 18.921 97 80 156 3 1964882272 30032400 23053408
14:45:01 1922 8192000000 10927065168 11337695232 1946928720 19.202 100 73 146 2 2000249008 30730400 22589888
14:45:10 4207 8192000000 10897312432 11319132160 1924306304 19.021 99 68 136 0 1976464864 31034624 21123936
14:45:20 3055 8192000000 10909464496 11321196544 1921494304 18.999 99 87 170 3 1977549008 30652016 25402688
14:45:31 6997 8192000000 10908770560 11329462272 1943898384 19.178 100 63 125 0 1996131312 32575104 19657824
14:45:47 3042 8192000000 10934577744 11348004864 1959511200 19.302 100 78 152 1 2017659440 33413216 24735024
14:45:58 8599 8192000000 10909434352 11325255680 1929575328 19.063 99 72 145 1 1985770448 34464656 21730464
14:46:14 2875 8192000000 10916081584 11327684608 1939069872 19.139 100 75 150 0 1996821104 34756224 22995008
14:46:25 6503 8192000000 10900503344 11323789312 1929935056 19.066 99 71 144 0 1987020480 34364528 22720896
14:46:39 1640 8192000000 10930790384 11337535488 1948750192 19.217 100 83 167 2 2006949200 31525440 26673568
14:46:49 2764 8192000000 10910212944 11326775296 1943574592 19.175 100 77 154 0 1999728704 32305536 23848576
14:47:00 9736 8192000000 10914142832 11337830400 1950720992 19.232 100 67 133 1 2004030240 33074528 20234720
14:47:23 2972 8192000000 10902972896 11317280768 1922702336 19.008 99 79 156 3 1983535792 36112912 24720544
14:47:33 3109 8192000000 10908134752 11316609024 1931295408 19.077 100 85 169 2 1994688224 37509568 25883248
14:47:43 6484 8192000000 10904202144 11310129152 1908789744 18.897 99 80 159 1 1969180768 36544080 23846944
14:47:57 8840 8192000000 10896824208 11313627136 1921744512 19.001 100 72 142 1 1981695776 37985248 21966016
14:48:15 2906 8192000000 10905700384 11322740736 1928377216 19.054 100 61 119 1 1986566896 39970560 18219120
14:48:26 16638 8192000000 10904222496 11317235712 1913710192 18.936 99 64 128 2 1973040448 39169440 20160816
14:48:49 4857 8192000000 10931321504 11342737408 1943089120 19.171 100 75 150 1 2010161488 43203936 23868432
14:49:01 3946 8192000000 10929651776 11343564800 1946859328 19.201 100 68 136 2 2009442448 41980128 20602992
14:49:14 5318 8192000000 10928261360 11341029376 1947004864 19.203 100 78 154 2 2015130240 45170080 22955296
14:49:27 5987 8192000000 10938291888 11343392768 1946134336 19.196 100 84 162 2 2012951376 42370384 24446656
14:49:41 3017 8192000000 10940122640 11347316736 1936058304 19.115 99 80 159 1 2002570768 42502928 24009536
14:49:54 4034 8192000000 10934478896 11348557824 1956080944 19.275 100 77 154 0 2022278416 42590400 23607072
14:50:05 3675 8192000000 10937094384 11346841600 1938547072 19.135 99 80 155 1 2005344912 43808400 22989440
14:50:15 2146 8192000000 10943611440 11352317952 1940065936 19.147 99 86 172 0 2012414864 45669232 26679696
14:50:23 4808 8192000000 10948732736 11358183424 1939764400 19.145 99 85 170 1 2012333968 46077200 26492368
14:50:40 6315 8192000000 10947017264 11364352000 1961017072 19.314 100 64 126 2 2028178128 47468608 19692448
14:50:55 6202 8192000000 10939209264 11357302784 1951763728 19.241 100 70 139 2 2021873984 47673456 22436800
14:51:11 3834 8192000000 10942535296 11353600000 1950345520 19.229 100 79 157 1 2026840384 51364096 25130768
14:51:22 2806 8192000000 10952246608 11358617600 1952111840 19.243 100 89 178 0 2032593728 52890784 27591104
14:51:33 3093 8192000000 10961770624 11366690816 1956971984 19.282 100 90 177 4 2037769408 54181984 26615440
14:51:44 2013 8192000000 10957847024 11373031424 1957226992 19.284 100 80 160 1 2038584448 55311584 26045872
14:51:54 1625 8192000000 10965279360 11378049024 1962583264 19.327 100 85 169 2 2045596144 56673408 26339472
14:52:02 3303 8192000000 10974522768 11384459264 1970055776 19.386 100 84 165 2 2052886544 56370608 26460160
14:52:14 1598 8192000000 10987131568 11398201344 1973547232 19.414 100 82 162 0 2058322880 58808704 25966944
14:52:26 2196 8192000000 10989186032 11402055680 1980929520 19.472 100 88 176 1 2063208944 54026544 28252880
14:52:38 4515 8192000000 10964799696 11384369152 1973884576 19.416 100 68 137 1 2042783344 47135456 21763312
14:52:54 2401 8192000000 10953741440 11369893888 1962828480 19.329 100 72 143 0 2031257488 45699696 22729312
14:53:07 4420 8192000000 10958425616 11380928512 1957131552 19.283 99 71 141 1 2026888736 46606144 23151040
14:53:19 3799 8192000000 10970028176 11389186048 1974949856 19.425 100 86 171 2 2053373344 50355120 28068368
14:53:31 1665 8192000000 10971162384 11378810880 1951958272 19.242 99 83 164 0 2025752176 48341728 25452176
14:53:39 2967 8192000000 10975739936 11383046144 1969883328 19.385 100 95 190 2 2050859776 50993792 29982656
14:53:49 5606 8192000000 10962680720 11378847744 1967809504 19.368 100 78 154 2 2042240672 50132224 24298944
14:54:07 11291 8192000000 10944085024 11381211136 1964398432 19.341 100 45 90 2 2030187472 50001952 15787088
14:54:34 3322 8192000000 10953500512 11386568704 1970813520 19.392 100 59 118 1 2040932688 50910464 19208704
14:54:48 6209 8192000000 10956423072 11383615488 1950314976 19.229 99 55 110 2 2021337792 53314480 17708336
14:55:01 2407 8192000000 10933904832 11362381824 1943991248 19.179 99 57 115 1 2015874576 53445328 18438000
14:55:14 1675 8192000000 10975289488 11395489792 1974463280 19.421 100 70 140 1 2051595184 54870608 22261296
14:55:24 2510 8192000000 10993387440 11402948608 1982283376 19.483 100 84 167 0 2062897776 54773184 25841216
14:55:33 2879 8192000000 10993228848 11402674176 1983232432 19.490 100 92 184 0 2068634832 56070240 29332160
14:55:43 2450 8192000000 10992285776 11409838080 1987398240 19.523 100 78 156 0 2068660592 56692512 24569840
14:55:57 13596 8192000000 10952136576 11402407936 1982262176 19.483 100 50 100 0 2050462816 51952848 16247792
14:56:19 12487 8192000000 10963453792 11398250496 1967902816 19.369 99 45 90 2 2028127232 45595264 14629152
14:56:44 6850 8192000000 10952851040 11396276224 1983296496 19.491 100 36 71 0 2037411344 42550320 11564528
14:57:02 10283 8192000000 10955612672 11395604480 1962197600 19.324 99 36 73 0 2020450816 45665184 12588032
14:57:19 14334 8192000000 10952336336 11400953856 1976645440 19.438 100 33 66 1 2037068832 48795248 11628144
14:57:43 11774 8192000000 10970936496 11408416768 1981639872 19.478 100 43 86 2 2047621664 51580336 14401456
14:58:07 9208 8192000000 10982016736 11425177600 1992519936 19.564 100 47 92 0 2067448128 59341472 15586720
14:58:27 7864 8192000000 10975030112 11426357248 1986238768 19.514 100 33 66 0 2056565232 58574960 11751504
14:58:47 46992 8192000000 10940798224 11390541824 1968183632 19.371 100 30 58 3 2026800608 48669440 9947536
14:59:41 15284 8192000000 10947809648 11390435328 1961309680 19.316 100 43 85 1 2020711616 45227088 14174848
15:00:04 14110 8192000000 10932614544 11393843200 1955794816 19.273 100 28 56 0 2020902192 55066384 10040992
15:00:26 16266 8192000000 10919235072 11384500224 1949665184 19.224 100 24 48 2 2009924416 51427056 8832176
15:00:49 16812 8192000000 10928007472 11387920384 1949488976 19.222 100 22 44 1 2008533552 51006192 8038384
15:01:39 40672 8192000000 10941127008 11404296192 1945327328 19.189 100 15 30 0 2011418256 60097376 5993552
15:02:35 61391 8192000000 10920476080 11366887424 1960002816 19.306 100 7 14 0 1982731344 21031040 1697488
15:03:45 46077 8192000000 10938136768 11372998656 1962235040 19.324 99 18 35 0 1979297472 11564976 5497456
15:04:39 64468 8192000000 10919296416 11388710912 1949128688 19.220 98 8 16 1 1965848000 14721984 1997328
15:05:59 77027 8192000000 10915611344 11375525888 1964426592 19.341 99 6 12 0 1977876080 12269600 1179888
15:07:28 80569 8192000000 10934002752 11381358592 1950661216 19.232 98 14 29 0 1968347440 14040928 3645296
15:08:59 62771 8192000000 10922856816 11388264448 1990139936 19.545 100 21 43 1 2006688464 10214096 6334432
15:10:13 15821 8192000000 10938516640 11394834432 2005578512 19.667 100 43 86 1 2024609888 7293088 11738288
15:10:51 41242 8192000000 10948241696 11397488640 1985568016 19.509 99 41 80 1 2006021968 9782896 10671056
15:11:47 131075 8192000000 10944974048 11393368064 1982945920 19.488 99 40 80 1 2006580112 12730048 10904144
15:14:10 64737 8192000000 10898782720 11360161792 1904718656 18.864 96 28 56 0 1925969952 13004624 8246672
15:15:27 37837 8192000000 10908459936 11390861312 1972895072 19.408 100 13 26 2 1994684432 18453440 3335920
15:17:34 31573 8192000000 10931073696 11381809152 1964067680 19.338 99 25 48 1 1981672800 10539520 7065600
15:18:12 51404 8192000000 10940070016 11403948032 1991327056 19.554 100 37 73 0 2016598512 13853280 11418176
15:19:33 69979 8192000000 10924089840 11407802368 1990965136 19.551 100 25 51 0 2017684176 19366432 7352608
15:20:51 65359 8192000000 10911786672 11402088448 1969609328 19.382 99 8 16 0 1989755584 17764432 2381824
15:22:02 39158 8192000000 10878627616 11354275840 1946505520 19.199 98 9 18 0 1957995280 9196816 2292944
15:22:48 70807 8192000000 10885649728 11352178688 1897465024 18.806 96 17 34 0 1913938416 10887376 5586016
15:24:05 72785 8192000000 10893718496 11373821952 1960174400 19.307 100 11 22 0 1976891072 13567536 3149136
15:25:38 52622 8192000000 10892162704 11367817216 1926689584 19.040 98 21 40 0 1950723648 18578640 5455424
15:26:38 76275 8192000000 10880391392 11360358400 1921487744 18.999 98 11 22 1 1944704576 20225440 2991392
15:28:01 48723 8192000000 10871344576 11347853312 1887314704 18.724 96 12 24 1 1902120240 11065504 3740032
15:28:56 31658 8192000000 10888487216 11355418624 1915417968 18.950 98 22 44 0 1935765856 14154208 6193680
15:29:34 22060 8192000000 10890071792 11350102016 1921718976 19.001 98 39 76 2 1942153744 10028320 10406448
15:30:07 68594 8192000000 10880819696 11357335552 1921597184 19.000 98 29 57 0 1941907248 12032880 8277184
15:31:27 56588 8192000000 10885891552 11350695936 1921579760 18.999 98 12 25 2 1934829232 10869856 2379616
15:32:35 43646 8192000000 10914599152 11374485504 1959811920 19.305 99 36 72 1 1983986576 14457664 9716992
15:33:26 27510 8192000000 10894856432 11348832256 1907427424 18.886 97 30 59 4 1929842720 14575536 7839760
15:34:00 67124 8192000000 10858822992 11337740288 1855017600 18.463 95 27 55 1 1879723936 17011216 7695120
15:35:17 68467 8192000000 10870879488 11312889856 1860718752 18.509 96 28 56 3 1879137424 10406576 8012096
15:36:32 47684 8192000000 10872313856 11337981952 1912976224 18.931 98 38 76 1 1937696064 13182960 11536880
15:38:46 32305 8192000000 10873396496 11318685696 1890048192 18.746 98 39 78 1 1911004400 9921632 11034576
15:39:27 19487 8192000000 10873347152 11317043200 1924609680 19.024 100 42 83 4 1947245184 10848016 11787488
15:39:53 108484 8192000000 10842664976 11306373120 1814582992 18.133 94 17 34 0 1833033120 13937760 4512368
15:41:48 100194 8192000000 10747407952 11187306496 1761927408 17.700 92 25 50 2 1781592272 12947728 6717136
15:44:05 89562 8192000000 10862230480 11318104064 1876027376 18.633 98 20 40 0 1893052640 11759632 5265632
15:47:08 32512 8192000000 10829204176 11304828928 1898748784 18.816 99 11 22 1 1919467888 16637056 4082048
15:47:57 51359 8192000000 10846699296 11323961344 1924909504 19.026 100 14 28 1 1941189056 12185584 4093968
15:48:55 83208 8192000000 10863254720 11335032832 1916434816 18.958 99 15 31 0 1928545504 7864800 4245888
15:50:33 46917 8192000000 10865384304 11336077312 1924887088 19.026 99 16 32 0 1941067776 11327248 4853440
15:51:32 81412 8192000000 10874966528 11357773824 1950124288 19.227 100 15 30 0 1967994080 13442736 4427056
15:53:02 93215 8192000000 10888490496 11362336768 1933449744 19.094 99 21 42 0 1954665856 14588576 6627536
15:54:49 73457 8192000000 10881579008 11364610048 1953729168 19.256 100 9 18 0 1968921120 12929616 2262336
15:56:17 89394 8192000000 10876927440 11344633856 1893291296 18.772 97 10 21 1 1904372352 8651584 2429472
15:57:56 61882 8192000000 10899051152 11369500672 1958732496 19.296 100 12 24 0 1973491280 11478256 3280528
15:59:08 59826 8192000000 10885995696 11371773952 1960050608 19.306 100 15 30 0 1977565104 13163136 4351360
16:00:22 35018 8192000000 10897838912 11357724672 1947911312 19.210 99 37 72 3 1965899760 8410448 9578000
16:01:07 24695 8192000000 10900565216 11372105728 1969887296 19.385 100 31 62 1 1988104544 9495904 8721344
16:01:40 32718 8192000000 10911211136 11382968320 1977781360 19.447 100 31 62 0 1999694000 13027712 8884928
16:02:22 28450 8192000000 10925247488 11394957312 1985376112 19.507 100 21 41 1 2003455920 12923728 5156080
16:03:00 94567 8192000000 10924213488 11394355200 1933730880 19.097 97 18 36 0 1950552976 12766384 4055712
16:04:44 47933 8192000000 10906692368 11375296512 1927980064 19.051 97 18 36 0 1942474848 10245328 4249456
16:05:39 73385 8192000000 10927698432 11391148032 1966412496 19.357 99 16 32 0 1979350416 8811200 4126720
16:07:00 50246 8192000000 10941368848 11400605696 1979038912 19.457 99 40 80 1 2001676864 11843936 10794016
16:08:02 157629 8192000000 10925000848 11399421952 1944562032 19.183 97 37 74 0 1976065904 21285440 10218432
16:10:46 76298 8192000000 10908956656 11386572800 1927294016 19.045 97 22 44 0 1947626544 13712704 6619824
16:12:10 81303 8192000000 10897245184 11384610816 1973084352 19.410 100 21 42 1 1993747680 14244320 6419008
16:13:38 48837 8192000000 10880866496 11374309376 1935336432 19.110 98 11 23 2 1955167776 17145680 2685664
16:14:38 35629 8192000000 10869792320 11349516288 1925261824 19.029 98 5 10 1 1935640080 8908096 1470160
16:15:25 57463 8192000000 10882062688 11367804928 1945579040 19.191 99 12 24 0 1956629808 7534992 3515776
16:16:32 62383 8192000000 10892477264 11376336896 1959995856 19.306 99 20 40 2 1973791888 7582080 6213952
16:17:43 66447 8192000000 10892961664 11374125056 1945613408 19.192 98 22 44 0 1961215728 9280528 6321792
16:18:58 6209 8192000000 10891974208 11356090368 1958129008 19.291 99 35 69 0 1977749184 10014016 9606160
16:19:11 25638 8192000000 10886386992 11376881664 1974387072 19.420 100 24 48 0 1991410176 9871904 7151200
16:19:52 56460 8192000000 10879368336 11364868096 1897494032 18.806 96 19 38 0 1908591376 6311600 4785744
16:20:55 74371 8192000000 10883935456 11354939392 1866842656 18.559 95 9 18 1 1877778192 8508112 2427424
16:22:35 42510 8192000000 10895975456 11379240960 1957308592 19.285 100 26 52 1 1983720192 18792304 7619296
16:23:29 50716 8192000000 10895346272 11366166528 1946434080 19.198 99 23 46 2 1967038544 13815136 6789328
16:24:26 79192 8192000000 10858440224 11343360000 1830815280 18.266 93 13 26 1 1855626912 21009264 3802368
16:25:52 113078 8192000000 10877895488 11348656128 1860197760 18.505 96 7 14 2 1881320656 18656320 2466576
16:27:51 92962 8192000000 10871221504 11343278080 1867896240 18.567 96 14 28 1 1883739680 11210160 4633280
16:29:30 65017 8192000000 10879267376 11338506240 1886959424 18.721 97 31 62 0 1911367904 15907664 8500816
16:30:41 60503 8192000000 10877206352 11364835328 1941792400 19.161 100 36 72 1 1969958352 17630032 10535920
16:31:48 52773 8192000000 9305712240 9580642304 453983904 5.250 24 4 8 0 459343072 4610096 749072

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 03-12-2020 16:33:30 to 03-12-2020 16:34:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 82 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:01, from 03-12-2020 16:34:04 to 03-12-2020 16:34:05.

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          248679
MON$OLDEST_ACTIVE               248680
MON$OLDEST_SNAPSHOT             248680
MON$NEXT_TRANSACTION            248680
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                       2059040
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.33396 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33396 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33396 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33396 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Thu Dec  3 16:32:47 2020
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:9: 
--- end of diff output ---

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

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